Направляемые сообщения не являются обращениями граждан, рассматриваемыми в порядке, установленном Федеральным законом от 2 мая 2006 г. № 59-ФЗ «О порядке рассмотрения обращений граждан Российской Федерации».
EXPLAIN не доступен для запроса: INSERT INTO `x8jlo_session`
(`session_id`, `client_id`, `time`) VALUES
('tmp735po1oue7taogb7lmm1ds7', 0, '1713534656')
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
Время запроса: 0.42 ms После последнего запроса: 0.31 msПамять запроса: 0.015 MB Память до запроса: 6.159 MBВыбрано строк: 0
SELECT `source`,`keepurlparams`
FROM `x8jlo_admintools_redirects`
WHERE ((`dest` = 'o-rajone/allnews.html') OR (`dest` = 'o-rajone/allnews.html?start=640') OR ('o-rajone/allnews.html?start=640' LIKE `dest`)) AND `published` = '1'
ORDERBY `ordering` DESC LIMIT 0, 1
EXPLAIN не доступен для запроса: SELECT `source`,`keepurlparams`
FROM `x8jlo_admintools_redirects`
WHERE ((`dest` = 'o-rajone/allnews.html') OR (`dest` = 'o-rajone/allnews.html?start=640') OR ('o-rajone/allnews.html?start=640' LIKE `dest`)) AND `published` = '1'
ORDER BY `ordering` DESC LIMIT 0, 1
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
EXPLAIN не доступен для запроса: UPDATE `x8jlo_extensions`
SET `params` = '{\"mediaversion\":\"1eea027d5828b3f881992001af4839a4\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
Время запроса: 2.02 ms После последнего запроса: 1.15 msПамять запроса: 0.025 MB Память до запроса: 9.640 MBВыбрано строк: 3
SELECT b.rules
FROMx8jlo_assetsAS a
LEFTJOINx8jlo_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'com_content.category.20')
GROUPBY b.id, b.rules, b.lft
ORDERBY 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.category.20')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
Время запроса: 37.63 ms После последнего запроса: 2.61 msПамять запроса: 0.024 MB Память до запроса: 9.781 MBВыбрано строк: 10
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, CASEWHENCHAR_LENGTH(c.alias) != 0 THENCONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems
FROMx8jlo_categories as c
LEFTJOINx8jlo_categoriesAS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt)
LEFTJOIN (SELECT cat.id as id FROMx8jlo_categoriesAS cat JOINx8jlo_categoriesAS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUPBY cat.id) AS badcats ON badcats.id = c.id
LEFTJOIN `x8jlo_content` AS i ON i.`catid` = c.id AND i.state = 1
WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1,5) AND c.published = 1 AND s.id=20 AND badcats.id is null
GROUPBY 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
ORDERBY 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,COUNT(i.`id`) AS numitems
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
LEFT JOIN `x8jlo_content` AS i ON i.`catid` = c.id AND i.state = 1
WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1,5) AND c.published = 1 AND s.id=20 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
Время запроса: 4.05 ms После последнего запроса: 3.18 msПамять запроса: 0.028 MB Память до запроса: 10.029 MBВыбрано строк: 2
SELECT b.rules
FROMx8jlo_assetsAS a
LEFTJOINx8jlo_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'com_content')
GROUPBY b.id, b.rules, b.lft
ORDERBY 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
Время запроса: 28.83 ms После последнего запроса: 0.37 msПамять запроса: 0.024 MB Память до запроса: 10.060 MBВыбрано строк: 20
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, CASEWHEN 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, CASEWHEN 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, CASEWHEN badcats.id is not null THEN 0 ELSE a.state ENDAS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias, CASEWHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name ENDAS 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, CASEWHEN badcats.id is null THEN c.published ELSE 0 ENDAS parents_published
FROMx8jlo_contentAS a
LEFTJOINx8jlo_content_frontpageAS fp ON fp.content_id = a.id
LEFTJOINx8jlo_categoriesAS c ON c.id = a.catid
LEFTJOINx8jlo_usersAS ua ON ua.id = a.created_by
LEFTJOINx8jlo_usersAS uam ON uam.id = a.modified_by
LEFTJOINx8jlo_categories as parent ON parent.id = c.parent_id
LEFTJOINx8jlo_content_ratingAS v ON a.id = v.content_id
LEFT OUTERJOIN (SELECT cat.id as id FROMx8jlo_categoriesAS cat JOINx8jlo_categoriesAS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUPBY cat.id ) AS badcats ON badcats.id = c.id
WHERE a.access IN (1,1,5) AND c.access IN (1,1,5) AND CASEWHEN badcats.id is null THEN a.state ELSE 0 END= 1 AND (a.catid = 20 OR a.catid IN (
SELECT sub.id
FROMx8jlo_categories as sub
INNERJOINx8jlo_categories as this ON sub.lft > this.lft AND sub.rgt < this.rgt
WHERE this.id = 20)) AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-19 13:50:56') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-19 13:50:56')
ORDERBY a.created DESC , a.created LIMIT 640, 20
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 = 20 OR a.catid IN (
SELECT sub.id
FROM x8jlo_categories as sub
INNER JOIN x8jlo_categories as this ON sub.lft > this.lft AND sub.rgt < this.rgt
WHERE this.id = 20)) AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-19 13:50:56') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-19 13:50:56')
ORDER BY a.created DESC , a.created LIMIT 640, 20
Время запроса: 4.58 ms После последнего запроса: 6.35 msПамять запроса: 0.022 MB Память до запроса: 11.006 MBВыбрано строк: 0
SELECT `m`.`tag_id`,`t`.* FROM `x8jlo_contentitem_tag_map` AS m
INNERJOIN `x8jlo_tags` AS t ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 991 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` = 991 AND `t`.`published` = 1 AND t.access IN (1,1,5)
Время запроса: 0.55 ms После последнего запроса: 0.83 msПамять запроса: 0.022 MB Память до запроса: 11.047 MBВыбрано строк: 0
SELECT `m`.`tag_id`,`t`.* FROM `x8jlo_contentitem_tag_map` AS m
INNERJOIN `x8jlo_tags` AS t ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 989 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` = 989 AND `t`.`published` = 1 AND t.access IN (1,1,5)
Время запроса: 0.40 ms После последнего запроса: 0.55 msПамять запроса: 0.022 MB Память до запроса: 11.087 MBВыбрано строк: 0
SELECT `m`.`tag_id`,`t`.* FROM `x8jlo_contentitem_tag_map` AS m
INNERJOIN `x8jlo_tags` AS t ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 988 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` = 988 AND `t`.`published` = 1 AND t.access IN (1,1,5)
Время запроса: 0.39 ms После последнего запроса: 0.53 msПамять запроса: 0.022 MB Память до запроса: 11.127 MBВыбрано строк: 0
SELECT `m`.`tag_id`,`t`.* FROM `x8jlo_contentitem_tag_map` AS m
INNERJOIN `x8jlo_tags` AS t ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 987 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` = 987 AND `t`.`published` = 1 AND t.access IN (1,1,5)
Время запроса: 0.33 ms После последнего запроса: 0.52 msПамять запроса: 0.022 MB Память до запроса: 11.168 MBВыбрано строк: 0
SELECT `m`.`tag_id`,`t`.* FROM `x8jlo_contentitem_tag_map` AS m
INNERJOIN `x8jlo_tags` AS t ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 986 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` = 986 AND `t`.`published` = 1 AND t.access IN (1,1,5)
Время запроса: 0.33 ms После последнего запроса: 0.53 msПамять запроса: 0.022 MB Память до запроса: 11.208 MBВыбрано строк: 0
SELECT `m`.`tag_id`,`t`.* FROM `x8jlo_contentitem_tag_map` AS m
INNERJOIN `x8jlo_tags` AS t ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 985 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` = 985 AND `t`.`published` = 1 AND t.access IN (1,1,5)
Время запроса: 0.32 ms После последнего запроса: 0.53 msПамять запроса: 0.022 MB Память до запроса: 11.249 MBВыбрано строк: 0
SELECT `m`.`tag_id`,`t`.* FROM `x8jlo_contentitem_tag_map` AS m
INNERJOIN `x8jlo_tags` AS t ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 984 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` = 984 AND `t`.`published` = 1 AND t.access IN (1,1,5)
Время запроса: 0.40 ms После последнего запроса: 3.09 msПамять запроса: 0.022 MB Память до запроса: 11.289 MBВыбрано строк: 0
SELECT `m`.`tag_id`,`t`.* FROM `x8jlo_contentitem_tag_map` AS m
INNERJOIN `x8jlo_tags` AS t ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 983 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` = 983 AND `t`.`published` = 1 AND t.access IN (1,1,5)
Время запроса: 0.79 ms После последнего запроса: 0.93 msПамять запроса: 0.022 MB Память до запроса: 11.330 MBВыбрано строк: 0
SELECT `m`.`tag_id`,`t`.* FROM `x8jlo_contentitem_tag_map` AS m
INNERJOIN `x8jlo_tags` AS t ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 982 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` = 982 AND `t`.`published` = 1 AND t.access IN (1,1,5)
Время запроса: 0.67 ms После последнего запроса: 0.90 msПамять запроса: 0.022 MB Память до запроса: 11.370 MBВыбрано строк: 0
SELECT `m`.`tag_id`,`t`.* FROM `x8jlo_contentitem_tag_map` AS m
INNERJOIN `x8jlo_tags` AS t ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 981 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` = 981 AND `t`.`published` = 1 AND t.access IN (1,1,5)
Время запроса: 0.37 ms После последнего запроса: 0.89 msПамять запроса: 0.022 MB Память до запроса: 11.411 MBВыбрано строк: 0
SELECT `m`.`tag_id`,`t`.* FROM `x8jlo_contentitem_tag_map` AS m
INNERJOIN `x8jlo_tags` AS t ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 980 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` = 980 AND `t`.`published` = 1 AND t.access IN (1,1,5)
Время запроса: 0.40 ms После последнего запроса: 0.87 msПамять запроса: 0.022 MB Память до запроса: 11.451 MBВыбрано строк: 0
SELECT `m`.`tag_id`,`t`.* FROM `x8jlo_contentitem_tag_map` AS m
INNERJOIN `x8jlo_tags` AS t ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 979 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` = 979 AND `t`.`published` = 1 AND t.access IN (1,1,5)
Время запроса: 2.92 ms После последнего запроса: 0.87 msПамять запроса: 0.022 MB Память до запроса: 11.491 MBВыбрано строк: 0
SELECT `m`.`tag_id`,`t`.* FROM `x8jlo_contentitem_tag_map` AS m
INNERJOIN `x8jlo_tags` AS t ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 978 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` = 978 AND `t`.`published` = 1 AND t.access IN (1,1,5)
Время запроса: 0.39 ms После последнего запроса: 0.89 msПамять запроса: 0.022 MB Память до запроса: 11.532 MBВыбрано строк: 0
SELECT `m`.`tag_id`,`t`.* FROM `x8jlo_contentitem_tag_map` AS m
INNERJOIN `x8jlo_tags` AS t ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 977 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` = 977 AND `t`.`published` = 1 AND t.access IN (1,1,5)
Время запроса: 0.65 ms После последнего запроса: 0.87 msПамять запроса: 0.023 MB Память до запроса: 11.573 MBВыбрано строк: 0
SELECT `m`.`tag_id`,`t`.* FROM `x8jlo_contentitem_tag_map` AS m
INNERJOIN `x8jlo_tags` AS t ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 976 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` = 976 AND `t`.`published` = 1 AND t.access IN (1,1,5)
Время запроса: 0.36 ms После последнего запроса: 0.81 msПамять запроса: 0.022 MB Память до запроса: 11.614 MBВыбрано строк: 0
SELECT `m`.`tag_id`,`t`.* FROM `x8jlo_contentitem_tag_map` AS m
INNERJOIN `x8jlo_tags` AS t ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 974 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` = 974 AND `t`.`published` = 1 AND t.access IN (1,1,5)
Время запроса: 0.36 ms После последнего запроса: 0.76 msПамять запроса: 0.022 MB Память до запроса: 11.654 MBВыбрано строк: 0
SELECT `m`.`tag_id`,`t`.* FROM `x8jlo_contentitem_tag_map` AS m
INNERJOIN `x8jlo_tags` AS t ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 973 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` = 973 AND `t`.`published` = 1 AND t.access IN (1,1,5)
Время запроса: 0.40 ms После последнего запроса: 0.78 msПамять запроса: 0.022 MB Память до запроса: 11.695 MBВыбрано строк: 0
SELECT `m`.`tag_id`,`t`.* FROM `x8jlo_contentitem_tag_map` AS m
INNERJOIN `x8jlo_tags` AS t ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 972 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` = 972 AND `t`.`published` = 1 AND t.access IN (1,1,5)
Время запроса: 3.80 ms После последнего запроса: 0.83 msПамять запроса: 0.022 MB Память до запроса: 11.735 MBВыбрано строк: 0
SELECT `m`.`tag_id`,`t`.* FROM `x8jlo_contentitem_tag_map` AS m
INNERJOIN `x8jlo_tags` AS t ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 971 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` = 971 AND `t`.`published` = 1 AND t.access IN (1,1,5)
Время запроса: 0.39 ms После последнего запроса: 1.23 msПамять запроса: 0.022 MB Память до запроса: 11.776 MBВыбрано строк: 0
SELECT `m`.`tag_id`,`t`.* FROM `x8jlo_contentitem_tag_map` AS m
INNERJOIN `x8jlo_tags` AS t ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 970 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` = 970 AND `t`.`published` = 1 AND t.access IN (1,1,5)
Время запроса: 16.62 ms После последнего запроса: 2.82 msПамять запроса: 0.024 MB Память до запроса: 11.915 MBВыбрано строк: 1
SELECTCOUNT(*)
FROMx8jlo_contentAS a
LEFTJOINx8jlo_content_frontpageAS fp ON fp.content_id = a.id
LEFTJOINx8jlo_categoriesAS c ON c.id = a.catid
LEFTJOINx8jlo_usersAS ua ON ua.id = a.created_by
LEFTJOINx8jlo_usersAS uam ON uam.id = a.modified_by
LEFTJOINx8jlo_categories as parent ON parent.id = c.parent_id
LEFTJOINx8jlo_content_ratingAS v ON a.id = v.content_id
LEFT OUTERJOIN (SELECT cat.id as id FROMx8jlo_categoriesAS cat JOINx8jlo_categoriesAS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUPBY cat.id ) AS badcats ON badcats.id = c.id
WHERE a.access IN (1,1,5) AND c.access IN (1,1,5) AND CASEWHEN badcats.id is null THEN a.state ELSE 0 END= 1 AND (a.catid = 20 OR a.catid IN (
SELECT sub.id
FROMx8jlo_categories as sub
INNERJOINx8jlo_categories as this ON sub.lft > this.lft AND sub.rgt < this.rgt
WHERE this.id = 20)) AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-19 13:50:56') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-19 13:50:56')
EXPLAIN не доступен для запроса: SELECT COUNT(*)
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 = 20 OR a.catid IN (
SELECT sub.id
FROM x8jlo_categories as sub
INNER JOIN x8jlo_categories as this ON sub.lft > this.lft AND sub.rgt < this.rgt
WHERE this.id = 20)) AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-19 13:50:56') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-19 13:50:56')
Время запроса: 0.43 ms После последнего запроса: 0.73 msПамять запроса: 0.019 MB Память до запроса: 11.924 MBВыбрано строк: 0
SELECT `m`.`tag_id`,`t`.* FROM `x8jlo_contentitem_tag_map` AS m
INNERJOIN `x8jlo_tags` AS t ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.category' AND `m`.`content_item_id` = 20 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.category' AND `m`.`content_item_id` = 20 AND `t`.`published` = 1 AND t.access IN (1,1,5)
Время запроса: 2.74 ms После последнего запроса: 0.69 msПамять запроса: 0.028 MB Память до запроса: 13.705 MBВыбрано строк: 5
SELECT b.rules
FROMx8jlo_assetsAS a
LEFTJOINx8jlo_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'com_content.article.991')
GROUPBY b.id, b.rules, b.lft
ORDERBY 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.article.991')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
Время запроса: 5.40 ms После последнего запроса: 3.21 msПамять запроса: 0.029 MB Память до запроса: 13.873 MBВыбрано строк: 2
SELECT b.rules
FROMx8jlo_assetsAS a
LEFTJOINx8jlo_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'com_attachments')
GROUPBY b.id, b.rules, b.lft
ORDERBY 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_attachments')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
Время запроса: 1.17 ms После последнего запроса: 0.17 msПамять запроса: 0.029 MB Память до запроса: 14.315 MBВыбрано строк: 1
SELECT b.rules
FROMx8jlo_assetsAS a
LEFTJOINx8jlo_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.id = 1)
GROUPBY b.id, b.rules, b.lft
ORDERBY 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.id = 1)
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
Время запроса: 5.12 ms После последнего запроса: 0.22 msПамять запроса: 0.025 MB Память до запроса: 14.347 MBВыбрано строк: 0
SELECT a.*, u.name as creator_name
FROMx8jlo_attachmentsAS a
LEFTJOINx8jlo_usersAS u ON u.id = a.created_by
WHERE a.parent_id=991 AND a.state = 1 AND a.parent_type='com_content' AND a.parent_entity='article' AND a.access IN (1,5)
ORDERBY modified DESC
EXPLAIN не доступен для запроса: SELECT a.*, u.name as creator_name
FROM x8jlo_attachments AS a
LEFT JOIN x8jlo_users AS u ON u.id = a.created_by
WHERE a.parent_id=991 AND a.state = 1 AND a.parent_type='com_content' AND a.parent_entity='article' AND a.access IN (1,5)
ORDER BY modified DESC
Время запроса: 2.07 ms После последнего запроса: 0.30 msПамять запроса: 0.028 MB Память до запроса: 14.427 MBВыбрано строк: 5
SELECT b.rules
FROMx8jlo_assetsAS a
LEFTJOINx8jlo_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'com_content.article.989')
GROUPBY b.id, b.rules, b.lft
ORDERBY 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.article.989')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
Время запроса: 1.73 ms После последнего запроса: 0.95 msПамять запроса: 0.025 MB Память до запроса: 14.470 MBВыбрано строк: 1
SELECT a.*, u.name as creator_name
FROMx8jlo_attachmentsAS a
LEFTJOINx8jlo_usersAS u ON u.id = a.created_by
WHERE a.parent_id=989 AND a.state = 1 AND a.parent_type='com_content' AND a.parent_entity='article' AND a.access IN (1,5)
ORDERBY modified DESC
EXPLAIN не доступен для запроса: SELECT a.*, u.name as creator_name
FROM x8jlo_attachments AS a
LEFT JOIN x8jlo_users AS u ON u.id = a.created_by
WHERE a.parent_id=989 AND a.state = 1 AND a.parent_type='com_content' AND a.parent_entity='article' AND a.access IN (1,5)
ORDER BY modified DESC
Время запроса: 0.24 ms После последнего запроса: 0.22 msПамять запроса: 0.030 MB Память до запроса: 14.508 MBВыбрано строк: 0
SELECT b.rules
FROMx8jlo_assetsAS a
LEFTJOINx8jlo_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'edit')
GROUPBY b.id, b.rules, b.lft
ORDERBY 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 = 'edit')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
Время запроса: 6.84 ms После последнего запроса: 0.63 msПамять запроса: 0.028 MB Память до запроса: 14.754 MBВыбрано строк: 5
SELECT b.rules
FROMx8jlo_assetsAS a
LEFTJOINx8jlo_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'com_content.article.988')
GROUPBY b.id, b.rules, b.lft
ORDERBY 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.article.988')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
Время запроса: 3.82 ms После последнего запроса: 1.46 msПамять запроса: 0.025 MB Память до запроса: 14.797 MBВыбрано строк: 0
SELECT a.*, u.name as creator_name
FROMx8jlo_attachmentsAS a
LEFTJOINx8jlo_usersAS u ON u.id = a.created_by
WHERE a.parent_id=988 AND a.state = 1 AND a.parent_type='com_content' AND a.parent_entity='article' AND a.access IN (1,5)
ORDERBY modified DESC
EXPLAIN не доступен для запроса: SELECT a.*, u.name as creator_name
FROM x8jlo_attachments AS a
LEFT JOIN x8jlo_users AS u ON u.id = a.created_by
WHERE a.parent_id=988 AND a.state = 1 AND a.parent_type='com_content' AND a.parent_entity='article' AND a.access IN (1,5)
ORDER BY modified DESC
Время запроса: 2.67 ms После последнего запроса: 0.36 msПамять запроса: 0.028 MB Память до запроса: 14.860 MBВыбрано строк: 5
SELECT b.rules
FROMx8jlo_assetsAS a
LEFTJOINx8jlo_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'com_content.article.987')
GROUPBY b.id, b.rules, b.lft
ORDERBY 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.article.987')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
Время запроса: 1.90 ms После последнего запроса: 1.50 msПамять запроса: 0.025 MB Память до запроса: 14.903 MBВыбрано строк: 0
SELECT a.*, u.name as creator_name
FROMx8jlo_attachmentsAS a
LEFTJOINx8jlo_usersAS u ON u.id = a.created_by
WHERE a.parent_id=987 AND a.state = 1 AND a.parent_type='com_content' AND a.parent_entity='article' AND a.access IN (1,5)
ORDERBY modified DESC
EXPLAIN не доступен для запроса: SELECT a.*, u.name as creator_name
FROM x8jlo_attachments AS a
LEFT JOIN x8jlo_users AS u ON u.id = a.created_by
WHERE a.parent_id=987 AND a.state = 1 AND a.parent_type='com_content' AND a.parent_entity='article' AND a.access IN (1,5)
ORDER BY modified DESC
Время запроса: 4.63 ms После последнего запроса: 0.29 msПамять запроса: 0.028 MB Память до запроса: 14.976 MBВыбрано строк: 5
SELECT b.rules
FROMx8jlo_assetsAS a
LEFTJOINx8jlo_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'com_content.article.986')
GROUPBY b.id, b.rules, b.lft
ORDERBY 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.article.986')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
Время запроса: 1.81 ms После последнего запроса: 1.33 msПамять запроса: 0.025 MB Память до запроса: 15.018 MBВыбрано строк: 0
SELECT a.*, u.name as creator_name
FROMx8jlo_attachmentsAS a
LEFTJOINx8jlo_usersAS u ON u.id = a.created_by
WHERE a.parent_id=986 AND a.state = 1 AND a.parent_type='com_content' AND a.parent_entity='article' AND a.access IN (1,5)
ORDERBY modified DESC
EXPLAIN не доступен для запроса: SELECT a.*, u.name as creator_name
FROM x8jlo_attachments AS a
LEFT JOIN x8jlo_users AS u ON u.id = a.created_by
WHERE a.parent_id=986 AND a.state = 1 AND a.parent_type='com_content' AND a.parent_entity='article' AND a.access IN (1,5)
ORDER BY modified DESC
Время запроса: 2.45 ms После последнего запроса: 0.30 msПамять запроса: 0.028 MB Память до запроса: 15.087 MBВыбрано строк: 5
SELECT b.rules
FROMx8jlo_assetsAS a
LEFTJOINx8jlo_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'com_content.article.985')
GROUPBY b.id, b.rules, b.lft
ORDERBY 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.article.985')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
Время запроса: 1.75 ms После последнего запроса: 4.09 msПамять запроса: 0.025 MB Память до запроса: 15.130 MBВыбрано строк: 0
SELECT a.*, u.name as creator_name
FROMx8jlo_attachmentsAS a
LEFTJOINx8jlo_usersAS u ON u.id = a.created_by
WHERE a.parent_id=985 AND a.state = 1 AND a.parent_type='com_content' AND a.parent_entity='article' AND a.access IN (1,5)
ORDERBY modified DESC
EXPLAIN не доступен для запроса: SELECT a.*, u.name as creator_name
FROM x8jlo_attachments AS a
LEFT JOIN x8jlo_users AS u ON u.id = a.created_by
WHERE a.parent_id=985 AND a.state = 1 AND a.parent_type='com_content' AND a.parent_entity='article' AND a.access IN (1,5)
ORDER BY modified DESC
Время запроса: 2.26 ms После последнего запроса: 0.35 msПамять запроса: 0.028 MB Память до запроса: 15.193 MBВыбрано строк: 5
SELECT b.rules
FROMx8jlo_assetsAS a
LEFTJOINx8jlo_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'com_content.article.984')
GROUPBY b.id, b.rules, b.lft
ORDERBY 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.article.984')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
Время запроса: 3.63 ms После последнего запроса: 1.05 msПамять запроса: 0.025 MB Память до запроса: 15.236 MBВыбрано строк: 0
SELECT a.*, u.name as creator_name
FROMx8jlo_attachmentsAS a
LEFTJOINx8jlo_usersAS u ON u.id = a.created_by
WHERE a.parent_id=984 AND a.state = 1 AND a.parent_type='com_content' AND a.parent_entity='article' AND a.access IN (1,5)
ORDERBY modified DESC
EXPLAIN не доступен для запроса: SELECT a.*, u.name as creator_name
FROM x8jlo_attachments AS a
LEFT JOIN x8jlo_users AS u ON u.id = a.created_by
WHERE a.parent_id=984 AND a.state = 1 AND a.parent_type='com_content' AND a.parent_entity='article' AND a.access IN (1,5)
ORDER BY modified DESC
Время запроса: 2.51 ms После последнего запроса: 0.33 msПамять запроса: 0.028 MB Память до запроса: 15.302 MBВыбрано строк: 5
SELECT b.rules
FROMx8jlo_assetsAS a
LEFTJOINx8jlo_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'com_content.article.983')
GROUPBY b.id, b.rules, b.lft
ORDERBY 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.article.983')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
Время запроса: 2.58 ms После последнего запроса: 1.02 msПамять запроса: 0.025 MB Память до запроса: 15.344 MBВыбрано строк: 0
SELECT a.*, u.name as creator_name
FROMx8jlo_attachmentsAS a
LEFTJOINx8jlo_usersAS u ON u.id = a.created_by
WHERE a.parent_id=983 AND a.state = 1 AND a.parent_type='com_content' AND a.parent_entity='article' AND a.access IN (1,5)
ORDERBY modified DESC
EXPLAIN не доступен для запроса: SELECT a.*, u.name as creator_name
FROM x8jlo_attachments AS a
LEFT JOIN x8jlo_users AS u ON u.id = a.created_by
WHERE a.parent_id=983 AND a.state = 1 AND a.parent_type='com_content' AND a.parent_entity='article' AND a.access IN (1,5)
ORDER BY modified DESC
Время запроса: 2.58 ms После последнего запроса: 0.32 msПамять запроса: 0.028 MB Память до запроса: 15.419 MBВыбрано строк: 5
SELECT b.rules
FROMx8jlo_assetsAS a
LEFTJOINx8jlo_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'com_content.article.982')
GROUPBY b.id, b.rules, b.lft
ORDERBY 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.article.982')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
Время запроса: 1.91 ms После последнего запроса: 1.37 msПамять запроса: 0.025 MB Память до запроса: 15.461 MBВыбрано строк: 0
SELECT a.*, u.name as creator_name
FROMx8jlo_attachmentsAS a
LEFTJOINx8jlo_usersAS u ON u.id = a.created_by
WHERE a.parent_id=982 AND a.state = 1 AND a.parent_type='com_content' AND a.parent_entity='article' AND a.access IN (1,5)
ORDERBY modified DESC
EXPLAIN не доступен для запроса: SELECT a.*, u.name as creator_name
FROM x8jlo_attachments AS a
LEFT JOIN x8jlo_users AS u ON u.id = a.created_by
WHERE a.parent_id=982 AND a.state = 1 AND a.parent_type='com_content' AND a.parent_entity='article' AND a.access IN (1,5)
ORDER BY modified DESC
Время запроса: 3.46 ms После последнего запроса: 0.42 msПамять запроса: 0.028 MB Память до запроса: 15.526 MBВыбрано строк: 5
SELECT b.rules
FROMx8jlo_assetsAS a
LEFTJOINx8jlo_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'com_content.article.981')
GROUPBY b.id, b.rules, b.lft
ORDERBY 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.article.981')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
Время запроса: 2.00 ms После последнего запроса: 3.65 msПамять запроса: 0.025 MB Память до запроса: 15.568 MBВыбрано строк: 0
SELECT a.*, u.name as creator_name
FROMx8jlo_attachmentsAS a
LEFTJOINx8jlo_usersAS u ON u.id = a.created_by
WHERE a.parent_id=981 AND a.state = 1 AND a.parent_type='com_content' AND a.parent_entity='article' AND a.access IN (1,5)
ORDERBY modified DESC
EXPLAIN не доступен для запроса: SELECT a.*, u.name as creator_name
FROM x8jlo_attachments AS a
LEFT JOIN x8jlo_users AS u ON u.id = a.created_by
WHERE a.parent_id=981 AND a.state = 1 AND a.parent_type='com_content' AND a.parent_entity='article' AND a.access IN (1,5)
ORDER BY modified DESC
Время запроса: 5.16 ms После последнего запроса: 0.34 msПамять запроса: 0.028 MB Память до запроса: 15.648 MBВыбрано строк: 5
SELECT b.rules
FROMx8jlo_assetsAS a
LEFTJOINx8jlo_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'com_content.article.980')
GROUPBY b.id, b.rules, b.lft
ORDERBY 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.article.980')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
Время запроса: 1.83 ms После последнего запроса: 1.16 msПамять запроса: 0.025 MB Память до запроса: 15.753 MBВыбрано строк: 0
SELECT a.*, u.name as creator_name
FROMx8jlo_attachmentsAS a
LEFTJOINx8jlo_usersAS u ON u.id = a.created_by
WHERE a.parent_id=980 AND a.state = 1 AND a.parent_type='com_content' AND a.parent_entity='article' AND a.access IN (1,5)
ORDERBY modified DESC
EXPLAIN не доступен для запроса: SELECT a.*, u.name as creator_name
FROM x8jlo_attachments AS a
LEFT JOIN x8jlo_users AS u ON u.id = a.created_by
WHERE a.parent_id=980 AND a.state = 1 AND a.parent_type='com_content' AND a.parent_entity='article' AND a.access IN (1,5)
ORDER BY modified DESC
Время запроса: 1.92 ms После последнего запроса: 0.27 msПамять запроса: 0.028 MB Память до запроса: 15.833 MBВыбрано строк: 5
SELECT b.rules
FROMx8jlo_assetsAS a
LEFTJOINx8jlo_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'com_content.article.979')
GROUPBY b.id, b.rules, b.lft
ORDERBY 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.article.979')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
Время запроса: 3.08 ms После последнего запроса: 0.97 msПамять запроса: 0.025 MB Память до запроса: 15.875 MBВыбрано строк: 0
SELECT a.*, u.name as creator_name
FROMx8jlo_attachmentsAS a
LEFTJOINx8jlo_usersAS u ON u.id = a.created_by
WHERE a.parent_id=979 AND a.state = 1 AND a.parent_type='com_content' AND a.parent_entity='article' AND a.access IN (1,5)
ORDERBY modified DESC
EXPLAIN не доступен для запроса: SELECT a.*, u.name as creator_name
FROM x8jlo_attachments AS a
LEFT JOIN x8jlo_users AS u ON u.id = a.created_by
WHERE a.parent_id=979 AND a.state = 1 AND a.parent_type='com_content' AND a.parent_entity='article' AND a.access IN (1,5)
ORDER BY modified DESC
Время запроса: 2.06 ms После последнего запроса: 0.28 msПамять запроса: 0.028 MB Память до запроса: 15.955 MBВыбрано строк: 5
SELECT b.rules
FROMx8jlo_assetsAS a
LEFTJOINx8jlo_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'com_content.article.978')
GROUPBY b.id, b.rules, b.lft
ORDERBY 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.article.978')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
Время запроса: 1.80 ms После последнего запроса: 1.01 msПамять запроса: 0.025 MB Память до запроса: 15.997 MBВыбрано строк: 1
SELECT a.*, u.name as creator_name
FROMx8jlo_attachmentsAS a
LEFTJOINx8jlo_usersAS u ON u.id = a.created_by
WHERE a.parent_id=978 AND a.state = 1 AND a.parent_type='com_content' AND a.parent_entity='article' AND a.access IN (1,5)
ORDERBY modified DESC
EXPLAIN не доступен для запроса: SELECT a.*, u.name as creator_name
FROM x8jlo_attachments AS a
LEFT JOIN x8jlo_users AS u ON u.id = a.created_by
WHERE a.parent_id=978 AND a.state = 1 AND a.parent_type='com_content' AND a.parent_entity='article' AND a.access IN (1,5)
ORDER BY modified DESC
Время запроса: 4.50 ms После последнего запроса: 0.32 msПамять запроса: 0.028 MB Память до запроса: 16.136 MBВыбрано строк: 5
SELECT b.rules
FROMx8jlo_assetsAS a
LEFTJOINx8jlo_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'com_content.article.977')
GROUPBY b.id, b.rules, b.lft
ORDERBY 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.article.977')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
Время запроса: 1.95 ms После последнего запроса: 1.60 msПамять запроса: 0.025 MB Память до запроса: 16.179 MBВыбрано строк: 0
SELECT a.*, u.name as creator_name
FROMx8jlo_attachmentsAS a
LEFTJOINx8jlo_usersAS u ON u.id = a.created_by
WHERE a.parent_id=977 AND a.state = 1 AND a.parent_type='com_content' AND a.parent_entity='article' AND a.access IN (1,5)
ORDERBY modified DESC
EXPLAIN не доступен для запроса: SELECT a.*, u.name as creator_name
FROM x8jlo_attachments AS a
LEFT JOIN x8jlo_users AS u ON u.id = a.created_by
WHERE a.parent_id=977 AND a.state = 1 AND a.parent_type='com_content' AND a.parent_entity='article' AND a.access IN (1,5)
ORDER BY modified DESC
Время запроса: 2.17 ms После последнего запроса: 0.28 msПамять запроса: 0.028 MB Память до запроса: 16.222 MBВыбрано строк: 5
SELECT b.rules
FROMx8jlo_assetsAS a
LEFTJOINx8jlo_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'com_content.article.976')
GROUPBY b.id, b.rules, b.lft
ORDERBY 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.article.976')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
Время запроса: 1.74 ms После последнего запроса: 2.47 msПамять запроса: 0.025 MB Память до запроса: 16.265 MBВыбрано строк: 0
SELECT a.*, u.name as creator_name
FROMx8jlo_attachmentsAS a
LEFTJOINx8jlo_usersAS u ON u.id = a.created_by
WHERE a.parent_id=976 AND a.state = 1 AND a.parent_type='com_content' AND a.parent_entity='article' AND a.access IN (1,5)
ORDERBY modified DESC
EXPLAIN не доступен для запроса: SELECT a.*, u.name as creator_name
FROM x8jlo_attachments AS a
LEFT JOIN x8jlo_users AS u ON u.id = a.created_by
WHERE a.parent_id=976 AND a.state = 1 AND a.parent_type='com_content' AND a.parent_entity='article' AND a.access IN (1,5)
ORDER BY modified DESC
Время запроса: 2.24 ms После последнего запроса: 0.38 msПамять запроса: 0.028 MB Память до запроса: 16.344 MBВыбрано строк: 5
SELECT b.rules
FROMx8jlo_assetsAS a
LEFTJOINx8jlo_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'com_content.article.974')
GROUPBY b.id, b.rules, b.lft
ORDERBY 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.article.974')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
Время запроса: 1.82 ms После последнего запроса: 1.11 msПамять запроса: 0.025 MB Память до запроса: 16.387 MBВыбрано строк: 0
SELECT a.*, u.name as creator_name
FROMx8jlo_attachmentsAS a
LEFTJOINx8jlo_usersAS u ON u.id = a.created_by
WHERE a.parent_id=974 AND a.state = 1 AND a.parent_type='com_content' AND a.parent_entity='article' AND a.access IN (1,5)
ORDERBY modified DESC
EXPLAIN не доступен для запроса: SELECT a.*, u.name as creator_name
FROM x8jlo_attachments AS a
LEFT JOIN x8jlo_users AS u ON u.id = a.created_by
WHERE a.parent_id=974 AND a.state = 1 AND a.parent_type='com_content' AND a.parent_entity='article' AND a.access IN (1,5)
ORDER BY modified DESC
Время запроса: 2.33 ms После последнего запроса: 1.85 msПамять запроса: 0.028 MB Память до запроса: 16.466 MBВыбрано строк: 5
SELECT b.rules
FROMx8jlo_assetsAS a
LEFTJOINx8jlo_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'com_content.article.973')
GROUPBY b.id, b.rules, b.lft
ORDERBY 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.article.973')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
Время запроса: 1.66 ms После последнего запроса: 1.32 msПамять запроса: 0.025 MB Память до запроса: 16.508 MBВыбрано строк: 0
SELECT a.*, u.name as creator_name
FROMx8jlo_attachmentsAS a
LEFTJOINx8jlo_usersAS u ON u.id = a.created_by
WHERE a.parent_id=973 AND a.state = 1 AND a.parent_type='com_content' AND a.parent_entity='article' AND a.access IN (1,5)
ORDERBY modified DESC
EXPLAIN не доступен для запроса: SELECT a.*, u.name as creator_name
FROM x8jlo_attachments AS a
LEFT JOIN x8jlo_users AS u ON u.id = a.created_by
WHERE a.parent_id=973 AND a.state = 1 AND a.parent_type='com_content' AND a.parent_entity='article' AND a.access IN (1,5)
ORDER BY modified DESC
Время запроса: 1.93 ms После последнего запроса: 0.26 msПамять запроса: 0.028 MB Память до запроса: 16.594 MBВыбрано строк: 5
SELECT b.rules
FROMx8jlo_assetsAS a
LEFTJOINx8jlo_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'com_content.article.972')
GROUPBY b.id, b.rules, b.lft
ORDERBY 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.article.972')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
Время запроса: 1.54 ms После последнего запроса: 0.77 msПамять запроса: 0.025 MB Память до запроса: 16.636 MBВыбрано строк: 0
SELECT a.*, u.name as creator_name
FROMx8jlo_attachmentsAS a
LEFTJOINx8jlo_usersAS u ON u.id = a.created_by
WHERE a.parent_id=972 AND a.state = 1 AND a.parent_type='com_content' AND a.parent_entity='article' AND a.access IN (1,5)
ORDERBY modified DESC
EXPLAIN не доступен для запроса: SELECT a.*, u.name as creator_name
FROM x8jlo_attachments AS a
LEFT JOIN x8jlo_users AS u ON u.id = a.created_by
WHERE a.parent_id=972 AND a.state = 1 AND a.parent_type='com_content' AND a.parent_entity='article' AND a.access IN (1,5)
ORDER BY modified DESC
Время запроса: 4.97 ms После последнего запроса: 0.29 msПамять запроса: 0.028 MB Память до запроса: 16.679 MBВыбрано строк: 5
SELECT b.rules
FROMx8jlo_assetsAS a
LEFTJOINx8jlo_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'com_content.article.971')
GROUPBY b.id, b.rules, b.lft
ORDERBY 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.article.971')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
Время запроса: 4.67 ms После последнего запроса: 1.12 msПамять запроса: 0.025 MB Память до запроса: 16.722 MBВыбрано строк: 0
SELECT a.*, u.name as creator_name
FROMx8jlo_attachmentsAS a
LEFTJOINx8jlo_usersAS u ON u.id = a.created_by
WHERE a.parent_id=971 AND a.state = 1 AND a.parent_type='com_content' AND a.parent_entity='article' AND a.access IN (1,5)
ORDERBY modified DESC
EXPLAIN не доступен для запроса: SELECT a.*, u.name as creator_name
FROM x8jlo_attachments AS a
LEFT JOIN x8jlo_users AS u ON u.id = a.created_by
WHERE a.parent_id=971 AND a.state = 1 AND a.parent_type='com_content' AND a.parent_entity='article' AND a.access IN (1,5)
ORDER BY modified DESC
Время запроса: 4.14 ms После последнего запроса: 0.63 msПамять запроса: 0.028 MB Память до запроса: 16.802 MBВыбрано строк: 5
SELECT b.rules
FROMx8jlo_assetsAS a
LEFTJOINx8jlo_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'com_content.article.970')
GROUPBY b.id, b.rules, b.lft
ORDERBY 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.article.970')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
Время запроса: 4.11 ms После последнего запроса: 1.15 msПамять запроса: 0.025 MB Память до запроса: 16.845 MBВыбрано строк: 0
SELECT a.*, u.name as creator_name
FROMx8jlo_attachmentsAS a
LEFTJOINx8jlo_usersAS u ON u.id = a.created_by
WHERE a.parent_id=970 AND a.state = 1 AND a.parent_type='com_content' AND a.parent_entity='article' AND a.access IN (1,5)
ORDERBY modified DESC
EXPLAIN не доступен для запроса: SELECT a.*, u.name as creator_name
FROM x8jlo_attachments AS a
LEFT JOIN x8jlo_users AS u ON u.id = a.created_by
WHERE a.parent_id=970 AND a.state = 1 AND a.parent_type='com_content' AND a.parent_entity='article' AND a.access IN (1,5)
ORDER BY modified DESC
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
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=43 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=36 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=40 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
Время запроса: 1.36 ms После последнего запроса: 70.62 msПамять запроса: 0.016 MB Память до запроса: 17.726 MBВыбрано строк: 16
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROMx8jlo_modulesAS m
LEFTJOINx8jlo_modules_menuAS mm ON mm.moduleid = m.id
LEFTJOINx8jlo_extensionsAS 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-04-19 13:50:56') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-19 13:50:56') AND m.access IN (1,1,5) AND m.client_id = 0 AND (mm.menuid = 271 OR mm.menuid <= 0)
ORDERBY 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-04-19 13:50:56') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-19 13:50:56') AND m.access IN (1,1,5) AND m.client_id = 0 AND (mm.menuid = 271 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
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=35 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=44 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=46 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=49 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
Время запроса: 0.83 ms После последнего запроса: 12.80 msПамять запроса: 0.019 MB Память до запроса: 20.049 MBВыбрано строк: 3
SELECT c.cid, c.parent_id, c.name, c.access, c.published, c.hidden, c.owner
FROMx8jlo_joomgallery_catgAS c
WHERE lft > 0 AND c.published = 1 AND c.access IN (1,1,5) AND (c.password = '' OR c.cid IN (0))
ORDERBY 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
Время запроса: 0.72 ms После последнего запроса: 0.16 msПамять запроса: 0.019 MB Память до запроса: 20.076 MBВыбрано строк: 3
SELECT catid, COUNT(id) as piccount, SUM(hits) as hitcount
FROMx8jlo_joomgallery WHERE approved = 1 AND published = 1 AND hidden = 0 AND access IN (1,1,5)
GROUPBY 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
Время запроса: 3.92 ms После последнего запроса: 0.17 msПамять запроса: 0.018 MB Память до запроса: 20.094 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
FROMx8jlo_joomgalleryAS p
LEFTJOINx8jlo_joomgallery_catgAS 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
ORDERBY 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
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
34 типов SQL-запросов зафиксировано, отсортировано по вхождениям
Запросы типа SELECT:
25 × SELECT b.rules FROMx8jlo_assetsAS a LEFTJOINx8jlo_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
21 × SELECT `m`.`tag_id`,`t`.* FROM `x8jlo_contentitem_tag_map` AS m INNERJOIN `x8jlo_tags` AS t ON `m`.`tag_id` = `t`.`id`
20 × SELECT created_by, catid FROMx8jlo_content
20 × SELECT a.*, u.name as creator_name FROMx8jlo_attachmentsAS a LEFTJOINx8jlo_usersAS u ON u.id = a.created_by
8 × 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, CASEWHENCHAR_LENGTH(c.alias) != 0 THENCONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROMx8jlo_categories as c LEFTJOINx8jlo_categoriesAS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFTJOIN (SELECT cat.id as id FROMx8jlo_categoriesAS cat JOINx8jlo_categoriesAS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
2 × SELECT title FROMx8jlo_content
2 × SELECT `manifest_cache` FROM `x8jlo_extensions`
2 × SELECT id FROMx8jlo_content
2 × SELECT catpath FROMx8jlo_joomgallery_catg
1 × SELECT rules FROMx8jlo_assets
1 × SELECT* FROMx8jlo_joomgallery_config
1 × SELECT id FROMx8jlo_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 FROMx8jlo_joomgalleryAS p LEFTJOINx8jlo_joomgallery_catgAS c ON c.cid = p.catid
1 × SELECT catid, COUNT(id) as piccount, SUM(hits) as hitcount FROMx8jlo_joomgallery
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROMx8jlo_modulesAS m LEFTJOINx8jlo_modules_menuAS mm ON mm.moduleid = m.id LEFTJOINx8jlo_extensionsAS e ON e.element = m.module AND e.client_id = m.client_id
1 × SELECTCOUNT(*) FROMx8jlo_contentAS a LEFTJOINx8jlo_content_frontpageAS fp ON fp.content_id = a.id LEFTJOINx8jlo_categoriesAS c ON c.id = a.catid LEFTJOINx8jlo_usersAS ua ON ua.id = a.created_by LEFTJOINx8jlo_usersAS uam ON uam.id = a.modified_by LEFTJOINx8jlo_categories as parent ON parent.id = c.parent_id LEFTJOINx8jlo_content_ratingAS v ON a.id = v.content_id LEFT OUTERJOIN (SELECT cat.id as id FROMx8jlo_categoriesAS cat JOINx8jlo_categoriesAS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
1 × SELECT `value` FROM `x8jlo_admintools_storage`
1 × SELECT* FROM `x8jlo_admintools_wafexceptions`
1 × SELECT id, rules FROM `x8jlo_viewlevels
1 × SELECT b.id FROMx8jlo_usergroupsAS a LEFTJOINx8jlo_usergroupsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
1 × SELECT `session_id` FROM `x8jlo_session`
1 × SELECT `source`,`keepurlparams` FROM `x8jlo_admintools_redirects`
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 FROMx8jlo_menuAS m LEFTJOINx8jlo_extensionsAS e ON m.component_id = e.extension_id
1 × SELECT `data` FROM `x8jlo_session`
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, CASEWHEN 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, CASEWHEN 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, CASEWHEN badcats.id is not null THEN 0 ELSE a.state ENDAS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias, CASEWHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name ENDAS 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, CASEWHEN badcats.id is null THEN c.published ELSE 0 ENDAS parents_published FROMx8jlo_contentAS a LEFTJOINx8jlo_content_frontpageAS fp ON fp.content_id = a.id LEFTJOINx8jlo_categoriesAS c ON c.id = a.catid LEFTJOINx8jlo_usersAS ua ON ua.id = a.created_by LEFTJOINx8jlo_usersAS uam ON uam.id = a.modified_by LEFTJOINx8jlo_categories as parent ON parent.id = c.parent_id LEFTJOINx8jlo_content_ratingAS v ON a.id = v.content_id LEFT OUTERJOIN (SELECT cat.id as id FROMx8jlo_categoriesAS cat JOINx8jlo_categoriesAS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
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, CASEWHENCHAR_LENGTH(c.alias) != 0 THENCONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems FROMx8jlo_categories as c LEFTJOINx8jlo_categoriesAS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFTJOIN (SELECT cat.id as id FROMx8jlo_categoriesAS cat JOINx8jlo_categoriesAS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
1 × SELECT a.rules FROMx8jlo_assetsAS a
1 × SELECT id FROMx8jlo_assets
Прочие SQL-запросы:
1 × SHOWFULLCOLUMNS FROM `x8jlo_joomgallery_config
1 × SHOWFULLCOLUMNS FROM `x8jlo_assets
1 × UPDATE `x8jlo_extensions` SET `params` = '{\"mediaversion\":\"1eea027d5828b3f881992001af4839a4\"}'