Poltekkes Kemenkes Kupang Membuka Pendaftaran Penerimaan Mahasiswa Baru Jalur PMDP Tahun Akademik 2023/2024.

Pendaftaran	: 24 Januari 2023 - 7 Februari 2023
Pengumuman Tahap I	: 21 Februari 2023
Pemeriksaan Kesehatan	: 22 Februari - 23 Februari 2023
Pengumuman Kelulusan PMDP	: 27 Februari 2023

Pendaftaran dilakukan secara online, Para pendaftar diwajibkan mengunduh formulir pendaftaran,mendaftar online dan mengirimkan berkas pendaftaran kepada panitia sipenmaru di Direktorat.

Pendafataran ini KHUSUS bagi yg masih duduk di bangku kelas XII, bagi yang sudah tamat tahun – tahun sebelumnya TIDAK BOLEH MENDAFTAR.

Kualifikasi Pendidikan Pendaftar :

Program Studi	Kualifikasi Pendidikan
DIII Keperawatan dan Pendidikan Profesi Ners	SMA/MA Jurusan IPA, IPS dan Bahasa, SMK Kesehatan
DIII Kebidanan	SMA/MA Jurusan IPA, IPS dan Bahasa, SMK Kesehatan
DIII Kesehatan Gigi	SMA/MA Jurusan IPA, IPS dan Bahasa, SMK Kesehatan
DIII Farmasi	SMA/MA Jurusan IPA, SMK Farmasi
DIII Teknologi Laboratorium Medik	SMA/MA Jurusan IPA, SMK Analis Kesehatan,SMK Teknologi Laboratorium Medik
DIII Gizi	SMA/MA Jurusan IPA, IPS dan Bahasa,SMK Kesehatan, SMK Pertanian,SMK Tata Boga, SMK Pariwisata
DIII Sanitasi	SMA/MA Jurusan IPA, IPS dan Bahasa,SMK Kesehatan, SMK Teknik, SMK Kimia

Cara melakukan pendaftaran Dapat Dilihat Disini

LINK PENDAFTARAN http://pmdp.poltekeskupang.ac.id

Dokumen Pendukung Dan Surat Pernyataan Dapat Diunduh Disini

Contoh Amplop Pengiriman Berkas Dapat Dilihat Diunduh Disini

Contoh Pengisian Slip Pembayaran Bank Mandiri

Persyaratan Pendaftaran

1. PERSYARATAN PMDP

a. Persyaratan Umum

Berbadan sehat, tidak buta warna, tidak sedang hamil, kondisi fisik tidak mengganggu tugas sebagai tenaga kesehatan.

Tinggi badan*) dengan ketentuan sebagai berikut:

1) Prodi Keperawatan dan PPN : minimal 155 cm bagi laki-laki dan 150 cm bagi perempuan.

2) Prodi Kebidanan; hanya menerima peserta perempuan dengan tinggi badan minimal 150 cm

3) Prodi lainnya : minimal 150 cm bagi laki-laki dan 148 cm bagi perempuan.

b. Persyaratan Khusus

1) Warga Negara Indonesia

2) Siswa SMA/MA Kelas XII

3) Siswa SMK Kelas XII dengan Jurusan yang relevan dengan Program Studi yang dipilih (terlampir).

4) Nilai pengetahuan pada raport minimal 75 untuk setiap mata pelajaran semester 1 – 5 dan/atau memiliki prestasi akademik/non akademik minimal tingkat Kabupaten/Kota.

5) Akreditasi sekolah minimal C

6) Dinyatakan Lulus SMA/MA/SMK (Apabila tidak lulus SMA/MA/SMK maka dinyatakan GUGUR)

Kelengkapan Berkas yg dikirim ke direktorat :

Slip pembayaran uang pendaftaran dari Bank Mandiri (WAJIB SLIP BANK MANDIRI)
Pas foto berwarna,4 x 6, 1 lembar (Latar merah)
Raport yg dilegalisir (Semester I – V)
Surat permohonan pendaftaran (Format Poltekkes)
Surat pernyataan bersedia gugur (Format Poltekkes)
Surat Rekapitulasi prestasi. “KALAU ADA’’ (Format Poltekkes)
Form rekomendasi dari sekolah (Format Poltekkes)
Fotocopy Akreditasi sekolah
Bagi yang punya prestasi, Fotocopy sertifikat/piagam/penghargaan yg sudah dilegalisir oleh kepala sekolah

Alamat Pengiriman Berkas

Direktorat Poltekkes Kemenkes Kupang – Panitia Sipenmaru 2023

Jln. Piet A Tallo, Liliba, Kec. Oebobo, Kota Kupang - NTT

Untuk Mendapatkan Informasi PMDP Bisa Juga Bergabung Pada Group Telegram Jalur PMDP Poltekkes Kupang :

Link Group Telegram Jalur PMDP Poltekkes Kupang

CP : 0813 9390 4607

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1679655350,
                "last": 1679655350,
                "now": 1679655350
            }
        },
        "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
        },
        "com_mailto": {
            "links": {
                "9496eb99a7f2c2d8a5d98a1ec673959023c9ebb1": {
                    "link": "https:\/\/www.poltekkeskupang.ac.id\/informasi\/393-seleksi-penerimaan-mahasiswa-brau-jalur-pmdp-poltekkes-kupang-tahun-akademik-2023-2024.html",
                    "expiry": 1679655350
                }
            }
        }
    }
}

Profile Information

Time

Memory

Time: 6.75 ms / 6.75 ms Memory: 0.521 MB / 0.86 MB Application: afterLoad

Time: 38.33 ms / 45.08 ms Memory: 3.653 MB / 4.51 MB Application: afterInitialise

Time: 11.23 ms / 56.30 ms Memory: 1.309 MB / 5.82 MB Application: afterRoute

Time: 3.90 ms / 60.20 ms Memory: 0.204 MB / 6.02 MB Application: beforeRenderComponent com_content

Time: 6.32 ms / 66.52 ms Memory: 0.642 MB / 6.67 MB Application: Start JAccess::getAssetRules Old (1)

Time: 0.55 ms / 67.06 ms Memory: 0.036 MB / 6.70 MB Application: Finish JAccess::getAssetRules Old (1)

Time: 0.02 ms / 67.08 ms Memory: 0.000 MB / 6.70 MB Application: Start JAccess::preload(components)

Time: 1.09 ms / 68.18 ms Memory: 0.223 MB / 6.92 MB Application: Finish JAccess::preload(components)

Time: 26.97 ms / 95.14 ms Memory: 2.284 MB / 9.20 MB Application: afterRenderComponent com_content

Time: 0.92 ms / 96.06 ms Memory: 0.093 MB / 9.30 MB Application: afterDispatch

Time: 2.95 ms / 99.01 ms Memory: 0.205 MB / 9.50 MB Application: beforeRenderModule mod_articles_latest (Pengumuman)

Time: 6.65 ms / 105.66 ms Memory: 0.374 MB / 9.88 MB Application: afterRenderModule mod_articles_latest (Pengumuman)

Time: 0.07 ms / 105.73 ms Memory: 0.000 MB / 9.77 MB Application: beforeRenderModule mod_articles_popular (Artikel Terpopuler)

Time: 5.45 ms / 111.18 ms Memory: 0.258 MB / 10.02 MB Application: afterRenderModule mod_articles_popular (Artikel Terpopuler)

