Foxyplast

Depunerile de calcar

Probleme cu depunerile de calcar

Apa pe care noi o utilizam in case cat si cea utilizata in mediul comercial si industrial, contine calcar dizolvat, constand din calciu si magneziu.
… Read More
Curatare si filtrare

Diferitele materiale componente si apa din instalatiile termice (clasice sau incalzire prin pardoseala), produc probleme prin coroziune (coroziunea, in mediile in care exista apa, este un proces electrochimic), depunere de
… Read More
FERNOX TF1 COMPACT

FERNOX TF1 COMPACT , filtru in linie de inalta performanta pentru instalatiile termice, foarte fiabil. Este ideal pentru instalatiile in care spatiul sau accesul este restrictionat. Filtru in linie de inalta
… Read More

› ‹

Servicii PrincipaleFoxy Plast

Foxy Plast este o companie de instalatii sanitare si termice (rezidentiale si comerciale) full-service, oferind un pachet de servicii totale (vanzare, proiectare, montaj instalatii termice, electrice, sanitare, apa-canal) sau asistenta programata pentru tot ceea ce domeniul instalatiilor acopera. De asemenea, oferim servicii de urgenta de 24 de ore pe zi, la sfarsit de saptamana, si de sarbatori.

Niciodata Despre noi ... Intotdeauna pentru tine!
• Oferim respect pentru clientii nostri
• Produse si servicii de calitate

Foxy Plast Servicii este o companie de distributie si montaj sisteme de alimentare cu apa, incalzire termica, cu un mare accent pe incazirea prin pardoseala. Ne mandrim cu servicii de inalta calitate, seriozitate si respect pentru clientii nostri.

Asiguram proiectarea instalatiilor de incalzire cu radiatoare sau a sistemelor de incalzire prin pardoseala, a instalatiilor de incalzire (racire) prin pereti sau tavane, a instalatiilor de alimentare cu apa. Va punem la dispozitie un sistem realizat la un standard inalt, conform cu cele mai moderne si eficiente sisteme de incalzire existente pe piata.

Scopul nostru este de a ramane in contact cu orice inovatie din aceasta ramura, astfel incat sa va putem oferi intotdeauna cele mai recente si actuale informatii si servicii. Pentru a ajuta la satisfacerea exigentelor clientilor, oferim acum servicii complete, sanitare si termice.
Contactati-ne pentru o oferta personalizata sau pentru a va putea raspunde la orice intrebari ati avea, specific cerintelor dumneavoastra.

Spalarea centralelor termice

Spalarea instalatiilor termice

Spalarea chimica a instalatiilor termice de incalzire

In general intr-un sistem de incalzire avem, centrala, boiler, pompa, supape, ventile, fitinguri, vas de expansiune, toate rezultand un amestec de metale. Incalzirea si amestecarea in sistem a continutului – apa,pasta de lipit si reziduri de flux creaza o reactie chimica care produce namol negru si gaz de hidrogen. Toate acestea vor reduce

Analiza apei din sistemul de incalzire
O valoare prea mare a oxigenului in sistemele de incalzire prin pardoseala devine un punct fragil, un fenomen de imbatranire, favorizat de temperaturi ridicate si de alti factori. Acest lucru inseamna ca… Read More
Apa urat mirositoare din boiler
Uneori, apa calda din boiler ne ofera surprize neplacute. Pe langa mirosul neplacut pe care il emana, poate dezvolta o bacterie, denumita Legionella Pneumophila. In general aceasta bacterie se poate Read More
Ce cauzeaza depunerea sarurilor de calcar?
Mineralele din rocile calcaroase sunt colectate de apa atunci cand trece prin pamant pana la straturile acvifere. Aceste minerale raman in apa si sunt antrenate in apa cu care se alimenteaza reteaua… Read More
Ce cauzeaza risipa de combustibil?
Depunerile de calcar pot reduce drastic capacitatea de a incalzi eficient. Problema este in cele mai multe cazuri la schimbatorul de caldura din centrala termica unde este cea mai mare temperatura din… Read More

› ‹

Sistemul de incalzire prin pardoseala, dupa ani de cercetare si teste, a devenit un sistem de incalzire practic si modern. Circulatia apei in scopul incalzirii sau racirii poate fi facuta si prin pereti, tavane sau placi de beton. Cand construim sau renovam locuinta, solutiile gasite trebuie sa ofere siguranta, comfort, rezistenta si costuri de exploatare reduse. Pentru aplicarea acestor criterii, venim in ajutorul dumneavoastra cu o experienta acumulata in cei 10 ani de montaj, de incalzirii prin pardoseala, oferind solutii inovatoare si de cea mai buna calitate.

Garantii

Garantia Foxy Plast +
Garantiile de montaj si calitate a materialelor, se vor regasii in contractele incheiate. Vor fi in conformitate cu instructiunile date… Read More
Garantia Uponor +
Sistemele Uponor beneficiaza de diferite certificari internationale,ajungand la 80 de certificari cum ar fi ABS Europe Ltd,etc. Acesta fiind unul Read More

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1558660074,
                "last": 1558660074,
                "now": 1558660074
            },
            "token": "ueI1FKXo9FLLg4hRlz84IcBhxdePFwQx"
        },
        "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
        },
        "gantry-current-template": "rt_spectral",
        "spectral-de0ea81297860b232287a6a9396e0dc5-name": null,
        "spectral-de0ea81297860b232287a6a9396e0dc5-logo-type": null,
        "spectral-de0ea81297860b232287a6a9396e0dc5-logo-custom-image": null,
        "spectral-de0ea81297860b232287a6a9396e0dc5-header-background": null,
        "spectral-de0ea81297860b232287a6a9396e0dc5-header-overlay": null,
        "spectral-de0ea81297860b232287a6a9396e0dc5-header-type": null,
        "spectral-de0ea81297860b232287a6a9396e0dc5-header-customheader-image": null,
        "spectral-de0ea81297860b232287a6a9396e0dc5-header-bg-position": null,
        "spectral-de0ea81297860b232287a6a9396e0dc5-main-body-style": null,
        "spectral-de0ea81297860b232287a6a9396e0dc5-main-accent": null,
        "spectral-de0ea81297860b232287a6a9396e0dc5-main-accent2": null,
        "spectral-de0ea81297860b232287a6a9396e0dc5-main-body-type": null,
        "spectral-de0ea81297860b232287a6a9396e0dc5-main-backgroundtop": null,
        "spectral-de0ea81297860b232287a6a9396e0dc5-main-backgroundmiddle": null,
        "spectral-de0ea81297860b232287a6a9396e0dc5-main-backgroundbottom": null,
        "spectral-de0ea81297860b232287a6a9396e0dc5-footer-background": null,
        "spectral-de0ea81297860b232287a6a9396e0dc5-footer-overlay": null,
        "spectral-de0ea81297860b232287a6a9396e0dc5-footer-type": null,
        "spectral-de0ea81297860b232287a6a9396e0dc5-footer-customfooter-image": null,
        "spectral-de0ea81297860b232287a6a9396e0dc5-footer-bg-position": null,
        "spectral-de0ea81297860b232287a6a9396e0dc5-font-family": null,
        "spectral-de0ea81297860b232287a6a9396e0dc5-font-size-is": null,
        "spectral-de0ea81297860b232287a6a9396e0dc5-menu-type": null,
        "spectral-de0ea81297860b232287a6a9396e0dc5-menu-numbering": null,
        "spectral-de0ea81297860b232287a6a9396e0dc5-layout-mode": null
    }
}

