Annonces de sous-location - Results from #240

Annonces de sous-location	Date
Sous-location Lyon Nous sommes deux colocataires et je cherche une personne qui prendrait ma place pour sous-louer mon ...	21-06-2010 par clofilde Vu 1235 fois
Sous-location LYON T3 Place Bellecour Juillet-Août Bonjour à tous, Etudiants en deuxième année d’école de commerce, nous, Benjamin et Romain, sous-l ...	20-06-2010 par Benjamin et Romain Vu 1221 fois
SOUS LOC SUR LYON JUILLET/AOUT Grand appartement typique (88m2, 3 personnes) situé dans le centre ville. Chambres spacieuses et lum ...	19-06-2010 par Marineloriot Vu 1022 fois
Sous location T2 Lyon 9 eme Bonjour à tous. Je m'absente durant tout l'été en région parisienne pour y effectuer un stage de 2 ...	18-06-2010 par capitaineHitsugaya Vu 1159 fois
A LOUER JUILLET AOUT VILLEURBANNE / LYON PROXIMITE CAMPUS UNIVERSITAIRE DE LA DOUA / PARC DE LA TETE D'OR A LOUER PENDANT LES VACCANCES D'ETE ( DU 12 JUILLET JUSQUAU 12 SEPTEMBRE ) UN GRAND T1 ( 2 ...	18-06-2010 par ryda56 Vu 1221 fois
Sous location Lyon 7iéme T1 bis 68m2 Sous loue grand appartement 70m2, à saxe gambetta pour juillet et aout. Commerce, métro, bus, tram ...	17-06-2010 par nans Vu 1008 fois
Appartement rue Victor Hugo Lyon 2 EN CENTRE VILLE DANS BEL IMMEUBLE ANCIEN. GRAND T5 DE 160 M² SE COMPOSANT D'UN HALL D'ENTREE, D'UN S ...	17-06-2010 par Lescolocs Vu 1104 fois
sous location appartement lyon bonjour, mon copain et moi avons un appartement de 40 m² au centre de la croix rousse, a 15 min a pi ...	16-06-2010 par yonyonb Vu 1051 fois
sous location Lyon mois de juillet Studio de 32 m2, Lyon 1er, à coté de la place des terreaux, refait à neuf il y a un an, 1 er étage a ...	15-06-2010 par matp1 Vu 1224 fois
Sous-location Appartement Lyon T5 spacieux ancien restauré, 120m², 4 chambres, 2 SdB, grand séjour, salle à manger, Rue de la Char ...	14-06-2010 par mgt31 Vu 1051 fois
lyon 1er proche terreaux juillet aout Étudiants en première année d’école d'ingénieur , nous sous-louons notre coloc à compter de juillet ...	13-06-2010 par lyonappart Vu 959 fois
Sous location appart 31m², 350 Euros, Lyon 7 ,dispo immediate à début Septembre Je sous-loue mon appartement disponible immédiatement jusqu'au 10 Septembre (mais flexible suivant ...	11-06-2010 par Phlip Vu 1135 fois
sous-location chambre Lyon centre Bonjour, Je propose une petite chambre sympa, 20 m2, pour le mois de juillet et début Aout. Idéal ...	10-06-2010 par fripondivin Vu 1084 fois
300e/m!! juillet aout/ 69009 Dans immeuble neuf, bel appart T4: ensoleillé, spacieux (100m2) et calme. Tout confort:2 terrasses, ...	10-06-2010 par csalies Vu 1130 fois
sous location chambre lyon bonjour dans un appartement situé dans le 7ème arrondissent de Lyon, à 5 minutes du métro de la gui ...	08-06-2010 par nico la Vu 1018 fois
studio lyon 2ième centre place Bellecour Studio de 25m2, meublé, en plein centre de lyon, sur la place Bellecour, donnant sur cour intérieur. ...	08-06-2010 par Astrid lc Vu 1347 fois
Appartement T1 bis tout confort sur Caluire (Lyon) Appartement T1 bis ï¿½ louer sur Caluire (montessuy) ï¿½ cï¿½tï¿½ de la piscine Caluire ï¿½ 10 min ...	07-06-2010 par butterfly Vu 1228 fois
sous location appartement a Londre SAINT FARGEAU PONTHIERRY PROCHE, pour cette demeure contemporaine récente (2002), les critères de ch ...	07-06-2010 par NACHIROU Vu 2027 fois
Sous Location T2 Lyon T2 avec mezzanine. cuis américaine équipée, SBD avec WC et douche balnéo. Chbre à l'étage avec ran ...	06-06-2010 par Mélie4 Vu 1105 fois
sous location appartment Lyon Bonjour, Je pars à l'étranger pour 2 mois et demi, je sous loue mon appartement situé au 6ème arron ...	06-06-2010 par sofia03 Vu 1066 fois

Console de débogage Joomla!

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1792725568,
                "last": 1792725568,
                "now": 1792725568
            },
            "token": "scLwWDAqDztwFimKN7ojaCEdF3tJR6iH"
        },
        "registry": {
            "com_adssearch": {
                "offres": {
                    "ordercol": null,
                    "limitstart": 240
                }
            }
        },
        "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
        }
    }
}

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

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Même appel que celui de la ligne ci-dessous.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

#	Appel	Fichier et numéro de ligne
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