Time: 0.07 ms / 111.24 ms Memory: 0.000 MB / 9.86 MB Application: beforeRenderModule mod_articles_latest (Artikel Terbaru)

Time: 4.87 ms / 116.11 ms Memory: 0.223 MB / 10.09 MB Application: afterRenderModule mod_articles_latest (Artikel Terbaru)

Time: 0.08 ms / 116.20 ms Memory: 0.000 MB / 9.94 MB Application: beforeRenderModule mod_phocagallery_image (Gallery Terbaru)

Time: 9.80 ms / 125.99 ms Memory: 0.638 MB / 10.58 MB Application: afterRenderModule mod_phocagallery_image (Gallery Terbaru)

Time: 0.07 ms / 126.06 ms Memory: 0.000 MB / 10.51 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 0.69 ms / 126.75 ms Memory: 0.029 MB / 10.54 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 0.05 ms / 126.81 ms Memory: 0.000 MB / 10.53 MB Application: beforeRenderModule mod_custom (Banner samping)

Time: 0.54 ms / 127.35 ms Memory: 0.009 MB / 10.54 MB Application: afterRenderModule mod_custom (Banner samping)

Time: 0.07 ms / 127.42 ms Memory: 0.004 MB / 10.55 MB Application: beforeRenderModule mod_icemegamenu (Mega Menu)

Time: 38.93 ms / 166.35 ms Memory: 1.159 MB / 11.71 MB Application: afterRenderModule mod_icemegamenu (Mega Menu)

Time: 0.07 ms / 166.42 ms Memory: 0.021 MB / 11.73 MB Application: beforeRenderModule mod_nice_social_bookmark (Nice Social Bookmark)

Time: 7.87 ms / 174.30 ms Memory: 0.028 MB / 11.76 MB Application: afterRenderModule mod_nice_social_bookmark (Nice Social Bookmark)

Time: 2.09 ms / 176.39 ms Memory: 0.134 MB / 11.89 MB Application: afterRender

Database queries total: 30.08 ms

Memory Usage

Database Queries

51 Queries Logged 30.08 ms

Query Time: 0.97 ms Query memory: 0.026 MB Memory before query: 2.339 MB Rows returned: 0

SELECT `data`

  FROM `j0ojv_session`

  WHERE `session_id` = 'soj8pj4qn4vgtgjf4dvf673865'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j0ojv_session	const	PRIMARY	PRIMARY	766	const	1

Profile

Status	Duration
Starting	0.14 ms
Waiting for query cache lock	0.02 ms
Init	0.02 ms
Checking query cache for query	0.03 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Waiting for query cache lock	0.03 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.24 ms
Preparing	0.02 ms
Executing	0.02 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.05 ms
Updating status	0.02 ms
Waiting for query cache lock	0.02 ms
Updating status	0.03 ms
Waiting for query cache lock	0.02 ms
Updating status	0.02 ms
Storing result in query cache	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
12	JSessionStorageDatabase->read()	Same as call in the line below.
11	session_start()	JROOT/libraries/joomla/session/handler/native.php:259
10	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:49
9	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:81
8	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:636
7	JSession->_start()	JROOT/libraries/joomla/session/session.php:596
6	JSession->start()	JROOT/libraries/cms/application/cms.php:773
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.66 ms After last query: 1.51 ms Query memory: 0.023 MB Memory before query: 2.475 MB Rows returned: 0

SELECT `session_id`

  FROM `j0ojv_session`

  WHERE `session_id` = 'soj8pj4qn4vgtgjf4dvf673865' 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j0ojv_session	const	PRIMARY	PRIMARY	766	const	1	Using index

Profile

Status	Duration
Starting	0.07 ms
Waiting for query cache lock	0.02 ms
Init	0.02 ms
Checking query cache for query	0.04 ms
Checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Waiting for query cache lock	0.02 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.02 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.02 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.05 ms
Updating status	0.02 ms
Waiting for query cache lock	0.02 ms
Updating status	0.02 ms
Waiting for query cache lock	0.02 ms
Updating status	0.02 ms
Storing result in query cache	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.52 ms After last query: 0.08 ms Query memory: 0.005 MB Memory before query: 2.481 MB

