Gulf Coast Pet Resort - Promotions and Extras

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1702284321,
                "last": 1702284321,
                "now": 1702284321
            },
            "token": "qy6vFKLTMoYFfyYbKPNzWFopyQBzMZBS"
        },
        "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: 17.74 ms / 17.74 ms Memory: 2.018 MB / 2.40 MB Application: afterLoad

Time: 208.30 ms / 226.05 ms Memory: 31.517 MB / 33.92 MB Application: afterInitialise

Time: 23.99 ms / 250.04 ms Memory: 2.425 MB / 36.35 MB Application: afterRoute

Time: 0.36 ms / 250.40 ms Memory: 0.010 MB / 36.36 MB Application: beforeRenderComponent com_chclient

Time: 22.25 ms / 272.64 ms Memory: 1.462 MB / 37.82 MB Application: afterRenderComponent com_chclient

Time: 2.77 ms / 275.41 ms Memory: 0.121 MB / 37.94 MB Application: afterDispatch

Time: 6.01 ms / 281.42 ms Memory: 0.314 MB / 38.25 MB Application: beforeRenderModule mod_jkit_item (FOOTER)

Time: 11.86 ms / 293.28 ms Memory: 0.458 MB / 38.71 MB Application: afterRenderModule mod_jkit_item (FOOTER)

Time: 0.56 ms / 293.85 ms Memory: -0.009 MB / 38.70 MB Application: beforeRenderModule mod_jkit_item (BOTTOM - CONTACT)

Time: 7.41 ms / 301.25 ms Memory: 0.069 MB / 38.77 MB Application: afterRenderModule mod_jkit_item (BOTTOM - CONTACT)

Time: 0.60 ms / 301.85 ms Memory: -0.011 MB / 38.76 MB Application: beforeRenderModule mod_jkit_item (BOTTOM - BENEFITS)

Time: 7.42 ms / 309.27 ms Memory: 0.083 MB / 38.84 MB Application: afterRenderModule mod_jkit_item (BOTTOM - BENEFITS)

Time: 0.31 ms / 309.59 ms Memory: -0.035 MB / 38.81 MB Application: beforeRenderModule mod_chsearch (TOP - SEARCH)

Time: 2.71 ms / 312.29 ms Memory: 0.150 MB / 38.96 MB Application: afterRenderModule mod_chsearch (TOP - SEARCH)

Time: 0.31 ms / 312.61 ms Memory: 0.020 MB / 38.98 MB Application: beforeRenderModule mod_menu (OFFCANVAS MENU ES)

Time: 0.81 ms / 313.41 ms Memory: 0.094 MB / 39.07 MB Application: afterRenderModule mod_menu (OFFCANVAS MENU ES)

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

Time: 1.84 ms / 315.72 ms Memory: 0.067 MB / 39.14 MB Application: afterRenderModule mod_menu (OFFCANVAS MENU EN)

Time: 0.49 ms / 316.21 ms Memory: -0.002 MB / 39.14 MB Application: beforeRenderModule mod_menu (MAIN MENU EN)

Time: 1.04 ms / 317.25 ms Memory: 0.007 MB / 39.14 MB Application: afterRenderModule mod_menu (MAIN MENU EN)

Time: 0.47 ms / 317.72 ms Memory: -0.002 MB / 39.14 MB Application: beforeRenderModule mod_menu (MAIN MENU ES)

Time: 0.53 ms / 318.25 ms Memory: 0.004 MB / 39.15 MB Application: afterRenderModule mod_menu (MAIN MENU ES)

Time: 0.22 ms / 318.47 ms Memory: -0.022 MB / 39.12 MB Application: beforeRenderModule mod_artnotifybar (Book online)

Time: 0.31 ms / 318.79 ms Memory: 0.017 MB / 39.14 MB Application: afterRenderModule mod_artnotifybar (Book online)

Time: 0.23 ms / 319.02 ms Memory: 0.017 MB / 39.16 MB Application: beforeRenderModule mod_jkit_item (LOGO)

