INOE 2000 @ Science2Business: Partnerships for Innovation

Dr. Anca Nemuc and Dr. Cătălin Vițelaru, senior researchers at INOE 2000, represented the institute at the Science2Business event organised by Magurele Science Park and held at Stup – Bucharest.

The event brought together researchers, entrepreneurs, and communication experts to explore effective collaboration models between science and industry, aiming to strengthen the role of research as a driver of economic innovation.

During the session dedicated to applied research, INOE 2000 presented results with clear potential for technology transfer to the private sector, reaffirming its mission to bridge the gap between the laboratory and the market.

DESE 2025 in Romania

INOE 2000 is honoured to host the 18t^h edition of the International Conference on Developments in eSystems Engineering DeSE 2025. This prestigious event, coordinated in partnership with the eSystems Engineering Society, will take place at the Sheraton Bucharest Hotel from 10 to 12 November.

Researchers, practitioners, and students in fields such as AI, intelligent systems, eSystems, robotics, sensors, and related domains are invited to submit their original works. DeSE 2025 offers an ideal environment to share findings, forge collaborations, and advance technological innovation aligned with Industry 4.0.

For further information, including detailed programme tracks, paper submission guidelines, and registration, please visit the DeSE 2025 official website.

3 women entrepreneurs from Romania "3’pitch e-catalogue for Women Entrepreneurs!"

The Enterprise Europe Network Women Entrepreneurship Thematic Group has launched the 3^rd edition of the electronic catalogue dedicated to women entrepreneurs: “3’pitch e-catalogue for Women Entrepreneurs!”

INOE's Technology Transfer Center - CENTI Cluj-Napoca, member of the Enterprise Europe Network since 2008, advised and supported the participation of 3 women entrepreneurs from Romania in this edition: Hodaia Cosmetice SRL, Zahra Drops SRL, and Asociația Antreprenoare.

We invite you to explore these inspirational stories here.

iPhotoCult 1st Annual Consortium Meeting

INOE
CERTO

On 8^th of September INOE will host the 1^st Annual Consortium Meeting of HE project Intelligent advanced Photonics Tools for remote and/or on-site monitoring of Cultural Heritage monuments and artefacts - iPhotoCult.

The event will bring together experts, researchers, and professionals in heritage science and photonics to discuss the latest advancements in the field. Attendees will have the opportunity to engage in networking sessions, presentations, and discussions led by distinguished speakers from institutions such as FORTH, EAGLE, CNR, CARTIF, TCR, UNIWA, CCR, and LSA.

INOE @ International Invention and Entrepreneurship Salon – Chisinau 2025

INOE

Performanță de excepție la Salonul de Inventică și Antreprenoriat Chișinău 2025 desfăşurat în perioada 6–7 iunie 2025 la Universitatea Pedagogică de Stat „Ion Creangă” din Chișinău

INOE 2000 a prezentat 12 brevete de invenție și proiecte inovatoare, demonstrând încă o dată excelența în cercetare și inovare.

Rezultatele nu au întârziat să apară:

9 medalii de aur

3 medalii de argint

În semn de recunoaștere a valorii și originalității contribuțiilor, INOE 2000 a fost distins cu:

Premiul special din partea Universitatea Politehnica Timisoara

Premiul special al Salonului Internațional de Inventică și Antreprenoriat

Felicitări echipei INOE 2000 pentru rezultatele extraordinare și pentru contribuția adusă progresului științific și tehnologic!

ICIA contribuie la cercetarea sustenabilă a elementelor de pământuri rare

Institutul de Cercetări pentru Instrumentație Analitică - ICIA, filială a INOE 2000, continuă să își consolideze implicarea în valorificarea durabilă a mineralelor care conțin elemente de pământuri rare, în concordanță cu principiile economiei circulare și dezvoltării sustenabile.

Cea mai recenta contribuție în acest sens o reprezintă articolul ISI "Towards a European sustainable beneficiation of rare earth elements bearing minerals: a review", pe care vă invităm să îl citiți în Science of the Total Environment (IF 8.2).

Felicitări echipei ICIA pentru această contribuție remarcabilă la cercetarea europeană!

INOE la ICE-USV 2025

În perioada 23 – 25 mai 2025, la Suceava, România, s-a desfășurat The IX^th International Fair of Innovation and Creative Education for Youth (ICE-USV) – un eveniment de referință dedicat inovației și educației creative pentru tineri. Cercetătorii INOE au obținut rezultate deosebite:

8 medalii de aur

5 medalii de argint

1 medalie de bronz

Marele Premiu oferit de Forumul Inventatorilor din România – o recunoaștere a excelenței și impactului proiectelor prezentate.

De asemenea, Inoe 2000 a primit Premii Speciale din partea:

Universității „Lucian Blaga” din Sibiu

Corneliu Group Association- Deva Romania

Salonului Internaţional al Inovării şi Cercetării Ştiinţifice Studenţeşti – ”Cadet INOVA’25”®, organizat de Academia Forţelor Terestre “Nicolae Bălcescu”.

Felicitări tuturor participanților, coordonatorilor și susținătorilor! Rezultatele voastre confirmă angajamentul INOE 2000 pentru inovație, excelență și un viitor mai bun!

Sărbători luminate!

Cu ocazia Sărbătorilor Pascale, vă dorim ca lumina și speranța Învierii Domnului să vă aducă liniște sufletească, sănătate, bucurii alături de cei dragi și împliniri în toate planurile.

Paște Fericit!

INOE 2000

Facultatea de Fizica de la A la Z

On April 4th, the National Institute for Research and Development for Optoelectronics attended Facultatea de Fizica de la A la Z, an event organized at the Faculty of Physics, University of Bucharest, to promote science among high school students.

The activity included interactive presentations, demonstration experiments and discussions with INOE researchers, thus strengthening the connection between education and research.

E-RIHS a devenit ERIC!

European Research Infrastructure for Heritage Science E-RIHS a devenit ERIC!

E-RIHS este acum European Research Infrastructure Consortium (ERIC), consolidându-și poziția de jucător cheie în știința patrimoniului, atât în Europa, cât și la nivel mondial.

De la sediul său central din Florența (Italia), E-RIHS coordonează activitățile operaționale dintre 11 membri fondatori – Cipru, Franța, Ungaria, Italia, Malta, Țările de Jos, Polonia, România, Slovenia, Spania și Regatul Unit al Marii Britanii și Irlandei de Nord – iar ICCROM se preconizează ca se va alătura în calitate de observator permanent. INOE este coordonatorul hub-ului românesc.

Conceput pentru a servi cercetătorii și profesioniștii, E-RIHS reunește organizații de cercetare, universități, centre de restaurare și instituții culturale într-o comunitate unică care permite accesul la facilități de ultimă oră, resurse și activități de formare la nivel înalt în toată Europa. Misiunea sa este de a promova o abordare integrată pentru a îmbunătăți înțelegerea, conservarea și aprecierea moștenirii noastre culturale comune.

Aflați mai multe aici: https://www.e-rihs.eu/e-rihs-becomes-a-european-research.../

#heritagescience #ERIHS #ERIHSbecomesERIC #ERIC

European Research Infrastructure METROFOOD-RI

ICIA

The project Consolidation of the integration of the Romanian node METROFOOD-RO into the European research infrastructure METROFOOD-RI (acronym METROFOOD-RO EVOLVE) was launched, representing a strategic approach to integrate the Romanian node METROFOOD-RO into the European research infrastructure METROFOOD-RI.

The project responds to the call PCIDIF PCIDIF_P1/OP1/RSO1.1/PCIDIF_A3 – Synergies with Horizon Europe actions within the Smart Growth, Digitization and Financial Instruments program.

