Annonces de sous-location - Results from #100

Annonces de sous-location	Date
T1 à Aubagne Bonjour, Je sous loue mon appartement situé dans le centre d'Aubagne, pour une durée de 1 à 2 mois ...	21-12-2010 par fonkfonkfonk Vu 1070 fois
3 pieces 66m² sur étage avec ascenseur , rue Auguste BLANQUI 3 pieces 66m² sur étage avec ascenseur , rue Auguste BLANQUI 13006 Marseille, elle est viable et ass ...	16-12-2010 par marionpp Vu 3112 fois
sous loc. T1 Cassis T1 29 m2 vue sur mer cuisine, frigo, plaques électriques, four. salle de bain, douche, lave-linge. ...	13-12-2010 par Maïté Vu 1008 fois
Appartement - Aix en Provence (Centre) 68 m2 Bonjour, Nous quittons notre appartement de janvier à mars 2011 et nous souhaitons le sous-louer ...	12-12-2010 par kevin.redureau Vu 1530 fois
colocation à marseille Offre de colocation à Marseille pour le mois de décembre ...	19-11-2010 par tof.g2 Vu 1058 fois
loft 110 m2, terrasse, Marseille centre, 30 nov-1er mars Bonjour, Nous partons 3 mois aux Etats-Unis pour nos projets artistiques et souhaitons pendant ce ...	14-11-2010 par melanieter Vu 1502 fois
cherche colocataire-trice 35OE/mois chambre meublée dans Appart 60 m2. Quartier Baille 13005.Cause départ a l'étranger pour 4 ...	01-11-2010 par joni Vu 1148 fois
marseille centre 55m² 550€ 4ème étage (très bel escalier à l'ancienne) cuisine donnant sur salon vaste salon avec demi-cloiso ...	18-10-2010 par rduret Vu 1377 fois
SOUS LOCATION T2 MARSEILLE BONJOUR JE SOUHAITE SOUS LOUER MON T2 TRES SYMPA AVEC UNE GRANDE TERRASSE SITUE DANS LE 5EME ARROND ...	29-09-2010 par DANCEFLOOR Vu 1353 fois
très beau t2 Endoume Marseille Sous loue Très beau T2 meublé à Endoume, quartier calme à 5 min de la plage des Catalans, 15 min à p ...	26-09-2010 par JANICK Vu 1509 fois
T1 Marseille a partir du 05/2O11 T1 a 5 min du centre ville a 5 min des plages idealement place Appartement refait neuf de 30 m2 c ...	26-09-2010 par Stone Vu 1240 fois
Sous location T2 bis Malmousque 13007 Bonjour ! Nous louons notre appartement marseillais T2 bis du 18 avril au 31 mai inclu. Il est situ ...	22-09-2010 par Camillou23 Vu 1281 fois
sous location t1 marseille Description: un studio type 1 de 40m2 propre équipé de télé plasma 107cm clic clac 2place 2 canapé d ...	14-09-2010 par makavelli Vu 1300 fois
studio avec grande terrasse MARSEILLE petit studio dans jardin fermé donnant sur un grande terrasse avec tonnelle et canapé d'exterieur. ...	13-09-2010 par ghis Vu 1354 fois
sous location T2 Marseille urgent Je sous-loue mon appartement - un T2 de 45m2 - pendant 2 semaines du 23/10/2010 au 06/11/2010 au p ...	28-08-2010 par Asia Vu 1266 fois
Sous-location à Marseille Je sous-loue mon appartement pour la période du16 au 22 août ainsi que pour les week-end tout au lon ...	09-08-2010 par camseille Vu 1045 fois
mois de septembre serieux et sociable ...	09-08-2010 par tarik103 Vu 1201 fois
URGENT T4 à Marseille pendant 10 à 12 mois Dû à une mutation professionnelle d’un an à l’étranger, je vous propose un appartementT4 de 81 m2 me ...	27-07-2010 par ysatis13 Vu 1455 fois
sous location T2 Marseille 07.08 au 29.08.2010 pour touriste uniquement Sous-loue appartement type 2 dans immeuble bourgeois début XXième app ...	26-07-2010 par jeff Vu 1083 fois
T2 MARSEILLE A SOUS LOUER Je propose de soulouer un t2 du 8 août au 21 août 10€ nuitée, 150€/semaine, 250€ les 2 semaines à En ...	21-07-2010 par loutreduloup Vu 1127 fois

Console de débogage Joomla!

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1778601975,
                "last": 1778601975,
                "now": 1778601975
            },
            "token": "rH2NxGAzXkXjDJwhD937QN7y6jfejjZa"
        },
        "registry": {
            "com_adssearch": {
                "offres": {
                    "ordercol": null,
                    "limitstart": 100
                }
            }
        },
        "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.08 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
