Next Generation CMS :: Форум поддержки

[ 1.2125 ] SELECT * FROM 2z_news WHERE approve = 1 AND mainpage = 1 AND (catid regexp '[[:<:]](128)[[:>:]]') ORDER BY postdate DESC LIMIT 0, 5
[ 1.2123 ] SELECT * FROM 2z_news WHERE approve = 1 AND (catid regexp '[[:<:]](128)[[:>:]]') ORDER BY postdate DESC LIMIT 0, 50
[ 1.2523 ] SELECT * FROM 2z_news WHERE approve = 1 AND mainpage = 1 AND (catid regexp '[[:<:]](128)[[:>:]]') ORDER BY postdate DESC LIMIT 1, 10
[ 1.295 ] SELECT * FROM 2z_news WHERE approve = 1 AND mainpage = 1 AND (catid regexp '[[:<:]](128)[[:>:]]') ORDER BY postdate DESC LIMIT 0, 1

SQL запитів: 14, Генерація сторінки: 6.25 сек

SQL queries:
[ 0.0011 ] select nc.*, ni.id as icon_id, ni.name as icon_name, ni.storage as icon_storage, ni.folder as icon_folder, ni.preview as icon_preview, ni.width as icon_width, ni.height as icon_height, ni.p_width as icon_pwidth, ni.p_height as icon_pheight from `2z_category` as nc left join `2z_images` ni on nc.image_id = ni.id order by nc.posorder asc
[ 9.9999999999999E-5 ] select * from 2z_users where authcookie = '88de850cc5d2e8269538e694e9db57fb' limit 1
[ 0.7672 ] SELECT * FROM 2z_news WHERE (`approve` = '1') AND (`catid` regexp '[[:<:]](128)[[:>:]]') order by pinned desc, postdate desc limit 0,50
[ 0.4045 ] SELECT count(*) as count FROM 2z_news WHERE (`approve` = '1') AND (`catid` regexp '[[:<:]](128)[[:>:]]')
[ 0.00019999999999998 ] SELECT * FROM 2z_posters WHERE active = 1
[ 0 ] SELECT id FROM 2z_posters WHERE active = 0
[ 9.9999999999989E-5 ] SELECT id, name, scores, country, flag, pos FROM 2z_topplayers where rating=1 ORDER BY scores DESC LIMIT 0,10
[ 9.9999999999989E-5 ] SELECT id, name, scores, country, flag, pos FROM 2z_topplayers where (country='Україна' and rating=1) ORDER BY scores DESC LIMIT 0,3
[ 9.9999999999989E-5 ] SELECT id, name, scores, country, flag, pos FROM 2z_topplayers where rating=2 ORDER BY scores DESC LIMIT 0,10
[ 0 ] SELECT id, name, scores, country, flag, pos FROM 2z_topplayers where (country='Україна' and rating=2) ORDER BY scores DESC LIMIT 0,3
[ 1.2125 ] SELECT * FROM 2z_news WHERE approve = 1 AND mainpage = 1 AND (catid regexp '[[:<:]](128)[[:>:]]') ORDER BY postdate DESC LIMIT 0, 5
[ 1.2123 ] SELECT * FROM 2z_news WHERE approve = 1 AND (catid regexp '[[:<:]](128)[[:>:]]') ORDER BY postdate DESC LIMIT 0, 50
[ 1.2523 ] SELECT * FROM 2z_news WHERE approve = 1 AND mainpage = 1 AND (catid regexp '[[:<:]](128)[[:>:]]') ORDER BY postdate DESC LIMIT 1, 10
[ 1.295 ] SELECT * FROM 2z_news WHERE approve = 1 AND mainpage = 1 AND (catid regexp '[[:<:]](128)[[:>:]]') ORDER BY postdate DESC LIMIT 0, 1