The METROFOOD-RO EVOLVE project proposes the development and strengthening of research capacities and analytical infrastructure in the field of food safety and nutrition. For the implementation of the project and the achievement of all the proposed targets, a consortium consisting of Institutul Național de Cercetare-Dezvoltare pentru Bioresurse Alimentare - IBA București (conducător de proiect) şi partenerii INOE 2000 – Institutul Național de Cercetare-Dezvoltare pentru Optoelectronică; INCDTIM – Institutul Național de Cercetare-Dezvoltare pentru Tehnologii Izotopice și Moleculare; Universitatea de Științele Vieții "Regele Mihai I" din Timișoara; INMA – Institutul Național de Cercetare-Dezvoltare pentru Mașini și Instalații Destinate Agriculturii și Industriei Alimentare; USAMV București – Universitatea de Științe Agronomice și Medicină Veterinară din București; Universitatea "Dunărea de Jos" and Universitatea din București.

JOAM & OAM-RC 1-2 issues/ 2025

revista

We invite you to browse the first 2025 issues of The Journal of Optoelectronics and Advanced Materials and The Optoelectronics and Advanced Materials – Rapid Communications, edited by INOE Publishing House - Integra Natura Omnia Aeterna.

JOAM & OAM-RC 3-4 issues/ 2025

revista

We invite you to browse the latest issue of The Journal of Optoelectronics and Advanced Materials and The Optoelectronics and Advanced Materials – Rapid Communications, edited by INOE Publishing House - Integra Natura Omnia Aeterna.

LACONA XIV

LACONA
CERTO

We are honored to host The XIV^th edition of the LAsers in CONservation of Artworks - LACONA, between 09-12 September 2025, in Bucharest.

Abstract submissions are now OPEN!

Oral and poster presentations are expected on the following TOPICS:

Morphological, mechanical, and thermal diagnostics
Compositional diagnostics
Deterioration phenomena
Conservation-restoration technologies & methods
Integrated approaches and best practices in photonic conservation-restoration
Novel photonic techniques or processes of interest in diagnostics or conservation-restoration

Website: lacona14.eu

Facebook: @LACONA.INOE

Page 1 of 7

Joomla! Debug Console

Session

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

Profile Information

Time

Memory

Time: 9.62 ms / 9.62 ms Memory: 0.554 MB / 0.93 MB Application: afterLoad

Time: 204.45 ms / 214.07 ms Memory: 4.164 MB / 5.09 MB Application: afterInitialise

Time: 11.25 ms / 225.32 ms Memory: 1.276 MB / 6.37 MB Application: afterRoute

Time: 0.20 ms / 225.52 ms Memory: 0.021 MB / 6.39 MB Application: beforeRenderComponent com_k2

Time: 0.14 ms / 225.66 ms Memory: 0.027 MB / 6.42 MB Application: Before JAccess::preloadComponents (all components)

Time: 1.00 ms / 226.66 ms Memory: 0.053 MB / 6.47 MB Application: After JAccess::preloadComponents (all components)

Time: 0.03 ms / 226.68 ms Memory: 0.000 MB / 6.47 MB Application: Before JAccess::getAssetRules (id:774 name:com_k2)

Time: 0.29 ms / 226.98 ms Memory: 0.024 MB / 6.49 MB Application: After JAccess::getAssetRules (id:774 name:com_k2)

Time: 84.64 ms / 311.62 ms Memory: 3.784 MB / 10.28 MB Application: afterRenderComponent com_k2

Time: 3.78 ms / 315.40 ms Memory: 0.338 MB / 10.61 MB Application: afterDispatch

Time: 5.06 ms / 320.46 ms Memory: 0.195 MB / 10.81 MB Application: beforeRenderModule mod_custom (Footer (en))

Time: 0.45 ms / 320.92 ms Memory: 0.033 MB / 10.84 MB Application: afterRenderModule mod_custom (Footer (en))

Time: 0.05 ms / 320.97 ms Memory: 0.000 MB / 10.84 MB Application: beforeRenderModule mod_menu (Main Menu (EN))

Time: 1.97 ms / 322.94 ms Memory: 0.095 MB / 10.94 MB Application: afterRenderModule mod_menu (Main Menu (EN))

Time: 0.05 ms / 322.98 ms Memory: 0.000 MB / 10.93 MB Application: beforeRenderModule mod_languages (Language Switcher)

Time: 2.64 ms / 325.62 ms Memory: 0.082 MB / 11.02 MB Application: afterRenderModule mod_languages (Language Switcher)

Time: 0.05 ms / 325.67 ms Memory: 0.000 MB / 11.01 MB Application: beforeRenderModule mod_search (Search form)

Time: 0.59 ms / 326.26 ms Memory: 0.018 MB / 11.03 MB Application: afterRenderModule mod_search (Search form)

Time: 0.04 ms / 326.30 ms Memory: 0.000 MB / 11.03 MB Application: beforeRenderModule mod_custom (Top Info)

Time: 0.12 ms / 326.43 ms Memory: 0.003 MB / 11.03 MB Application: afterRenderModule mod_custom (Top Info)

Time: 17.81 ms / 344.23 ms Memory: 0.453 MB / 11.48 MB Application: afterRender

Database queries total: 207.90 ms

Memory Usage

Database Queries

68 Queries Logged 207.90 ms

Query Time: 0.55 ms Query memory: 0.003 MB Memory before query: 2.541 MB

DELETE 

  FROM `cf3ki_session`

  WHERE `time` < '1757186311'

Explain

EXPLAIN not possible on query: DELETE FROM `cf3ki_session` WHERE `time` < '1757186311'

Profile

Status	Duration
Starting	0.06 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 for update	0.08 ms
Updating	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.02 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.08 ms
Reset for next command	0.01 ms

Call Stack

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

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

Query Time: 0.68 ms After last query: 0.21 ms Query memory: 0.023 MB Memory before query: 2.555 MB Rows returned: 0

SELECT `data`

  FROM `cf3ki_session`

  WHERE `session_id` = 'anvmc5q4pkqce47bhrchfijkvn'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cf3ki_session	const	PRIMARY	PRIMARY	575	const	1

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.03 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.01 ms
Executing	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.08 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Same as call in the line below.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:82
10	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:648
9	JSession->_start()	JROOT/libraries/joomla/session/session.php:608
8	JSession->start()	JROOT/libraries/joomla/session/session.php:486
7	JSession->get()	JROOT/libraries/joomla/session/session.php:443
6	JSession->isNew()	JROOT/libraries/cms/application/cms.php:829
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:413
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:47

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

Query Time: 0.32 ms After last query: 0.78 ms Query memory: 0.019 MB Memory before query: 2.637 MB Rows returned: 0

SELECT `session_id`

  FROM `cf3ki_session`

  WHERE `session_id` = 'anvmc5q4pkqce47bhrchfijkvn' 
  LIMIT 1

Explain

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

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.03 ms
Reset for next command	0.00 ms

Call Stack

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

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

Query Time: 158.98 ms After last query: 0.08 ms Query memory: 0.003 MB Memory before query: 2.641 MB

INSERT INTO `cf3ki_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('anvmc5q4pkqce47bhrchfijkvn', 1, '1757187211', 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `cf3ki_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('anvmc5q4pkqce47bhrchfijkvn', 1, '1757187211', 0, '', 0)

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init for update	0.01 ms
Update	0.05 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	158.53 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.07 ms
Reset for next command	0.01 ms

Call Stack

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

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

Query Time: 1.07 ms After last query: 3.93 ms Query memory: 0.039 MB Memory before query: 2.811 MB Rows returned: 39

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

  FROM `cf3ki_extensions`

  WHERE `type` = 'component'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cf3ki_extensions	ref	extension	extension	62	const	39	Using index condition

Profile

Status	Duration
Starting	0.10 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.07 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.42 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.06 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/component/helper.php:447
8	JComponentHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:455
6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:111
4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:593
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.35 ms After last query: 1.58 ms Query memory: 0.021 MB Memory before query: 3.057 MB Rows returned: 3

SELECT id, rules

  FROM `cf3ki_viewlevels`

Explain

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

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.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:1061
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.36 ms After last query: 0.07 ms Query memory: 0.021 MB Memory before query: 3.069 MB Rows returned: 1