Profile Information

Time

Memory

Time: 24.40 ms / 24.40 ms Memory: 1.680 MB / 2.03 MB Application: afterLoad

Time: 97.13 ms / 121.52 ms Memory: 5.196 MB / 7.23 MB Application: afterInitialise

Time: 16.03 ms / 137.55 ms Memory: 0.917 MB / 8.14 MB Application: afterRoute

Time: 5.10 ms / 142.65 ms Memory: 0.244 MB / 8.39 MB Application: beforeRenderComponent com_content

Time: 5.51 ms / 148.16 ms Memory: 0.521 MB / 8.91 MB Application: Before Access::preloadComponents (all components)

Time: 1.11 ms / 149.27 ms Memory: 0.067 MB / 8.98 MB Application: After Access::preloadComponents (all components)

Time: 0.03 ms / 149.30 ms Memory: 0.000 MB / 8.97 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Time: 0.60 ms / 149.91 ms Memory: 0.026 MB / 9.00 MB Application: After Access::getAssetRules (id:8 name:com_content)

Time: 45.84 ms / 195.75 ms Memory: 3.674 MB / 12.67 MB Application: afterRenderComponent com_content

Time: 17.12 ms / 212.87 ms Memory: 0.493 MB / 13.17 MB Application: afterDispatch

Time: 10.01 ms / 222.88 ms Memory: 0.262 MB / 13.43 MB Application: beforeRenderModule mod_roknavmenu ()

Time: 13.48 ms / 236.36 ms Memory: 0.748 MB / 14.18 MB Application: afterRenderModule mod_roknavmenu ()

Time: 8.13 ms / 244.49 ms Memory: 0.023 MB / 14.20 MB Application: beforeRenderModule mod_custom (Image Copyright & Attribution)

Time: 0.48 ms / 244.97 ms Memory: 0.007 MB / 14.21 MB Application: afterRenderModule mod_custom (Image Copyright & Attribution)

Time: 0.06 ms / 245.03 ms Memory: 0.000 MB / 14.21 MB Application: beforeRenderModule mod_custom (FP Footer Contact Info)

Time: 0.25 ms / 245.28 ms Memory: 0.004 MB / 14.21 MB Application: afterRenderModule mod_custom (FP Footer Contact Info)

Time: 0.05 ms / 245.34 ms Memory: 0.001 MB / 14.21 MB Application: beforeRenderModule mod_custom (FP Footer Demo Info)

Time: 0.22 ms / 245.56 ms Memory: 0.005 MB / 14.21 MB Application: afterRenderModule mod_custom (FP Footer Demo Info)

Time: 0.03 ms / 245.59 ms Memory: 0.000 MB / 14.22 MB Application: beforeRenderModule mod_menu (FP Footer Menu)

Time: 2.55 ms / 248.14 ms Memory: 0.089 MB / 14.30 MB Application: afterRenderModule mod_menu (FP Footer Menu)

Time: 0.09 ms / 248.23 ms Memory: 0.012 MB / 14.32 MB Application: beforeRenderModule mod_roksprocket (Garantii )

Time: 19.27 ms / 267.50 ms Memory: 0.749 MB / 15.07 MB Application: afterRenderModule mod_roksprocket (Garantii )

Time: 0.14 ms / 267.64 ms Memory: 0.000 MB / 15.05 MB Application: beforeRenderModule mod_roksprocket (FP RokSprocket - Strips)

Time: 26.79 ms / 294.43 ms Memory: 0.675 MB / 15.72 MB Application: afterRenderModule mod_roksprocket (FP RokSprocket - Strips)

Time: 0.13 ms / 294.56 ms Memory: 0.000 MB / 15.45 MB Application: beforeRenderModule mod_custom (Spalarea chimica a instalatiilor termice de incalzire)

Time: 0.26 ms / 294.82 ms Memory: 0.004 MB / 15.46 MB Application: afterRenderModule mod_custom (Spalarea chimica a instalatiilor termice de incalzire)

Time: 0.09 ms / 294.91 ms Memory: 0.019 MB / 15.48 MB Application: beforeRenderModule mod_roksprocket (Servicii Principale[span class="rt-title-tag"]Foxy Plast[/span])

Time: 14.53 ms / 309.45 ms Memory: 0.257 MB / 15.73 MB Application: afterRenderModule mod_roksprocket (Servicii Principale[span class="rt-title-tag"]Foxy Plast[/span])

Time: 0.15 ms / 309.59 ms Memory: 0.000 MB / 15.68 MB Application: beforeRenderModule mod_roksprocket (FP RokSprocket - Showcase xxx)

Time: 13.26 ms / 322.86 ms Memory: 0.155 MB / 15.84 MB Application: afterRenderModule mod_roksprocket (FP RokSprocket - Showcase xxx)

Time: 6.04 ms / 328.90 ms Memory: 0.131 MB / 15.97 MB Application: afterRender

Database queries total: 40.19 ms

Memory Usage

Database Queries

48 Queries Logged 40.19 ms

7 duplicate found!

2 duplicates: #8 #9

2 duplicates: #13 #15

3 duplicates: #18 #29 #30

Query Time: 0.50 ms Query memory: 0.010 MB Memory before query: 3.570 MB Rows returned: 0

SELECT `data`

  FROM `yx5yl_session`

  WHERE `session_id` = 'mj4d4pvukol7bab8anrbjbn3u4'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	yx5yl_session	const	PRIMARY	PRIMARY	194	const	1

Profile