Time: 7.01 ms / 326.02 ms Memory: 0.063 MB / 39.22 MB Application: afterRenderModule mod_jkit_item (LOGO)

Time: 0.31 ms / 326.33 ms Memory: -0.028 MB / 39.19 MB Application: beforeRenderModule mod_chmybooking (MY BOOKING)

Time: 0.65 ms / 326.98 ms Memory: 0.013 MB / 39.21 MB Application: afterRenderModule mod_chmybooking (MY BOOKING)

Time: 13.81 ms / 340.80 ms Memory: 1.453 MB / 40.66 MB Application: afterRender

Database queries total: 49.52 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.30 ms
Executing hook on transaction	0.03 ms
starting	0.09 ms
checking permissions	0.02 ms
Opening tables	0.14 ms
init	0.02 ms
System lock	0.06 ms
optimizing	0.03 ms
statistics	0.16 ms
executing	0.06 ms
end	0.02 ms
query end	0.04 ms
waiting for handler commit	0.03 ms
closing tables	0.09 ms
freeing items	0.10 ms
cleaning up	0.04 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'6230633762336433633336303239326634353935656365383932303361396632', 1, 1702284321, 0, '')

Profile

Status	Duration
starting	0.22 ms
Executing hook on transaction	0.02 ms
starting	0.06 ms
checking permissions	0.02 ms
Opening tables	0.12 ms
init	0.04 ms
System lock	0.10 ms
update	0.18 ms
end	0.02 ms
query end	0.04 ms
waiting for handler commit	1.87 ms
closing tables	0.08 ms
freeing items	0.09 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php: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.72 ms After last query: 8.18 ms Query memory: 0.005 MB Memory before query: 4.824 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.28 ms
Executing hook on transaction	0.02 ms
starting	0.05 ms
checking permissions	0.02 ms
Opening tables	0.17 ms
init	0.02 ms
System lock	0.04 ms
optimizing	0.03 ms
statistics	0.02 ms
preparing	0.05 ms
executing	0.47 ms
end	0.02 ms
query end	0.05 ms
waiting for handler commit	0.02 ms
closing tables	0.09 ms
freeing items	0.11 ms
cleaning up	0.05 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: 1.17 ms After last query: 1.76 ms Query memory: 0.005 MB Memory before query: 5.107 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.18 ms
Executing hook on transaction	0.02 ms
starting	0.04 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
Opening tables	0.17 ms
init	0.01 ms
System lock	0.04 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.07 ms
executing	0.04 ms
end	0.01 ms
query end	0.04 ms
waiting for handler commit	0.02 ms
closing tables	0.15 ms
freeing items	0.06 ms
cleaning up	0.03 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: 0.91 ms After last query: 3.55 ms Query memory: 0.003 MB Memory before query: 5.319 MB Rows returned: 1

SELECT *

  FROM josql_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josql_languages	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	50.00	Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Language/LanguageHelper.php:67
4	Joomla\CMS\Language\LanguageHelper::detectLanguage()	JROOT/libraries/src/Application/SiteApplication.php:653
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.67 ms After last query: 123.27 ms Query memory: 0.005 MB Memory before query: 30.131 MB Rows returned: 6

SELECT `element`,`name`,`client_id`,`extension_id`

  FROM `josql_extensions`

  WHERE `type` = 'language' 
  AND `state` = 0 
  AND `enabled` = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josql_extensions	NULL	ref	extension	extension	82	const	6	1.00	Using where

Profile

Status	Duration
starting	0.42 ms
Executing hook on transaction	0.02 ms
starting	0.07 ms
checking permissions	0.02 ms
Opening tables	0.13 ms
init	0.02 ms
System lock	0.11 ms
optimizing	0.03 ms
statistics	0.10 ms
preparing	0.11 ms
executing	0.13 ms
end	0.02 ms
query end	0.06 ms
waiting for handler commit	0.02 ms
closing tables	0.20 ms
freeing items	0.10 ms
cleaning up	0.03 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/LanguageHelper.php:209
8	Joomla\CMS\Language\LanguageHelper::getInstalledLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:110
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.99 ms After last query: 44.56 ms Query memory: 0.006 MB Memory before query: 34.534 MB