EXPLAIN impossible sur la requête : INSERT INTO `xca3p_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3636373166653634323434653539663134383862333237316331643661396638', 1, 1792725568, 0, '', 0)

Profil

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.03 ms
init for update	0.02 ms
Update	0.11 ms
Waiting for query cache lock	0.01 ms
Update	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.04 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.03 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Temps de requête : 0.64 ms Après la dernière requête : 1.42 ms Mémoire de requête : 0.021 MB mémoire avant requête : 1.160 MB Rangées retournées : 5

SELECT id, rules

  FROM `xca3p_viewlevels`

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xca3p_viewlevels	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	5

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.47 ms Après la dernière requête : 0.08 ms Mémoire de requête : 0.021 MB mémoire avant requête : 1.172 MB Rangées retournées : 2

SELECT b.id

  FROM xca3p_usergroups AS a

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

  WHERE a.id = 11

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	6	Using where; Using index

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.39 ms Après la dernière requête : 2.88 ms Mémoire de requête : 0.021 MB mémoire avant requête : 1.510 MB Rangées retournées : 0

SELECT `path`

  FROM xca3p_rsfirewall_ignored

  WHERE `type`='ignore_folder' OR `type`='ignore_file'

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
11	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:53
10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:19
9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:161
8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:27
7	plgSystemRsfirewall->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.08 ms Mémoire de requête : 0.021 MB mémoire avant requête : 1.515 MB Rangées retournées : 0

SELECT `file`

  FROM xca3p_rsfirewall_hashes

  WHERE `type`='protect'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xca3p_rsfirewall_hashes	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	52	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
11	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:60
10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:19
9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:161
8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:27
7	plgSystemRsfirewall->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT *

  FROM xca3p_rsfirewall_configuration

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xca3p_rsfirewall_configuration	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	65

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:68
10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:19
9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:161
8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:27
7	plgSystemRsfirewall->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.71 ms Après la dernière requête : 1.79 ms Mémoire de requête : 0.025 MB mémoire avant requête : 1.766 MB Rangées retournées : 10

SHOW FULL COLUMNS 
  FROM `xca3p_rsfirewall_logs`

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
12	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_rsfirewall/tables/logs.php:36
11	RsfirewallTableLogs->__construct()	JROOT/libraries/src/Table/Table.php:328
10	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_rsfirewall/helpers/log.php:23
9	RSFirewallLogger->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/log.php:77
8	RSFirewallLogger::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:47
7	plgSystemRsfirewall->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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 : 20.26 ms Mémoire de requête : 0.023 MB mémoire avant requête : 3.113 MB Rangées retournées : 31

SELECT *

  FROM xca3p_rsform_config

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xca3p_rsform_config	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	31

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsform/helpers/config.php:50
11	RSFormProConfig->load()	JROOT/administrator/components/com_rsform/helpers/config.php:17
10	RSFormProConfig->__construct()	JROOT/administrator/components/com_rsform/helpers/config.php:102
9	RSFormProConfig::getInstance()	JROOT/plugins/system/rsformdeletesubmissions/rsformdeletesubmissions.php:26
8	plgSystemRsformdeletesubmissions->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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 : 5.02 ms Mémoire de requête : 0.031 MB mémoire avant requête : 3.480 MB Rangées retournées : 4

SELECT `key`, `value` 
  FROM `xca3p_forseo_config`;

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xca3p_forseo_config	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	4

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
32	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/platform/joomla/dbconnection.php:88
31	Weeblr\Wblib\Forseo\Platform\Joomla\Dbconnection->loadAssocList()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/db/db.php:477
30	Weeblr\Wblib\Forseo\Db\Db->loadAssocList()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/db/helper.php:213
29	Weeblr\Wblib\Forseo\Db\Helper->selectAssocList()	JROOT/plugins/system/forseo/vendor/weeblr/forseo/model/config.php:122
28	Weeblr\Forseo\Model\Config->preload()	JROOT/plugins/system/forseo/vendor/weeblr/forseo/model/config.php:82
27	Weeblr\Forseo\Model\Config->__construct()	JROOT/plugins/system/forseo/vendor/weeblr/forseo/factory.php:138
26	Weeblr\Forseo\ForseoApp->Weeblr\Forseo\{closure}()	Même appel que celui de la ligne ci-dessous.
25	call_user_func_array()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/platform/joomla/platform.php:1911
24	Weeblr\Wblib\Forseo\Platform\JoomlaPlatform->executeHook()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/system/hook.php:169
23	Weeblr\Wblib\Forseo\System\Hook->execute()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/system/hook.php:151
22	Weeblr\Wblib\Forseo\System\Hook->filter()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/factory.php:308
21	Weeblr\Wblib\Forseo\Factory->buildObject()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/factory.php:243
20	Weeblr\Wblib\Forseo\Factory->getObject()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/factory.php:129
19	Weeblr\Wblib\Forseo\Factory->getThis()	JROOT/plugins/system/forseo/platform/components/hikashop.php:99
18	Weeblr\Forseo\Platform\Components\Hikashop->__construct()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/factory.php:322
17	Weeblr\Wblib\Forseo\Factory->buildObject()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/factory.php:227
16	Weeblr\Wblib\Forseo\Factory->getObject()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/factory.php:115
15	Weeblr\Wblib\Forseo\Factory->getThe()	JROOT/plugins/system/forseo/platform/hooks.php:118
14	Weeblr\Forseo\Platform\Hooks->add()	JROOT/plugins/system/forseo/vendor/weeblr/forseo/forseo.php:81
13	Weeblr\Forseo\ForseoApp->__construct()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/factory.php:427
12	Weeblr\Wblib\Forseo\Factory->buildApp()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/factory.php:301
11	Weeblr\Wblib\Forseo\Factory->buildObject()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/factory.php:243
10	Weeblr\Wblib\Forseo\Factory->getObject()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/factory.php:129
9	Weeblr\Wblib\Forseo\Factory->getThis()	JROOT/plugins/system/forseo/forseo.php:142
8	plgSystemForseo->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT `value`, `format` 
  FROM `xca3p_forseo_keystore` 
  WHERE `scope`='default' 
  AND `key`='crawl.completed';

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xca3p_forseo_keystore	const	main	main	574	const,const	1

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
26	JDatabaseDriver->loadAssoc()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/platform/joomla/dbconnection.php:83
25	Weeblr\Wblib\Forseo\Platform\Joomla\Dbconnection->loadAssoc()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/db/db.php:456
24	Weeblr\Wblib\Forseo\Db\Db->loadAssoc()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/db/helper.php:179
23	Weeblr\Wblib\Forseo\Db\Helper->selectAssoc()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/db/keystore.php:649
22	Weeblr\Wblib\Forseo\Db\Keystore->doGet()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/db/keystore.php:586
21	Weeblr\Wblib\Forseo\Db\Keystore->get()	JROOT/plugins/system/forseo/vendor/weeblr/forseo/helper/crawler.php:63
20	Weeblr\Forseo\Helper\Crawler->getCrawlId()	JROOT/plugins/system/forseo/vendor/weeblr/forseo/helper/crawler.php:81
19	Weeblr\Forseo\Helper\Crawler->getCompletedCrawlId()	JROOT/plugins/system/forseo/vendor/weeblr/forseo/model/sitemaps.php:184
18	Weeblr\Forseo\Model\Sitemaps->__construct()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/factory.php:322
17	Weeblr\Wblib\Forseo\Factory->buildObject()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/factory.php:220
16	Weeblr\Wblib\Forseo\Factory->getObject()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/factory.php:102
15	Weeblr\Wblib\Forseo\Factory->getA()	JROOT/plugins/system/forseo/vendor/weeblr/forseo/hooks.php:80
14	Weeblr\Forseo\Hooks->add()	JROOT/plugins/system/forseo/vendor/weeblr/forseo/forseo.php:88
13	Weeblr\Forseo\ForseoApp->__construct()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/factory.php:427
12	Weeblr\Wblib\Forseo\Factory->buildApp()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/factory.php:301
11	Weeblr\Wblib\Forseo\Factory->buildObject()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/factory.php:243
10	Weeblr\Wblib\Forseo\Factory->getObject()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/factory.php:129
9	Weeblr\Wblib\Forseo\Factory->getThis()	JROOT/plugins/system/forseo/forseo.php:142
8	plgSystemForseo->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 105.87 ms Après la dernière requête : 2.31 ms Mémoire de requête : 102.665 MB mémoire avant requête : 4.235 MB Rangées retournées : 12813

SELECT * 
  FROM `xca3p_forseo_rules` 
  WHERE `enabled` = 1 or (`enabled` = 2 
  and (`enabled_after` is null or `enabled_after` < '2026-10-23 03:19:28') 
  and (`enabled_until` is null or `enabled_until` > '2026-10-23 03:19:28')) 
  ORDER BY `type`asc;

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xca3p_forseo_rules	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	6423	Using where; Utilisation du tri complet de type filesort

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
17	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/platform/joomla/dbconnection.php:88
16	Weeblr\Wblib\Forseo\Platform\Joomla\Dbconnection->loadAssocList()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/db/db.php:477
15	Weeblr\Wblib\Forseo\Db\Db->loadAssocList()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/db/helper.php:213
14	Weeblr\Wblib\Forseo\Db\Helper->selectAssocList()	JROOT/plugins/system/forseo/vendor/weeblr/forseo/model/rules.php:133
13	Weeblr\Forseo\Model\Rules->loadRules()	Même appel que celui de la ligne ci-dessous.
12	call_user_func_array()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/platform/joomla/platform.php:1915
11	Weeblr\Wblib\Forseo\Platform\JoomlaPlatform->executeHook()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/system/hook.php:173
10	Weeblr\Wblib\Forseo\System\Hook->execute()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/system/hook.php:116
9	Weeblr\Wblib\Forseo\System\Hook->run()	JROOT/plugins/system/forseo/forseo.php:156
8	plgSystemForseo->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.81 ms Après la dernière requête : 84.50 ms Mémoire de requête : 0.025 MB mémoire avant requête : 115.433 MB Rangées retournées : 1

SELECT `value`, `format` 
  FROM `xca3p_forseo_keystore` 
  WHERE `scope`='default' 
  AND `key`='lists.rules.ordering';

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xca3p_forseo_keystore	const	main	main	574	const,const	1

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
21	JDatabaseDriver->loadAssoc()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/platform/joomla/dbconnection.php:83
20	Weeblr\Wblib\Forseo\Platform\Joomla\Dbconnection->loadAssoc()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/db/db.php:456
19	Weeblr\Wblib\Forseo\Db\Db->loadAssoc()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/db/helper.php:179
18	Weeblr\Wblib\Forseo\Db\Helper->selectAssoc()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/db/keystore.php:649
17	Weeblr\Wblib\Forseo\Db\Keystore->doGet()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/db/keystore.php:586
16	Weeblr\Wblib\Forseo\Db\Keystore->get()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/db/dataobjectsortedlist.php:552
15	Weeblr\Wblib\Forseo\Db\Dataobjectsortedlist->orderingLoad()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/db/dataobjectsortedlist.php:219
14	Weeblr\Wblib\Forseo\Db\Dataobjectsortedlist->orderingSort()	JROOT/plugins/system/forseo/vendor/weeblr/forseo/model/rules.php:144
13	Weeblr\Forseo\Model\Rules->loadRules()	Même appel que celui de la ligne ci-dessous.
12	call_user_func_array()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/platform/joomla/platform.php:1915
11	Weeblr\Wblib\Forseo\Platform\JoomlaPlatform->executeHook()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/system/hook.php:173
10	Weeblr\Wblib\Forseo\System\Hook->execute()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/system/hook.php:116
9	Weeblr\Wblib\Forseo\System\Hook->run()	JROOT/plugins/system/forseo/forseo.php:156
8	plgSystemForseo->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.55 ms Après la dernière requête : 14.80 ms Mémoire de requête : 0.020 MB mémoire avant requête : 4.656 MB Rangées retournées : 0

SELECT *

  FROM xca3p_rsfirewall_hashes

  WHERE (`type`='3.10.11' OR `type`='protect') 
  AND `flag`!='C'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xca3p_rsfirewall_hashes	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	52	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1049
8	plgSystemRsfirewall->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
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:225
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.34 ms Après la dernière requête : 0.16 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.663 MB Rangées retournées : 0

SELECT *

  FROM xca3p_rsfirewall_snapshots

  WHERE `type`='protect'

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsfirewall/helpers/snapshot.php:47
9	RSFirewallSnapshot::get()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1072
8	plgSystemRsfirewall->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
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:225
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.46 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.022 MB mémoire avant requête : 4.734 MB Rangées retournées : 0

SELECT `ip`,`reason`

  FROM xca3p_rsfirewall_lists

  WHERE (`ip`='216.73.216.33' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') 
  AND `type`='1' 
  AND `published`='1'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xca3p_rsfirewall_lists	ref	published,type,ip	published	1	const	1	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:165
10	plgSystemRsfirewall->isListed()	JROOT/plugins/system/rsfirewall/rsfirewall.php:144
9	plgSystemRsfirewall->isWhitelisted()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1108
8	plgSystemRsfirewall->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
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:225
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.07 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.740 MB Rangées retournées : 0

SELECT `ip`,`reason`

  FROM xca3p_rsfirewall_lists

  WHERE (`ip`='216.73.216.33' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') 
  AND `type`='0' 
  AND `published`='1'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xca3p_rsfirewall_lists	ref	published,type,ip	published	1	const	1	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:165
10	plgSystemRsfirewall->isListed()	JROOT/plugins/system/rsfirewall/rsfirewall.php:134
9	plgSystemRsfirewall->isBlacklisted()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1112
8	plgSystemRsfirewall->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
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:225
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.39 ms Après la dernière requête : 0.28 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.745 MB Rangées retournées : 0

SELECT *

  FROM xca3p_rsfirewall_exceptions

  WHERE `published`='1'

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:700
9	plgSystemRsfirewall->isException()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1243
8	plgSystemRsfirewall->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
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:225
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 : 3.25 ms Mémoire de requête : 0.028 MB mémoire avant requête : 4.843 MB Rangées retournées : 49

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

  FROM `xca3p_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_adsmanager','com_adssearch','com_advancedmodules','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cookix','com_cpanel','com_ffexplorer','com_fields','com_finder','com_forseo','com_installer','com_invoicing','com_jce','com_jmap','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_paidsystem','com_plugins','com_postinstall','com_privacy','com_quantummanager','com_redirect','com_regularlabsmanager','com_rsfirewall','com_rsform','com_search','com_tags','com_templates','com_users','com_wrapper')

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xca3p_assets	ALL	idx_asset_name	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	304	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
15	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
14	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
13	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
12	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
11	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/advancedmodules/src/Document.php:30
10	RegularLabs\Plugin\System\AdvancedModules\Document::loadFrontEditScript()	JROOT/plugins/system/advancedmodules/advancedmodules.php:95
9	PlgSystemAdvancedModules->handleOnAfterRoute()	JROOT/libraries/regularlabs/src/SystemPlugin.php:191
8	RegularLabs\Library\SystemPlugin->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
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:225
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 : 3.04 ms Mémoire de requête : 0.010 MB mémoire avant requête : 4.828 MB

