Appartement ap084

Recherche d'hôtel
Immobilier
Animations et excursions

Emplacement

Enregistrement

19-10-2021

Check-out

20-10-2021

Recherche avancée Fermer

Catégorie

Emplacement de base

Lieu de fin

Appartement ap084

Ajouter aux favoris

Prix: 179000 EUR Le prix est négociable

Contact info@alexandretour.com
alexandretour.com

Description

60 m2, 2 chambres à coucher, salon, cuisine séparée, terrasse, à 200 mètres de la plage Sa Boadella. Permis de tourisme.

Vente appartement dans un quartier calme de Lloret de Mar, Fenals. près des jardins de Sainte Clotilde. L'appartement est situé dans une des maisons sur le territoire d'un complexe privé à 200m de la mer. Il y a 5 maisons sur le territoire du complexe et 4 piscines communes à l'usage des locataires, une zone de loisirs, des douches et un parking souterrain. L'appartement est situé au 2ème étage. La superficie de l'appartement est de 60m2, se compose de: 2 chambres à coucher, 1 salle de bain, salon avec sortie à la terrasse et cuisine. L'appartement a toutes les chambres meublées, air conditionné et chauffage installé. Les commerces et restaurants sont situés à 5 minutes à pied.

Détails spécifiques

ID de l'objet Ap084

La superficie totale m2 68

Étage 2

Étages dans la maison 5

Les étages de l'appartement 1

Salles de bains 1

Le nombre de chambres 2

Balcon Un balcon

Piscine Oui

Emplacement

Sa Boadella, 2-4, Gerona, Льорет де Мар, Spain/Lloret de Mar, 17310, Spain

Vidéo

Détails de l'annonce

ID de l'annonce: 3

affiché: 3286

Ajouté: 2018-10-23 10:06:53

La consultation

Lloret de Mar | 4°C | Dégagé

ADRESSE

17310, Lloret de Mar

Téléphone

+34 603 207 704

E-MAIL

info@alexandretour.com

STAY UP TO DATE

Console de débogage Joomla!

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1634660154,
                "last": 1634660154,
                "now": 1634660154
            },
            "token": "dnzlL0kOQMMKJfZQ71ygY4xOTix64XrH"
        },
        "registry": {
            "current_currency_id": "2"
        },
        "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": "fr-FR"
        }
    }
}

Profil d'information

Temps

Mémoire

Temps: 5.77 ms / 5.77 ms Mémoire: 0.566 MB / 0.95 MB Application: afterLoad

Temps: 53.64 ms / 59.41 ms Mémoire: 1.640 MB / 2.59 MB Application: afterInitialise

Temps: 37.98 ms / 97.40 ms Mémoire: 0.863 MB / 3.45 MB Application: Before Access::preloadComponents (all components)

Temps: 1.86 ms / 99.26 ms Mémoire: 0.064 MB / 3.52 MB Application: After Access::preloadComponents (all components)

Temps: 0.04 ms / 99.30 ms Mémoire: 0.000 MB / 3.51 MB Application: Before Access::getAssetRules (id:124 name:com_solidres)

Temps: 0.43 ms / 99.73 ms Mémoire: 0.013 MB / 3.53 MB Application: After Access::getAssetRules (id:124 name:com_solidres)

Temps: 17.01 ms / 116.74 ms Mémoire: 0.732 MB / 4.26 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Temps: 0.06 ms / 116.80 ms Mémoire: 0.007 MB / 4.27 MB Application: After Access::getAssetRules (id:1 name:root.1)

Temps: 0.12 ms / 116.92 ms Mémoire: 0.001 MB / 4.27 MB Application: afterRoute

Temps: 0.72 ms / 117.64 ms Mémoire: 0.074 MB / 4.34 MB Application: beforeRenderComponent com_djclassifieds

Temps: 51.91 ms / 169.56 ms Mémoire: 0.842 MB / 5.18 MB Application: afterRenderComponent com_djclassifieds

Temps: 2.84 ms / 172.40 ms Mémoire: 0.021 MB / 5.20 MB Application: afterDispatch

Temps: 5.41 ms / 177.82 ms Mémoire: 0.368 MB / 5.57 MB Application: beforeRenderModule mod_tabs_gk5 (Booking Tabs (2))

Temps: 1.73 ms / 179.55 ms Mémoire: 0.059 MB / 5.63 MB Application: beforeRenderModule mod_sr_advancedsearch (Advanced Search)

Temps: 4.28 ms / 183.83 ms Mémoire: 0.125 MB / 5.76 MB Application: afterRenderModule mod_sr_advancedsearch (Advanced Search)

Temps: 0.11 ms / 183.95 ms Mémoire: 0.000 MB / 5.75 MB Application: beforeRenderModule mod_djclassifieds_search (DJClassifieds Search)

Temps: 6.84 ms / 190.79 ms Mémoire: 0.190 MB / 5.94 MB Application: afterRenderModule mod_djclassifieds_search (DJClassifieds Search)

Temps: 0.13 ms / 190.92 ms Mémoire: 0.000 MB / 5.93 MB Application: beforeRenderModule mod_sr_experience_search (Experience Search)

Temps: 6.74 ms / 197.66 ms Mémoire: 0.140 MB / 6.07 MB Application: afterRenderModule mod_sr_experience_search (Experience Search)

Temps: 0.08 ms / 197.73 ms Mémoire: 0.000 MB / 6.04 MB Application: afterRenderModule mod_tabs_gk5 (Booking Tabs (2))

Temps: 0.19 ms / 197.92 ms Mémoire: 0.000 MB / 6.03 MB Application: beforeRenderModule mod_weather_gk4 (Weather)

Temps: 4.20 ms / 202.12 ms Mémoire: 0.048 MB / 6.08 MB Application: afterRenderModule mod_weather_gk4 (Weather)

Temps: 0.06 ms / 202.18 ms Mémoire: 0.000 MB / 6.05 MB Application: beforeRenderModule mod_custom (Contact Details Контактная информация)