UPDATE `josql_extensions`

  SET `params` = '{\"mediaversion\":\"b9a2c2c2cfd91386d04526b7c61461cb\"}'

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

Explain

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

Profile

Status	Duration
starting	0.33 ms
Executing hook on transaction	0.02 ms
starting	0.07 ms
checking permissions	0.02 ms
Opening tables	0.16 ms
init	0.02 ms
System lock	0.23 ms
updating	0.21 ms
end	0.02 ms
query end	0.05 ms
waiting for handler commit	1.46 ms
closing tables	0.24 ms
freeing items	0.10 ms
cleaning up	0.04 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: 1.43 ms After last query: 4.77 ms Query memory: 0.007 MB Memory before query: 35.175 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.19 ms
Executing hook on transaction	0.02 ms
starting	0.06 ms
checking permissions	0.03 ms
Opening tables	0.14 ms
init	0.02 ms
System lock	0.12 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.06 ms
executing	0.41 ms
end	0.03 ms
query end	0.05 ms
closing tables	0.10 ms
freeing items	0.07 ms
cleaning up	0.05 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.99 ms After last query: 9.91 ms Query memory: 0.006 MB Memory before query: 36.612 MB Rows returned: 1

SELECT id 
  FROM josql_chclient_inventory 
  ORDER BY title

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/components/com_chclient/helpers/chclient.php:452
9	CHClient::checkViewHotels()	JROOT/components/com_chclient/helpers/chclient.php:467
8	CHClient::checkViewEngine()	JROOT/components/com_chclient/helpers/chclient.php:412
7	CHClient::checkView()	JROOT/components/com_chclient/chclient.php:28
6	require_once JROOT/components/com_chclient/chclient.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.97 ms After last query: 5.35 ms Query memory: 0.008 MB Memory before query: 36.876 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.19 ms
Executing hook on transaction	0.02 ms
starting	0.04 ms
checking permissions	0.02 ms
Opening tables	0.17 ms
init	0.03 ms
System lock	0.06 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.05 ms
executing	0.03 ms
end	0.01 ms
query end	0.03 ms
waiting for handler commit	0.02 ms
closing tables	0.09 ms
freeing items	0.06 ms
cleaning up	0.04 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_chclient/helpers/chclient.php:92
15	CHClient::getConfig()	JROOT/components/com_chclient/helpers/chclient.php:118
14	CHClient::getSearch()	JROOT/components/com_chclient/helpers/view/base.php:22
13	CHClientViewBase->__construct()	JROOT/libraries/src/MVC/Factory/LegacyFactory.php:89
12	Joomla\CMS\MVC\Factory\LegacyFactory->createView()	JROOT/libraries/src/MVC/Controller/BaseController.php:590
11	Joomla\CMS\MVC\Controller\BaseController->createView()	JROOT/libraries/src/MVC/Controller/BaseController.php:833
10	Joomla\CMS\MVC\Controller\BaseController->getView()	JROOT/libraries/src/MVC/Controller/BaseController.php:613
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_chclient/controller.php:25
8	CHClientController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_chclient/chclient.php:32
6	require_once JROOT/components/com_chclient/chclient.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.93 ms After last query: 2.91 ms Query memory: 0.007 MB Memory before query: 37.130 MB Rows returned: 1

SELECT `id` 
  FROM `josql_chclient_inventory` 
  WHERE `slug` = 'gulfcoastpetresort-com'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josql_chclient_inventory	NULL	ref	idx_slug	idx_slug	767	const	1	100.00	Using index

Profile

