Waqf is an special endowment for the development of the Islamic center and mosque center of Universiti Malaysia Perlis (UniMAP)

Wakaf

IMSIC is the Integrated Management System of the UniMAP Islamic Center. There are Online Applications for 'Khairat Kematian' and more.

IMSIC

Facebook

Instagram

Mufti Department

University Islamic Center

Department & School

Zakat Calculator

Online App

News

Video

Universiti Malaysia Perlis (UniMAP) is Malaysia's 17th public institution of higher learning. It was approved by the Malaysian Cabinet on May 2001.

Watch Video

UniMAP CORPORATE VIDEO

Moderator: Ahmad Zulazmeer Rozali (UniMAP Administrative Officer) Panel 1: Nur Rieya Ali Abdullah's sister (Author of the Book: "The Journey of a Muallaf") Panel 2: Brother Adam Corrie Lee Abdullah (Celebrity Poltava- Muallaf)

Watch Video

FORUM: "BICARA HIDAYAH"

Sambutan Aidilfitri perlu dirayai dengan sunnah kembali kepada fitrah insani. Dengarkan ucapan dan pesanan sempena sambutan Hari Raya Aidilfitri tahun 2024 | 1445H

Sorotan sambutan sepanjang Ramadan peringkat Universiti Malaysia Perlis bagi tahun 2024 / 1445H

International Community Outreach Programme (i-COP) merupakan program antarabangsa Pusat Islam & Pembangunan Insan (PIMPIN) dengan kerjasama Jawatankuasa Pengurusan Hal Ehwal Islam IPT Malaysia (JAHEIS).

Perlis Prayer Times

Strict Standards: Redefining already defined constructor for class PrayTime in /home/islamctr/public_html/modules/mod_islamic_prayer_time_pro/helper.php on line 135

Strict Standards: Non-static method JDate::dayToString() should not be called statically in /home/islamctr/public_html/modules/mod_islamic_prayer_time_pro/mod_islamic_prayer_time_pro.php on line 130

Perlis - MALAYSIA

الأحد 7 ربيع الأوّل 1447
Sunday Rabbi al-Thanni 7 1447
Notice: Undefined variable: lday in /home/islamctr/public_html/modules/mod_islamic_prayer_time_pro/tmpl/dailytable.php on line 34

Sunday August 31 2025

Subuh	6:02 am
Syuruk	7:12 am
Zohor	1:20 pm
Asar	4:25 pm
Maghrib	7:27 pm
Isya	8:33 pm

Visitor Counter

10065489

Today

Yesterday

This Week

Last Week

This Month

Last Month

Since 27 July 2011

1783

1772

35632

552120

487219

10065489

Online (15 minutes ago):26
26 guests
no members

Your IP:10.0.5.224

Visitor Counter

Reflection

Boleh jadi kamu benci kepada sesuatu padahal ia baik bagi kamu, dan boleh jadi kamu suka kepada sesuatu padahal ia buruk bagi kamu. Dan (ingatlah), Allah jualah Yang mengetahui (semuanya itu), sedang kamu tidak mengetahuinya - Al Baqarah 216

{uniform form=25/}

poster

Pengenalan Program Tahfiz TVET UniMAP

Mencipta Keseimbangan antara Al-Quran dan Kemahiran Profesional

Universiti Malaysia Perlis (UniMAP) mengambil langkah progresif dalam memperkasa pendidikan holistik menerusi pengenalan Program Tahfiz TVET, iaitu satu inisiatif pendidikan yang menggabungkan hafazan al-Quran dengan pendidikan dan latihan teknikal serta vokasional (TVET).

Program ini bertujuan melahirkan pelajar yang bukan sahaja unggul dari sudut akhlak dan hafazan al-Quran, tetapi juga cemerlang dalam kemahiran teknikal dan profesional yang relevan dengan keperluan industri masa kini.

Objektif Program

Melahirkan graduan seimbang antara penguasaan ilmu agama dan kemahiran teknikal.
Memberi nilai tambah kepada pelajar melalui kemahiran vokasional yang diiktiraf.
Membentuk generasi profesional berteraskan al-Quran, beretika dan berwibawa.
Menjadi platform lanjutan bagi pelajar tahfiz untuk meneruskan pengajian tinggi dalam bidang teknikal tanpa meninggalkan asas keislaman.

Kelebihan Program Tahfiz TVET di UniMAP

Integrasi kurikulum hafazan dan akademik dalam suasana universiti berteraskan teknologi.
Peluang mengikuti latihan industri dengan rakan strategik dalam bidang berkaitan.
Persekitaran kondusif dengan sokongan rohani dan mentor yang berkelayakan.
Peluang kerjaya lebih luas, sama ada dalam sektor profesional, keusahawanan, atau keagamaan.

Siapa Yang Layak Menyertai?

Program ini dibuka kepada:

Pelajar lepasan sekolah tahfiz yang ingin menyambung pengajian dalam bidang teknikal.
Pelajar yang sedang mengikuti program diploma atau ijazah di UniMAP dan berminat menghafaz al-Quran.
Mana-mana individu yang bercita-cita menjadi profesional berteraskan al-Quran.

Harapan dan Visi

Dengan pelaksanaan Program Tahfiz TVET ini, UniMAP berhasrat menjadi antara peneraju institusi pengajian tinggi yang menampilkan model pendidikan Islam moden yang menyeluruh – merangkumi kecemerlangan spiritual, intelektual dan teknikal. Ini juga sejajar dengan hasrat negara untuk memartabatkan pendidikan TVET dan mengangkat martabat huffaz sebagai tonggak pembangunan ummah.

COVID 19 SOP

Joomla! Debug Console

Session

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

Profile Information

Time

Memory

Time: 8.79 ms / 8.79 ms Memory: 0.718 MB / 0.94 MB Application: afterLoad

Time: 114.63 ms / 123.42 ms Memory: 10.973 MB / 11.91 MB Application: afterInitialise

Time: 19.37 ms / 142.79 ms Memory: 1.331 MB / 13.24 MB Application: afterRoute

Time: 1.75 ms / 144.54 ms Memory: 0.215 MB / 13.46 MB Application: beforeRenderComponent com_content

Time: 11.61 ms / 156.15 ms Memory: 1.067 MB / 14.53 MB Application: Start JAccess::getAssetRules Old (1)

Time: 1.42 ms / 157.57 ms Memory: 0.065 MB / 14.59 MB Application: Finish JAccess::getAssetRules Old (1)

Time: 0.04 ms / 157.62 ms Memory: 0.000 MB / 14.59 MB Application: New JAccess Preloading Process(com_content.category)

Time: 2.10 ms / 159.72 ms Memory: 0.137 MB / 14.72 MB Application: After preloadPermissionsParentIdMapping (com_content.category)

Time: 2.54 ms / 162.26 ms Memory: 0.222 MB / 14.95 MB Application: After preloadPermissions (com_content.category)

Time: 0.01 ms / 162.27 ms Memory: 0.002 MB / 14.95 MB Application: End New JAccess Preloading Process(com_content.category)

Time: 0.02 ms / 162.29 ms Memory: 0.002 MB / 14.95 MB Application: Start JAccess::getAssetRules New (com_content.category.2)

Time: 0.09 ms / 162.38 ms Memory: 0.010 MB / 14.96 MB Application: Finish JAccess::getAssetRules New (com_content.category.2)

Time: 9.31 ms / 171.69 ms Memory: 0.298 MB / 15.26 MB Application: Start JAccess::preload(components)

Time: 4.96 ms / 176.65 ms Memory: 0.416 MB / 15.67 MB Application: Finish JAccess::preload(components)

Time: 69.90 ms / 246.55 ms Memory: 4.725 MB / 20.40 MB Application: afterRenderComponent com_content

Time: 3.78 ms / 250.33 ms Memory: 0.206 MB / 20.60 MB Application: afterDispatch

Time: 5.85 ms / 256.18 ms Memory: 0.077 MB / 20.68 MB Application: beforeRenderModule mod_custom (Copyright)

Time: 1.09 ms / 257.27 ms Memory: 0.044 MB / 20.73 MB Application: afterRenderModule mod_custom (Copyright)

Time: 0.10 ms / 257.37 ms Memory: 0.003 MB / 20.73 MB Application: beforeRenderModule mod_postit (Reflection)

Time: 0.73 ms / 258.10 ms Memory: 0.017 MB / 20.75 MB Application: afterRenderModule mod_postit (Reflection)

Time: 0.10 ms / 258.20 ms Memory: 0.000 MB / 20.74 MB Application: beforeRenderModule mod_zt_visitor_counter (Visitor Counter)

Time: 158.52 ms / 416.72 ms Memory: 0.259 MB / 21.00 MB Application: afterRenderModule mod_zt_visitor_counter (Visitor Counter)

Time: 0.35 ms / 417.07 ms Memory: 0.000 MB / 20.99 MB Application: beforeRenderModule mod_islamic_prayer_time_pro (Perlis Prayer Times)

Time: 7.56 ms / 424.63 ms Memory: 0.276 MB / 21.27 MB Application: afterRenderModule mod_islamic_prayer_time_pro (Perlis Prayer Times)

Time: 0.47 ms / 425.10 ms Memory: 0.000 MB / 21.25 MB Application: beforeRenderModule mod_favimagehover (Video)

Time: 2.34 ms / 427.44 ms Memory: 0.058 MB / 21.31 MB Application: afterRenderModule mod_favimagehover (Video)

Time: 0.34 ms / 427.78 ms Memory: 0.000 MB / 21.28 MB Application: beforeRenderModule mod_bt_contentslider (News)

Time: 16.60 ms / 444.38 ms Memory: 0.865 MB / 22.15 MB Application: afterRenderModule mod_bt_contentslider (News)

Time: 0.42 ms / 444.79 ms Memory: 0.000 MB / 21.74 MB Application: beforeRenderModule mod_faveffects (Module 2)

Time: 0.77 ms / 445.56 ms Memory: 0.038 MB / 21.77 MB Application: afterRenderModule mod_faveffects (Module 2)

Time: 0.15 ms / 445.71 ms Memory: 0.000 MB / 21.75 MB Application: beforeRenderModule mod_faveffects (Iconic 1)

Time: 0.69 ms / 446.40 ms Memory: 0.038 MB / 21.79 MB Application: afterRenderModule mod_faveffects (Iconic 1)

Time: 0.15 ms / 446.55 ms Memory: 0.000 MB / 21.77 MB Application: beforeRenderModule mod_favpromote (FavPromote)

Time: 0.82 ms / 447.37 ms Memory: 0.047 MB / 21.82 MB Application: afterRenderModule mod_favpromote (FavPromote)

Time: 0.10 ms / 447.47 ms Memory: 0.000 MB / 21.78 MB Application: beforeRenderModule mod_social_icons (Social Icons)

Time: 1.65 ms / 449.12 ms Memory: 0.054 MB / 21.84 MB Application: afterRenderModule mod_social_icons (Social Icons)

Time: 0.16 ms / 449.28 ms Memory: 0.000 MB / 21.79 MB Application: beforeRenderModule mod_gtranslate (gtranslate)

Time: 2.46 ms / 451.74 ms Memory: 0.206 MB / 22.00 MB Application: afterRenderModule mod_gtranslate (gtranslate)

Time: 0.13 ms / 451.87 ms Memory: 0.000 MB / 21.84 MB Application: beforeRenderModule mod_popup_jt (Pop up JT)

Time: 2.80 ms / 454.67 ms Memory: 0.210 MB / 22.05 MB Application: beforeRenderModule mod_newsscroller_self_dhtml (Announcement)

Time: 1.50 ms / 456.17 ms Memory: 0.092 MB / 22.14 MB Application: afterRenderModule mod_newsscroller_self_dhtml (Announcement)

Time: 0.10 ms / 456.27 ms Memory: 0.000 MB / 22.05 MB Application: afterRenderModule mod_popup_jt (Pop up JT)

Time: 0.06 ms / 456.34 ms Memory: 0.000 MB / 22.03 MB Application: beforeRenderModule mod_search (Search)

