Demandes de sous location - Results from #520

Annonces de sous-location	Date
sous location dans une collocation à Montmartre Je cherche à sous-louer ma chambre durant les deux mois d'été (1er juillet au 31 aout - ou 15 septe ...	04-06-2010 par Vicks Vu 515 fois
cherche une location paris est bonjours, je recherche une sous location dés que possible, paris est, 11eme, 20eme, 10eme, 12eme, ou ...	03-06-2010 par kabyle Vu 593 fois
recherche sous location je recherche une sous location sur paris 18eme arrondissement ...	01-06-2010 par madila Vu 720 fois
SouLoc - 21/06 au 16/07 - Lyon Je m'appelle Sébastien et je suis en stage à Lyon du 21 juin au 16 jullet. Je cherche un hébergemen ...	01-06-2010 par diabetix Vu 578 fois
recherche Paris jeune couple recherche à sous louer un appartement sur Paris intramuros. (on est sympa et surtout tr ...	01-06-2010 par jotreza Vu 656 fois
Cherche sous loc longue durée Bonjour, Je suis à la recherche d'une sous location longue durée (1 an). J'ai 31 ans, je suis cél ...	31-05-2010 par alysong Vu 552 fois
recherche un petit studio ou appart sur Paris Bonjour ! Je recherche un petit studio ou un petit appart bien meublé et équipé sur Paris a partir d ...	25-05-2010 par Mistral Vu 743 fois
Sous location Bourg la Reine/Sceaux Bonjour, Consultante en entreprise recherche sous-location durée trois mois de juillet à Septembr ...	24-05-2010 par Vu 623 fois
Sous location appartement PARIS MONTPARNASSE BONNE AFFAIRE ! Situé à 30m de la Tour Montparnasse (métro ligne 4,6,12,13, Gare TGV, Bus) 1er ...	24-05-2010 par Vu 680 fois
recherche T2 bonjour,je recherche un T2 sur paris en urgence je le louerai a l'année si possible merci ...	23-05-2010 par awax2000@live.fr Vu 609 fois
Sous location appartement Paris Bonjour! Nous sommes deux suédoises qui sommes en France depuis juillet et septembre 2009. On es ...	22-05-2010 par Angelica Vu 655 fois
Cherche à Paris studio/T2 où poser ses valises de juin à août ou septembre 2010 Bonjour! Je recherche un T2 dans l'idéal, sinon un studio, dans Paris, plus particulièrement 8, 9 ...	21-05-2010 par Rashel Vu 633 fois
recherche un petit studio ou un appart Bonjour ! Je recherche un petit studio ou un petit appart bien meublé et équipé sur Paris a partir d ...	21-05-2010 par Mistral Vu 580 fois
recherche urgent bonjour,jeune couple trés sérieux recherche f2 ou f3 ...	21-05-2010 par awax2000@live.fr Vu 620 fois
Appartement de 60 m² environ au 6ème étage avec ascenseur Au 6eme étage et dernier étage avec ascenseur d'un immeuble en Pierre de taille, appartement de 60m² ...	20-05-2010 par roland Vu 617 fois
recherche soius location urgent !!! je recherche une sous location pour debut Juin C est urgent !!!! ...	19-05-2010 par TATA Vu 594 fois
Appartement de 20 m² environ au 3ème étage avec ascenseur 2 PIECES MEUBLE - ST MANDE. Dans imm. ancien, au 3eme avec asc., appartement de 2 pièces meublé comp ...	19-05-2010 par coka Vu 590 fois
Recherche un petit studio ou appart sur Paris Bonjour ! Je recherche un petit studio ou un petit appart bien meublé et équipé sur Paris a partir d ...	18-05-2010 par Mistral Vu 636 fois
recherche f2 ou f3 bonjour nous sommes un jeune couple actuellement sur paris nous cherchons f2 ou f3 a nous deux nous ...	18-05-2010 par awax2000@live.fr Vu 588 fois
cherche sous location appartement paris urgent bonjours a tous, je suis a la recherche d'une sous location pour a partir du mois de juin, serieuses ...	17-05-2010 par kabyle Vu 603 fois

Console de débogage Joomla!

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1714064928,
                "last": 1714064928,
                "now": 1714064928
            },
            "token": "uU1Au0mDfU4e7VSpX2EZz7YL7dXKmSE6"
        },
        "registry": {
            "com_adssearch": {
                "demandes": {
                    "ordercol": null,
                    "limitstart": 520
                }
            }
        },
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

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

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

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

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

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

Profil

Status	Duration
Starting	0.05 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 for update	0.02 ms
Update	0.09 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.05 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pile d'appels

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

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

Temps de requête : 0.34 ms Après la dernière requête : 1.74 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.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.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
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.41 ms Après la dernière requête : 0.09 ms Mémoire de requête : 0.021 MB mémoire avant requête : 1.173 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
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
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.40 ms Après la dernière requête : 3.24 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.03 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
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.02 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
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.30 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.021 MB mémoire avant requête : 1.516 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
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pile d'appels

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

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

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

SELECT *

  FROM xca3p_rsfirewall_configuration

Explication

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

Profil

Status	Duration
Starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.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
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pile d'appels

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

SHOW FULL COLUMNS 
  FROM `xca3p_rsfirewall_logs`

Explication

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

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
closing tables	0.01 ms
Opening tables	0.18 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.07 ms
closing tables	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
closing tables	0.01 ms
Removing tmp table	0.07 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pile d'appels

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

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

Temps de requête : 0.50 ms Après la dernière requête : 24.66 ms Mémoire de requête : 0.023 MB mémoire avant requête : 3.114 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.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.01 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
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Pile d'appels

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

Pile d'appels

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

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

Explication

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

Profil

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.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
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
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 : 54.88 ms Après la dernière requête : 3.05 ms Mémoire de requête : 64.036 MB mémoire avant requête : 4.236 MB Rangées retournées : 7992

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

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.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	53.61 ms
End of update loop	0.05 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.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.56 ms Après la dernière requête : 53.00 ms Mémoire de requête : 0.025 MB mémoire avant requête : 73.519 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.02 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pile d'appels

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

SELECT *

  FROM xca3p_rsfirewall_hashes

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

Explication

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

Profil

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

Pile d'appels

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

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

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

SELECT *

  FROM xca3p_rsfirewall_snapshots

  WHERE `type`='protect'

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
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.44 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.731 MB Rangées retournées : 0

SELECT `ip`,`reason`

  FROM xca3p_rsfirewall_lists

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

Pile d'appels

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

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

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

SELECT `ip`,`reason`

  FROM xca3p_rsfirewall_lists

  WHERE (`ip`='3.145.16.90' 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.04 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 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
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
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.30 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.743 MB Rangées retournées : 0

SELECT *

  FROM xca3p_rsfirewall_exceptions

  WHERE `published`='1'

Explication

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

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.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
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
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 : 1.19 ms Après la dernière requête : 3.73 ms Mémoire de requête : 0.028 MB mémoire avant requête : 4.840 MB Rangées retournées : 49

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

  FROM `xca3p_assets`

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

Explication

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

Profil

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

Pile d'appels

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

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

Temps de requête : 0.52 ms Après la dernière requête : 3.69 ms Mémoire de requête : 0.010 MB mémoire avant requête : 4.826 MB

UPDATE `xca3p_extensions`

  SET `params` = '{\"mediaversion\":\"2966de6b28f5e9498ff0602d943f9c03\"}'

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

Explication

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

Profil

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

Pile d'appels

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

Requêtes dupliquées: #53

SELECT * 
  FROM `xca3p_forseo_pages` 
  WHERE `url`='recherche-sous-locataire?reg=11&dept=75&ville=30787&start=520';

Explication

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

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.02 ms
Statistics	0.08 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.02 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 : 24.66 ms Après la dernière requête : 4.20 ms Mémoire de requête : 0.086 MB mémoire avant requête : 5.025 MB Rangées retournées : 1309

Requêtes dupliquées: #24

SELECT `region`

  FROM `xca3p_adssearch_ville`

  WHERE `reg` = 11

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.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	24.22 ms
End of update loop	0.05 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/components/com_adssearch/helpers/adssearch.php:693
16	AdssearchHelper::getVar()	JROOT/components/com_adssearch/models/demandes.php:91
15	AdssearchModelDemandes->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/demandes.php:139
12	AdssearchModelDemandes->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_adssearch/views/demandes/view.html.php:36
10	AdssearchViewDemandes->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 : 24.42 ms Après la dernière requête : 0.11 ms Mémoire de requête : 0.087 MB mémoire avant requête : 5.033 MB Rangées retournées : 1309

Requêtes dupliquées: #23

SELECT `region`

  FROM `xca3p_adssearch_ville`

  WHERE `reg` = 11

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	24.02 ms
End of update loop	0.05 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
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/demandes.php:91
15	AdssearchModelDemandes->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/demandes.php:139
12	AdssearchModelDemandes->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_adssearch/views/demandes/view.html.php:36
10	AdssearchViewDemandes->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 : 24.66 ms Après la dernière requête : 0.16 ms Mémoire de requête : 0.025 MB mémoire avant requête : 5.042 MB Rangées retournées : 21

Requêtes dupliquées: #26

SELECT `departement`

  FROM `xca3p_adssearch_ville`

  WHERE `dep` = 75

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/components/com_adssearch/helpers/adssearch.php:693
16	AdssearchHelper::getVar()	JROOT/components/com_adssearch/models/demandes.php:98
15	AdssearchModelDemandes->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/demandes.php:139
12	AdssearchModelDemandes->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_adssearch/views/demandes/view.html.php:36
10	AdssearchViewDemandes->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 : 24.09 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.025 MB mémoire avant requête : 5.050 MB Rangées retournées : 21

Requêtes dupliquées: #25

SELECT `departement`

  FROM `xca3p_adssearch_ville`

  WHERE `dep` = 75

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
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/demandes.php:98
15	AdssearchModelDemandes->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/demandes.php:139
12	AdssearchModelDemandes->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_adssearch/views/demandes/view.html.php:36
10	AdssearchViewDemandes->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.33 ms Après la dernière requête : 0.16 ms Mémoire de requête : 0.024 MB mémoire avant requête : 5.059 MB Rangées retournées : 1

Requêtes dupliquées: #28 #32 #33 #38 #39

SELECT `communetwo`

  FROM `xca3p_adssearch_ville`

  WHERE `id` = 30787

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xca3p_adssearch_ville	const	PRIMARY	PRIMARY	4	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.01 ms
Statistics	0.04 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
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/components/com_adssearch/helpers/adssearch.php:693
16	AdssearchHelper::getVar()	JROOT/components/com_adssearch/models/demandes.php:105
15	AdssearchModelDemandes->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/demandes.php:139
12	AdssearchModelDemandes->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_adssearch/views/demandes/view.html.php:36
10	AdssearchViewDemandes->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.27 ms Après la dernière requête : 0.04 ms Mémoire de requête : 0.024 MB mémoire avant requête : 5.067 MB Rangées retournées : 1

Requêtes dupliquées: #27 #32 #33 #38 #39

SELECT `communetwo`

  FROM `xca3p_adssearch_ville`

  WHERE `id` = 30787

Explication

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

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

Pile d'appels

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

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

Temps de requête : 22.22 ms Après la dernière requête : 0.13 ms Mémoire de requête : 0.024 MB mémoire avant requête : 5.083 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 = 'ILE DE FRANCE' 
  AND a.ad_dpartement = 'PARIS' 
  AND a.ad_city = 'PARIS' 
  AND c.catid = 2 
  AND a.published = 1

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	index	PRIMARY	PRIMARY	8	NULL	11141	Using where; Using index
1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	4	opzn1997_soulouercom.c.adid	1	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
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/demandes.php:139
12	AdssearchModelDemandes->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_adssearch/views/demandes/view.html.php:36
10	AdssearchViewDemandes->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 : 40.28 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.086 MB mémoire avant requête : 5.086 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 = 'ILE DE FRANCE' 
  AND a.ad_dpartement = 'PARIS' 
  AND a.ad_city = 'PARIS' 
  AND c.catid = 2 
  AND a.published = 1

  ORDER BY a.date_created DESC 
  LIMIT 520, 20

Explication

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

Profil

Status	Duration
Starting	0.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.06 ms
Optimizing	0.03 ms
Statistics	0.04 ms
Preparing	0.03 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.06 ms
Creating sort index	39.71 ms
End of update loop	0.05 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.04 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/demandes.php:139
12	AdssearchModelDemandes->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_adssearch/views/demandes/view.html.php:36
10	AdssearchViewDemandes->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.45 ms Après la dernière requête : 1.82 ms Mémoire de requête : 0.032 MB mémoire avant requête : 5.329 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.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
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	View32d694cb->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_adssearch/views/demandes/view.html.php:51
10	AdssearchViewDemandes->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_adssearch/controller.php:110
8	AdssearchController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_adssearch/adssearch.php:36
6	require_once JROOT/components/com_adssearch/adssearch.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.41 ms Après la dernière requête : 21.58 ms Mémoire de requête : 0.023 MB mémoire avant requête : 6.083 MB Rangées retournées : 1

Requêtes dupliquées: #27 #28 #33 #38 #39

SELECT `communetwo`

  FROM `xca3p_adssearch_ville`

  WHERE `id` = 30787

Explication

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

Profil

Status	Duration
Starting	0.04 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.01 ms
Statistics	0.04 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
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.02 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/components/com_adssearch/helpers/adssearch.php:693
15	AdssearchHelper::getVar()	JROOT/components/com_adssearch/views/demandes/tmpl/default.php:36
14	include JROOT/components/com_adssearch/views/demandes/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	View32d694cb->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_adssearch/views/demandes/view.html.php:51
10	AdssearchViewDemandes->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.29 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.097 MB Rangées retournées : 1

Requêtes dupliquées: #27 #28 #32 #38 #39

SELECT `communetwo`

  FROM `xca3p_adssearch_ville`

  WHERE `id` = 30787

Explication

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

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
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/demandes/tmpl/default.php:36
14	include JROOT/components/com_adssearch/views/demandes/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	View32d694cb->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_adssearch/views/demandes/view.html.php:51
10	AdssearchViewDemandes->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.07 ms Mémoire de requête : 0.024 MB mémoire avant requête : 6.106 MB Rangées retournées : 8

Requêtes dupliquées: #35

SELECT `region_alias`

  FROM `xca3p_adssearch_departement`

  WHERE `reg_code` = 11

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/components/com_adssearch/helpers/adssearch.php:693
15	AdssearchHelper::getVar()	JROOT/components/com_adssearch/views/demandes/tmpl/default.php:37
14	include JROOT/components/com_adssearch/views/demandes/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	View32d694cb->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_adssearch/views/demandes/view.html.php:51
10	AdssearchViewDemandes->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.33 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.114 MB Rangées retournées : 8

Requêtes dupliquées: #34

SELECT `region_alias`

  FROM `xca3p_adssearch_departement`

  WHERE `reg_code` = 11

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.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.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
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/demandes/tmpl/default.php:37
14	include JROOT/components/com_adssearch/views/demandes/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	View32d694cb->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_adssearch/views/demandes/view.html.php:51
10	AdssearchViewDemandes->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.32 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.023 MB mémoire avant requête : 6.123 MB Rangées retournées : 1

Requêtes dupliquées: #37

SELECT `departement_alias`

  FROM `xca3p_adssearch_departement`

  WHERE `dep_code` = 75

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/components/com_adssearch/helpers/adssearch.php:693
15	AdssearchHelper::getVar()	JROOT/components/com_adssearch/views/demandes/tmpl/default.php:38
14	include JROOT/components/com_adssearch/views/demandes/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	View32d694cb->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_adssearch/views/demandes/view.html.php:51
10	AdssearchViewDemandes->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.37 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.130 MB Rangées retournées : 1

Requêtes dupliquées: #36

SELECT `departement_alias`

  FROM `xca3p_adssearch_departement`

  WHERE `dep_code` = 75

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.02 ms
Opening tables	0.01 ms
After opening tables	0.02 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
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_adssearch/helpers/adssearch.php:696
15	AdssearchHelper::getVar()	JROOT/components/com_adssearch/views/demandes/tmpl/default.php:38
14	include JROOT/components/com_adssearch/views/demandes/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	View32d694cb->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_adssearch/views/demandes/view.html.php:51
10	AdssearchViewDemandes->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.27 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.139 MB Rangées retournées : 1

Requêtes dupliquées: #27 #28 #32 #33 #39

SELECT `communetwo`

  FROM `xca3p_adssearch_ville`

  WHERE `id` = 30787

Explication

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

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.03 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
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.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/demandes/tmpl/default.php:58
14	include JROOT/components/com_adssearch/views/demandes/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	View32d694cb->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_adssearch/views/demandes/view.html.php:51
10	AdssearchViewDemandes->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.26 ms Après la dernière requête : 0.03 ms Mémoire de requête : 0.024 MB mémoire avant requête : 6.146 MB Rangées retournées : 1

Requêtes dupliquées: #27 #28 #32 #33 #38

SELECT `communetwo`

  FROM `xca3p_adssearch_ville`

  WHERE `id` = 30787

Explication

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

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
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/demandes/tmpl/default.php:58
14	include JROOT/components/com_adssearch/views/demandes/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	View32d694cb->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_adssearch/views/demandes/view.html.php:51
10	AdssearchViewDemandes->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_adssearch/controller.php:110
8	AdssearchController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_adssearch/adssearch.php:36
6	require_once JROOT/components/com_adssearch/adssearch.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.10 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.025 MB mémoire avant requête : 6.156 MB Rangées retournées : 21

SELECT `codepostal`

  FROM `xca3p_adssearch_ville`

  WHERE `reg` = '11' 
  AND `dep` = '75' 
  AND `communetwo` = 'PARIS'

  ORDER BY codepostal

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xca3p_adssearch_ville	index_merge	idx_reg,idx_dep	idx_dep,idx_reg	32,32	NULL	1	Using intersect(idx_dep,idx_reg); Using where; Utilisation du tri complet de type filesort

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
16	JDatabaseDriver->loadColumn()	JROOT/components/com_adssearch/helpers/adssearch.php:143
15	AdssearchHelper::getZipcodes()	JROOT/components/com_adssearch/views/demandes/tmpl/default.php:66
14	include JROOT/components/com_adssearch/views/demandes/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	View32d694cb->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_adssearch/views/demandes/view.html.php:51
10	AdssearchViewDemandes->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 : 6.98 ms Après la dernière requête : 43.01 ms Mémoire de requête : 0.024 MB mémoire avant requête : 6.353 MB Rangées retournées : 1

SELECT * 
  FROM `xca3p_forseo_custom_meta` 
  WHERE `url`='recherche-sous-locataire?reg=11&dept=75&ville=30787&start=520';

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

Pile d'appels

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

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

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

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

  FROM xca3p_modules AS m

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

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

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

  ORDER BY m.position, m.ordering

Explication

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

Profil

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

Pile d'appels

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

SELECT *
 
  FROM xca3p_jmap_metainfo
 
  WHERE `linkurl` = 'https://www.souslouer.com/recherche-sous-locataire'
 
  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.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.04 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/plugins/system/jmap/jmap.php: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.28 ms Après la dernière requête : 0.04 ms Mémoire de requête : 0.022 MB mémoire avant requête : 7.299 MB Rangées retournées : 0

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

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

Pile d'appels

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

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

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

select `full_url` 
  from `xca3p_forseo_pages`  
  where  `content_id`='Itemid=291&dept=75&limitstart=520&option=com_adssearch&reg=11&start=520&view=demandes&ville=30787' 
  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.04 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.09 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pile d'appels

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

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

  FROM `xca3p_cookix_action` AS `a`

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

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

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/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.32 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.460 MB Rangées retournées : 1

SELECT `varname`,`varvalue`

  FROM `xca3p_cookix_var`

  WHERE `published` = 1

Explication

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

Profil

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

Pile d'appels

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

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

Explication

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

Profil

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

Pile d'appels

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

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

Temps de requête : 0.44 ms Après la dernière requête : 2.26 ms Mémoire de requête : 0.043 MB mémoire avant requête : 7.645 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.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.04 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
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pile d'appels

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

SELECT group_id 
  FROM xca3p_user_usergroup_map
                            
  WHERE user_id = 0

Explication

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

Profil

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

Pile d'appels

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

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

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

SELECT `id` 
  FROM `xca3p_forseo_pages` 
  WHERE `content_id`='Itemid=291&dept=75&limitstart=520&option=com_adssearch&reg=11&start=520&view=demandes&ville=30787' 
  AND `canonical_auto`=0 
  AND `url` != 'recherche-sous-locataire?reg=11&dept=75&ville=30787&start=520';

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.03 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.02 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.38 ms Après la dernière requête : 1.54 ms Mémoire de requête : 0.025 MB mémoire avant requête : 7.787 MB Rangées retournées : 0

Requêtes dupliquées: #54

SELECT * 
  FROM `xca3p_forseo_collected_urls` 
  WHERE `url`='recherche-sous-locataire?reg=11&dept=75&ville=30787&start=520';

Explication

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

Profil

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

Pile d'appels

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

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

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

Requêtes dupliquées: #22

SELECT * 
  FROM `xca3p_forseo_pages` 
  WHERE `url`='recherche-sous-locataire?reg=11&dept=75&ville=30787&start=520';

Explication

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

Profil

Status	Duration
Starting	0.02 ms
checking permissions	0.03 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.05 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
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Pile d'appels

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

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

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

Requêtes dupliquées: #52

SELECT * 
  FROM `xca3p_forseo_collected_urls` 
  WHERE `url`='recherche-sous-locataire?reg=11&dept=75&ville=30787&start=520';

Explication

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

Profil

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

Pile d'appels

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

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

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

SELECT * 
  FROM `xca3p_forseo_excluded_urls` 
  WHERE `url`='recherche-sous-locataire?reg=11&dept=75&ville=30787&start=520';

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

Pile d'appels

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

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

Temps de requête : 0.41 ms Après la dernière requête : 0.08 ms Mémoire de requête : 0.008 MB mémoire avant requête : 7.843 MB

INSERT INTO `xca3p_forseo_collected_urls` (`id`, `crawled_by`, `crawl_started_at`, `crawl_timeout_at`, `status`, `target`, `url`, `full_url`, `referrers`, `click_depth`, `attempts`, `priority`) 
  VALUES (0, '', NULL, NULL, 0, 0, 'recherche-sous-locataire?reg=11&dept=75&ville=30787&start=520', 'recherche-sous-locataire?reg=11&dept=75&ville=30787&start=520', 'recherche-sous-locataire?reg=11&dept=75&ville=30787&start=520', 0, 0, 0);

Explication

EXPLAIN impossible sur la requête : INSERT INTO `xca3p_forseo_collected_urls` (`id`, `crawled_by`, `crawl_started_at`, `crawl_timeout_at`, `status`, `target`, `url`, `full_url`, `referrers`, `click_depth`, `attempts`, `priority`) VALUES (0, '', NULL, NULL, 0, 0, 'recherche-sous-locataire?reg=11&dept=75&ville=30787&start=520', 'recherche-sous-locataire?reg=11&dept=75&ville=30787&start=520', 'recherche-sous-locataire?reg=11&dept=75&ville=30787&start=520', 0, 0, 0);

Profil

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

Pile d'appels

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

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

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

Tables sélectionnées :

6 × SELECT `communetwo` 
  FROM `xca3p_adssearch_ville`

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

2 × SELECT `departement` 
  FROM `xca3p_adssearch_ville`

2 × SELECT `region` 
  FROM `xca3p_adssearch_ville`

2 × SELECT * 
  FROM `xca3p_forseo_pages`

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

2 × SELECT `region_alias` 
  FROM `xca3p_adssearch_departement`

2 × SELECT `departement_alias` 
  FROM `xca3p_adssearch_departement`

2 × SELECT * 
  FROM `xca3p_forseo_collected_urls`

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_jmap_canonicals

1 × SELECT *  
  FROM xca3p_jmap_metainfo

1 × SELECT * 
  FROM xca3p_adsmanager_confi

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

1 × SELECT * 
  FROM `xca3p_forseo_custom_meta`

1 × SELECT group_id 
  FROM xca3p_user_usergroup_map

1 × SELECT `id` 
  FROM `xca3p_forseo_pages`

1 × SELECT `codepostal` 
  FROM `xca3p_adssearch_ville`

1 × select `full_url` 
  from `xca3p_forseo_pages`

1 × SELECT `data` 
  FROM `xca3p_session`

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

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

1 × SELECT * 
  FROM `xca3p_forseo_excluded_urls`

Autres tables :

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

1 × SHOW FULL COLUMNS 
  FROM `xca3p_rsfirewall_logs

1 × UPDATE `xca3p_extensions` 
  SET `params` = '{\"mediaversion\":\"2966de6b28f5e9498ff0602d943f9c03\"}'

1 × INSERT INTO `xca3p_forseo_collected_urls` (`id`, `crawled_by`, `crawl_started_at`, `crawl_timeout_at`, `status`, `target`, `url`, `full_url`, `referrers`, `click_depth`, `attempts`, `priority`) 
  VALUES (0, '', NULL, NULL, 0, 0, 'recherche-sous-locataire?reg=11&dept=75&ville=30787&start=520', 'recherche-sous-locataire?reg=11&dept=75&ville=30787&start=520', 'recherche-sous-locataire?reg=11&dept=75&ville=30787&start=520', 0, 0, 0)

Recherches de sous-location PARIS

sous location dans une collocation à Montmartre

cherche une location paris est

recherche sous location

SouLoc - 21/06 au 16/07 - Lyon

recherche Paris

Cherche sous loc longue durée

recherche un petit studio ou appart sur Paris

Sous location Bourg la Reine/Sceaux

Sous location appartement PARIS MONTPARNASSE

recherche T2

Sous location appartement Paris

Cherche à Paris studio/T2 où poser ses valises de juin à août ou septembre 2010

recherche un petit studio ou un appart

recherche urgent

Appartement de 60 m² environ au 6ème étage avec ascenseur

recherche soius location urgent !!!

Appartement de 20 m² environ au 3ème étage avec ascenseur

Recherche un petit studio ou appart sur Paris

recherche f2 ou f3

cherche sous location appartement paris urgent

Console de débogage Joomla!

Session

Profil d'information

Temps

Mémoire

Occupation de la mémoire

Requêtes de base de données

56 requêtes exécutées 242.69 ms

18 doubles découverts!

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

Tables sélectionnées :

Autres tables :