Анкор статьи 30 queries executed
1
SET sql_mode = 'MYSQL40'
2
SELECT folder, element, published, params
 FROM bak_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
3
SELECT template
 FROM bak_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 104 )
 ORDER BY menuid DESC
LIMIT 1
4
DELETE FROM bak_session
 WHERE (
 ( time < '1524319171' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1524321871' )
 AND guest = 1
 AND userid = 0
 )
5
SELECT *
 FROM bak_menu
 WHERE id = 104
6
SELECT COUNT(a.id)
 FROM bak_content AS a
 INNER JOIN bak_categories AS cc ON cc.id = a.catid
 LEFT JOIN bak_users AS u ON u.id = a.created_by
 LEFT JOIN bak_sections AS s ON a.sectionid = s.id
 LEFT JOIN bak_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 <= '2018-04-21 17:59' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-21 17:59' )
 AND ( a.sectionid=28 )
 AND s.published = 1
 AND cc.published = 1
7
SELECT a.id, a.title, a.title_alias, a.introtext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,
 a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access,
 CHAR_LENGTH( a.fulltext ) AS readmore, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups
 FROM bak_content AS a
 INNER JOIN bak_categories AS cc ON cc.id = a.catid
 LEFT JOIN bak_users AS u ON u.id = a.created_by
 LEFT JOIN bak_sections AS s ON a.sectionid = s.id
 LEFT JOIN bak_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 <= '2018-04-21 17:59' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-21 17:59' )
 AND ( a.sectionid=28 )
 AND s.published = 1
 AND cc.published = 1
 ORDER BY  a.created DESC
LIMIT 30, 30
8
SELECT folder, element, published, params
 FROM bak_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
9
SELECT a.*
 FROM bak_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'
10
SELECT id, title, module, position, content, showtitle, params
 FROM bak_modules AS m
 INNER JOIN bak_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 OR mm.menuid = 104 )
 ORDER BY ordering
11
SELECT a.id, a.title, a.sectionid, a.catid, a.images
 FROM bak_content AS a
 LEFT JOIN bak_content_frontpage AS f ON f.content_id = a.id
 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 <= '2018-04-21 16:59:31' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-21 16:59:31' )
 AND ( a.sectionid IN (10,11,12, 13, 14,15,16,17,18,19,20) )
 ORDER BY a.created DESC LIMIT 4
12
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 bak_content AS i
 LEFT JOIN bak_sections AS s ON i.sectionid = s.id
 LEFT JOIN bak_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN bak_categories AS c ON i.catid = c.id
 LEFT JOIN bak_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 = 75758
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
13
SELECT id 
 FROM bak_menu 
 WHERE type = 'content_blog_section'
 AND published = 1
 AND componentid = 0
14
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 bak_content AS i
 LEFT JOIN bak_sections AS s ON i.sectionid = s.id
 LEFT JOIN bak_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN bak_categories AS c ON i.catid = c.id
 LEFT JOIN bak_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 = 75757
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
15
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 bak_content AS i
 LEFT JOIN bak_sections AS s ON i.sectionid = s.id
 LEFT JOIN bak_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN bak_categories AS c ON i.catid = c.id
 LEFT JOIN bak_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 = 75756
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
16
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 bak_content AS i
 LEFT JOIN bak_sections AS s ON i.sectionid = s.id
 LEFT JOIN bak_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN bak_categories AS c ON i.catid = c.id
 LEFT JOIN bak_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 = 75755
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
17
SELECT a.id, a.title, a.sectionid, a.catid
 FROM bak_content AS a
 LEFT JOIN bak_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN bak_categories AS cc ON cc.id = a.catid
 INNER JOIN bak_sections AS s ON s.id = a.sectionid
 WHERE ( a.state = 1 AND a.sectionid > 0 )
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-21 17:59' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-21 17:59' )
 AND s.published = 1
 AND cc.published = 1
 ORDER BY a.created DESC
LIMIT 5
18
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 bak_content AS i
 LEFT JOIN bak_sections AS s ON i.sectionid = s.id
 LEFT JOIN bak_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN bak_categories AS c ON i.catid = c.id
 LEFT JOIN bak_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 = 75762
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
19
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 bak_content AS i
 LEFT JOIN bak_sections AS s ON i.sectionid = s.id
 LEFT JOIN bak_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN bak_categories AS c ON i.catid = c.id
 LEFT JOIN bak_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 = 75761
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
20
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 bak_content AS i
 LEFT JOIN bak_sections AS s ON i.sectionid = s.id
 LEFT JOIN bak_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN bak_categories AS c ON i.catid = c.id
 LEFT JOIN bak_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 = 75759
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
21
SELECT id
 FROM bak_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
22
SELECT id, name, link, parent, type, menutype, access
 FROM bak_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering
23
SELECT m.*
 FROM bak_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 ORDER BY parent, ordering
24
SELECT m.*
 FROM bak_menu AS m
 WHERE menutype = 'Konf_menu'
 AND published = 1
 ORDER BY parent, ordering
25
SELECT m.*
 FROM bak_menu AS m
 WHERE menutype = 'News_menu'
 AND published = 1
 ORDER BY parent, ordering
26
SELECT m.*
 FROM bak_menu AS m
 WHERE menutype = 'contakt-menu'
 AND published = 1
 ORDER BY parent, ordering
27
SELECT COUNT( id )
 FROM bak_menu 
 WHERE type = 'content_typed'
 AND published = 1
28
SELECT id
 FROM bak_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=12314'
29
SELECT m.*
 FROM bak_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND parent = 0
 ORDER BY ordering
30
SELECT id
 FROM bak_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1