SELECT b.id

  FROM cf3ki_usergroups AS a

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

  WHERE a.id = 1

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	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	1	Using where; Using index

Profile

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:978
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:1093
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.83 ms After last query: 0.47 ms Query memory: 0.026 MB Memory before query: 3.131 MB Rows returned: 77

SELECT `folder` AS `type`,`element` AS `name`,`params`

  FROM cf3ki_extensions

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

  ORDER BY ordering

Explain

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

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.04 ms
Statistics	0.03 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.28 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.07 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:311
8	JPluginHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/plugin/helper.php:316
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.74 ms After last query: 10.60 ms Query memory: 0.021 MB Memory before query: 4.166 MB Rows returned: 2

SELECT *

  FROM cf3ki_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

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.04 ms
Optimizing	0.02 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.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.07 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:148
8	JLanguageHelper::getLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:98
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:683
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.74 ms After last query: 0.12 ms Query memory: 0.021 MB Memory before query: 4.174 MB Rows returned: 4

SELECT `element`,`name`,`client_id`,`extension_id`

  FROM `cf3ki_extensions`

  WHERE `type` = 'language' 
  AND `state` = 0 
  AND `enabled` = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cf3ki_extensions	ref	extension	extension	62	const	4	Using index condition; Using where

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.03 ms
Statistics	0.06 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:207
8	JLanguageHelper::getInstalledLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:109
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:683
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 1.45 ms After last query: 5.59 ms Query memory: 0.069 MB Memory before query: 4.867 MB Rows returned: 37

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

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

Profile