Time: 1.30 ms / 457.63 ms Memory: 0.024 MB / 22.05 MB Application: afterRenderModule mod_search (Search)

Time: 0.12 ms / 457.76 ms Memory: 0.010 MB / 22.06 MB Application: beforeRenderModule mod_favslider (FavSlider Responsive Slideshow)

Time: 0.86 ms / 458.62 ms Memory: 0.048 MB / 22.11 MB Application: afterRenderModule mod_favslider (FavSlider Responsive Slideshow)

Time: 0.12 ms / 458.74 ms Memory: 0.000 MB / 22.06 MB Application: beforeRenderModule mod_menu (Main Menu)

Time: 23.49 ms / 482.23 ms Memory: 1.046 MB / 23.11 MB Application: afterRenderModule mod_menu (Main Menu)

Time: 18.52 ms / 500.75 ms Memory: 0.663 MB / 23.77 MB Application: afterRender

Database queries total: 217.61 ms

Memory Usage

Database Queries

67 Queries Logged 217.61 ms

23 duplicate found!

2 duplicates: #35 #36

2 duplicates: #37 #38

2 duplicates: #39 #40

3 duplicates: #41 #42 #43

2 duplicates: #44 #45

2 duplicates: #46 #47

2 duplicates: #48 #49

2 duplicates: #50 #51

4 duplicates: #52 #53 #54 #55

2 duplicates: #60 #61

Query Time: 0.38 ms Query memory: 0.019 MB Memory before query: 2.978 MB Rows returned: 0

SELECT `data`

  FROM `n7kfz_session`

  WHERE `session_id` = 'b0b97f8457cae5dc931755a53bf066e5'

Explain

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

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

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

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

Query Time: 0.30 ms After last query: 2.18 ms Query memory: 0.009 MB Memory before query: 3.186 MB

DELETE 

  FROM `n7kfz_session`

  WHERE `time` < '1756624185'

Explain

EXPLAIN not possible on query: DELETE FROM `n7kfz_session` WHERE `time` < '1756624185'

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.06 ms
updating	0.03 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

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

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

Query Time: 0.30 ms After last query: 0.15 ms Query memory: 0.013 MB Memory before query: 3.199 MB Rows returned: 0

SELECT `session_id`

  FROM `n7kfz_session`

  WHERE `session_id` = 'b0b97f8457cae5dc931755a53bf066e5' 
  LIMIT 1

Explain

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

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

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

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

Query Time: 0.91 ms After last query: 0.13 ms Query memory: 0.010 MB Memory before query: 3.215 MB

