Время запроса: 0.30 ms Память запроса: 0.013 MB Память до запроса: 2.493 MB Выбрано строк: 0
SELECT `data`
FROM `x8jlo_session`
WHERE `session_id` = 'p9l43m4u4u1j60dkcr345o5bs2'
EXPLAIN не доступен для запроса: SELECT `data`
FROM `x8jlo_session`
WHERE `session_id` = 'p9l43m4u4u1j60dkcr345o5bs2'
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
JROOT/libraries/joomla/session/storage/database.php:44
JROOT/libraries/joomla/session/session.php:579
JROOT/libraries/joomla/session/session.php:527
JROOT/libraries/cms/application/cms.php:739
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:399
JROOT/libraries/joomla/factory.php:125
JROOT/index.php:42
Время запроса: 0.28 ms После последнего запроса: 6.49 ms Память запроса: 0.010 MB Память до запроса: 2.684 MB Выбрано строк: 0
SELECT `session_id`
FROM `x8jlo_session`
WHERE `session_id` = 'p9l43m4u4u1j60dkcr345o5bs2'
LIMIT 0, 1
EXPLAIN не доступен для запроса: SELECT `session_id`
FROM `x8jlo_session`
WHERE `session_id` = 'p9l43m4u4u1j60dkcr345o5bs2' LIMIT 0, 1
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
JROOT/libraries/cms/application/cms.php:176
JROOT/libraries/cms/application/cms.php:765
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:399
JROOT/libraries/joomla/factory.php:125
JROOT/index.php:42
Время запроса: 0.25 ms После последнего запроса: 0.18 ms Память запроса: 0.009 MB Память до запроса: 2.697 MB
INSERT INTO `x8jlo_session`
(`session_id`, `client_id`, `time`)
VALUES
('p9l43m4u4u1j60dkcr345o5bs2', 0, '1730935800')
EXPLAIN не доступен для запроса: INSERT INTO `x8jlo_session`
(`session_id`, `client_id`, `time`) VALUES
('p9l43m4u4u1j60dkcr345o5bs2', 0, '1730935800')
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
JROOT/libraries/cms/application/cms.php:208
JROOT/libraries/cms/application/cms.php:765
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:399
JROOT/libraries/joomla/factory.php:125
JROOT/index.php:42
Время запроса: 0.52 ms После последнего запроса: 10.58 ms Память запроса: 0.013 MB Память до запроса: 3.202 MB Выбрано строк: 2
SELECT b.id
FROM x8jlo_usergroups AS a
LEFT JOIN x8jlo_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
EXPLAIN не доступен для запроса: SELECT b.id
FROM x8jlo_usergroups AS a
LEFT JOIN x8jlo_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE a.id = 9
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
JROOT/libraries/joomla/access/access.php:332
JROOT/libraries/joomla/access/access.php:401
JROOT/libraries/joomla/user/user.php:453
JROOT/libraries/cms/plugin/helper.php:296
JROOT/libraries/cms/plugin/helper.php:163
JROOT/libraries/cms/application/site.php:589
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
Время запроса: 0.45 ms После последнего запроса: 1.06 ms Память запроса: 0.011 MB Память до запроса: 3.259 MB Выбрано строк: 4
SELECT id, rules
FROM `x8jlo_viewlevels`
EXPLAIN не доступен для запроса: SELECT id, rules
FROM `x8jlo_viewlevels`
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
JROOT/libraries/joomla/access/access.php:418
JROOT/libraries/joomla/user/user.php:453
JROOT/libraries/cms/plugin/helper.php:296
JROOT/libraries/cms/plugin/helper.php:163
JROOT/libraries/cms/application/site.php:589
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
Время запроса: 0.99 ms После последнего запроса: 29.30 ms Память запроса: 0.017 MB Память до запроса: 4.553 MB Выбрано строк: 0
Повторяющиеся запросы:
#7SELECT `manifest_cache`
FROM `x8jlo_extensions`
WHERE `type` = 'component'
AND `name` = 'com_admintools'
EXPLAIN не доступен для запроса: SELECT `manifest_cache`
FROM `x8jlo_extensions`
WHERE `type` = 'component' AND `name` = 'com_admintools'
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
JROOT/libraries/fof30/Container/Container.php:787
JROOT/libraries/fof30/Container/Container.php:675
JROOT/libraries/fof30/Container/Container.php:159
JROOT/libraries/fof30/Container/Container.php:140
JROOT/plugins/system/admintools/admintools/main.php:813
JROOT/plugins/system/admintools/admintools/main.php:110
JROOT/libraries/cms/plugin/helper.php:255
JROOT/libraries/cms/plugin/helper.php:170
JROOT/libraries/cms/application/cms.php:653
JROOT/libraries/cms/application/site.php:663
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
Время запроса: 0.56 ms После последнего запроса: 17.24 ms Память запроса: 0.017 MB Память до запроса: 4.975 MB Выбрано строк: 0
Повторяющиеся запросы:
#6SELECT `manifest_cache`
FROM `x8jlo_extensions`
WHERE `type` = 'component'
AND `name` = 'com_admintools'
EXPLAIN не доступен для запроса: SELECT `manifest_cache`
FROM `x8jlo_extensions`
WHERE `type` = 'component' AND `name` = 'com_admintools'
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
JROOT/libraries/fof30/Container/Container.php:787
JROOT/libraries/fof30/Container/Container.php:675
JROOT/libraries/fof30/Container/Container.php:290
JROOT/libraries/fof30/Container/Container.php:140
JROOT/plugins/system/admintools/admintools/main.php:813
JROOT/plugins/system/admintools/admintools/main.php:110
JROOT/libraries/cms/plugin/helper.php:255
JROOT/libraries/cms/plugin/helper.php:170
JROOT/libraries/cms/application/cms.php:653
JROOT/libraries/cms/application/site.php:663
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
Время запроса: 0.24 ms После последнего запроса: 0.83 ms Память запроса: 0.017 MB Память до запроса: 5.013 MB Выбрано строк: 1
SELECT `value`
FROM `x8jlo_admintools_storage`
WHERE `key` = 'cparams'
EXPLAIN не доступен для запроса: SELECT `value`
FROM `x8jlo_admintools_storage`
WHERE `key` = 'cparams'
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
JROOT/administrator/components/com_admintools/Helper/Storage.php:123
JROOT/administrator/components/com_admintools/Helper/Storage.php:53
JROOT/administrator/components/com_admintools/Helper/Storage.php:41
JROOT/plugins/system/admintools/admintools/main.php:278
JROOT/plugins/system/admintools/admintools/main.php:831
JROOT/plugins/system/admintools/admintools/main.php:110
JROOT/libraries/cms/plugin/helper.php:255
JROOT/libraries/cms/plugin/helper.php:170
JROOT/libraries/cms/application/cms.php:653
JROOT/libraries/cms/application/site.php:663
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
Время запроса: 0.30 ms После последнего запроса: 2.61 ms Память запроса: 0.015 MB Память до запроса: 5.194 MB Выбрано строк: 0
SELECT *
FROM `x8jlo_admintools_wafexceptions`
WHERE NOT(`option` LIKE 'com_%')
EXPLAIN не доступен для запроса: SELECT *
FROM `x8jlo_admintools_wafexceptions`
WHERE NOT(`option` LIKE 'com_%')
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
JROOT/plugins/system/admintools/admintools/main.php:549
JROOT/plugins/system/admintools/admintools/main.php:460
JROOT/plugins/system/admintools/admintools/main.php:843
JROOT/plugins/system/admintools/admintools/main.php:110
JROOT/libraries/cms/plugin/helper.php:255
JROOT/libraries/cms/plugin/helper.php:170
JROOT/libraries/cms/application/cms.php:653
JROOT/libraries/cms/application/site.php:663
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
Время запроса: 0.90 ms После последнего запроса: 37.56 ms Память запроса: 0.017 MB Память до запроса: 6.131 MB Выбрано строк: 1
SHOW VARIABLES LIKE "collation_database"
EXPLAIN не доступен для запроса: SHOW VARIABLES LIKE "collation_database"
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
JROOT/plugins/system/admintools/feature/utf8mb4.php:28
JROOT/plugins/system/admintools/admintools/main.php:710
JROOT/plugins/system/admintools/admintools/main.php:135
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:654
JROOT/libraries/cms/application/site.php:663
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
Время запроса: 0.43 ms После последнего запроса: 0.59 ms Память запроса: 0.015 MB Память до запроса: 6.154 MB Выбрано строк: 0
SELECT `source`,`keepurlparams`
FROM `x8jlo_admintools_redirects`
WHERE ((`dest` = '') OR (`dest` = '') OR ('' LIKE `dest`))
AND `published` = '1'
ORDER BY `ordering` DESC
LIMIT 0, 1
EXPLAIN не доступен для запроса: SELECT `source`,`keepurlparams`
FROM `x8jlo_admintools_redirects`
WHERE ((`dest` = '') OR (`dest` = '') OR ('' LIKE `dest`)) AND `published` = '1'
ORDER BY `ordering` DESC LIMIT 0, 1
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
JROOT/plugins/system/admintools/feature/urlredir.php:89
JROOT/plugins/system/admintools/admintools/main.php:710
JROOT/plugins/system/admintools/admintools/main.php:135
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:654
JROOT/libraries/cms/application/site.php:663
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
Время запроса: 7.53 ms После последнего запроса: 21.52 ms Память запроса: 0.019 MB Память до запроса: 6.690 MB Выбрано строк: 111
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM x8jlo_menu AS m
LEFT JOIN x8jlo_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
EXPLAIN не доступен для запроса: SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM x8jlo_menu AS m
LEFT JOIN x8jlo_extensions AS e ON m.component_id = e.extension_id
WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0
ORDER BY m.lft
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
JROOT/libraries/cms/menu/site.php:45
JROOT/libraries/cms/menu/menu.php:64
JROOT/libraries/cms/menu/menu.php:118
JROOT/libraries/cms/application/cms.php:424
JROOT/libraries/cms/application/site.php:272
JROOT/libraries/cms/router/site.php:57
JROOT/libraries/cms/router/router.php:196
JROOT/libraries/cms/application/cms.php:520
JROOT/libraries/cms/application/site.php:407
JROOT/libraries/cms/application/cms.php:1088
JROOT/libraries/cms/application/site.php:763
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
Время запроса: 0.92 ms После последнего запроса: 21.84 ms Память запроса: 0.018 MB Память до запроса: 8.173 MB
UPDATE `x8jlo_extensions`
SET `params` = '{\"mediaversion\":\"160ea8d89c8af8404d0ec341be9124ed\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
EXPLAIN не доступен для запроса: UPDATE `x8jlo_extensions`
SET `params` = '{\"mediaversion\":\"160ea8d89c8af8404d0ec341be9124ed\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
JROOT/libraries/cms/library/helper.php:119
JROOT/libraries/cms/version/version.php:240
JROOT/libraries/cms/version/version.php:199
JROOT/libraries/joomla/factory.php:736
JROOT/libraries/joomla/factory.php:216
JROOT/plugins/system/sef/sef.php:29
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:763
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
Время запроса: 2.25 ms После последнего запроса: 67.61 ms Память запроса: 0.016 MB Память до запроса: 10.005 MB Выбрано строк: 17
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM x8jlo_modules AS m
LEFT JOIN x8jlo_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN x8jlo_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-11-06 23:30:00')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-11-06 23:30:00')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 101 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
EXPLAIN не доступен для запроса: SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM x8jlo_modules AS m
LEFT JOIN x8jlo_modules_menu AS mm ON mm.moduleid = m.id
LEFT JOIN x8jlo_extensions AS e ON e.element = m.module AND e.client_id = m.client_id
WHERE m.published = 1 AND e.enabled = 1 AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-11-06 23:30:00') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-11-06 23:30:00') AND m.access IN (1,1,5) AND m.client_id = 0 AND (mm.menuid = 101 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
JROOT/libraries/cms/module/helper.php:407
JROOT/libraries/cms/module/helper.php:350
JROOT/libraries/cms/module/helper.php:84
JROOT/libraries/joomla/document/html/html.php:501
JROOT/templates/gazikumuh/index.php:11
JROOT/libraries/joomla/document/html/html.php:578
JROOT/libraries/joomla/document/html/html.php:635
JROOT/libraries/joomla/document/html/html.php:455
JROOT/libraries/cms/application/cms.php:1045
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
Время запроса: 0.55 ms После последнего запроса: 26.08 ms Память запроса: 0.024 MB Память до запроса: 10.597 MB Выбрано строк: 1
SELECT a.rules
FROM x8jlo_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lft
EXPLAIN не доступен для запроса: SELECT a.rules
FROM x8jlo_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lft
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
JROOT/libraries/joomla/access/access.php:246
JROOT/libraries/joomla/user/user.php:384
JROOT/components/com_content/models/articles.php:449
JROOT/libraries/legacy/model/list.php:129
JROOT/libraries/legacy/model/list.php:181
JROOT/components/com_content/models/articles.php:537
JROOT/modules/mod_ga_articlesslideshow/helper.php:142
JROOT/modules/mod_ga_articlesslideshow/mod_ga_articlesslideshow.php:15
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/libraries/joomla/document/html/renderer/modules.php:43
JROOT/libraries/joomla/document/html/html.php:411
JROOT/libraries/joomla/document/html/html.php:697
JROOT/libraries/joomla/document/html/html.php:477
JROOT/libraries/cms/application/cms.php:1059
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
Время запроса: 6.85 ms После последнего запроса: 1.20 ms Память запроса: 0.025 MB Память до запроса: 10.655 MB Выбрано строк: 2
SELECT b.rules
FROM x8jlo_assets AS a
LEFT JOIN x8jlo_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
EXPLAIN не доступен для запроса: SELECT b.rules
FROM x8jlo_assets AS a
LEFT JOIN x8jlo_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'com_content')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
JROOT/libraries/joomla/access/access.php:246
JROOT/libraries/joomla/access/access.php:107
JROOT/libraries/joomla/user/user.php:393
JROOT/components/com_content/models/articles.php:449
JROOT/libraries/legacy/model/list.php:129
JROOT/libraries/legacy/model/list.php:181
JROOT/components/com_content/models/articles.php:537
JROOT/modules/mod_ga_articlesslideshow/helper.php:142
JROOT/modules/mod_ga_articlesslideshow/mod_ga_articlesslideshow.php:15
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/libraries/joomla/document/html/renderer/modules.php:43
JROOT/libraries/joomla/document/html/html.php:411
JROOT/libraries/joomla/document/html/html.php:697
JROOT/libraries/joomla/document/html/html.php:477
JROOT/libraries/cms/application/cms.php:1059
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
Время запроса: 22.44 ms После последнего запроса: 0.37 ms Память запроса: 0.020 MB Память до запроса: 10.685 MB Выбрано строк: 3
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM x8jlo_content AS a
LEFT JOIN x8jlo_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN x8jlo_categories AS c
ON c.id = a.catid
LEFT JOIN x8jlo_users AS ua
ON ua.id = a.created_by
LEFT JOIN x8jlo_users AS uam
ON uam.id = a.modified_by
LEFT JOIN x8jlo_categories as parent
ON parent.id = c.parent_id
LEFT JOIN x8jlo_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM x8jlo_categories AS cat JOIN x8jlo_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.catid IN (20,35,37,38,39,40,41,43,44,46,45,42,36)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-11-06 23:30:00')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-06 23:30:00')
ORDER BY a.created desc
LIMIT 0, 3
EXPLAIN не доступен для запроса: SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM x8jlo_content AS a
LEFT JOIN x8jlo_content_frontpage AS fp ON fp.content_id = a.id
LEFT JOIN x8jlo_categories AS c ON c.id = a.catid
LEFT JOIN x8jlo_users AS ua ON ua.id = a.created_by
LEFT JOIN x8jlo_users AS uam ON uam.id = a.modified_by
LEFT JOIN x8jlo_categories as parent ON parent.id = c.parent_id
LEFT JOIN x8jlo_content_rating AS v ON a.id = v.content_id
LEFT OUTER JOIN (SELECT cat.id as id FROM x8jlo_categories AS cat JOIN x8jlo_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id
WHERE a.access IN (1,1,5) AND c.access IN (1,1,5) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND a.catid IN (20,35,37,38,39,40,41,43,44,46,45,42,36) AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-11-06 23:30:00') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-06 23:30:00')
ORDER BY a.created desc LIMIT 0, 3
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
JROOT/libraries/legacy/model/legacy.php:312
JROOT/libraries/legacy/model/list.php:185
JROOT/components/com_content/models/articles.php:537
JROOT/modules/mod_ga_articlesslideshow/helper.php:142
JROOT/modules/mod_ga_articlesslideshow/mod_ga_articlesslideshow.php:15
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/libraries/joomla/document/html/renderer/modules.php:43
JROOT/libraries/joomla/document/html/html.php:411
JROOT/libraries/joomla/document/html/html.php:697
JROOT/libraries/joomla/document/html/html.php:477
JROOT/libraries/cms/application/cms.php:1059
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
Время запроса: 0.68 ms После последнего запроса: 9.83 ms Память запроса: 0.019 MB Память до запроса: 10.954 MB Выбрано строк: 0
SELECT `m`.`tag_id`,`t`.*
FROM `x8jlo_contentitem_tag_map` AS m
INNER JOIN `x8jlo_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 1800
AND `t`.`published` = 1
AND t.access IN (1,1,5)
EXPLAIN не доступен для запроса: SELECT `m`.`tag_id`,`t`.*
FROM `x8jlo_contentitem_tag_map` AS m
INNER JOIN `x8jlo_tags` AS t ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 1800 AND `t`.`published` = 1 AND t.access IN (1,1,5)
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
JROOT/libraries/cms/helper/tags.php:426
JROOT/components/com_content/models/articles.php:663
JROOT/modules/mod_ga_articlesslideshow/helper.php:142
JROOT/modules/mod_ga_articlesslideshow/mod_ga_articlesslideshow.php:15
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/libraries/joomla/document/html/renderer/modules.php:43
JROOT/libraries/joomla/document/html/html.php:411
JROOT/libraries/joomla/document/html/html.php:697
JROOT/libraries/joomla/document/html/html.php:477
JROOT/libraries/cms/application/cms.php:1059
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
Время запроса: 4.94 ms После последнего запроса: 1.14 ms Память запроса: 0.019 MB Память до запроса: 10.992 MB Выбрано строк: 0
SELECT `m`.`tag_id`,`t`.*
FROM `x8jlo_contentitem_tag_map` AS m
INNER JOIN `x8jlo_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 1799
AND `t`.`published` = 1
AND t.access IN (1,1,5)
EXPLAIN не доступен для запроса: SELECT `m`.`tag_id`,`t`.*
FROM `x8jlo_contentitem_tag_map` AS m
INNER JOIN `x8jlo_tags` AS t ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 1799 AND `t`.`published` = 1 AND t.access IN (1,1,5)
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
JROOT/libraries/cms/helper/tags.php:426
JROOT/components/com_content/models/articles.php:663
JROOT/modules/mod_ga_articlesslideshow/helper.php:142
JROOT/modules/mod_ga_articlesslideshow/mod_ga_articlesslideshow.php:15
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/libraries/joomla/document/html/renderer/modules.php:43
JROOT/libraries/joomla/document/html/html.php:411
JROOT/libraries/joomla/document/html/html.php:697
JROOT/libraries/joomla/document/html/html.php:477
JROOT/libraries/cms/application/cms.php:1059
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
Время запроса: 1.39 ms После последнего запроса: 1.35 ms Память запроса: 0.019 MB Память до запроса: 11.030 MB Выбрано строк: 0
SELECT `m`.`tag_id`,`t`.*
FROM `x8jlo_contentitem_tag_map` AS m
INNER JOIN `x8jlo_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 1798
AND `t`.`published` = 1
AND t.access IN (1,1,5)
EXPLAIN не доступен для запроса: SELECT `m`.`tag_id`,`t`.*
FROM `x8jlo_contentitem_tag_map` AS m
INNER JOIN `x8jlo_tags` AS t ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 1798 AND `t`.`published` = 1 AND t.access IN (1,1,5)
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
JROOT/libraries/cms/helper/tags.php:426
JROOT/components/com_content/models/articles.php:663
JROOT/modules/mod_ga_articlesslideshow/helper.php:142
JROOT/modules/mod_ga_articlesslideshow/mod_ga_articlesslideshow.php:15
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/libraries/joomla/document/html/renderer/modules.php:43
JROOT/libraries/joomla/document/html/html.php:411
JROOT/libraries/joomla/document/html/html.php:697
JROOT/libraries/joomla/document/html/html.php:477
JROOT/libraries/cms/application/cms.php:1059
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
Время запроса: 7.54 ms После последнего запроса: 3.40 ms Память запроса: 0.020 MB Память до запроса: 11.150 MB Выбрано строк: 3
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM x8jlo_categories as c
LEFT JOIN x8jlo_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM x8jlo_categories AS cat JOIN x8jlo_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id=41
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
ORDER BY c.lft
EXPLAIN не доступен для запроса: SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM x8jlo_categories as c
LEFT JOIN x8jlo_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id FROM x8jlo_categories AS cat JOIN x8jlo_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1,5) AND c.published = 1 AND s.id=41 AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
ORDER BY c.lft
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
JROOT/libraries/legacy/categories/categories.php:292
JROOT/libraries/legacy/categories/categories.php:184
JROOT/components/com_content/helpers/route.php:44
JROOT/modules/mod_ga_articlesslideshow/helper.php:151
JROOT/modules/mod_ga_articlesslideshow/mod_ga_articlesslideshow.php:15
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/libraries/joomla/document/html/renderer/modules.php:43
JROOT/libraries/joomla/document/html/html.php:411
JROOT/libraries/joomla/document/html/html.php:697
JROOT/libraries/joomla/document/html/html.php:477
JROOT/libraries/cms/application/cms.php:1059
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
Время запроса: 12.44 ms После последнего запроса: 126.39 ms Память запроса: 0.027 MB Память до запроса: 13.273 MB Выбрано строк: 294
SHOW FULL COLUMNS
FROM `x8jlo_joomgallery_config`
EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `x8jlo_joomgallery_config`
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
JROOT/libraries/joomla/table/table.php:241
JROOT/libraries/joomla/table/table.php:162
JROOT/administrator/components/com_joomgallery/tables/joomgalleryconfig.php:332
JROOT/libraries/joomla/table/table.php:305
JROOT/administrator/components/com_joomgallery/helpers/config.php:359
JROOT/administrator/components/com_joomgallery/helpers/config.php:422
JROOT/components/com_joomgallery/helpers/ambit.php:147
JROOT/components/com_joomgallery/helpers/ambit.php:220
JROOT/components/com_joomgallery/interface.php:102
JROOT/modules/mod_joomimg/mod_joomimg.php:43
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/libraries/joomla/document/html/renderer/modules.php:43
JROOT/libraries/joomla/document/html/html.php:411
JROOT/libraries/joomla/document/html/html.php:697
JROOT/libraries/joomla/document/html/html.php:477
JROOT/libraries/cms/application/cms.php:1059
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
Время запроса: 0.77 ms После последнего запроса: 12.19 ms Память запроса: 0.022 MB Память до запроса: 14.041 MB Выбрано строк: 1
SELECT *
FROM x8jlo_joomgallery_config
WHERE `id` = '1'
EXPLAIN не доступен для запроса: SELECT *
FROM x8jlo_joomgallery_config
WHERE `id` = '1'
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
JROOT/libraries/joomla/table/table.php:728
JROOT/administrator/components/com_joomgallery/helpers/config.php:360
JROOT/administrator/components/com_joomgallery/helpers/config.php:422
JROOT/components/com_joomgallery/helpers/ambit.php:147
JROOT/components/com_joomgallery/helpers/ambit.php:220
JROOT/components/com_joomgallery/interface.php:102
JROOT/modules/mod_joomimg/mod_joomimg.php:43
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/libraries/joomla/document/html/renderer/modules.php:43
JROOT/libraries/joomla/document/html/html.php:411
JROOT/libraries/joomla/document/html/html.php:697
JROOT/libraries/joomla/document/html/html.php:477
JROOT/libraries/cms/application/cms.php:1059
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
Время запроса: 1.67 ms После последнего запроса: 23.75 ms Память запроса: 0.019 MB Память до запроса: 14.281 MB Выбрано строк: 3
SELECT c.cid, c.parent_id, c.name, c.access, c.published, c.hidden, c.owner
FROM x8jlo_joomgallery_catg AS c
WHERE lft > 0
AND c.published = 1
AND c.access IN (1,1,5)
AND (c.password = '' OR c.cid IN (0))
ORDER BY c.lft
EXPLAIN не доступен для запроса: SELECT c.cid, c.parent_id, c.name, c.access, c.published, c.hidden, c.owner
FROM x8jlo_joomgallery_catg AS c
WHERE lft > 0 AND c.published = 1 AND c.access IN (1,1,5) AND (c.password = '' OR c.cid IN (0))
ORDER BY c.lft
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
JROOT/components/com_joomgallery/helpers/ambit.php:489
JROOT/modules/mod_joomimg/helper.php:439
JROOT/modules/mod_joomimg/helper.php:47
JROOT/modules/mod_joomimg/mod_joomimg.php:52
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/libraries/joomla/document/html/renderer/modules.php:43
JROOT/libraries/joomla/document/html/html.php:411
JROOT/libraries/joomla/document/html/html.php:697
JROOT/libraries/joomla/document/html/html.php:477
JROOT/libraries/cms/application/cms.php:1059
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
Время запроса: 0.94 ms После последнего запроса: 0.35 ms Память запроса: 0.019 MB Память до запроса: 14.307 MB Выбрано строк: 3
SELECT catid, COUNT(id) as piccount, SUM(hits) as hitcount
FROM x8jlo_joomgallery
WHERE approved = 1
AND published = 1
AND hidden = 0
AND access IN (1,1,5)
GROUP BY catid
EXPLAIN не доступен для запроса: SELECT catid, COUNT(id) as piccount, SUM(hits) as hitcount
FROM x8jlo_joomgallery
WHERE approved = 1 AND published = 1 AND hidden = 0 AND access IN (1,1,5)
GROUP BY catid
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
JROOT/components/com_joomgallery/helpers/ambit.php:505
JROOT/modules/mod_joomimg/helper.php:439
JROOT/modules/mod_joomimg/helper.php:47
JROOT/modules/mod_joomimg/mod_joomimg.php:52
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/libraries/joomla/document/html/renderer/modules.php:43
JROOT/libraries/joomla/document/html/html.php:411
JROOT/libraries/joomla/document/html/html.php:697
JROOT/libraries/joomla/document/html/html.php:477
JROOT/libraries/cms/application/cms.php:1059
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
Время запроса: 2.14 ms После последнего запроса: 0.39 ms Память запроса: 0.018 MB Память до запроса: 14.325 MB Выбрано строк: 4
SELECT p.id AS id, p.catid, p.imgthumbname, p.imgfilename, p.imgtitle,p.imgtext,c.cid AS ccid, c.catpath AS catpath
FROM x8jlo_joomgallery AS p
LEFT JOIN x8jlo_joomgallery_catg AS c
ON c.cid = p.catid
WHERE c.published = 1
AND c.access IN (1,1,5)
AND p.published = 1
AND p.approved = 1
AND p.access IN (1,1,5)
AND p.catid IN (7,6,2)
AND c.hidden = 0
AND c.in_hidden = 0
AND p.hidden = 0
ORDER BY rand()
LIMIT 0, 4
EXPLAIN не доступен для запроса: SELECT p.id AS id, p.catid, p.imgthumbname, p.imgfilename, p.imgtitle,p.imgtext,c.cid AS ccid, c.catpath AS catpath
FROM x8jlo_joomgallery AS p
LEFT JOIN x8jlo_joomgallery_catg AS c ON c.cid = p.catid
WHERE c.published = 1 AND c.access IN (1,1,5) AND p.published = 1 AND p.approved = 1 AND p.access IN (1,1,5) AND p.catid IN (7,6,2) AND c.hidden = 0 AND c.in_hidden = 0 AND p.hidden = 0
ORDER BY rand() LIMIT 0, 4
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
JROOT/modules/mod_joomimg/helper.php:511
JROOT/modules/mod_joomimg/helper.php:47
JROOT/modules/mod_joomimg/mod_joomimg.php:52
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/libraries/joomla/document/html/renderer/modules.php:43
JROOT/libraries/joomla/document/html/html.php:411
JROOT/libraries/joomla/document/html/html.php:697
JROOT/libraries/joomla/document/html/html.php:477
JROOT/libraries/cms/application/cms.php:1059
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
Время запроса: 3.50 ms После последнего запроса: 0.73 ms Память запроса: 0.021 MB Память до запроса: 14.353 MB Выбрано строк: 1
SELECT id
FROM x8jlo_menu
WHERE link LIKE '%com_joomgallery%view=gallery%'
AND access IN (1,1,5)
AND published = 1
AND client_id = 0
ORDER BY id DESC
EXPLAIN не доступен для запроса: SELECT id
FROM x8jlo_menu
WHERE link LIKE '%com_joomgallery%view=gallery%' AND access IN (1,1,5) AND published = 1 AND client_id = 0
ORDER BY id DESC
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
JROOT/components/com_joomgallery/helpers/ambit.php:424
JROOT/components/com_joomgallery/interface.php:304
JROOT/components/com_joomgallery/interface.php:370
JROOT/modules/mod_joomimg/helper.php:782
JROOT/modules/mod_joomimg/helper.php:100
JROOT/modules/mod_joomimg/mod_joomimg.php:52
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/libraries/joomla/document/html/renderer/modules.php:43
JROOT/libraries/joomla/document/html/html.php:411
JROOT/libraries/joomla/document/html/html.php:697
JROOT/libraries/joomla/document/html/html.php:477
JROOT/libraries/cms/application/cms.php:1059
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
Время запроса: 0.40 ms После последнего запроса: 15.85 ms Память запроса: 0.025 MB Память до запроса: 14.877 MB Выбрано строк: 1
SELECT catpath
FROM x8jlo_joomgallery_catg
WHERE cid = 6
EXPLAIN не доступен для запроса: SELECT catpath
FROM x8jlo_joomgallery_catg
WHERE cid = 6
Не поддерживается SHOW PROFILE (возможно потому, что более 100 запросов)
JROOT/components/com_joomgallery/helpers/helper.php:141
JROOT/components/com_joomgallery/helpers/ambit.php:338
JROOT/administrator/components/com_joomgallery/helpers/html/joomgallery.php:573
JROOT/libraries/cms/html/html.php:236
JROOT/libraries/cms/html/html.php:138
JROOT/components/com_joomgallery/interface.php:372
JROOT/modules/mod_joomimg/helper.php:782
JROOT/modules/mod_joomimg/helper.php:100
JROOT/modules/mod_joomimg/mod_joomimg.php:52
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/libraries/joomla/document/html/renderer/modules.php:43
JROOT/libraries/joomla/document/html/html.php:411
JROOT/libraries/joomla/document/html/html.php:697
JROOT/libraries/joomla/document/html/html.php:477
JROOT/libraries/cms/application/cms.php:1059
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
3 × SELECT `m`.`tag_id`,`t`.*
FROM `x8jlo_contentitem_tag_map` AS m
INNER JOIN `x8jlo_tags` AS t
ON `m`.`tag_id` = `t`.`id`
2 × SELECT `manifest_cache`
FROM `x8jlo_extensions`
1 × SELECT *
FROM x8jlo_joomgallery_config
1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM x8jlo_categories as c
LEFT JOIN x8jlo_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM x8jlo_categories AS cat JOIN x8jlo_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
1 × SELECT c.cid, c.parent_id, c.name, c.access, c.published, c.hidden, c.owner
FROM x8jlo_joomgallery_catg AS c
1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM x8jlo_content AS a
LEFT JOIN x8jlo_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN x8jlo_categories AS c
ON c.id = a.catid
LEFT JOIN x8jlo_users AS ua
ON ua.id = a.created_by
LEFT JOIN x8jlo_users AS uam
ON uam.id = a.modified_by
LEFT JOIN x8jlo_categories as parent
ON parent.id = c.parent_id
LEFT JOIN x8jlo_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM x8jlo_categories AS cat JOIN x8jlo_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
1 × SELECT catid, COUNT(id) as piccount, SUM(hits) as hitcount
FROM x8jlo_joomgallery
1 × SELECT catpath
FROM x8jlo_joomgallery_catg
1 × SELECT id
FROM x8jlo_menu
1 × SELECT p.id AS id, p.catid, p.imgthumbname, p.imgfilename, p.imgtitle,p.imgtext,c.cid AS ccid, c.catpath AS catpath
FROM x8jlo_joomgallery AS p
LEFT JOIN x8jlo_joomgallery_catg AS c
ON c.cid = p.catid
1 × SELECT b.rules
FROM x8jlo_assets AS a
LEFT JOIN x8jlo_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT a.rules
FROM x8jlo_assets AS a
1 × SELECT id, rules
FROM `x8jlo_viewlevels
1 × SELECT b.id
FROM x8jlo_usergroups AS a
LEFT JOIN x8jlo_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT `session_id`
FROM `x8jlo_session`
1 × SELECT `value`
FROM `x8jlo_admintools_storage`
1 × SELECT *
FROM `x8jlo_admintools_wafexceptions`
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM x8jlo_modules AS m
LEFT JOIN x8jlo_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN x8jlo_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM x8jlo_menu AS m
LEFT JOIN x8jlo_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT `source`,`keepurlparams`
FROM `x8jlo_admintools_redirects`
1 × SELECT `data`
FROM `x8jlo_session`