UPDATE `xca3p_extensions`

  SET `params` = '{\"mediaversion\":\"4eac727ebc132435b413646376837e37\"}'

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

Explication

EXPLAIN impossible sur la requête : UPDATE `xca3p_extensions` SET `params` = '{\"mediaversion\":\"4eac727ebc132435b413646376837e37\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
21	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
20	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
19	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
18	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
17	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/platform/joomla/platform.php:1741
16	Weeblr\Wblib\Forseo\Platform\JoomlaPlatform->isDocumentType()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/platform/joomla/platform.php:1717
15	Weeblr\Wblib\Forseo\Platform\JoomlaPlatform->isHtmlPage()	JROOT/plugins/system/forseo/vendor/weeblr/forseo/controller/pagedatacollector.php:1158
14	Weeblr\Forseo\Controller\Pagedatacollector->canRun()	JROOT/plugins/system/forseo/vendor/weeblr/forseo/controller/pagedatacollector.php:157
13	Weeblr\Forseo\Controller\Pagedatacollector->onAfterRoute()	Même appel que celui de la ligne ci-dessous.
12	call_user_func_array()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/platform/joomla/platform.php:1915
11	Weeblr\Wblib\Forseo\Platform\JoomlaPlatform->executeHook()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/system/hook.php:173
10	Weeblr\Wblib\Forseo\System\Hook->execute()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/system/hook.php:116
9	Weeblr\Wblib\Forseo\System\Hook->run()	JROOT/plugins/system/forseo/forseo.php:225
8	plgSystemForseo->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
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:225
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.49 ms Après la dernière requête : 0.37 ms Mémoire de requête : 0.025 MB mémoire avant requête : 4.931 MB Rangées retournées : 0

SELECT * 
  FROM `xca3p_forseo_pages` 
  WHERE `url`='offre-sous-location?dept=69&reg=82&start=240';

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
20	JDatabaseDriver->loadAssoc()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/platform/joomla/dbconnection.php:83
19	Weeblr\Wblib\Forseo\Platform\Joomla\Dbconnection->loadAssoc()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/db/db.php:456
18	Weeblr\Wblib\Forseo\Db\Db->loadAssoc()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/db/helper.php:179
17	Weeblr\Wblib\Forseo\Db\Helper->selectAssoc()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/db/dataobject.php:318
16	Weeblr\Wblib\Forseo\Db\Dataobject->loadPerColumn()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/db/dataobject.php:461
15	Weeblr\Wblib\Forseo\Db\Dataobject->loadStorageSafe()	JROOT/plugins/system/forseo/vendor/weeblr/forseo/data/url.php:70
14	Weeblr\Forseo\Data\Url->loadPerUrl()	JROOT/plugins/system/forseo/vendor/weeblr/forseo/controller/pagedatacollector.php:170
13	Weeblr\Forseo\Controller\Pagedatacollector->onAfterRoute()	Même appel que celui de la ligne ci-dessous.
12	call_user_func_array()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/platform/joomla/platform.php:1915
11	Weeblr\Wblib\Forseo\Platform\JoomlaPlatform->executeHook()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/system/hook.php:173
10	Weeblr\Wblib\Forseo\System\Hook->execute()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/system/hook.php:116
9	Weeblr\Wblib\Forseo\System\Hook->run()	JROOT/plugins/system/forseo/forseo.php:225
8	plgSystemForseo->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
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:225
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 : 18.92 ms Après la dernière requête : 3.59 ms Mémoire de requête : 0.165 MB mémoire avant requête : 5.018 MB Rangées retournées : 2912