Status	Duration
starting	0.14 ms
Executing hook on transaction	0.01 ms
starting	0.07 ms
checking permissions	0.02 ms
Opening tables	0.08 ms
init	0.01 ms
System lock	0.04 ms
optimizing	0.04 ms
statistics	0.12 ms
preparing	0.06 ms
executing	0.03 ms
end	0.01 ms
query end	0.06 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
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/libraries/chlib/database.php:118
13	CHLibDatabase::loadResult()	JROOT/components/com_chclient/models/promo.php:37
12	CHClientModelPromo->getPromo()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_chclient/views/promo/view.html.php:22
10	CHClientViewPromo->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_chclient/controller.php:25
8	CHClientController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_chclient/chclient.php:32
6	require_once JROOT/components/com_chclient/chclient.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT `data` 
  FROM `josql_chclient_inventory` 
  WHERE `id` = '100001'

Explain

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

Profile

Status	Duration
starting	0.09 ms
Executing hook on transaction	0.03 ms
starting	0.03 ms
checking permissions	0.02 ms
Opening tables	0.11 ms
init	0.01 ms
System lock	0.04 ms
optimizing	0.02 ms
statistics	0.33 ms
preparing	0.06 ms
executing	0.15 ms
end	0.01 ms
query end	0.03 ms
waiting for handler commit	0.02 ms
closing tables	0.07 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:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/chlib/database.php:118
14	CHLibDatabase::loadResult()	JROOT/components/com_chclient/helpers/model/base.php:98
13	CHClientModelBase->getHotel()	JROOT/components/com_chclient/models/promo.php:44
12	CHClientModelPromo->getPromo()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_chclient/views/promo/view.html.php:22
10	CHClientViewPromo->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_chclient/controller.php:25
8	CHClientController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_chclient/chclient.php:32
6	require_once JROOT/components/com_chclient/chclient.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.92 ms After last query: 4.12 ms Query memory: 0.011 MB Memory before query: 37.768 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.14 ms
Executing hook on transaction	0.01 ms
starting	0.04 ms
checking permissions	0.02 ms
Opening tables	0.11 ms
init	0.01 ms
System lock	0.04 ms
optimizing	0.04 ms
statistics	0.06 ms
preparing	0.05 ms
executing	0.07 ms
end	0.01 ms
query end	0.04 ms
waiting for handler commit	0.01 ms
closing tables	0.12 ms
freeing items	0.06 ms
cleaning up	0.04 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/components/com_chclient/helpers/route.php:95
20	CHClientRoute::menuItems()	JROOT/components/com_chclient/helpers/route.php:56
19	CHClientRoute::menuItemid()	JROOT/components/com_chclient/helpers/route.php:33
18	CHClientRoute::viewUrl()	JROOT/components/com_chclient/views/promo/tmpl/default_main.php:61
17	include JROOT/components/com_chclient/views/promo/tmpl/default_main.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_chclient/views/tmpl_modules.php:34
15	require JROOT/components/com_chclient/views/tmpl_modules.php	JROOT/components/com_chclient/views/promo/tmpl/default.php:11
14	include JROOT/components/com_chclient/views/promo/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_chclient/helpers/view/base.php:56
11	CHClientViewBase->display()	JROOT/components/com_chclient/views/promo/view.html.php:40
10	CHClientViewPromo->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_chclient/controller.php:25
8	CHClientController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_chclient/chclient.php:32
6	require_once JROOT/components/com_chclient/chclient.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.92 ms After last query: 2.39 ms Query memory: 0.005 MB Memory before query: 37.823 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.10 ms
init	0.01 ms
System lock	0.04 ms
optimizing	0.03 ms
statistics	0.04 ms
preparing	0.05 ms
executing	0.16 ms
end	0.02 ms
query end	0.05 ms
waiting for handler commit	0.02 ms
closing tables	0.06 ms
freeing items	0.06 ms
cleaning up	0.03 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: 1.84 ms After last query: 3.32 ms Query memory: 0.009 MB Memory before query: 38.076 MB Rows returned: 12

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 08:45:21') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-12-11 08:45:21') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 127 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.19 ms
Executing hook on transaction	0.01 ms
starting	0.04 ms
checking permissions	0.01 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
Opening tables	0.26 ms
init	0.02 ms
System lock	0.05 ms
optimizing	0.08 ms
statistics	0.14 ms
preparing	0.08 ms
executing	0.36 ms
end	0.02 ms
query end	0.08 ms
waiting for handler commit	0.04 ms
closing tables	0.21 ms
freeing items	0.12 ms
cleaning up	0.04 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: 1.48 ms After last query: 6.26 ms Query memory: 0.007 MB Memory before query: 38.647 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 = 21 
  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.31 ms
