На нашем сайте работает виртуальная приемная.
Вы можете получить консультации по вопросам социальной защиты.
Подробнее...
10.02.2018 года, свой 90 летний юбилей отметила Шалимова Екатерина Емельяновна - труженик тыла, ветеран труда. По доброй традиции, поздравить именинника с юбилее мприехали представители управления социальной защиты населения администрации Междуреченского городского округа. Юбиляру были вручены персональные поздравления с 90-летием от имени Губернатора Кемеровской области А.Г. Тулеева и главы Междуреченского городского округа С.А. Кислицина.
02.02.2018 года исполнилось 75 лет со дня разгрома Советскими войсками немецко-фашистских войск в Сталинградской битве.
На сегодняшний день в Междуреченском городском округе проживает четыре вдовы участников ВОВ, принимавших участие в Сталинградской битве.
01 февраля 2018г. заместитель главы Междуреченского городского округа по социальным вопросам Ирина Витальевна Вантеева и начальник управления социальной защиты населения администрации Междуреченского городского округа Светлана Николаевна Ченцова поздравили вдов участников ВОВна дому. Вручили денежную премию, поздравительную открытку от Губернатора Кемеровской области А.Г. Тулеева и букет цветов от главы Междуреченского городского округа.
02.02.2018г в 10.00 ч. состоялось возложение цветов к памятнику войнов – кузбассовцев, павшихза Родину в Великой Отечественной войне.Участие в мероприятии приняли представители администрации Междуреченского городского округа, Совета народных депутатов Междуреченского городского округа, Городского Совета ветеранов, а также представители учреждений спорта, культуры, образования, социальной защиты.
Информация по поздравлению юбиляра с 90 -летием.
26.01.2018 года, в день празднования юбилея Кемеровской области, свой 90 летний юбилей отметила Морева Анастасия Васильевна - ветеран труда и просто замечательный человек. По доброй традиции, поздравить именинника с юбилеем приехал начальник управления социальной защиты населения администрации Междуреченского городского округа С.Н. Ченцова. Юбиляру была вручена денежная премия, а также персональные поздравления с 90-летием от имени Губернатора Кемеровской области А.Г. Тулеева и главы Междуреченского городского округа.
«С 1 января 2018г. в России вступил в силу Федеральный закон от 28.12.2017 г. № 418-ФЗ « О ежемесячных выплатах семьям, имеющих детей».
Закон предусматривает, что поддержку получат семьи, у которых первый и второй ребенок рожден с 1 января 2018 года. Оба пособия касаются не только родных, но и усыновленных детей. Усыновленные дети также должны быть рождены с 1 января 2018 года.
Пособия предоставляются гражданам Российской Федерации, зарегистрированным по месту жительства на территории Российской Федерации.
Расчет среднедушевого дохода рассчитывается исходя из суммы доходов членов семьи за последние 12 календарных месяцев (до вычета подоходного налога) предшествующих месяцу подачи заявления.
Размер указанных пособий установлен в размере регионального прожиточного минимума ребенка за второй квартал предыдущего года. В Кемеровской области, размер выплат в 2018 году составит 9857 руб. в месяц, при этом право на данную выплату будут иметь семьи, среднедушевой доход которых не превышает 1,5-кратную величину прожиточногоминимума трудоспособного населения (сумму 14971,5 руб. на 1 члена семьи).
За пособием на первого ребенка родителям нужно обратиться в управление социальной защиты населения по месту регистрации, за пособием на второго ребенка - в органы Пенсионного фонда, одновременно с заявлением на материнский (семейный) капитал.
По всем вопросам обращаться в Управление социальной защиты населения кабинет № 203, контактный телефон – 4-29-45.
ПЕРЕЧЕНЬ
документов, представляемых для назначения и выплаты ежемесячных выплат в связи с рождением(усыновлением) первого ребенка с 01.01.2018 г.
Закон № 418-ФЗ от 28.12.2017 г.
- Паспорт гражданина РФ или документ, заменяющий паспорт (копия и оригинал);
- Свидетельство о рождении ребенка (усыновлении) (копия и оригинал);
- Документы, подтверждающие принадлежность к гражданству РФ заявителя и ребенка;
- Выписка из решения органа опеки и попечительства об установлении над ребенком опеки;
- Свидетельство о заключении брака (копия и оригинал);
- Свидетельство о расторжении брака, если члены семьи находятся в разводе (копия и оригинал);
- Сведения о доходах семьи за предшествующие 12 месяцев:
- заработная плата (справка с места работы по форме 2-НДФЛ);
- пенсия (справка с Пенсионного фонда, ул.Пушкина, 150);
- алименты ;
- регресс (справка из фонда социального страхования, ул. Юности, 10);
- стипендия (справка с места учебы);
- пособие по безработице (для неработающих граждан справка с центра занятости, ул. Чехова, 2);
- другие доходы семьи;
- Документ, подтверждающий реквизиты счета в кредитной организации;
- пенсионное страховое свидетельство (СНИЛС) на имя заявителя.
Государственные выплаты
семьям, имеющим детей, назначаемые и выплачиваемые
в отделе по назначению и выплате детского пособия
Вид пособия |
Размер пособия на ребенка (руб.) |
|
в 2017г. |
в 2018 г. |
|
Ежемесячное пособие на детей от 0 до 16-18 лет (Закон Кемеровской области № 75-ОЗ от 18.11.2004г.) |
290 |
310 |
Ежемесячное пособие на детей одиноких матерей |
520 |
560 |
Ежемесячное пособие на детей военнослужащих по призыву |
405 |
435 |
Ежемесячное пособие на детей, родители которых уклоняются от уплаты алиментов |
405 |
435 |
Ежемесячное пособие детям-инвалидам в полных семьях |
460 |
500 |
Ежемесячное пособие детям-инвалидам одиноких матерей |
660 |
720 |
Ежемесячное пособие детям из неполных семей |
520 |
560 |
Ежемесячное пособие детям-инвалидам из неполных семей |
660 |
720 |
Единовременное пособие при рождении ребенка (Федеральный Закон № 81-ФЗ от 19.05.1995г.) |
21255,43 с 01.02.2017г. |
21786,82 с 01.02.2018г. |
Ежемесячное пособие по уходу за ребенком до полутора лет не работающим и обучающимся на очной форме обучения гражданам: на 1-го ребенка (№ 81-ФЗ от 19.05.1995г.) |
3985,40 с 01.02.2017г. |
4085,03 с 01.02.2018г. |
Ежемесячное пособие по уходу за ребенком до полутора лет не работающим и обучающимся на очной форме обучения гражданам: на 2-го ребенка и последующих детей (№ 81-ФЗ от 19.05.1995г.) |
7970,78 с 01.02.2017г. |
8170,05 с 01.02.2018г. |
Единовременное пособие беременной жене военнослужащего, проходящего военную службу по призыву (№ 81-ФЗ от 19.05.1995г.) |
33660,19 с 01.02.2017г. |
34501,69 с 01.02.2018г. |
Ежемесячное пособие на ребенка военнослужащего, проходящего военную службу по призыву (№ 81-ФЗ от 19.05.1995г.) |
14425,79 с 01.02.2017г. |
14786,43 с 01.02.2018г. |
Ежемесячная денежная выплата, в случае рождения третьего ребенка или последующих детей до достижения ребенком трех лет (Закон КО № 73-ОЗ) |
9135,00 с 01.01.2017г. |
9306,00 с 01.01.2018г. |
Ежемесячная выплата семьям, имеющих детей (Закон № 418-ФЗ от 28.12.2017г.) |
|
9857,00 с 01.01.2018г. |
Звонок осуществляется круглосуточно, бесплатно и анонимно со стационарного или мобильного телефона.
К детским проблем здесь относятся со взрослым пониманием.
номер телефона, по которому из любой точки нашей страны можно получить консультацию по вопросам социальной защиты.
Кемеровская область
г. Междуреченск
ул. Космонавтов, 17
Тел.: +7 (38 475) 2-93-73
Факс: +7 (38 475) 2-93-73
e-mail: Этот адрес электронной почты защищён от спам-ботов. У вас должен быть включен JavaScript для просмотра.
{ "__default": { "session": { "counter": 1, "timer": { "start": 1550400180, "last": 1550400180, "now": 1550400180 }, "token": "mh4T2pAh1pUee7GS5NswvDq4NaZTLfYg" }, "registry": {}, "user": { "id": 0, "name": null, "username": null, "email": null, "password": null, "password_clear": "", "block": null, "sendEmail": 0, "registerDate": null, "lastvisitDate": null, "activation": null, "params": null, "groups": [], "guest": 1, "lastResetTime": null, "resetCount": null, "requireReset": null, "aid": 0 } } }
SELECT `data`
FROM `so_session`
WHERE `session_id` = 'm5b8qit9k0c4bi2losjiaoag9r'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | so_session | NULL | const | PRIMARY | PRIMARY | 766 | const | 1 | 100.00 | NULL |
Status | Duration |
---|---|
starting | 0.11 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
init | 0.04 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.09 ms |
executing | 0.02 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.05 ms |
cleaning up | 0.02 ms |
# | Caller | File and line number |
---|---|---|
16 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1730 |
15 | JDatabaseDriver->loadResult() | JROOT\libraries\joomla\session\storage\database.php:45 |
14 | JSessionStorageDatabase->read() | Same as call in the line below. |
13 | session_start() | JROOT\libraries\joomla\session\handler\native.php:260 |
12 | JSessionHandlerNative->doSessionStart() | JROOT\libraries\joomla\session\handler\native.php:50 |
11 | JSessionHandlerNative->start() | JROOT\libraries\joomla\session\handler\joomla.php:88 |
10 | JSessionHandlerJoomla->start() | JROOT\libraries\src\Session\Session.php:660 |
9 | Joomla\CMS\Session\Session->_start() | JROOT\libraries\src\Session\Session.php:620 |
8 | Joomla\CMS\Session\Session->start() | JROOT\libraries\src\Session\Session.php:498 |
7 | Joomla\CMS\Session\Session->get() | JROOT\libraries\src\Session\Session.php:455 |
6 | Joomla\CMS\Session\Session->isNew() | JROOT\libraries\src\Application\CMSApplication.php:854 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT\libraries\src\Application\CMSApplication.php:133 |
4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT\libraries\src\Application\SiteApplication.php:66 |
3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT\libraries\src\Application\CMSApplication.php:451 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT\libraries\src\Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT\index.php:46 |
SELECT `session_id`
FROM `so_session`
WHERE `session_id` = 'm5b8qit9k0c4bi2losjiaoag9r'
LIMIT 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | so_session | NULL | const | PRIMARY | PRIMARY | 766 | const | 1 | 100.00 | Using index |
Status | Duration |
---|---|
starting | 0.07 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.06 ms |
executing | 0.01 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.04 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|---|---|
8 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1730 |
7 | JDatabaseDriver->loadResult() | JROOT\libraries\src\Application\CMSApplication.php:214 |
6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT\libraries\src\Application\CMSApplication.php:856 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT\libraries\src\Application\CMSApplication.php:133 |
4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT\libraries\src\Application\SiteApplication.php:66 |
3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT\libraries\src\Application\CMSApplication.php:451 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT\libraries\src\Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT\index.php:46 |
INSERT INTO `so_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('m5b8qit9k0c4bi2losjiaoag9r', 1, '1550400180', 0, '', 0)
Status | Duration |
---|---|
starting | 0.07 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.02 ms |
System lock | 0.01 ms |
update | 0.14 ms |
end | 0.01 ms |
query end | 23.65 ms |
closing tables | 0.01 ms |
freeing items | 11.42 ms |
cleaning up | 0.03 ms |
# | Caller | File and line number |
---|---|---|
7 | JDatabaseDriverMysqli->execute() | JROOT\libraries\src\Application\CMSApplication.php:254 |
6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT\libraries\src\Application\CMSApplication.php:856 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT\libraries\src\Application\CMSApplication.php:133 |
4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT\libraries\src\Application\SiteApplication.php:66 |
3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT\libraries\src\Application\CMSApplication.php:451 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT\libraries\src\Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT\index.php:46 |
SELECT id, rules
FROM `so_viewlevels`
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | so_viewlevels | NULL | ALL | NULL | Индекс не используется | NULL | NULL | 3 | 100.00 | NULL |
Status | Duration |
---|---|
starting | 0.06 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.00 ms |
statistics | 0.02 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.07 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.26 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|---|---|
10 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1496 |
9 | JDatabaseDriver->loadAssocList() | JROOT\libraries\src\Access\Access.php:1063 |
8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT\libraries\src\User\User.php:458 |
7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT\libraries\src\Plugin\PluginHelper.php:310 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT\libraries\src\Plugin\PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT\libraries\src\Plugin\PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT\libraries\src\Application\SiteApplication.php:606 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT\libraries\src\Application\SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT\libraries\src\Application\CMSApplication.php:303 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:50 |
SELECT b.id
FROM so_usergroups AS a
LEFT JOIN so_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
id | 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 | 1 | 100.00 | Using where; Using index |
Status | Duration |
---|---|
starting | 0.05 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.10 ms |
preparing | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.03 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 32.42 ms |
cleaning up | 0.03 ms |
# | Caller | File and line number |
---|---|---|
11 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1540 |
10 | JDatabaseDriver->loadColumn() | JROOT\libraries\src\Access\Access.php:980 |
9 | Joomla\CMS\Access\Access::getGroupsByUser() | JROOT\libraries\src\Access\Access.php:1095 |
8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT\libraries\src\User\User.php:458 |
7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT\libraries\src\Plugin\PluginHelper.php:310 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT\libraries\src\Plugin\PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT\libraries\src\Plugin\PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT\libraries\src\Application\SiteApplication.php:606 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT\libraries\src\Application\SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT\libraries\src\Application\CMSApplication.php:303 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:50 |
UPDATE `so_extensions`
SET `params` = '{\"mediaversion\":\"69f6ac38823f4ed2be9dc3ceb887d8ac\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | UPDATE | so_extensions | NULL | range | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | Using where |
Status | Duration |
---|---|
starting | 0.10 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.03 ms |
System lock | 0.13 ms |
updating | 0.11 ms |
end | 0.01 ms |
query end | 20.12 ms |
closing tables | 0.02 ms |
freeing items | 0.05 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|---|---|
14 | JDatabaseDriverMysqli->execute() | JROOT\libraries\src\Helper\LibraryHelper.php:117 |
13 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT\libraries\src\Version.php:372 |
12 | Joomla\CMS\Version->setMediaVersion() | JROOT\libraries\src\Version.php:331 |
11 | Joomla\CMS\Version->getMediaVersion() | JROOT\libraries\src\Factory.php:778 |
10 | Joomla\CMS\Factory::createDocument() | JROOT\libraries\src\Factory.php:234 |
9 | Joomla\CMS\Factory::getDocument() | JROOT\plugins\system\jcktypography\jcktypography.php:48 |
8 | plgSystemJCKtypography->onAfterRoute() | JROOT\libraries\joomla\event\event.php:70 |
7 | JEvent->update() | JROOT\libraries\joomla\event\dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT\libraries\src\Application\BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT\libraries\src\Application\CMSApplication.php:1179 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT\libraries\src\Application\SiteApplication.php:798 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT\libraries\src\Application\SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT\libraries\src\Application\CMSApplication.php:303 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:50 |
SELECT params
FROM so_extensions
WHERE folder ='editors'
AND element ='jckeditor'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | so_extensions | NULL | ref | element_clientid,element_folder_clientid | element_clientid | 402 | const | 1 | 10.00 | Using where |
Status | Duration |
---|---|
starting | 0.07 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.10 ms |
preparing | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.25 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|---|---|
10 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1730 |
9 | JDatabaseDriver->loadResult() | JROOT\plugins\system\jcktypography\jcktypography.php:61 |
8 | plgSystemJCKtypography->onAfterRoute() | JROOT\libraries\joomla\event\event.php:70 |
7 | JEvent->update() | JROOT\libraries\joomla\event\dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT\libraries\src\Application\BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT\libraries\src\Application\CMSApplication.php:1179 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT\libraries\src\Application\SiteApplication.php:798 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT\libraries\src\Application\SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT\libraries\src\Application\CMSApplication.php:303 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:50 |
SELECT `id`,`name`,`rules`,`parent_id`
FROM `so_assets`
WHERE `name` IN ('root.1','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_faqftw','com_fields','com_finder','com_foxcontact','com_installer','com_jckman','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_mijopolls','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_sigpro','com_tags','com_templates','com_users','com_weblinks','com_wrapper')
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | so_assets | NULL | ALL | idx_asset_name | Индекс не используется | NULL | NULL | 347 | 11.24 | Using where |
Status | Duration |
---|---|
starting | 0.12 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.07 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.17 ms |
preparing | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.85 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.05 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|---|---|
21 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1691 |
20 | JDatabaseDriver->loadObjectList() | JROOT\libraries\src\Access\Access.php:429 |
19 | Joomla\CMS\Access\Access::preloadComponents() | JROOT\libraries\src\Access\Access.php:213 |
18 | Joomla\CMS\Access\Access::preload() | JROOT\libraries\src\Access\Access.php:531 |
17 | Joomla\CMS\Access\Access::getAssetRules() | JROOT\libraries\src\Access\Access.php:183 |
16 | Joomla\CMS\Access\Access::check() | JROOT\libraries\src\User\User.php:398 |
15 | Joomla\CMS\User\User->authorise() | JROOT\components\com_content\models\category.php:139 |
14 | ContentModelCategory->populateState() | JROOT\libraries\src\MVC\Model\BaseDatabaseModel.php:435 |
13 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT\libraries\src\MVC\View\CategoryView.php:116 |
12 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT\components\com_content\views\category\view.html.php:72 |
11 | ContentViewCategory->display() | JROOT\libraries\src\Cache\Controller\ViewController.php:102 |
10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT\libraries\src\MVC\Controller\BaseController.php:663 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT\components\com_content\controller.php:113 |
8 | ContentController->display() | JROOT\libraries\src\MVC\Controller\BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT\components\com_content\content.php:43 |
6 | require_once JROOT\components\com_content\content.php | JROOT\libraries\src\Component\ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT\libraries\src\Component\ComponentHelper.php:357 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT\libraries\src\Application\SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT\libraries\src\Application\SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT\libraries\src\Application\CMSApplication.php:303 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:50 |
SELECT `id`,`name`,`rules`,`parent_id`
FROM `so_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | so_assets | NULL | ALL | idx_asset_name,idx_parent_id | Индекс не используется | NULL | NULL | 347 | 23.20 | Using where |
Status | Duration |
---|---|
starting | 0.04 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.02 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.07 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.50 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
freeing items | 0.05 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|---|---|
21 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1691 |
20 | JDatabaseDriver->loadObjectList() | JROOT\libraries\src\Access\Access.php:359 |
19 | Joomla\CMS\Access\Access::preloadPermissions() | JROOT\libraries\src\Access\Access.php:226 |
18 | Joomla\CMS\Access\Access::preload() | JROOT\libraries\src\Access\Access.php:540 |
17 | Joomla\CMS\Access\Access::getAssetRules() | JROOT\libraries\src\Access\Access.php:183 |
16 | Joomla\CMS\Access\Access::check() | JROOT\libraries\src\User\User.php:398 |
15 | Joomla\CMS\User\User->authorise() | JROOT\components\com_content\models\category.php:139 |
14 | ContentModelCategory->populateState() | JROOT\libraries\src\MVC\Model\BaseDatabaseModel.php:435 |
13 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT\libraries\src\MVC\View\CategoryView.php:116 |
12 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT\components\com_content\views\category\view.html.php:72 |
11 | ContentViewCategory->display() | JROOT\libraries\src\Cache\Controller\ViewController.php:102 |
10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT\libraries\src\MVC\Controller\BaseController.php:663 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT\components\com_content\controller.php:113 |
8 | ContentController->display() | JROOT\libraries\src\MVC\Controller\BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT\components\com_content\content.php:43 |
6 | require_once JROOT\components\com_content\content.php | JROOT\libraries\src\Component\ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT\libraries\src\Component\ComponentHelper.php:357 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT\libraries\src\Application\SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT\libraries\src\Application\SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT\libraries\src\Application\CMSApplication.php:303 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:50 |
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,( SELECT COUNT(i.`id`)
FROM `so_content` AS `i`
WHERE i.`catid` = c.id
AND i.state = 1
AND (i.language = '*' OR i.language = 'ru-RU')) AS numitems
FROM `so_categories` AS `s`
INNER JOIN `so_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('ru-RU','*')) OR (c.lft <= s.lft
AND s.rgt <= c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.published = 1
AND s.id = 25
ORDER BY c.lft
id | 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 | Используется filesort |
1 | PRIMARY | c | NULL | ALL | cat_idx,idx_left_right,idx_language | Индекс не используется | NULL | NULL | 34 | 15.82 | Using where |
2 | DEPENDENT SUBQUERY | i | NULL | ref | idx_state,idx_catid,idx_language | idx_catid | 4 | uszn.c.id | 13 | 100.00 | Using index condition; Using where |
Status | Duration |
---|---|
starting | 0.20 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.03 ms |
init | 0.08 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.16 ms |
preparing | 0.02 ms |
Sorting result | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.07 ms |
preparing | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.02 ms |
Creating sort index | 0.12 ms |
executing | 0.00 ms |
Sending data | 0.03 ms |
executing | 0.00 ms |
Sending data | 0.30 ms |
executing | 0.00 ms |
Sending data | 0.57 ms |
executing | 0.00 ms |
Sending data | 0.11 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.07 ms |
cleaning up | 0.02 ms |
# | Caller | File and line number |
---|---|---|
18 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1691 |
17 | JDatabaseDriver->loadObjectList() | JROOT\libraries\src\Categories\Categories.php:314 |
16 | Joomla\CMS\Categories\Categories->_load() | JROOT\libraries\src\Categories\Categories.php:186 |
15 | Joomla\CMS\Categories\Categories->get() | JROOT\components\com_content\models\category.php:355 |
14 | ContentModelCategory->getCategory() | JROOT\libraries\src\MVC\View\HtmlView.php:423 |
13 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT\libraries\src\MVC\View\CategoryView.php:122 |
12 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT\components\com_content\views\category\view.html.php:72 |
11 | ContentViewCategory->display() | JROOT\libraries\src\Cache\Controller\ViewController.php:102 |
10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT\libraries\src\MVC\Controller\BaseController.php:663 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT\components\com_content\controller.php:113 |
8 | ContentController->display() | JROOT\libraries\src\MVC\Controller\BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT\components\com_content\content.php:43 |
6 | require_once JROOT\components\com_content\content.php | JROOT\libraries\src\Component\ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT\libraries\src\Component\ComponentHelper.php:357 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT\libraries\src\Application\SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT\libraries\src\Application\SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT\libraries\src\Application\CMSApplication.php:303 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:50 |
SELECT DISTINCT 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 c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
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, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
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,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM so_content AS a
LEFT JOIN so_categories AS c
ON c.id = a.catid
LEFT JOIN so_users AS ua
ON ua.id = a.created_by
LEFT JOIN so_users AS uam
ON uam.id = a.modified_by
LEFT JOIN so_categories as parent
ON parent.id = c.parent_id
LEFT JOIN so_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND c.published = 1
AND a.state = 1
AND (a.catid = 25 OR a.catid IN ( SELECT sub.id
FROM so_categories as sub
INNER JOIN so_categories as this
ON sub.lft > this.lft
AND sub.rgt < this.rgt
WHERE this.id = 25))
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-02-17 10:43:00')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-02-17 10:43:00')
AND a.language in ('ru-RU','*')
ORDER BY a.created DESC , a.created
LIMIT 50, 9
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | PRIMARY | a | NULL | ref | idx_access,idx_state,idx_catid,idx_language | idx_state | 1 | const | 194 | 16.00 | Using where; Using temporary; Используется filesort |
1 | PRIMARY | c | NULL | eq_ref | PRIMARY,idx_access | PRIMARY | 4 | uszn.a.catid | 1 | 10.00 | Using where |
1 | PRIMARY | ua | NULL | ALL | PRIMARY | Индекс не используется | NULL | NULL | 2 | 100.00 | Using where; Using join buffer (Block Nested Loop) |
1 | PRIMARY | uam | NULL | eq_ref | PRIMARY | PRIMARY | 4 | uszn.a.modified_by | 1 | 100.00 | Using where |
1 | PRIMARY | parent | NULL | eq_ref | PRIMARY | PRIMARY | 4 | uszn.c.parent_id | 1 | 100.00 | Using where |
1 | PRIMARY | v | NULL | ALL | PRIMARY | Индекс не используется | NULL | NULL | 1 | 100.00 | Using where; Using join buffer (Block Nested Loop) |
2 | SUBQUERY | this | NULL | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | NULL |
2 | SUBQUERY | sub | NULL | range | PRIMARY,idx_left_right | idx_left_right | 4 | NULL | 9 | 33.33 | Using where; Using index |
Status | Duration |
---|---|
starting | 0.29 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.04 ms |
init | 0.14 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.25 ms |
preparing | 0.05 ms |
Creating tmp table | 0.09 ms |
Sorting result | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.11 ms |
preparing | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.07 ms |
executing | 0.00 ms |
Sending data | 39.52 ms |
Creating sort index | 1.98 ms |
end | 0.01 ms |
query end | 0.02 ms |
removing tmp table | 0.24 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.03 ms |
removing tmp table | 0.01 ms |
freeing items | 0.05 ms |
cleaning up | 0.02 ms |
# | Caller | File and line number |
---|---|---|
19 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1691 |
18 | JDatabaseDriver->loadObjectList() | JROOT\libraries\src\MVC\Model\BaseDatabaseModel.php:308 |
17 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT\libraries\src\MVC\Model\ListModel.php:187 |
16 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT\components\com_content\models\articles.php:558 |
15 | ContentModelArticles->getItems() | JROOT\components\com_content\models\category.php:253 |
14 | ContentModelCategory->getItems() | JROOT\libraries\src\MVC\View\HtmlView.php:423 |
13 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT\libraries\src\MVC\View\CategoryView.php:144 |
12 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT\components\com_content\views\category\view.html.php:72 |
11 | ContentViewCategory->display() | JROOT\libraries\src\Cache\Controller\ViewController.php:102 |
10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT\libraries\src\MVC\Controller\BaseController.php:663 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT\components\com_content\controller.php:113 |
8 | ContentController->display() | JROOT\libraries\src\MVC\Controller\BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT\components\com_content\content.php:43 |
6 | require_once JROOT\components\com_content\content.php | JROOT\libraries\src\Component\ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT\libraries\src\Component\ComponentHelper.php:357 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT\libraries\src\Application\SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT\libraries\src\Application\SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT\libraries\src\Application\CMSApplication.php:303 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:50 |
SELECT COUNT(*)
FROM so_content AS a
LEFT JOIN so_categories AS c
ON c.id = a.catid
LEFT JOIN so_users AS ua
ON ua.id = a.created_by
LEFT JOIN so_users AS uam
ON uam.id = a.modified_by
LEFT JOIN so_categories as parent
ON parent.id = c.parent_id
LEFT JOIN so_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND c.published = 1
AND a.state = 1
AND (a.catid = 25 OR a.catid IN ( SELECT sub.id
FROM so_categories as sub
INNER JOIN so_categories as this
ON sub.lft > this.lft
AND sub.rgt < this.rgt
WHERE this.id = 25))
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-02-17 10:43:00')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-02-17 10:43:00')
AND a.language in ('ru-RU','*')
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | PRIMARY | c | NULL | ALL | PRIMARY,idx_access | Индекс не используется | NULL | NULL | 34 | 10.00 | Using where |
1 | PRIMARY | a | NULL | ref | idx_access,idx_state,idx_catid,idx_language | idx_catid | 4 | uszn.c.id | 13 | 16.00 | Using index condition; Using where |
1 | PRIMARY | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | uszn.a.created_by | 1 | 100.00 | Using where; Using index |
1 | PRIMARY | uam | NULL | eq_ref | PRIMARY | PRIMARY | 4 | uszn.a.modified_by | 1 | 100.00 | Using where; Using index |
1 | PRIMARY | parent | NULL | eq_ref | PRIMARY | PRIMARY | 4 | uszn.c.parent_id | 1 | 100.00 | Using where; Using index |
1 | PRIMARY | v | NULL | eq_ref | PRIMARY | PRIMARY | 4 | uszn.a.id | 1 | 100.00 | Using where; Using index |
2 | SUBQUERY | this | NULL | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | NULL |
2 | SUBQUERY | sub | NULL | range | PRIMARY,idx_left_right | idx_left_right | 4 | NULL | 9 | 33.33 | Using where; Using index |
Status | Duration |
---|---|
starting | 0.18 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.03 ms |
init | 0.09 ms |
System lock | 0.01 ms |
optimizing | 0.03 ms |
statistics | 0.19 ms |
preparing | 0.05 ms |
optimizing | 0.01 ms |
statistics | 0.12 ms |
preparing | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.08 ms |
executing | 0.00 ms |
Sending data | 3.06 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
removing tmp table | 0.00 ms |
freeing items | 0.05 ms |
cleaning up | 0.02 ms |
# | Caller | File and line number |
---|---|---|
19 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1730 |
18 | JDatabaseDriver->loadResult() | JROOT\libraries\src\MVC\Model\BaseDatabaseModel.php:335 |
17 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() | JROOT\libraries\src\MVC\Model\ListModel.php:282 |
16 | Joomla\CMS\MVC\Model\ListModel->getTotal() | JROOT\libraries\src\MVC\Model\ListModel.php:232 |
15 | Joomla\CMS\MVC\Model\ListModel->getPagination() | JROOT\components\com_content\models\category.php:265 |
14 | ContentModelCategory->getItems() | JROOT\libraries\src\MVC\View\HtmlView.php:423 |
13 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT\libraries\src\MVC\View\CategoryView.php:144 |
12 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT\components\com_content\views\category\view.html.php:72 |
11 | ContentViewCategory->display() | JROOT\libraries\src\Cache\Controller\ViewController.php:102 |
10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT\libraries\src\MVC\Controller\BaseController.php:663 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT\components\com_content\controller.php:113 |
8 | ContentController->display() | JROOT\libraries\src\MVC\Controller\BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT\components\com_content\content.php:43 |
6 | require_once JROOT\components\com_content\content.php | JROOT\libraries\src\Component\ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT\libraries\src\Component\ComponentHelper.php:357 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT\libraries\src\Application\SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT\libraries\src\Application\SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT\libraries\src\Application\CMSApplication.php:303 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:50 |
SELECT `m`.`tag_id`,`t`.*
FROM `so_contentitem_tag_map` AS m
INNER JOIN `so_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.category'
AND `m`.`content_item_id` = 25
AND `t`.`published` = 1
AND t.access IN (1,1)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | NULL | ALL | idx_tag_type | Индекс не используется | NULL | NULL | 1 | 100.00 | Using where |
1 | SIMPLE | t | NULL | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | uszn.m.tag_id | 1 | 100.00 | Using where |
Status | Duration |
---|---|
starting | 0.10 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.02 ms |
init | 0.05 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.10 ms |
preparing | 0.03 ms |
executing | 0.00 ms |
Sending data | 0.04 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.04 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|---|---|
15 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1691 |
14 | JDatabaseDriver->loadObjectList() | JROOT\libraries\src\Helper\TagsHelper.php:454 |
13 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT\libraries\src\MVC\View\CategoryView.php:226 |
12 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT\components\com_content\views\category\view.html.php:72 |
11 | ContentViewCategory->display() | JROOT\libraries\src\Cache\Controller\ViewController.php:102 |
10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT\libraries\src\MVC\Controller\BaseController.php:663 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT\components\com_content\controller.php:113 |
8 | ContentController->display() | JROOT\libraries\src\MVC\Controller\BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT\components\com_content\content.php:43 |
6 | require_once JROOT\components\com_content\content.php | JROOT\libraries\src\Component\ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT\libraries\src\Component\ComponentHelper.php:357 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT\libraries\src\Application\SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT\libraries\src\Application\SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT\libraries\src\Application\CMSApplication.php:303 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:50 |
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 `so_categories` AS `s`
INNER JOIN `so_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('ru-RU','*')) OR (c.lft <= s.lft
AND s.rgt <= c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id = 28
ORDER BY c.lft
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | s | NULL | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | Используется filesort |
1 | SIMPLE | c | NULL | ALL | cat_idx,idx_access,idx_left_right,idx_language | Индекс не используется | NULL | NULL | 34 | 15.82 | Using where |
Status | Duration |
---|---|
starting | 0.19 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.02 ms |
init | 0.08 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.19 ms |
preparing | 0.03 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.02 ms |
Creating sort index | 0.15 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.06 ms |
cleaning up | 0.02 ms |
# | Caller | File and line number |
---|---|---|
22 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1691 |
21 | JDatabaseDriver->loadObjectList() | JROOT\libraries\src\Categories\Categories.php:314 |
20 | Joomla\CMS\Categories\Categories->_load() | JROOT\libraries\src\Categories\Categories.php:186 |
19 | Joomla\CMS\Categories\Categories->get() | JROOT\administrator\components\com_fields\models\fields.php:197 |
18 | FieldsModelFields->getListQuery() | JROOT\libraries\src\MVC\Model\ListModel.php:133 |
17 | Joomla\CMS\MVC\Model\ListModel->_getListQuery() | JROOT\libraries\src\MVC\Model\ListModel.php:187 |
16 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT\administrator\components\com_fields\helpers\fields.php:136 |
15 | FieldsHelper::getFields() | JROOT\plugins\system\fields\fields.php:427 |
14 | PlgSystemFields->onContentPrepare() | JROOT\libraries\joomla\event\event.php:70 |
13 | JEvent->update() | JROOT\libraries\joomla\event\dispatcher.php:160 |
12 | JEventDispatcher->trigger() | JROOT\components\com_content\views\category\view.html.php:108 |
11 | ContentViewCategory->display() | JROOT\libraries\src\Cache\Controller\ViewController.php:102 |
10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT\libraries\src\MVC\Controller\BaseController.php:663 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT\components\com_content\controller.php:113 |
8 | ContentController->display() | JROOT\libraries\src\MVC\Controller\BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT\components\com_content\content.php:43 |
6 | require_once JROOT\components\com_content\content.php | JROOT\libraries\src\Component\ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT\libraries\src\Component\ComponentHelper.php:357 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT\libraries\src\Application\SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT\libraries\src\Application\SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT\libraries\src\Application\CMSApplication.php:303 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:50 |
SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
FROM so_fields AS a
LEFT JOIN `so_languages` AS l
ON l.lang_code = a.language
LEFT JOIN so_users AS uc
ON uc.id=a.checked_out
LEFT JOIN so_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN so_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN so_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `so_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (28,0,25))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
AND a.language in ('*','ru-RU')
ORDER BY a.ordering ASC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | NULL | ref | idx_state,idx_access,idx_language | idx_state | 1 | const | 1 | 100.00 | Using index condition; Using where; Используется filesort |
1 | SIMPLE | l | NULL | eq_ref | idx_langcode | idx_langcode | 28 | uszn.a.language | 1 | 100.00 | Using where |
1 | SIMPLE | uc | NULL | eq_ref | PRIMARY | PRIMARY | 4 | uszn.a.checked_out | 1 | 100.00 | NULL |
1 | SIMPLE | ag | NULL | eq_ref | PRIMARY | PRIMARY | 4 | uszn.a.access | 1 | 100.00 | Using where |
1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | uszn.a.created_user_id | 1 | 100.00 | Using where |
1 | SIMPLE | g | NULL | eq_ref | PRIMARY | PRIMARY | 4 | uszn.a.group_id | 1 | 100.00 | Using where |
1 | SIMPLE | fc | NULL | ref | PRIMARY | PRIMARY | 4 | uszn.a.id | 1 | 100.00 | Using where; Using index |
Status | Duration |
---|---|
starting | 0.13 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.03 ms |
init | 0.06 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.10 ms |
preparing | 0.03 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.02 ms |
Creating sort index | 0.04 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.04 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|---|---|
20 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1691 |
19 | JDatabaseDriver->loadObjectList() | JROOT\libraries\src\MVC\Model\BaseDatabaseModel.php:308 |
18 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT\administrator\components\com_fields\models\fields.php:327 |
17 | FieldsModelFields->_getList() | JROOT\libraries\src\MVC\Model\ListModel.php:187 |
16 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT\administrator\components\com_fields\helpers\fields.php:136 |
15 | FieldsHelper::getFields() | JROOT\plugins\system\fields\fields.php:427 |
14 | PlgSystemFields->onContentPrepare() | JROOT\libraries\joomla\event\event.php:70 |
13 | JEvent->update() | JROOT\libraries\joomla\event\dispatcher.php:160 |
12 | JEventDispatcher->trigger() | JROOT\components\com_content\views\category\view.html.php:108 |
11 | ContentViewCategory->display() | JROOT\libraries\src\Cache\Controller\ViewController.php:102 |
10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT\libraries\src\MVC\Controller\BaseController.php:663 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT\components\com_content\controller.php:113 |
8 | ContentController->display() | JROOT\libraries\src\MVC\Controller\BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT\components\com_content\content.php:43 |
6 | require_once JROOT\components\com_content\content.php | JROOT\libraries\src\Component\ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT\libraries\src\Component\ComponentHelper.php:357 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT\libraries\src\Application\SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT\libraries\src\Application\SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT\libraries\src\Application\CMSApplication.php:303 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:50 |
SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
FROM so_fields AS a
LEFT JOIN `so_languages` AS l
ON l.lang_code = a.language
LEFT JOIN so_users AS uc
ON uc.id=a.checked_out
LEFT JOIN so_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN so_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN so_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `so_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (25,0))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
AND a.language in ('*','ru-RU')
ORDER BY a.ordering ASC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | NULL | ref | idx_state,idx_access,idx_language | idx_state | 1 | const | 1 | 100.00 | Using index condition; Using where; Используется filesort |
1 | SIMPLE | l | NULL | eq_ref | idx_langcode | idx_langcode | 28 | uszn.a.language | 1 | 100.00 | Using where |
1 | SIMPLE | uc | NULL | eq_ref | PRIMARY | PRIMARY | 4 | uszn.a.checked_out | 1 | 100.00 | NULL |
1 | SIMPLE | ag | NULL | eq_ref | PRIMARY | PRIMARY | 4 | uszn.a.access | 1 | 100.00 | Using where |
1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | uszn.a.created_user_id | 1 | 100.00 | Using where |
1 | SIMPLE | g | NULL | eq_ref | PRIMARY | PRIMARY | 4 | uszn.a.group_id | 1 | 100.00 | Using where |
1 | SIMPLE | fc | NULL | ref | PRIMARY | PRIMARY | 4 | uszn.a.id | 1 | 100.00 | Using where; Using index |
Status | Duration |
---|---|
starting | 0.19 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.04 ms |
init | 0.08 ms |
System lock | 0.01 ms |
optimizing | 0.03 ms |
statistics | 0.15 ms |
preparing | 0.04 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.02 ms |
Creating sort index | 0.06 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.05 ms |
cleaning up | 0.02 ms |
# | Caller | File and line number |
---|---|---|
20 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1691 |
19 | JDatabaseDriver->loadObjectList() | JROOT\libraries\src\MVC\Model\BaseDatabaseModel.php:308 |
18 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT\administrator\components\com_fields\models\fields.php:327 |
17 | FieldsModelFields->_getList() | JROOT\libraries\src\MVC\Model\ListModel.php:187 |
16 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT\administrator\components\com_fields\helpers\fields.php:136 |
15 | FieldsHelper::getFields() | JROOT\plugins\system\fields\fields.php:427 |
14 | PlgSystemFields->onContentPrepare() | JROOT\libraries\joomla\event\event.php:70 |
13 | JEvent->update() | JROOT\libraries\joomla\event\dispatcher.php:160 |
12 | JEventDispatcher->trigger() | JROOT\components\com_content\views\category\view.html.php:108 |
11 | ContentViewCategory->display() | JROOT\libraries\src\Cache\Controller\ViewController.php:102 |
10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT\libraries\src\MVC\Controller\BaseController.php:663 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT\components\com_content\controller.php:113 |
8 | ContentController->display() | JROOT\libraries\src\MVC\Controller\BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT\components\com_content\content.php:43 |
6 | require_once JROOT\components\com_content\content.php | JROOT\libraries\src\Component\ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT\libraries\src\Component\ComponentHelper.php:357 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT\libraries\src\Application\SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT\libraries\src\Application\SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT\libraries\src\Application\CMSApplication.php:303 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:50 |
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 `so_categories` AS `s`
INNER JOIN `so_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('ru-RU','*')) OR (c.lft <= s.lft
AND s.rgt <= c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id = 27
ORDER BY c.lft
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | s | NULL | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | Используется filesort |
1 | SIMPLE | c | NULL | ALL | cat_idx,idx_access,idx_left_right,idx_language | Индекс не используется | NULL | NULL | 34 | 15.26 | Using where |
Status | Duration |
---|---|
starting | 0.14 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.02 ms |
init | 0.06 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.15 ms |
preparing | 0.02 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.02 ms |
Creating sort index | 0.14 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.04 ms |
cleaning up | 0.02 ms |
# | Caller | File and line number |
---|---|---|
22 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1691 |
21 | JDatabaseDriver->loadObjectList() | JROOT\libraries\src\Categories\Categories.php:314 |
20 | Joomla\CMS\Categories\Categories->_load() | JROOT\libraries\src\Categories\Categories.php:186 |
19 | Joomla\CMS\Categories\Categories->get() | JROOT\administrator\components\com_fields\models\fields.php:197 |
18 | FieldsModelFields->getListQuery() | JROOT\libraries\src\MVC\Model\ListModel.php:133 |
17 | Joomla\CMS\MVC\Model\ListModel->_getListQuery() | JROOT\libraries\src\MVC\Model\ListModel.php:187 |
16 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT\administrator\components\com_fields\helpers\fields.php:136 |
15 | FieldsHelper::getFields() | JROOT\plugins\system\fields\fields.php:427 |
14 | PlgSystemFields->onContentPrepare() | JROOT\libraries\joomla\event\event.php:70 |
13 | JEvent->update() | JROOT\libraries\joomla\event\dispatcher.php:160 |
12 | JEventDispatcher->trigger() | JROOT\components\com_content\views\category\view.html.php:108 |
11 | ContentViewCategory->display() | JROOT\libraries\src\Cache\Controller\ViewController.php:102 |
10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT\libraries\src\MVC\Controller\BaseController.php:663 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT\components\com_content\controller.php:113 |
8 | ContentController->display() | JROOT\libraries\src\MVC\Controller\BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT\components\com_content\content.php:43 |
6 | require_once JROOT\components\com_content\content.php | JROOT\libraries\src\Component\ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT\libraries\src\Component\ComponentHelper.php:357 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT\libraries\src\Application\SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT\libraries\src\Application\SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT\libraries\src\Application\CMSApplication.php:303 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:50 |
SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
FROM so_fields AS a
LEFT JOIN `so_languages` AS l
ON l.lang_code = a.language
LEFT JOIN so_users AS uc
ON uc.id=a.checked_out
LEFT JOIN so_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN so_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN so_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `so_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (27,0,25))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
AND a.language in ('*','ru-RU')
ORDER BY a.ordering ASC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | NULL | ref | idx_state,idx_access,idx_language | idx_state | 1 | const | 1 | 100.00 | Using index condition; Using where; Используется filesort |
1 | SIMPLE | l | NULL | eq_ref | idx_langcode | idx_langcode | 28 | uszn.a.language | 1 | 100.00 | Using where |
1 | SIMPLE | uc | NULL | eq_ref | PRIMARY | PRIMARY | 4 | uszn.a.checked_out | 1 | 100.00 | NULL |
1 | SIMPLE | ag | NULL | eq_ref | PRIMARY | PRIMARY | 4 | uszn.a.access | 1 | 100.00 | Using where |
1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | uszn.a.created_user_id | 1 | 100.00 | Using where |
1 | SIMPLE | g | NULL | eq_ref | PRIMARY | PRIMARY | 4 | uszn.a.group_id | 1 | 100.00 | Using where |
1 | SIMPLE | fc | NULL | ref | PRIMARY | PRIMARY | 4 | uszn.a.id | 1 | 100.00 | Using where; Using index |
Status | Duration |
---|---|
starting | 0.13 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.02 ms |
init | 0.06 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.09 ms |
preparing | 0.03 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.02 ms |
Creating sort index | 0.04 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.04 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|---|---|
20 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1691 |
19 | JDatabaseDriver->loadObjectList() | JROOT\libraries\src\MVC\Model\BaseDatabaseModel.php:308 |
18 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT\administrator\components\com_fields\models\fields.php:327 |
17 | FieldsModelFields->_getList() | JROOT\libraries\src\MVC\Model\ListModel.php:187 |
16 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT\administrator\components\com_fields\helpers\fields.php:136 |
15 | FieldsHelper::getFields() | JROOT\plugins\system\fields\fields.php:427 |
14 | PlgSystemFields->onContentPrepare() | JROOT\libraries\joomla\event\event.php:70 |
13 | JEvent->update() | JROOT\libraries\joomla\event\dispatcher.php:160 |
12 | JEventDispatcher->trigger() | JROOT\components\com_content\views\category\view.html.php:108 |
11 | ContentViewCategory->display() | JROOT\libraries\src\Cache\Controller\ViewController.php:102 |
10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT\libraries\src\MVC\Controller\BaseController.php:663 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT\components\com_content\controller.php:113 |
8 | ContentController->display() | JROOT\libraries\src\MVC\Controller\BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT\components\com_content\content.php:43 |
6 | require_once JROOT\components\com_content\content.php | JROOT\libraries\src\Component\ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT\libraries\src\Component\ComponentHelper.php:357 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT\libraries\src\Application\SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT\libraries\src\Application\SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT\libraries\src\Application\CMSApplication.php:303 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:50 |
SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
FROM so_fields AS a
LEFT JOIN `so_languages` AS l
ON l.lang_code = a.language
LEFT JOIN so_users AS uc
ON uc.id=a.checked_out
LEFT JOIN so_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN so_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN so_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `so_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.categories'
AND (fc.category_id IS NULL OR fc.category_id IN (27,0,25))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
AND a.language in ('*','ru-RU')
ORDER BY a.ordering ASC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | NULL | ref | idx_state,idx_access,idx_language | idx_state | 1 | const | 1 | 100.00 | Using index condition; Using where; Используется filesort |
1 | SIMPLE | l | NULL | eq_ref | idx_langcode | idx_langcode | 28 | uszn.a.language | 1 | 100.00 | Using where |
1 | SIMPLE | uc | NULL | eq_ref | PRIMARY | PRIMARY | 4 | uszn.a.checked_out | 1 | 100.00 | NULL |
1 | SIMPLE | ag | NULL | eq_ref | PRIMARY | PRIMARY | 4 | uszn.a.access | 1 | 100.00 | Using where |
1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | uszn.a.created_user_id | 1 | 100.00 | Using where |
1 | SIMPLE | g | NULL | eq_ref | PRIMARY | PRIMARY | 4 | uszn.a.group_id | 1 | 100.00 | Using where |
1 | SIMPLE | fc | NULL | ref | PRIMARY | PRIMARY | 4 | uszn.a.id | 1 | 100.00 | Using where; Using index |
Status | Duration |
---|---|
starting | 0.20 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.04 ms |
init | 0.08 ms |
System lock | 0.01 ms |
optimizing | 0.03 ms |
statistics | 0.15 ms |
preparing | 0.04 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.02 ms |
Creating sort index | 0.06 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.05 ms |
cleaning up | 0.02 ms |
# | Caller | File and line number |
---|---|---|
24 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1691 |
23 | JDatabaseDriver->loadObjectList() | JROOT\libraries\src\MVC\Model\BaseDatabaseModel.php:308 |
22 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT\administrator\components\com_fields\models\fields.php:327 |
21 | FieldsModelFields->_getList() | JROOT\libraries\src\MVC\Model\ListModel.php:187 |
20 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT\administrator\components\com_fields\helpers\fields.php:136 |
19 | FieldsHelper::getFields() | JROOT\plugins\system\fields\fields.php:427 |
18 | PlgSystemFields->onContentPrepare() | JROOT\libraries\joomla\event\event.php:70 |
17 | JEvent->update() | JROOT\libraries\joomla\event\dispatcher.php:160 |
16 | JEventDispatcher->trigger() | JROOT\components\com_content\views\category\tmpl\blog.php:19 |
15 | include JROOT\components\com_content\views\category\tmpl\blog.php | JROOT\libraries\src\MVC\View\HtmlView.php:695 |
14 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT\libraries\src\MVC\View\HtmlView.php:230 |
13 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT\libraries\src\MVC\View\CategoryView.php:242 |
12 | Joomla\CMS\MVC\View\CategoryView->display() | JROOT\components\com_content\views\category\view.html.php:269 |
11 | ContentViewCategory->display() | JROOT\libraries\src\Cache\Controller\ViewController.php:102 |
10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT\libraries\src\MVC\Controller\BaseController.php:663 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT\components\com_content\controller.php:113 |
8 | ContentController->display() | JROOT\libraries\src\MVC\Controller\BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT\components\com_content\content.php:43 |
6 | require_once JROOT\components\com_content\content.php | JROOT\libraries\src\Component\ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT\libraries\src\Component\ComponentHelper.php:357 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT\libraries\src\Application\SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT\libraries\src\Application\SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT\libraries\src\Application\CMSApplication.php:303 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:50 |
SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
FROM so_fields AS a
LEFT JOIN `so_languages` AS l
ON l.lang_code = a.language
LEFT JOIN so_users AS uc
ON uc.id=a.checked_out
LEFT JOIN so_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN so_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN so_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `so_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.categories'
AND (fc.category_id IS NULL OR fc.category_id IN (25,0))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
AND a.language in ('*','ru-RU')
ORDER BY a.ordering ASC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | NULL | ref | idx_state,idx_access,idx_language | idx_state | 1 | const | 1 | 100.00 | Using index condition; Using where; Используется filesort |
1 | SIMPLE | l | NULL | eq_ref | idx_langcode | idx_langcode | 28 | uszn.a.language | 1 | 100.00 | Using where |
1 | SIMPLE | uc | NULL | eq_ref | PRIMARY | PRIMARY | 4 | uszn.a.checked_out | 1 | 100.00 | NULL |
1 | SIMPLE | ag | NULL | eq_ref | PRIMARY | PRIMARY | 4 | uszn.a.access | 1 | 100.00 | Using where |
1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | uszn.a.created_user_id | 1 | 100.00 | Using where |
1 | SIMPLE | g | NULL | eq_ref | PRIMARY | PRIMARY | 4 | uszn.a.group_id | 1 | 100.00 | Using where |
1 | SIMPLE | fc | NULL | ref | PRIMARY | PRIMARY | 4 | uszn.a.id | 1 | 100.00 | Using where; Using index |
Status | Duration |
---|---|
starting | 0.15 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.02 ms |
init | 0.06 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.10 ms |
preparing | 0.03 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.02 ms |
Creating sort index | 0.04 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.04 ms |
cleaning up | 0.02 ms |
# | Caller | File and line number |
---|---|---|
25 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1691 |
24 | JDatabaseDriver->loadObjectList() | JROOT\libraries\src\MVC\Model\BaseDatabaseModel.php:308 |
23 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT\administrator\components\com_fields\models\fields.php:327 |
22 | FieldsModelFields->_getList() | JROOT\libraries\src\MVC\Model\ListModel.php:187 |
21 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT\administrator\components\com_fields\helpers\fields.php:136 |
20 | FieldsHelper::getFields() | JROOT\plugins\system\fields\fields.php:344 |
19 | PlgSystemFields->display() | JROOT\plugins\system\fields\fields.php:264 |
18 | PlgSystemFields->onContentAfterTitle() | JROOT\libraries\joomla\event\event.php:70 |
17 | JEvent->update() | JROOT\libraries\joomla\event\dispatcher.php:160 |
16 | JEventDispatcher->trigger() | JROOT\components\com_content\views\category\tmpl\blog.php:22 |
15 | include JROOT\components\com_content\views\category\tmpl\blog.php | JROOT\libraries\src\MVC\View\HtmlView.php:695 |
14 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT\libraries\src\MVC\View\HtmlView.php:230 |
13 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT\libraries\src\MVC\View\CategoryView.php:242 |
12 | Joomla\CMS\MVC\View\CategoryView->display() | JROOT\components\com_content\views\category\view.html.php:269 |
11 | ContentViewCategory->display() | JROOT\libraries\src\Cache\Controller\ViewController.php:102 |
10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT\libraries\src\MVC\Controller\BaseController.php:663 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT\components\com_content\controller.php:113 |
8 | ContentController->display() | JROOT\libraries\src\MVC\Controller\BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT\components\com_content\content.php:43 |
6 | require_once JROOT\components\com_content\content.php | JROOT\libraries\src\Component\ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT\libraries\src\Component\ComponentHelper.php:357 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT\libraries\src\Application\SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT\libraries\src\Application\SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT\libraries\src\Application\CMSApplication.php:303 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:50 |
SELECT *
FROM so_template_styles
WHERE template = 'corpway';
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | so_template_styles | NULL | ref | idx_template | idx_template | 202 | const | 1 | 100.00 | NULL |
Status | Duration |
---|---|
starting | 0.09 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.04 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.09 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.07 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|---|---|
11 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1496 |
10 | JDatabaseDriver->loadAssocList() | JROOT\templates\corpway\vertex\parameters.php:19 |
9 | getTemplateName() | JROOT\templates\corpway\vertex\parameters.php:167 |
8 | require_once JROOT\templates\corpway\vertex\parameters.php | JROOT\templates\corpway\index.php:11 |
7 | require JROOT\templates\corpway\index.php | JROOT\libraries\src\Document\HtmlDocument.php:658 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT\libraries\src\Document\HtmlDocument.php:720 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT\libraries\src\Document\HtmlDocument.php:535 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT\libraries\src\Application\CMSApplication.php:1126 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT\libraries\src\Application\SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT\libraries\src\Application\CMSApplication.php:309 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:50 |
SELECT *
FROM so_menu
WHERE template_style_id IN (17)
AND alias = 'home'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | so_menu | NULL | ALL | NULL | Индекс не используется | NULL | NULL | 143 | 1.00 | Using where |
Status | Duration |
---|---|
starting | 0.04 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.47 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.04 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|---|---|
11 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1496 |
10 | JDatabaseDriver->loadAssocList() | JROOT\templates\corpway\vertex\parameters.php:40 |
9 | getTemplateName() | JROOT\templates\corpway\vertex\parameters.php:167 |
8 | require_once JROOT\templates\corpway\vertex\parameters.php | JROOT\templates\corpway\index.php:11 |
7 | require JROOT\templates\corpway\index.php | JROOT\libraries\src\Document\HtmlDocument.php:658 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT\libraries\src\Document\HtmlDocument.php:720 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT\libraries\src\Document\HtmlDocument.php:535 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT\libraries\src\Application\CMSApplication.php:1126 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT\libraries\src\Application\SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT\libraries\src\Application\CMSApplication.php:309 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:50 |
SELECT menutype
FROM so_menu
WHERE language = 'ru-RU'
AND home = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | so_menu | NULL | ref | idx_language | idx_language | 28 | const | 1 | 10.00 | Using where |
Status | Duration |
---|---|
starting | 0.10 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.13 ms |
preparing | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.04 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|---|---|
12 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1730 |
11 | JDatabaseDriver->loadResult() | JROOT\templates\corpway\vertex\responsive\responsive_mobile_menu.php:139 |
10 | include JROOT\templates\corpway\vertex\responsive\responsive_mobile_menu.php | JROOT\templates\corpway\vertex\responsive\responsive_mobile_sidebar.php:68 |
9 | require JROOT\templates\corpway\vertex\responsive\responsive_mobile_sidebar.php | JROOT\templates\corpway\vertex\includes\vertex_includes_top.php:4 |
8 | require_once JROOT\templates\corpway\vertex\includes\vertex_includes_top.php | JROOT\templates\corpway\index.php:201 |
7 | require JROOT\templates\corpway\index.php | JROOT\libraries\src\Document\HtmlDocument.php:658 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT\libraries\src\Document\HtmlDocument.php:720 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT\libraries\src\Document\HtmlDocument.php:535 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT\libraries\src\Application\CMSApplication.php:1126 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT\libraries\src\Application\SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT\libraries\src\Application\CMSApplication.php:309 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:50 |
SELECT menutype
FROM so_menu
WHERE language = 'ru-RU'
AND home = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | so_menu | NULL | ref | idx_language | idx_language | 28 | const | 1 | 10.00 | Using where |
Status | Duration |
---|---|
starting | 0.07 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.08 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.03 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|---|---|
10 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1730 |
9 | JDatabaseDriver->loadResult() | JROOT\templates\corpway\vertex\s5flex_menu\default.php:45 |
8 | include JROOT\templates\corpway\vertex\s5flex_menu\default.php | JROOT\templates\corpway\index.php:247 |
7 | require JROOT\templates\corpway\index.php | JROOT\libraries\src\Document\HtmlDocument.php:658 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT\libraries\src\Document\HtmlDocument.php:720 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT\libraries\src\Document\HtmlDocument.php:535 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT\libraries\src\Application\CMSApplication.php:1126 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT\libraries\src\Application\SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT\libraries\src\Application\CMSApplication.php:309 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:50 |
SELECT a.*,u.name,u.username,u.email
FROM so_jvcounter_logs as a
LEFT JOIN so_users as u
ON u.id = a.user_id
WHERE a.timelast >= 1199145600
ORDER BY a.timelast desc
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | NULL | ALL | NULL | Индекс не используется | NULL | NULL | 66951 | 33.33 | Using where; Using temporary; Используется filesort |
1 | SIMPLE | u | NULL | ALL | PRIMARY | Индекс не используется | NULL | NULL | 2 | 100.00 | Using where; Using join buffer (Block Nested Loop) |
Status | Duration |
---|---|
starting | 0.12 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
Opening tables | 0.03 ms |
init | 0.04 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.03 ms |
preparing | 0.04 ms |
Creating tmp table | 0.04 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 527.07 ms |
Creating sort index | 712.18 ms |
end | 0.01 ms |
query end | 0.01 ms |
removing tmp table | 0.49 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.04 ms |
logging slow query | 0.04 ms |
cleaning up | 0.02 ms |
# | Caller | File and line number |
---|---|---|
13 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1691 |
12 | JDatabaseDriver->loadObjectList() | JROOT\modules\mod_jvcounter\helper.php:77 |
11 | modJVCounterHelper::getVisits() | JROOT\modules\mod_jvcounter\mod_jvcounter.php:16 |
10 | include JROOT\modules\mod_jvcounter\mod_jvcounter.php | JROOT\libraries\src\Helper\ModuleHelper.php:201 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT\libraries\src\Document\Renderer\Html\ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT\libraries\src\Document\HtmlDocument.php:479 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT\libraries\src\Document\HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT\libraries\src\Document\HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT\libraries\src\Application\CMSApplication.php:1140 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT\libraries\src\Application\SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT\libraries\src\Application\CMSApplication.php:309 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:50 |
SELECT guest, client_id
FROM so_session
WHERE client_id = 0
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | so_session | NULL | ALL | NULL | Индекс не используется | NULL | NULL | 184 | 10.00 | Using where |
Status | Duration |
---|---|
starting | 0.11 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.24 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.04 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|---|---|
13 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1691 |
12 | JDatabaseDriver->loadObjectList() | JROOT\modules\mod_jvcounter\helper.php:187 |
11 | modJVCounterHelper::getOnlineCount() | JROOT\modules\mod_jvcounter\mod_jvcounter.php:19 |
10 | include JROOT\modules\mod_jvcounter\mod_jvcounter.php | JROOT\libraries\src\Helper\ModuleHelper.php:201 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT\libraries\src\Document\Renderer\Html\ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT\libraries\src\Document\HtmlDocument.php:479 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT\libraries\src\Document\HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT\libraries\src\Document\HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT\libraries\src\Application\CMSApplication.php:1140 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT\libraries\src\Application\SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT\libraries\src\Application\CMSApplication.php:309 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:50 |
select *
from so_jvcounter_logs
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | so_jvcounter_logs | NULL | ALL | NULL | Индекс не используется | NULL | NULL | 66951 | 100.00 | NULL |
Status | Duration |
---|---|
starting | 0.07 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.00 ms |
statistics | 0.02 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 354.09 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.04 ms |
cleaning up | 0.02 ms |
# | Caller | File and line number |
---|---|---|
11 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1691 |
10 | JDatabaseDriver->loadObjectList() | JROOT\plugins\system\jvcounter\jvcounter.php:107 |
9 | plgSystemJVCounter->getDataLogs() | JROOT\plugins\system\jvcounter\jvcounter.php:48 |
8 | plgSystemJVCounter->saveData() | JROOT\plugins\system\jvcounter\jvcounter.php:24 |
7 | plgSystemJVCounter->onAfterRender() | JROOT\libraries\joomla\event\event.php:70 |
6 | JEvent->update() | JROOT\libraries\joomla\event\dispatcher.php:160 |
5 | JEventDispatcher->trigger() | JROOT\libraries\src\Application\BaseApplication.php:108 |
4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT\libraries\src\Application\CMSApplication.php:1146 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT\libraries\src\Application\SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT\libraries\src\Application\CMSApplication.php:309 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:50 |
select *
from so_session
where session_id = 'm5b8qit9k0c4bi2losjiaoag9r'
and client_id=0
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | so_session | NULL | const | PRIMARY | PRIMARY | 766 | const | 1 | 100.00 | NULL |
Status | Duration |
---|---|
starting | 0.10 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.04 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.09 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.02 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|---|---|
11 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1691 |
10 | JDatabaseDriver->loadObjectList() | JROOT\plugins\system\jvcounter\jvcounter.php:123 |
9 | plgSystemJVCounter->getSession() | JROOT\plugins\system\jvcounter\jvcounter.php:50 |
8 | plgSystemJVCounter->saveData() | JROOT\plugins\system\jvcounter\jvcounter.php:24 |
7 | plgSystemJVCounter->onAfterRender() | JROOT\libraries\joomla\event\event.php:70 |
6 | JEvent->update() | JROOT\libraries\joomla\event\dispatcher.php:160 |
5 | JEventDispatcher->trigger() | JROOT\libraries\src\Application\BaseApplication.php:108 |
4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT\libraries\src\Application\CMSApplication.php:1146 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT\libraries\src\Application\SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT\libraries\src\Application\CMSApplication.php:309 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:50 |
INSERT INTO so_jvcounter_logs (session_id,user_id,ip,timestart,timelast,counter,browser,timezone,lasturl)
VALUES('m5b8qit9k0c4bi2losjiaoag9r','0','18.206.175.155','1550400180','1550400180','0','CCBot/2.0 (https://commoncrawl.org/faq/)','','')
Status | Duration |
---|---|
starting | 0.05 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.02 ms |
System lock | 0.01 ms |
update | 0.09 ms |
end | 0.00 ms |
query end | 32.83 ms |
closing tables | 0.02 ms |
freeing items | 0.04 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|---|---|
10 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\database.php:33 |
9 | JDatabase->query() | JROOT\plugins\system\jvcounter\jvcounter.php:95 |
8 | plgSystemJVCounter->saveData() | JROOT\plugins\system\jvcounter\jvcounter.php:24 |
7 | plgSystemJVCounter->onAfterRender() | JROOT\libraries\joomla\event\event.php:70 |
6 | JEvent->update() | JROOT\libraries\joomla\event\dispatcher.php:160 |
5 | JEventDispatcher->trigger() | JROOT\libraries\src\Application\BaseApplication.php:108 |
4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT\libraries\src\Application\CMSApplication.php:1146 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT\libraries\src\Application\SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT\libraries\src\Application\CMSApplication.php:309 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:50 |
5 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
FROM so_fields AS a
LEFT JOIN `so_languages` AS l
ON l.lang_code = a.language
LEFT JOIN so_users AS uc
ON uc.id=a.checked_out
LEFT JOIN so_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN so_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN so_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `so_fields_categories` AS fc
ON fc.field_id = a.id
2 × 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 `so_categories` AS `s`
INNER JOIN `so_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('ru-RU','*')) OR (c.lft <= s.lft
AND s.rgt <= c.rgt)
2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `so_assets`
2 × SELECT menutype
FROM so_menu
1 × SELECT `data`
FROM `so_session`
1 × select *
from so_jvcounter_log
1 × SELECT guest, client_id
FROM so_session
1 × SELECT a.*,u.name,u.username,u.email
FROM so_jvcounter_logs as a
LEFT JOIN so_users as u
ON u.id = a.user_id
1 × SELECT *
FROM so_menu
1 × SELECT *
FROM so_template_styles
1 × SELECT `m`.`tag_id`,`t`.*
FROM `so_contentitem_tag_map` AS m
INNER JOIN `so_tags` AS t
ON `m`.`tag_id` = `t`.`id`
1 × SELECT `session_id`
FROM `so_session`
1 × SELECT COUNT(*)
FROM so_content AS a
LEFT JOIN so_categories AS c
ON c.id = a.catid
LEFT JOIN so_users AS ua
ON ua.id = a.created_by
LEFT JOIN so_users AS uam
ON uam.id = a.modified_by
LEFT JOIN so_categories as parent
ON parent.id = c.parent_id
LEFT JOIN so_content_rating AS v
ON a.id = v.content_id
1 × SELECT DISTINCT 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 c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
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, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
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,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM so_content AS a
LEFT JOIN so_categories AS c
ON c.id = a.catid
LEFT JOIN so_users AS ua
ON ua.id = a.created_by
LEFT JOIN so_users AS uam
ON uam.id = a.modified_by
LEFT JOIN so_categories as parent
ON parent.id = c.parent_id
LEFT JOIN so_content_rating AS v
ON a.id = v.content_id
1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,( SELECT COUNT(i.`id`)
FROM `so_content` AS `i`
1 × SELECT params
FROM so_extensions
1 × SELECT b.id
FROM so_usergroups AS a
LEFT JOIN so_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT id, rules
FROM `so_viewlevels
1 × select *
from so_session
1 × INSERT INTO `so_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('m5b8qit9k0c4bi2losjiaoag9r', 1, '1550400180', 0, '', 0
1 × UPDATE `so_extensions`
SET `params` = '{\"mediaversion\":\"69f6ac38823f4ed2be9dc3ceb887d8ac\"}'
1 × INSERT INTO so_jvcounter_logs (session_id,user_id,ip,timestart,timelast,counter,browser,timezone,lasturl)
VALUES('m5b8qit9k0c4bi2losjiaoag9r','0','18.206.175.155','1550400180','1550400180','0','CCBot/2.0 (https://commoncrawl.org/faq/)','',''