• Ruko Rose Garden 5 No.96, Galaxy City, Indonesia
  • +62 21 82751187
  • CALL US (WHATSAPP)

trimaprimamandiri.com

  • Bahasa Indonesia Bahasa Indonesia
  • English (UK) English (UK)
  • HOME
  • PROFILE
    • COMPANY AT GLANCE
    • VISION & MISSION
    • LEGALITIES
    • OUR CLIENTS
    • OUR FLEET
  • CORE BUSINESS
    • FORWARDING COMPANY
    • HIGH SPEED DIESEL OIL SUPPLIES
    • MEDICAL EQUIPMENT & SERVICES
    • OTHER SERVICES
  • GALLERY
  • CONTACT US
  • EVENT
    • CHRISTMAS

  • MEDICAL EQUIPMENT AND DEVICES

    We market and distribute licensed medical appliances with competitive price

  • OUR TEAM

    Our dedicated and experienced personnel work tirelessly to customized solutions and support clients requirement effectively

  • LOGISTIC SERVICES & FREIGHT FORWARDING

    We guarantee safe, on-time delivery and offer high-quality services at the most affordable rate

  • OUR FLEET

    Young and sophisticated fleet, deep industry expertise and a strong commitment to high standards of safety and quality

  • HIGH SPEED DIESEL OIL SUPPLIES

    We assure customers to provide and deliver best quality of diesel oil
prev next

DISTRIBUTOR

Market and distribute licensed medical appliances with competitive price
Reliable to support hospitals, privates and all companies

FORWARDING COMPANY

Guarantee safe, on-time delivery and offer quality services
Provide and arrange the fastest, the most convenient routing

SUPPLIER

All industrial sector can purchase diesel oil directly to us
Assure customers to provide and deliver the best quality of diesel oil in promising special prices

PRODUCT & FLEET

It’s Suitable for Corporate, Creative, Personal, Noncommercial Needs

  • All
  • MEDICAL EQUIPMENT
  • FORWARDING
  • FLEET
  • FORWARDING
  • DIESEL OIL
  • ekspedisi
    FORWARDING
  • FORWARDING
    FORWARDING
  • DIESEL OIL
    DIESEL OIL
  • pengiriman ke rs
    FORWARDING
  • ekspedisi
    FORWARDING
  • FLEET
    FLEET
  • ekspedisi
    FORWARDING
  • ekspedisi
    FORWARDING

OUR BEST PROFESSIONALS TEAM

  • TEAM
  • TEAM
  • TEAM
  • TEAM
  • TEAM

OUR CUSTOMERS

Paramount Bed Indonesia

PT Dua Putra Prameswari

PT Pratamindo Mitra Rizky

 

 

PT. Dwi Mitra Ekatama Mandiri

PT. Daya Multi Elektrindo

PT. WIjaya Karya

 

 

PT. Samudera Energi Tangguh

PT. Duta Wisata Loka

PT. Berkah Dental Indonesia

 

 

PT. Airindo Sentra Medika

PT. Metropolitan Permata Development
 

 

 

PT Trima Prima Mandiri

Copyright 2020 www.trimaprimamandiri.com. Powered by PT Trima Prima Mandiri

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1674793684,
                "last": 1674793684,
                "now": 1674793684
            }
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "plg_system_languagefilter": {
            "language": "en-GB"
        }
    }
}

Profile Information

Time

Memory

Time: 0.00 ms / 0.00 ms Memory: 0.884 MB / 0.88 MB Application: afterLoad
Time: 110.86 ms / 110.87 ms Memory: 1.372 MB / 2.26 MB Application: afterInitialise
Time: 25.53 ms / 136.40 ms Memory: 0.277 MB / 2.53 MB Application: afterRoute
Time: 0.36 ms / 136.76 ms Memory: 0.016 MB / 2.55 MB Application: beforeRenderComponent com_content
Time: 12.70 ms / 149.46 ms Memory: 0.131 MB / 2.68 MB Application: Before Access::preloadComponents (all components)
Time: 1.55 ms / 151.01 ms Memory: 0.055 MB / 2.74 MB Application: After Access::preloadComponents (all components)
Time: 0.03 ms / 151.04 ms Memory: 0.000 MB / 2.73 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Time: 0.88 ms / 151.92 ms Memory: 0.008 MB / 2.74 MB Application: After Access::getAssetRules (id:8 name:com_content)
Time: 17.59 ms / 169.51 ms Memory: 0.125 MB / 2.86 MB Application: afterRenderComponent com_content
Time: 7.97 ms / 177.48 ms Memory: 0.027 MB / 2.89 MB Application: afterDispatch
Time: 6.13 ms / 183.61 ms Memory: 0.172 MB / 3.06 MB Application: beforeRenderModule mod_custom (OUR CUSTOMER)
Time: 1.31 ms / 184.92 ms Memory: 0.006 MB / 3.07 MB Application: afterRenderModule mod_custom (OUR CUSTOMER)
Time: 0.03 ms / 184.94 ms Memory: 0.000 MB / 3.07 MB Application: beforeRenderModule mod_custom (Footer 2)
Time: 0.17 ms / 185.12 ms Memory: 0.003 MB / 3.07 MB Application: afterRenderModule mod_custom (Footer 2)
Time: 0.03 ms / 185.14 ms Memory: 0.038 MB / 3.11 MB Application: beforeRenderModule mod_custom (Footer 3)
Time: 0.14 ms / 185.29 ms Memory: 0.003 MB / 3.11 MB Application: afterRenderModule mod_custom (Footer 3)
Time: 0.02 ms / 185.31 ms Memory: 0.000 MB / 3.11 MB Application: beforeRenderModule mod_custom (Footer 4)
Time: 0.15 ms / 185.45 ms Memory: 0.004 MB / 3.11 MB Application: afterRenderModule mod_custom (Footer 4)
Time: 0.05 ms / 185.50 ms Memory: 0.004 MB / 3.12 MB Application: beforeRenderModule mod_k2_content (OUR BEST PROFESSIONALS TEAM)
Time: 20.72 ms / 206.23 ms Memory: 0.167 MB / 3.29 MB Application: afterRenderModule mod_k2_content (OUR BEST PROFESSIONALS TEAM)
Time: 0.06 ms / 206.29 ms Memory: 0.000 MB / 3.23 MB Application: beforeRenderModule mod_k2_content (PRODUCT & FLEET)
Time: 10.63 ms / 216.92 ms Memory: 0.168 MB / 3.40 MB Application: afterRenderModule mod_k2_content (PRODUCT & FLEET)
Time: 0.06 ms / 216.97 ms Memory: 0.000 MB / 3.30 MB Application: beforeRenderModule mod_custom (KONSULTAN (2))
Time: 0.18 ms / 217.16 ms Memory: 0.003 MB / 3.31 MB Application: afterRenderModule mod_custom (KONSULTAN (2))
Time: 0.02 ms / 217.18 ms Memory: 0.000 MB / 3.30 MB Application: beforeRenderModule mod_custom (SERVICE (2))
Time: 0.14 ms / 217.32 ms Memory: 0.003 MB / 3.31 MB Application: afterRenderModule mod_custom (SERVICE (2))
Time: 0.02 ms / 217.34 ms Memory: 0.000 MB / 3.31 MB Application: beforeRenderModule mod_custom (KEUNGGULAN (2))
Time: 0.14 ms / 217.48 ms Memory: 0.003 MB / 3.31 MB Application: afterRenderModule mod_custom (KEUNGGULAN (2))
Time: 0.10 ms / 217.58 ms Memory: 0.026 MB / 3.34 MB Application: beforeRenderModule mod_jfslideshow (JF slideshow)
Time: 1.94 ms / 219.53 ms Memory: 0.055 MB / 3.39 MB Application: afterRenderModule mod_jfslideshow (JF slideshow)
Time: 0.05 ms / 219.58 ms Memory: 0.000 MB / 3.34 MB Application: beforeRenderModule mod_menu (Main Menu)
Time: 4.07 ms / 223.65 ms Memory: 0.145 MB / 3.48 MB Application: afterRenderModule mod_menu (Main Menu)
Time: 0.05 ms / 223.70 ms Memory: 0.000 MB / 3.48 MB Application: beforeRenderModule mod_languages (Language Switcher)
Time: 1.97 ms / 225.67 ms Memory: 0.017 MB / 3.50 MB Application: afterRenderModule mod_languages (Language Switcher)
Time: 0.05 ms / 225.72 ms Memory: 0.000 MB / 3.50 MB Application: beforeRenderModule mod_search (Search form)
Time: 1.07 ms / 226.79 ms Memory: 0.014 MB / 3.51 MB Application: afterRenderModule mod_search (Search form)
Time: 0.06 ms / 226.85 ms Memory: 0.000 MB / 3.51 MB Application: beforeRenderModule mod_custom (Top info)
Time: 2.91 ms / 229.76 ms Memory: 0.042 MB / 3.55 MB Application: afterRenderModule mod_custom (Top info)
Time: 5.31 ms / 235.07 ms Memory: 0.169 MB / 3.72 MB Application: afterRender