INSERT INTO `j0ojv_session`
(`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES 
('soj8pj4qn4vgtgjf4dvf673865', 0, 1, '1679655350', 0, '')

Explain

EXPLAIN not possible on query: INSERT INTO `j0ojv_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('soj8pj4qn4vgtgjf4dvf673865', 0, 1, '1679655350', 0, '')

Profile

Status	Duration
Starting	0.07 ms
Checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Init for update	0.02 ms
Update	0.07 ms
Waiting for query cache lock	0.02 ms
Update	0.02 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.04 ms
Closing tables	0.02 ms
Unlocking tables	0.02 ms
Closing tables	0.02 ms
Starting cleanup	0.03 ms
Freeing items	0.05 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:212
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.86 ms After last query: 1.76 ms Query memory: 0.048 MB Memory before query: 2.647 MB Rows returned: 37

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `j0ojv_extensions`

  WHERE `type` = 'component'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j0ojv_extensions	ref	extension	extension	82	const	37	Using index condition

Profile

Status	Duration
Starting	0.07 ms
Waiting for query cache lock	0.02 ms
Init	0.02 ms
Checking query cache for query	0.04 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Waiting for query cache lock	0.02 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.03 ms
Executing	0.02 ms
Sending data	0.12 ms
Waiting for query cache lock	0.02 ms
Sending data	0.07 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.02 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.05 ms
Updating status	0.02 ms
Waiting for query cache lock	0.02 ms
Updating status	0.02 ms
Waiting for query cache lock	0.02 ms
Updating status	0.02 ms
Storing result in query cache	0.03 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
8	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:152
7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:448
6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:120
4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:589
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.23 ms After last query: 1.21 ms Query memory: 0.024 MB Memory before query: 2.797 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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
Starting	0.07 ms
Waiting for query cache lock	0.02 ms
Init	0.02 ms
Checking query cache for query	0.02 ms
Checking privileges on cached	0.02 ms
Checking permissions	0.02 ms
Sending cached result to clien	0.05 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:835
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:904
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.23 ms After last query: 0.48 ms Query memory: 0.025 MB Memory before query: 2.845 MB Rows returned: 5

SELECT id, rules

  FROM `j0ojv_viewlevels`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j0ojv_viewlevels	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	5

Profile

Status	Duration
Starting	0.07 ms
Waiting for query cache lock	0.02 ms
Init	0.02 ms
Checking query cache for query	0.02 ms
Checking privileges on cached	0.02 ms
Checking permissions	0.02 ms
Sending cached result to clien	0.05 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:921
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.04 ms After last query: 0.07 ms Query memory: 0.029 MB Memory before query: 2.856 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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j0ojv_extensions	ref	extension	extension	82	const	70	Using index condition; Using where; Using filesort

Profile

Status	Duration
Starting	0.05 ms
Waiting for query cache lock	0.02 ms
Init	0.02 ms
Checking query cache for query	0.05 ms
Checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Waiting for query cache lock	0.02 ms
Init	0.03 ms
Optimizing	0.03 ms
Statistics	0.04 ms
Preparing	0.03 ms
Sorting result	0.02 ms
Executing	0.02 ms
Sending data	0.02 ms
Creating sort index	0.32 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.02 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Waiting for query cache lock	0.02 ms
Updating status	0.02 ms
Waiting for query cache lock	0.02 ms
Updating status	0.02 ms
Storing result in query cache	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
7	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:310
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.63 ms After last query: 15.44 ms Query memory: 0.116 MB Memory before query: 4.651 MB Rows returned: 67

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	122	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	poltekke_beginning2.m.component_id	1	Using where

Profile

Status	Duration
Starting	0.07 ms
Waiting for query cache lock	0.02 ms
Init	0.02 ms
Checking query cache for query	0.06 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Waiting for query cache lock	0.03 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.03 ms
Sorting result	0.02 ms
Executing	0.02 ms
Sending data	0.03 ms
Creating sort index	0.44 ms
Waiting for query cache lock	0.02 ms
Creating sort index	0.14 ms
Waiting for query cache lock	0.02 ms
Creating sort index	0.07 ms
Waiting for query cache lock	0.02 ms
Creating sort index	0.07 ms
Waiting for query cache lock	0.02 ms
Creating sort index	0.06 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.02 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Waiting for query cache lock	0.02 ms
Updating status	0.02 ms
Waiting for query cache lock	0.02 ms
Updating status	0.02 ms
Storing result in query cache	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
14	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
13	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
12	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:197
7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:535
6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1115
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.16 ms After last query: 6.17 ms Query memory: 0.037 MB Memory before query: 5.821 MB Rows returned: 0

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=393

  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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
2	LATERAL DERIVED	cat	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
2	LATERAL DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	2	Using index condition; Using where; Using join buffer (flat, BNL join)

Profile

Status	Duration
Starting	0.07 ms
Waiting for query cache lock	0.02 ms
Init	0.02 ms
Checking query cache for query	0.15 ms
Checking permissions	0.02 ms
Opening tables	0.05 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Waiting for query cache lock	0.03 ms
Init	0.10 ms
Optimizing	0.04 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Statistics	0.08 ms
Preparing	0.05 ms
Preparing	0.02 ms
Executing	0.04 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.02 ms
Removing tmp table	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.02 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Waiting for query cache lock	0.02 ms
Updating status	0.03 ms
Waiting for query cache lock	0.02 ms
Updating status	0.02 ms
Storing result in query cache	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
11	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
10	JCategories->get()	JROOT/components/com_content/router.php:341
9	ContentRouter->parse()	JROOT/libraries/cms/router/site.php:408
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.65 ms After last query: 0.07 ms Query memory: 0.025 MB Memory before query: 5.827 MB Rows returned: 1

SELECT `alias`,`catid`

  FROM `j0ojv_content`

  WHERE `id` = 393

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j0ojv_content	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.05 ms
Waiting for query cache lock	0.02 ms
Init	0.02 ms
Checking query cache for query	0.03 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Waiting for query cache lock	0.02 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Unlocking tables	0.02 ms
Preparing	0.02 ms
Executing	0.02 ms
Sending data	0.02 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Waiting for query cache lock	0.02 ms
Updating status	0.02 ms
Waiting for query cache lock	0.02 ms
Updating status	0.02 ms
Storing result in query cache	0.04 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
10	JDatabaseDriver->loadObject()	JROOT/components/com_content/router.php:357
9	ContentRouter->parse()	JROOT/libraries/cms/router/site.php:408
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.73 ms After last query: 0.37 ms Query memory: 0.026 MB Memory before query: 5.854 MB Rows returned: 1

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `j0ojv_extensions`

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j0ojv_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using index condition

Profile

Status	Duration
Starting	0.07 ms
Waiting for query cache lock	0.02 ms
Init	0.02 ms
Checking query cache for query	0.04 ms
Checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Waiting for query cache lock	0.02 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.03 ms
Executing	0.02 ms
Sending data	0.05 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.02 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.05 ms
Updating status	0.02 ms
Waiting for query cache lock	0.02 ms
Updating status	0.03 ms
Waiting for query cache lock	0.02 ms
Updating status	0.02 ms
Storing result in query cache	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
12	JDatabaseDriver->loadObject()	JROOT/libraries/joomla/cache/controller/callback.php:152
11	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
10	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
9	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
8	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:977
4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.49 ms After last query: 0.12 ms Query memory: 0.007 MB Memory before query: 5.847 MB

UPDATE `j0ojv_extensions`

  SET `params` = '{\"mediaversion\":\"3ab77276e2cdac3b4d5651e70db28a4d\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain

EXPLAIN not possible on query: UPDATE `j0ojv_extensions` SET `params` = '{\"mediaversion\":\"3ab77276e2cdac3b4d5651e70db28a4d\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profile

Status	Duration
Starting	0.07 ms
Checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Init for update	0.06 ms
Updating	0.05 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.02 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.05 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
9	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
8	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:977
4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.20 ms After last query: 1.43 ms Query memory: 0.026 MB Memory before query: 6.004 MB Rows returned: 1

SELECT *

  FROM j0ojv_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j0ojv_languages	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using filesort

Profile

Status	Duration
Starting	0.07 ms
Waiting for query cache lock	0.02 ms
Init	0.02 ms
Checking query cache for query	0.02 ms
Checking privileges on cached	0.02 ms
Checking permissions	0.02 ms
Sending cached result to clien	0.05 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:164
5	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:329
4	JApplicationSite->getParams()	JROOT/libraries/cms/application/site.php:135
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.17 ms After last query: 0.19 ms Query memory: 0.023 MB Memory before query: 6.015 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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	6	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	poltekke_beginning2.s.template,const	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.04 ms
Waiting for query cache lock	0.02 ms
Init	0.02 ms
Checking query cache for query	0.02 ms
Checking privileges on cached	0.02 ms
Checking permissions	0.02 ms
Sending cached result to clien	0.04 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
4	JApplicationSite->getTemplate()	JROOT/libraries/cms/application/site.php:165
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.10 ms After last query: 4.80 ms Query memory: 0.035 MB Memory before query: 6.613 MB Rows returned: 8

SHOW FULL COLUMNS 
  FROM `j0ojv_assets`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `j0ojv_assets`

Profile

Status	Duration
Starting	0.09 ms
Checking permissions	0.02 ms
Closing tables	0.02 ms
Opening tables	0.24 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.02 ms
Filling schema table	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
Checking permissions	0.07 ms
Closing tables	0.02 ms
Executing	0.02 ms
Sending data	0.04 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.02 ms
Removing tmp table	0.10 ms
Closing tables	0.02 ms
Unlocking tables	0.02 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.05 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
18	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
17	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:60
16	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:308
15	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:696
14	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
13	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:435
10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:262
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.19 ms After last query: 0.43 ms Query memory: 0.031 MB Memory before query: 6.657 MB Rows returned: 1

SELECT *

  FROM j0ojv_assets

  WHERE `id` = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j0ojv_assets	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.06 ms
Waiting for query cache lock	0.02 ms
Init	0.02 ms
Checking query cache for query	0.02 ms
Checking privileges on cached	0.02 ms
Checking permissions	0.02 ms
Sending cached result to clien	0.04 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
16	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
15	JTable->load()	JROOT/libraries/joomla/access/access.php:697
14	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
13	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:435
10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:262
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.17 ms After last query: 0.09 ms Query memory: 0.028 MB Memory before query: 6.668 MB Rows returned: 1

SELECT a.rules

  FROM j0ojv_assets AS a

  WHERE (a.id = 1 OR a.name = 'root.1')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,202	NULL	2	Using union(PRIMARY,idx_asset_name); Using where

Profile

Status	Duration
Starting	0.05 ms
Waiting for query cache lock	0.02 ms
Init	0.02 ms
Checking query cache for query	0.02 ms
Checking privileges on cached	0.02 ms
Checking permissions	0.02 ms
Sending cached result to clien	0.04 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
14	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
13	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:435
10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:262
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.20 ms After last query: 0.40 ms Query memory: 0.031 MB Memory before query: 6.697 MB Rows returned: 37

SELECT element

  FROM j0ojv_extensions

  WHERE type = 'component' 
  AND enabled = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j0ojv_extensions	ref	extension	extension	82	const	37	Using index condition; Using where

Profile

Status	Duration
Starting	0.05 ms
Waiting for query cache lock	0.02 ms
Init	0.02 ms
Checking query cache for query	0.02 ms
Checking privileges on cached	0.02 ms
Checking permissions	0.02 ms
Sending cached result to clien	0.04 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
16	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:413
15	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
14	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
13	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:435
10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:262
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.17 ms After last query: 0.09 ms Query memory: 0.032 MB Memory before query: 6.714 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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	range	idx_asset_name	idx_asset_name	202	NULL	38	Using index condition; Using where

Profile

Status	Duration
Starting	0.04 ms
Waiting for query cache lock	0.02 ms
Init	0.02 ms
Checking query cache for query	0.02 ms
Checking privileges on cached	0.02 ms
Checking permissions	0.02 ms
Sending cached result to clien	0.04 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
16	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:441
15	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
14	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
13	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:435
10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:262
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.09 ms After last query: 0.97 ms Query memory: 0.039 MB Memory before query: 6.948 MB Rows returned: 30

SHOW FULL COLUMNS 
  FROM `j0ojv_content`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `j0ojv_content`

Profile

Status	Duration
Starting	0.08 ms
Checking permissions	0.02 ms
Closing tables	0.02 ms
Opening tables	0.19 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.02 ms
Filling schema table	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
Checking permissions	0.11 ms
Closing tables	0.02 ms
Executing	0.02 ms
Sending data	0.06 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.02 ms
Removing tmp table	0.09 ms
Closing tables	0.02 ms
Unlocking tables	0.02 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.05 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
13	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
12	JTable->__construct()	JROOT/libraries/legacy/table/content.php:31
11	JTableContent->__construct()	JROOT/libraries/joomla/table/table.php:308
10	JTable::getInstance()	JROOT/components/com_content/models/article.php:264
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.75 ms After last query: 1.81 ms Query memory: 0.037 MB Memory before query: 7.173 MB Rows returned: 1

SELECT *

  FROM j0ojv_content

  WHERE `id` = '393'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j0ojv_content	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.07 ms
Waiting for query cache lock	0.02 ms
Init	0.02 ms
Checking query cache for query	0.03 ms
Checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Waiting for query cache lock	0.02 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Unlocking tables	0.02 ms
Preparing	0.02 ms
Executing	0.02 ms
Sending data	0.04 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.02 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.05 ms
Updating status	0.02 ms
Waiting for query cache lock	0.02 ms
Updating status	0.03 ms
Waiting for query cache lock	0.02 ms
Updating status	0.02 ms
Storing result in query cache	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
10	JTable->load()	JROOT/components/com_content/models/article.php:265
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.73 ms After last query: 0.09 ms Query memory: 0.007 MB Memory before query: 7.189 MB

UPDATE j0ojv_content

  SET `hits` = (`hits` + 1)

  WHERE `id` = '393'

Explain

EXPLAIN not possible on query: UPDATE j0ojv_content SET `hits` = (`hits` + 1) WHERE `id` = '393'

Profile

Status	Duration
Starting	0.07 ms
Checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Init for update	0.04 ms
Updating	0.05 ms
End of update loop	0.02 ms
Waiting for query cache lock	0.02 ms
End of update loop	0.21 ms
Query end	0.02 ms
Commit	0.04 ms
Closing tables	0.02 ms
Unlocking tables	0.02 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.05 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/table/table.php:1228
10	JTable->hit()	JROOT/components/com_content/models/article.php:266
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.47 ms After last query: 1.08 ms Query memory: 0.039 MB Memory before query: 7.298 MB Rows returned: 1

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, 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, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,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

  FROM j0ojv_content AS a

  LEFT JOIN j0ojv_categories AS c 
  on c.id = a.catid

  LEFT JOIN j0ojv_users AS u 
  on u.id = a.created_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 <= 0 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  WHERE a.id = 393 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-03-24 10:55:50') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-03-24 10:55:50') 
  AND (a.state = 1 OR a.state =2)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	const	PRIMARY,idx_state	PRIMARY	4	const	1
