Annonces de sous-location

Annonces de sous-location	Date
Appartement, 1 Pièces, 20 m² Bel appartement duplex en bon état au 2ème étage d'un immeuble bien situé, Cet appartement comprend ...	22-11-2022 par rayon1 Vu 59 fois
Studio à partager avec touristes Agréable studio neuf à partager avec moi. Il est composé d’une belle cuisine d’un espace nuit ouvert ...	09-07-2022 par Dudu92 Vu 95 fois
Sous location PANTIN (93) JUILLET - AOÛT PANTIN (93) / Limitrophe PARIS 19 (LA VILLETTE)) JUILLET - AOÛT Bonjour ! Mon logement est dis ...	17-06-2022 par Harisandevi Vu 89 fois
Sous location appartement Pantin Appartement meublé, 48 m2, très bon état, à 2 mn du métro Eglise de Pantin, 3ème étage, calme et lum ...	15-10-2016 par Vu 2197 fois
grand studio sur le canal de l'ourq bonjour je sous loue mon studio de 36m2 situé sur le canal de l'OURQ a cinq mn de la gare RER de p ...	18-06-2016 par etienneetmarie Vu 4276 fois
Sous-location Chambre Paris-Pantin Salut à tous, je sous-loue ma chambre du 19 mai au 21 juin dans ma colocation à Pantin dans un bel a ...	30-04-2016 par Epocaa Vu 1108 fois
Appartement T2 métro Eglise de Pantin Je sous-loue mon deux pièces de 30 m2 pendant un déplacement professionnel du mardi 12/04 au samedi ...	10-04-2016 par Numuke Vu 1160 fois
T2 Porte de Paris / Proche canal et Parc de la Villette ! Aux portes de Paris (Métro Hoche à Pantin, ligne 5), je vous propose un appartement de deux pièces a ...	02-09-2015 par lasflotchup Vu 1877 fois
LOFT DUPLEX DUPLEX meublé DE 100m2 env. 3 chambres , terrasse. 10' du métro Eglise Pantin. Dans petite co-pro ...	29-01-2015 par sanchoo Vu 2154 fois
Sous-loc appart Paris juillet et/ou août, souplesse sur date d'arrivée et de sortie! Bonjour! Je sous-loue ma chambre meublée à Paris, pour 2 semaines minimum, ou 3 semaines, ou 1 ...	17-06-2014 par LaurenceCools Vu 2765 fois
"Une Chambre meublé" - 400€ A 5 minutes à pied de la station "Raymond Quenau Bobigny" à 15 minutes en transport de la station "g ...	21-04-2014 par ouriyah Vu 1654 fois
2 pièces au bord du canal de l'Ourcq Nous sous-louons notre charmant deux pièces de 41m2 au bord du canal de l'Ourcq à Pantin dans une ré ...	26-02-2014 par lilas1302 Vu 1845 fois
sous-location chambre Paris 450e/mois Bonjour je sous-loue ma chambre dans une colocation à deux. Ma colocataire s'appelle Laurence, elle ...	19-06-2013 par noemiecalo Vu 1351 fois
JUILLET AOUT PANTIN Sous-Loue appartement de 40m² à Pantin Proximité métro (ligne 5 station église de Pantin) et 19°arr ...	13-06-2013 par souslocpantin2013 Vu 1194 fois
Loue Grand Studio Métro Eglise Pantin Location saisonnière (juillet-août) grand studio 25 m2, mezzanine, clair, proche tous commerces, mét ...	14-05-2013 par nathaliejalo Vu 1120 fois
850€ - Collocation Pte de la Villette - dispo février/mi-avril L\'appart fait 115 m2, il a un jardin, 1 salon, une mezzanine (salle télé), une cuisine, 2 sdb et 3 ...	31-01-2013 par karinhello Vu 1342 fois
Beau F2 47 m2 PANTIN 850 €/mois F2 47m2 clair, calme, en bon état avec garage (box fermé). Situation : 50m du m° Raymond Queneau lig ...	03-09-2012 par sabbatik Vu 1280 fois
Location F3 (2 chambres) Pantin Août-Octobre 2013 A 2 min de Paris, proximité ts transports (METRO Eglise de Pantin (Gare du Nord, Gare de l'Est, Répu ...	09-05-2012 par Birma Vu 1008 fois
2 pièces proche Paris; Durée:5 à 6 mois Mon appartement se situe à Pantin, à 500m de Paris, entre le métro Hoche et le RER E station Pantin. ...	11-03-2012 par Lili Bellule Vu 1445 fois
Sous loc appartement au mois ou pour plusieurs mois Bonjour, Nous cherchons qqun pour remplacer notre troisième coloc qui vient de partir. L'apparte ...	26-07-2011 par Matthieu935 Vu 1468 fois

Console de débogage Joomla!

Session

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

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'3635306230626434353662383835346631316266666633623036343062376661', 1, 1714150497, 0, '', 0)

Profil

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

Pile d'appels

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

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

Temps de requête : 0.36 ms Après la dernière requête : 1.69 ms Mémoire de requête : 0.021 MB mémoire avant requête : 1.159 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.01 ms
Optimizing	0.01 ms
Statistics	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
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.44 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.021 MB mémoire avant requête : 1.171 MB Rangées retournées : 2

SELECT b.id

  FROM xca3p_usergroups AS a

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

  WHERE a.id = 11

Explication

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

Profil

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.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.41 ms Après la dernière requête : 3.04 ms Mémoire de requête : 0.021 MB mémoire avant requête : 1.508 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.06 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	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.02 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pile d'appels

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
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.76 ms Après la dernière requête : 1.95 ms Mémoire de requête : 0.025 MB mémoire avant requête : 1.765 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.08 ms
closing tables	0.01 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Removing tmp table	0.08 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
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.41 ms Après la dernière requête : 22.51 ms Mémoire de requête : 0.023 MB mémoire avant requête : 3.111 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.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.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.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.06 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.44 ms Après la dernière requête : 6.01 ms Mémoire de requête : 0.031 MB mémoire avant requête : 3.478 MB Rangées retournées : 4

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

Explication

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

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.02 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.02 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
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.46 ms Après la dernière requête : 5.65 ms Mémoire de requête : 0.027 MB mémoire avant requête : 3.968 MB Rangées retournées : 1

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

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
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 : 52.64 ms Après la dernière requête : 2.55 ms Mémoire de requête : 64.067 MB mémoire avant requête : 4.234 MB Rangées retournées : 7996

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

Profil

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.02 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
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	51.31 ms
End of update loop	0.06 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.02 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.74 ms Après la dernière requête : 49.33 ms Mémoire de requête : 0.025 MB mémoire avant requête : 73.551 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.16 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.07 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.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
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.53 ms Après la dernière requête : 12.63 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.652 MB Rangées retournées : 8

Requêtes dupliquées: #16

SELECT `reg_code`

  FROM `xca3p_adssearch_departement`

  WHERE `region_alias` = 'ILE_DE_FRANCE'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xca3p_adssearch_departement	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	104	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.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.11 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.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
11	JDatabaseDriverMysqli->execute()	JROOT/components/com_adssearch/helpers/adssearch.php:693
10	AdssearchHelper::getVar()	JROOT/components/com_adssearch/router.php:145
9	AdssearchRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
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.38 ms Après la dernière requête : 0.05 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.658 MB Rangées retournées : 8

Requêtes dupliquées: #15

SELECT `reg_code`

  FROM `xca3p_adssearch_departement`

  WHERE `region_alias` = 'ILE_DE_FRANCE'

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/components/com_adssearch/helpers/adssearch.php:696
10	AdssearchHelper::getVar()	JROOT/components/com_adssearch/router.php:145
9	AdssearchRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
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.30 ms Après la dernière requête : 0.08 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.665 MB Rangées retournées : 1

Requêtes dupliquées: #18

SELECT `dep_code`

  FROM `xca3p_adssearch_departement`

  WHERE `departement_alias` = 'SEINE_SAINT_DENIS'

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/components/com_adssearch/helpers/adssearch.php:693
10	AdssearchHelper::getVar()	JROOT/components/com_adssearch/router.php:146
9	AdssearchRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
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.03 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.671 MB Rangées retournées : 1

Requêtes dupliquées: #17

SELECT `dep_code`

  FROM `xca3p_adssearch_departement`

  WHERE `departement_alias` = 'SEINE_SAINT_DENIS'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xca3p_adssearch_departement	ALL	NULL	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.01 ms
Preparing	0.02 ms
Executing	0.02 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:1740
11	JDatabaseDriver->loadResult()	JROOT/components/com_adssearch/helpers/adssearch.php:696
10	AdssearchHelper::getVar()	JROOT/components/com_adssearch/router.php:146
9	AdssearchRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
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.24 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.676 MB Rangées retournées : 1

SELECT id

  FROM xca3p_adssearch_ville

  WHERE `ville_alias` = 'PANTIN' 
  AND `reg` = '11' 
  AND `dep` = '93'

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

Profil

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.03 ms
Statistics	0.13 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.81 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.01 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/components/com_adssearch/router.php:240
10	AdssearchRouter::getVille()	JROOT/components/com_adssearch/router.php:147
9	AdssearchRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.42 ms Après la dernière requête : 0.15 ms Mémoire de requête : 0.020 MB mémoire avant requête : 4.681 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.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.02 ms
Preparing	0.02 ms
Executing	0.03 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.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

Pile d'appels

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

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

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

SELECT *

  FROM xca3p_rsfirewall_snapshots

  WHERE `type`='protect'

Explication

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

Profil

Status	Duration
Starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.03 ms
Optimizing	0.02 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.01 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.39 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.757 MB Rangées retournées : 0

SELECT `ip`,`reason`

  FROM xca3p_rsfirewall_lists

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

Explication

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

Profil

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

Pile d'appels

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

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

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

SELECT `ip`,`reason`

  FROM xca3p_rsfirewall_lists

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

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
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.35 ms Après la dernière requête : 0.35 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.768 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.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
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 : 0.88 ms Après la dernière requête : 3.53 ms Mémoire de requête : 0.028 MB mémoire avant requête : 4.865 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.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.12 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.35 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.03 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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.50 ms Après la dernière requête : 3.59 ms Mémoire de requête : 0.010 MB mémoire avant requête : 4.870 MB

UPDATE `xca3p_extensions`

  SET `params` = '{\"mediaversion\":\"85cdb18a8cc152d97fb5ea831136122b\"}'

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

Explication

EXPLAIN impossible sur la requête : UPDATE `xca3p_extensions` SET `params` = '{\"mediaversion\":\"85cdb18a8cc152d97fb5ea831136122b\"}' 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.01 ms
init for update	0.10 ms
Updating	0.08 ms
End of update loop	0.01 ms
Query end	0.02 ms
Commit	0.04 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
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.43 ms Après la dernière requête : 0.40 ms Mémoire de requête : 0.025 MB mémoire avant requête : 4.954 MB Rangées retournées : 0

SELECT * 
  FROM `xca3p_forseo_pages` 
  WHERE `url`='offre-sous-location/ILE_DE_FRANCE/SEINE_SAINT_DENIS/PANTIN/';

Explication

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

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.01 ms
Executing	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.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.19 ms Après la dernière requête : 3.82 ms Mémoire de requête : 0.086 MB mémoire avant requête : 5.040 MB Rangées retournées : 1309

Requêtes dupliquées: #29

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

Pile d'appels

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

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

Temps de requête : 23.07 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.087 MB mémoire avant requête : 5.048 MB Rangées retournées : 1309

Requêtes dupliquées: #28

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

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

Temps de requête : 22.03 ms Après la dernière requête : 0.08 ms Mémoire de requête : 0.025 MB mémoire avant requête : 5.058 MB Rangées retournées : 41

Requêtes dupliquées: #31

SELECT `departement`

  FROM `xca3p_adssearch_ville`

  WHERE `dep` = 93

Explication

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

Profil

Status	Duration
Starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	21.73 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/offres.php:98
15	AdssearchModelOffres->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:140
14	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:194
13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_adssearch/models/offres.php:139
12	AdssearchModelOffres->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_adssearch/views/offres/view.html.php:36
10	AdssearchViewOffres->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_adssearch/controller.php:110
8	AdssearchController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_adssearch/adssearch.php:36
6	require_once JROOT/components/com_adssearch/adssearch.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 22.29 ms Après la dernière requête : 0.05 ms Mémoire de requête : 0.026 MB mémoire avant requête : 5.066 MB Rangées retournées : 41

Requêtes dupliquées: #30

SELECT `departement`

  FROM `xca3p_adssearch_ville`

  WHERE `dep` = 93

Explication

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

Profil

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	21.95 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.03 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
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/components/com_adssearch/helpers/adssearch.php:696
16	AdssearchHelper::getVar()	JROOT/components/com_adssearch/models/offres.php:98
15	AdssearchModelOffres->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:140
14	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:194
13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_adssearch/models/offres.php:139
12	AdssearchModelOffres->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_adssearch/views/offres/view.html.php:36
10	AdssearchViewOffres->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_adssearch/controller.php:110
8	AdssearchController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_adssearch/adssearch.php:36
6	require_once JROOT/components/com_adssearch/adssearch.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #33 #37 #38 #43 #44

SELECT `communetwo`

  FROM `xca3p_adssearch_ville`

  WHERE `id` = 36310

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

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

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

Requêtes dupliquées: #32 #37 #38 #43 #44

SELECT `communetwo`

  FROM `xca3p_adssearch_ville`

  WHERE `id` = 36310

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.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.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.01 ms
Reset for next command	0.01 ms

Pile d'appels

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

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

Temps de requête : 16.45 ms Après la dernière requête : 0.09 ms Mémoire de requête : 0.102 MB mémoire avant requête : 5.098 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 = 'SEINE SAINT DENIS' 
  AND a.ad_city = 'PANTIN' 
  AND c.catid = 1 
  AND a.published = 1

  ORDER BY a.date_created DESC 
  LIMIT 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.07 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.07 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.03 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	15.87 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pile d'appels

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

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

Temps de requête : 43.17 ms Après la dernière requête : 0.55 ms Mémoire de requête : 0.023 MB mémoire avant requête : 5.316 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 = 'SEINE SAINT DENIS' 
  AND a.ad_city = 'PANTIN' 
  AND c.catid = 1 
  AND a.published = 1

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	index	PRIMARY	PRIMARY	8	NULL	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.07 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.04 ms
Optimizing	0.03 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.05 ms
Executing	0.02 ms
Sending data	42.63 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.03 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
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:289
13	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:239
12	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_adssearch/views/offres/view.html.php:37
10	AdssearchViewOffres->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_adssearch/controller.php:110
8	AdssearchController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_adssearch/adssearch.php:36
6	require_once JROOT/components/com_adssearch/adssearch.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.48 ms Après la dernière requête : 1.25 ms Mémoire de requête : 0.032 MB mémoire avant requête : 5.363 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.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.09 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pile d'appels

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

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

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

Requêtes dupliquées: #32 #33 #38 #43 #44

SELECT `communetwo`

  FROM `xca3p_adssearch_ville`

  WHERE `id` = 36310

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.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.02 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.02 ms

Pile d'appels

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

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

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

Requêtes dupliquées: #32 #33 #37 #43 #44

SELECT `communetwo`

  FROM `xca3p_adssearch_ville`

  WHERE `id` = 36310

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.03 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.01 ms
Reset for next command	0.02 ms

Pile d'appels

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

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

Temps de requête : 0.37 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.024 MB mémoire avant requête : 6.133 MB Rangées retournées : 8

Requêtes dupliquées: #40

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

Pile d'appels

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

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

Temps de requête : 0.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.140 MB Rangées retournées : 8

Requêtes dupliquées: #39

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.02 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.02 ms
Reset for next command	0.01 ms

Pile d'appels

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

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

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

Requêtes dupliquées: #42

SELECT `departement_alias`

  FROM `xca3p_adssearch_departement`

  WHERE `dep_code` = 93

Explication

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

Profil

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

Pile d'appels

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

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

Temps de requête : 0.33 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.157 MB Rangées retournées : 1

Requêtes dupliquées: #41

SELECT `departement_alias`

  FROM `xca3p_adssearch_departement`

  WHERE `dep_code` = 93

Explication

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

Profil

Status	Duration
Starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.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.01 ms
Reset for next command	0.01 ms

Pile d'appels

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

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

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

Requêtes dupliquées: #32 #33 #37 #38 #44

SELECT `communetwo`

  FROM `xca3p_adssearch_ville`

  WHERE `id` = 36310

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.02 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.01 ms
Reset for next command	0.01 ms

Pile d'appels

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

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

Temps de requête : 0.29 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.173 MB Rangées retournées : 1

Requêtes dupliquées: #32 #33 #37 #38 #43

SELECT `communetwo`

  FROM `xca3p_adssearch_ville`

  WHERE `id` = 36310

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

Pile d'appels

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

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

Temps de requête : 1.26 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.182 MB Rangées retournées : 1

SELECT `codepostal`

  FROM `xca3p_adssearch_ville`

  WHERE `reg` = '11' 
  AND `dep` = '93' 
  AND `communetwo` = 'PANTIN'

  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.04 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.10 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.82 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.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/offres/tmpl/default.php:66
14	include JROOT/components/com_adssearch/views/offres/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla/src/ViewTrait.php:26
12	View3aeb4553->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_adssearch/views/offres/view.html.php:51
10	AdssearchViewOffres->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_adssearch/controller.php:110
8	AdssearchController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_adssearch/adssearch.php:36
6	require_once JROOT/components/com_adssearch/adssearch.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM `xca3p_forseo_custom_meta` 
  WHERE `url`='offre-sous-location/ILE_DE_FRANCE/SEINE_SAINT_DENIS/PANTIN/';

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
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.89 ms Après la dernière requête : 1.16 ms Mémoire de requête : 0.085 MB mémoire avant requête : 6.408 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.08 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.04 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.06 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.35 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.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.44 ms Après la dernière requête : 28.88 ms Mémoire de requête : 0.022 MB mémoire avant requête : 7.305 MB Rangées retournées : 0

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

Explication

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

Profil

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.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.02 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.02 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.30 ms Après la dernière requête : 0.05 ms Mémoire de requête : 0.022 MB mémoire avant requête : 7.311 MB Rangées retournées : 0

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

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

Pile d'appels

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

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

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

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

Explication

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

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.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.06 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.02 ms
Sending data	0.01 ms
Creating sort index	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 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
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.47 ms Après la dernière requête : 1.68 ms Mémoire de requête : 0.021 MB mémoire avant requête : 7.455 MB Rangées retournées : 2

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

  FROM `xca3p_cookix_action` AS `a`

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

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

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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.33 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.461 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.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.02 ms
Updating status	0.03 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 : 1.99 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/offre-sous-location/ILE_DE_FRANCE/SEINE_SAINT_DENIS/PANTIN/'

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
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.49 ms Après la dernière requête : 2.38 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.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.05 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.10 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
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.33 ms Après la dernière requête : 0.09 ms Mémoire de requête : 0.025 MB mémoire avant requête : 7.678 MB Rangées retournées : 0

SELECT group_id 
  FROM xca3p_user_usergroup_map
                            
  WHERE user_id = 0

Explication

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

Profil

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

Pile d'appels

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

SELECT `id` 
  FROM `xca3p_forseo_pages` 
  WHERE `content_id`='Itemid=104&dept=93&option=com_adssearch&reg=11&view=offres&ville=36310' 
  AND `canonical_auto`=0 
  AND `url` != 'offre-sous-location/ILE_DE_FRANCE/SEINE_SAINT_DENIS/PANTIN/';

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.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.02 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.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: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.43 ms Après la dernière requête : 0.95 ms Mémoire de requête : 0.025 MB mémoire avant requête : 7.777 MB Rangées retournées : 0

SELECT * 
  FROM `xca3p_forseo_errors` 
  WHERE `url`='offre-sous-location/ILE_DE_FRANCE/SEINE_SAINT_DENIS/PANTIN/';

Explication

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

Profil

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

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

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

SELECT * 
  FROM `xca3p_forseo_links` 
  WHERE `url`='offre-sous-location/ILE_DE_FRANCE/SEINE_SAINT_DENIS/PANTIN/';

Explication

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

Profil

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

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

45 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 `region_alias` 
  FROM `xca3p_adssearch_departement`

2 × SELECT `region` 
  FROM `xca3p_adssearch_ville`

2 × SELECT `departement_alias` 
  FROM `xca3p_adssearch_departement`

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

2 × SELECT `dep_code` 
  FROM `xca3p_adssearch_departement`

2 × SELECT `departement` 
  FROM `xca3p_adssearch_ville`

2 × SELECT `reg_code` 
  FROM `xca3p_adssearch_departement`

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 `full_url` 
  from `xca3p_forseo_pages`

1 × SELECT custom_data 
  FROM xca3p_extensions

1 × SELECT *  
  FROM xca3p_jmap_headings

1 × SELECT *  
  FROM xca3p_jmap_canonicals

1 × SELECT *  
  FROM xca3p_jmap_metainfo

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_adsmanager_confi

1 × SELECT * 
  FROM `xca3p_forseo_custom_meta`

1 × SELECT `codepostal` 
  FROM `xca3p_adssearch_ville`

1 × SELECT group_id 
  FROM xca3p_user_usergroup_map

1 × SELECT `id` 
  FROM `xca3p_forseo_pages`

1 × SELECT * 
  FROM `xca3p_forseo_errors`

1 × SELECT `data` 
  FROM `xca3p_session`

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

1 × SELECT `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 id 
  FROM xca3p_adssearch_ville

1 × SELECT * 
  FROM xca3p_rsfirewall_hashes

1 × SELECT * 
  FROM xca3p_rsfirewall_snapshots

1 × SELECT * 
  FROM xca3p_rsfirewall_exceptions

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

1 × SELECT * 
  FROM `xca3p_forseo_pages`

1 × SELECT `session_id` 
  FROM `xca3p_session`

1 × SELECT * 
  FROM `xca3p_forseo_links`

Autres tables :

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

1 × SHOW FULL COLUMNS 
  FROM `xca3p_rsfirewall_logs

1 × UPDATE `xca3p_extensions` 
  SET `params` = '{\"mediaversion\":\"85cdb18a8cc152d97fb5ea831136122b\"}'

Offres de sous-location PANTIN

Appartement, 1 Pièces, 20 m²

Studio à partager avec touristes

Sous location PANTIN (93) JUILLET - AOÛT

Sous location appartement Pantin

grand studio sur le canal de l'ourq

Sous-location Chambre Paris-Pantin

Appartement T2 métro Eglise de Pantin

T2 Porte de Paris / Proche canal et Parc de la Villette !

LOFT DUPLEX

Sous-loc appart Paris juillet et/ou août, souplesse sur date d'arrivée et de sortie!

"Une Chambre meublé" - 400€

2 pièces au bord du canal de l'Ourcq

sous-location chambre Paris 450e/mois

JUILLET AOUT PANTIN

Loue Grand Studio Métro Eglise Pantin

850€ - Collocation Pte de la Villette - dispo février/mi-avril

Beau F2 47 m2 PANTIN 850 €/mois

Location F3 (2 chambres) Pantin Août-Octobre 2013

2 pièces proche Paris; Durée:5 à 6 mois

Sous loc appartement au mois ou pour plusieurs mois

Console de débogage Joomla!

Session

Profil d'information

Temps

Mémoire

Occupation de la mémoire

Requêtes de base de données

58 requêtes exécutées 227.28 ms

18 doubles découverts!

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

Tables sélectionnées :

Autres tables :