Requêtes dupliquées: #24

SELECT `region`

  FROM `xca3p_adssearch_ville`

  WHERE `reg` = 82

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xca3p_adssearch_ville	ALL	idx_reg	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	36868	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/components/com_adssearch/helpers/adssearch.php:693
16	AdssearchHelper::getVar()	JROOT/components/com_adssearch/models/offres.php:91
15	AdssearchModelOffres->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:140
14	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:194
13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_adssearch/models/offres.php:139
12	AdssearchModelOffres->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_adssearch/views/offres/view.html.php:36
10	AdssearchViewOffres->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_adssearch/controller.php:110
8	AdssearchController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_adssearch/adssearch.php:36
6	require_once JROOT/components/com_adssearch/adssearch.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 17.88 ms Après la dernière requête : 0.04 ms Mémoire de requête : 0.165 MB mémoire avant requête : 5.026 MB Rangées retournées : 2912

Requêtes dupliquées: #23

SELECT `region`

  FROM `xca3p_adssearch_ville`

  WHERE `reg` = 82

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xca3p_adssearch_ville	ALL	idx_reg	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	36868	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/components/com_adssearch/helpers/adssearch.php:696
16	AdssearchHelper::getVar()	JROOT/components/com_adssearch/models/offres.php:91
15	AdssearchModelOffres->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:140
14	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:194
13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_adssearch/models/offres.php:139
12	AdssearchModelOffres->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_adssearch/views/offres/view.html.php:36
10	AdssearchViewOffres->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_adssearch/controller.php:110
8	AdssearchController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_adssearch/adssearch.php:36
6	require_once JROOT/components/com_adssearch/adssearch.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 17.40 ms Après la dernière requête : 0.08 ms Mémoire de requête : 0.040 MB mémoire avant requête : 5.035 MB Rangées retournées : 304

Requêtes dupliquées: #26 #35 #36

SELECT `departement`

  FROM `xca3p_adssearch_ville`

  WHERE `dep` = 69

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xca3p_adssearch_ville	ALL	idx_dep	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	36868	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/components/com_adssearch/helpers/adssearch.php:693
16	AdssearchHelper::getVar()	JROOT/components/com_adssearch/models/offres.php:98
15	AdssearchModelOffres->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:140
14	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:194
13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_adssearch/models/offres.php:139
12	AdssearchModelOffres->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_adssearch/views/offres/view.html.php:36
10	AdssearchViewOffres->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_adssearch/controller.php:110
8	AdssearchController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_adssearch/adssearch.php:36
6	require_once JROOT/components/com_adssearch/adssearch.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 17.63 ms Après la dernière requête : 0.05 ms Mémoire de requête : 0.040 MB mémoire avant requête : 5.043 MB Rangées retournées : 304

Requêtes dupliquées: #25 #35 #36

SELECT `departement`

  FROM `xca3p_adssearch_ville`

  WHERE `dep` = 69

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xca3p_adssearch_ville	ALL	idx_dep	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	36868	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/components/com_adssearch/helpers/adssearch.php:696
16	AdssearchHelper::getVar()	JROOT/components/com_adssearch/models/offres.php:98
15	AdssearchModelOffres->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:140
14	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:194
13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_adssearch/models/offres.php:139
12	AdssearchModelOffres->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_adssearch/views/offres/view.html.php:36
10	AdssearchViewOffres->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_adssearch/controller.php:110
8	AdssearchController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_adssearch/adssearch.php:36
6	require_once JROOT/components/com_adssearch/adssearch.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 15.22 ms Après la dernière requête : 0.17 ms Mémoire de requête : 0.024 MB mémoire avant requête : 5.059 MB Rangées retournées : 1

SELECT COUNT(*)

  FROM `xca3p_adsmanager_ads` AS `a`

  LEFT JOIN `xca3p_adsmanager_adcat` AS `c` 
  ON (`a`.`id` = `c`.`adid`)

  LEFT JOIN `xca3p_users` AS `u` 
  ON (`a`.`userid` = `u`.`id`)

  WHERE a.ad_region = 'RHONE ALPES' 
  AND a.ad_dpartement = 'RHONE' 
  AND c.catid = 1 
  AND a.published = 1

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	PRIMARY	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	13545	Using where
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	8	opzn1997_soulouercom.a.id,const	1

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354
16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:289
15	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:323
14	Joomla\CMS\MVC\Model\ListModel->getStart()	JROOT/libraries/src/MVC/Model/ListModel.php:194
13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_adssearch/models/offres.php:139
12	AdssearchModelOffres->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_adssearch/views/offres/view.html.php:36
10	AdssearchViewOffres->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_adssearch/controller.php:110
8	AdssearchController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_adssearch/adssearch.php:36
6	require_once JROOT/components/com_adssearch/adssearch.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 15.89 ms Après la dernière requête : 0.08 ms Mémoire de requête : 0.086 MB mémoire avant requête : 5.062 MB Rangées retournées : 20

SELECT a.*,`c`.`catid` AS `adcat_catid`,`u`.`name` AS `owner_name`,`u`.`username` AS `owner_username`,`u`.`email` AS `owner_email`

  FROM `xca3p_adsmanager_ads` AS `a`

  LEFT JOIN `xca3p_adsmanager_adcat` AS `c` 
  ON (`a`.`id` = `c`.`adid`)

  LEFT JOIN `xca3p_users` AS `u` 
  ON (`a`.`userid` = `u`.`id`)

  WHERE a.ad_region = 'RHONE ALPES' 
  AND a.ad_dpartement = 'RHONE' 
  AND c.catid = 1 
  AND a.published = 1

  ORDER BY a.date_created DESC 
  LIMIT 240, 20

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	PRIMARY	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	13545	Using where; Utilisation du tri complet de type filesort
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	8	opzn1997_soulouercom.a.id,const	1
1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	opzn1997_soulouercom.a.userid	1	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_adssearch/models/offres.php:139
12	AdssearchModelOffres->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_adssearch/views/offres/view.html.php:36
10	AdssearchViewOffres->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_adssearch/controller.php:110
8	AdssearchController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_adssearch/adssearch.php:36
6	require_once JROOT/components/com_adssearch/adssearch.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT custom_data 
  FROM xca3p_extensions 
  WHERE element = 'yootheme' 
  AND folder = 'system' 
  LIMIT 1

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xca3p_extensions	ref	element_clientid,element_folder_clientid	element_folder_clientid	804	const,const	1	Using index condition

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
36	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
35	JDatabaseDriver->loadAssoc()	JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Database.php:39
34	YOOtheme\Joomla\Database->fetchAssoc()	JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Storage.php:23
33	YOOtheme\Joomla\Storage->__construct()	Même appel que celui de la ligne ci-dessous.
32	ReflectionClass->newInstanceArgs()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container/Service.php:181
31	YOOtheme\Container\Service->resolveClass()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container/Service.php:154
30	YOOtheme\Container\Service->resolveInstance()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:327
29	YOOtheme\Container->resolve()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:92
28	YOOtheme\Container->get()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:408
27	YOOtheme\Container->resolveDependencies()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:358
26	YOOtheme\Container->resolveArguments()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container/Service.php:179
25	YOOtheme\Container\Service->resolveClass()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container/Service.php:154
24	YOOtheme\Container\Service->resolveInstance()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:327
23	YOOtheme\Container->resolve()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:92
22	YOOtheme\Container->get()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:408
21	YOOtheme\Container->resolveDependencies()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:358
20	YOOtheme\Container->resolveArguments()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:274
19	YOOtheme\Container->call()	JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71
18	YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:115
17	YOOtheme\EventDispatcher->handleDefault()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:45
16	YOOtheme\EventDispatcher->dispatch()	JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Dispatcher.php:48
15	YOOtheme\Joomla\Dispatcher->YOOtheme\Joomla\{closure}()	JROOT/libraries/joomla/event/dispatcher.php:165
14	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
13	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla/src/ViewTrait.php:22
12	View3aeb4553->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_adssearch/views/offres/view.html.php:51
10	AdssearchViewOffres->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_adssearch/controller.php:110
8	AdssearchController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_adssearch/adssearch.php:36
6	require_once JROOT/components/com_adssearch/adssearch.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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 : 17.05 ms Mémoire de requête : 0.023 MB mémoire avant requête : 6.072 MB Rangées retournées : 0