INSERT INTO `n7kfz_session`
(`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES 
('b0b97f8457cae5dc931755a53bf066e5', 0, 1, '1756625085', 0, '')

Explain

EXPLAIN not possible on query: INSERT INTO `n7kfz_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('b0b97f8457cae5dc931755a53bf066e5', 0, 1, '1756625085', 0, '')

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
update	0.10 ms
end	0.01 ms
query end	0.52 ms
closing tables	0.04 ms
Unlocking tables	0.04 ms
freeing items	0.03 ms
updating status	0.05 ms
cleaning up	0.02 ms

Call Stack

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

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

Query Time: 1.40 ms After last query: 2.50 ms Query memory: 0.023 MB Memory before query: 3.471 MB Rows returned: 52

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

  FROM `n7kfz_extensions`

  WHERE `type` = 'component'

Explain

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

Profile

Status	Duration
starting	0.11 ms
checking permissions	0.03 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.02 ms
Table lock	0.03 ms
init	0.05 ms
optimizing	0.04 ms
statistics	0.11 ms
preparing	0.06 ms
executing	0.02 ms
Sending data	0.59 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.02 ms
Unlocking tables	0.03 ms
freeing items	0.02 ms
updating status	0.04 ms
cleaning up	0.02 ms

Call Stack

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

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

Query Time: 1.01 ms After last query: 1.82 ms Query memory: 0.016 MB Memory before query: 3.700 MB Rows returned: 2

SELECT b.id

  FROM n7kfz_usergroups AS a

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

  WHERE a.id = 9

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	b	index	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	8	NULL	9	Using where; Using index

Profile

Status	Duration
starting	0.11 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
init	0.07 ms
optimizing	0.05 ms
statistics	0.13 ms
preparing	0.02 ms
Unlocking tables	0.06 ms
executing	0.02 ms
Sending data	0.08 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.05 ms
Unlocking tables	0.03 ms
freeing items	0.03 ms
updating status	0.03 ms
cleaning up	0.02 ms

Call Stack

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

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

Query Time: 0.62 ms After last query: 0.70 ms Query memory: 0.016 MB Memory before query: 3.777 MB Rows returned: 5

SELECT id, rules

  FROM `n7kfz_viewlevels`

Explain

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

Profile

Status	Duration
starting	0.06 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
init	0.03 ms
optimizing	0.03 ms
statistics	0.04 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.08 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.02 ms
Unlocking tables	0.03 ms
freeing items	0.02 ms
updating status	0.03 ms
cleaning up	0.02 ms

Call Stack

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

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

Query Time: 2.43 ms After last query: 0.15 ms Query memory: 0.017 MB Memory before query: 3.797 MB Rows returned: 104

SELECT folder AS type, element AS name, params

  FROM n7kfz_extensions

  WHERE enabled = 1 
  AND type ='plugin' 
  AND state IN (0,1) 
  AND access IN (1,1,5)

  ORDER BY ordering

Explain

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

Profile

Status	Duration
starting	0.10 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
init	0.07 ms
optimizing	0.05 ms
statistics	0.09 ms
preparing	0.06 ms
Sorting result	0.03 ms
executing	0.02 ms
Sending data	0.03 ms
Creating sort index	1.61 ms
end	0.03 ms
query end	0.05 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
freeing items	0.03 ms
updating status	0.04 ms
cleaning up	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/cms/plugin/helper.php:310
7	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
6	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
5	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
4	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

Query Time: 1.08 ms After last query: 19.28 ms Query memory: 0.014 MB Memory before query: 5.652 MB Rows returned: 1

SELECT `enabled`

  FROM `n7kfz_extensions`

  WHERE `element` = 'com_akeeba' 
  AND `type` = 'component'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	n7kfz_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using index condition; Using where

Profile

Status	Duration
starting	0.15 ms
checking permissions	0.04 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
init	0.06 ms
optimizing	0.05 ms
statistics	0.17 ms
preparing	0.06 ms
executing	0.02 ms
Sending data	0.11 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
freeing items	0.03 ms
updating status	0.03 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/backuponupdate/backuponupdate.php:50
8	require_once JROOT/plugins/system/backuponupdate/backuponupdate.php	JROOT/libraries/cms/plugin/helper.php:230
7	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
6	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
5	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
4	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

Query Time: 1.01 ms After last query: 21.93 ms Query memory: 0.018 MB Memory before query: 7.699 MB Rows returned: 1

SELECT *

  FROM n7kfz_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

Status	Duration
starting	0.13 ms
checking permissions	0.07 ms
Opening tables	0.06 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
init	0.07 ms
optimizing	0.05 ms
statistics	0.05 ms
preparing	0.05 ms
Sorting result	0.03 ms
executing	0.02 ms
Sending data	0.05 ms
Creating sort index	0.13 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.03 ms
freeing items	0.03 ms
updating status	0.04 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:164
9	JLanguageHelper::getLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:97
8	PlgSystemLanguageFilter->__construct()	JROOT/libraries/cms/plugin/helper.php:255
7	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
6	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
5	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
4	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

[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.43 ms Query memory: 0.015 MB Memory before query: 7.736 MB Rows returned: 6

SELECT element

  FROM n7kfz_extensions

  WHERE type = 'language' 
  AND client_id = 0 
  AND enabled = 1

Explain

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

Profile

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.08 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/multilang.php:90
9	JLanguageMultilang::getSiteLangs()	JROOT/plugins/system/languagefilter/languagefilter.php:108
8	PlgSystemLanguageFilter->__construct()	JROOT/libraries/cms/plugin/helper.php:255
7	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
6	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
5	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
4	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

Query Time: 0.49 ms After last query: 9.60 ms Query memory: 0.017 MB Memory before query: 8.718 MB Rows returned: 1

SELECT params

  FROM n7kfz_extensions

  WHERE type = "plugin" 
  AND folder = "system" 
  AND element = 'jsnextfw'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	n7kfz_extensions	ref	element_clientid,element_folder_clientid,extension	element_folder_clientid	804	const,const	1	Using index condition; Using where

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
12	JDatabaseDriver->loadResult()	JROOT/plugins/system/jsnextfw/includes/helper.php:163
11	JsnExtFwHelper::getSettings()	JROOT/plugins/system/jsnextfw/jsnextfw.php:141
10	PlgSystemJsnExtFw->onAfterInitialise()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
8	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
7	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
6	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
5	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
4	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

Query Time: 0.58 ms After last query: 3.82 ms Query memory: 0.028 MB Memory before query: 9.165 MB Rows returned: 1

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

  FROM `n7kfz_extensions`

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

Explain

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

Profile

Status	Duration
starting	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
init	0.03 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.04 ms
executing	0.03 ms
Sending data	0.07 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
21	JDatabaseDriver->loadObject()	Same as call in the line below.
20	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
19	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
18	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
17	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
16	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
15	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
14	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
13	JFactory::getDocument()	JROOT/plugins/system/helix/core/helix.php:50
12	Helix::getDocument()	JROOT/plugins/system/helix/core/helix.php:36
11	Helix::getInstance()	JROOT/plugins/system/helix/helix.php:21
10	plgSystemHelix->onAfterInitialise()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
8	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
7	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
6	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
5	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
4	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

Query Time: 0.42 ms After last query: 0.22 ms Query memory: 0.021 MB Memory before query: 9.176 MB

UPDATE `n7kfz_extensions`

  SET `params` = '{\"mediaversion\":\"8417364cafa4dc40524f59a6f7d30e6d\"}'

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

Explain

EXPLAIN not possible on query: UPDATE `n7kfz_extensions` SET `params` = '{\"mediaversion\":\"8417364cafa4dc40524f59a6f7d30e6d\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.09 ms
updating	0.06 ms
end	0.02 ms
query end	0.03 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
17	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
16	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
15	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
14	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
13	JFactory::getDocument()	JROOT/plugins/system/helix/core/helix.php:50
12	Helix::getDocument()	JROOT/plugins/system/helix/core/helix.php:36
11	Helix::getInstance()	JROOT/plugins/system/helix/helix.php:21
10	plgSystemHelix->onAfterInitialise()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
8	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
7	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
6	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
5	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
4	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

Query Time: 1.99 ms After last query: 2.38 ms Query memory: 0.048 MB Memory before query: 9.485 MB Rows returned: 93

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 n7kfz_menu AS m

  LEFT JOIN n7kfz_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	109	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	islamctr_db1.m.component_id	1	Using where

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.05 ms
optimizing	0.03 ms
statistics	0.06 ms
preparing	0.05 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
Creating sort index	1.37 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
22	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
21	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
20	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
19	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
18	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
17	JApplicationSite->getMenu()	JROOT/libraries/cms/application/site.php:438
16	JApplicationSite->getTemplate()	JROOT/plugins/system/helix/core/helix.php:65
15	Helix::themeName()	JROOT/plugins/system/helix/core/helix.php:114
14	Helix::themePath()	JROOT/plugins/system/helix/core/helix.php:302
13	Helix::_Import()	JROOT/plugins/system/helix/core/helix.php:290
12	Helix::Import()	JROOT/plugins/system/helix/core/helix.php:1592
11	Helix::loadHelixOverwrite()	JROOT/plugins/system/helix/helix.php:22
10	plgSystemHelix->onAfterInitialise()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
8	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
7	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
6	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
5	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
4	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

Query Time: 0.88 ms After last query: 3.80 ms Query memory: 0.030 MB Memory before query: 10.731 MB Rows returned: 6

SELECT id, home, template, s.params

  FROM n7kfz_template_styles as s

  LEFT JOIN n7kfz_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	8	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	islamctr_db1.s.template,const	1	Using index condition; Using where

Profile

Status	Duration
starting	0.08 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.04 ms
optimizing	0.06 ms
statistics	0.11 ms
preparing	0.06 ms
executing	0.02 ms
Sending data	0.24 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.03 ms
freeing items	0.02 ms
updating status	0.03 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
16	JApplicationSite->getTemplate()	JROOT/plugins/system/helix/core/helix.php:65
15	Helix::themeName()	JROOT/plugins/system/helix/core/helix.php:114
14	Helix::themePath()	JROOT/plugins/system/helix/core/helix.php:302
13	Helix::_Import()	JROOT/plugins/system/helix/core/helix.php:290
12	Helix::Import()	JROOT/plugins/system/helix/core/helix.php:1592
11	Helix::loadHelixOverwrite()	JROOT/plugins/system/helix/helix.php:22
10	plgSystemHelix->onAfterInitialise()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
8	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
7	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
6	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
5	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
4	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

Query Time: 0.92 ms After last query: 9.43 ms Query memory: 0.017 MB Memory before query: 11.585 MB Rows returned: 1

SELECT timestamp

  FROM n7kfz_zt_visitor_counter

  WHERE ipaddress = '10.0.5.224' 
  AND useragent LIKE "%other%"

  ORDER BY timestamp DESC 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	n7kfz_zt_visitor_counter	index	NULL	timestamp	4	NULL	1	Using where

Profile

Status	Duration
starting	0.13 ms
checking permissions	0.04 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
init	0.06 ms
optimizing	0.05 ms
statistics	0.04 ms
preparing	0.04 ms
Sorting result	0.03 ms
executing	0.02 ms
Sending data	0.12 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.02 ms
Unlocking tables	0.03 ms
freeing items	0.03 ms
updating status	0.03 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
12	JDatabaseDriver->loadResult()	JROOT/plugins/system/zt_visitor_counter/helper.php:65
11	plgZTVisitorCounterHelper::getLastVisit()	JROOT/plugins/system/zt_visitor_counter/zt_visitor_counter.php:42
10	plgSystemZT_Visitor_Counter->onAfterInitialise()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
8	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
7	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
6	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
5	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
4	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

Query Time: 1.11 ms After last query: 0.12 ms Query memory: 0.015 MB Memory before query: 11.598 MB

UPDATE n7kfz_zt_visitor_counter 
  SET visits=visits + 1, guests=guests + 1, useragent = 'other' 
  WHERE timestamp = 1756625930 
  AND `ipaddress` = '10.0.5.224';

Explain

EXPLAIN not possible on query: UPDATE n7kfz_zt_visitor_counter SET visits=visits + 1, guests=guests + 1, useragent = 'other' WHERE timestamp = 1756625930 AND `ipaddress` = '10.0.5.224';

Profile

Status	Duration
starting	0.08 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
init	0.08 ms
updating	0.11 ms
end	0.03 ms
query end	0.55 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
freeing items	0.03 ms
updating status	0.03 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
12	JDatabase->query()	JROOT/plugins/system/zt_visitor_counter/helper.php:43
11	plgZTVisitorCounterHelper::updateVisits()	JROOT/plugins/system/zt_visitor_counter/zt_visitor_counter.php:52
10	plgSystemZT_Visitor_Counter->onAfterInitialise()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
8	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
7	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
6	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
5	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
4	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

Query Time: 4.64 ms After last query: 15.02 ms Query memory: 0.025 MB Memory before query: 13.071 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 n7kfz_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM n7kfz_categories AS cat JOIN n7kfz_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 n7kfz_categories AS s 
  ON (s.lft < c.lft 
  AND s.rgt > c.rgt 
  AND c.language in ('en-GB','*')) 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,5) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=2

  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,idx_language	NO INDEX KEY COULD BE USED	NULL	NULL	23	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	islamctr_db1.c.id	4	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	idx_left_right	idx_left_right	8	NULL	23	Using where; Using index; Using join buffer (flat, BNL join)

Profile

Status	Duration
starting	0.44 ms
checking permissions	0.04 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
Opening tables	0.07 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
init	0.28 ms
optimizing	0.11 ms
optimizing	0.04 ms
statistics	0.15 ms
preparing	0.06 ms
Creating tmp table	0.04 ms
Sorting result	0.06 ms
statistics	0.32 ms
preparing	0.03 ms
Unlocking tables	0.10 ms
Creating tmp table	0.11 ms
Sorting result	0.04 ms
executing	0.02 ms
Sending data	0.12 ms
executing	0.02 ms
Sending data	0.15 ms
Creating sort index	0.05 ms
removing tmp table	0.04 ms
Creating sort index	1.17 ms
Creating sort index	0.15 ms
removing tmp table	0.47 ms
Creating sort index	0.05 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.02 ms
removing tmp table	0.03 ms
closing tables	0.02 ms
Unlocking tables	0.04 ms
freeing items	0.05 ms
updating status	0.04 ms
cleaning up	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/legacy/categories/categories.php:309
12	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
11	JCategories->get()	JROOT/components/com_content/router.php:341
10	ContentRouter->parse()	JROOT/libraries/cms/router/site.php:408
9	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
8	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
7	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
6	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
5	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
4	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

Query Time: 2.48 ms After last query: 11.33 ms Query memory: 0.034 MB Memory before query: 14.429 MB Rows returned: 8

SHOW FULL COLUMNS 
  FROM `n7kfz_assets`

Explain

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

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.03 ms
closing tables	0.03 ms
Opening tables	0.84 ms
After opening tables	0.03 ms
System lock	0.02 ms
Table lock	0.02 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.03 ms
preparing	0.04 ms
executing	0.02 ms
Filling schema table	0.03 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
checking permissions	0.09 ms
checking permissions	0.04 ms
checking permissions	0.03 ms
checking permissions	0.04 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
closing tables	0.03 ms
executing	0.02 ms
Sending data	0.10 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
removing tmp table	0.46 ms
closing tables	0.03 ms
Unlocking tables	0.02 ms
freeing items	0.03 ms
updating status	0.04 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
23	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
22	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
21	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:60
20	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:308
19	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:696
18	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
17	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
16	JUser->authorise()	JROOT/components/com_content/models/category.php:142
15	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:435
14	JModelLegacy->getState()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:394
13	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:114
12	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
11	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
9	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
8	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
7	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
6	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
5	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
4	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

Query Time: 0.71 ms After last query: 0.76 ms Query memory: 0.029 MB Memory before query: 14.505 MB Rows returned: 1

SELECT *

  FROM n7kfz_assets

  WHERE `id` = '1'

Explain

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

Profile

Status	Duration
starting	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
init	0.05 ms
optimizing	0.04 ms
statistics	0.09 ms
preparing	0.02 ms
Unlocking tables	0.05 ms
executing	0.02 ms
Sending data	0.04 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.03 ms
freeing items	0.02 ms
updating status	0.03 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
20	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
19	JTable->load()	JROOT/libraries/joomla/access/access.php:697
18	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
17	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
16	JUser->authorise()	JROOT/components/com_content/models/category.php:142
15	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:435
14	JModelLegacy->getState()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:394
13	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:114
12	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
11	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
9	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
8	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
7	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
6	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
5	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
4	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

Query Time: 0.78 ms After last query: 0.17 ms Query memory: 0.025 MB Memory before query: 14.528 MB Rows returned: 1

SELECT a.rules

  FROM n7kfz_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.07 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
init	0.04 ms
optimizing	0.04 ms
statistics	0.08 ms
preparing	0.06 ms
executing	0.02 ms
Sending data	0.16 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.03 ms
freeing items	0.03 ms
updating status	0.03 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
18	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
17	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
16	JUser->authorise()	JROOT/components/com_content/models/category.php:142
15	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:435
14	JModelLegacy->getState()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:394
13	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:114
12	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
11	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
9	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
8	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
7	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
6	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
5	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
4	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

Query Time: 1.69 ms After last query: 0.71 ms Query memory: 0.031 MB Memory before query: 14.589 MB Rows returned: 157

SELECT a.id, a.parent_id

  FROM n7kfz_assets AS a

  WHERE (a.name LIKE 'com_content.%' OR a.name = 'com_content' OR a.id = 1)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	PRIMARY,idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	349	Using where

Profile

Status	Duration
starting	0.08 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
init	0.05 ms
optimizing	0.04 ms
statistics	0.11 ms
preparing	0.04 ms
executing	0.02 ms
Sending data	1.02 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.03 ms
cleaning up	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/access/access.php:332
19	JAccess::preloadPermissionsParentIdMapping()	JROOT/libraries/joomla/access/access.php:240
18	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
17	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
16	JUser->authorise()	JROOT/components/com_content/models/category.php:142
15	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:435
14	JModelLegacy->getState()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:394
13	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:114
12	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
11	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
9	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
8	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
7	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
6	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
5	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
4	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

Query Time: 1.52 ms After last query: 0.78 ms Query memory: 0.032 MB Memory before query: 14.750 MB Rows returned: 157

SELECT a.id, a.name, a.rules

  FROM n7kfz_assets AS a

  WHERE (a.name LIKE 'com_content.%' OR a.name = 'com_content' OR a.id = 1 )

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	PRIMARY,idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	349	Using where

Profile

Status	Duration
starting	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
init	0.04 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.04 ms
executing	0.02 ms
Sending data	0.95 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
freeing items	0.03 ms
updating status	0.03 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1255
20	JDatabaseDriver->getIterator()	JROOT/libraries/joomla/access/access.php:373
19	JAccess::preloadPermissions()	JROOT/libraries/joomla/access/access.php:243
18	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
17	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
16	JUser->authorise()	JROOT/components/com_content/models/category.php:142
15	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:435
14	JModelLegacy->getState()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:394
13	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:114
12	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
11	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
9	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
8	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
7	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
6	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
5	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
4	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

Query Time: 6.38 ms After last query: 1.02 ms Query memory: 0.030 MB Memory before query: 14.958 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,COUNT(i.`id`) AS numitems

  FROM n7kfz_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM n7kfz_categories AS cat JOIN n7kfz_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 n7kfz_categories AS s 
  ON (s.lft < c.lft 
  AND s.rgt > c.rgt 
  AND c.language in ('en-GB','*')) OR (s.lft >= c.lft 
  AND s.rgt <= c.rgt)

  LEFT JOIN `n7kfz_content` AS i 
  ON i.`catid` = c.id 
  AND i.state = 1 
  AND (i.language = '*' OR i.language = 'en-GB')

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=2

  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,idx_language	NO INDEX KEY COULD BE USED	NULL	NULL	23	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	islamctr_db1.c.id	4	Using where
1	PRIMARY	i	ref	idx_state,idx_catid,idx_language	idx_catid	4	islamctr_db1.c.id	7	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	idx_left_right	idx_left_right	8	NULL	23	Using where; Using index; Using join buffer (flat, BNL join)

Profile

Status	Duration
starting	0.34 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.07 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
init	0.25 ms
optimizing	0.12 ms
optimizing	0.04 ms
statistics	0.12 ms
preparing	0.05 ms
Creating tmp table	0.04 ms
Sorting result	0.04 ms
statistics	0.46 ms
preparing	0.02 ms
Unlocking tables	0.11 ms
Creating tmp table	0.13 ms
Sorting result	0.03 ms
executing	0.02 ms
Sending data	0.11 ms
executing	0.02 ms
Sending data	0.13 ms
Creating sort index	0.04 ms
removing tmp table	0.02 ms
Creating sort index	3.21 ms
Creating sort index	0.10 ms
removing tmp table	0.45 ms
Creating sort index	0.04 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.02 ms
removing tmp table	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.03 ms
freeing items	0.03 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
16	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
15	JCategories->get()	JROOT/components/com_content/models/category.php:354
14	ContentModelCategory->getCategory()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:394
13	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:115
12	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
11	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
9	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
8	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
7	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
6	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
5	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
4	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

Query Time: 0.59 ms After last query: 2.72 ms Query memory: 0.031 MB Memory before query: 15.254 MB Rows returned: 51

SELECT element

  FROM n7kfz_extensions

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

Explain

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

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.21 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
23	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:413
22	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
21	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
20	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
19	JUser->authorise()	JROOT/components/com_content/models/articles.php:466
18	ContentModelArticles->getListQuery()	JROOT/libraries/legacy/model/list.php:129
17	JModelList->_getListQuery()	JROOT/libraries/legacy/model/list.php:183
16	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
15	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
14	ContentModelCategory->getItems()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:394
13	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
12	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
11	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
9	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
8	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
7	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
6	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
5	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
4	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

Query Time: 1.47 ms After last query: 0.28 ms Query memory: 0.032 MB Memory before query: 15.295 MB Rows returned: 51

SELECT a.name, a.rules

  FROM n7kfz_assets AS a

  WHERE (a.name IN ('com_acymailing','com_admin','com_ajax','com_akeeba','com_allvideoshare','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_countdowntimer','com_cpanel','com_finder','com_hdwmusic','com_installer','com_jaextmanager','com_jalang','com_jce','com_jevents','com_jforms','com_jimigrator','com_joomlaupdate','com_kunena','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osmap','com_pagebuilder3','com_phocagallery','com_phocamaps','com_plugins','com_portfoliogallery','com_postinstall','com_redirect','com_search','com_seftranslate','com_tags','com_templates','com_uniform','com_users','com_weblinks','com_wrapper','com_youtubegallery') OR a.name = 'root.1')

Explain

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

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.07 ms
optimizing	0.02 ms
statistics	0.19 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.91 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
23	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:441
22	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
21	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
20	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
19	JUser->authorise()	JROOT/components/com_content/models/articles.php:466
18	ContentModelArticles->getListQuery()	JROOT/libraries/legacy/model/list.php:129
17	JModelList->_getListQuery()	JROOT/libraries/legacy/model/list.php:183
16	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
15	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
14	ContentModelCategory->getItems()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:394
13	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
12	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
11	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
9	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
8	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
7	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
6	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
5	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
4	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

Query Time: 4.26 ms After last query: 2.69 ms Query memory: 0.037 MB Memory before query: 15.662 MB Rows returned: 9

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 n7kfz_content AS a

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

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

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

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

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

  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM n7kfz_categories AS cat JOIN n7kfz_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,5) 
  AND c.access IN (1,1,5) 
  AND 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
  AND (a.catid = 2 OR a.catid IN (
SELECT sub.id

  FROM n7kfz_categories as sub

  INNER JOIN n7kfz_categories as this 
  ON sub.lft > this.lft 
  AND sub.rgt < this.rgt

  WHERE this.id = 2)) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-08-31 07:24:45') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-08-31 07:24:45') 
  AND a.language in ('en-GB','*')

  ORDER BY  c.lft,   
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC ,  a.created   
  LIMIT 9

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	c	ALL	PRIMARY,idx_access	NO INDEX KEY COULD BE USED	NULL	NULL	23	Using where; Using temporary; Using filesort
1	PRIMARY	a	ref	idx_access,idx_catid,idx_language	idx_catid	4	islamctr_db1.c.id	7	Using index condition; Using where
1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	islamctr_db1.a.created_by	1	Using where
1	PRIMARY	uam	eq_ref	PRIMARY	PRIMARY	4	islamctr_db1.a.modified_by	1	Using where
1	PRIMARY	parent	eq_ref	PRIMARY	PRIMARY	4	islamctr_db1.c.parent_id	1	Using where
1	PRIMARY	v	eq_ref	PRIMARY	PRIMARY	4	islamctr_db1.a.id	1	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	islamctr_db1.c.id	4	Using where
3	MATERIALIZED	this	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
3	MATERIALIZED	sub	range	PRIMARY,idx_left_right	idx_left_right	4	NULL	21	Using where; Using index
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	idx_left_right	idx_left_right	8	NULL	23	Using where; Using index; Using join buffer (flat, BNL join)