Status	Duration
starting	0.10 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
System lock	0.02 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.01 ms
executing	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
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:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[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.50 ms Query memory: 0.006 MB Memory before query: 3.676 MB Rows returned: 0

SELECT `session_id`

  FROM `yx5yl_session`

  WHERE `session_id` = 'mj4d4pvukol7bab8anrbjbn3u4' 
  LIMIT 1

Explain

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

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.02 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Query Time: 0.35 ms After last query: 0.09 ms Query memory: 0.005 MB Memory before query: 3.683 MB

INSERT INTO `yx5yl_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('mj4d4pvukol7bab8anrbjbn3u4', 1, 1558660074, 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `yx5yl_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('mj4d4pvukol7bab8anrbjbn3u4', 1, 1558660074, 0, '', 0)

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
System lock	0.02 ms
init	0.02 ms
update	0.08 ms
Waiting for query cache lock	0.01 ms
update	0.01 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Query Time: 1.08 ms After last query: 2.94 ms Query memory: 0.008 MB Memory before query: 3.960 MB Rows returned: 39

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

  FROM `yx5yl_extensions`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	yx5yl_extensions	ref	extension	extension	82	const	41	Using where

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
System lock	0.02 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.10 ms
preparing	0.04 ms
executing	0.01 ms
Sending data	0.54 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.42 ms After last query: 2.50 ms Query memory: 0.007 MB Memory before query: 4.160 MB Rows returned: 3

SELECT id, rules

  FROM `yx5yl_viewlevels`

Explain

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

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
System lock	0.02 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.43 ms After last query: 0.10 ms Query memory: 0.007 MB Memory before query: 4.174 MB Rows returned: 1

SELECT b.id

  FROM yx5yl_usergroups AS a

  LEFT JOIN yx5yl_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	index	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	8	NULL	9	Using index

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.02 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.71 ms After last query: 0.79 ms Query memory: 0.007 MB Memory before query: 4.241 MB Rows returned: 85

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

  FROM yx5yl_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	yx5yl_extensions	ref	extension	extension	82	const	114	Using where; Using filesort

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
System lock	0.02 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.01 ms
Sorting result	0.57 ms
Sending data	0.70 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.57 ms After last query: 11.14 ms Query memory: 0.009 MB Memory before query: 5.183 MB Rows returned: 1

Duplicate queries: #9

SELECT template

  FROM yx5yl_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

Explain

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

Profile

Status	Duration
starting	0.10 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
System lock	0.02 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.04 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.07 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
13	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:96
8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:54
7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.08 ms Query memory: 0.010 MB Memory before query: 5.194 MB Rows returned: 1

Duplicate queries: #8

SELECT template

  FROM yx5yl_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.04 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
14	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
13	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:96
8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:54
7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.49 ms After last query: 4.12 ms Query memory: 0.007 MB Memory before query: 5.440 MB Rows returned: 2

SELECT extension, file, type

  FROM yx5yl_rokcommon_configs

  ORDER BY priority

Explain

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

Profile

Status	Duration
starting	0.08 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
System lock	0.02 ms
init	0.03 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sorting result	0.06 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rokcommon/rokcommon.php:132
8	plgSystemRokCommon->processRegisteredConfigs()	JROOT/plugins/system/rokcommon/rokcommon.php:76
7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.58 ms After last query: 20.59 ms Query memory: 0.009 MB Memory before query: 6.611 MB Rows returned: 18

SHOW FULL COLUMNS 
  FROM `yx5yl_extensions`

Explain

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

Profile

Status	Duration
starting	0.08 ms
checking permissions	0.02 ms
Opening tables	1.42 ms
System lock	0.02 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.02 ms
Opening tables	0.03 ms
checking permissions	0.04 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.04 ms
Sending data	0.10 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.17 ms
closing tables	0.02 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
13	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
12	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
11	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Extension.php:32
10	Joomla\CMS\Table\Extension->__construct()	JROOT/libraries/src/Table/Table.php:312
9	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/roksprocket/roksprocket.php:45
8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.56 ms After last query: 0.69 ms Query memory: 0.007 MB Memory before query: 6.669 MB Rows returned: 1

SELECT `extension_id`

  FROM `yx5yl_extensions`

  WHERE type = 'component' 
  AND element = 'com_roksprocket'

Explain

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

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
System lock	0.02 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.16 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.07 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
10	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:124
9	Joomla\CMS\Table\Extension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:47
8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.10 ms Query memory: 0.007 MB Memory before query: 6.678 MB Rows returned: 1

Duplicate queries: #15

SELECT *

  FROM yx5yl_extensions

  WHERE `extension_id` = '10010'

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.02 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
9	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/roksprocket/roksprocket.php:54
8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

SELECT `extension_id`

  FROM `yx5yl_extensions`

  WHERE type = 'module' 
  AND element = 'mod_roksprocket'

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.05 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
10	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:124
9	Joomla\CMS\Table\Extension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:70
8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.31 ms After last query: 0.08 ms Query memory: 0.007 MB Memory before query: 6.692 MB Rows returned: 1

Duplicate queries: #13

SELECT *

  FROM yx5yl_extensions

  WHERE `extension_id` = '10010'

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
9	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/roksprocket/roksprocket.php:76
8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.79 ms After last query: 26.78 ms Query memory: 0.012 MB Memory before query: 7.407 MB Rows returned: 50

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

  LEFT JOIN yx5yl_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	77	Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	foxyplas_foxy.m.component_id	1

Profile

Status	Duration
starting	0.11 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
System lock	0.02 ms
init	0.05 ms
optimizing	0.03 ms
statistics	0.08 ms
preparing	0.04 ms
executing	0.01 ms
Sorting result	0.43 ms
Sending data	0.83 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1073
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.49 ms After last query: 9.68 ms Query memory: 0.010 MB Memory before query: 8.133 MB Rows returned: 9

SELECT * 
  FROM yx5yl_rokcandy 
  WHERE published=1

Explain

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

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
System lock	0.03 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.08 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:27
13	RokCandyHelper::getUserMacros()	Same as call in the line below.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
10	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:17
9	RokCandyHelper::getMacros()	JROOT/plugins/system/rokcandy/rokcandy.php:28
8	plgSystemRokCandy->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.60 ms After last query: 0.23 ms Query memory: 0.011 MB Memory before query: 8.148 MB Rows returned: 7

Duplicate queries: #29 #30

SELECT id, home, template, s.params

  FROM yx5yl_template_styles as s

  LEFT JOIN yx5yl_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	e	ref	element_clientid,element_folder_clientid,extension	extension	82	const	6	Using where
1	SIMPLE	s	ref	idx_template	idx_template	202	foxyplas_foxy.e.element	1	Using where

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.02 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.08 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.18 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
15	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:53
14	RokCandyHelper::readIniFile()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
11	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:44
10	RokCandyHelper::getTemplateOverrides()	JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:18
9	RokCandyHelper::getMacros()	JROOT/plugins/system/rokcandy/rokcandy.php:28
8	plgSystemRokCandy->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.34 ms After last query: 0.86 ms Query memory: 0.009 MB Memory before query: 8.179 MB Rows returned: 1

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

  FROM `yx5yl_extensions`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	yx5yl_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1129
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.33 ms After last query: 0.20 ms Query memory: 0.007 MB Memory before query: 8.172 MB

UPDATE `yx5yl_extensions`

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

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

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.06 ms
Updating	0.08 ms
end	0.02 ms
Waiting for query cache lock	0.01 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1129
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.48 ms After last query: 2.81 ms Query memory: 0.005 MB Memory before query: 8.355 MB Rows returned: 1

SELECT *

  FROM yx5yl_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

Status	Duration
starting	0.08 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
System lock	0.02 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.01 ms
Sorting result	0.05 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.87 ms After last query: 6.12 ms Query memory: 0.014 MB Memory before query: 8.913 MB Rows returned: 39

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

  FROM `yx5yl_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_gantry','com_installer','com_jce','com_jedchecker','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_rokcandy','com_roksprocket','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')

Explain

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

Profile

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.02 ms
init	0.06 ms
optimizing	0.01 ms
statistics	0.14 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.39 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
19	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
15	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/articles.php:115
14	ContentModelArticles->populateState()	JROOT/components/com_content/models/featured.php:44
13	ContentModelFeatured->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:55
10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.30 ms After last query: 1.80 ms Query memory: 0.011 MB Memory before query: 9.070 MB Rows returned: 1

SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,fp.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,
							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count

  FROM yx5yl_content AS a

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

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

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

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

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

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

  WHERE a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-05-24 01:07:54') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-05-24 01:07:54')

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fp	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using temporary; Using filesort
1	SIMPLE	a	eq_ref	PRIMARY,idx_access,idx_state,idx_catid	PRIMARY	4	foxyplas_foxy.fp.content_id	1	Using where
1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	foxyplas_foxy.a.catid	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	foxyplas_foxy.a.created_by	1
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	foxyplas_foxy.a.modified_by	1
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	foxyplas_foxy.c.parent_id	1
1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	foxyplas_foxy.a.id	1

Profile

Status	Duration
starting	0.20 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
System lock	0.02 ms
init	0.09 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.05 ms
Creating tmp table	1.17 ms
executing	0.01 ms
Copying to tmp table	0.14 ms
Sorting result	0.05 ms
Sending data	0.06 ms
end	0.01 ms
removing tmp table	0.13 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
15	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
14	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:125
12	ContentModelFeatured->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:56
10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.46 ms After last query: 2.37 ms Query memory: 0.010 MB Memory before query: 9.308 MB Rows returned: 0

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

  FROM `yx5yl_contentitem_tag_map` AS m 

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

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

Explain

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

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.12 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
14	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:125
12	ContentModelFeatured->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:56
10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.47 ms After last query: 1.16 ms Query memory: 0.010 MB Memory before query: 9.382 MB Rows returned: 1

SELECT COUNT(*)

  FROM yx5yl_content AS a

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

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

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

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

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

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

  WHERE a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-05-24 01:07:54') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-05-24 01:07:54')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fp	index	PRIMARY	PRIMARY	4	NULL	1	Using index
1	SIMPLE	a	eq_ref	PRIMARY,idx_access,idx_state,idx_catid	PRIMARY	4	foxyplas_foxy.fp.content_id	1	Using where
1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	foxyplas_foxy.a.catid	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	foxyplas_foxy.a.created_by	1	Using index
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	foxyplas_foxy.a.modified_by	1	Using index
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	foxyplas_foxy.c.parent_id	1	Using index
1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	foxyplas_foxy.a.id	1	Using index

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
System lock	0.02 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
15	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:340
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:282
13	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:232
12	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:57
10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.75 ms After last query: 5.60 ms Query memory: 0.014 MB Memory before query: 9.848 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 `yx5yl_categories` AS `s`

  INNER JOIN `yx5yl_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.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 = 15

  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	Using filesort
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	23	Using where

Profile

Status	Duration
starting	0.13 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
System lock	0.02 ms
init	0.05 ms
optimizing	0.03 ms
statistics	0.14 ms
preparing	0.03 ms
executing	0.01 ms
Sorting result	0.07 ms
Sending data	0.08 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
19	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
18	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:203
17	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
16	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:488
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:102
10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.57 ms After last query: 0.58 ms Query memory: 0.013 MB Memory before query: 9.897 MB Rows returned: 0

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

  FROM yx5yl_fields AS a

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

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

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

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

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

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

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (15,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 filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	foxyplas_foxy.a.language	1
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	foxyplas_foxy.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	foxyplas_foxy.a.access	1
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	foxyplas_foxy.a.created_user_id	1
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	foxyplas_foxy.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	foxyplas_foxy.a.id	1	Using where; Using index

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
System lock	0.02 ms
init	0.06 ms
optimizing	0.03 ms
statistics	0.06 ms
preparing	0.04 ms
executing	0.01 ms
Sorting result	0.03 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
16	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:488
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:102
10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.40 ms After last query: 12.42 ms Query memory: 0.013 MB Memory before query: 11.088 MB Rows returned: 9

SELECT id, home, template, params

  FROM yx5yl_template_styles

  WHERE client_id = 0

Explain

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

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.02 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.08 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/gantry/gantry.php:148
18	gantry_getAllTemplates()	JROOT/libraries/gantry/gantry.php:125
17	gantry_getTemplateById()	JROOT/libraries/gantry/gantry.php:206
16	gantry_getTemplateParams()	JROOT/libraries/gantry/gantry.php:264
15	gantry_setup()	JROOT/libraries/gantry/gantry.php:432
14	include JROOT/libraries/gantry/gantry.php	JROOT/templates/rt_spectral/html/com_content/featured/default.php:14
13	include JROOT/templates/rt_spectral/html/com_content/featured/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/featured/view.html.php:164
10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.55 ms After last query: 5.88 ms Query memory: 0.015 MB Memory before query: 12.046 MB Rows returned: 7

Duplicate queries: #18 #30

SELECT id, home, template, s.params

  FROM yx5yl_template_styles as s

  LEFT JOIN yx5yl_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	e	ref	element_clientid,element_folder_clientid,extension	extension	82	const	6	Using where
1	SIMPLE	s	ref	idx_template	idx_template	202	foxyplas_foxy.e.element	1	Using where

Profile

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
System lock	0.02 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.11 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/gantry/core/gantrytemplate.class.php:638
20	GantryTemplate::getAllTemplates()	JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:65
19	GantryMenuItemParamOverride::_populateSingleItem()	JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:36
18	GantryMenuItemParamOverride::populate()	JROOT/libraries/gantry/core/gantry.class.php:1843
17	Gantry->populateParams()	JROOT/libraries/gantry/core/gantry.class.php:392
16	Gantry->init()	JROOT/libraries/gantry/gantry.php:275
15	gantry_setup()	JROOT/libraries/gantry/gantry.php:432
14	include JROOT/libraries/gantry/gantry.php	JROOT/templates/rt_spectral/html/com_content/featured/default.php:14
13	include JROOT/templates/rt_spectral/html/com_content/featured/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/featured/view.html.php:164
10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.35 ms After last query: 0.51 ms Query memory: 0.015 MB Memory before query: 12.065 MB Rows returned: 7

Duplicate queries: #18 #29

SELECT id, home, template, s.params

  FROM yx5yl_template_styles as s

  LEFT JOIN yx5yl_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	e	ref	element_clientid,element_folder_clientid,extension	extension	82	const	6	Using where
1	SIMPLE	s	ref	idx_template	idx_template	202	foxyplas_foxy.e.element	1	Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/gantry/core/gantrytemplate.class.php:638
21	GantryTemplate::getAllTemplates()	JROOT/libraries/gantry/core/gantrytemplate.class.php:590
20	GantryTemplate::getTemplateParams()	JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:69
19	GantryMenuItemParamOverride::_populateSingleItem()	JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:36
18	GantryMenuItemParamOverride::populate()	JROOT/libraries/gantry/core/gantry.class.php:1843
17	Gantry->populateParams()	JROOT/libraries/gantry/core/gantry.class.php:392
16	Gantry->init()	JROOT/libraries/gantry/gantry.php:275
15	gantry_setup()	JROOT/libraries/gantry/gantry.php:432
14	include JROOT/libraries/gantry/gantry.php	JROOT/templates/rt_spectral/html/com_content/featured/default.php:14
13	include JROOT/templates/rt_spectral/html/com_content/featured/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/featured/view.html.php:164
10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.71 ms After last query: 34.10 ms Query memory: 0.011 MB Memory before query: 13.357 MB Rows returned: 11

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

  FROM yx5yl_modules AS m

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

  LEFT JOIN yx5yl_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 <= '2019-05-24 01:07:54') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-05-24 01:07:54') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 101 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

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

Profile

Status	Duration
starting	0.14 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
System lock	0.02 ms
init	0.06 ms
optimizing	0.03 ms
statistics	0.11 ms
preparing	0.06 ms
executing	0.01 ms
Sorting result	0.42 ms
Sending data	0.64 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	Same as call in the line below.
15	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
14	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
13	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
12	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
11	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
10	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/libraries/gantry/core/gantry.class.php:804
9	Gantry->getJoomlaModuleCount()	JROOT/libraries/gantry/core/gantry.class.php:757
8	Gantry->countModules()	JROOT/templates/rt_spectral/index.php:61
7	require JROOT/templates/rt_spectral/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.46 ms After last query: 9.08 ms Query memory: 0.012 MB Memory before query: 13.895 MB Rows returned: 1

SELECT ts.template

  FROM yx5yl_template_styles AS ts

  INNER JOIN yx5yl_menu AS m 
  ON ts.id=m.template_style_id

  WHERE m.id = 101 
  AND m.template_style_id != 0

Explain

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

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
System lock	0.02 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
17	JDatabaseDriver->loadColumn()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:101
16	RokNavMenu::getTemplates()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:74
15	RokNavMenu::loadCatalogs()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:25
14	RokNavMenu->__construct()	JROOT/modules/mod_roknavmenu/mod_roknavmenu.php:21
13	include JROOT/modules/mod_roknavmenu/mod_roknavmenu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
11	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/rt_spectral/features/dropdownmenu.php:56
10	GantryFeatureDropdownMenu->render()	JROOT/libraries/gantry/core/renderers/gantrymodulesrenderer.class.php:70
9	GantryModulesRenderer::display()	JROOT/libraries/gantry/core/gantry.class.php:867
8	Gantry->displayModules()	JROOT/templates/rt_spectral/index.php:69
7	require JROOT/templates/rt_spectral/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.53 ms After last query: 27.30 ms Query memory: 0.015 MB Memory before query: 14.702 MB Rows returned: 2

SELECT i.provider_id as id, i.
  order, i.params

  FROM yx5yl_roksprocket_items as i

  WHERE i.module_id = '195' 
  AND i.provider = 'simple'

  ORDER BY i.
  order

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	i	ref	idx_module,idx_module_order	idx_module_order	137	const	2	Using where

Profile

Status	Duration
starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
System lock	0.02 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.03 ms
executing	0.01 ms
Sorting result	0.01 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
20	JDatabaseDriver->loadObjectList()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple/Storage/Joomla.php:37
19	RokSprocket_Provider_Simple_Storage_Joomla->getItemsFromDB()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple/Storage/Abstract.php:50
18	RokSprocket_Provider_Simple_Storage_Abstract->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple.php:105
17	RokSprocket_Provider_Simple->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
16	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
15	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
14	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
13	ModRokSprocket->_realGetData()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
12	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
11	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
10	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.29 ms After last query: 1.93 ms Query memory: 0.014 MB Memory before query: 14.843 MB Rows returned: 2

SELECT i.provider_id as id, i.
  order, i.params

  FROM yx5yl_roksprocket_items as i

  WHERE i.module_id = '195' 
  AND i.provider = 'simple'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	i	ref	idx_module,idx_module_order	idx_module	137	const	2	Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
21	JDatabaseDriver->loadObjectList()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple/Storage/Joomla.php:59
20	RokSprocket_Provider_Simple_Storage_Joomla->mapPerItemData()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple/Storage/Joomla.php:40
19	RokSprocket_Provider_Simple_Storage_Joomla->getItemsFromDB()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple/Storage/Abstract.php:50
18	RokSprocket_Provider_Simple_Storage_Abstract->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple.php:105
17	RokSprocket_Provider_Simple->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
16	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
15	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
14	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
13	ModRokSprocket->_realGetData()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
12	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
11	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
10	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.79 ms After last query: 15.77 ms Query memory: 0.015 MB Memory before query: 15.387 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 `yx5yl_categories` AS `s`

  INNER JOIN `yx5yl_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.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 = 16

  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	Using filesort
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	23	Using where

Profile

Status	Duration
starting	0.15 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
System lock	0.02 ms
init	0.06 ms
optimizing	0.03 ms
statistics	0.16 ms
preparing	0.03 ms
executing	0.01 ms
Sorting result	0.07 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
21	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
20	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Joomla/Filter.php:134
19	RokSprocket_Provider_Joomla_Filter->category()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstractJoomlaPlatformFilter.php:120
18	RokSprocket_Provider_AbstractJoomlaPlatformFilter->process()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:46
17	RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
16	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
15	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
14	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
13	ModRokSprocket->_realGetData()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
12	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
11	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
10	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 4.27 ms After last query: 0.15 ms Query memory: 0.013 MB Memory before query: 15.406 MB Rows returned: 11

SELECT a.id, a.title, a.alias, a.introtext, a.`fulltext`, a.catid, a.state, a.access, a.created, a.created_by, a.created_by_alias, a.modified, a.featured, a.language, a.hits, a.publish_up, a.publish_down, a.images, a.urls, a.language, a.metakey, a.metadesc, a.metadata,c.title AS category_title, c.alias AS category_alias,ua.name AS author_name,um.name AS last_modified_by,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,vl.title AS access_title,l.title AS language_title

  FROM yx5yl_content as a

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

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

  LEFT JOIN yx5yl_users AS um 
  ON um.id = a.modified_by

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

  LEFT JOIN yx5yl_viewlevels AS vl 
  ON a.access = vl.id

  LEFT JOIN yx5yl_languages AS l 
  ON a.language = l.lang_code

  LEFT JOIN yx5yl_contentitem_tag_map AS ct 
  ON ct.content_item_id = a.id

  LEFT JOIN yx5yl_tags AS t 
  ON t.id = ct.tag_id

  WHERE ((a.access IN(1,1) 
  AND (a.state = 1 or a.state = 2) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-05-24 01:07:54') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-05-24 01:07:54') 
  AND (a.state != -2)) 
  AND a.catid IN (16))

  GROUP BY id

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	index_merge	idx_access,idx_state,idx_catid	idx_catid,idx_access	4,4	NULL	8	Using intersect(idx_catid,idx_access); Using where; Using temporary; Using filesort
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	foxyplas_foxy.a.created_by	1
1	SIMPLE	um	eq_ref	PRIMARY	PRIMARY	4	foxyplas_foxy.a.modified_by	1
1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	foxyplas_foxy.a.id	1
1	SIMPLE	vl	eq_ref	PRIMARY	PRIMARY	4	foxyplas_foxy.a.access	1
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	foxyplas_foxy.a.language	1
1	SIMPLE	ct	index	NULL	idx_core_content_id	4	NULL	21	Using index
1	SIMPLE	t	eq_ref	PRIMARY	PRIMARY	4	foxyplas_foxy.ct.tag_id	1	Using index

Profile

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
System lock	0.02 ms
init	0.06 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.05 ms
Creating tmp table	1.13 ms
executing	0.01 ms
Copying to tmp table	1.30 ms
Sorting result	0.13 ms
Sending data	0.43 ms
end	0.02 ms
removing tmp table	0.57 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.06 ms
freeing items	0.05 ms
logging slow query	0.02 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
18	JDatabaseDriver->loadObjectList()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:58
17	RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
16	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
15	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
14	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
13	ModRokSprocket->_realGetData()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
12	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
11	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
10	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.40 ms After last query: 1.69 ms Query memory: 0.014 MB Memory before query: 15.652 MB Rows returned: 0

SELECT ct.content_item_id as article_id, t.title as tag

  FROM yx5yl_contentitem_tag_map as ct

  LEFT JOIN yx5yl_tags AS t 
  ON t.id = ct.tag_id

  WHERE ct.content_item_id in (25,26,27,28,29,30,40,68,71,79,80)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ct	index	NULL	idx_core_content_id	4	NULL	21	Using where; Using index
1	SIMPLE	t	eq_ref	PRIMARY	PRIMARY	4	foxyplas_foxy.ct.tag_id	1

Profile

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
System lock	0.02 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
20	JDatabaseDriver->loadAssocList()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Joomla/TagMerge.php:26
19	RokSprocket_Provider_Joomla_TagMerge->populateTags()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Joomla.php:159
18	RokSprocket_Provider_Joomla->populateTags()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:62
17	RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
16	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
15	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
14	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
13	ModRokSprocket->_realGetData()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
12	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
11	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
10	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.43 ms After last query: 3.37 ms Query memory: 0.013 MB Memory before query: 15.695 MB Rows returned: 8

SELECT i.provider_id as id, i.
  order, i.params

  FROM yx5yl_roksprocket_items as i

  WHERE i.module_id = '194' 
  AND i.provider = 'joomla'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	i	ref	idx_module,idx_module_order	idx_module_order	137	const	8	Using where

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.02 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
19	JDatabaseDriver->loadObjectList()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:139
18	RokSprocket_Provider_AbstarctJoomlaBasedProvider->mapPerItemData()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:64
17	RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
16	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
15	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
14	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
13	ModRokSprocket->_realGetData()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
12	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
11	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
10	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.82 ms After last query: 11.53 ms Query memory: 0.015 MB Memory before query: 15.537 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 `yx5yl_categories` AS `s`

  INNER JOIN `yx5yl_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.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 = 17

  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	Using filesort
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	23	Using where

Profile

Status	Duration
starting	0.15 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
System lock	0.02 ms
init	0.06 ms
optimizing	0.03 ms
statistics	0.15 ms
preparing	0.03 ms
executing	0.01 ms
Sorting result	0.07 ms
Sending data	0.08 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.04 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
21	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
20	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Joomla/Filter.php:134
19	RokSprocket_Provider_Joomla_Filter->category()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstractJoomlaPlatformFilter.php:120
18	RokSprocket_Provider_AbstractJoomlaPlatformFilter->process()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:46
17	RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
16	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
15	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
14	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
13	ModRokSprocket->_realGetData()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
12	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
11	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
10	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.70 ms After last query: 0.15 ms Query memory: 0.013 MB Memory before query: 15.557 MB Rows returned: 4

SELECT a.id, a.title, a.alias, a.introtext, a.`fulltext`, a.catid, a.state, a.access, a.created, a.created_by, a.created_by_alias, a.modified, a.featured, a.language, a.hits, a.publish_up, a.publish_down, a.images, a.urls, a.language, a.metakey, a.metadesc, a.metadata,c.title AS category_title, c.alias AS category_alias,ua.name AS author_name,um.name AS last_modified_by,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,vl.title AS access_title,l.title AS language_title

  FROM yx5yl_content as a

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

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

  LEFT JOIN yx5yl_users AS um 
  ON um.id = a.modified_by

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

  LEFT JOIN yx5yl_viewlevels AS vl 
  ON a.access = vl.id

  LEFT JOIN yx5yl_languages AS l 
  ON a.language = l.lang_code

  LEFT JOIN yx5yl_contentitem_tag_map AS ct 
  ON ct.content_item_id = a.id

  LEFT JOIN yx5yl_tags AS t 
  ON t.id = ct.tag_id

  WHERE ((a.access IN(1,1) 
  AND (a.state = 1 or a.state = 2) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-05-24 01:07:54') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-05-24 01:07:54') 
  AND (a.state != -2)) 
  AND a.id IN (0)) OR ((a.access IN(1,1) 
  AND (a.state = 1 or a.state = 2) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-05-24 01:07:54') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-05-24 01:07:54') 
  AND (a.state != -2)) 
  AND a.catid IN (17))

  GROUP BY id

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	range	PRIMARY,idx_access,idx_state,idx_catid	idx_state	1	NULL	74	Using where; Using temporary; Using filesort
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	foxyplas_foxy.a.catid	1
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	foxyplas_foxy.a.created_by	1
1	SIMPLE	um	eq_ref	PRIMARY	PRIMARY	4	foxyplas_foxy.a.modified_by	1
1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	foxyplas_foxy.a.id	1
1	SIMPLE	vl	eq_ref	PRIMARY	PRIMARY	4	foxyplas_foxy.a.access	1
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	foxyplas_foxy.a.language	1
1	SIMPLE	ct	index	NULL	idx_core_content_id	4	NULL	21	Using index
1	SIMPLE	t	eq_ref	PRIMARY	PRIMARY	4	foxyplas_foxy.ct.tag_id	1	Using index

