Toggle Navigation
  • Trang chủ
  • Giới thiệu
  • Thông báo
  • Tài nguyên số
  • Hình ảnh
  • Học bổng
  • Hướng nghiệp
  • Góc Thơ - Văn
  • Video
  • TRỞ VỀ ĐẦU TRANG »  

Chuyên mục BÀI GIẢNG - GIÁO TRÌNH BÀI GIẢNG - GIÁO TRÌNH 4

Chuyên mục CHUYÊN ĐỀ HỌC SINH GIỎI CHUYÊN ĐỀ HỌC SINH GIỎI 0

Chuyên mục GIAI PHẨM XUÂN GIAI PHẨM XUÂN 1

Chuyên mục KỶ YẾU KỶ YẾU 4

Chuyên mục SÁCH GIÁO KHOA SÁCH GIÁO KHOA 2

Alexandria Book Library
  • You are here:  
  • Home
  • Tài nguyên số
VĂN BẢN
BIỂU MẪU
BẢN TIN ONLINE
WEBSITE TRƯỜNG HỆ THỐNG
HỌC THI
TRỰC TUYẾN
 

Thống kê

Vietnam 56.7% Vietnam
United States 42.7% United States

Total:

7

Countries
005899
Today: 5
This Week: 13
This Month: 11

Back to Top

Bản quyền © 2020 thuộc về Trường THPT chuyên Thoại Ngọc Hầu
5B Tôn Đức Thắng, Mỹ Bình, Long Xuyên, An Giang
Phát triển bởi Lê Thanh Phong, Email: ltphong.agu@gmail.com

Joomla! Debug Console

Session

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

Profile Information

Time

Memory

Time: 21.18 ms / 21.18 ms Memory: 0.708 MB / 1.04 MB Application: afterLoad
Time: 83.05 ms / 104.24 ms Memory: 1.326 MB / 2.37 MB Application: afterInitialise
Time: 32.92 ms / 137.15 ms Memory: 0.348 MB / 2.72 MB Application: afterRoute
Time: 7.82 ms / 144.97 ms Memory: 0.160 MB / 2.88 MB Application: beforeRenderComponent com_abook
Time: 33.48 ms / 178.45 ms Memory: 0.432 MB / 3.31 MB Application: afterRenderComponent com_abook
Time: 1.86 ms / 180.31 ms Memory: 0.011 MB / 3.32 MB Application: afterDispatch
Time: 5.41 ms / 185.71 ms Memory: 0.113 MB / 3.43 MB Application: beforeRenderModule mod_custom (Liên kết)
Time: 2.18 ms / 187.89 ms Memory: 0.006 MB / 3.44 MB Application: afterRenderModule mod_custom (Liên kết)
Time: 0.03 ms / 187.93 ms Memory: 0.002 MB / 3.44 MB Application: beforeRenderModule mod_jsvisit_counter (Thống kê)
Time: 7.24 ms / 195.17 ms Memory: 0.130 MB / 3.57 MB Application: afterRenderModule mod_jsvisit_counter (Thống kê)
Time: 0.06 ms / 195.23 ms Memory: 0.000 MB / 3.57 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 3.12 ms / 198.36 ms Memory: 0.014 MB / 3.58 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 0.08 ms / 198.44 ms Memory: 0.000 MB / 3.58 MB Application: beforeRenderModule mod_menu (Main Menu)
Time: 4.58 ms / 203.02 ms Memory: 0.094 MB / 3.67 MB Application: afterRenderModule mod_menu (Main Menu)
Time: 4.15 ms / 207.17 ms Memory: 0.103 MB / 3.78 MB Application: afterRender

Database queries total: 24.79 ms

Memory Usage

4.26 MB (4,471,928 Bytes)

Database Queries

30 Queries Logged 24.79 ms


10 duplicate found!

