Annonces de sous-location - Results from #80

Annonces de sous-location	Date
Sous Location Lyon 8e dans Colocation Je sous-loue une chambre dans une colocation de 3 personnes en tout. Nous sommes situés au 8e Arro ...	23-05-2013 par cweinsbe Vu 1325 fois
Sous location Lyon/Vénissieux Juillet septembre possibilité de prolonger Appartement 1 pièce 38 m2 meublé rénové dans une villa de 9 appartements avec portail éléctrique ...	09-05-2013 par Carlotta2407 Vu 1087 fois
sous location T2 Villeurbanne Grandclement sous loue appartement sous les toits type T2 - tout confort -Villeurbanne Place Grandclement - Proxi ...	08-05-2013 par chrystool69 Vu 1158 fois
location de chambre chez l'habitant A louer dans jolie maison au centre du village de Mornant (69440) proche de toutes commodités (cine ...	02-05-2013 par lespetitescasseroles Vu 968 fois
appart croix-rousse situé à la croix-rousse, quartier très animé de Lyon et très touristique. Proche toutes commodités. ...	25-04-2013 par laurie04 Vu 2049 fois
Superbe appartement 35m2 Lyon,560€/mois tout compris ! Bonjour à tous, Je suis étudiante et je sous loue mon studio de 35m2 près de Croix Paquet de mi j ...	14-04-2013 par mariegod Vu 2178 fois
Sous-location T1 25 m² Lyon Bonjour Je sous loue mon appartement tout équipé situé à Villeurbanne ( Totem ) à 10 mn de la g ...	02-04-2013 par mary Vu 1408 fois
Lyon - Villeurbanne FLACHET Sous location pour départ à l\'étranger du 01/04/13 moderne T2 meublé refait à neuf, au métro Flach ...	12-03-2013 par Anissa Vu 1653 fois
A sous-louer Lyon centre A louer studio Lyon centre, pour printemps-été, spacieux et agréable, chambre mezzanine, meublé U ...	12-03-2013 par enzo6938 Vu 2421 fois
Appartement sous location T2 Lyon3 Je sous loue mon appartement pour 670 euros le mois. Il est situé à lyon 3 proche du métro du tram e ...	19-02-2013 par gael Vu 1412 fois
Appartement 64m2 Lyon 9ème proche métro Appartement meublé disponible du 1er janvier au 31 août 2013 pour raison professionnelle. Si nécessa ...	12-12-2012 par antoinalaplage Vu 1950 fois
Appartement, beau souplex, Perrache Appartement atypique: Souplex de 110m2 en rez de chaussée, très spacieux, dans le centre ville de Ly ...	10-12-2012 par happyhour Vu 1632 fois
Location T2 Lyon fetes des lumieres Loue charmant 2 pieces 58m2 en face des galeries lafayette, idealement placé , 2 a 3 personnes , ide ...	28-11-2012 par locen1clic Vu 1555 fois
Sous Location T2 Meublé- Lyon 2e (Jacobins) Sous loue à compter du 20 décembre 2012 très beau T2 meublé , belle décoration, calme, lumineux, 7e ...	19-11-2012 par CCD Vu 2100 fois
Sous location T2 lyon Bonjour, Je souhaite sous louer mon appart uniquement pour les wee du jeudi ou vendredi jusqu'au ...	12-11-2012 par janeoff Vu 1336 fois
Echange Studio Lyon contre Paris 2-3-4mois Bonjour, Je suis basée à Lyon dans un studio plein centre meublé tout confort et joli (lit deux pla ...	09-10-2012 par charlotteb Vu 1686 fois
Location appartement centre lyon Nous recherchons une personne ou couple sérieux pour sous louer notre appartement de début décembre ...	05-10-2012 par Marionsouslocation Vu 1995 fois
sous-location charmant appartement Lyon 7ème- 17aout au 7 septembre Bonjour, Je sous-loue mon appartement à Lyon pour de courtes durées (4 jours min - 3 semaines max). ...	02-08-2012 par Vu 1440 fois
sous-location charmant appartement Lyon 7ï¿½me- 17aout au 7 septembre Bonjour, Je sous-loue mon appartement a Lyon du 17-08 au 7-09 (min 3nuits) / 3 pers.max C'est un ...	02-08-2012 par cecilenoemie Vu 1079 fois
T2 rénové Lyon/villeurbanne Juillet/Aout Sous location du 26 juillet au 21 aout c'est un T2 de 45m2 situé au métro Flachet Villeurbanne (sur ...	19-07-2012 par coraliedutang Vu 1361 fois

Console de débogage Joomla!

Session

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

Status	Duration
Starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.02 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.01 ms
Executing	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	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

#	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	Using index

#	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'3338623330396433383664343261356131366433356565313063326433336534', 1, 1713564104, 0, '', 0)

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 for update	0.02 ms
Update	0.09 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.04 ms
closing tables	0.03 ms
Unlocking tables	0.01 ms
closing tables	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
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.42 ms Après la dernière requête : 1.67 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.03 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
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	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.51 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.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.02 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	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: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.43 ms Après la dernière requête : 3.25 ms Mémoire de requête : 0.021 MB mémoire avant requête : 1.509 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.02 ms
Statistics	0.02 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
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	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.39 ms Après la dernière requête : 0.05 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.03 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	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.04 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.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.09 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	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
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.81 ms Après la dernière requête : 2.00 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.03 ms
checking permissions	0.01 ms
closing tables	0.01 ms
Opening tables	0.17 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.03 ms
Executing	0.01 ms
Filling schema table	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
checking permissions	0.07 ms
closing tables	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
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
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.51 ms Après la dernière requête : 24.21 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.09 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.02 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
closing tables	0.02 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.49 ms Après la dernière requête : 6.33 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.06 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
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	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
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.49 ms Après la dernière requête : 5.85 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.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.05 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.03 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	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
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 : 55.01 ms Après la dernière requête : 2.77 ms Mémoire de requête : 63.622 MB mémoire avant requête : 4.235 MB Rangées retournées : 7939

SELECT * 
  FROM `xca3p_forseo_rules` 
  WHERE `enabled` = 1 or (`enabled` = 2 
  and (`enabled_after` is null or `enabled_after` < '2024-04-19 22:01:44') 
  and (`enabled_until` is null or `enabled_until` > '2024-04-19 22:01:44')) 
  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	3970	Using where; Utilisation du tri complet de type filesort

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.03 ms
Optimizing	0.03 ms
Statistics	0.02 ms
Preparing	0.03 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	53.64 ms
End of update loop	0.08 ms
Query end	0.02 ms
Commit	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 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.78 ms Après la dernière requête : 52.87 ms Mémoire de requête : 0.025 MB mémoire avant requête : 73.061 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.15 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.07 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.01 ms
Unlocking tables	0.01 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
closing tables	0.01 ms
Unlocking tables	0.05 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.02 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.57 ms Après la dernière requête : 12.75 ms Mémoire de requête : 0.020 MB mémoire avant requête : 4.654 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.09 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.02 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.09 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	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.41 ms Après la dernière requête : 0.14 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.661 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.02 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
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
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.05 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.48 ms Après la dernière requête : 0.08 ms Mémoire de requête : 0.022 MB mémoire avant requête : 4.731 MB Rangées retournées : 0

SELECT `ip`,`reason`

  FROM xca3p_rsfirewall_lists

  WHERE (`ip`='3.145.206.169' 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.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.04 ms
Optimizing	0.05 ms
Statistics	0.06 ms
Preparing	0.03 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
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	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
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.41 ms Après la dernière requête : 0.08 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.737 MB Rangées retournées : 0

SELECT `ip`,`reason`

  FROM xca3p_rsfirewall_lists

  WHERE (`ip`='3.145.206.169' 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.02 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.03 ms
Executing	0.02 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.02 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.30 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.743 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.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.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
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 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.98 ms Après la dernière requête : 3.57 ms Mémoire de requête : 0.028 MB mémoire avant requête : 4.840 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	284	Using where

Profil

Status	Duration
Starting	0.07 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.03 ms
init	0.06 ms
Optimizing	0.02 ms
Statistics	0.13 ms
Preparing	0.02 ms
Executing	0.03 ms
Sending data	0.35 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	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
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.51 ms Après la dernière requête : 3.49 ms Mémoire de requête : 0.010 MB mémoire avant requête : 4.825 MB

UPDATE `xca3p_extensions`

  SET `params` = '{\"mediaversion\":\"336b4ba5ebba0442fd01511c9d902a12\"}'

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

Explication

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

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.04 ms
init for update	0.07 ms
Updating	0.06 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.04 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	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
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.61 ms Après la dernière requête : 0.41 ms Mémoire de requête : 0.026 MB mémoire avant requête : 4.928 MB Rangées retournées : 1

Requêtes dupliquées: #42

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

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xca3p_forseo_pages	const	url	url	762	const	1

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.04 ms
Statistics	0.07 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
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	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
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 : 22.83 ms Après la dernière requête : 3.82 ms Mémoire de requête : 0.165 MB mémoire avant requête : 5.024 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.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.05 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	22.29 ms
End of update loop	0.03 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 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: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 : 22.00 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.165 MB mémoire avant requête : 5.033 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.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.02 ms
Statistics	0.03 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	21.48 ms
End of update loop	0.03 ms
Query end	0.02 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 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/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 : 21.88 ms Après la dernière requête : 0.13 ms Mémoire de requête : 0.040 MB mémoire avant requête : 5.042 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.04 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	21.37 ms
End of update loop	0.03 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 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 : 23.01 ms Après la dernière requête : 0.09 ms Mémoire de requête : 0.040 MB mémoire avant requête : 5.050 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.05 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.02 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	22.47 ms
End of update loop	0.06 ms
Query end	0.01 ms
Commit	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.02 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/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 : 45.14 ms Après la dernière requête : 0.22 ms Mémoire de requête : 0.024 MB mémoire avant requête : 5.066 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	c	index	PRIMARY	PRIMARY	8	NULL	11144	Using where; Using index
1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	4	opzn1997_soulouercom.c.adid	1	Using where

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.05 ms
Executing	0.02 ms
Sending data	44.48 ms
End of update loop	0.08 ms
Query end	0.02 ms
Commit	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.03 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: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 : 19.01 ms Après la dernière requête : 0.13 ms Mémoire de requête : 0.086 MB mémoire avant requête : 5.069 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 80, 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	12804	Using where; Utilisation du tri complet de type filesort
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	8	opzn1997_soulouercom.a.id,const	1	Using index
1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	opzn1997_soulouercom.a.userid	1	Using where

Profil

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.10 ms
Optimizing	0.05 ms
Statistics	0.06 ms
Preparing	0.04 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.05 ms
Creating sort index	18.23 ms
End of update loop	0.07 ms
Query end	0.01 ms
Commit	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 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.51 ms Après la dernière requête : 1.48 ms Mémoire de requête : 0.032 MB mémoire avant requête : 5.318 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.02 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.07 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
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 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
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.54 ms Après la dernière requête : 20.57 ms Mémoire de requête : 0.023 MB mémoire avant requête : 6.071 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.09 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.02 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.02 ms
End of update loop	0.03 ms
Query end	0.02 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.05 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
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.50 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.024 MB mémoire avant requête : 6.079 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.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.02 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.11 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	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: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.43 ms Après la dernière requête : 0.05 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.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.02 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.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	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/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.43 ms Après la dernière requête : 0.06 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.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.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
closing tables	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
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.42 ms Après la dernière requête : 0.05 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.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.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.03 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
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 : 23.27 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.039 MB mémoire avant requête : 6.119 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.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.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	22.79 ms
End of update loop	0.07 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.03 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/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 : 22.79 ms Après la dernière requête : 0.10 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.04 ms
checking permissions	0.02 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.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	22.27 ms
End of update loop	0.07 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 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
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 : 1.71 ms Après la dernière requête : 42.25 ms Mémoire de requête : 0.024 MB mémoire avant requête : 6.316 MB Rangées retournées : 1

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

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.12 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.02 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.11 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	1.05 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	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.97 ms Après la dernière requête : 1.51 ms Mémoire de requête : 0.085 MB mémoire avant requête : 6.363 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	am	eq_ref	PRIMARY	PRIMARY	4	opzn1997_soulouercom.m.id	1	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	opzn1997_soulouercom.m.module,const	1	Using index condition; Using where

Profil

Status	Duration
Starting	0.07 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.07 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.34 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 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.59 ms Après la dernière requête : 23.20 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_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.09 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.06 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
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	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.38 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.022 MB mémoire avant requête : 7.266 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.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	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
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.47 ms Après la dernière requête : 1.90 ms Mémoire de requête : 0.027 MB mémoire avant requête : 7.305 MB Rangées retournées : 0

Requêtes dupliquées: #43 #53 #54

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

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xca3p_forseo_collected_urls	const	url	url	762	const	1

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.03 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.05 ms
Preparing	0.01 ms
Executing	0.03 ms
End of update loop	0.01 ms
Query end	0.03 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.03 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/dataobject.php:318
22	Weeblr\Wblib\Forseo\Db\Dataobject->loadPerColumn()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/db/dataobject.php:461
21	Weeblr\Wblib\Forseo\Db\Dataobject->loadStorageSafe()	JROOT/plugins/system/forseo/vendor/weeblr/forseo/data/url.php:70
20	Weeblr\Forseo\Data\Url->loadPerUrl()	JROOT/plugins/system/forseo/vendor/weeblr/forseo/helper/linkscollector.php:91
19	Weeblr\Forseo\Helper\Linkscollector->urlAlreadySeen()	JROOT/plugins/system/forseo/vendor/weeblr/forseo/helper/linkscollector.php:279
18	Weeblr\Forseo\Helper\Linkscollector->storeCollectedLinks()	JROOT/plugins/system/forseo/vendor/weeblr/forseo/controller/pagedatacollector.php:513
17	Weeblr\Forseo\Controller\Pagedatacollector->collectPlatformMetaData()	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.54 ms Après la dernière requête : 0.08 ms Mémoire de requête : 0.028 MB mémoire avant requête : 7.317 MB Rangées retournées : 1

Requêtes dupliquées: #22

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

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xca3p_forseo_pages	const	url	url	762	const	1

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.03 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.01 ms
Unlocking tables	0.01 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
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	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
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/dataobject.php:318
22	Weeblr\Wblib\Forseo\Db\Dataobject->loadPerColumn()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/db/dataobject.php:461
21	Weeblr\Wblib\Forseo\Db\Dataobject->loadStorageSafe()	JROOT/plugins/system/forseo/vendor/weeblr/forseo/data/url.php:70
20	Weeblr\Forseo\Data\Url->loadPerUrl()	JROOT/plugins/system/forseo/vendor/weeblr/forseo/helper/linkscollector.php:102
19	Weeblr\Forseo\Helper\Linkscollector->urlAlreadySeen()	JROOT/plugins/system/forseo/vendor/weeblr/forseo/helper/linkscollector.php:279
18	Weeblr\Forseo\Helper\Linkscollector->storeCollectedLinks()	JROOT/plugins/system/forseo/vendor/weeblr/forseo/controller/pagedatacollector.php:513
17	Weeblr\Forseo\Controller\Pagedatacollector->collectPlatformMetaData()	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.43 ms Après la dernière requête : 0.22 ms Mémoire de requête : 0.027 MB mémoire avant requête : 7.339 MB Rangées retournées : 0

Requêtes dupliquées: #41 #53 #54

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

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xca3p_forseo_collected_urls	const	url	url	762	const	1

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.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
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	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
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
25	JDatabaseDriver->loadAssoc()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/platform/joomla/dbconnection.php:83
24	Weeblr\Wblib\Forseo\Platform\Joomla\Dbconnection->loadAssoc()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/db/db.php:456
23	Weeblr\Wblib\Forseo\Db\Db->loadAssoc()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/db/helper.php:179
22	Weeblr\Wblib\Forseo\Db\Helper->selectAssoc()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/db/dataobject.php:318
21	Weeblr\Wblib\Forseo\Db\Dataobject->loadPerColumn()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/db/dataobject.php:461
20	Weeblr\Wblib\Forseo\Db\Dataobject->loadStorageSafe()	JROOT/plugins/system/forseo/vendor/weeblr/forseo/data/url.php:70
19	Weeblr\Forseo\Data\Url->loadPerUrl()	JROOT/plugins/system/forseo/vendor/weeblr/forseo/helper/linkscollector.php:315
18	Weeblr\Forseo\Helper\Linkscollector->storeCollectedLinks()	JROOT/plugins/system/forseo/vendor/weeblr/forseo/controller/pagedatacollector.php:513
17	Weeblr\Forseo\Controller\Pagedatacollector->collectPlatformMetaData()	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.41 ms Après la dernière requête : 0.37 ms Mémoire de requête : 0.027 MB mémoire avant requête : 7.357 MB Rangées retournées : 0

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

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.03 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.03 ms
Preparing	0.01 ms
Executing	0.02 ms
End of update loop	0.01 ms
Query end	0.03 ms
Commit	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	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
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
27	JDatabaseDriver->loadAssoc()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/platform/joomla/dbconnection.php:83
26	Weeblr\Wblib\Forseo\Platform\Joomla\Dbconnection->loadAssoc()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/db/db.php:456
25	Weeblr\Wblib\Forseo\Db\Db->loadAssoc()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/db/helper.php:179
24	Weeblr\Wblib\Forseo\Db\Helper->selectAssoc()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/db/dataobject.php:318
23	Weeblr\Wblib\Forseo\Db\Dataobject->loadPerColumn()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/db/dataobject.php:461
22	Weeblr\Wblib\Forseo\Db\Dataobject->loadStorageSafe()	JROOT/plugins/system/forseo/vendor/weeblr/forseo/data/url.php:70
21	Weeblr\Forseo\Data\Url->loadPerUrl()	JROOT/plugins/system/forseo/vendor/weeblr/forseo/data/collected.php:89
20	Weeblr\Forseo\Data\Collected->beforeStore()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/db/dataobject.php:367
19	Weeblr\Wblib\Forseo\Db\Dataobject->store()	JROOT/plugins/system/forseo/vendor/weeblr/forseo/helper/linkscollector.php:371
18	Weeblr\Forseo\Helper\Linkscollector->storeCollectedLinks()	JROOT/plugins/system/forseo/vendor/weeblr/forseo/controller/pagedatacollector.php:513
17	Weeblr\Forseo\Controller\Pagedatacollector->collectPlatformMetaData()	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.45 ms Après la dernière requête : 0.08 ms Mémoire de requête : 0.010 MB mémoire avant requête : 7.368 MB

INSERT INTO `xca3p_forseo_collected_urls` (`id`, `crawled_by`, `crawl_started_at`, `crawl_timeout_at`, `status`, `target`, `url`, `full_url`, `referrers`, `click_depth`, `attempts`, `priority`) 
  VALUES (0, '', NULL, NULL, 0, 0, 'offre-sous-location?reg=82&dept=69&start=80', 'offre-sous-location?reg=82&dept=69&start=80', 'offre-sous-location?reg=82&dept=69&start=80', 0, 0, 0);

Explication

EXPLAIN impossible sur la requête : INSERT INTO `xca3p_forseo_collected_urls` (`id`, `crawled_by`, `crawl_started_at`, `crawl_timeout_at`, `status`, `target`, `url`, `full_url`, `referrers`, `click_depth`, `attempts`, `priority`) VALUES (0, '', NULL, NULL, 0, 0, 'offre-sous-location?reg=82&dept=69&start=80', 'offre-sous-location?reg=82&dept=69&start=80', 'offre-sous-location?reg=82&dept=69&start=80', 0, 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.01 ms
init for update	0.03 ms
Update	0.09 ms
End of update loop	0.01 ms
Query end	0.02 ms
Commit	0.05 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
23	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/platform/joomla/dbconnection.php:158
22	Weeblr\Wblib\Forseo\Platform\Joomla\Dbconnection->execute()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/db/db.php:125
21	Weeblr\Wblib\Forseo\Db\Db->execute()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/db/helper.php:339
20	Weeblr\Wblib\Forseo\Db\Helper->insert()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/db/dataobject.php:388
19	Weeblr\Wblib\Forseo\Db\Dataobject->store()	JROOT/plugins/system/forseo/vendor/weeblr/forseo/helper/linkscollector.php:371
18	Weeblr\Forseo\Helper\Linkscollector->storeCollectedLinks()	JROOT/plugins/system/forseo/vendor/weeblr/forseo/controller/pagedatacollector.php:513
17	Weeblr\Forseo\Controller\Pagedatacollector->collectPlatformMetaData()	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.70 ms Après la dernière requête : 0.68 ms Mémoire de requête : 0.025 MB mémoire avant requête : 7.367 MB Rangées retournées : 1

select `full_url` 
  from `xca3p_forseo_pages`  
  where  `content_id`='Itemid=104&dept=69&limitstart=80&option=com_adssearch&reg=82&start=80&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.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.04 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.03 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.17 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	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
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.52 ms Après la dernière requête : 1.68 ms Mémoire de requête : 0.021 MB mémoire avant requête : 7.495 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	1	Using where

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.02 ms
Optimizing	0.02 ms
Statistics	0.07 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
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.02 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.06 ms Mémoire de requête : 0.020 MB mémoire avant requête : 7.501 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.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.02 ms
Statistics	0.03 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
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.03 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 : 2.05 ms Mémoire de requête : 0.020 MB mémoire avant requête : 7.503 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.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.04 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
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	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.59 ms Après la dernière requête : 2.35 ms Mémoire de requête : 0.043 MB mémoire avant requête : 7.681 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.04 ms
checking permissions	0.03 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.10 ms
End of update loop	0.01 ms
Query end	0.02 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 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
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.10 ms Mémoire de requête : 0.025 MB mémoire avant requête : 7.714 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	Using index

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.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
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	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
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.56 ms Après la dernière requête : 17.66 ms Mémoire de requête : 0.024 MB mémoire avant requête : 7.795 MB Rangées retournées : 0

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

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.05 ms
checking permissions	0.01 ms
Opening tables	0.03 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.05 ms
Preparing	0.04 ms
Executing	0.02 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.03 ms
closing tables	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: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.54 ms Après la dernière requête : 0.66 ms Mémoire de requête : 0.026 MB mémoire avant requête : 7.805 MB Rangées retournées : 1

Requêtes dupliquées: #41 #43 #54

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

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xca3p_forseo_collected_urls	const	url	url	762	const	1

Profil

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.03 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	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
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/helper/linkscollector.php:91
14	Weeblr\Forseo\Helper\Linkscollector->urlAlreadySeen()	JROOT/plugins/system/forseo/vendor/weeblr/forseo/helper/linkscollector.php:279
13	Weeblr\Forseo\Helper\Linkscollector->storeCollectedLinks()	JROOT/plugins/system/forseo/vendor/weeblr/forseo/controller/pagedatacollector.php:688
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.41 ms Après la dernière requête : 0.10 ms Mémoire de requête : 0.025 MB mémoire avant requête : 7.817 MB Rangées retournées : 1

Requêtes dupliquées: #41 #43 #53

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

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xca3p_forseo_collected_urls	const	url	url	762	const	1

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.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.01 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
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	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: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/helper/linkscollector.php:315
13	Weeblr\Forseo\Helper\Linkscollector->storeCollectedLinks()	JROOT/plugins/system/forseo/vendor/weeblr/forseo/controller/pagedatacollector.php:688
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]

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

Tables sélectionnées :

4 × SELECT * 
  FROM `xca3p_forseo_collected_urls`

4 × SELECT `departement` 
  FROM `xca3p_adssearch_ville`

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

2 × SELECT `departement_alias` 
  FROM `xca3p_adssearch_departement`

2 × SELECT `region` 
  FROM `xca3p_adssearch_ville`

2 × SELECT * 
  FROM `xca3p_forseo_pages`

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

2 × SELECT `region_alias` 
  FROM `xca3p_adssearch_departement`

1 × SELECT * 
  FROM `xca3p_forseo_excluded_urls`

1 × select `full_url` 
  from `xca3p_forseo_pages`

1 × SELECT `communetwo` 
  FROM `xca3p_adssearch_ville`

1 × SELECT *  
  FROM xca3p_jmap_canonicals

1 × SELECT *  
  FROM xca3p_jmap_metainfo

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 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_forseo_custom_meta`

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 `data` 
  FROM `xca3p_session`

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 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 `session_id` 
  FROM `xca3p_session`

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

1 × SELECT * 
  FROM xca3p_rsfirewall_exceptions

1 × SELECT * 
  FROM xca3p_rsfirewall_snapshots

1 × SELECT * 
  FROM xca3p_rsfirewall_hashes

1 × SELECT * 
  FROM `xca3p_forseo_rules`

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

1 × SELECT * 
  FROM xca3p_rsform_confi

1 × SELECT * 
  FROM xca3p_rsfirewall_configuratio

1 × SELECT `file` 
  FROM xca3p_rsfirewall_hashes

1 × SELECT `path` 
  FROM xca3p_rsfirewall_ignored

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 id, rules 
  FROM `xca3p_viewlevels

1 × SELECT `id` 
  FROM `xca3p_forseo_pages`

Autres tables :

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

1 × SHOW FULL COLUMNS 
  FROM `xca3p_rsfirewall_logs

1 × UPDATE `xca3p_extensions` 
  SET `params` = '{\"mediaversion\":\"336b4ba5ebba0442fd01511c9d902a12\"}'

1 × INSERT INTO `xca3p_forseo_collected_urls` (`id`, `crawled_by`, `crawl_started_at`, `crawl_timeout_at`, `status`, `target`, `url`, `full_url`, `referrers`, `click_depth`, `attempts`, `priority`) 
  VALUES (0, '', NULL, NULL, 0, 0, 'offre-sous-location?reg=82&dept=69&start=80', 'offre-sous-location?reg=82&dept=69&start=80', 'offre-sous-location?reg=82&dept=69&start=80', 0, 0, 0)

Offres de sous-location RHONE

Sous Location Lyon 8e dans Colocation

Sous location Lyon/Vénissieux Juillet septembre possibilité de prolonger

sous location T2 Villeurbanne Grandclement

location de chambre chez l'habitant

appart croix-rousse

Superbe appartement 35m2 Lyon,560€/mois tout compris !

Sous-location T1 25 m² Lyon

Lyon - Villeurbanne FLACHET

A sous-louer Lyon centre

Appartement sous location T2 Lyon3

Appartement 64m2 Lyon 9ème proche métro

Appartement, beau souplex, Perrache

Location T2 Lyon fetes des lumieres

Sous Location T2 Meublé- Lyon 2e (Jacobins)

Sous location T2 lyon

Echange Studio Lyon contre Paris 2-3-4mois

Location appartement centre lyon

sous-location charmant appartement Lyon 7ème- 17aout au 7 septembre

sous-location charmant appartement Lyon 7ï¿½me- 17aout au 7 septembre

T2 rénové Lyon/villeurbanne Juillet/Aout

Console de débogage Joomla!

Session

Profil d'information

Temps

Mémoire

Occupation de la mémoire

Requêtes de base de données

54 requêtes exécutées 279.26 ms

16 doubles découverts!

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

Tables sélectionnées :

Autres tables :