Profile

Status	Duration
starting	0.25 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.14 ms
optimizing	0.07 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.03 ms
Creating tmp table	0.02 ms
Sorting result	0.03 ms
statistics	0.13 ms
preparing	0.06 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.04 ms
Creating tmp table	0.07 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	0.11 ms
executing	0.01 ms
Sending data	0.07 ms
Creating sort index	0.02 ms
removing tmp table	0.01 ms
Creating sort index	1.24 ms
executing	0.01 ms
Sending data	0.78 ms
Creating sort index	0.19 ms
removing tmp table	0.39 ms
Creating sort index	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
removing tmp table	0.01 ms
freeing items	0.02 ms
removing tmp table	0.01 ms
freeing items	0.02 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:310
17	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:183
16	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
15	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
14	ContentModelCategory->getItems()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:394
13	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
12	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
11	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
9	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
8	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
7	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
6	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
5	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
4	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

Query Time: 1.79 ms After last query: 3.49 ms Query memory: 0.025 MB Memory before query: 16.097 MB Rows returned: 1

SELECT COUNT(*)

  FROM n7kfz_content AS a

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

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

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

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

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

  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM n7kfz_categories AS cat JOIN n7kfz_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,5) 
  AND c.access IN (1,1,5) 
  AND 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
  AND (a.catid = 2 OR a.catid IN (
SELECT sub.id

  FROM n7kfz_categories as sub

  INNER JOIN n7kfz_categories as this 
  ON sub.lft > this.lft 
  AND sub.rgt < this.rgt

  WHERE this.id = 2)) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-08-31 07:24:45') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-08-31 07:24:45') 
  AND a.language in ('en-GB','*')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	c	ALL	PRIMARY,idx_access	NO INDEX KEY COULD BE USED	NULL	NULL	23	Using where
1	PRIMARY	a	ref	idx_access,idx_catid,idx_language	idx_catid	4	islamctr_db1.c.id	7	Using index condition; Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	islamctr_db1.c.id	4	Using where
3	MATERIALIZED	this	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
3	MATERIALIZED	sub	range	PRIMARY,idx_left_right	idx_left_right	4	NULL	21	Using where; Using index
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	idx_left_right	idx_left_right	8	NULL	23	Using where; Using index; Using join buffer (flat, BNL join)

Profile

Status	Duration
starting	0.13 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.07 ms
optimizing	0.05 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
Creating tmp table	0.02 ms
Sorting result	0.02 ms
statistics	0.08 ms
preparing	0.01 ms
Unlocking tables	0.04 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.07 ms
executing	0.01 ms
Sending data	0.06 ms
Creating sort index	0.02 ms
removing tmp table	0.01 ms
Creating sort index	0.24 ms
executing	0.01 ms
Sending data	0.42 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
removing tmp table	0.01 ms
freeing items	0.02 ms
removing tmp table	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
18	JDatabaseDriver->loadResult()	JROOT/libraries/legacy/model/legacy.php:337
17	JModelLegacy->_getListCount()	JROOT/libraries/legacy/model/list.php:278
16	JModelList->getTotal()	JROOT/libraries/legacy/model/list.php:228
15	JModelList->getPagination()	JROOT/components/com_content/models/category.php:265
14	ContentModelCategory->getItems()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:394
13	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
12	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
11	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
9	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
8	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
7	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
6	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
5	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
4	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

