Exhibitions

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1768744138,
                "last": 1768744138,
                "now": 1768744138
            },
            "token": "qTYGvKctXECOOtAltSXV8n6j5mU6vAZW"
        },
        "registry": {},
        "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
        }
    }
}

Profile Information

Time

Memory

Time: 11.96 ms / 11.96 ms Memory: 1.603 MB / 1.95 MB Application: afterLoad

Time: 83.79 ms / 95.75 ms Memory: 4.492 MB / 6.44 MB Application: afterInitialise

Time: 35.20 ms / 130.94 ms Memory: 1.509 MB / 7.95 MB Application: afterRoute

Time: 0.27 ms / 131.21 ms Memory: 0.049 MB / 8.00 MB Application: beforeRenderComponent com_phocagallery

Time: 175.59 ms / 306.80 ms Memory: 2.150 MB / 10.15 MB Application: afterRenderComponent com_phocagallery

Time: 9.12 ms / 315.92 ms Memory: 0.966 MB / 11.12 MB Application: afterDispatch

Time: 4.18 ms / 320.10 ms Memory: 0.220 MB / 11.34 MB Application: beforeRenderModule mod_menu ()

Time: 5.43 ms / 325.53 ms Memory: 0.312 MB / 11.65 MB Application: afterRenderModule mod_menu ()

Time: 0.10 ms / 325.63 ms Memory: 0.000 MB / 11.41 MB Application: beforeRenderModule mod_menu ()

Time: 4.16 ms / 329.80 ms Memory: 0.248 MB / 11.66 MB Application: afterRenderModule mod_menu ()

Time: 0.47 ms / 330.27 ms Memory: 0.000 MB / 11.41 MB Application: beforeRenderModule mod_menu ()

Time: 3.57 ms / 333.84 ms Memory: 0.247 MB / 11.65 MB Application: afterRenderModule mod_menu ()

Time: 0.06 ms / 333.90 ms Memory: 0.000 MB / 11.41 MB Application: beforeRenderModule mod_menu ()

Time: 7.36 ms / 341.26 ms Memory: 0.247 MB / 11.66 MB Application: afterRenderModule mod_menu ()

Time: 0.22 ms / 341.48 ms Memory: 0.000 MB / 11.41 MB Application: beforeRenderModule mod_menu ()

Time: 3.41 ms / 344.89 ms Memory: 0.247 MB / 11.66 MB Application: afterRenderModule mod_menu ()

Time: 0.06 ms / 344.96 ms Memory: 0.000 MB / 11.42 MB Application: beforeRenderModule mod_menu ()

Time: 5.32 ms / 350.28 ms Memory: 0.249 MB / 11.67 MB Application: afterRenderModule mod_menu ()

Time: 2334.51 ms / 2684.78 ms Memory: 14.553 MB / 26.22 MB Application: beforeRenderModule mod_sp_quickcontact (Quick Contact)

Time: 0.93 ms / 2685.71 ms Memory: 0.012 MB / 26.23 MB Application: afterRenderModule mod_sp_quickcontact (Quick Contact)

Time: 3156.63 ms / 5842.34 ms Memory: 0.000 MB / 11.67 MB Application: afterRender

Database queries total: 181.13 ms

Memory Usage

Database Queries

18 Queries Logged 181.13 ms

Query Time: 2.51 ms Query memory: 0.007 MB Memory before query: 3.483 MB Rows returned: 0

SELECT `data`

  FROM `ky5qo_session`

  WHERE `session_id` = 'ed7aa51b22e360718e08333f812e7cc0'