SELECT `communetwo`

  FROM `xca3p_adssearch_ville`

  WHERE `id` = 0

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/components/com_adssearch/helpers/adssearch.php:693
15	AdssearchHelper::getVar()	JROOT/components/com_adssearch/views/offres/tmpl/default.php:36
14	include JROOT/components/com_adssearch/views/offres/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla/src/ViewTrait.php:26
12	View3aeb4553->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_adssearch/views/offres/view.html.php:51
10	AdssearchViewOffres->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_adssearch/controller.php:110
8	AdssearchController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_adssearch/adssearch.php:36
6	require_once JROOT/components/com_adssearch/adssearch.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.08 ms Mémoire de requête : 0.024 MB mémoire avant requête : 6.080 MB Rangées retournées : 8

Requêtes dupliquées: #32

SELECT `region_alias`

  FROM `xca3p_adssearch_departement`

  WHERE `reg_code` = 82

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xca3p_adssearch_departement	ALL	idx_reg_code	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	104	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/components/com_adssearch/helpers/adssearch.php:693
15	AdssearchHelper::getVar()	JROOT/components/com_adssearch/views/offres/tmpl/default.php:37
14	include JROOT/components/com_adssearch/views/offres/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla/src/ViewTrait.php:26
12	View3aeb4553->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_adssearch/views/offres/view.html.php:51
10	AdssearchViewOffres->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_adssearch/controller.php:110
8	AdssearchController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_adssearch/adssearch.php:36
6	require_once JROOT/components/com_adssearch/adssearch.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.03 ms Mémoire de requête : 0.024 MB mémoire avant requête : 6.087 MB Rangées retournées : 8

Requêtes dupliquées: #31

SELECT `region_alias`

  FROM `xca3p_adssearch_departement`

  WHERE `reg_code` = 82

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xca3p_adssearch_departement	ALL	idx_reg_code	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	104	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_adssearch/helpers/adssearch.php:696
15	AdssearchHelper::getVar()	JROOT/components/com_adssearch/views/offres/tmpl/default.php:37
14	include JROOT/components/com_adssearch/views/offres/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla/src/ViewTrait.php:26
12	View3aeb4553->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_adssearch/views/offres/view.html.php:51
10	AdssearchViewOffres->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_adssearch/controller.php:110
8	AdssearchController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_adssearch/adssearch.php:36
6	require_once JROOT/components/com_adssearch/adssearch.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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 : 0.04 ms Mémoire de requête : 0.025 MB mémoire avant requête : 6.102 MB Rangées retournées : 1

Requêtes dupliquées: #34

SELECT `departement_alias`

  FROM `xca3p_adssearch_departement`

  WHERE `dep_code` = 69

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xca3p_adssearch_departement	ALL	idx_dep_code	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	104	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/components/com_adssearch/helpers/adssearch.php:693
15	AdssearchHelper::getVar()	JROOT/components/com_adssearch/views/offres/tmpl/default.php:38
14	include JROOT/components/com_adssearch/views/offres/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla/src/ViewTrait.php:26
12	View3aeb4553->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_adssearch/views/offres/view.html.php:51
10	AdssearchViewOffres->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_adssearch/controller.php:110
8	AdssearchController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_adssearch/adssearch.php:36
6	require_once JROOT/components/com_adssearch/adssearch.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.03 ms Mémoire de requête : 0.024 MB mémoire avant requête : 6.111 MB Rangées retournées : 1

Requêtes dupliquées: #33

SELECT `departement_alias`

  FROM `xca3p_adssearch_departement`

  WHERE `dep_code` = 69

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xca3p_adssearch_departement	ALL	idx_dep_code	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	104	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_adssearch/helpers/adssearch.php:696
15	AdssearchHelper::getVar()	JROOT/components/com_adssearch/views/offres/tmpl/default.php:38
14	include JROOT/components/com_adssearch/views/offres/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla/src/ViewTrait.php:26
12	View3aeb4553->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_adssearch/views/offres/view.html.php:51
10	AdssearchViewOffres->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_adssearch/controller.php:110
8	AdssearchController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_adssearch/adssearch.php:36
6	require_once JROOT/components/com_adssearch/adssearch.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 18.61 ms Après la dernière requête : 0.04 ms Mémoire de requête : 0.039 MB mémoire avant requête : 6.120 MB Rangées retournées : 304

Requêtes dupliquées: #25 #26 #36

SELECT `departement`

  FROM `xca3p_adssearch_ville`

  WHERE `dep` = 69

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xca3p_adssearch_ville	ALL	idx_dep	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	36868	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/components/com_adssearch/helpers/adssearch.php:693
15	AdssearchHelper::getVar()	JROOT/components/com_adssearch/views/offres/tmpl/default.php:75
14	include JROOT/components/com_adssearch/views/offres/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla/src/ViewTrait.php:26
12	View3aeb4553->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_adssearch/views/offres/view.html.php:51
10	AdssearchViewOffres->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_adssearch/controller.php:110
8	AdssearchController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_adssearch/adssearch.php:36
6	require_once JROOT/components/com_adssearch/adssearch.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 17.29 ms Après la dernière requête : 0.04 ms Mémoire de requête : 0.040 MB mémoire avant requête : 6.127 MB Rangées retournées : 304

Requêtes dupliquées: #25 #26 #35

SELECT `departement`

  FROM `xca3p_adssearch_ville`

  WHERE `dep` = 69

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xca3p_adssearch_ville	ALL	idx_dep	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	36868	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_adssearch/helpers/adssearch.php:696
15	AdssearchHelper::getVar()	JROOT/components/com_adssearch/views/offres/tmpl/default.php:75
14	include JROOT/components/com_adssearch/views/offres/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla/src/ViewTrait.php:26
12	View3aeb4553->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_adssearch/views/offres/view.html.php:51
10	AdssearchViewOffres->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_adssearch/controller.php:110
8	AdssearchController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_adssearch/adssearch.php:36
6	require_once JROOT/components/com_adssearch/adssearch.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.70 ms Après la dernière requête : 61.38 ms Mémoire de requête : 0.024 MB mémoire avant requête : 6.315 MB Rangées retournées : 0