Profile

Status	Duration
starting	0.12 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
System lock	0.02 ms
init	0.07 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.04 ms
Creating tmp table	1.10 ms
executing	0.01 ms
Copying to tmp table	0.67 ms
Sorting result	0.04 ms
Sending data	0.09 ms
end	0.01 ms
removing tmp table	0.13 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.04 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
18	JDatabaseDriver->loadObjectList()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:58
17	RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
16	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
15	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
14	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
13	ModRokSprocket->_realGetData()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
12	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
11	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
10	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.31 ms After last query: 0.28 ms Query memory: 0.014 MB Memory before query: 15.602 MB Rows returned: 0

SELECT ct.content_item_id as article_id, t.title as tag

  FROM yx5yl_contentitem_tag_map as ct

  LEFT JOIN yx5yl_tags AS t 
  ON t.id = ct.tag_id

  WHERE ct.content_item_id in (32,34,35,36)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ct	index	NULL	idx_core_content_id	4	NULL	21	Using where; Using index
1	SIMPLE	t	eq_ref	PRIMARY	PRIMARY	4	foxyplas_foxy.ct.tag_id	1

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
20	JDatabaseDriver->loadAssocList()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Joomla/TagMerge.php:26
19	RokSprocket_Provider_Joomla_TagMerge->populateTags()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Joomla.php:159
18	RokSprocket_Provider_Joomla->populateTags()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:62
17	RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
16	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
15	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
14	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
13	ModRokSprocket->_realGetData()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
12	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
11	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
10	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.38 ms After last query: 1.22 ms Query memory: 0.013 MB Memory before query: 15.625 MB Rows returned: 4

