Направляемые сообщения не являются обращениями граждан, рассматриваемыми в порядке, установленном Федеральным законом от 2 мая 2006 г. № 59-ФЗ «О порядке рассмотрения обращений граждан Российской Федерации».
EXPLAIN не доступен для запроса: INSERT INTO `x8jlo_session`
(`session_id`, `client_id`, `time`) VALUES
('4dh33mikbdes0g0v79i3sfht87', 0, '1732304249')
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.31 ms После последнего запроса: 0.30 msПамять запроса: 0.015 MB Память до запроса: 6.169 MBВыбрано строк: 0
SELECT `source`,`keepurlparams`
FROM `x8jlo_admintools_redirects`
WHERE ((`dest` = 'o-rajone/allnews.html') OR (`dest` = 'o-rajone/allnews.html?start=700') OR ('o-rajone/allnews.html?start=700' 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=700') OR ('o-rajone/allnews.html?start=700' 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\":\"27a08f3e3e6d9bd2123a1f917ddb4589\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
Время запроса: 1.76 ms После последнего запроса: 1.13 msПамять запроса: 0.025 MB Память до запроса: 9.638 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.03 ms После последнего запроса: 2.64 msПамять запроса: 0.024 MB Память до запроса: 9.779 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
Время запроса: 0.82 ms После последнего запроса: 2.75 msПамять запроса: 0.028 MB Память до запроса: 10.027 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
Время запроса: 26.63 ms После последнего запроса: 0.34 msПамять запроса: 0.023 MB Память до запроса: 10.058 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-11-22 19:37:29') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-22 19:37:29')
ORDERBY a.created DESC , a.created LIMIT 700, 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-11-22 19:37:29') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-22 19:37:29')
ORDER BY a.created DESC , a.created LIMIT 700, 20
Время запроса: 2.93 ms После последнего запроса: 3.87 msПамять запроса: 0.022 MB Память до запроса: 10.877 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` = 1006 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` = 1006 AND `t`.`published` = 1 AND t.access IN (1,1,5)
Время запроса: 0.44 ms После последнего запроса: 0.59 msПамять запроса: 0.022 MB Память до запроса: 10.917 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` = 1004 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` = 1004 AND `t`.`published` = 1 AND t.access IN (1,1,5)
Время запроса: 0.44 ms После последнего запроса: 0.50 msПамять запроса: 0.022 MB Память до запроса: 10.957 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` = 1003 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` = 1003 AND `t`.`published` = 1 AND t.access IN (1,1,5)
Время запроса: 0.36 ms После последнего запроса: 0.50 msПамять запроса: 0.022 MB Память до запроса: 10.998 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` = 1002 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` = 1002 AND `t`.`published` = 1 AND t.access IN (1,1,5)
Время запроса: 0.38 ms После последнего запроса: 0.50 msПамять запроса: 0.022 MB Память до запроса: 11.038 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.33 ms После последнего запроса: 0.51 msПамять запроса: 0.022 MB Память до запроса: 11.079 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.39 ms После последнего запроса: 0.77 msПамять запроса: 0.022 MB Память до запроса: 11.119 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.30 ms После последнего запроса: 0.47 msПамять запроса: 0.022 MB Память до запроса: 11.160 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.32 ms После последнего запроса: 0.49 msПамять запроса: 0.022 MB Память до запроса: 11.200 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.32 ms После последнего запроса: 2.36 msПамять запроса: 0.022 MB Память до запроса: 11.241 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.36 ms После последнего запроса: 0.47 msПамять запроса: 0.022 MB Память до запроса: 11.281 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.60 ms После последнего запроса: 0.48 msПамять запроса: 0.022 MB Память до запроса: 11.321 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.36 ms После последнего запроса: 0.47 msПамять запроса: 0.022 MB Память до запроса: 11.362 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.31 ms После последнего запроса: 0.47 msПамять запроса: 0.023 MB Память до запроса: 11.403 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.31 ms После последнего запроса: 0.50 msПамять запроса: 0.022 MB Память до запроса: 11.444 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.30 ms После последнего запроса: 0.49 msПамять запроса: 0.022 MB Память до запроса: 11.484 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.30 ms После последнего запроса: 0.49 msПамять запроса: 0.022 MB Память до запроса: 11.525 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.32 ms После последнего запроса: 0.44 msПамять запроса: 0.022 MB Память до запроса: 11.565 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.45 msПамять запроса: 0.022 MB Память до запроса: 11.606 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.32 ms После последнего запроса: 2.14 msПамять запроса: 0.022 MB Память до запроса: 11.646 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)
Время запроса: 16.55 ms После последнего запроса: 1.96 msПамять запроса: 0.023 MB Память до запроса: 11.785 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-11-22 19:37:29') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-22 19:37:29')
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-11-22 19:37:29') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-22 19:37:29')
Время запроса: 0.47 ms После последнего запроса: 1.19 msПамять запроса: 0.019 MB Память до запроса: 11.794 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.26 ms После последнего запроса: 0.65 msПамять запроса: 0.028 MB Память до запроса: 13.575 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.1006')
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.1006')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
Время запроса: 1.64 ms После последнего запроса: 3.06 msПамять запроса: 0.029 MB Память до запроса: 13.743 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
Время запроса: 0.73 ms После последнего запроса: 0.18 msПамять запроса: 0.029 MB Память до запроса: 14.185 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.56 ms После последнего запроса: 0.22 msПамять запроса: 0.025 MB Память до запроса: 14.217 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=1006 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=1006 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.43 ms После последнего запроса: 1.14 msПамять запроса: 0.028 MB Память до запроса: 14.261 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.1004')
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.1004')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
Время запроса: 1.87 ms После последнего запроса: 1.00 msПамять запроса: 0.025 MB Память до запроса: 14.304 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=1004 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=1004 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.78 ms После последнего запроса: 0.27 msПамять запроса: 0.028 MB Память до запроса: 14.368 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.1003')
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.1003')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
Время запроса: 3.59 ms После последнего запроса: 0.92 msПамять запроса: 0.025 MB Память до запроса: 14.411 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=1003 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=1003 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.61 ms После последнего запроса: 0.29 msПамять запроса: 0.028 MB Память до запроса: 14.476 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.1002')
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.1002')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
Время запроса: 1.96 ms После последнего запроса: 1.55 msПамять запроса: 0.025 MB Память до запроса: 14.518 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=1002 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=1002 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.11 ms После последнего запроса: 0.29 msПамять запроса: 0.028 MB Память до запроса: 14.583 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.82 ms После последнего запроса: 1.07 msПамять запроса: 0.025 MB Память до запроса: 14.625 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.81 ms После последнего запроса: 0.58 msПамять запроса: 0.028 MB Память до запроса: 14.695 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.81 ms После последнего запроса: 1.02 msПамять запроса: 0.025 MB Память до запроса: 14.737 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
Время запроса: 4.90 ms После последнего запроса: 0.33 msПамять запроса: 0.028 MB Память до запроса: 14.811 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.30 ms После последнего запроса: 1.27 msПамять запроса: 0.025 MB Память до запроса: 14.854 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
Время запроса: 4.83 ms После последнего запроса: 0.31 msПамять запроса: 0.028 MB Память до запроса: 14.922 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.96 ms После последнего запроса: 1.33 msПамять запроса: 0.025 MB Память до запроса: 14.964 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
Время запроса: 2.40 ms После последнего запроса: 0.34 msПамять запроса: 0.028 MB Память до запроса: 15.029 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.99 ms После последнего запроса: 1.06 msПамять запроса: 0.025 MB Память до запроса: 15.071 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
Время запроса: 1.88 ms После последнего запроса: 0.30 msПамять запроса: 0.028 MB Память до запроса: 15.134 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
Время запроса: 2.21 ms После последнего запроса: 2.09 msПамять запроса: 0.025 MB Память до запроса: 15.177 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
Время запроса: 1.84 ms После последнего запроса: 0.30 msПамять запроса: 0.028 MB Память до запроса: 15.240 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
Время запроса: 1.95 ms После последнего запроса: 0.97 msПамять запроса: 0.025 MB Память до запроса: 15.282 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
Время запроса: 1.77 ms После последнего запроса: 0.31 msПамять запроса: 0.028 MB Память до запроса: 15.345 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
Время запроса: 1.99 ms После последнего запроса: 2.44 msПамять запроса: 0.025 MB Память до запроса: 15.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=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.33 ms После последнего запроса: 0.36 msПамять запроса: 0.028 MB Память до запроса: 15.449 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
Время запроса: 2.14 ms После последнего запроса: 1.19 msПамять запроса: 0.025 MB Память до запроса: 15.554 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
Время запроса: 4.67 ms После последнего запроса: 0.31 msПамять запроса: 0.028 MB Память до запроса: 15.618 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
Время запроса: 1.94 ms После последнего запроса: 1.01 msПамять запроса: 0.025 MB Память до запроса: 15.661 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
Время запроса: 5.37 ms После последнего запроса: 0.30 msПамять запроса: 0.028 MB Память до запроса: 15.722 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.49 ms После последнего запроса: 1.38 msПамять запроса: 0.025 MB Память до запроса: 15.765 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.04 ms После последнего запроса: 3.44 msПамять запроса: 0.028 MB Память до запроса: 15.845 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
Время запроса: 2.47 ms После последнего запроса: 1.86 msПамять запроса: 0.025 MB Память до запроса: 15.887 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.30 ms После последнего запроса: 2.39 msПамять запроса: 0.030 MB Память до запроса: 15.924 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
Время запроса: 4.83 ms После последнего запроса: 0.34 msПамять запроса: 0.028 MB Память до запроса: 16.171 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
Время запроса: 2.48 ms После последнего запроса: 1.96 msПамять запроса: 0.025 MB Память до запроса: 16.214 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
Время запроса: 4.42 ms После последнего запроса: 0.30 msПамять запроса: 0.028 MB Память до запроса: 16.277 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.05 ms После последнего запроса: 0.95 msПамять запроса: 0.025 MB Память до запроса: 16.320 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
Время запроса: 1.77 ms После последнего запроса: 0.31 msПамять запроса: 0.028 MB Память до запроса: 16.393 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
Время запроса: 4.68 ms После последнего запроса: 1.56 msПамять запроса: 0.025 MB Память до запроса: 16.435 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.08 ms После последнего запроса: 0.30 msПамять запроса: 0.028 MB Память до запроса: 16.502 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
Время запроса: 2.03 ms После последнего запроса: 1.02 msПамять запроса: 0.025 MB Память до запроса: 16.545 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
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=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=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
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
Время запроса: 1.58 ms После последнего запроса: 132.67 msПамять запроса: 0.016 MB Память до запроса: 17.448 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-11-22 19:37:29') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-11-22 19:37:29') 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-11-22 19:37:29') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-11-22 19:37:29') 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=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.38 ms После последнего запроса: 14.43 msПамять запроса: 0.019 MB Память до запроса: 19.741 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.99 ms После последнего запроса: 0.17 msПамять запроса: 0.020 MB Память до запроса: 19.767 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.49 ms После последнего запроса: 0.18 msПамять запроса: 0.018 MB Память до запроса: 19.786 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
35 типов 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
3 × SELECT catpath FROMx8jlo_joomgallery_catg
2 × SELECT `manifest_cache` FROM `x8jlo_extensions`
1 × SELECT rules FROMx8jlo_assets
1 × SELECT title FROMx8jlo_content
1 × SELECT id FROMx8jlo_content
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_assets
1 × SHOWFULLCOLUMNS FROM `x8jlo_joomgallery_config
1 × UPDATE `x8jlo_extensions` SET `params` = '{\"mediaversion\":\"27a08f3e3e6d9bd2123a1f917ddb4589\"}'
Карта сайта
Республика Дагестан, Лакский район, село Кумух, 
