slider6.png
imageshow2.jpg
imageshow0.jpg
slider9.png
slider11.png
slider10.png
walden-pond.jpg
slider8.png
slider13.png
slider7.png
FrontPageShowList
slider6.png
imageshow2.jpg
http://dobzhanskycenter.spbu.ru/htdocs/images/imageshow2.jpg
imageshow0.jpg
slider9.png
slider11.png
slider10.png
walden-pond.jpg
http://dobzhanskycenter.spbu.ru/htdocs/images/headers/walden-pond.jpg
slider8.png
slider13.png
slider7.png
Ð›Ð°Ð±Ð¾Ñ€Ð°Ñ‚Ð¾Ñ€Ð¸Ñ Ð¦ÐµÐ½Ñ‚Ñ€ Геномной Биоинформатики им. Ф.Г.ДобржанÑкого СПбГУ была оÑнована в 2011 году Ð±Ð»Ð°Ð³Ð¾Ð´Ð°Ñ€Ñ Ð¼ÐµÐ³Ð°Ð³Ñ€Ð°Ð½Ñ‚Ñƒ МиниÑтерÑтва науки и Ð¾Ð±Ñ€Ð°Ð·Ð¾Ð²Ð°Ð½Ð¸Ñ Ð Ð¾ÑÑийÑкой Федерации, предназначенного Ð´Ð»Ñ Ð³Ð¾ÑударÑтвенной поддержки научных иÑÑледований, проводимых под руководÑтвом ведущих мировых ученых в роÑÑийÑких гоÑударÑтвенных образовательных и научных учреждениÑÑ….
ОÑновной задачей ÑвлÑлоÑÑŒ Ñоздание лаборатории биоинформатики, в которой ÑпециалиÑÑ‚Ñ‹ в облаÑти генетики и информатики, Ñтуденты и научные Ñотрудники, будут разрабатывать и внедрÑÑ‚ÑŒ инновационные компьютерные и биоинформатичеÑке инÑтрументы анализа, примененÑÑ Ð½Ð¾Ð²ÐµÐ¹ÑˆÐ¸Ðµ доÑÑ‚Ð¸Ð¶ÐµÐ½Ð¸Ñ Ð³ÐµÐ½ÐµÑ‚Ð¸ÐºÐ¸, биоинформатики и компьютерной биологии Ð´Ð»Ñ Ñборки геномов живых организмов, их аннотации и Ð¾Ð±Ð½Ð°Ñ€ÑƒÐ¶ÐµÐ½Ð¸Ñ Ð³ÐµÐ½Ð¾Ð², Ñ Ð¿Ð¾Ñледующим внедрением полученных результатов в здравоохранение, ÑельÑкое хозÑйÑтво и охрану природы.
Гены ÑвлÑÑŽÑ‚ÑÑ Ð¾Ñновной «инÑтрукцией» Ð´Ð»Ñ Ñ„ÑƒÐ½ÐºÑ†Ð¸Ð¾Ð½Ð¸Ñ€Ð¾Ð²Ð°Ð½Ð¸Ñ ÐºÐ»ÐµÑ‚Ð¾Ðº, из которых ÑоÑтоит организм человека. Гены входÑÑ‚ в ÑоÑтав геномной ДÐК. Более 99% поÑледовательноÑтей ДÐК у вÑех людей идентично. Однако не ÑущеÑтвует двух людей, имеющих полноÑтью одинаковую поÑледовательноÑÑ‚ÑŒ ДÐК, за иÑключением одноÑйцевых близнецов. Индивидуальные Ð¾Ñ‚Ð»Ð¸Ñ‡Ð¸Ñ Ð¿Ð¾ÑледовательноÑтей ДÐК называютÑÑ Ð³ÐµÐ½ÐµÑ‚Ð¸Ñ‡ÐµÑкими вариациÑми. Они объÑÑнÑÑŽÑ‚ некоторые физичеÑкие Ñ€Ð°Ð·Ð»Ð¸Ñ‡Ð¸Ñ Ð¼ÐµÐ¶Ð´Ñƒ людьми и чаÑтично объÑÑнÑÑŽÑ‚, почему у одних людей возникают такие болезни, как рак, диабет, аÑтма, депреÑÑÐ¸Ñ Ð¸ пр., в то Ð²Ñ€ÐµÐ¼Ñ ÐºÐ°Ðº у других Ñтих болезней не бывает. Ðа возникновение упомÑнутых выше заболеваний могут оказывать влиÑние такие факторы, как диета, физичеÑкие упражнениÑ, курение и загрÑзнение окружающей Ñреды, что затруднÑет точное выÑÑнение, какие именно гены влиÑÑŽÑ‚ на болезни.
GWATCH is a web-based genome browser designed to automate analysis, visualization and release of data from genome-wide association studies (GWAS) and whole genome sequence association studies of genetic epidemiological cohorts. For any association study, GWATCH allows cataloging and viewing of significant statistical results of association tests (p-values, odds ratios, hazard ratios and others) for single or multiple variants (SNP, indels, CNV), for single or multiple tests.
Исследование геномов клинических штаммов возбудителя туберкулеза - Mycobacterium tuberculosis, посвящено поиску маркеров, ассоциированных с клиническими и микробиологическими характеристиками патогена на основе данных полногеномного секвенирования. Сотрудниками Центра создана база данных геномных вариаций штаммов M. tuberculosis, распространенных по всему миру, объединяющая генетические, клинические, микробиологические и географические данные (GMTV). Исследования ведутся совместно с Санкт-Петербургским НИИ фтизиопульмонологии, Санкт-Петербургским НИИ эпидемиолонии и микробиологии им. Пастера, и поддержаны грантами РФФИ и СПбГУ.
Проект направлен на изучение фундаментальных оÑнов взаимодейÑÑ‚Ð²Ð¸Ñ Ð¾Ð¿ÑƒÑ…Ð¾Ð»Ð¸ и Ð¼Ð¸ÐºÑ€Ð¾Ð¾ÐºÑ€ÑƒÐ¶ÐµÐ½Ð¸Ñ Ð¿Ñ€Ð¸ фолликулÑрной лимфоме, злокачеÑтвенной опухоли лимфатичеÑкой ÑиÑтемы. ÐеÑÐ¼Ð¾Ñ‚Ñ€Ñ Ð½Ð° ÑффективноÑÑ‚ÑŒ терапии первой линии, обеÑпечивающей подавление роÑта опухолевых клеток, Ñто заболевание оÑтаетÑÑ Ð½ÐµÐ¸Ð·Ð»ÐµÑ‡Ð¸Ð¼Ñ‹Ð¼ и у 20% пациентов наблюдаетÑÑ Ñ€ÐµÑ†Ð¸Ð´Ð¸Ð² в течение первых двух лет терапии. Понимание механизмов Ñ€Ð°Ð·Ð²Ð¸Ñ‚Ð¸Ñ Ñ€ÐµÐ·Ð¸ÑтентноÑти и поиÑк ранних прогноÑтичеÑких маркеров оÑтаетÑÑ Ð¾Ð´Ð½Ð¾Ð¹ из актуальных задач.
Apomixis is asexual way of plant reproduction through seeds, which could be found in more than 400 plant species representing almost 40 families. It is believed that apomixis evolved independently in several taxa from sexual ancestors. Apomixis could be considered as a developmental variation of sexual reproduction in which some steps are lost, reduced, deregulated or desynchronized (Fig.1). The main features of gametophytic apomixis are:
ФеодоÑий Григорьевич ДобржанÑкий, ÑоветÑкий и американÑкий генетик роÑÑийÑкого проиÑхождениÑ, Ñнтомолог, один из оÑнователей ÑинтетичеÑкой теории Ñволюции.
Больше информации о ...
Стефан Ð”Ð¶ÐµÐ¹Ð¼Ñ Ðž'БрайенÂ
Главный научный Ñотрудник, научный конÑультант Â
Стефан Ð”Ð¶ÐµÐ¹Ð¼Ñ Ðžâ€™Ð‘Ñ€Ð°Ð¹ÐµÐ½ руководил лабораторией геномного Ñ€Ð°Ð·Ð½Ð¾Ð¾Ð±Ñ€Ð°Ð·Ð¸Ñ Ðационального ...
Владимир БрюхинÂ
Ведущий научный Ñотрудник, И.о. руководителÑ
Владимир БориÑович Брюхин начал работу в Центре геномной биоинформатики им. ...
27 ÑентÑÐ±Ñ€Ñ 2019 (пÑтница) в 14:00: Dr. Kirill Vinnikov from Hawaii University (USA) and head of the lab at the Far Eastern Federal University (Vladivostok) "Exome sequencing of non-model species"
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1653736595,
"last": 1653736595,
"now": 1653736595
},
"client": {
"forwarded": "3.236.97.59"
},
"token": "1lDmL9h02dtJLtq3gKsJsx0fLt0UAF1S"
},
"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
},
"plg_system_languagefilter": {
"language": "ru-RU"
}
}
}
SELECT `data`
FROM `joo_session`
WHERE `session_id` = 'fabece2g8hgvoopsj4j3m7sqqq'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | joo_session | NULL | const | PRIMARY | PRIMARY | 766 | const | 1 | 100.00 | NULL |
| # | Вызывающий объект | Файл и номер строки |
|---|---|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
| 15 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/session/storage/database.php:45 |
| 14 | JSessionStorageDatabase->read() | Так же, как вызов в строке ниже. |
| 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:755 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:134 |
| 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:343 |
| 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 `joo_session`
WHERE `session_id` = 'fabece2g8hgvoopsj4j3m7sqqq'
LIMIT 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | joo_session | NULL | const | PRIMARY | PRIMARY | 766 | const | 1 | 100.00 | Using index |
| # | Вызывающий объект | Файл и номер строки |
|---|---|---|
| 9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
| 8 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Session/MetadataManager.php:74 |
| 7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:152 |
| 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:757 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:134 |
| 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:343 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
INSERT INTO `joo_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('fabece2g8hgvoopsj4j3m7sqqq', 1, '1653736595', 0, '', 0)
| # | Вызывающий объект | Файл и номер строки |
|---|---|---|
| 8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Session/MetadataManager.php:116 |
| 7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:152 |
| 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:757 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:134 |
| 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:343 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `joo_extensions`
WHERE `type` = 'component'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | joo_extensions | NULL | ref | extension | extension | 82 | const | 36 | 100.00 | NULL |
| # | Вызывающий объект | Файл и номер строки |
|---|---|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Component/ComponentHelper.php:423 |
| 10 | Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() | Так же, как вызов в строке ниже. |
| 9 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 8 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Component/ComponentHelper.php:431 |
| 7 | Joomla\CMS\Component\ComponentHelper::load() | JROOT/libraries/src/Component/ComponentHelper.php:497 |
| 6 | Joomla\CMS\Component\ComponentHelper::getComponents() | JROOT/libraries/src/Component/ComponentHelper.php:44 |
| 5 | Joomla\CMS\Component\ComponentHelper::getComponent() | JROOT/libraries/src/Component/ComponentHelper.php:103 |
| 4 | Joomla\CMS\Component\ComponentHelper::getParams() | JROOT/libraries/src/Application/SiteApplication.php:596 |
| 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:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT id, rules
FROM `joo_viewlevels`
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | joo_viewlevels | NULL | ALL | NULL | Индекс не используется | NULL | NULL | 5 | 100.00 | NULL |
| # | Вызывающий объект | Файл и номер строки |
|---|---|---|
| 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:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT b.id
FROM joo_usergroups AS a
LEFT JOIN joo_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
| 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 | 2 | 100.00 | Using where; Using index |
| # | Вызывающий объект | Файл и номер строки |
|---|---|---|
| 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:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM joo_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY ordering
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | joo_extensions | NULL | ref | extension | extension | 82 | const | 103 | 0.60 | Using index condition; Using where; Используется filesort |
| # | Вызывающий объект | Файл и номер строки |
|---|---|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Plugin/PluginHelper.php:343 |
| 9 | Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() | Так же, как вызов в строке ниже. |
| 8 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 7 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Plugin/PluginHelper.php:348 |
| 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:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM joo_languages
WHERE published=1
ORDER BY ordering ASC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | joo_languages | NULL | ALL | NULL | Индекс не используется | NULL | NULL | 2 | 50.00 | Using where; Используется filesort |
| # | Вызывающий объект | Файл и номер строки |
|---|---|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 9 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/LanguageHelper.php:150 |
| 8 | Joomla\CMS\Language\LanguageHelper::getLanguages() | JROOT/plugins/system/languagefilter/languagefilter.php:98 |
| 7 | PlgSystemLanguageFilter->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:272 |
| 6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:622 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:688 |
| 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:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `element`,`name`,`client_id`,`extension_id`
FROM `joo_extensions`
WHERE `type` = 'language'
AND `state` = 0
AND `enabled` = 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | joo_extensions | NULL | ref | extension | extension | 82 | const | 4 | 1.25 | Using where |
| # | Вызывающий объект | Файл и номер строки |
|---|---|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 9 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/LanguageHelper.php:209 |
| 8 | Joomla\CMS\Language\LanguageHelper::getInstalledLanguages() | JROOT/plugins/system/languagefilter/languagefilter.php:109 |
| 7 | PlgSystemLanguageFilter->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:272 |
| 6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:622 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:688 |
| 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:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM joo_menu AS m
LEFT JOIN joo_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | m | NULL | range | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 5 | NULL | 65 | 10.00 | Using index condition; Using where; Используется filesort |
| 1 | SIMPLE | e | NULL | eq_ref | PRIMARY | PRIMARY | 4 | dobzh_j.m.component_id | 1 | 100.00 | Using where |
| # | Вызывающий объект | Файл и номер строки |
|---|---|---|
| 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 22 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Menu/SiteMenu.php:93 |
| 21 | Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() | Так же, как вызов в строке ниже. |
| 20 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 19 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Menu/SiteMenu.php:101 |
| 18 | Joomla\CMS\Menu\SiteMenu->load() | JROOT/libraries/src/Menu/AbstractMenu.php:76 |
| 17 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT/libraries/src/Menu/SiteMenu.php:62 |
| 16 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT/libraries/src/Menu/AbstractMenu.php:131 |
| 15 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:374 |
| 14 | Joomla\CMS\Application\CMSApplication->getMenu() | JROOT/libraries/src/Application/SiteApplication.php:275 |
| 13 | Joomla\CMS\Application\SiteApplication->getMenu() | JROOT/libraries/src/Router/SiteRouter.php:64 |
| 12 | Joomla\CMS\Router\SiteRouter->__construct() | JROOT/libraries/src/Router/Router.php:189 |
| 11 | Joomla\CMS\Router\Router::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:488 |
| 10 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:405 |
| 9 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/plugins/system/languagefilter/languagefilter.php:130 |
| 8 | PlgSystemLanguageFilter->onAfterInitialise() | 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:623 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:688 |
| 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:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT id, home, template, s.params
FROM joo_template_styles as s
LEFT JOIN joo_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | s | NULL | ALL | idx_template | Индекс не используется | NULL | NULL | 5 | 20.00 | Using where |
| 1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid,extension | element_clientid | 403 | dobzh_j.s.template,const | 1 | 4.43 | Using index condition; Using where |
| # | Вызывающий объект | Файл и номер строки |
|---|---|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Application/SiteApplication.php:488 |
| 11 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT/plugins/system/jsntplframework/libraries/joomlashine/loader.php:33 |
| 10 | jsn_template_framework_class_loader() | Так же, как вызов в строке ниже. |
| 9 | spl_autoload_call() | JROOT/plugins/system/jsntplframework/jsntplframework.php:187 |
| 8 | PlgSystemJSNTPLFramework->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:1080 |
| 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:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT manifest_cache
FROM joo_extensions
WHERE element LIKE 'jsn_mico_pro'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | joo_extensions | NULL | range | element_clientid,element_folder_clientid | element_clientid | 402 | NULL | 3 | 100.00 | Using index condition |
| # | Вызывающий объект | Файл и номер строки |
|---|---|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
| 13 | JDatabaseDriver->loadResult() | JROOT/plugins/system/jsntplframework/libraries/joomlashine/helper.php:122 |
| 12 | JSNTplHelper::getManifestCache() | JROOT/plugins/system/jsntplframework/libraries/joomlashine/helper.php:217 |
| 11 | JSNTplHelper::getTemplateVersion() | JROOT/plugins/system/jsntplframework/libraries/joomlashine/loader.php:35 |
| 10 | jsn_template_framework_class_loader() | Так же, как вызов в строке ниже. |
| 9 | spl_autoload_call() | JROOT/plugins/system/jsntplframework/jsntplframework.php:187 |
| 8 | PlgSystemJSNTPLFramework->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:1080 |
| 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:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT COUNT(*)
FROM joo_extensions
WHERE type = 'component'
AND element = 'com_sh404sef'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | joo_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | 10.00 | Using where |
| # | Вызывающий объект | Файл и номер строки |
|---|---|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
| 11 | JDatabaseDriver->loadResult() | JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:1166 |
| 10 | JSNTplUtils->checkSH404SEF() | JROOT/plugins/system/jsntplframework/includes/core/jsntplframework.php:36 |
| 9 | JSNTPLFramework::initial() | JROOT/plugins/system/jsntplframework/jsntplframework.php:191 |
| 8 | PlgSystemJSNTPLFramework->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:1080 |
| 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:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `joo_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | joo_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | NULL |
| # | Вызывающий объект | Файл и номер строки |
|---|---|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
| 14 | JDatabaseDriver->loadObject() | JROOT/libraries/src/Helper/LibraryHelper.php:167 |
| 13 | Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() | Так же, как вызов в строке ниже. |
| 12 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 11 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/LibraryHelper.php:175 |
| 10 | Joomla\CMS\Helper\LibraryHelper::loadLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:43 |
| 9 | Joomla\CMS\Helper\LibraryHelper::getLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:90 |
| 8 | Joomla\CMS\Helper\LibraryHelper::getParams() | JROOT/libraries/src/Version.php:321 |
| 7 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
| 6 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
| 5 | Joomla\CMS\Factory::getDocument() | JROOT/libraries/src/Application/WebApplication.php:1113 |
| 4 | Joomla\CMS\Application\WebApplication->loadDocument() | JROOT/libraries/src/Application/SiteApplication.php:133 |
| 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:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
UPDATE `joo_extensions`
SET `params` = '{\"mediaversion\":\"7abaafe14edfe41ea66148677ad6975d\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | UPDATE | joo_extensions | NULL | range | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | Using where |
| # | Вызывающий объект | Файл и номер строки |
|---|---|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 |
| 9 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 |
| 8 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 |
| 7 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
| 6 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
| 5 | Joomla\CMS\Factory::getDocument() | JROOT/libraries/src/Application/WebApplication.php:1113 |
| 4 | Joomla\CMS\Application\WebApplication->loadDocument() | JROOT/libraries/src/Application/SiteApplication.php:133 |
| 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:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `id`,`name`,`rules`,`parent_id`
FROM `joo_assets`
WHERE `name` IN ('root.1','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_formmaker','com_imageshow','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper')
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | joo_assets | NULL | range | idx_asset_name | idx_asset_name | 202 | NULL | 37 | 100.00 | Using index condition |
| # | Вызывающий объект | Файл и номер строки |
|---|---|---|
| 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/articles.php:113 |
| 14 | ContentModelArticles->populateState() | JROOT/components/com_content/models/featured.php:44 |
| 13 | ContentModelFeatured->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435 |
| 12 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:398 |
| 11 | JViewLegacy->get() | JROOT/components/com_content/views/featured/view.html.php:54 |
| 10 | ContentViewFeatured->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 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:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN 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,fp.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 joo_content AS a
INNER JOIN joo_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN joo_categories AS c
ON c.id = a.catid
LEFT JOIN joo_users AS ua
ON ua.id = a.created_by
LEFT JOIN joo_users AS uam
ON uam.id = a.modified_by
LEFT JOIN joo_categories as parent
ON parent.id = c.parent_id
LEFT JOIN joo_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-05-28 11:16:35')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-05-28 11:16:35')
AND a.language IN ('ru-RU','*')
ORDER BY c.lft, a.featured DESC, fp.ordering,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created DESC
LIMIT 4
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | fp | NULL | ALL | PRIMARY | Индекс не используется | NULL | NULL | 3 | 100.00 | Using temporary; Используется filesort |
| 1 | SIMPLE | a | NULL | eq_ref | PRIMARY,idx_access,idx_state,idx_catid,idx_language | PRIMARY | 4 | dobzh_j.fp.content_id | 1 | 9.71 | Using where |
| 1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | dobzh_j.a.created_by | 1 | 100.00 | Using where |
| 1 | SIMPLE | uam | NULL | eq_ref | PRIMARY | PRIMARY | 4 | dobzh_j.a.modified_by | 1 | 100.00 | Using where |
| 1 | SIMPLE | c | NULL | eq_ref | PRIMARY,idx_access | PRIMARY | 4 | dobzh_j.a.catid | 1 | 10.00 | Using where |
| 1 | SIMPLE | parent | NULL | eq_ref | PRIMARY | PRIMARY | 4 | dobzh_j.c.parent_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | v | NULL | eq_ref | PRIMARY | PRIMARY | 4 | dobzh_j.a.id | 1 | 100.00 | Using where |
| # | Вызывающий объект | Файл и номер строки |
|---|---|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
| 15 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
| 14 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_content/models/articles.php:559 |
| 13 | ContentModelArticles->getItems() | JROOT/components/com_content/models/featured.php:125 |
| 12 | ContentModelFeatured->getItems() | JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:398 |
| 11 | JViewLegacy->get() | JROOT/components/com_content/views/featured/view.html.php:55 |
| 10 | ContentViewFeatured->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 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:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT COUNT(*)
FROM joo_content AS a
INNER JOIN joo_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN joo_categories AS c
ON c.id = a.catid
LEFT JOIN joo_users AS ua
ON ua.id = a.created_by
LEFT JOIN joo_users AS uam
ON uam.id = a.modified_by
LEFT JOIN joo_categories as parent
ON parent.id = c.parent_id
LEFT JOIN joo_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-05-28 11:16:35')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-05-28 11:16:35')
AND a.language IN ('ru-RU','*')
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | fp | NULL | index | PRIMARY | PRIMARY | 4 | NULL | 3 | 100.00 | Using index |
| 1 | SIMPLE | a | NULL | eq_ref | PRIMARY,idx_access,idx_state,idx_catid,idx_language | PRIMARY | 4 | dobzh_j.fp.content_id | 1 | 9.71 | Using where |
| 1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | dobzh_j.a.created_by | 1 | 100.00 | Using where; Using index |
| 1 | SIMPLE | uam | NULL | eq_ref | PRIMARY | PRIMARY | 4 | dobzh_j.a.modified_by | 1 | 100.00 | Using where; Using index |
| 1 | SIMPLE | c | NULL | eq_ref | PRIMARY,idx_access | PRIMARY | 4 | dobzh_j.a.catid | 1 | 10.00 | Using where |
| 1 | SIMPLE | parent | NULL | eq_ref | PRIMARY | PRIMARY | 4 | dobzh_j.c.parent_id | 1 | 100.00 | Using where; Using index |
| 1 | SIMPLE | v | NULL | eq_ref | PRIMARY | PRIMARY | 4 | dobzh_j.a.id | 1 | 100.00 | Using where; Using index |
| # | Вызывающий объект | Файл и номер строки |
|---|---|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
| 15 | JDatabaseDriver->loadResult() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:335 |
| 14 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() | JROOT/libraries/src/MVC/Model/ListModel.php:282 |
| 13 | Joomla\CMS\MVC\Model\ListModel->getTotal() | JROOT/libraries/src/MVC/Model/ListModel.php:232 |
| 12 | Joomla\CMS\MVC\Model\ListModel->getPagination() | JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:398 |
| 11 | JViewLegacy->get() | JROOT/components/com_content/views/featured/view.html.php:56 |
| 10 | ContentViewFeatured->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 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:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SHOW TABLES LIKE 'joo_fields'
| # | Вызывающий объект | Файл и номер строки |
|---|---|---|
| 31 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
| 30 | JDatabaseDriver->loadResult() | JROOT/libraries/regularlabs/src/DB.php:47 |
| 29 | RegularLabs\Library\DB::tableExists() | JROOT/plugins/system/articlesanywhere/src/Collection/Fields/CustomFields.php:31 |
| 28 | RegularLabs\Plugin\System\ArticlesAnywhere\Collection\Fields\CustomFields->getAvailableFields() | JROOT/plugins/system/articlesanywhere/src/PluginTags/Selects.php:30 |
| 27 | RegularLabs\Plugin\System\ArticlesAnywhere\PluginTags\Selects->__construct() | JROOT/plugins/system/articlesanywhere/src/PluginTags/PluginTag.php:168 |
| 26 | RegularLabs\Plugin\System\ArticlesAnywhere\PluginTags\PluginTag->getSet() | JROOT/plugins/system/articlesanywhere/src/PluginTags/PluginTag.php:142 |
| 25 | RegularLabs\Plugin\System\ArticlesAnywhere\PluginTags\PluginTag->getSets() | JROOT/plugins/system/articlesanywhere/src/PluginTags/PluginTag.php:55 |
| 24 | RegularLabs\Plugin\System\ArticlesAnywhere\PluginTags\PluginTag->getOutput() | JROOT/plugins/system/articlesanywhere/src/Replace.php:210 |
| 23 | RegularLabs\Plugin\System\ArticlesAnywhere\Replace::replaceTagsInString() | JROOT/plugins/system/articlesanywhere/src/Replace.php:197 |
| 22 | RegularLabs\Plugin\System\ArticlesAnywhere\Replace::process() | JROOT/plugins/system/articlesanywhere/src/Replace.php:88 |
| 21 | RegularLabs\Plugin\System\ArticlesAnywhere\Replace::replaceTags() | JROOT/plugins/system/articlesanywhere/src/Helper.php:81 |
| 20 | RegularLabs\Plugin\System\ArticlesAnywhere\Helper->replaceTags() | Так же, как вызов в строке ниже. |
| 19 | call_user_func_array() | JROOT/libraries/regularlabs/src/Article.php:190 |
| 18 | RegularLabs\Library\Article::processText() | JROOT/libraries/regularlabs/src/Article.php:167 |
| 17 | RegularLabs\Library\Article::process() | JROOT/plugins/system/articlesanywhere/src/Helper.php:31 |
| 16 | RegularLabs\Plugin\System\ArticlesAnywhere\Helper->onContentPrepare() | Так же, как вызов в строке ниже. |
| 15 | call_user_func_array() | JROOT/plugins/system/articlesanywhere/src/Plugin.php:97 |
| 14 | RegularLabs\Plugin\System\ArticlesAnywhere\Plugin->run() | JROOT/plugins/system/articlesanywhere/articlesanywhere.php:51 |
| 13 | PlgSystemArticlesAnywhere->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/featured/view.html.php:98 |
| 10 | ContentViewFeatured->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 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:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `id`,`name`
FROM `joo_fields`
WHERE `context` = 'com_content.article'
AND `state` = 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | joo_fields | NULL | ref | idx_state,idx_context | idx_context | 766 | const | 1 | 100.00 | Using where |
| # | Вызывающий объект | Файл и номер строки |
|---|---|---|
| 32 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1496 |
| 31 | JDatabaseDriver->loadAssocList() | Так же, как вызов в строке ниже. |
| 30 | call_user_func_array() | JROOT/plugins/system/articlesanywhere/src/Collection/DB.php:43 |
| 29 | RegularLabs\Plugin\System\ArticlesAnywhere\Collection\DB::getResults() | JROOT/plugins/system/articlesanywhere/src/Collection/Fields/CustomFields.php:43 |
| 28 | RegularLabs\Plugin\System\ArticlesAnywhere\Collection\Fields\CustomFields->getAvailableFields() | JROOT/plugins/system/articlesanywhere/src/PluginTags/Selects.php:30 |
| 27 | RegularLabs\Plugin\System\ArticlesAnywhere\PluginTags\Selects->__construct() | JROOT/plugins/system/articlesanywhere/src/PluginTags/PluginTag.php:168 |
| 26 | RegularLabs\Plugin\System\ArticlesAnywhere\PluginTags\PluginTag->getSet() | JROOT/plugins/system/articlesanywhere/src/PluginTags/PluginTag.php:142 |
| 25 | RegularLabs\Plugin\System\ArticlesAnywhere\PluginTags\PluginTag->getSets() | JROOT/plugins/system/articlesanywhere/src/PluginTags/PluginTag.php:55 |
| 24 | RegularLabs\Plugin\System\ArticlesAnywhere\PluginTags\PluginTag->getOutput() | JROOT/plugins/system/articlesanywhere/src/Replace.php:210 |
| 23 | RegularLabs\Plugin\System\ArticlesAnywhere\Replace::replaceTagsInString() | JROOT/plugins/system/articlesanywhere/src/Replace.php:197 |
| 22 | RegularLabs\Plugin\System\ArticlesAnywhere\Replace::process() | JROOT/plugins/system/articlesanywhere/src/Replace.php:88 |
| 21 | RegularLabs\Plugin\System\ArticlesAnywhere\Replace::replaceTags() | JROOT/plugins/system/articlesanywhere/src/Helper.php:81 |
| 20 | RegularLabs\Plugin\System\ArticlesAnywhere\Helper->replaceTags() | Так же, как вызов в строке ниже. |
| 19 | call_user_func_array() | JROOT/libraries/regularlabs/src/Article.php:190 |
| 18 | RegularLabs\Library\Article::processText() | JROOT/libraries/regularlabs/src/Article.php:167 |
| 17 | RegularLabs\Library\Article::process() | JROOT/plugins/system/articlesanywhere/src/Helper.php:31 |
| 16 | RegularLabs\Plugin\System\ArticlesAnywhere\Helper->onContentPrepare() | Так же, как вызов в строке ниже. |
| 15 | call_user_func_array() | JROOT/plugins/system/articlesanywhere/src/Plugin.php:97 |
| 14 | RegularLabs\Plugin\System\ArticlesAnywhere\Plugin->run() | JROOT/plugins/system/articlesanywhere/articlesanywhere.php:51 |
| 13 | PlgSystemArticlesAnywhere->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/featured/view.html.php:98 |
| 10 | ContentViewFeatured->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 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:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SHOW FULL COLUMNS
FROM `joo_content`
| # | Вызывающий объект | Файл и номер строки |
|---|---|---|
| 31 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 30 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:430 |
| 29 | JDatabaseDriverMysqli->getTableColumns() | JROOT/plugins/system/articlesanywhere/src/Collection/Fields/Fields.php:33 |
| 28 | RegularLabs\Plugin\System\ArticlesAnywhere\Collection\Fields\Fields->getAvailableFields() | JROOT/plugins/system/articlesanywhere/src/PluginTags/Selects.php:31 |
| 27 | RegularLabs\Plugin\System\ArticlesAnywhere\PluginTags\Selects->__construct() | JROOT/plugins/system/articlesanywhere/src/PluginTags/PluginTag.php:168 |
| 26 | RegularLabs\Plugin\System\ArticlesAnywhere\PluginTags\PluginTag->getSet() | JROOT/plugins/system/articlesanywhere/src/PluginTags/PluginTag.php:142 |
| 25 | RegularLabs\Plugin\System\ArticlesAnywhere\PluginTags\PluginTag->getSets() | JROOT/plugins/system/articlesanywhere/src/PluginTags/PluginTag.php:55 |
| 24 | RegularLabs\Plugin\System\ArticlesAnywhere\PluginTags\PluginTag->getOutput() | JROOT/plugins/system/articlesanywhere/src/Replace.php:210 |
| 23 | RegularLabs\Plugin\System\ArticlesAnywhere\Replace::replaceTagsInString() | JROOT/plugins/system/articlesanywhere/src/Replace.php:197 |
| 22 | RegularLabs\Plugin\System\ArticlesAnywhere\Replace::process() | JROOT/plugins/system/articlesanywhere/src/Replace.php:88 |
| 21 | RegularLabs\Plugin\System\ArticlesAnywhere\Replace::replaceTags() | JROOT/plugins/system/articlesanywhere/src/Helper.php:81 |
| 20 | RegularLabs\Plugin\System\ArticlesAnywhere\Helper->replaceTags() | Так же, как вызов в строке ниже. |
| 19 | call_user_func_array() | JROOT/libraries/regularlabs/src/Article.php:190 |
| 18 | RegularLabs\Library\Article::processText() | JROOT/libraries/regularlabs/src/Article.php:167 |
| 17 | RegularLabs\Library\Article::process() | JROOT/plugins/system/articlesanywhere/src/Helper.php:31 |
| 16 | RegularLabs\Plugin\System\ArticlesAnywhere\Helper->onContentPrepare() | Так же, как вызов в строке ниже. |
| 15 | call_user_func_array() | JROOT/plugins/system/articlesanywhere/src/Plugin.php:97 |
| 14 | RegularLabs\Plugin\System\ArticlesAnywhere\Plugin->run() | JROOT/plugins/system/articlesanywhere/articlesanywhere.php:51 |
| 13 | PlgSystemArticlesAnywhere->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/featured/view.html.php:98 |
| 10 | ContentViewFeatured->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 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:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `items`.`id`
FROM `joo_content` AS `items`
WHERE (`title` = 'О нас' OR `alias` = 'О нас')
AND `items`.`state` = 1
AND ( `items`.`publish_up` <= '2022-05-28 11:16:35' )
AND ( `items`.`publish_down` = '0000-00-00 00:00:00' OR `items`.`publish_down` >= '2022-05-28 11:16:35' )
AND `items`.`access` IN ('1','1','5')
AND `items`.`language` IN ('ru-RU','*')
GROUP BY `items`.`id`
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | items | NULL | ref | PRIMARY,idx_access,idx_checkout,idx_state,idx_catid,idx_createdby,idx_featured_catid,idx_language,idx_xreference,idx_alias | idx_state | 1 | const | 189 | 0.85 | Using index condition; Using where |
| # | Вызывающий объект | Файл и номер строки |
|---|---|---|
| 31 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1540 |
| 30 | JDatabaseDriver->loadColumn() | Так же, как вызов в строке ниже. |
| 29 | call_user_func_array() | JROOT/plugins/system/articlesanywhere/src/Collection/DB.php:43 |
| 28 | RegularLabs\Plugin\System\ArticlesAnywhere\Collection\DB::getResults() | JROOT/plugins/system/articlesanywhere/src/Collection/Collection.php:97 |
| 27 | RegularLabs\Plugin\System\ArticlesAnywhere\Collection\Collection->getIds() | JROOT/plugins/system/articlesanywhere/src/Collection/Collection.php:42 |
| 26 | RegularLabs\Plugin\System\ArticlesAnywhere\Collection\Collection->getOnlyIds() | JROOT/plugins/system/articlesanywhere/src/PluginTags/PluginTag.php:78 |
| 25 | RegularLabs\Plugin\System\ArticlesAnywhere\PluginTags\PluginTag->getIdsBySet() | JROOT/plugins/system/articlesanywhere/src/PluginTags/PluginTag.php:66 |
| 24 | RegularLabs\Plugin\System\ArticlesAnywhere\PluginTags\PluginTag->getOutput() | JROOT/plugins/system/articlesanywhere/src/Replace.php:210 |
| 23 | RegularLabs\Plugin\System\ArticlesAnywhere\Replace::replaceTagsInString() | JROOT/plugins/system/articlesanywhere/src/Replace.php:197 |
| 22 | RegularLabs\Plugin\System\ArticlesAnywhere\Replace::process() | JROOT/plugins/system/articlesanywhere/src/Replace.php:88 |
| 21 | RegularLabs\Plugin\System\ArticlesAnywhere\Replace::replaceTags() | JROOT/plugins/system/articlesanywhere/src/Helper.php:81 |
| 20 | RegularLabs\Plugin\System\ArticlesAnywhere\Helper->replaceTags() | Так же, как вызов в строке ниже. |
| 19 | call_user_func_array() | JROOT/libraries/regularlabs/src/Article.php:190 |
| 18 | RegularLabs\Library\Article::processText() | JROOT/libraries/regularlabs/src/Article.php:167 |
| 17 | RegularLabs\Library\Article::process() | JROOT/plugins/system/articlesanywhere/src/Helper.php:31 |
| 16 | RegularLabs\Plugin\System\ArticlesAnywhere\Helper->onContentPrepare() | Так же, как вызов в строке ниже. |
| 15 | call_user_func_array() | JROOT/plugins/system/articlesanywhere/src/Plugin.php:97 |
| 14 | RegularLabs\Plugin\System\ArticlesAnywhere\Plugin->run() | JROOT/plugins/system/articlesanywhere/articlesanywhere.php:51 |
| 13 | PlgSystemArticlesAnywhere->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/featured/view.html.php:98 |
| 10 | ContentViewFeatured->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 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:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT items.*,`categories`.`id` AS `category_id`,`categories`.`title` AS `category_title`,`categories`.`alias` AS `category_alias`,`categories`.`description` AS `category_description`,`categories`.`params` AS `category_params`
FROM `joo_content` AS `items`
LEFT JOIN `joo_categories` AS `categories`
ON `categories`.`id` = `items`.`catid`
WHERE `items`.`id` = '43'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | items | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | categories | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| # | Вызывающий объект | Файл и номер строки |
|---|---|---|
| 30 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 29 | JDatabaseDriver->loadObjectList() | Так же, как вызов в строке ниже. |
| 28 | call_user_func_array() | JROOT/plugins/system/articlesanywhere/src/Collection/DB.php:43 |
| 27 | RegularLabs\Plugin\System\ArticlesAnywhere\Collection\DB::getResults() | JROOT/plugins/system/articlesanywhere/src/Collection/Collection.php:131 |
| 26 | RegularLabs\Plugin\System\ArticlesAnywhere\Collection\Collection->getData() | JROOT/plugins/system/articlesanywhere/src/Collection/Collection.php:53 |
| 25 | RegularLabs\Plugin\System\ArticlesAnywhere\Collection\Collection->getOutputByIds() | JROOT/plugins/system/articlesanywhere/src/PluginTags/PluginTag.php:71 |
| 24 | RegularLabs\Plugin\System\ArticlesAnywhere\PluginTags\PluginTag->getOutput() | JROOT/plugins/system/articlesanywhere/src/Replace.php:210 |
| 23 | RegularLabs\Plugin\System\ArticlesAnywhere\Replace::replaceTagsInString() | JROOT/plugins/system/articlesanywhere/src/Replace.php:197 |
| 22 | RegularLabs\Plugin\System\ArticlesAnywhere\Replace::process() | JROOT/plugins/system/articlesanywhere/src/Replace.php:88 |
| 21 | RegularLabs\Plugin\System\ArticlesAnywhere\Replace::replaceTags() | JROOT/plugins/system/articlesanywhere/src/Helper.php:81 |
| 20 | RegularLabs\Plugin\System\ArticlesAnywhere\Helper->replaceTags() | Так же, как вызов в строке ниже. |
| 19 | call_user_func_array() | JROOT/libraries/regularlabs/src/Article.php:190 |
| 18 | RegularLabs\Library\Article::processText() | JROOT/libraries/regularlabs/src/Article.php:167 |
| 17 | RegularLabs\Library\Article::process() | JROOT/plugins/system/articlesanywhere/src/Helper.php:31 |
| 16 | RegularLabs\Plugin\System\ArticlesAnywhere\Helper->onContentPrepare() | Так же, как вызов в строке ниже. |
| 15 | call_user_func_array() | JROOT/plugins/system/articlesanywhere/src/Plugin.php:97 |
| 14 | RegularLabs\Plugin\System\ArticlesAnywhere\Plugin->run() | JROOT/plugins/system/articlesanywhere/articlesanywhere.php:51 |
| 13 | PlgSystemArticlesAnywhere->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/featured/view.html.php:98 |
| 10 | ContentViewFeatured->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 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:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SHOW FULL COLUMNS
FROM `joo_content`
| # | Вызывающий объект | Файл и номер строки |
|---|---|---|
| 40 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 39 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:430 |
| 38 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
| 37 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
| 36 | Joomla\CMS\Table\Table->__construct() | JROOT/libraries/src/Table/Content.php:39 |
| 35 | Joomla\CMS\Table\Content->__construct() | JROOT/libraries/src/Table/Table.php:312 |
| 34 | Joomla\CMS\Table\Table::getInstance() | JROOT/plugins/system/articlesanywhere/src/Helpers/article_model.php:273 |
| 33 | ArticlesAnywhereArticleModel->hit() | JROOT/plugins/system/articlesanywhere/src/Collection/Item.php:164 |
| 32 | RegularLabs\Plugin\System\ArticlesAnywhere\Collection\Item->hit() | JROOT/plugins/system/articlesanywhere/src/Output/Values.php:83 |
| 31 | RegularLabs\Plugin\System\ArticlesAnywhere\Output\Values->get() | JROOT/plugins/system/articlesanywhere/src/Output/DataTags.php:70 |
| 30 | RegularLabs\Plugin\System\ArticlesAnywhere\Output\DataTags->getValueFromTag() | JROOT/plugins/system/articlesanywhere/src/Output/DataTags.php:49 |
| 29 | RegularLabs\Plugin\System\ArticlesAnywhere\Output\DataTags->handle() | JROOT/plugins/system/articlesanywhere/src/Output/Output.php:117 |
| 28 | RegularLabs\Plugin\System\ArticlesAnywhere\Output\Output->renderOutput() | JROOT/plugins/system/articlesanywhere/src/Output/Output.php:56 |
| 27 | RegularLabs\Plugin\System\ArticlesAnywhere\Output\Output->get() | JROOT/plugins/system/articlesanywhere/src/Collection/Collection.php:83 |
| 26 | RegularLabs\Plugin\System\ArticlesAnywhere\Collection\Collection->getOutput() | JROOT/plugins/system/articlesanywhere/src/Collection/Collection.php:59 |
| 25 | RegularLabs\Plugin\System\ArticlesAnywhere\Collection\Collection->getOutputByIds() | JROOT/plugins/system/articlesanywhere/src/PluginTags/PluginTag.php:71 |
| 24 | RegularLabs\Plugin\System\ArticlesAnywhere\PluginTags\PluginTag->getOutput() | JROOT/plugins/system/articlesanywhere/src/Replace.php:210 |
| 23 | RegularLabs\Plugin\System\ArticlesAnywhere\Replace::replaceTagsInString() | JROOT/plugins/system/articlesanywhere/src/Replace.php:197 |
| 22 | RegularLabs\Plugin\System\ArticlesAnywhere\Replace::process() | JROOT/plugins/system/articlesanywhere/src/Replace.php:88 |
| 21 | RegularLabs\Plugin\System\ArticlesAnywhere\Replace::replaceTags() | JROOT/plugins/system/articlesanywhere/src/Helper.php:81 |
| 20 | RegularLabs\Plugin\System\ArticlesAnywhere\Helper->replaceTags() | Так же, как вызов в строке ниже. |
| 19 | call_user_func_array() | JROOT/libraries/regularlabs/src/Article.php:190 |
| 18 | RegularLabs\Library\Article::processText() | JROOT/libraries/regularlabs/src/Article.php:167 |
| 17 | RegularLabs\Library\Article::process() | JROOT/plugins/system/articlesanywhere/src/Helper.php:31 |
| 16 | RegularLabs\Plugin\System\ArticlesAnywhere\Helper->onContentPrepare() | Так же, как вызов в строке ниже. |
| 15 | call_user_func_array() | JROOT/plugins/system/articlesanywhere/src/Plugin.php:97 |
| 14 | RegularLabs\Plugin\System\ArticlesAnywhere\Plugin->run() | JROOT/plugins/system/articlesanywhere/articlesanywhere.php:51 |
| 13 | PlgSystemArticlesAnywhere->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/featured/view.html.php:98 |
| 10 | ContentViewFeatured->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 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\SiteApp |