Executing hook on transaction	0.02 ms
starting	0.05 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.28 ms
init	0.02 ms
System lock	0.04 ms
optimizing	0.03 ms
statistics	0.15 ms
preparing	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.24 ms
freeing items	0.07 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: 1.16 ms After last query: 0.11 ms Query memory: 0.008 MB Memory before query: 38.667 MB Rows returned: 0

SELECT *

  FROM josql_jkit_images

  WHERE item_id = 21 
  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.13 ms
Executing hook on transaction	0.01 ms
starting	0.03 ms
checking permissions	0.02 ms
Opening tables	0.10 ms
init	0.01 ms
System lock	0.04 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.06 ms
executing	0.24 ms
end	0.02 ms
query end	0.04 ms
waiting for handler commit	0.07 ms
closing tables	0.09 ms
freeing items	0.10 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: 1.07 ms After last query: 0.07 ms Query memory: 0.007 MB Memory before query: 38.679 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 = 21

  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.10 ms
Executing hook on transaction	0.01 ms
starting	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.17 ms
init	0.02 ms
System lock	0.04 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.03 ms
Creating tmp table	0.08 ms
executing	0.04 ms
end	0.01 ms
query end	0.04 ms
waiting for handler commit	0.02 ms
closing tables	0.19 ms
freeing items	0.10 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.88 ms After last query: 0.07 ms Query memory: 0.007 MB Memory before query: 38.688 MB Rows returned: 0

SELECT *

  FROM josql_jkit_translations

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

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.09 ms
Executing hook on transaction	0.01 ms
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.10 ms
init	0.03 ms
System lock	0.04 ms
optimizing	0.06 ms
statistics	0.08 ms
preparing	0.06 ms
executing	0.04 ms
end	0.01 ms
query end	0.05 ms
waiting for handler commit	0.03 ms
closing tables	0.09 ms
freeing items	0.07 ms
cleaning up	0.04 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.90 ms After last query: 0.06 ms Query memory: 0.007 MB Memory before query: 38.697 MB Rows returned: 0

Duplicate queries: #27 #34 #41

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.09 ms
Executing hook on transaction	0.01 ms
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
init	0.01 ms
System lock	0.05 ms
optimizing	0.03 ms
statistics	0.05 ms
preparing	0.10 ms
executing	0.03 ms
end	0.03 ms
query end	0.04 ms
waiting for handler commit	0.02 ms
closing tables	0.07 ms
freeing items	0.14 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.82 ms After last query: 0.05 ms Query memory: 0.007 MB Memory before query: 38.704 MB Rows returned: 1

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

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.09 ms
Executing hook on transaction	0.02 ms
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.08 ms
init	0.03 ms
System lock	0.06 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.09 ms
executing	0.03 ms
end	0.01 ms
query end	0.04 ms
waiting for handler commit	0.02 ms
closing tables	0.09 ms
freeing items	0.07 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: 1.04 ms After last query: 0.04 ms Query memory: 0.007 MB Memory before query: 38.712 MB Rows returned: 1

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

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.09 ms
Executing hook on transaction	0.02 ms
starting	0.04 ms
checking permissions	0.02 ms
Opening tables	0.12 ms
init	0.01 ms
System lock	0.05 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.05 ms
executing	0.19 ms
end	0.02 ms
query end	0.04 ms
waiting for handler commit	0.07 ms
closing tables	0.12 ms
freeing items	0.05 ms
cleaning up	0.06 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: 1.14 ms After last query: 1.20 ms Query memory: 0.007 MB Memory before query: 38.733 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 = 29 
  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.13 ms