1	PRIMARY	c	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	u	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	parent	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	v	const	PRIMARY	PRIMARY	4	const	0	Unique row not found
1	PRIMARY	<derived2>	ref	key0	key0	5	const	2
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	1	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	index	PRIMARY,idx_left_right	idx_left_right	8	NULL	26	Using where; Using index; Using join buffer (flat, BNL join)

Profile

Status	Duration
Starting	0.07 ms
Waiting for query cache lock	0.02 ms
Init	0.02 ms
Checking query cache for query	0.14 ms
Checking permissions	0.02 ms
Opening tables	0.05 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Waiting for query cache lock	0.04 ms
Init	0.08 ms
Optimizing	0.04 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Statistics	0.11 ms
Preparing	0.04 ms
Creating tmp table	0.03 ms
Sorting result	0.03 ms
Preparing	0.02 ms
Unlocking tables	0.02 ms
Preparing	0.03 ms
Executing	0.02 ms
Sending data	0.04 ms
Executing	0.02 ms
Sending data	0.03 ms
Creating sort index	0.03 ms
Removing tmp table	0.03 ms
Creating sort index	0.04 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.02 ms
Removing tmp table	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.02 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Waiting for query cache lock	0.02 ms
Updating status	0.08 ms
Waiting for query cache lock	0.02 ms
Updating status	0.02 ms
Storing result in query cache	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
13	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:159
12	ContentModelArticle->getItem()	JROOT/libraries/legacy/view/legacy.php:408
11	JViewLegacy->get()	JROOT/components/com_content/views/article/view.html.php:42
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.23 ms After last query: 1.23 ms Query memory: 0.039 MB Memory before query: 7.486 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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Using filesort
1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	26	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	poltekke_beginning2.c.id	5	Using where
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	2	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	index	PRIMARY,idx_left_right	idx_left_right	8	NULL	26	Using where; Using index; Using join buffer (flat, BNL join)

Profile