Status	Duration
Starting	0.10 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.05 ms
Optimizing	0.03 ms
Statistics	0.09 ms
Preparing	0.05 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.62 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:88
20	JMenuSite->{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
19	JCacheControllerCallback->get()	JROOT/libraries/cms/menu/site.php:96
18	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
17	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
16	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:129
15	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:444
14	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
13	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:59
12	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:198
11	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:549
10	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:402
9	JApplicationSite::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:130
8	PlgSystemLanguageFilter->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:684
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.74 ms After last query: 7.34 ms Query memory: 0.024 MB Memory before query: 5.984 MB Rows returned: 1

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

  FROM `cf3ki_extensions`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cf3ki_extensions	ref	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	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.03 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.06 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
17	JDatabaseDriver->loadObject()	JROOT/libraries/cms/library/helper.php:166
16	JLibraryHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
15	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:174
14	JLibraryHelper::loadLibrary()	JROOT/libraries/cms/library/helper.php:42
13	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:89
12	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:270
11	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
10	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
9	JFactory::getDocument()	JROOT/plugins/system/k2/k2.php:460
8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1155
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:50

[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.14 ms Query memory: 0.006 MB Memory before query: 5.977 MB

UPDATE `cf3ki_extensions`

  SET `params` = '{\"mediaversion\":\"b5da6a877533ec1b44bd7f5cf9473096\"}'

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

Explain

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

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 for update	0.09 ms
Updating	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.02 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.06 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:116
13	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:321
12	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:280
11	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
10	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
9	JFactory::getDocument()	JROOT/plugins/system/k2/k2.php:460
8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1155
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.66 ms After last query: 2.61 ms Query memory: 0.022 MB Memory before query: 6.363 MB Rows returned: 10

SELECT id, home, template, s.params

  FROM cf3ki_template_styles as s

  LEFT JOIN cf3ki_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	13	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	website3.s.template,const	1	Using index condition; 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.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.09 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:485
10	JApplicationSite->getTemplate()	JROOT/administrator/components/com_k2/helpers/html.php:290
9	K2HelperHTML::loadHeadIncludes()	JROOT/plugins/system/k2/k2.php:478
8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1155
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.86 ms After last query: 0.63 ms Query memory: 0.025 MB Memory before query: 6.422 MB Rows returned: 39

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `cf3ki_assets`

  WHERE `name` IN ('com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_contactmap','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_flexicontact','com_installer','com_jcrawler','com_joomlaupdate','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_portfoliogallery','com_postinstall','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper') OR `parent_id` = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cf3ki_assets	index_merge	idx_asset_name,idx_parent_id	idx_asset_name,idx_parent_id	152,4	NULL	40	Using sort_union(idx_asset_name,idx_parent_id); Using where

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.00 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.09 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.21 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.06 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:427
11	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:211
10	JAccess::preload()	JROOT/libraries/joomla/access/access.php:529
9	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
8	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
7	JUser->authorise()	JROOT/components/com_k2/k2.php:16
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 1.04 ms After last query: 7.35 ms Query memory: 0.023 MB Memory before query: 7.404 MB Rows returned: 15

SELECT id 
  FROM cf3ki_k2_categories 
  WHERE published=1 
  AND trash=0 
  AND access IN(1,1)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cf3ki_k2_categories	ref	category,published,access,trash	category	8	const,const,const	15	Using index

Profile

Status	Duration
Starting	0.14 ms
checking permissions	0.07 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.04 ms
Statistics	0.12 ms
Preparing	0.05 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.09 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
13	JDatabaseDriver->loadColumn()	JROOT/components/com_k2/helpers/permissions.php:274
12	K2HelperPermissions::canAddItem()	JROOT/components/com_k2/views/itemlist/view.html.php:29
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.61 ms After last query: 0.49 ms Query memory: 0.023 MB Memory before query: 7.442 MB Rows returned: 0

SELECT id
						
  FROM cf3ki_k2_categories
						
  WHERE parent IN (12,13,14)
						
  AND id NOT IN (12,13,14) 
								
  AND published=1
								
  AND trash=0 
  AND access IN(1,1) 
  AND language IN('en-GB', '*')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cf3ki_k2_categories	range\|filter	PRIMARY,category,parent,published,access,trash,language	parent\|language	5\|21	NULL	3 (40%)	Using index condition; Using where; Using rowid filter

Profile

Status	Duration
Starting	0.05 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.02 ms
Statistics	0.08 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
14	JDatabaseDriver->loadColumn()	JROOT/components/com_k2/models/itemlist.php:648
13	K2ModelItemlist->getCategoryTree()	JROOT/components/com_k2/models/itemlist.php:263
12	K2ModelItemlist->getData()	JROOT/components/com_k2/views/itemlist/view.html.php:391
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 2.51 ms After last query: 0.21 ms Query memory: 0.175 MB Memory before query: 7.453 MB Rows returned: 14

SELECT i.*, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams 
  FROM cf3ki_k2_items as i RIGHT JOIN cf3ki_k2_categories AS c 
  ON c.id = i.catid 
  WHERE i.published = 1 
  AND i.access IN(1,1) 
  AND i.trash = 0 
  AND c.published = 1 
  AND c.access IN(1,1) 
  AND c.trash = 0 
  AND c.language IN ('en-GB','*')
						
  AND i.language IN ('en-GB','*') 
  AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-09-06 19:33:31' ) 
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-09-06 19:33:31' ) 
  AND c.id IN (12,13,14) 
  ORDER BY i.publish_up DESC 
  LIMIT 0, 14

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	range\|filter	PRIMARY,category,published,access,trash,language	published\|trash	6\|6	NULL	3 (20%)	Using index condition; Using where; Using temporary; Using filesort; Using rowid filter
1	SIMPLE	i	ref	item,catid,language	catid	4	website3.c.id	6	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.06 ms
Optimizing	0.04 ms
Statistics	0.15 ms
Preparing	0.04 ms
Creating tmp table	0.05 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	1.06 ms
Creating sort index	0.52 ms
Removing tmp table	0.09 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/itemlist.php:360
12	K2ModelItemlist->getData()	JROOT/components/com_k2/views/itemlist/view.html.php:391
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:50

[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.31 ms Query memory: 0.022 MB Memory before query: 7.615 MB Rows returned: 1

SELECT COUNT(*) 
  FROM cf3ki_k2_items as i RIGHT JOIN cf3ki_k2_categories c 
  ON c.id = i.catid 
  WHERE i.published = 1 
  AND i.access IN(1,1) 
  AND i.trash = 0 
  AND c.published = 1 
  AND c.access IN(1,1) 
  AND c.trash = 0 
  AND c.language IN ('en-GB','*')
						
  AND i.language IN ('en-GB','*') 
  AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-09-06 19:33:31' ) 
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-09-06 19:33:31' ) 
  AND c.id IN (12,13,14)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	range\|filter	PRIMARY,category,published,access,trash,language	published\|trash	6\|6	NULL	3 (20%)	Using index condition; Using where; Using rowid filter
1	SIMPLE	i	ref	item,catid,language	catid	4	website3.c.id	6	Using index condition; Using where

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.10 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.24 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
13	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/itemlist.php:598
12	K2ModelItemlist->getTotal()	JROOT/components/com_k2/views/itemlist/view.html.php:415
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.79 ms After last query: 1.71 ms Query memory: 0.027 MB Memory before query: 7.734 MB Rows returned: 14

SHOW FULL COLUMNS 
  FROM `cf3ki_k2_categories`

Explain

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

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
closing tables	0.00 ms
checking permissions	0.00 ms
Opening tables	0.17 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Filling schema table	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
checking permissions	0.06 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.08 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.04 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
15	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
14	JTable->__construct()	JROOT/administrator/components/com_k2/tables/k2category.php:36
13	TableK2Category->__construct()	JROOT/libraries/joomla/table/table.php:311
12	JTable::getInstance()	JROOT/components/com_k2/views/itemlist/view.html.php:460
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:50

[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.56 ms Query memory: 0.024 MB Memory before query: 7.786 MB Rows returned: 1

SELECT * 
  FROM cf3ki_k2_categories 
  WHERE id = '12'

Explain

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

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
16	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_k2/tables/k2category.php:67
15	TableK2Category->load()	JROOT/components/com_k2/models/item.php:73
14	K2ModelItem->prepareItem()	JROOT/libraries/joomla/cache/controller/callback.php:169
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:41
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/itemlist/view.html.php:462
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.50 ms After last query: 1.13 ms Query memory: 0.024 MB Memory before query: 7.966 MB Rows returned: 1

SELECT * 
  FROM cf3ki_k2_categories 
  WHERE id = '10'

Explain

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

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.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.07 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
16	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_k2/tables/k2category.php:67
15	TableK2Category->load()	JROOT/components/com_k2/models/item.php:94
14	K2ModelItem->prepareItem()	JROOT/libraries/joomla/cache/controller/callback.php:169
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:41
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/itemlist/view.html.php:462
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.46 ms After last query: 0.17 ms Query memory: 0.024 MB Memory before query: 7.987 MB Rows returned: 0

SELECT tag.*
			
  FROM cf3ki_k2_tags AS tag
			JOIN cf3ki_k2_tags_xref AS xref 
  ON tag.id = xref.tagID
			
  WHERE tag.published=1
			
  AND xref.itemID = 150 
  ORDER BY xref.id ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xref	ref	tagID,itemID	itemID	4	const	1	Using where
1	SIMPLE	tag	eq_ref	PRIMARY,published	PRIMARY	4	website3.xref.tagID	1	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.07 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1387
15	K2ModelItem->getItemTags()	JROOT/components/com_k2/models/item.php:107
14	K2ModelItem->prepareItem()	JROOT/libraries/joomla/cache/controller/callback.php:169
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:41
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/itemlist/view.html.php:462
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.45 ms After last query: 0.13 ms Query memory: 0.024 MB Memory before query: 7.997 MB Rows returned: 1

SELECT COUNT(*) 
  FROM cf3ki_k2_comments 
  WHERE itemID=150 
  AND published=1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cf3ki_k2_comments	ref	itemID,published,latestComments,countComments	countComments	8	const,const	1	Using index

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.06 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
16	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1723
15	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:273
14	K2ModelItem->prepareItem()	JROOT/libraries/joomla/cache/controller/callback.php:169
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:41
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/itemlist/view.html.php:462
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 2.06 ms After last query: 7.48 ms Query memory: 0.026 MB Memory before query: 9.057 MB Rows returned: 0

SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state

  FROM cf3ki_fields AS a

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

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

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

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

  LEFT JOIN cf3ki_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `cf3ki_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_k2.itemlist' 
  AND (fc.category_id IS NULL OR fc.category_id IN (12,0)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; Using filesort
1	SIMPLE	l	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where; Using join buffer (flat, BNL join)
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	website3.a.checked_out	1
1	SIMPLE	ag	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	website3.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	website3.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	website3.a.id	1	Using where; Using index

Profile

Status	Duration
Starting	0.19 ms
checking permissions	0.01 ms
Opening tables	0.09 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.09 ms
Optimizing	0.07 ms
Statistics	0.14 ms
Preparing	0.08 ms
Creating tmp table	0.08 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.44 ms
Creating sort index	0.05 ms
Removing tmp table	0.11 ms
Creating sort index	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.09 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
19	JModelLegacy->_getList()	JROOT/administrator/components/com_fields/models/fields.php:326
18	FieldsModelFields->_getList()	JROOT/libraries/legacy/model/list.php:186
17	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
16	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
15	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
13	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:737
12	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/itemlist/view.html.php:473
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.78 ms After last query: 3.03 ms Query memory: 0.024 MB Memory before query: 9.351 MB Rows returned: 1

SELECT * 
  FROM cf3ki_k2_categories 
  WHERE id = '13'

Explain

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

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.07 ms
Statistics	0.06 ms
Preparing	0.05 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.11 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
16	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_k2/tables/k2category.php:67
15	TableK2Category->load()	JROOT/components/com_k2/models/item.php:73
14	K2ModelItem->prepareItem()	JROOT/libraries/joomla/cache/controller/callback.php:169
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:41
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/itemlist/view.html.php:462
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.75 ms After last query: 0.60 ms Query memory: 0.024 MB Memory before query: 9.421 MB Rows returned: 0

SELECT tag.*
			
  FROM cf3ki_k2_tags AS tag
			JOIN cf3ki_k2_tags_xref AS xref 
  ON tag.id = xref.tagID
			
  WHERE tag.published=1
			
  AND xref.itemID = 149 
  ORDER BY xref.id ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xref	ref	tagID,itemID	itemID	4	const	1	Using where
1	SIMPLE	tag	eq_ref	PRIMARY,published	PRIMARY	4	website3.xref.tagID	1	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.04 ms
Optimizing	0.03 ms
Statistics	0.10 ms
Preparing	0.05 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.07 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1387
15	K2ModelItem->getItemTags()	JROOT/components/com_k2/models/item.php:107
14	K2ModelItem->prepareItem()	JROOT/libraries/joomla/cache/controller/callback.php:169
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:41
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/itemlist/view.html.php:462
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.65 ms After last query: 0.16 ms Query memory: 0.024 MB Memory before query: 9.430 MB Rows returned: 1

SELECT COUNT(*) 
  FROM cf3ki_k2_comments 
  WHERE itemID=149 
  AND published=1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cf3ki_k2_comments	ref	itemID,published,latestComments,countComments	countComments	8	const,const	1	Using index

Profile

Status	Duration
Starting	0.10 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.11 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.06 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
16	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1723
15	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:273
14	K2ModelItem->prepareItem()	JROOT/libraries/joomla/cache/controller/callback.php:169
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:41
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/itemlist/view.html.php:462
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.94 ms After last query: 0.77 ms Query memory: 0.025 MB Memory before query: 9.409 MB Rows returned: 0

SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state

  FROM cf3ki_fields AS a

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

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

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

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

  LEFT JOIN cf3ki_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `cf3ki_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_k2.itemlist' 
  AND (fc.category_id IS NULL OR fc.category_id IN (13,0)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; Using filesort
1	SIMPLE	l	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where; Using join buffer (flat, BNL join)
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	website3.a.checked_out	1
1	SIMPLE	ag	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	website3.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	website3.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	website3.a.id	1	Using where; Using index

Profile

Status	Duration
Starting	0.09 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.05 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.03 ms
Creating tmp table	0.04 ms
Sorting result	0.02 ms
Executing	0.00 ms
Sending data	0.24 ms
Creating sort index	0.02 ms
Removing tmp table	0.06 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
19	JModelLegacy->_getList()	JROOT/administrator/components/com_fields/models/fields.php:326
18	FieldsModelFields->_getList()	JROOT/libraries/legacy/model/list.php:186
17	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
16	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
15	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
13	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:737
12	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/itemlist/view.html.php:473
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.59 ms After last query: 1.02 ms Query memory: 0.024 MB Memory before query: 9.493 MB Rows returned: 3

SELECT tag.*
			
  FROM cf3ki_k2_tags AS tag
			JOIN cf3ki_k2_tags_xref AS xref 
  ON tag.id = xref.tagID
			
  WHERE tag.published=1
			
  AND xref.itemID = 148 
  ORDER BY xref.id ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xref	ref	tagID,itemID	itemID	4	const	3	Using where
1	SIMPLE	tag	eq_ref	PRIMARY,published	PRIMARY	4	website3.xref.tagID	1	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.02 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1387
15	K2ModelItem->getItemTags()	JROOT/components/com_k2/models/item.php:107
14	K2ModelItem->prepareItem()	JROOT/libraries/joomla/cache/controller/callback.php:169
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:41
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/itemlist/view.html.php:462
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.55 ms After last query: 0.51 ms Query memory: 0.024 MB Memory before query: 9.508 MB Rows returned: 1

SELECT COUNT(*) 
  FROM cf3ki_k2_comments 
  WHERE itemID=148 
  AND published=1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cf3ki_k2_comments	ref	itemID,published,latestComments,countComments	countComments	8	const,const	1	Using index

Profile

Status	Duration
Starting	0.03 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.02 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
16	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1723
15	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:273
14	K2ModelItem->prepareItem()	JROOT/libraries/joomla/cache/controller/callback.php:169
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:41
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/itemlist/view.html.php:462
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.54 ms After last query: 1.35 ms Query memory: 0.024 MB Memory before query: 9.551 MB Rows returned: 2

SELECT tag.*
			
  FROM cf3ki_k2_tags AS tag
			JOIN cf3ki_k2_tags_xref AS xref 
  ON tag.id = xref.tagID
			
  WHERE tag.published=1
			
  AND xref.itemID = 147 
  ORDER BY xref.id ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xref	ref	tagID,itemID	itemID	4	const	2	Using where
1	SIMPLE	tag	eq_ref	PRIMARY,published	PRIMARY	4	website3.xref.tagID	1	Using where

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.02 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1387
15	K2ModelItem->getItemTags()	JROOT/components/com_k2/models/item.php:107
14	K2ModelItem->prepareItem()	JROOT/libraries/joomla/cache/controller/callback.php:169
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:41
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/itemlist/view.html.php:462
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.50 ms After last query: 0.29 ms Query memory: 0.025 MB Memory before query: 9.570 MB Rows returned: 1

SELECT COUNT(*) 
  FROM cf3ki_k2_comments 
  WHERE itemID=147 
  AND published=1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cf3ki_k2_comments	ref	itemID,published,latestComments,countComments	countComments	8	const,const	1	Using index

Profile

Status	Duration
Starting	0.03 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.02 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
16	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1723
15	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:273
14	K2ModelItem->prepareItem()	JROOT/libraries/joomla/cache/controller/callback.php:169
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:41
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/itemlist/view.html.php:462
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.53 ms After last query: 1.34 ms Query memory: 0.024 MB Memory before query: 9.615 MB Rows returned: 1

SELECT tag.*
			
  FROM cf3ki_k2_tags AS tag
			JOIN cf3ki_k2_tags_xref AS xref 
  ON tag.id = xref.tagID
			
  WHERE tag.published=1
			
  AND xref.itemID = 146 
  ORDER BY xref.id ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xref	ref	tagID,itemID	itemID	4	const	1	Using where
1	SIMPLE	tag	eq_ref	PRIMARY,published	PRIMARY	4	website3.xref.tagID	1	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.06 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1387
15	K2ModelItem->getItemTags()	JROOT/components/com_k2/models/item.php:107
14	K2ModelItem->prepareItem()	JROOT/libraries/joomla/cache/controller/callback.php:169
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:41
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/itemlist/view.html.php:462
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.52 ms After last query: 0.14 ms Query memory: 0.024 MB Memory before query: 9.626 MB Rows returned: 1

SELECT COUNT(*) 
  FROM cf3ki_k2_comments 
  WHERE itemID=146 
  AND published=1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cf3ki_k2_comments	ref	itemID,published,latestComments,countComments	countComments	8	const,const	1	Using index

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.02 ms
Optimizing	0.02 ms
Statistics	0.08 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.03 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
16	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1723
15	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:273
14	K2ModelItem->prepareItem()	JROOT/libraries/joomla/cache/controller/callback.php:169
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:41
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/itemlist/view.html.php:462
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.63 ms After last query: 1.32 ms Query memory: 0.024 MB Memory before query: 9.670 MB Rows returned: 0

SELECT tag.*
			
  FROM cf3ki_k2_tags AS tag
			JOIN cf3ki_k2_tags_xref AS xref 
  ON tag.id = xref.tagID
			
  WHERE tag.published=1
			
  AND xref.itemID = 142 
  ORDER BY xref.id ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xref	ref	tagID,itemID	itemID	4	const	1	Using where
1	SIMPLE	tag	eq_ref	PRIMARY,published	PRIMARY	4	website3.xref.tagID	1	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.06 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.02 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1387
15	K2ModelItem->getItemTags()	JROOT/components/com_k2/models/item.php:107
14	K2ModelItem->prepareItem()	JROOT/libraries/joomla/cache/controller/callback.php:169
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:41
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/itemlist/view.html.php:462
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.45 ms After last query: 0.15 ms Query memory: 0.024 MB Memory before query: 9.680 MB Rows returned: 1

SELECT COUNT(*) 
  FROM cf3ki_k2_comments 
  WHERE itemID=142 
  AND published=1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cf3ki_k2_comments	ref	itemID,published,latestComments,countComments	countComments	8	const,const	1	Using index

Profile

Status	Duration
Starting	0.03 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.02 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
16	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1723
15	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:273
14	K2ModelItem->prepareItem()	JROOT/libraries/joomla/cache/controller/callback.php:169
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:41
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/itemlist/view.html.php:462
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.52 ms After last query: 1.43 ms Query memory: 0.024 MB Memory before query: 9.723 MB Rows returned: 0

SELECT tag.*
			
  FROM cf3ki_k2_tags AS tag
			JOIN cf3ki_k2_tags_xref AS xref 
  ON tag.id = xref.tagID
			
  WHERE tag.published=1
			
  AND xref.itemID = 141 
  ORDER BY xref.id ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xref	ref	tagID,itemID	itemID	4	const	1	Using where
1	SIMPLE	tag	eq_ref	PRIMARY,published	PRIMARY	4	website3.xref.tagID	1	Using where

Profile

Status	Duration
Starting	0.05 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.02 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1387
15	K2ModelItem->getItemTags()	JROOT/components/com_k2/models/item.php:107
14	K2ModelItem->prepareItem()	JROOT/libraries/joomla/cache/controller/callback.php:169
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:41
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/itemlist/view.html.php:462
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.53 ms After last query: 0.12 ms Query memory: 0.024 MB Memory before query: 9.733 MB Rows returned: 1

SELECT COUNT(*) 
  FROM cf3ki_k2_comments 
  WHERE itemID=141 
  AND published=1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cf3ki_k2_comments	ref	itemID,published,latestComments,countComments	countComments	8	const,const	1	Using index

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.04 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.10 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
16	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1723
15	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:273
14	K2ModelItem->prepareItem()	JROOT/libraries/joomla/cache/controller/callback.php:169
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:41
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/itemlist/view.html.php:462
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.67 ms After last query: 1.33 ms Query memory: 0.024 MB Memory before query: 9.776 MB Rows returned: 0

SELECT tag.*
			
  FROM cf3ki_k2_tags AS tag
			JOIN cf3ki_k2_tags_xref AS xref 
  ON tag.id = xref.tagID
			
  WHERE tag.published=1
			
  AND xref.itemID = 136 
  ORDER BY xref.id ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xref	ref	tagID,itemID	itemID	4	const	1	Using where
1	SIMPLE	tag	eq_ref	PRIMARY,published	PRIMARY	4	website3.xref.tagID	1	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.04 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.06 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1387
15	K2ModelItem->getItemTags()	JROOT/components/com_k2/models/item.php:107
14	K2ModelItem->prepareItem()	JROOT/libraries/joomla/cache/controller/callback.php:169
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:41
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/itemlist/view.html.php:462
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:50

[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.13 ms Query memory: 0.024 MB Memory before query: 9.785 MB Rows returned: 1

SELECT COUNT(*) 
  FROM cf3ki_k2_comments 
  WHERE itemID=136 
  AND published=1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cf3ki_k2_comments	ref	itemID,published,latestComments,countComments	countComments	8	const,const	1	Using index

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
16	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1723
15	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:273
14	K2ModelItem->prepareItem()	JROOT/libraries/joomla/cache/controller/callback.php:169
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:41
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/itemlist/view.html.php:462
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.55 ms After last query: 1.34 ms Query memory: 0.024 MB Memory before query: 9.828 MB Rows returned: 0

SELECT tag.*
			
  FROM cf3ki_k2_tags AS tag
			JOIN cf3ki_k2_tags_xref AS xref 
  ON tag.id = xref.tagID
			
  WHERE tag.published=1
			
  AND xref.itemID = 134 
  ORDER BY xref.id ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xref	ref	tagID,itemID	itemID	4	const	1	Using where
1	SIMPLE	tag	eq_ref	PRIMARY,published	PRIMARY	4	website3.xref.tagID	1	Using where

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.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1387
15	K2ModelItem->getItemTags()	JROOT/components/com_k2/models/item.php:107
14	K2ModelItem->prepareItem()	JROOT/libraries/joomla/cache/controller/callback.php:169
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:41
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/itemlist/view.html.php:462
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 1.01 ms After last query: 0.15 ms Query memory: 0.024 MB Memory before query: 9.839 MB Rows returned: 1

SELECT COUNT(*) 
  FROM cf3ki_k2_comments 
  WHERE itemID=134 
  AND published=1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cf3ki_k2_comments	ref	itemID,published,latestComments,countComments	countComments	8	const,const	1	Using index

Profile

Status	Duration
Starting	0.07 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.13 ms
Preparing	0.05 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.09 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
16	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1723
15	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:273
14	K2ModelItem->prepareItem()	JROOT/libraries/joomla/cache/controller/callback.php:169
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:41
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/itemlist/view.html.php:462
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 2.46 ms After last query: 1.74 ms Query memory: 0.025 MB Memory before query: 9.809 MB Rows returned: 0

SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state

  FROM cf3ki_fields AS a

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

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

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

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

  LEFT JOIN cf3ki_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `cf3ki_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_k2.itemlist' 
  AND (fc.category_id IS NULL OR fc.category_id IN (12,0)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1) 
  AND a.language in ('*','en-GB')

  ORDER BY a.ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context,idx_language	idx_state	1	const	1	Using where; Using temporary; Using filesort
1	SIMPLE	l	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where; Using join buffer (flat, BNL join)
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	website3.a.checked_out	1
1	SIMPLE	ag	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	website3.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	website3.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	website3.a.id	1	Using where; Using index

Profile

Status	Duration
Starting	0.27 ms
checking permissions	0.02 ms
Opening tables	0.06 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.13 ms
Optimizing	0.10 ms
Statistics	0.20 ms
Preparing	0.12 ms
Creating tmp table	0.14 ms
Sorting result	0.04 ms
Executing	0.01 ms
Sending data	0.54 ms
Creating sort index	0.05 ms
Removing tmp table	0.16 ms
Creating sort index	0.02 ms
End of update loop	0.04 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.12 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
19	JModelLegacy->_getList()	JROOT/administrator/components/com_fields/models/fields.php:326
18	FieldsModelFields->_getList()	JROOT/libraries/legacy/model/list.php:186
17	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
16	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
15	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
13	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:737
12	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/itemlist/view.html.php:473
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.50 ms After last query: 1.46 ms Query memory: 0.024 MB Memory before query: 9.893 MB Rows returned: 0

SELECT tag.*
			
  FROM cf3ki_k2_tags AS tag
			JOIN cf3ki_k2_tags_xref AS xref 
  ON tag.id = xref.tagID
			
  WHERE tag.published=1
			
  AND xref.itemID = 132 
  ORDER BY xref.id ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xref	ref	tagID,itemID	itemID	4	const	1	Using where
1	SIMPLE	tag	eq_ref	PRIMARY,published	PRIMARY	4	website3.xref.tagID	1	Using where

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.00 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.02 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1387
15	K2ModelItem->getItemTags()	JROOT/components/com_k2/models/item.php:107
14	K2ModelItem->prepareItem()	JROOT/libraries/joomla/cache/controller/callback.php:169
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:41
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/itemlist/view.html.php:462
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.46 ms After last query: 0.30 ms Query memory: 0.024 MB Memory before query: 9.903 MB Rows returned: 1

SELECT COUNT(*) 
  FROM cf3ki_k2_comments 
  WHERE itemID=132 
  AND published=1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cf3ki_k2_comments	ref	itemID,published,latestComments,countComments	countComments	8	const,const	1	Using index

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.03 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
16	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1723
15	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:273
14	K2ModelItem->prepareItem()	JROOT/libraries/joomla/cache/controller/callback.php:169
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:41
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/itemlist/view.html.php:462
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 1.91 ms After last query: 2.05 ms Query memory: 0.025 MB Memory before query: 9.873 MB Rows returned: 0

SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state

  FROM cf3ki_fields AS a

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

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

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

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

  LEFT JOIN cf3ki_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `cf3ki_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_k2.itemlist' 
  AND (fc.category_id IS NULL OR fc.category_id IN (13,0)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1) 
  AND a.language in ('*','en-GB')

  ORDER BY a.ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context,idx_language	idx_state	1	const	1	Using where; Using temporary; Using filesort
1	SIMPLE	l	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where; Using join buffer (flat, BNL join)
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	website3.a.checked_out	1
1	SIMPLE	ag	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	website3.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	website3.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	website3.a.id	1	Using where; Using index

Profile

Status	Duration
Starting	0.13 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.07 ms
Optimizing	0.09 ms
Statistics	0.17 ms
Preparing	0.09 ms
Creating tmp table	0.09 ms
Sorting result	0.04 ms
Executing	0.01 ms
Sending data	0.55 ms
Creating sort index	0.05 ms
Removing tmp table	0.14 ms
Creating sort index	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.11 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
19	JModelLegacy->_getList()	JROOT/administrator/components/com_fields/models/fields.php:326
18	FieldsModelFields->_getList()	JROOT/libraries/legacy/model/list.php:186
17	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
16	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
15	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
13	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:737
12	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/itemlist/view.html.php:473
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.39 ms After last query: 0.78 ms Query memory: 0.024 MB Memory before query: 9.957 MB Rows returned: 1

SELECT tag.*
			
  FROM cf3ki_k2_tags AS tag
			JOIN cf3ki_k2_tags_xref AS xref 
  ON tag.id = xref.tagID
			
  WHERE tag.published=1
			
  AND xref.itemID = 131 
  ORDER BY xref.id ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xref	ref	tagID,itemID	itemID	4	const	1	Using where
1	SIMPLE	tag	eq_ref	PRIMARY,published	PRIMARY	4	website3.xref.tagID	1	Using where

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1387
15	K2ModelItem->getItemTags()	JROOT/components/com_k2/models/item.php:107
14	K2ModelItem->prepareItem()	JROOT/libraries/joomla/cache/controller/callback.php:169
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:41
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/itemlist/view.html.php:462
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.48 ms After last query: 0.16 ms Query memory: 0.024 MB Memory before query: 9.968 MB Rows returned: 1

SELECT COUNT(*) 
  FROM cf3ki_k2_comments 
  WHERE itemID=131 
  AND published=1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cf3ki_k2_comments	ref	itemID,published,latestComments,countComments	countComments	8	const,const	1	Using index

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
16	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1723
15	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:273
14	K2ModelItem->prepareItem()	JROOT/libraries/joomla/cache/controller/callback.php:169
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:41
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/itemlist/view.html.php:462
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.60 ms After last query: 1.78 ms Query memory: 0.024 MB Memory before query: 10.011 MB Rows returned: 1

SELECT tag.*
			
  FROM cf3ki_k2_tags AS tag
			JOIN cf3ki_k2_tags_xref AS xref 
  ON tag.id = xref.tagID
			
  WHERE tag.published=1
			
  AND xref.itemID = 129 
  ORDER BY xref.id ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xref	ref	tagID,itemID	itemID	4	const	1	Using where
1	SIMPLE	tag	eq_ref	PRIMARY,published	PRIMARY	4	website3.xref.tagID	1	Using where

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.03 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1387
15	K2ModelItem->getItemTags()	JROOT/components/com_k2/models/item.php:107
14	K2ModelItem->prepareItem()	JROOT/libraries/joomla/cache/controller/callback.php:169
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:41
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/itemlist/view.html.php:462
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.48 ms After last query: 0.23 ms Query memory: 0.024 MB Memory before query: 10.023 MB Rows returned: 1

SELECT COUNT(*) 
  FROM cf3ki_k2_comments 
  WHERE itemID=129 
  AND published=1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cf3ki_k2_comments	ref	itemID,published,latestComments,countComments	countComments	8	const,const	1	Using index

Profile

Status	Duration
Starting	0.03 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.02 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
16	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1723
15	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:273
14	K2ModelItem->prepareItem()	JROOT/libraries/joomla/cache/controller/callback.php:169
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:41
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/itemlist/view.html.php:462
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.52 ms After last query: 1.41 ms Query memory: 0.024 MB Memory before query: 10.067 MB Rows returned: 1

SELECT tag.*
			
  FROM cf3ki_k2_tags AS tag
			JOIN cf3ki_k2_tags_xref AS xref 
  ON tag.id = xref.tagID
			
  WHERE tag.published=1
			
  AND xref.itemID = 151 
  ORDER BY xref.id ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xref	ref	tagID,itemID	itemID	4	const	1	Using where
1	SIMPLE	tag	eq_ref	PRIMARY,published	PRIMARY	4	website3.xref.tagID	1	Using where

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.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1387
15	K2ModelItem->getItemTags()	JROOT/components/com_k2/models/item.php:107
14	K2ModelItem->prepareItem()	JROOT/libraries/joomla/cache/controller/callback.php:169
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:41
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/itemlist/view.html.php:462
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.53 ms After last query: 0.16 ms Query memory: 0.024 MB Memory before query: 10.078 MB Rows returned: 1

SELECT COUNT(*) 
  FROM cf3ki_k2_comments 
  WHERE itemID=151 
  AND published=1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cf3ki_k2_comments	ref	itemID,published,latestComments,countComments	countComments	8	const,const	1	Using index

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
16	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1723
15	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:273
14	K2ModelItem->prepareItem()	JROOT/libraries/joomla/cache/controller/callback.php:169
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:41
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/itemlist/view.html.php:462
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.39 ms After last query: 1.36 ms Query memory: 0.024 MB Memory before query: 10.121 MB Rows returned: 2

SELECT tag.*
			
  FROM cf3ki_k2_tags AS tag
			JOIN cf3ki_k2_tags_xref AS xref 
  ON tag.id = xref.tagID
			
  WHERE tag.published=1
			
  AND xref.itemID = 104 
  ORDER BY xref.id ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xref	ref	tagID,itemID	itemID	4	const	2	Using where
1	SIMPLE	tag	eq_ref	PRIMARY,published	PRIMARY	4	website3.xref.tagID	1	Using where

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.05 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1387
15	K2ModelItem->getItemTags()	JROOT/components/com_k2/models/item.php:107
14	K2ModelItem->prepareItem()	JROOT/libraries/joomla/cache/controller/callback.php:169
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:41
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/itemlist/view.html.php:462
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.67 ms After last query: 0.24 ms Query memory: 0.024 MB Memory before query: 10.134 MB Rows returned: 1

SELECT COUNT(*) 
  FROM cf3ki_k2_comments 
  WHERE itemID=104 
  AND published=1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cf3ki_k2_comments	ref	itemID,published,latestComments,countComments	countComments	8	const,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.08 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.07 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
16	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1723
15	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:273
14	K2ModelItem->prepareItem()	JROOT/libraries/joomla/cache/controller/callback.php:169
13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:41
12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/itemlist/view.html.php:462
11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:50
8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.59 ms After last query: 8.71 ms Query memory: 0.021 MB Memory before query: 10.283 MB Rows returned: 3

SELECT language,id

  FROM `cf3ki_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	cf3ki_menu	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	102	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.04 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/multilang.php:106
8	JLanguageMultilang::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:718
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 1.49 ms After last query: 4.00 ms Query memory: 0.023 MB Memory before query: 10.771 MB Rows returned: 5

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

  FROM cf3ki_modules AS m

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

  LEFT JOIN cf3ki_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-09-06 19:33:31') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-09-06 19:33:31') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 343 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	ALL	PRIMARY,published,newsfeeds,idx_language	NO INDEX KEY COULD BE USED	NULL	NULL	88	Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	website3.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	303	website3.m.module,const	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.10 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
Optimizing	0.06 ms
Statistics	0.10 ms
Preparing	0.07 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.58 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.11 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:169
12	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:424
11	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:360
10	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
9	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:576
8	JDocumentHtml->countModules()	JROOT/templates/inoe/index.php:72
7	require JROOT/templates/inoe/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 1.12 ms After last query: 5.82 ms Query memory: 0.023 MB Memory before query: 11.019 MB Rows returned: 2

SELECT `c2`.`language`,`c2`.`id`

  FROM `cf3ki_menu` AS `c`

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

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

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

  WHERE c.id = 343

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1	Using index
1	SIMPLE	a	const	PRIMARY,idx_key	PRIMARY	156	const,const	1
1	SIMPLE	a2	ref	idx_key	idx_key	96	const	2	Using index
1	SIMPLE	c2	eq_ref	PRIMARY	PRIMARY	4	website3.a2.id	1

Profile

Status	Duration
Starting	0.12 ms
checking permissions	0.01 ms
Opening tables	0.09 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.05 ms
Statistics	0.16 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.05 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.08 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/associations.php:101
13	JLanguageAssociations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:314
12	MenusHelper::getAssociations()	JROOT/modules/mod_languages/helper.php:61
11	ModLanguagesHelper::getList()	JROOT/modules/mod_languages/mod_languages.php:17
10	include JROOT/modules/mod_languages/mod_languages.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.54 ms After last query: 11.57 ms Query memory: 0.024 MB Memory before query: 11.365 MB Rows returned: 1

SELECT `alias`

  FROM `cf3ki_content`

  WHERE id = '708'

Explain

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

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.02 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.06 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
16	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
15	ContentRouter->getArticleSegment()	JROOT/libraries/cms/component/router/view.php:117
14	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
13	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
12	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
11	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
10	JRouter->build()	JROOT/libraries/cms/router/site.php:149
9	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
8	JRoute::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1122
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 1.18 ms After last query: 0.21 ms Query memory: 0.026 MB Memory before query: 11.380 MB Rows returned: 3

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM cf3ki_categories as c

  LEFT JOIN cf3ki_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) 
  AND c.published = 1 
  AND s.id=43

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	NO INDEX KEY COULD BE USED	NULL	NULL	43	Using where; Using filesort

Profile

Status	Duration
Starting	0.15 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.08 ms
Optimizing	0.05 ms
Statistics	0.15 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.04 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.15 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.05 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.08 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
17	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
16	JCategories->get()	JROOT/components/com_content/router.php:72
15	ContentRouter->getCategorySegment()	JROOT/libraries/cms/component/router/view.php:117
14	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
13	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
12	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
11	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
10	JRouter->build()	JROOT/libraries/cms/router/site.php:149
9	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
8	JRoute::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1122
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.63 ms After last query: 0.14 ms Query memory: 0.023 MB Memory before query: 11.399 MB Rows returned: 1

SELECT alias

  FROM cf3ki_content

  WHERE id=708

Explain

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

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.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.07 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
15	JDatabaseDriver->loadResult()	JROOT/components/com_content/helpers/legacyrouter.php:140
14	ContentRouterRulesLegacy->build()	JROOT/libraries/cms/component/router/view.php:241
13	JComponentRouterView->build()	JROOT/libraries/cms/router/site.php:519
12	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
11	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
10	JRouter->build()	JROOT/libraries/cms/router/site.php:149
9	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
8	JRoute::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1122
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.40 ms After last query: 0.18 ms Query memory: 0.024 MB Memory before query: 11.477 MB Rows returned: 1

SELECT `alias`

  FROM `cf3ki_content`

  WHERE id = '709'

Explain

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

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
16	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
15	ContentRouter->getArticleSegment()	JROOT/libraries/cms/component/router/view.php:117
14	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
13	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
12	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
11	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
10	JRouter->build()	JROOT/libraries/cms/router/site.php:149
9	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
8	JRoute::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1122
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:50

[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.09 ms Query memory: 0.023 MB Memory before query: 11.484 MB Rows returned: 1

SELECT alias

  FROM cf3ki_content

  WHERE id=709

Explain

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

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.05 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
15	JDatabaseDriver->loadResult()	JROOT/components/com_content/helpers/legacyrouter.php:140
14	ContentRouterRulesLegacy->build()	JROOT/libraries/cms/component/router/view.php:241
13	JComponentRouterView->build()	JROOT/libraries/cms/router/site.php:519
12	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
11	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
10	JRouter->build()	JROOT/libraries/cms/router/site.php:149
9	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
8	JRoute::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1122
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:50

[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.23 ms Query memory: 0.024 MB Memory before query: 11.492 MB Rows returned: 1

SELECT `alias`

  FROM `cf3ki_content`

  WHERE id = '649'

Explain

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

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.03 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
16	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
15	ContentRouter->getArticleSegment()	JROOT/libraries/cms/component/router/view.php:117
14	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
13	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
12	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
11	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
10	JRouter->build()	JROOT/libraries/cms/router/site.php:149
9	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
8	JRoute::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1122
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:50

[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.13 ms Query memory: 0.031 MB Memory before query: 11.512 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 cf3ki_categories as c

  LEFT JOIN cf3ki_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) 
  AND c.published = 1 
  AND s.id=2

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	NO INDEX KEY COULD BE USED	NULL	NULL	43	Using where; Using filesort

Profile

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.06 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
17	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
16	JCategories->get()	JROOT/components/com_content/router.php:72
15	ContentRouter->getCategorySegment()	JROOT/libraries/cms/component/router/view.php:117
14	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
13	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
12	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
11	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
10	JRouter->build()	JROOT/libraries/cms/router/site.php:149
9	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
8	JRoute::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1122
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:50

[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.15 ms Query memory: 0.023 MB Memory before query: 11.528 MB Rows returned: 1

SELECT alias

  FROM cf3ki_content

  WHERE id=649

Explain

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

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.03 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
15	JDatabaseDriver->loadResult()	JROOT/components/com_content/helpers/legacyrouter.php:140
14	ContentRouterRulesLegacy->build()	JROOT/libraries/cms/component/router/view.php:241
13	JComponentRouterView->build()	JROOT/libraries/cms/router/site.php:519
12	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
11	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
10	JRouter->build()	JROOT/libraries/cms/router/site.php:149
9	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
8	JRoute::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1122
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.26 ms After last query: 0.24 ms Query memory: 0.024 MB Memory before query: 11.536 MB Rows returned: 1

SELECT `alias`

  FROM `cf3ki_content`

  WHERE id = '713'

Explain

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

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.03 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
16	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
15	ContentRouter->getArticleSegment()	JROOT/libraries/cms/component/router/view.php:117
14	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
13	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
12	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
11	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
10	JRouter->build()	JROOT/libraries/cms/router/site.php:149
9	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
8	JRoute::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1122
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.48 ms After last query: 0.09 ms Query memory: 0.024 MB Memory before query: 11.547 MB Rows returned: 0

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM cf3ki_categories as c

  LEFT JOIN cf3ki_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) 
  AND c.published = 1 
  AND s.id=713

  ORDER BY c.lft

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.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.06 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
17	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
16	JCategories->get()	JROOT/components/com_content/router.php:72
15	ContentRouter->getCategorySegment()	JROOT/libraries/cms/component/router/view.php:121
14	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
13	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
12	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
11	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
10	JRouter->build()	JROOT/libraries/cms/router/site.php:149
9	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
8	JRoute::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1122
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:50

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

29 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

14 × SELECT tag.*    
  FROM cf3ki_k2_tags AS tag    JOIN cf3ki_k2_tags_xref AS xref 
  ON tag.id = xref.tagID

14 × SELECT COUNT(*) 
  FROM cf3ki_k2_comments

4 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state 
  FROM cf3ki_fields AS a 
  LEFT JOIN `cf3ki_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN cf3ki_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN cf3ki_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN cf3ki_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN cf3ki_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `cf3ki_fields_categories` AS fc 
  ON fc.field_id = a.id

4 × SELECT `alias` 
  FROM `cf3ki_content`

3 × SELECT alias 
  FROM cf3ki_content

3 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM cf3ki_categories as c 
  LEFT JOIN cf3ki_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)

3 × SELECT * 
  FROM cf3ki_k2_categories

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

1 × SELECT COUNT(*) 
  FROM cf3ki_k2_items as i RIGHT JOIN cf3ki_k2_categories c 
  ON c.id = i.catid

1 × SELECT `c2`.`language`,`c2`.`id` 
  FROM `cf3ki_menu` AS `c` 
  INNER JOIN `cf3ki_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item' 
  INNER JOIN `cf3ki_associations` AS `a2` 
  ON a.key = a2.key 
  INNER JOIN `cf3ki_menu` AS `c2` 
  ON a2.id = c2.`id`

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

1 × SELECT language,id 
  FROM `cf3ki_menu`

1 × SELECT `data` 
  FROM `cf3ki_session`

1 × SELECT i.*, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams 
  FROM cf3ki_k2_items as i RIGHT JOIN cf3ki_k2_categories AS c 
  ON c.id = i.catid

1 × SELECT `session_id` 
  FROM `cf3ki_session`

1 × SELECT id 
  FROM cf3ki_k2_categories

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `cf3ki_assets`

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

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

1 × SELECT `element`,`name`,`client_id`,`extension_id` 
  FROM `cf3ki_extensions`

```
1 × SELECT * 
  FROM cf3ki_languages
```

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` 
  FROM cf3ki_extensions

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

1 × SELECT id, rules 
  FROM `cf3ki_viewlevels

1 × SELECT id       
  FROM cf3ki_k2_categories

OTHER Tables:

```
1 × DELETE  
  FROM `cf3ki_session`
```

1 × INSERT INTO `cf3ki_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('anvmc5q4pkqce47bhrchfijkvn', 1, '1757187211', 0, '', 0

1 × UPDATE `cf3ki_extensions` 
  SET `params` = '{\"mediaversion\":\"b5da6a877533ec1b44bd7f5cf9473096\"}'

1 × SHOW FULL COLUMNS 
  FROM `cf3ki_k2_categories