Executing	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

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

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

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

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

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 for update	0.02 ms
Update	0.06 ms
Waiting for query cache lock	0.01 ms
Update	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.03 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
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.39 ms Après la dernière requête : 1.46 ms Mémoire de requête : 0.021 MB mémoire avant requête : 1.160 MB Rangées retournées : 5

SELECT id, rules

  FROM `xca3p_viewlevels`

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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.42 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.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.05 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pile d'appels

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

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

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

SELECT `path`

  FROM xca3p_rsfirewall_ignored

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

Explication

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

Profil

Status	Duration
Starting	0.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.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
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pile d'appels

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

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

Temps de requête : 0.32 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.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.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 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.39 ms Après la dernière requête : 0.03 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.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 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
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
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.69 ms Après la dernière requête : 1.88 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
checking permissions	0.01 ms
Opening tables	0.14 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
checking permissions	0.05 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Executing	0.02 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Removing tmp table	0.04 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pile d'appels

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

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

Temps de requête : 0.43 ms Après la dernière requête : 21.67 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.03 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.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
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.43 ms Après la dernière requête : 5.55 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.05 ms
After opening tables	0.01 ms
System lock	0.03 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.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
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.05 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.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.02 ms
Statistics	0.06 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
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 : 71.52 ms Après la dernière requête : 2.38 ms Mémoire de requête : 95.516 MB mémoire avant requête : 4.235 MB Rangées retournées : 11921

SELECT * 
  FROM `xca3p_forseo_rules` 
  WHERE `enabled` = 1 or (`enabled` = 2 
  and (`enabled_after` is null or `enabled_after` < '2026-05-12 16:06:15') 
  and (`enabled_until` is null or `enabled_until` > '2026-05-12 16:06:15')) 
  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	5963	Using where; Utilisation du tri complet de type filesort

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	69.64 ms
End of update loop	0.07 ms
Query end	0.01 ms
Commit	0.02 ms
Query end	0.01 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	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.63 ms Après la dernière requête : 95.72 ms Mémoire de requête : 0.025 MB mémoire avant requête : 107.736 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.10 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.09 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
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.46 ms Après la dernière requête : 16.65 ms Mémoire de requête : 0.020 MB mémoire avant requête : 4.656 MB Rangées retournées : 0

SELECT *

  FROM xca3p_rsfirewall_hashes

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

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/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.31 ms Après la dernière requête : 0.15 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.663 MB Rangées retournées : 0

SELECT *

  FROM xca3p_rsfirewall_snapshots

  WHERE `type`='protect'

Explication

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

Profil

Status	Duration
Starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.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.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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.42 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.022 MB mémoire avant requête : 4.733 MB Rangées retournées : 0