Executing hook on transaction	0.02 ms
starting	0.04 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.24 ms
init	0.02 ms
System lock	0.05 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.06 ms
executing	0.07 ms
end	0.01 ms
query end	0.03 ms
waiting for handler commit	0.02 ms
closing tables	0.13 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: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: 1.07 ms After last query: 0.10 ms Query memory: 0.007 MB Memory before query: 38.751 MB Rows returned: 0

SELECT *

  FROM josql_jkit_images

  WHERE item_id = 29 
  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.09 ms
Executing hook on transaction	0.04 ms
starting	0.04 ms
checking permissions	0.02 ms
Opening tables	0.10 ms
init	0.02 ms
System lock	0.06 ms
optimizing	0.03 ms
statistics	0.08 ms
preparing	0.10 ms
executing	0.14 ms
end	0.02 ms
query end	0.04 ms
waiting for handler commit	0.06 ms
closing tables	0.08 ms
freeing items	0.07 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.99 ms After last query: 0.09 ms Query memory: 0.007 MB Memory before query: 38.761 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 = 29

  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.11 ms
Executing hook on transaction	0.02 ms
starting	0.04 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.18 ms
init	0.02 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.02 ms
Creating tmp table	0.07 ms
executing	0.05 ms
end	0.01 ms
query end	0.04 ms
waiting for handler commit	0.02 ms
closing tables	0.12 ms
freeing items	0.07 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: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.86 ms After last query: 0.09 ms Query memory: 0.007 MB Memory before query: 38.770 MB Rows returned: 0

SELECT *

  FROM josql_jkit_translations

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

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.02 ms
starting	0.06 ms
checking permissions	0.02 ms
Opening tables	0.10 ms
init	0.03 ms
System lock	0.05 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.07 ms
executing	0.04 ms
end	0.02 ms
query end	0.04 ms
waiting for handler commit	0.02 ms
closing tables	0.07 ms
freeing items	0.07 ms
cleaning up	0.06 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.78 ms After last query: 0.13 ms Query memory: 0.007 MB Memory before query: 38.779 MB Rows returned: 0

Duplicate queries: #20 #34 #41

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.04 ms
checking permissions	0.01 ms
Opening tables	0.14 ms
init	0.03 ms
System lock	0.04 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.05 ms
executing	0.03 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.07 ms
cleaning up	0.04 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.75 ms After last query: 0.04 ms Query memory: 0.007 MB Memory before query: 38.787 MB Rows returned: 1

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

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.12 ms
Executing hook on transaction	0.02 ms
starting	0.04 ms
checking permissions	0.03 ms
Opening tables	0.07 ms
init	0.01 ms
System lock	0.06 ms
optimizing	0.03 ms
statistics	0.05 ms
preparing	0.05 ms
executing	0.02 ms
end	0.01 ms
query end	0.03 ms
waiting for handler commit	0.01 ms
closing tables	0.06 ms
freeing items	0.07 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.92 ms After last query: 0.05 ms Query memory: 0.007 MB Memory before query: 38.794 MB Rows returned: 1

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

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.09 ms
Executing hook on transaction	0.01 ms
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
init	0.01 ms
System lock	0.06 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.06 ms
executing	0.21 ms
end	0.01 ms
query end	0.03 ms
waiting for handler commit	0.06 ms
closing tables	0.06 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: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: 1.10 ms After last query: 1.00 ms Query memory: 0.007 MB Memory before query: 38.790 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 = 28 
  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.01 ms
starting	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
Opening tables	0.21 ms
init	0.02 ms
System lock	0.05 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.10 ms
executing	0.04 ms
end	0.01 ms
query end	0.03 ms
waiting for handler commit	0.03 ms
closing tables	0.15 ms
freeing items	0.07 ms
cleaning up	0.04 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: 1.19 ms After last query: 0.10 ms Query memory: 0.007 MB Memory before query: 38.807 MB Rows returned: 4