Query Time: 0.51 ms After last query: 1.92 ms Query memory: 0.027 MB Memory before query: 16.285 MB Rows returned: 0

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

  FROM `n7kfz_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.category' 
  AND `m`.`content_item_id` = 2 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

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	islamctr_db1.m.tag_id	1	Using where

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 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/libraries/legacy/view/category.php:217
12	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
11	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
9	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
8	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
7	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
6	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
5	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
4	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

Query Time: 0.43 ms After last query: 15.28 ms Query memory: 0.026 MB Memory before query: 18.042 MB Rows returned: 0

SELECT *

  FROM n7kfz_jsn_uniform_config

  WHERE name='load_bootstrap_css'

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
checking permissions	0.03 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
19	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_uniform/helpers/uniform.php:786
18	JSNUniformHelper::getDataConfig()	JROOT/administrator/components/com_uniform/helpers/uniform.php:1520
17	JSNUniformHelper::generateHTMLPages()	JROOT/plugins/content/uniform/uniform.php:103
16	plgContentUniform->loadJSNUniform()	JROOT/plugins/content/uniform/uniform.php:82
15	plgContentUniform->onContentBeforeDisplay()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:114
11	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
9	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
8	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
7	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
6	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
5	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
4	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

Query Time: 0.34 ms After last query: 0.14 ms Query memory: 0.031 MB Memory before query: 18.069 MB Rows returned: 1

SELECT *

  FROM n7kfz_jsn_uniform_forms

  WHERE form_state = 1 
  AND form_id=25

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
18	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_uniform/helpers/uniform.php:1540
17	JSNUniformHelper::generateHTMLPages()	JROOT/plugins/content/uniform/uniform.php:103
16	plgContentUniform->loadJSNUniform()	JROOT/plugins/content/uniform/uniform.php:82
15	plgContentUniform->onContentBeforeDisplay()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:114
11	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
9	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
8	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
7	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
6	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
5	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
4	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

Query Time: 0.90 ms After last query: 0.11 ms Query memory: 0.057 MB Memory before query: 18.102 MB Rows returned: 1

SELECT *

  FROM n7kfz_jsn_uniform_form_pages

  WHERE form_id=25

  ORDER BY page_id ASC

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.62 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_uniform/helpers/uniform.php:1543
17	JSNUniformHelper::generateHTMLPages()	JROOT/plugins/content/uniform/uniform.php:103
16	plgContentUniform->loadJSNUniform()	JROOT/plugins/content/uniform/uniform.php:82
15	plgContentUniform->onContentBeforeDisplay()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:114
11	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
9	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
8	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
7	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
6	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
5	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
4	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

Query Time: 2.19 ms After last query: 8.09 ms Query memory: 0.030 MB Memory before query: 18.847 MB Rows returned: 30

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM n7kfz_modules AS m

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

  LEFT JOIN n7kfz_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2025-08-31 07:24:45') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-08-31 07:24:45') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 150 OR mm.menuid <= 0) 
  AND m.language IN ('en-GB','*')

  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,idx_language	published	1	const	49	Using index condition; Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	islamctr_db1.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	islamctr_db1.m.module,const	1	Using index condition; Using where

Profile

Status	Duration
starting	0.16 ms
checking permissions	0.03 ms
checking permissions	0.02 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
init	0.07 ms
optimizing	0.08 ms
statistics	0.13 ms
preparing	0.07 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
Creating sort index	1.24 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.04 ms
freeing items	0.02 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
20	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:413
19	JModuleHelper::getModuleList()	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:356
18	JModuleHelper::load()	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:34
17	JModuleHelper::getModule()	JROOT/plugins/content/loadmodule/loadmodule.php:168
16	PlgContentLoadmodule->_loadmod()	JROOT/plugins/content/loadmodule/loadmodule.php:113
15	PlgContentLoadmodule->onContentPrepare()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:106
11	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
9	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
8	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
7	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
6	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
5	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
4	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

Query Time: 0.74 ms After last query: 4.55 ms Query memory: 0.027 MB Memory before query: 19.446 MB Rows returned: 1

Duplicate queries: #36

SELECT * 
  FROM n7kfz_youtubegallery_videolists 
  WHERE id=2 
  LIMIT 1

Explain

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

Profile

Status	Duration
starting	0.08 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.02 ms
Table lock	0.02 ms
init	0.05 ms
optimizing	0.03 ms
statistics	0.07 ms
preparing	0.02 ms
Unlocking tables	0.03 ms
executing	0.02 ms
Sending data	0.05 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.03 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
18	JDatabase->query()	JROOT/plugins/content/youtubegallery/youtubegallery.php:137
17	plgContentYoutubeGallery::getYoutubeGallery()	JROOT/plugins/content/youtubegallery/youtubegallery.php:78
16	plgContentYoutubeGallery::plgYoutubeGallery()	JROOT/plugins/content/youtubegallery/youtubegallery.php:39
15	plgContentYoutubeGallery->onContentPrepare()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:106
11	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
9	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
8	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
7	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
6	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
5	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
4	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

Query Time: 0.54 ms After last query: 0.06 ms Query memory: 0.027 MB Memory before query: 19.470 MB Rows returned: 1

Duplicate queries: #35

SELECT * 
  FROM n7kfz_youtubegallery_videolists 
  WHERE id=2 
  LIMIT 1

Explain

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

Profile

Status	Duration
starting	0.05 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
init	0.04 ms
optimizing	0.03 ms
statistics	0.05 ms
preparing	0.02 ms
Unlocking tables	0.03 ms
executing	0.02 ms
Sending data	0.04 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.03 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/content/youtubegallery/youtubegallery.php:138
17	plgContentYoutubeGallery::getYoutubeGallery()	JROOT/plugins/content/youtubegallery/youtubegallery.php:78
16	plgContentYoutubeGallery::plgYoutubeGallery()	JROOT/plugins/content/youtubegallery/youtubegallery.php:39
15	plgContentYoutubeGallery->onContentPrepare()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:106
11	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
9	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
8	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
7	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
6	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
5	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
4	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

Query Time: 0.64 ms After last query: 0.09 ms Query memory: 0.038 MB Memory before query: 19.496 MB Rows returned: 1

Duplicate queries: #38

SELECT * 
  FROM n7kfz_youtubegallery_themes 
  WHERE id=1 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	n7kfz_youtubegallery_themes	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1

Profile

Status	Duration
starting	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
init	0.06 ms
optimizing	0.03 ms
statistics	0.05 ms
preparing	0.03 ms
Unlocking tables	0.03 ms
executing	0.02 ms
Sending data	0.09 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.03 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
18	JDatabase->query()	JROOT/plugins/content/youtubegallery/youtubegallery.php:148
17	plgContentYoutubeGallery::getYoutubeGallery()	JROOT/plugins/content/youtubegallery/youtubegallery.php:78
16	plgContentYoutubeGallery::plgYoutubeGallery()	JROOT/plugins/content/youtubegallery/youtubegallery.php:39
15	plgContentYoutubeGallery->onContentPrepare()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:106
11	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
9	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
8	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
7	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
6	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
5	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
4	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

Query Time: 0.59 ms After last query: 0.05 ms Query memory: 0.038 MB Memory before query: 19.520 MB Rows returned: 1

Duplicate queries: #37

SELECT * 
  FROM n7kfz_youtubegallery_themes 
  WHERE id=1 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	n7kfz_youtubegallery_themes	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1

Profile

Status	Duration
starting	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
init	0.06 ms
optimizing	0.03 ms
statistics	0.05 ms
preparing	0.02 ms
Unlocking tables	0.03 ms
executing	0.02 ms
Sending data	0.08 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.03 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/content/youtubegallery/youtubegallery.php:149
17	plgContentYoutubeGallery::getYoutubeGallery()	JROOT/plugins/content/youtubegallery/youtubegallery.php:78
16	plgContentYoutubeGallery::plgYoutubeGallery()	JROOT/plugins/content/youtubegallery/youtubegallery.php:39
15	plgContentYoutubeGallery->onContentPrepare()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:106
11	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
9	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
8	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
7	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
6	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
5	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
4	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

Query Time: 0.58 ms After last query: 0.20 ms Query memory: 0.026 MB Memory before query: 19.555 MB Rows returned: 0

Duplicate queries: #40

SELECT videoid 
  FROM n7kfz_youtubegallery_videos 
  WHERE !INSTR(title,"***Video not found***") 
  AND `listid`='2' 
  AND isvideo=0 
  AND videosource="videolist"

Explain

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

Profile

Status	Duration
starting	0.07 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
init	0.05 ms
optimizing	0.04 ms
statistics	0.03 ms
preparing	0.04 ms
executing	0.02 ms
Sending data	0.07 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.03 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
19	JDatabase->query()	JROOT/components/com_youtubegallery/includes/misc.php:866
18	YouTubeGalleryMisc->getVideoList_FromCache_From_Table()	JROOT/plugins/content/youtubegallery/youtubegallery.php:206
17	plgContentYoutubeGallery::getYoutubeGallery()	JROOT/plugins/content/youtubegallery/youtubegallery.php:78
16	plgContentYoutubeGallery::plgYoutubeGallery()	JROOT/plugins/content/youtubegallery/youtubegallery.php:39
15	plgContentYoutubeGallery->onContentPrepare()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:106
11	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
9	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
8	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
7	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
6	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
5	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
4	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

Query Time: 0.57 ms After last query: 0.06 ms Query memory: 0.026 MB Memory before query: 19.580 MB Rows returned: 0

Duplicate queries: #39

SELECT videoid 
  FROM n7kfz_youtubegallery_videos 
  WHERE !INSTR(title,"***Video not found***") 
  AND `listid`='2' 
  AND isvideo=0 
  AND videosource="videolist"

Explain

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

Profile

Status	Duration
starting	0.07 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
init	0.06 ms
optimizing	0.04 ms
statistics	0.03 ms
preparing	0.04 ms
executing	0.02 ms
Sending data	0.06 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.03 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
19	JDatabaseDriver->loadAssocList()	JROOT/components/com_youtubegallery/includes/misc.php:867
18	YouTubeGalleryMisc->getVideoList_FromCache_From_Table()	JROOT/plugins/content/youtubegallery/youtubegallery.php:206
17	plgContentYoutubeGallery::getYoutubeGallery()	JROOT/plugins/content/youtubegallery/youtubegallery.php:78
16	plgContentYoutubeGallery::plgYoutubeGallery()	JROOT/plugins/content/youtubegallery/youtubegallery.php:39
15	plgContentYoutubeGallery->onContentPrepare()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:106
11	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
9	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
8	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
7	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
6	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
5	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
4	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

Query Time: 2.16 ms After last query: 0.13 ms Query memory: 0.039 MB Memory before query: 19.607 MB Rows returned: 2

Duplicate queries: #42 #43

SELECT * 
  FROM n7kfz_youtubegallery_videos 
  WHERE (`listid`='2') 
  AND isvideo=1 
  GROUP BY videoid 
  ORDER BY publisheddate

Explain

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

Profile

Status	Duration
starting	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
init	0.07 ms
optimizing	0.04 ms
statistics	0.03 ms
preparing	0.03 ms
Creating tmp table	0.11 ms
Sorting result	0.02 ms
executing	0.03 ms
Sending data	0.87 ms
Creating sort index	0.15 ms
removing tmp table	0.41 ms
Creating sort index	0.03 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
freeing items	0.03 ms
updating status	0.03 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
20	JDatabase->query()	JROOT/components/com_youtubegallery/includes/misc.php:1033
19	YouTubeGalleryMisc->getVideoList_FromCacheFromTable()	JROOT/components/com_youtubegallery/includes/misc.php:923
18	YouTubeGalleryMisc->getVideoList_FromCache_From_Table()	JROOT/plugins/content/youtubegallery/youtubegallery.php:206
17	plgContentYoutubeGallery::getYoutubeGallery()	JROOT/plugins/content/youtubegallery/youtubegallery.php:78
16	plgContentYoutubeGallery::plgYoutubeGallery()	JROOT/plugins/content/youtubegallery/youtubegallery.php:39
15	plgContentYoutubeGallery->onContentPrepare()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:106
11	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
9	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
8	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
7	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
6	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
5	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
4	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

Query Time: 1.94 ms After last query: 0.10 ms Query memory: 0.039 MB Memory before query: 19.632 MB Rows returned: 2

Duplicate queries: #41 #43

SELECT * 
  FROM n7kfz_youtubegallery_videos 
  WHERE (`listid`='2') 
  AND isvideo=1 
  GROUP BY videoid 
  ORDER BY publisheddate

Explain

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

Profile

Status	Duration
starting	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
init	0.09 ms
optimizing	0.05 ms
statistics	0.03 ms
preparing	0.04 ms
Creating tmp table	0.10 ms
Sorting result	0.03 ms
executing	0.02 ms
Sending data	0.81 ms
Creating sort index	0.13 ms
removing tmp table	0.33 ms
Creating sort index	0.02 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.02 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
20	JDatabase->query()	JROOT/components/com_youtubegallery/includes/misc.php:1042
19	YouTubeGalleryMisc->getVideoList_FromCacheFromTable()	JROOT/components/com_youtubegallery/includes/misc.php:923
18	YouTubeGalleryMisc->getVideoList_FromCache_From_Table()	JROOT/plugins/content/youtubegallery/youtubegallery.php:206
17	plgContentYoutubeGallery::getYoutubeGallery()	JROOT/plugins/content/youtubegallery/youtubegallery.php:78
16	plgContentYoutubeGallery::plgYoutubeGallery()	JROOT/plugins/content/youtubegallery/youtubegallery.php:39
15	plgContentYoutubeGallery->onContentPrepare()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:106
11	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
9	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
8	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
7	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
6	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
5	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
4	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

Query Time: 1.25 ms After last query: 0.07 ms Query memory: 0.039 MB Memory before query: 19.658 MB Rows returned: 2

Duplicate queries: #41 #42

SELECT * 
  FROM n7kfz_youtubegallery_videos 
  WHERE (`listid`='2') 
  AND isvideo=1 
  GROUP BY videoid 
  ORDER BY publisheddate

Explain

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

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.05 ms
optimizing	0.03 ms
statistics	0.02 ms
preparing	0.02 ms
Creating tmp table	0.07 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	0.47 ms
Creating sort index	0.07 ms
removing tmp table	0.24 ms
Creating sort index	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.02 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
20	JDatabaseDriver->loadAssocList()	JROOT/components/com_youtubegallery/includes/misc.php:1044
19	YouTubeGalleryMisc->getVideoList_FromCacheFromTable()	JROOT/components/com_youtubegallery/includes/misc.php:923
18	YouTubeGalleryMisc->getVideoList_FromCache_From_Table()	JROOT/plugins/content/youtubegallery/youtubegallery.php:206
17	plgContentYoutubeGallery::getYoutubeGallery()	JROOT/plugins/content/youtubegallery/youtubegallery.php:78
16	plgContentYoutubeGallery::plgYoutubeGallery()	JROOT/plugins/content/youtubegallery/youtubegallery.php:39
15	plgContentYoutubeGallery->onContentPrepare()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:106
11	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
9	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
8	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
7	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
6	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
5	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
4	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

Query Time: 0.41 ms After last query: 0.32 ms Query memory: 0.044 MB Memory before query: 19.723 MB Rows returned: 1

Duplicate queries: #45

SELECT * 
  FROM n7kfz_youtubegallery_videos 
  WHERE videoid="3EDz-eR2XEE" 
  LIMIT 1

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
24	JDatabase->query()	JROOT/components/com_youtubegallery/includes/layoutrenderer.php:2412
23	YoutubeGalleryLayoutRenderer::getVideoRowByID()	JROOT/components/com_youtubegallery/includes/layoutrenderer.php:1832
22	YoutubeGalleryLayoutRenderer::SetHeaderTags()	JROOT/components/com_youtubegallery/includes/layoutrenderer.php:2270
21	YoutubeGalleryLayoutRenderer::addHotReloadScript()	JROOT/components/com_youtubegallery/includes/layoutrenderer.php:137
20	YoutubeGalleryLayoutRenderer->getValue()	JROOT/components/com_youtubegallery/includes/layoutrenderer.php:447
19	YoutubeGalleryLayoutRenderer->render()	JROOT/components/com_youtubegallery/includes/render.php:179
18	YouTubeGalleryRenderer->render()	JROOT/plugins/content/youtubegallery/youtubegallery.php:224
17	plgContentYoutubeGallery::getYoutubeGallery()	JROOT/plugins/content/youtubegallery/youtubegallery.php:78
16	plgContentYoutubeGallery::plgYoutubeGallery()	JROOT/plugins/content/youtubegallery/youtubegallery.php:39
15	plgContentYoutubeGallery->onContentPrepare()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:106
11	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
9	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
8	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
7	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
6	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
5	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
4	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

Query Time: 0.38 ms After last query: 0.08 ms Query memory: 0.044 MB Memory before query: 19.753 MB Rows returned: 1

Duplicate queries: #44

SELECT * 
  FROM n7kfz_youtubegallery_videos 
  WHERE videoid="3EDz-eR2XEE" 
  LIMIT 1

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
24	JDatabaseDriver->loadAssocList()	JROOT/components/com_youtubegallery/includes/layoutrenderer.php:2413
23	YoutubeGalleryLayoutRenderer::getVideoRowByID()	JROOT/components/com_youtubegallery/includes/layoutrenderer.php:1832
22	YoutubeGalleryLayoutRenderer::SetHeaderTags()	JROOT/components/com_youtubegallery/includes/layoutrenderer.php:2270
21	YoutubeGalleryLayoutRenderer::addHotReloadScript()	JROOT/components/com_youtubegallery/includes/layoutrenderer.php:137
20	YoutubeGalleryLayoutRenderer->getValue()	JROOT/components/com_youtubegallery/includes/layoutrenderer.php:447
19	YoutubeGalleryLayoutRenderer->render()	JROOT/components/com_youtubegallery/includes/render.php:179
18	YouTubeGalleryRenderer->render()	JROOT/plugins/content/youtubegallery/youtubegallery.php:224
17	plgContentYoutubeGallery::getYoutubeGallery()	JROOT/plugins/content/youtubegallery/youtubegallery.php:78
16	plgContentYoutubeGallery::plgYoutubeGallery()	JROOT/plugins/content/youtubegallery/youtubegallery.php:39
15	plgContentYoutubeGallery->onContentPrepare()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:106
11	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
9	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
8	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
7	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
6	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
5	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
4	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

Query Time: 0.33 ms After last query: 1.22 ms Query memory: 0.030 MB Memory before query: 19.897 MB Rows returned: 1

Duplicate queries: #47

SELECT `value` 
  FROM n7kfz_youtubegallery_settings 
  WHERE `option`='getinfomethod' 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	n7kfz_youtubegallery_settings	const	PRIMARY	PRIMARY	152	const	1

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
23	JDatabase->query()	JROOT/components/com_youtubegallery/includes/misc.php:1792
22	YouTubeGalleryMisc::getSettingValue()	JROOT/components/com_youtubegallery/includes/layoutrenderer.php:1021
21	YoutubeGalleryLayoutRenderer->ClassicNavTable()	JROOT/components/com_youtubegallery/includes/layoutrenderer.php:183
20	YoutubeGalleryLayoutRenderer->getValue()	JROOT/components/com_youtubegallery/includes/layoutrenderer.php:447
19	YoutubeGalleryLayoutRenderer->render()	JROOT/components/com_youtubegallery/includes/render.php:179
18	YouTubeGalleryRenderer->render()	JROOT/plugins/content/youtubegallery/youtubegallery.php:224
17	plgContentYoutubeGallery::getYoutubeGallery()	JROOT/plugins/content/youtubegallery/youtubegallery.php:78
16	plgContentYoutubeGallery::plgYoutubeGallery()	JROOT/plugins/content/youtubegallery/youtubegallery.php:39
15	plgContentYoutubeGallery->onContentPrepare()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:106
11	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
9	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
8	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
7	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
6	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
5	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
4	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

Query Time: 0.30 ms After last query: 0.08 ms Query memory: 0.030 MB Memory before query: 19.926 MB Rows returned: 1

Duplicate queries: #46

SELECT `value` 
  FROM n7kfz_youtubegallery_settings 
  WHERE `option`='getinfomethod' 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	n7kfz_youtubegallery_settings	const	PRIMARY	PRIMARY	152	const	1

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
Unlocking tables	0.02 ms
executing	0.01 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
23	JDatabaseDriver->loadAssocList()	JROOT/components/com_youtubegallery/includes/misc.php:1793
22	YouTubeGalleryMisc::getSettingValue()	JROOT/components/com_youtubegallery/includes/layoutrenderer.php:1021
21	YoutubeGalleryLayoutRenderer->ClassicNavTable()	JROOT/components/com_youtubegallery/includes/layoutrenderer.php:183
20	YoutubeGalleryLayoutRenderer->getValue()	JROOT/components/com_youtubegallery/includes/layoutrenderer.php:447
19	YoutubeGalleryLayoutRenderer->render()	JROOT/components/com_youtubegallery/includes/render.php:179
18	YouTubeGalleryRenderer->render()	JROOT/plugins/content/youtubegallery/youtubegallery.php:224
17	plgContentYoutubeGallery::getYoutubeGallery()	JROOT/plugins/content/youtubegallery/youtubegallery.php:78
16	plgContentYoutubeGallery::plgYoutubeGallery()	JROOT/plugins/content/youtubegallery/youtubegallery.php:39
15	plgContentYoutubeGallery->onContentPrepare()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:106
11	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
9	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
8	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
7	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
6	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
5	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
4	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

Query Time: 0.30 ms After last query: 0.15 ms Query memory: 0.031 MB Memory before query: 19.957 MB Rows returned: 1

Duplicate queries: #49

SELECT rawdata 
  FROM n7kfz_youtubegallery_videos 
  WHERE videoid='3EDz-eR2XEE' 
  LIMIT 1

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
24	JDatabase->query()	JROOT/components/com_youtubegallery/includes/misc.php:379
23	YouTubeGalleryMisc::getRawData()	JROOT/components/com_youtubegallery/includes/misc.php:1401
22	YouTubeGalleryMisc->RefreshVideoData()	JROOT/components/com_youtubegallery/includes/layoutrenderer.php:1023
21	YoutubeGalleryLayoutRenderer->ClassicNavTable()	JROOT/components/com_youtubegallery/includes/layoutrenderer.php:183
20	YoutubeGalleryLayoutRenderer->getValue()	JROOT/components/com_youtubegallery/includes/layoutrenderer.php:447
19	YoutubeGalleryLayoutRenderer->render()	JROOT/components/com_youtubegallery/includes/render.php:179
18	YouTubeGalleryRenderer->render()	JROOT/plugins/content/youtubegallery/youtubegallery.php:224
17	plgContentYoutubeGallery::getYoutubeGallery()	JROOT/plugins/content/youtubegallery/youtubegallery.php:78
16	plgContentYoutubeGallery::plgYoutubeGallery()	JROOT/plugins/content/youtubegallery/youtubegallery.php:39
15	plgContentYoutubeGallery->onContentPrepare()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:106
11	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
9	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
8	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
7	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
6	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
5	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
4	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

Query Time: 0.29 ms After last query: 0.07 ms Query memory: 0.031 MB Memory before query: 19.988 MB Rows returned: 1

Duplicate queries: #48

SELECT rawdata 
  FROM n7kfz_youtubegallery_videos 
  WHERE videoid='3EDz-eR2XEE' 
  LIMIT 1

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
24	JDatabaseDriver->loadAssocList()	JROOT/components/com_youtubegallery/includes/misc.php:381
23	YouTubeGalleryMisc::getRawData()	JROOT/components/com_youtubegallery/includes/misc.php:1401
22	YouTubeGalleryMisc->RefreshVideoData()	JROOT/components/com_youtubegallery/includes/layoutrenderer.php:1023
21	YoutubeGalleryLayoutRenderer->ClassicNavTable()	JROOT/components/com_youtubegallery/includes/layoutrenderer.php:183
20	YoutubeGalleryLayoutRenderer->getValue()	JROOT/components/com_youtubegallery/includes/layoutrenderer.php:447
19	YoutubeGalleryLayoutRenderer->render()	JROOT/components/com_youtubegallery/includes/render.php:179
18	YouTubeGalleryRenderer->render()	JROOT/plugins/content/youtubegallery/youtubegallery.php:224
17	plgContentYoutubeGallery::getYoutubeGallery()	JROOT/plugins/content/youtubegallery/youtubegallery.php:78
16	plgContentYoutubeGallery::plgYoutubeGallery()	JROOT/plugins/content/youtubegallery/youtubegallery.php:39
15	plgContentYoutubeGallery->onContentPrepare()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:106
11	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
9	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
8	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
7	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
6	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
5	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
4	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

Query Time: 0.28 ms After last query: 0.14 ms Query memory: 0.031 MB Memory before query: 20.018 MB Rows returned: 1

Duplicate queries: #51

SELECT rawdata 
  FROM n7kfz_youtubegallery_videos 
  WHERE videoid='I5ceUPEAxT0' 
  LIMIT 1

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
24	JDatabase->query()	JROOT/components/com_youtubegallery/includes/misc.php:379
23	YouTubeGalleryMisc::getRawData()	JROOT/components/com_youtubegallery/includes/misc.php:1401
22	YouTubeGalleryMisc->RefreshVideoData()	JROOT/components/com_youtubegallery/includes/layoutrenderer.php:1023
21	YoutubeGalleryLayoutRenderer->ClassicNavTable()	JROOT/components/com_youtubegallery/includes/layoutrenderer.php:183
20	YoutubeGalleryLayoutRenderer->getValue()	JROOT/components/com_youtubegallery/includes/layoutrenderer.php:447
19	YoutubeGalleryLayoutRenderer->render()	JROOT/components/com_youtubegallery/includes/render.php:179
18	YouTubeGalleryRenderer->render()	JROOT/plugins/content/youtubegallery/youtubegallery.php:224
17	plgContentYoutubeGallery::getYoutubeGallery()	JROOT/plugins/content/youtubegallery/youtubegallery.php:78
16	plgContentYoutubeGallery::plgYoutubeGallery()	JROOT/plugins/content/youtubegallery/youtubegallery.php:39
15	plgContentYoutubeGallery->onContentPrepare()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:106
11	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
9	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
8	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
7	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
6	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
5	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
4	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

Query Time: 0.28 ms After last query: 0.08 ms Query memory: 0.031 MB Memory before query: 20.049 MB Rows returned: 1

Duplicate queries: #50

SELECT rawdata 
  FROM n7kfz_youtubegallery_videos 
  WHERE videoid='I5ceUPEAxT0' 
  LIMIT 1

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
24	JDatabaseDriver->loadAssocList()	JROOT/components/com_youtubegallery/includes/misc.php:381
23	YouTubeGalleryMisc::getRawData()	JROOT/components/com_youtubegallery/includes/misc.php:1401
22	YouTubeGalleryMisc->RefreshVideoData()	JROOT/components/com_youtubegallery/includes/layoutrenderer.php:1023
21	YoutubeGalleryLayoutRenderer->ClassicNavTable()	JROOT/components/com_youtubegallery/includes/layoutrenderer.php:183
20	YoutubeGalleryLayoutRenderer->getValue()	JROOT/components/com_youtubegallery/includes/layoutrenderer.php:447
19	YoutubeGalleryLayoutRenderer->render()	JROOT/components/com_youtubegallery/includes/render.php:179
18	YouTubeGalleryRenderer->render()	JROOT/plugins/content/youtubegallery/youtubegallery.php:224
17	plgContentYoutubeGallery::getYoutubeGallery()	JROOT/plugins/content/youtubegallery/youtubegallery.php:78
16	plgContentYoutubeGallery::plgYoutubeGallery()	JROOT/plugins/content/youtubegallery/youtubegallery.php:39
15	plgContentYoutubeGallery->onContentPrepare()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:106
11	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
9	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
8	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
7	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
6	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
5	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
4	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

Query Time: 0.30 ms After last query: 0.20 ms Query memory: 0.031 MB Memory before query: 20.086 MB Rows returned: 1

Duplicate queries: #53 #54 #55

SELECT `value` 
  FROM n7kfz_youtubegallery_settings 
  WHERE `option`='allowsef' 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	n7kfz_youtubegallery_settings	const	PRIMARY	PRIMARY	152	const	1

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
executing	0.01 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
24	JDatabase->query()	JROOT/components/com_youtubegallery/includes/misc.php:1792
23	YouTubeGalleryMisc::getSettingValue()	JROOT/components/com_youtubegallery/includes/layoutrenderer.php:733
22	YoutubeGalleryLayoutRenderer::makeLink()	JROOT/components/com_youtubegallery/includes/layoutrenderer.php:1072
21	YoutubeGalleryLayoutRenderer->ClassicNavTable()	JROOT/components/com_youtubegallery/includes/layoutrenderer.php:183
20	YoutubeGalleryLayoutRenderer->getValue()	JROOT/components/com_youtubegallery/includes/layoutrenderer.php:447
19	YoutubeGalleryLayoutRenderer->render()	JROOT/components/com_youtubegallery/includes/render.php:179
18	YouTubeGalleryRenderer->render()	JROOT/plugins/content/youtubegallery/youtubegallery.php:224
17	plgContentYoutubeGallery::getYoutubeGallery()	JROOT/plugins/content/youtubegallery/youtubegallery.php:78
16	plgContentYoutubeGallery::plgYoutubeGallery()	JROOT/plugins/content/youtubegallery/youtubegallery.php:39
15	plgContentYoutubeGallery->onContentPrepare()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:106
11	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
9	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
8	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
7	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
6	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
5	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
4	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

Query Time: 0.29 ms After last query: 0.07 ms Query memory: 0.031 MB Memory before query: 20.116 MB Rows returned: 1

Duplicate queries: #52 #54 #55

SELECT `value` 
  FROM n7kfz_youtubegallery_settings 
  WHERE `option`='allowsef' 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	n7kfz_youtubegallery_settings	const	PRIMARY	PRIMARY	152	const	1

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
executing	0.01 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
24	JDatabaseDriver->loadAssocList()	JROOT/components/com_youtubegallery/includes/misc.php:1793
23	YouTubeGalleryMisc::getSettingValue()	JROOT/components/com_youtubegallery/includes/layoutrenderer.php:733
22	YoutubeGalleryLayoutRenderer::makeLink()	JROOT/components/com_youtubegallery/includes/layoutrenderer.php:1072
21	YoutubeGalleryLayoutRenderer->ClassicNavTable()	JROOT/components/com_youtubegallery/includes/layoutrenderer.php:183
20	YoutubeGalleryLayoutRenderer->getValue()	JROOT/components/com_youtubegallery/includes/layoutrenderer.php:447
19	YoutubeGalleryLayoutRenderer->render()	JROOT/components/com_youtubegallery/includes/render.php:179
18	YouTubeGalleryRenderer->render()	JROOT/plugins/content/youtubegallery/youtubegallery.php:224
17	plgContentYoutubeGallery::getYoutubeGallery()	JROOT/plugins/content/youtubegallery/youtubegallery.php:78
16	plgContentYoutubeGallery::plgYoutubeGallery()	JROOT/plugins/content/youtubegallery/youtubegallery.php:39
15	plgContentYoutubeGallery->onContentPrepare()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:106
11	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
9	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
8	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
7	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
6	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
5	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
4	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

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

Duplicate queries: #52 #53 #55

SELECT `value` 
  FROM n7kfz_youtubegallery_settings 
  WHERE `option`='allowsef' 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	n7kfz_youtubegallery_settings	const	PRIMARY	PRIMARY	152	const	1

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
executing	0.01 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
24	JDatabase->query()	JROOT/components/com_youtubegallery/includes/misc.php:1792
23	YouTubeGalleryMisc::getSettingValue()	JROOT/components/com_youtubegallery/includes/layoutrenderer.php:733
22	YoutubeGalleryLayoutRenderer::makeLink()	JROOT/components/com_youtubegallery/includes/layoutrenderer.php:1072
21	YoutubeGalleryLayoutRenderer->ClassicNavTable()	JROOT/components/com_youtubegallery/includes/layoutrenderer.php:183
20	YoutubeGalleryLayoutRenderer->getValue()	JROOT/components/com_youtubegallery/includes/layoutrenderer.php:447
19	YoutubeGalleryLayoutRenderer->render()	JROOT/components/com_youtubegallery/includes/render.php:179
18	YouTubeGalleryRenderer->render()	JROOT/plugins/content/youtubegallery/youtubegallery.php:224
17	plgContentYoutubeGallery::getYoutubeGallery()	JROOT/plugins/content/youtubegallery/youtubegallery.php:78
16	plgContentYoutubeGallery::plgYoutubeGallery()	JROOT/plugins/content/youtubegallery/youtubegallery.php:39
15	plgContentYoutubeGallery->onContentPrepare()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:106
11	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
9	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
8	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
7	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
6	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
5	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
4	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

Query Time: 0.29 ms After last query: 0.08 ms Query memory: 0.031 MB Memory before query: 20.180 MB Rows returned: 1

Duplicate queries: #52 #53 #54

SELECT `value` 
  FROM n7kfz_youtubegallery_settings 
  WHERE `option`='allowsef' 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	n7kfz_youtubegallery_settings	const	PRIMARY	PRIMARY	152	const	1

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
executing	0.01 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
24	JDatabaseDriver->loadAssocList()	JROOT/components/com_youtubegallery/includes/misc.php:1793
23	YouTubeGalleryMisc::getSettingValue()	JROOT/components/com_youtubegallery/includes/layoutrenderer.php:733
22	YoutubeGalleryLayoutRenderer::makeLink()	JROOT/components/com_youtubegallery/includes/layoutrenderer.php:1072
21	YoutubeGalleryLayoutRenderer->ClassicNavTable()	JROOT/components/com_youtubegallery/includes/layoutrenderer.php:183
20	YoutubeGalleryLayoutRenderer->getValue()	JROOT/components/com_youtubegallery/includes/layoutrenderer.php:447
19	YoutubeGalleryLayoutRenderer->render()	JROOT/components/com_youtubegallery/includes/render.php:179
18	YouTubeGalleryRenderer->render()	JROOT/plugins/content/youtubegallery/youtubegallery.php:224
17	plgContentYoutubeGallery::getYoutubeGallery()	JROOT/plugins/content/youtubegallery/youtubegallery.php:78
16	plgContentYoutubeGallery::plgYoutubeGallery()	JROOT/plugins/content/youtubegallery/youtubegallery.php:39
15	plgContentYoutubeGallery->onContentPrepare()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:106
11	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
10	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
9	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
8	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
7	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
6	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
5	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
4	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

Query Time: 0.44 ms After last query: 9.38 ms Query memory: 0.016 MB Memory before query: 20.409 MB Rows returned: 1

SELECT language,id

  FROM `n7kfz_menu`

  WHERE home = 1 
  AND published = 1 
  AND client_id = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	n7kfz_menu	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	110	Using where

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.20 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/multilang.php:121
10	JLanguageMultilang::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:697
9	PlgSystemLanguageFilter->onAfterDispatch()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
4	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

Query Time: 0.49 ms After last query: 1.56 ms Query memory: 0.020 MB Memory before query: 20.494 MB Rows returned: 0

SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`

  FROM `n7kfz_categories` AS `c`

  INNER JOIN `n7kfz_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_categories.item'

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

  INNER JOIN `n7kfz_categories` AS `c2` 
  ON a2.id = c2.`id` 
  AND c2.extension = 'com_content'

  WHERE c.id = 2 
  AND c.extension = 'com_content'

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
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.08 ms
preparing	0.01 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/associations.php:101
14	JLanguageAssociations::getAssociations()	JROOT/administrator/components/com_categories/helpers/categories.php:102
13	CategoriesHelper::getAssociations()	JROOT/administrator/components/com_categories/helpers/association.php:43
12	CategoryHelperAssociation::getCategoryAssociations()	JROOT/components/com_content/helpers/association.php:58
11	ContentHelperAssociation::getAssociations()	Same as call in the line below.
10	call_user_func()	JROOT/plugins/system/languagefilter/languagefilter.php:729
9	PlgSystemLanguageFilter->onAfterDispatch()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
4	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

Query Time: 0.93 ms After last query: 10.35 ms Query memory: 0.019 MB Memory before query: 20.902 MB Rows returned: 1

SELECT SUM(visits)

  FROM n7kfz_zt_visitor_counter

  WHERE timestamp BETWEEN UNIX_TIMESTAMP(DATE(NOW())) 
  AND UNIX_TIMESTAMP(DATE(NOW()) + INTERVAL 1 DAY)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	n7kfz_zt_visitor_counter	range	timestamp	timestamp	4	NULL	80	Using index condition

Profile

Status	Duration
starting	0.13 ms
checking permissions	0.04 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.04 ms
executing	0.01 ms
Sending data	0.26 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
13	JDatabaseDriver->loadResult()	JROOT/modules/mod_zt_visitor_counter/helper.php:32
12	modZTCounterHelper->getTodayVisitors()	JROOT/modules/mod_zt_visitor_counter/mod_zt_visitor_counter.php:57
11	include JROOT/modules/mod_zt_visitor_counter/mod_zt_visitor_counter.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
10	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
9	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
8	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
7	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
6	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
5	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
4	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
3	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

Query Time: 0.69 ms After last query: 0.09 ms Query memory: 0.019 MB Memory before query: 20.921 MB Rows returned: 1

SELECT SUM(visits)

  FROM n7kfz_zt_visitor_counter

  WHERE timestamp BETWEEN UNIX_TIMESTAMP(DATE(NOW() - INTERVAL 1 DAY)) 
  AND UNIX_TIMESTAMP(DATE(NOW()))

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	n7kfz_zt_visitor_counter	range	timestamp	timestamp	4	NULL	106	Using index condition

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.26 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.02 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
13	JDatabaseDriver->loadResult()	JROOT/modules/mod_zt_visitor_counter/helper.php:48
12	modZTCounterHelper->getYesterdayVisitors()	JROOT/modules/mod_zt_visitor_counter/mod_zt_visitor_counter.php:65
11	include JROOT/modules/mod_zt_visitor_counter/mod_zt_visitor_counter.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
10	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
9	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
8	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
7	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
6	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
5	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
4	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
3	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

Query Time: 1.74 ms After last query: 0.14 ms Query memory: 0.019 MB Memory before query: 20.940 MB Rows returned: 1

Duplicate queries: #61

SELECT SUM(visits)

  FROM n7kfz_zt_visitor_counter

  WHERE timestamp BETWEEN 1755990000 
  AND 1756594800

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	n7kfz_zt_visitor_counter	range	timestamp	timestamp	4	NULL	518	Using index condition

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	1.36 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
13	JDatabaseDriver->loadResult()	JROOT/modules/mod_zt_visitor_counter/helper.php:103
12	modZTCounterHelper->getWeekVisitors()	JROOT/modules/mod_zt_visitor_counter/mod_zt_visitor_counter.php:74
11	include JROOT/modules/mod_zt_visitor_counter/mod_zt_visitor_counter.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
10	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
9	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
8	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
7	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
6	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
5	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
4	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
3	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

Query Time: 1.48 ms After last query: 0.14 ms Query memory: 0.019 MB Memory before query: 20.958 MB Rows returned: 1

Duplicate queries: #60

SELECT SUM(visits)

  FROM n7kfz_zt_visitor_counter

  WHERE timestamp BETWEEN 1755990000 
  AND 1756594800

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	n7kfz_zt_visitor_counter	range	timestamp	timestamp	4	NULL	518	Using index condition

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	1.12 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
13	JDatabaseDriver->loadResult()	JROOT/modules/mod_zt_visitor_counter/helper.php:130
12	modZTCounterHelper->getLastWeekVisitors()	JROOT/modules/mod_zt_visitor_counter/mod_zt_visitor_counter.php:84
11	include JROOT/modules/mod_zt_visitor_counter/mod_zt_visitor_counter.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
10	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
9	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
8	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
7	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
6	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
5	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
4	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
3	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

Query Time: 7.46 ms After last query: 0.08 ms Query memory: 0.019 MB Memory before query: 20.976 MB Rows returned: 1

SELECT SUM(visits)

  FROM n7kfz_zt_visitor_counter

  WHERE timestamp BETWEEN UNIX_TIMESTAMP(DATE_FORMAT(NOW(), '%Y-%m-01')) 
  AND UNIX_TIMESTAMP(DATE_FORMAT(NOW(),'%Y-%m-01') + INTERVAL 1 MONTH)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	n7kfz_zt_visitor_counter	range	timestamp	timestamp	4	NULL	3891	Using index condition

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	6.99 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
13	JDatabaseDriver->loadResult()	JROOT/modules/mod_zt_visitor_counter/helper.php:150
12	modZTCounterHelper->getMonthVisitors()	JROOT/modules/mod_zt_visitor_counter/mod_zt_visitor_counter.php:94
11	include JROOT/modules/mod_zt_visitor_counter/mod_zt_visitor_counter.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
10	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
9	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
8	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
7	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
6	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
5	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
4	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
3	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

Query Time: 7.10 ms After last query: 0.18 ms Query memory: 0.019 MB Memory before query: 20.995 MB Rows returned: 1

SELECT SUM(visits)

  FROM n7kfz_zt_visitor_counter

  WHERE timestamp BETWEEN UNIX_TIMESTAMP(DATE_FORMAT(NOW(), '%Y-%m-01') - INTERVAL 1 MONTH) 
  AND UNIX_TIMESTAMP(DATE_FORMAT(NOW(),'%Y-%m-01'))

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	n7kfz_zt_visitor_counter	range	timestamp	timestamp	4	NULL	5491	Using index condition

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.01 ms
statistics	0.10 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	6.68 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
13	JDatabaseDriver->loadResult()	JROOT/modules/mod_zt_visitor_counter/helper.php:169
12	modZTCounterHelper->getLastMonthVisitors()	JROOT/modules/mod_zt_visitor_counter/mod_zt_visitor_counter.php:103
11	include JROOT/modules/mod_zt_visitor_counter/mod_zt_visitor_counter.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
10	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
9	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
8	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
7	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
6	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
5	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
4	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
3	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

Query Time: 134.49 ms After last query: 0.23 ms Query memory: 0.019 MB Memory before query: 21.012 MB Rows returned: 1

SELECT SUM(visits)

  FROM n7kfz_zt_visitor_counter

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	134.17 ms
end	0.04 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
13	JDatabaseDriver->loadResult()	JROOT/modules/mod_zt_visitor_counter/helper.php:187
12	modZTCounterHelper->getTotalVisitors()	JROOT/modules/mod_zt_visitor_counter/mod_zt_visitor_counter.php:112
11	include JROOT/modules/mod_zt_visitor_counter/mod_zt_visitor_counter.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
10	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
9	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
8	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
7	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
6	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
5	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
4	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
3	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

Query Time: 0.41 ms After last query: 0.55 ms Query memory: 0.020 MB Memory before query: 21.034 MB Rows returned: 26

SELECT guest, client_id

  FROM n7kfz_session

  WHERE client_id = 0 
  AND `time` BETWEEN 1756624186 
  AND 1756625086

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	n7kfz_session	ALL	time	NO INDEX KEY COULD BE USED	NULL	NULL	26	Using where

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
13	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_zt_visitor_counter/helper.php:309
12	modZTCounterHelper->getOnline()	JROOT/modules/mod_zt_visitor_counter/mod_zt_visitor_counter.php:139
11	include JROOT/modules/mod_zt_visitor_counter/mod_zt_visitor_counter.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
10	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
9	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
8	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
7	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
6	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
5	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
4	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
3	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

Query Time: 1.93 ms After last query: 17.22 ms Query memory: 0.043 MB Memory before query: 21.575 MB Rows returned: 12

SELECT a.urls, a.images, a.fulltext, a.id, a.title, a.alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, LENGTH(a.fulltext) AS readmore,a.urls, a.images, a.fulltext, a.id, a.title, a.alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, LENGTH(a.fulltext) AS readmore,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 n7kfz_content AS a

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

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

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

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

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

  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM n7kfz_categories AS cat JOIN n7kfz_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,5) 
  AND c.access IN (1,1,5) 
  AND 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
  AND a.catid IN (2) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-08-31 07:24:45') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-08-31 07:24:45') 
  AND a.language in ('en-GB','*')

  ORDER BY a.created desc 
  LIMIT 12

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_language	idx_catid	4	const	51	Using where; Using filesort
1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	islamctr_db1.a.created_by	1	Using where
1	PRIMARY	parent	eq_ref	PRIMARY	PRIMARY	4	const	1	Using where
1	PRIMARY	v	eq_ref	PRIMARY	PRIMARY	4	islamctr_db1.a.id	1	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	const	4	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	idx_left_right	idx_left_right	8	NULL	23	Using where; Using index; Using join buffer (flat, BNL join)

Profile

Status	Duration
starting	0.29 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.14 ms
optimizing	0.07 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.03 ms
Creating tmp table	0.02 ms
Sorting result	0.02 ms
statistics	0.13 ms
preparing	0.01 ms
Unlocking tables	0.05 ms
Sorting result	0.02 ms
executing	0.02 ms
Sending data	0.06 ms
Creating sort index	0.25 ms
executing	0.01 ms
Sending data	0.07 ms
Creating sort index	0.02 ms
removing tmp table	0.01 ms
Creating sort index	0.21 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:310
16	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:183
15	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
14	ContentModelArticles->getItems()	JROOT/modules/mod_bt_contentslider/classes/content.php:159
13	BtContentDataSource->getList()	JROOT/modules/mod_bt_contentslider/helpers/helper.php:69
12	modBtContentSliderHelper::getList()	JROOT/modules/mod_bt_contentslider/mod_bt_contentslider.php:21
11	include JROOT/modules/mod_bt_contentslider/mod_bt_contentslider.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
10	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
9	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
8	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
7	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
6	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
5	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
4	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
3	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

Query Time: 0.69 ms After last query: 19.43 ms Query memory: 0.020 MB Memory before query: 22.030 MB Rows returned: 1

SELECT module, title

  FROM n7kfz_modules

  WHERE published=1 
  AND client_id=0 
  AND id='126'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	n7kfz_modules	const	PRIMARY,published	PRIMARY	4	const	1

Profile

Status	Duration
starting	0.11 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
init	0.04 ms
optimizing	0.04 ms
statistics	0.07 ms
preparing	0.02 ms
Unlocking tables	0.04 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
14	JDatabaseDriver->loadObject()	JROOT/modules/mod_popup_jt/helper.php:136
13	modPopupJTHelper::getModuleById()	JROOT/modules/mod_popup_jt/helper.php:121
12	modPopupJTHelper::getModulesEnable()	JROOT/modules/mod_popup_jt/mod_popup_jt.php:46
11	include JROOT/modules/mod_popup_jt/mod_popup_jt.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
10	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
9	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
8	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
7	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
6	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
5	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
4	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
3	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
2	JApplicationCms->execute()	JROOT/home.php:49
1	include JROOT/home.php	JROOT/index.php:27

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

45 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

6 × SELECT SUM(visits) 
  FROM n7kfz_zt_visitor_counter

6 × SELECT `value` 
  FROM n7kfz_youtubegallery_settings

5 × SELECT * 
  FROM n7kfz_youtubegallery_videos

4 × SELECT rawdata 
  FROM n7kfz_youtubegallery_videos

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

2 × SELECT * 
  FROM n7kfz_youtubegallery_videolists

2 × SELECT videoid 
  FROM n7kfz_youtubegallery_videos

2 × SELECT * 
  FROM n7kfz_youtubegallery_themes

2 × SELECT element 
  FROM n7kfz_extensions

1 × SELECT `m`.`tag_id`,`t`.* 
  FROM `n7kfz_contentitem_tag_map` AS m  
  INNER JOIN `n7kfz_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

