|
Cueillir les prunes lorsque le fruit se détache facilement de la queue. Ces prunes acides ont l'avantage de contenir beaucoup de pectine, ce qui les rend faciles à gélifier. De plus, elles conservent leur jolie couleur d'un rouge lumineux, même après cuisson.
Recette de confiture de rhubarbe au citron
|
| Auteur Martine Acknin |
 |
Pour 4 pots de 35 cl
- 1kg de rhubarbe
- 800g de sucre
- 2 petits citrons bio
- 2 gousses de vanille
- 13 g de pectine
- marmite
|
| Difficulté: Facile Préparation: 60 minutes Cuisson: 20 minutes Repos: 24 heures |
|
L'accord de la rhubarbe avec le citron est parfait pour obtenir la bonne texture. En effet, la pectine contenue dans le citron équilibre le côté aqueux de la rhubarbe. Penser à commencer la recette la veille.
|
With a soft crumbly texture
|
|
Makes 35 à 40 biscuits:
- 250g flour
- 125g caster sugar
- 125g softened butter,
cut into small pieces
- zest of 1 lemon
- 1 pinch of salt
- 1 small egg(50g)
- icing(optional):
- white of a small egg
- 60g icing sugar
|
- In a large bowl, mix the flour, salt, sugar and butter. Rub the fat into the flour. Make sure that you don’t work the mixture for longer than 5 minutes or the butter will become too soft in contact with your fingers. This can also be done in a food mixer: stop before the mixture binds together and becomes a dough.
- Mix in the egg to obtain a smooth dough. If you’re using a food mixer, this will take 30 seconds.
Shape the dough into a ball, place it between tow sheets of floured baking parchment and roll it out with a rolling pin to a thickness of 5 or 6 mm. Place it on a baking sheet, still within the sheets of baking parchment, and refrigerate for an hour.
- Preheat the oven to 160°.
- The dough will be firm after an hour and easier to cut. Remove the baking parchment and cut different shapes, such as stars, moons or hearts. Place the biscuits on a baking sheet lined with fresh baking parchment and bake for 15 to 20 minutes.
- Leave to cool, then sprinkle with icing sugar .
- Variation: For those of you who are brave enough, instead of sprinkling with icing sugar, you can decorate them with a royal icing:
- In a bowl, mix 20g of egg white with 60g icing sugar, whisk it briskly with a fork. Then simply coat each biscuit with a brushful of the icing mixture.
- Leave to harden overnight.
 
Moons:
|
Based on a Baked Alaska, this yule log is filled with vanilla ice cream and coated with meringue.
|
|
For 10 :
The coloured filling :
- 43g white chocolate
- 60g milk
- 1/3 leaf of gélatine
- 8 drops red colouring
The genoise sponge:
- 125g sieved plain flour
- 125g caster sugar
- 225g eggs (4 medium)
- 1 baking tray 30*40cm
- 50cl vanilla ice-cream
For flavouring:
- 1tbsp white rum or kirsch
- 30 maraschino cherries
- 2tbsp de rhum
For the meringue:
- 60g egg white(2medium)
- 100g caster sugar
|
You will achieve a better result with bought ice cream as it is easier to spread.
- Prior preparation:
Put the cherries to macerate in a jar with the rum. Prepare the coloured filling, this will highlight the typical spiral of a swiss roll.Melt the grated chocolate with the milk warmed to 45 -50°. Mix well, then add the gelatine which you have soaked in cold water and then drained. Leave to melt, then add the 8 drops red food colouring and mix again. Refrigerate. The mixture will set like a jelly.
- Making the sponge :
Pre-heat the oven to 170°; line the baking tray with baking parchment.In the bowl of your mixer, beat the eggs and sugar for 10 mins at medium speed till they are light and frothy. Add the flour in three lots, folding it in with a spatula. Turn the mixture onto the baking tray, level the surface and cook for 15-17mins, taking care that the cake does no more than colour slightly. When it is cooked, turn it onto a seconds sheet of baking parchment and refrigerate between the sheets of paper for 30mins.
- Assemblin the yule log:{mosimage}{mosimage} {mosimage}
Remove the top sheet of baking paper. Sprinkle the sponge with a few drops of white rum. No need to drench the cake as it is moist and supple enough. Spread the coloured filling thinly and evenly over the sponge. Take the ice cream out of the freezer and spread in spoonfuls over the filling, taking no longer than 3mins. Push the cherries into the ice cream at regular intervals. Finally, roll up the sponge, using the paper to keep the shape. Envelop the whole thing in a sheet of tinfoil and put in the freezer overnight.
- Decoration (can be done later) :
Preparing the meringue:
Whip the eggwhites till stiff and incorporate the sugar in two lots, beat for a further minute. Pre-heat the oven to 210°. Remove the log from the freezer, coat completely with ¾ of the meringue, smoothed over with a spatula. Comb with a fork to form a pattern and either pipe the remaining meringue in whorls on top or use it to decorate with a fork. Change the oven setting to grill and cook the cake for no longer than 4 mins, until the meringue has coloured. Stay close to the oven to check that the top doesn’t burn.
- You can put the yule log in the freezer if you don’t intend to eat it immediately. If you need to keep it longer than a day, you should wrap it in clingfilm to prevent it drying out.
This yule Log will keep up to 30 days in the freezer.
Recette des petits gâteaux au chocolat et à la cerise
|
| Auteur Martine Acknin |
 |
Pour 6 gâteaux:
- 1 oeuf moyen
- 65g de sucre
- 80g crème liquide entière
- 60g farine de blé
- 3g cacao noir en poudre
- 1,5g levure chimique
- 6 cerises confites
- plaque silicone de 6 moules à cake
- 140g de pâte à sucre rouge
|
| Difficulté: Facile. Préparation: 90 minutes. Cuisson: 30 minutes. |
|
Ces petits gâteaux ont une texture moëlleuse et gourmande. Grâce à l'enrobage en pâte à sucre, ils se conservent une semaine et vous pourrez ensuite les décorer à votre goût pour fêter un événement par exemple.
Recette de gâteau roulé au tahiné et au chocolat
|
| Auteur Martine Acknin |
 |
Pour 8à10 personnes:
Pour le biscuit:
- 3 gros oeufs (150g hors coquille)
- 90g de sucre
- 90g de farine tamisée
- 1/2 zeste de citron
- une plaque de cuisson 40x30cm
- 2 feuilles 40x30 de papier sulfurisé
Pour le sirop:
- 75g de jus de citron
- 90g d'eau
- 90g de sucre
- 4 tours de moulin de poivre Tellicherry
Pour la garniture:
- 150g de tahiné (purée de sésame)
- 180 g chocolat dessert râpé
- 50g de crème liquide entière
|
| Difficulté: Moyenne Préparation: 30 minutes Cuisson: 10 minutes Repos: 120 minutes |
|
C'est un gâteau roulé délicieux par ses saveurs bien dosées, et qui permet de profiter des bienfaits du sésame!
Recette de torsades feuilletées
|
| Auteur Martine Acknin |
 |