SELECT *

  FROM josql_jkit_images

  WHERE item_id = 28 
  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.09 ms
Executing hook on transaction	0.02 ms
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.10 ms
init	0.02 ms
System lock	0.06 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.07 ms
executing	0.26 ms
end	0.02 ms
query end	0.04 ms
waiting for handler commit	0.07 ms
closing tables	0.10 ms
freeing items	0.07 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.99 ms After last query: 0.13 ms Query memory: 0.007 MB Memory before query: 38.827 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 = 28

  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.16 ms
Executing hook on transaction	0.02 ms
starting	0.04 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.15 ms
init	0.02 ms
System lock	0.04 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
Creating tmp table	0.06 ms
executing	0.05 ms
end	0.01 ms
query end	0.03 ms
waiting for handler commit	0.02 ms
closing tables	0.13 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.87 ms After last query: 0.07 ms Query memory: 0.009 MB Memory before query: 38.843 MB Rows returned: 0

SELECT *

  FROM josql_jkit_translations

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

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.15 ms
Executing hook on transaction	0.01 ms
starting	0.03 ms
checking permissions	0.02 ms
Opening tables	0.09 ms
init	0.02 ms
System lock	0.04 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.05 ms
executing	0.04 ms
end	0.01 ms
query end	0.05 ms
waiting for handler commit	0.02 ms
closing tables	0.07 ms
freeing items	0.14 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.76 ms After last query: 0.06 ms Query memory: 0.007 MB Memory before query: 38.853 MB Rows returned: 0

Duplicate queries: #20 #27 #41

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.11 ms
Executing hook on transaction	0.01 ms
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.09 ms
init	0.01 ms
System lock	0.05 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.05 ms
executing	0.03 ms
end	0.01 ms
query end	0.03 ms
waiting for handler commit	0.01 ms
closing tables	0.06 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: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.72 ms After last query: 0.04 ms Query memory: 0.007 MB Memory before query: 38.860 MB Rows returned: 1

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

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.12 ms
Executing hook on transaction	0.01 ms
starting	0.04 ms
checking permissions	0.02 ms
Opening tables	0.07 ms
init	0.01 ms
System lock	0.05 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.05 ms
executing	0.02 ms
end	0.01 ms
query end	0.04 ms
waiting for handler commit	0.01 ms
closing tables	0.06 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.98 ms After last query: 0.05 ms Query memory: 0.007 MB Memory before query: 38.868 MB Rows returned: 1

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

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.09 ms
Executing hook on transaction	0.01 ms
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
init	0.01 ms
System lock	0.07 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.06 ms
executing	0.26 ms
end	0.01 ms
query end	0.04 ms
waiting for handler commit	0.06 ms
closing tables	0.06 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: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: 1.17 ms After last query: 10.10 ms Query memory: 0.007 MB Memory before query: 39.186 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 = 15 
  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.03 ms
starting	0.05 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.25 ms
init	0.02 ms
System lock	0.04 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.05 ms
executing	0.04 ms
end	0.01 ms
query end	0.04 ms
waiting for handler commit	0.02 ms
closing tables	0.14 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: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.96 ms After last query: 0.13 ms Query memory: 0.007 MB Memory before query: 39.203 MB Rows returned: 0

SELECT *

  FROM josql_jkit_images

  WHERE item_id = 15 
  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.10 ms
Executing hook on transaction	0.01 ms
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.12 ms
init	0.01 ms
System lock	0.05 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.05 ms
executing	0.13 ms
end	0.02 ms
query end	0.05 ms
waiting for handler commit	0.06 ms
closing tables	0.06 ms
freeing items	0.05 ms
cleaning up	0.08 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.95 ms After last query: 0.09 ms Query memory: 0.007 MB Memory before query: 39.214 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 = 15

  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.12 ms