1 × SELECT * 
  FROM n7kfz_jsn_uniform_config

1 × SELECT * 
  FROM n7kfz_jsn_uniform_forms

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM n7kfz_modules AS m 
  LEFT JOIN n7kfz_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN n7kfz_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT * 
  FROM n7kfz_jsn_uniform_form_pages

1 × SELECT module, title 
  FROM n7kfz_modules

1 × SELECT a.urls, a.images, a.fulltext, a.id, a.title, a.alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, LENGTH(a.fulltext) AS readmore,a.urls, a.images, a.fulltext, a.id, a.title, a.alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, LENGTH(a.fulltext) AS readmore,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 n7kfz_content AS a 
  LEFT JOIN n7kfz_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN n7kfz_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN n7kfz_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN n7kfz_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN n7kfz_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM n7kfz_categories AS cat JOIN n7kfz_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT SUM(visits) 
  FROM n7kfz_zt_visitor_counte

1 × SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id` 
  FROM `n7kfz_categories` AS `c` 
  INNER JOIN `n7kfz_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_categories.item' 
  INNER JOIN `n7kfz_associations` AS `a2` 
  ON a.key = a2.key 
  INNER JOIN `n7kfz_categories` AS `c2` 
  ON a2.id = c2.`id` 
  AND c2.extension = 'com_content'

