Yakiev
Включить/выключить навигацию
  • Блог
  • Общая информация
  • Авторизация

Home

sGerh seh

  • Печать
Информация о материале
Автор: Super User
Категория: Uncategorised
Опубликовано: 10 сентября 2020
Просмотров: 1029

sth strj s

  • Вы здесь:  
  • Главная

Main Menu

  • Home

Старые материалы

  • Добро пожаловать в ваш блог
  • О главной странице
  • Ваши модули
  • Ваш шаблон

Популярные материалы

  • Добро пожаловать в ваш блог
  • Ваши модули
  • О главной странице
  • Ваш шаблон
feed-image My Blog

Login Form

  • Забыли логин?
  • Забыли пароль?

  • Авторизация

Наверх

© 2021 Yakiev

Консоль отладки Joomla!

Сессия

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1614670052,
                "last": 1614670052,
                "now": 1614670052
            },
            "token": "JoZaj8qwC85p8i0EgkT0JlslOG6ZfGQi"
        },
        "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
        }
    }
}

Результаты профилирования

Время

Память

Время: 1.72 ms / 1.72 ms Память: 0.397 MB / 0.74 MB Application: afterLoad
Время: 16.66 ms / 18.38 ms Память: 0.902 MB / 1.64 MB Application: afterInitialise
Время: 2.47 ms / 20.85 ms Память: 0.207 MB / 1.85 MB Application: afterRoute
Время: 2.00 ms / 22.85 ms Память: 0.048 MB / 1.90 MB Application: beforeRenderComponent com_content
Время: 2.10 ms / 24.95 ms Память: 0.158 MB / 2.05 MB Application: Before Access::preloadComponents (all components)
Время: 0.94 ms / 25.89 ms Память: 0.052 MB / 2.11 MB Application: After Access::preloadComponents (all components)
Время: 0.03 ms / 25.92 ms Память: 0.000 MB / 2.10 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Время: 0.17 ms / 26.09 ms Память: 0.008 MB / 2.11 MB Application: After Access::getAssetRules (id:8 name:com_content)
Время: 93.72 ms / 119.81 ms Память: 0.537 MB / 2.65 MB Application: afterRenderComponent com_content
Время: 1.08 ms / 120.89 ms Память: 0.007 MB / 2.66 MB Application: afterDispatch
Время: 84.05 ms / 204.94 ms Память: 1.140 MB / 3.80 MB Application: beforeRenderModule mod_menu (Нижнее меню)
Время: 71.02 ms / 275.96 ms Память: 0.015 MB / 3.81 MB Application: afterRenderModule mod_menu (Нижнее меню)
Время: 144.93 ms / 420.89 ms Память: 0.010 MB / 3.82 MB Application: beforeRenderModule mod_menu (Main Menu)
Время: 68.95 ms / 489.84 ms Память: 0.005 MB / 3.83 MB Application: afterRenderModule mod_menu (Main Menu)
Время: 67.60 ms / 557.45 ms Память: 0.000 MB / 3.81 MB Application: beforeRenderModule mod_tags_popular (Популярные метки)
Время: 70.59 ms / 628.03 ms Память: 0.022 MB / 3.83 MB Application: afterRenderModule mod_tags_popular (Популярные метки)
Время: 0.09 ms / 628.12 ms Память: 0.001 MB / 3.83 MB Application: beforeRenderModule mod_articles_category (Старые материалы)
Время: 74.57 ms / 702.69 ms Память: 0.123 MB / 3.95 MB Application: afterRenderModule mod_articles_category (Старые материалы)
Время: 0.45 ms / 703.14 ms Память: 0.000 MB / 3.90 MB Application: beforeRenderModule mod_articles_archive (Архивные материалы)
Время: 2.36 ms / 705.50 ms Память: 0.011 MB / 3.91 MB Application: afterRenderModule mod_articles_archive (Архивные материалы)
Время: 67.51 ms / 773.00 ms Память: 0.001 MB / 3.91 MB Application: beforeRenderModule mod_articles_popular (Популярные материалы)
Время: 4.09 ms / 777.09 ms Память: 0.089 MB / 4.00 MB Application: afterRenderModule mod_articles_popular (Популярные материалы)
Время: 72.60 ms / 849.69 ms Память: 0.000 MB / 3.93 MB Application: beforeRenderModule mod_syndicate (Лента новостей)
Время: 3.35 ms / 853.03 ms Память: 0.006 MB / 3.93 MB Application: afterRenderModule mod_syndicate (Лента новостей)
Время: 0.05 ms / 853.08 ms Память: 0.000 MB / 3.93 MB Application: beforeRenderModule mod_login (Login Form)
Время: 4.94 ms / 858.02 ms Память: 0.021 MB / 3.95 MB Application: afterRenderModule mod_login (Login Form)
Время: 78.59 ms / 936.61 ms Память: 0.028 MB / 3.98 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Время: 1.43 ms / 938.04 ms Память: 0.009 MB / 3.99 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Время: 78.02 ms / 1016.05 ms Память: 0.035 MB / 4.02 MB Application: beforeRenderModule mod_custom (Изображение)
Время: 3.89 ms / 1019.94 ms Память: 0.014 MB / 4.04 MB Application: afterRenderModule mod_custom (Изображение)
Время: 188.87 ms / 1208.81 ms Память: 0.030 MB / 4.07 MB Application: beforeRenderModule mod_menu (Главное меню блога)
Время: 56.18 ms / 1264.99 ms Память: 0.014 MB / 4.08 MB Application: afterRenderModule mod_menu (Главное меню блога)
Время: 110.54 ms / 1375.53 ms Память: 0.016 MB / 4.10 MB Application: beforeRenderModule mod_search (Поиск)
Время: 0.61 ms / 1376.14 ms Память: 0.017 MB / 4.11 MB Application: afterRenderModule mod_search (Поиск)
Время: 106.59 ms / 1482.73 ms Память: 0.000 MB / 2.97 MB Application: afterRender