Database queries total: 31.62 ms

Memory Usage

4.19 MB (4,396,272 Bytes)

Database Queries

36 Queries Logged 31.62 ms


10 duplicate found!

5 duplicates: #21  #23  #25  #27  #29
5 duplicates: #22  #24  #26  #28  #30
  1. Query Time: 1.31 ms Query memory: 0.023 MB Memory before query: 1.302 MB Rows returned: 0
    SELECT `data`

      FROM `alkes_session`

      WHERE `session_id` = '73267f64b9e925321693ecf43418fa9f'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEalkes_sessionconstPRIMARYPRIMARY194const1
    Profile
    StatusDuration
    starting0.13 ms
    checking permissions0.01 ms
    Opening tables0.79 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.03 ms
    optimizing0.02 ms
    statistics0.05 ms
    preparing0.01 ms
    executing0.02 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.02 ms
    freeing items0.06 ms
    updating status0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1734
    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:37
    [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.24 ms Query memory: 0.020 MB Memory before query: 1.316 MB Rows returned: 0
    SELECT `session_id`

      FROM `alkes_session`

      WHERE `session_id` = '73267f64b9e925321693ecf43418fa9f' 
      LIMIT 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEalkes_sessionconstPRIMARYPRIMARY194const1Using index
    Profile
    StatusDuration
    starting0.09 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.02 ms
    init0.02 ms
    optimizing0.02 ms
    statistics0.03 ms
    preparing0.01 ms
    executing0.02 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    freeing items0.06 ms
    updating status0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    9JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1734
    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:37
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]
  3. Query Time: 0.85 ms After last query: 0.06 ms Query memory: 0.004 MB Memory before query: 1.321 MB
    INSERT INTO `alkes_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES 
('73267f64b9e925321693ecf43418fa9f', 1, 1674793684, 0, '', 0)
    Explain
    EXPLAIN not possible on query: INSERT INTO `alkes_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('73267f64b9e925321693ecf43418fa9f', 1, 1674793684, 0, '', 0)
    Profile
    StatusDuration
    starting0.10 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
    update0.13 ms
    Waiting for query cache lock0.02 ms
    update0.02 ms
    end0.02 ms
    query end0.29 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    freeing items0.05 ms
    updating status0.01 ms
    cleaning up0.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:37
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]
  4. Query Time: 1.14 ms After last query: 5.41 ms Query memory: 0.040 MB Memory before query: 1.416 MB Rows returned: 36
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

      FROM `alkes_extensions`

      WHERE `type` = 'component' 
      AND `state` = 0 
      AND `enabled` = 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEalkes_extensionsrefextensionextension82const36Using index condition; Using where
    Profile
    StatusDuration
    starting0.10 ms
    checking permissions0.01 ms
    Opening tables0.37 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.02 ms
    optimizing0.02 ms
    statistics0.08 ms
    preparing0.03 ms
    executing0.01 ms
    Sending data0.30 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    freeing items0.08 ms
    updating status0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    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:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]
  5. Query Time: 0.67 ms After last query: 4.51 ms Query memory: 0.021 MB Memory before query: 1.454 MB Rows returned: 5
    SELECT id, rules

      FROM `alkes_viewlevels`
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEalkes_viewlevelsALLNULLNO INDEX KEY COULD BE USEDNULLNULL5
    Profile
    StatusDuration
    starting0.07 ms
    checking permissions0.01 ms
    Opening tables0.32 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.01 ms
    Sending data0.03 ms
    end0.01 ms
    query end0.02 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    freeing items0.05 ms
    updating status0.01 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1500
    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:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]
  6. Query Time: 0.78 ms After last query: 0.07 ms Query memory: 0.021 MB Memory before query: 1.466 MB Rows returned: 2
    SELECT b.id

      FROM alkes_usergroups AS a

      LEFT JOIN alkes_usergroups AS b 
      ON b.lft <= a.lft 
      AND b.rgt >= a.rgt

      WHERE a.id = 9
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaconstPRIMARYPRIMARY4const1
    1SIMPLEbindexidx_usergroup_nested_set_lookupidx_usergroup_nested_set_lookup8NULL9Using where; Using index
    Profile
    StatusDuration
    starting0.07 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.39 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.06 ms
    preparing0.01 ms
    Unlocking tables0.02 ms
    executing0.01 ms
    Sending data0.03 ms
    end0.01 ms
    query end0.02 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    freeing items0.05 ms
    updating status0.01 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1544
    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:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]
  7. Query Time: 1.21 ms After last query: 1.64 ms Query memory: 0.030 MB Memory before query: 1.488 MB Rows returned: 81
    SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

      FROM alkes_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
    1SIMPLEalkes_extensionsrefextensionextension82const102Using index condition; Using where; Using filesort
    Profile
    StatusDuration
    starting0.09 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.02 ms
    optimizing0.02 ms
    statistics0.06 ms
    preparing0.03 ms
    Sorting result0.01 ms
    executing0.01 ms
    Sending data0.01 ms
    Creating sort index0.69 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    freeing items0.05 ms
    updating status0.01 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    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:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]
  8. Query Time: 1.07 ms After last query: 1.68 ms Query memory: 0.020 MB Memory before query: 1.528 MB Rows returned: 2
    SELECT *

      FROM alkes_languages

      WHERE published=1

      ORDER BY ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEalkes_languagesALLNULLNO INDEX KEY COULD BE USEDNULLNULL3Using where; Using filesort
    Profile
    StatusDuration
    starting0.12 ms
    checking permissions0.01 ms
    Opening tables0.49 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.03 ms
    optimizing0.02 ms
    statistics0.02 ms
    preparing0.02 ms
    Sorting result0.01 ms
    executing0.01 ms
    Sending data0.02 ms
    Creating sort index0.06 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    freeing items0.05 ms
    updating status0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    7JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    6JDatabaseDriver->loadObjectList()JROOT/libraries/src/Language/LanguageHelper.php:150
    5Joomla\CMS\Language\LanguageHelper::getLanguages()JROOT/libraries/src/Language/LanguageHelper.php:67
    4Joomla\CMS\Language\LanguageHelper::detectLanguage()JROOT/libraries/src/Application/SiteApplication.php:653
    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:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]
  9. Query Time: 0.54 ms After last query: 19.02 ms Query memory: 0.021 MB Memory before query: 1.863 MB Rows returned: 6
    SELECT `element`,`name`,`client_id`,`extension_id`

      FROM `alkes_extensions`

      WHERE `type` = 'language' 
      AND `state` = 0 
      AND `enabled` = 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEalkes_extensionsrefextensionextension82const6Using index condition; Using where
    Profile
    StatusDuration
    starting0.10 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.07 ms
    preparing0.03 ms
    executing0.01 ms
    Sending data0.06 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    freeing items0.05 ms
    updating status0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    9JDatabaseDriver->loadObjectList()JROOT/libraries/src/Language/LanguageHelper.php:209
    8Joomla\CMS\Language\LanguageHelper::getInstalledLanguages()JROOT/plugins/system/languagefilter/languagefilter.php:110
    7PlgSystemLanguageFilter->__construct()JROOT/libraries/src/Plugin/PluginHelper.php:283
    6Joomla\CMS\Plugin\PluginHelper::import()JROOT/libraries/src/Plugin/PluginHelper.php:182
    5Joomla\CMS\Plugin\PluginHelper::importPlugin()JROOT/libraries/src/Application/CMSApplication.php:625
    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:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]
  10. Query Time: 0.66 ms After last query: 11.68 ms Query memory: 0.024 MB Memory before query: 1.988 MB Rows returned: 1
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

      FROM `alkes_extensions`

      WHERE `type` = 'library' 
      AND `element` = 'joomla'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEalkes_extensionsrefelement_clientid,element_folder_clientid,extensionextension484const,const1Using index condition
    Profile
    StatusDuration
    starting0.10 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.12 ms
    preparing0.04 ms
    executing0.01 ms
    Sending data0.09 ms
    end0.02 ms
    query end0.03 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    freeing items0.06 ms
    updating status0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1656
    18JDatabaseDriver->loadObject()JROOT/libraries/src/Helper/LibraryHelper.php:167
    17Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()Same as call in the line below.
    16call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Helper/LibraryHelper.php:175
    14Joomla\CMS\Helper\LibraryHelper::loadLibrary()JROOT/libraries/src/Helper/LibraryHelper.php:43
    13Joomla\CMS\Helper\LibraryHelper::getLibrary()JROOT/libraries/src/Helper/LibraryHelper.php:90
    12Joomla\CMS\Helper\LibraryHelper::getParams()JROOT/libraries/src/Version.php:321
    11Joomla\CMS\Version->getMediaVersion()JROOT/libraries/src/Factory.php:778
    10Joomla\CMS\Factory::createDocument()JROOT/libraries/src/Factory.php:234
    9Joomla\CMS\Factory::getDocument()JROOT/plugins/system/k2/k2.php:47
    8plgSystemK2->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:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]
  11. Query Time: 0.86 ms After last query: 0.13 ms Query memory: 0.006 MB Memory before query: 1.981 MB
    UPDATE `alkes_extensions`

      SET `params` = '{\"mediaversion\":\"197ef06ee3e8669e47af14b4af9d58c7\"}'

      WHERE `type` = 'library' 
      AND `element` = 'joomla'
    Explain
    EXPLAIN not possible on query: UPDATE `alkes_extensions` SET `params` = '{\"mediaversion\":\"197ef06ee3e8669e47af14b4af9d58c7\"}' WHERE `type` = 'library' AND `element` = 'joomla'
    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.09 ms
    updating0.11 ms
    end0.01 ms
    Waiting for query cache lock0.01 ms
    end0.01 ms
    query end0.33 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    freeing items0.06 ms
    updating status0.01 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/src/Helper/LibraryHelper.php:117
    13Joomla\CMS\Helper\LibraryHelper::saveParams()JROOT/libraries/src/Version.php:372
    12Joomla\CMS\Version->setMediaVersion()JROOT/libraries/src/Version.php:331
    11Joomla\CMS\Version->getMediaVersion()JROOT/libraries/src/Factory.php:778
    10Joomla\CMS\Factory::createDocument()JROOT/libraries/src/Factory.php:234
    9Joomla\CMS\Factory::getDocument()JROOT/plugins/system/k2/k2.php:47
    8plgSystemK2->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:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]
  12. Query Time: 1.73 ms After last query: 12.84 ms Query memory: 0.069 MB Memory before query: 2.113 MB Rows returned: 40
    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 alkes_menu AS m

      LEFT JOIN alkes_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
    1SIMPLEmrefidx_client_id_parent_id_alias_languageidx_client_id_parent_id_alias_language1const76Using index condition; Using where; Using filesort
    1SIMPLEeeq_refPRIMARYPRIMARY4trip4732_db_kesehatan.m.component_id1Using where
    Profile
    StatusDuration
    starting0.10 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.47 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.02 ms
    optimizing0.02 ms
    statistics0.07 ms
    preparing0.03 ms
    Sorting result0.01 ms
    executing0.01 ms
    Sending data0.03 ms
    Creating sort index0.75 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    freeing items0.05 ms
    updating status0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    23JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    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/languagefilter/languagefilter.php:145
    8PlgSystemLanguageFilter->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:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]
  13. Query Time: 0.95 ms After last query: 26.27 ms Query memory: 0.025 MB Memory before query: 2.519 MB Rows returned: 5
    SELECT id, home, template, s.params

      FROM alkes_template_styles as s

      LEFT JOIN alkes_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
    1SIMPLEerefelement_clientid,element_folder_clientid,extensionextension82const5Using index condition; Using where
    1SIMPLEsALLidx_templateNO INDEX KEY COULD BE USEDNULLNULL7Using where; Using join buffer (flat, BNL join)
    Profile
    StatusDuration
    starting0.10 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.27 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.03 ms
    optimizing0.03 ms
    statistics0.08 ms
    preparing0.04 ms
    executing0.01 ms
    Sending data0.14 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.02 ms
    freeing items0.06 ms
    updating status0.01 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    20JDatabaseDriver->loadObjectList()JROOT/libraries/src/Application/SiteApplication.php:486
    19Joomla\CMS\Application\SiteApplication->getTemplate()JROOT/libraries/src/HTML/HTMLHelper.php:365
    18Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles()JROOT/libraries/src/HTML/HTMLHelper.php:712
    17Joomla\CMS\HTML\HTMLHelper::script()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/libraries/cms/html/jquery.php:52
    13JHtmlJquery::framework()Same as call in the line below.
    12call_user_func_array()JROOT/libraries/src/HTML/HTMLHelper.php:239
    11Joomla\CMS\HTML\HTMLHelper::call()JROOT/libraries/src/HTML/HTMLHelper.php:146
    10Joomla\CMS\HTML\HTMLHelper::_()JROOT/administrator/components/com_k2/helpers/html.php:259
    9K2HelperHTML::loadHeadIncludes()JROOT/plugins/system/k2/k2.php:438
    8plgSystemK2->onAfterRoute()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:1122
    4Joomla\CMS\Application\CMSApplication->route()JROOT/libraries/src/Application/SiteApplication.php:796
    3Joomla\CMS\Application\SiteApplication->route()JROOT/libraries/src/Application/SiteApplication.php:218
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]
  14. Query Time: 1.41 ms After last query: 14.35 ms Query memory: 0.028 MB Memory before query: 2.684 MB Rows returned: 36
    SELECT `id`,`name`,`rules`,`parent_id`

      FROM `alkes_assets`

      WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_joomlaupdate','com_k2','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')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEalkes_assetsrangeidx_asset_nameidx_asset_name202NULL37Using index condition
    Profile
    StatusDuration
    starting0.10 ms
    checking permissions0.01 ms
    Opening tables0.39 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.02 ms
    init0.05 ms
    optimizing0.01 ms
    statistics0.12 ms
    preparing0.02 ms
    executing0.01 ms
    Sending data0.52 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    freeing items0.05 ms
    updating status0.01 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    20JDatabaseDriver->loadObjectList()JROOT/libraries/src/Access/Access.php:429
    19Joomla\CMS\Access\Access::preloadComponents()JROOT/libraries/src/Access/Access.php:213
    18Joomla\CMS\Access\Access::preload()JROOT/libraries/src/Access/Access.php:531
    17Joomla\CMS\Access\Access::getAssetRules()JROOT/libraries/src/Access/Access.php:183
    16Joomla\CMS\Access\Access::check()JROOT/libraries/src/User/User.php:398
    15Joomla\CMS\User\User->authorise()JROOT/components/com_content/models/articles.php:115
    14ContentModelArticles->populateState()JROOT/components/com_content/models/featured.php:44
    13ContentModelFeatured->populateState()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
    12Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()JROOT/libraries/src/MVC/View/HtmlView.php:425
    11Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_content/views/featured/view.html.php:55
    10ContentViewFeatured->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    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:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]
  15. Query Time: 3.27 ms After last query: 2.50 ms Query memory: 0.024 MB Memory before query: 2.770 MB Rows returned: 0
    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2 
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,fp.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,
							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count

      FROM alkes_content AS a

      INNER JOIN alkes_content_frontpage AS fp 
      ON fp.content_id = a.id

      LEFT JOIN alkes_categories AS c 
      ON c.id = a.catid

      LEFT JOIN alkes_users AS ua 
      ON ua.id = a.created_by

      LEFT JOIN alkes_users AS uam 
      ON uam.id = a.modified_by

      LEFT JOIN alkes_categories as parent 
      ON parent.id = c.parent_id

      LEFT JOIN alkes_content_rating AS v 
      ON a.id = v.content_id

      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-01-27 04:28:04') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-01-27 04:28:04') 
      AND a.language IN ('en-GB','*')

      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
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEfpALLPRIMARYNO INDEX KEY COULD BE USEDNULLNULL1Using temporary; Using filesort
    1SIMPLEaeq_refPRIMARY,idx_access,idx_state,idx_catid,idx_languagePRIMARY4trip4732_db_kesehatan.fp.content_id1Using where
    1SIMPLEceq_refPRIMARY,idx_accessPRIMARY4trip4732_db_kesehatan.a.catid1Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4trip4732_db_kesehatan.a.created_by1Using where
    1SIMPLEuameq_refPRIMARYPRIMARY4trip4732_db_kesehatan.a.modified_by1Using where
    1SIMPLEparenteq_refPRIMARYPRIMARY4trip4732_db_kesehatan.c.parent_id1Using where
    1SIMPLEveq_refPRIMARYPRIMARY4trip4732_db_kesehatan.a.id1Using where
    Profile
    StatusDuration
    starting0.23 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables1.73 ms
    After opening tables0.02 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.10 ms
    optimizing0.04 ms
    statistics0.19 ms
    preparing0.04 ms
    Creating tmp table0.11 ms
    Sorting result0.02 ms
    executing0.01 ms
    Sending data0.36 ms
    Creating sort index0.03 ms
    removing tmp table0.07 ms
    Creating sort index0.02 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    freeing items0.10 ms
    updating status0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    16JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    15Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:187
    14Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/components/com_content/models/articles.php:576
    13ContentModelArticles->getItems()JROOT/components/com_content/models/featured.php:125
    12ContentModelFeatured->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    11Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_content/views/featured/view.html.php:56
    10ContentViewFeatured->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    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:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]
  16. Query Time: 0.65 ms After last query: 1.92 ms Query memory: 0.023 MB Memory before query: 2.782 MB Rows returned: 1
    SELECT COUNT(*)

      FROM alkes_content AS a

      INNER JOIN alkes_content_frontpage AS fp 
      ON fp.content_id = a.id

      LEFT JOIN alkes_categories AS c 
      ON c.id = a.catid

      LEFT JOIN alkes_users AS ua 
      ON ua.id = a.created_by

      LEFT JOIN alkes_users AS uam 
      ON uam.id = a.modified_by

      LEFT JOIN alkes_categories as parent 
      ON parent.id = c.parent_id

      LEFT JOIN alkes_content_rating AS v 
      ON a.id = v.content_id

      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-01-27 04:28:04') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-01-27 04:28:04') 
      AND a.language IN ('en-GB','*')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEfpindexPRIMARYPRIMARY4NULL1Using index
    1SIMPLEaeq_refPRIMARY,idx_access,idx_state,idx_catid,idx_languagePRIMARY4trip4732_db_kesehatan.fp.content_id1Using where
    1SIMPLEceq_refPRIMARY,idx_accessPRIMARY4trip4732_db_kesehatan.a.catid1Using where
    Profile
    StatusDuration
    starting0.11 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.03 ms
    optimizing0.03 ms
    statistics0.09 ms
    preparing0.01 ms
    Unlocking tables0.03 ms
    executing0.03 ms
    Sending data0.03 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    freeing items0.06 ms
    updating status0.01 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1734
    15JDatabaseDriver->loadResult()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:340
    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_content/views/featured/view.html.php:57
    10ContentViewFeatured->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    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:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]
  17. Query Time: 0.64 ms After last query: 10.49 ms Query memory: 0.021 MB Memory before query: 2.863 MB Rows returned: 4
    SELECT language,id

      FROM `alkes_menu`

      WHERE home = 1 
      AND published = 1 
      AND client_id = 0
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEalkes_menurefidx_client_id_parent_id_alias_languageidx_client_id_parent_id_alias_language1const77Using where
    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
    init0.01 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.02 ms
    executing0.01 ms
    Sending data0.24 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    freeing items0.05 ms
    updating status0.01 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    9JDatabaseDriver->loadObjectList()JROOT/libraries/src/Language/Multilanguage.php:107
    8Joomla\CMS\Language\Multilanguage::getSiteHomePages()JROOT/plugins/system/languagefilter/languagefilter.php:751
    7PlgSystemLanguageFilter->onAfterDispatch()JROOT/libraries/joomla/event/event.php:70
    6JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    5JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    4Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/SiteApplication.php:199
    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:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]
  18. Query Time: 0.85 ms After last query: 1.72 ms Query memory: 0.021 MB Memory before query: 2.875 MB Rows returned: 2
    SELECT `c2`.`language`,`c2`.`id`

      FROM `alkes_menu` AS `c`

      INNER JOIN `alkes_associations` AS `a` 
      ON a.id = c.`id` 
      AND a.context='com_menus.item'

      INNER JOIN `alkes_associations` AS `a2` 
      ON `a`.`key` = `a2`.`key`

      INNER JOIN `alkes_menu` AS `c2` 
      ON a2.id = c2.`id`

      WHERE c.id = 101
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEcconstPRIMARYPRIMARY4const1Using index
    1SIMPLEaconstPRIMARY,idx_keyPRIMARY206const,const1
    1SIMPLEa2refidx_keyidx_key128const2Using index
    1SIMPLEc2eq_refPRIMARYPRIMARY4trip4732_db_kesehatan.a2.id1
    Profile
    StatusDuration
    starting0.08 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.34 ms
    After opening tables0.02 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.02 ms
    optimizing0.02 ms
    statistics0.10 ms
    preparing0.01 ms
    Unlocking tables0.03 ms
    executing0.01 ms
    Sending data0.04 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    freeing items0.05 ms
    updating status0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    10JDatabaseDriver->loadObjectList()JROOT/libraries/src/Language/Associations.php:115
    9Joomla\CMS\Language\Associations::getAssociations()JROOT/administrator/components/com_menus/helpers/menus.php:321
    8MenusHelper::getAssociations()JROOT/plugins/system/languagefilter/languagefilter.php:768
    7PlgSystemLanguageFilter->onAfterDispatch()JROOT/libraries/joomla/event/event.php:70
    6JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    5JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    4Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/SiteApplication.php:199
    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:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]
  19. Query Time: 1.81 ms After last query: 7.19 ms Query memory: 0.103 MB Memory before query: 2.938 MB Rows returned: 18
    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

      FROM alkes_modules AS m

      LEFT JOIN alkes_modules_menu AS mm 
      ON mm.moduleid = m.id

      LEFT JOIN alkes_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 <= '2023-01-27 04:28:04') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-01-27 04:28:04') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 101 OR mm.menuid <= 0) 
      AND m.language IN ('en-GB','*')

      ORDER BY m.position, m.ordering
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmrefPRIMARY,published,newsfeeds,idx_languagepublished1const24Using index condition; Using where; Using filesort
    1SIMPLEerefelement_clientid,element_folder_clientidelement_clientid403trip4732_db_kesehatan.m.module,const1Using index condition; Using where
    1SIMPLEmmrefPRIMARYPRIMARY4trip4732_db_kesehatan.m.id2Using where; Using index
    Profile
    StatusDuration
    starting0.10 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.50 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.01 ms
    Sending data0.03 ms
    Creating sort index0.76 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    freeing items0.05 ms
    updating status0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    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:581
    8Joomla\CMS\Document\HtmlDocument->countModules()JROOT/templates/jf_couda/index.php:79
    7require JROOT/templates/jf_couda/index.phpJROOT/libraries/src/Document/HtmlDocument.php:658
    6Joomla\CMS\Document\HtmlDocument->_loadTemplate()JROOT/libraries/src/Document/HtmlDocument.php:720
    5Joomla\CMS\Document\HtmlDocument->_fetchTemplate()JROOT/libraries/src/Document/HtmlDocument.php:535
    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:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]
  20. Query Time: 1.49 ms After last query: 7.38 ms Query memory: 0.057 MB Memory before query: 3.155 MB Rows returned: 5
    SELECT i.*, c.name AS categoryname, c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams 
      FROM alkes_k2_items AS i RIGHT JOIN alkes_k2_categories AS c 
      ON c.id = i.catid 
      WHERE i.published = 1
                
      AND i.access IN(1,5)
                
      AND i.trash = 0
                
      AND c.published = 1
                
      AND c.access IN(1,5)
                
      AND c.trash = 0
                
      AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2023-01-27 04:28:04')
                
      AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2023-01-27 04:28:04') 
      AND i.catid IN(7) 
      AND i.language IN ('en-GB', '*') 
      AND c.language IN ('en-GB', '*') 
      ORDER BY i.id DESC 
      LIMIT 0, 6
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEcconstPRIMARY,category,published,access,trash,languagePRIMARY4const1
    1SIMPLEirefitem,catid,languagecatid4const12Using where
    Profile
    StatusDuration
    starting0.11 ms
    checking permissions0.01 ms
    checking permissions0.02 ms
    Opening tables0.67 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.04 ms
    optimizing0.03 ms
    statistics0.16 ms
    preparing0.01 ms
    Unlocking tables0.03 ms
    Sorting result0.01 ms
    executing0.01 ms
    Sending data0.22 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    freeing items0.06 ms
    updating status0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    13JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    12JDatabaseDriver->loadObjectList()JROOT/modules/mod_k2_content/helper.php:262
    11modK2ContentHelper::getItems()JROOT/modules/mod_k2_content/mod_k2_content.php:65
    10include JROOT/modules/mod_k2_content/mod_k2_content.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:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:783
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    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:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]
  21. Query Time: 0.39 ms After last query: 7.78 ms Query memory: 0.022 MB Memory before query: 3.217 MB Rows returned: 1
    Duplicate queries: #23  #25  #27  #29
    SELECT extraFieldsGroup 
      FROM alkes_k2_categories 
      WHERE id=7
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEalkes_k2_categoriesconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.05 ms
    preparing0.02 ms
    Unlocking tables0.03 ms
    executing0.01 ms
    Sending data0.01 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    freeing items0.04 ms
    updating status0.01 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1734
    13JDatabaseDriver->loadResult()JROOT/components/com_k2/models/item.php:1226
    12K2ModelItem->getItemExtraFields()JROOT/modules/mod_k2_content/helper.php:387
    11modK2ContentHelper::getItems()JROOT/modules/mod_k2_content/mod_k2_content.php:65
    10include JROOT/modules/mod_k2_content/mod_k2_content.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:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:783
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    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:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]
  22. Query Time: 0.72 ms After last query: 0.03 ms Query memory: 0.022 MB Memory before query: 3.223 MB Rows returned: 1
    Duplicate queries: #24  #26  #28  #30
    SELECT * 
      FROM alkes_k2_extra_fields 
      WHERE `
      group` = 2 
      AND published=1 
      AND (id IN (4) OR `type` = 'header') 
      ORDER BY ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEalkes_k2_extra_fieldsrefPRIMARY,group,publishedgroup4const1Using where; Using filesort
    Profile
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.28 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.02 ms
    optimizing0.03 ms
    statistics0.07 ms
    preparing0.02 ms
    Sorting result0.01 ms
    executing0.01 ms
    Sending data0.01 ms
    Creating sort index0.04 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    freeing items0.04 ms
    updating status0.01 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    13JDatabaseDriver->loadObjectList()JROOT/components/com_k2/models/item.php:1230
    12K2ModelItem->getItemExtraFields()JROOT/modules/mod_k2_content/helper.php:387
    11modK2ContentHelper::getItems()JROOT/modules/mod_k2_content/mod_k2_content.php:65
    10include JROOT/modules/mod_k2_content/mod_k2_content.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:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:783
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    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:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]
  23. Query Time: 0.39 ms After last query: 1.78 ms Query memory: 0.022 MB Memory before query: 3.233 MB Rows returned: 1
    Duplicate queries: #21  #25  #27  #29
    SELECT extraFieldsGroup 
      FROM alkes_k2_categories 
      WHERE id=7
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEalkes_k2_categoriesconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.02 ms
    Unlocking tables0.03 ms
    executing0.01 ms
    Sending data0.01 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    freeing items0.05 ms
    updating status0.01 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1734
    13JDatabaseDriver->loadResult()JROOT/components/com_k2/models/item.php:1226
    12K2ModelItem->getItemExtraFields()JROOT/modules/mod_k2_content/helper.php:387
    11modK2ContentHelper::getItems()JROOT/modules/mod_k2_content/mod_k2_content.php:65
    10include JROOT/modules/mod_k2_content/mod_k2_content.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:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:783
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    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:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]
  24. Query Time: 0.42 ms After last query: 0.03 ms Query memory: 0.022 MB Memory before query: 3.240 MB Rows returned: 1
    Duplicate queries: #22  #26  #28  #30
    SELECT * 
      FROM alkes_k2_extra_fields 
      WHERE `
      group` = 2 
      AND published=1 
      AND (id IN (4) OR `type` = 'header') 
      ORDER BY ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEalkes_k2_extra_fieldsrefPRIMARY,group,publishedgroup4const1Using where; Using filesort
    Profile
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.02 ms
    optimizing0.02 ms
    statistics0.03 ms
    preparing0.02 ms
    Sorting result0.01 ms
    executing0.01 ms
    Sending data0.01 ms
    Creating sort index0.04 ms
    end0.02 ms
    query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    freeing items0.04 ms
    updating status0.01 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    13JDatabaseDriver->loadObjectList()JROOT/components/com_k2/models/item.php:1230
    12K2ModelItem->getItemExtraFields()JROOT/modules/mod_k2_content/helper.php:387
    11modK2ContentHelper::getItems()JROOT/modules/mod_k2_content/mod_k2_content.php:65
    10include JROOT/modules/mod_k2_content/mod_k2_content.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:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:783
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    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:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]
  25. Query Time: 0.30 ms After last query: 0.26 ms Query memory: 0.022 MB Memory before query: 3.250 MB Rows returned: 1
    Duplicate queries: #21  #23  #27  #29
    SELECT extraFieldsGroup 
      FROM alkes_k2_categories 
      WHERE id=7
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEalkes_k2_categoriesconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.02 ms
    preparing0.01 ms
    Unlocking tables0.02 ms
    executing0.01 ms
    Sending data0.01 ms
    end0.02 ms
    query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    freeing items0.04 ms
    updating status0.01 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1734
    13JDatabaseDriver->loadResult()JROOT/components/com_k2/models/item.php:1226
    12K2ModelItem->getItemExtraFields()JROOT/modules/mod_k2_content/helper.php:387
    11modK2ContentHelper::getItems()JROOT/modules/mod_k2_content/mod_k2_content.php:65
    10include JROOT/modules/mod_k2_content/mod_k2_content.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:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:783
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    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:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]
  26. Query Time: 0.41 ms After last query: 0.03 ms Query memory: 0.022 MB Memory before query: 3.256 MB Rows returned: 1
    Duplicate queries: #22  #24  #28  #30
    SELECT * 
      FROM alkes_k2_extra_fields 
      WHERE `
      group` = 2 
      AND published=1 
      AND (id IN (4) OR `type` = 'header') 
      ORDER BY ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEalkes_k2_extra_fieldsrefPRIMARY,group,publishedgroup4const1Using where; Using filesort
    Profile
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.02 ms
    optimizing0.02 ms
    statistics0.03 ms
    preparing0.02 ms
    Sorting result0.01 ms
    executing0.01 ms
    Sending data0.01 ms
    Creating sort index0.04 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    Unlocking tables0.01 ms
    freeing items0.04 ms
    updating status0.01 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    13JDatabaseDriver->loadObjectList()JROOT/components/com_k2/models/item.php:1230
    12K2ModelItem->getItemExtraFields()JROOT/modules/mod_k2_content/helper.php:387
    11modK2ContentHelper::getItems()JROOT/modules/mod_k2_content/mod_k2_content.php:65
    10include JROOT/modules/mod_k2_content/mod_k2_content.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:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:783
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    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:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]
  27. Query Time: 0.30 ms After last query: 0.26 ms Query memory: 0.022 MB Memory before query: 3.266 MB Rows returned: 1
    Duplicate queries: #21  #23  #25  #29
    SELECT extraFieldsGroup 
      FROM alkes_k2_categories 
      WHERE id=7
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEalkes_k2_categoriesconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.02 ms
    preparing0.01 ms
    Unlocking tables0.02 ms
    executing0.01 ms
    Sending data0.03 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    freeing items0.04 ms
    updating status0.01 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1734
    13JDatabaseDriver->loadResult()JROOT/components/com_k2/models/item.php:1226
    12K2ModelItem->getItemExtraFields()JROOT/modules/mod_k2_content/helper.php:387
    11modK2ContentHelper::getItems()JROOT/modules/mod_k2_content/mod_k2_content.php:65
    10include JROOT/modules/mod_k2_content/mod_k2_content.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:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:783
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    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:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]
  28. Query Time: 0.41 ms After last query: 0.03 ms Query memory: 0.022 MB Memory before query: 3.272 MB Rows returned: 1
    Duplicate queries: #22  #24  #26  #30
    SELECT * 
      FROM alkes_k2_extra_fields 
      WHERE `
      group` = 2 
      AND published=1 
      AND (id IN (4) OR `type` = 'header') 
      ORDER BY ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEalkes_k2_extra_fieldsrefPRIMARY,group,publishedgroup4const1Using where; Using filesort
    Profile
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.02 ms
    optimizing0.02 ms
    statistics0.03 ms
    preparing0.02 ms
    Sorting result0.01 ms
    executing0.01 ms
    Sending data0.01 ms
    Creating sort index0.04 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.03 ms
    Unlocking tables0.01 ms
    freeing items0.04 ms
    updating status0.01 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    13JDatabaseDriver->loadObjectList()JROOT/components/com_k2/models/item.php:1230
    12K2ModelItem->getItemExtraFields()JROOT/modules/mod_k2_content/helper.php:387
    11modK2ContentHelper::getItems()JROOT/modules/mod_k2_content/mod_k2_content.php:65
    10include JROOT/modules/mod_k2_content/mod_k2_content.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:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:783
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    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:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]
  29. Query Time: 0.29 ms After last query: 0.26 ms Query memory: 0.022 MB Memory before query: 3.282 MB Rows returned: 1
    Duplicate queries: #21  #23  #25  #27
    SELECT extraFieldsGroup 
      FROM alkes_k2_categories 
      WHERE id=7
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEalkes_k2_categoriesconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.02 ms
    preparing0.01 ms
    Unlocking tables0.02 ms
    executing0.01 ms
    Sending data0.02 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    freeing items0.04 ms
    updating status0.01 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1734
    13JDatabaseDriver->loadResult()JROOT/components/com_k2/models/item.php:1226
    12K2ModelItem->getItemExtraFields()JROOT/modules/mod_k2_content/helper.php:387
    11modK2ContentHelper::getItems()JROOT/modules/mod_k2_content/mod_k2_content.php:65
    10include JROOT/modules/mod_k2_content/mod_k2_content.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:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:783
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    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:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]
  30. Query Time: 0.36 ms After last query: 0.03 ms Query memory: 0.022 MB Memory before query: 3.289 MB Rows returned: 1
    Duplicate queries: #22  #24  #26  #28
    SELECT * 
      FROM alkes_k2_extra_fields 
      WHERE `
      group` = 2 
      AND published=1 
      AND (id IN (4) OR `type` = 'header') 
      ORDER BY ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEalkes_k2_extra_fieldsrefPRIMARY,group,publishedgroup4const1Using where; Using filesort
    Profile
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.02 ms
    optimizing0.02 ms
    statistics0.03 ms
    preparing0.02 ms
    Sorting result0.01 ms
    executing0.01 ms
    Sending data0.01 ms
    Creating sort index0.04 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    freeing items0.04 ms
    updating status0.01 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    13JDatabaseDriver->loadObjectList()JROOT/components/com_k2/models/item.php:1230
    12K2ModelItem->getItemExtraFields()JROOT/modules/mod_k2_content/helper.php:387
    11modK2ContentHelper::getItems()JROOT/modules/mod_k2_content/mod_k2_content.php:65
    10include JROOT/modules/mod_k2_content/mod_k2_content.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:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:783
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    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:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]
  31. Query Time: 0.66 ms After last query: 4.22 ms Query memory: 0.022 MB Memory before query: 3.260 MB Rows returned: 5
    SELECT id
                        
      FROM alkes_k2_categories
                        
      WHERE parent IN(2)
                            
      AND id NOT IN(2) 
      AND published=1 
      AND trash=0 
      AND access IN(1,1,5) 
      AND language IN('en-GB', '*')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEalkes_k2_categoriesrefPRIMARY,category,parent,published,access,trash,languageparent5const8Using index condition; Using where
    Profile
    StatusDuration
    starting0.08 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.02 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.02 ms
    optimizing0.02 ms
    statistics0.23 ms
    preparing0.03 ms
    executing0.01 ms
    Sending data0.05 ms
    end0.02 ms
    query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    freeing items0.04 ms
    updating status0.02 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1544
    13JDatabaseDriver->loadColumn()JROOT/components/com_k2/models/itemlist.php:398
    12K2ModelItemlist->getCategoryTree()JROOT/modules/mod_k2_content/helper.php:137
    11modK2ContentHelper::getItems()JROOT/modules/mod_k2_content/mod_k2_content.php:65
    10include JROOT/modules/mod_k2_content/mod_k2_content.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:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:783
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    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:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]
  32. Query Time: 0.45 ms After last query: 0.05 ms Query memory: 0.022 MB Memory before query: 3.268 MB Rows returned: 0
    SELECT id
                        
      FROM alkes_k2_categories
                        
      WHERE parent IN(4,5,12,13,14)
                            
      AND id NOT IN(4,5,12,13,14) 
      AND published=1 
      AND trash=0 
      AND access IN(1,1,5) 
      AND language IN('en-GB', '*')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEalkes_k2_categoriesrefPRIMARY,category,parent,published,access,trash,languagecategory2const12Using index condition; Using where
    Profile
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.02 ms
    optimizing0.02 ms
    statistics0.07 ms
    preparing0.02 ms
    executing0.01 ms
    Sending data0.06 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    freeing items0.05 ms
    updating status0.01 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1544
    13JDatabaseDriver->loadColumn()JROOT/components/com_k2/models/itemlist.php:398
    12K2ModelItemlist->getCategoryTree()JROOT/modules/mod_k2_content/helper.php:137
    11modK2ContentHelper::getItems()JROOT/modules/mod_k2_content/mod_k2_content.php:65
    10include JROOT/modules/mod_k2_content/mod_k2_content.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:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:783
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    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:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]
  33. Query Time: 1.88 ms After last query: 0.04 ms Query memory: 0.078 MB Memory before query: 3.282 MB Rows returned: 8
    SELECT i.*, c.name AS categoryname, c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams 
      FROM alkes_k2_items AS i RIGHT JOIN alkes_k2_categories AS c 
      ON c.id = i.catid 
      WHERE i.published = 1
                
      AND i.access IN(1,5)
                
      AND i.trash = 0
                
      AND c.published = 1
                
      AND c.access IN(1,5)
                
      AND c.trash = 0
                
      AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2023-01-27 04:28:04')
                
      AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2023-01-27 04:28:04') 
      AND i.catid IN (2,4,5,12,13,14) 
      AND i.language IN ('en-GB', '*') 
      AND c.language IN ('en-GB', '*') 
      ORDER BY RAND() 
      LIMIT 0, 8
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEcrefPRIMARY,category,published,access,trash,languagecategory2const12Using index condition; Using where; Using temporary; Using filesort
    1SIMPLEirefitem,catid,languagecatid4trip4732_db_kesehatan.c.id3Using index condition; Using where
    Profile
    StatusDuration
    starting0.10 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.04 ms
    optimizing0.03 ms
    statistics0.12 ms
    preparing0.04 ms
    Creating tmp table0.04 ms
    Sorting result0.01 ms
    executing0.01 ms
    Sending data0.83 ms
    Creating sort index0.16 ms
    end0.01 ms
    removing tmp table0.24 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    Unlocking tables0.01 ms
    freeing items0.06 ms
    updating status0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    13JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    12JDatabaseDriver->loadObjectList()JROOT/modules/mod_k2_content/helper.php:262
    11modK2ContentHelper::getItems()JROOT/modules/mod_k2_content/mod_k2_content.php:65
    10include JROOT/modules/mod_k2_content/mod_k2_content.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:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:783
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    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:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]
  34. Query Time: 0.54 ms After last query: 0.16 ms Query memory: 0.024 MB Memory before query: 3.356 MB Rows returned: 11
    SELECT id, name, parent 
      FROM alkes_k2_categories 
      WHERE published=1 
      AND trash=0 
      AND access IN(1,1,5) 
      AND language IN('en-GB', '*') 
      ORDER BY parent
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEalkes_k2_categoriesrefcategory,published,access,trash,languagecategory2const12Using index condition; Using where; Using filesort
    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
    init0.02 ms
    optimizing0.02 ms
    statistics0.06 ms
    preparing0.02 ms
    Sorting result0.01 ms
    executing0.01 ms
    Sending data0.01 ms
    Creating sort index0.15 ms
    end0.02 ms
    query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    freeing items0.04 ms
    updating status0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    15JDatabaseDriver->loadObjectList()JROOT/components/com_k2/models/itemlist.php:897
    14K2ModelItemlist->getCategoriesTree()JROOT/components/com_k2/helpers/route.php:252
    13K2HelperRoute::_findItem()JROOT/components/com_k2/helpers/route.php:39
    12K2HelperRoute::getItemRoute()JROOT/modules/mod_k2_content/helper.php:281
    11modK2ContentHelper::getItems()JROOT/modules/mod_k2_content/mod_k2_content.php:65
    10include JROOT/modules/mod_k2_content/mod_k2_content.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:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:783
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    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:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]
  35. Query Time: 0.45 ms After last query: 2.99 ms Query memory: 0.022 MB Memory before query: 3.395 MB Rows returned: 5
    SELECT name, alias
						
      FROM alkes_k2_categories
						
      WHERE parent IN (2)
						
      AND id NOT IN (2) 
						
      AND published=1
						
      AND trash=0
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEalkes_k2_categoriesrefPRIMARY,category,parent,published,trashparent5const8Using index condition; Using where
    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
    init0.02 ms
    optimizing0.01 ms
    statistics0.06 ms
    preparing0.02 ms
    executing0.01 ms
    Sending data0.06 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    freeing items0.06 ms
    updating status0.01 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    13JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    12JDatabaseDriver->loadObjectList()JROOT/templates/jf_couda/html/mod_k2_content/Masonry/default.php:38
    11require JROOT/templates/jf_couda/html/mod_k2_content/Masonry/default.phpJROOT/modules/mod_k2_content/mod_k2_content.php:68
    10include JROOT/modules/mod_k2_content/mod_k2_content.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:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:783
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    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:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]
  36. Query Time: 1.27 ms After last query: 11.54 ms Query memory: 0.026 MB Memory before query: 3.555 MB Rows returned: 0
    SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

      FROM alkes_fields AS a

      LEFT JOIN `alkes_languages` AS l 
      ON l.lang_code = a.language

      LEFT JOIN alkes_users AS uc 
      ON uc.id=a.checked_out

      LEFT JOIN alkes_viewlevels AS ag 
      ON ag.id = a.access

      LEFT JOIN alkes_users AS ua 
      ON ua.id = a.created_user_id

      LEFT JOIN alkes_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
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEarefidx_state,idx_access,idx_contextidx_state1const1Using where; Using filesort
    1SIMPLEleq_refidx_langcodeidx_langcode28trip4732_db_kesehatan.a.language1Using where
    1SIMPLEuceq_refPRIMARYPRIMARY4trip4732_db_kesehatan.a.checked_out1
    1SIMPLEageq_refPRIMARYPRIMARY4trip4732_db_kesehatan.a.access1Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4trip4732_db_kesehatan.a.created_user_id1Using where
    1SIMPLEgeq_refPRIMARYPRIMARY4trip4732_db_kesehatan.a.group_id1Using where
    Profile
    StatusDuration
    starting0.12 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.62 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.04 ms
    optimizing0.03 ms
    statistics0.10 ms
    preparing0.03 ms
    Sorting result0.01 ms
    executing0.01 ms
    Sending data0.02 ms
    Creating sort index0.03 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    freeing items0.05 ms
    updating status0.01 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    23JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    22JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    21Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:333
    20FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:187
    19Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:135
    18FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:488
    17PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    16JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    15JEventDispatcher->trigger()JROOT/libraries/cms/html/content.php:41
    14JHtmlContent::prepare()Same as call in the line below.
    13call_user_func_array()JROOT/libraries/src/HTML/HTMLHelper.php:239
    12Joomla\CMS\HTML\HTMLHelper::call()JROOT/libraries/src/HTML/HTMLHelper.php:146
    11Joomla\CMS\HTML\HTMLHelper::_()JROOT/modules/mod_custom/mod_custom.php:15
    10include JROOT/modules/mod_custom/mod_custom.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:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:783
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    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:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