SELECT i.provider_id as id, i.
  order, i.params

  FROM yx5yl_roksprocket_items as i

  WHERE i.module_id = '192' 
  AND i.provider = 'joomla'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	i	ref	idx_module,idx_module_order	idx_module	137	const	4	Using where

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.02 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
19	JDatabaseDriver->loadObjectList()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:139
18	RokSprocket_Provider_AbstarctJoomlaBasedProvider->mapPerItemData()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:64
17	RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
16	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
15	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
14	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
13	ModRokSprocket->_realGetData()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
12	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
11	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
10	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.80 ms After last query: 8.73 ms Query memory: 0.015 MB Memory before query: 15.733 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 `yx5yl_categories` AS `s`

  INNER JOIN `yx5yl_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.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 = 18

  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	Using filesort
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	23	Using where

Profile

Status	Duration
starting	0.14 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
System lock	0.02 ms
init	0.06 ms
optimizing	0.03 ms
statistics	0.14 ms
preparing	0.03 ms
executing	0.01 ms
Sorting result	0.07 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
21	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
20	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Joomla/Filter.php:134
19	RokSprocket_Provider_Joomla_Filter->category()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstractJoomlaPlatformFilter.php:120
18	RokSprocket_Provider_AbstractJoomlaPlatformFilter->process()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:46
17	RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
16	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
15	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
14	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
13	ModRokSprocket->_realGetData()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
12	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
11	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
10	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.56 ms After last query: 0.15 ms Query memory: 0.013 MB Memory before query: 15.754 MB Rows returned: 3

SELECT a.id, a.title, a.alias, a.introtext, a.`fulltext`, a.catid, a.state, a.access, a.created, a.created_by, a.created_by_alias, a.modified, a.featured, a.language, a.hits, a.publish_up, a.publish_down, a.images, a.urls, a.language, a.metakey, a.metadesc, a.metadata,c.title AS category_title, c.alias AS category_alias,ua.name AS author_name,um.name AS last_modified_by,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,vl.title AS access_title,l.title AS language_title

  FROM yx5yl_content as a

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

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

  LEFT JOIN yx5yl_users AS um 
  ON um.id = a.modified_by

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

  LEFT JOIN yx5yl_viewlevels AS vl 
  ON a.access = vl.id

  LEFT JOIN yx5yl_languages AS l 
  ON a.language = l.lang_code

  LEFT JOIN yx5yl_contentitem_tag_map AS ct 
  ON ct.content_item_id = a.id

  LEFT JOIN yx5yl_tags AS t 
  ON t.id = ct.tag_id

  LEFT 
  OUTER JOIN (select rsi.provider_id, rsi.
  order 
  from yx5yl_roksprocket_items as rsi 
  where module_id = 189) rsi 
  on a.id = rsi.provider_id

  WHERE ((a.access IN(1,1) 
  AND (a.state = 1 or a.state = 2) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-05-24 01:07:54') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-05-24 01:07:54') 
  AND (a.state != -2)) 
  AND a.catid IN (18))

  GROUP BY id

  ORDER BY IF(ISNULL(rsi.
  order),1,0),rsi.
  order

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	3	Using where; Using temporary; Using filesort
1	PRIMARY	c	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	foxyplas_foxy.a.created_by	1
1	PRIMARY	um	eq_ref	PRIMARY	PRIMARY	4	foxyplas_foxy.a.modified_by	1
1	PRIMARY	v	eq_ref	PRIMARY	PRIMARY	4	foxyplas_foxy.a.id	1
1	PRIMARY	vl	eq_ref	PRIMARY	PRIMARY	4	foxyplas_foxy.a.access	1
1	PRIMARY	l	eq_ref	idx_langcode	idx_langcode	28	foxyplas_foxy.a.language	1
1	PRIMARY	ct	index	NULL	idx_core_content_id	4	NULL	21	Using index
1	PRIMARY	t	eq_ref	PRIMARY	PRIMARY	4	foxyplas_foxy.ct.tag_id	1	Using index
1	PRIMARY	<derived2>	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	3
2	DERIVED	rsi	ALL	idx_module,idx_module_order	NO INDEX KEY COULD BE USED	NULL	NULL	73	Using where

Profile

Status	Duration
starting	0.13 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
System lock	0.06 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.07 ms
init	0.07 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.04 ms
Creating tmp table	1.13 ms
executing	0.02 ms
Copying to tmp table	0.28 ms
Sorting result	0.04 ms
Sending data	0.07 ms
end	0.01 ms
removing tmp table	0.13 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.02 ms
closing tables	0.03 ms
freeing items	0.04 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
18	JDatabaseDriver->loadObjectList()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:58
17	RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
16	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
15	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
14	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
13	ModRokSprocket->_realGetData()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
12	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
11	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
10	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.31 ms After last query: 0.26 ms Query memory: 0.014 MB Memory before query: 15.792 MB Rows returned: 0

SELECT ct.content_item_id as article_id, t.title as tag

  FROM yx5yl_contentitem_tag_map as ct

  LEFT JOIN yx5yl_tags AS t 
  ON t.id = ct.tag_id

  WHERE ct.content_item_id in (78,39,38)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ct	index	NULL	idx_core_content_id	4	NULL	21	Using where; Using index
1	SIMPLE	t	eq_ref	PRIMARY	PRIMARY	4	foxyplas_foxy.ct.tag_id	1

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
20	JDatabaseDriver->loadAssocList()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Joomla/TagMerge.php:26
19	RokSprocket_Provider_Joomla_TagMerge->populateTags()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Joomla.php:159
18	RokSprocket_Provider_Joomla->populateTags()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:62
17	RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
16	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
15	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
14	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
13	ModRokSprocket->_realGetData()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
12	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
11	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
10	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.31 ms After last query: 0.68 ms Query memory: 0.013 MB Memory before query: 15.814 MB Rows returned: 3

SELECT i.provider_id as id, i.
  order, i.params

  FROM yx5yl_roksprocket_items as i

  WHERE i.module_id = '189' 
  AND i.provider = 'joomla'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	i	ref	idx_module,idx_module_order	idx_module	137	const	3	Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
19	JDatabaseDriver->loadObjectList()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:139
18	RokSprocket_Provider_AbstarctJoomlaBasedProvider->mapPerItemData()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:64
17	RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
16	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
15	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
14	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
13	ModRokSprocket->_realGetData()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
12	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
11	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
10	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.67 ms After last query: 5.22 ms Query memory: 0.013 MB Memory before query: 15.830 MB Rows returned: 6

SHOW FULL COLUMNS 
  FROM `yx5yl_template_styles`

Explain

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

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	1.03 ms
System lock	0.02 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.02 ms
executing	0.02 ms
Opening tables	0.02 ms
checking permissions	0.04 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.12 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
18	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
17	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_templates/tables/style.php:30
16	TemplatesTableStyle->__construct()	JROOT/libraries/src/Table/Table.php:312
15	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/gantry/gantry.php:194
14	plgSystemGantry->getTable()	JROOT/plugins/system/gantry/gantry.php:165
13	plgSystemGantry->isGantryTemplate()	JROOT/plugins/system/gantry/gantry.php:234
12	plgSystemGantry->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.30 ms After last query: 0.14 ms Query memory: 0.010 MB Memory before query: 15.855 MB Rows returned: 1

SELECT *

  FROM yx5yl_template_styles

  WHERE `id` = '12'

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.03 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
15	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
14	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/gantry/gantry.php:168
13	plgSystemGantry->isGantryTemplate()	JROOT/plugins/system/gantry/gantry.php:234
12	plgSystemGantry->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

32 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

5 × SELECT i.provider_id as id, i.
  order, i.params 
  FROM yx5yl_roksprocket_items as i

4 × 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 `yx5yl_categories` AS `s` 
  INNER JOIN `yx5yl_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

3 × SELECT ct.content_item_id as article_id, t.title as tag 
  FROM yx5yl_contentitem_tag_map as ct 
  LEFT JOIN yx5yl_tags AS t 
  ON t.id = ct.tag_id

3 × SELECT id, home, template, s.params 
  FROM yx5yl_template_styles as s 
  LEFT JOIN yx5yl_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

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

2 × SELECT a.id, a.title, a.alias, a.introtext, a.`fulltext`, a.catid, a.state, a.access, a.created, a.created_by, a.created_by_alias, a.modified, a.featured, a.language, a.hits, a.publish_up, a.publish_down, a.images, a.urls, a.language, a.metakey, a.metadesc, a.metadata,c.title AS category_title, c.alias AS category_alias,ua.name AS author_name,um.name AS last_modified_by,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,vl.title AS access_title,l.title AS language_title 
  FROM yx5yl_content as a 
  LEFT JOIN yx5yl_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN yx5yl_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN yx5yl_users AS um 
  ON um.id = a.modified_by 
  LEFT JOIN yx5yl_content_rating AS v 
  ON a.id = v.content_id 
  LEFT JOIN yx5yl_viewlevels AS vl 
  ON a.access = vl.id 
  LEFT JOIN yx5yl_languages AS l 
  ON a.language = l.lang_code 
  LEFT JOIN yx5yl_contentitem_tag_map AS ct 
  ON ct.content_item_id = a.id 
  LEFT JOIN yx5yl_tags AS t 
  ON t.id = ct.tag_id