Status	Duration
Starting	0.07 ms
Waiting for query cache lock	0.02 ms
Init	0.02 ms
Checking query cache for query	0.02 ms
Checking privileges on cached	0.02 ms
Checking permissions	0.02 ms
Sending cached result to clien	0.05 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
13	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
12	JCategories->get()	JROOT/components/com_content/helpers/route.php:44
11	ContentHelperRoute::getArticleRoute()	JROOT/components/com_content/views/article/view.html.php:71
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.80 ms After last query: 0.39 ms Query memory: 0.037 MB Memory before query: 7.519 MB Rows returned: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `j0ojv_contentitem_tag_map` AS m 

  INNER JOIN `j0ojv_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 393 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	poltekke_beginning2.m.tag_id	1	Using where

Profile

Status	Duration
Starting	0.07 ms
Waiting for query cache lock	0.02 ms
Init	0.02 ms
Checking query cache for query	0.05 ms
Checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Waiting for query cache lock	0.03 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.03 ms
Executing	0.02 ms
Sending data	0.05 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.02 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Waiting for query cache lock	0.02 ms
Updating status	0.02 ms
Waiting for query cache lock	0.02 ms
Updating status	0.02 ms
Storing result in query cache	0.04 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
11	JHelperTags->getItemTags()	JROOT/components/com_content/views/article/view.html.php:156
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.70 ms After last query: 11.44 ms Query memory: 0.032 MB Memory before query: 8.831 MB Rows returned: 1

SELECT alias

  FROM j0ojv_content

  WHERE id=393

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j0ojv_content	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.07 ms
Waiting for query cache lock	0.02 ms
Init	0.02 ms
Checking query cache for query	0.03 ms
Checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Waiting for query cache lock	0.02 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Unlocking tables	0.02 ms
Preparing	0.02 ms
Executing	0.02 ms
Sending data	0.02 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.02 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.05 ms
Updating status	0.02 ms
Waiting for query cache lock	0.02 ms
Updating status	0.02 ms
Waiting for query cache lock	0.02 ms
Updating status	0.02 ms
Storing result in query cache	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
21	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:118
20	ContentRouter->build()	JROOT/libraries/cms/router/site.php:496
19	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
18	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
17	JRouter->build()	JROOT/libraries/cms/router/site.php:147
16	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
15	JRoute::_()	JROOT/plugins/content/bt_socialshare/bt_socialshare.php:91
14	plgContentBt_socialshare->buildHTML()	JROOT/plugins/content/bt_socialshare/bt_socialshare.php:277
13	plgContentBt_socialshare->onContentAfterTitle()	JROOT/libraries/joomla/event/event.php:69
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:164
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.18 ms After last query: 6.67 ms Query memory: 0.030 MB Memory before query: 9.489 MB Rows returned: 12

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-03-24 10:55:50') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-03-24 10:55:50') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 217 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	24	Using index condition; Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	poltekke_beginning2.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	poltekke_beginning2.m.module,const	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.08 ms
Waiting for query cache lock	0.02 ms
Init	0.02 ms
Checking query cache for query	0.07 ms
Checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Waiting for query cache lock	0.03 ms
Init	0.05 ms
Optimizing	0.04 ms
Statistics	0.06 ms
Preparing	0.05 ms
Sorting result	0.02 ms
Executing	0.02 ms
Sending data	0.02 ms
Creating sort index	0.30 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.02 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Waiting for query cache lock	0.02 ms
Updating status	0.03 ms
Waiting for query cache lock	0.02 ms
Updating status	0.02 ms
Storing result in query cache	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:152
12	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:425
11	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:361
10	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
9	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:501
8	JDocumentHtml->countModules()	JROOT/templates/sw-poltekkes/index.php:51
7	require JROOT/templates/sw-poltekkes/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.71 ms After last query: 2.51 ms Query memory: 0.043 MB Memory before query: 9.693 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-03-24 10:55:50') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-03-24 10:55:50')

  ORDER BY a.created DESC 
  LIMIT 5

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	c	const	PRIMARY,idx_access	PRIMARY	4	const	1
1	PRIMARY	a	ref	idx_access,idx_catid	idx_catid	4	const	16	Using where; Using filesort
1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	poltekke_beginning2.a.created_by	1	Using where
1	PRIMARY	uam	eq_ref	PRIMARY	PRIMARY	4	poltekke_beginning2.a.modified_by	1	Using where
1	PRIMARY	parent	eq_ref	PRIMARY	PRIMARY	4	const	1	Using where
1	PRIMARY	v	eq_ref	PRIMARY	PRIMARY	4	poltekke_beginning2.a.id	1	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	const	5	Using where
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	2	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	index	PRIMARY,idx_left_right	idx_left_right	8	NULL	26	Using where; Using index; Using join buffer (flat, BNL join)

Profile

Status	Duration
Starting	0.07 ms
Waiting for query cache lock	0.02 ms
Init	0.02 ms
Checking query cache for query	0.17 ms
Checking permissions	0.02 ms
Opening tables	0.05 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Waiting for query cache lock	0.04 ms
Init	0.09 ms
Optimizing	0.05 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Statistics	0.10 ms
Preparing	0.03 ms
Creating tmp table	0.03 ms
Sorting result	0.03 ms
Preparing	0.02 ms
Unlocking tables	0.02 ms
Preparing	0.04 ms
Sorting result	0.02 ms
Executing	0.02 ms
Sending data	0.04 ms
Creating sort index	0.14 ms
Executing	0.02 ms
Sending data	0.03 ms
Creating sort index	0.03 ms
Removing tmp table	0.02 ms
Creating sort index	0.12 ms
End of update loop	0.03 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.02 ms
Removing tmp table	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.02 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Waiting for query cache lock	0.02 ms
Updating status	0.03 ms
Waiting for query cache lock	0.02 ms
Updating status	0.02 ms
Storing result in query cache	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:310
14	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:183
13	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_latest/helper.php:113
11	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
10	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/libraries/cms/module/helper.php:199
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.19 ms After last query: 0.18 ms Query memory: 0.038 MB Memory before query: 9.773 MB Rows returned: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `j0ojv_contentitem_tag_map` AS m 

  INNER JOIN `j0ojv_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 101 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	poltekke_beginning2.m.tag_id	1	Using where

Profile

Status	Duration
Starting	0.05 ms
Waiting for query cache lock	0.02 ms
Init	0.02 ms
Checking query cache for query	0.02 ms
Checking privileges on cached	0.02 ms
Checking permissions	0.02 ms
Sending cached result to clien	0.04 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
13	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_latest/helper.php:113
11	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
10	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/libraries/cms/module/helper.php:199
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.19 ms After last query: 0.14 ms Query memory: 0.038 MB Memory before query: 9.797 MB Rows returned: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `j0ojv_contentitem_tag_map` AS m 

  INNER JOIN `j0ojv_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 81 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	poltekke_beginning2.m.tag_id	1	Using where

Profile

Status	Duration
Starting	0.04 ms
Waiting for query cache lock	0.02 ms
Init	0.02 ms
Checking query cache for query	0.02 ms
Checking privileges on cached	0.02 ms
Checking permissions	0.02 ms
Sending cached result to clien	0.05 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
13	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_latest/helper.php:113
11	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
10	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/libraries/cms/module/helper.php:199
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.19 ms After last query: 0.13 ms Query memory: 0.038 MB Memory before query: 9.821 MB Rows returned: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `j0ojv_contentitem_tag_map` AS m 

  INNER JOIN `j0ojv_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 66 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	poltekke_beginning2.m.tag_id	1	Using where

Profile

