Queries |
---|
0.000058 - SET SQL_BIG_SELECTS = 1 |
0.000667 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '1') ORDER BY conf_order ASC |
0.000225 - SELECT * FROM modules WHERE dirname = 'xlanguage' |
0.000175 - SELECT sess_data, sess_ip FROM session WHERE sess_id = 'a41113a857ccc27e5e24371953259b37' |
0.000200 - SELECT * FROM modules WHERE dirname = 'xoopstube' |
0.000331 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '1' AND (`gperm_groupid` = '3') AND `gperm_name` = 'module_read' AND `gperm_itemid` = '67') |
0.000825 - SELECT * FROM config WHERE (`conf_modid` = '67') ORDER BY conf_order ASC |
0.000277 - DELETE FROM protector_access WHERE expire < UNIX_TIMESTAMP() |
0.000255 - SELECT COUNT(*) FROM protector_access WHERE ip='3.238.118.27' AND request_uri='/modules/xoopstube/' |
0.000239 - SELECT COUNT(*) FROM protector_access WHERE ip='3.238.118.27' |
0.000196 - INSERT INTO protector_access SET ip='3.238.118.27', request_uri='/modules/xoopstube/', expire=UNIX_TIMESTAMP()+'60' |
0.000281 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '67' AND (`gperm_groupid` = '3') AND `gperm_name` = 'XTubeSubPerm') |
0.000244 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '5') ORDER BY conf_order ASC |
0.000118 - SELECT COUNT(*) FROM banner |
0.000125 - SELECT * FROM banner LIMIT 1, 1 |
0.000142 - UPDATE banner SET impmade = 2920244 WHERE bid = 2 |
0.000263 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '3') ORDER BY conf_order ASC |
0.002467 - SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (3) |
0.000995 - 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,67) AND b.bid IN (1,2,3,4,5,6,8,9,10,11,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,68,66,67,69,70,71,72,75,73,74,76,77,78,79,80,81,82,83,92,93,91,89,90,94,95,113,114,115,116,118,117,252,249,254,251,248,253,250,108,109,110,111,138,136,134,137,135,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,23,21,22,17,18,20,222,221,220,219,217,218,226,227,228,245,243,246,244,247,255,256,13,14,15,19,257,258,259,16,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,294,293,291,289,290,292,295,296,297,298,299,300,301,302,303,304,305,310,309,308,307,306,312,311,313,314,315,316,317,319,318) ORDER BY b.weight, m.block_id |
0.000338 - 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` = 'xlanguage_block.tpl') ORDER BY tpl_refid |
0.000305 - SELECT * FROM modules WHERE (`hasmain` = '1' AND `isactive` = '1' AND `weight` > '0') ORDER BY weight ASC, mid ASC |
0.000982 - SELECT * FROM group_permission WHERE (`gperm_name` = 'module_read' AND `gperm_modid` = '1' AND `gperm_groupid` = '3') |
0.000212 - SELECT * FROM modules WHERE dirname = 'oledrion' |
0.001708 - SELECT * FROM config WHERE (`conf_modid` = '7') ORDER BY conf_order ASC |
0.000175 - SELECT * FROM groups WHERE (`group_type` = 'Admin') |
0.000142 - SELECT * FROM groups |
0.000138 - SELECT * FROM groups WHERE (`group_type` = 'Admin') |
0.000141 - SELECT * FROM groups |
0.000151 - SELECT * FROM groups WHERE (`group_type` = 'Admin') |
0.000151 - SELECT * FROM groups |
0.000139 - SELECT * FROM groups WHERE (`group_type` = 'Admin') |
0.000190 - SELECT * FROM modules WHERE dirname = 'news' |
0.000220 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '34' AND (`gperm_groupid` = '3') AND `gperm_name` = 'news_submit') |
0.000737 - SELECT * FROM config WHERE (`conf_modid` = '34') ORDER BY conf_order ASC |
0.000193 - SELECT * FROM modules WHERE dirname = 'tdmmoney' |
0.000143 - SELECT * FROM groups |
0.000194 - SELECT * FROM modules WHERE dirname = 'xnewsletter' |
0.000136 - SELECT * FROM `xnewsletter_cat` ORDER BY cat_id ASC |
0.000144 - SELECT * FROM `xnewsletter_cat` ORDER BY cat_id ASC |
0.000199 - SELECT * FROM modules WHERE dirname = 'extcal' |
0.000176 - SELECT * FROM groups WHERE (`group_type` = 'Admin') |
0.000143 - SELECT * FROM groups |
0.000140 - SELECT * FROM groups WHERE (`group_type` = 'Admin') |
0.000149 - SELECT * FROM groups |
0.000142 - SELECT * FROM groups WHERE (`group_type` = 'Admin') |
0.000194 - SELECT * FROM modules WHERE dirname = 'tdmdownloads' |
0.000143 - SELECT * FROM groups |
0.000170 - SELECT * FROM groups WHERE (`group_type` = 'Admin') |
0.000143 - SELECT * FROM groups |
0.000144 - SELECT * FROM groups WHERE (`group_type` = 'Admin') |
0.000449 - 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.tpl') ORDER BY tpl_refid |
0.000150 - SELECT * FROM xoopstube_indexpage |
0.000136 - SELECT * FROM smiles |
0.000269 - SELECT UPPER(LEFT(title,1)), COUNT(*) AS count FROM `xoopstube_videos` GROUP BY UPPER(LEFT(title,1)) |
0.000491 - 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` = 'xoopstube_letterschoice.tpl') ORDER BY tpl_refid |
0.000195 - SELECT lid, cid, published FROM xoopstube_videos WHERE offline = 0 AND published > 0 AND published <= 1686301386 AND (expired = 0 OR expired > 1686301386) |
0.000253 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '67' AND (`gperm_groupid` = '3') AND `gperm_name` = 'XTubeCatPerm') |
0.000235 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '67' AND (`gperm_groupid` = '3') AND `gperm_name` = 'XTubeCatPerm') |
0.000253 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '67' AND (`gperm_groupid` = '3') AND `gperm_name` = 'XTubeCatPerm') |
0.000223 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '67' AND (`gperm_groupid` = '3') AND `gperm_name` = 'XTubeCatPerm') |
0.000230 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '67' AND (`gperm_groupid` = '3') AND `gperm_name` = 'XTubeCatPerm') |
0.000218 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '67' AND (`gperm_groupid` = '3') AND `gperm_name` = 'XTubeCatPerm') |
0.000249 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '67' AND (`gperm_groupid` = '3') AND `gperm_name` = 'XTubeCatPerm') |
0.000218 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '67' AND (`gperm_groupid` = '3') AND `gperm_name` = 'XTubeCatPerm') |
0.000226 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '67' AND (`gperm_groupid` = '3') AND `gperm_name` = 'XTubeCatPerm') |
0.000092 - SELECT cid FROM xoopstube_cat |
0.000248 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '67' AND (`gperm_groupid` = '3') AND `gperm_name` = 'XTubeCatPerm' AND `gperm_itemid` = '1') |
0.000234 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '67' AND (`gperm_groupid` = '3') AND `gperm_name` = 'XTubeCatPerm' AND `gperm_itemid` = '2') |
0.000224 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '67' AND (`gperm_groupid` = '3') AND `gperm_name` = 'XTubeCatPerm' AND `gperm_itemid` = '3') |
0.000186 - SELECT * FROM xoopstube_cat WHERE pid=0 ORDER BY title |
0.000219 - SELECT a.lid, a.cid, a.published FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid=a.lid WHERE a.published > 0 AND a.published <= 1686301386 AND (a.expired = 0 OR a.expired > 1686301386) AND offline = 0 AND (b.cid=a.cid OR (a.cid=2 OR b.cid=2)) GROUP BY a.lid, a.cid, a.published |
0.000235 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '67' AND (`gperm_groupid` = '3') AND `gperm_name` = 'XTubeCatPerm') |
0.000219 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '67' AND (`gperm_groupid` = '3') AND `gperm_name` = 'XTubeCatPerm') |
0.000230 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '67' AND (`gperm_groupid` = '3') AND `gperm_name` = 'XTubeCatPerm') |
0.000228 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '67' AND (`gperm_groupid` = '3') AND `gperm_name` = 'XTubeCatPerm') |
0.000216 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '67' AND (`gperm_groupid` = '3') AND `gperm_name` = 'XTubeCatPerm') |
0.000100 - SELECT cid FROM xoopstube_cat WHERE pid=2 |
0.000241 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '67' AND (`gperm_groupid` = '3') AND `gperm_name` = 'XTubeCatPerm' AND `gperm_itemid` = '2') |
0.000128 - SELECT * FROM xoopstube_cat WHERE pid=2 ORDER BY title |
0.000228 - SELECT a.lid, a.cid, a.published FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid=a.lid WHERE a.published > 0 AND a.published <= 1686301386 AND (a.expired = 0 OR a.expired > 1686301386) AND offline = 0 AND (b.cid=a.cid OR (a.cid=3 OR b.cid=3)) GROUP BY a.lid, a.cid, a.published |
0.000255 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '67' AND (`gperm_groupid` = '3') AND `gperm_name` = 'XTubeCatPerm') |
0.000106 - SELECT cid FROM xoopstube_cat WHERE pid=3 |
0.000254 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '67' AND (`gperm_groupid` = '3') AND `gperm_name` = 'XTubeCatPerm' AND `gperm_itemid` = '3') |
0.000129 - SELECT * FROM xoopstube_cat WHERE pid=3 ORDER BY title |
0.000193 - SELECT a.lid, a.cid, a.published FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid=a.lid WHERE a.published > 0 AND a.published <= 1686301386 AND (a.expired = 0 OR a.expired > 1686301386) AND offline = 0 AND (b.cid=a.cid OR (a.cid=1 OR b.cid=1)) GROUP BY a.lid, a.cid, a.published |
0.000245 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '67' AND (`gperm_groupid` = '3') AND `gperm_name` = 'XTubeCatPerm') |
0.000235 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '67' AND (`gperm_groupid` = '3') AND `gperm_name` = 'XTubeCatPerm') |
0.000219 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '67' AND (`gperm_groupid` = '3') AND `gperm_name` = 'XTubeCatPerm') |
0.000100 - SELECT cid FROM xoopstube_cat WHERE pid=1 |
0.000242 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '67' AND (`gperm_groupid` = '3') AND `gperm_name` = 'XTubeCatPerm' AND `gperm_itemid` = '1') |
0.000128 - SELECT * FROM xoopstube_cat WHERE pid=1 ORDER BY title |
0.000092 - SELECT lastvideosyn, lastvideostotal FROM xoopstube_indexpage |
0.000109 - select `tt_theme`,`tt_use_bootstrap`,`tt_bootstrap_color`,`tt_theme_kind` from `mtools_setup` where `tt_theme`='default' |
0.000474 - 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` = 'xoopstube_index.tpl') ORDER BY tpl_refid |
0.000329 - 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.tpl') ORDER BY tpl_refid |
0.000146 - SELECT * FROM xlanguage_base |