Explain

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` = 'ed7aa51b22e360718e08333' at line 1

Profile

Status	Duration
starting	0.17 ms
Executing hook on transaction	0.01 ms
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.50 ms
init	0.02 ms
System lock	0.04 ms
optimizing	0.01 ms
statistics	0.09 ms
executing	0.01 ms
end	0.01 ms
query end	0.04 ms
waiting for handler commit	0.01 ms
closing tables	0.08 ms
freeing items	0.09 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Same as call in the line below.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
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:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.71 ms After last query: 1.26 ms Query memory: 0.004 MB Memory before query: 3.586 MB Rows returned: 0

SELECT `session_id`

  FROM `ky5qo_session`

  WHERE `session_id` = 'ed7aa51b22e360718e08333f812e7cc0' 
  LIMIT 1

Explain

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` = 'ed7aa51b22e360718' at line 1

Profile

Status	Duration
starting	0.13 ms
Executing hook on transaction	0.01 ms
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.08 ms
init	0.02 ms
System lock	0.05 ms
optimizing	0.01 ms
statistics	0.07 ms
executing	0.01 ms
end	0.01 ms
query end	0.04 ms
waiting for handler commit	0.01 ms
closing tables	0.10 ms
freeing items	0.07 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
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:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 10.82 ms After last query: 0.09 ms Query memory: 0.004 MB Memory before query: 3.591 MB

INSERT INTO `ky5qo_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('ed7aa51b22e360718e08333f812e7cc0', 1, 1768744138, 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `ky5qo_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('ed7aa51b22e360718e08333f812e7cc0', 1, 1768744138, 0, '', 0)

Profile

Status	Duration
starting	0.11 ms
Executing hook on transaction	0.01 ms
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.12 ms
init	0.01 ms
System lock	0.05 ms
update	0.11 ms
end	0.01 ms
query end	0.06 ms
waiting for handler commit	10.00 ms
closing tables	0.16 ms
freeing items	0.07 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
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:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 4.50 ms After last query: 5.29 ms Query memory: 0.005 MB Memory before query: 4.181 MB Rows returned: 4

SELECT id, rules

  FROM `ky5qo_viewlevels`

Explain

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

Profile

Status	Duration
starting	0.16 ms
Executing hook on transaction	0.01 ms
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	3.78 ms
init	0.01 ms
System lock	0.04 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.04 ms
executing	0.06 ms
end	0.01 ms
query end	0.04 ms
waiting for handler commit	0.01 ms
closing tables	0.09 ms
freeing items	0.09 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
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:321
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 4.41 ms After last query: 0.10 ms Query memory: 0.005 MB Memory before query: 4.193 MB Rows returned: 2

SELECT b.id

  FROM ky5qo_usergroups AS a

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

  WHERE a.id = 9

Explain

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

Profile

Status	Duration
starting	0.11 ms
Executing hook on transaction	0.01 ms
starting	0.04 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	3.63 ms
init	0.02 ms
System lock	0.04 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.06 ms
executing	0.02 ms
end	0.01 ms
query end	0.04 ms
waiting for handler commit	0.01 ms
closing tables	0.18 ms
freeing items	0.08 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
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:321
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 4.58 ms After last query: 21.25 ms Query memory: 0.005 MB Memory before query: 5.862 MB Rows returned: 0

SELECT `state`,`rule_type`

  FROM `ky5qo_jhackguard_ip_filters`

  WHERE `ip` = '18.97.14.88' 
  AND `state` = 1

  ORDER BY ordering ASC

Explain

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 `state`,`rule_type` FROM `#__jhackguard_ip_filters` WHERE `ip` = '18.9' at line 1

Profile

Status	Duration
starting	0.21 ms
Executing hook on transaction	0.02 ms
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	3.70 ms
init	0.02 ms
System lock	0.13 ms
optimizing	0.03 ms
statistics	0.10 ms
preparing	0.04 ms
executing	0.01 ms
end	0.00 ms
query end	0.04 ms
closing tables	0.09 ms
freeing items	0.07 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
10	JDatabaseDriver->loadObject()	JROOT/plugins/system/jhackguard/jhackguard.php:358
9	PlgSystemJhackguard->ip_is()	JROOT/plugins/system/jhackguard/jhackguard.php:174
8	PlgSystemJhackguard->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:626
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 16.29 ms After last query: 15.15 ms Query memory: 0.008 MB Memory before query: 7.402 MB