Status	Duration
Starting	0.05 ms
Waiting for query cache lock	0.02 ms
Init	0.02 ms
Checking query cache for query	0.02 ms
Checking privileges on cached	0.02 ms
Checking permissions	0.02 ms
Sending cached result to clien	0.04 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
13	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_latest/helper.php:113
11	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
10	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/libraries/cms/module/helper.php:199
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.08 ms After last query: 0.12 ms Query memory: 0.038 MB Memory before query: 9.846 MB Rows returned: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `j0ojv_contentitem_tag_map` AS m 

  INNER JOIN `j0ojv_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 53 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	poltekke_beginning2.m.tag_id	1	Using where

Profile

Status	Duration
Starting	0.04 ms
Waiting for query cache lock	0.89 ms
Init	0.02 ms
Checking query cache for query	0.02 ms
Checking privileges on cached	0.02 ms
Checking permissions	0.02 ms
Sending cached result to clien	0.06 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
13	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_latest/helper.php:113
11	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
10	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/libraries/cms/module/helper.php:199
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.19 ms After last query: 0.11 ms Query memory: 0.040 MB Memory before query: 9.864 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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Using filesort
1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	26	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	poltekke_beginning2.c.id	5	Using where
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	2	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	index	PRIMARY,idx_left_right	idx_left_right	8	NULL	26	Using where; Using index; Using join buffer (flat, BNL join)

Profile

Status	Duration
Starting	0.05 ms
Waiting for query cache lock	0.02 ms
Init	0.02 ms
Checking query cache for query	0.03 ms
Checking privileges on cached	0.02 ms
Checking permissions	0.02 ms
Sending cached result to clien	0.04 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
14	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
13	JCategories->get()	JROOT/components/com_content/helpers/route.php:44
12	ContentHelperRoute::getArticleRoute()	JROOT/modules/mod_articles_latest/helper.php:123
11	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
10	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/libraries/cms/module/helper.php:199
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.80 ms After last query: 1.32 ms Query memory: 0.079 MB Memory before query: 9.813 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-03-24 10:55:50') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-03-24 10:55:50')

  ORDER BY a.hits DESC 
  LIMIT 5

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	range	idx_access,idx_catid	idx_catid	4	NULL	268	Using index condition; Using where; Using filesort
1	PRIMARY	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	poltekke_beginning2.a.catid	1	Using where
1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	poltekke_beginning2.a.created_by	1	Using where
1	PRIMARY	uam	eq_ref	PRIMARY	PRIMARY	4	poltekke_beginning2.a.modified_by	1	Using where
1	PRIMARY	parent	eq_ref	PRIMARY	PRIMARY	4	poltekke_beginning2.c.parent_id	1	Using where
1	PRIMARY	v	eq_ref	PRIMARY	PRIMARY	4	poltekke_beginning2.a.id	1	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	poltekke_beginning2.c.id	5	Using where
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	2	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	index	PRIMARY,idx_left_right	idx_left_right	8	NULL	26	Using where; Using index; Using join buffer (flat, BNL join)

Profile

Status	Duration
Starting	0.07 ms
Waiting for query cache lock	0.02 ms
Init	0.02 ms
Checking query cache for query	0.16 ms
Checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Waiting for query cache lock	0.04 ms
Init	0.09 ms
Optimizing	0.05 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Statistics	0.09 ms
Preparing	0.03 ms
Creating tmp table	0.02 ms
Sorting result	0.03 ms
Preparing	0.07 ms
Sorting result	0.02 ms
Executing	0.02 ms
Sending data	0.04 ms
Creating sort index	1.25 ms
Executing	0.02 ms
Sending data	0.03 ms
Creating sort index	0.02 ms
Removing tmp table	0.02 ms
Creating sort index	0.05 ms
Waiting for query cache lock	0.02 ms
Creating sort index	0.07 ms
Waiting for query cache lock	0.02 ms
Creating sort index	0.03 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.02 ms
Removing tmp table	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Waiting for query cache lock	0.01 ms
Updating status	0.02 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.04 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:310
14	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:183
13	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_popular/helper.php:73
11	ModArticlesPopularHelper::getList()	JROOT/modules/mod_articles_popular/mod_articles_popular.php:15
10	include JROOT/modules/mod_articles_popular/mod_articles_popular.php	JROOT/libraries/cms/module/helper.php:199
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.18 ms After last query: 0.21 ms Query memory: 0.038 MB Memory before query: 9.940 MB Rows returned: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `j0ojv_contentitem_tag_map` AS m 

  INNER JOIN `j0ojv_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 277 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	poltekke_beginning2.m.tag_id	1	Using where

Profile

Status	Duration
Starting	0.05 ms
Waiting for query cache lock	0.02 ms
Init	0.01 ms
Checking query cache for query	0.02 ms
Checking privileges on cached	0.02 ms
Checking permissions	0.02 ms
Sending cached result to clien	0.04 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
13	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_popular/helper.php:73
11	ModArticlesPopularHelper::getList()	JROOT/modules/mod_articles_popular/mod_articles_popular.php:15
10	include JROOT/modules/mod_articles_popular/mod_articles_popular.php	JROOT/libraries/cms/module/helper.php:199
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.17 ms After last query: 0.15 ms Query memory: 0.038 MB Memory before query: 9.965 MB Rows returned: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `j0ojv_contentitem_tag_map` AS m 

  INNER JOIN `j0ojv_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 356 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	poltekke_beginning2.m.tag_id	1	Using where

Profile

Status	Duration
Starting	0.04 ms
Waiting for query cache lock	0.02 ms
Init	0.01 ms
Checking query cache for query	0.02 ms
Checking privileges on cached	0.02 ms
Checking permissions	0.02 ms
Sending cached result to clien	0.04 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
13	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_popular/helper.php:73
11	ModArticlesPopularHelper::getList()	JROOT/modules/mod_articles_popular/mod_articles_popular.php:15
10	include JROOT/modules/mod_articles_popular/mod_articles_popular.php	JROOT/libraries/cms/module/helper.php:199
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.17 ms After last query: 0.13 ms Query memory: 0.038 MB Memory before query: 9.989 MB Rows returned: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `j0ojv_contentitem_tag_map` AS m 

  INNER JOIN `j0ojv_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 345 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	poltekke_beginning2.m.tag_id	1	Using where

Profile

Status	Duration
Starting	0.04 ms
Waiting for query cache lock	0.02 ms
Init	0.02 ms
Checking query cache for query	0.02 ms
Checking privileges on cached	0.02 ms
Checking permissions	0.02 ms
Sending cached result to clien	0.04 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
13	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_popular/helper.php:73
11	ModArticlesPopularHelper::getList()	JROOT/modules/mod_articles_popular/mod_articles_popular.php:15
10	include JROOT/modules/mod_articles_popular/mod_articles_popular.php	JROOT/libraries/cms/module/helper.php:199
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.17 ms After last query: 0.13 ms Query memory: 0.038 MB Memory before query: 10.014 MB Rows returned: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `j0ojv_contentitem_tag_map` AS m 

  INNER JOIN `j0ojv_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 347 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	poltekke_beginning2.m.tag_id	1	Using where

Profile

Status	Duration
Starting	0.04 ms
Waiting for query cache lock	0.02 ms
Init	0.02 ms
Checking query cache for query	0.02 ms
Checking privileges on cached	0.02 ms
Checking permissions	0.02 ms
Sending cached result to clien	0.04 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
13	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_popular/helper.php:73
11	ModArticlesPopularHelper::getList()	JROOT/modules/mod_articles_popular/mod_articles_popular.php:15
10	include JROOT/modules/mod_articles_popular/mod_articles_popular.php	JROOT/libraries/cms/module/helper.php:199
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.17 ms After last query: 0.13 ms Query memory: 0.038 MB Memory before query: 10.038 MB Rows returned: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `j0ojv_contentitem_tag_map` AS m 

  INNER JOIN `j0ojv_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 304 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	poltekke_beginning2.m.tag_id	1	Using where

Profile