1 × SELECT language,id 
  FROM `n7kfz_menu`

1 × SELECT COUNT(*) 
  FROM n7kfz_content AS a 
  LEFT JOIN n7kfz_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN n7kfz_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN n7kfz_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN n7kfz_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN n7kfz_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM n7kfz_categories AS cat JOIN n7kfz_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT guest, client_id 
  FROM n7kfz_session

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

```
1 × SELECT * 
  FROM n7kfz_languages
```

1 × SELECT params 
  FROM n7kfz_extensions

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 n7kfz_menu AS m 
  LEFT JOIN n7kfz_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT `enabled` 
  FROM `n7kfz_extensions`

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

1 × SELECT `session_id` 
  FROM `n7kfz_session`

1 × SELECT b.id 
  FROM n7kfz_usergroups AS a 
  LEFT JOIN n7kfz_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × SELECT id, rules 
  FROM `n7kfz_viewlevels

1 × SELECT id, home, template, s.params 
  FROM n7kfz_template_styles as s 
  LEFT JOIN n7kfz_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

1 × SELECT timestamp 
  FROM n7kfz_zt_visitor_counter

1 × SELECT a.id, a.name, a.rules 
  FROM n7kfz_assets AS a

1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems 
  FROM n7kfz_categories as c 
  LEFT JOIN  (SELECT cat.id as id 
  FROM n7kfz_categories AS cat JOIN n7kfz_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT `data` 
  FROM `n7kfz_session`

1 × SELECT a.id, a.parent_id 
  FROM n7kfz_assets AS a

1 × SELECT a.rules 
  FROM n7kfz_assets AS a

1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM n7kfz_categories as c 
  LEFT JOIN  (SELECT cat.id as id 
  FROM n7kfz_categories AS cat JOIN n7kfz_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

```
1 × SELECT * 
  FROM n7kfz_assets