SELECT * 
  FROM `xca3p_forseo_custom_meta` 
  WHERE `url`='offre-sous-location?dept=69&reg=82&start=240';

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xca3p_forseo_custom_meta	ref	url	url	763	const	1	Using index condition

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
17	JDatabaseDriver->loadAssoc()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/platform/joomla/dbconnection.php:83
16	Weeblr\Wblib\Forseo\Platform\Joomla\Dbconnection->loadAssoc()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/db/db.php:456
15	Weeblr\Wblib\Forseo\Db\Db->loadAssoc()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/db/helper.php:179
14	Weeblr\Wblib\Forseo\Db\Helper->selectAssoc()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/db/dataobject.php:318
13	Weeblr\Wblib\Forseo\Db\Dataobject->loadPerColumn()	JROOT/plugins/system/forseo/vendor/weeblr/forseo/controller/pagedatacollector.php:418
12	Weeblr\Forseo\Controller\Pagedatacollector->loadCustomMetaData()	Même appel que celui de la ligne ci-dessous.
11	call_user_func_array()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/platform/joomla/platform.php:1915
10	Weeblr\Wblib\Forseo\Platform\JoomlaPlatform->executeHook()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/system/hook.php:173
9	Weeblr\Wblib\Forseo\System\Hook->execute()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/system/hook.php:116
8	Weeblr\Wblib\Forseo\System\Hook->run()	JROOT/plugins/system/forseo/forseo.php:378
7	plgSystemForseo->doOnAfterDispatchComplete()	JROOT/plugins/system/forseo/forseo.php:230
6	plgSystemForseo->{closure}()	JROOT/libraries/joomla/event/dispatcher.php:165
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.92 ms Après la dernière requête : 1.35 ms Mémoire de requête : 0.085 MB mémoire avant requête : 6.358 MB Rangées retournées : 18

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down

  FROM xca3p_modules AS m

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

  LEFT JOIN xca3p_advancedmodules as am 
  ON am.moduleid = m.id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND m.access IN (1,1) 
  AND m.client_id = 0

  ORDER BY m.position, m.ordering

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	published,newsfeeds	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	51	Using where; Utilisation du tri complet de type filesort
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	opzn1997_soulouercom.m.module,const	1	Using index condition; Using where
1	SIMPLE	am	eq_ref	PRIMARY	PRIMARY	4	opzn1997_soulouercom.m.id	1	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
40	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
39	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:179
38	PlgSystemAdvancedModuleHelper->getModuleList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:60
37	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
36	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
35	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Helper/ModuleHelper.php:366
34	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
33	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
32	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:277
31	YOOtheme\Container->call()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:292
30	YOOtheme\Container->YOOtheme\{closure}()	Même appel que celui de la ligne ci-dessous.
29	call_user_func_array()	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:86
28	YOOtheme\View->__call()	JROOT/templates/yootheme/templates/header-mobile.php:31
27	require JROOT/templates/yootheme/templates/header-mobile.php	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:274
26	YOOtheme\View->evaluate()	JROOT/templates/yootheme/vendor/yootheme/view/src/View/FileLoader.php:15
25	YOOtheme\View\FileLoader->__invoke()	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:162
24	YOOtheme\View->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/theme/src/Theme/ViewHelper.php:62
23	YOOtheme\Theme\ViewHelper->YOOtheme\Theme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:162
22	YOOtheme\View->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla/src/UrlListener.php:22
21	YOOtheme\Theme\Joomla\UrlListener::resolveRelativeUrl()	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:162
20	YOOtheme\View->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:237
19	YOOtheme\View->render()	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:69
18	YOOtheme\View->__invoke()	JROOT/templates/yootheme/templates/header.php:111
17	require JROOT/templates/yootheme/templates/header.php	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:274
16	YOOtheme\View->evaluate()	JROOT/templates/yootheme/vendor/yootheme/view/src/View/FileLoader.php:15
15	YOOtheme\View\FileLoader->__invoke()	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:162
14	YOOtheme\View->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/theme/src/Theme/ViewHelper.php:62
13	YOOtheme\Theme\ViewHelper->YOOtheme\Theme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:162
12	YOOtheme\View->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla/src/UrlListener.php:22
11	YOOtheme\Theme\Joomla\UrlListener::resolveRelativeUrl()	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:162
10	YOOtheme\View->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:237
9	YOOtheme\View->render()	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:69
8	YOOtheme\View->__invoke()	JROOT/templates/yootheme_souslouer/index.php:134
7	require JROOT/templates/yootheme_souslouer/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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 : 39.00 ms Mémoire de requête : 0.022 MB mémoire avant requête : 7.254 MB Rangées retournées : 0

SELECT *
 
  FROM xca3p_jmap_metainfo
 
  WHERE `linkurl` = 'https://www.souslouer.com/offre-sous-location'
 
  AND `published` = 1

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xca3p_jmap_metainfo	ref	published	published	1	const	1	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/plugins/system/jmap/jmap.php:429
12	plgSystemJMap->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.04 ms Mémoire de requête : 0.022 MB mémoire avant requête : 7.260 MB Rangées retournées : 0

SELECT *
 
  FROM xca3p_jmap_canonicals
 
  WHERE `linkurl` = 'https://www.souslouer.com/offre-sous-location'

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/plugins/system/jmap/jmap.php:508
12	plgSystemJMap->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.68 ms Après la dernière requête : 0.97 ms Mémoire de requête : 0.025 MB mémoire avant requête : 7.280 MB Rangées retournées : 1

select `full_url` 
  from `xca3p_forseo_pages`  
  where  `content_id`='Itemid=104&dept=69&limitstart=240&option=com_adssearch&reg=82&start=240&view=offres' 
  and ( (`canonical_mode`='1' 
  and `canonical_user`='0') or (`canonical_mode`='0' 
  and `canonical_auto`='0') ) 
  order by `canonical_mode` desc

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xca3p_forseo_pages	ref	content_id	content_id	762	const	1	Using index condition; Using where; Utilisation du tri complet de type filesort

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
21	JDatabaseDriver->loadResult()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/platform/joomla/dbconnection.php:108
20	Weeblr\Wblib\Forseo\Platform\Joomla\Dbconnection->loadResult()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/db/db.php:536
19	Weeblr\Wblib\Forseo\Db\Db->loadResult()	JROOT/plugins/system/forseo/vendor/weeblr/forseo/helper/page.php:401
18	Weeblr\Forseo\Helper\Page->getDefaultCanonical()	JROOT/plugins/system/forseo/vendor/weeblr/forseo/controller/pageprocessor.php:788
17	Weeblr\Forseo\Controller\Pageprocessor->autoCanonical()	Même appel que celui de la ligne ci-dessous.
16	call_user_func_array()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/platform/joomla/platform.php:1915
15	Weeblr\Wblib\Forseo\Platform\JoomlaPlatform->executeHook()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/system/hook.php:173
14	Weeblr\Wblib\Forseo\System\Hook->execute()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/system/hook.php:116
13	Weeblr\Wblib\Forseo\System\Hook->run()	JROOT/plugins/system/forseo/forseo.php:485
12	plgSystemForseo->doOnBeforeCompileHeadComplete()	JROOT/plugins/system/forseo/forseo.php:420
11	plgSystemForseo->{closure}()	JROOT/libraries/joomla/event/dispatcher.php:165
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.56 ms Après la dernière requête : 1.64 ms Mémoire de requête : 0.021 MB mémoire avant requête : 7.412 MB Rangées retournées : 2

SELECT `a`.`type`,`a`.`search`,`a`.`replace`,`a`.`position`

  FROM `xca3p_cookix_action` AS `a`

  LEFT JOIN xca3p_cookix_service AS s 
  ON s.id = a.service

  WHERE `a`.`published` = 1 
  AND `s`.`published` = 1

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ref	PRIMARY,idx_state	idx_state	1	const	1	Using index
1	SIMPLE	a	ref	idx_service,idx_state	idx_service	4	opzn1997_soulouercom.s.id	2	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_cookix/helpers/cookix.php:226
8	CookixHelper::getTasks()	JROOT/plugins/system/cookix/cookix.php:70
7	PlgSystemCookix->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.43 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.020 MB mémoire avant requête : 7.417 MB Rangées retournées : 1

SELECT `varname`,`varvalue`

  FROM `xca3p_cookix_var`

  WHERE `published` = 1

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xca3p_cookix_var	ref	idx_state	idx_state	1	const	1

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_cookix/helpers/cookix.php:208
8	CookixHelper::getVariables()	JROOT/plugins/system/cookix/cookix.php:74
7	PlgSystemCookix->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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 : 1.88 ms Mémoire de requête : 0.020 MB mémoire avant requête : 7.420 MB Rangées retournées : 0

SELECT *
 
  FROM xca3p_jmap_headings
 
  WHERE `linkurl` = 'https://www.souslouer.com/offre-sous-location'

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
8	JDatabaseDriver->loadObject()	JROOT/plugins/system/jmap/jmap.php:819
7	plgSystemJMap->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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 : 2.12 ms Mémoire de requête : 0.043 MB mémoire avant requête : 7.602 MB Rangées retournées : 1

