| Queries |
|---|
| 0.000098 - SET NAMES 'utf8' |
| 0.000042 - SET SQL_BIG_SELECTS = 1 |
| 0.000098 - SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC |
| 0.000219 - SELECT sess_data, sess_ip FROM session WHERE sess_id = '905f89c36c57f465639aad5c7572c920' |
| 0.000192 - SELECT * FROM modules WHERE dirname = 'classifieds' |
| 0.000500 - SELECT COUNT(*) FROM group_permission WHERE (gperm_modid = '1' AND (gperm_groupid = '3') AND gperm_name = 'module_read' AND gperm_itemid = '6') |
| 0.000720 - SELECT * FROM config WHERE (conf_modid = '6') ORDER BY conf_order ASC |
| 0.000060 - SELECT * FROM modules WHERE dirname = 'protector' |
| 0.001217 - SELECT COUNT(*) FROM group_permission WHERE (gperm_modid = '6' AND (gperm_groupid = '3') AND gperm_name = 'classifieds_view') |
| 0.001202 - SELECT COUNT(*) FROM group_permission WHERE (gperm_modid = '6' AND (gperm_groupid = '3') AND gperm_name = 'classifieds_premium') |
| 0.000103 - SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '3') ORDER BY conf_order ASC |
| 0.000079 - SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (3) |
| 0.001723 - SELECT b.* FROM newblocks b, block_module_link m WHERE m.block_id=b.bid AND b.isactive=1 AND b.visible=1 AND m.module_id IN (0,6) AND b.bid IN (20,19,18,17,16,15,14,13,12,11,10,9,8,7,6,5,4,3,2,1,21,22,23,24,25,26,27,28,29,30,31) ORDER BY b.weight, m.block_id |
| 0.000104 - SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_login.html') ORDER BY tpl_refid |
| 0.000054 - SELECT COUNT(*) FROM modules WHERE dirname = 'news' |
| 0.000049 - SELECT COUNT(*) FROM modules WHERE dirname = 'mylinks' |
| 0.000049 - SELECT COUNT(*) FROM modules WHERE dirname = 'mydownloads' |
| 0.000049 - SELECT COUNT(*) FROM xoopscomments WHERE com_status=1 |
| 0.000060 - SELECT COUNT(*) FROM modules WHERE dirname = 'TDMDownloads' |
| 0.000046 - SELECT COUNT(*) FROM modules WHERE dirname = 'extgallery' |
| 0.000048 - SELECT COUNT(*) FROM modules WHERE dirname = 'smartsection' |
| 0.000063 - SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_waiting.html') ORDER BY tpl_refid |
| 0.000072 - SELECT * FROM modules WHERE (hasmain = '1' AND isactive = '1' AND weight > '0') ORDER BY weight ASC, mid ASC |
| 0.000063 - SELECT * FROM group_permission WHERE (gperm_name = 'module_read' AND gperm_modid = '1' AND gperm_groupid = '3') |
| 0.000095 - SELECT * FROM modules WHERE dirname = 'xnews' |
| 0.000041 - SELECT COUNT(*) FROM group_permission WHERE (gperm_modid = '8' AND (gperm_groupid = '3') AND gperm_name = 'nw_submit') |
| 0.000084 - SELECT * FROM config WHERE (conf_modid = '8') ORDER BY conf_order ASC |
| 0.000069 - SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_mainmenu.html') ORDER BY tpl_refid |
| 0.001004 - SELECT * FROM group_permission WHERE (gperm_name = 'classifieds_submit' AND gperm_modid = '6' AND gperm_groupid = '3') |
| 0.015972 - SELECT cid, title FROM classifieds_categories WHERE pid=0 ORDER BY title |
| 0.001076 - SELECT * FROM group_permission WHERE (gperm_name = 'classifieds_view' AND gperm_modid = '6' AND gperm_groupid = '3') |
| 0.000343 - SELECT * FROM classifieds_categories WHERE pid=12 AND cid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) ORDER BY title |
| 0.000243 - SELECT * FROM classifieds_categories WHERE pid=11 AND cid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) ORDER BY title |
| 0.000266 - SELECT * FROM classifieds_categories WHERE pid=21 AND cid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) ORDER BY title |
| 0.000274 - SELECT * FROM classifieds_categories WHERE pid=19 AND cid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) ORDER BY title |
| 0.000267 - SELECT * FROM classifieds_categories WHERE pid=20 AND cid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) ORDER BY title |
| 0.050022 - SELECT * FROM smiles |
| 0.000500 - SELECT * FROM classifieds_categories WHERE pid=6 AND cid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) ORDER BY title |
| 0.000315 - SELECT * FROM classifieds_categories WHERE pid=1 AND cid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) ORDER BY title |
| 0.000343 - SELECT * FROM classifieds_categories WHERE pid=13 AND cid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) ORDER BY title |
| 0.000315 - SELECT * FROM classifieds_categories WHERE pid=22 AND cid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) ORDER BY title |
| 0.000303 - SELECT * FROM classifieds_categories WHERE pid=24 AND cid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) ORDER BY title |
| 0.000323 - SELECT * FROM classifieds_categories WHERE pid=25 AND cid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) ORDER BY title |
| 0.000311 - SELECT * FROM classifieds_categories WHERE pid=23 AND cid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) ORDER BY title |
| 0.000375 - SELECT * FROM classifieds_categories WHERE pid=2 AND cid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) ORDER BY title |
| 0.000308 - SELECT * FROM classifieds_categories WHERE pid=10 AND cid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) ORDER BY title |
| 0.000342 - SELECT * FROM classifieds_categories WHERE pid=27 AND cid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) ORDER BY title |
| 0.000315 - SELECT * FROM classifieds_categories WHERE pid=28 AND cid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) ORDER BY title |
| 0.000317 - SELECT * FROM classifieds_categories WHERE pid=9 AND cid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) ORDER BY title |
| 0.000298 - SELECT * FROM classifieds_categories WHERE pid=5 AND cid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) ORDER BY title |
| 0.000284 - SELECT * FROM classifieds_categories WHERE pid=3 AND cid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) ORDER BY title |
| 0.000285 - SELECT * FROM classifieds_categories WHERE pid=4 AND cid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) ORDER BY title |
| 0.000354 - SELECT * FROM classifieds_categories WHERE pid=7 AND cid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) ORDER BY title |
| 0.000342 - SELECT * FROM classifieds_categories WHERE pid=14 AND cid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) ORDER BY title |
| 0.000309 - SELECT * FROM classifieds_categories WHERE pid=18 AND cid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) ORDER BY title |
| 0.000293 - SELECT * FROM classifieds_categories WHERE pid=17 AND cid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) ORDER BY title |
| 0.000402 - SELECT * FROM classifieds_categories WHERE pid=15 AND cid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) ORDER BY title |
| 0.000297 - SELECT * FROM classifieds_categories WHERE pid=26 AND cid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) ORDER BY title |
| 0.000293 - SELECT * FROM classifieds_categories WHERE pid=16 AND cid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) ORDER BY title |
| 0.000278 - SELECT * FROM classifieds_categories WHERE pid=8 AND cid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) ORDER BY title |
| 0.044277 - SELECT rid, name FROM classifieds_region WHERE pid=0 ORDER BY rid |
| 0.000139 - SELECT * FROM classifieds_region WHERE pid=1 ORDER BY rid |
| 0.000131 - SELECT COUNT(*) FROM banner |
| 0.010133 - SELECT * FROM banner LIMIT 0, 1 |
| 0.009261 - UPDATE banner SET impmade = 3536 WHERE bid = 1 |
| 0.010453 - select lid, title, status, expire, type, desctext, date, email, submitter, photo, photo2, photo3, valid, hits, comments, remind FROM classifieds_listing WHERE valid='Yes' and status!='1' |
| 0.000224 - select COUNT(*) FROM classifieds_listing WHERE valid='No' |
| 0.000340 - SELECT cid, title, img, ordre FROM classifieds_categories WHERE pid = 0 AND cid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) ORDER BY title |
| 0.000159 - select count(*) from classifieds_listing where cid=12 and valid='Yes' and status!='1' |
| 0.000222 - SELECT cid FROM classifieds_categories WHERE pid=12 AND pid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) |
| 0.000247 - SELECT * FROM classifieds_categories WHERE pid=12 AND pid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) ORDER BY title |
| 0.000202 - select date from classifieds_listing where cid=12 and valid = 'Yes' AND cid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) order by date desc limit 1 |
| 0.000158 - select count(*) from classifieds_listing where cid=11 and valid='Yes' and status!='1' |
| 0.000227 - SELECT cid FROM classifieds_categories WHERE pid=11 AND pid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) |
| 0.000238 - SELECT cid FROM classifieds_categories WHERE pid=19 AND pid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) |
| 0.000206 - SELECT cid FROM classifieds_categories WHERE pid=20 AND pid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) |
| 0.000201 - SELECT cid FROM classifieds_categories WHERE pid=21 AND pid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) |
| 0.000153 - select count(*) from classifieds_listing where cid=19 and valid='Yes' and status!='1' |
| 0.000162 - select count(*) from classifieds_listing where cid=20 and valid='Yes' and status!='1' |
| 0.000154 - select count(*) from classifieds_listing where cid=21 and valid='Yes' and status!='1' |
| 0.000295 - SELECT * FROM classifieds_categories WHERE pid=11 AND pid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) ORDER BY title |
| 0.000204 - select date from classifieds_listing where cid=11 and valid = 'Yes' AND cid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) order by date desc limit 1 |
| 0.000188 - select count(*) from classifieds_listing where cid=6 and valid='Yes' and status!='1' |
| 0.000207 - SELECT cid FROM classifieds_categories WHERE pid=6 AND pid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) |
| 0.000270 - SELECT * FROM classifieds_categories WHERE pid=6 AND pid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) ORDER BY title |
| 0.000200 - select date from classifieds_listing where cid=6 and valid = 'Yes' AND cid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) order by date desc limit 1 |
| 0.000193 - select count(*) from classifieds_listing where cid=1 and valid='Yes' and status!='1' |
| 0.000217 - SELECT cid FROM classifieds_categories WHERE pid=1 AND pid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) |
| 0.000247 - SELECT * FROM classifieds_categories WHERE pid=1 AND pid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) ORDER BY title |
| 0.000210 - select date from classifieds_listing where cid=1 and valid = 'Yes' AND cid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) order by date desc limit 1 |
| 0.000159 - select count(*) from classifieds_listing where cid=13 and valid='Yes' and status!='1' |
| 0.000209 - SELECT cid FROM classifieds_categories WHERE pid=13 AND pid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) |
| 0.000255 - SELECT * FROM classifieds_categories WHERE pid=13 AND pid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) ORDER BY title |
| 0.000229 - select date from classifieds_listing where cid=13 and valid = 'Yes' AND cid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) order by date desc limit 1 |
| 0.000166 - select count(*) from classifieds_listing where cid=22 and valid='Yes' and status!='1' |
| 0.000215 - SELECT cid FROM classifieds_categories WHERE pid=22 AND pid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) |
| 0.000213 - SELECT cid FROM classifieds_categories WHERE pid=23 AND pid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) |
| 0.000202 - SELECT cid FROM classifieds_categories WHERE pid=24 AND pid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) |
| 0.000207 - SELECT cid FROM classifieds_categories WHERE pid=25 AND pid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) |
| 0.000166 - select count(*) from classifieds_listing where cid=23 and valid='Yes' and status!='1' |
| 0.000150 - select count(*) from classifieds_listing where cid=24 and valid='Yes' and status!='1' |
| 0.000162 - select count(*) from classifieds_listing where cid=25 and valid='Yes' and status!='1' |
| 0.000275 - SELECT * FROM classifieds_categories WHERE pid=22 AND pid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) ORDER BY title |
| 0.000205 - select date from classifieds_listing where cid=22 and valid = 'Yes' AND cid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) order by date desc limit 1 |
| 0.000175 - select count(*) from classifieds_listing where cid=2 and valid='Yes' and status!='1' |
| 0.000221 - SELECT cid FROM classifieds_categories WHERE pid=2 AND pid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) |
| 0.000202 - SELECT cid FROM classifieds_categories WHERE pid=3 AND pid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) |
| 0.000213 - SELECT cid FROM classifieds_categories WHERE pid=4 AND pid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) |
| 0.000202 - SELECT cid FROM classifieds_categories WHERE pid=5 AND pid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) |
| 0.000202 - SELECT cid FROM classifieds_categories WHERE pid=7 AND pid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) |
| 0.000213 - SELECT cid FROM classifieds_categories WHERE pid=9 AND pid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) |
| 0.000210 - SELECT cid FROM classifieds_categories WHERE pid=10 AND pid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) |
| 0.000219 - SELECT cid FROM classifieds_categories WHERE pid=27 AND pid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) |
| 0.000208 - SELECT cid FROM classifieds_categories WHERE pid=28 AND pid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) |
| 0.000169 - select count(*) from classifieds_listing where cid=3 and valid='Yes' and status!='1' |
| 0.000152 - select count(*) from classifieds_listing where cid=4 and valid='Yes' and status!='1' |
| 0.000158 - select count(*) from classifieds_listing where cid=5 and valid='Yes' and status!='1' |
| 0.000168 - select count(*) from classifieds_listing where cid=7 and valid='Yes' and status!='1' |
| 0.000154 - select count(*) from classifieds_listing where cid=9 and valid='Yes' and status!='1' |
| 0.000150 - select count(*) from classifieds_listing where cid=10 and valid='Yes' and status!='1' |
| 0.000147 - select count(*) from classifieds_listing where cid=27 and valid='Yes' and status!='1' |
| 0.000163 - select count(*) from classifieds_listing where cid=28 and valid='Yes' and status!='1' |
| 0.000290 - SELECT * FROM classifieds_categories WHERE pid=2 AND pid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) ORDER BY title |
| 0.000185 - select date from classifieds_listing where cid=2 and valid = 'Yes' AND cid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) order by date desc limit 1 |
| 0.000158 - select count(*) from classifieds_listing where cid=14 and valid='Yes' and status!='1' |
| 0.000207 - SELECT cid FROM classifieds_categories WHERE pid=14 AND pid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) |
| 0.000226 - SELECT cid FROM classifieds_categories WHERE pid=17 AND pid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) |
| 0.000185 - SELECT cid FROM classifieds_categories WHERE pid=18 AND pid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) |
| 0.000129 - select count(*) from classifieds_listing where cid=17 and valid='Yes' and status!='1' |
| 0.000125 - select count(*) from classifieds_listing where cid=18 and valid='Yes' and status!='1' |
| 0.000206 - SELECT * FROM classifieds_categories WHERE pid=14 AND pid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) ORDER BY title |
| 0.000151 - select date from classifieds_listing where cid=14 and valid = 'Yes' AND cid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) order by date desc limit 1 |
| 0.000124 - select count(*) from classifieds_listing where cid=15 and valid='Yes' and status!='1' |
| 0.000150 - SELECT cid FROM classifieds_categories WHERE pid=15 AND pid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) |
| 0.000180 - SELECT * FROM classifieds_categories WHERE pid=15 AND pid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) ORDER BY title |
| 0.000140 - select date from classifieds_listing where cid=15 and valid = 'Yes' AND cid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) order by date desc limit 1 |
| 0.000124 - select count(*) from classifieds_listing where cid=26 and valid='Yes' and status!='1' |
| 0.000152 - SELECT cid FROM classifieds_categories WHERE pid=26 AND pid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) |
| 0.000191 - SELECT * FROM classifieds_categories WHERE pid=26 AND pid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) ORDER BY title |
| 0.000147 - select date from classifieds_listing where cid=26 and valid = 'Yes' AND cid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) order by date desc limit 1 |
| 0.000113 - select count(*) from classifieds_listing where cid=16 and valid='Yes' and status!='1' |
| 0.000154 - SELECT cid FROM classifieds_categories WHERE pid=16 AND pid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) |
| 0.000159 - SELECT cid FROM classifieds_categories WHERE pid=8 AND pid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) |
| 0.000147 - select count(*) from classifieds_listing where cid=8 and valid='Yes' and status!='1' |
| 0.000191 - SELECT * FROM classifieds_categories WHERE pid=16 AND pid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) ORDER BY title |
| 0.000151 - select date from classifieds_listing where cid=16 and valid = 'Yes' AND cid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) order by date desc limit 1 |
| 0.000143 - select COUNT(*) FROM classifieds_listing WHERE valid='Yes' AND status!='1' AND cid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) |
| 0.000110 - select COUNT(*) FROM classifieds_categories |
| 0.000185 - select lid, title, status, type, price, typeprice, date, town, state, country, usid, premium, valid, photo, hits from classifieds_listing WHERE valid='Yes' and status!='1' AND cid IN (1,2,3,4,5,7,9,10,27,28,6,11,19,20,21,12,13,14,17,18,15,16,8,22,23,24,25,26) ORDER BY date DESC LIMIT 10 |
| 0.040744 - SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'classifieds_index.html') ORDER BY tpl_refid |
| 0.020649 - SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_notification_select.html') ORDER BY tpl_refid |