SELECT `ip`,`reason`

  FROM xca3p_rsfirewall_lists

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

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:165
10	plgSystemRsfirewall->isListed()	JROOT/plugins/system/rsfirewall/rsfirewall.php:144
9	plgSystemRsfirewall->isWhitelisted()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1108
8	plgSystemRsfirewall->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT `ip`,`reason`

  FROM xca3p_rsfirewall_lists

  WHERE (`ip`='216.73.216.130' 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.01 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
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:165
10	plgSystemRsfirewall->isListed()	JROOT/plugins/system/rsfirewall/rsfirewall.php:134
9	plgSystemRsfirewall->isBlacklisted()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1112
8	plgSystemRsfirewall->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT *

  FROM xca3p_rsfirewall_exceptions

  WHERE `published`='1'

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:700
9	plgSystemRsfirewall->isException()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1243
8	plgSystemRsfirewall->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.82 ms Après la dernière requête : 3.30 ms Mémoire de requête : 0.028 MB mémoire avant requête : 4.843 MB Rangées retournées : 49

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

  FROM `xca3p_assets`

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

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
15	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
14	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
13	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
12	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
11	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/advancedmodules/src/Document.php:30
10	RegularLabs\Plugin\System\AdvancedModules\Document::loadFrontEditScript()	JROOT/plugins/system/advancedmodules/advancedmodules.php:95
9	PlgSystemAdvancedModules->handleOnAfterRoute()	JROOT/libraries/regularlabs/src/SystemPlugin.php:191
8	RegularLabs\Library\SystemPlugin->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.59 ms Après la dernière requête : 3.25 ms Mémoire de requête : 0.010 MB mémoire avant requête : 4.828 MB

UPDATE `xca3p_extensions`

  SET `params` = '{\"mediaversion\":\"62bd2a7d7ae747a58f888ea9169db1a8\"}'

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

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
21	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
20	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
19	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
18	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
17	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/platform/joomla/platform.php:1741
16	Weeblr\Wblib\Forseo\Platform\JoomlaPlatform->isDocumentType()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/platform/joomla/platform.php:1717
15	Weeblr\Wblib\Forseo\Platform\JoomlaPlatform->isHtmlPage()	JROOT/plugins/system/forseo/vendor/weeblr/forseo/controller/pagedatacollector.php:1158
14	Weeblr\Forseo\Controller\Pagedatacollector->canRun()	JROOT/plugins/system/forseo/vendor/weeblr/forseo/controller/pagedatacollector.php:157
13	Weeblr\Forseo\Controller\Pagedatacollector->onAfterRoute()	Même appel que celui de la ligne ci-dessous.
12	call_user_func_array()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/platform/joomla/platform.php:1915
11	Weeblr\Wblib\Forseo\Platform\JoomlaPlatform->executeHook()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/system/hook.php:173
10	Weeblr\Wblib\Forseo\System\Hook->execute()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/system/hook.php:116
9	Weeblr\Wblib\Forseo\System\Hook->run()	JROOT/plugins/system/forseo/forseo.php:225
8	plgSystemForseo->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM `xca3p_forseo_pages` 
  WHERE `url`='offre-sous-location?dept=13&reg=93&start=100';

Explication

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

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.01 ms
Executing	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.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/controller/pagedatacollector.php:170
13	Weeblr\Forseo\Controller\Pagedatacollector->onAfterRoute()	Même appel que celui de la ligne ci-dessous.
12	call_user_func_array()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/platform/joomla/platform.php:1915
11	Weeblr\Wblib\Forseo\Platform\JoomlaPlatform->executeHook()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/system/hook.php:173
10	Weeblr\Wblib\Forseo\System\Hook->execute()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/system/hook.php:116
9	Weeblr\Wblib\Forseo\System\Hook->run()	JROOT/plugins/system/forseo/forseo.php:225
8	plgSystemForseo->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 18.90 ms Après la dernière requête : 3.71 ms Mémoire de requête : 0.086 MB mémoire avant requête : 5.018 MB Rangées retournées : 1003

Requêtes dupliquées: #24

SELECT `region`

  FROM `xca3p_adssearch_ville`

  WHERE `reg` = 93

Explication

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

Profil

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

Pile d'appels

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

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

Temps de requête : 17.20 ms Après la dernière requête : 0.05 ms Mémoire de requête : 0.087 MB mémoire avant requête : 5.026 MB Rangées retournées : 1003

Requêtes dupliquées: #23

SELECT `region`

  FROM `xca3p_adssearch_ville`

  WHERE `reg` = 93

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.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	16.80 ms
End of update loop	0.02 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pile d'appels

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

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

Temps de requête : 17.78 ms Après la dernière requête : 0.11 ms Mémoire de requête : 0.029 MB mémoire avant requête : 5.035 MB Rangées retournées : 145

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

SELECT `departement`

  FROM `xca3p_adssearch_ville`

  WHERE `dep` = 13

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.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	17.37 ms
End of update loop	0.02 ms
Query end	0.01 ms
closing tables	0.03 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.03 ms

Pile d'appels

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

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

Temps de requête : 17.24 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.029 MB mémoire avant requête : 5.043 MB Rangées retournées : 145

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

SELECT `departement`

  FROM `xca3p_adssearch_ville`

  WHERE `dep` = 13

Explication

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

Profil

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

Pile d'appels

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

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

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

SELECT COUNT(*)

  FROM `xca3p_adsmanager_ads` AS `a`

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

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

  WHERE a.ad_region = 'PROVENCE ALPES COTE D\'AZUR' 
  AND a.ad_dpartement = 'BOUCHES DU RHONE' 
  AND c.catid = 1 
  AND a.published = 1

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
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 : 14.17 ms Après la dernière requête : 0.10 ms Mémoire de requête : 0.086 MB mémoire avant requête : 5.062 MB Rangées retournées : 20

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

  FROM `xca3p_adsmanager_ads` AS `a`

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

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

  WHERE a.ad_region = 'PROVENCE ALPES COTE D\'AZUR' 
  AND a.ad_dpartement = 'BOUCHES DU RHONE' 
  AND c.catid = 1 
  AND a.published = 1

  ORDER BY a.date_created DESC 
  LIMIT 100, 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	13458	Using where; Utilisation du tri complet de type filesort
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	8	opzn1997_soulouercom.a.id,const	1
1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	opzn1997_soulouercom.a.userid	1	Using where

Profil

Status	Duration
Starting	0.07 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.08 ms
Optimizing	0.04 ms
Statistics	0.04 ms
Preparing	0.03 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.04 ms
Creating sort index	13.58 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/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.53 ms Mémoire de requête : 0.032 MB mémoire avant requête : 5.308 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.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.06 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.03 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.03 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
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.48 ms Après la dernière requête : 17.45 ms Mémoire de requête : 0.023 MB mémoire avant requête : 6.068 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.06 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.06 ms
Starting cleanup	0.01 ms
Freeing items	0.03 ms
Updating status	0.03 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: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.34 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.023 MB mémoire avant requête : 6.076 MB Rangées retournées : 6

Requêtes dupliquées: #32

SELECT `region_alias`

  FROM `xca3p_adssearch_departement`

  WHERE `reg_code` = 93

Explication

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

Profil

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

Pile d'appels

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

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

Temps de requête : 0.31 ms Après la dernière requête : 0.04 ms Mémoire de requête : 0.024 MB mémoire avant requête : 6.083 MB Rangées retournées : 6

Requêtes dupliquées: #31

SELECT `region_alias`

  FROM `xca3p_adssearch_departement`

  WHERE `reg_code` = 93

Explication

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

Profil

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

Pile d'appels

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

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

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

Requêtes dupliquées: #34

SELECT `departement_alias`

  FROM `xca3p_adssearch_departement`

  WHERE `dep_code` = 13

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
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.30 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.108 MB Rangées retournées : 1

Requêtes dupliquées: #33

SELECT `departement_alias`

  FROM `xca3p_adssearch_departement`

  WHERE `dep_code` = 13

Explication

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

Profil

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

Pile d'appels

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

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

Temps de requête : 18.27 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.028 MB mémoire avant requête : 6.116 MB Rangées retournées : 145

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

SELECT `departement`

  FROM `xca3p_adssearch_ville`

  WHERE `dep` = 13

Explication

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

Profil

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

Pile d'appels

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

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

Temps de requête : 17.21 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.029 MB mémoire avant requête : 6.124 MB Rangées retournées : 145

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

SELECT `departement`

  FROM `xca3p_adssearch_ville`

  WHERE `dep` = 13

Explication

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

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	16.86 ms
End of update loop	0.02 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.03 ms
Updating status	0.02 ms
Reset for next command	0.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:75
14	include JROOT/components/com_adssearch/views/offres/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla/src/ViewTrait.php:26
12	View3aeb4553->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_adssearch/views/offres/view.html.php:51
10	AdssearchViewOffres->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_adssearch/controller.php:110
8	AdssearchController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_adssearch/adssearch.php:36
6	require_once JROOT/components/com_adssearch/adssearch.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM `xca3p_forseo_custom_meta` 
  WHERE `url`='offre-sous-location?dept=13&reg=93&start=100';

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.10 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.03 ms
table lock	0.03 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.09 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.03 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
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 : 1.12 ms Après la dernière requête : 1.47 ms Mémoire de requête : 0.085 MB mémoire avant requête : 6.354 MB Rangées retournées : 18

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

  FROM xca3p_modules AS m

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

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

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

  ORDER BY m.position, m.ordering

Explication

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

Profil

Status	Duration
Starting	0.11 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.05 ms
Optimizing	0.06 ms
Statistics	0.10 ms
Preparing	0.05 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.48 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
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.69 ms Après la dernière requête : 737.98 ms Mémoire de requête : 0.022 MB mémoire avant requête : 7.251 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.11 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.06 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.03 ms
closing tables	0.01 ms
Query end	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.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.43 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.257 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.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.02 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.03 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
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.69 ms Après la dernière requête : 0.90 ms Mémoire de requête : 0.025 MB mémoire avant requête : 7.277 MB Rangées retournées : 1

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

Explication

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

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.05 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.06 ms
Preparing	0.06 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.12 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.02 ms
Unlocking tables	0.03 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pile d'appels

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

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

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

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

  FROM `xca3p_cookix_action` AS `a`

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

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

Explication

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

Profil

Status	Duration
Starting	0.06 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.07 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.03 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
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.44 ms Après la dernière requête : 0.08 ms Mémoire de requête : 0.020 MB mémoire avant requête : 7.412 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.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.04 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.03 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
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.39 ms Après la dernière requête : 1.95 ms Mémoire de requête : 0.020 MB mémoire avant requête : 7.414 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.04 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.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
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.61 ms Après la dernière requête : 2.28 ms Mémoire de requête : 0.043 MB mémoire avant requête : 7.593 MB Rangées retournées : 1

SELECT * 
  FROM xca3p_adsmanager_config

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
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.44 ms Après la dernière requête : 0.09 ms Mémoire de requête : 0.025 MB mémoire avant requête : 7.625 MB Rangées retournées : 0

SELECT group_id 
  FROM xca3p_user_usergroup_map
                            
  WHERE user_id = 0

Explication

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

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.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.02 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
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.48 ms Après la dernière requête : 14.97 ms Mémoire de requête : 0.024 MB mémoire avant requête : 7.710 MB Rangées retournées : 1

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

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.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.03 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
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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.53 ms Après la dernière requête : 0.16 ms Mémoire de requête : 0.026 MB mémoire avant requête : 7.719 MB Rangées retournées : 1

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

Explication

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

Profil

Status	Duration
Starting	0.04 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.02 ms
Statistics	0.07 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Pile d'appels

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

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

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

SELECT * 
  FROM `xca3p_forseo_errors` 
  WHERE `url`='offre-sous-location?dept=13&reg=93&start=100';

Explication

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

Profil

Status	Duration
Starting	0.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.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.03 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 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/controller/pagedatacollector.php:950
14	Weeblr\Forseo\Controller\Pagedatacollector->forceRecrawlIfExisting()	JROOT/plugins/system/forseo/vendor/weeblr/forseo/controller/pagedatacollector.php:819
13	Weeblr\Forseo\Controller\Pagedatacollector->storeUnknownIncomingRequests()	JROOT/plugins/system/forseo/vendor/weeblr/forseo/controller/pagedatacollector.php:698
12	Weeblr\Forseo\Controller\Pagedatacollector->onAfterRenderComplete()	Même appel que celui de la ligne ci-dessous.
11	call_user_func_array()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/platform/joomla/platform.php:1915
10	Weeblr\Wblib\Forseo\Platform\JoomlaPlatform->executeHook()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/system/hook.php:173
9	Weeblr\Wblib\Forseo\System\Hook->execute()	JROOT/plugins/system/forseo/vendor/weeblr/wblib/v2/packages/system/hook.php:116
8	Weeblr\Wblib\Forseo\System\Hook->run()	JROOT/plugins/system/forseo/forseo.php:568
7	plgSystemForseo->doOnAfterRenderComplete()	JROOT/plugins/system/forseo/forseo.php:410
6	plgSystemForseo->{closure}()	JROOT/libraries/joomla/event/dispatcher.php:165
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM `xca3p_forseo_links` 
  WHERE `url`='offre-sous-location?dept=13&reg=93&start=100';

Explication

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

Profil

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

Pile d'appels

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

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

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

Tables sélectionnées :

4 × SELECT `departement` 
  FROM `xca3p_adssearch_ville`

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

2 × SELECT `region_alias` 
  FROM `xca3p_adssearch_departement`

2 × SELECT `region` 
  FROM `xca3p_adssearch_ville`

2 × SELECT `departement_alias` 
  FROM `xca3p_adssearch_departement`

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

1 × SELECT *  
  FROM xca3p_jmap_canonicals

1 × SELECT * 
  FROM `xca3p_forseo_custom_meta`

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

1 × SELECT *  
  FROM xca3p_jmap_metainfo

1 × SELECT `data` 
  FROM `xca3p_session`

1 × SELECT `communetwo` 
  FROM `xca3p_adssearch_ville`

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

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

1 × SELECT *  
  FROM xca3p_jmap_headings

1 × SELECT * 
  FROM xca3p_adsmanager_confi

1 × SELECT group_id 
  FROM xca3p_user_usergroup_map

1 × SELECT `id` 
  FROM `xca3p_forseo_pages`

1 × SELECT * 
  FROM `xca3p_forseo_errors`

1 × select `full_url` 
  from `xca3p_forseo_pages`

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

1 × SELECT custom_data 
  FROM xca3p_extensions

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

1 × SELECT id, rules 
  FROM `xca3p_viewlevels

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

1 × SELECT `path` 
  FROM xca3p_rsfirewall_ignored

1 × SELECT `file` 
  FROM xca3p_rsfirewall_hashes

1 × SELECT * 
  FROM xca3p_rsfirewall_configuratio

1 × SELECT * 
  FROM xca3p_rsform_confi

1 × SELECT * 
  FROM `xca3p_forseo_rules`

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

1 × SELECT * 
  FROM xca3p_rsfirewall_hashes

1 × SELECT * 
  FROM xca3p_rsfirewall_snapshots

1 × SELECT * 
  FROM xca3p_rsfirewall_exceptions

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

1 × SELECT * 
  FROM `xca3p_forseo_pages`

1 × SELECT `session_id` 
  FROM `xca3p_session`

1 × SELECT * 
  FROM `xca3p_forseo_links`

Autres tables :

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

1 × SHOW FULL COLUMNS 
  FROM `xca3p_rsfirewall_logs

1 × UPDATE `xca3p_extensions` 
  SET `params` = '{\"mediaversion\":\"62bd2a7d7ae747a58f888ea9169db1a8\"}'

Offres de sous-location BOUCHES DU RHONE

T1 à Aubagne

3 pieces 66m² sur étage avec ascenseur , rue Auguste BLANQUI

sous loc. T1 Cassis

Appartement - Aix en Provence (Centre) 68 m2

colocation à marseille

loft 110 m2, terrasse, Marseille centre, 30 nov-1er mars

cherche colocataire-trice

marseille centre 55m² 550€

SOUS LOCATION T2 MARSEILLE

très beau t2 Endoume Marseille

T1 Marseille a partir du 05/2O11

Sous location T2 bis Malmousque 13007

sous location t1 marseille

studio avec grande terrasse MARSEILLE

sous location T2 Marseille urgent

Sous-location à Marseille

mois de septembre

URGENT T4 à Marseille pendant 10 à 12 mois

sous location T2 Marseille 07.08 au 29.08.2010

T2 MARSEILLE A SOUS LOUER

Console de débogage Joomla!

Session

Profil d'information

Temps

Mémoire

Occupation de la mémoire

Requêtes de base de données

50 requêtes exécutées 227.67 ms

10 doubles découverts!

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

Tables sélectionnées :

Autres tables :