SELECT * 
  FROM xca3p_adsmanager_config

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xca3p_adsmanager_config	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
19	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_adsmanager/models/configuration.php:26
18	AdsmanagerModelConfiguration->getConfiguration()	JROOT/components/com_adsmanager/lib/tconf.php:18
17	TConf::getConfig()	JROOT/components/com_adsmanager/lib/core.php:123
16	require_once JROOT/components/com_adsmanager/lib/core.php	JROOT/components/com_adsmanager/router.php:92
15	AdsmanagerBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
14	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
13	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
12	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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 : 0.08 ms Mémoire de requête : 0.025 MB mémoire avant requête : 7.634 MB Rangées retournées : 0

SELECT group_id 
  FROM xca3p_user_usergroup_map
                            
  WHERE user_id = 0

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
20	JDatabaseDriver->loadColumn()	JROOT/components/com_adsmanager/helpers/usergroups.php:28
19	JHTMLAdsmanagerUserGroups::getUserGroup()	JROOT/administrator/components/com_adsmanager/models/configuration.php:65
18	AdsmanagerModelConfiguration->getConfiguration()	JROOT/components/com_adsmanager/lib/tconf.php:18
17	TConf::getConfig()	JROOT/components/com_adsmanager/lib/core.php:123
16	require_once JROOT/components/com_adsmanager/lib/core.php	JROOT/components/com_adsmanager/router.php:92
15	AdsmanagerBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
14	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
13	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
12	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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 : 15.14 ms Mémoire de requête : 0.024 MB mémoire avant requête : 7.710 MB Rangées retournées : 1

SELECT `id` 
  FROM `xca3p_forseo_pages` 
  WHERE `content_id`='Itemid=104&dept=69&limitstart=240&option=com_adssearch&reg=82&start=240&view=offres' 
  AND `canonical_auto`=0 
  AND `url` != 'offre-sous-location?dept=69&reg=82&start=240';

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xca3p_forseo_pages	ref	url,content_id	content_id	762	const	1	Using index condition; Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/platform/joomla/dbconnection.php:103
16	Weeblr\Wblib\Forseo\Platform\Joomla\Dbconnection->loadObjectList()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/db/db.php:524
15	Weeblr\Wblib\Forseo\Db\Db->loadObjectList()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/db/helper.php:261
14	Weeblr\Wblib\Forseo\Db\Helper->selectObjectList()	JROOT/plugins/system/forseo/vendor/weeblr/forseo/helper/page.php:429
13	Weeblr\Forseo\Helper\Page->canonicalType()	JROOT/plugins/system/forseo/vendor/weeblr/forseo/controller/pagedatacollector.php:634
12	Weeblr\Forseo\Controller\Pagedatacollector->onAfterRenderComplete()	Même appel que celui de la ligne ci-dessous.
11	call_user_func_array()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/platform/joomla/platform.php:1915
10	Weeblr\Wblib\Forseo\Platform\JoomlaPlatform->executeHook()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/system/hook.php:173
9	Weeblr\Wblib\Forseo\System\Hook->execute()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/system/hook.php:116
8	Weeblr\Wblib\Forseo\System\Hook->run()	JROOT/plugins/system/forseo/forseo.php:568
7	plgSystemForseo->doOnAfterRenderComplete()	JROOT/plugins/system/forseo/forseo.php:410
6	plgSystemForseo->{closure}()	JROOT/libraries/joomla/event/dispatcher.php:165
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT `value`, `format` 
  FROM `xca3p_forseo_keystore` 
  WHERE `scope`='default' 
  AND `key`='crawl.in_progress';

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xca3p_forseo_keystore	const	main	main	574	const,const	1

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
24	JDatabaseDriver->loadAssoc()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/platform/joomla/dbconnection.php:83
23	Weeblr\Wblib\Forseo\Platform\Joomla\Dbconnection->loadAssoc()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/db/db.php:456
22	Weeblr\Wblib\Forseo\Db\Db->loadAssoc()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/db/helper.php:179
21	Weeblr\Wblib\Forseo\Db\Helper->selectAssoc()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/db/keystore.php:649
20	Weeblr\Wblib\Forseo\Db\Keystore->doGet()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/db/keystore.php:586
19	Weeblr\Wblib\Forseo\Db\Keystore->get()	JROOT/plugins/system/forseo/vendor/weeblr/forseo/helper/crawler.php:63
18	Weeblr\Forseo\Helper\Crawler->getCrawlId()	JROOT/plugins/system/forseo/vendor/weeblr/forseo/helper/crawler.php:110
17	Weeblr\Forseo\Helper\Crawler->getInProgressCrawlId()	JROOT/plugins/system/forseo/vendor/weeblr/forseo/helper/crawler.php:124
16	Weeblr\Forseo\Helper\Crawler->isCrawlInProgress()	JROOT/plugins/system/forseo/vendor/weeblr/forseo/data/page.php:317
15	Weeblr\Forseo\Data\Page->afterSetKey()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/base/dataobject.php:220
14	Weeblr\Wblib\Forseo\Base\Dataobject->setKey()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/base/dataobject.php:106
13	Weeblr\Wblib\Forseo\Base\Dataobject->set()	JROOT/plugins/system/forseo/vendor/weeblr/forseo/controller/pagedatacollector.php:634
12	Weeblr\Forseo\Controller\Pagedatacollector->onAfterRenderComplete()	Même appel que celui de la ligne ci-dessous.
11	call_user_func_array()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/platform/joomla/platform.php:1915
10	Weeblr\Wblib\Forseo\Platform\JoomlaPlatform->executeHook()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/system/hook.php:173
9	Weeblr\Wblib\Forseo\System\Hook->execute()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/system/hook.php:116
8	Weeblr\Wblib\Forseo\System\Hook->run()	JROOT/plugins/system/forseo/forseo.php:568
7	plgSystemForseo->doOnAfterRenderComplete()	JROOT/plugins/system/forseo/forseo.php:410
6	plgSystemForseo->{closure}()	JROOT/libraries/joomla/event/dispatcher.php:165
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM `xca3p_forseo_errors` 
  WHERE `url`='offre-sous-location?dept=69&reg=82&start=240';

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xca3p_forseo_errors	ref	url	url	762	const	1	Using index condition

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
21	JDatabaseDriver->loadAssoc()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/platform/joomla/dbconnection.php:83
20	Weeblr\Wblib\Forseo\Platform\Joomla\Dbconnection->loadAssoc()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/db/db.php:456
19	Weeblr\Wblib\Forseo\Db\Db->loadAssoc()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/db/helper.php:179
18	Weeblr\Wblib\Forseo\Db\Helper->selectAssoc()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/db/dataobject.php:318
17	Weeblr\Wblib\Forseo\Db\Dataobject->loadPerColumn()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/db/dataobject.php:461
16	Weeblr\Wblib\Forseo\Db\Dataobject->loadStorageSafe()	JROOT/plugins/system/forseo/vendor/weeblr/forseo/data/url.php:70
15	Weeblr\Forseo\Data\Url->loadPerUrl()	JROOT/plugins/system/forseo/vendor/weeblr/forseo/controller/pagedatacollector.php:950
14	Weeblr\Forseo\Controller\Pagedatacollector->forceRecrawlIfExisting()	JROOT/plugins/system/forseo/vendor/weeblr/forseo/controller/pagedatacollector.php:819
13	Weeblr\Forseo\Controller\Pagedatacollector->storeUnknownIncomingRequests()	JROOT/plugins/system/forseo/vendor/weeblr/forseo/controller/pagedatacollector.php:698
12	Weeblr\Forseo\Controller\Pagedatacollector->onAfterRenderComplete()	Même appel que celui de la ligne ci-dessous.
11	call_user_func_array()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/platform/joomla/platform.php:1915
10	Weeblr\Wblib\Forseo\Platform\JoomlaPlatform->executeHook()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/system/hook.php:173
9	Weeblr\Wblib\Forseo\System\Hook->execute()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/system/hook.php:116
8	Weeblr\Wblib\Forseo\System\Hook->run()	JROOT/plugins/system/forseo/forseo.php:568
7	plgSystemForseo->doOnAfterRenderComplete()	JROOT/plugins/system/forseo/forseo.php:410
6	plgSystemForseo->{closure}()	JROOT/libraries/joomla/event/dispatcher.php:165
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM `xca3p_forseo_links` 
  WHERE `url`='offre-sous-location?dept=69&reg=82&start=240';

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
21	JDatabaseDriver->loadAssoc()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/platform/joomla/dbconnection.php:83
20	Weeblr\Wblib\Forseo\Platform\Joomla\Dbconnection->loadAssoc()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/db/db.php:456
19	Weeblr\Wblib\Forseo\Db\Db->loadAssoc()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/db/helper.php:179
18	Weeblr\Wblib\Forseo\Db\Helper->selectAssoc()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/db/dataobject.php:318
17	Weeblr\Wblib\Forseo\Db\Dataobject->loadPerColumn()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/db/dataobject.php:461
16	Weeblr\Wblib\Forseo\Db\Dataobject->loadStorageSafe()	JROOT/plugins/system/forseo/vendor/weeblr/forseo/data/url.php:70
15	Weeblr\Forseo\Data\Url->loadPerUrl()	JROOT/plugins/system/forseo/vendor/weeblr/forseo/controller/pagedatacollector.php:950
14	Weeblr\Forseo\Controller\Pagedatacollector->forceRecrawlIfExisting()	JROOT/plugins/system/forseo/vendor/weeblr/forseo/controller/pagedatacollector.php:820
13	Weeblr\Forseo\Controller\Pagedatacollector->storeUnknownIncomingRequests()	JROOT/plugins/system/forseo/vendor/weeblr/forseo/controller/pagedatacollector.php:698
12	Weeblr\Forseo\Controller\Pagedatacollector->onAfterRenderComplete()	Même appel que celui de la ligne ci-dessous.
11	call_user_func_array()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/platform/joomla/platform.php:1915
10	Weeblr\Wblib\Forseo\Platform\JoomlaPlatform->executeHook()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/system/hook.php:173
9	Weeblr\Wblib\Forseo\System\Hook->execute()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/system/hook.php:116
8	Weeblr\Wblib\Forseo\System\Hook->run()	JROOT/plugins/system/forseo/forseo.php:568
7	plgSystemForseo->doOnAfterRenderComplete()	JROOT/plugins/system/forseo/forseo.php:410
6	plgSystemForseo->{closure}()	JROOT/libraries/joomla/event/dispatcher.php:165
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