UPDATE `ky5qo_extensions`

  SET `params` = '{\"mediaversion\":\"9c32b720981f7e32cc88f02a14ce6cc5\"}'

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

Explain

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\":\"9c32b720981f7e32cc' at line 1

Profile

Status	Duration
starting	0.20 ms
Executing hook on transaction	0.01 ms
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	3.56 ms
init	0.02 ms
System lock	0.11 ms
updating	0.12 ms
end	0.01 ms
query end	0.03 ms
waiting for handler commit	11.69 ms
closing tables	0.23 ms
freeing items	0.17 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
17	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
16	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
15	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
14	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
13	Joomla\CMS\Factory::getDocument()	JROOT/libraries/cms/html/behavior.php:359
12	JHtmlBehavior::modal()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
10	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
9	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/plugins/system/k2/k2.php:41
8	plgSystemK2->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:1122
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 19.36 ms After last query: 25.55 ms Query memory: 0.006 MB Memory before query: 9.176 MB Rows returned: 3

SELECT a.filename as filename, a.type as type, a.menulink as menulink 
  FROM ky5qo_phocagallery_styles AS a 
  WHERE a.published = 1 
  ORDER BY a.type, a.ordering ASC

Explain

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.filename as filename, a.type as type, a.menulink as menulink FROM ky5qo' at line 1

Profile

Status	Duration
starting	0.40 ms
Executing hook on transaction	0.02 ms
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	16.61 ms
init	0.04 ms
System lock	0.05 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.11 ms
executing	1.02 ms
end	0.02 ms
query end	0.06 ms
waiting for handler commit	0.02 ms
closing tables	0.66 ms
freeing items	0.13 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_phocagallery/libraries/phocagallery/render/renderfront.php:722
11	PhocaGalleryRenderFront::renderAllCSS()	JROOT/components/com_phocagallery/views/category/view.html.php:63
10	PhocaGalleryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocagallery/controller.php:30
8	PhocaGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocagallery/phocagallery.php:56
6	require_once JROOT/components/com_phocagallery/phocagallery.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 17.65 ms After last query: 2.75 ms Query memory: 0.007 MB Memory before query: 9.234 MB Rows returned: 0

SELECT a.* 
  FROM ky5qo_phocagallery_fb_users AS a 
  WHERE a.id =0

Explain

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.* FROM #__phocagallery_fb_users AS a WHERE a.id =0' at line 1

Profile

Status	Duration
starting	0.27 ms
Executing hook on transaction	0.01 ms
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	15.12 ms
init	0.04 ms
System lock	0.04 ms
optimizing	0.01 ms
statistics	0.99 ms
executing	0.03 ms
end	0.01 ms
query end	0.04 ms
waiting for handler commit	0.01 ms
closing tables	0.76 ms
freeing items	0.13 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
13	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_phocagallery/libraries/phocagallery/facebook/fbsystem.php:46
12	PhocaGalleryFbSystem::getFbUserInfo()	JROOT/administrator/components/com_phocagallery/libraries/phocagallery/facebook/fbsystem.php:53
11	PhocaGalleryFbSystem::getCommentsParams()	JROOT/components/com_phocagallery/views/category/view.html.php:203
10	PhocaGalleryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocagallery/controller.php:30
8	PhocaGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocagallery/phocagallery.php:56
6	require_once JROOT/components/com_phocagallery/phocagallery.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 33.57 ms After last query: 1.63 ms Query memory: 0.007 MB Memory before query: 9.397 MB Rows returned: 1