Pour 30 à 40 biscuits
- 200g de farine
- 100g d'eau froide
- pincée de sel
- 140g de beurre
- 60g sucre en poudre
- pincée de canelle
- papier sulfurisé
- plaque de cuisson
|
| Difficulté: Moyenne Préparation: 90+20 minutes Cuisson: 15minutes Repos: 60minutes |
|
Ces biscuits vous serviront pour accompagner de façon élégante un dessert frais ou glacé. Et vous pourrez aussi les croquer à volonté....
Recette de gâteau aux pommes topping crumble
|
| Auteur Martine Acknin |
 |
Pour 18 petits gâteaux(6personnes):
Pour le gâteau:
- 3 oeufs moyens
- 100g de sucre
- 70g de lait
- 230g de farine tamisée
- 1/2 sachet de levure chimique…
- 60g huile de tournesol
- 2 pommes golden
- 2c.à.s de rhum
Pour le crumble:
- 50g de farine
- 50g de sucre
- 50g de beurre froid
|
| Difficulté: Facile Préparation: 20 minutes Cuisson: 25 minutes Repos: 0 minutes |
|
C'est un gâteau craquant en surface , pour étonner vos invités. Vous ferez macérer les dés de pommes dans du rhum pour le rendre irrésistible. La recette peut être faite dans un moule à manqué de 22cm, ou bien dans des moules à muffins , pour avoir des portions individuelles.
Recette de muffins au kiwi
|
| Auteur Martine Acknin |
 |
Pour 12 muffins:
- 6 kiwis
- 2 oeufs moyens
- 100g de sucre
- 100g de farine
- 1/2 sachet levure chimique
- 1 zeste d'orange
- 1 zeste de citron
- 100g beurre fondu et refroidi
- plaque de 12 moules à muffins
|
| Difficulté: Facile Préparation: 20 minutes Cuisson: 20 minutes Repos: 0 minutes |
|
De délicieux petits gâteaux aux fruits que l'on déguste sans attendre.
Recette de tartelettes au lemon curd.
|
| Auteur Martine Acknin |
Tartelettes rectangulaires: |
Pour 8 tartelettes:
Pour la pâte sablée:
- 250g de farine froide
- 125g de sucre en poudre
- 125g de beurre froid
- 1 pincée de sel
- 4 jaunes d'oeufs
- plaque silicone de 8 moules
Pour le lemon curd:
- 3 jus de citron (100g)et 3 zestes de citron
- 3 oeufs moyens
- 135g de sucre en poudre
- 1 c.à.s rase de farine
Pour le décor:
- 1 blanc d'oeuf
- 50g de sucre en poudre
- ou bien des petites meringues toutes prêtes
- fruits de saison
|
| Difficulté: Moyenne Préparation: 60 minutes Cuisson: 20 minutes Repos: 2 heures |
|
…
Recette de Granola
|
| Auteur Martine Acknin |
 |
Pour un bocal de 75cl environ:
- 1 blanc d'oeuf
- 1 c.à.s d'huile d'olive
- 1 c.à.s de miel liquide
- 1c.à.s d'oranges confites coupées en petits dés
- 2c.à.s de graines de lin ou autres suivant les goûts
- 2c.à.s de poudre d'amandes
- 200g de flocons d'avoine
- 50g d'amandes coupées en deux
|
| Difficulté: Facile Préparation: 20 minutes Cuisson: 20 minutes Repos: 0 minutes |
|
C'est un mélange de flocons d'avoine et d'amandes, le tout agrémenté de graines et parfumé de miel et d'orange. Ce mélange, une fois torréfié, donne une texture croustillante, à servir avec un yaourt ou du fromage blanc pour le petit déjeuner. C'est une sorte de Musli sans fruits, mais plus délicat. c'est une recette sans gluten.
Recette de brioche facile
|
| Auteur Martine Acknin |
 |
Pour deux grosses brioches:
- 500g farine T55
- 1 sachet de levure boulangère en granules
- 80g de lait
- 50g de sucre
- 3 gros oeufs ou 4 moyens
- 4 c.à.s de sirop d'orange
- 100g de beurre 1/2sel mou
- 2 moules à cake
|
| Difficulté: Facile. Préparation: 25 minutes. Cuisson: 40 minutes. Repos: 3 à 4 heures |
|
C'est une brioche très légère car elle est enfournée dans un four froid. Gourmande par son parfum d'orange, vous la dégusterez pour le petit déjeuner de Pâques. Si vous n'avez pas de sirop d'orange, remplacer par une c.à.s d'eau de fleur d'oranger additionnée d'une c.à.s d'eau.
Nougatine recipe
|
| Par gateaupassion.com |
 |
