Poltekkes Kupang
FacebookTwitterGoogle+
Menu
  • HomeBeranda
  • ProfilTentang Kami
      • Sejarah
      • Visi Misi
      • Motto dan Janji Layanan
      • Arah Kebijakan
      • Rencana Strategis
      • STATUTA Poltekkes Kupang
      • Struktur Organisasi
      • Zona Integritas Poltekkes Kemenkes Kupang
  • Program StudiProgram Studi
      • Prodi DIII Keperawatan Kupang
      • Prodi DIII Keperawatan Ende
      • Prodi DIII Keperawatan Waingapu
      • Prodi DIII Kesehatan Gigi
      • Prodi DIII Kebidanan
      • Prodi DIII Sanitasi
      • Prodi DIII Gizi
      • Prodi DIII Farmasi
      • Prodi DIII Teknologi Laboratorium Medik
      • Prodi Pendidikan Profesi Ners
      • Prodi PJJ DIII Kebidanan
      • Prodi PJJ DIII Keperawatan
      • Prodi DIII Keperawatan Waikabubak
  • KepegawaianKepegawaian
      • Tenaga Pendidik dan Kependidikan
      • Pejabat Struktural
      • Peraturan Kepegawaian
  • AkademikaAkademika
      • Data Penerimaan Mahasiswa
      • Data Alumni
      • SK Akreditasi Poltekkes Kupang - Prodi
      • Kode Etik Civitas Akademik
      • Panduan Akademik
      • Standar Mutu Pendidikan
      • Standar Mutu Penelitian
  • Layanan PolkesKuLayanan Poltekkes Kupang
      • Aman Info
      • Maklumat Layanan
      • Jenis Layanan
      • Survey Kepuasan Layanan
      • Pola Tarif
      • PK BLU PolkesKu
  • Lab Penguji
      • Visi Dan Misi
      • Maklumat Lab Penguji
      • Struktur Organisasi
      • Kebijakan dan Sasaran Mutu
      • Ruang Lingkup Pengujian
      • Alur Layanan Lab Penguji Polkesku
  • PengabmasPengabmas
      • Standar Penelitian dan Pengabmas
      • Kegiatan Pengabmas
  • Gallery FotoGaleri Poltekkes
  • InformasiInformasi
      • Informasi Kerja
      • Beasiswa
      • Download
  • Gallery Foto
Pelatihan Applied Approach 2013
Pelatihan... (16)
SeminarNasional
SeminarNa... (52)
Wisuda Tahun 2012
Wisuda Ta... (14)
Sipensimaru
Sipensima... (8)
PEMILIHAN DIREKTUR 2014
PEMILIHAN... (12)
Komitmen _Tanpa_Rokok
Komitmen ... (6)
wisuda2014
wisuda201... (4)
Kunjungan_Manado
Kunjungan... (3)
Pengabmas_2015
Pengabmas... (17)
Rapat Senat Periode I Tahun 2015
Rapat Sen... (20)
Natal Bersama 2017
Natal Ber... (1)
 
Powered by Phoca Gallery

 

  • Home
  • Gallery Foto

Gallery Terbaru

Pelatihan Applied Approach 2013
Wisuda Tahun 2012
sipensimaru
PEMILIHAN DIREKTUR 2014
Siap Komitmen
Wisuda
Manado1
Pengabmas_Analis
Rapat Senat Periode I

Artikel Terbaru

  • Poltekkes Kemenkes Kupang gelar rapat Penjajakan Kerjasama dengan Kementerian Kesehatan RDTL
  • Seleksi Penerimaan Mahasiswa Baru Jalur PMDP Poltekkes Kupang Tahun Akademik 2023/2024
  • Penyerahan Bantuan Wadah dan Kemasan oleh Ketua Dewan Kerajinan Nasional Daerah Kepada Desa Binaan Prodi Farmasi Poltekkes Kemenkes Kupang - Desa Uiboa
  • Pertemuan Koordinasi Dan Penguatan Kerjasama Serapan Lulusan Padinakes Dan Lulusan Poltekkes Kemenkes Kupang Dengan Pemda Kab/Kota Provinsi NTT
  • Workshop Review Renstra Tahun 2020 - 2024 Poltekkes Kemenkes Kupang

Artikel Terpopuler

  • Pendaftaran Jalur Mandiri Poltekkes Kemenkes Kupang
  • Penerimaan Jalur Mandiri Poltekkes Kemenkes Kupang Tahun Akademik 2022/2023
  • Seleksi Penerimaan mahasiswa Baru Jalur PMDP 2022/2023 Poltekkes Kemenkes Kupang
  • Penerimaan Mahasiswa Baru Jalur SIMAMA Tahun Akademik 2022/2023
  • Penerimaan Mahasiswa Baru Jalur Mandiri Poltekkes Kemenkes Kupang 2021/2022

Pengumuman

  • Kuesioner Survei Kepuasaan Dosen dan Tenaga Kependidikan Poltekkes Kemenkes Kupang
  • Buku Panduan Riset Pengembangan Penelitian dan Pengabdian Masyarakat Tahun 2016
  • Kuesioner Pemahaman Visi, Misi dan tujuan Poltekkes Kemenkes Kupang
  • Format Penelusuran Lulusan
Copyright 2014 © www.poltekkeskupang.ac.id

Website Designed by : Sasandoweb.Com

Joomla! Debug Console

Session

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

Profile Information

Time

Memory

Time: 7.14 ms / 7.14 ms Memory: 0.518 MB / 0.86 MB Application: afterLoad
Time: 37.71 ms / 44.85 ms Memory: 3.652 MB / 4.51 MB Application: afterInitialise
Time: 8.41 ms / 53.26 ms Memory: 1.201 MB / 5.71 MB Application: afterRoute
Time: 4.23 ms / 57.49 ms Memory: 0.238 MB / 5.95 MB Application: beforeRenderComponent com_phocagallery
Time: 26.09 ms / 83.58 ms Memory: 1.775 MB / 7.72 MB Application: afterRenderComponent com_phocagallery
Time: 1.16 ms / 84.74 ms Memory: 0.104 MB / 7.82 MB Application: afterDispatch
Time: 2.98 ms / 87.71 ms Memory: 0.151 MB / 7.98 MB Application: beforeRenderModule mod_articles_latest (Pengumuman)
Time: 4.71 ms / 92.42 ms Memory: 0.445 MB / 8.42 MB Application: Start JAccess::getAssetRules Old (1)
Time: 0.53 ms / 92.95 ms Memory: 0.036 MB / 8.46 MB Application: Finish JAccess::getAssetRules Old (1)
Time: 0.06 ms / 93.01 ms Memory: 0.000 MB / 8.45 MB Application: Start JAccess::preload(components)
Time: 1.49 ms / 94.50 ms Memory: 0.228 MB / 8.68 MB Application: Finish JAccess::preload(components)
Time: 4.25 ms / 98.75 ms Memory: 0.365 MB / 9.05 MB Application: afterRenderModule mod_articles_latest (Pengumuman)
Time: 0.07 ms / 98.82 ms Memory: 0.000 MB / 8.88 MB Application: beforeRenderModule mod_articles_popular (Artikel Terpopuler)
Time: 8.52 ms / 107.34 ms Memory: 0.298 MB / 9.18 MB Application: afterRenderModule mod_articles_popular (Artikel Terpopuler)
Time: 0.08 ms / 107.42 ms Memory: 0.000 MB / 8.94 MB Application: beforeRenderModule mod_articles_latest (Artikel Terbaru)
Time: 7.34 ms / 114.76 ms Memory: 0.246 MB / 9.19 MB Application: afterRenderModule mod_articles_latest (Artikel Terbaru)
Time: 0.08 ms / 114.84 ms Memory: 0.000 MB / 8.97 MB Application: beforeRenderModule mod_phocagallery_image (Gallery Terbaru)
Time: 8.47 ms / 123.31 ms Memory: 0.342 MB / 9.31 MB Application: afterRenderModule mod_phocagallery_image (Gallery Terbaru)
Time: 0.07 ms / 123.38 ms Memory: 0.000 MB / 9.25 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 1.15 ms / 124.54 ms Memory: 0.022 MB / 9.27 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 0.05 ms / 124.58 ms Memory: 0.000 MB / 9.27 MB Application: beforeRenderModule mod_custom (Banner samping)
Time: 11.21 ms / 135.80 ms Memory: 1.205 MB / 10.47 MB Application: afterRenderModule mod_custom (Banner samping)
Time: 0.07 ms / 135.86 ms Memory: 0.003 MB / 10.47 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 0.32 ms / 136.18 ms Memory: 0.004 MB / 10.48 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 0.06 ms / 136.24 ms Memory: 0.000 MB / 10.48 MB Application: beforeRenderModule mod_icemegamenu (Mega Menu)
Time: 38.00 ms / 174.24 ms Memory: 1.110 MB / 11.59 MB Application: afterRenderModule mod_icemegamenu (Mega Menu)
Time: 0.11 ms / 174.35 ms Memory: 0.021 MB / 11.61 MB Application: beforeRenderModule mod_nice_social_bookmark (Nice Social Bookmark)
Time: 0.85 ms / 175.20 ms Memory: 0.028 MB / 11.64 MB Application: afterRenderModule mod_nice_social_bookmark (Nice Social Bookmark)
Time: 3.49 ms / 178.68 ms Memory: 0.249 MB / 11.89 MB Application: afterRender

Database queries total: 31.05 ms

Memory Usage

12.44 MB (13,039,408 Bytes)

Database Queries

31 Queries Logged 31.05 ms


2 duplicate found!