4 duplicates: #21  #22  #29  #30
2 duplicates: #23  #24
2 duplicates: #25  #26
2 duplicates: #27  #28
  1. Query Time: 0.61 ms Query memory: 0.027 MB Memory before query: 1.511 MB Rows returned: 0
    SELECT `data`
    
      FROM `d6v9n_session`
      WHERE `session_id` = X'62356d333636653972626a6f646b7173717062766e32756b3130'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEd6v9n_sessionconstPRIMARYPRIMARY194const1
    Profile
    StatusDuration
    Starting0.12 ms
    checking permissions0.02 ms
    Opening tables0.05 ms
    After opening tables0.02 ms
    System lock0.01 ms
    table lock0.02 ms
    init0.03 ms
    Optimizing0.02 ms
    Statistics0.05 ms
    Preparing0.01 ms
    Executing0.03 ms
    End of update loop0.02 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.04 ms
    Updating status0.03 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    15JDatabaseDriver->loadResult()JROOT/libraries/joomla/session/storage/database.php:45
    14JSessionStorageDatabase->read()Same as call in the line below.
    13session_start()JROOT/libraries/joomla/session/handler/native.php:260
    12JSessionHandlerNative->doSessionStart()JROOT/libraries/joomla/session/handler/native.php:50
    11JSessionHandlerNative->start()JROOT/libraries/joomla/session/handler/joomla.php:88
    10JSessionHandlerJoomla->start()JROOT/libraries/src/Session/Session.php:660
    9Joomla\CMS\Session\Session->_start()JROOT/libraries/src/Session/Session.php:620
    8Joomla\CMS\Session\Session->start()JROOT/libraries/src/Session/Session.php:498
    7Joomla\CMS\Session\Session->get()JROOT/libraries/src/Session/Session.php:455
    6Joomla\CMS\Session\Session->isNew()JROOT/libraries/src/Application/CMSApplication.php:758
    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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  2. Query Time: 0.47 ms After last query: 2.92 ms Query memory: 0.023 MB Memory before query: 1.530 MB Rows returned: 0
    SELECT `session_id`
    
      FROM `d6v9n_session`
      WHERE `session_id` = X'62356d333636653972626a6f646b7173717062766e32756b3130'
      LIMIT 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEd6v9n_sessionconstPRIMARYPRIMARY194const1Using index
    Profile
    StatusDuration
    Starting0.09 ms
    checking permissions0.02 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.03 ms
    Optimizing0.01 ms
    Statistics0.03 ms
    Preparing0.01 ms
    Executing0.01 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.00 ms
    closing tables0.02 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.05 ms
    Updating status0.04 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  3. Query Time: 1.25 ms After last query: 0.12 ms Query memory: 0.005 MB Memory before query: 1.537 MB
    INSERT INTO `d6v9n_session`
    (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES (X'62356d333636653972626a6f646b7173717062766e32756b3130', 1, 1751635344, 0, '', 0)
    Explain
    EXPLAIN not possible on query: INSERT INTO `d6v9n_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'62356d333636653972626a6f646b7173717062766e32756b3130', 1, 1751635344, 0, '', 0)
    Profile
    StatusDuration
    Starting0.07 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init for update0.02 ms
    Update0.58 ms
    Waiting for query cache lock0.01 ms
    Update0.01 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    Waiting for query cache lock0.00 ms
    Unlocking tables0.36 ms
    closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.05 ms
    Updating status0.04 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  4. Query Time: 2.30 ms After last query: 6.30 ms Query memory: 0.033 MB Memory before query: 1.637 MB Rows returned: 44
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `d6v9n_extensions`
      WHERE `type` = 'component'
      AND `state` = 0
      AND `enabled` = 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEd6v9n_extensionsrefextensionextension82const50Using index condition; Using where
    Profile
    StatusDuration
    Starting0.10 ms
    checking permissions0.01 ms
    Opening tables0.08 ms
    After opening tables0.01 ms
    System lock0.00 ms
    table lock0.01 ms
    init0.03 ms
    Optimizing0.02 ms
    Statistics0.13 ms
    Preparing0.03 ms
    Executing0.01 ms
    Sending data1.59 ms
    End of update loop0.01 ms
    Query end0.03 ms
    Commit0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.04 ms
    Updating status0.05 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    11JDatabaseDriver->loadObjectList()JROOT/libraries/src/Component/ComponentHelper.php:445
    10Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()Same as call in the line below.
    9call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    8Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Component/ComponentHelper.php:453
    7Joomla\CMS\Component\ComponentHelper::load()JROOT/libraries/src/Component/ComponentHelper.php:519
    6Joomla\CMS\Component\ComponentHelper::getComponents()JROOT/libraries/src/Component/ComponentHelper.php:44
    5Joomla\CMS\Component\ComponentHelper::getComponent()JROOT/libraries/src/Component/ComponentHelper.php:103
    4Joomla\CMS\Component\ComponentHelper::getParams()JROOT/libraries/src/Application/SiteApplication.php:594
    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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  5. Query Time: 0.64 ms After last query: 4.01 ms Query memory: 0.025 MB Memory before query: 1.681 MB Rows returned: 5
    SELECT id, rules
    
      FROM `d6v9n_viewlevels`
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEd6v9n_viewlevelsALLNULLNO INDEX KEY COULD BE USEDNULLNULL5
    Profile
    StatusDuration
    Starting0.08 ms
    checking permissions0.01 ms
    Opening tables0.08 ms
    After opening tables0.01 ms
    System lock0.00 ms
    table lock0.01 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.03 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.17 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.04 ms
    Updating status0.03 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  6. Query Time: 0.64 ms After last query: 0.09 ms Query memory: 0.025 MB Memory before query: 1.695 MB Rows returned: 2
    SELECT b.id
    
      FROM d6v9n_usergroups AS a
      LEFT JOIN d6v9n_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE a.id = 9
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaconstPRIMARYPRIMARY4const1
    1SIMPLEbrangeidx_usergroup_nested_set_lookupidx_usergroup_nested_set_lookup4NULL2Using where
    Profile
    StatusDuration
    Starting0.07 ms
    checking permissions0.01 ms
    Opening tables0.07 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.02 ms
    Optimizing0.01 ms
    Statistics0.24 ms
    Preparing0.01 ms
    Unlocking tables0.00 ms
    Preparing0.02 ms
    Executing0.00 ms
    Sending data0.03 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.05 ms
    Updating status0.03 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  7. Query Time: 0.88 ms After last query: 1.10 ms Query memory: 0.038 MB Memory before query: 1.719 MB Rows returned: 94
    SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
    
      FROM d6v9n_extensions
      WHERE enabled = 1
      AND type = 'plugin'
      AND state IN (0,1)
      AND access IN (1,1,5)
      ORDER BY ordering
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEd6v9n_extensionsALLextensionNO INDEX KEY COULD BE USEDNULLNULL219Using where; Using filesort
    Profile
    StatusDuration
    Starting0.09 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.01 ms
    init0.02 ms
    Optimizing0.02 ms
    Statistics0.08 ms
    Preparing0.02 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.41 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.04 ms
    Updating status0.03 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    10JDatabaseDriver->loadObjectList()JROOT/libraries/src/Plugin/PluginHelper.php:354
    9Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()Same as call in the line below.
    8call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    7Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Plugin/PluginHelper.php:359
    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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  8. Query Time: 1.74 ms After last query: 30.07 ms Query memory: 0.045 MB Memory before query: 2.308 MB Rows returned: 14
    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 d6v9n_menu AS m
      LEFT JOIN d6v9n_extensions AS e
      ON m.component_id = e.extension_id
      WHERE m.published = 1
      AND m.parent_id > 0
      AND m.client_id = 0
      ORDER BY m.lft
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmrangeidx_client_id_parent_id_alias_languageidx_client_id_parent_id_alias_language5NULL19Using index condition; Using where; Using filesort
    1SIMPLEeeq_refPRIMARYPRIMARY4ltmvxxbhosting_lib2.m.component_id1Using where
    Profile
    StatusDuration
    Starting0.18 ms
    checking permissions0.01 ms
    Opening tables0.13 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.06 ms
    Optimizing0.02 ms
    Statistics0.13 ms
    Preparing0.03 ms
    Sorting result0.02 ms
    Executing0.00 ms
    Sending data0.02 ms
    Creating sort index0.87 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.05 ms
    Updating status0.05 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    23JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    22JDatabaseDriver->loadObjectList()JROOT/libraries/src/Menu/SiteMenu.php:93
    21Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()Same as call in the line below.
    20call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    19Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Menu/SiteMenu.php:101
    18Joomla\CMS\Menu\SiteMenu->load()JROOT/libraries/src/Menu/AbstractMenu.php:76
    17Joomla\CMS\Menu\AbstractMenu->__construct()JROOT/libraries/src/Menu/SiteMenu.php:62
    16Joomla\CMS\Menu\SiteMenu->__construct()JROOT/libraries/src/Menu/AbstractMenu.php:131
    15Joomla\CMS\Menu\AbstractMenu::getInstance()JROOT/libraries/src/Application/CMSApplication.php:375
    14Joomla\CMS\Application\CMSApplication->getMenu()JROOT/libraries/src/Application/SiteApplication.php:275
    13Joomla\CMS\Application\SiteApplication->getMenu()JROOT/libraries/src/Router/SiteRouter.php:64
    12Joomla\CMS\Router\SiteRouter->__construct()JROOT/libraries/src/Router/Router.php:189
    11Joomla\CMS\Router\Router::getInstance()JROOT/libraries/src/Application/CMSApplication.php:491
    10Joomla\CMS\Application\CMSApplication::getRouter()JROOT/libraries/src/Application/SiteApplication.php:403
    9Joomla\CMS\Application\SiteApplication::getRouter()JROOT/plugins/system/dropfiles/dropfiles.php:37
    8PlgSystemDropfiles->onAfterInitialise()JROOT/libraries/joomla/event/event.php:70
    7JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    6JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    5Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:626
    4Joomla\CMS\Application\CMSApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:686
    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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  9. Query Time: 0.77 ms After last query: 35.54 ms Query memory: 0.028 MB Memory before query: 2.738 MB Rows returned: 1
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `d6v9n_extensions`
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEd6v9n_extensionsrefelement_clientid,element_folder_clientid,extensionextension484const,const1Using index condition
    Profile
    StatusDuration
    Starting0.11 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.25 ms
    Preparing0.03 ms
    Executing0.00 ms
    Sending data0.06 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.04 ms
    Updating status0.04 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    14JDatabaseDriver->loadObject()JROOT/libraries/src/Helper/LibraryHelper.php:167
    13Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()Same as call in the line below.
    12call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    11Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Helper/LibraryHelper.php:175
    10Joomla\CMS\Helper\LibraryHelper::loadLibrary()JROOT/libraries/src/Helper/LibraryHelper.php:43
    9Joomla\CMS\Helper\LibraryHelper::getLibrary()JROOT/libraries/src/Helper/LibraryHelper.php:90
    8Joomla\CMS\Helper\LibraryHelper::getParams()JROOT/libraries/src/Version.php:321
    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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  10. Query Time: 0.84 ms After last query: 0.12 ms Query memory: 0.007 MB Memory before query: 2.732 MB
    UPDATE `d6v9n_extensions`
    
      SET `params` = '{\"mediaversion\":\"8d9d9af88274b08275aa1ae87d7c6702\"}'
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    EXPLAIN not possible on query: UPDATE `d6v9n_extensions` SET `params` = '{\"mediaversion\":\"8d9d9af88274b08275aa1ae87d7c6702\"}' WHERE `type` = 'library' AND `element` = 'joomla'
    Profile
    StatusDuration
    Starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.00 ms
    table lock0.01 ms
    init for update0.16 ms
    Updating0.26 ms
    End of update loop0.01 ms
    Waiting for query cache lock0.00 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.00 ms
    closing tables0.00 ms
    Unlocking tables0.01 ms
    Waiting for query cache lock0.01 ms
    Unlocking tables0.17 ms
    closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.04 ms
    Updating status0.03 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  11. Query Time: 0.71 ms After last query: 3.00 ms Query memory: 0.026 MB Memory before query: 2.847 MB Rows returned: 2
    SELECT *
    
      FROM d6v9n_languages
      WHERE published=1
      ORDER BY ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEd6v9n_languagesALLNULLNO INDEX KEY COULD BE USEDNULLNULL2Using where; Using filesort
    Profile
    StatusDuration
    Starting0.08 ms
    checking permissions0.01 ms
    Opening tables0.10 ms
    After opening tables0.01 ms
    System lock0.00 ms
    table lock0.01 ms
    init0.02 ms
    Optimizing0.01 ms
    Statistics0.05 ms
    Preparing0.02 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.20 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.04 ms
    Updating status0.03 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    7JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    6JDatabaseDriver->loadObjectList()JROOT/libraries/src/Language/LanguageHelper.php:150
    5Joomla\CMS\Language\LanguageHelper::getLanguages()JROOT/libraries/src/Application/SiteApplication.php:330
    4Joomla\CMS\Application\SiteApplication->getParams()JROOT/libraries/src/Application/SiteApplication.php:138
    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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  12. Query Time: 0.82 ms After last query: 0.20 ms Query memory: 0.022 MB Memory before query: 2.869 MB Rows returned: 2
    SELECT id, home, template, s.params
    
      FROM d6v9n_template_styles as s
      LEFT JOIN d6v9n_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
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsrefidx_template,idx_client_id,idx_client_id_homeidx_client_id1const2
    1SIMPLEerefelement_clientid,element_folder_clientid,extensionelement_clientid403ltmvxxbhosting_lib2.s.template,const1Using index condition; Using where
    Profile
    StatusDuration
    Starting0.07 ms
    checking permissions0.01 ms
    Opening tables0.07 ms
    After opening tables0.01 ms
    System lock0.00 ms
    table lock0.01 ms
    init0.02 ms
    Optimizing0.02 ms
    Statistics0.20 ms
    Preparing0.03 ms
    Executing0.00 ms
    Sending data0.22 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.04 ms
    Updating status0.03 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    6JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    5JDatabaseDriver->loadObjectList()JROOT/libraries/src/Application/SiteApplication.php:486
    4Joomla\CMS\Application\SiteApplication->getTemplate()JROOT/libraries/src/Application/SiteApplication.php:168
    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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  13. Query Time: 4.95 ms After last query: 17.18 ms Query memory: 0.041 MB Memory before query: 3.032 MB Rows returned: 5
    SELECT c.*,
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,u.name AS owner,ag.title AS access_level,COUNT(DISTINCT i.id) AS numitems
      FROM d6v9n_abcategories AS c
      LEFT JOIN d6v9n_users AS u
      ON u.id = c.checked_out
      LEFT JOIN d6v9n_viewlevels AS ag
      ON ag.id = c.access
      LEFT JOIN d6v9n_abbook AS i
      ON i.catid = c.id
      AND i.state = 1
      AND i.language in ('en-GB','*')
      WHERE c.level <= 1
      AND c.extension = 'com_abook'
      AND c.published =1
      AND c.access IN (1,1,5)
      GROUP BY c.id, c.language, c.level, c.lft, c.parent_id, c.path, c.rgt
      ORDER BY c.title ASC, c.lft, c.level
      LIMIT 10
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEcALLcat_idx,idx_accessNO INDEX KEY COULD BE USEDNULLNULL9Using where; Using temporary; Using filesort
    1SIMPLEueq_refPRIMARYPRIMARY4ltmvxxbhosting_lib2.c.checked_out1Using where
    1SIMPLEageq_refPRIMARYPRIMARY4ltmvxxbhosting_lib2.c.access1Using where
    1SIMPLEiALLNULLNO INDEX KEY COULD BE USEDNULLNULL13Using where; Using join buffer (flat, BNL join)
    Profile
    StatusDuration
    Starting0.18 ms
    checking permissions0.01 ms
    Opening tables3.01 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.08 ms
    Optimizing0.03 ms
    Statistics0.16 ms
    Preparing0.04 ms
    Creating tmp table0.13 ms
    Creating tmp table0.08 ms
    Sorting result0.02 ms
    Executing0.00 ms
    Sending data0.68 ms
    Creating sort index0.13 ms
    Creating sort index0.05 ms
    Removing tmp table0.01 ms
    Creating sort index0.00 ms
    Removing tmp table0.01 ms
    Creating sort index0.01 ms
    End of update loop0.02 ms
    Removing tmp table0.01 ms
    End of update loop0.00 ms
    Query end0.01 ms
    Commit0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Removing tmp table0.00 ms
    Freeing items0.05 ms
    Updating status0.05 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    14JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    13Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:187
    12Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    11Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_abook/views/categories/view.html.php:41
    10AbookViewCategories->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_abook/controller.php:36
    8AbookController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_abook/abook.php:26
    6require_once JROOT/components/com_abook/abook.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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  14. Query Time: 0.36 ms After last query: 0.09 ms Query memory: 0.034 MB Memory before query: 3.064 MB Rows returned: 1
    SELECT *
    
      FROM d6v9n_abcategories
      WHERE parent_id =0
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEd6v9n_abcategoriesALLNULLNO INDEX KEY COULD BE USEDNULLNULL9Using where
    Profile
    StatusDuration
    Starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.01 ms
    init0.02 ms
    Optimizing0.01 ms
    Statistics0.01 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.03 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.04 ms
    Updating status0.03 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    13JDatabaseDriver->loadObjectList()JROOT/components/com_abook/models/categories.php:211
    12AbookModelCategories->getParent()JROOT/libraries/src/MVC/View/HtmlView.php:425
    11Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_abook/views/categories/view.html.php:42
    10AbookViewCategories->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_abook/controller.php:36
    8AbookController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_abook/abook.php:26
    6require_once JROOT/components/com_abook/abook.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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  15. Query Time: 1.03 ms After last query: 1.55 ms Query memory: 0.041 MB Memory before query: 3.093 MB Rows returned: 5
    SELECT c.*,
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,u.name AS owner,ag.title AS access_level,COUNT(DISTINCT i.id) AS numitems
      FROM d6v9n_abcategories AS c
      LEFT JOIN d6v9n_users AS u
      ON u.id = c.checked_out
      LEFT JOIN d6v9n_viewlevels AS ag
      ON ag.id = c.access
      LEFT JOIN d6v9n_abbook AS i
      ON i.catid = c.id
      AND i.state = 1
      AND i.language in ('en-GB','*')
      WHERE c.level <= 1
      AND c.extension = 'com_abook'
      AND c.published =1
      AND c.access IN (1,1,5)
      GROUP BY c.id, c.language, c.level, c.lft, c.parent_id, c.path, c.rgt
      ORDER BY c.title ASC, c.lft, c.level
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEcALLcat_idx,idx_accessNO INDEX KEY COULD BE USEDNULLNULL9Using where; Using temporary; Using filesort
    1SIMPLEueq_refPRIMARYPRIMARY4ltmvxxbhosting_lib2.c.checked_out1Using where
    1SIMPLEageq_refPRIMARYPRIMARY4ltmvxxbhosting_lib2.c.access1Using where
    1SIMPLEiALLNULLNO INDEX KEY COULD BE USEDNULLNULL13Using where; Using join buffer (flat, BNL join)
    Profile
    StatusDuration
    Starting0.13 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.00 ms
    table lock0.01 ms
    init0.05 ms
    Optimizing0.02 ms
    Statistics0.06 ms
    Preparing0.03 ms
    Creating tmp table0.05 ms
    Creating tmp table0.05 ms
    Sorting result0.02 ms
    Executing0.00 ms
    Sending data0.15 ms
    Creating sort index0.09 ms
    Creating sort index0.05 ms
    Removing tmp table0.01 ms
    Creating sort index0.00 ms
    Removing tmp table0.00 ms
    Creating sort index0.01 ms
    End of update loop0.01 ms
    Removing tmp table0.00 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Removing tmp table0.00 ms
    Freeing items0.04 ms
    Updating status0.03 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    15JDatabaseDriverMysqli->execute()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:353
    14Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()JROOT/libraries/src/MVC/Model/ListModel.php:282
    13Joomla\CMS\MVC\Model\ListModel->getTotal()JROOT/libraries/src/MVC/Model/ListModel.php:232
    12Joomla\CMS\MVC\Model\ListModel->getPagination()JROOT/libraries/src/MVC/View/HtmlView.php:425
    11Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_abook/views/categories/view.html.php:49
    10AbookViewCategories->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_abook/controller.php:36
    8AbookController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_abook/abook.php:26
    6require_once JROOT/components/com_abook/abook.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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  16. Query Time: 1.44 ms After last query: 3.81 ms Query memory: 0.043 MB Memory before query: 3.264 MB Rows returned: 8
    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
                            c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
                            c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
                            c.path, c.published, c.rgt, c.title, c.modified_user_id, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
      FROM d6v9n_abcategories as c
      LEFT JOIN (SELECT cat.id as id
      FROM d6v9n_abcategories AS cat JOIN d6v9n_abcategories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_abook'
      AND parent.published != 1
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      WHERE (c.extension='com_abook' OR c.extension='system')
      AND c.access IN (1,1,5)
      AND c.published = 1
      AND badcats.id is null
      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id
      ORDER BY c.lft
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1PRIMARYcALLcat_idx,idx_accessNO INDEX KEY COULD BE USEDNULLNULL9Using where; Using temporary; Using filesort
    1PRIMARY<derived2>refkey0key05ltmvxxbhosting_lib2.c.id2Using where
    2DERIVEDparentrangecat_idx,idx_left_rightcat_idx153NULL2Using index condition; Using temporary; Using filesort
    2DERIVEDcatALLPRIMARY,idx_left_rightNO INDEX KEY COULD BE USEDNULLNULL9Range checked for each record (index map: 0x21)
    Profile
    StatusDuration
    Starting0.16 ms
    checking permissions0.01 ms
    Opening tables0.16 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.07 ms
    Optimizing0.02 ms
    Optimizing0.01 ms
    Statistics0.05 ms
    Statistics0.09 ms
    Preparing0.02 ms
    Creating tmp table0.01 ms
    Sorting result0.01 ms
    Preparing0.02 ms
    Creating tmp table0.05 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.03 ms
    Executing0.00 ms
    Sending data0.06 ms
    Creating sort index0.01 ms
    Removing tmp table0.01 ms
    Creating sort index0.22 ms
    Creating sort index0.09 ms
    Removing tmp table0.06 ms
    Creating sort index0.01 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.00 ms
    closing tables0.00 ms
    Removing tmp table0.01 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.05 ms
    Updating status0.03 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    22JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    21JDatabaseDriver->loadObjectList()JROOT/components/com_abook/helpers/category.php:134
    20AbookCategories->_load()JROOT/libraries/src/Categories/Categories.php:184
    19Joomla\CMS\Categories\Categories->get()JROOT/components/com_abook/helpers/route.php:91
    18AbookHelperRoute::getCategoryRoute()JROOT/components/com_abook/helpers/icon.php:104
    17JHtmlIcon::breadcrumb()Same as call in the line below.
    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/components/com_abook/views/categories/tmpl/default.php:38
    13include JROOT/components/com_abook/views/categories/tmpl/default.phpJROOT/libraries/src/MVC/View/HtmlView.php:701
    12Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/libraries/src/MVC/View/HtmlView.php:230
    11Joomla\CMS\MVC\View\HtmlView->display()JROOT/components/com_abook/views/categories/view.html.php:81
    10AbookViewCategories->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_abook/controller.php:36
    8AbookController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_abook/abook.php:26
    6require_once JROOT/components/com_abook/abook.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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  17. Query Time: 1.20 ms After last query: 8.27 ms Query memory: 0.030 MB Memory before query: 3.369 MB Rows returned: 4
    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM d6v9n_modules AS m
      LEFT JOIN d6v9n_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN d6v9n_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
      WHERE m.published = 1
      AND e.enabled = 1
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2025-07-04 13:22:24')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-07-04 13:22:24')
      AND m.access IN (1,1,5)
      AND m.client_id = 0
      AND (mm.menuid = 110 OR mm.menuid <= 0)
      ORDER BY m.position, m.ordering
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmrangePRIMARY,published,newsfeedspublished5NULL10Using index condition; Using where; Using filesort
    1SIMPLEmmrefPRIMARYPRIMARY4ltmvxxbhosting_lib2.m.id1Using where; Using index
    1SIMPLEerefelement_clientid,element_folder_clientidelement_clientid403ltmvxxbhosting_lib2.m.module,const1Using index condition; Using where
    Profile
    StatusDuration
    Starting0.13 ms
    checking permissions0.01 ms
    Opening tables0.16 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.04 ms
    Optimizing0.03 ms
    Statistics0.11 ms
    Preparing0.04 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.42 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.05 ms
    Updating status0.03 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    14JDatabaseDriver->loadObjectList()Same as call in the line below.
    13call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    12Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Helper/ModuleHelper.php:432
    11Joomla\CMS\Helper\ModuleHelper::getModuleList()JROOT/libraries/src/Helper/ModuleHelper.php:362
    10Joomla\CMS\Helper\ModuleHelper::load()JROOT/libraries/src/Helper/ModuleHelper.php:87
    9Joomla\CMS\Helper\ModuleHelper::getModules()JROOT/libraries/src/Document/HtmlDocument.php:591
    8Joomla\CMS\Document\HtmlDocument->countModules()JROOT/templates/protostar/index.php:100
    7require JROOT/templates/protostar/index.phpJROOT/libraries/src/Document/HtmlDocument.php:668
    6Joomla\CMS\Document\HtmlDocument->_loadTemplate()JROOT/libraries/src/Document/HtmlDocument.php:730
    5Joomla\CMS\Document\HtmlDocument->_fetchTemplate()JROOT/libraries/src/Document/HtmlDocument.php:545
    4Joomla\CMS\Document\HtmlDocument->parse()JROOT/libraries/src/Application/CMSApplication.php:1030
    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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  18. Query Time: 0.75 ms After last query: 5.70 ms Query memory: 0.026 MB Memory before query: 3.468 MB Rows returned: 1
    select SUM(count) 
      from d6v9n_visitors_country
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEd6v9n_visitors_countryALLNULLNO INDEX KEY COULD BE USEDNULLNULL7
    Profile
    StatusDuration
    Starting0.08 ms
    checking permissions0.01 ms
    Opening tables0.05 ms
    After opening tables0.01 ms
    System lock0.00 ms
    table lock0.01 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.02 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.34 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.04 ms
    Updating status0.03 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    13JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    12JDatabaseDriver->loadResult()JROOT/modules/mod_jsvisit_counter/helper.php:151
    11jsvisit_counter\module\mod_jsvisit_counterHelper->getCountries()JROOT/modules/mod_jsvisit_counter/mod_jsvisit_counter.php:177
    10include JROOT/modules/mod_jsvisit_counter/mod_jsvisit_counter.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:501
    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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  19. Query Time: 0.23 ms After last query: 0.05 ms Query memory: 0.026 MB Memory before query: 3.477 MB Rows returned: 1
    select count(*) 
      from d6v9n_visitors_country
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLENULLNULLNULLNO INDEX KEY COULD BE USEDNULLNULLNULLSelect tables optimized away
    Profile
    StatusDuration
    Starting0.05 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.01 ms
    init0.01 ms
    Optimizing0.01 ms
    Executing0.01 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.03 ms
    Updating status0.03 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    13JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    12JDatabaseDriver->loadResult()JROOT/modules/mod_jsvisit_counter/helper.php:163
    11jsvisit_counter\module\mod_jsvisit_counterHelper->getCountries()JROOT/modules/mod_jsvisit_counter/mod_jsvisit_counter.php:177
    10include JROOT/modules/mod_jsvisit_counter/mod_jsvisit_counter.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:501
    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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  20. Query Time: 0.32 ms After last query: 0.03 ms Query memory: 0.027 MB Memory before query: 3.486 MB Rows returned: 5
    SELECT country, name, count 
      FROM d6v9n_visitors_country
      ORDER BY count DESC
      LIMIT 5
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEd6v9n_visitors_countryALLNULLNO INDEX KEY COULD BE USEDNULLNULL7Using filesort
    Profile
    StatusDuration
    Starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.01 ms
    Preparing0.01 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.02 ms
    Creating sort index0.04 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.03 ms
    Updating status0.03 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    13JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    12JDatabaseDriver->loadObjectList()JROOT/modules/mod_jsvisit_counter/helper.php:171
    11jsvisit_counter\module\mod_jsvisit_counterHelper->getCountries()JROOT/modules/mod_jsvisit_counter/mod_jsvisit_counter.php:177
    10include JROOT/modules/mod_jsvisit_counter/mod_jsvisit_counter.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:501
    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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  21. Query Time: 0.55 ms After last query: 0.04 ms Query memory: 0.027 MB Memory before query: 3.497 MB Rows returned: 1
    Duplicate queries: #22  #29  #30
    select count 
      from d6v9n_visitors
      where id = '7'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEd6v9n_visitorsconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    Starting0.05 ms
    checking permissions0.00 ms
    Opening tables0.05 ms
    After opening tables0.01 ms
    System lock0.00 ms
    table lock0.01 ms
    init0.01 ms
    Optimizing0.02 ms
    Statistics0.20 ms
    Preparing0.01 ms
    Unlocking tables0.00 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.01 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.04 ms
    Updating status0.03 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    13JDatabaseDriver->loadResult()JROOT/modules/mod_jsvisit_counter/helper.php:387
    12jsvisit_counter\module\mod_jsvisit_counterHelper->getVisitors()JROOT/modules/mod_jsvisit_counter/helper.php:175
    11jsvisit_counter\module\mod_jsvisit_counterHelper->getCountries()JROOT/modules/mod_jsvisit_counter/mod_jsvisit_counter.php:177
    10include JROOT/modules/mod_jsvisit_counter/mod_jsvisit_counter.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:501
    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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  22. Query Time: 0.27 ms After last query: 0.04 ms Query memory: 0.027 MB Memory before query: 3.507 MB Rows returned: 1
    Duplicate queries: #21  #29  #30
    select count 
      from d6v9n_visitors
      where id = '7'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEd6v9n_visitorsconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    Starting0.05 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.01 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.02 ms
    Preparing0.00 ms
    Unlocking tables0.00 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.01 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.03 ms
    Updating status0.03 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1550
    13JDatabaseDriver->loadColumn()JROOT/modules/mod_jsvisit_counter/helper.php:393
    12jsvisit_counter\module\mod_jsvisit_counterHelper->getVisitors()JROOT/modules/mod_jsvisit_counter/helper.php:175
    11jsvisit_counter\module\mod_jsvisit_counterHelper->getCountries()JROOT/modules/mod_jsvisit_counter/mod_jsvisit_counter.php:177
    10include JROOT/modules/mod_jsvisit_counter/mod_jsvisit_counter.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:501
    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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  23. Query Time: 0.28 ms After last query: 0.09 ms Query memory: 0.026 MB Memory before query: 3.514 MB Rows returned: 1
    Duplicate queries: #24
    select count 
      from d6v9n_visitors
      where id = '1'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEd6v9n_visitorsconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    Starting0.05 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.02 ms
    Preparing0.00 ms
    Unlocking tables0.00 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.01 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.05 ms
    Updating status0.03 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    13JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    12JDatabaseDriver->loadResult()JROOT/modules/mod_jsvisit_counter/helper.php:387
    11jsvisit_counter\module\mod_jsvisit_counterHelper->getVisitors()JROOT/modules/mod_jsvisit_counter/mod_jsvisit_counter.php:203
    10include JROOT/modules/mod_jsvisit_counter/mod_jsvisit_counter.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:501
    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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  24. Query Time: 0.25 ms After last query: 0.03 ms Query memory: 0.026 MB Memory before query: 3.523 MB Rows returned: 1
    Duplicate queries: #23
    select count 
      from d6v9n_visitors
      where id = '1'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEd6v9n_visitorsconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    Starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.02 ms
    Preparing0.00 ms
    Unlocking tables0.00 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.01 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.04 ms
    Updating status0.03 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    13JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1550
    12JDatabaseDriver->loadColumn()JROOT/modules/mod_jsvisit_counter/helper.php:393
    11jsvisit_counter\module\mod_jsvisit_counterHelper->getVisitors()JROOT/modules/mod_jsvisit_counter/mod_jsvisit_counter.php:203
    10include JROOT/modules/mod_jsvisit_counter/mod_jsvisit_counter.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:501
    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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  25. Query Time: 0.25 ms After last query: 0.04 ms Query memory: 0.026 MB Memory before query: 3.531 MB Rows returned: 1
    Duplicate queries: #26
    select count 
      from d6v9n_visitors
      where id = '3'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEd6v9n_visitorsconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    Starting0.05 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.01 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.02 ms
    Preparing0.00 ms
    Unlocking tables0.00 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.01 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.03 ms
    Updating status0.03 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    13JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    12JDatabaseDriver->loadResult()JROOT/modules/mod_jsvisit_counter/helper.php:387
    11jsvisit_counter\module\mod_jsvisit_counterHelper->getVisitors()JROOT/modules/mod_jsvisit_counter/mod_jsvisit_counter.php:219
    10include JROOT/modules/mod_jsvisit_counter/mod_jsvisit_counter.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:501
    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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  26. Query Time: 0.25 ms After last query: 0.04 ms Query memory: 0.026 MB Memory before query: 3.540 MB Rows returned: 1
    Duplicate queries: #25
    select count 
      from d6v9n_visitors
      where id = '3'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEd6v9n_visitorsconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    Starting0.05 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.02 ms
    Preparing0.00 ms
    Unlocking tables0.00 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.01 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.03 ms
    Updating status0.03 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    13JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1550
    12JDatabaseDriver->loadColumn()JROOT/modules/mod_jsvisit_counter/helper.php:393
    11jsvisit_counter\module\mod_jsvisit_counterHelper->getVisitors()JROOT/modules/mod_jsvisit_counter/mod_jsvisit_counter.php:219
    10include JROOT/modules/mod_jsvisit_counter/mod_jsvisit_counter.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:501
    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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  27. Query Time: 0.25 ms After last query: 0.03 ms Query memory: 0.026 MB Memory before query: 3.549 MB Rows returned: 1
    Duplicate queries: #28
    select count 
      from d6v9n_visitors
      where id = '5'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEd6v9n_visitorsconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    Starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.02 ms
    Preparing0.00 ms
    Unlocking tables0.00 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.01 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.03 ms
    Updating status0.03 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    13JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    12JDatabaseDriver->loadResult()JROOT/modules/mod_jsvisit_counter/helper.php:387
    11jsvisit_counter\module\mod_jsvisit_counterHelper->getVisitors()JROOT/modules/mod_jsvisit_counter/mod_jsvisit_counter.php:235
    10include JROOT/modules/mod_jsvisit_counter/mod_jsvisit_counter.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:501
    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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  28. Query Time: 0.25 ms After last query: 0.02 ms Query memory: 0.026 MB Memory before query: 3.557 MB Rows returned: 1
    Duplicate queries: #27
    select count 
      from d6v9n_visitors
      where id = '5'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEd6v9n_visitorsconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    Starting0.05 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.02 ms
    Preparing0.00 ms
    Unlocking tables0.00 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.01 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.04 ms
    Updating status0.03 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    13JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1550
    12JDatabaseDriver->loadColumn()JROOT/modules/mod_jsvisit_counter/helper.php:393
    11jsvisit_counter\module\mod_jsvisit_counterHelper->getVisitors()JROOT/modules/mod_jsvisit_counter/mod_jsvisit_counter.php:235
    10include JROOT/modules/mod_jsvisit_counter/mod_jsvisit_counter.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:501
    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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  29. Query Time: 0.25 ms After last query: 0.04 ms Query memory: 0.027 MB Memory before query: 3.566 MB Rows returned: 1
    Duplicate queries: #21  #22  #30
    select count 
      from d6v9n_visitors
      where id = '7'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEd6v9n_visitorsconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    Starting0.05 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.02 ms
    Preparing0.00 ms
    Unlocking tables0.00 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.01 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.03 ms
    Updating status0.03 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    13JDatabaseDriver->loadResult()JROOT/modules/mod_jsvisit_counter/helper.php:387
    12jsvisit_counter\module\mod_jsvisit_counterHelper->getVisitors()JROOT/modules/mod_jsvisit_counter/helper.php:353
    11jsvisit_counter\module\mod_jsvisit_counterHelper->getCounter()JROOT/modules/mod_jsvisit_counter/mod_jsvisit_counter.php:265
    10include JROOT/modules/mod_jsvisit_counter/mod_jsvisit_counter.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:501
    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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  30. Query Time: 0.26 ms After last query: 0.03 ms Query memory: 0.027 MB Memory before query: 3.575 MB Rows returned: 1
    Duplicate queries: #21  #22  #29
    select count 
      from d6v9n_visitors
      where id = '7'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEd6v9n_visitorsconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    Starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.01 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.02 ms
    Preparing0.00 ms
    Unlocking tables0.00 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.01 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.04 ms
    Updating status0.03 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1550
    13JDatabaseDriver->loadColumn()JROOT/modules/mod_jsvisit_counter/helper.php:393
    12jsvisit_counter\module\mod_jsvisit_counterHelper->getVisitors()JROOT/modules/mod_jsvisit_counter/helper.php:353
    11jsvisit_counter\module\mod_jsvisit_counterHelper->getCounter()JROOT/modules/mod_jsvisit_counter/mod_jsvisit_counter.php:265
    10include JROOT/modules/mod_jsvisit_counter/mod_jsvisit_counter.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:501
    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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

19 Query Types Logged, Sorted by Occurrences.

SELECT Tables:
  1. 10 × select count 
      from d6v9n_visitors
  2. 2 × SELECT c.*,
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,u.name AS owner,ag.title AS access_level,COUNT(DISTINCT i.id) AS numitems
      FROM d6v9n_abcategories AS c
      LEFT JOIN d6v9n_users AS u
      ON u.id = c.checked_out
      LEFT JOIN d6v9n_viewlevels AS ag
      ON ag.id = c.access
      LEFT JOIN d6v9n_abbook AS i
      ON i.catid = c.id
      AND i.state = 1
      AND i.language in ('en-GB','*')
  3. 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
      FROM `d6v9n_extensions`
  4. 1 × SELECT country, name, count 
      FROM d6v9n_visitors_country
  5. 1 × select count(*) 
      from d6v9n_visitors_countr
  6. 1 × select SUM(count) 
      from d6v9n_visitors_countr
  7. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
      FROM d6v9n_modules AS m
      LEFT JOIN d6v9n_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN d6v9n_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
  8. 1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
                             c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
                             c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
                             c.path, c.published, c.rgt, c.title, c.modified_user_id, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
      FROM d6v9n_abcategories as c
      LEFT JOIN (SELECT cat.id as id
      FROM d6v9n_abcategories AS cat JOIN d6v9n_abcategories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
  9. 1 × SELECT * 
      FROM d6v9n_abcategories
  10. 1 × SELECT `data` 
      FROM `d6v9n_session`
  11. 1 × SELECT `session_id` 
      FROM `d6v9n_session`
  12. 1 × SELECT * 
      FROM d6v9n_languages
  13. 1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
      FROM d6v9n_menu AS m
      LEFT JOIN d6v9n_extensions AS e
      ON m.component_id = e.extension_id
  14. 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
      FROM d6v9n_extensions
  15. 1 × SELECT b.id 
      FROM d6v9n_usergroups AS a
      LEFT JOIN d6v9n_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
  16. 1 × SELECT id, rules 
      FROM `d6v9n_viewlevels
  17. 1 × SELECT id, home, template, s.params 
      FROM d6v9n_template_styles as s
      LEFT JOIN d6v9n_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
OTHER Tables:
  1. 1 × INSERT INTO `d6v9n_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES (X'62356d333636653972626a6f646b7173717062766e32756b3130', 1, 1751635344, 0, '', 0
  2. 1 × UPDATE `d6v9n_extensions` 
      SET `params` = '{\"mediaversion\":\"8d9d9af88274b08275aa1ae87d7c6702\"}'