Направляемые сообщения не являются обращениями граждан, рассматриваемыми в порядке, установленном Федеральным законом от 2 мая 2006 г. № 59-ФЗ «О порядке рассмотрения обращений граждан Российской Федерации».
EXPLAIN не доступен для запроса: INSERT INTO `x8jlo_session`
(`session_id`, `client_id`, `time`) VALUES
('ccakpppdjkr8ubtijiuq8sgu72', 0, '1715783624')
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.43 ms После последнего запроса: 0.33 msПамять запроса: 0.015 MB Память до запроса: 6.160 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\":\"0bb7e85da06d33284b418fe782271cf0\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
Время запроса: 1.69 ms После последнего запроса: 1.11 msПамять запроса: 0.025 MB Память до запроса: 9.641 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.36 ms После последнего запроса: 4.14 msПамять запроса: 0.024 MB Память до запроса: 9.782 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
Время запроса: 1.10 ms После последнего запроса: 6.61 msПамять запроса: 0.028 MB Память до запроса: 10.030 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
Время запроса: 48.06 ms После последнего запроса: 0.35 msПамять запроса: 0.023 MB Память до запроса: 10.061 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-05-15 14:33:45') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-05-15 14:33:45')
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-05-15 14:33:45') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-05-15 14:33:45')
ORDER BY a.created DESC , a.created LIMIT 640, 20
Время запроса: 0.49 ms После последнего запроса: 7.07 msПамять запроса: 0.022 MB Память до запроса: 10.927 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` = 1001 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` = 1001 AND `t`.`published` = 1 AND t.access IN (1,1,5)
Время запроса: 0.39 ms После последнего запроса: 0.90 msПамять запроса: 0.022 MB Память до запроса: 10.967 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` = 1000 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` = 1000 AND `t`.`published` = 1 AND t.access IN (1,1,5)
Время запроса: 0.37 ms После последнего запроса: 0.52 msПамять запроса: 0.022 MB Память до запроса: 11.008 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` = 999 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` = 999 AND `t`.`published` = 1 AND t.access IN (1,1,5)
Время запроса: 0.35 ms После последнего запроса: 0.54 msПамять запроса: 0.022 MB Память до запроса: 11.048 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` = 998 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` = 998 AND `t`.`published` = 1 AND t.access IN (1,1,5)
Время запроса: 0.35 ms После последнего запроса: 0.55 msПамять запроса: 0.022 MB Память до запроса: 11.089 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` = 997 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` = 997 AND `t`.`published` = 1 AND t.access IN (1,1,5)
Время запроса: 0.35 ms После последнего запроса: 0.51 msПамять запроса: 0.022 MB Память до запроса: 11.129 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` = 996 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` = 996 AND `t`.`published` = 1 AND t.access IN (1,1,5)
Время запроса: 0.83 ms После последнего запроса: 0.49 msПамять запроса: 0.022 MB Память до запроса: 11.170 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` = 995 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` = 995 AND `t`.`published` = 1 AND t.access IN (1,1,5)
Время запроса: 0.39 ms После последнего запроса: 1.82 msПамять запроса: 0.022 MB Память до запроса: 11.210 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` = 994 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` = 994 AND `t`.`published` = 1 AND t.access IN (1,1,5)
Время запроса: 0.40 ms После последнего запроса: 1.07 msПамять запроса: 0.022 MB Память до запроса: 11.251 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` = 993 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` = 993 AND `t`.`published` = 1 AND t.access IN (1,1,5)
Время запроса: 0.40 ms После последнего запроса: 0.52 msПамять запроса: 0.022 MB Память до запроса: 11.291 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` = 992 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` = 992 AND `t`.`published` = 1 AND t.access IN (1,1,5)
Время запроса: 0.40 ms После последнего запроса: 0.53 msПамять запроса: 0.022 MB Память до запроса: 11.331 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.65 ms После последнего запроса: 0.52 msПамять запроса: 0.022 MB Память до запроса: 11.372 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.51 msПамять запроса: 0.022 MB Память до запроса: 11.412 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.42 ms После последнего запроса: 0.50 msПамять запроса: 0.022 MB Память до запроса: 11.453 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.42 ms После последнего запроса: 0.50 msПамять запроса: 0.023 MB Память до запроса: 11.494 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)
Время запроса: 1.77 ms После последнего запроса: 0.52 msПамять запроса: 0.022 MB Память до запроса: 11.535 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.96 ms После последнего запроса: 0.52 msПамять запроса: 0.022 MB Память до запроса: 11.575 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.43 ms После последнего запроса: 0.80 msПамять запроса: 0.022 MB Память до запроса: 11.615 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.43 ms После последнего запроса: 0.52 msПамять запроса: 0.022 MB Память до запроса: 11.656 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.35 ms После последнего запроса: 0.51 msПамять запроса: 0.022 MB Память до запроса: 11.696 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)
Время запроса: 17.14 ms После последнего запроса: 1.82 msПамять запроса: 0.023 MB Память до запроса: 11.836 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-05-15 14:33:45') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-05-15 14:33:45')
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-05-15 14:33:45') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-05-15 14:33:45')
Время запроса: 0.74 ms После последнего запроса: 0.73 msПамять запроса: 0.019 MB Память до запроса: 11.844 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)
Время запроса: 5.76 ms После последнего запроса: 0.75 msПамять запроса: 0.028 MB Память до запроса: 13.625 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.1001')
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.1001')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
Время запроса: 3.53 ms После последнего запроса: 3.52 msПамять запроса: 0.029 MB Память до запроса: 13.793 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
Время запроса: 3.03 ms После последнего запроса: 0.18 msПамять запроса: 0.029 MB Память до запроса: 14.235 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
Время запроса: 2.00 ms После последнего запроса: 0.27 msПамять запроса: 0.025 MB Память до запроса: 14.267 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=1001 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=1001 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.97 ms После последнего запроса: 0.37 msПамять запроса: 0.028 MB Память до запроса: 14.337 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.1000')
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.1000')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
Время запроса: 1.95 ms После последнего запроса: 2.80 msПамять запроса: 0.025 MB Память до запроса: 14.380 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=1000 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=1000 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.44 ms После последнего запроса: 0.54 msПамять запроса: 0.028 MB Память до запроса: 14.453 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.999')
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.999')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
Время запроса: 2.66 ms После последнего запроса: 5.28 msПамять запроса: 0.025 MB Память до запроса: 14.496 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=999 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=999 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.25 ms После последнего запроса: 0.31 msПамять запроса: 0.028 MB Память до запроса: 14.563 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.998')
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.998')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
Время запроса: 1.79 ms После последнего запроса: 3.40 msПамять запроса: 0.025 MB Память до запроса: 14.606 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=998 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=998 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.95 ms После последнего запроса: 0.35 msПамять запроса: 0.028 MB Память до запроса: 14.670 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.997')
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.997')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
Время запроса: 1.88 ms После последнего запроса: 1.09 msПамять запроса: 0.025 MB Память до запроса: 14.713 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=997 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=997 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.77 ms После последнего запроса: 0.31 msПамять запроса: 0.028 MB Память до запроса: 14.776 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.996')
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.996')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
Время запроса: 1.84 ms После последнего запроса: 1.02 msПамять запроса: 0.025 MB Память до запроса: 14.818 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=996 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=996 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.14 ms После последнего запроса: 0.32 msПамять запроса: 0.028 MB Память до запроса: 14.881 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.995')
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.995')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
Время запроса: 6.48 ms После последнего запроса: 1.05 msПамять запроса: 0.026 MB Память до запроса: 14.925 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=995 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=995 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.37 ms После последнего запроса: 0.67 msПамять запроса: 0.028 MB Память до запроса: 14.988 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.994')
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.994')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
Время запроса: 6.51 ms После последнего запроса: 1.11 msПамять запроса: 0.025 MB Память до запроса: 15.031 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=994 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=994 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.97 ms После последнего запроса: 0.92 msПамять запроса: 0.028 MB Память до запроса: 15.092 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.993')
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.993')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
Время запроса: 3.28 ms После последнего запроса: 3.28 msПамять запроса: 0.025 MB Память до запроса: 15.135 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=993 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=993 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.81 ms После последнего запроса: 0.29 msПамять запроса: 0.028 MB Память до запроса: 15.199 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.992')
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.992')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
Время запроса: 2.99 ms После последнего запроса: 3.20 msПамять запроса: 0.025 MB Память до запроса: 15.242 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=992 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=992 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.79 ms После последнего запроса: 0.35 msПамять запроса: 0.028 MB Память до запроса: 15.303 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
Время запроса: 3.09 ms После последнего запроса: 3.37 msПамять запроса: 0.025 MB Память до запроса: 15.346 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
Время запроса: 7.87 ms После последнего запроса: 0.64 msПамять запроса: 0.028 MB Память до запроса: 15.426 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
Время запроса: 5.33 ms После последнего запроса: 1.84 msПамять запроса: 0.025 MB Память до запроса: 15.531 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.44 ms После последнего запроса: 0.50 msПамять запроса: 0.030 MB Память до запроса: 15.568 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
Время запроса: 3.32 ms После последнего запроса: 0.66 msПамять запроса: 0.028 MB Память до запроса: 15.815 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.47 ms После последнего запроса: 3.84 msПамять запроса: 0.025 MB Память до запроса: 15.857 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
Время запроса: 3.34 ms После последнего запроса: 0.35 msПамять запроса: 0.028 MB Память до запроса: 15.921 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
Время запроса: 2.07 ms После последнего запроса: 7.73 msПамять запроса: 0.025 MB Память до запроса: 15.963 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
Время запроса: 6.31 ms После последнего запроса: 0.50 msПамять запроса: 0.028 MB Память до запроса: 16.036 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
Время запроса: 2.09 ms После последнего запроса: 2.31 msПамять запроса: 0.025 MB Память до запроса: 16.079 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
Время запроса: 1.97 ms После последнего запроса: 0.40 msПамять запроса: 0.028 MB Память до запроса: 16.146 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.93 ms После последнего запроса: 4.40 msПамять запроса: 0.025 MB Память до запроса: 16.188 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
Время запроса: 1.95 ms После последнего запроса: 0.35 msПамять запроса: 0.028 MB Память до запроса: 16.251 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
Время запроса: 1.93 ms После последнего запроса: 4.54 msПамять запроса: 0.025 MB Память до запроса: 16.294 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.13 ms После последнего запроса: 0.37 msПамять запроса: 0.028 MB Память до запроса: 16.360 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.12 ms После последнего запроса: 5.55 msПамять запроса: 0.025 MB Память до запроса: 16.402 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
Время запроса: 6.12 ms После последнего запроса: 0.38 msПамять запроса: 0.028 MB Память до запроса: 16.477 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
Время запроса: 3.19 ms После последнего запроса: 1.15 msПамять запроса: 0.025 MB Память до запроса: 16.519 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.17 ms После последнего запроса: 0.35 msПамять запроса: 0.028 MB Память до запроса: 16.584 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.71 ms После последнего запроса: 3.42 msПамять запроса: 0.025 MB Память до запроса: 16.626 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
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=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=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=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
Время запроса: 3.27 ms После последнего запроса: 139.95 msПамять запроса: 0.016 MB Память до запроса: 17.506 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-05-15 14:33:45') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-05-15 14:33:45') 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-05-15 14:33:45') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-05-15 14:33:45') 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=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
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.48 ms После последнего запроса: 11.12 msПамять запроса: 0.020 MB Память до запроса: 19.830 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.49 ms После последнего запроса: 0.22 msПамять запроса: 0.019 MB Память до запроса: 19.856 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
Время запроса: 1.30 ms После последнего запроса: 0.18 msПамять запроса: 0.018 MB Память до запроса: 19.874 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 a.*, u.name as creator_name FROMx8jlo_attachmentsAS a LEFTJOINx8jlo_usersAS u ON u.id = a.created_by
20 × SELECT created_by, catid FROMx8jlo_content
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 `manifest_cache` FROM `x8jlo_extensions`
1 × SELECT rules FROMx8jlo_assets
1 × SELECT id FROMx8jlo_content
1 × SELECT title FROMx8jlo_content
1 × SELECT* FROMx8jlo_joomgallery_config
1 × SELECT id FROMx8jlo_menu
1 × SELECT catpath FROMx8jlo_joomgallery_catg
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\":\"0bb7e85da06d33284b418fe782271cf0\"}'
Карта сайта
Республика Дагестан, Лакский район, село Кумух, 