Status	Duration
Starting	0.04 ms
Waiting for query cache lock	0.02 ms
Init	0.01 ms
Checking query cache for query	0.02 ms
Checking privileges on cached	0.02 ms
Checking permissions	0.02 ms
Sending cached result to clien	0.04 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
13	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_popular/helper.php:73
11	ModArticlesPopularHelper::getList()	JROOT/modules/mod_articles_popular/mod_articles_popular.php:15
10	include JROOT/modules/mod_articles_popular/mod_articles_popular.php	JROOT/libraries/cms/module/helper.php:199
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.51 ms After last query: 0.79 ms Query memory: 0.056 MB Memory before query: 9.893 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-03-24 10:55:50') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-03-24 10:55:50')

  ORDER BY a.created DESC 
  LIMIT 5

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	range	idx_access,idx_catid	idx_catid	4	NULL	268	Using index condition; Using where; Using filesort
1	PRIMARY	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	poltekke_beginning2.a.catid	1	Using where
1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	poltekke_beginning2.a.created_by	1	Using where
1	PRIMARY	uam	eq_ref	PRIMARY	PRIMARY	4	poltekke_beginning2.a.modified_by	1	Using where
1	PRIMARY	parent	eq_ref	PRIMARY	PRIMARY	4	poltekke_beginning2.c.parent_id	1	Using where
1	PRIMARY	v	eq_ref	PRIMARY	PRIMARY	4	poltekke_beginning2.a.id	1	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	poltekke_beginning2.c.id	5	Using where
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	2	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	index	PRIMARY,idx_left_right	idx_left_right	8	NULL	26	Using where; Using index; Using join buffer (flat, BNL join)

Profile

Status	Duration
Starting	0.05 ms
Waiting for query cache lock	0.02 ms
Init	0.02 ms
Checking query cache for query	0.17 ms
Checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Waiting for query cache lock	0.04 ms
Init	0.09 ms
Optimizing	0.05 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Statistics	0.09 ms
Preparing	0.03 ms
Creating tmp table	0.02 ms
Sorting result	0.03 ms
Preparing	0.06 ms
Sorting result	0.02 ms
Executing	0.02 ms
Sending data	0.04 ms
Creating sort index	1.07 ms
Executing	0.02 ms
Sending data	0.03 ms
Creating sort index	0.02 ms
Removing tmp table	0.02 ms
Creating sort index	0.06 ms
Waiting for query cache lock	0.02 ms
Creating sort index	0.05 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.02 ms
Removing tmp table	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Waiting for query cache lock	0.02 ms
Updating status	0.02 ms
Waiting for query cache lock	0.02 ms
Updating status	0.01 ms
Storing result in query cache	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:310
14	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:183
13	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_latest/helper.php:113
11	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
10	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/libraries/cms/module/helper.php:199
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.18 ms After last query: 0.20 ms Query memory: 0.038 MB Memory before query: 10.001 MB Rows returned: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `j0ojv_contentitem_tag_map` AS m 

  INNER JOIN `j0ojv_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 402 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	poltekke_beginning2.m.tag_id	1	Using where

Profile

Status	Duration
Starting	0.05 ms
Waiting for query cache lock	0.02 ms
Init	0.01 ms
Checking query cache for query	0.02 ms
Checking privileges on cached	0.02 ms
Checking permissions	0.02 ms
Sending cached result to clien	0.04 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
13	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_latest/helper.php:113
11	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
10	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/libraries/cms/module/helper.php:199
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.18 ms After last query: 0.14 ms Query memory: 0.038 MB Memory before query: 10.026 MB Rows returned: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `j0ojv_contentitem_tag_map` AS m 

  INNER JOIN `j0ojv_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 401 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	poltekke_beginning2.m.tag_id	1	Using where

Profile

Status	Duration
Starting	0.05 ms
Waiting for query cache lock	0.02 ms
Init	0.02 ms
Checking query cache for query	0.02 ms
Checking privileges on cached	0.02 ms
Checking permissions	0.02 ms
Sending cached result to clien	0.04 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
13	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_latest/helper.php:113
11	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
10	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/libraries/cms/module/helper.php:199
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.17 ms After last query: 0.13 ms Query memory: 0.038 MB Memory before query: 10.050 MB Rows returned: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `j0ojv_contentitem_tag_map` AS m 

  INNER JOIN `j0ojv_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 400 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	poltekke_beginning2.m.tag_id	1	Using where

Profile

Status	Duration
Starting	0.04 ms
Waiting for query cache lock	0.02 ms
Init	0.02 ms
Checking query cache for query	0.02 ms
Checking privileges on cached	0.02 ms
Checking permissions	0.02 ms
Sending cached result to clien	0.04 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
13	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_latest/helper.php:113
11	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
10	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/libraries/cms/module/helper.php:199
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.17 ms After last query: 0.16 ms Query memory: 0.038 MB Memory before query: 10.075 MB Rows returned: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `j0ojv_contentitem_tag_map` AS m 

  INNER JOIN `j0ojv_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 399 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	poltekke_beginning2.m.tag_id	1	Using where

Profile