Temps: 0.89 ms / 203.07 ms Mémoire: 0.008 MB / 6.06 MB Application: afterRenderModule mod_custom (Contact Details Контактная информация)

Temps: 0.06 ms / 203.14 ms Mémoire: 0.006 MB / 6.07 MB Application: beforeRenderModule mod_acymailing (STAY UP TO DATE)

Temps: 11.50 ms / 214.64 ms Mémoire: 0.633 MB / 6.70 MB Application: afterRenderModule mod_acymailing (STAY UP TO DATE)

Temps: 0.14 ms / 214.78 ms Mémoire: 0.000 MB / 6.66 MB Application: beforeRenderModule mod_convertforms (La consultation)

Temps: 15.93 ms / 230.71 ms Mémoire: 0.151 MB / 6.81 MB Application: afterRenderModule mod_convertforms (La consultation)

Temps: 1.88 ms / 232.59 ms Mémoire: 0.033 MB / 6.85 MB Application: beforeRenderModule mod_custom (Immobilier et vacances en Espagne)

Temps: 0.34 ms / 232.93 ms Mémoire: 0.003 MB / 6.85 MB Application: afterRenderModule mod_custom (Immobilier et vacances en Espagne)

Temps: 0.27 ms / 233.19 ms Mémoire: 0.003 MB / 6.85 MB Application: beforeRenderModule mod_falang (FaLang Language Switcher)

Temps: 5.02 ms / 238.21 ms Mémoire: 0.236 MB / 7.09 MB Application: afterRenderModule mod_falang (FaLang Language Switcher)

Temps: 0.06 ms / 238.28 ms Mémoire: 0.000 MB / 7.08 MB Application: beforeRenderModule mod_sr_currency (Currency)

Temps: 2.36 ms / 240.64 ms Mémoire: 0.035 MB / 7.12 MB Application: afterRenderModule mod_sr_currency (Currency)

Temps: 0.49 ms / 241.13 ms Mémoire: 0.000 MB / 7.11 MB Application: beforeRenderModule mod_custom (Logo)

Temps: 0.31 ms / 241.43 ms Mémoire: 0.003 MB / 7.11 MB Application: afterRenderModule mod_custom (Logo)

Temps: 0.37 ms / 241.81 ms Mémoire: 0.003 MB / 7.12 MB Application: beforeRenderModule mod_menu (Main Menu)

Temps: 4.10 ms / 245.91 ms Mémoire: 0.056 MB / 7.17 MB Application: afterRenderModule mod_menu (Main Menu)

Temps: 3.68 ms / 249.59 ms Mémoire: 0.078 MB / 7.25 MB Application: beforeRenderModule mod_custom (Logo Small)

Temps: 0.32 ms / 249.92 ms Mémoire: 0.003 MB / 7.25 MB Application: afterRenderModule mod_custom (Logo Small)

Temps: 0.76 ms / 250.68 ms Mémoire: 0.017 MB / 7.27 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Temps: 1.39 ms / 252.07 ms Mémoire: 0.013 MB / 7.28 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Temps: 1.45 ms / 253.51 ms Mémoire: 0.011 MB / 7.29 MB Application: beforeRenderModule mod_custom (Copyright)

Temps: 0.28 ms / 253.80 ms Mémoire: 0.003 MB / 7.30 MB Application: afterRenderModule mod_custom (Copyright)

Temps: 0.21 ms / 254.01 ms Mémoire: 0.001 MB / 7.30 MB Application: beforeRenderModule mod_custom (debug)

Temps: 2.14 ms / 256.15 ms Mémoire: 0.028 MB / 7.33 MB Application: afterRenderModule mod_custom (debug)

Temps: 0.04 ms / 256.19 ms Mémoire: 0.000 MB / 7.33 MB Application: beforeRenderModule mod_custom (fontawesome)

Temps: 0.32 ms / 256.51 ms Mémoire: 0.003 MB / 7.33 MB Application: afterRenderModule mod_custom (fontawesome)

Temps: 0.40 ms / 256.91 ms Mémoire: 0.003 MB / 7.33 MB Application: beforeRenderModule mod_menu (Offcanvas Menu)

Temps: 1.93 ms / 258.84 ms Mémoire: 0.006 MB / 7.34 MB Application: afterRenderModule mod_menu (Offcanvas Menu)

Temps: 6.02 ms / 264.86 ms Mémoire: 0.171 MB / 7.51 MB Application: afterRender

Total de requêtes base de données : 51.58 ms

Occupation de la mémoire

Requêtes de base de données

79 requêtes exécutées 51.58 ms

16 doubles découverts!

2 requêtes dupliquées: #1 #6

2 requêtes dupliquées: #4 #50

2 requêtes dupliquées: #16 #19

2 requêtes dupliquées: #21 #60

3 requêtes dupliquées: #35 #54 #56

2 requêtes dupliquées: #37 #57

3 requêtes dupliquées: #51 #65 #67

Temps de requête : 1.27 ms Mémoire de requête : 0.044 MB mémoire avant requête : 2.279 MB Rangées retournées : 24

Requêtes dupliquées: #6

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

  LEFT JOIN cqbns_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

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	84	3.33	Using index condition; Using where; Utilisation du tri complet de type filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	lloret_alexand.m.component_id	1	100.00	Using where

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
26	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
25	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
23	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
22	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Même appel que celui de la ligne ci-dessous.
21	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
20	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
19	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
18	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
17	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
16	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
15	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
14	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
13	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
12	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
11	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
10	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:145
9	PlgSystemLanguageFilter->onAfterInitialise()	Même appel que celui de la ligne ci-dessous.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.25 ms Après la dernière requête : 1.14 ms Mémoire de requête : 0.033 MB mémoire avant requête : 2.347 MB Rangées retournées : 36

