48 queries executed
1
SET sql_mode = 'MYSQL40'
2 SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 AND folder = 'system' ORDER BY ordering
3 SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 AND folder = 'sefpatch' ORDER BY ordering
4 SELECT file, title FROM jos_sefexts WHERE title != ''
5 SELECT name, link, id FROM jos_menu WHERE published > 0 AND link LIKE 'index.php?option=com_%'
6 UPDATE jos_redirection SET cpt=(cpt+1) WHERE `newurl` = 'index.php?option=com_xmap'
7 SELECT template FROM jos_templates_menu WHERE client_id = 0 AND ( menuid = 0 OR menuid = 99999999 ) ORDER BY menuid DESC LIMIT 1
8 DELETE FROM jos_session WHERE ( ( time < '1571468230' ) AND guest = 0 AND gid > 0 ) OR ( ( time < '1571468230' ) AND guest = 1 AND userid = 0 )
9 SELECT template FROM jos_templates_menu WHERE client_id = 0 AND ( menuid = 0 OR menuid = 99999999 ) ORDER BY menuid DESC LIMIT 1
10 SELECT * FROM jos_menu WHERE published = 1 AND link LIKE 'index.php?option=com\_xmap%'
11 SELECT * FROM jos_xmap
12 SELECT * FROM jos_xmap_sitemap where id=1
13 select * from `jos_xmap_ext` where `published`=1 and extension not like '%.bak'
14 SELECT * FROM jos_menu WHERE id = '0'
15 SELECT * FROM jos_modules WHERE published='1' AND module='mod_mainmenu' AND params LIKE '%menutype=topmenu%'
16 SELECT m.id, m.name, m.parent, m.link, m.type, m.browserNav, m.menutype, m.ordering, m.params, m.componentid, c.name AS component FROM jos_menu AS m LEFT JOIN jos_components AS c ON m.type='components' AND c.id=m.componentid WHERE m.published='1' AND m.parent=0 AND m.menutype = 'topmenu' AND m.access <= '0' ORDER BY m.menutype,m.parent,m.ordering
17 SELECT * FROM jos_sefexts WHERE file = 'com_true.xml'
18 SELECT m.id, m.name, m.parent, m.link, m.type, m.browserNav, m.menutype, m.ordering, m.params, m.componentid, c.name AS component FROM jos_menu AS m LEFT JOIN jos_components AS c ON m.type='components' AND c.id=m.componentid WHERE m.published='1' AND m.parent=7 AND m.menutype = 'topmenu' AND m.access <= '0' ORDER BY m.menutype,m.parent,m.ordering
19 SELECT * FROM jos_sefexts WHERE file = 'com_content.xml'
20 SELECT m.id, m.name, m.parent, m.link, m.type, m.browserNav, m.menutype, m.ordering, m.params, m.componentid, c.name AS component FROM jos_menu AS m LEFT JOIN jos_components AS c ON m.type='components' AND c.id=m.componentid WHERE m.published='1' AND m.parent=5 AND m.menutype = 'topmenu' AND m.access <= '0' ORDER BY m.menutype,m.parent,m.ordering
21 SELECT m.id, m.name, m.parent, m.link, m.type, m.browserNav, m.menutype, m.ordering, m.params, m.componentid, c.name AS component FROM jos_menu AS m LEFT JOIN jos_components AS c ON m.type='components' AND c.id=m.componentid WHERE m.published='1' AND m.parent=17 AND m.menutype = 'topmenu' AND m.access <= '0' ORDER BY m.menutype,m.parent,m.ordering
22 SELECT a.id, a.title, a.modified, a.created FROM jos_content AS a WHERE a.catid=(1) AND a.state='1' AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-10-19 10:12:11' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-10-19 10:12:11' ) AND a.access<='0' ORDER BY a.created DESC
23 SELECT m.id, m.name, m.parent, m.link, m.type, m.browserNav, m.menutype, m.ordering, m.params, m.componentid, c.name AS component FROM jos_menu AS m LEFT JOIN jos_components AS c ON m.type='components' AND c.id=m.componentid WHERE m.published='1' AND m.parent=16 AND m.menutype = 'topmenu' AND m.access <= '0' ORDER BY m.menutype,m.parent,m.ordering
24 SELECT a.id, a.title, a.modified, a.created FROM jos_content AS a INNER JOIN jos_categories AS cc ON cc.id = a.catid LEFT JOIN jos_users AS u ON u.id = a.created_by LEFT JOIN jos_content_rating AS v ON a.id = v.content_id LEFT JOIN jos_sections AS s ON a.sectionid = s.id LEFT JOIN jos_groups AS g ON a.access = g.id WHERE a.state = '1' AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-10-19 10:12:11' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-10-19 10:12:11' ) AND a.sectionid IN ( 4 ) AND s.access <= 0 AND cc.access <= 0 AND s.published = 1 AND cc.published = 1 ORDER BY a.created DESC
25 SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_content&id=15&task=view'
26 SELECT a.title AS title, a.id FROM jos_content as a LEFT JOIN jos_sections AS s ON a.sectionid = s.id WHERE a.id = 15
27 SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_content&id=15&task=view'
28 SELECT newurl, Itemid FROM jos_redirection WHERE oldurl = ''
29 SELECT m.id, m.name, m.parent, m.link, m.type, m.browserNav, m.menutype, m.ordering, m.params, m.componentid, c.name AS component FROM jos_menu AS m LEFT JOIN jos_components AS c ON m.type='components' AND c.id=m.componentid WHERE m.published='1' AND m.parent=8 AND m.menutype = 'topmenu' AND m.access <= '0' ORDER BY m.menutype,m.parent,m.ordering
30 SELECT * FROM jos_sefexts WHERE file = 'com_artforms.xml'
31 SELECT m.id, m.name, m.parent, m.link, m.type, m.browserNav, m.menutype, m.ordering, m.params, m.componentid, c.name AS component FROM jos_menu AS m LEFT JOIN jos_components AS c ON m.type='components' AND c.id=m.componentid WHERE m.published='1' AND m.parent=10 AND m.menutype = 'topmenu' AND m.access <= '0' ORDER BY m.menutype,m.parent,m.ordering
32 UPDATE jos_xmap_sitemap SET `name`='New Sitemap',`expand_category`='1',`expand_section`='1',`show_menutitle`='1',`columns`='1',`exlinks`='1',`ext_image`='img_grey.gif',`menus`='topmenu,1,1,1,0.5,daily',`exclmenus`='',`includelink`='1',`usecache`='0',`cachelifetime`='900',`classname`='xmap',`count_xml`='0',`count_html`='11',`views_xml`='0',`views_html`='3850',`lastvisit_xml`='0',`lastvisit_html`='1571469131' WHERE id=1
33 SELECT id FROM jos_mambots WHERE element = 'joomsef_metabot' AND folder = 'system'
34 SELECT * FROM jos_mambots WHERE id = '22'
35 SELECT a.* FROM jos_components AS a WHERE ( a.admin_menu_link = 'option=com_syndicate' OR a.admin_menu_link = 'option=com_syndicate&hidemainmenu=1' ) AND a.option = 'com_syndicate'
36 SELECT id, title, module, position, content, showtitle, params FROM jos_modules AS m INNER JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id != 1 AND ( mm.menuid = 0 ) ORDER BY ordering
37 SELECT m.* FROM jos_menu AS m WHERE menutype = 'topmenu' AND published = 1 AND access <= 0 ORDER BY parent, ordering
38 SELECT COUNT( id ) FROM jos_menu WHERE type = 'content_item_link' AND published = 1
39 SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=4'
40 SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=3'
41 SELECT folder, element, published, params FROM jos_mambots WHERE access <= 0 AND folder = 'content' ORDER BY ordering
42 SELECT * FROM jos_sefexts WHERE file = 'com_xmap.xml'
43 select id from jos_menu where link='index.php?option=com_true'
44 SELECT a.*, c.username, b.description FROM jos_true AS a LEFT JOIN jos_true_catg AS b ON b.cid = a.catid LEFT JOIN jos_users AS c ON a.owner = c.id WHERE a.catid = b.cid AND ( a.catid=1 ) AND a.published = 1 AND a.approved = 1 AND b.published = 1 AND b.access <= 0 ORDER BY RAND() DESC LIMIT 2
45 SELECT a.id, a.title as title, a.images, a.created, u.name, a.created_by_alias, u.email, a.created_by, a.modified, a.introtext, cc.id AS cc_id, cc.title AS cc_title, a.sectionid, a.catid, ss.title AS ss_title, a.ordering, a.hits FROM jos_content AS a INNER JOIN jos_categories AS c ON c.id = a.catid LEFT JOIN jos_users AS u ON u.id = a.created_by LEFT JOIN jos_categories AS cc ON cc.id = a.catid LEFT JOIN jos_sections AS ss ON ss.id = a.sectionid WHERE ( a.state = '1' AND a.checked_out = '0' AND a.sectionid > '0' ) AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-10-19 10:12' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-10-19 10:12' ) AND ( a.catid IN (1) ) AND ( a.sectionid IN (1) ) ORDER BY created DESC LIMIT 3
46 SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub FROM jos_content AS i LEFT JOIN jos_sections AS s ON i.sectionid = s.id LEFT JOIN jos_menu AS ms ON ms.componentid = s.id LEFT JOIN jos_categories AS c ON i.catid = c.id LEFT JOIN jos_menu AS mc ON mc.componentid = c.id WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) ) AND i.id = 1 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
47 SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub FROM jos_content AS i LEFT JOIN jos_sections AS s ON i.sectionid = s.id LEFT JOIN jos_menu AS ms ON ms.componentid = s.id LEFT JOIN jos_categories AS c ON i.catid = c.id LEFT JOIN jos_menu AS mc ON mc.componentid = c.id WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) ) AND i.id = 2 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
48 SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub FROM jos_content AS i LEFT JOIN jos_sections AS s ON i.sectionid = s.id LEFT JOIN jos_menu AS ms ON ms.componentid = s.id LEFT JOIN jos_categories AS c ON i.catid = c.id LEFT JOIN jos_menu AS mc ON mc.componentid = c.id WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) ) AND i.id = 14 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id