For serves 8:
- 80g hazelnuts
- 80g almonds
- 220g caster sugar
- baking parchment
- rolling pin
|
| Difficulty: Easy, Prep time: 20 minutes, baking time:10 min. Rest: 0 minutes |
|
A delicious candy to taste and to offer.
|
- Pre-heat oven to 338F.
- Grill the fruits in a cooking pan. Remove the skin from the hazelnuts. Leave to cool, then place in a cloth, and crush them with the rolling pin. Check and set aside.
- Prepare a sheet of baking parchment of 30X50cm.
- Using a sauce pan of 15cm, put the sugar on medium fire until it become golden. As soon as the caramel is golden, throw in the almonds ans hazelnuts, and mix gently with a spatula. Immediately pour onto the sheet of baking parchment, fold the sheet allowing nougatine to be between the two sheets , and roll the dough to 5mm thick, using the rolling pin. The nougatine gets hard when it is cold.
- Remove the top sheet, and cut the nougatine into strips. Then wrap around a small roll or pen. If you want to soften the dough, you can easily heat it inside the oven at 330°F.
- if you don't want to make a decoration, just let cool and break into pieces to taste like candy.
Bon appétit !
|
Look at nougatine glacé recipe.
|
Liens utiles
Joomla! Debug Console{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1685459133,
"last": 1685459133,
"now": 1685459133
}
},
"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: 20.94 ms / 20.94 ms Memory: 2.024 MB / 2.39 MB Application: afterLoad Time: 67.64 ms / 88.57 ms Memory: 4.504 MB / 6.90 MB Application: afterInitialise Time: 6.12 ms / 94.69 ms Memory: 0.556 MB / 7.45 MB Application: afterRoute Time: 6.42 ms / 101.12 ms Memory: 0.284 MB / 7.74 MB Application: beforeRenderComponent com_content Time: 6.33 ms / 107.45 ms Memory: 0.675 MB / 8.41 MB Application: Before Access::preloadComponents (all components) Time: 1.84 ms / 109.29 ms Memory: 0.059 MB / 8.47 MB Application: After Access::preloadComponents (all components) Time: 0.08 ms / 109.37 ms Memory: -0.005 MB / 8.47 MB Application: Before Access::getAssetRules (id:8 name:com_content) Time: 0.50 ms / 109.87 ms Memory: 0.027 MB / 8.49 MB Application: After Access::getAssetRules (id:8 name:com_content) Time: 81.81 ms / 191.68 ms Memory: 2.464 MB / 10.96 MB Application: afterRenderComponent com_content Time: 2.67 ms / 194.34 ms Memory: 0.204 MB / 11.16 MB Application: afterDispatch Time: 4.97 ms / 199.31 ms Memory: 0.335 MB / 11.50 MB Application: beforeRenderModule mod_custom (Martine EN) Time: 3.19 ms / 202.50 ms Memory: 0.039 MB / 11.53 MB Application: afterRenderModule mod_custom (Martine EN) Time: 0.37 ms / 202.86 ms Memory: 0.085 MB / 11.62 MB Application: beforeRenderModule mod_news_pro_gk5 (gâteaux pour Pâques) Time: 15.64 ms / 218.50 ms Memory: 0.702 MB / 12.32 MB Application: afterRenderModule mod_news_pro_gk5 (gâteaux pour Pâques) Time: 0.11 ms / 218.61 ms Memory: -0.180 MB / 12.14 MB Application: beforeRenderModule mod_custom (Follow) Time: 0.37 ms / 218.98 ms Memory: 0.003 MB / 12.14 MB Application: afterRenderModule mod_custom (Follow) Time: 0.06 ms / 219.04 ms Memory: 0.001 MB / 12.15 MB Application: beforeRenderModule mod_custom (Liens gourmands) Time: 0.25 ms / 219.29 ms Memory: 0.004 MB / 12.15 MB Application: afterRenderModule mod_custom (Liens gourmands) Time: 0.02 ms / 219.31 ms Memory: 0.000 MB / 12.15 MB Application: beforeRenderModule mod_custom (Liens utiles) Time: 0.30 ms / 219.61 ms Memory: 0.003 MB / 12.15 MB Application: afterRenderModule mod_custom (Liens utiles) Time: 0.05 ms / 219.66 ms Memory: 0.002 MB / 12.15 MB Application: beforeRenderModule mod_languages (Choix de la langue) Time: 4.10 ms / 223.76 ms Memory: 0.129 MB / 12.28 MB Application: afterRenderModule mod_languages (Choix de la langue) Time: 0.05 ms / 223.81 ms Memory: -0.003 MB / 12.28 MB Application: beforeRenderModule mod_syndicate (Flux RSS) Time: 0.58 ms / 224.39 ms Memory: 0.009 MB / 12.29 MB Application: afterRenderModule mod_syndicate (Flux RSS) Time: 0.12 ms / 224.51 ms Memory: 0.002 MB / 12.29 MB Application: beforeRenderModule mod_search (Trouver une recette :) Time: 1.25 ms / 225.76 ms Memory: 0.018 MB / 12.31 MB Application: afterRenderModule mod_search (Trouver une recette :) Time: 3.21 ms / 228.96 ms Memory: 0.090 MB / 12.40 MB Application: beforeRenderModule mod_search (Find a recipe) Time: 0.71 ms / 229.68 ms Memory: 0.007 MB / 12.41 MB Application: afterRenderModule mod_search (Find a recipe) Time: 0.74 ms / 230.41 ms Memory: 0.001 MB / 12.41 MB Application: beforeRenderModule mod_menu (Menu Principal) Time: 3.33 ms / 233.75 ms Memory: 0.167 MB / 12.58 MB Application: afterRenderModule mod_menu (Menu Principal) Time: 6.07 ms / 239.82 ms Memory: 0.121 MB / 12.70 MB Application: beforeRenderModule mod_phocagoogleadsense (Google AdSense Top) Time: 0.27 ms / 240.09 ms Memory: 0.008 MB / 12.70 MB Application: afterRenderModule mod_phocagoogleadsense (Google AdSense Top) Time: 2.24 ms / 242.33 ms Memory: 0.016 MB / 12.72 MB Application: beforeRenderModule mod_menu (Plan du site) Time: 1.17 ms / 243.50 ms Memory: 0.017 MB / 12.74 MB Application: afterRenderModule mod_menu (Plan du site) Time: 1.20 ms / 244.70 ms Memory: 0.001 MB / 12.74 MB Application: beforeRenderModule mod_search (Recherche smartphone) Time: 0.69 ms / 245.39 ms Memory: 0.005 MB / 12.74 MB Application: afterRenderModule mod_search (Recherche smartphone) Time: 0.05 ms / 245.45 ms Memory: -0.001 MB / 12.74 MB Application: beforeRenderModule mod_menu (Menu Smartphone) Time: 1.45 ms / 246.89 ms Memory: 0.005 MB / 12.75 MB Application: afterRenderModule mod_menu (Menu Smartphone) Time: 3.64 ms / 250.53 ms Memory: 0.102 MB / 12.85 MB Application: afterRender Database queries total: 68.92 ms 13.61 MB (14,270,464 Bytes) 58 Queries Logged 68.92 msQuery Time: 0.32 ms Query memory: 0.023 MB Memory before query: 4.163 MB Rows returned: 0 SELECT `data`
FROM `gpv25_session`
WHERE `session_id` = X'6432333863356562666230663634353039366431633736633063363366643561' | 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.03 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.00 ms | | closing tables | 0.01 ms | | freeing items | 0.02 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.32 ms After last query: 1.08 ms Query memory: 0.020 MB Memory before query: 4.259 MB Rows returned: 0 SELECT `session_id`
FROM `gpv25_session`
WHERE `session_id` = X'6432333863356562666230663634353039366431633736633063363366643561'
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.04 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.03 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.68 ms After last query: 0.12 ms Query memory: 0.004 MB Memory before query: 4.264 MB INSERT INTO `gpv25_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
(X'6432333863356562666230663634353039366431633736633063363366643561', 1, 1685459133, 0, '', 0) EXPLAIN not possible on query: INSERT INTO `gpv25_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(X'6432333863356562666230663634353039366431633736633063363366643561', 1, 1685459133, 0, '', 0) | Status | Duration |
|---|
| starting | 0.03 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | init | 0.03 ms | | System lock | 0.01 ms | | update | 0.12 ms | | end | 0.01 ms | | query end | 2.30 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.67 ms After last query: 2.53 ms Query memory: 0.024 MB Memory before query: 4.452 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.03 ms | | init | 0.02 ms | | System lock | 0.01 ms | | optimizing | 0.01 ms | | statistics | 0.04 ms | | preparing | 0.01 ms | | executing | 0.00 ms | | Sending data | 0.16 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 |
|---|
| 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.45 ms After last query: 2.61 ms Query memory: 0.021 MB Memory before query: 4.706 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.04 ms | | checking permissions | 0.01 ms | | Opening tables | 0.03 ms | | init | 0.01 ms | | System lock | 0.01 ms | | optimizing | 0.00 ms | | statistics | 0.01 ms | | preparing | 0.01 ms | | executing | 0.00 ms | | Sending data | 0.04 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.12 ms Query memory: 0.021 MB Memory before query: 4.717 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.05 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.42 ms After last query: 0.71 ms Query memory: 0.030 MB Memory before query: 4.786 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.03 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.96 ms | | end | 0.01 ms | | query end | 0.03 ms | | closing tables | 0.01 ms | | freeing items | 0.04 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: 3.12 ms After last query: 1.30 ms Query memory: 0.020 MB Memory before query: 4.900 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.02 ms | | preparing | 0.01 ms | | Sorting result | 0.00 ms | | executing | 0.00 ms | | Sending data | 0.01 ms | | Creating sort index | 0.07 ms | | end | 0.00 ms | | query end | 0.01 ms | | closing tables | 0.02 ms | | freeing items | 0.02 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: 1.06 ms After last query: 5.57 ms Query memory: 0.021 MB Memory before query: 5.504 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.03 ms | | checking permissions | 0.00 ms | | Opening tables | 0.01 ms | | init | 0.01 ms | | System lock | 0.01 ms | | optimizing | 0.01 ms | | statistics | 0.03 ms | | preparing | 0.01 ms | | executing | 0.00 ms | | Sending data | 0.04 ms | | end | 0.00 ms | | query end | 0.01 ms | | closing tables | 0.00 ms | | freeing items | 0.02 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.21 ms After last query: 10.07 ms Query memory: 0.085 MB Memory before query: 6.616 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.06 ms | | checking permissions | 0.00 ms | | checking permissions | 0.00 ms | | Opening tables | 0.02 ms | | init | 0.02 ms | | System lock | 0.01 ms | | optimizing | 0.01 ms | | statistics | 0.06 ms | | preparing | 0.02 ms | | Sorting result | 0.01 ms | | executing | 0.00 ms | | Sending data | 0.01 ms | | Creating sort index | 0.68 ms | | end | 0.04 ms | | query end | 0.01 ms | | closing tables | 0.02 ms | | freeing items | 0.03 ms | | cleaning up | 0.01 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.42 ms After last query: 7.92 ms Query memory: 0.022 MB Memory before query: 7.486 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.04 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | init | 0.02 ms | | System lock | 0.02 ms | | optimizing | 0.02 ms | | statistics | 0.07 ms | | preparing | 0.01 ms | | executing | 0.01 ms | | Sending data | 0.03 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 |
|---|
| 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: 2.97 ms After last query: 0.13 ms Query memory: 0.005 MB Memory before query: 7.477 MB UPDATE `gpv25_extensions`
SET `params` = '{\"mediaversion\":\"92fa20e3dae4fb44bad43f1954bf3fc5\"}'
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.03 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | init | 0.02 ms | | System lock | 0.06 ms | | updating | 0.07 ms | | end | 0.01 ms | | query end | 2.58 ms | | closing tables | 0.02 ms | | freeing items | 0.03 ms | | cleaning up | 0.01 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: 0.65 ms After last query: 1.74 ms Query memory: 0.020 MB Memory before query: 7.731 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.05 ms | | checking permissions | 0.00 ms | | checking permissions | 0.00 ms | | Opening tables | 0.02 ms | | init | 0.02 ms | | System lock | 0.01 ms | | optimizing | 0.03 ms | | statistics | 0.11 ms | | preparing | 0.02 ms | | executing | 0.00 ms | | Sending data | 0.16 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 |
|---|
| 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: 1.59 ms After last query: 6.66 ms Query memory: 0.028 MB Memory before query: 8.415 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.08 ms | | checking permissions | 0.01 ms | | Opening tables | 0.03 ms | | init | 0.14 ms | | System lock | 0.01 ms | | optimizing | 0.01 ms | | statistics | 0.25 ms | | preparing | 0.03 ms | | executing | 0.00 ms | | Sending data | 0.72 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 |
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 | | 19 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 | | 18 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 | | 17 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 | | 16 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 | | 15 | Joomla\CMS\User\User->authorise() | JROOT/components/com_content/models/articles.php:115 | | 14 | ContentModelArticles->populateState() | JROOT/components/com_content/models/featured.php:45 | | 13 | ContentModelFeatured->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 | | 12 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/libraries/src/MVC/View/HtmlView.php:425 | | 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_content/views/featured/view.html.php:55 | | 10 | ContentViewFeatured->display() | JROOT/libraries/src/MVC/Controller/BaseController.php: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: 5.04 ms After last query: 1.76 ms Query memory: 0.115 MB Memory before query: 8.549 MB Rows returned: 13 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.featured = 1
AND a.access IN (1,1)
AND c.access IN (1,1)
AND c.published = 1
AND a.state IN (0,1,2)
AND a.language IN ('en-GB','*')
ORDER BY c.path, a.title, a.created DESC
LIMIT 30 | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | NULL | ref | idx_access,idx_state,idx_catid,idx_featured_catid,idx_language | idx_featured_catid | 1 | const | 26 | 100.00 | Using where; Using temporary; Using filesort | | 1 | SIMPLE | c | NULL | eq_ref | PRIMARY,idx_access | PRIMARY | 4 | db462563782.a.catid | 1 | 9.83 | 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 | eq_ref | PRIMARY | PRIMARY | 4 | db462563782.c.parent_id | 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.37 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | checking permissions | 0.03 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | Opening tables | 0.14 ms | | init | 0.21 ms | | System lock | 0.03 ms | | optimizing | 0.03 ms | | statistics | 0.46 ms | | preparing | 0.07 ms | | Creating tmp table | 0.19 ms | | Sorting result | 0.02 ms | | executing | 0.01 ms | | Sending data | 1.99 ms | | Creating sort index | 0.70 ms | | end | 0.02 ms | | query end | 0.05 ms | | removing tmp table | 0.25 ms | | query end | 0.02 ms | | closing tables | 0.04 ms | | freeing items | 0.07 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/MVC/Model/BaseDatabaseModel.php:322 | | 15 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 | | 14 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_content/models/articles.php:576 | | 13 | ContentModelArticles->getItems() | JROOT/components/com_content/models/featured.php:126 | | 12 | ContentModelFeatured->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 | | 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_content/views/featured/view.html.php:56 | | 10 | ContentViewFeatured->display() | JROOT/libraries/src/MVC/Controller/BaseController.php: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.00 ms After last query: 2.36 ms Query memory: 0.023 MB Memory before query: 8.824 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.article'
AND `m`.`content_item_id` = 1955
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.10 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | Opening tables | 0.04 ms | | init | 0.07 ms | | System lock | 0.01 ms | | optimizing | 0.03 ms | | statistics | 0.12 ms | | preparing | 0.03 ms | | executing | 0.01 ms | | Sending data | 0.16 ms | | end | 0.01 ms | | query end | 0.01 ms | | closing tables | 0.03 ms | | freeing items | 0.08 ms | | cleaning up | 0.02 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 | | 14 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:706 | | 13 | ContentModelArticles->getItems() | JROOT/components/com_content/models/featured.php:126 | | 12 | ContentModelFeatured->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 | | 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_content/views/featured/view.html.php:56 | | 10 | ContentViewFeatured->display() | JROOT/libraries/src/MVC/Controller/BaseController.php: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.33 ms After last query: 0.28 ms Query memory: 0.024 MB Memory before query: 8.843 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.article'
AND `m`.`content_item_id` = 1968
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.09 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | Opening tables | 0.03 ms | | init | 0.06 ms | | System lock | 0.01 ms | | optimizing | 0.04 ms | | statistics | 1.57 ms | | preparing | 0.04 ms | | executing | 0.01 ms | | Sending data | 0.16 ms | | end | 0.01 ms | | query end | 0.01 ms | | closing tables | 0.02 ms | | freeing items | 0.05 ms | | cleaning up | 0.04 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 | | 14 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:706 | | 13 | ContentModelArticles->getItems() | JROOT/components/com_content/models/featured.php:126 | | 12 | ContentModelFeatured->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 | | 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_content/views/featured/view.html.php:56 | | 10 | ContentViewFeatured->display() | JROOT/libraries/src/MVC/Controller/BaseController.php: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.95 ms After last query: 0.33 ms Query memory: 0.023 MB Memory before query: 8.862 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.article'
AND `m`.`content_item_id` = 1795
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.10 ms | | checking permissions | 0.01 ms | | checking permissions | 0.02 ms | | Opening tables | 0.02 ms | | init | 0.04 ms | | System lock | 0.01 ms | | optimizing | 0.02 ms | | statistics | 0.06 ms | | preparing | 0.02 ms | | executing | 0.00 ms | | Sending data | 0.10 ms | | end | 0.01 ms | | query end | 0.02 ms | | closing tables | 0.01 ms | | freeing items | 0.04 ms | | cleaning up | 0.08 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 | | 14 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:706 | | 13 | ContentModelArticles->getItems() | JROOT/components/com_content/models/featured.php:126 | | 12 | ContentModelFeatured->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 | | 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_content/views/featured/view.html.php:56 | | 10 | ContentViewFeatured->display() | JROOT/libraries/src/MVC/Controller/BaseController.php: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.69 ms After last query: 0.28 ms Query memory: 0.023 MB Memory before query: 8.877 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.article'
AND `m`.`content_item_id` = 1850
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.04 ms | | init | 0.04 ms | | System lock | 0.01 ms | | optimizing | 0.01 ms | | statistics | 0.15 ms | | preparing | 0.02 ms | | executing | 0.00 ms | | Sending data | 0.09 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:1701 | | 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 | | 14 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:706 | | 13 | ContentModelArticles->getItems() | JROOT/components/com_content/models/featured.php:126 | | 12 | ContentModelFeatured->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 | | 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_content/views/featured/view.html.php:56 | | 10 | ContentViewFeatured->display() | JROOT/libraries/src/MVC/Controller/BaseController.php: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.75 ms After last query: 0.21 ms Query memory: 0.023 MB Memory before query: 8.894 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.article'
AND `m`.`content_item_id` = 1945
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.04 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.24 ms | | end | 0.01 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 |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 | | 14 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:706 | | 13 | ContentModelArticles->getItems() | JROOT/components/com_content/models/featured.php:126 | | 12 | ContentModelFeatured->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 | | 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_content/views/featured/view.html.php:56 | | 10 | ContentViewFeatured->display() | JROOT/libraries/src/MVC/Controller/BaseController.php: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.29 ms Query memory: 0.023 MB Memory before query: 8.911 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.article'
AND `m`.`content_item_id` = 1984
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.02 ms | | Opening tables | 0.02 ms | | init | 0.03 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.09 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:1701 | | 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 | | 14 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:706 | | 13 | ContentModelArticles->getItems() | JROOT/components/com_content/models/featured.php:126 | | 12 | ContentModelFeatured->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 | | 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_content/views/featured/view.html.php:56 | | 10 | ContentViewFeatured->display() | JROOT/libraries/src/MVC/Controller/BaseController.php: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.02 ms After last query: 0.23 ms Query memory: 0.023 MB Memory before query: 8.928 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.article'
AND `m`.`content_item_id` = 1965
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.00 ms | | Opening tables | 0.01 ms | | init | 0.03 ms | | System lock | 0.01 ms | | optimizing | 0.01 ms | | statistics | 0.06 ms | | preparing | 0.02 ms | | executing | 0.00 ms | | Sending data | 0.08 ms | | end | 0.01 ms | | query end | 0.01 ms | | closing tables | 0.01 ms | | freeing items | 0.03 ms | | cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 | | 14 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:706 | | 13 | ContentModelArticles->getItems() | JROOT/components/com_content/models/featured.php:126 | | 12 | ContentModelFeatured->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 | | 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_content/views/featured/view.html.php:56 | | 10 | ContentViewFeatured->display() | JROOT/libraries/src/MVC/Controller/BaseController.php: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.56 ms After last query: 0.21 ms Query memory: 0.023 MB Memory before query: 8.945 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.article'
AND `m`.`content_item_id` = 1959
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.02 ms | | init | 0.03 ms | | System lock | 0.01 ms | | optimizing | 0.01 ms | | statistics | 0.06 ms | | preparing | 0.02 ms | | executing | 0.00 ms | | Sending data | 0.08 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 |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 | | 14 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:706 | | 13 | ContentModelArticles->getItems() | JROOT/components/com_content/models/featured.php:126 | | 12 | ContentModelFeatured->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 | | 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_content/views/featured/view.html.php:56 | | 10 | ContentViewFeatured->display() | JROOT/libraries/src/MVC/Controller/BaseController.php: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.50 ms After last query: 0.20 ms Query memory: 0.023 MB Memory before query: 8.962 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.article'
AND `m`.`content_item_id` = 1947
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.03 ms | | System lock | 0.01 ms | | optimizing | 0.01 ms | | statistics | 0.06 ms | | preparing | 0.02 ms | | executing | 0.00 ms | | Sending data | 0.09 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 |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 | | 14 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:706 | | 13 | ContentModelArticles->getItems() | JROOT/components/com_content/models/featured.php:126 | | 12 | ContentModelFeatured->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 | | 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_content/views/featured/view.html.php:56 | | 10 | ContentViewFeatured->display() | JROOT/libraries/src/MVC/Controller/BaseController.php: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.57 ms After last query: 0.25 ms Query memory: 0.023 MB Memory before query: 8.979 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.article'
AND `m`.`content_item_id` = 1953
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.03 ms | | init | 0.05 ms | | System lock | 0.01 ms | | optimizing | 0.01 ms | | statistics | 0.06 ms | | preparing | 0.02 ms | | executing | 0.00 ms | | Sending data | 0.08 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 |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 | | 14 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:706 | | 13 | ContentModelArticles->getItems() | JROOT/components/com_content/models/featured.php:126 | | 12 | ContentModelFeatured->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 | | 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_content/views/featured/view.html.php:56 | | 10 | ContentViewFeatured->display() | JROOT/libraries/src/MVC/Controller/BaseController.php: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.55 ms After last query: 0.21 ms Query memory: 0.023 MB Memory before query: 8.996 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.article'
AND `m`.`content_item_id` = 1944
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.03 ms | | System lock | 0.01 ms | | optimizing | 0.01 ms | | statistics | 0.05 ms | | preparing | 0.01 ms | | executing | 0.02 ms | | Sending data | 0.09 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 |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 | | 14 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:706 | | 13 | ContentModelArticles->getItems() | JROOT/components/com_content/models/featured.php:126 | | 12 | ContentModelFeatured->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 | | 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_content/views/featured/view.html.php:56 | | 10 | ContentViewFeatured->display() | JROOT/libraries/src/MVC/Controller/BaseController.php: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.50 ms After last query: 0.21 ms Query memory: 0.023 MB Memory before query: 9.013 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.article'
AND `m`.`content_item_id` = 1946
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.00 ms | | Opening tables | 0.01 ms | | init | 0.03 ms | | System lock | 0.01 ms | | optimizing | 0.01 ms | | statistics | 0.05 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.03 ms | | cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 | | 14 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:706 | | 13 | ContentModelArticles->getItems() | JROOT/components/com_content/models/featured.php:126 | | 12 | ContentModelFeatured->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 | | 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_content/views/featured/view.html.php:56 | | 10 | ContentViewFeatured->display() | JROOT/libraries/src/MVC/Controller/BaseController.php: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.59 ms After last query: 0.17 ms Query memory: 0.023 MB Memory before query: 9.030 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.article'
AND `m`.`content_item_id` = 1896
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.03 ms | | System lock | 0.03 ms | | optimizing | 0.01 ms | | statistics | 0.06 ms | | preparing | 0.02 ms | | executing | 0.00 ms | | Sending data | 0.11 ms | | end | 0.01 ms | | query end | 0.01 ms | | closing tables | 0.01 ms | | freeing items | 0.03 ms | | cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 | | 14 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:706 | | 13 | ContentModelArticles->getItems() | JROOT/components/com_content/models/featured.php:126 | | 12 | ContentModelFeatured->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 | | 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_content/views/featured/view.html.php:56 | | 10 | ContentViewFeatured->display() | JROOT/libraries/src/MVC/Controller/BaseController.php: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.76 ms After last query: 1.48 ms Query memory: 0.023 MB Memory before query: 9.110 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.featured = 1
AND a.access IN (1,1)
AND c.access IN (1,1)
AND c.published = 1
AND a.state IN (0,1,2)
AND a.language IN ('en-GB','*') | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | NULL | ref | idx_access,idx_state,idx_catid,idx_featured_catid,idx_language | idx_featured_catid | 1 | const | 26 | 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 | c | NULL | eq_ref | PRIMARY,idx_access | PRIMARY | 4 | db462563782.a.catid | 1 | 9.83 | Using where | | 1 | SIMPLE | parent | NULL | eq_ref | PRIMARY | PRIMARY | 4 | db462563782.c.parent_id | 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.06 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.03 ms | | init | 0.03 ms | | System lock | 0.01 ms | | optimizing | 0.01 ms | | statistics | 0.11 ms | | preparing | 0.02 ms | | executing | 0.00 ms | | Sending data | 0.28 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 |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 | | 15 | JDatabaseDriver->loadResult() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354 | | 14 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() | JROOT/libraries/src/MVC/Model/ListModel.php:289 | | 13 | Joomla\CMS\MVC\Model\ListModel->getTotal() | JROOT/libraries/src/MVC/Model/ListModel.php:239 | | 12 | Joomla\CMS\MVC\Model\ListModel->getPagination() | JROOT/libraries/src/MVC/View/HtmlView.php:425 | | 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_content/views/featured/view.html.php:57 | | 10 | ContentViewFeatured->display() | JROOT/libraries/src/MVC/Controller/BaseController.php: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: 6.18 ms Query memory: 0.027 MB Memory before query: 9.645 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 = 39
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.86 | Using where |
| Status | Duration |
|---|
| starting | 0.09 ms | | checking permissions | 0.00 ms | | checking permissions | 0.00 ms | | Opening tables | 0.01 ms | | init | 0.04 ms | | System lock | 0.01 ms | | optimizing | 0.01 ms | | statistics | 0.12 ms | | preparing | 0.02 ms | | Sorting result | 0.00 ms | | executing | 0.00 ms | | Sending data | 0.02 ms | | Creating sort index | 0.20 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 |
|---|
| 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/featured/view.html.php:102 | | 10 | ContentViewFeatured->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.07 ms After last query: 0.61 ms Query memory: 0.025 MB Memory before query: 9.694 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 (39,0,87))
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.10 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.05 ms | | init | 0.05 ms | | System lock | 0.01 ms | | optimizing | 0.02 ms | | statistics | 0.13 ms | | preparing | 0.03 ms | | Creating tmp table | 0.06 ms | | Sorting result | 0.01 ms | | executing | 0.00 ms | | Sending data | 0.22 ms | | Creating sort index | 0.03 ms | | end | 0.01 ms | | query end | 0.01 ms | | removing tmp table | 0.06 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/featured/view.html.php:102 | | 10 | ContentViewFeatured->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.91 ms After last query: 5.35 ms Query memory: 0.027 MB Memory before query: 10.061 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 = 215
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 | 25.74 | Using where |
| Status | Duration |
|---|
| starting | 0.14 ms | | checking permissions | 0.01 ms | | checking permissions | 0.00 ms | | Opening tables | 0.01 ms | | init | 0.06 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.21 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 |
|---|
| 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/featured/view.html.php:102 | | 10 | ContentViewFeatured->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.11 ms After last query: 0.19 ms Query memory: 0.026 MB Memory before query: 10.078 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 (215,0,202))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
AND a.language in ('*','en-GB')
ORDER BY a.ordering ASC | 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_language,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.00 ms | | checking permissions | 0.00 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 | | Opening tables | 0.04 ms | | init | 0.06 ms | | System lock | 0.01 ms | | optimizing | 0.02 ms | | statistics | 0.14 ms | | preparing | 0.03 ms | | Creating tmp table | 0.05 ms | | Sorting result | 0.01 ms | | executing | 0.00 ms | | Sending data | 0.23 ms | | Creating sort index | 0.03 ms | | end | 0.00 ms | | query end | 0.01 ms | | removing tmp table | 0.07 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 |
|---|
| 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/featured/view.html.php:102 | | 10 | ContentViewFeatured->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.93 ms After last query: 0.56 ms Query memory: 0.027 MB Memory before query: 10.099 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 = 218
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 | 26.80 | Using where |
| Status | Duration |
|---|
| starting | 0.10 ms | | checking permissions | 0.00 ms | | checking permissions | 0.00 ms | | Opening tables | 0.01 ms | | init | 0.05 ms | | System lock | 0.01 ms | | optimizing | 0.02 ms | | statistics | 0.12 ms | | preparing | 0.02 ms | | Sorting result | 0.01 ms | | executing | 0.00 ms | | Sending data | 0.03 ms | | Creating sort index | 0.22 ms | | end | 0.01 ms | | query end | 0.01 ms | | closing tables | 0.01 ms | | freeing items | 0.05 ms | | cleaning up | 0.01 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/featured/view.html.php:102 | | 10 | ContentViewFeatured->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.12 ms After last query: 0.18 ms Query memory: 0.025 MB Memory before query: 10.105 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 (218,0,202))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
AND a.language in ('*','en-GB')
ORDER BY a.ordering ASC | 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_language,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.11 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 | | checking permissions | 0.00 ms | | Opening tables | 0.06 ms | | init | 0.05 ms | | System lock | 0.01 ms | | optimizing | 0.02 ms | | statistics | 1.26 ms | | preparing | 0.05 ms | | Creating tmp table | 0.05 ms | | Sorting result | 0.01 ms | | executing | 0.00 ms | | Sending data | 0.18 ms | | Creating sort index | 0.02 ms | | end | 0.00 ms | | query end | 0.01 ms | | removing tmp table | 0.05 ms | | query end | 0.00 ms | | closing tables | 0.01 ms | | freeing items | 0.03 ms | | cleaning up | 0.01 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/featured/view.html.php:102 | | 10 | ContentViewFeatured->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.83 ms After last query: 0.64 ms Query memory: 0.027 MB Memory before query: 10.125 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 = 54
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 | 15.87 | Using where |
| Status | Duration |
|---|
| starting | 0.09 ms | | checking permissions | 0.00 ms | | checking permissions | 0.00 ms | | Opening tables | 0.01 ms | | init | 0.04 ms | | System lock | 0.01 ms | | optimizing | 0.01 ms | | statistics | 0.09 ms | | preparing | 0.02 ms | | Sorting result | 0.00 ms | | executing | 0.00 ms | | Sending data | 0.02 ms | | Creating sort index | 0.18 ms | | end | 0.00 ms | | query end | 0.01 ms | | closing tables | 0.01 ms | | freeing items | 0.03 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/featured/view.html.php:102 | | 10 | ContentViewFeatured->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.19 ms After last query: 0.19 ms Query memory: 0.025 MB Memory before query: 10.135 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 (54,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)
AND a.language in ('*','en-GB')
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_language,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.09 ms | | checking permissions | 0.00 ms | | checking permissions | 0.00 ms | | checking permissions | 0.00 ms | | checking permissions | 0.02 ms | | checking permissions | 0.00 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.13 ms | | preparing | 0.04 ms | | Creating tmp table | 0.05 ms | | Sorting result | 0.01 ms | | executing | 0.01 ms | | Sending data | 0.35 ms | | Creating sort index | 0.02 ms | | end | 0.00 ms | | query end | 0.02 ms | | removing tmp table | 0.06 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 |
|---|
| 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/featured/view.html.php:102 | | 10 | ContentViewFeatured->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: 0.57 ms Query memory: 0.027 MB Memory before query: 10.155 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 = 62
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 | 14.81 | Using where |
| Status | Duration |
|---|
| starting | 0.08 ms | | checking permissions | 0.00 ms | | checking permissions | 0.00 ms | | Opening tables | 0.01 ms | | init | 0.04 ms | | System lock | 0.01 ms | | optimizing | 0.01 ms | | statistics | 0.09 ms | | preparing | 0.02 ms | | Sorting result | 0.00 ms | | executing | 0.01 ms | | Sending data | 0.02 ms | | Creating sort index | 0.17 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 |
|---|
| 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/featured/view.html.php:102 | | 10 | ContentViewFeatured->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: 3.23 ms After last query: 0.19 ms Query memory: 0.025 MB Memory before query: 10.162 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 (62,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)
AND a.language in ('*','en-GB')
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_language,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.10 ms | | checking permissions | 0.00 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 | | Opening tables | 0.02 ms | | init | 0.06 ms | | System lock | 0.01 ms | | optimizing | 0.02 ms | | statistics | 0.11 ms | | preparing | 0.03 ms | | Creating tmp table | 0.04 ms | | Sorting result | 0.01 ms | | executing | 0.00 ms | | Sending data | 0.18 ms | | Creating sort index | 0.02 ms | | end | 0.00 ms | | query end | 0.01 ms | | removing tmp table | 0.06 ms | | query end | 1.25 ms | | closing tables | 0.02 ms | | freeing items | 0.02 ms | | cleaning up | 0.01 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/featured/view.html.php:102 | | 10 | ContentViewFeatured->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.73 ms After last query: 0.63 ms Query memory: 0.027 MB Memory before query: 10.182 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 = 50
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 | 16.22 | Using where |
| Status | Duration |
|---|
| starting | 0.08 ms | | checking permissions | 0.00 ms | | checking permissions | 0.00 ms | | Opening tables | 0.01 ms | | init | 0.03 ms | | System lock | 0.01 ms | | optimizing | 0.01 ms | | statistics | 0.11 ms | | preparing | 0.01 ms | | Sorting result | 0.01 ms | | executing | 0.00 ms | | Sending data | 0.01 ms | | Creating sort index | 0.15 ms | | end | 0.00 ms | | query end | 0.01 ms | | closing tables | 0.01 ms | | freeing items | 0.03 ms | | cleaning up | 0.03 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/featured/view.html.php:102 | | 10 | ContentViewFeatured->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: 0.19 ms Query memory: 0.025 MB Memory before query: 10.188 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 (50,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)
AND a.language in ('*','en-GB')
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_language,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.09 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 | | checking permissions | 0.00 ms | | Opening tables | 0.02 ms | | init | 0.04 ms | | System lock | 0.01 ms | | optimizing | 0.02 ms | | statistics | 0.10 ms | | preparing | 0.02 ms | | Creating tmp table | 0.04 ms | | Sorting result | 0.01 ms | | executing | 0.00 ms | | Sending data | 0.14 ms | | Creating sort index | 0.03 ms | | end | 0.00 ms | | query end | 0.01 ms | | removing tmp table | 0.04 ms | | query end | 0.00 ms | | closing tables | 0.01 ms | | freeing items | 0.03 ms | | cleaning up | 0.01 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/featured/view.html.php:102 | | 10 | ContentViewFeatured->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.68 ms After last query: 0.60 ms Query memory: 0.027 MB Memory before query: 10.207 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 = 61
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 | 15.16 | Using where |
| Status | Duration |
|---|
| starting | 0.08 ms | | checking permissions | 0.00 ms | | checking permissions | 0.00 ms | | Opening tables | 0.01 ms | | init | 0.03 ms | | System lock | 0.01 ms | | optimizing | 0.01 ms | | statistics | 0.08 ms | | preparing | 0.01 ms | | Sorting result | 0.01 ms | | executing | 0.00 ms | | Sending data | 0.01 ms | | Creating sort index | 0.15 ms | | end | 0.00 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 |
|---|
| 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/featured/view.html.php:102 | | 10 | ContentViewFeatured->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.88 ms After last query: 0.18 ms Query memory: 0.025 MB Memory before query: 10.213 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 (61,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)
AND a.language in ('*','en-GB')
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_language,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.08 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.01 ms | | checking permissions | 0.00 ms | | Opening tables | 0.02 ms | | init | 0.04 ms | | System lock | 0.01 ms | | optimizing | 0.02 ms | | statistics | 0.10 ms | | preparing | 0.02 ms | | Creating tmp table | 0.04 ms | | Sorting result | 0.01 ms | | executing | 0.00 ms | | Sending data | 0.14 ms | | Creating sort index | 0.03 ms | | end | 0.01 ms | | query end | 0.01 ms | | removing tmp table | 0.05 ms | | query end | 0.03 ms | | closing tables | 0.01 ms | | freeing items | 0.04 ms | | cleaning up | 0.01 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/featured/view.html.php:102 | | 10 | ContentViewFeatured->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: 0.74 ms Query memory: 0.027 MB Memory before query: 10.234 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 = 16
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 | 18.33 | Using where |
| Status | Duration |
|---|
| starting | 0.08 ms | | checking permissions | 0.01 ms | | checking permissions | 0.00 ms | | Opening tables | 0.01 ms | | init | 0.04 ms | | System lock | 0.01 ms | | optimizing | 0.01 ms | | statistics | 0.08 ms | | preparing | 0.02 ms | | Sorting result | 0.00 ms | | executing | 0.00 ms | | Sending data | 0.02 ms | | Creating sort index | 0.15 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 |
|---|
| 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/featured/view.html.php:102 | | 10 | ContentViewFeatured->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.84 ms After last query: 0.18 ms Query memory: 0.025 MB Memory before query: 10.240 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 (16,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)
AND a.language in ('*','en-GB')
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_language,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.09 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.03 ms | | init | 0.04 ms | | System lock | 0.01 ms | | optimizing | 0.02 ms | | statistics | 0.10 ms | | preparing | 0.02 ms | | Creating tmp table | 0.04 ms | | Sorting result | 0.01 ms | | executing | 0.00 ms | | Sending data | 0.15 ms | | Creating sort index | 0.02 ms | | end | 0.00 ms | | query end | 0.01 ms | | removing tmp table | 0.05 ms | | query end | 0.00 ms | | closing tables | 0.01 ms | | freeing items | 0.03 ms | | cleaning up | 0.01 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/featured/view.html.php:102 | | 10 | ContentViewFeatured->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.69 ms After last query: 0.56 ms Query memory: 0.027 MB Memory before query: 10.260 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 = 46
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 | 11.64 | Using where |
| Status | Duration |
|---|
| starting | 0.08 ms | | checking permissions | 0.00 ms | | checking permissions | 0.00 ms | | Opening tables | 0.01 ms | | init | 0.03 ms | | System lock | 0.01 ms | | optimizing | 0.01 ms | | statistics | 0.08 ms | | preparing | 0.01 ms | | Sorting result | 0.00 ms | | executing | 0.00 ms | | Sending data | 0.01 ms | | Creating sort index | 0.16 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 |
|---|
| 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/featured/view.html.php:102 | | 10 | ContentViewFeatured->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.88 ms After last query: 0.18 ms Query memory: 0.025 MB Memory before query: 10.271 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 (46,0,83))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
AND a.language in ('*','en-GB')
ORDER BY a.ordering ASC | 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_language,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.08 ms | | checking permissions | 0.00 ms | | checking permissions | 0.01 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 | | Opening tables | 0.03 ms | | init | 0.06 ms | | System lock | 0.01 ms | | optimizing | 0.02 ms | | statistics | 0.10 ms | | preparing | 0.02 ms | | Creating tmp table | 0.04 ms | | Sorting result | 0.01 ms | | executing | 0.00 ms | | Sending data | 0.14 ms | | Creating sort index | 0.02 ms | | end | 0.00 ms | | query end | 0.02 ms | | removing tmp table | 0.05 ms | | query end | 0.00 ms | | closing tables | 0.01 ms | | freeing items | 0.03 ms | | cleaning up | 0.01 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/featured/view.html.php:102 | | 10 | ContentViewFeatured->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.75 ms After last query: 0.54 ms Query memory: 0.027 MB Memory before query: 10.291 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 = 42
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 | 9.52 | Using where |
| Status | Duration |
|---|
| starting | 0.08 ms | | checking permissions | 0.00 ms | | checking permissions | 0.00 ms | | Opening tables | 0.01 ms | | init | 0.03 ms | | System lock | 0.01 ms | | optimizing | 0.01 ms | | statistics | 0.08 ms | | preparing | 0.01 ms | | Sorting result | 0.01 ms | | executing | 0.00 ms | | Sending data | 0.02 ms | | Creating sort index | 0.18 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 |
|---|
| 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/featured/view.html.php:102 | | 10 | ContentViewFeatured->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.15 ms After last query: 0.19 ms Query memory: 0.025 MB Memory before query: 10.301 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 (42,0,81))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
AND a.language in ('*','en-GB')
ORDER BY a.ordering ASC | 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_language,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.09 ms | | checking permissions | 0.00 ms | | checking permissions | 0.00 ms | | checking permissions | 0.01 ms | | checking permissions | 0.00 ms | | checking permissions | 0.00 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | Opening tables | 0.03 ms | | init | 0.06 ms | | System lock | 0.03 ms | | optimizing | 0.02 ms | | statistics | 0.14 ms | | preparing | 0.05 ms | | Creating tmp table | 0.05 ms | | Sorting result | 0.01 ms | | executing | 0.00 ms | | Sending data | 0.20 ms | | Creating sort index | 0.03 ms | | end | 0.00 ms | | query end | 0.02 ms | | removing tmp table | 0.07 ms | | query end | 0.02 ms | | closing tables | 0.02 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/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/featured/view.html.php:102 | | 10 | ContentViewFeatured->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.78 ms After last query: 0.56 ms Query memory: 0.027 MB Memory before query: 10.321 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 = 231
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 | 32.44 | Using where |
| Status | Duration |
|---|
| starting | 0.08 ms | | checking permissions | 0.02 ms | | checking permissions | 0.00 ms | | Opening tables | 0.01 ms | | init | 0.05 ms | | System lock | 0.01 ms | | optimizing | 0.01 ms | | statistics | 0.10 ms | | preparing | 0.02 ms | | Sorting result | 0.01 ms | | executing | 0.00 ms | | Sending data | 0.03 ms | | Creating sort index | 0.17 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 |
|---|
| 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/featured/view.html.php:102 | | 10 | ContentViewFeatured->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.07 ms After last query: 0.19 ms Query memory: 0.025 MB Memory before query: 10.332 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 (231,0,230))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
AND a.language in ('*','en-GB')
ORDER BY a.ordering ASC | 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_language,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.10 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | checking permissions | 0.02 ms | | checking permissions | 0.00 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | Opening tables | 0.03 ms | | init | 0.06 ms | | System lock | 0.03 ms | | optimizing | 0.02 ms | | statistics | 0.14 ms | | preparing | 0.05 ms | | Creating tmp table | 0.05 ms | | Sorting result | 0.01 ms | | executing | 0.00 ms | | Sending data | 0.19 ms | | Creating sort index | 0.03 ms | | end | 0.01 ms | | query end | 0.01 ms | | removing tmp table | 0.06 ms | | query end | 0.01 ms | | closing tables | 0.02 ms | | freeing items | 0.04 ms | | cleaning up | 0.01 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/featured/view.html.php:102 | | 10 | ContentViewFeatured->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.59 ms After last query: 18.04 ms Query memory: 0.059 MB Memory before query: 11.446 MB Rows returned: 18
| | | | | | | | | |
Administrator