SELECT c.id, c.title, c.alias, c.description, c.published, c.approved, c.parent_id, c.deleteuserid, c.accessuserid, c.uploaduserid, c.access, c.metakey, c.metadesc, c.latitude, c.longitude, c.zoom, c.geotitle, c.userfolder, 
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug  
  FROM ky5qo_phocagallery_categories AS c 
  WHERE c.id = 7 
  LIMIT 0, 1

Explain

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.title, c.alias, c.description, c.published, c.approved, c.parent_' at line 1

Profile

Status	Duration
starting	0.26 ms
Executing hook on transaction	0.01 ms
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	29.88 ms
init	0.06 ms
System lock	0.08 ms
optimizing	0.03 ms
statistics	1.10 ms
preparing	0.09 ms
executing	0.04 ms
end	0.01 ms
query end	0.04 ms
waiting for handler commit	0.01 ms
closing tables	1.59 ms
freeing items	0.20 ms
cleaning up	0.04 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
14	JDatabaseDriver->loadObject()	JROOT/components/com_phocagallery/models/category.php:212
13	PhocagalleryModelCategory->_loadCategory()	JROOT/components/com_phocagallery/models/category.php:169
12	PhocagalleryModelCategory->getCategory()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_phocagallery/views/category/view.html.php:374
10	PhocaGalleryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocagallery/controller.php:30
8	PhocaGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocagallery/phocagallery.php:56
6	require_once JROOT/components/com_phocagallery/phocagallery.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.39 ms After last query: 0.17 ms Query memory: 0.006 MB Memory before query: 9.407 MB Rows returned: 1

SELECT * 
  FROM ky5qo_phocagallery_categories AS c 
  WHERE c.id = 4 
  AND c.published = 1

Explain

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 * FROM #__phocagallery_categories AS c WHERE c.id = 4 AND c.published ' at line 1

Profile

Status	Duration
starting	0.26 ms
Executing hook on transaction	0.01 ms
starting	0.05 ms
checking permissions	0.02 ms
Opening tables	0.43 ms
init	0.02 ms
System lock	0.04 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.05 ms
executing	0.03 ms
end	0.01 ms
query end	0.04 ms
waiting for handler commit	0.01 ms
closing tables	0.11 ms
freeing items	0.13 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_phocagallery/views/category/view.html.php:2071
11	PhocaGalleryViewCategory->_addBreadCrumbs()	JROOT/components/com_phocagallery/views/category/view.html.php:424
10	PhocaGalleryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocagallery/controller.php:30
8	PhocaGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocagallery/phocagallery.php:56
6	require_once JROOT/components/com_phocagallery/phocagallery.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.22 ms After last query: 3.12 ms Query memory: 0.007 MB Memory before query: 9.506 MB Rows returned: 1

SELECT cc.id, cc.title, cc.alias, cc.published, cc.approved, cc.parent_id, cc.deleteuserid, cc.accessuserid, cc.uploaduserid, cc.access 
  FROM ky5qo_phocagallery_categories AS cc 
  WHERE cc.id = 4 
  AND cc.published = 1 
  AND cc.approved = 1 
  AND cc.id <> 7 
  ORDER BY cc.ordering ASC 
  LIMIT 0, 1

Explain

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 cc.id, cc.title, cc.alias, cc.published, cc.approved, cc.parent_id, cc.de' at line 1

Profile

Status	Duration
starting	0.21 ms
Executing hook on transaction	0.01 ms
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.10 ms
init	0.01 ms
System lock	0.04 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.22 ms
executing	0.03 ms
end	0.01 ms
query end	0.05 ms
waiting for handler commit	0.01 ms
closing tables	0.23 ms
freeing items	0.11 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
13	JDatabaseDriver->loadObject()	JROOT/components/com_phocagallery/models/category.php:240
12	PhocagalleryModelCategory->getParentCategory()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_phocagallery/views/category/view.html.php:569
10	PhocaGalleryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocagallery/controller.php:30
8	PhocaGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocagallery/phocagallery.php:56
6	require_once JROOT/components/com_phocagallery/phocagallery.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 27.91 ms After last query: 0.07 ms Query memory: 0.007 MB Memory before query: 9.515 MB Rows returned: 0