Status	Duration
Starting	0.05 ms
Waiting for query cache lock	0.02 ms
Init	0.01 ms
Checking query cache for query	0.02 ms
Checking privileges on cached	0.02 ms
Checking permissions	0.02 ms
Sending cached result to clien	0.04 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
13	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_latest/helper.php:113
11	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
10	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/libraries/cms/module/helper.php:199
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.17 ms After last query: 0.13 ms Query memory: 0.038 MB Memory before query: 10.099 MB Rows returned: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `j0ojv_contentitem_tag_map` AS m 

  INNER JOIN `j0ojv_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 398 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	poltekke_beginning2.m.tag_id	1	Using where

Profile

Status	Duration
Starting	0.04 ms
Waiting for query cache lock	0.02 ms
Init	0.01 ms
Checking query cache for query	0.02 ms
Checking privileges on cached	0.02 ms
Checking permissions	0.02 ms
Sending cached result to clien	0.04 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
13	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_latest/helper.php:113
11	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
10	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/libraries/cms/module/helper.php:199
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.17 ms After last query: 2.67 ms Query memory: 0.027 MB Memory before query: 10.164 MB Rows returned: 3

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	4	Using where; Using filesort

Profile

Status	Duration
Starting	0.05 ms
Waiting for query cache lock	0.02 ms
Init	0.01 ms
Checking query cache for query	0.02 ms
Checking privileges on cached	0.02 ms
Checking permissions	0.02 ms
Sending cached result to clien	0.04 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_phocagallery/libraries/phocagallery/render/renderfront.php:722
11	PhocaGalleryRenderFront::renderAllCSS()	JROOT/modules/mod_phocagallery_image/mod_phocagallery_image.php:43
10	include JROOT/modules/mod_phocagallery_image/mod_phocagallery_image.php	JROOT/libraries/cms/module/helper.php:199
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.21 ms After last query: 1.69 ms Query memory: 0.028 MB Memory before query: 10.291 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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cc	ALL	idx_access	NO INDEX KEY COULD BE USED	NULL	NULL	13	Using where; Using filesort

Profile

Status	Duration
Starting	0.07 ms
Waiting for query cache lock	0.02 ms
Init	0.02 ms
Checking query cache for query	0.02 ms
Checking privileges on cached	0.02 ms
Checking permissions	0.02 ms
Sending cached result to clien	0.05 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
11	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_phocagallery_image/mod_phocagallery_image.php:619
10	include JROOT/modules/mod_phocagallery_image/mod_phocagallery_image.php	JROOT/libraries/cms/module/helper.php:199
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.20 ms After last query: 0.51 ms Query memory: 0.026 MB Memory before query: 10.350 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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cc	index	PRIMARY	cat_idx	154	NULL	13	Using where; Using index; Using temporary; Using filesort
1	SIMPLE	a	ref	catid	catid	5	poltekke_beginning2.cc.id,const	6	Using where

Profile

Status	Duration
Starting	0.05 ms
Waiting for query cache lock	0.02 ms
Init	0.02 ms
Checking query cache for query	0.02 ms
Checking privileges on cached	0.02 ms
Checking permissions	0.02 ms
Sending cached result to clien	0.04 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
11	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_phocagallery_image/mod_phocagallery_image.php:682
10	include JROOT/modules/mod_phocagallery_image/mod_phocagallery_image.php	JROOT/libraries/cms/module/helper.php:199
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.17 ms After last query: 0.05 ms Query memory: 0.033 MB Memory before query: 10.364 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 (1,17,51,134,39,57,154,61,31) 
  ORDER BY a.ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	range	PRIMARY,catid	PRIMARY	4	NULL	9	Using where; Using filesort
1	SIMPLE	cc	eq_ref	PRIMARY	PRIMARY	4	poltekke_beginning2.a.catid	1

Profile

Status	Duration
Starting	0.04 ms
Waiting for query cache lock	0.02 ms
Init	0.01 ms
Checking query cache for query	0.02 ms
Checking privileges on cached	0.02 ms
Checking permissions	0.02 ms
Sending cached result to clien	0.04 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
11	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_phocagallery_image/mod_phocagallery_image.php:706
10	include JROOT/modules/mod_phocagallery_image/mod_phocagallery_image.php	JROOT/libraries/cms/module/helper.php:199
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.22 ms After last query: 8.13 ms Query memory: 0.031 MB Memory before query: 10.819 MB Rows returned: 1

SELECT id,parent_id 
  FROM j0ojv_menu 
  WHERE id = 217

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j0ojv_menu	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.07 ms
Waiting for query cache lock	0.02 ms
Init	0.02 ms
Checking query cache for query	0.02 ms
Checking privileges on cached	0.02 ms
Checking permissions	0.02 ms
Sending cached result to clien	0.05 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
19	JDatabaseDriver->loadObject()	JROOT/modules/mod_icemegamenu/libs/menucore.php:82
18	IceMenuTree->getCurrentMenuItem()	JROOT/modules/mod_icemegamenu/libs/menucore.php:67
17	IceMenuTree->__construct()	JROOT/modules/mod_icemegamenu/helper.php:45
16	modIceMegamenuHelper::buildXML()	JROOT/libraries/joomla/cache/controller/callback.php:152
15	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
14	JCacheControllerCallback->call()	JROOT/modules/mod_icemegamenu/helper.php:110
13	modIceMegamenuHelper->getXML()	JROOT/modules/mod_icemegamenu/helper.php:148
12	modIceMegamenuHelper->render()	JROOT/modules/mod_icemegamenu/tmpl/default.php:16
11	require JROOT/modules/mod_icemegamenu/tmpl/default.php	JROOT/modules/mod_icemegamenu/mod_icemegamenu.php:65
10	include JROOT/modules/mod_icemegamenu/mod_icemegamenu.php	JROOT/libraries/cms/module/helper.php:199
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.17 ms After last query: 0.04 ms Query memory: 0.031 MB Memory before query: 10.833 MB Rows returned: 1

SELECT id,parent_id 
  FROM j0ojv_menu 
  WHERE id = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j0ojv_menu	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.04 ms
Waiting for query cache lock	0.02 ms
Init	0.02 ms
Checking query cache for query	0.02 ms
Checking privileges on cached	0.02 ms
Checking permissions	0.02 ms
Sending cached result to clien	0.04 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
19	JDatabaseDriver->loadObject()	JROOT/modules/mod_icemegamenu/libs/menucore.php:82
18	IceMenuTree->getCurrentMenuItem()	JROOT/modules/mod_icemegamenu/libs/menucore.php:67
17	IceMenuTree->__construct()	JROOT/modules/mod_icemegamenu/helper.php:45
16	modIceMegamenuHelper::buildXML()	JROOT/libraries/joomla/cache/controller/callback.php:152
15	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
14	JCacheControllerCallback->call()	JROOT/modules/mod_icemegamenu/helper.php:110
13	modIceMegamenuHelper->getXML()	JROOT/modules/mod_icemegamenu/helper.php:148
12	modIceMegamenuHelper->render()	JROOT/modules/mod_icemegamenu/tmpl/default.php:16
11	require JROOT/modules/mod_icemegamenu/tmpl/default.php	JROOT/modules/mod_icemegamenu/mod_icemegamenu.php:65
10	include JROOT/modules/mod_icemegamenu/mod_icemegamenu.php	JROOT/libraries/cms/module/helper.php:199
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

31 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

15 × SELECT `m`.`tag_id`,`t`.* 
  FROM `j0ojv_contentitem_tag_map` AS m  
  INNER JOIN `j0ojv_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

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

3 × 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

2 × SELECT id,parent_id 
  FROM j0ojv_menu

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `j0ojv_extensions`

```
1 × SELECT * 
  FROM j0ojv_content
```

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

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

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

1 × SELECT a.filename as filename, a.type as type, a.menulink as menulink 
  FROM j0ojv_phocagallery_styles AS a

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

1 × SELECT alias 
  FROM j0ojv_content

1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, 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, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,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 
  FROM j0ojv_content AS a 
  LEFT JOIN j0ojv_categories AS c 
  on c.id = a.catid 
  LEFT JOIN j0ojv_users AS u 
  on u.id = a.created_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

1 × SELECT `data` 
  FROM `j0ojv_session`

1 × SELECT a.name, a.rules 
  FROM j0ojv_assets AS a

1 × SELECT `session_id` 
  FROM `j0ojv_session`

1 × SELECT a.rules 
  FROM j0ojv_assets AS a

```
1 × SELECT * 
  FROM j0ojv_assets
```

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

```
1 × SELECT * 
  FROM j0ojv_languages
```

1 × SELECT `alias`,`catid` 
  FROM `j0ojv_content`

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

1 × SELECT folder AS type, element AS name, params 
  FROM j0ojv_extensions

1 × SELECT id, rules 
  FROM `j0ojv_viewlevels

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

1 × SELECT element 
  FROM j0ojv_extensions

OTHER Tables:

1 × INSERT INTO `j0ojv_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES  ('soj8pj4qn4vgtgjf4dvf673865', 0, 1, '1679655350', 0, ''

1 × UPDATE `j0ojv_extensions` 
  SET `params` = '{\"mediaversion\":\"3ab77276e2cdac3b4d5651e70db28a4d\"}'

1 × SHOW FULL COLUMNS 
  FROM `j0ojv_assets

1 × SHOW FULL COLUMNS 
  FROM `j0ojv_content

1 × UPDATE j0ojv_content 
  SET `hits` = (`hits` + 1)

Informasi

Seleksi Penerimaan Mahasiswa Baru Jalur PMDP Poltekkes Kupang Tahun Akademik 2023/2024

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

51 Queries Logged 30.08 ms

31 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: