 |
|
Un régal de légèreté , que vous pourrez aussi faire à l'avance, à congeler sans la décoration, pour finition le jour J.
|
|
Pour 16 personnes
(2 bûches):
Biscuit:
- 120g de sucre semoule
- 120g amandes en poudre
- 2 jaunes d'oeuf
- 2 oeufs entiers
- 100g farine tamisée
- 6 blancs d'oeufs
- 80g de sucre semoule
Ganache:
- 230g de chocolat dessert
- 230g de crème liquide chaude
- 270g de crème fouettée froide
- 2 plaques de 28cm*38cm
Marmelade d'oranges:
- 600g oranges non traitées
- 600g sucre en poudre
- 900g eau
|
- A l'avance, préparer la marmelade d'oranges: Rincer les oranges, les couper en tranches ( laisser la peau) , puis recoupez les tranches en morceaux de 2cm environ. Cuire 3 minutes à l'eau bouillante, puis égoutter.Dans une casserole, verser les 900g d'eau, les 600g de sucre, amener à ébullition, puis ajouter les oranges.Cuire 1 heure à feu vif. Laisser refroidir, puis ajouter 2 càs de Grand Marnier. Cette marmelade se conserve dans un bocal un mois au frigo.
- Commencer par préparer le biscuit:
Battre les blancs à la vitesse lente, de façon à former de petites bulles d'air, 5 minutes environ. Quand les bulles apparaissent, verser les 80g de sucre semoule, en deux fois, en fouettant toujours à vitesse lente, puis augmenter la vitesse quand vous aurez versé tout le sucre. Vous battez 10 minutes au total. . Si vous avez un robot, vous pouvez laisser les blancs monter dans le robot pendant que vous préparez la suite:
Dans un saladier, battre au fouet le sucre, la poudre d'amandes, et les oeufs et jaunes d'oeufs, de façon a obtenir un appareil mousseux et léger. Ajouter la moitié de la farine tamisée, mélanger au fouet pour 2 minutes. Le mélange doit être aéré. Ajouter alors la moitié des blancs, mélanger délicatement au fouet.
Ajouter l'autre moitié de la farine, mélanger délicatement au fouet.
Enfin, incorporer progressivement le restant des blancs, en utilisant une maryse. Mélanger en tournant et soulevant la pâte, pendant 30 secondes, vous obtiendrez ainsi un appareil léger et mousseux, ce qui rendra votre biscuit léger.
- Allumer le four à 160°.
- Diviser cet appareil en deux ( 2 fois 400g ), pour faire deux plaques de biscuit.
- Verser la préparation sur une plaque recouverte de papier sulfurisé, étaler régulièrement avec une grande spatule, bien lisser la surface.
Enfourner pour 10 minutes (dans un four à chaleur tournante, vous pourrez enfourner deux plaques).
- Préparez maintenant la ganache:
Dans une casserole, faire chauffer les 230g de crème liquide . Lorsqu'elle bout, éteindre le feu, ajouter le chocolat en morceaux, laisser fondre, puis bien mélanger au fouet, il faut que le mélange prenne un aspect onctueux. Laisser refroidir à température ambiante.
Dans un récipient froid, fouetter les 270g de crème liquide , à vitesse lente. Lorsque la crème est montée, la verser sur le mélange chocolat-crème, et mélanger délicatement au fouet.
- Montage:
Prendre un biscuit réalisé en (5), coupez le quart du biscuit : vous obtenez un rectangle de 28cm×10cm. Placez-le sur une feuille de papier sulfurisé , l'imbiber de marmelade d'oranges, morceaux et sirop, puis roulez ce biscuit pour former une bûche très serrée, il ne faut pas qu'il y ait de trous. Imbiber le restant de biscuit (les 3/4 qu'il vous reste), uniquement de sirop cette fois-ci. Ensuite , avec une grande spatule, étaler la ganache. Mettez-en moins de la moitié, il faut en garder pour le masquage . Poser alors la mini bûche au centre, sachant que sa longueur (28cm) doit être la même que la longueur de la grande bûche.
Enrouler cette nouvelle bûche, toujours bien serrée, envelopper de papier sulfurisé, et mettre au frigo pour 1à2h elle doit durcir.
- Monter de même le deuxième biscuit.
- Quand la bûche est prête, il ne vous reste plus qu'à la masquer et à la décorer en imitant l'écorce du bois, puis placer les décors selon votre inspiration: pensez à vous servir des oranges de la marmelade.
Voir la recette des Champignons en meringue .
Voir d'autres recettes de Bûche de Noël.
Cette recette provient du restaurant "La Tavenre" à Castelnau (81).
Recette de mini-bûches au citron
|
| Auteur Martine Acknin |
 |
Pour 12 bûchettes:
- 2 oeufs moyens à température ambiante
- 60g de sucre en poudre
- 60g de farine tamisée
- une plaque de cuisson 30x40cm
- 2 feuilles de papier sulfurisé 30x40cm
Pour la garniture:
- 4 citrons bio
- 400g de sucre
- 160g d'eau
- mascarpone
Décor:
- sucre glace tamisé
- poudre d'or ou autre...
|
| Difficulté: Moyenne Préparation: 30 minutes Cuisson: 9 minutes Repos: 60 minutes |
|
Recette à commencer la veille. Ce sont de petits gâteaux roulés garnis de confit de citron, adouci avec du mascarpone. Vous les présenterez pour Noel en accompagnement de fruits, ou de glace au chocolat ou aux fruits rouges.
Liens utiles
Joomla! Debug Console{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1685458833,
"last": 1685458833,
"now": 1685458833
}
},
"registry": {},
"user": {
"id": 0,
"name": null,
"username": null,
"email": null,
"password": null,
"password_clear": "",
"block": null,
"sendEmail": 0,
"registerDate": null,
"lastvisitDate": null,
"activation": null,
"params": null,
"groups": [],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
},
"plg_system_languagefilter": {
"language": "en-GB"
}
}
}
TimeMemoryTime: 13.75 ms / 13.75 ms Memory: 2.024 MB / 2.39 MB Application: afterLoad Time: 63.01 ms / 76.76 ms Memory: 4.503 MB / 6.89 MB Application: afterInitialise Time: 5.80 ms / 82.55 ms Memory: 0.556 MB / 7.45 MB Application: afterRoute Time: 7.46 ms / 90.01 ms Memory: 0.284 MB / 7.73 MB Application: beforeRenderComponent com_content Time: 5.75 ms / 95.76 ms Memory: 0.679 MB / 8.41 MB Application: Before Access::preloadComponents (all components) Time: 2.74 ms / 98.50 ms Memory: 0.059 MB / 8.47 MB Application: After Access::preloadComponents (all components) Time: 0.03 ms / 98.53 ms Memory: -0.005 MB / 8.47 MB Application: Before Access::preloadPermissions (com_content) Time: 5.32 ms / 103.85 ms Memory: 0.728 MB / 9.20 MB Application: After Access::preloadPermissions (com_content) Time: 0.05 ms / 103.89 ms Memory: -0.034 MB / 9.16 MB Application: Before Access::getAssetRules (id:2229 name:com_content.category.255) Time: 0.38 ms / 104.28 ms Memory: 0.027 MB / 9.19 MB Application: After Access::getAssetRules (id:2229 name:com_content.category.255) Time: 4.84 ms / 109.11 ms Memory: 0.219 MB / 9.41 MB Application: Before Access::getAssetRules (id:8 name:com_content) Time: 0.05 ms / 109.16 ms Memory: 0.008 MB / 9.41 MB Application: After Access::getAssetRules (id:8 name:com_content) Time: 26.97 ms / 136.13 ms Memory: 1.799 MB / 11.21 MB Application: afterRenderComponent com_content Time: 2.47 ms / 138.60 ms Memory: 0.274 MB / 11.49 MB Application: afterDispatch Time: 4.08 ms / 142.68 ms Memory: 0.265 MB / 11.75 MB Application: beforeRenderModule mod_custom (Martine EN) Time: 2.64 ms / 145.32 ms Memory: 0.039 MB / 11.79 MB Application: afterRenderModule mod_custom (Martine EN) Time: 0.23 ms / 145.55 ms Memory: 0.085 MB / 11.88 MB Application: beforeRenderModule mod_news_pro_gk5 (gâteaux pour Pâques) Time: 13.39 ms / 158.95 ms Memory: 0.703 MB / 12.58 MB Application: afterRenderModule mod_news_pro_gk5 (gâteaux pour Pâques) Time: 0.13 ms / 159.08 ms Memory: -0.180 MB / 12.40 MB Application: beforeRenderModule mod_custom (Follow) Time: 0.44 ms / 159.52 ms Memory: 0.003 MB / 12.40 MB Application: afterRenderModule mod_custom (Follow) Time: 0.09 ms / 159.60 ms Memory: 0.001 MB / 12.40 MB Application: beforeRenderModule mod_custom (Liens gourmands) Time: 0.34 ms / 159.94 ms Memory: 0.003 MB / 12.41 MB Application: afterRenderModule mod_custom (Liens gourmands) Time: 0.03 ms / 159.98 ms Memory: 0.000 MB / 12.41 MB Application: beforeRenderModule mod_custom (Liens utiles) Time: 0.33 ms / 160.31 ms Memory: 0.003 MB / 12.41 MB Application: afterRenderModule mod_custom (Liens utiles) Time: 0.04 ms / 160.35 ms Memory: 0.002 MB / 12.41 MB Application: beforeRenderModule mod_languages (Choix de la langue) Time: 4.54 ms / 164.89 ms Memory: 0.155 MB / 12.57 MB Application: afterRenderModule mod_languages (Choix de la langue) Time: 0.03 ms / 164.92 ms Memory: -0.003 MB / 12.56 MB Application: beforeRenderModule mod_syndicate (Flux RSS) Time: 0.37 ms / 165.29 ms Memory: 0.009 MB / 12.57 MB Application: afterRenderModule mod_syndicate (Flux RSS) Time: 0.08 ms / 165.37 ms Memory: 0.002 MB / 12.58 MB Application: beforeRenderModule mod_search (Trouver une recette :) Time: 0.72 ms / 166.09 ms Memory: 0.019 MB / 12.59 MB Application: afterRenderModule mod_search (Trouver une recette :) Time: 1.99 ms / 168.08 ms Memory: 0.153 MB / 12.75 MB Application: beforeRenderModule mod_search (Find a recipe) Time: 0.38 ms / 168.46 ms Memory: 0.007 MB / 12.75 MB Application: afterRenderModule mod_search (Find a recipe) Time: 0.42 ms / 168.88 ms Memory: 0.001 MB / 12.75 MB Application: beforeRenderModule mod_menu (Menu Principal) Time: 2.03 ms / 170.91 ms Memory: 0.106 MB / 12.86 MB Application: afterRenderModule mod_menu (Menu Principal) Time: 3.91 ms / 174.83 ms Memory: 0.121 MB / 12.98 MB Application: beforeRenderModule mod_phocagoogleadsense (Google AdSense Top) Time: 0.23 ms / 175.06 ms Memory: 0.008 MB / 12.99 MB Application: afterRenderModule mod_phocagoogleadsense (Google AdSense Top) Time: 1.43 ms / 176.49 ms Memory: 0.016 MB / 13.00 MB Application: beforeRenderModule mod_menu (Plan du site) Time: 0.64 ms / 177.13 ms Memory: 0.014 MB / 13.02 MB Application: afterRenderModule mod_menu (Plan du site) Time: 0.72 ms / 177.85 ms Memory: 0.001 MB / 13.02 MB Application: beforeRenderModule mod_search (Recherche smartphone) Time: 0.40 ms / 178.26 ms Memory: 0.005 MB / 13.03 MB Application: afterRenderModule mod_search (Recherche smartphone) Time: 0.03 ms / 178.28 ms Memory: -0.001 MB / 13.02 MB Application: beforeRenderModule mod_menu (Menu Smartphone) Time: 0.86 ms / 179.15 ms Memory: 0.005 MB / 13.03 MB Application: afterRenderModule mod_menu (Menu Smartphone) Time: 2.60 ms / 181.75 ms Memory: 0.056 MB / 13.09 MB Application: afterRender Database queries total: 40.97 ms 13.47 MB (14,119,624 Bytes) 32 Queries Logged 40.97 msQuery Time: 0.35 ms Query memory: 0.023 MB Memory before query: 4.162 MB Rows returned: 0 SELECT `data`
FROM `gpv25_session`
WHERE `session_id` = X'3234643662363230306264373264653832666335376666636662666631303539' | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | gpv25_session | NULL | const | PRIMARY | PRIMARY | 194 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.04 ms | | checking permissions | 0.01 ms | | Opening tables | 0.02 ms | | init | 0.01 ms | | System lock | 0.01 ms | | optimizing | 0.01 ms | | statistics | 0.04 ms | | executing | 0.01 ms | | end | 0.00 ms | | query end | 0.01 ms | | closing tables | 0.01 ms | | freeing items | 0.03 ms | | cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 | | 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:661 | | 9 | Joomla\CMS\Session\Session->_start() | JROOT/libraries/src/Session/Session.php:621 | | 8 | Joomla\CMS\Session\Session->start() | JROOT/libraries/src/Session/Session.php:499 | | 7 | Joomla\CMS\Session\Session->get() | JROOT/libraries/src/Session/Session.php:456 | | 6 | Joomla\CMS\Session\Session->isNew() | JROOT/libraries/src/Application/CMSApplication.php:826 | | 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 | | 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:386 | | 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 | | 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Query Time: 0.28 ms After last query: 0.98 ms Query memory: 0.020 MB Memory before query: 4.257 MB Rows returned: 0 SELECT `session_id`
FROM `gpv25_session`
WHERE `session_id` = X'3234643662363230306264373264653832666335376666636662666631303539'
LIMIT 1 | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | gpv25_session | NULL | const | PRIMARY | PRIMARY | 194 | const | 1 | 100.00 | Using index |
| Status | Duration |
|---|
| starting | 0.03 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | init | 0.01 ms | | System lock | 0.01 ms | | optimizing | 0.01 ms | | statistics | 0.02 ms | | executing | 0.01 ms | | end | 0.00 ms | | query end | 0.01 ms | | closing tables | 0.01 ms | | freeing items | 0.02 ms | | cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 | | 8 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Session/MetadataManager.php:74 | | 7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:154 | | 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:828 | | 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 | | 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:386 | | 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 | | 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Query Time: 2.50 ms After last query: 0.07 ms Query memory: 0.004 MB Memory before query: 4.262 MB INSERT INTO `gpv25_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
(X'3234643662363230306264373264653832666335376666636662666631303539', 1, 1685458833, 0, '', 0) EXPLAIN not possible on query: INSERT INTO `gpv25_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(X'3234643662363230306264373264653832666335376666636662666631303539', 1, 1685458833, 0, '', 0) | Status | Duration |
|---|
| starting | 0.03 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | init | 0.01 ms | | System lock | 0.01 ms | | update | 0.10 ms | | end | 0.01 ms | | query end | 2.15 ms | | closing tables | 0.02 ms | | freeing items | 0.03 ms | | cleaning up | 0.01 ms |
| # | 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:154 | | 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:828 | | 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 | | 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:386 | | 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 | | 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Query Time: 0.60 ms After last query: 1.86 ms Query memory: 0.024 MB Memory before query: 4.451 MB Rows returned: 40 SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `gpv25_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1 | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | gpv25_extensions | NULL | ref | extension | extension | 82 | const | 41 | 1.00 | Using where |
| Status | Duration |
|---|
| starting | 0.04 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | init | 0.02 ms | | System lock | 0.01 ms | | optimizing | 0.01 ms | | statistics | 0.05 ms | | preparing | 0.01 ms | | executing | 0.00 ms | | Sending data | 0.19 ms | | end | 0.01 ms | | query end | 0.01 ms | | closing tables | 0.01 ms | | freeing items | 0.04 ms | | cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 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:225 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.31 ms After last query: 1.91 ms Query memory: 0.021 MB Memory before query: 4.704 MB Rows returned: 4 SELECT id, rules
FROM `gpv25_viewlevels` | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | gpv25_viewlevels | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 4 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.03 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | init | 0.01 ms | | System lock | 0.01 ms | | optimizing | 0.01 ms | | statistics | 0.01 ms | | preparing | 0.01 ms | | executing | 0.00 ms | | Sending data | 0.05 ms | | end | 0.00 ms | | query end | 0.01 ms | | closing tables | 0.01 ms | | freeing items | 0.03 ms | | cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 | | 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:318 | | 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:225 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.36 ms After last query: 0.07 ms Query memory: 0.021 MB Memory before query: 4.715 MB Rows returned: 1 SELECT b.id
FROM gpv25_usergroups AS a
LEFT JOIN gpv25_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1 | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL | | 1 | SIMPLE | b | NULL | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 3 | 100.00 | Using where; Using index |
| Status | Duration |
|---|
| starting | 0.04 ms | | checking permissions | 0.00 ms | | checking permissions | 0.00 ms | | Opening tables | 0.03 ms | | init | 0.02 ms | | System lock | 0.01 ms | | optimizing | 0.01 ms | | statistics | 0.06 ms | | preparing | 0.01 ms | | executing | 0.00 ms | | Sending data | 0.02 ms | | end | 0.00 ms | | query end | 0.01 ms | | closing tables | 0.01 ms | | freeing items | 0.03 ms | | cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 | | 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:318 | | 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:225 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.20 ms After last query: 0.54 ms Query memory: 0.030 MB Memory before query: 4.784 MB Rows returned: 92 SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM gpv25_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1)
ORDER BY ordering | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | gpv25_extensions | NULL | ref | extension | extension | 82 | const | 190 | 0.40 | Using index condition; Using where; Using filesort |
| Status | Duration |
|---|
| starting | 0.05 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | init | 0.02 ms | | System lock | 0.01 ms | | optimizing | 0.01 ms | | statistics | 0.04 ms | | preparing | 0.02 ms | | Sorting result | 0.01 ms | | executing | 0.00 ms | | Sending data | 0.01 ms | | Creating sort index | 0.79 ms | | end | 0.01 ms | | query end | 0.01 ms | | closing tables | 0.01 ms | | freeing items | 0.03 ms | | cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Plugin/PluginHelper.php:351 | | 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:356 | | 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:225 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.36 ms After last query: 0.86 ms Query memory: 0.020 MB Memory before query: 4.898 MB Rows returned: 2 SELECT *
FROM gpv25_languages
WHERE published=1
ORDER BY ordering ASC | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | gpv25_languages | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 2 | 50.00 | Using where; Using filesort |
| Status | Duration |
|---|
| starting | 0.03 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | init | 0.02 ms | | System lock | 0.01 ms | | optimizing | 0.01 ms | | statistics | 0.01 ms | | preparing | 0.01 ms | | Sorting result | 0.00 ms | | executing | 0.00 ms | | Sending data | 0.01 ms | | Creating sort index | 0.06 ms | | end | 0.00 ms | | query end | 0.01 ms | | closing tables | 0.01 ms | | freeing items | 0.03 ms | | cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 7 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 6 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/LanguageHelper.php:150 | | 5 | Joomla\CMS\Language\LanguageHelper::getLanguages() | JROOT/libraries/src/Language/LanguageHelper.php:67 | | 4 | Joomla\CMS\Language\LanguageHelper::detectLanguage() | JROOT/libraries/src/Application/SiteApplication.php:653 | | 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:225 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.57 ms After last query: 5.15 ms Query memory: 0.021 MB Memory before query: 5.503 MB Rows returned: 4 SELECT `element`,`name`,`client_id`,`extension_id`
FROM `gpv25_extensions`
WHERE `type` = 'language'
AND `state` = 0
AND `enabled` = 1 | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | gpv25_extensions | NULL | ref | extension | extension | 82 | const | 4 | 1.25 | Using where |
| Status | Duration |
|---|
| starting | 0.06 ms | | checking permissions | 0.01 ms | | Opening tables | 0.02 ms | | init | 0.02 ms | | System lock | 0.01 ms | | optimizing | 0.01 ms | | statistics | 0.07 ms | | preparing | 0.01 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.04 ms | | cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 9 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/LanguageHelper.php:209 | | 8 | Joomla\CMS\Language\LanguageHelper::getInstalledLanguages() | JROOT/plugins/system/languagefilter/languagefilter.php:110 | | 7 | PlgSystemLanguageFilter->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 | | 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:667 | | 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:225 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.95 ms After last query: 9.55 ms Query memory: 0.085 MB Memory before query: 6.614 MB Rows returned: 40 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 gpv25_menu AS m
LEFT JOIN gpv25_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 | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | NULL | range | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 5 | NULL | 63 | 10.00 | Using index condition; Using where; Using filesort | | 1 | SIMPLE | e | NULL | eq_ref | PRIMARY | PRIMARY | 4 | db462563782.m.component_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.11 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | Opening tables | 0.03 ms | | init | 0.05 ms | | System lock | 0.01 ms | | optimizing | 0.02 ms | | statistics | 0.13 ms | | preparing | 0.03 ms | | Sorting result | 0.01 ms | | executing | 0.01 ms | | Sending data | 0.03 ms | | Creating sort index | 1.24 ms | | end | 0.01 ms | | query end | 0.03 ms | | closing tables | 0.02 ms | | freeing items | 0.05 ms | | cleaning up | 0.02 ms |
| # | Caller | File and line number |
|---|
| 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 22 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Menu/SiteMenu.php:93 | | 21 | Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() | Same as call in the line below. | | 20 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 | | 19 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Menu/SiteMenu.php:101 | | 18 | Joomla\CMS\Menu\SiteMenu->load() | JROOT/libraries/src/Menu/AbstractMenu.php:78 | | 17 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT/libraries/src/Menu/SiteMenu.php:62 | | 16 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT/libraries/src/Menu/AbstractMenu.php:142 | | 15 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:417 | | 14 | Joomla\CMS\Application\CMSApplication->getMenu() | JROOT/libraries/src/Application/SiteApplication.php:275 | | 13 | Joomla\CMS\Application\SiteApplication->getMenu() | JROOT/libraries/src/Router/SiteRouter.php:65 | | 12 | Joomla\CMS\Router\SiteRouter->__construct() | JROOT/libraries/src/Router/Router.php:189 | | 11 | Joomla\CMS\Router\Router::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:533 | | 10 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:403 | | 9 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/plugins/system/languagefilter/languagefilter.php:145 | | 8 | PlgSystemLanguageFilter->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 | | 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | | 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 | | 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 | | 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:225 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.71 ms After last query: 7.50 ms Query memory: 0.022 MB Memory before query: 7.484 MB Rows returned: 1 SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `gpv25_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla' | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | gpv25_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.08 ms | | checking permissions | 0.01 ms | | Opening tables | 0.03 ms | | init | 0.03 ms | | System lock | 0.02 ms | | optimizing | 0.02 ms | | statistics | 0.15 ms | | preparing | 0.02 ms | | executing | 0.01 ms | | Sending data | 0.06 ms | | end | 0.01 ms | | query end | 0.01 ms | | closing tables | 0.01 ms | | freeing items | 0.06 ms | | cleaning up | 0.02 ms |
| # | Caller | File and line number |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 | | 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:1137 | | 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:225 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 3.40 ms After last query: 0.11 ms Query memory: 0.005 MB Memory before query: 7.475 MB UPDATE `gpv25_extensions`
SET `params` = '{\"mediaversion\":\"c5f49027732ff4a89b4b07301d1e9140\"}'
WHERE `type` = 'library'
AND `element` = 'joomla' | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | UPDATE | gpv25_extensions | NULL | range | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.09 ms | | checking permissions | 0.01 ms | | Opening tables | 0.02 ms | | init | 0.03 ms | | System lock | 0.12 ms | | updating | 0.16 ms | | end | 0.02 ms | | query end | 2.68 ms | | closing tables | 0.05 ms | | freeing items | 0.06 ms | | cleaning up | 0.02 ms |
| # | 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:1137 | | 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:225 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.13 ms After last query: 1.58 ms Query memory: 0.020 MB Memory before query: 7.729 MB Rows returned: 11 SELECT id, home, template, s.params
FROM gpv25_template_styles as s
LEFT JOIN gpv25_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 | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid,extension | extension | 82 | const | 15 | 1.00 | Using index condition; Using where | | 1 | SIMPLE | s | NULL | ref | idx_template,idx_client_id,idx_client_id_home | idx_template | 202 | db462563782.e.element | 1 | 78.57 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.12 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | Opening tables | 0.03 ms | | init | 0.05 ms | | System lock | 0.01 ms | | optimizing | 0.03 ms | | statistics | 0.17 ms | | preparing | 0.07 ms | | executing | 0.01 ms | | Sending data | 0.30 ms | | end | 0.01 ms | | query end | 0.01 ms | | closing tables | 0.02 ms | | freeing items | 0.07 ms | | cleaning up | 0.02 ms |
| # | Caller | File and line number |
|---|
| 6 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 5 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Application/SiteApplication.php:486 | | 4 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT/libraries/src/Application/SiteApplication.php:168 | | 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:225 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 2.56 ms After last query: 6.09 ms Query memory: 0.028 MB Memory before query: 8.417 MB Rows returned: 40 SELECT `id`,`name`,`rules`,`parent_id`
FROM `gpv25_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_easytagcloud','com_fields','com_finder','com_installer','com_joomlaupdate','com_josetta','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_search','com_slideshowck','com_tags','com_templates','com_users','com_weblinks','com_wrapper','com_xmap') | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | gpv25_assets | NULL | range | idx_asset_name | idx_asset_name | 202 | NULL | 41 | 100.00 | Using index condition |
| Status | Duration |
|---|
| starting | 0.13 ms | | checking permissions | 0.01 ms | | Opening tables | 0.03 ms | | init | 0.26 ms | | System lock | 0.01 ms | | optimizing | 0.02 ms | | statistics | 0.49 ms | | preparing | 0.02 ms | | executing | 0.01 ms | | Sending data | 1.21 ms | | end | 0.01 ms | | query end | 0.02 ms | | closing tables | 0.02 ms | | freeing items | 0.06 ms | | cleaning up | 0.02 ms |
| # | Caller | File and line number |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 | | 18 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 | | 17 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 | | 16 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 | | 15 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 | | 14 | Joomla\CMS\User\User->authorise() | JROOT/components/com_content/models/category.php:139 | | 13 | ContentModelCategory->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 | | 12 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/libraries/src/MVC/View/CategoryView.php:116 | | 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 | | 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | | 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 | | 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | | 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:225 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 4.18 ms After last query: 0.15 ms Query memory: 0.162 MB Memory before query: 8.468 MB Rows returned: 941 SELECT `id`,`name`,`rules`,`parent_id`
FROM `gpv25_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0 | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | gpv25_assets | NULL | ALL | idx_asset_name,idx_parent_id | NO INDEX KEY COULD BE USED | NULL | NULL | 1138 | 20.84 | Using where |
| Status | Duration |
|---|
| starting | 0.07 ms | | checking permissions | 0.01 ms | | Opening tables | 0.02 ms | | init | 0.03 ms | | System lock | 0.01 ms | | optimizing | 0.05 ms | | statistics | 0.11 ms | | preparing | 0.02 ms | | executing | 0.01 ms | | Sending data | 3.55 ms | | end | 0.01 ms | | query end | 0.01 ms | | closing tables | 0.01 ms | | freeing items | 0.04 ms | | cleaning up | 0.02 ms |
| # | Caller | File and line number |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:359 | | 18 | Joomla\CMS\Access\Access::preloadPermissions() | JROOT/libraries/src/Access/Access.php:226 | | 17 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:540 | | 16 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 | | 15 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 | | 14 | Joomla\CMS\User\User->authorise() | JROOT/components/com_content/models/category.php:139 | | 13 | ContentModelCategory->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 | | 12 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/libraries/src/MVC/View/CategoryView.php:116 | | 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 | | 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | | 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 | | 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | | 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:225 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 2.38 ms After last query: 2.36 ms Query memory: 0.026 MB Memory before query: 9.240 MB Rows returned: 3 SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,(
SELECT COUNT(i.`id`)
FROM `gpv25_content` AS `i`
WHERE i.`catid` = c.id
AND i.state = 1
AND (i.language = '*' OR i.language = 'en-GB')) AS numitems
FROM `gpv25_categories` AS `s`
INNER JOIN `gpv25_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('en-GB','*')) OR (c.lft <= s.lft
AND s.rgt <= c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.published = 1
AND s.id = 255
ORDER BY c.lft | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | PRIMARY | s | NULL | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | Using filesort | | 1 | PRIMARY | c | NULL | ALL | cat_idx,idx_left_right,idx_language | NO INDEX KEY COULD BE USED | NULL | NULL | 119 | 20.47 | Using where | | 2 | DEPENDENT SUBQUERY | i | NULL | ref | idx_state,idx_catid,idx_language | idx_catid | 4 | db462563782.c.id | 8 | 100.00 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.27 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | Opening tables | 0.04 ms | | init | 0.13 ms | | System lock | 0.02 ms | | optimizing | 0.05 ms | | statistics | 0.27 ms | | preparing | 0.04 ms | | Sorting result | 0.01 ms | | optimizing | 0.02 ms | | statistics | 0.11 ms | | preparing | 0.03 ms | | executing | 0.01 ms | | Sending data | 0.04 ms | | Creating sort index | 0.38 ms | | executing | 0.01 ms | | Sending data | 0.05 ms | | executing | 0.01 ms | | Sending data | 0.06 ms | | executing | 0.01 ms | | Sending data | 0.36 ms | | end | 0.01 ms | | query end | 0.02 ms | | closing tables | 0.02 ms | | freeing items | 0.08 ms | | cleaning up | 0.03 ms |
| # | Caller | File and line number |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 | | 15 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 | | 14 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/models/category.php:355 | | 13 | ContentModelCategory->getCategory() | JROOT/libraries/src/MVC/View/HtmlView.php:425 | | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:122 | | 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 | | 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | | 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 | | 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | | 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:225 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 2.96 ms After last query: 1.71 ms Query memory: 0.075 MB Memory before query: 9.415 MB Rows returned: 3 SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN 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,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 gpv25_content AS a
LEFT JOIN gpv25_categories AS c
ON c.id = a.catid
LEFT JOIN gpv25_users AS ua
ON ua.id = a.created_by
LEFT JOIN gpv25_users AS uam
ON uam.id = a.modified_by
LEFT JOIN gpv25_categories as parent
ON parent.id = c.parent_id
LEFT JOIN gpv25_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 IN (0,1,2)
AND a.catid = 255
AND a.language IN ('en-GB','*')
ORDER BY c.path, a.title, a.created
LIMIT 30 | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | c | NULL | const | PRIMARY,idx_access | PRIMARY | 4 | const | 1 | 100.00 | Using temporary; Using filesort | | 1 | SIMPLE | a | NULL | ref | idx_access,idx_state,idx_catid,idx_language | idx_catid | 4 | const | 8 | 100.00 | Using where | | 1 | SIMPLE | ua | NULL | ALL | PRIMARY | NO INDEX KEY COULD BE USED | NULL | NULL | 2 | 100.00 | Using where; Using join buffer (Block Nested Loop) | | 1 | SIMPLE | uam | NULL | eq_ref | PRIMARY | PRIMARY | 4 | db462563782.a.modified_by | 1 | 100.00 | Using where | | 1 | SIMPLE | parent | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using where | | 1 | SIMPLE | v | NULL | eq_ref | PRIMARY | PRIMARY | 4 | db462563782.a.id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.31 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.08 ms | | init | 0.19 ms | | System lock | 0.02 ms | | optimizing | 0.03 ms | | statistics | 0.25 ms | | preparing | 0.07 ms | | Creating tmp table | 0.20 ms | | Sorting result | 0.01 ms | | executing | 0.01 ms | | Sending data | 1.02 ms | | Creating sort index | 0.20 ms | | end | 0.01 ms | | query end | 0.01 ms | | removing tmp table | 0.17 ms | | query end | 0.01 ms | | closing tables | 0.02 ms | | freeing items | 0.06 ms | | cleaning up | 0.02 ms |
| # | Caller | File and line number |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 | | 16 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 | | 15 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_content/models/articles.php:576 | | 14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 | | 13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 | | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 | | 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 | | 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | | 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 | | 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | | 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:225 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.74 ms After last query: 1.41 ms Query memory: 0.024 MB Memory before query: 9.616 MB Rows returned: 1 SELECT `m`.`tag_id`,`t`.*
FROM `gpv25_contentitem_tag_map` AS m
INNER JOIN `gpv25_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 555
AND `t`.`published` = 1
AND t.access IN (1,1) | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | NULL | ALL | idx_tag_type | NO INDEX KEY COULD BE USED | NULL | NULL | 93 | 1.08 | Using where | | 1 | SIMPLE | t | NULL | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | db462563782.m.tag_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.07 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | Opening tables | 0.02 ms | | init | 0.05 ms | | System lock | 0.01 ms | | optimizing | 0.03 ms | | statistics | 0.10 ms | | preparing | 0.02 ms | | executing | 0.01 ms | | Sending data | 0.16 ms | | end | 0.01 ms | | query end | 0.01 ms | | closing tables | 0.01 ms | | freeing items | 0.04 ms | | cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 | | 15 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:706 | | 14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 | | 13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 | | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 | | 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 | | 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | | 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 | | 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | | 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:225 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.61 ms After last query: 0.16 ms Query memory: 0.024 MB Memory before query: 9.636 MB Rows returned: 1 SELECT `m`.`tag_id`,`t`.*
FROM `gpv25_contentitem_tag_map` AS m
INNER JOIN `gpv25_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 196
AND `t`.`published` = 1
AND t.access IN (1,1) | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | NULL | ALL | idx_tag_type | NO INDEX KEY COULD BE USED | NULL | NULL | 93 | 1.08 | Using where | | 1 | SIMPLE | t | NULL | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | db462563782.m.tag_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.06 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | Opening tables | 0.02 ms | | init | 0.04 ms | | System lock | 0.01 ms | | optimizing | 0.02 ms | | statistics | 0.07 ms | | preparing | 0.02 ms | | executing | 0.00 ms | | Sending data | 0.14 ms | | end | 0.01 ms | | query end | 0.01 ms | | closing tables | 0.01 ms | | freeing items | 0.04 ms | | cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 | | 15 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:706 | | 14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 | | 13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 | | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 | | 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 | | 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | | 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 | | 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | | 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:225 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.67 ms After last query: 0.12 ms Query memory: 0.025 MB Memory before query: 9.656 MB Rows returned: 2 SELECT `m`.`tag_id`,`t`.*
FROM `gpv25_contentitem_tag_map` AS m
INNER JOIN `gpv25_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 1991
AND `t`.`published` = 1
AND t.access IN (1,1) | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | NULL | ALL | idx_tag_type | NO INDEX KEY COULD BE USED | NULL | NULL | 93 | 1.08 | Using where | | 1 | SIMPLE | t | NULL | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | db462563782.m.tag_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.05 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | init | 0.04 ms | | System lock | 0.01 ms | | optimizing | 0.02 ms | | statistics | 0.06 ms | | preparing | 0.02 ms | | executing | 0.01 ms | | Sending data | 0.14 ms | | end | 0.01 ms | | query end | 0.01 ms | | closing tables | 0.01 ms | | freeing items | 0.04 ms | | cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 | | 15 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:706 | | 14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 | | 13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 | | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 | | 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 | | 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | | 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 | | 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | | 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:225 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.81 ms After last query: 0.89 ms Query memory: 0.024 MB Memory before query: 9.813 MB Rows returned: 1 SELECT COUNT(*)
FROM gpv25_content AS a
LEFT JOIN gpv25_categories AS c
ON c.id = a.catid
LEFT JOIN gpv25_users AS ua
ON ua.id = a.created_by
LEFT JOIN gpv25_users AS uam
ON uam.id = a.modified_by
LEFT JOIN gpv25_categories as parent
ON parent.id = c.parent_id
LEFT JOIN gpv25_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 IN (0,1,2)
AND a.catid = 255
AND a.language IN ('en-GB','*') | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | c | NULL | const | PRIMARY,idx_access | PRIMARY | 4 | const | 1 | 100.00 | NULL | | 1 | SIMPLE | a | NULL | ref | idx_access,idx_state,idx_catid,idx_language | idx_catid | 4 | const | 8 | 100.00 | Using where | | 1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | db462563782.a.created_by | 1 | 100.00 | Using where; Using index | | 1 | SIMPLE | uam | NULL | eq_ref | PRIMARY | PRIMARY | 4 | db462563782.a.modified_by | 1 | 100.00 | Using where; Using index | | 1 | SIMPLE | parent | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using where; Using index | | 1 | SIMPLE | v | NULL | eq_ref | PRIMARY | PRIMARY | 4 | db462563782.a.id | 1 | 100.00 | Using where; Using index |
| Status | Duration |
|---|
| starting | 0.09 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | checking permissions | 0.00 ms | | checking permissions | 0.00 ms | | checking permissions | 0.00 ms | | checking permissions | 0.01 ms | | Opening tables | 0.03 ms | | init | 0.05 ms | | System lock | 0.01 ms | | optimizing | 0.02 ms | | statistics | 0.20 ms | | preparing | 0.03 ms | | executing | 0.01 ms | | Sending data | 0.14 ms | | end | 0.01 ms | | query end | 0.01 ms | | closing tables | 0.01 ms | | freeing items | 0.04 ms | | cleaning up | 0.02 ms |
| # | Caller | File and line number |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 | | 17 | JDatabaseDriver->loadResult() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354 | | 16 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() | JROOT/libraries/src/MVC/Model/ListModel.php:289 | | 15 | Joomla\CMS\MVC\Model\ListModel->getTotal() | JROOT/libraries/src/MVC/Model/ListModel.php:239 | | 14 | Joomla\CMS\MVC\Model\ListModel->getPagination() | JROOT/components/com_content/models/category.php:265 | | 13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 | | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 | | 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 | | 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | | 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 | | 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | | 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:225 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.62 ms After last query: 0.15 ms Query memory: 0.022 MB Memory before query: 9.815 MB Rows returned: 0 SELECT `m`.`tag_id`,`t`.*
FROM `gpv25_contentitem_tag_map` AS m
INNER JOIN `gpv25_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.category'
AND `m`.`content_item_id` = 255
AND `t`.`published` = 1
AND t.access IN (1,1) | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | NULL | ALL | idx_tag_type | NO INDEX KEY COULD BE USED | NULL | NULL | 93 | 1.08 | Using where | | 1 | SIMPLE | t | NULL | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | db462563782.m.tag_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.07 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | Opening tables | 0.02 ms | | init | 0.04 ms | | System lock | 0.01 ms | | optimizing | 0.02 ms | | statistics | 0.07 ms | | preparing | 0.02 ms | | executing | 0.00 ms | | Sending data | 0.10 ms | | end | 0.01 ms | | query end | 0.01 ms | | closing tables | 0.01 ms | | freeing items | 0.04 ms | | cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 | | 12 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/libraries/src/MVC/View/CategoryView.php:229 | | 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 | | 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | | 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 | | 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | | 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:225 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.86 ms After last query: 4.50 ms Query memory: 0.027 MB Memory before query: 10.251 MB Rows returned: 3 SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `gpv25_categories` AS `s`
INNER JOIN `gpv25_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('en-GB','*')) 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 = 255
ORDER BY c.lft | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | s | NULL | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | Using filesort | | 1 | SIMPLE | c | NULL | ALL | cat_idx,idx_access,idx_left_right,idx_language | NO INDEX KEY COULD BE USED | NULL | NULL | 119 | 20.10 | Using where |
| Status | Duration |
|---|
| starting | 0.12 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | Opening tables | 0.02 ms | | init | 0.05 ms | | System lock | 0.01 ms | | optimizing | 0.02 ms | | statistics | 0.11 ms | | preparing | 0.02 ms | | Sorting result | 0.01 ms | | executing | 0.00 ms | | Sending data | 0.02 ms | | Creating sort index | 0.22 ms | | end | 0.01 ms | | query end | 0.01 ms | | closing tables | 0.01 ms | | freeing items | 0.04 ms | | cleaning up | 0.02 ms |
| # | Caller | File and line number |
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 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:140 | | 16 | Joomla\CMS\MVC\Model\ListModel->_getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:194 | | 15 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 | | 14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 | | 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/category/view.html.php:113 | | 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | | 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 | | 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | | 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:225 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.14 ms After last query: 0.12 ms Query memory: 0.025 MB Memory before query: 10.272 MB Rows returned: 0 SELECT DISTINCT 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 gpv25_fields AS a
LEFT JOIN `gpv25_languages` AS l
ON l.lang_code = a.language
LEFT JOIN gpv25_users AS uc
ON uc.id=a.checked_out
LEFT JOIN gpv25_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN gpv25_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN gpv25_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `gpv25_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 (255,0,86))
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 | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | NULL | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | 100.00 | Using index condition; Using where; Using temporary; Using filesort | | 1 | SIMPLE | l | NULL | eq_ref | idx_langcode | idx_langcode | 28 | db462563782.a.language | 1 | 100.00 | Using where | | 1 | SIMPLE | uc | NULL | eq_ref | PRIMARY | PRIMARY | 4 | db462563782.a.checked_out | 1 | 100.00 | NULL | | 1 | SIMPLE | ag | NULL | eq_ref | PRIMARY | PRIMARY | 4 | db462563782.a.access | 1 | 100.00 | Using where | | 1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | db462563782.a.created_user_id | 1 | 100.00 | Using where | | 1 | SIMPLE | g | NULL | eq_ref | PRIMARY | PRIMARY | 4 | db462563782.a.group_id | 1 | 100.00 | Using where | | 1 | SIMPLE | fc | NULL | ref | PRIMARY | PRIMARY | 4 | db462563782.a.id | 1 | 100.00 | Using where; Using index; Distinct |
| Status | Duration |
|---|
| starting | 0.12 ms | | checking permissions | 0.01 ms | | checking permissions | 0.00 ms | | checking permissions | 0.00 ms | | checking permissions | 0.00 ms | | checking permissions | 0.00 ms | | checking permissions | 0.00 ms | | checking permissions | 0.00 ms | | Opening tables | 0.06 ms | | init | 0.06 ms | | System lock | 0.01 ms | | optimizing | 0.02 ms | | statistics | 0.13 ms | | preparing | 0.06 ms | | Creating tmp table | 0.08 ms | | Sorting result | 0.01 ms | | executing | 0.00 ms | | Sending data | 0.25 ms | | Creating sort index | 0.03 ms | | end | 0.00 ms | | query end | 0.01 ms | | removing tmp table | 0.08 ms | | query end | 0.01 ms | | closing tables | 0.02 ms | | freeing items | 0.04 ms | | cleaning up | 0.02 ms |
| # | Caller | File and line number |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 | | 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:194 | | 15 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 | | 14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 | | 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/category/view.html.php:113 | | 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | | 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 | | 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | | 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:225 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 2.05 ms After last query: 15.45 ms Query memory: 0.059 MB Memory before query: 11.704 MB Rows returned: 18 SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM gpv25_modules AS m
LEFT JOIN gpv25_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN gpv25_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-05-30 15:00:33')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-05-30 15:00:33')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 201 OR mm.menuid <= 0)
AND m.language IN ('en-GB','*')
ORDER BY m.position, m.ordering | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | NULL | range | PRIMARY,published,newsfeeds,idx_language | published | 5 | NULL | 27 | 1.39 | Using index condition; Using where; Using filesort | | 1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid | element_clientid | 403 | db462563782.m.module,const | 1 | 10.00 | Using index condition; Using where | | 1 | SIMPLE | mm | NULL | ref | PRIMARY | PRIMARY | 4 | db462563782.m.id | 2 | 40.00 | Using where; Using index |
| Status | Duration |
|---|
| starting | 0.14 ms | | checking permissions | 0.01 ms | | checking permissions | 0.00 ms | | checking permissions | 0.01 ms | | Opening tables | 0.03 ms | | init | 0.09 ms | | System lock | 0.01 ms | | optimizing | 0.03 ms | | statistics | 0.15 ms | | preparing | 0.04 ms | | Sorting result | 0.01 ms | | executing | 0.01 ms | | Sending data | 0.01 ms | | Creating sort index | 1.14 ms | | end | 0.04 ms | | query end | 0.02 ms | | closing tables | 0.02 ms | | freeing items | 0.06 ms | | cleaning up | 0.02 ms |
| # | Caller | File and line number |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 18 | JDatabaseDriver->loadObjectList() | Same as call in the line below. | | 17 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 | | 16 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:441 | | 15 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/src/Helper/ModuleHelper.php:371 | | 14 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:87 | | 13 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT/libraries/src/Document/HtmlDocument.php:601 | | 12 | Joomla\CMS\Document\HtmlDocument->countModules() | JROOT/templates/yoo_eat/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:54 | | 11 | Warp\Joomla\Helper\WidgetsHelper->count() | JROOT/templates/yoo_eat/layouts/theme.config.php:26 | | 10 | include JROOT/templates/yoo_eat/layouts/theme.config.php | JROOT/templates/yoo_eat/layouts/theme.php:10 | | 9 | include JROOT/templates/yoo_eat/layouts/theme.php | JROOT/templates/yoo_eat/warp/src/Warp/Helper/TemplateHelper.php:49 | | 8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/yoo_eat/index.php:16 | | 7 | require JROOT/templates/yoo_eat/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 | | 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 | | 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 | | 4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 | | 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:231 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.76 ms After last query: 0.63 ms Query memory: 0.029 MB Memory before query: 11.781 MB Rows returned: 0 SELECT DISTINCT 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 gpv25_fields AS a
LEFT JOIN `gpv25_languages` AS l
ON l.lang_code = a.language
LEFT JOIN gpv25_users AS uc
ON uc.id=a.checked_out
LEFT JOIN gpv25_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN gpv25_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN gpv25_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'mod_custom.content'
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 | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | NULL | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | 100.00 | Using index condition; Using where; Using temporary; Using filesort | | 1 | SIMPLE | l | NULL | eq_ref | idx_langcode | idx_langcode | 28 | db462563782.a.language | 1 | 100.00 | Using where | | 1 | SIMPLE | uc | NULL | eq_ref | PRIMARY | PRIMARY | 4 | db462563782.a.checked_out | 1 | 100.00 | NULL | | 1 | SIMPLE | ag | NULL | eq_ref | PRIMARY | PRIMARY | 4 | db462563782.a.access | 1 | 100.00 | Using where | | 1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | db462563782.a.created_user_id | 1 | 100.00 | Using where | | 1 | SIMPLE | g | NULL | eq_ref | PRIMARY | PRIMARY | 4 | db462563782.a.group_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.21 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 | | init | 0.10 ms | | System lock | 0.02 ms | | optimizing | 0.04 ms | | statistics | 0.27 ms | | preparing | 0.05 ms | | Creating tmp table | 0.10 ms | | Sorting result | 0.01 ms | | executing | 0.01 ms | | Sending data | 0.40 ms | | Creating sort index | 0.04 ms | | end | 0.01 ms | | query end | 0.02 ms | | removing tmp table | 0.12 ms | | query end | 0.01 ms | | closing tables | 0.02 ms | | freeing items | 0.07 ms | | cleaning up | 0.05 ms |
| # | Caller | File and line number |
|---|
| 27 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 26 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 | | 25 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 | | 24 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 | | 23 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 | | 22 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 | | 21 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 | | 20 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | | 19 | JEventDispatcher->trigger() | JROOT/libraries/cms/html/content.php:41 | | 18 | JHtmlContent::prepare() | Same as call in the line below. | | 17 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 | | 16 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:146 | | 15 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/modules/mod_custom/mod_custom.php:15 | | 14 | include JROOT/modules/mod_custom/mod_custom.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 | | 13 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 | | 12 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/templates/yoo_eat/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 | | 11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/yoo_eat/layouts/theme.config.php:73 | | 10 | include JROOT/templates/yoo_eat/layouts/theme.config.php | JROOT/templates/yoo_eat/layouts/theme.php:10 | | 9 | include JROOT/templates/yoo_eat/layouts/theme.php | JROOT/templates/yoo_eat/warp/src/Warp/Helper/TemplateHelper.php:49 | | 8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/yoo_eat/index.php:16 | | 7 | require JROOT/templates/yoo_eat/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 | | 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 | | 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 | | 4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 | | 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:231 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.75 ms After last query: 4.07 ms Query memory: 0.026 MB Memory before query: 12.395 MB Rows returned: 9 SELECT
c.id AS CID
FROM
gpv25_categories AS c
LEFT JOIN
gpv25_content AS content
ON
c.id = content.catid
WHERE
1=1
AND ( c.id = 259)
AND
c.extension = 'com_content'
AND
c.published = 1 | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | c | NULL | const | PRIMARY,cat_idx | PRIMARY | 4 | const | 1 | 100.00 | NULL | | 1 | SIMPLE | content | NULL | ref | idx_catid | idx_catid | 4 | const | 9 | 100.00 | Using index |
| Status | Duration |
|---|
| starting | 0.10 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | Opening tables | 0.07 ms | | init | 0.04 ms | | System lock | 0.01 ms | | optimizing | 0.03 ms | | statistics | 0.12 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.06 ms | | cleaning up | 0.02 ms |
| # | Caller | File and line number |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 17 | JDatabaseDriver->loadObjectList() | JROOT/modules/mod_news_pro_gk5/data_sources/com_content/model.php:85 | | 16 | NSP_GK5_com_content_Model::getSources() | JROOT/modules/mod_news_pro_gk5/helper.php:100 | | 15 | NSP_GK5_Helper->getDatas() | JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:27 | | 14 | include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 | | 13 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 | | 12 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/templates/yoo_eat/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 | | 11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/yoo_eat/layouts/theme.config.php:73 | | 10 | include JROOT/templates/yoo_eat/layouts/theme.config.php | JROOT/templates/yoo_eat/layouts/theme.php:10 | | 9 | include JROOT/templates/yoo_eat/layouts/theme.php | JROOT/templates/yoo_eat/warp/src/Warp/Helper/TemplateHelper.php:49 | | 8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/yoo_eat/index.php:16 | | 7 | require JROOT/templates/yoo_eat/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 | | 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 | | 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 | | 4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 | | 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:231 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.02 ms After last query: 0.10 ms Query memory: 0.026 MB Memory before query: 12.407 MB Rows returned: 7 SELECT
content.id AS iid
FROM
gpv25_content AS content
WHERE
content.state = 1
AND content.access IN (1,1)
AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2023-05-30 17:00:33' )
AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2023-05-30 17:00:33' )
AND ( content.catid = 259 )
AND content.language in ('en-GB','*')
ORDER BY
content.created DESC
LIMIT
0,36; | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | content | NULL | ref | idx_access,idx_state,idx_catid,idx_language | idx_catid | 4 | const | 9 | 16.00 | Using index condition; Using where; Using filesort |
| Status | Duration |
|---|
| starting | 0.10 ms | | checking permissions | 0.01 ms | | Opening tables | 0.02 ms | | init | 0.05 ms | | System lock | 0.01 ms | | optimizing | 0.02 ms | | statistics | 0.16 ms | | preparing | 0.04 ms | | Sorting result | 0.01 ms | | executing | 0.01 ms | | Sending data | 0.01 ms | | Creating sort index | 0.32 ms | | end | 0.01 ms | | query end | 0.01 ms | | closing tables | 0.01 ms | | freeing items | 0.05 ms | | cleaning up | 0.02 ms |
| # | Caller | File and line number |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 | | 17 | JDatabaseDriver->loadAssocList() | JROOT/modules/mod_news_pro_gk5/data_sources/com_content/model.php:268 | | 16 | NSP_GK5_com_content_Model::getArticles() | JROOT/modules/mod_news_pro_gk5/helper.php:114 | | 15 | NSP_GK5_Helper->getDatas() | JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:27 | | 14 | include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 | | 13 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 | | 12 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/templates/yoo_eat/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 | | 11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/yoo_eat/layouts/theme.config.php:73 | | 10 | include JROOT/templates/yoo_eat/layouts/theme.config.php | JROOT/templates/yoo_eat/layouts/theme.php:10 | | 9 | include JROOT/templates/yoo_eat/layouts/theme.php | JROOT/templates/yoo_eat/warp/src/Warp/Helper/TemplateHelper.php:49 | | 8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/yoo_eat/index.php:16 | | 7 | require JROOT/templates/yoo_eat/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 | | 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 | | 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 | | 4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 | | 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:231 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.55 ms After last query: 0.04 ms Query memory: 0.090 MB Memory before query: 12.423 MB Rows returned: 7 SELECT
content.id AS iid,
content.title AS title,
content.introtext AS text,
content.created AS date,
content.publish_up AS date_publish,
content.hits AS hits,
content.images AS images,
content.featured AS frontpage,
content.access AS access,
content.language AS lang,
categories.title AS catname,
users.email AS author_email,
content.created_by_alias AS author_alias,
users.name AS author_username,
content_rating.rating_sum AS rating_sum,
content_rating.rating_count AS rating_count,
CASE WHEN CHAR_LENGTH(content.alias)
THEN CONCAT_WS(":", content.id, content.alias)
ELSE content.id END as id,
CASE WHEN CHAR_LENGTH(categories.alias)
THEN CONCAT_WS(":", categories.id, categories.alias)
ELSE categories.id END as cid
FROM
gpv25_content AS content
LEFT JOIN
gpv25_categories AS categories
ON categories.id = content.catid
LEFT JOIN
gpv25_users AS users
ON users.id = content.created_by
LEFT JOIN
gpv25_content_rating AS content_rating
ON content_rating.content_id = content.id
LEFT JOIN
gpv25_content_frontpage AS content_frontpage
ON content_frontpage.content_id = content.id
WHERE
1=1
AND ( content.id = 1864 OR content.id = 577 OR content.id = 576 OR content.id = 445 OR content.id = 233 OR content.id = 232 OR content.id = 125)
ORDER BY
content.created DESC | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | content | NULL | range | PRIMARY | PRIMARY | 4 | NULL | 7 | 100.00 | Using where; Using filesort | | 1 | SIMPLE | categories | NULL | eq_ref | PRIMARY | PRIMARY | 4 | db462563782.content.catid | 1 | 100.00 | Using where | | 1 | SIMPLE | users | NULL | eq_ref | PRIMARY | PRIMARY | 4 | db462563782.content.created_by | 1 | 100.00 | Using where | | 1 | SIMPLE | content_rating | NULL | eq_ref | PRIMARY | PRIMARY | 4 | db462563782.content.id | 1 | 100.00 | Using where | | 1 | SIMPLE | content_frontpage | NULL | eq_ref | PRIMARY | PRIMARY | 4 | db462563782.content.id | 1 | 100.00 | Using where; Using index |
| Status | Duration |
|---|
| starting | 0.21 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.14 ms | | init | 0.08 ms | | System lock | 0.01 ms | | optimizing | 0.03 ms | | statistics | 0.09 ms | | preparing | 0.03 ms | | Sorting result | 0.01 ms | | executing | 0.01 ms | | Sending data | 0.03 ms | | Creating sort index | 0.52 ms | | end | 0.04 ms | | query end | 0.01 ms | | closing tables | 0.02 ms | | freeing items | 0.05 ms | | cleaning up | 0.02 ms |
| # | Caller | File and line number |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 | | 17 | JDatabaseDriver->loadAssocList() | JROOT/modules/mod_news_pro_gk5/data_sources/com_content/model.php:332 | | 16 | NSP_GK5_com_content_Model::getArticles() | JROOT/modules/mod_news_pro_gk5/helper.php:114 | | 15 | NSP_GK5_Helper->getDatas() | JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:27 | | 14 | include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 | | 13 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 | | 12 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/templates/yoo_eat/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 | | 11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/yoo_eat/layouts/theme.config.php:73 | | 10 | include JROOT/templates/yoo_eat/layouts/theme.config.php | JROOT/templates/yoo_eat/layouts/theme.php:10 | | 9 | include JROOT/templates/yoo_eat/layouts/theme.php | JROOT/templates/yoo_eat/warp/src/Warp/Helper/TemplateHelper.php:49 | | 8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/yoo_eat/index.php:16 | | 7 | require JROOT/templates/yoo_eat/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 | | 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 | | 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 | | 4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 | | 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:231 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.06 ms After last query: 1.06 ms Query memory: 0.033 MB Memory before query: 12.556 MB Rows returned: 3 SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `gpv25_categories` AS `s`
INNER JOIN `gpv25_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('en-GB','*')) 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 = 259
ORDER BY c.lft | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | s | NULL | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | Using filesort | | 1 | SIMPLE | c | NULL | ALL | cat_idx,idx_access,idx_left_right,idx_language | NO INDEX KEY COULD BE USED | NULL | NULL | 119 | 21.16 | Using where |
| Status | Duration |
|---|
| starting | 0.14 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | Opening tables | 0.02 ms | | init | 0.06 ms | | System lock | 0.01 ms | | optimizing | 0.02 ms | | statistics | 0.16 ms | | preparing | 0.03 ms | | Sorting result | 0.01 ms | | executing | 0.01 ms | | Sending data | 0.03 ms | | Creating sort index | 0.29 ms | | end | 0.01 ms | | query end | 0.01 ms | | closing tables | 0.01 ms | | freeing items | 0.05 ms | | cleaning up | 0.02 ms |
| # | Caller | File and line number |
|---|
| 33 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 32 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 | | 31 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 | | 30 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/router.php:72 | | 29 | ContentRouter->getCategorySegment() | Same as call in the line below. | | 28 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 | | 27 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 | | 26 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 | | 25 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:676 | | 24 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 | | 23 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 | | 22 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 | | 21 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 | | 20 | Joomla\CMS\Router\Route::_() | JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:189 | | 19 | NSP_GK5_com_content_View::itemLink() | JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:22 | | 18 | NSP_GK5_com_content_View::image() | JROOT/modules/mod_news_pro_gk5/tmpl/view.php:25 | | 17 | NSP_GK5_View::header() | JROOT/modules/mod_news_pro_gk5/data_sources/com_content/controller.php:41 | | 16 | NSP_GK5_com_content_Controller->initialize() | JROOT/modules/mod_news_pro_gk5/helper.php:180 | | 15 | NSP_GK5_Helper->renderLayout() | JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:28 | | 14 | include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 | | 13 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 | | 12 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/templates/yoo_eat/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 | | 11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/yoo_eat/layouts/theme.config.php:73 | | 10 | include JROOT/templates/yoo_eat/layouts/theme.config.php | JROOT/templates/yoo_eat/layouts/theme.php:10 | | 9 | include JROOT/templates/yoo_eat/layouts/theme.php | JROOT/templates/yoo_eat/warp/src/Warp/Helper/TemplateHelper.php:49 | | 8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/yoo_eat/index.php:16 | | 7 | require JROOT/templates/yoo_eat/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 | | 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 | | 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 | | 4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 | | 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:231 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.85 ms After last query: 7.50 ms Query memory: 0.026 MB Memory before query: 12.522 MB Rows returned: 2 SELECT `c2`.`language`,`c2`.`id`
FROM `gpv25_menu` AS `c`
INNER JOIN `gpv25_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_menus.item'
INNER JOIN `gpv25_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `gpv25_menu` AS `c2`
ON a2.id = c2.`id`
WHERE c.id = 201 | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | c | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using index | | 1 | SIMPLE | a | NULL | const | PRIMARY,idx_key | PRIMARY | 206 | const,const | 1 | 100.00 | NULL | | 1 | SIMPLE | a2 | NULL | ref | idx_key | idx_key | 128 | const | 2 | 100.00 | Using index | | 1 | SIMPLE | c2 | NULL | eq_ref | PRIMARY | PRIMARY | 4 | db462563782.a2.id | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.07 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | checking permissions | 0.00 ms | | checking permissions | 0.02 ms | | Opening tables | 0.07 ms | | init | 0.04 ms | | System lock | 0.01 ms | | optimizing | 0.02 ms | | statistics | 0.16 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.03 ms | | freeing items | 0.05 ms | | cleaning up | 0.02 ms |
| # | Caller | File and line number |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/Associations.php:115 | | 17 | Joomla\CMS\Language\Associations::getAssociations() | JROOT/administrator/components/com_menus/helpers/menus.php:321 | | 16 | MenusHelper::getAssociations() | JROOT/modules/mod_languages/helper.php:58 | | 15 | ModLanguagesHelper::getList() | JROOT/modules/mod_languages/mod_languages.php:17 | | 14 | include JROOT/modules/mod_languages/mod_languages.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 | | 13 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 | | 12 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/templates/yoo_eat/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 | | 11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/yoo_eat/layouts/theme.config.php:73 | | 10 | include JROOT/templates/yoo_eat/layouts/theme.config.php | JROOT/templates/yoo_eat/layouts/theme.php:10 | | 9 | include JROOT/templates/yoo_eat/layouts/theme.php | JROOT/templates/yoo_eat/warp/src/Warp/Helper/TemplateHelper.php:49 | | 8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/yoo_eat/index.php:16 | | 7 | require JROOT/templates/yoo_eat/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 | | 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 | | 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 | | 4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 | | 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:231 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.67 ms After last query: 0.64 ms Query memory: 0.026 MB Memory before query: 12.567 MB Rows returned: 0 SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`
FROM `gpv25_categories` AS `c`
INNER JOIN `gpv25_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_categories.item'
INNER JOIN `gpv25_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `gpv25_categories` AS `c2`
ON a2.id = c2.`id`
AND c2.extension = 'com_content'
WHERE c.id = 255
AND c.extension = 'com_content'| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | no matching row in const table |
| 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 | | Opening tables | 0.03 ms | | init | 0.07 ms | | System lock | 0.01 ms | | optimizing | 0.03 ms | | statistics | 0.13 ms | | executing | 0.02 ms | | end | 0.01 ms | | query end | 0.01 ms | | closing tables | 0.01 ms | | freeing items | 0.05 ms | | cleaning up | 0.02 ms |
| # | Caller | File and line number |
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/Associations.php:115 | | 19 | Joomla\CMS\Language\Associations::getAssociations() | JROOT/administrator/components/com_categories/helpers/categories.php:113 | | 18 | CategoriesHelper::getAssociations() | JROOT/administrator/components/com_categories/helpers/association.php:44 | | 17 | CategoryHelperAssociation::getCategoryAssociations() | JROOT/components/com_content/helpers/association.php:91 | | 16 | ContentHelperAssociation::getAssociations() | JROOT/modules/mod_languages/helper.php:68 | | 15 | ModLanguagesHelper::getList() | JROOT/modules/mod_languages/mod_languages.php:17 | | 14 | include JROOT/modules/mod_languages/mod_languages.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 | | 13 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 | | 12 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/templates/yoo_eat/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 | | 11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/yoo_eat/layouts/theme.config.php:73 | | 10 | include JROOT/templates/yoo_eat/layouts/theme.config.php | JROOT/templates/yoo_eat/layouts/theme.php:10 | | 9 | include JROOT/templates/yoo_eat/layouts/theme.php | JROOT/templates/yoo_eat/warp/src/Warp/Helper/TemplateHelper.php:49 | | 8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/yoo_eat/index.php:16 | | 7 | require JROOT/templates/yoo_eat/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 | | 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 | | 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 | | 4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 | | 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:231 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
26 Query Types Logged, Sorted by Occurrences.SELECT Tables:4 × SELECT `m`.`tag_id`,`t`.*
FROM `gpv25_contentitem_tag_map` AS m
INNER JOIN `gpv25_tags` AS t
ON `m`.`tag_id` = `t`.`id` 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `gpv25_extensions` 2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `gpv25_assets` 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 `gpv25_categories` AS `s`
INNER JOIN `gpv25_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('en-GB','*')) OR (c.lft <= s.lft
AND s.rgt <= c.rgt) 1 × SELECT `data`
FROM `gpv25_session` 1 × SELECT `c2`.`language`,`c2`.`id`
FROM `gpv25_menu` AS `c`
INNER JOIN `gpv25_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_menus.item'
INNER JOIN `gpv25_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `gpv25_menu` AS `c2`
ON a2.id = c2.`id` 1 × SELECT content.id AS iid, content.title AS title, content.introtext AS text, content.created AS date, content.publish_up AS date_publish, content.hits AS hits, content.images AS images, content.featured AS frontpage, content.access AS access, content.language AS lang, categories.title AS catname, users.email AS author_email, content.created_by_alias AS author_alias, users.name AS author_username, content_rating.rating_sum AS rating_sum, content_rating.rating_count AS rating_count,
CASE WHEN CHAR_LENGTH(content.alias) THEN CONCAT_WS(":", content.id, content.alias) ELSE content.id END as id,
CASE WHEN CHAR_LENGTH(categories.alias) THEN CONCAT_WS(":", categories.id, categories.alias) ELSE categories.id END as cid
FROM gpv25_content AS content
LEFT JOIN gpv25_categories AS categories
ON categories.id = content.catid
LEFT JOIN gpv25_users AS users
ON users.id = content.created_by
LEFT JOIN gpv25_content_rating AS content_rating
ON content_rating.content_id = content.id
LEFT JOIN gpv25_content_frontpage AS content_frontpage
ON content_frontpage.content_id = content.id 1 × SELECT content.id AS iid
FROM gpv25_content AS content 1 × SELECT c.id AS CID
FROM gpv25_categories AS c
LEFT JOIN gpv25_content AS content
ON c.id = content.catid 1 × SELECT DISTINCT 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 gpv25_fields AS a
LEFT JOIN `gpv25_languages` AS l
ON l.lang_code = a.language
LEFT JOIN gpv25_users AS uc
ON uc.id=a.checked_out
LEFT JOIN gpv25_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN gpv25_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN gpv25_fields_groups AS g
ON g.id = a.group_id 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM gpv25_modules AS m
LEFT JOIN gpv25_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN gpv25_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id 1 × SELECT DISTINCT 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 gpv25_fields AS a
LEFT JOIN `gpv25_languages` AS l
ON l.lang_code = a.language
LEFT JOIN gpv25_users AS uc
ON uc.id=a.checked_out
LEFT JOIN gpv25_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN gpv25_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN gpv25_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `gpv25_fields_categories` AS fc
ON fc.field_id = a.id 1 × SELECT COUNT(*)
FROM gpv25_content AS a
LEFT JOIN gpv25_categories AS c
ON c.id = a.catid
LEFT JOIN gpv25_users AS ua
ON ua.id = a.created_by
LEFT JOIN gpv25_users AS uam
ON uam.id = a.modified_by
LEFT JOIN gpv25_categories as parent
ON parent.id = c.parent_id
LEFT JOIN gpv25_content_rating AS v
ON a.id = v.content_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,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 gpv25_content AS a
LEFT JOIN gpv25_categories AS c
ON c.id = a.catid
LEFT JOIN gpv25_users AS ua
ON ua.id = a.created_by
LEFT JOIN gpv25_users AS uam
ON uam.id = a.modified_by
LEFT JOIN gpv25_categories as parent
ON parent.id = c.parent_id
LEFT JOIN gpv25_content_rating AS v
ON a.id = v.content_id 1 × SELECT `session_id`
FROM `gpv25_session` 1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,( SELECT COUNT(i.`id`)
FROM `gpv25_content` AS `i` 1 × SELECT id, home, template, s.params
FROM gpv25_template_styles as s
LEFT JOIN gpv25_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id 1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM gpv25_menu AS m
LEFT JOIN gpv25_extensions AS e
ON m.component_id = e.extension_id 1 × SELECT `element`,`name`,`client_id`,`extension_id`
FROM `gpv25_extensions` 1 × SELECT *
FROM gpv25_languages 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM gpv25_extensions 1 × SELECT b.id
FROM gpv25_usergroups AS a
LEFT JOIN gpv25_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt 1 × SELECT id, rules
FROM `gpv25_viewlevels 1 × SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`
FROM `gpv25_categories` AS `c`
INNER JOIN `gpv25_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_categories.item'
INNER JOIN `gpv25_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `gpv25_categories` AS `c2`
ON a2.id = c2.`id`
AND c2.extension = 'com_content'
OTHER Tables:1 × INSERT INTO `gpv25_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3234643662363230306264373264653832666335376666636662666631303539', 1, 1685458833, 0, '', 0 1 × UPDATE `gpv25_extensions`
SET `params` = '{\"mediaversion\":\"c5f49027732ff4a89b4b07301d1e9140\"}'
| |
Administrator