41 types de requêtes exécutées, triées par occurrences.

Tables sélectionnées :

4 × SELECT `departement` 
  FROM `xca3p_adssearch_ville`

3 × SELECT `value`, `format` 
  FROM `xca3p_forseo_keystore`

2 × SELECT `region_alias` 
  FROM `xca3p_adssearch_departement`

2 × SELECT `region` 
  FROM `xca3p_adssearch_ville`

2 × SELECT `departement_alias` 
  FROM `xca3p_adssearch_departement`

2 × SELECT `ip`,`reason` 
  FROM xca3p_rsfirewall_lists

1 × SELECT *  
  FROM xca3p_jmap_canonicals

1 × SELECT * 
  FROM `xca3p_forseo_custom_meta`

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down 
  FROM xca3p_modules AS m 
  LEFT JOIN xca3p_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id 
  LEFT JOIN xca3p_advancedmodules as am 
  ON am.moduleid = m.id

1 × SELECT *  
  FROM xca3p_jmap_metainfo

1 × SELECT `data` 
  FROM `xca3p_session`

1 × SELECT `communetwo` 
  FROM `xca3p_adssearch_ville`

1 × SELECT `a`.`type`,`a`.`search`,`a`.`replace`,`a`.`position` 
  FROM `xca3p_cookix_action` AS `a` 
  LEFT JOIN xca3p_cookix_service AS s 
  ON s.id = a.service

1 × SELECT `varname`,`varvalue` 
  FROM `xca3p_cookix_var`

1 × SELECT *  
  FROM xca3p_jmap_headings

1 × SELECT * 
  FROM xca3p_adsmanager_confi

1 × SELECT group_id 
  FROM xca3p_user_usergroup_map

1 × SELECT `id` 
  FROM `xca3p_forseo_pages`

1 × SELECT * 
  FROM `xca3p_forseo_errors`

1 × select `full_url` 
  from `xca3p_forseo_pages`

1 × SELECT COUNT(*) 
  FROM `xca3p_adsmanager_ads` AS `a` 
  LEFT JOIN `xca3p_adsmanager_adcat` AS `c` 
  ON (`a`.`id` = `c`.`adid`) 
  LEFT JOIN `xca3p_users` AS `u` 
  ON (`a`.`userid` = `u`.`id`)

1 × SELECT custom_data 
  FROM xca3p_extensions

1 × SELECT `key`, `value` 
  FROM `xca3p_forseo_config`

1 × SELECT id, rules 
  FROM `xca3p_viewlevels

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

1 × SELECT `path` 
  FROM xca3p_rsfirewall_ignored

1 × SELECT `file` 
  FROM xca3p_rsfirewall_hashes

1 × SELECT * 
  FROM xca3p_rsfirewall_configuratio

1 × SELECT * 
  FROM xca3p_rsform_confi

1 × SELECT * 
  FROM `xca3p_forseo_rules`

1 × SELECT a.*,`c`.`catid` AS `adcat_catid`,`u`.`name` AS `owner_name`,`u`.`username` AS `owner_username`,`u`.`email` AS `owner_email` 
  FROM `xca3p_adsmanager_ads` AS `a` 
  LEFT JOIN `xca3p_adsmanager_adcat` AS `c` 
  ON (`a`.`id` = `c`.`adid`) 
  LEFT JOIN `xca3p_users` AS `u` 
  ON (`a`.`userid` = `u`.`id`)

1 × SELECT * 
  FROM xca3p_rsfirewall_hashes

1 × SELECT * 
  FROM xca3p_rsfirewall_snapshots

1 × SELECT * 
  FROM xca3p_rsfirewall_exceptions

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

1 × SELECT * 
  FROM `xca3p_forseo_pages`

1 × SELECT `session_id` 
  FROM `xca3p_session`

1 × SELECT * 
  FROM `xca3p_forseo_links`

Autres tables :

1 × INSERT INTO `xca3p_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'3636373166653634323434653539663134383862333237316331643661396638', 1, 1792725568, 0, '', 0

1 × SHOW FULL COLUMNS 
  FROM `xca3p_rsfirewall_logs

1 × UPDATE `xca3p_extensions` 
  SET `params` = '{\"mediaversion\":\"4eac727ebc132435b413646376837e37\"}'

Offres de sous-location RHONE

Sous-location Lyon

Sous-location LYON T3 Place Bellecour Juillet-Août

SOUS LOC SUR LYON JUILLET/AOUT

Sous location T2 Lyon 9 eme

A LOUER JUILLET AOUT VILLEURBANNE / LYON PROXIMITE CAMPUS UNIVERSITAIRE DE LA DOUA / PARC DE LA TETE D'OR

Sous location Lyon 7iéme T1 bis 68m2

Appartement rue Victor Hugo Lyon 2

sous location appartement lyon

sous location Lyon mois de juillet

Sous-location Appartement Lyon

lyon 1er proche terreaux juillet aout

Sous location appart 31m², 350 Euros, Lyon 7 ,dispo immediate à début Septembre

sous-location chambre Lyon centre

300e/m!! juillet aout/ 69009

sous location chambre lyon

studio lyon 2ième centre place Bellecour

Appartement T1 bis tout confort sur Caluire (Lyon)

sous location appartement a Londre

Sous Location T2 Lyon

sous location appartment Lyon

Console de débogage Joomla!

Session

Profil d'information

Temps

Mémoire

Occupation de la mémoire

Requêtes de base de données

50 requêtes exécutées 264.95 ms

10 doubles découverts!

41 types de requêtes exécutées, triées par occurrences.

Tables sélectionnées :

Autres tables :