2 duplicates: #13  #26
  1. Query Time: 0.58 ms Query memory: 0.026 MB Memory before query: 2.335 MB Rows returned: 0
    SELECT `data`
    
      FROM `j0ojv_session`
      WHERE `session_id` = 'o7625o431tccuet9v4dbqdnp84'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEj0ojv_sessionconstPRIMARYPRIMARY766const1
    Profile
    StatusDuration
    Starting0.09 ms
    Waiting for query cache lock0.01 ms
    Init0.01 ms
    Checking query cache for query0.04 ms
    Checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Waiting for query cache lock0.02 ms
    Init0.02 ms
    Optimizing0.02 ms
    Statistics0.04 ms
    Preparing0.01 ms
    Executing0.02 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Closing tables0.01 ms
    Unlocking tables0.01 ms
    Closing tables0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.05 ms
    Updating status0.01 ms
    Waiting for query cache lock0.01 ms
    Updating status0.04 ms
    Waiting for query cache lock0.01 ms
    Updating status0.01 ms
    Storing result in query cache0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1728
    13JDatabaseDriver->loadResult()JROOT/libraries/joomla/session/storage/database.php:44
    12JSessionStorageDatabase->read()Same as call in the line below.
    11session_start()JROOT/libraries/joomla/session/handler/native.php:259
    10JSessionHandlerNative->doSessionStart()JROOT/libraries/joomla/session/handler/native.php:49
    9JSessionHandlerNative->start()JROOT/libraries/joomla/session/handler/joomla.php:81
    8JSessionHandlerJoomla->start()JROOT/libraries/joomla/session/session.php:636
    7JSession->_start()JROOT/libraries/joomla/session/session.php:596
    6JSession->start()JROOT/libraries/cms/application/cms.php:773
    5JApplicationCms->loadSession()JROOT/libraries/cms/application/cms.php:131
    4JApplicationCms->__construct()JROOT/libraries/cms/application/site.php:63
    3JApplicationSite->__construct()JROOT/libraries/cms/application/cms.php:408
    2JApplicationCms::getInstance()JROOT/libraries/joomla/factory.php:125
    1JFactory::getApplication()JROOT/index.php:46
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  2. Query Time: 0.50 ms After last query: 1.47 ms Query memory: 0.023 MB Memory before query: 2.472 MB Rows returned: 0
    SELECT `session_id`
    
      FROM `j0ojv_session`
      WHERE `session_id` = 'o7625o431tccuet9v4dbqdnp84'
      LIMIT 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEj0ojv_sessionconstPRIMARYPRIMARY766const1Using index
    Profile
    StatusDuration
    Starting0.06 ms
    Waiting for query cache lock0.01 ms
    Init0.01 ms
    Checking query cache for query0.03 ms
    Checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Waiting for query cache lock0.01 ms
    Init0.02 ms
    Optimizing0.01 ms
    Statistics0.03 ms
    Preparing0.01 ms
    Executing0.02 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Closing tables0.01 ms
    Unlocking tables0.01 ms
    Closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.05 ms
    Updating status0.01 ms
    Waiting for query cache lock0.01 ms
    Updating status0.05 ms
    Waiting for query cache lock0.01 ms
    Updating status0.01 ms
    Storing result in query cache0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    8JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1728
    7JDatabaseDriver->loadResult()JROOT/libraries/cms/application/cms.php:176
    6JApplicationCms->checkSession()JROOT/libraries/cms/application/cms.php:799
    5JApplicationCms->loadSession()JROOT/libraries/cms/application/cms.php:131
    4JApplicationCms->__construct()JROOT/libraries/cms/application/site.php:63
    3JApplicationSite->__construct()JROOT/libraries/cms/application/cms.php:408
    2JApplicationCms::getInstance()JROOT/libraries/joomla/factory.php:125
    1JFactory::getApplication()JROOT/index.php:46
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  3. Query Time: 0.42 ms After last query: 0.07 ms Query memory: 0.005 MB Memory before query: 2.478 MB
    INSERT INTO `j0ojv_session`
    (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
      VALUES ('o7625o431tccuet9v4dbqdnp84', 0, 1, '1675464952', 0, '')
    Explain
    EXPLAIN not possible on query: INSERT INTO `j0ojv_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('o7625o431tccuet9v4dbqdnp84', 0, 1, '1675464952', 0, '')
    Profile
    StatusDuration
    Starting0.07 ms
    Checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Init for update0.02 ms
    Update0.07 ms
    Waiting for query cache lock0.01 ms
    Update0.01 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.04 ms
    Closing tables0.01 ms
    Unlocking tables0.01 ms
    Closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.04 ms
    Updating status0.02 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    7JDatabaseDriverMysqli->execute()JROOT/libraries/cms/application/cms.php:212
    6JApplicationCms->checkSession()JROOT/libraries/cms/application/cms.php:799
    5JApplicationCms->loadSession()JROOT/libraries/cms/application/cms.php:131
    4JApplicationCms->__construct()JROOT/libraries/cms/application/site.php:63
    3JApplicationSite->__construct()JROOT/libraries/cms/application/cms.php:408
    2JApplicationCms::getInstance()JROOT/libraries/joomla/factory.php:125
    1JFactory::getApplication()JROOT/index.php:46
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  4. Query Time: 0.68 ms After last query: 1.78 ms Query memory: 0.048 MB Memory before query: 2.644 MB Rows returned: 37
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `j0ojv_extensions`
      WHERE `type` = 'component'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEj0ojv_extensionsrefextensionextension82const37Using index condition
    Profile
    StatusDuration
    Starting0.06 ms
    Waiting for query cache lock0.01 ms
    Init0.01 ms
    Checking query cache for query0.03 ms
    Checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Waiting for query cache lock0.02 ms
    Init0.02 ms
    Optimizing0.01 ms
    Statistics0.04 ms
    Preparing0.02 ms
    Executing0.01 ms
    Sending data0.11 ms
    Waiting for query cache lock0.01 ms
    Sending data0.05 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Closing tables0.01 ms
    Unlocking tables0.01 ms
    Closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.05 ms
    Updating status0.02 ms
    Waiting for query cache lock0.01 ms
    Updating status0.02 ms
    Waiting for query cache lock0.01 ms
    Updating status0.01 ms
    Storing result in query cache0.17 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    9JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    8JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/cache/controller/callback.php:152
    7JCacheControllerCallback->get()JROOT/libraries/cms/component/helper.php:448
    6JComponentHelper::load()JROOT/libraries/cms/component/helper.php:43
    5JComponentHelper::getComponent()JROOT/libraries/cms/component/helper.php:120
    4JComponentHelper::getParams()JROOT/libraries/cms/application/site.php:589
    3JApplicationSite->initialiseApp()JROOT/libraries/cms/application/site.php:209
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  5. Query Time: 0.16 ms After last query: 1.18 ms Query memory: 0.024 MB Memory before query: 2.794 MB Rows returned: 0
    SELECT b.id
    
      FROM j0ojv_usergroups AS a
      LEFT JOIN j0ojv_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE a.id = 13
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLENULLNULLNULLNO INDEX KEY COULD BE USEDNULLNULLNULLImpossible WHERE noticed after reading const tables
    Profile
    StatusDuration
    Starting0.06 ms
    Waiting for query cache lock0.01 ms
    Init0.01 ms
    Checking query cache for query0.01 ms
    Checking privileges on cached 0.01 ms
    Checking permissions0.01 ms
    Sending cached result to clien0.04 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1538
    10JDatabaseDriver->loadColumn()JROOT/libraries/joomla/access/access.php:835
    9JAccess::getGroupsByUser()JROOT/libraries/joomla/access/access.php:904
    8JAccess::getAuthorisedViewLevels()JROOT/libraries/joomla/user/user.php:454
    7JUser->getAuthorisedViewLevels()JROOT/libraries/cms/plugin/helper.php:296
    6JPluginHelper::load()JROOT/libraries/cms/plugin/helper.php:86
    5JPluginHelper::getPlugin()JROOT/libraries/cms/plugin/helper.php:128
    4JPluginHelper::isEnabled()JROOT/libraries/cms/application/site.php:599
    3JApplicationSite->initialiseApp()JROOT/libraries/cms/application/site.php:209
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  6. Query Time: 0.17 ms After last query: 0.47 ms Query memory: 0.025 MB Memory before query: 2.842 MB Rows returned: 5
    SELECT id, rules
    
      FROM `j0ojv_viewlevels`
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEj0ojv_viewlevelsALLNULLNO INDEX KEY COULD BE USEDNULLNULL5
    Profile
    StatusDuration
    Starting0.05 ms
    Waiting for query cache lock0.01 ms
    Init0.01 ms
    Checking query cache for query0.01 ms
    Checking privileges on cached 0.01 ms
    Checking permissions0.01 ms
    Sending cached result to clien0.05 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1494
    9JDatabaseDriver->loadAssocList()JROOT/libraries/joomla/access/access.php:921
    8JAccess::getAuthorisedViewLevels()JROOT/libraries/joomla/user/user.php:454
    7JUser->getAuthorisedViewLevels()JROOT/libraries/cms/plugin/helper.php:296
    6JPluginHelper::load()JROOT/libraries/cms/plugin/helper.php:86
    5JPluginHelper::getPlugin()JROOT/libraries/cms/plugin/helper.php:128
    4JPluginHelper::isEnabled()JROOT/libraries/cms/application/site.php:599
    3JApplicationSite->initialiseApp()JROOT/libraries/cms/application/site.php:209
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  7. Query Time: 0.84 ms After last query: 0.07 ms Query memory: 0.029 MB Memory before query: 2.852 MB Rows returned: 58
    SELECT folder AS type, element AS name, params
    
      FROM j0ojv_extensions
      WHERE enabled = 1
      AND type ='plugin'
      AND state IN (0,1)
      AND access IN (1,1)
      ORDER BY ordering
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEj0ojv_extensionsrefextensionextension82const70Using index condition; Using where; Using filesort
    Profile
    StatusDuration
    Starting0.04 ms
    Waiting for query cache lock0.01 ms
    Init0.01 ms
    Checking query cache for query0.04 ms
    Checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Waiting for query cache lock0.01 ms
    Init0.03 ms
    Optimizing0.02 ms
    Statistics0.04 ms
    Preparing0.03 ms
    Sorting result0.01 ms
    Executing0.01 ms
    Sending data0.01 ms
    Creating sort index0.30 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Closing tables0.01 ms
    Unlocking tables0.01 ms
    Closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.05 ms
    Updating status0.01 ms
    Waiting for query cache lock0.01 ms
    Updating status0.03 ms
    Waiting for query cache lock0.01 ms
    Updating status0.01 ms
    Storing result in query cache0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    8JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    7JDatabaseDriver->loadObjectList()JROOT/libraries/cms/plugin/helper.php:310
    6JPluginHelper::load()JROOT/libraries/cms/plugin/helper.php:86
    5JPluginHelper::getPlugin()JROOT/libraries/cms/plugin/helper.php:128
    4JPluginHelper::isEnabled()JROOT/libraries/cms/application/site.php:599
    3JApplicationSite->initialiseApp()JROOT/libraries/cms/application/site.php:209
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  8. Query Time: 1.40 ms After last query: 16.14 ms Query memory: 0.115 MB Memory before query: 4.648 MB Rows returned: 66
    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 j0ojv_menu AS m
      LEFT JOIN j0ojv_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_language1const121Using index condition; Using where; Using filesort
    1SIMPLEeeq_refPRIMARYPRIMARY4poltekke_beginning2.m.component_id1Using where
    Profile
    StatusDuration
    Starting0.06 ms
    Waiting for query cache lock0.01 ms
    Init0.01 ms
    Checking query cache for query0.06 ms
    Checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Waiting for query cache lock0.02 ms
    Init0.03 ms
    Optimizing0.02 ms
    Statistics0.04 ms
    Preparing0.03 ms
    Sorting result0.01 ms
    Executing0.01 ms
    Sending data0.02 ms
    Creating sort index0.41 ms
    Waiting for query cache lock0.01 ms
    Creating sort index0.07 ms
    Waiting for query cache lock0.01 ms
    Creating sort index0.07 ms
    Waiting for query cache lock0.01 ms
    Creating sort index0.06 ms
    Waiting for query cache lock0.01 ms
    Creating sort index0.18 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Closing tables0.01 ms
    Unlocking tables0.01 ms
    Closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.05 ms
    Updating status0.01 ms
    Waiting for query cache lock0.01 ms
    Updating status0.02 ms
    Waiting for query cache lock0.01 ms
    Updating status0.01 ms
    Storing result in query cache0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    15JDatabaseDriver->loadObjectList()JROOT/libraries/cms/menu/site.php:86
    14JMenuSite->load()JROOT/libraries/cms/menu/menu.php:74
    13JMenu->__construct()JROOT/libraries/cms/menu/site.php:57
    12JMenuSite->__construct()JROOT/libraries/cms/menu/menu.php:145
    11JMenu::getInstance()JROOT/libraries/cms/application/cms.php:439
    10JApplicationCms->getMenu()JROOT/libraries/cms/application/site.php:272
    9JApplicationSite->getMenu()JROOT/libraries/cms/router/site.php:57
    8JRouterSite->__construct()JROOT/libraries/cms/router/router.php:197
    7JRouter::getInstance()JROOT/libraries/cms/application/cms.php:535
    6JApplicationCms::getRouter()JROOT/libraries/cms/application/site.php:407
    5JApplicationSite::getRouter()JROOT/libraries/cms/application/cms.php:1115
    4JApplicationCms->route()JROOT/libraries/cms/application/site.php:791
    3JApplicationSite->route()JROOT/libraries/cms/application/site.php:215
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  9. Query Time: 0.59 ms After last query: 5.88 ms Query memory: 0.027 MB Memory before query: 5.742 MB Rows returned: 1
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `j0ojv_extensions`
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEj0ojv_extensionsrefelement_clientid,element_folder_clientid,extensionextension484const,const1Using index condition
    Profile
    StatusDuration
    Starting0.06 ms
    Waiting for query cache lock0.01 ms
    Init0.01 ms
    Checking query cache for query0.03 ms
    Checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Waiting for query cache lock0.01 ms
    Init0.02 ms
    Optimizing0.02 ms
    Statistics0.05 ms
    Preparing0.02 ms
    Executing0.01 ms
    Sending data0.05 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Closing tables0.01 ms
    Unlocking tables0.01 ms
    Closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.05 ms
    Updating status0.01 ms
    Waiting for query cache lock0.01 ms
    Updating status0.04 ms
    Waiting for query cache lock0.01 ms
    Updating status0.01 ms
    Storing result in query cache0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    13JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1650
    12JDatabaseDriver->loadObject()JROOT/libraries/joomla/cache/controller/callback.php:152
    11JCacheControllerCallback->get()JROOT/libraries/cms/library/helper.php:156
    10JLibraryHelper::_load()JROOT/libraries/cms/library/helper.php:47
    9JLibraryHelper::getLibrary()JROOT/libraries/cms/library/helper.php:90
    8JLibraryHelper::getParams()JROOT/libraries/cms/version/version.php:274
    7JVersion->getMediaVersion()JROOT/libraries/joomla/factory.php:755
    6JFactory::createDocument()JROOT/libraries/joomla/factory.php:216
    5JFactory::getDocument()JROOT/libraries/joomla/application/web.php:977
    4JApplicationWeb->loadDocument()JROOT/libraries/cms/application/site.php:130
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  10. Query Time: 0.47 ms After last query: 0.13 ms Query memory: 0.007 MB Memory before query: 5.735 MB
    UPDATE `j0ojv_extensions`
    
      SET `params` = '{\"mediaversion\":\"7242d3363169eaefaa7adbcebaa17b96\"}'
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    EXPLAIN not possible on query: UPDATE `j0ojv_extensions` SET `params` = '{\"mediaversion\":\"7242d3363169eaefaa7adbcebaa17b96\"}' WHERE `type` = 'library' AND `element` = 'joomla'
    Profile
    StatusDuration
    Starting0.07 ms
    Checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Init for update0.05 ms
    Updating0.06 ms
    End of update loop0.01 ms
    Waiting for query cache lock0.01 ms
    End of update loop0.03 ms
    Query end0.01 ms
    Commit0.04 ms
    Closing tables0.01 ms
    Unlocking tables0.01 ms
    Closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.05 ms
    Updating status0.02 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    10JDatabaseDriverMysqli->execute()JROOT/libraries/cms/library/helper.php:119
    9JLibraryHelper::saveParams()JROOT/libraries/cms/version/version.php:325
    8JVersion->setMediaVersion()JROOT/libraries/cms/version/version.php:284
    7JVersion->getMediaVersion()JROOT/libraries/joomla/factory.php:755
    6JFactory::createDocument()JROOT/libraries/joomla/factory.php:216
    5JFactory::getDocument()JROOT/libraries/joomla/application/web.php:977
    4JApplicationWeb->loadDocument()JROOT/libraries/cms/application/site.php:130
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  11. Query Time: 0.16 ms After last query: 1.49 ms Query memory: 0.026 MB Memory before query: 5.926 MB Rows returned: 1
    SELECT *
    
      FROM j0ojv_languages
      WHERE published=1
      ORDER BY ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEj0ojv_languagesALLNULLNO INDEX KEY COULD BE USEDNULLNULL1Using where; Using filesort
    Profile
    StatusDuration
    Starting0.06 ms
    Waiting for query cache lock0.01 ms
    Init0.01 ms
    Checking query cache for query0.01 ms
    Checking privileges on cached 0.01 ms
    Checking permissions0.01 ms
    Sending cached result to clien0.04 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    7JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    6JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/language/helper.php:164
    5JLanguageHelper::getLanguages()JROOT/libraries/cms/application/site.php:329
    4JApplicationSite->getParams()JROOT/libraries/cms/application/site.php:135
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  12. Query Time: 0.66 ms After last query: 0.17 ms Query memory: 0.023 MB Memory before query: 5.937 MB Rows returned: 4
    SELECT id, home, template, s.params
    
      FROM j0ojv_template_styles as s
      LEFT JOIN j0ojv_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
    1SIMPLEsALLidx_templateNO INDEX KEY COULD BE USEDNULLNULL6Using where
    1SIMPLEerefelement_clientid,element_folder_clientid,extensionelement_clientid403poltekke_beginning2.s.template,const1Using index condition; Using where
    Profile
    StatusDuration
    Starting0.04 ms
    Waiting for query cache lock0.01 ms
    Init0.01 ms
    Checking query cache for query0.04 ms
    Checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Waiting for query cache lock0.02 ms
    Init0.02 ms
    Optimizing0.02 ms
    Statistics0.05 ms
    Preparing0.03 ms
    Executing0.01 ms
    Sending data0.07 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Closing tables0.01 ms
    Unlocking tables0.01 ms
    Closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.05 ms
    Updating status0.01 ms
    Waiting for query cache lock0.01 ms
    Updating status0.08 ms
    Waiting for query cache lock0.01 ms
    Updating status0.01 ms
    Storing result in query cache0.01 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile and line number
    6JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    5JDatabaseDriver->loadObjectList()JROOT/libraries/cms/application/site.php:484
    4JApplicationSite->getTemplate()JROOT/libraries/cms/application/site.php:165
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  13. Query Time: 0.18 ms After last query: 9.57 ms Query memory: 0.027 MB Memory before query: 6.900 MB Rows returned: 3
    Duplicate queries: #26
    SELECT a.filename as filename, a.type as type, a.menulink as menulink 
      FROM j0ojv_phocagallery_styles AS a
      WHERE a.published = 1
      ORDER BY a.type, a.ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaALLNULLNO INDEX KEY COULD BE USEDNULLNULL4Using where; Using filesort
    Profile
    StatusDuration
    Starting0.06 ms
    Waiting for query cache lock0.01 ms
    Init0.01 ms
    Checking query cache for query0.01 ms
    Checking privileges on cached 0.01 ms
    Checking permissions0.01 ms
    Sending cached result to clien0.04 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    13JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    12JDatabaseDriver->loadObjectList()JROOT/administrator/components/com_phocagallery/libraries/phocagallery/render/renderfront.php:722
    11PhocaGalleryRenderFront::renderAllCSS()JROOT/components/com_phocagallery/views/categories/view.html.php:41
    10PhocaGalleryViewCategories->display()JROOT/libraries/legacy/controller/legacy.php:664
    9JControllerLegacy->display()JROOT/components/com_phocagallery/controller.php:30
    8PhocaGalleryController->display()JROOT/libraries/legacy/controller/legacy.php:702
    7JControllerLegacy->execute()JROOT/components/com_phocagallery/phocagallery.php:55
    6require_once JROOT/components/com_phocagallery/phocagallery.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  14. Query Time: 3.40 ms After last query: 3.52 ms Query memory: 0.054 MB Memory before query: 7.231 MB Rows returned: 11
    SELECT cc.*, a.catid, COUNT(a.id) AS numlinks, u.username AS username, r.count AS ratingcount, r.average AS ratingaverage, uc.avatar AS avatar, uc.approved AS avatarapproved, uc.published AS avatarpublished, a.filename, a.exts, a.extm, a.extw, a.exth, 
      CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as slug
      FROM j0ojv_phocagallery_categories AS cc
      LEFT JOIN j0ojv_phocagallery AS a
      ON a.catid = cc.id
      and a.published = 1
      LEFT JOIN j0ojv_phocagallery_user AS uc
      ON uc.userid = cc.owner_id
      LEFT JOIN j0ojv_users AS u
      ON u.id = cc.owner_id
      LEFT JOIN j0ojv_phocagallery_votes_statistics AS r
      ON r.catid = cc.id
      WHERE cc.published = 1
      AND cc.approved = 1
      GROUP BY cc.id
      ORDER BY cc.ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEccALLNULLNO INDEX KEY COULD BE USEDNULLNULL13Using where; Using temporary; Using filesort
    1SIMPLEarefcatidcatid5poltekke_beginning2.cc.id,const6
    1SIMPLEucALLuseridNO INDEX KEY COULD BE USEDNULLNULL1Using where; Using join buffer (flat, BNL join)
    1SIMPLEueq_refPRIMARYPRIMARY4poltekke_beginning2.cc.owner_id1
    1SIMPLErALLNULLNO INDEX KEY COULD BE USEDNULLNULL1Using where; Using join buffer (flat, BNL join)
    Profile
    StatusDuration
    Starting0.06 ms
    Waiting for query cache lock0.01 ms
    Init0.01 ms
    Checking query cache for query0.10 ms
    Checking permissions0.01 ms
    Opening tables0.60 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Waiting for query cache lock0.03 ms
    Init0.06 ms
    Optimizing0.03 ms
    Statistics0.04 ms
    Preparing0.03 ms
    Creating tmp table0.07 ms
    Sorting result0.03 ms
    Executing0.01 ms
    Sending data1.78 ms
    Creating sort index0.10 ms
    Removing tmp table0.11 ms
    Creating sort index0.01 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Closing tables0.01 ms
    Unlocking tables0.01 ms
    Closing tables0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.06 ms
    Updating status0.01 ms
    Waiting for query cache lock0.01 ms
    Updating status0.02 ms
    Waiting for query cache lock0.01 ms
    Updating status0.01 ms
    Storing result in query cache0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    14JDatabaseDriver->loadObjectList()JROOT/libraries/legacy/model/legacy.php:310
    13JModelLegacy->_getList()JROOT/components/com_phocagallery/models/categories.php:49
    12PhocagalleryModelCategories->getData()JROOT/libraries/legacy/view/legacy.php:408
    11JViewLegacy->get()JROOT/components/com_phocagallery/views/categories/view.html.php:161
    10PhocaGalleryViewCategories->display()JROOT/libraries/legacy/controller/legacy.php:664
    9JControllerLegacy->display()JROOT/components/com_phocagallery/controller.php:30
    8PhocaGalleryController->display()JROOT/libraries/legacy/controller/legacy.php:702
    7JControllerLegacy->execute()JROOT/components/com_phocagallery/phocagallery.php:55
    6require_once JROOT/components/com_phocagallery/phocagallery.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  15. Query Time: 1.01 ms After last query: 11.91 ms Query memory: 0.031 MB Memory before query: 7.957 MB Rows returned: 13
    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM j0ojv_modules AS m
      LEFT JOIN j0ojv_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN j0ojv_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-02-03 22:55:52')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-02-03 22:55:52')
      AND m.access IN (1,1)
      AND m.client_id = 0
      AND (mm.menuid = 188 OR mm.menuid <= 0)
      ORDER BY m.position, m.ordering
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmrefPRIMARY,published,newsfeedspublished1const24Using index condition; Using where; Using filesort
    1SIMPLEmmrefPRIMARYPRIMARY4poltekke_beginning2.m.id1Using where; Using index
    1SIMPLEerefelement_clientid,element_folder_clientidelement_clientid403poltekke_beginning2.m.module,const1Using index condition; Using where
    Profile
    StatusDuration
    Starting0.06 ms
    Waiting for query cache lock0.01 ms
    Init0.01 ms
    Checking query cache for query0.07 ms
    Checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Waiting for query cache lock0.02 ms
    Init0.04 ms
    Optimizing0.04 ms
    Statistics0.07 ms
    Preparing0.04 ms
    Sorting result0.01 ms
    Executing0.01 ms
    Sending data0.01 ms
    Creating sort index0.29 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Closing tables0.01 ms
    Unlocking tables0.01 ms
    Closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.06 ms
    Updating status0.01 ms
    Waiting for query cache lock0.01 ms
    Updating status0.02 ms
    Waiting for query cache lock0.01 ms
    Updating status0.01 ms
    Storing result in query cache0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    13JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/cache/controller/callback.php:152
    12JCacheControllerCallback->get()JROOT/libraries/cms/module/helper.php:425
    11JModuleHelper::getModuleList()JROOT/libraries/cms/module/helper.php:361
    10JModuleHelper::load()JROOT/libraries/cms/module/helper.php:84
    9JModuleHelper::getModules()JROOT/libraries/joomla/document/html.php:501
    8JDocumentHtml->countModules()JROOT/templates/sw-poltekkes/index.php:51
    7require JROOT/templates/sw-poltekkes/index.phpJROOT/libraries/joomla/document/html.php:578
    6JDocumentHtml->_loadTemplate()JROOT/libraries/joomla/document/html.php:640
    5JDocumentHtml->_fetchTemplate()JROOT/libraries/joomla/document/html.php:455
    4JDocumentHtml->parse()JROOT/libraries/cms/application/cms.php:1072
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:773
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:267
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  16. Query Time: 0.85 ms After last query: 4.12 ms Query memory: 0.037 MB Memory before query: 8.361 MB Rows returned: 8
    SHOW FULL COLUMNS 
      FROM `j0ojv_assets`
    Explain
    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `j0ojv_assets`
    Profile
    StatusDuration
    Starting0.09 ms
    Checking permissions0.01 ms
    Closing tables0.01 ms
    Opening tables0.21 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Init0.01 ms
    Optimizing0.01 ms
    Statistics0.01 ms
    Preparing0.02 ms
    Executing0.01 ms
    Filling schema table0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    Checking permissions0.06 ms
    Closing tables0.01 ms
    Executing0.01 ms
    Sending data0.03 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Closing tables0.01 ms
    Removing tmp table0.09 ms
    Closing tables0.01 ms
    Unlocking tables0.01 ms
    Closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.05 ms
    Updating status0.02 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    25JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    24JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/database/driver/mysqli.php:440
    23JDatabaseDriverMysqli->getTableColumns()JROOT/libraries/joomla/table/table.php:241
    22JTable->getFields()JROOT/libraries/joomla/table/table.php:162
    21JTable->__construct()JROOT/libraries/joomla/table/asset.php:60
    20JTableAsset->__construct()JROOT/libraries/joomla/table/table.php:308
    19JTable::getInstance()JROOT/libraries/joomla/access/access.php:696
    18JAccess::getExtensionNameFromAsset()JROOT/libraries/joomla/access/access.php:555
    17JAccess::getAssetRules()JROOT/libraries/joomla/user/user.php:385
    16JUser->authorise()JROOT/components/com_content/models/articles.php:466
    15ContentModelArticles->getListQuery()JROOT/libraries/legacy/model/list.php:129
    14JModelList->_getListQuery()JROOT/libraries/legacy/model/list.php:183
    13JModelList->getItems()JROOT/components/com_content/models/articles.php:565
    12ContentModelArticles->getItems()JROOT/modules/mod_articles_latest/helper.php:113
    11ModArticlesLatestHelper::getList()JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
    10include JROOT/modules/mod_articles_latest/mod_articles_latest.phpJROOT/libraries/cms/module/helper.php:199
    9JModuleHelper::renderModule()JROOT/libraries/joomla/document/renderer/html/module.php:93
    8JDocumentRendererHtmlModule->render()JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7JDocumentRendererHtmlModules->render()JROOT/libraries/joomla/document/html.php:411
    6JDocumentHtml->getBuffer()JROOT/libraries/joomla/document/html.php:702
    5JDocumentHtml->_renderTemplate()JROOT/libraries/joomla/document/html.php:477
    4JDocumentHtml->render()JROOT/libraries/cms/application/cms.php:1086
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:773
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:267
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  17. Query Time: 0.15 ms After last query: 0.44 ms Query memory: 0.034 MB Memory before query: 8.409 MB Rows returned: 1
    SELECT *
    
      FROM j0ojv_assets
      WHERE `id` = '1'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEj0ojv_assetsconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    Starting0.05 ms
    Waiting for query cache lock0.01 ms
    Init0.01 ms
    Checking query cache for query0.01 ms
    Checking privileges on cached 0.01 ms
    Checking permissions0.01 ms
    Sending cached result to clien0.04 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1453
    20JDatabaseDriver->loadAssoc()JROOT/libraries/joomla/table/table.php:719
    19JTable->load()JROOT/libraries/joomla/access/access.php:697
    18JAccess::getExtensionNameFromAsset()JROOT/libraries/joomla/access/access.php:555
    17JAccess::getAssetRules()JROOT/libraries/joomla/user/user.php:385
    16JUser->authorise()JROOT/components/com_content/models/articles.php:466
    15ContentModelArticles->getListQuery()JROOT/libraries/legacy/model/list.php:129
    14JModelList->_getListQuery()JROOT/libraries/legacy/model/list.php:183
    13JModelList->getItems()JROOT/components/com_content/models/articles.php:565
    12ContentModelArticles->getItems()JROOT/modules/mod_articles_latest/helper.php:113
    11ModArticlesLatestHelper::getList()JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
    10include JROOT/modules/mod_articles_latest/mod_articles_latest.phpJROOT/libraries/cms/module/helper.php:199
    9JModuleHelper::renderModule()JROOT/libraries/joomla/document/renderer/html/module.php:93
    8JDocumentRendererHtmlModule->render()JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7JDocumentRendererHtmlModules->render()JROOT/libraries/joomla/document/html.php:411
    6JDocumentHtml->getBuffer()JROOT/libraries/joomla/document/html.php:702
    5JDocumentHtml->_renderTemplate()JROOT/libraries/joomla/document/html.php:477
    4JDocumentHtml->render()JROOT/libraries/cms/application/cms.php:1086
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:773
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:267
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  18. Query Time: 0.13 ms After last query: 0.09 ms Query memory: 0.030 MB Memory before query: 8.421 MB Rows returned: 1
    SELECT a.rules
    
      FROM j0ojv_assets AS a
      WHERE (a.id = 1 OR a.name = 'root.1')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaindex_mergePRIMARY,idx_asset_namePRIMARY,idx_asset_name4,202NULL2Using union(PRIMARY,idx_asset_name); Using where
    Profile
    StatusDuration
    Starting0.04 ms
    Waiting for query cache lock0.01 ms
    Init0.01 ms
    Checking query cache for query0.01 ms
    Checking privileges on cached 0.01 ms
    Checking permissions0.01 ms
    Sending cached result to clien0.04 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1538
    18JDatabaseDriver->loadColumn()JROOT/libraries/joomla/access/access.php:652
    17JAccess::getAssetRules()JROOT/libraries/joomla/user/user.php:385
    16JUser->authorise()JROOT/components/com_content/models/articles.php:466
    15ContentModelArticles->getListQuery()JROOT/libraries/legacy/model/list.php:129
    14JModelList->_getListQuery()JROOT/libraries/legacy/model/list.php:183
    13JModelList->getItems()JROOT/components/com_content/models/articles.php:565
    12ContentModelArticles->getItems()JROOT/modules/mod_articles_latest/helper.php:113
    11ModArticlesLatestHelper::getList()JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
    10include JROOT/modules/mod_articles_latest/mod_articles_latest.phpJROOT/libraries/cms/module/helper.php:199
    9JModuleHelper::renderModule()JROOT/libraries/joomla/document/renderer/html/module.php:93
    8JDocumentRendererHtmlModule->render()JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7JDocumentRendererHtmlModules->render()JROOT/libraries/joomla/document/html.php:411
    6JDocumentHtml->getBuffer()JROOT/libraries/joomla/document/html.php:702
    5JDocumentHtml->_renderTemplate()JROOT/libraries/joomla/document/html.php:477
    4JDocumentHtml->render()JROOT/libraries/cms/application/cms.php:1086
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:773
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:267
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  19. Query Time: 0.61 ms After last query: 0.46 ms Query memory: 0.034 MB Memory before query: 8.453 MB Rows returned: 37
    SELECT element
    
      FROM j0ojv_extensions
      WHERE type = 'component'
      AND enabled = '1'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEj0ojv_extensionsrefextensionextension82const37Using index condition; Using where
    Profile
    StatusDuration
    Starting0.05 ms
    Waiting for query cache lock0.01 ms
    Init0.01 ms
    Checking query cache for query0.03 ms
    Checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.02 ms
    System lock0.01 ms
    Table lock0.01 ms
    Waiting for query cache lock0.01 ms
    Init0.02 ms
    Optimizing0.02 ms
    Statistics0.04 ms
    Preparing0.02 ms
    Executing0.01 ms
    Sending data0.11 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Closing tables0.01 ms
    Unlocking tables0.01 ms
    Closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.05 ms
    Updating status0.01 ms
    Waiting for query cache lock0.01 ms
    Updating status0.03 ms
    Waiting for query cache lock0.01 ms
    Updating status0.01 ms
    Storing result in query cache0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1538
    20JDatabaseDriver->loadColumn()JROOT/libraries/joomla/access/access.php:413
    19JAccess::preloadComponents()JROOT/libraries/joomla/access/access.php:213
    18JAccess::preload()JROOT/libraries/joomla/access/access.php:168
    17JAccess::check()JROOT/libraries/joomla/user/user.php:394
    16JUser->authorise()JROOT/components/com_content/models/articles.php:466
    15ContentModelArticles->getListQuery()JROOT/libraries/legacy/model/list.php:129
    14JModelList->_getListQuery()JROOT/libraries/legacy/model/list.php:183
    13JModelList->getItems()JROOT/components/com_content/models/articles.php:565
    12ContentModelArticles->getItems()JROOT/modules/mod_articles_latest/helper.php:113
    11ModArticlesLatestHelper::getList()JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
    10include JROOT/modules/mod_articles_latest/mod_articles_latest.phpJROOT/libraries/cms/module/helper.php:199
    9JModuleHelper::renderModule()JROOT/libraries/joomla/document/renderer/html/module.php:93
    8JDocumentRendererHtmlModule->render()JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7JDocumentRendererHtmlModules->render()JROOT/libraries/joomla/document/html.php:411
    6JDocumentHtml->getBuffer()JROOT/libraries/joomla/document/html.php:702
    5JDocumentHtml->_renderTemplate()JROOT/libraries/joomla/document/html.php:477
    4JDocumentHtml->render()JROOT/libraries/cms/application/cms.php:1086
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:773
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:267
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  20. Query Time: 0.14 ms After last query: 0.10 ms Query memory: 0.034 MB Memory before query: 8.472 MB Rows returned: 37
    SELECT a.name, a.rules
    
      FROM j0ojv_assets AS a
      WHERE (a.name IN ('com_admin','com_ajax','com_akeeba','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_easybookreloaded','com_finder','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_nivoslider','com_phocadownload','com_phocagallery','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper','com_zoo') OR a.name = 'root.1')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEarangeidx_asset_nameidx_asset_name202NULL38Using index condition; Using where
    Profile
    StatusDuration
    Starting0.04 ms
    Waiting for query cache lock0.01 ms
    Init0.01 ms
    Checking query cache for query0.01 ms
    Checking privileges on cached 0.01 ms
    Checking permissions0.01 ms
    Sending cached result to clien0.04 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1494
    20JDatabaseDriver->loadAssocList()JROOT/libraries/joomla/access/access.php:441
    19JAccess::preloadComponents()JROOT/libraries/joomla/access/access.php:213
    18JAccess::preload()JROOT/libraries/joomla/access/access.php:168
    17JAccess::check()JROOT/libraries/joomla/user/user.php:394
    16JUser->authorise()JROOT/components/com_content/models/articles.php:466
    15ContentModelArticles->getListQuery()JROOT/libraries/legacy/model/list.php:129
    14JModelList->_getListQuery()JROOT/libraries/legacy/model/list.php:183
    13JModelList->getItems()JROOT/components/com_content/models/articles.php:565
    12ContentModelArticles->getItems()JROOT/modules/mod_articles_latest/helper.php:113
    11ModArticlesLatestHelper::getList()JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
    10include JROOT/modules/mod_articles_latest/mod_articles_latest.phpJROOT/libraries/cms/module/helper.php:199
    9JModuleHelper::renderModule()JROOT/libraries/joomla/document/renderer/html/module.php:93
    8JDocumentRendererHtmlModule->render()JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7JDocumentRendererHtmlModules->render()JROOT/libraries/joomla/document/html.php:411
    6JDocumentHtml->getBuffer()JROOT/libraries/joomla/document/html.php:702
    5JDocumentHtml->_renderTemplate()JROOT/libraries/joomla/document/html.php:477
    4JDocumentHtml->render()JROOT/libraries/cms/application/cms.php:1086
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:773
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:267
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  21. Query Time: 1.48 ms After last query: 0.66 ms Query memory: 0.043 MB Memory before query: 8.678 MB Rows returned: 4
    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN 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,
      CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
      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,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
      CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
      FROM j0ojv_content AS a
      LEFT JOIN j0ojv_categories AS c
      ON c.id = a.catid
      LEFT JOIN j0ojv_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN j0ojv_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN j0ojv_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN j0ojv_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM j0ojv_categories AS cat JOIN j0ojv_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id ) AS badcats
      ON badcats.id = c.id
      WHERE a.access IN (1,1)
      AND c.access IN (1,1)
      AND
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
      AND a.catid IN (17)
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-02-03 22:55:52')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-02-03 22:55:52')
      ORDER BY a.created DESC
      LIMIT 5
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1PRIMARYcconstPRIMARY,idx_accessPRIMARY4const1
    1PRIMARYarefidx_access,idx_catididx_catid4const16Using where; Using filesort
    1PRIMARYuaeq_refPRIMARYPRIMARY4poltekke_beginning2.a.created_by1Using where
    1PRIMARYuameq_refPRIMARYPRIMARY4poltekke_beginning2.a.modified_by1Using where
    1PRIMARYparenteq_refPRIMARYPRIMARY4const1Using where
    1PRIMARYveq_refPRIMARYPRIMARY4poltekke_beginning2.a.id1Using where
    1PRIMARY<derived2>refkey0key05const5Using where
    2DERIVEDparentrangecat_idx,idx_left_rightcat_idx203NULL2Using index condition; Using temporary; Using filesort
    2DERIVEDcatindexPRIMARY,idx_left_rightidx_left_right8NULL26Using where; Using index; Using join buffer (flat, BNL join)
    Profile
    StatusDuration
    Starting0.06 ms
    Waiting for query cache lock0.01 ms
    Init0.01 ms
    Checking query cache for query0.17 ms
    Checking permissions0.01 ms
    Opening tables0.07 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Waiting for query cache lock0.03 ms
    Init0.09 ms
    Optimizing0.04 ms
    Optimizing0.02 ms
    Statistics0.06 ms
    Statistics0.10 ms
    Preparing0.03 ms
    Creating tmp table0.02 ms
    Sorting result0.02 ms
    Preparing0.01 ms
    Unlocking tables0.01 ms
    Preparing0.04 ms
    Sorting result0.02 ms
    Executing0.01 ms
    Sending data0.03 ms
    Creating sort index0.14 ms
    Executing0.01 ms
    Sending data0.03 ms
    Creating sort index0.02 ms
    Removing tmp table0.01 ms
    Creating sort index0.11 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Closing tables0.01 ms
    Removing tmp table0.01 ms
    Closing tables0.01 ms
    Unlocking tables0.01 ms
    Closing tables0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.06 ms
    Updating status0.01 ms
    Waiting for query cache lock0.01 ms
    Updating status0.02 ms
    Waiting for query cache lock0.01 ms
    Updating status0.01 ms
    Storing result in query cache0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    15JDatabaseDriver->loadObjectList()JROOT/libraries/legacy/model/legacy.php:310
    14JModelLegacy->_getList()JROOT/libraries/legacy/model/list.php:183
    13JModelList->getItems()JROOT/components/com_content/models/articles.php:565
    12ContentModelArticles->getItems()JROOT/modules/mod_articles_latest/helper.php:113
    11ModArticlesLatestHelper::getList()JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
    10include JROOT/modules/mod_articles_latest/mod_articles_latest.phpJROOT/libraries/cms/module/helper.php:199
    9JModuleHelper::renderModule()JROOT/libraries/joomla/document/renderer/html/module.php:93
    8JDocumentRendererHtmlModule->render()JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7JDocumentRendererHtmlModules->render()JROOT/libraries/joomla/document/html.php:411
    6JDocumentHtml->getBuffer()JROOT/libraries/joomla/document/html.php:702
    5JDocumentHtml->_renderTemplate()JROOT/libraries/joomla/document/html.php:477
    4JDocumentHtml->render()JROOT/libraries/cms/application/cms.php:1086
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:773
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:267
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  22. Query Time: 0.19 ms After last query: 1.58 ms Query memory: 0.039 MB Memory before query: 9.025 MB Rows returned: 2
    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
      FROM j0ojv_categories as c
      LEFT JOIN (SELECT cat.id as id
      FROM j0ojv_categories AS cat JOIN j0ojv_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      LEFT JOIN j0ojv_categories AS s
      ON (s.lft <= c.lft
      AND s.rgt >= c.rgt) OR (s.lft > c.lft
      AND s.rgt < c.rgt)
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1)
      AND c.published = 1
      AND badcats.id is null
      AND s.id=17
      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
      ORDER BY c.lft
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1PRIMARYsconstPRIMARY,idx_left_rightPRIMARY4const1Using temporary; Using filesort
    1PRIMARYcALLcat_idx,idx_access,idx_left_rightNO INDEX KEY COULD BE USEDNULLNULL26Using where
    1PRIMARY<derived2>refkey0key05poltekke_beginning2.c.id5Using where
    2DERIVEDparentrangecat_idx,idx_left_rightcat_idx203NULL2Using index condition; Using temporary; Using filesort
    2DERIVEDcatindexPRIMARY,idx_left_rightidx_left_right8NULL26Using where; Using index; Using join buffer (flat, BNL join)
    Profile
    StatusDuration
    Starting0.06 ms
    Waiting for query cache lock0.01 ms
    Init0.01 ms
    Checking query cache for query0.01 ms
    Checking privileges on cached 0.01 ms
    Checking permissions0.01 ms
    Sending cached result to clien0.04 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    15JDatabaseDriver->loadObjectList()JROOT/libraries/legacy/categories/categories.php:309
    14JCategories->_load()JROOT/libraries/legacy/categories/categories.php:184
    13JCategories->get()JROOT/components/com_content/helpers/route.php:44
    12ContentHelperRoute::getArticleRoute()JROOT/modules/mod_articles_latest/helper.php:123
    11ModArticlesLatestHelper::getList()JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
    10include JROOT/modules/mod_articles_latest/mod_articles_latest.phpJROOT/libraries/cms/module/helper.php:199
    9JModuleHelper::renderModule()JROOT/libraries/joomla/document/renderer/html/module.php:93
    8JDocumentRendererHtmlModule->render()JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7JDocumentRendererHtmlModules->render()JROOT/libraries/joomla/document/html.php:411
    6JDocumentHtml->getBuffer()JROOT/libraries/joomla/document/html.php:702
    5JDocumentHtml->_renderTemplate()JROOT/libraries/joomla/document/html.php:477
    4JDocumentHtml->render()JROOT/libraries/cms/application/cms.php:1086
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:773
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:267
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  23. Query Time: 6.76 ms After last query: 1.57 ms Query memory: 0.079 MB Memory before query: 8.925 MB Rows returned: 5
    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 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,
      CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
      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,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
      CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
      FROM j0ojv_content AS a
      LEFT JOIN j0ojv_categories AS c
      ON c.id = a.catid
      LEFT JOIN j0ojv_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN j0ojv_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN j0ojv_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN j0ojv_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM j0ojv_categories AS cat JOIN j0ojv_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id ) AS badcats
      ON badcats.id = c.id
      WHERE a.access IN (1,1)
      AND c.access IN (1,1)
      AND
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
      AND a.catid IN (8,14,15)
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-02-03 22:55:52')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-02-03 22:55:52')
      ORDER BY a.hits DESC
      LIMIT 5
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1PRIMARYcrangePRIMARY,idx_accessidx_access4NULL26Using index condition; Using temporary; Using filesort
    1PRIMARYarefidx_access,idx_catididx_catid4poltekke_beginning2.c.id7Using index condition; Using where
    1PRIMARYuaeq_refPRIMARYPRIMARY4poltekke_beginning2.a.created_by1Using where
    1PRIMARYuameq_refPRIMARYPRIMARY4poltekke_beginning2.a.modified_by1Using where
    1PRIMARYparenteq_refPRIMARYPRIMARY4poltekke_beginning2.c.parent_id1Using where
    1PRIMARYveq_refPRIMARYPRIMARY4poltekke_beginning2.a.id1Using where
    1PRIMARY<derived2>refkey0key05poltekke_beginning2.c.id5Using where
    2DERIVEDparentrangecat_idx,idx_left_rightcat_idx203NULL2Using index condition; Using temporary; Using filesort
    2DERIVEDcatindexPRIMARY,idx_left_rightidx_left_right8NULL26Using where; Using index; Using join buffer (flat, BNL join)
    Profile
    StatusDuration
    Starting0.06 ms
    Waiting for query cache lock0.01 ms
    Init0.01 ms
    Checking query cache for query0.16 ms
    Checking permissions0.01 ms
    Opening tables0.04 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Waiting for query cache lock0.03 ms
    Init0.08 ms
    Optimizing0.04 ms
    Optimizing0.02 ms
    Statistics0.05 ms
    Statistics0.08 ms
    Preparing0.02 ms
    Creating tmp table0.02 ms
    Sorting result0.02 ms
    Preparing0.05 ms
    Creating tmp table0.08 ms
    Sorting result0.02 ms
    Executing0.01 ms
    Sending data0.14 ms
    Executing0.01 ms
    Sending data0.03 ms
    Creating sort index0.02 ms
    Removing tmp table0.01 ms
    Creating sort index3.58 ms
    Creating sort index0.29 ms
    Waiting for query cache lock0.01 ms
    Creating sort index0.04 ms
    Waiting for query cache lock0.01 ms
    Creating sort index0.03 ms
    Removing tmp table1.51 ms
    Creating sort index0.02 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Closing tables0.01 ms
    Removing tmp table0.01 ms
    Closing tables0.01 ms
    Unlocking tables0.01 ms
    Closing tables0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.06 ms
    Updating status0.01 ms
    Waiting for query cache lock0.01 ms
    Updating status0.02 ms
    Waiting for query cache lock0.01 ms
    Updating status0.01 ms
    Storing result in query cache0.02 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    15JDatabaseDriver->loadObjectList()JROOT/libraries/legacy/model/legacy.php:310
    14JModelLegacy->_getList()JROOT/libraries/legacy/model/list.php:183
    13JModelList->getItems()JROOT/components/com_content/models/articles.php:565
    12ContentModelArticles->getItems()JROOT/modules/mod_articles_popular/helper.php:73
    11ModArticlesPopularHelper::getList()JROOT/modules/mod_articles_popular/mod_articles_popular.php:15
    10include JROOT/modules/mod_articles_popular/mod_articles_popular.phpJROOT/libraries/cms/module/helper.php:199
    9JModuleHelper::renderModule()JROOT/libraries/joomla/document/renderer/html/module.php:93
    8JDocumentRendererHtmlModule->render()JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7JDocumentRendererHtmlModules->render()JROOT/libraries/joomla/document/html.php:411
    6JDocumentHtml->getBuffer()JROOT/libraries/joomla/document/html.php:702
    5JDocumentHtml->_renderTemplate()JROOT/libraries/joomla/document/html.php:477
    4JDocumentHtml->render()JROOT/libraries/cms/application/cms.php:1086
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:773
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:267
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  24. Query Time: 0.19 ms After last query: 0.48 ms Query memory: 0.039 MB Memory before query: 9.184 MB Rows returned: 2
    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
      FROM j0ojv_categories as c
      LEFT JOIN (SELECT cat.id as id
      FROM j0ojv_categories AS cat JOIN j0ojv_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      LEFT JOIN j0ojv_categories AS s
      ON (s.lft <= c.lft
      AND s.rgt >= c.rgt) OR (s.lft > c.lft
      AND s.rgt < c.rgt)
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1)
      AND c.published = 1
      AND badcats.id is null
      AND s.id=8
      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
      ORDER BY c.lft
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1PRIMARYsconstPRIMARY,idx_left_rightPRIMARY4const1Using temporary; Using filesort
    1PRIMARYcALLcat_idx,idx_access,idx_left_rightNO INDEX KEY COULD BE USEDNULLNULL26Using where
    1PRIMARY<derived2>refkey0key05poltekke_beginning2.c.id5Using where
    2DERIVEDparentrangecat_idx,idx_left_rightcat_idx203NULL2Using index condition; Using temporary; Using filesort
    2DERIVEDcatindexPRIMARY,idx_left_rightidx_left_right8NULL26Using where; Using index; Using join buffer (flat, BNL join)
    Profile
    StatusDuration
    Starting0.06 ms
    Waiting for query cache lock0.01 ms
    Init0.01 ms
    Checking query cache for query0.02 ms
    Checking privileges on cached 0.01 ms
    Checking permissions0.01 ms
    Sending cached result to clien0.04 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    15JDatabaseDriver->loadObjectList()JROOT/libraries/legacy/categories/categories.php:309
    14JCategories->_load()JROOT/libraries/legacy/categories/categories.php:184
    13JCategories->get()JROOT/components/com_content/helpers/route.php:44
    12ContentHelperRoute::getArticleRoute()JROOT/modules/mod_articles_popular/helper.php:83
    11ModArticlesPopularHelper::getList()JROOT/modules/mod_articles_popular/mod_articles_popular.php:15
    10include JROOT/modules/mod_articles_popular/mod_articles_popular.phpJROOT/libraries/cms/module/helper.php:199
    9JModuleHelper::renderModule()JROOT/libraries/joomla/document/renderer/html/module.php:93
    8JDocumentRendererHtmlModule->render()JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7JDocumentRendererHtmlModules->render()JROOT/libraries/joomla/document/html.php:411
    6JDocumentHtml->getBuffer()JROOT/libraries/joomla/document/html.php:702
    5JDocumentHtml->_renderTemplate()JROOT/libraries/joomla/document/html.php:477
    4JDocumentHtml->render()JROOT/libraries/cms/application/cms.php:1086
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:773
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:267
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  25. Query Time: 6.22 ms After last query: 0.84 ms Query memory: 0.059 MB Memory before query: 8.972 MB Rows returned: 5
    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 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,
      CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
      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,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
      CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
      FROM j0ojv_content AS a
      LEFT JOIN j0ojv_categories AS c
      ON c.id = a.catid
      LEFT JOIN j0ojv_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN j0ojv_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN j0ojv_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN j0ojv_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM j0ojv_categories AS cat JOIN j0ojv_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id ) AS badcats
      ON badcats.id = c.id
      WHERE a.access IN (1,1)
      AND c.access IN (1,1)
      AND
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
      AND a.catid IN (8,14,15)
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-02-03 22:55:52')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-02-03 22:55:52')
      ORDER BY a.created DESC
      LIMIT 5
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1PRIMARYcrangePRIMARY,idx_accessidx_access4NULL26Using index condition; Using temporary; Using filesort
    1PRIMARYarefidx_access,idx_catididx_catid4poltekke_beginning2.c.id7Using index condition; Using where
    1PRIMARYuaeq_refPRIMARYPRIMARY4poltekke_beginning2.a.created_by1Using where
    1PRIMARYuameq_refPRIMARYPRIMARY4poltekke_beginning2.a.modified_by1Using where
    1PRIMARYparenteq_refPRIMARYPRIMARY4poltekke_beginning2.c.parent_id1Using where
    1PRIMARYveq_refPRIMARYPRIMARY4poltekke_beginning2.a.id1Using where
    1PRIMARY<derived2>refkey0key05poltekke_beginning2.c.id5Using where
    2DERIVEDparentrangecat_idx,idx_left_rightcat_idx203NULL2Using index condition; Using temporary; Using filesort
    2DERIVEDcatindexPRIMARY,idx_left_rightidx_left_right8NULL26Using where; Using index; Using join buffer (flat, BNL join)
    Profile
    StatusDuration
    Starting0.07 ms
    Waiting for query cache lock0.01 ms
    Init0.01 ms
    Checking query cache for query0.16 ms
    Checking permissions0.01 ms
    Opening tables0.04 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Waiting for query cache lock0.03 ms
    Init0.08 ms
    Optimizing0.05 ms
    Optimizing0.02 ms
    Statistics0.05 ms
    Statistics0.07 ms
    Preparing0.02 ms
    Creating tmp table0.02 ms
    Sorting result0.02 ms
    Preparing0.05 ms
    Creating tmp table0.06 ms
    Sorting result0.02 ms
    Executing0.01 ms
    Sending data0.12 ms
    Executing0.01 ms
    Sending data0.02 ms
    Creating sort index0.02 ms
    Removing tmp table0.01 ms
    Creating sort index3.20 ms
    Creating sort index0.28 ms
    Waiting for query cache lock0.01 ms
    Creating sort index0.04 ms
    Removing tmp table1.40 ms
    Creating sort index0.02 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Closing tables0.01 ms
    Removing tmp table0.01 ms
    Closing tables0.01 ms
    Unlocking tables0.01 ms
    Closing tables0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.06 ms
    Updating status0.01 ms
    Waiting for query cache lock0.01 ms
    Updating status0.02 ms
    Waiting for query cache lock0.01 ms
    Updating status0.01 ms
    Storing result in query cache0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    15JDatabaseDriver->loadObjectList()JROOT/libraries/legacy/model/legacy.php:310
    14JModelLegacy->_getList()JROOT/libraries/legacy/model/list.php:183
    13JModelList->getItems()JROOT/components/com_content/models/articles.php:565
    12ContentModelArticles->getItems()JROOT/modules/mod_articles_latest/helper.php:113
    11ModArticlesLatestHelper::getList()JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
    10include JROOT/modules/mod_articles_latest/mod_articles_latest.phpJROOT/libraries/cms/module/helper.php:199
    9JModuleHelper::renderModule()JROOT/libraries/joomla/document/renderer/html/module.php:93
    8JDocumentRendererHtmlModule->render()JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7JDocumentRendererHtmlModules->render()JROOT/libraries/joomla/document/html.php:411
    6JDocumentHtml->getBuffer()JROOT/libraries/joomla/document/html.php:702
    5JDocumentHtml->_renderTemplate()JROOT/libraries/joomla/document/html.php:477
    4JDocumentHtml->render()JROOT/libraries/cms/application/cms.php:1086
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:773
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:267
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  26. Query Time: 0.16 ms After last query: 2.51 ms Query memory: 0.027 MB Memory before query: 9.123 MB Rows returned: 3
    Duplicate queries: #13
    SELECT a.filename as filename, a.type as type, a.menulink as menulink 
      FROM j0ojv_phocagallery_styles AS a
      WHERE a.published = 1
      ORDER BY a.type, a.ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaALLNULLNO INDEX KEY COULD BE USEDNULLNULL4Using where; Using filesort
    Profile
    StatusDuration
    Starting0.06 ms
    Waiting for query cache lock0.01 ms
    Init0.01 ms
    Checking query cache for query0.01 ms
    Checking privileges on cached 0.01 ms
    Checking permissions0.01 ms
    Sending cached result to clien0.04 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    13JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    12JDatabaseDriver->loadObjectList()JROOT/administrator/components/com_phocagallery/libraries/phocagallery/render/renderfront.php:722
    11PhocaGalleryRenderFront::renderAllCSS()JROOT/modules/mod_phocagallery_image/mod_phocagallery_image.php:43
    10include JROOT/modules/mod_phocagallery_image/mod_phocagallery_image.phpJROOT/libraries/cms/module/helper.php:199
    9JModuleHelper::renderModule()JROOT/libraries/joomla/document/renderer/html/module.php:93
    8JDocumentRendererHtmlModule->render()JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7JDocumentRendererHtmlModules->render()JROOT/libraries/joomla/document/html.php:411
    6JDocumentHtml->getBuffer()JROOT/libraries/joomla/document/html.php:702
    5JDocumentHtml->_renderTemplate()JROOT/libraries/joomla/document/html.php:477
    4JDocumentHtml->render()JROOT/libraries/cms/application/cms.php:1086
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:773
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:267
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  27. Query Time: 0.18 ms After last query: 2.23 ms Query memory: 0.028 MB Memory before query: 9.320 MB Rows returned: 11
    SELECT cc.title AS text, cc.id AS id, cc.parent_id as parentid, cc.alias as alias, cc.access as access, cc.accessuserid as accessuserid 
      FROM j0ojv_phocagallery_categories AS cc
      WHERE cc.published = 1
      AND cc.access IN (1,1)
      ORDER BY cc.ordering
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEccALLidx_accessNO INDEX KEY COULD BE USEDNULLNULL13Using where; Using filesort
    Profile
    StatusDuration
    Starting0.06 ms
    Waiting for query cache lock0.01 ms
    Init0.01 ms
    Checking query cache for query0.01 ms
    Checking privileges on cached 0.01 ms
    Checking permissions0.01 ms
    Sending cached result to clien0.04 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    11JDatabaseDriver->loadObjectList()JROOT/modules/mod_phocagallery_image/mod_phocagallery_image.php:619
    10include JROOT/modules/mod_phocagallery_image/mod_phocagallery_image.phpJROOT/libraries/cms/module/helper.php:199
    9JModuleHelper::renderModule()JROOT/libraries/joomla/document/renderer/html/module.php:93
    8JDocumentRendererHtmlModule->render()JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7JDocumentRendererHtmlModules->render()JROOT/libraries/joomla/document/html.php:411
    6JDocumentHtml->getBuffer()JROOT/libraries/joomla/document/html.php:702
    5JDocumentHtml->_renderTemplate()JROOT/libraries/joomla/document/html.php:477
    4JDocumentHtml->render()JROOT/libraries/cms/application/cms.php:1086
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:773
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:267
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  28. Query Time: 0.93 ms After last query: 0.07 ms Query memory: 0.026 MB Memory before query: 9.341 MB Rows returned: 9
    SELECT cc.id AS idcat, a.id AS idimage 
      FROM j0ojv_phocagallery_categories AS cc
      LEFT JOIN j0ojv_phocagallery AS a
      ON a.catid = cc.id
      WHERE a.published = 1
      AND a.approved = 1
      AND cc.published = 1
      AND cc.id IN (1,10,2,3,4,5,6,7,8,12,13)
      ORDER BY a.ordering ASC
      LIMIT 0,9
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEccindexPRIMARYcat_idx154NULL13Using where; Using index; Using temporary; Using filesort
    1SIMPLEarefcatidcatid5poltekke_beginning2.cc.id,const6Using where
    Profile
    StatusDuration
    Starting0.04 ms
    Waiting for query cache lock0.01 ms
    Init0.01 ms
    Checking query cache for query0.05 ms
    Checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Waiting for query cache lock0.02 ms
    Init0.03 ms
    Optimizing0.02 ms
    Statistics0.07 ms
    Preparing0.03 ms
    Creating tmp table0.02 ms
    Sorting result0.01 ms
    Executing0.01 ms
    Sending data0.27 ms
    Creating sort index0.03 ms
    Removing tmp table0.01 ms
    Creating sort index0.01 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Closing tables0.01 ms
    Unlocking tables0.01 ms
    Closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.05 ms
    Updating status0.01 ms
    Waiting for query cache lock0.01 ms
    Updating status0.02 ms
    Waiting for query cache lock0.01 ms
    Updating status0.01 ms
    Storing result in query cache0.17 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    11JDatabaseDriver->loadObjectList()JROOT/modules/mod_phocagallery_image/mod_phocagallery_image.php:682
    10include JROOT/modules/mod_phocagallery_image/mod_phocagallery_image.phpJROOT/libraries/cms/module/helper.php:199
    9JModuleHelper::renderModule()JROOT/libraries/joomla/document/renderer/html/module.php:93
    8JDocumentRendererHtmlModule->render()JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7JDocumentRendererHtmlModules->render()JROOT/libraries/joomla/document/html.php:411
    6JDocumentHtml->getBuffer()JROOT/libraries/joomla/document/html.php:702
    5JDocumentHtml->_renderTemplate()JROOT/libraries/joomla/document/html.php:477
    4JDocumentHtml->render()JROOT/libraries/cms/application/cms.php:1086
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:773
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:267
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  29. Query Time: 0.76 ms After last query: 0.06 ms Query memory: 0.033 MB Memory before query: 9.355 MB Rows returned: 9
    SELECT cc.id, cc.alias as catalias, a.id, a.catid, a.title, a.alias, a.filename, a.description, a.extm, a.exts,a.extl, a.exto, a.extw, a.exth, a.extid, 
      CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug,
      CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug
      FROM j0ojv_phocagallery_categories AS cc
      LEFT JOIN j0ojv_phocagallery AS a
      ON a.catid = cc.id
      WHERE a.id in (61,31,64,1,17,51,134,39,57)
      ORDER BY a.ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEarangePRIMARY,catidPRIMARY4NULL9Using where; Using filesort
    1SIMPLEcceq_refPRIMARYPRIMARY4poltekke_beginning2.a.catid1
    Profile
    StatusDuration
    Starting0.04 ms
    Waiting for query cache lock0.01 ms
    Init0.01 ms
    Checking query cache for query0.07 ms
    Checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Waiting for query cache lock0.02 ms
    Init0.04 ms
    Optimizing0.02 ms
    Statistics0.03 ms
    Preparing0.02 ms
    Sorting result0.01 ms
    Executing0.01 ms
    Sending data0.02 ms
    Creating sort index0.10 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Closing tables0.01 ms
    Unlocking tables0.01 ms
    Closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.05 ms
    Updating status0.01 ms
    Waiting for query cache lock0.01 ms
    Updating status0.02 ms
    Waiting for query cache lock0.01 ms
    Updating status0.01 ms
    Storing result in query cache0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    11JDatabaseDriver->loadObjectList()JROOT/modules/mod_phocagallery_image/mod_phocagallery_image.php:706
    10include JROOT/modules/mod_phocagallery_image/mod_phocagallery_image.phpJROOT/libraries/cms/module/helper.php:199
    9JModuleHelper::renderModule()JROOT/libraries/joomla/document/renderer/html/module.php:93
    8JDocumentRendererHtmlModule->render()JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7JDocumentRendererHtmlModules->render()JROOT/libraries/joomla/document/html.php:411
    6JDocumentHtml->getBuffer()JROOT/libraries/joomla/document/html.php:702
    5JDocumentHtml->_renderTemplate()JROOT/libraries/joomla/document/html.php:477
    4JDocumentHtml->render()JROOT/libraries/cms/application/cms.php:1086
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:773
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:267
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  30. Query Time: 0.96 ms After last query: 17.55 ms Query memory: 0.031 MB Memory before query: 10.711 MB Rows returned: 1
    SELECT id,parent_id 
      FROM j0ojv_menu
      WHERE id = 188
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEj0ojv_menuconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    Starting0.09 ms
    Waiting for query cache lock0.01 ms
    Init0.01 ms
    Checking query cache for query0.04 ms
    Checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Waiting for query cache lock0.31 ms
    Init0.03 ms
    Optimizing0.02 ms
    Statistics0.05 ms
    Preparing0.01 ms
    Unlocking tables0.01 ms
    Preparing0.02 ms
    Executing0.01 ms
    Sending data0.02 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Closing tables0.01 ms
    Unlocking tables0.01 ms
    Closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.05 ms
    Updating status0.01 ms
    Waiting for query cache lock0.01 ms
    Updating status0.11 ms
    Waiting for query cache lock0.01 ms
    Updating status0.01 ms
    Storing result in query cache0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1650
    19JDatabaseDriver->loadObject()JROOT/modules/mod_icemegamenu/libs/menucore.php:82
    18IceMenuTree->getCurrentMenuItem()JROOT/modules/mod_icemegamenu/libs/menucore.php:67
    17IceMenuTree->__construct()JROOT/modules/mod_icemegamenu/helper.php:45
    16modIceMegamenuHelper::buildXML()JROOT/libraries/joomla/cache/controller/callback.php:152
    15JCacheControllerCallback->get()JROOT/libraries/joomla/cache/controller/callback.php:40
    14JCacheControllerCallback->call()JROOT/modules/mod_icemegamenu/helper.php:110
    13modIceMegamenuHelper->getXML()JROOT/modules/mod_icemegamenu/helper.php:148
    12modIceMegamenuHelper->render()JROOT/modules/mod_icemegamenu/tmpl/default.php:16
    11require JROOT/modules/mod_icemegamenu/tmpl/default.phpJROOT/modules/mod_icemegamenu/mod_icemegamenu.php:65
    10include JROOT/modules/mod_icemegamenu/mod_icemegamenu.phpJROOT/libraries/cms/module/helper.php:199
    9JModuleHelper::renderModule()JROOT/libraries/joomla/document/renderer/html/module.php:93
    8JDocumentRendererHtmlModule->render()JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7JDocumentRendererHtmlModules->render()JROOT/libraries/joomla/document/html.php:411
    6JDocumentHtml->getBuffer()JROOT/libraries/joomla/document/html.php:702
    5JDocumentHtml->_renderTemplate()JROOT/libraries/joomla/document/html.php:477
    4JDocumentHtml->render()JROOT/libraries/cms/application/cms.php:1086
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:773
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:267
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  31. Query Time: 0.13 ms After last query: 0.05 ms Query memory: 0.031 MB Memory before query: 10.725 MB Rows returned: 1
    SELECT id,parent_id 
      FROM j0ojv_menu
      WHERE id = 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEj0ojv_menuconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    Starting0.05 ms
    Waiting for query cache lock0.01 ms
    Init0.01 ms
    Checking query cache for query0.01 ms
    Checking privileges on cached 0.01 ms
    Checking permissions0.01 ms
    Sending cached result to clien0.04 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1650
    19JDatabaseDriver->loadObject()JROOT/modules/mod_icemegamenu/libs/menucore.php:82
    18IceMenuTree->getCurrentMenuItem()JROOT/modules/mod_icemegamenu/libs/menucore.php:67
    17IceMenuTree->__construct()JROOT/modules/mod_icemegamenu/helper.php:45
    16modIceMegamenuHelper::buildXML()JROOT/libraries/joomla/cache/controller/callback.php:152
    15JCacheControllerCallback->get()JROOT/libraries/joomla/cache/controller/callback.php:40
    14JCacheControllerCallback->call()JROOT/modules/mod_icemegamenu/helper.php:110
    13modIceMegamenuHelper->getXML()JROOT/modules/mod_icemegamenu/helper.php:148
    12modIceMegamenuHelper->render()JROOT/modules/mod_icemegamenu/tmpl/default.php:16
    11require JROOT/modules/mod_icemegamenu/tmpl/default.phpJROOT/modules/mod_icemegamenu/mod_icemegamenu.php:65
    10include JROOT/modules/mod_icemegamenu/mod_icemegamenu.phpJROOT/libraries/cms/module/helper.php:199
    9JModuleHelper::renderModule()JROOT/libraries/joomla/document/renderer/html/module.php:93
    8JDocumentRendererHtmlModule->render()JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7JDocumentRendererHtmlModules->render()JROOT/libraries/joomla/document/html.php:411
    6JDocumentHtml->getBuffer()JROOT/libraries/joomla/document/html.php:702
    5JDocumentHtml->_renderTemplate()JROOT/libraries/joomla/document/html.php:477
    4JDocumentHtml->render()JROOT/libraries/cms/application/cms.php:1086
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:773
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:267
    1JApplicationCms->execute()JROOT/index.php:49
    [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. 3 × 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 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,
      CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
      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,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
      CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
      FROM j0ojv_content AS a
      LEFT JOIN j0ojv_categories AS c
      ON c.id = a.catid
      LEFT JOIN j0ojv_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN j0ojv_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN j0ojv_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN j0ojv_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM j0ojv_categories AS cat JOIN j0ojv_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
  2. 2 × SELECT id,parent_id 
      FROM j0ojv_menu
  3. 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
      FROM `j0ojv_extensions`
  4. 2 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
      FROM j0ojv_categories as c
      LEFT JOIN (SELECT cat.id as id
      FROM j0ojv_categories AS cat JOIN j0ojv_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
  5. 2 × SELECT a.filename as filename, a.type as type, a.menulink as menulink 
      FROM j0ojv_phocagallery_styles AS a
  6. 1 × SELECT a.rules 
      FROM j0ojv_assets AS a
  7. 1 × SELECT cc.id, cc.alias as catalias, a.id, a.catid, a.title, a.alias, a.filename, a.description, a.extm, a.exts,a.extl, a.exto, a.extw, a.exth, a.extid, 
      CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug,
      CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug
      FROM j0ojv_phocagallery_categories AS cc
      LEFT JOIN j0ojv_phocagallery AS a
      ON a.catid = cc.id
  8. 1 × SELECT cc.id AS idcat, a.id AS idimage 
      FROM j0ojv_phocagallery_categories AS cc
      LEFT JOIN j0ojv_phocagallery AS a
      ON a.catid = cc.id
  9. 1 × SELECT cc.title AS text, cc.id AS id, cc.parent_id as parentid, cc.alias as alias, cc.access as access, cc.accessuserid as accessuserid 
      FROM j0ojv_phocagallery_categories AS cc
  10. 1 × SELECT a.name, a.rules 
      FROM j0ojv_assets AS a
  11. 1 × SELECT element 
      FROM j0ojv_extensions
  12. 1 × SELECT `data` 
      FROM `j0ojv_session`
  13. 1 × SELECT * 
      FROM j0ojv_assets
  14. 1 × SELECT `session_id` 
      FROM `j0ojv_session`
  15. 1 × SELECT cc.*, a.catid, COUNT(a.id) AS numlinks, u.username AS username, r.count AS ratingcount, r.average AS ratingaverage, uc.avatar AS avatar, uc.approved AS avatarapproved, uc.published AS avatarpublished, a.filename, a.exts, a.extm, a.extw, a.exth, 
      CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as slug
      FROM j0ojv_phocagallery_categories AS cc
      LEFT JOIN j0ojv_phocagallery AS a
      ON a.catid = cc.id
      and a.published = 1
      LEFT JOIN j0ojv_phocagallery_user AS uc
      ON uc.userid = cc.owner_id
      LEFT JOIN j0ojv_users AS u
      ON u.id = cc.owner_id
      LEFT JOIN j0ojv_phocagallery_votes_statistics AS r
      ON r.catid = cc.id
  16. 1 × SELECT id, home, template, s.params 
      FROM j0ojv_template_styles as s
      LEFT JOIN j0ojv_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
  17. 1 × SELECT * 
      FROM j0ojv_languages
  18. 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 j0ojv_menu AS m
      LEFT JOIN j0ojv_extensions AS e
      ON m.component_id = e.extension_id
  19. 1 × SELECT folder AS type, element AS name, params 
      FROM j0ojv_extensions
  20. 1 × SELECT id, rules 
      FROM `j0ojv_viewlevels
  21. 1 × SELECT b.id 
      FROM j0ojv_usergroups AS a
      LEFT JOIN j0ojv_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
  22. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
      FROM j0ojv_modules AS m
      LEFT JOIN j0ojv_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN j0ojv_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
OTHER Tables:
  1. 1 × INSERT INTO `j0ojv_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
      VALUES ('o7625o431tccuet9v4dbqdnp84', 0, 1, '1675464952', 0, ''
  2. 1 × UPDATE `j0ojv_extensions` 
      SET `params` = '{\"mediaversion\":\"7242d3363169eaefaa7adbcebaa17b96\"}'
  3. 1 × SHOW FULL COLUMNS 
      FROM `j0ojv_assets