```

1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN 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 n7kfz_content AS a 
  LEFT JOIN n7kfz_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN n7kfz_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN n7kfz_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN n7kfz_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN n7kfz_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM n7kfz_categories AS cat JOIN n7kfz_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

OTHER Tables:

1 × SHOW FULL COLUMNS 
  FROM `n7kfz_assets

1 × UPDATE n7kfz_zt_visitor_counter 
  SET visits=visits + 1, guests=guests + 1, useragent = 'other'

1 × UPDATE `n7kfz_extensions` 
  SET `params` = '{\"mediaversion\":\"8417364cafa4dc40524f59a6f7d30e6d\"}'

1 × INSERT INTO `n7kfz_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES  ('b0b97f8457cae5dc931755a53bf066e5', 0, 1, '1756625085', 0, ''

```
1 × DELETE  
  FROM `n7kfz_session`
```

Wakaf

IMSIC

News

Video

UniMAP CORPORATE VIDEO

FORUM: "BICARA HIDAYAH"

UCAPAN & PESANAN AIDILFITRI PIMPIN

BINGKISAN RAMADAN 2024 | 1445H

INTERNATIONAL PROGRAMME

Perlis Prayer Times

Visitor Counter

Reflection

Pengenalan Program Tahfiz TVET UniMAP

Objektif Program

Kelebihan Program Tahfiz TVET di UniMAP

Siapa Yang Layak Menyertai?

Harapan dan Visi

More Articles ...

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

67 Queries Logged 217.61 ms

23 duplicate found!

45 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: