Console de débogage Joomla!

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1714041500,
                "last": 1714041500,
                "now": 1714041500
            },
            "client": {
                "forwarded": "18.227.24.209"
            },
            "token": "r4SsJ5kAuBAZiOoEROCknm810FoFoioI"
        },
        "registry": {
            "current_theme": null,
            "current_direction": "ltr",
            "current_key_sufix": "__ltr"
        },
        "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
        },
        "date_value": ""
    }
}

Profil d'information

Occupation de la mémoire

Requêtes de base de données

27 requêtes exécutées 669.13 ms

Temps de requête : 6.96 ms Mémoire de requête : 0.019 MB mémoire avant requête : 0.914 MB Rangées retournées : 0

SELECT `data`

  FROM `x87lg_session`

  WHERE `session_id` = 'hoh9clejtjen7uhjctasntrv84'

Explication

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `data` FROM `#__session` WHERE `session_id` = 'hoh9clejtjen7uhjctasntr' at line 1

Profil

Status	Duration
starting	0.39 ms
Executing hook on transaction	0.20 ms
starting	0.16 ms
checking permissions	0.16 ms
Opening tables	1.37 ms
init	0.20 ms
System lock	0.16 ms
optimizing	0.14 ms
statistics	0.16 ms
executing	0.14 ms
end	0.13 ms
query end	0.12 ms
waiting for handler commit	0.16 ms
closing tables	0.13 ms
freeing items	1.58 ms
cleaning up	0.22 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Même appel que celui de la ligne ci-dessous.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:82
10	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:648
9	JSession->_start()	JROOT/libraries/joomla/session/session.php:608
8	JSession->start()	JROOT/libraries/joomla/session/session.php:486
7	JSession->get()	JROOT/libraries/joomla/session/session.php:443
6	JSession->isNew()	JROOT/libraries/cms/application/cms.php:829
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:413
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::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 : 8.92 ms Après la dernière requête : 0.72 ms Mémoire de requête : 0.010 MB mémoire avant requête : 0.968 MB Rangées retournées : 0

SELECT `session_id`

  FROM `x87lg_session`

  WHERE `session_id` = 'hoh9clejtjen7uhjctasntrv84' 
  LIMIT 1

Explication

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `session_id` FROM `#__session` WHERE `session_id` = 'hoh9clejtjen7uhjc' at line 1

Profil

Status	Duration
starting	0.34 ms
Executing hook on transaction	0.18 ms
starting	0.17 ms
checking permissions	1.49 ms
Opening tables	0.85 ms
init	0.23 ms
System lock	0.14 ms
optimizing	0.13 ms
statistics	0.15 ms
executing	0.14 ms
end	0.41 ms
query end	0.37 ms
waiting for handler commit	0.35 ms
closing tables	0.93 ms
freeing items	0.22 ms
cleaning up	0.39 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:831
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:413
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::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 : 7.77 ms Après la dernière requête : 0.26 ms Mémoire de requête : 0.009 MB mémoire avant requête : 0.983 MB

INSERT INTO `x87lg_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('hoh9clejtjen7uhjctasntrv84', 1, '1714041500', 0, '', 0)

Explication

EXPLAIN impossible sur la requête : INSERT INTO `x87lg_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('hoh9clejtjen7uhjctasntrv84', 1, '1714041500', 0, '', 0)

Profil

Status	Duration
starting	0.22 ms
Executing hook on transaction	0.89 ms
starting	0.20 ms
checking permissions	0.16 ms
Opening tables	0.16 ms
init	0.95 ms
System lock	0.93 ms
update	0.91 ms
end	1.50 ms
query end	0.23 ms
waiting for handler commit	0.15 ms
closing tables	0.11 ms
freeing items	0.12 ms
cleaning up	0.11 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:216
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:831
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:413
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::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 : 6.44 ms Après la dernière requête : 2.02 ms Mémoire de requête : 0.013 MB mémoire avant requête : 1.148 MB Rangées retournées : 5

SELECT id, rules

  FROM `x87lg_viewlevels`

Explication

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT id, rules FROM `#__viewlevels`' at line 1

Profil

Status	Duration
starting	1.14 ms
Executing hook on transaction	0.41 ms
starting	0.18 ms
checking permissions	0.13 ms
Opening tables	2.03 ms
init	0.23 ms
System lock	0.16 ms
optimizing	0.15 ms
statistics	0.14 ms
preparing	0.14 ms
executing	0.17 ms
end	0.13 ms
query end	0.13 ms
waiting for handler commit	0.12 ms
closing tables	0.11 ms
freeing items	0.14 ms
cleaning up	0.14 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:1061
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:309
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Temps de requête : 14.70 ms Après la dernière requête : 0.38 ms Mémoire de requête : 0.014 MB mémoire avant requête : 1.173 MB Rangées retournées : 2

SELECT b.id

  FROM x87lg_usergroups AS a

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

  WHERE a.id = 13

Explication

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT b.id FROM #__usergroups AS a LEFT JOIN #__usergroups AS b ON b.lft ' at line 1

Profil

Status	Duration
starting	0.20 ms
Executing hook on transaction	0.15 ms
starting	0.13 ms
checking permissions	0.13 ms
checking permissions	0.11 ms
Opening tables	4.11 ms
init	0.29 ms
System lock	2.79 ms
optimizing	1.91 ms
statistics	0.36 ms
preparing	0.20 ms
executing	0.17 ms
end	0.14 ms
query end	2.77 ms
waiting for handler commit	0.26 ms
closing tables	0.15 ms
freeing items	0.13 ms
cleaning up	0.12 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:978
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:1093
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:309
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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 : 299.17 ms Après la dernière requête : 17.29 ms Mémoire de requête : 0.013 MB mémoire avant requête : 2.181 MB Rangées retournées : 0

SELECT id, 
  LEFT( tm, 9 ) , ip, count(*)

  FROM `x87lg_cwtraffic`

  GROUP BY 
  LEFT( tm, 9 ) , ip

  HAVING count(*) > 1 
  LIMIT 50

Explication

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT id, LEFT( tm, 9 ) , ip, count(*) FROM `#__cwtraffic` GROUP BY LEFT( tm' at line 1

Profil

Status	Duration
starting	0.35 ms
Executing hook on transaction	0.17 ms
starting	0.13 ms
checking permissions	0.12 ms
Opening tables	9.16 ms
init	0.29 ms
System lock	0.13 ms
optimizing	0.11 ms
statistics	0.11 ms
preparing	1.45 ms
Creating tmp table	0.38 ms
executing	281.92 ms
end	0.29 ms
query end	1.14 ms
closing tables	0.29 ms
freeing items	0.20 ms
cleaning up	0.15 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/cwtrafficclean/cwtrafficclean.php:66
9	plgSystemCwtrafficClean->onAfterInitialise()	Même appel que celui de la ligne ci-dessous.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:684
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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 : 7.77 ms Après la dernière requête : 0.42 ms Mémoire de requête : 0.013 MB mémoire avant requête : 2.193 MB Rangées retournées : 1

SELECT count(*)

  FROM `x87lg_cwtraffic_total`

Explication

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT count(*) FROM `#__cwtraffic_total`' at line 1

Profil

Status	Duration
starting	0.28 ms
Executing hook on transaction	0.17 ms
starting	0.13 ms
checking permissions	0.13 ms
Opening tables	0.96 ms
init	0.19 ms
System lock	0.15 ms
optimizing	0.15 ms
executing	0.13 ms
end	0.11 ms
query end	0.11 ms
closing tables	0.11 ms
freeing items	0.14 ms
cleaning up	0.13 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
10	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwtrafficclean/cwtrafficclean.php:88
9	plgSystemCwtrafficClean->onAfterInitialise()	Même appel que celui de la ligne ci-dessous.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:684
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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 : 11.88 ms Après la dernière requête : 0.47 ms Mémoire de requête : 0.013 MB mémoire avant requête : 2.208 MB Rangées retournées : 1

SELECT count(*)

  FROM `x87lg_cwtraffic`

  WHERE tm < '1711324800'

Explication

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT count(*) FROM `#__cwtraffic` WHERE tm < '1711324800'' at line 1

Profil

Status	Duration
starting	0.29 ms
Executing hook on transaction	0.14 ms
starting	0.11 ms
checking permissions	0.10 ms
Opening tables	0.11 ms
init	0.13 ms
System lock	0.12 ms
optimizing	0.13 ms
statistics	5.77 ms
preparing	0.33 ms
executing	0.19 ms
end	0.14 ms
query end	0.12 ms
closing tables	0.10 ms
freeing items	0.12 ms
cleaning up	0.13 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
10	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwtrafficclean/cwtrafficclean.php:143
9	plgSystemCwtrafficClean->onAfterInitialise()	Même appel que celui de la ligne ci-dessous.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:684
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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 : 7.18 ms Après la dernière requête : 0.86 ms Mémoire de requête : 0.013 MB mémoire avant requête : 2.235 MB Rangées retournées : 0

SELECT ip

  FROM `x87lg_cwtraffic_knownips`

  WHERE state = 1 
  AND count = 0

Explication

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT ip FROM `#__cwtraffic_knownips` WHERE state = 1 AND count = 0' at line 1

Profil

Status	Duration
starting	0.32 ms
Executing hook on transaction	0.17 ms
starting	0.12 ms
checking permissions	0.16 ms
Opening tables	3.43 ms
init	0.30 ms
System lock	0.19 ms
optimizing	0.16 ms
statistics	0.14 ms
executing	0.13 ms
end	0.11 ms
query end	0.15 ms
closing tables	0.11 ms
freeing items	0.16 ms
cleaning up	0.13 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
10	JDatabaseDriver->loadColumn()	JROOT/plugins/system/cwtrafficcount/cwtrafficcount.php:106
9	plgSystemCwtrafficCount->onAfterInitialise()	Même appel que celui de la ligne ci-dessous.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:684
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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 : 5.41 ms Après la dernière requête : 0.32 ms Mémoire de requête : 0.013 MB mémoire avant requête : 2.248 MB Rangées retournées : 0

SELECT botname

  FROM `x87lg_cwtraffic_knownips`

  WHERE state = 1 
  AND count = 0

Explication

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT botname FROM `#__cwtraffic_knownips` WHERE state = 1 AND count = 0' at line 1

Profil

Status	Duration
starting	0.33 ms
Executing hook on transaction	1.52 ms
starting	0.46 ms
checking permissions	0.15 ms
Opening tables	0.12 ms
init	0.13 ms
System lock	0.14 ms
optimizing	0.14 ms
statistics	0.15 ms
executing	0.12 ms
end	0.11 ms
query end	0.11 ms
closing tables	0.13 ms
freeing items	0.14 ms
cleaning up	0.14 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
10	JDatabaseDriver->loadColumn()	JROOT/plugins/system/cwtrafficcount/cwtrafficcount.php:126
9	plgSystemCwtrafficCount->onAfterInitialise()	Même appel que celui de la ligne ci-dessous.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:684
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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 : 53.21 ms Après la dernière requête : 0.37 ms Mémoire de requête : 0.013 MB mémoire avant requête : 2.262 MB Rangées retournées : 1

SELECT count(*)

  FROM `x87lg_cwtraffic`

  WHERE ip = '18.227.24.209' 
  AND tm + '86400'>'1714041500'

Explication

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT count(*) FROM `#__cwtraffic` WHERE ip = '18.227.24.209' AND tm + '8640' at line 1

Profil

Status	Duration
starting	1.16 ms
Executing hook on transaction	0.69 ms
starting	4.80 ms
checking permissions	0.28 ms
Opening tables	0.18 ms
init	0.13 ms
System lock	0.12 ms
optimizing	0.11 ms
statistics	0.14 ms
preparing	0.13 ms
executing	34.88 ms
end	2.89 ms
query end	2.67 ms
closing tables	0.25 ms
freeing items	0.66 ms
cleaning up	0.19 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
10	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwtrafficcount/cwtrafficcount.php:163
9	plgSystemCwtrafficCount->onAfterInitialise()	Même appel que celui de la ligne ci-dessous.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:684
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Temps de requête : 15.00 ms Après la dernière requête : 0.54 ms Mémoire de requête : 0.013 MB mémoire avant requête : 2.276 MB

INSERT INTO `x87lg_cwtraffic`
(tm, ip, browser, bversion, platform, referer) 
  VALUES 
('1714041500','18.227.24.209','Mozilla','5.0','unknown','-')

Explication

EXPLAIN impossible sur la requête : INSERT INTO `x87lg_cwtraffic` (tm, ip, browser, bversion, platform, referer) VALUES ('1714041500','18.227.24.209','Mozilla','5.0','unknown','-')

Profil

Status	Duration
starting	0.37 ms
Executing hook on transaction	0.18 ms
starting	0.90 ms
checking permissions	0.41 ms
Opening tables	0.20 ms
init	0.13 ms
System lock	0.10 ms
update	6.89 ms
end	1.11 ms
query end	0.20 ms
closing tables	2.33 ms
freeing items	0.24 ms
cleaning up	0.15 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
10	JDatabase->query()	JROOT/plugins/system/cwtrafficcount/cwtrafficcount.php:172
9	plgSystemCwtrafficCount->onAfterInitialise()	Même appel que celui de la ligne ci-dessous.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:684
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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 : 9.99 ms Après la dernière requête : 0.44 ms Mémoire de requête : 0.013 MB mémoire avant requête : 2.293 MB Rangées retournées : 1

SELECT count(*)

  FROM `x87lg_cwtraffic_whoisonline`

  WHERE ip = '316872913'

Explication

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT count(*) FROM `#__cwtraffic_whoisonline` WHERE ip = '316872913'' at line 1

Profil

Status	Duration
starting	0.36 ms
Executing hook on transaction	0.49 ms
starting	0.19 ms
checking permissions	1.36 ms
Opening tables	2.81 ms
init	0.90 ms
System lock	0.23 ms
optimizing	0.16 ms
statistics	0.15 ms
executing	0.12 ms
end	0.11 ms
query end	0.10 ms
closing tables	0.11 ms
freeing items	0.13 ms
cleaning up	0.12 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
10	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwtrafficonline/cwtrafficonline.php:75
9	plgSystemCwtrafficOnline->onAfterInitialise()	Même appel que celui de la ligne ci-dessous.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:684
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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 : 5.30 ms Après la dernière requête : 0.30 ms Mémoire de requête : 0.013 MB mémoire avant requête : 2.307 MB

INSERT INTO `x87lg_cwtraffic_whoisonline`
(ip,country_name, country_code, city,  dt) 
  VALUES 
('316872913','unknown country','xx','unknown city',NOW())

Explication

EXPLAIN impossible sur la requête : INSERT INTO `x87lg_cwtraffic_whoisonline` (ip,country_name, country_code, city, dt) VALUES ('316872913','unknown country','xx','unknown city',NOW())

Profil

Status	Duration
starting	0.32 ms
Executing hook on transaction	0.14 ms
starting	0.12 ms
checking permissions	0.10 ms
Opening tables	0.13 ms
init	0.11 ms
System lock	0.11 ms
update	0.17 ms
end	0.12 ms
query end	0.12 ms
closing tables	0.12 ms
freeing items	0.12 ms
cleaning up	0.11 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
10	JDatabase->query()	JROOT/plugins/system/cwtrafficonline/cwtrafficonline.php:106
9	plgSystemCwtrafficOnline->onAfterInitialise()	Même appel que celui de la ligne ci-dessous.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:684
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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 : 12.32 ms Après la dernière requête : 0.39 ms Mémoire de requête : 0.013 MB mémoire avant requête : 2.321 MB

DELETE 

  FROM `x87lg_cwtraffic_whoisonline`

  WHERE dt < SUBTIME(NOW(),'0 0:10:0')

Explication

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELETE FROM `#__cwtraffic_whoisonline` WHERE dt < SUBTIME(NOW(),'0 0:10:0')' at line 1

Profil

Status	Duration
starting	0.28 ms
Executing hook on transaction	0.16 ms
starting	0.13 ms
checking permissions	0.12 ms
Opening tables	0.12 ms
init	0.10 ms
System lock	0.11 ms
updating	7.40 ms
end	0.30 ms
query end	0.14 ms
closing tables	0.13 ms
freeing items	0.14 ms
cleaning up	0.12 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
10	JDatabase->query()	JROOT/plugins/system/cwtrafficonline/cwtrafficonline.php:120
9	plgSystemCwtrafficOnline->onAfterInitialise()	Même appel que celui de la ligne ci-dessous.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:684
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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 : 10.91 ms Après la dernière requête : 24.82 ms Mémoire de requête : 0.018 MB mémoire avant requête : 3.084 MB

UPDATE `x87lg_extensions`

  SET `params` = '{\"mediaversion\":\"2df8451183554993ebe9b3bc815ac656\"}'

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

Explication

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UPDATE `#__extensions` SET `params` = '{\"mediaversion\":\"2df8451183554993eb' at line 1

Profil

Status	Duration
starting	0.34 ms
Executing hook on transaction	0.16 ms
starting	0.13 ms
checking permissions	0.11 ms
Opening tables	2.84 ms
init	0.25 ms
System lock	0.24 ms
updating	0.24 ms
end	0.16 ms
query end	0.13 ms
waiting for handler commit	0.15 ms
closing tables	0.14 ms
freeing items	1.30 ms
cleaning up	0.18 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:116
14	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:321
13	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:280
12	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
11	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
10	JFactory::getDocument()	JROOT/plugins/system/cwgears/cwgears.php:52
9	plgSystemCwgears->onAfterRoute()	Même appel que celui de la ligne ci-dessous.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1155
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Temps de requête : 14.77 ms Après la dernière requête : 29.10 ms Mémoire de requête : 0.022 MB mémoire avant requête : 3.751 MB Rangées retournées : 9

SELECT next AS tNext, dates AS tDates, startdate AS tStartdate, enddate AS tEnddate,
						weekdays AS tWeekdays, id AS tId, state AS tState, access AS tAccess

  FROM `x87lg_icagenda_events` AS e

  WHERE  e.state = 1 OR e.state = 0

Explication

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT next AS tNext, dates AS tDates, startdate AS tStartdate, enddate AS tEndd' at line 1

Profil

Status	Duration
starting	0.39 ms
Executing hook on transaction	0.22 ms
starting	0.15 ms
checking permissions	0.12 ms
Opening tables	3.98 ms
init	0.26 ms
System lock	0.16 ms
optimizing	0.14 ms
statistics	1.32 ms
preparing	0.20 ms
executing	0.68 ms
end	0.14 ms
query end	0.10 ms
closing tables	0.60 ms
freeing items	0.18 ms
cleaning up	0.14 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_icagenda/utilities/events/data.php:653
15	icagendaEventsData::getNext()	JROOT/components/com_icagenda/helpers/icmodel.php:117
14	iCModelItem->getDBitems()	JROOT/components/com_icagenda/helpers/icmodel.php:81
13	iCModelItem->getItems()	JROOT/components/com_icagenda/models/list.php:321
12	icagendaModelList->getData()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
11	JViewLegacy->get()	JROOT/components/com_icagenda/views/list/view.html.php:47
10	icagendaViewList->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_icagenda/controller.php:61
8	iCagendaController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_icagenda/icagenda.php:139
6	require_once JROOT/components/com_icagenda/icagenda.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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 : 28.84 ms Après la dernière requête : 4.03 ms Mémoire de requête : 0.020 MB mémoire avant requête : 3.790 MB Rangées retournées : 1

SELECT e.*,
			e.place as place_name, e.coordinate as coordinate, e.lat as lat, e.lng as lng,
			c.id as cat_id, c.title as cat_title, c.color as cat_color, c.desc as cat_desc, c.alias as cat_alias,feat.count AS features,r.count AS registered

  FROM `x87lg_icagenda_events` AS e

  LEFT JOIN `x87lg_icagenda_category` AS c 
  ON c.id = e.catid

  LEFT JOIN (
SELECT fx.event_id, COUNT(*) AS count

  FROM `x87lg_icagenda_feature_xref` AS fx

  INNER JOIN `x87lg_icagenda_feature` AS f 
  ON fx.feature_id=f.id 
  AND f.state=1 
  AND f.icon<>'-1'

  GROUP BY fx.event_id) AS feat 
  ON e.id=feat.event_id

  LEFT JOIN (
SELECT r.eventid, sum(r.people) AS count

  FROM `x87lg_icagenda_registration` AS r

  WHERE r.state > 0

  GROUP BY r.eventid) AS r 
  ON e.id=r.eventid

  WHERE c.state = 1 
  AND e.state = 1 
  AND e.approval <> 1 
  AND (e.language in ('fr-FR','*')) 
  AND e.id=112

Explication

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT e.*, e.place as place_name, e.coordinate as coordinate, e.lat as lat, ' at line 1

Profil

Status	Duration
starting	0.51 ms
Executing hook on transaction	0.17 ms
starting	0.12 ms
checking permissions	0.14 ms
checking permissions	0.12 ms
checking permissions	0.12 ms
checking permissions	0.13 ms
checking permissions	0.12 ms
Opening tables	8.17 ms
init	2.04 ms
System lock	0.56 ms
optimizing	0.76 ms
optimizing	0.72 ms
statistics	0.66 ms
executing	0.42 ms
optimizing	0.45 ms
statistics	1.00 ms
preparing	0.29 ms
Creating tmp table	0.56 ms
statistics	0.55 ms
preparing	0.49 ms
executing	2.53 ms
end	0.90 ms
query end	0.25 ms
closing tables	0.40 ms
freeing items	0.20 ms
cleaning up	0.15 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_icagenda/helpers/icmodel.php:384
14	iCModelItem->getDBitems()	JROOT/components/com_icagenda/helpers/icmodel.php:81
13	iCModelItem->getItems()	JROOT/components/com_icagenda/models/list.php:321
12	icagendaModelList->getData()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
11	JViewLegacy->get()	JROOT/components/com_icagenda/views/list/view.html.php:47
10	icagendaViewList->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_icagenda/controller.php:61
8	iCagendaController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_icagenda/icagenda.php:139
6	require_once JROOT/components/com_icagenda/icagenda.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

SELECT r.date AS date, r.eventid AS eventid, r.people AS people

  FROM `x87lg_icagenda_registration` AS r

  WHERE r.state = 1 
  AND r.eventid = '112'

Explication

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT r.date AS date, r.eventid AS eventid, r.people AS people FROM `#__icag' at line 1

Profil

Status	Duration
starting	0.36 ms
Executing hook on transaction	0.17 ms
starting	0.15 ms
checking permissions	0.12 ms
Opening tables	0.15 ms
init	0.13 ms
System lock	0.16 ms
optimizing	0.67 ms
statistics	0.17 ms
preparing	0.16 ms
executing	0.16 ms
end	0.12 ms
query end	0.10 ms
closing tables	0.38 ms
freeing items	0.17 ms
cleaning up	0.14 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_icagenda/utilities/events/data.php:1004
15	icagendaEventsData::registeredList()	JROOT/components/com_icagenda/helpers/icmodel.php:386
14	iCModelItem->getDBitems()	JROOT/components/com_icagenda/helpers/icmodel.php:81
13	iCModelItem->getItems()	JROOT/components/com_icagenda/models/list.php:321
12	icagendaModelList->getData()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
11	JViewLegacy->get()	JROOT/components/com_icagenda/views/list/view.html.php:47
10	icagendaViewList->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_icagenda/controller.php:61
8	iCagendaController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_icagenda/icagenda.php:139
6	require_once JROOT/components/com_icagenda/icagenda.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

SELECT a.title, a.published, a.id

  FROM `x87lg_menu` AS a

  WHERE (link = 'index.php?option=com_icagenda&view=list') 
  AND (published > 0)

Explication

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT a.title, a.published, a.id FROM `#__menu` AS a WHERE (link = 'index.ph' at line 1

Profil

Status	Duration
starting	0.30 ms
Executing hook on transaction	0.14 ms
starting	0.12 ms
checking permissions	0.13 ms
Opening tables	1.81 ms
init	0.22 ms
System lock	0.16 ms
optimizing	0.14 ms
statistics	0.16 ms
preparing	0.15 ms
executing	0.31 ms
end	0.14 ms
query end	0.12 ms
waiting for handler commit	6.09 ms
closing tables	0.27 ms
freeing items	0.15 ms
cleaning up	0.11 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_icagenda/helpers/icmodel.php:873
14	iCModelItem->items()	JROOT/components/com_icagenda/helpers/icmodel.php:86
13	iCModelItem->getItems()	JROOT/components/com_icagenda/models/list.php:321
12	icagendaModelList->getData()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
11	JViewLegacy->get()	JROOT/components/com_icagenda/views/list/view.html.php:47
10	icagendaViewList->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_icagenda/controller.php:61
8	iCagendaController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_icagenda/icagenda.php:139
6	require_once JROOT/components/com_icagenda/icagenda.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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.81 ms Après la dernière requête : 13.16 ms Mémoire de requête : 0.021 MB mémoire avant requête : 3.999 MB Rangées retournées : 0

SELECT  r.userid AS userid, r.name AS registeredUsers, r.date as regDate, r.people as regPeople, r.email as regEmail,
						u.name AS name, u.username AS username

  FROM x87lg_icagenda_registration AS r

  LEFT JOIN x87lg_users as u 
  ON u.id = r.userid

  WHERE (r.eventId=112) 
  AND (r.state > 0)

Explication

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT r.userid AS userid, r.name AS registeredUsers, r.date as regDate, r.peop' at line 1

Profil

Status	Duration
starting	0.38 ms
Executing hook on transaction	0.18 ms
starting	0.34 ms
checking permissions	0.16 ms
checking permissions	0.15 ms
Opening tables	8.27 ms
init	0.32 ms
System lock	0.14 ms
optimizing	0.12 ms
statistics	0.15 ms
preparing	0.15 ms
executing	0.14 ms
end	0.10 ms
query end	0.10 ms
waiting for handler commit	0.11 ms
closing tables	0.12 ms
freeing items	0.12 ms
cleaning up	1.49 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_icagenda/helpers/icmodel.php:2776
15	iCModelItem->registeredUsers()	JROOT/components/com_icagenda/helpers/icmodel.php:933
14	iCModelItem->items()	JROOT/components/com_icagenda/helpers/icmodel.php:86
13	iCModelItem->getItems()	JROOT/components/com_icagenda/models/list.php:321
12	icagendaModelList->getData()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
11	JViewLegacy->get()	JROOT/components/com_icagenda/views/list/view.html.php:47
10	icagendaViewList->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_icagenda/controller.php:61
8	iCagendaController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_icagenda/icagenda.php:139
6	require_once JROOT/components/com_icagenda/icagenda.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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 : 28.44 ms Après la dernière requête : 3.60 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.050 MB Rangées retournées : 0

SELECT cfd.*, cf.title AS title

  FROM `x87lg_icagenda_customfields_data` AS cfd

  LEFT JOIN x87lg_icagenda_customfields AS cf 
  ON cf.slug = cfd.slug

  WHERE `cfd`.`parent_id` = 112 
  AND `cfd`.`parent_form` = 2 
  AND `cf`.`parent_form` = 2 
  AND `cfd`.`state` = 1 
  AND `cf`.`state` = 1

  ORDER BY cf.ordering ASC

Explication

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT cfd.*, cf.title AS title FROM `#__icagenda_customfields_data` AS cfd L' at line 1

Profil

Status	Duration
starting	0.36 ms
Executing hook on transaction	0.13 ms
starting	0.10 ms
checking permissions	0.33 ms
checking permissions	1.24 ms
Opening tables	17.98 ms
init	0.28 ms
System lock	0.23 ms
optimizing	0.15 ms
statistics	0.15 ms
executing	0.37 ms
end	0.17 ms
query end	0.15 ms
closing tables	0.31 ms
freeing items	0.18 ms
cleaning up	0.16 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_icagenda/helpers/icmodel.php:3682
15	iCModelItem->loadEventCustomFields()	JROOT/components/com_icagenda/helpers/icmodel.php:933
14	iCModelItem->items()	JROOT/components/com_icagenda/helpers/icmodel.php:86
13	iCModelItem->getItems()	JROOT/components/com_icagenda/models/list.php:321
12	icagendaModelList->getData()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
11	JViewLegacy->get()	JROOT/components/com_icagenda/views/list/view.html.php:47
10	icagendaViewList->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_icagenda/controller.php:61
8	iCagendaController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_icagenda/icagenda.php:139
6	require_once JROOT/components/com_icagenda/icagenda.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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 : 26.03 ms Après la dernière requête : 1.05 ms Mémoire de requête : 0.017 MB mémoire avant requête : 4.036 MB Rangées retournées : 9

SELECT e.next, e.dates, e.startdate, e.enddate, e.period, e.weekdays, e.displaytime, e.id, e.catid

  FROM x87lg_icagenda_events AS e

  LEFT JOIN `x87lg_icagenda_category` AS c 
  ON c.id = e.catid

  WHERE c.state = 1 
  AND e.state = 1 
  AND  TRUE  
  AND e.language IN ('fr-FR','*') 
  AND e.access IN (1, 1, 5) 
  AND e.approval <> 1

Explication

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT e.next, e.dates, e.startdate, e.enddate, e.period, e.weekdays, e.displayt' at line 1

Profil

Status	Duration
starting	0.56 ms
Executing hook on transaction	0.79 ms
starting	0.23 ms
checking permissions	0.17 ms
checking permissions	0.14 ms
Opening tables	0.19 ms
init	0.15 ms
System lock	10.08 ms
optimizing	0.29 ms
statistics	0.17 ms
preparing	0.15 ms
executing	3.93 ms
end	0.27 ms
query end	0.15 ms
closing tables	0.13 ms
freeing items	4.31 ms
cleaning up	0.27 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_icagenda/utilities/events/data.php:110
11	icagendaEventsData::getAllDates()	JROOT/components/com_icagenda/views/list/view.html.php:48
10	icagendaViewList->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_icagenda/controller.php:61
8	iCagendaController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_icagenda/icagenda.php:139
6	require_once JROOT/components/com_icagenda/icagenda.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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 : 9.26 ms Après la dernière requête : 17.06 ms Mémoire de requête : 0.020 MB mémoire avant requête : 4.132 MB Rangées retournées : 1

SELECT e.state AS evtState, e.approval AS evtApproval, e.access AS evtAccess,v.title AS accessName

  FROM `x87lg_icagenda_events` AS e

  LEFT JOIN `x87lg_viewlevels` AS v 
  ON v.id = e.access

  WHERE `e`.`id` = '112'

Explication

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT e.state AS evtState, e.approval AS evtApproval, e.access AS evtAccess,v.t' at line 1

Profil

Status	Duration
starting	0.34 ms
Executing hook on transaction	0.16 ms
starting	0.12 ms
checking permissions	0.11 ms
checking permissions	0.11 ms
Opening tables	0.18 ms
init	0.11 ms
System lock	0.12 ms
optimizing	0.12 ms
statistics	0.19 ms
preparing	0.13 ms
executing	0.12 ms
end	0.11 ms
query end	1.15 ms
waiting for handler commit	0.19 ms
closing tables	0.13 ms
freeing items	0.13 ms
cleaning up	0.12 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_icagenda/utilities/events/events.php:49
14	icagendaEvents::eventAccess()	JROOT/components/com_icagenda/views/list/tmpl/event.php:53
13	include JROOT/components/com_icagenda/views/list/tmpl/event.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_icagenda/views/list/view.html.php:133
10	icagendaViewList->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_icagenda/controller.php:61
8	iCagendaController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_icagenda/icagenda.php:139
6	require_once JROOT/components/com_icagenda/icagenda.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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 : 28.15 ms Après la dernière requête : 25.29 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.793 MB Rangées retournées : 116

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

  FROM x87lg_modules AS m

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

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

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

  ORDER BY m.ordering, m.id

Explication

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle,' at line 1

Profil

Status	Duration
starting	0.46 ms
Executing hook on transaction	0.20 ms
starting	0.16 ms
checking permissions	0.14 ms
checking permissions	0.14 ms
checking permissions	0.14 ms
Opening tables	2.30 ms
init	0.24 ms
System lock	0.24 ms
optimizing	0.19 ms
statistics	0.24 ms
preparing	0.17 ms
Creating tmp table	0.18 ms
executing	4.49 ms
end	0.27 ms
query end	0.16 ms
waiting for handler commit	0.14 ms
closing tables	0.17 ms
freeing items	0.15 ms
cleaning up	0.16 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/advancedmodules/modulehelper.php:455
15	JModuleHelper::load()	JROOT/plugins/system/advancedmodules/modulehelper.php:102
14	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:576
13	JDocumentHtml->countModules()	JROOT/plugins/system/t3/includes/core/template.php:608
12	T3Template->countModules()	JROOT/templates/purity_iii/tpls/blocks/header.php:62
11	include JROOT/templates/purity_iii/tpls/blocks/header.php	JROOT/plugins/system/t3/includes/core/template.php:176
10	T3Template->loadBlock()	JROOT/templates/purity_iii/tpls/corporate.php:38
9	include JROOT/templates/purity_iii/tpls/corporate.php	JROOT/plugins/system/t3/includes/core/template.php:200
8	T3Template->loadLayout()	JROOT/templates/purity_iii/index.php:34
7	require JROOT/templates/purity_iii/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->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 : 5.26 ms Après la dernière requête : 14.01 ms Mémoire de requête : 0.029 MB mémoire avant requête : 5.907 MB Rangées retournées : 1

SELECT m.menutype

  FROM x87lg_menu AS m

  WHERE m.id = 815

Explication

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT m.menutype FROM #__menu AS m WHERE m.id = 815' at line 1

Profil

Status	Duration
starting	0.29 ms
Executing hook on transaction	0.15 ms
starting	0.14 ms
checking permissions	0.14 ms
Opening tables	0.14 ms
init	0.14 ms
System lock	0.14 ms
optimizing	0.13 ms
statistics	0.89 ms
preparing	0.21 ms
executing	0.16 ms
end	0.16 ms
query end	0.14 ms
waiting for handler commit	0.15 ms
closing tables	0.15 ms
freeing items	0.15 ms
cleaning up	0.13 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
23	JDatabaseDriver->loadResult()	JROOT/plugins/system/nnframework/helpers/assignments/menu.php:75
22	NNFrameworkAssignmentsMenu->getMenuType()	JROOT/plugins/system/nnframework/helpers/assignments/menu.php:27
21	NNFrameworkAssignmentsMenu->passMenu()	JROOT/plugins/system/nnframework/helpers/assignments.php:293
20	NNFrameworkAssignmentsHelper->passAll()	JROOT/plugins/system/advancedmodules/advancedmodulehelper.php:270
19	plgSystemAdvancedModuleHelper->onPrepareModuleList()	Même appel que celui de la ligne ci-dessous.
18	call_user_func_array()	JROOT/libraries/joomla/event/dispatcher.php:165
17	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
16	JApplicationBase->triggerEvent()	JROOT/plugins/system/advancedmodules/modulehelper.php:508
15	JModuleHelper::load()	JROOT/plugins/system/advancedmodules/modulehelper.php:102
14	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:576
13	JDocumentHtml->countModules()	JROOT/plugins/system/t3/includes/core/template.php:608
12	T3Template->countModules()	JROOT/templates/purity_iii/tpls/blocks/header.php:62
11	include JROOT/templates/purity_iii/tpls/blocks/header.php	JROOT/plugins/system/t3/includes/core/template.php:176
10	T3Template->loadBlock()	JROOT/templates/purity_iii/tpls/corporate.php:38
9	include JROOT/templates/purity_iii/tpls/corporate.php	JROOT/plugins/system/t3/includes/core/template.php:200
8	T3Template->loadLayout()	JROOT/templates/purity_iii/index.php:34
7	require JROOT/templates/purity_iii/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->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 : 7.68 ms Après la dernière requête : 47.29 ms Mémoire de requête : 0.023 MB mémoire avant requête : 5.844 MB Rangées retournées : 2

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM x87lg_categories as c

  LEFT JOIN x87lg_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id=78

  ORDER BY c.lft

Explication

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, ' at line 1

Profil

Status	Duration
starting	0.41 ms
Executing hook on transaction	0.17 ms
starting	0.15 ms
checking permissions	0.14 ms
checking permissions	0.13 ms
Opening tables	2.05 ms
init	0.36 ms
System lock	0.20 ms
optimizing	0.18 ms
statistics	0.33 ms
preparing	0.24 ms
executing	0.30 ms
end	0.14 ms
query end	0.13 ms
waiting for handler commit	0.13 ms
closing tables	0.13 ms
freeing items	0.14 ms
cleaning up	0.11 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
17	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
16	JCategories->get()	JROOT/components/com_content/helpers/legacyrouter.php:173
15	ContentRouterRulesLegacy->build()	JROOT/libraries/cms/component/router/view.php:241
14	JComponentRouterView->build()	JROOT/libraries/cms/router/site.php:519
13	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
12	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
11	JRouter->build()	JROOT/libraries/cms/router/site.php:149
10	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
9	JRoute::_()	JROOT/plugins/system/sef/sef.php:110
8	PlgSystemSef->onAfterRender()	Même appel que celui de la ligne ci-dessous.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1122
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

Tables sélectionnées :

2 × SELECT count(*) 
  FROM `x87lg_cwtraffic`

1 × SELECT cfd.*, cf.title AS title 
  FROM `x87lg_icagenda_customfields_data` AS cfd 
  LEFT JOIN x87lg_icagenda_customfields AS cf 
  ON cf.slug = cfd.slug

1 × SELECT  r.userid AS userid, r.name AS registeredUsers, r.date as regDate, r.people as regPeople, r.email as regEmail,       u.name AS name, u.username AS username 
  FROM x87lg_icagenda_registration AS r 
  LEFT JOIN x87lg_users as u 
  ON u.id = r.userid

1 × SELECT a.title, a.published, a.id 
  FROM `x87lg_menu` AS a

1 × SELECT r.date AS date, r.eventid AS eventid, r.people AS people 
  FROM `x87lg_icagenda_registration` AS r

1 × SELECT e.next, e.dates, e.startdate, e.enddate, e.period, e.weekdays, e.displaytime, e.id, e.catid 
  FROM x87lg_icagenda_events AS e 
  LEFT JOIN `x87lg_icagenda_category` AS c 
  ON c.id = e.catid

1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM x87lg_categories as c 
  LEFT JOIN x87lg_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

1 × SELECT m.menutype 
  FROM x87lg_menu AS m

1 × SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.params as advancedparams, 0 as menuid, m.publish_up, m.publish_down 
  FROM x87lg_modules AS m 
  LEFT JOIN x87lg_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id 
  LEFT JOIN x87lg_advancedmodules as am 
  ON am.moduleid = m.id

1 × SELECT e.state AS evtState, e.approval AS evtApproval, e.access AS evtAccess,v.title AS accessName 
  FROM `x87lg_icagenda_events` AS e 
  LEFT JOIN `x87lg_viewlevels` AS v 
  ON v.id = e.access

1 × SELECT e.*,    e.place as place_name, e.coordinate as coordinate, e.lat as lat, e.lng as lng,    c.id as cat_id, c.title as cat_title, c.color as cat_color, c.desc as cat_desc, c.alias as cat_alias,feat.count AS features,r.count AS registered 
  FROM `x87lg_icagenda_events` AS e 
  LEFT JOIN `x87lg_icagenda_category` AS c 
  ON c.id = e.catid 
  LEFT JOIN ( SELECT fx.event_id, COUNT(*) AS count 
  FROM `x87lg_icagenda_feature_xref` AS fx 
  INNER JOIN `x87lg_icagenda_feature` AS f 
  ON fx.feature_id=f.id 
  AND f.state=1 
  AND f.icon<>'-1' 
  GROUP BY fx.event_id) AS feat 
  ON e.id=feat.event_id 
  LEFT JOIN ( SELECT r.eventid, sum(r.people) AS count 
  FROM `x87lg_icagenda_registration` AS r

1 × SELECT next AS tNext, dates AS tDates, startdate AS tStartdate, enddate AS tEnddate,       weekdays AS tWeekdays, id AS tId, state AS tState, access AS tAccess 
  FROM `x87lg_icagenda_events` AS e

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

1 × SELECT id, rules 
  FROM `x87lg_viewlevels

1 × SELECT `session_id` 
  FROM `x87lg_session`

1 × SELECT id, 
  LEFT( tm, 9 ) , ip, count(*) 
  FROM `x87lg_cwtraffic` 
  GROUP BY 
  LEFT( tm, 9 ) , ip 
  HAVING count(*) > 1 
  LIMIT 5

1 × SELECT count(*) 
  FROM `x87lg_cwtraffic_total

1 × SELECT count(*) 
  FROM `x87lg_cwtraffic_whoisonline`

1 × SELECT botname 
  FROM `x87lg_cwtraffic_knownips`

1 × SELECT ip 
  FROM `x87lg_cwtraffic_knownips`

1 × SELECT `data` 
  FROM `x87lg_session`

Autres tables :

1 × UPDATE `x87lg_extensions` 
  SET `params` = '{\"mediaversion\":\"2df8451183554993ebe9b3bc815ac656\"}'

1 × DELETE  
  FROM `x87lg_cwtraffic_whoisonline`

1 × INSERT INTO `x87lg_cwtraffic_whoisonline` (ip,country_name, country_code, city,  dt) 
  VALUES  ('316872913','unknown country','xx','unknown city',NOW()

1 × INSERT INTO `x87lg_cwtraffic` (tm, ip, browser, bversion, platform, referer) 
  VALUES  ('1714041500','18.227.24.209','Mozilla','5.0','unknown','-'

1 × INSERT INTO `x87lg_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('hoh9clejtjen7uhjctasntrv84', 1, '1714041500', 0, '', 0

Sidebar

T3 Framework

FETE DU TENNIS FFT

Toutes les Dates

Liste des Participants

Console de débogage Joomla!

Session

Profil d'information

Temps

Mémoire

Occupation de la mémoire

Requêtes de base de données

27 requêtes exécutées 669.13 ms

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

Tables sélectionnées :

Autres tables :