SELECT joomlatablename,tablepkID 
  FROM `cqbns_falang_tableinfo`

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cqbns_falang_tableinfo	NULL	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	36	100.00	NULL

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
31	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
30	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
29	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
28	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:144
27	FalangManager->_loadPrimaryKeyData()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:57
26	FalangManager->__construct()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:85
25	FalangManager::getInstance()	JROOT/components/com_falang/helpers/falang.class.php:35
24	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
23	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
22	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Même appel que celui de la ligne ci-dessous.
21	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
20	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
19	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
18	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
17	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
16	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
15	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
14	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
13	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
12	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
11	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
10	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:145
9	PlgSystemLanguageFilter->onAfterInitialise()	Même appel que celui de la ligne ci-dessous.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.24 ms Après la dernière requête : 0.24 ms Mémoire de requête : 0.036 MB mémoire avant requête : 2.365 MB Rangées retournées : 8

SELECT * 
  FROM cqbns_languages 
  ORDER BY ordering

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cqbns_languages	NULL	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	8	100.00	Utilisation du tri complet de type filesort

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
31	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
30	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
29	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
28	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:319
27	FalangManager->getLanguages()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:63
26	FalangManager->__construct()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:85
25	FalangManager::getInstance()	JROOT/components/com_falang/helpers/falang.class.php:35
24	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
23	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
22	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Même appel que celui de la ligne ci-dessous.
21	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
20	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
19	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
18	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
17	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
16	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
15	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
14	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
13	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
12	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
11	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
10	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:145
9	PlgSystemLanguageFilter->onAfterInitialise()	Même appel que celui de la ligne ci-dessous.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.52 ms Après la dernière requête : 0.87 ms Mémoire de requête : 0.037 MB mémoire avant requête : 2.400 MB Rangées retournées : 14

Requêtes dupliquées: #50

SHOW FULL COLUMNS 
  FROM `cqbns_languages`

Explication

EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `cqbns_languages`

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
35	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
34	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
33	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
32	JFalangDatabase->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
31	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
30	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
29	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_falang/tables/JFLanguage.php:54
28	TableJFLanguage->__construct()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:325
27	FalangManager->getLanguages()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:63
26	FalangManager->__construct()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:85
25	FalangManager::getInstance()	JROOT/components/com_falang/helpers/falang.class.php:35
24	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
23	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
22	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Même appel que celui de la ligne ci-dessous.
21	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
20	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
19	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
18	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
17	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
16	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
15	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
14	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
13	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
12	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
11	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
10	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:145
9	PlgSystemLanguageFilter->onAfterInitialise()	Même appel que celui de la ligne ci-dessous.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 5.52 ms Après la dernière requête : 1.04 ms Mémoire de requête : 0.042 MB mémoire avant requête : 2.465 MB Rangées retournées : 97

SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 

  FROM cqbns_falang_content AS falang_content

  WHERE falang_content.language_id=1
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(954,306,886,290,925,127,891,129,193,130,243,240,888,890,889,932,102,101,885,128,918,926,933,934)
   
  AND falang_content.reference_table='menu'

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	falang_content	NULL	range	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table	falangContent	310	NULL	76	10.00	Using index condition; Using where

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
29	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
28	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
27	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:277
26	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:235
25	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:108
24	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
23	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
22	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Même appel que celui de la ligne ci-dessous.
21	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
20	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
19	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
18	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
17	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
16	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
15	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
14	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
13	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
12	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
11	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
10	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:145
9	PlgSystemLanguageFilter->onAfterInitialise()	Même appel que celui de la ligne ci-dessous.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 1.24 ms Après la dernière requête : 14.85 ms Mémoire de requête : 0.040 MB mémoire avant requête : 3.020 MB Rangées retournées : 24

Requêtes dupliquées: #1

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM cqbns_menu AS m

  LEFT JOIN cqbns_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

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	84	3.33	Using index condition; Using where; Utilisation du tri complet de type filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	lloret_alexand.m.component_id	1	100.00	Using where

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
21	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
20	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
18	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Même appel que celui de la ligne ci-dessous.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/plugins/system/falangdriver/falangdriver.php:366
11	plgSystemFalangdriver->parseRule()	Même appel que celui de la ligne ci-dessous.
10	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
9	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:593
8	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:570
7	Joomla\CMS\Router\Router->_processParseRules()	JROOT/libraries/src/Router/Router.php:216
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 5.28 ms Après la dernière requête : 0.62 ms Mémoire de requête : 0.043 MB mémoire avant requête : 3.076 MB Rangées retournées : 111

SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 

  FROM cqbns_falang_content AS falang_content

  WHERE falang_content.language_id=4
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(954,306,886,290,925,127,891,129,193,130,243,240,888,890,889,932,102,101,885,128,918,926,933,934)
   
  AND falang_content.reference_table='menu'

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	falang_content	NULL	range	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table	falangContent	310	NULL	71	10.00	Using index condition; Using where

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
24	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
23	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:277
21	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:235
20	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:108
19	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
18	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Même appel que celui de la ligne ci-dessous.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/plugins/system/falangdriver/falangdriver.php:366
11	plgSystemFalangdriver->parseRule()	Même appel que celui de la ligne ci-dessous.
10	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
9	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:593
8	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:570
7	Joomla\CMS\Router\Router->_processParseRules()	JROOT/libraries/src/Router/Router.php:216
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.33 ms Après la dernière requête : 2.24 ms Mémoire de requête : 0.029 MB mémoire avant requête : 3.055 MB Rangées retournées : 1

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

  FROM `cqbns_extensions`

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

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cqbns_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
25	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
24	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
22	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
21	JFalangDatabase->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
20	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Même appel que celui de la ligne ci-dessous.
19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
17	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
16	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
15	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
14	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
13	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
12	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/nrframework/NRFramework/Functions.php:147
11	NRFramework\Functions::isFeed()	JROOT/plugins/system/convertforms/convertforms.php:455
10	PlgSystemConvertForms->getHelper()	JROOT/plugins/system/convertforms/convertforms.php:98
9	PlgSystemConvertForms->onAfterRoute()	Même appel que celui de la ligne ci-dessous.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.37 ms Après la dernière requête : 0.36 ms Mémoire de requête : 0.008 MB mémoire avant requête : 3.038 MB