Executing hook on transaction	0.03 ms
starting	0.08 ms
checking permissions	0.01 ms
checking permissions	0.03 ms
Opening tables	0.13 ms
init	0.01 ms
System lock	0.04 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.03 ms
Creating tmp table	0.06 ms
executing	0.03 ms
end	0.01 ms
query end	0.03 ms
waiting for handler commit	0.02 ms
closing tables	0.10 ms
freeing items	0.09 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.77 ms After last query: 0.06 ms Query memory: 0.007 MB Memory before query: 39.223 MB Rows returned: 0

SELECT *

  FROM josql_jkit_translations

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

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.07 ms
checking permissions	0.02 ms
Opening tables	0.09 ms
init	0.01 ms
System lock	0.05 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.05 ms
executing	0.03 ms
end	0.02 ms
query end	0.04 ms
waiting for handler commit	0.02 ms
closing tables	0.06 ms
freeing items	0.05 ms
cleaning up	0.06 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.80 ms After last query: 0.05 ms Query memory: 0.007 MB Memory before query: 39.232 MB Rows returned: 0

Duplicate queries: #20 #27 #34

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.14 ms
Executing hook on transaction	0.01 ms
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.10 ms
init	0.03 ms
System lock	0.07 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.05 ms
executing	0.03 ms
end	0.01 ms
query end	0.03 ms
waiting for handler commit	0.01 ms
closing tables	0.06 ms
freeing items	0.05 ms
cleaning up	0.06 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.69 ms After last query: 0.05 ms Query memory: 0.007 MB Memory before query: 39.240 MB Rows returned: 1

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

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.09 ms
Executing hook on transaction	0.01 ms
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
init	0.01 ms
System lock	0.04 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.05 ms
executing	0.03 ms
end	0.01 ms
query end	0.05 ms
waiting for handler commit	0.03 ms
closing tables	0.06 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.92 ms After last query: 0.05 ms Query memory: 0.007 MB Memory before query: 39.247 MB Rows returned: 1

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

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.09 ms
Executing hook on transaction	0.01 ms
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
init	0.01 ms
System lock	0.05 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.05 ms
executing	0.15 ms
end	0.02 ms
query end	0.04 ms
waiting for handler commit	0.06 ms
closing tables	0.11 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: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: 1.00 ms After last query: 11.97 ms Query memory: 0.006 MB Memory before query: 40.475 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.15 ms
Executing hook on transaction	0.01 ms
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.10 ms
init	0.01 ms
System lock	0.04 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.04 ms
executing	0.16 ms
end	0.02 ms
query end	0.04 ms
waiting for handler commit	0.02 ms
closing tables	0.09 ms
freeing items	0.08 ms
cleaning up	0.05 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.]

22 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

8 × SELECT * 
  FROM josql_jkit_translations

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

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

4 × 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

4 × SELECT * 
  FROM josql_jkit_images

4 × 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

1 × SELECT `session_id` 
  FROM `josql_session`

1 × SELECT language,id 
  FROM `josql_menu`

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 a.id, a.link, a.language, a.params 
  FROM josql_menu AS a

1 × SELECT id, rules 
  FROM `josql_viewlevels

1 × SELECT `data` 
  FROM `josql_chclient_inventory`

1 × SELECT `id` 
  FROM `josql_chclient_inventory`

1 × SELECT config 
  FROM josql_chclient_config AS a

1 × SELECT id 
  FROM josql_chclient_inventory

1 × SELECT * 
  FROM josql_acysms_confi

1 × SELECT `element`,`name`,`client_id`,`extension_id` 
  FROM `josql_extensions`

```
1 × SELECT * 
  FROM josql_languages
```

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_acym_configuratio

OTHER Tables:

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

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

10% Active Duty/Veteran Discount

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

44 Queries Logged 49.52 ms

4 duplicate found!

22 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables:

Access to your booking

10% Active Duty/Veteran Discount

10% Active Duty/Veteran Discount

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

44 Queries Logged 49.52 ms

4 duplicate found!

22 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