2 × SELECT template 
  FROM yx5yl_template_styles as s

2 × SELECT `extension_id` 
  FROM `yx5yl_extensions`

```
2 × SELECT * 
  FROM yx5yl_extensions
```

1 × SELECT `data` 
  FROM `yx5yl_session`

1 × SELECT COUNT(*) 
  FROM yx5yl_content AS a 
  INNER JOIN yx5yl_content_frontpage AS fp 
  ON fp.content_id = a.id 
  LEFT JOIN yx5yl_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN yx5yl_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN yx5yl_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN yx5yl_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN yx5yl_content_rating AS v 
  ON a.id = v.content_id

1 × SELECT a.id, a.title, a.alias, a.introtext, a.`fulltext`, a.catid, a.state, a.access, a.created, a.created_by, a.created_by_alias, a.modified, a.featured, a.language, a.hits, a.publish_up, a.publish_down, a.images, a.urls, a.language, a.metakey, a.metadesc, a.metadata,c.title AS category_title, c.alias AS category_alias,ua.name AS author_name,um.name AS last_modified_by,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,vl.title AS access_title,l.title AS language_title 
  FROM yx5yl_content as a 
  LEFT JOIN yx5yl_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN yx5yl_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN yx5yl_users AS um 
  ON um.id = a.modified_by 
  LEFT JOIN yx5yl_content_rating AS v 
  ON a.id = v.content_id 
  LEFT JOIN yx5yl_viewlevels AS vl 
  ON a.access = vl.id 
  LEFT JOIN yx5yl_languages AS l 
  ON a.language = l.lang_code 
  LEFT JOIN yx5yl_contentitem_tag_map AS ct 
  ON ct.content_item_id = a.id 
  LEFT JOIN yx5yl_tags AS t 
  ON t.id = ct.tag_id 
  LEFT 
  OUTER JOIN (select rsi.provider_id, rsi.
  order 
  from yx5yl_roksprocket_items as rsi

1 × SELECT ts.template 
  FROM yx5yl_template_styles AS ts 
  INNER JOIN yx5yl_menu AS m 
  ON ts.id=m.template_style_id

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

1 × SELECT id, home, template, params 
  FROM yx5yl_template_styles

1 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM yx5yl_fields AS a 
  LEFT JOIN `yx5yl_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN yx5yl_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN yx5yl_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN yx5yl_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN yx5yl_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `yx5yl_fields_categories` AS fc 
  ON fc.field_id = a.id

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

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

1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,fp.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,        COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count 
  FROM yx5yl_content AS a 
  INNER JOIN yx5yl_content_frontpage AS fp 
  ON fp.content_id = a.id 
  LEFT JOIN yx5yl_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN yx5yl_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN yx5yl_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN yx5yl_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN yx5yl_content_rating AS v 
  ON a.id = v.content_id

1 × SELECT `session_id` 
  FROM `yx5yl_session`

```
1 × SELECT * 
  FROM yx5yl_languages
```
```
1 × SELECT * 
  FROM yx5yl_rokcandy
```

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

1 × SELECT extension, file, type 
  FROM yx5yl_rokcommon_configs

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM yx5yl_extensions

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

1 × SELECT id, rules 
  FROM `yx5yl_viewlevels

1 × SELECT * 
  FROM yx5yl_template_styles

OTHER Tables:

1 × INSERT INTO `yx5yl_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('mj4d4pvukol7bab8anrbjbn3u4', 1, 1558660074, 0, '', 0

1 × SHOW FULL COLUMNS 
  FROM `yx5yl_extensions

1 × UPDATE `yx5yl_extensions` 
  SET `params` = '{\"mediaversion\":\"d9f14e18ada979b650e407cd1cc57360\"}'

1 × SHOW FULL COLUMNS 
  FROM `yx5yl_template_styles

Depunerile de calcar

Curatare si filtrare

FERNOX TF1 COMPACT

Servicii PrincipaleFoxy Plast

Spalarea chimica a instalatiilor termice de incalzire

Analiza apei din sistemul de incalzire

Apa urat mirositoare din boiler

Ce cauzeaza depunerea sarurilor de calcar?

Ce cauzeaza risipa de combustibil?

Foxyplast

Garantii

Garantia Foxy Plast +

Garantia Uponor +

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

48 Queries Logged 40.19 ms

7 duplicate found!

32 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: