Gulf Coast Pet Resort

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1702290209,
                "last": 1702290209,
                "now": 1702290209
            },
            "token": "zAdgHiNvCX8rNyXGwcSd7R5aVYSqHrUc"
        },
        "registry": {
            "plg_system_eprivacygeoip_cache": {
                "cc": "US",
                "abbr": "USA",
                "name": "United States"
            },
            "plg_chtrack": {
                "referer": "",
                "referer_first_visit": null,
                "first_visit_date": "2023-12-11",
                "gclid": null,
                "gclid_first_visit": null,
                "aid": null,
                "aid_first_visit": null,
                "said": null,
                "said_first_visit": null,
                "utm_source": null,
                "utm_source_first_visit": null,
                "utm_medium": null,
                "utm_medium_first_visit": null,
                "utm_term": null,
                "utm_term_first_visit": null,
                "utm_content": null,
                "utm_content_first_visit": null,
                "utm_campaign": null,
                "utm_campaign_first_visit": null
            },
            "plg_system_eprivacy_non_eu": false,
            "chclient": {
                "start_date": "2023-12-11",
                "end_date": "2023-12-12",
                "party": "[{\"adults\":2,\"children\":[]}]"
            }
        },
        "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
        },
        "plg_system_languagefilter": {
            "language": "en-US"
        }
    }
}

Profile Information

Time

Memory

Time: 16.74 ms / 16.74 ms Memory: 2.018 MB / 2.40 MB Application: afterLoad

Time: 178.51 ms / 195.24 ms Memory: 31.507 MB / 33.91 MB Application: afterInitialise

Time: 22.37 ms / 217.61 ms Memory: 2.424 MB / 36.34 MB Application: afterRoute

Time: 0.32 ms / 217.93 ms Memory: 0.018 MB / 36.35 MB Application: beforeRenderComponent com_jkit

Time: 5.78 ms / 223.71 ms Memory: 0.510 MB / 36.86 MB Application: afterRenderComponent com_jkit

Time: 7.39 ms / 231.10 ms Memory: 0.227 MB / 37.09 MB Application: afterDispatch

Time: 7.02 ms / 238.11 ms Memory: 0.298 MB / 37.39 MB Application: beforeRenderModule mod_chsearch (TOP - SEARCH)

Time: 12.55 ms / 250.67 ms Memory: 0.680 MB / 38.07 MB Application: afterRenderModule mod_chsearch (TOP - SEARCH)

Time: 0.29 ms / 250.95 ms Memory: 0.016 MB / 38.08 MB Application: beforeRenderModule mod_jkit_item (HOME - WELCOME)

Time: 7.56 ms / 258.52 ms Memory: 0.220 MB / 38.30 MB Application: afterRenderModule mod_jkit_item (HOME - WELCOME)

Time: 1.12 ms / 259.63 ms Memory: 0.008 MB / 38.31 MB Application: beforeRenderModule mod_jkit_item (HOME - FEATURED)

Time: 5.45 ms / 265.09 ms Memory: 0.088 MB / 38.40 MB Application: afterRenderModule mod_jkit_item (HOME - FEATURED)

Time: 0.63 ms / 265.72 ms Memory: -0.021 MB / 38.38 MB Application: beforeRenderModule mod_jkit_item (HOME - REVIEWS)

Time: 5.33 ms / 271.04 ms Memory: 0.133 MB / 38.51 MB Application: afterRenderModule mod_jkit_item (HOME - REVIEWS)

Time: 0.70 ms / 271.74 ms Memory: -0.048 MB / 38.46 MB Application: beforeRenderModule mod_jkit_item (HOME - COLLAGE)

Time: 5.23 ms / 276.97 ms Memory: 0.095 MB / 38.56 MB Application: afterRenderModule mod_jkit_item (HOME - COLLAGE)

Time: 0.69 ms / 277.66 ms Memory: -0.017 MB / 38.54 MB Application: beforeRenderModule mod_menu (OFFCANVAS MENU ES)

Time: 1.06 ms / 278.72 ms Memory: 0.033 MB / 38.57 MB Application: afterRenderModule mod_menu (OFFCANVAS MENU ES)

Time: 0.46 ms / 279.19 ms Memory: -0.002 MB / 38.57 MB Application: beforeRenderModule mod_menu (OFFCANVAS MENU EN)

Time: 2.09 ms / 281.28 ms Memory: 0.066 MB / 38.64 MB Application: afterRenderModule mod_menu (OFFCANVAS MENU EN)

Time: 0.52 ms / 281.81 ms Memory: -0.002 MB / 38.64 MB Application: beforeRenderModule mod_menu (MAIN MENU EN)

Time: 1.17 ms / 282.97 ms Memory: 0.007 MB / 38.64 MB Application: afterRenderModule mod_menu (MAIN MENU EN)

Time: 0.46 ms / 283.44 ms Memory: -0.002 MB / 38.64 MB Application: beforeRenderModule mod_menu (MAIN MENU ES)

Time: 0.57 ms / 284.00 ms Memory: 0.004 MB / 38.65 MB Application: afterRenderModule mod_menu (MAIN MENU ES)

Time: 0.49 ms / 284.50 ms Memory: -0.020 MB / 38.63 MB Application: beforeRenderModule mod_chmybooking (MY BOOKING)

Time: 0.62 ms / 285.12 ms Memory: 0.013 MB / 38.64 MB Application: afterRenderModule mod_chmybooking (MY BOOKING)

Time: 0.27 ms / 285.39 ms Memory: 0.018 MB / 38.66 MB Application: beforeRenderModule mod_jkit_item (HOME - SLIDESHOW)

Time: 5.25 ms / 290.64 ms Memory: 0.095 MB / 38.75 MB Application: afterRenderModule mod_jkit_item (HOME - SLIDESHOW)

Time: 16.51 ms / 307.15 ms Memory: 1.379 MB / 40.13 MB Application: afterRender

Database queries total: 37.18 ms

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josql_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	Using index

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

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

EXPLAIN not possible on query: INSERT INTO `josql_session` (`session_id`,`guest`,`time`,`userid`,`username`) VALUES (X'3066346362386166353665393662356639653739313665303163333330306633', 1, 1702290209, 0, '')

Profile

Status	Duration
starting	0.13 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
init	0.02 ms
System lock	0.02 ms
update	0.13 ms
end	0.02 ms
query end	0.02 ms
waiting for handler commit	1.30 ms
closing tables	0.03 ms
freeing items	0.09 ms
cleaning up	0.04 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:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Query Time: 1.35 ms After last query: 5.73 ms Query memory: 0.005 MB Memory before query: 4.823 MB Rows returned: 655

SELECT id, rules

  FROM `josql_viewlevels`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josql_viewlevels	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	655	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.89 ms After last query: 0.97 ms Query memory: 0.005 MB Memory before query: 5.106 MB Rows returned: 2

SELECT b.id

  FROM josql_usergroups AS a

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

  WHERE a.id = 9

Explain

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

Profile

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

Call Stack

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

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

Query Time: 1.85 ms After last query: 150.61 ms Query memory: 0.006 MB Memory before query: 34.523 MB

UPDATE `josql_extensions`

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

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

Explain

EXPLAIN not possible on query: UPDATE `josql_extensions` SET `params` = '{\"mediaversion\":\"2c72d49a409577ea6148d7bdcb6ee483\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profile

Status	Duration
starting	0.20 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	0.06 ms
init	0.02 ms
System lock	0.10 ms
updating	0.09 ms
end	0.02 ms
query end	0.01 ms
waiting for handler commit	0.95 ms
closing tables	0.03 ms
freeing items	0.09 ms
cleaning up	0.07 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
14	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
13	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
12	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
11	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
10	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/eprivacy/eprivacy.php:391
9	plgSystemePrivacy->_exitEarly()	JROOT/plugins/system/eprivacy/eprivacy.php:64
8	plgSystemePrivacy->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.76 ms After last query: 4.51 ms Query memory: 0.007 MB Memory before query: 35.164 MB Rows returned: 48

SELECT * 
  FROM josql_acysms_config

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josql_acysms_config	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	48	100.00	NULL

Profile

Status	Duration
starting	0.12 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.03 ms
executing	0.26 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acysms/classes/cpanel.php:17
12	ACYSMScpanelClass->load()	JROOT/administrator/components/com_acysms/helpers/helper.php:265
11	ACYSMS::config()	JROOT/administrator/components/com_acysms/helpers/helper.php:774
10	include_once JROOT/administrator/components/com_acysms/helpers/helper.php	JROOT/plugins/system/acysmsverifnumber/acysmsverifnumber.php:30
9	plgSystemAcySMSVerifNumber->init()	JROOT/plugins/system/acysmsverifnumber/acysmsverifnumber.php:48
8	plgSystemAcySMSVerifNumber->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.89 ms After last query: 13.43 ms Query memory: 0.005 MB Memory before query: 36.876 MB Rows returned: 3

SELECT language,id

  FROM `josql_menu`

  WHERE home = 1 
  AND published = 1 
  AND client_id = 0

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josql_menu	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	45	1.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
8	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
7	PlgSystemLanguageFilter->onAfterDispatch()	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/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.86 ms After last query: 1.55 ms Query memory: 0.005 MB Memory before query: 36.975 MB Rows returned: 0

SELECT `c2`.`language`,`c2`.`id`

  FROM `josql_menu` AS `c`

  INNER JOIN `josql_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item'

  INNER JOIN `josql_associations` AS `a2` 
  ON `a`.`key` = `a2`.`key`

  INNER JOIN `josql_menu` AS `c2` 
  ON a2.id = c2.`id`

  WHERE c.id = 106

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Associations.php:115
9	Joomla\CMS\Language\Associations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:321
8	MenusHelper::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:768
7	PlgSystemLanguageFilter->onAfterDispatch()	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/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.44 ms After last query: 3.68 ms Query memory: 0.009 MB Memory before query: 37.287 MB Rows returned: 16

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM josql_modules AS m

  LEFT JOIN josql_modules_menu AS mm 
  ON mm.moduleid = m.id

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-12-11 10:23:29') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-12-11 10:23:29') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 106 OR mm.menuid <= 0) 
  AND m.language IN ('en-US','*')

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	PRIMARY,published,newsfeeds,idx_language	NO INDEX KEY COULD BE USED	NULL	NULL	46	2.17	Using where; Using filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	gulfcoa2_joom202.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	gulfcoa2_joom202.m.id	2	40.00	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	Same as call in the line below.
15	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
14	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
13	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
12	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
11	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
10	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/splash/helpers/chtheme.php:63
9	CHTheme::init()	JROOT/templates/splash/helpers/init.php:17
8	require_once JROOT/templates/splash/helpers/init.php	JROOT/templates/splash/index.php:12
7	require JROOT/templates/splash/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.57 ms After last query: 10.42 ms Query memory: 0.007 MB Memory before query: 37.751 MB Rows returned: 1

SELECT config 
  FROM josql_chclient_config AS a 
  WHERE a.id = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	PRIMARY	PRIMARY	1	const	1	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/components/com_chclient/helpers/chclient.php:92
13	CHClient::getConfig()	JROOT/components/com_chclient/helpers/chclient.php:519
12	CHClient::chassets()	JROOT/templates/chthemes/html/mod_chsearch/theme-top-search.php:11
11	require JROOT/templates/chthemes/html/mod_chsearch/theme-top-search.php	JROOT/modules/mod_chsearch/mod_chsearch.php:29
10	include JROOT/modules/mod_chsearch/mod_chsearch.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.70 ms After last query: 2.15 ms Query memory: 0.008 MB Memory before query: 37.962 MB Rows returned: 5

SELECT a.id, a.link, a.language, a.params 
  FROM josql_menu AS a 
  WHERE a.component_id = 10017 
  AND a.client_id = 0 
  AND a.type = 'component' 
  AND a.published = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_client_id_parent_id_alias_language,idx_componentid	idx_componentid	4	const	10	0.74	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_chclient/helpers/route.php:95
14	CHClientRoute::menuItems()	JROOT/components/com_chclient/helpers/route.php:56
13	CHClientRoute::menuItemid()	JROOT/components/com_chclient/helpers/route.php:33
12	CHClientRoute::viewUrl()	JROOT/templates/chthemes/html/mod_chsearch/theme-top-search.php:16
11	require JROOT/templates/chthemes/html/mod_chsearch/theme-top-search.php	JROOT/modules/mod_chsearch/mod_chsearch.php:29
10	include JROOT/modules/mod_chsearch/mod_chsearch.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.88 ms After last query: 4.80 ms Query memory: 0.007 MB Memory before query: 38.262 MB Rows returned: 1

SELECT a.*,c.title AS category, c.alias AS category_alias,u.title AS user, u.alias AS user_alias, u.info AS user_info

  FROM josql_jkit_items AS a

  LEFT JOIN josql_jkit_categories AS c 
  ON c.id = a.category_id

  LEFT JOIN josql_jkit_users AS u 
  ON u.id = a.user_id

  WHERE a.id = 26 
  AND a.state = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	PRIMARY,idx_state	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	u	NULL	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/components/com_jkit/helpers/model/item.php:53
14	JKitModelItem->getItem()	JROOT/modules/mod_jkit_item/mod_jkit_item.php:29
13	include JROOT/modules/mod_jkit_item/mod_jkit_item.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:606
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.91 ms After last query: 0.10 ms Query memory: 0.007 MB Memory before query: 38.281 MB Rows returned: 0

SELECT *

  FROM josql_jkit_images

  WHERE item_id = 26 
  AND state = 1

  ORDER BY ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josql_jkit_images	NULL	index_merge	idx_item_id,idx_state	idx_item_id,idx_state	4,1	NULL	1	100.00	Using intersect(idx_item_id,idx_state); Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jkit/helpers/model/item.php:79
14	JKitModelItem->getItem()	JROOT/modules/mod_jkit_item/mod_jkit_item.php:29
13	include JROOT/modules/mod_jkit_item/mod_jkit_item.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:606
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.68 ms After last query: 0.06 ms Query memory: 0.007 MB Memory before query: 38.291 MB Rows returned: 0

SELECT a.id, a.title, a.alias

  FROM josql_jkit_tags AS a

  INNER JOIN josql_jkit_tags_item AS t 
  ON t.tag_id = a.id

  WHERE a.state = 1 
  AND t.item_id = 26

  ORDER BY a.id

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t	NULL	index	PRIMARY	PRIMARY	8	NULL	5	20.00	Using where; Using index; Using temporary; Using filesort
1	SIMPLE	a	NULL	eq_ref	PRIMARY,idx_state	PRIMARY	4	gulfcoa2_joom202.t.tag_id	1	93.75	Using where

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jkit/helpers/model/item.php:99
14	JKitModelItem->getItem()	JROOT/modules/mod_jkit_item/mod_jkit_item.php:29
13	include JROOT/modules/mod_jkit_item/mod_jkit_item.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:606
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.58 ms After last query: 0.08 ms Query memory: 0.007 MB Memory before query: 38.300 MB Rows returned: 0

SELECT *

  FROM josql_jkit_translations

  WHERE ref_table = 'items' 
  AND lang = 'en-US' 
  AND ref_id = 26

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josql_jkit_translations	NULL	ref	idx_ref_table,idx_ref_id,idx_lang	idx_ref_id	4	const	1	6.67	Using where

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/components/com_jkit/helpers/model/item.php:108
14	JKitModelItem->getItem()	JROOT/modules/mod_jkit_item/mod_jkit_item.php:29
13	include JROOT/modules/mod_jkit_item/mod_jkit_item.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:606
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.57 ms After last query: 0.06 ms Query memory: 0.007 MB Memory before query: 38.310 MB Rows returned: 0

Duplicate queries: #23 #30 #37 #44

SELECT *

  FROM josql_jkit_translations

  WHERE ref_table = 'categories' 
  AND lang = 'en-US' 
  AND ref_id = 3

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josql_jkit_translations	NULL	ref	idx_ref_table,idx_ref_id,idx_lang	idx_ref_table	767	const	1	6.67	Using where

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/components/com_jkit/helpers/model/item.php:120
14	JKitModelItem->getItem()	JROOT/modules/mod_jkit_item/mod_jkit_item.php:29
13	include JROOT/modules/mod_jkit_item/mod_jkit_item.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:606
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.51 ms After last query: 0.04 ms Query memory: 0.008 MB Memory before query: 38.319 MB Rows returned: 1

SELECT COUNT(`user_id`) 
  FROM `josql_jkit_like` 
  WHERE `item_id` = 26

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josql_jkit_like	NULL	ref	item_id	item_id	4	const	1	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/components/com_jkit/helpers/model/item.php:166
14	JKitModelItem->getItem()	JROOT/modules/mod_jkit_item/mod_jkit_item.php:29
13	include JROOT/modules/mod_jkit_item/mod_jkit_item.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:606
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.78 ms After last query: 0.04 ms Query memory: 0.007 MB Memory before query: 38.327 MB Rows returned: 1

SELECT COUNT(`user_id`) 
  FROM `josql_jkit_comments` 
  WHERE `state` = 1 
  AND `parent_id` = 0 
  AND `item_id` = 26

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josql_jkit_comments	NULL	index_merge	idx_item_id,idx_state	idx_item_id,idx_state	4,1	NULL	1	10.00	Using intersect(idx_item_id,idx_state); Using where

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/components/com_jkit/helpers/model/item.php:167
14	JKitModelItem->getItem()	JROOT/modules/mod_jkit_item/mod_jkit_item.php:29
13	include JROOT/modules/mod_jkit_item/mod_jkit_item.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:606
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.77 ms After last query: 1.50 ms Query memory: 0.007 MB Memory before query: 38.340 MB Rows returned: 1

SELECT a.*,c.title AS category, c.alias AS category_alias,u.title AS user, u.alias AS user_alias, u.info AS user_info

  FROM josql_jkit_items AS a

  LEFT JOIN josql_jkit_categories AS c 
  ON c.id = a.category_id

  LEFT JOIN josql_jkit_users AS u 
  ON u.id = a.user_id

  WHERE a.id = 17 
  AND a.state = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	PRIMARY,idx_state	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	u	NULL	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/components/com_jkit/helpers/model/item.php:53
14	JKitModelItem->getItem()	JROOT/modules/mod_jkit_item/mod_jkit_item.php:29
13	include JROOT/modules/mod_jkit_item/mod_jkit_item.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:606
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.92 ms After last query: 0.09 ms Query memory: 0.007 MB Memory before query: 38.358 MB Rows returned: 4

SELECT *

  FROM josql_jkit_images

  WHERE item_id = 17 
  AND state = 1

  ORDER BY ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josql_jkit_images	NULL	index_merge	idx_item_id,idx_state	idx_item_id,idx_state	4,1	NULL	3	86.32	Using intersect(idx_item_id,idx_state); Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jkit/helpers/model/item.php:79
14	JKitModelItem->getItem()	JROOT/modules/mod_jkit_item/mod_jkit_item.php:29
13	include JROOT/modules/mod_jkit_item/mod_jkit_item.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:606
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.57 ms After last query: 0.14 ms Query memory: 0.007 MB Memory before query: 38.382 MB Rows returned: 0

SELECT a.id, a.title, a.alias

  FROM josql_jkit_tags AS a

  INNER JOIN josql_jkit_tags_item AS t 
  ON t.tag_id = a.id

  WHERE a.state = 1 
  AND t.item_id = 17

  ORDER BY a.id

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t	NULL	index	PRIMARY	PRIMARY	8	NULL	5	20.00	Using where; Using index; Using temporary; Using filesort
1	SIMPLE	a	NULL	eq_ref	PRIMARY,idx_state	PRIMARY	4	gulfcoa2_joom202.t.tag_id	1	93.75	Using where

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jkit/helpers/model/item.php:99
14	JKitModelItem->getItem()	JROOT/modules/mod_jkit_item/mod_jkit_item.php:29
13	include JROOT/modules/mod_jkit_item/mod_jkit_item.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:606
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.54 ms After last query: 0.06 ms Query memory: 0.007 MB Memory before query: 38.392 MB Rows returned: 0

SELECT *

  FROM josql_jkit_translations

  WHERE ref_table = 'items' 
  AND lang = 'en-US' 
  AND ref_id = 17

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josql_jkit_translations	NULL	ref	idx_ref_table,idx_ref_id,idx_lang	idx_ref_id	4	const	1	6.67	Using where

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/components/com_jkit/helpers/model/item.php:108
14	JKitModelItem->getItem()	JROOT/modules/mod_jkit_item/mod_jkit_item.php:29
13	include JROOT/modules/mod_jkit_item/mod_jkit_item.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:606
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.48 ms After last query: 0.05 ms Query memory: 0.007 MB Memory before query: 38.401 MB Rows returned: 0

Duplicate queries: #16 #30 #37 #44

SELECT *

  FROM josql_jkit_translations

  WHERE ref_table = 'categories' 
  AND lang = 'en-US' 
  AND ref_id = 3

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josql_jkit_translations	NULL	ref	idx_ref_table,idx_ref_id,idx_lang	idx_ref_table	767	const	1	6.67	Using where

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/components/com_jkit/helpers/model/item.php:120
14	JKitModelItem->getItem()	JROOT/modules/mod_jkit_item/mod_jkit_item.php:29
13	include JROOT/modules/mod_jkit_item/mod_jkit_item.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:606
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.42 ms After last query: 0.08 ms Query memory: 0.007 MB Memory before query: 38.408 MB Rows returned: 1

SELECT COUNT(`user_id`) 
  FROM `josql_jkit_like` 
  WHERE `item_id` = 17

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josql_jkit_like	NULL	ref	item_id	item_id	4	const	1	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/components/com_jkit/helpers/model/item.php:166
14	JKitModelItem->getItem()	JROOT/modules/mod_jkit_item/mod_jkit_item.php:29
13	include JROOT/modules/mod_jkit_item/mod_jkit_item.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:606
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.85 ms After last query: 0.03 ms Query memory: 0.007 MB Memory before query: 38.415 MB Rows returned: 1

SELECT COUNT(`user_id`) 
  FROM `josql_jkit_comments` 
  WHERE `state` = 1 
  AND `parent_id` = 0 
  AND `item_id` = 17

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josql_jkit_comments	NULL	index_merge	idx_item_id,idx_state	idx_item_id,idx_state	4,1	NULL	1	10.00	Using intersect(idx_item_id,idx_state); Using where

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/components/com_jkit/helpers/model/item.php:167
14	JKitModelItem->getItem()	JROOT/modules/mod_jkit_item/mod_jkit_item.php:29
13	include JROOT/modules/mod_jkit_item/mod_jkit_item.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:606
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.75 ms After last query: 1.08 ms Query memory: 0.007 MB Memory before query: 38.408 MB Rows returned: 1

SELECT a.*,c.title AS category, c.alias AS category_alias,u.title AS user, u.alias AS user_alias, u.info AS user_info

  FROM josql_jkit_items AS a

  LEFT JOIN josql_jkit_categories AS c 
  ON c.id = a.category_id

  LEFT JOIN josql_jkit_users AS u 
  ON u.id = a.user_id

  WHERE a.id = 19 
  AND a.state = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	PRIMARY,idx_state	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	u	NULL	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/components/com_jkit/helpers/model/item.php:53
14	JKitModelItem->getItem()	JROOT/modules/mod_jkit_item/mod_jkit_item.php:29
13	include JROOT/modules/mod_jkit_item/mod_jkit_item.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:606
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.70 ms After last query: 0.10 ms Query memory: 0.007 MB Memory before query: 38.424 MB Rows returned: 14

SELECT *

  FROM josql_jkit_images

  WHERE item_id = 19 
  AND state = 1

  ORDER BY ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josql_jkit_images	NULL	ref	idx_item_id,idx_state	idx_item_id	4	const	14	86.89	Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jkit/helpers/model/item.php:79
14	JKitModelItem->getItem()	JROOT/modules/mod_jkit_item/mod_jkit_item.php:29
13	include JROOT/modules/mod_jkit_item/mod_jkit_item.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:606
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.62 ms After last query: 0.29 ms Query memory: 0.007 MB Memory before query: 38.489 MB Rows returned: 0

SELECT a.id, a.title, a.alias

  FROM josql_jkit_tags AS a

  INNER JOIN josql_jkit_tags_item AS t 
  ON t.tag_id = a.id

  WHERE a.state = 1 
  AND t.item_id = 19

  ORDER BY a.id

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t	NULL	index	PRIMARY	PRIMARY	8	NULL	5	20.00	Using where; Using index; Using temporary; Using filesort
1	SIMPLE	a	NULL	eq_ref	PRIMARY,idx_state	PRIMARY	4	gulfcoa2_joom202.t.tag_id	1	93.75	Using where

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jkit/helpers/model/item.php:99
14	JKitModelItem->getItem()	JROOT/modules/mod_jkit_item/mod_jkit_item.php:29
13	include JROOT/modules/mod_jkit_item/mod_jkit_item.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:606
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.57 ms After last query: 0.06 ms Query memory: 0.007 MB Memory before query: 38.498 MB Rows returned: 0

SELECT *

  FROM josql_jkit_translations

  WHERE ref_table = 'items' 
  AND lang = 'en-US' 
  AND ref_id = 19

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josql_jkit_translations	NULL	ref	idx_ref_table,idx_ref_id,idx_lang	idx_ref_id	4	const	1	6.67	Using where

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/components/com_jkit/helpers/model/item.php:108
14	JKitModelItem->getItem()	JROOT/modules/mod_jkit_item/mod_jkit_item.php:29
13	include JROOT/modules/mod_jkit_item/mod_jkit_item.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:606
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.59 ms After last query: 0.05 ms Query memory: 0.007 MB Memory before query: 38.508 MB Rows returned: 0

Duplicate queries: #16 #23 #37 #44

SELECT *

  FROM josql_jkit_translations

  WHERE ref_table = 'categories' 
  AND lang = 'en-US' 
  AND ref_id = 3

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josql_jkit_translations	NULL	ref	idx_ref_table,idx_ref_id,idx_lang	idx_ref_table	767	const	1	6.67	Using where

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/components/com_jkit/helpers/model/item.php:120
14	JKitModelItem->getItem()	JROOT/modules/mod_jkit_item/mod_jkit_item.php:29
13	include JROOT/modules/mod_jkit_item/mod_jkit_item.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:606
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.46 ms After last query: 0.06 ms Query memory: 0.007 MB Memory before query: 38.515 MB Rows returned: 1

SELECT COUNT(`user_id`) 
  FROM `josql_jkit_like` 
  WHERE `item_id` = 19

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josql_jkit_like	NULL	ref	item_id	item_id	4	const	1	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/components/com_jkit/helpers/model/item.php:166
14	JKitModelItem->getItem()	JROOT/modules/mod_jkit_item/mod_jkit_item.php:29
13	include JROOT/modules/mod_jkit_item/mod_jkit_item.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:606
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.57 ms After last query: 0.08 ms Query memory: 0.007 MB Memory before query: 38.522 MB Rows returned: 1

SELECT COUNT(`user_id`) 
  FROM `josql_jkit_comments` 
  WHERE `state` = 1 
  AND `parent_id` = 0 
  AND `item_id` = 19

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josql_jkit_comments	NULL	index_merge	idx_item_id,idx_state	idx_item_id,idx_state	4,1	NULL	1	10.00	Using intersect(idx_item_id,idx_state); Using where

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/components/com_jkit/helpers/model/item.php:167
14	JKitModelItem->getItem()	JROOT/modules/mod_jkit_item/mod_jkit_item.php:29
13	include JROOT/modules/mod_jkit_item/mod_jkit_item.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:606
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.77 ms After last query: 1.18 ms Query memory: 0.009 MB Memory before query: 38.500 MB Rows returned: 1

SELECT a.*,c.title AS category, c.alias AS category_alias,u.title AS user, u.alias AS user_alias, u.info AS user_info

  FROM josql_jkit_items AS a

  LEFT JOIN josql_jkit_categories AS c 
  ON c.id = a.category_id

  LEFT JOIN josql_jkit_users AS u 
  ON u.id = a.user_id

  WHERE a.id = 27 
  AND a.state = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	PRIMARY,idx_state	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	u	NULL	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/components/com_jkit/helpers/model/item.php:53
14	JKitModelItem->getItem()	JROOT/modules/mod_jkit_item/mod_jkit_item.php:29
13	include JROOT/modules/mod_jkit_item/mod_jkit_item.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:606
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.86 ms After last query: 0.09 ms Query memory: 0.007 MB Memory before query: 38.519 MB Rows returned: 5

SELECT *

  FROM josql_jkit_images

  WHERE item_id = 27 
  AND state = 1

  ORDER BY ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josql_jkit_images	NULL	index_merge	idx_item_id,idx_state	idx_item_id,idx_state	4,1	NULL	4	92.08	Using intersect(idx_item_id,idx_state); Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jkit/helpers/model/item.php:79
14	JKitModelItem->getItem()	JROOT/modules/mod_jkit_item/mod_jkit_item.php:29
13	include JROOT/modules/mod_jkit_item/mod_jkit_item.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:606
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.58 ms After last query: 0.15 ms Query memory: 0.007 MB Memory before query: 38.545 MB Rows returned: 0

SELECT a.id, a.title, a.alias

  FROM josql_jkit_tags AS a

  INNER JOIN josql_jkit_tags_item AS t 
  ON t.tag_id = a.id

  WHERE a.state = 1 
  AND t.item_id = 27

  ORDER BY a.id

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t	NULL	index	PRIMARY	PRIMARY	8	NULL	5	20.00	Using where; Using index; Using temporary; Using filesort
1	SIMPLE	a	NULL	eq_ref	PRIMARY,idx_state	PRIMARY	4	gulfcoa2_joom202.t.tag_id	1	93.75	Using where

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jkit/helpers/model/item.php:99
14	JKitModelItem->getItem()	JROOT/modules/mod_jkit_item/mod_jkit_item.php:29
13	include JROOT/modules/mod_jkit_item/mod_jkit_item.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:606
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.51 ms After last query: 0.10 ms Query memory: 0.007 MB Memory before query: 38.554 MB Rows returned: 0

SELECT *

  FROM josql_jkit_translations

  WHERE ref_table = 'items' 
  AND lang = 'en-US' 
  AND ref_id = 27

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josql_jkit_translations	NULL	ref	idx_ref_table,idx_ref_id,idx_lang	idx_ref_id	4	const	1	6.67	Using where

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/components/com_jkit/helpers/model/item.php:108
14	JKitModelItem->getItem()	JROOT/modules/mod_jkit_item/mod_jkit_item.php:29
13	include JROOT/modules/mod_jkit_item/mod_jkit_item.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:606
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.55 ms After last query: 0.05 ms Query memory: 0.007 MB Memory before query: 38.564 MB Rows returned: 0

Duplicate queries: #16 #23 #30 #44

SELECT *

  FROM josql_jkit_translations

  WHERE ref_table = 'categories' 
  AND lang = 'en-US' 
  AND ref_id = 3

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josql_jkit_translations	NULL	ref	idx_ref_table,idx_ref_id,idx_lang	idx_ref_table	767	const	1	6.67	Using where

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/components/com_jkit/helpers/model/item.php:120
14	JKitModelItem->getItem()	JROOT/modules/mod_jkit_item/mod_jkit_item.php:29
13	include JROOT/modules/mod_jkit_item/mod_jkit_item.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:606
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.42 ms After last query: 0.03 ms Query memory: 0.007 MB Memory before query: 38.571 MB Rows returned: 1

SELECT COUNT(`user_id`) 
  FROM `josql_jkit_like` 
  WHERE `item_id` = 27

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josql_jkit_like	NULL	ref	item_id	item_id	4	const	1	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/components/com_jkit/helpers/model/item.php:166
14	JKitModelItem->getItem()	JROOT/modules/mod_jkit_item/mod_jkit_item.php:29
13	include JROOT/modules/mod_jkit_item/mod_jkit_item.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:606
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.57 ms After last query: 0.03 ms Query memory: 0.007 MB Memory before query: 38.578 MB Rows returned: 1

SELECT COUNT(`user_id`) 
  FROM `josql_jkit_comments` 
  WHERE `state` = 1 
  AND `parent_id` = 0 
  AND `item_id` = 27

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josql_jkit_comments	NULL	index_merge	idx_item_id,idx_state	idx_item_id,idx_state	4,1	NULL	1	10.00	Using intersect(idx_item_id,idx_state); Using where

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/components/com_jkit/helpers/model/item.php:167
14	JKitModelItem->getItem()	JROOT/modules/mod_jkit_item/mod_jkit_item.php:29
13	include JROOT/modules/mod_jkit_item/mod_jkit_item.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:606
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.78 ms After last query: 8.93 ms Query memory: 0.007 MB Memory before query: 38.684 MB Rows returned: 1

SELECT a.*,c.title AS category, c.alias AS category_alias,u.title AS user, u.alias AS user_alias, u.info AS user_info

  FROM josql_jkit_items AS a

  LEFT JOIN josql_jkit_categories AS c 
  ON c.id = a.category_id

  LEFT JOIN josql_jkit_users AS u 
  ON u.id = a.user_id

  WHERE a.id = 16 
  AND a.state = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	PRIMARY,idx_state	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	u	NULL	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/components/com_jkit/helpers/model/item.php:53
14	JKitModelItem->getItem()	JROOT/modules/mod_jkit_item/mod_jkit_item.php:29
13	include JROOT/modules/mod_jkit_item/mod_jkit_item.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:606
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.87 ms After last query: 0.12 ms Query memory: 0.007 MB Memory before query: 38.702 MB Rows returned: 7

SELECT *

  FROM josql_jkit_images

  WHERE item_id = 16 
  AND state = 1

  ORDER BY ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josql_jkit_images	NULL	index_merge	idx_item_id,idx_state	idx_item_id,idx_state	4,1	NULL	7	89.52	Using intersect(idx_item_id,idx_state); Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jkit/helpers/model/item.php:79
14	JKitModelItem->getItem()	JROOT/modules/mod_jkit_item/mod_jkit_item.php:29
13	include JROOT/modules/mod_jkit_item/mod_jkit_item.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:606
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.62 ms After last query: 0.19 ms Query memory: 0.007 MB Memory before query: 38.735 MB Rows returned: 0

SELECT a.id, a.title, a.alias

  FROM josql_jkit_tags AS a

  INNER JOIN josql_jkit_tags_item AS t 
  ON t.tag_id = a.id

  WHERE a.state = 1 
  AND t.item_id = 16

  ORDER BY a.id

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t	NULL	index	PRIMARY	PRIMARY	8	NULL	5	20.00	Using where; Using index; Using temporary; Using filesort
1	SIMPLE	a	NULL	eq_ref	PRIMARY,idx_state	PRIMARY	4	gulfcoa2_joom202.t.tag_id	1	93.75	Using where

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jkit/helpers/model/item.php:99
14	JKitModelItem->getItem()	JROOT/modules/mod_jkit_item/mod_jkit_item.php:29
13	include JROOT/modules/mod_jkit_item/mod_jkit_item.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:606
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.55 ms After last query: 0.06 ms Query memory: 0.007 MB Memory before query: 38.745 MB Rows returned: 0

SELECT *

  FROM josql_jkit_translations

  WHERE ref_table = 'items' 
  AND lang = 'en-US' 
  AND ref_id = 16

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josql_jkit_translations	NULL	ref	idx_ref_table,idx_ref_id,idx_lang	idx_ref_id	4	const	1	6.67	Using where

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/components/com_jkit/helpers/model/item.php:108
14	JKitModelItem->getItem()	JROOT/modules/mod_jkit_item/mod_jkit_item.php:29
13	include JROOT/modules/mod_jkit_item/mod_jkit_item.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:606
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.46 ms After last query: 0.06 ms Query memory: 0.007 MB Memory before query: 38.754 MB Rows returned: 0

Duplicate queries: #16 #23 #30 #37

SELECT *

  FROM josql_jkit_translations

  WHERE ref_table = 'categories' 
  AND lang = 'en-US' 
  AND ref_id = 3

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josql_jkit_translations	NULL	ref	idx_ref_table,idx_ref_id,idx_lang	idx_ref_table	767	const	1	6.67	Using where

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/components/com_jkit/helpers/model/item.php:120
14	JKitModelItem->getItem()	JROOT/modules/mod_jkit_item/mod_jkit_item.php:29
13	include JROOT/modules/mod_jkit_item/mod_jkit_item.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:606
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.49 ms After last query: 0.03 ms Query memory: 0.007 MB Memory before query: 38.761 MB Rows returned: 1

SELECT COUNT(`user_id`) 
  FROM `josql_jkit_like` 
  WHERE `item_id` = 16

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josql_jkit_like	NULL	ref	item_id	item_id	4	const	1	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/components/com_jkit/helpers/model/item.php:166
14	JKitModelItem->getItem()	JROOT/modules/mod_jkit_item/mod_jkit_item.php:29
13	include JROOT/modules/mod_jkit_item/mod_jkit_item.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:606
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.49 ms After last query: 0.03 ms Query memory: 0.007 MB Memory before query: 38.768 MB Rows returned: 1

SELECT COUNT(`user_id`) 
  FROM `josql_jkit_comments` 
  WHERE `state` = 1 
  AND `parent_id` = 0 
  AND `item_id` = 16

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josql_jkit_comments	NULL	index_merge	idx_item_id,idx_state	idx_item_id,idx_state	4,1	NULL	1	10.00	Using intersect(idx_item_id,idx_state); Using where

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/components/com_jkit/helpers/model/item.php:167
14	JKitModelItem->getItem()	JROOT/modules/mod_jkit_item/mod_jkit_item.php:29
13	include JROOT/modules/mod_jkit_item/mod_jkit_item.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:606
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.83 ms After last query: 13.49 ms Query memory: 0.006 MB Memory before query: 39.962 MB Rows returned: 101

SELECT * 
  FROM josql_acym_configuration

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josql_acym_configuration	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	101	100.00	NULL

Profile

Status	Duration
starting	0.14 ms
Executing hook on transaction	0.02 ms
starting	0.01 ms
checking permissions	0.02 ms
Opening tables	0.07 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.15 ms
end	0.06 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.06 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acym/library/joomla.php:531
10	acym_loadObjectList()	JROOT/administrator/components/com_acym/classes/configuration.php:21
9	acymconfigurationClass->load()	JROOT/administrator/components/com_acym/helpers/helper.php:1975
8	acym_config()	JROOT/plugins/system/acymtriggers/acymtriggers.php:90
7	plgSystemAcymtriggers->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

18 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

10 × SELECT * 
  FROM josql_jkit_translations

5 × SELECT * 
  FROM josql_jkit_images

5 × SELECT a.*,c.title AS category, c.alias AS category_alias,u.title AS user, u.alias AS user_alias, u.info AS user_info 
  FROM josql_jkit_items AS a 
  LEFT JOIN josql_jkit_categories AS c 
  ON c.id = a.category_id 
  LEFT JOIN josql_jkit_users AS u 
  ON u.id = a.user_id

5 × SELECT a.id, a.title, a.alias 
  FROM josql_jkit_tags AS a 
  INNER JOIN josql_jkit_tags_item AS t 
  ON t.tag_id = a.id

5 × SELECT COUNT(`user_id`) 
  FROM `josql_jkit_like`

5 × SELECT COUNT(`user_id`) 
  FROM `josql_jkit_comments`

1 × SELECT `session_id` 
  FROM `josql_session`

1 × SELECT id, rules 
  FROM `josql_viewlevels

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

1 × SELECT * 
  FROM josql_acysms_confi

1 × SELECT language,id 
  FROM `josql_menu`

1 × SELECT `c2`.`language`,`c2`.`id` 
  FROM `josql_menu` AS `c` 
  INNER JOIN `josql_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item' 
  INNER JOIN `josql_associations` AS `a2` 
  ON `a`.`key` = `a2`.`key` 
  INNER JOIN `josql_menu` AS `c2` 
  ON a2.id = c2.`id`

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM josql_modules AS m 
  LEFT JOIN josql_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN josql_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT config 
  FROM josql_chclient_config AS a

1 × SELECT a.id, a.link, a.language, a.params 
  FROM josql_menu AS a

1 × SELECT * 
  FROM josql_acym_configuratio

OTHER Tables:

1 × INSERT INTO `josql_session` (`session_id`,`guest`,`time`,`userid`,`username`) 
  VALUES  (X'3066346362386166353665393662356639653739313665303163333330306633', 1, 1702290209, 0, ''

1 × UPDATE `josql_extensions` 
  SET `params` = '{\"mediaversion\":\"2c72d49a409577ea6148d7bdcb6ee483\"}'

“Great care during difficult time”

Would definitely recommend this place to anyone. Took great care of my dog during a difficult time and even helped us on a longer stay during hurricane IRMA (when we could not get back on time)! Brandon is very friendly and has a passion for animals! Thank you again!

Noami · Yelp.com
“Kind and caring”

Brandon was so kind and caring to Agnes, my 17 year old dog. I know she enjoyed herself as well. I will most certainly book with him again.

Jan, Rover.com
“Great stay”

Tippi had a great day with Brandon. She's a young, active puppy that needs a lot of attention. He was great with her, sent photos throughout the day, and offered training tips. She was calm and relaxed when I picked her up..

Ashley · Rover.com
“Cameras streaming live”

This place is amazing. At first I was a little concerned when leaving my two dogs for the first time with someone they don't know, but the process was easy. What I enjoyed the most is that they have cameras around the house streaming live; so you are able to see where are your pets and what are they doing.

Yerlin C. -Yelp.com
“Daily photo updates”

Brandon runs an amazing, small boarding facility. We visited before giving him a try and found it is located in his home and you can tell how much he loves animals - it's clean and he spends lots of time doting on your furry kids. Daily photo updates are provided and he went above and beyond providing Christmas stockings with special treats and toys for our pup Bella and kitty Trouble! Would definitely highly recommend Brandon and Gulf Coast Pet Resort! Our guys loved it and it was a big relief knowing they were free to roam and get attention - a home away from home!

Mary K. A. -Yelp.com
“Treated like family”

It is always tough leaving your pet in the hands of the stranger but Brandon was absolutely great with Clyde! You would expect a house containing multiple dogs to have at least a little smell and not be the cleanest. My wife is 8 months pregnant and her crazy sensitive nose couldn't smell a thing! With the exception of a few dog toys and beds (which you want to see at a pet resort) his house was spotless! He took notes of how Clyde's day typically went. Brandon posted multiple pictures of Clyde throughout the day, everyday he was there and we could see Clyde was happy and being loved! So put your mind at ease, Brandon will treat your pup like family!

Troy B. -Yelp.com
“Fantastic Experience”

Fantastic experience with Brandon!! I have used a handful of dog sitters and though I have been happy with all of them, my experience with Brandon exceeded my expectations. He runs a professional business in a home setting. He responded to my boarding request within 30 minutes despite it being a last minute request. The guidelines of what you can expect from him are clearly defined, for instance the use of video cameras so you can see how your dog is doing. It was clear my dog was given plenty of attention based on Brandon's review of her personality and her interactions with the other dogs. When I picked her up, she was happy and relaxed. Needless to say, I'll be booking with him from now on.

Brandi C. · Rover.com
“Impressed”

Brandon gave me a tour of the place and I was impressed with the cleanliness. The yard was remarkably clean as well. The dogs were roaming and were very happy. I have a very keen sense of smell and despite the amount of dogs there, there was no smell. Usually I can tell when someone is trying to mask it. Just the kind of place I would want for my dogs. Brandon is also very professional and friendly. Would highly recommend.

Bridgette · Google.com
“Try this place first”

Absolutely the most friendly and professional animal boarding. First time boarding my dog and I could not have been more pleased. Brandon sent me pictures and my dog was on a pillow and on top of couch. Just like she does at home. I would highly recommend you try this place first.

Lynn · Google.com
“Very comfortable”

He took care of Bambi and Ollie for me a couple months ago, it was great. Definitely treated them like his own and they were very comfortable at this place. Even got reports on how they behaved. Definitely 5 stars all across the board

Jenier R. · Google.com
“Very satisfied”

Brandon with Gulf Coast Pet Resort was wonderful. We had 4 pets- one lab and one Aussie and two love birds. We were very satisfied. We would rate them 5 stars.

Chad D.· Google.com
“Great people”

Great people will highly recommend

Patrick W.· Google.com
“Very accomodating”

Our princess Maya stayed with Brandon over Christmas as the rest of our family traveled out of town for the holiday. I can't say enough about Brandon and Gulf Coast Pet Resort! We had updates daily via a weblink that was texted to us. Maya looked very happy and was socializing well with the other pups at the resort. Our flight arrived late at night, and after dealing with lost luggage at the airport, we weren't able to pick Maya up until after midnight and Brandon was very accommodating! Thanks Brandon! Maya and the family look forward to our next visit!

Jeremy P. · Google.com
“Highly recommend”

Brandon has watched my dog Mercy now twice in the last year. Mercy is not scared of him, she recognized him the 2nd time I dropped her off and he shows her attention and love. I highly recommend Gulf Coast Pet Resort to anyone who needs doggie boarding. Mercy also stayed 10 days in a commercial dog boarding facility earlier this year and I will never do that to her again. Be sure your checking the cameras regularly if you leave your pet there in one of those places. That’s all I will say about. Brandon is wonderful and your pet will be very happy with the decision you made.

Chelly D. · Google.com

Play and relax during the day.

Sleep and stay securely at night.

Be a part of the family.

Discount for Active Duty/Veterans. Promo code: supportthetroops.

Allow your pet to be pampered.

Cats welcome.

Access to your booking

Welcome

What Sets Us Apart

Roam and Play

Roam & Play

Did you know?

Safe Day & Night

Pickup and Drop-off

Gulf Coast Pet Resort offers pickup and drop-off service for your convenience.

Pickup & Drop-off

The Economical Choice

Cents & Savings

“Great care during difficult time”

“Kind and caring”

“Great stay”

“Cameras streaming live”

“Daily photo updates”

“Treated like family”

“Fantastic Experience”

“Impressed”

“Try this place first”

“Very comfortable”

“Very satisfied”

“Great people”

“Very accomodating”

“Highly recommend”

Some of our furry friends

Contact Us

We are available 24 hours a day.2312 SW 17th PL 204 Cape Coral FL 33991

Benefits of Booking with Us

Free cancellation

Lowest Prices Guaranteed

Secure Reservations

Immediate Confirmation

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

47 Queries Logged 37.18 ms

5 duplicate found!

18 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables:

We are available 24 hours a day.

2312 SW 17th PL 204 Cape Coral FL 33991