SELECT cc.id, cc.title, cc.alias, cc.published, cc.approved, cc.parent_id, cc.deleteuserid, cc.accessuserid, cc.uploaduserid, cc.access, a.filename, a.extm, a.exts, a.extw, a.exth, a.extid 
  FROM ky5qo_phocagallery_categories AS cc 
  LEFT JOIN ky5qo_phocagallery AS a 
  ON cc.id = a.catid 
  WHERE cc.parent_id = 7 
  AND cc.published = 1 
  AND cc.approved = 1 
  AND cc.id <> 7 
  AND cc.language IN ('en-GB','*') 
  GROUP BY cc.id 
  ORDER BY cc.ordering ASC

Explain

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 cc.id, cc.title, cc.alias, cc.published, cc.approved, cc.parent_id, cc.de' at line 1

Profile

Status	Duration
starting	0.24 ms
Executing hook on transaction	0.01 ms
starting	0.04 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	25.17 ms
init	0.06 ms
System lock	0.05 ms
optimizing	0.03 ms
statistics	0.11 ms
preparing	0.03 ms
Creating tmp table	0.13 ms
executing	0.07 ms
end	0.01 ms
query end	0.04 ms
waiting for handler commit	0.02 ms
closing tables	1.65 ms
freeing items	0.16 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_phocagallery/models/category.php:282
12	PhocagalleryModelCategory->getSubCategory()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_phocagallery/views/category/view.html.php:727
10	PhocaGalleryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocagallery/controller.php:30
8	PhocaGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocagallery/phocagallery.php:56
6	require_once JROOT/components/com_phocagallery/phocagallery.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 13.65 ms After last query: 0.18 ms Query memory: 0.007 MB Memory before query: 9.521 MB Rows returned: 4

SELECT a.*, cc.alias AS catalias, cc.accessuserid AS cataccessuserid, cc.access AS cataccess, 
  CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug 
  FROM ky5qo_phocagallery AS a 
  LEFT JOIN ky5qo_phocagallery_img_votes_statistics AS r 
  ON r.imgid = a.id 
  LEFT JOIN ky5qo_phocagallery_categories AS cc 
  ON cc.id = a.catid 
  WHERE  a.language IN ('en-GB','*') 
  AND  a.catid= 7 
  AND a.published = 1 
  AND a.approved = 1 
  ORDER BY a.ordering ASC 
  LIMIT 0, 20

Explain

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.*, cc.alias AS catalias, cc.accessuserid AS cataccessuserid, cc.access ' at line 1

Profile

Status	Duration
starting	0.34 ms
Executing hook on transaction	0.02 ms
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	9.46 ms
init	0.04 ms
System lock	0.04 ms
optimizing	0.02 ms
statistics	1.19 ms
preparing	0.04 ms
Creating tmp table	0.22 ms
executing	1.33 ms
end	0.02 ms
query end	0.04 ms
waiting for handler commit	0.02 ms
closing tables	0.56 ms
freeing items	0.13 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_phocagallery/models/category.php:67
11	PhocagalleryModelCategory->getData()	JROOT/components/com_phocagallery/views/category/view.html.php:944
10	PhocaGalleryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocagallery/controller.php:30
8	PhocaGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocagallery/phocagallery.php:56
6	require_once JROOT/components/com_phocagallery/phocagallery.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.64 ms After last query: 1.61 ms Query memory: 0.007 MB Memory before query: 9.635 MB Rows returned: 4

SELECT a.*, cc.alias AS catalias, cc.accessuserid AS cataccessuserid, cc.access AS cataccess, 
  CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug 
  FROM ky5qo_phocagallery AS a 
  LEFT JOIN ky5qo_phocagallery_img_votes_statistics AS r 
  ON r.imgid = a.id 
  LEFT JOIN ky5qo_phocagallery_categories AS cc 
  ON cc.id = a.catid 
  WHERE  a.language IN ('en-GB','*') 
  AND  a.catid= 7 
  AND a.published = 1 
  AND a.approved = 1 
  ORDER BY a.ordering ASC

Explain

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.*, cc.alias AS catalias, cc.accessuserid AS cataccessuserid, cc.access ' at line 1

Profile

Status	Duration
starting	0.30 ms
Executing hook on transaction	0.01 ms
starting	0.04 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.29 ms
init	0.01 ms
System lock	0.04 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.02 ms
Creating tmp table	0.15 ms
executing	0.17 ms
end	0.01 ms
query end	0.05 ms
waiting for handler commit	0.02 ms
closing tables	0.24 ms
freeing items	0.09 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:353
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/components/com_phocagallery/models/category.php:75
12	PhocagalleryModelCategory->getTotal()	JROOT/components/com_phocagallery/models/category.php:83
11	PhocagalleryModelCategory->getPagination()	JROOT/components/com_phocagallery/views/category/view.html.php:945
10	PhocaGalleryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocagallery/controller.php:30
8	PhocaGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocagallery/phocagallery.php:56
6	require_once JROOT/components/com_phocagallery/phocagallery.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 4.76 ms After last query: 10.50 ms Query memory: 0.009 MB Memory before query: 10.050 MB Rows returned: 39

SHOW FULL COLUMNS 
  FROM `ky5qo_phocagallery_categories`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `ky5qo_phocagallery_categories`

Profile

Status	Duration
starting	0.29 ms
Executing hook on transaction	0.02 ms
starting	0.25 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	1.72 ms
init	0.03 ms
System lock	0.05 ms
optimizing	0.03 ms
statistics	0.15 ms
preparing	0.03 ms
Creating tmp table	0.10 ms
executing	0.12 ms
checking permissions	0.12 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.04 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.04 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.08 ms
end	0.01 ms
query end	0.07 ms
waiting for handler commit	0.02 ms
closing tables	0.73 ms
freeing items	0.12 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
15	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
14	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_phocagallery/tables/phocagalleryc.php:16
13	TablePhocaGalleryc->__construct()	JROOT/libraries/src/Table/Table.php:312
12	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_phocagallery/models/category.php:542
11	PhocagalleryModelCategory->hit()	JROOT/components/com_phocagallery/views/category/view.html.php:1874
10	PhocaGalleryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocagallery/controller.php:30
8	PhocaGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocagallery/phocagallery.php:56
6	require_once JROOT/components/com_phocagallery/phocagallery.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 10.09 ms After last query: 0.98 ms Query memory: 0.007 MB Memory before query: 10.133 MB

UPDATE ky5qo_phocagallery_categories

  SET `hits` = (`hits` + 1)

  WHERE `id` = '7'

Explain

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 #__phocagallery_categories SET `hits` = (`hits` + 1) WHERE `id` = '7'' at line 1

Profile

Status	Duration
starting	0.21 ms
Executing hook on transaction	0.01 ms
starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.11 ms
init	0.01 ms
System lock	0.09 ms
updating	0.13 ms
end	0.01 ms
query end	0.04 ms
waiting for handler commit	8.80 ms
closing tables	0.14 ms
freeing items	0.10 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1245
12	Joomla\CMS\Table\Table->hit()	JROOT/components/com_phocagallery/models/category.php:543
11	PhocagalleryModelCategory->hit()	JROOT/components/com_phocagallery/views/category/view.html.php:1874
10	PhocaGalleryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocagallery/controller.php:30
8	PhocaGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocagallery/phocagallery.php:56
6	require_once JROOT/components/com_phocagallery/phocagallery.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 6.08 ms After last query: 5534.84 ms Query memory: 0.004 MB Memory before query: 11.654 MB Rows returned: 0

SELECT `name`,`regex`,`replacement`

  FROM `ky5qo_jhackguard_output_filters`

  WHERE `state` = 1

  ORDER BY ordering ASC

Explain

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 `name`,`regex`,`replacement` FROM `#__jhackguard_output_filters` WHERE' at line 1

Profile

Status	Duration
starting	0.44 ms
Executing hook on transaction	0.03 ms
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	4.68 ms
init	0.04 ms
System lock	0.13 ms
optimizing	0.03 ms
statistics	0.10 ms
executing	0.09 ms
end	0.01 ms
query end	0.04 ms
closing tables	0.13 ms
freeing items	0.11 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
8	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jhackguard/jhackguard.php:91
7	PlgSystemJhackguard->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:1050
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

17 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

2 × SELECT a.*, cc.alias AS catalias, cc.accessuserid AS cataccessuserid, cc.access AS cataccess, 
  CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug 
  FROM ky5qo_phocagallery AS a 
  LEFT JOIN ky5qo_phocagallery_img_votes_statistics AS r 
  ON r.imgid = a.id 
  LEFT JOIN ky5qo_phocagallery_categories AS cc 
  ON cc.id = a.catid

1 × SELECT `data` 
  FROM `ky5qo_session`

1 × SELECT `session_id` 
  FROM `ky5qo_session`

1 × SELECT id, rules 
  FROM `ky5qo_viewlevels

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

1 × SELECT `state`,`rule_type` 
  FROM `ky5qo_jhackguard_ip_filters`

1 × SELECT a.filename as filename, a.type as type, a.menulink as menulink 
  FROM ky5qo_phocagallery_styles AS a

1 × SELECT a.* 
  FROM ky5qo_phocagallery_fb_users AS a

1 × SELECT c.id, c.title, c.alias, c.description, c.published, c.approved, c.parent_id, c.deleteuserid, c.accessuserid, c.uploaduserid, c.access, c.metakey, c.metadesc, c.latitude, c.longitude, c.zoom, c.geotitle, c.userfolder, 
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug  
  FROM ky5qo_phocagallery_categories AS c

1 × SELECT * 
  FROM ky5qo_phocagallery_categories AS c

1 × SELECT cc.id, cc.title, cc.alias, cc.published, cc.approved, cc.parent_id, cc.deleteuserid, cc.accessuserid, cc.uploaduserid, cc.access 
  FROM ky5qo_phocagallery_categories AS cc

1 × SELECT cc.id, cc.title, cc.alias, cc.published, cc.approved, cc.parent_id, cc.deleteuserid, cc.accessuserid, cc.uploaduserid, cc.access, a.filename, a.extm, a.exts, a.extw, a.exth, a.extid 
  FROM ky5qo_phocagallery_categories AS cc 
  LEFT JOIN ky5qo_phocagallery AS a 
  ON cc.id = a.catid

1 × SELECT `name`,`regex`,`replacement` 
  FROM `ky5qo_jhackguard_output_filters`

OTHER Tables:

1 × INSERT INTO `ky5qo_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('ed7aa51b22e360718e08333f812e7cc0', 1, 1768744138, 0, '', 0

1 × UPDATE `ky5qo_extensions` 
  SET `params` = '{\"mediaversion\":\"9c32b720981f7e32cc88f02a14ce6cc5\"}'

1 × SHOW FULL COLUMNS 
  FROM `ky5qo_phocagallery_categories

1 × UPDATE ky5qo_phocagallery_categories 
  SET `hits` = (`hits` + 1)

Quick Contact

Certificates

Contact Us

Unit 10, No. 232, Zafar st., 19186 33764, Tehran - Iran.

Tel: +98 21 2226 1030

Fax: +98 21 2226 6004

Email: info@stanahita.com

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

18 Queries Logged 181.13 ms

17 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: