- 04 Июня 2021
Интерактивная карта отключения горячего водоснабжения
- 23 Июня 2020
Уведомление об отмене поверки бытовых приборов учета
Федеральное агентство по техническому регулированию и метрологии (далее - Госстандарт) информирует, что 6 апреля 2020 года вступило в действие Постановление Правительства Российской Федерации от 2 апреля 2020 г. № 424 «Об особенностях предоставления коммунальных услуг собственникам и пользователям помещений в многоквартирных домах и жилых домов» (далее - Постановление № 424), в том числе регулирующее осуществление поверки бытовых приборов учета в срок до 1 января 2021 года.
Полный текст разъяснения можно скачать по ссылке ниже.
- 10 Января 2019
Изменение сроков заключения прямых договоров!
Уведомление новой редакции об одностороннем отказе от исполнения договоров ресурсоснабжения, в порядке, предусмотренном статьей 157.2 ЖК РФ с УК МУП «СЕЗ- Белоозёрский» и заключения договора о предоставлении коммунальных услуг с собственниками и пользователями многоквартирных домов.
Ранее выложенное уведомление №1229 от 29.12 2018 года считать недействительным.
Ксерокопию НОВОГО! уведомления доступна для скачивания по ссылке ниже.
- 04 Января 2019
Уточнение к Уведомлению от 29.12.2018 года
29.12.2018 года на сайте МУП "Белоозерское ЖКХ" было размещено уведомление в адрес МУП "СЕЗ-Белоозерский" и Главное Управление Московской области "Государственная жилищная инспекция МО", в котором была опечатка в дате заключения прямых договоров, где было указанно 01.02.2018 год, а в действительности следует считать 01.02.2019 год.
Ксерокопия договора доступна для скачивания по ссылке ниже.
- 29 Декабря 2018
Уведомление об односторонним расторжении договоров.
МУП «Белоозерское ЖКХ» в соответствии с п.2 ч.2 ст. 450 ГК РФ, а также ч.2 ст.157.2 ЖК РФ уведомляет об односторонним расторжением договоров с управляющей организацией (МУП «СЕЗ-Белоозерский»)
Ксерокопия договора доступна для скачивания по ссылке ниже.
Остальные новости...
Joomla! Debug Console
Time
Memory
98 Queries Logged 11.8 ms
- Query Time: 0.23 ms
SELECT `data`
FROM `ya01j_session`
WHERE `session_id` = 'm91r6o2gic3ml1hc7k15c91dj2'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ya01j_session NULL const PRIMARY PRIMARY 602 const 1 100.00 NULL No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/joomla/session/storage/database.php:46JROOT/libraries/joomla/session/session.php:658JROOT/libraries/joomla/session/session.php:596JROOT/libraries/cms/application/cms.php:686JROOT/libraries/cms/application/cms.php:140JROOT/libraries/cms/application/site.php:63JROOT/libraries/cms/application/cms.php:341JROOT/libraries/joomla/factory.php:124JROOT/index.php:37 - Query Time: 0.10 ms After last query: 1.14 ms
DELETE
FROM `ya01j_session`
WHERE `time` < '1657070605'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 DELETE ya01j_session NULL range time time 45 const 1 100.00 Using where No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/cms/application/cms.php:703JROOT/libraries/cms/application/cms.php:140JROOT/libraries/cms/application/site.php:63JROOT/libraries/cms/application/cms.php:341JROOT/libraries/joomla/factory.php:124JROOT/index.php:37 - Query Time: 0.08 ms After last query: 0.10 ms
SELECT `session_id`
FROM `ya01j_session`
WHERE `session_id` = 'm91r6o2gic3ml1hc7k15c91dj2'
LIMIT 0, 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ya01j_session NULL const PRIMARY PRIMARY 602 const 1 100.00 Using index No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/cms/application/cms.php:184JROOT/libraries/cms/application/cms.php:712JROOT/libraries/cms/application/cms.php:140JROOT/libraries/cms/application/site.php:63JROOT/libraries/cms/application/cms.php:341JROOT/libraries/joomla/factory.php:124JROOT/index.php:37 - Query Time: 0.10 ms After last query: 0.09 ms
INSERT INTO `ya01j_session` (`session_id`, `client_id`, `time`)
VALUES ('m91r6o2gic3ml1hc7k15c91dj2', 0, '1657071505')EXPLAIN not possible on query: INSERT INTO `ya01j_session` (`session_id`, `client_id`, `time`) VALUES ('m91r6o2gic3ml1hc7k15c91dj2', 0, '1657071505')No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/cms/application/cms.php:216JROOT/libraries/cms/application/cms.php:712JROOT/libraries/cms/application/cms.php:140JROOT/libraries/cms/application/site.php:63JROOT/libraries/cms/application/cms.php:341JROOT/libraries/joomla/factory.php:124JROOT/index.php:37 - Query Time: 0.34 ms After last query: 2.37 ms
SELECT extension_id AS id, element AS "option", params, enabled
FROM ya01j_extensions
WHERE `type` = 'component'
AND `element` = 'com_users'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ya01j_extensions NULL ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 10.00 Using where No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/joomla/cache/controller/callback.php:158JROOT/libraries/cms/component/helper.php:395JROOT/libraries/cms/component/helper.php:43JROOT/libraries/cms/component/helper.php:91JROOT/libraries/cms/application/site.php:539JROOT/libraries/cms/application/site.php:196JROOT/libraries/cms/application/cms.php:264JROOT/index.php:40 - Query Time: 0.28 ms After last query: 0.84 ms
SELECT b.id
FROM ya01j_usergroups AS a
LEFT JOIN ya01j_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE b NULL range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 3 100.00 Using where No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/joomla/access/access.php:336JROOT/libraries/joomla/access/access.php:405JROOT/libraries/joomla/user/user.php:420JROOT/libraries/cms/plugin/helper.php:298JROOT/libraries/cms/plugin/helper.php:165JROOT/libraries/cms/application/site.php:544JROOT/libraries/cms/application/site.php:196JROOT/libraries/cms/application/cms.php:264JROOT/index.php:40 - Query Time: 0.19 ms After last query: 0.43 ms
SELECT id, rules
FROM `ya01j_viewlevels`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ya01j_viewlevels NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 4 100.00 NULL No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/joomla/access/access.php:422JROOT/libraries/joomla/user/user.php:420JROOT/libraries/cms/plugin/helper.php:298JROOT/libraries/cms/plugin/helper.php:165JROOT/libraries/cms/application/site.php:544JROOT/libraries/cms/application/site.php:196JROOT/libraries/cms/application/cms.php:264JROOT/index.php:40 - Query Time: 0.33 ms After last query: 0.14 ms
SELECT folder AS type, element AS name, params
FROM ya01j_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1,5)
ORDER BY orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ya01j_extensions NULL ref extension extension 62 const 68 3.33 Using index condition; Using where; Using filesort No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/cms/plugin/helper.php:312JROOT/libraries/cms/plugin/helper.php:165JROOT/libraries/cms/application/site.php:544JROOT/libraries/cms/application/site.php:196JROOT/libraries/cms/application/cms.php:264JROOT/index.php:40 - Query Time: 0.16 ms After last query: 0.23 ms
SELECT extension_id AS id, element AS "option", params, enabled
FROM ya01j_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ya01j_extensions NULL ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 10.00 Using where No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/joomla/cache/controller/callback.php:158JROOT/libraries/cms/component/helper.php:395JROOT/libraries/cms/component/helper.php:43JROOT/libraries/cms/component/helper.php:91JROOT/libraries/cms/application/site.php:597JROOT/libraries/cms/application/site.php:196JROOT/libraries/cms/application/cms.php:264JROOT/index.php:40 - Query Time: 0.52 ms After last query: 8.78 ms
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 ya01j_menu AS m
LEFT JOIN ya01j_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.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL range idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 5 NULL 11 10.00 Using index condition; Using where; Using filesort 1 SIMPLE e NULL eq_ref PRIMARY PRIMARY 4 bgkhru.m.component_id 1 100.00 Using where No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/cms/menu/site.php:47JROOT/libraries/cms/menu/menu.php:64JROOT/libraries/cms/menu/menu.php:118JROOT/libraries/cms/application/cms.php:366JROOT/libraries/cms/application/site.php:250JROOT/libraries/cms/router/site.php:210JROOT/libraries/cms/router/router.php:391JROOT/libraries/cms/router/router.php:184JROOT/libraries/cms/router/site.php:82JROOT/libraries/cms/application/cms.php:1043JROOT/libraries/cms/application/site.php:727JROOT/libraries/cms/application/site.php:202JROOT/libraries/cms/application/cms.php:264JROOT/index.php:40 - Query Time: 0.29 ms After last query: 4.39 ms
SELECT a.rules
FROM ya01j_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/joomla/access/access.php:250JROOT/libraries/joomla/user/user.php:356JROOT/plugins/system/sourcerer/helper.php:44JROOT/plugins/system/sourcerer/sourcerer.php:94JROOT/libraries/joomla/event/event.php:71JROOT/libraries/joomla/event/dispatcher.php:162JROOT/libraries/joomla/application/base.php:106JROOT/libraries/cms/application/cms.php:1052JROOT/libraries/cms/application/site.php:727JROOT/libraries/cms/application/site.php:202JROOT/libraries/cms/application/cms.php:264JROOT/index.php:40 - Query Time: 0.32 ms After last query: 0.43 ms
SELECT b.rules
FROM ya01j_assets AS a
LEFT JOIN ya01j_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.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY PRIMARY 4 const 1 100.00 Using temporary; Using filesort 1 SIMPLE b NULL range idx_lft_rgt idx_lft_rgt 4 NULL 2 100.00 Using where No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/joomla/access/access.php:250JROOT/libraries/joomla/access/access.php:110JROOT/libraries/joomla/user/user.php:365JROOT/plugins/system/sourcerer/helper.php:44JROOT/plugins/system/sourcerer/sourcerer.php:94JROOT/libraries/joomla/event/event.php:71JROOT/libraries/joomla/event/dispatcher.php:162JROOT/libraries/joomla/application/base.php:106JROOT/libraries/cms/application/cms.php:1052JROOT/libraries/cms/application/site.php:727JROOT/libraries/cms/application/site.php:202JROOT/libraries/cms/application/cms.php:264JROOT/index.php:40 - Query Time: 0.25 ms After last query: 0.44 ms
SELECT extension_id AS id, element AS "option", params, enabled
FROM ya01j_extensions
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ya01j_extensions NULL ref element_clientid,element_folder_clientid,extension extension 364 const,const 1 100.00 NULL No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/joomla/cache/controller/callback.php:158JROOT/libraries/cms/library/helper.php:156JROOT/libraries/cms/library/helper.php:47JROOT/libraries/cms/library/helper.php:90JROOT/libraries/cms/version/version.php:179JROOT/libraries/joomla/factory.php:734JROOT/libraries/joomla/factory.php:215JROOT/plugins/system/sef/sef.php:30JROOT/libraries/joomla/event/event.php:71JROOT/libraries/joomla/event/dispatcher.php:162JROOT/libraries/joomla/application/base.php:106JROOT/libraries/cms/application/cms.php:1052JROOT/libraries/cms/application/site.php:727JROOT/libraries/cms/application/site.php:202JROOT/libraries/cms/application/cms.php:264JROOT/index.php:40 - Query Time: 0.31 ms After last query: 0.19 ms
UPDATE `ya01j_extensions`
SET `params` = '{\"mediaversion\":\"f7f8b3426c5ece6e2db57f4386b9cd1f\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE ya01j_extensions NULL range element_clientid,element_folder_clientid,extension extension 364 const,const 1 100.00 Using where No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/cms/library/helper.php:119JROOT/libraries/cms/version/version.php:230JROOT/libraries/cms/version/version.php:189JROOT/libraries/joomla/factory.php:734JROOT/libraries/joomla/factory.php:215JROOT/plugins/system/sef/sef.php:30JROOT/libraries/joomla/event/event.php:71JROOT/libraries/joomla/event/dispatcher.php:162JROOT/libraries/joomla/application/base.php:106JROOT/libraries/cms/application/cms.php:1052JROOT/libraries/cms/application/site.php:727JROOT/libraries/cms/application/site.php:202JROOT/libraries/cms/application/cms.php:264JROOT/index.php:40 - Query Time: 0.20 ms After last query: 1.80 ms
SELECT extension_id AS id, element AS "option", params, enabled
FROM ya01j_extensions
WHERE `type` = 'component'
AND `element` = 'com_content'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ya01j_extensions NULL ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 10.00 Using where No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/joomla/cache/controller/callback.php:158JROOT/libraries/cms/component/helper.php:395JROOT/libraries/cms/component/helper.php:43JROOT/libraries/cms/component/helper.php:91JROOT/components/com_content/router.php:26JROOT/libraries/cms/router/site.php:437JROOT/libraries/cms/router/site.php:395JROOT/libraries/cms/router/router.php:216JROOT/libraries/cms/router/site.php:98JROOT/libraries/joomla/application/route.php:62JROOT/plugins/system/sef/sef.php:49JROOT/libraries/joomla/event/event.php:71JROOT/libraries/joomla/event/dispatcher.php:162JROOT/libraries/joomla/application/base.php:106JROOT/libraries/cms/application/cms.php:1052JROOT/libraries/cms/application/site.php:727JROOT/libraries/cms/application/site.php:202JROOT/libraries/cms/application/cms.php:264JROOT/index.php:40 - Query Time: 0.21 ms After last query: 0.69 ms
SELECT *
FROM ya01j_languages
WHERE published=1
ORDER BY ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ya01j_languages NULL system NULL NO INDEX KEY COULD BE USED NULL NULL 1 100.00 NULL No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/joomla/language/helper.php:166JROOT/libraries/cms/application/site.php:306JROOT/libraries/cms/application/site.php:122JROOT/libraries/cms/application/site.php:208JROOT/libraries/cms/application/cms.php:264JROOT/index.php:40 - Query Time: 0.31 ms After last query: 0.35 ms
SELECT id, home, template, s.params
FROM ya01j_template_styles as s
LEFT JOIN ya01j_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL ALL idx_template NO INDEX KEY COULD BE USED NULL NULL 3 33.33 Using where 1 SIMPLE e NULL ref element_clientid,element_folder_clientid,extension element_clientid 303 bgkhru.s.template,const 1 5.00 Using index condition; Using where No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/cms/application/site.php:455JROOT/libraries/cms/application/site.php:152JROOT/libraries/cms/application/site.php:208JROOT/libraries/cms/application/cms.php:264JROOT/index.php:40 - Query Time: 0.29 ms After last query: 7.90 ms
SELECT b.rules
FROM ya01j_assets AS a
LEFT JOIN ya01j_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.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const idx_asset_name idx_asset_name 152 const 1 100.00 Using temporary; Using filesort 1 SIMPLE b NULL range idx_lft_rgt idx_lft_rgt 4 NULL 12 100.00 Using where No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/joomla/access/access.php:250JROOT/libraries/joomla/access/access.php:110JROOT/libraries/joomla/user/user.php:365JROOT/components/com_content/models/articles.php:107JROOT/components/com_content/models/featured.php:39JROOT/libraries/legacy/model/legacy.php:415JROOT/libraries/legacy/view/legacy.php:398JROOT/components/com_content/views/featured/view.html.php:46JROOT/libraries/legacy/controller/legacy.php:685JROOT/components/com_content/controller.php:79JROOT/libraries/legacy/controller/legacy.php:722JROOT/components/com_content/content.php:17JROOT/libraries/cms/component/helper.php:351JROOT/libraries/cms/component/helper.php:331JROOT/libraries/cms/application/site.php:178JROOT/libraries/cms/application/site.php:208JROOT/libraries/cms/application/cms.php:264JROOT/index.php:40 - Query Time: 2.06 ms After last query: 0.69 ms
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, 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,( SELECT MAX(contact.id) AS id
FROM ya01j_contact_details AS contact
WHERE contact.published = 1
AND contact.user_id = a.created_by) as contactid,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 ya01j_content AS a
LEFT JOIN ya01j_categories AS c
ON c.id = a.catid
LEFT JOIN ya01j_users AS ua
ON ua.id = a.created_by
LEFT JOIN ya01j_users AS uam
ON uam.id = a.modified_by
LEFT JOIN ya01j_categories as parent
ON parent.id = c.parent_id
LEFT JOIN ya01j_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM ya01j_categories AS cat JOIN ya01j_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
INNER JOIN ya01j_content_frontpage AS fp
ON fp.content_id = a.id
WHERE
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-07-06 01:38:25')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-07-06 01:38:25')
ORDER BY c.lft,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created DESC
LIMIT 0, 9id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY v NULL system PRIMARY NO INDEX KEY COULD BE USED NULL NULL 0 0.00 const row not found 1 PRIMARY fp NULL index PRIMARY PRIMARY 4 NULL 33 100.00 Using index; Using temporary; Using filesort 1 PRIMARY a NULL eq_ref PRIMARY PRIMARY 4 bgkhru.fp.content_id 1 16.00 Using index condition; Using where 1 PRIMARY c NULL eq_ref PRIMARY PRIMARY 4 bgkhru.a.catid 1 100.00 Using where 1 PRIMARY ua NULL eq_ref PRIMARY PRIMARY 4 bgkhru.a.created_by 1 100.00 Using where 1 PRIMARY uam NULL eq_ref PRIMARY PRIMARY 4 bgkhru.a.modified_by 1 100.00 Using where 1 PRIMARY parent NULL eq_ref PRIMARY PRIMARY 4 bgkhru.c.parent_id 1 100.00 Using where 1 PRIMARY <derived3> NULL ref <auto_key0> <auto_key0> 4 bgkhru.c.id 2 100.00 Using where; Using index 3 DERIVED parent NULL range cat_idx,idx_left_right cat_idx 153 NULL 4 100.00 Using index condition; Using temporary; Using filesort 3 DERIVED cat NULL ALL PRIMARY,idx_left_right NO INDEX KEY COULD BE USED NULL NULL 25 11.11 Range checked for each record (index map: 0x21) 2 DEPENDENT SUBQUERY NULL NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL no matching row in const table No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/legacy/model/legacy.php:301JROOT/libraries/legacy/model/list.php:171JROOT/components/com_content/models/articles.php:546JROOT/components/com_content/models/featured.php:84JROOT/libraries/legacy/view/legacy.php:398JROOT/components/com_content/views/featured/view.html.php:47JROOT/libraries/legacy/controller/legacy.php:685JROOT/components/com_content/controller.php:79JROOT/libraries/legacy/controller/legacy.php:722JROOT/components/com_content/content.php:17JROOT/libraries/cms/component/helper.php:351JROOT/libraries/cms/component/helper.php:331JROOT/libraries/cms/application/site.php:178JROOT/libraries/cms/application/site.php:208JROOT/libraries/cms/application/cms.php:264JROOT/index.php:40 - Query Time: 0.21 ms After last query: 1.53 ms
SELECT extension_id AS id, element AS "option", params, enabled
FROM ya01j_extensions
WHERE `type` = 'component'
AND `element` = 'com_tags'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ya01j_extensions NULL ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 10.00 Using where No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/joomla/cache/controller/callback.php:158JROOT/libraries/cms/component/helper.php:395JROOT/libraries/cms/component/helper.php:43JROOT/libraries/cms/component/helper.php:91JROOT/libraries/cms/helper/tags.php:396JROOT/components/com_content/models/articles.php:672JROOT/components/com_content/models/featured.php:84JROOT/libraries/legacy/view/legacy.php:398JROOT/components/com_content/views/featured/view.html.php:47JROOT/libraries/legacy/controller/legacy.php:685JROOT/components/com_content/controller.php:79JROOT/libraries/legacy/controller/legacy.php:722JROOT/components/com_content/content.php:17JROOT/libraries/cms/component/helper.php:351JROOT/libraries/cms/component/helper.php:331JROOT/libraries/cms/application/site.php:178JROOT/libraries/cms/application/site.php:208JROOT/libraries/cms/application/cms.php:264JROOT/index.php:40 - Query Time: 0.34 ms After last query: 0.17 ms
SELECT `m`.`tag_id`,`t`.*
FROM `ya01j_contentitem_tag_map` AS m
INNER JOIN `ya01j_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 101
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL no matching row in const table No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/cms/helper/tags.php:416JROOT/components/com_content/models/articles.php:672JROOT/components/com_content/models/featured.php:84JROOT/libraries/legacy/view/legacy.php:398JROOT/components/com_content/views/featured/view.html.php:47JROOT/libraries/legacy/controller/legacy.php:685JROOT/components/com_content/controller.php:79JROOT/libraries/legacy/controller/legacy.php:722JROOT/components/com_content/content.php:17JROOT/libraries/cms/component/helper.php:351JROOT/libraries/cms/component/helper.php:331JROOT/libraries/cms/application/site.php:178JROOT/libraries/cms/application/site.php:208JROOT/libraries/cms/application/cms.php:264JROOT/index.php:40 - Query Time: 0.12 ms After last query: 0.33 ms
SELECT `m`.`tag_id`,`t`.*
FROM `ya01j_contentitem_tag_map` AS m
INNER JOIN `ya01j_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 100
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL no matching row in const table No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/cms/helper/tags.php:416JROOT/components/com_content/models/articles.php:672JROOT/components/com_content/models/featured.php:84JROOT/libraries/legacy/view/legacy.php:398JROOT/components/com_content/views/featured/view.html.php:47JROOT/libraries/legacy/controller/legacy.php:685JROOT/components/com_content/controller.php:79JROOT/libraries/legacy/controller/legacy.php:722JROOT/components/com_content/content.php:17JROOT/libraries/cms/component/helper.php:351JROOT/libraries/cms/component/helper.php:331JROOT/libraries/cms/application/site.php:178JROOT/libraries/cms/application/site.php:208JROOT/libraries/cms/application/cms.php:264JROOT/index.php:40 - Query Time: 0.14 ms After last query: 0.30 ms
SELECT `m`.`tag_id`,`t`.*
FROM `ya01j_contentitem_tag_map` AS m
INNER JOIN `ya01j_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 91
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL no matching row in const table No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/cms/helper/tags.php:416JROOT/components/com_content/models/articles.php:672JROOT/components/com_content/models/featured.php:84JROOT/libraries/legacy/view/legacy.php:398JROOT/components/com_content/views/featured/view.html.php:47JROOT/libraries/legacy/controller/legacy.php:685JROOT/components/com_content/controller.php:79JROOT/libraries/legacy/controller/legacy.php:722JROOT/components/com_content/content.php:17JROOT/libraries/cms/component/helper.php:351JROOT/libraries/cms/component/helper.php:331JROOT/libraries/cms/application/site.php:178JROOT/libraries/cms/application/site.php:208JROOT/libraries/cms/application/cms.php:264JROOT/index.php:40 - Query Time: 0.11 ms After last query: 0.39 ms
SELECT `m`.`tag_id`,`t`.*
FROM `ya01j_contentitem_tag_map` AS m
INNER JOIN `ya01j_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 89
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL no matching row in const table No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/cms/helper/tags.php:416JROOT/components/com_content/models/articles.php:672JROOT/components/com_content/models/featured.php:84JROOT/libraries/legacy/view/legacy.php:398JROOT/components/com_content/views/featured/view.html.php:47JROOT/libraries/legacy/controller/legacy.php:685JROOT/components/com_content/controller.php:79JROOT/libraries/legacy/controller/legacy.php:722JROOT/components/com_content/content.php:17JROOT/libraries/cms/component/helper.php:351JROOT/libraries/cms/component/helper.php:331JROOT/libraries/cms/application/site.php:178JROOT/libraries/cms/application/site.php:208JROOT/libraries/cms/application/cms.php:264JROOT/index.php:40 - Query Time: 0.12 ms After last query: 0.31 ms
SELECT `m`.`tag_id`,`t`.*
FROM `ya01j_contentitem_tag_map` AS m
INNER JOIN `ya01j_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 88
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL no matching row in const table No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/cms/helper/tags.php:416JROOT/components/com_content/models/articles.php:672JROOT/components/com_content/models/featured.php:84JROOT/libraries/legacy/view/legacy.php:398JROOT/components/com_content/views/featured/view.html.php:47JROOT/libraries/legacy/controller/legacy.php:685JROOT/components/com_content/controller.php:79JROOT/libraries/legacy/controller/legacy.php:722JROOT/components/com_content/content.php:17JROOT/libraries/cms/component/helper.php:351JROOT/libraries/cms/component/helper.php:331JROOT/libraries/cms/application/site.php:178JROOT/libraries/cms/application/site.php:208JROOT/libraries/cms/application/cms.php:264JROOT/index.php:40 - Query Time: 0.10 ms After last query: 0.31 ms
SELECT `m`.`tag_id`,`t`.*
FROM `ya01j_contentitem_tag_map` AS m
INNER JOIN `ya01j_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 57
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL no matching row in const table No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/cms/helper/tags.php:416JROOT/components/com_content/models/articles.php:672JROOT/components/com_content/models/featured.php:84JROOT/libraries/legacy/view/legacy.php:398JROOT/components/com_content/views/featured/view.html.php:47JROOT/libraries/legacy/controller/legacy.php:685JROOT/components/com_content/controller.php:79JROOT/libraries/legacy/controller/legacy.php:722JROOT/components/com_content/content.php:17JROOT/libraries/cms/component/helper.php:351JROOT/libraries/cms/component/helper.php:331JROOT/libraries/cms/application/site.php:178JROOT/libraries/cms/application/site.php:208JROOT/libraries/cms/application/cms.php:264JROOT/index.php:40 - Query Time: 0.11 ms After last query: 0.29 ms
SELECT `m`.`tag_id`,`t`.*
FROM `ya01j_contentitem_tag_map` AS m
INNER JOIN `ya01j_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 53
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL no matching row in const table No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/cms/helper/tags.php:416JROOT/components/com_content/models/articles.php:672JROOT/components/com_content/models/featured.php:84JROOT/libraries/legacy/view/legacy.php:398JROOT/components/com_content/views/featured/view.html.php:47JROOT/libraries/legacy/controller/legacy.php:685JROOT/components/com_content/controller.php:79JROOT/libraries/legacy/controller/legacy.php:722JROOT/components/com_content/content.php:17JROOT/libraries/cms/component/helper.php:351JROOT/libraries/cms/component/helper.php:331JROOT/libraries/cms/application/site.php:178JROOT/libraries/cms/application/site.php:208JROOT/libraries/cms/application/cms.php:264JROOT/index.php:40 - Query Time: 0.12 ms After last query: 0.30 ms
SELECT `m`.`tag_id`,`t`.*
FROM `ya01j_contentitem_tag_map` AS m
INNER JOIN `ya01j_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 52
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL no matching row in const table Status Duration starting 0.0 ms Waiting for query cache lock 0.0 ms Waiting on query cache mutex 0.0 ms starting 0.0 ms checking query cache for query 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms Opening tables 0.0 ms init 0.0 ms System lock 0.0 ms Waiting for query cache lock 0.0 ms Waiting on query cache mutex 0.0 ms System lock 0.0 ms optimizing 0.0 ms statistics 0.0 ms executing 0.0 ms end 0.0 ms query end 0.0 ms closing tables 0.0 ms freeing items 0.0 ms Waiting for query cache lock 0.0 ms Waiting on query cache mutex 0.0 ms freeing items 0.0 ms Waiting for query cache lock 0.0 ms Waiting on query cache mutex 0.0 ms freeing items 0.0 ms storing result in query cache 0.0 ms cleaning up 0.0 ms JROOT/libraries/cms/helper/tags.php:416JROOT/components/com_content/models/articles.php:672JROOT/components/com_content/models/featured.php:84JROOT/libraries/legacy/view/legacy.php:398JROOT/components/com_content/views/featured/view.html.php:47JROOT/libraries/legacy/controller/legacy.php:685JROOT/components/com_content/controller.php:79JROOT/libraries/legacy/controller/legacy.php:722JROOT/components/com_content/content.php:17JROOT/libraries/cms/component/helper.php:351JROOT/libraries/cms/component/helper.php:331JROOT/libraries/cms/application/site.php:178JROOT/libraries/cms/application/site.php:208JROOT/libraries/cms/application/cms.php:264JROOT/index.php:40 - Query Time: 0.12 ms After last query: 0.30 ms
SELECT `m`.`tag_id`,`t`.*
FROM `ya01j_contentitem_tag_map` AS m
INNER JOIN `ya01j_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 50
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL no matching row in const table Status Duration starting 0.0 ms Waiting for query cache lock 0.0 ms Waiting on query cache mutex 0.0 ms starting 0.0 ms checking query cache for query 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms Opening tables 0.0 ms init 0.0 ms System lock 0.0 ms Waiting for query cache lock 0.0 ms Waiting on query cache mutex 0.0 ms System lock 0.0 ms optimizing 0.0 ms statistics 0.0 ms executing 0.0 ms end 0.0 ms query end 0.0 ms closing tables 0.0 ms freeing items 0.0 ms Waiting for query cache lock 0.0 ms Waiting on query cache mutex 0.0 ms freeing items 0.0 ms Waiting for query cache lock 0.0 ms Waiting on query cache mutex 0.0 ms freeing items 0.0 ms storing result in query cache 0.0 ms cleaning up 0.0 ms JROOT/libraries/cms/helper/tags.php:416JROOT/components/com_content/models/articles.php:672JROOT/components/com_content/models/featured.php:84JROOT/libraries/legacy/view/legacy.php:398JROOT/components/com_content/views/featured/view.html.php:47JROOT/libraries/legacy/controller/legacy.php:685JROOT/components/com_content/controller.php:79JROOT/libraries/legacy/controller/legacy.php:722JROOT/components/com_content/content.php:17JROOT/libraries/cms/component/helper.php:351JROOT/libraries/cms/component/helper.php:331JROOT/libraries/cms/application/site.php:178JROOT/libraries/cms/application/site.php:208JROOT/libraries/cms/application/cms.php:264JROOT/index.php:40 - Query Time: 0.59 ms After last query: 1.07 ms
SELECT COUNT(*)
FROM ya01j_content AS a
LEFT JOIN ya01j_categories AS c
ON c.id = a.catid
LEFT JOIN ya01j_users AS ua
ON ua.id = a.created_by
LEFT JOIN ya01j_users AS uam
ON uam.id = a.modified_by
LEFT JOIN ya01j_categories as parent
ON parent.id = c.parent_id
LEFT JOIN ya01j_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM ya01j_categories AS cat JOIN ya01j_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
INNER JOIN ya01j_content_frontpage AS fp
ON fp.content_id = a.id
WHERE
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-07-06 01:38:25')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-07-06 01:38:25')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY v NULL system PRIMARY NO INDEX KEY COULD BE USED NULL NULL 0 0.00 const row not found 1 PRIMARY fp NULL index PRIMARY PRIMARY 4 NULL 33 100.00 Using index 1 PRIMARY a NULL eq_ref PRIMARY PRIMARY 4 bgkhru.fp.content_id 1 16.00 Using index condition; Using where 1 PRIMARY c NULL eq_ref PRIMARY PRIMARY 4 bgkhru.a.catid 1 100.00 Using where 1 PRIMARY ua NULL eq_ref PRIMARY PRIMARY 4 bgkhru.a.created_by 1 100.00 Using where; Using index 1 PRIMARY uam NULL eq_ref PRIMARY PRIMARY 4 bgkhru.a.modified_by 1 100.00 Using where; Using index 1 PRIMARY parent NULL eq_ref PRIMARY PRIMARY 4 bgkhru.c.parent_id 1 100.00 Using where; Using index 1 PRIMARY <derived2> NULL ref <auto_key0> <auto_key0> 4 bgkhru.c.id 2 100.00 Using where; Using index 2 DERIVED parent NULL range cat_idx,idx_left_right cat_idx 153 NULL 4 100.00 Using index condition; Using temporary; Using filesort 2 DERIVED cat NULL ALL PRIMARY,idx_left_right NO INDEX KEY COULD BE USED NULL NULL 25 11.11 Range checked for each record (index map: 0x21) Status Duration starting 0.0 ms Waiting for query cache lock 0.0 ms Waiting on query cache mutex 0.0 ms starting 0.0 ms checking query cache for query 0.1 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms Opening tables 0.0 ms init 0.0 ms System lock 0.0 ms Waiting for query cache lock 0.0 ms Waiting on query cache mutex 0.0 ms System lock 0.0 ms optimizing 0.0 ms optimizing 0.0 ms statistics 0.0 ms preparing 0.0 ms Creating tmp table 0.0 ms Sorting result 0.0 ms statistics 0.0 ms preparing 0.0 ms executing 0.0 ms Sending data 0.0 ms executing 0.0 ms Sending data 0.1 ms Creating sort index 0.1 ms end 0.0 ms query end 0.0 ms removing tmp table 0.0 ms query end 0.0 ms closing tables 0.0 ms removing tmp table 0.0 ms closing tables 0.0 ms freeing items 0.0 ms Waiting for query cache lock 0.0 ms Waiting on query cache mutex 0.0 ms freeing items 0.0 ms Waiting for query cache lock 0.0 ms Waiting on query cache mutex 0.0 ms freeing items 0.0 ms storing result in query cache 0.0 ms cleaning up 0.0 ms JROOT/libraries/legacy/model/legacy.php:327JROOT/libraries/legacy/model/list.php:276JROOT/libraries/legacy/model/list.php:221JROOT/libraries/legacy/view/legacy.php:398JROOT/components/com_content/views/featured/view.html.php:48JROOT/libraries/legacy/controller/legacy.php:685JROOT/components/com_content/controller.php:79JROOT/libraries/legacy/controller/legacy.php:722JROOT/components/com_content/content.php:17JROOT/libraries/cms/component/helper.php:351JROOT/libraries/cms/component/helper.php:331JROOT/libraries/cms/application/site.php:178JROOT/libraries/cms/application/site.php:208JROOT/libraries/cms/application/cms.php:264JROOT/index.php:40 - Query Time: 0.87 ms After last query: 5.50 ms
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 ya01j_categories as c
LEFT JOIN ya01j_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 ya01j_categories AS cat JOIN ya01j_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=15
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.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY s NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 Using temporary; Using filesort 1 PRIMARY c NULL ALL cat_idx,idx_access,idx_left_right NO INDEX KEY COULD BE USED NULL NULL 25 37.77 Using where 1 PRIMARY <derived2> NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 11 10.00 Using where; Not exists; Using join buffer (Block Nested Loop) 2 DERIVED parent NULL range cat_idx,idx_left_right cat_idx 153 NULL 4 100.00 Using index condition; Using temporary; Using filesort 2 DERIVED cat NULL ALL PRIMARY,idx_left_right NO INDEX KEY COULD BE USED NULL NULL 25 11.11 Range checked for each record (index map: 0x21) Status Duration starting 0.0 ms Waiting for query cache lock 0.0 ms Waiting on query cache mutex 0.0 ms starting 0.0 ms checking query cache for query 0.1 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms Opening tables 0.0 ms init 0.1 ms System lock 0.0 ms Waiting for query cache lock 0.0 ms Waiting on query cache mutex 0.0 ms System lock 0.0 ms optimizing 0.0 ms optimizing 0.0 ms statistics 0.0 ms preparing 0.0 ms Creating tmp table 0.0 ms Sorting result 0.0 ms statistics 0.1 ms preparing 0.0 ms Creating tmp table 0.0 ms Sorting result 0.0 ms executing 0.0 ms Sending data 0.0 ms executing 0.0 ms Sending data 0.1 ms Creating sort index 0.2 ms Creating sort index 0.0 ms end 0.0 ms query end 0.0 ms removing tmp table 0.0 ms query end 0.0 ms removing tmp table 0.0 ms query end 0.0 ms closing tables 0.0 ms removing tmp table 0.0 ms closing tables 0.0 ms freeing items 0.0 ms Waiting for query cache lock 0.0 ms Waiting on query cache mutex 0.0 ms freeing items 0.0 ms Waiting for query cache lock 0.0 ms Waiting on query cache mutex 0.0 ms freeing items 0.0 ms storing result in query cache 0.0 ms cleaning up 0.0 ms JROOT/libraries/legacy/categories/categories.php:288JROOT/libraries/legacy/categories/categories.php:181JROOT/components/com_content/helpers/route.php:39JROOT/components/com_content/helpers/icon.php:213JROOT/libraries/cms/html/html.php:238JROOT/libraries/cms/html/html.php:140JROOT/templates/beez3/html/com_content/featured/default_item.php:30JROOT/libraries/legacy/view/legacy.php:663JROOT/templates/beez3/html/com_content/featured/default.php:30JROOT/libraries/legacy/view/legacy.php:663JROOT/libraries/legacy/view/legacy.php:211JROOT/components/com_content/views/featured/view.html.php:148JROOT/libraries/legacy/controller/legacy.php:685JROOT/components/com_content/controller.php:79JROOT/libraries/legacy/controller/legacy.php:722JROOT/components/com_content/content.php:17JROOT/libraries/cms/component/helper.php:351JROOT/libraries/cms/component/helper.php:331JROOT/libraries/cms/application/site.php:178JROOT/libraries/cms/application/site.php:208JROOT/libraries/cms/application/cms.php:264JROOT/index.php:40 - Query Time: 0.51 ms After last query: 10.68 ms
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM ya01j_modules AS m
LEFT JOIN ya01j_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN ya01j_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 <= '2022-07-06 01:38:25')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-07-06 01:38:25')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 106 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL range PRIMARY,published,newsfeeds published 5 NULL 4 3.70 Using index condition; Using where; Using filesort 1 SIMPLE mm NULL ref PRIMARY PRIMARY 4 bgkhru.m.id 1 40.00 Using where; Using index 1 SIMPLE e NULL ref element_clientid,element_folder_clientid element_clientid 303 bgkhru.m.module,const 1 10.00 Using index condition; Using where Status Duration starting 0.0 ms Waiting for query cache lock 0.0 ms Waiting on query cache mutex 0.0 ms starting 0.0 ms checking query cache for query 0.1 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms Opening tables 0.1 ms init 0.0 ms System lock 0.0 ms Waiting for query cache lock 0.0 ms Waiting on query cache mutex 0.0 ms System lock 0.0 ms optimizing 0.0 ms statistics 0.0 ms preparing 0.0 ms Sorting result 0.0 ms executing 0.0 ms Sending data 0.0 ms Creating sort index 0.1 ms end 0.0 ms query end 0.0 ms closing tables 0.0 ms freeing items 0.0 ms Waiting for query cache lock 0.0 ms Waiting on query cache mutex 0.0 ms freeing items 0.0 ms Waiting for query cache lock 0.0 ms Waiting on query cache mutex 0.0 ms freeing items 0.0 ms storing result in query cache 0.1 ms cleaning up 0.0 ms JROOT/libraries/cms/module/helper.php:362JROOT/libraries/cms/module/helper.php:84JROOT/libraries/joomla/document/html/html.php:502JROOT/templates/beez3/index.php:42JROOT/libraries/joomla/document/html/html.php:570JROOT/libraries/joomla/document/html/html.php:628JROOT/libraries/joomla/document/html/html.php:452JROOT/libraries/cms/application/cms.php:999JROOT/libraries/cms/application/site.php:709JROOT/libraries/cms/application/cms.php:270JROOT/index.php:40 - Query Time: 0.39 ms After last query: 2.84 ms
SELECT extension_id AS id, element AS "option", params, enabled
FROM ya01j_extensions
WHERE `type` = 'component'
AND `element` = 'com_weblinks'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ya01j_extensions NULL ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 10.00 Using where Status Duration starting 0.0 ms Waiting for query cache lock 0.0 ms Waiting on query cache mutex 0.0 ms starting 0.0 ms checking query cache for query 0.0 ms checking permissions 0.0 ms Opening tables 0.0 ms init 0.0 ms System lock 0.0 ms Waiting for query cache lock 0.0 ms Waiting on query cache mutex 0.0 ms System lock 0.0 ms optimizing 0.0 ms statistics 0.1 ms preparing 0.0 ms executing 0.0 ms Sending data 0.0 ms end 0.0 ms query end 0.0 ms closing tables 0.0 ms freeing items 0.0 ms Waiting for query cache lock 0.0 ms Waiting on query cache mutex 0.0 ms freeing items 0.1 ms Waiting for query cache lock 0.0 ms Waiting on query cache mutex 0.0 ms freeing items 0.0 ms storing result in query cache 0.0 ms cleaning up 0.0 ms JROOT/libraries/joomla/cache/controller/callback.php:158JROOT/libraries/cms/component/helper.php:395JROOT/libraries/cms/component/helper.php:43JROOT/libraries/cms/component/helper.php:91JROOT/components/com_weblinks/router.php:26JROOT/libraries/cms/router/site.php:437JROOT/libraries/cms/router/site.php:395JROOT/libraries/cms/router/router.php:216JROOT/libraries/cms/router/site.php:98JROOT/libraries/joomla/application/route.php:62JROOT/modules/mod_menu/helper.php:118JROOT/modules/mod_menu/mod_menu.php:15JROOT/libraries/cms/module/helper.php:177JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:690JROOT/libraries/joomla/document/html/html.php:471JROOT/libraries/cms/application/cms.php:1013JROOT/libraries/cms/application/site.php:709JROOT/libraries/cms/application/cms.php:270JROOT/index.php:40 - Query Time: 0.24 ms After last query: 2.33 ms
SELECT *
FROM ya01j_banners
WHERE '2022-07-06 01:38:25' >= 'reset'
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL Impossible WHERE Status Duration starting 0.0 ms Waiting for query cache lock 0.0 ms Waiting on query cache mutex 0.0 ms starting 0.0 ms checking query cache for query 0.0 ms checking permissions 0.0 ms Opening tables 0.1 ms init 0.0 ms System lock 0.0 ms Waiting for query cache lock 0.0 ms Waiting on query cache mutex 0.0 ms System lock 0.0 ms optimizing 0.0 ms executing 0.0 ms end 0.0 ms query end 0.0 ms closing tables 0.0 ms freeing items 0.0 ms Waiting for query cache lock 0.0 ms Waiting on query cache mutex 0.0 ms freeing items 0.0 ms Waiting for query cache lock 0.0 ms Waiting on query cache mutex 0.0 ms freeing items 0.0 ms storing result in query cache 0.0 ms cleaning up 0.0 ms JROOT/administrator/components/com_banners/helpers/banners.php:76JROOT/modules/mod_banners/mod_banners.php:19JROOT/libraries/cms/module/helper.php:177JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:690JROOT/libraries/joomla/document/html/html.php:471JROOT/libraries/cms/application/cms.php:1013JROOT/libraries/cms/application/site.php:709JROOT/libraries/cms/application/cms.php:270JROOT/index.php:40 - Query Time: 0.23 ms After last query: 0.66 ms
SELECT COUNT(*)
FROM ya01j_banners as a
LEFT JOIN ya01j_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.catid IN (31)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL system idx_state,idx_banner_catid NO INDEX KEY COULD BE USED NULL NULL 1 100.00 NULL 1 SIMPLE cl NULL system PRIMARY NO INDEX KEY COULD BE USED NULL NULL 0 0.00 const row not found Status Duration starting 0.0 ms Waiting for query cache lock 0.0 ms Waiting on query cache mutex 0.0 ms starting 0.0 ms checking query cache for query 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms Opening tables 0.1 ms init 0.0 ms System lock 0.0 ms optimizing 0.0 ms statistics 0.0 ms preparing 0.0 ms executing 0.0 ms Sending data 0.0 ms end 0.0 ms query end 0.0 ms closing tables 0.0 ms freeing items 0.0 ms cleaning up 0.0 ms JROOT/libraries/legacy/model/legacy.php:327JROOT/libraries/legacy/model/list.php:276JROOT/libraries/legacy/model/list.php:310JROOT/libraries/legacy/model/list.php:171JROOT/components/com_banners/models/banners.php:185JROOT/modules/mod_banners/helper.php:38JROOT/modules/mod_banners/mod_banners.php:20JROOT/libraries/cms/module/helper.php:177JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:690JROOT/libraries/joomla/document/html/html.php:471JROOT/libraries/cms/application/cms.php:1013JROOT/libraries/cms/application/site.php:709JROOT/libraries/cms/application/cms.php:270JROOT/index.php:40 - Query Time: 0.14 ms After last query: 0.08 ms
SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM ya01j_banners as a
LEFT JOIN ya01j_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.catid IN (31)
ORDER BY a.sticky DESC,a.ordering
LIMIT 0, 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL system idx_state,idx_banner_catid NO INDEX KEY COULD BE USED NULL NULL 1 100.00 NULL 1 SIMPLE cl NULL system PRIMARY NO INDEX KEY COULD BE USED NULL NULL 0 0.00 const row not found Status Duration starting 0.0 ms Waiting for query cache lock 0.0 ms Waiting on query cache mutex 0.0 ms starting 0.0 ms checking query cache for query 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms Opening tables 0.0 ms init 0.0 ms System lock 0.0 ms optimizing 0.0 ms statistics 0.0 ms preparing 0.0 ms executing 0.0 ms Sending data 0.0 ms end 0.0 ms query end 0.0 ms closing tables 0.0 ms freeing items 0.0 ms cleaning up 0.0 ms JROOT/libraries/legacy/model/legacy.php:301JROOT/libraries/legacy/model/list.php:171JROOT/components/com_banners/models/banners.php:185JROOT/modules/mod_banners/helper.php:38JROOT/modules/mod_banners/mod_banners.php:20JROOT/libraries/cms/module/helper.php:177JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:690JROOT/libraries/joomla/document/html/html.php:471JROOT/libraries/cms/application/cms.php:1013JROOT/libraries/cms/application/site.php:709JROOT/libraries/cms/application/cms.php:270JROOT/index.php:40 - Query Time: 0.11 ms After last query: 0.12 ms
UPDATE ya01j_banners
SET impmade = (impmade + 1)
WHERE id = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE ya01j_banners NULL range PRIMARY PRIMARY 4 const 1 100.00 Using where Status Duration starting 0.0 ms checking permissions 0.0 ms Opening tables 0.0 ms init 0.0 ms System lock 0.0 ms updating 0.0 ms end 0.0 ms Waiting for query cache lock 0.0 ms end 0.0 ms query end 0.0 ms closing tables 0.0 ms freeing items 0.0 ms cleaning up 0.0 ms JROOT/components/com_banners/models/banners.php:222JROOT/modules/mod_banners/helper.php:39JROOT/modules/mod_banners/mod_banners.php:20JROOT/libraries/cms/module/helper.php:177JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:690JROOT/libraries/joomla/document/html/html.php:471JROOT/libraries/cms/application/cms.php:1013JROOT/libraries/cms/application/site.php:709JROOT/libraries/cms/application/cms.php:270JROOT/index.php:40 - Query Time: 0.26 ms After last query: 0.08 msDuplicate queries: #39
SELECT `count`
FROM ya01j_banner_tracks
WHERE track_type=1
AND banner_id=1
AND track_date='2022-07-06 01'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ya01j_banner_tracks NULL const PRIMARY,idx_track_date,idx_track_type,idx_banner_id PRIMARY 13 const,const,const 1 100.00 NULL Status Duration starting 0.0 ms Waiting for query cache lock 0.0 ms Waiting on query cache mutex 0.0 ms starting 0.0 ms checking query cache for query 0.0 ms checking permissions 0.0 ms Opening tables 0.2 ms init 0.0 ms System lock 0.0 ms Waiting for query cache lock 0.0 ms Waiting on query cache mutex 0.0 ms System lock 0.0 ms optimizing 0.0 ms statistics 0.0 ms preparing 0.0 ms executing 0.0 ms Sending data 0.0 ms end 0.0 ms query end 0.0 ms closing tables 0.0 ms freeing items 0.0 ms Waiting for query cache lock 0.0 ms Waiting on query cache mutex 0.0 ms freeing items 0.0 ms Waiting for query cache lock 0.0 ms Waiting on query cache mutex 0.0 ms freeing items 0.0 ms storing result in query cache 0.0 ms cleaning up 0.0 ms JROOT/components/com_banners/models/banners.php:256JROOT/modules/mod_banners/helper.php:39JROOT/modules/mod_banners/mod_banners.php:20JROOT/libraries/cms/module/helper.php:177JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:690JROOT/libraries/joomla/document/html/html.php:471JROOT/libraries/cms/application/cms.php:1013JROOT/libraries/cms/application/site.php:709JROOT/libraries/cms/application/cms.php:270JROOT/index.php:40 - Query Time: 0.02 ms After last query: 0.04 msDuplicate queries: #38
SELECT `count`
FROM ya01j_banner_tracks
WHERE track_type=1
AND banner_id=1
AND track_date='2022-07-06 01'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ya01j_banner_tracks NULL const PRIMARY,idx_track_date,idx_track_type,idx_banner_id PRIMARY 13 const,const,const 1 100.00 NULL Status Duration starting 0.0 ms Waiting for query cache lock 0.0 ms Waiting on query cache mutex 0.0 ms starting 0.0 ms checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms sending cached result to clien 0.0 ms cleaning up 0.0 ms JROOT/components/com_banners/models/banners.php:263JROOT/modules/mod_banners/helper.php:39JROOT/modules/mod_banners/mod_banners.php:20JROOT/libraries/cms/module/helper.php:177JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:690JROOT/libraries/joomla/document/html/html.php:471JROOT/libraries/cms/application/cms.php:1013JROOT/libraries/cms/application/site.php:709JROOT/libraries/cms/application/cms.php:270JROOT/index.php:40 - Query Time: 0.11 ms After last query: 0.08 ms
UPDATE ya01j_banner_tracks
SET `count` = ('count' + 1)
WHERE track_type=1
AND banner_id=1
AND track_date='2022-07-06 01'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE ya01j_banner_tracks NULL range PRIMARY,idx_track_date,idx_track_type,idx_banner_id PRIMARY 13 const,const,const 1 100.00 Using where Status Duration starting 0.0 ms checking permissions 0.0 ms Opening tables 0.0 ms init 0.0 ms System lock 0.0 ms updating 0.0 ms end 0.0 ms query end 0.0 ms closing tables 0.0 ms freeing items 0.0 ms cleaning up 0.0 ms JROOT/components/com_banners/models/banners.php:294JROOT/modules/mod_banners/helper.php:39JROOT/modules/mod_banners/mod_banners.php:20JROOT/libraries/cms/module/helper.php:177JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:690JROOT/libraries/joomla/document/html/html.php:471JROOT/libraries/cms/application/cms.php:1013JROOT/libraries/cms/application/site.php:709JROOT/libraries/cms/application/cms.php:270JROOT/index.php:40 - Query Time: 0.27 ms After last query: 12.96 ms
UPDATE `ya01j_session`
SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1657071505;s:18:\"session.timer.last\";i:1657071505;s:17:\"session.timer.now\";i:1657071505;s:24:\"session.client.forwarded\";s:13:\"18.207.133.27\";s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:9;}s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:16:\"com_mailto.links\";a:5:{s:40:\"dffab49f41d060ef6b133a3e5be025ef0d16429a\";O:8:\"stdClass\":2:{s:4:\"link\";s:56:\"http://bgkh.ru/index.php/novosti/101-2021-06-04-06-38-07\";s:6:\"expiry\";i:1657071505;}s:40:\"f235c85110b953da12aa4da64c7df967b3c190cf\";O:8:\"stdClass\":2:{s:4:\"link\";s:91:\"http://bgkh.ru/index.php/novosti/100-uvedomlenie-ob-otmene-poverki-bytovykh-priborov-ucheta\";s:6:\"expiry\";i:1657071505;}s:40:\"bde1ff275bc7e70e9b3bf845ff30096d24a45add\";O:8:\"stdClass\":2:{s:4:\"link\";s:85:\"http://bgkh.ru/index.php/novosti/91-izmenenie-srokov-zaklyucheniya-pryamykh-dogovorov\";s:6:\"expiry\";i:1657071505;}s:40:\"3fecf13cb52dd126e968a53467da2d9c795ce545\";O:8:\"stdClass\":2:{s:4:\"link\";s:80:\"http://bgkh.ru/index.php/novosti/89-utochnenie-k-uvedomleniyu-ot-29-12-2018-goda\";s:6:\"expiry\";i:1657071505;}s:40:\"d35b07c5c67c1e3cb0340707c1ea262aa91fbd03\";O:8:\"stdClass\":2:{s:4:\"link\";s:91:\"http://bgkh.ru/index.php/novosti/88-zhkkh-mozhet-podorozhat-na-15-protsentov-iz-za-musora-2\";s:6:\"expiry\";i:1657071505;}}}' , `time` = '1657071505'
WHERE `session_id` = 'm91r6o2gic3ml1hc7k15c91dj2'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE ya01j_session NULL range PRIMARY PRIMARY 602 const 1 100.00 Using where Status Duration starting 0.1 ms checking permissions 0.0 ms Opening tables 0.1 ms init 0.0 ms System lock 0.0 ms updating 0.0 ms end 0.0 ms Waiting for query cache lock 0.0 ms end 0.0 ms query end 0.0 ms closing tables 0.0 ms freeing items 0.0 ms cleaning up 0.0 ms JROOT/libraries/joomla/session/storage/database.php:85
26 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
9 × SELECT `m`.`tag_id`,`t`.*
FROM `ya01j_contentitem_tag_map` AS m
INNER JOIN `ya01j_tags` AS t
ON `m`.`tag_id` = `t`.`id`6 × SELECT extension_id AS id, element AS "option", params, enabled
FROM ya01j_extensions2 × SELECT b.rules
FROM ya01j_assets AS a
LEFT JOIN ya01j_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt2 × SELECT `count`
FROM ya01j_banner_tracks1 × 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 ya01j_categories as c
LEFT JOIN ya01j_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 ya01j_categories AS cat JOIN ya01j_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt1 × SELECT COUNT(*)
FROM ya01j_content AS a
LEFT JOIN ya01j_categories AS c
ON c.id = a.catid
LEFT JOIN ya01j_users AS ua
ON ua.id = a.created_by
LEFT JOIN ya01j_users AS uam
ON uam.id = a.modified_by
LEFT JOIN ya01j_categories as parent
ON parent.id = c.parent_id
LEFT JOIN ya01j_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM ya01j_categories AS cat JOIN ya01j_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt1 × SELECT *
FROM ya01j_banners1 × SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM ya01j_banners as a
LEFT JOIN ya01j_banner_clients AS cl
ON cl.id = a.cid1 × SELECT COUNT(*)
FROM ya01j_banners as a
LEFT JOIN ya01j_banner_clients AS cl
ON cl.id = a.cid1 × 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, 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,( SELECT MAX(contact.id) AS id
FROM ya01j_contact_details AS contact1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM ya01j_modules AS m
LEFT JOIN ya01j_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN ya01j_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT *
FROM ya01j_languages1 × SELECT id, rules
FROM `ya01j_viewlevels1 × SELECT b.id
FROM ya01j_usergroups AS a
LEFT JOIN ya01j_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT `session_id`
FROM `ya01j_session`1 × SELECT folder AS type, element AS name, params
FROM ya01j_extensions1 × 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 ya01j_menu AS m
LEFT JOIN ya01j_extensions AS e
ON m.component_id = e.extension_id1 × SELECT `data`
FROM `ya01j_session`1 × SELECT a.rules
FROM ya01j_assets AS a1 × SELECT id, home, template, s.params
FROM ya01j_template_styles as s
LEFT JOIN ya01j_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
OTHER Tables:
1 × UPDATE ya01j_banner_tracks
SET `count` = ('count' + 1)1 × UPDATE `ya01j_session`
SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1657071505;s:18:\"session.timer.last\";i:1657071505;s:17:\"session.timer.now\";i:1657071505;s:24:\"session.client.forwarded\";s:13:\"18.207.133.27\";s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:9;}s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:16:\"com_mailto.links\";a:5:{s:40:\"dffab49f41d060ef6b133a3e5be025ef0d16429a\";O:8:\"stdClass\":2:{s:4:\"link\";s:56:\"http://bgkh.ru/index.php/novosti/101-2021-06-04-06-38-07\";s:6:\"expiry\";i:1657071505;}s:40:\"f235c85110b953da12aa4da64c7df967b3c190cf\";O:8:\"stdClass\":2:{s:4:\"link\";s:91:\"http://bgkh.ru/index.php/novosti/100-uvedomlenie-ob-otmene-poverki-bytovykh-priborov-ucheta\";s:6:\"expiry\";i:1657071505;}s:40:\"bde1ff275bc7e70e9b3bf845ff30096d24a45add\";O:8:\"stdClass\":2:{s:4:\"link\";s:85:\"http://bgkh.ru/index.php/novosti/91-izmenenie-srokov-zaklyucheniya-pryamykh-dogovorov\";s:6:\"expiry\";i:1657071505;}s:40:\"3fecf13cb52dd126e968a53467da2d9c795ce545\";O:8:\"stdClass\":2:{s:4:\"link\";s:80:\"http://bgkh.ru/index.php/novosti/89-utochnenie-k-uvedomleniyu-ot-29-12-2018-goda\";s:6:\"expiry\";i:1657071505;}s:40:\"d35b07c5c67c1e3cb0340707c1ea262aa91fbd03\";O:8:\"stdClass\":2:{s:4:\"link\";s:91:\"http://bgkh.ru/index.php/novosti/88-zhkkh-mozhet-podorozhat-na-15-protsentov-iz-za-musora-2\";s:6:\"expiry\";i:1657071505;}}}' , `time` = '1657071505'1 × UPDATE ya01j_banners
SET impmade = (impmade + 1)1 × UPDATE `ya01j_extensions`
SET `params` = '{\"mediaversion\":\"f7f8b3426c5ece6e2db57f4386b9cd1f\"}'1 × INSERT INTO `ya01j_session` (`session_id`, `client_id`, `time`)
VALUES ('m91r6o2gic3ml1hc7k15c91dj2', 0, '1657071505'1 × DELETE
FROM `ya01j_session`