Всего SQL-запросов: 16.30 ms

Использование памяти

3.25 MB (3 407 672 Байт)

Запросы к базе данных

Зафиксировано 17 SQL-запросов 16.30 ms


  1. Время запроса: 0.48 ms Память запроса: 0.020 MB Память до запроса: 1.090 MB Выбрано строк: 0
    SELECT `session_id`
    
      FROM `jom_session`
      WHERE `session_id` = X'726d36743039706e6f6e6e6d3030396d627662766668716a6e70'
      LIMIT 1
    План SQL-запросов (Explain)
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjom_sessionconstPRIMARYPRIMARY194const1Using index
    Профилирование SQL-запросов
    StatusDuration
    Starting0.07 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.02 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.03 ms
    Optimizing0.02 ms
    Statistics0.08 ms
    Preparing0.02 ms
    Executing0.02 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.01 ms
    Стек вызовов
    #Вызывающий объектФайл и номер строки
    9JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    8JDatabaseDriver->loadResult()JROOT/libraries/src/Session/MetadataManager.php:74
    7Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()JROOT/libraries/src/Application/CMSApplication.php:153
    6Joomla\CMS\Application\CMSApplication->checkSession()JROOT/libraries/src/Application/CMSApplication.php:760
    5Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:135
    4Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:66
    3Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:344
    2Joomla\CMS\Application\CMSApplication::getInstance()JROOT/libraries/src/Factory.php:140
    1Joomla\CMS\Factory::getApplication()JROOT/index.php:46
    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

  2. Время запроса: 0.45 ms После последнего запроса: 0.11 ms Память запроса: 0.004 MB Память до запроса: 1.096 MB
    INSERT INTO `jom_session`
    (`session_id`,`guest`,`time`,`userid`,`username`) 
      VALUES (X'726d36743039706e6f6e6e6d3030396d627662766668716a6e70', 1, 1614670052, 0, '')
    План SQL-запросов (Explain)
    EXPLAIN недоступен для запроса: INSERT INTO `jom_session` (`session_id`,`guest`,`time`,`userid`,`username`) VALUES (X'726d36743039706e6f6e6e6d3030396d627662766668716a6e70', 1, 1614670052, 0, '')
    Профилирование SQL-запросов
    StatusDuration
    Starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init for update0.02 ms
    Update0.09 ms
    End of update loop0.02 ms
    Query end0.01 ms
    Commit0.06 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.01 ms
    Стек вызовов
    #Вызывающий объектФайл и номер строки
    8JDatabaseDriverMysqli->execute()JROOT/libraries/src/Session/MetadataManager.php:116
    7Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()JROOT/libraries/src/Application/CMSApplication.php:153
    6Joomla\CMS\Application\CMSApplication->checkSession()JROOT/libraries/src/Application/CMSApplication.php:760
    5Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:135
    4Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:66
    3Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:344
    2Joomla\CMS\Application\CMSApplication::getInstance()JROOT/libraries/src/Factory.php:140
    1Joomla\CMS\Factory::getApplication()JROOT/index.php:46
    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

  3. Время запроса: 0.38 ms После последнего запроса: 1.03 ms Память запроса: 0.021 MB Память до запроса: 1.179 MB Выбрано строк: 5
    SELECT id, rules
    
      FROM `jom_viewlevels`
    План SQL-запросов (Explain)
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjom_viewlevelsALLNULLИндекс не используетсяNULLNULL5
    Профилирование SQL-запросов
    StatusDuration
    Starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.02 ms
    Optimizing0.02 ms
    Statistics0.02 ms
    Preparing0.02 ms
    Executing0.01 ms
    Sending data0.05 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.01 ms
    Стек вызовов
    #Вызывающий объектФайл и номер строки
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1506
    9JDatabaseDriver->loadAssocList()JROOT/libraries/src/Access/Access.php:1063
    8Joomla\CMS\Access\Access::getAuthorisedViewLevels()JROOT/libraries/src/User/User.php:458
    7Joomla\CMS\User\User->getAuthorisedViewLevels()JROOT/libraries/src/Plugin/PluginHelper.php:321
    6Joomla\CMS\Plugin\PluginHelper::load()JROOT/libraries/src/Plugin/PluginHelper.php:87
    5Joomla\CMS\Plugin\PluginHelper::getPlugin()JROOT/libraries/src/Plugin/PluginHelper.php:129
    4Joomla\CMS\Plugin\PluginHelper::isEnabled()JROOT/libraries/src/Application/SiteApplication.php:604
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

  4. Время запроса: 0.55 ms После последнего запроса: 0.09 ms Память запроса: 0.021 MB Память до запроса: 1.191 MB Выбрано строк: 2
    SELECT b.id
    
      FROM jom_usergroups AS a
      LEFT JOIN jom_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE a.id = 9
    План SQL-запросов (Explain)
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaconstPRIMARYPRIMARY4const1
    1SIMPLEbrangeidx_usergroup_nested_set_lookupidx_usergroup_nested_set_lookup4NULL2Using where; Using index
    Профилирование SQL-запросов
    StatusDuration
    Starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.03 ms
    Optimizing0.02 ms
    Statistics0.08 ms
    Preparing0.02 ms
    Unlocking tables0.01 ms
    Preparing0.03 ms
    Executing0.01 ms
    Sending data0.04 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.01 ms
    Стек вызовов
    #Вызывающий объектФайл и номер строки
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1550
    10JDatabaseDriver->loadColumn()JROOT/libraries/src/Access/Access.php:980
    9Joomla\CMS\Access\Access::getGroupsByUser()JROOT/libraries/src/Access/Access.php:1095
    8Joomla\CMS\Access\Access::getAuthorisedViewLevels()JROOT/libraries/src/User/User.php:458
    7Joomla\CMS\User\User->getAuthorisedViewLevels()JROOT/libraries/src/Plugin/PluginHelper.php:321
    6Joomla\CMS\Plugin\PluginHelper::load()JROOT/libraries/src/Plugin/PluginHelper.php:87
    5Joomla\CMS\Plugin\PluginHelper::getPlugin()JROOT/libraries/src/Plugin/PluginHelper.php:129
    4Joomla\CMS\Plugin\PluginHelper::isEnabled()JROOT/libraries/src/Application/SiteApplication.php:604
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

  5. Время запроса: 0.52 ms После последнего запроса: 12.12 ms Память запроса: 0.005 MB Память до запроса: 1.851 MB
    UPDATE `jom_extensions`
    
      SET `params` = '{\"mediaversion\":\"f84147717181a4a062b55e0d682f896c\"}'
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    План SQL-запросов (Explain)
    EXPLAIN недоступен для запроса: UPDATE `jom_extensions` SET `params` = '{\"mediaversion\":\"f84147717181a4a062b55e0d682f896c\"}' WHERE `type` = 'library' AND `element` = 'joomla'
    Профилирование SQL-запросов
    StatusDuration
    Starting0.06 ms
    checking permissions0.02 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init for update0.12 ms
    Updating0.08 ms
    End of update loop0.02 ms
    Query end0.01 ms
    Commit0.03 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.01 ms
    Стек вызовов
    #Вызывающий объектФайл и номер строки
    10JDatabaseDriverMysqli->execute()JROOT/libraries/src/Helper/LibraryHelper.php:117
    9Joomla\CMS\Helper\LibraryHelper::saveParams()JROOT/libraries/src/Version.php:372
    8Joomla\CMS\Version->setMediaVersion()JROOT/libraries/src/Version.php:331
    7Joomla\CMS\Version->getMediaVersion()JROOT/libraries/src/Factory.php:778
    6Joomla\CMS\Factory::createDocument()JROOT/libraries/src/Factory.php:234
    5Joomla\CMS\Factory::getDocument()JROOT/libraries/src/Application/WebApplication.php:1130
    4Joomla\CMS\Application\WebApplication->loadDocument()JROOT/libraries/src/Application/SiteApplication.php:133
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

  6. Время запроса: 0.74 ms После последнего запроса: 3.35 ms Память запроса: 0.029 MB Память до запроса: 2.059 MB Выбрано строк: 34
    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `jom_assets`
      WHERE `name` IN ('root.1','com_actionlogs','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_fields','com_finder','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper')
    План SQL-запросов (Explain)
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjom_assetsALLidx_asset_nameИндекс не используетсяNULLNULL85Using where
    Профилирование SQL-запросов
    StatusDuration
    Starting0.07 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.02 ms
    init0.05 ms
    Optimizing0.02 ms
    Statistics0.12 ms
    Preparing0.03 ms
    Executing0.01 ms
    Sending data0.18 ms
    End of update loop0.02 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.01 ms
    Стек вызовов
    #Вызывающий объектФайл и номер строки
    22JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    21JDatabaseDriver->loadObjectList()JROOT/libraries/src/Access/Access.php:429
    20Joomla\CMS\Access\Access::preloadComponents()JROOT/libraries/src/Access/Access.php:213
    19Joomla\CMS\Access\Access::preload()JROOT/libraries/src/Access/Access.php:531
    18Joomla\CMS\Access\Access::getAssetRules()JROOT/libraries/src/Access/Access.php:183
    17Joomla\CMS\Access\Access::check()JROOT/libraries/src/User/User.php:398
    16Joomla\CMS\User\User->authorise()JROOT/components/com_content/models/articles.php:115
    15ContentModelArticles->populateState()JROOT/components/com_content/models/featured.php:45
    14ContentModelFeatured->populateState()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
    13Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()JROOT/libraries/src/MVC/View/HtmlView.php:425
    12Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_content/views/featured/view.html.php:55
    11ContentViewFeatured->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

  7. Время запроса: 1.85 ms После последнего запроса: 0.82 ms Память запроса: 0.025 MB Память до запроса: 2.138 MB Выбрано строк: 1
    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      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
      FROM jom_content AS a
      INNER JOIN jom_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN jom_categories AS c
      ON c.id = a.catid
      LEFT JOIN jom_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN jom_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN jom_categories as parent
      ON parent.id = c.parent_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 <= '2021-03-02 07:27:32')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-03-02 07:27:32')
      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
    План SQL-запросов (Explain)
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEfpALLPRIMARYИндекс не используетсяNULLNULL1Using temporary; Используется filesort
    1SIMPLEaeq_refPRIMARY,idx_access,idx_state,idx_catidPRIMARY4yakiev.fp.content_id1Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4yakiev.a.created_by1Using where
    1SIMPLEuameq_refPRIMARYPRIMARY4yakiev.a.modified_by1Using where
    1SIMPLEceq_refPRIMARY,idx_accessPRIMARY4yakiev.a.catid1Using where
    1SIMPLEparenteq_refPRIMARYPRIMARY4yakiev.c.parent_id1Using where
    Профилирование SQL-запросов
    StatusDuration
    Starting0.24 ms
    checking permissions0.02 ms
    Opening tables0.15 ms
    After opening tables0.02 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.11 ms
    Optimizing0.06 ms
    Statistics0.16 ms
    Preparing0.06 ms
    Creating tmp table0.13 ms
    Sorting result0.03 ms
    Executing0.01 ms
    Sending data0.45 ms
    Creating sort index0.06 ms
    Removing tmp table0.09 ms
    Creating sort index0.02 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.02 ms
    Updating status0.02 ms
    Reset for next command0.01 ms
    Стек вызовов
    #Вызывающий объектФайл и номер строки
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    17JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    16Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:187
    15Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/components/com_content/models/articles.php:576
    14ContentModelArticles->getItems()JROOT/components/com_content/models/featured.php:126
    13ContentModelFeatured->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    12Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_content/views/featured/view.html.php:56
    11ContentViewFeatured->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

  8. Время запроса: 0.67 ms После последнего запроса: 0.44 ms Память запроса: 0.024 MB Память до запроса: 2.181 MB Выбрано строк: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `jom_contentitem_tag_map` AS m
      INNER JOIN `jom_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 1
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    План SQL-запросов (Explain)
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmALLidx_tag_typeИндекс не используетсяNULLNULL1Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4yakiev.m.tag_id1Using where
    Профилирование SQL-запросов
    StatusDuration
    Starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.09 ms
    After opening tables0.02 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.05 ms
    Optimizing0.03 ms
    Statistics0.11 ms
    Preparing0.04 ms
    Executing0.01 ms
    Sending data0.05 ms
    End of update loop0.02 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.03 ms
    Reset for next command0.01 ms
    Стек вызовов
    #Вызывающий объектФайл и номер строки
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    16JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    15Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/models/articles.php:706
    14ContentModelArticles->getItems()JROOT/components/com_content/models/featured.php:126
    13ContentModelFeatured->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    12Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_content/views/featured/view.html.php:56
    11ContentViewFeatured->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

  9. Время запроса: 0.73 ms После последнего запроса: 0.73 ms Память запроса: 0.024 MB Память до запроса: 2.180 MB Выбрано строк: 1
    SELECT COUNT(*)
    
      FROM jom_content AS a
      INNER JOIN jom_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN jom_categories AS c
      ON c.id = a.catid
      LEFT JOIN jom_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN jom_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN jom_categories as parent
      ON parent.id = c.parent_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 <= '2021-03-02 07:27:32')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-03-02 07:27:32')
    План SQL-запросов (Explain)
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEfpindexPRIMARYPRIMARY4NULL1Using index
    1SIMPLEaeq_refPRIMARY,idx_access,idx_state,idx_catidPRIMARY4yakiev.fp.content_id1Using where
    1SIMPLEceq_refPRIMARY,idx_accessPRIMARY4yakiev.a.catid1Using where
    Профилирование SQL-запросов
    StatusDuration
    Starting0.09 ms
    checking permissions0.02 ms
    Opening tables0.04 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.06 ms
    Optimizing0.05 ms
    Statistics0.11 ms
    Preparing0.02 ms
    Unlocking tables0.01 ms
    Preparing0.04 ms
    Executing0.01 ms
    Sending data0.06 ms
    End of update loop0.02 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.02 ms
    Updating status0.02 ms
    Reset for next command0.01 ms
    Стек вызовов
    #Вызывающий объектФайл и номер строки
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    16JDatabaseDriver->loadResult()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:340
    15Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()JROOT/libraries/src/MVC/Model/ListModel.php:282
    14Joomla\CMS\MVC\Model\ListModel->getTotal()JROOT/libraries/src/MVC/Model/ListModel.php:232
    13Joomla\CMS\MVC\Model\ListModel->getPagination()JROOT/libraries/src/MVC/View/HtmlView.php:425
    12Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_content/views/featured/view.html.php:57
    11ContentViewFeatured->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

  10. Время запроса: 0.81 ms После последнего запроса: 2.68 ms Память запроса: 0.027 MB Память до запроса: 2.214 MB Выбрано строк: 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 `jom_categories` AS `s`
      INNER JOIN `jom_categories` AS `c`
      ON (s.lft <= c.lft
      AND c.lft < s.rgt) 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,5)
      AND c.published = 1
      AND s.id = 2
      ORDER BY c.lft
    План SQL-запросов (Explain)
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsconstPRIMARY,idx_left_rightPRIMARY4const1
    1SIMPLEcrangecat_idx,idx_access,idx_left_rightidx_left_right4NULL2Using index condition; Using where
    Профилирование SQL-запросов
    StatusDuration
    Starting0.12 ms
    checking permissions0.02 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.06 ms
    Optimizing0.04 ms
    Statistics0.15 ms
    Preparing0.02 ms
    Unlocking tables0.01 ms
    Preparing0.04 ms
    Sorting result0.02 ms
    Executing0.01 ms
    Sending data0.10 ms
    End of update loop0.02 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.02 ms
    Updating status0.02 ms
    Reset for next command0.01 ms
    Стек вызовов
    #Вызывающий объектФайл и номер строки
    22JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    21JDatabaseDriver->loadObjectList()JROOT/libraries/src/Categories/Categories.php:324
    20Joomla\CMS\Categories\Categories->_load()JROOT/libraries/src/Categories/Categories.php:184
    19Joomla\CMS\Categories\Categories->get()JROOT/administrator/components/com_fields/models/fields.php:203
    18FieldsModelFields->getListQuery()JROOT/libraries/src/MVC/Model/ListModel.php:133
    17Joomla\CMS\MVC\Model\ListModel->_getListQuery()JROOT/libraries/src/MVC/Model/ListModel.php:187
    16Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    15FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:495
    14PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    13JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    12JEventDispatcher->trigger()JROOT/components/com_content/views/featured/view.html.php:102
    11ContentViewFeatured->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

  11. Время запроса: 1.31 ms После последнего запроса: 0.24 ms Память запроса: 0.025 MB Память до запроса: 2.235 MB Выбрано строк: 0
    SELECT DISTINCT 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, g.note as group_note
    
      FROM jom_fields AS a
      LEFT JOIN `jom_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN jom_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN jom_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN jom_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN jom_fields_groups AS g
      ON g.id = a.group_id
      LEFT JOIN `jom_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 (2,0))
      AND a.access IN (1,1,5)
      AND (a.group_id = 0 OR g.access IN (1,1,5))
      AND a.state = 1
      AND (a.group_id = 0 OR g.state = 1)
      ORDER BY a.ordering ASC
    План SQL-запросов (Explain)
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEarefidx_state,idx_access,idx_contextidx_state1const1Using where; Using temporary; Используется filesort
    1SIMPLEleq_refidx_langcodeidx_langcode28yakiev.a.language1Using where
    1SIMPLEuceq_refPRIMARYPRIMARY4yakiev.a.checked_out1
    1SIMPLEageq_refPRIMARYPRIMARY4yakiev.a.access1Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4yakiev.a.created_user_id1Using where
    1SIMPLEgeq_refPRIMARYPRIMARY4yakiev.a.group_id1Using where
    1SIMPLEfcrefPRIMARYPRIMARY4yakiev.a.id1Using where; Using index; Distinct
    Профилирование SQL-запросов
    StatusDuration
    Starting0.13 ms
    checking permissions0.01 ms
    Opening tables0.12 ms
    After opening tables0.02 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.06 ms
    Optimizing0.05 ms
    Statistics0.17 ms
    Preparing0.06 ms
    Creating tmp table0.06 ms
    Sorting result0.02 ms
    Executing0.02 ms
    Sending data0.23 ms
    Creating sort index0.05 ms
    Removing tmp table0.05 ms
    Creating sort index0.02 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.02 ms
    Updating status0.02 ms
    Reset for next command0.01 ms
    Стек вызовов
    #Вызывающий объектФайл и номер строки
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    19JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    18Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:333
    17FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:187
    16Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    15FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:495
    14PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    13JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    12JEventDispatcher->trigger()JROOT/components/com_content/views/featured/view.html.php:102
    11ContentViewFeatured->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

  12. Время запроса: 1.46 ms После последнего запроса: 523.28 ms Память запроса: 0.023 MB Память до запроса: 3.856 MB Выбрано строк: 0
    SELECT MAX(`tag_id`) AS tag_id, COUNT(*) AS count,MAX(t.title) AS title,MAX(`t`.`access`) AS access,MAX(`t`.`alias`) AS alias,MAX(`t`.`params`) AS params
    
      FROM `jom_contentitem_tag_map` AS `m`
      INNER JOIN `jom_tags` AS `t`
      ON `tag_id` = t.id
      INNER JOIN `jom_ucm_content` AS `c`
      ON `m`.`core_content_id` = `c`.`core_content_id`
      WHERE `t`.`access` IN (1,1,5)
      AND `t`.`published` = 1
      AND `m`.`type_alias` = `c`.`core_type_alias`
      AND `c`.`core_state` = 1
      AND (`c`.`core_access` IN (1,1,5) OR `c`.`core_access` = 0)
      AND (`c`.`core_publish_up` = '0000-00-00 00:00:00' OR `c`.`core_publish_up` <= '2021-03-02 07:27:32')
      AND (`c`.`core_publish_down` = '0000-00-00 00:00:00' OR `c`.`core_publish_down` >= '2021-03-02 07:27:32')
      GROUP BY `tag_id`,`title`,`access`,`alias`
      ORDER BY `count` DESC
      LIMIT 8
    План SQL-запросов (Explain)
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmALLidx_tag_type,idx_core_content_idИндекс не используетсяNULLNULL1Using temporary; Используется filesort
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4yakiev.m.tag_id1Using where
    1SIMPLEceq_refPRIMARY,tag_idx,idx_access,idx_content_typePRIMARY4yakiev.m.core_content_id1Using where
    Профилирование SQL-запросов
    StatusDuration
    Starting0.20 ms
    checking permissions0.02 ms
    Opening tables0.08 ms
    After opening tables0.02 ms
    System lock0.01 ms
    table lock0.02 ms
    init0.11 ms
    Optimizing0.06 ms
    Statistics0.20 ms
    Preparing0.07 ms
    Creating tmp table0.06 ms
    Sorting result0.03 ms
    Executing0.01 ms
    Sending data0.20 ms
    Creating sort index0.06 ms
    Removing tmp table0.06 ms
    Creating sort index0.02 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.02 ms
    Updating status0.02 ms
    Reset for next command0.01 ms
    Стек вызовов
    #Вызывающий объектФайл и номер строки
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/modules/mod_tags_popular/helper.php:134
    14ModTagsPopularHelper::getList()Так же, как вызов в строке ниже.
    13call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    12Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Helper/ModuleHelper.php:587
    11Joomla\CMS\Helper\ModuleHelper::moduleCache()JROOT/modules/mod_tags_popular/mod_tags_popular.php:22
    10include JROOT/modules/mod_tags_popular/mod_tags_popular.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:489
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:793
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:567
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1044
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:202
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

  13. Время запроса: 1.52 ms После последнего запроса: 69.93 ms Память запроса: 0.044 MB Память до запроса: 3.898 MB Выбрано строк: 4
    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
      FROM jom_content AS a
      LEFT JOIN jom_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN jom_categories AS c
      ON c.id = a.catid
      LEFT JOIN jom_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN jom_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN jom_categories as parent
      ON parent.id = c.parent_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.catid = 8
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-03-02 07:27:32')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-03-02 07:27:32')
      ORDER BY a.created DESC
      LIMIT 6
    План SQL-запросов (Explain)
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEcconstPRIMARY,idx_accessPRIMARY4const1
    1SIMPLEaALLidx_access,idx_state,idx_catidИндекс не используетсяNULLNULL7Using where; Используется filesort
    1SIMPLEfpeq_refPRIMARYPRIMARY4yakiev.a.id1Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4yakiev.a.created_by1Using where
    1SIMPLEuameq_refPRIMARYPRIMARY4yakiev.a.modified_by1Using where
    1SIMPLEparenteq_refPRIMARYPRIMARY4const1Using where
    Профилирование SQL-запросов
    StatusDuration
    Starting0.30 ms
    checking permissions0.02 ms
    Opening tables0.07 ms
    After opening tables0.02 ms
    System lock0.01 ms
    table lock0.02 ms
    init0.11 ms
    Optimizing0.07 ms
    Statistics0.21 ms
    Preparing0.02 ms
    Unlocking tables0.01 ms
    Preparing0.06 ms
    Sorting result0.03 ms
    Executing0.01 ms
    Sending data0.04 ms
    Creating sort index0.20 ms
    End of update loop0.02 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.03 ms
    Starting cleanup0.01 ms
    Freeing items0.02 ms
    Updating status0.03 ms
    Reset for next command0.01 ms
    Стек вызовов
    #Вызывающий объектФайл и номер строки
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    18JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    17Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:187
    16Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/components/com_content/models/articles.php:576
    15ContentModelArticles->getItems()JROOT/modules/mod_articles_category/helper.php:224
    14ModArticlesCategoryHelper::getList()Так же, как вызов в строке ниже.
    13call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    12Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Helper/ModuleHelper.php:557
    11Joomla\CMS\Helper\ModuleHelper::moduleCache()JROOT/modules/mod_articles_category/mod_articles_category.php:61
    10include JROOT/modules/mod_articles_category/mod_articles_category.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:489
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:793
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:567
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1044
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:202
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

  14. Время запроса: 0.89 ms После последнего запроса: 0.58 ms Память запроса: 0.029 MB Память до запроса: 3.974 MB Выбрано строк: 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 `jom_categories` AS `s`
      INNER JOIN `jom_categories` AS `c`
      ON (s.lft <= c.lft
      AND c.lft < s.rgt) 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,5)
      AND c.published = 1
      AND s.id = 8
      ORDER BY c.lft
    План SQL-запросов (Explain)
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsconstPRIMARY,idx_left_rightPRIMARY4const1
    1SIMPLEcALLcat_idx,idx_access,idx_left_rightИндекс не используетсяNULLNULL8Using where; Используется filesort
    Профилирование SQL-запросов
    StatusDuration
    Starting0.12 ms
    checking permissions0.02 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.06 ms
    Optimizing0.04 ms
    Statistics0.13 ms
    Preparing0.02 ms
    Unlocking tables0.01 ms
    Preparing0.03 ms
    Sorting result0.02 ms
    Executing0.01 ms
    Sending data0.03 ms
    Creating sort index0.12 ms
    End of update loop0.02 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.02 ms
    Updating status0.02 ms
    Reset for next command0.01 ms
    Стек вызовов
    #Вызывающий объектФайл и номер строки
    28JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    27JDatabaseDriver->loadObjectList()JROOT/libraries/src/Categories/Categories.php:324
    26Joomla\CMS\Categories\Categories->_load()JROOT/libraries/src/Categories/Categories.php:184
    25Joomla\CMS\Categories\Categories->get()JROOT/components/com_content/router.php:72
    24ContentRouter->getCategorySegment()Так же, как вызов в строке ниже.
    23call_user_func_array()JROOT/libraries/src/Component/Router/RouterView.php:120
    22Joomla\CMS\Component\Router\RouterView->getPath()JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    21Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()JROOT/libraries/src/Component/Router/RouterView.php:222
    20Joomla\CMS\Component\Router\RouterView->preprocess()JROOT/libraries/src/Router/SiteRouter.php:676
    19Joomla\CMS\Router\SiteRouter->processBuildRules()JROOT/libraries/src/Router/Router.php:266
    18Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:155
    17Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:144
    16Joomla\CMS\Router\Route::link()JROOT/libraries/src/Router/Route.php:93
    15Joomla\CMS\Router\Route::_()JROOT/modules/mod_articles_category/helper.php:260
    14ModArticlesCategoryHelper::getList()Так же, как вызов в строке ниже.
    13call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    12Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Helper/ModuleHelper.php:557
    11Joomla\CMS\Helper\ModuleHelper::moduleCache()JROOT/modules/mod_articles_category/mod_articles_category.php:61
    10include JROOT/modules/mod_articles_category/mod_articles_category.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:489
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:793
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:567
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1044
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:202
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

  15. Время запроса: 0.86 ms После последнего запроса: 70.77 ms Память запроса: 0.023 MB Память до запроса: 3.922 MB Выбрано строк: 0
    SELECT MONTH(`created`) AS created_month,MIN(`created`) AS created,YEAR(`created`) AS created_year
    
      FROM jom_content
      WHERE state = 2
      GROUP BY YEAR(`created`), MONTH(`created`)
      ORDER BY YEAR(`created`) DESC, MONTH(`created`) DESC
      LIMIT 10
    План SQL-запросов (Explain)
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjom_contentrefidx_stateidx_state1const1Using where; Using temporary; Используется filesort
    Профилирование SQL-запросов
    StatusDuration
    Starting0.15 ms
    checking permissions0.02 ms
    Opening tables0.04 ms
    After opening tables0.02 ms
    System lock0.01 ms
    table lock0.02 ms
    init0.05 ms
    Optimizing0.03 ms
    Statistics0.09 ms
    Preparing0.04 ms
    Creating tmp table0.04 ms
    Sorting result0.02 ms
    Executing0.01 ms
    Sending data0.04 ms
    Creating sort index0.03 ms
    Removing tmp table0.01 ms
    Creating sort index0.02 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.02 ms
    Updating status0.02 ms
    Reset for next command0.01 ms
    Стек вызовов
    #Вызывающий объектФайл и номер строки
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/modules/mod_articles_archive/helper.php:51
    14ModArchiveHelper::getList()JROOT/modules/mod_articles_archive/mod_articles_archive.php:17
    13include JROOT/modules/mod_articles_archive/mod_articles_archive.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    12Joomla\CMS\Helper\ModuleHelper::renderModule()Так же, как вызов в строке ниже.
    11call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Helper/ModuleHelper.php:597
    9Joomla\CMS\Helper\ModuleHelper::moduleCache()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:489
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:793
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:567
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1044
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:202
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

  16. Время запроса: 1.48 ms После последнего запроса: 69.38 ms Память запроса: 0.044 MB Память до запроса: 3.944 MB Выбрано строк: 4
    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
      FROM jom_content AS a
      LEFT JOIN jom_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN jom_categories AS c
      ON c.id = a.catid
      LEFT JOIN jom_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN jom_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN jom_categories as parent
      ON parent.id = c.parent_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.catid = 8
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-03-02 07:27:32')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-03-02 07:27:32')
      ORDER BY a.hits DESC
      LIMIT 5
    План SQL-запросов (Explain)
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEcconstPRIMARY,idx_accessPRIMARY4const1
    1SIMPLEaALLidx_access,idx_state,idx_catidИндекс не используетсяNULLNULL7Using where; Используется filesort
    1SIMPLEfpeq_refPRIMARYPRIMARY4yakiev.a.id1Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4yakiev.a.created_by1Using where
    1SIMPLEuameq_refPRIMARYPRIMARY4yakiev.a.modified_by1Using where
    1SIMPLEparenteq_refPRIMARYPRIMARY4const1Using where
    Профилирование SQL-запросов
    StatusDuration
    Starting0.30 ms
    checking permissions0.02 ms
    Opening tables0.07 ms
    After opening tables0.02 ms
    System lock0.01 ms
    table lock0.02 ms
    init0.11 ms
    Optimizing0.07 ms
    Statistics0.20 ms
    Preparing0.02 ms
    Unlocking tables0.01 ms
    Preparing0.05 ms
    Sorting result0.03 ms
    Executing0.01 ms
    Sending data0.04 ms
    Creating sort index0.20 ms
    End of update loop0.02 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.02 ms
    Updating status0.03 ms
    Reset for next command0.01 ms
    Стек вызовов
    #Вызывающий объектФайл и номер строки
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    18JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    17Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:187
    16Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/components/com_content/models/articles.php:576
    15ContentModelArticles->getItems()JROOT/modules/mod_articles_popular/helper.php:77
    14ModArticlesPopularHelper::getList()JROOT/modules/mod_articles_popular/mod_articles_popular.php:15
    13include JROOT/modules/mod_articles_popular/mod_articles_popular.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    12Joomla\CMS\Helper\ModuleHelper::renderModule()Так же, как вызов в строке ниже.
    11call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Helper/ModuleHelper.php:597
    9Joomla\CMS\Helper\ModuleHelper::moduleCache()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:489
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:793
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:567
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1044
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:202
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

  17. Время запроса: 1.61 ms После последнего запроса: 241.65 ms Память запроса: 0.028 MB Память до запроса: 4.044 MB Выбрано строк: 0
    SELECT DISTINCT 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, g.note as group_note
    
      FROM jom_fields AS a
      LEFT JOIN `jom_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN jom_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN jom_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN jom_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN jom_fields_groups AS g
      ON g.id = a.group_id
      WHERE a.context = 'mod_custom.content'
      AND a.access IN (1,1,5)
      AND (a.group_id = 0 OR g.access IN (1,1,5))
      AND a.state = 1
      AND (a.group_id = 0 OR g.state = 1)
      ORDER BY a.ordering ASC
    План SQL-запросов (Explain)
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEarefidx_state,idx_access,idx_contextidx_state1const1Using where; Using temporary; Используется filesort
    1SIMPLEleq_refidx_langcodeidx_langcode28yakiev.a.language1Using where
    1SIMPLEuceq_refPRIMARYPRIMARY4yakiev.a.checked_out1
    1SIMPLEageq_refPRIMARYPRIMARY4yakiev.a.access1Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4yakiev.a.created_user_id1Using where
    1SIMPLEgeq_refPRIMARYPRIMARY4yakiev.a.group_id1Using where
    Профилирование SQL-запросов
    StatusDuration
    Starting0.22 ms
    checking permissions0.02 ms
    Opening tables0.07 ms
    After opening tables0.02 ms
    System lock0.01 ms
    table lock0.02 ms
    init0.08 ms
    Optimizing0.06 ms
    Statistics0.18 ms
    Preparing0.07 ms
    Creating tmp table0.08 ms
    Sorting result0.03 ms
    Executing0.01 ms
    Sending data0.27 ms
    Creating sort index0.05 ms
    Removing tmp table0.06 ms
    Creating sort index0.03 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.02 ms
    Updating status0.02 ms
    Reset for next command0.01 ms
    Стек вызовов
    #Вызывающий объектФайл и номер строки
    26JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    25JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    24Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:333
    23FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:187
    22Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    21FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:495
    20PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    19JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    18JEventDispatcher->trigger()JROOT/libraries/cms/html/content.php:41
    17JHtmlContent::prepare()Так же, как вызов в строке ниже.
    16call_user_func_array()JROOT/libraries/src/HTML/HTMLHelper.php:239
    15Joomla\CMS\HTML\HTMLHelper::call()JROOT/libraries/src/HTML/HTMLHelper.php:146
    14Joomla\CMS\HTML\HTMLHelper::_()JROOT/modules/mod_custom/mod_custom.php:15
    13include JROOT/modules/mod_custom/mod_custom.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    12Joomla\CMS\Helper\ModuleHelper::renderModule()Так же, как вызов в строке ниже.
    11call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Helper/ModuleHelper.php:597
    9Joomla\CMS\Helper\ModuleHelper::moduleCache()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:489
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:793
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:567
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1044
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:202
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Зафиксировано 15 типов SQL-запросов, отсортировано по вхождениям