UPDATE `cqbns_extensions`

  SET `params` = '{\"mediaversion\":\"1a930b1fd34f9fb455d0e78db1222fc6\"}'

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

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	cqbns_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
17	JFalangDatabase->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
16	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
15	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
14	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
13	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
12	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/nrframework/NRFramework/Functions.php:147
11	NRFramework\Functions::isFeed()	JROOT/plugins/system/convertforms/convertforms.php:455
10	PlgSystemConvertForms->getHelper()	JROOT/plugins/system/convertforms/convertforms.php:98
9	PlgSystemConvertForms->onAfterRoute()	Même appel que celui de la ligne ci-dessous.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.48 ms Après la dernière requête : 3.10 ms Mémoire de requête : 0.028 MB mémoire avant requête : 3.122 MB Rangées retournées : 3

SELECT id, home, template, s.params

  FROM cqbns_template_styles as s

  LEFT JOIN cqbns_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

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	idx_template,idx_client_id,idx_client_id_home	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	5	60.00	Using where
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	lloret_alexand.s.template,const	1	4.51	Using index condition; Using where

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
23	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
22	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
20	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
19	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/HTML/HTMLHelper.php:365
18	Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles()	JROOT/libraries/src/HTML/HTMLHelper.php:712
17	Joomla\CMS\HTML\HTMLHelper::script()	Même appel que celui de la ligne ci-dessous.
16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/cms/html/jquery.php:52
13	JHtmlJquery::framework()	Même appel que celui de la ligne ci-dessous.
12	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
11	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
10	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/plugins/system/solidres/solidres.php:40
9	plgSystemSolidres->onAfterRoute()	Même appel que celui de la ligne ci-dessous.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 1.30 ms Après la dernière requête : 13.01 ms Mémoire de requête : 0.032 MB mémoire avant requête : 3.457 MB Rangées retournées : 46

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

  FROM `cqbns_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','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_convertforms','com_cpanel','com_djclassifieds','com_falang','com_fields','com_finder','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_minitekwall','com_modules','com_newsfeeds','com_nextend2','com_osmap','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_smartslider3','com_solidres','com_tags','com_templates','com_users','com_weblinks','com_wrapper')

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cqbns_assets	NULL	ALL	idx_asset_name	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	198	23.74	Using where

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
22	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
21	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
19	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
18	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
17	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
14	Joomla\CMS\User\User->authorise()	JROOT/plugins/solidres/acl/acl.php:35
13	PlgSolidresACL->authorise()	JROOT/plugins/solidres/acl/acl.php:27
12	PlgSolidresACL->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
11	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
10	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/plugins/system/solidres/solidres.php:66
9	plgSystemSolidres->onAfterRoute()	Même appel que celui de la ligne ci-dessous.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.74 ms Après la dernière requête : 10.90 ms Mémoire de requête : 0.033 MB mémoire avant requête : 3.834 MB Rangées retournées : 18

SHOW FULL COLUMNS 
  FROM `cqbns_extensions`

Explication

EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `cqbns_extensions`

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
23	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
22	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
20	JFalangDatabase->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
18	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
17	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Extension.php:32
16	Joomla\CMS\Table\Extension->__construct()	JROOT/libraries/src/Table/Table.php:312
15	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/user/solidres/solidres.php:533
14	plgUserSolidres->onSolidresPluginRegister()	Même appel que celui de la ligne ci-dessous.
13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
10	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/solidres/solidres.php:67
9	plgSystemSolidres->onAfterRoute()	Même appel que celui de la ligne ci-dessous.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 1.23 ms Après la dernière requête : 0.31 ms Mémoire de requête : 0.032 MB mémoire avant requête : 3.877 MB Rangées retournées : 1

SELECT *

  FROM cqbns_extensions

  WHERE `name` = 'plg_user_solidres'

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cqbns_extensions	NULL	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	400	10.00	Using where

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
22	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
21	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
19	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
18	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
17	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:434
16	JFalangDatabase->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
15	Joomla\CMS\Table\Table->load()	JROOT/plugins/user/solidres/solidres.php:534
14	plgUserSolidres->onSolidresPluginRegister()	Même appel que celui de la ligne ci-dessous.
13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
10	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/solidres/solidres.php:67
9	plgSystemSolidres->onAfterRoute()	Même appel que celui de la ligne ci-dessous.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.82 ms Après la dernière requête : 10.78 ms Mémoire de requête : 0.023 MB mémoire avant requête : 4.535 MB Rangées retournées : 0

SELECT item_id 
  FROM cqbns_djcf_items_promotions 
  WHERE date_exp <= '2021-10-19 19:15:54' 
  AND updated=0 
  GROUP BY item_id

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cqbns_djcf_items_promotions	NULL	ALL	item_id,date_exp	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	5	20.00	Using where; Using temporary; Utilisation du tri complet de type filesort

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
10	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
8	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djpayment.php:891
7	DJClassifiedsPayment::updatePromotions()	JROOT/components/com_djclassifieds/djclassifieds.php:103
6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.40 ms Après la dernière requête : 2.01 ms Mémoire de requête : 0.043 MB mémoire avant requête : 4.552 MB Rangées retournées : 1

SELECT * 
  FROM cqbns_djcf_items 
  WHERE id=3

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cqbns_djcf_items	NULL	system	PRIMARY	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	100.00	NULL

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
13	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
12	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
10	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
9	JFalangDatabase->loadObject()	JROOT/components/com_djclassifieds/controllers/item.php:57
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:132
6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.53 ms Après la dernière requête : 0.37 ms Mémoire de requête : 0.026 MB mémoire avant requête : 4.603 MB Rangées retournées : 9

Requêtes dupliquées: #19

SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 

  FROM cqbns_falang_content AS falang_content

  WHERE falang_content.language_id=4
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(3)
   
  AND falang_content.reference_table='djcf_items'

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	falang_content	NULL	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table	falangContent	310	const,const,const	7	10.00	Using where

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
15	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:277
13	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:235
12	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:108
11	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
10	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
9	JFalangDatabase->loadObject()	JROOT/components/com_djclassifieds/controllers/item.php:57
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:132
6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.36 ms Après la dernière requête : 0.19 ms Mémoire de requête : 0.006 MB mémoire avant requête : 4.613 MB

UPDATE `cqbns_djcf_items` 
  SET display=display+1 
  WHERE id=3

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	cqbns_djcf_items	NULL	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
10	JFalangDatabase->execute()	JROOT/plugins/system/falangdriver/falang_database.php:124
9	JFalangDatabase->query()	JROOT/components/com_djclassifieds/controllers/item.php:92
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:132
6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.85 ms Après la dernière requête : 4.03 ms Mémoire de requête : 0.051 MB mémoire avant requête : 4.632 MB Rangées retournées : 1

SELECT i.*,c.name as c_name,c.alias as c_alias, c.access_view as c_access_view, c.access_item_view as c_access_item_view,  c.rev_group_id, r.name as r_name, u.name as username, u.email as u_email, iu.name as unit_name , t.id as t_id, t.name as t_name,t.params as t_params  
  FROM cqbns_djcf_categories c, cqbns_djcf_items i 
  LEFT JOIN cqbns_djcf_types t 
  ON t.id = i.type_id 
  LEFT JOIN cqbns_users u 
  ON u.id = i.user_id 
  LEFT JOIN cqbns_djcf_regions r 
  ON r.id = i.region_id 
  LEFT JOIN cqbns_djcf_items_units iu 
  ON iu.id = i.unit_id 
  WHERE c.id=i.cat_id 
  AND i.id = 3 
  LIMIT 1

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	i	NULL	system	PRIMARY,cat_id	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	100.00	NULL
1	SIMPLE	r	NULL	system	PRIMARY	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	0	0.00	const row not found
1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	t	NULL	system	PRIMARY	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	100.00	NULL
1	SIMPLE	u	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	iu	NULL	system	PRIMARY	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	100.00	NULL

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
15	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
13	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
12	JFalangDatabase->loadObject()	JROOT/components/com_djclassifieds/models/item.php:71
11	DjclassifiedsModelItem->getItem()	JROOT/components/com_djclassifieds/views/item/view.html.php:56
10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:132
6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.57 ms Après la dernière requête : 0.41 ms Mémoire de requête : 0.028 MB mémoire avant requête : 4.672 MB Rangées retournées : 9

Requêtes dupliquées: #16

SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 

  FROM cqbns_falang_content AS falang_content

  WHERE falang_content.language_id=4
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(3)
   
  AND falang_content.reference_table='djcf_items'

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	falang_content	NULL	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table	falangContent	310	const,const,const	7	10.00	Using where

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
18	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:277
16	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:235
15	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:108
14	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
13	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
12	JFalangDatabase->loadObject()	JROOT/components/com_djclassifieds/models/item.php:71
11	DjclassifiedsModelItem->getItem()	JROOT/components/com_djclassifieds/views/item/view.html.php:56
10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:132
6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.38 ms Après la dernière requête : 0.17 ms Mémoire de requête : 0.027 MB mémoire avant requête : 4.680 MB Rangées retournées : 0

SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 

  FROM cqbns_falang_content AS falang_content

  WHERE falang_content.language_id=4
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(3)
   
  AND falang_content.reference_table='djcf_categories'

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	falang_content	NULL	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table	falangContent	310	const,const,const	1	10.00	Using where

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
18	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:277
16	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:235
15	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:108
14	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
13	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
12	JFalangDatabase->loadObject()	JROOT/components/com_djclassifieds/models/item.php:71
11	DjclassifiedsModelItem->getItem()	JROOT/components/com_djclassifieds/views/item/view.html.php:56
10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:132
6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.38 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.027 MB mémoire avant requête : 4.689 MB Rangées retournées : 1

Requêtes dupliquées: #60

SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 

  FROM cqbns_falang_content AS falang_content

  WHERE falang_content.language_id=4
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(1)
   
  AND falang_content.reference_table='djcf_types'

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	falang_content	NULL	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table	falangContent	310	const,const,const	1	10.00	Using where

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
18	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:277
16	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:235
15	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:108
14	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
13	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
12	JFalangDatabase->loadObject()	JROOT/components/com_djclassifieds/models/item.php:71
11	DjclassifiedsModelItem->getItem()	JROOT/components/com_djclassifieds/views/item/view.html.php:56
10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:132
6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.27 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.031 MB mémoire avant requête : 4.697 MB Rangées retournées : 0

SELECT c.* 
  FROM cqbns_djcf_items_categories ic, cqbns_djcf_categories c 
  WHERE c.id=ic.cat_id 
  AND ic.item_id = 3  
  ORDER BY ic.item_id,ic.ordering

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
14	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
12	JFalangDatabase->loadObjectList()	JROOT/components/com_djclassifieds/models/item.php:78
11	DjclassifiedsModelItem->getItem()	JROOT/components/com_djclassifieds/views/item/view.html.php:56
10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:132
6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.41 ms Après la dernière requête : 0.19 ms Mémoire de requête : 0.030 MB mémoire avant requête : 4.680 MB Rangées retournées : 18

SELECT img.* 
  FROM cqbns_djcf_images img 
  WHERE img.item_id IN (3) 
  AND img.type='item' 
  ORDER BY img.item_id, img.ordering

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	img	NULL	ref	item_id,type	item_id	4	const	17	77.27	Using index condition; Using where; Utilisation du tri complet de type filesort

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
14	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
12	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djimage.php:427
11	DJClassifiedsImage::getAdsImages()	JROOT/components/com_djclassifieds/views/item/view.html.php:71
10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:132
6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.14 ms Après la dernière requête : 0.18 ms Mémoire de requête : 0.031 MB mémoire avant requête : 4.708 MB Rangées retournées : 1

SELECT c.* 
  FROM cqbns_djcf_categories c 
  WHERE id='2' 
  LIMIT 1

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
15	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
13	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
12	JFalangDatabase->loadObject()	JROOT/components/com_djclassifieds/models/item.php:90
11	DjclassifiedsModelItem->getCategory()	JROOT/components/com_djclassifieds/views/item/view.html.php:73
10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:132
6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.40 ms Après la dernière requête : 0.20 ms Mémoire de requête : 0.027 MB mémoire avant requête : 4.734 MB Rangées retournées : 1

SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 

  FROM cqbns_falang_content AS falang_content

  WHERE falang_content.language_id=4
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(2)
   
  AND falang_content.reference_table='djcf_categories'

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	falang_content	NULL	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table	falangContent	310	const,const,const	1	10.00	Using where

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
18	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:277
16	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:235
15	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:108
14	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
13	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
12	JFalangDatabase->loadObject()	JROOT/components/com_djclassifieds/models/item.php:90
11	DjclassifiedsModelItem->getCategory()	JROOT/components/com_djclassifieds/views/item/view.html.php:73
10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:132
6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 1.12 ms Après la dernière requête : 0.08 ms Mémoire de requête : 0.044 MB mémoire avant requête : 4.742 MB Rangées retournées : 9

SELECT f.*, v.value,v.value_date,v.value_date_to 
  FROM cqbns_djcf_fields f 
  LEFT JOIN cqbns_djcf_fields_xref fx 
  ON f.id=fx.field_id 
  LEFT JOIN (SELECT * 
  FROM cqbns_djcf_fields_values 
  WHERE item_id=3) v 
  ON v.field_id=f.id 
  WHERE fx.cat_id  = 2 
  AND f.published=1 
  AND f.access=0 
  AND f.name!='price' 
  AND f.name!='contact' 
  ORDER BY fx.ordering, f.ordering

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	f	NULL	ref	PRIMARY,name,published	published	4	const	8	11.11	Using where; Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	fx	NULL	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	36	2.78	Using where; Using join buffer (Block Nested Loop)
1	SIMPLE	cqbns_djcf_fields_values	NULL	ref	field_id,type_id	field_id	4	lloret_alexand.f.id	1	100.00	Using where

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
14	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
12	JFalangDatabase->loadObjectList()	JROOT/components/com_djclassifieds/models/item.php:160
11	DjclassifiedsModelItem->getFields()	JROOT/components/com_djclassifieds/views/item/view.html.php:74
10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:132
6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 1.44 ms Après la dernière requête : 0.26 ms Mémoire de requête : 0.028 MB mémoire avant requête : 4.830 MB Rangées retournées : 9

SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 

  FROM cqbns_falang_content AS falang_content

  WHERE falang_content.language_id=4
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(9,1,2,3,5,8,6,4,7)
   
  AND falang_content.reference_table='djcf_fields'

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	falang_content	NULL	range	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table	falangContent	310	NULL	9	10.00	Using index condition; Using where

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
17	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:277
15	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:235
14	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:108
13	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
12	JFalangDatabase->loadObjectList()	JROOT/components/com_djclassifieds/models/item.php:160
11	DjclassifiedsModelItem->getFields()	JROOT/components/com_djclassifieds/views/item/view.html.php:74
10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:132
6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.50 ms Après la dernière requête : 0.11 ms Mémoire de requête : 0.036 MB mémoire avant requête : 4.838 MB Rangées retournées : 0

SELECT f.*, v.value,v.value_date,v.value_date_to 
  FROM cqbns_djcf_fields f 
  LEFT JOIN cqbns_djcf_fields_xref fx 
  ON f.id=fx.field_id 
  LEFT JOIN (SELECT * 
  FROM cqbns_djcf_fields_values 
  WHERE item_id=3) v 
  ON v.field_id=f.id 
  WHERE f.source=1 
  AND f.published=1 
  AND f.access=0 
  AND f.name!='price' 
  GROUP BY f.id 
  ORDER BY fx.ordering, f.ordering

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	f	NULL	ref	PRIMARY,name,published	published	4	const	8	11.11	Using where; Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	fx	NULL	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	36	100.00	Using where; Using join buffer (Block Nested Loop)
1	SIMPLE	cqbns_djcf_fields_values	NULL	ref	field_id,type_id	field_id	4	lloret_alexand.f.id	1	100.00	Using where

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
14	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
12	JFalangDatabase->loadObjectList()	JROOT/components/com_djclassifieds/models/item.php:176
11	DjclassifiedsModelItem->geContactFields()	JROOT/components/com_djclassifieds/views/item/view.html.php:75
10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:132
6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.31 ms Après la dernière requête : 0.22 ms Mémoire de requête : 0.026 MB mémoire avant requête : 4.846 MB Rangées retournées : 0

SELECT s.plan_id 
  FROM cqbns_djcf_plans_subscr_items si, cqbns_djcf_plans_subscr s 
  WHERE si.subscr_id= s.id 
  AND si.item_id = 3

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	no matching row in const table

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
17	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
15	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
14	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
13	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
12	JFalangDatabase->loadResult()	JROOT/components/com_djclassifieds/models/item.php:198
11	DjclassifiedsModelItem->getItemPayment()	JROOT/components/com_djclassifieds/views/item/view.html.php:76
10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:132
6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.19 ms Après la dernière requête : 0.10 ms Mémoire de requête : 0.026 MB mémoire avant requête : 4.837 MB Rangées retournées : 1

SELECT COUNT(p.id) 
  FROM cqbns_djcf_payments p 
  WHERE p.price>0 
  AND  p.item_id = 3 
  AND p.type=0

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	no matching row in const table

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
17	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
15	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
14	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
13	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
12	JFalangDatabase->loadResult()	JROOT/components/com_djclassifieds/models/item.php:209
11	DjclassifiedsModelItem->getItemPayment()	JROOT/components/com_djclassifieds/views/item/view.html.php:76
10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:132
6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.21 ms Après la dernière requête : 0.11 ms Mémoire de requête : 0.025 MB mémoire avant requête : 4.845 MB Rangées retournées : 0

SELECT f.* 
  FROM cqbns_djcf_fields_values_sale f 
  WHERE f.item_id =3 
  ORDER BY f.id

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	no matching row in const table

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
14	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
12	JFalangDatabase->loadObjectList()	JROOT/components/com_djclassifieds/models/item.php:296
11	DjclassifiedsModelItem->getItemOptions()	JROOT/components/com_djclassifieds/views/item/view.html.php:77
10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:132
6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.26 ms Après la dernière requête : 0.26 ms Mémoire de requête : 0.026 MB mémoire avant requête : 4.852 MB Rangées retournées : 0

SELECT a.*, u.name as u_name 
  FROM cqbns_djcf_auctions a, cqbns_users u  
  WHERE a.user_id=u.id 
  AND a.item_id=3 
  ORDER BY a.date DESC 
  LIMIT 5

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	no matching row in const table

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
14	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
12	JFalangDatabase->loadObjectList()	JROOT/components/com_djclassifieds/models/item.php:246
11	DjclassifiedsModelItem->getBids()	JROOT/components/com_djclassifieds/views/item/view.html.php:78
10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:132
6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.15 ms Après la dernière requête : 0.14 ms Mémoire de requête : 0.027 MB mémoire avant requête : 4.866 MB Rangées retournées : 1

SELECT COUNT(i.id) 
  FROM cqbns_djcf_items i 
  WHERE i.published=1 
  AND i.date_exp > '2021-10-19 19:15:54' 
  AND i.user_id  = 454

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	i	NULL	system	user_id,published	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	100.00	NULL

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
17	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
15	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
14	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
13	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
12	JFalangDatabase->loadResult()	JROOT/components/com_djclassifieds/models/item.php:106
11	DjclassifiedsModelItem->getUserItemsCount()	JROOT/components/com_djclassifieds/views/item/view.html.php:80
10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:132
6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.28 ms Après la dernière requête : 0.65 ms Mémoire de requête : 0.033 MB mémoire avant requête : 4.879 MB Rangées retournées : 4

SELECT c.* 
  FROM cqbns_djcf_categories c 
  WHERE c.published=1  
  AND c.access_view IN (1,1,5) 
  ORDER BY c.parent_id, c.ordering

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	ref	published	published	4	const	3	50.00	Using index condition; Using where; Utilisation du tri complet de type filesort

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
15	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
13	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:482
12	DJClassifiedsCategory::getCategories()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:259
11	DJClassifiedsCategory::getParentPath()	JROOT/components/com_djclassifieds/views/item/view.html.php:102
10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:132
6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.82 ms Après la dernière requête : 0.31 ms Mémoire de requête : 0.027 MB mémoire avant requête : 4.913 MB Rangées retournées : 2

Requêtes dupliquées: #54 #56

SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 

  FROM cqbns_falang_content AS falang_content

  WHERE falang_content.language_id=4
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(1,2,4,5)
   
  AND falang_content.reference_table='djcf_categories'

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	falang_content	NULL	range	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table	falangContent	310	NULL	4	10.00	Using index condition; Using where

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
18	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:277
16	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:235
15	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:108
14	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
13	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:482
12	DJClassifiedsCategory::getCategories()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:259
11	DJClassifiedsCategory::getParentPath()	JROOT/components/com_djclassifieds/views/item/view.html.php:102
10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:132
6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.15 ms Après la dernière requête : 0.11 ms Mémoire de requête : 0.026 MB mémoire avant requête : 4.921 MB Rangées retournées : 1

SELECT i.cat_id, count(i.id) as items_count 
  FROM cqbns_djcf_items i 
  WHERE i.published=1 
  AND i.blocked=0 
  AND i.date_exp > '2021-10-19 19:00:00'  
  GROUP BY i.cat_id

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	i	NULL	system	published,blocked	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	100.00	NULL

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
16	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
14	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:535
13	DJClassifiedsCategory::getItemsCount()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:494
12	DJClassifiedsCategory::getCategories()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:259
11	DJClassifiedsCategory::getParentPath()	JROOT/components/com_djclassifieds/views/item/view.html.php:102
10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:132
6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.14 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.025 MB mémoire avant requête : 4.918 MB Rangées retournées : 0

Requêtes dupliquées: #57

SELECT ic.cat_id, count(ic.item_id) as items_count 
  FROM cqbns_djcf_items_categories ic, cqbns_djcf_items i 
  WHERE ic.item_id=i.id 
  AND i.published=1 
  AND i.blocked=0 
  AND i.date_exp > '2021-10-19 19:00:00' 
  GROUP BY ic.cat_id

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
15	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
13	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:501
12	DJClassifiedsCategory::getCategories()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:259
11	DJClassifiedsCategory::getParentPath()	JROOT/components/com_djclassifieds/views/item/view.html.php:102
10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:132
6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.14 ms Après la dernière requête : 0.43 ms Mémoire de requête : 0.026 MB mémoire avant requête : 4.927 MB Rangées retournées : 0

SELECT r.* 
  FROM cqbns_djcf_regions r 
  WHERE published=1 
  ORDER BY r.parent_id

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	no matching row in const table

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
14	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
12	JFalangDatabase->loadObjectList()	JROOT/components/com_djclassifieds/models/item.php:187
11	DjclassifiedsModelItem->getRegions()	JROOT/components/com_djclassifieds/views/item/view.html.php:135
10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:132
6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.17 ms Après la dernière requête : 0.11 ms Mémoire de requête : 0.027 MB mémoire avant requête : 4.934 MB Rangées retournées : 0

SELECT * 
  FROM cqbns_djcf_images 
  WHERE item_id = 454 
  AND type='profile' 
  LIMIT 1

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cqbns_djcf_images	NULL	ref	item_id,type	item_id	4	const	1	5.00	Using where

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
15	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
13	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
12	JFalangDatabase->loadObject()	JROOT/components/com_djclassifieds/models/item.php:220
11	DjclassifiedsModelItem->getProfile()	JROOT/components/com_djclassifieds/views/item/view.html.php:171
10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:132
6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.59 ms Après la dernière requête : 0.11 ms Mémoire de requête : 0.036 MB mémoire avant requête : 4.942 MB Rangées retournées : 0

SELECT f.*, v.value, v.value_date 
  FROM cqbns_djcf_fields f 
  LEFT JOIN (SELECT * 
  FROM cqbns_djcf_fields_values_profile 
  WHERE user_id=454) v 
  ON v.field_id=f.id 
  WHERE f.published=1 
  AND f.source=2 
  AND f.in_item=1 
  AND f.access=0 
  ORDER BY f.ordering

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	f	NULL	ref	published	published	4	const	8	11.11	Using where; Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	cqbns_djcf_fields_values_profile	NULL	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	0	0.00	Using where; Using join buffer (Block Nested Loop)

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
14	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
12	JFalangDatabase->loadObjectList()	JROOT/components/com_djclassifieds/models/item.php:227
11	DjclassifiedsModelItem->getProfile()	JROOT/components/com_djclassifieds/views/item/view.html.php:171
10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:132
6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.19 ms Après la dernière requête : 0.20 ms Mémoire de requête : 0.027 MB mémoire avant requête : 4.967 MB Rangées retournées : 0

SELECT * 
  FROM cqbns_djcf_profiles 
  WHERE user_id = 454  
  LIMIT 1

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	no matching row in const table

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
15	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
13	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
12	JFalangDatabase->loadObject()	JROOT/components/com_djclassifieds/models/item.php:231
11	DjclassifiedsModelItem->getProfile()	JROOT/components/com_djclassifieds/views/item/view.html.php:171
10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:132
6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.19 ms Après la dernière requête : 0.16 ms Mémoire de requête : 0.035 MB mémoire avant requête : 4.956 MB Rangées retournées : 0

SELECT f.* 
  FROM cqbns_djcf_fields f 
  WHERE f.published=1 
  AND f.source=3 
  ORDER BY f.name

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	f	NULL	ref	published	published	4	const	8	11.11	Using index condition; Using where; Utilisation du tri complet de type filesort

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
14	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
12	JFalangDatabase->loadObjectList()	JROOT/components/com_djclassifieds/models/item.php:277
11	DjclassifiedsModelItem->getCustomAskSellerFields()	JROOT/components/com_djclassifieds/views/item/view.html.php:174
10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:132
6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.15 ms Après la dernière requête : 0.40 ms Mémoire de requête : 0.028 MB mémoire avant requête : 4.987 MB Rangées retournées : 0

SELECT r.* 
  FROM cqbns_djcf_regions r 
  ORDER BY r.parent_id, r.name COLLATE utf8_polish_ci

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	no matching row in const table

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
16	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
14	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:434
13	DJClassifiedsRegion::getRegions()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:339
12	DJClassifiedsRegion::getSEOParentPath()	JROOT/administrator/components/com_djclassifieds/lib/djseo.php:87
11	DJClassifiedsSEO::getItemRoute()	JROOT/components/com_djclassifieds/views/item/view.html.php:250
10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:132
6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.15 ms Après la dernière requête : 0.11 ms Mémoire de requête : 0.026 MB mémoire avant requête : 4.977 MB Rangées retournées : 1

SELECT i.region_id, count(i.id) as items_count 
  FROM cqbns_djcf_items i 
  WHERE i.published=1 
  AND i.date_exp > '2021-10-19 19:15:54' 
  GROUP BY i.region_id

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	i	NULL	system	published	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	100.00	NULL

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
16	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
14	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:439
13	DJClassifiedsRegion::getRegions()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:339
12	DJClassifiedsRegion::getSEOParentPath()	JROOT/administrator/components/com_djclassifieds/lib/djseo.php:87
11	DJClassifiedsSEO::getItemRoute()	JROOT/components/com_djclassifieds/views/item/view.html.php:250
10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:132
6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.42 ms Après la dernière requête : 4.43 ms Mémoire de requête : 0.025 MB mémoire avant requête : 5.051 MB Rangées retournées : 0

SELECT a.id, a.alias, a.catid, c.alias as c_alias 
  FROM cqbns_content a 
  LEFT JOIN cqbns_categories c 
  ON c.id=a.catid 
  WHERE a.state=1 
  AND a.id=1

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	no matching row in const table

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
15	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
13	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
12	JFalangDatabase->loadObject()	JROOT/administrator/components/com_djclassifieds/lib/djseo.php:496
11	DJClassifiedsSEO::getArticleLink()	JROOT/components/com_djclassifieds/views/item/view.html.php:287
10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:132
6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 1.42 ms Après la dernière requête : 2.93 ms Mémoire de requête : 0.033 MB mémoire avant requête : 5.110 MB Rangées retournées : 19

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

  FROM cqbns_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2021-10-19 16:15:54') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-10-19 16:15:54') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 0 OR mm.menuid <= 0) 
  AND m.language IN ('fr-FR','*')

  ORDER BY m.position, m.ordering

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	PRIMARY,published,newsfeeds,idx_language	published	1	const	34	1.04	Using index condition; Using where; Utilisation du tri complet de type filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	lloret_alexand.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	lloret_alexand.m.id	1	40.00	Using where; Using index

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
22	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
21	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
19	JFalangDatabase->loadObjectList()	Même appel que celui de la ligne ci-dessous.
18	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
17	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
16	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
15	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
14	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/templates/infinity/html/com_djclassifieds/item/default.php:85
13</