25 Query Types Logged, Sorted by Occurrences.

SELECT Tables:
  1. 5 × SELECT * 
      FROM alkes_k2_extra_fields
  2. 5 × SELECT extraFieldsGroup 
      FROM alkes_k2_categories
  3. 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
      FROM `alkes_extensions`
  4. 2 × SELECT id                         
      FROM alkes_k2_categories
  5. 2 × SELECT i.*, c.name AS categoryname, c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams 
      FROM alkes_k2_items AS i RIGHT JOIN alkes_k2_categories AS c 
      ON c.id = i.catid
  6. 1 × SELECT `data` 
      FROM `alkes_session`
  7. 1 × SELECT language,id 
      FROM `alkes_menu`
  8. 1 × SELECT name, alias       
      FROM alkes_k2_categories
  9. 1 × SELECT id, name, parent 
      FROM alkes_k2_categories
  10. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
      FROM alkes_modules AS m 
      LEFT JOIN alkes_modules_menu AS mm 
      ON mm.moduleid = m.id 
      LEFT JOIN alkes_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
  11. 1 × SELECT `c2`.`language`,`c2`.`id` 
      FROM `alkes_menu` AS `c` 
      INNER JOIN `alkes_associations` AS `a` 
      ON a.id = c.`id` 
      AND a.context='com_menus.item' 
      INNER JOIN `alkes_associations` AS `a2` 
      ON `a`.`key` = `a2`.`key` 
      INNER JOIN `alkes_menu` AS `c2` 
      ON a2.id = c2.`id`
  12. 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,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,        COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count 
      FROM alkes_content AS a 
      INNER JOIN alkes_content_frontpage AS fp 
      ON fp.content_id = a.id 
      LEFT JOIN alkes_categories AS c 
      ON c.id = a.catid 
      LEFT JOIN alkes_users AS ua 
      ON ua.id = a.created_by 
      LEFT JOIN alkes_users AS uam 
      ON uam.id = a.modified_by 
      LEFT JOIN alkes_categories as parent 
      ON parent.id = c.parent_id 
      LEFT JOIN alkes_content_rating AS v 
      ON a.id = v.content_id
  13. 1 × SELECT COUNT(*) 
      FROM alkes_content AS a 
      INNER JOIN alkes_content_frontpage AS fp 
      ON fp.content_id = a.id 
      LEFT JOIN alkes_categories AS c 
      ON c.id = a.catid 
      LEFT JOIN alkes_users AS ua 
      ON ua.id = a.created_by 
      LEFT JOIN alkes_users AS uam 
      ON uam.id = a.modified_by 
      LEFT JOIN alkes_categories as parent 
      ON parent.id = c.parent_id 
      LEFT JOIN alkes_content_rating AS v 
      ON a.id = v.content_id
  14. 1 × SELECT `session_id` 
      FROM `alkes_session`
  15. 1 × SELECT `id`,`name`,`rules`,`parent_id` 
      FROM `alkes_assets`
  16. 1 × SELECT id, home, template, s.params 
      FROM alkes_template_styles as s 
      LEFT JOIN alkes_extensions as e 
      ON e.element=s.template 
      AND e.type='template' 
      AND e.client_id=s.client_id
  17. 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 alkes_menu AS m 
      LEFT JOIN alkes_extensions AS e 
      ON m.component_id = e.extension_id
  18. 1 × SELECT `element`,`name`,`client_id`,`extension_id` 
      FROM `alkes_extensions`
  19. 1 × SELECT * 
      FROM alkes_languages
  20. 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
      FROM alkes_extensions
  21. 1 × SELECT b.id 
      FROM alkes_usergroups AS a 
      LEFT JOIN alkes_usergroups AS b 
      ON b.lft <= a.lft 
      AND b.rgt >= a.rgt
  22. 1 × SELECT id, rules 
      FROM `alkes_viewlevels
  23. 1 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
      FROM alkes_fields AS a 
      LEFT JOIN `alkes_languages` AS l 
      ON l.lang_code = a.language 
      LEFT JOIN alkes_users AS uc 
      ON uc.id=a.checked_out 
      LEFT JOIN alkes_viewlevels AS ag 
      ON ag.id = a.access 
      LEFT JOIN alkes_users AS ua 
      ON ua.id = a.created_user_id 
      LEFT JOIN alkes_fields_groups AS g 
      ON g.id = a.group_id
OTHER Tables:
  1. 1 × INSERT INTO `alkes_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES  ('73267f64b9e925321693ecf43418fa9f', 1, 1674793684, 0, '', 0
  2. 1 × UPDATE `alkes_extensions` 
      SET `params` = '{\"mediaversion\":\"197ef06ee3e8669e47af14b4af9d58c7\"}'