Запросы типа SELECT:
  1. 2 × 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
      FROM jom_content AS a
      LEFT JOIN jom_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN jom_categories AS c
      ON c.id = a.catid
      LEFT JOIN jom_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN jom_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN jom_categories as parent
      ON parent.id = c.parent_id
  2. 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 `jom_categories` AS `s`
      INNER JOIN `jom_categories` AS `c`
      ON (s.lft <= c.lft
      AND c.lft < s.rgt) OR (c.lft < s.lft
      AND s.rgt < c.rgt)
  3. 1 × SELECT `session_id` 
      FROM `jom_session`
  4. 1 × SELECT id, rules 
      FROM `jom_viewlevels
  5. 1 × SELECT b.id 
      FROM jom_usergroups AS a
      LEFT JOIN jom_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
  6. 1 × SELECT `id`,`name`,`rules`,`parent_id` 
      FROM `jom_assets`
  7. 1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      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
      FROM jom_content AS a
      INNER JOIN jom_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN jom_categories AS c
      ON c.id = a.catid
      LEFT JOIN jom_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN jom_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN jom_categories as parent
      ON parent.id = c.parent_id
  8. 1 × SELECT `m`.`tag_id`,`t`.* 
      FROM `jom_contentitem_tag_map` AS m
      INNER JOIN `jom_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
  9. 1 × SELECT COUNT(*) 
      FROM jom_content AS a
      INNER JOIN jom_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN jom_categories AS c
      ON c.id = a.catid
      LEFT JOIN jom_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN jom_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN jom_categories as parent
      ON parent.id = c.parent_id
  10. 1 × SELECT DISTINCT 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, g.note as group_note 
      FROM jom_fields AS a
      LEFT JOIN `jom_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN jom_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN jom_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN jom_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN jom_fields_groups AS g
      ON g.id = a.group_id
      LEFT JOIN `jom_fields_categories` AS fc
      ON fc.field_id = a.id
  11. 1 × SELECT MAX(`tag_id`) AS tag_id, COUNT(*) AS count,MAX(t.title) AS title,MAX(`t`.`access`) AS access,MAX(`t`.`alias`) AS alias,MAX(`t`.`params`) AS params 
      FROM `jom_contentitem_tag_map` AS `m`
      INNER JOIN `jom_tags` AS `t`
      ON `tag_id` = t.id
      INNER JOIN `jom_ucm_content` AS `c`
      ON `m`.`core_content_id` = `c`.`core_content_id`
  12. 1 × SELECT MONTH(`created`) AS created_month,MIN(`created`) AS created,YEAR(`created`) AS created_year 
      FROM jom_content
  13. 1 × SELECT DISTINCT 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, g.note as group_note 
      FROM jom_fields AS a
      LEFT JOIN `jom_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN jom_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN jom_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN jom_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN jom_fields_groups AS g
      ON g.id = a.group_id
Прочие SQL-запросы:
  1. 1 × INSERT INTO `jom_session` (`session_id`,`guest`,`time`,`userid`,`username`) 
      VALUES (X'726d36743039706e6f6e6e6d3030396d627662766668716a6e70', 1, 1614670052, 0, ''
  2. 1 × UPDATE `jom_extensions` 
      SET `params` = '{\"mediaversion\":\"f84147717181a4a062b55e0d682f896c\"}'