SilverCloud Tag

Product Attributes
UPC
Model	2700
Dimensions	1.50" W; 2.70" L; 0.93" H
Dimensions	3.4" W x 4.2" L x 1.7" H
Operating Temperature	-15ºF to 185ºF (-26ºC to 85ºC)
Operating Temperature	-20°C to 55°C (-4°F to 131°F)
Housing	ABS plastic
Mounting	Powerful magnet mounts
Power	4 AA batteries
Power Draw	Track mode: 63mA; Sleep mode: 0.040mA
Sleep Mode Entry	3.5 Minutes of no movement
Cold Start Acquisition Time	90 Seconds
Warm Start Acquisition Time	50 Seconds
Hot Start Acquisition Time	10 Seconds
Max Number of Satellites	16 Satellites
Horizontal Accuracy	2.5 Meters
Communication Protocol	NMEA
Communication Protocol	TCP/UP, UDP, SMS
Data Output	USB (PC compatible only)
Memory Type	Flash memory (non-volatile)
Storage Capacity	300 Hours of driving time
Power Source	3.7 volt, 1340 mAh rechargeable battery, wall charger, and USB charger
GSM Channels	850/1900 (United States) 900/1800 (Europe, Australia, Asia and the Middle East)
Update Frequency	Based on service plan: 30 second and 1 min updates
Antenna	Quad-band GSM/GPRS and GPS, integrated into device
Historical Playback	Unlimiited historical playback stored at server
Reporting	Individual vehicle report, enhanced vehicle report, start/stop report, mileage and more
Diagnostics	Blinking LED, SMS or TCP diagnostic messages

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1550613370,
                "last": 1550613370,
                "now": 1550613370
            },
            "token": "l8JLumMbhFf6Z8FTFwjQY4pXPLbxZLe1"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "viewed_product_ids": [
            5
        ],
        "continue_shopping_url": "https:\/\/vehicle-tracking.com\/real-time-trackers\/silvercloud-tag?keyword=real-time%20GPS%20tracker"
    }
}

Profile Information

Time

Memory

Time: 5.31 ms / 5.31 ms Memory: 0.561 MB / 0.90 MB Application: afterLoad

Time: 17.77 ms / 23.08 ms Memory: 0.876 MB / 1.78 MB Application: afterInitialise

Time: 4.60 ms / 27.67 ms Memory: 0.252 MB / 2.03 MB Application: afterRoute

Time: 2.36 ms / 30.04 ms Memory: 0.181 MB / 2.21 MB Application: beforeRenderComponent com_eshop

Time: 29.61 ms / 59.65 ms Memory: 0.655 MB / 2.87 MB Application: afterRenderComponent com_eshop

Time: 0.27 ms / 59.92 ms Memory: 0.006 MB / 2.87 MB Application: afterDispatch

Time: 15.65 ms / 75.56 ms Memory: 0.320 MB / 3.19 MB Application: beforeRenderModule mod_search (Search)

Time: 0.58 ms / 76.14 ms Memory: 0.085 MB / 3.28 MB Application: afterRenderModule mod_search (Search)

Time: 0.03 ms / 76.17 ms Memory: 0.000 MB / 3.27 MB Application: beforeRenderModule mod_menu (Off Canvas Menu)

Time: 1.11 ms / 77.27 ms Memory: 0.050 MB / 3.32 MB Application: afterRenderModule mod_menu (Off Canvas Menu)

Time: 0.04 ms / 77.32 ms Memory: 0.000 MB / 3.32 MB Application: beforeRenderModule mod_menu (Information)

Time: 0.38 ms / 77.69 ms Memory: 0.019 MB / 3.34 MB Application: afterRenderModule mod_menu (Information)

Time: 0.04 ms / 77.73 ms Memory: 0.000 MB / 3.33 MB Application: beforeRenderModule mod_menu (Product)

Time: 0.54 ms / 78.27 ms Memory: 0.019 MB / 3.35 MB Application: afterRenderModule mod_menu (Product)

Time: 0.06 ms / 78.33 ms Memory: 0.000 MB / 3.35 MB Application: beforeRenderModule mod_custom_advanced (Verified Merchant)

Time: 0.23 ms / 78.56 ms Memory: 0.009 MB / 3.36 MB Application: afterRenderModule mod_custom_advanced (Verified Merchant)

Time: 0.06 ms / 78.63 ms Memory: 0.001 MB / 3.36 MB Application: beforeRenderModule mod_sppagebuilder (Company Logo Slogan)

Time: 20.77 ms / 99.39 ms Memory: 1.173 MB / 4.53 MB Application: afterRenderModule mod_sppagebuilder (Company Logo Slogan)

Time: 0.09 ms / 99.48 ms Memory: 0.000 MB / 4.52 MB Application: beforeRenderModule mod_eshop_cart (Shopping Cart)

Time: 3.21 ms / 102.69 ms Memory: 0.160 MB / 4.68 MB Application: afterRenderModule mod_eshop_cart (Shopping Cart)

Time: 4.02 ms / 106.71 ms Memory: 0.348 MB / 5.03 MB Application: afterRender

Database queries total: 27.64 ms

Memory Usage

Database Queries

108 Queries Logged 27.64 ms

68 duplicate found!

8 duplicates: #15 #99 #100 #101 #102 #104 #105 #107

2 duplicates: #33 #42

3 duplicates: #35 #36 #37

55 duplicates: #44 #45 #46 #47 #48 #49 #50 #51 #52 #53 #54 #55 #56 #57 #58 #59 #60 #61 #62 #63 #64 #65 #66 #67 #68 #69 #70 #71 #72 #73 #74 #75 #76 #77 #78 #79 #80 #81 #82 #83 #84 #85 #86 #87 #88 #89 #90 #91 #92 #93 #94 #95 #96 #97 #98

Query Time: 0.28 ms Query memory: 0.007 MB Memory before query: 1.162 MB Rows returned: 0

SELECT `data`

  FROM `xg5ba_session`

  WHERE `session_id` = '5eab166312fadf6d9b177a7e79e58997'

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

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

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

Query Time: 0.09 ms After last query: 0.50 ms Query memory: 0.004 MB Memory before query: 1.178 MB Rows returned: 0

SELECT `session_id`

  FROM `xg5ba_session`

  WHERE `session_id` = '5eab166312fadf6d9b177a7e79e58997' 
  LIMIT 1

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

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

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

Query Time: 0.16 ms After last query: 0.05 ms Query memory: 0.004 MB Memory before query: 1.183 MB

INSERT INTO `xg5ba_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('5eab166312fadf6d9b177a7e79e58997', 1, 1550613370, 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `xg5ba_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('5eab166312fadf6d9b177a7e79e58997', 1, 1550613370, 0, '', 0)

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

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

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

Query Time: 0.39 ms After last query: 0.98 ms Query memory: 0.006 MB Memory before query: 1.281 MB Rows returned: 42

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `xg5ba_extensions`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	xg5ba_extensions	ref	extension	extension	82	const	42	100.00	Using index condition; Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.12 ms After last query: 0.95 ms Query memory: 0.005 MB Memory before query: 1.315 MB Rows returned: 5

SELECT id, rules

  FROM `xg5ba_viewlevels`

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

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

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

Query Time: 0.12 ms After last query: 0.05 ms Query memory: 0.005 MB Memory before query: 1.327 MB Rows returned: 0

SELECT b.id

  FROM xg5ba_usergroups AS a

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

  WHERE a.id = 13

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

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

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

Query Time: 0.63 ms After last query: 0.22 ms Query memory: 0.005 MB Memory before query: 1.349 MB Rows returned: 105

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM xg5ba_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1)

  ORDER BY ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	xg5ba_extensions	ref	extension	extension	82	const	137	100.00	Using index condition; Using where; Using filesort

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.54 ms After last query: 7.27 ms Query memory: 0.009 MB Memory before query: 1.807 MB Rows returned: 22

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM xg5ba_menu AS m

  LEFT JOIN xg5ba_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	61	100.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	new58872_db.m.component_id	1	100.00	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1073
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.21 ms After last query: 3.50 ms Query memory: 0.007 MB Memory before query: 2.049 MB Rows returned: 1

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `xg5ba_extensions`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	xg5ba_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using index condition

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1119
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.19 ms After last query: 0.10 ms Query memory: 0.005 MB Memory before query: 2.040 MB

UPDATE `xg5ba_extensions`

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

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	xg5ba_extensions	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.03 ms
updating	0.04 ms
end	0.00 ms
Waiting for query cache lock	0.00 ms
end	0.01 ms
query end	0.03 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1119
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.15 ms After last query: 0.63 ms Query memory: 0.003 MB Memory before query: 2.127 MB Rows returned: 1

SELECT *

  FROM xg5ba_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.24 ms After last query: 0.14 ms Query memory: 0.003 MB Memory before query: 2.138 MB Rows returned: 4

SELECT id, home, template, s.params

  FROM xg5ba_template_styles as s

  LEFT JOIN xg5ba_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	6	100.00	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	new58872_db.s.template,const	1	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.06 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.05 ms

Call Stack

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.49 ms After last query: 3.59 ms Query memory: 0.005 MB Memory before query: 2.316 MB Rows returned: 235

SELECT config_key, config_value

  FROM xg5ba_eshop_configs

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.29 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
9	JDatabaseDriver->loadObjectList()	JROOT/components/com_eshop/helpers/helper.php:32
8	EshopHelper::getConfig()	JROOT/components/com_eshop/helpers/helper.php:134
7	EshopHelper::getConfigValue()	JROOT/components/com_eshop/eshop.php:62
6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.84 ms After last query: 4.19 ms Query memory: 0.007 MB Memory before query: 2.467 MB Rows returned: 1

SELECT a.*, b.product_name, b.product_alias, b.product_desc, b.product_short_desc, b.product_page_title, b.product_page_heading, b.meta_key, b.meta_desc, b.tab1_title, b.tab1_content, b.tab2_title, b.tab2_content, b.tab3_title, b.tab3_content, b.tab4_title, b.tab4_content, b.tab5_title, b.tab5_content

  FROM xg5ba_eshop_products AS a

  INNER JOIN xg5ba_eshop_productdetails AS b 
  ON (a.id = b.product_id)

  WHERE a.id = 5 
  AND a.published = 1 
  AND b.language = "en-GB" 
  AND ((a.product_customergroups = "") OR (a.product_customergroups IS NULL) OR (a.product_customergroups = "1") OR (a.product_customergroups LIKE "1,%") OR (a.product_customergroups LIKE "%,1,%") OR (a.product_customergroups LIKE "%,1")) 
  AND (a.product_available_date = "0000-00-00 00:00:00" OR a.product_available_date <= '2019-02-19 21:56:10') 
  AND ((a.product_languages = "") OR (a.product_languages IS NULL) OR (a.product_languages = "en-GB") OR (a.product_languages LIKE "en-GB,%") OR (a.product_languages LIKE "%,en-GB,%") OR (a.product_languages LIKE "%,en-GB"))

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	b	ref	product_id	product_id	5	const	1	100.00	Using where

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.06 ms
System lock	0.00 ms
optimizing	0.02 ms
statistics	0.30 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.18 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
13	JDatabaseDriver->loadObject()	JROOT/components/com_eshop/models/product.php:113
12	EShopModelProduct->_loadData()	JROOT/components/com_eshop/models/product.php:58
11	EShopModelProduct->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_eshop/views/product/view.html.php:33
9	EShopViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:101
6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.23 ms After last query: 0.16 ms Query memory: 0.006 MB Memory before query: 2.486 MB Rows returned: 3

Duplicate queries: #99 #100 #101 #102 #104 #105 #107

SELECT *

  FROM xg5ba_eshop_currencies

  WHERE published = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	xg5ba_eshop_currencies	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	3	100.00	Using where

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.13 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.06 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_eshop/helpers/currency.php:52
10	EshopCurrency->__construct()	JROOT/components/com_eshop/views/product/view.html.php:34
9	EShopViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:101
6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.48 ms After last query: 0.08 ms Query memory: 0.006 MB Memory before query: 2.497 MB Rows returned: 1

SELECT a.id

  FROM xg5ba_eshop_categories AS a

  INNER JOIN xg5ba_eshop_productcategories AS b 
  ON a.id = b.category_id

  WHERE b.product_id = 5

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	b	ref	product_id,category_id	product_id	5	const	1	100.00	Using where
1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	4	new58872_db.b.category_id	1	100.00	Using index

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.13 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.19 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
10	JDatabaseDriver->loadResult()	JROOT/components/com_eshop/views/product/view.html.php:84
9	EShopViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:101
6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.16 ms After last query: 0.05 ms Query memory: 0.006 MB Memory before query: 2.507 MB

UPDATE xg5ba_eshop_products

  SET hits = hits + 1

  WHERE id = 5

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	xg5ba_eshop_products	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.02 ms
updating	0.04 ms
end	0.00 ms
Waiting for query cache lock	0.00 ms
end	0.01 ms
query end	0.03 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/components/com_eshop/helpers/helper.php:495
10	EshopHelper::updateHits()	JROOT/components/com_eshop/views/product/view.html.php:115
9	EShopViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:101
6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.98 ms After last query: 0.11 ms Query memory: 0.006 MB Memory before query: 2.513 MB Rows returned: 1

SELECT stockstatus_name

  FROM xg5ba_eshop_stockstatusdetails

  WHERE stockstatus_id = 2 
  AND language = "en-GB"

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	xg5ba_eshop_stockstatusdetails	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	4	100.00	Using where

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.94 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.92 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
11	JDatabaseDriver->loadResult()	JROOT/components/com_eshop/helpers/helper.php:517
10	EshopHelper::getStockStatusName()	JROOT/components/com_eshop/views/product/view.html.php:176
9	EShopViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:101
6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.42 ms After last query: 0.05 ms Query memory: 0.006 MB Memory before query: 2.520 MB Rows returned: 5

SELECT a.*

  FROM xg5ba_eshop_tags AS a

  INNER JOIN xg5ba_eshop_producttags AS b 
  ON (a.id = b.tag_id)

  WHERE a.published = 1 
  AND b.product_id = 5

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	b	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	139	100.00	Using where
1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	4	new58872_db.b.tag_id	1	100.00	Using where

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.28 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_eshop/helpers/helper.php:1393
10	EshopHelper::getProductTags()	JROOT/components/com_eshop/views/product/view.html.php:190
9	EShopViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:101
6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.22 ms After last query: 0.04 ms Query memory: 0.006 MB Memory before query: 2.526 MB Rows returned: 0

SELECT *

  FROM xg5ba_eshop_productattachments

  WHERE product_id = 5

  ORDER BY ordering

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.12 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
10	JDatabaseDriver->loadObjectList()	JROOT/components/com_eshop/views/product/view.html.php:200
9	EShopViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:101
6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.39 ms After last query: 2.08 ms Query memory: 0.006 MB Memory before query: 2.624 MB Rows returned: 3

SELECT pi.*

  FROM xg5ba_eshop_productimages AS pi

  WHERE product_id = 5

  ORDER BY pi.ordering

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.20 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_eshop/helpers/helper.php:1371
10	EshopHelper::getProductImages()	JROOT/components/com_eshop/views/product/view.html.php:230
9	EShopViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:101
6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.26 ms After last query: 0.19 ms Query memory: 0.006 MB Memory before query: 2.636 MB Rows returned: 0

SELECT quantity, price

  FROM xg5ba_eshop_productdiscounts

  WHERE product_id = 5 
  AND published = 1 
  AND customergroup_id = 1 
  AND (date_start <= "2019-02-19 15:56:10" OR date_start = "0000-00-00 00:00:00") 
  AND (date_end >= "2019-02-19 15:56:10" OR date_end = "0000-00-00 00:00:00") 
  AND quantity > 1

  ORDER BY priority

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.12 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_eshop/helpers/helper.php:1690
10	EshopHelper::getDiscountPrices()	JROOT/components/com_eshop/views/product/view.html.php:262
9	EShopViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:101
6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.45 ms After last query: 0.04 ms Query memory: 0.006 MB Memory before query: 2.644 MB Rows returned: 0

SELECT o.id, o.option_type, o.option_image, od.option_name, od.option_desc, po.required, po.id AS product_option_id

  FROM xg5ba_eshop_options AS o

  INNER JOIN xg5ba_eshop_optiondetails AS od 
  ON (o.id = od.option_id)

  INNER JOIN xg5ba_eshop_productoptions AS po 
  ON (o.id = po.option_id)

  WHERE po.product_id = 5 
  AND od.language = 'en-GB' 
  AND o.published = 1

  ORDER BY o.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	o	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where; Using filesort
1	SIMPLE	od	ref	option_id	option_id	5	new58872_db.o.id	1	100.00	Using where
1	SIMPLE	po	ref	product_id,option_id	product_id	5	const	1	100.00	Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.13 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.14 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.04 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_eshop/helpers/helper.php:1327
10	EshopHelper::getProductOptions()	JROOT/components/com_eshop/views/product/view.html.php:263
9	EShopViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:101
6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT a.id, b.attributegroup_name

  FROM xg5ba_eshop_attributegroups AS a

  INNER JOIN xg5ba_eshop_attributegroupdetails AS b 
  ON (a.id = b.attributegroup_id)

  WHERE a.published = 1 
  AND b.language = 'en-GB'

  ORDER BY a.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where; Using filesort
1	SIMPLE	b	ref	attributegroup_id	attributegroup_id	5	new58872_db.a.id	1	100.00	Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.29 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.01 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_eshop/helpers/helper.php:727
10	EshopHelper::getAttributeGroups()	JROOT/components/com_eshop/views/product/view.html.php:265
9	EShopViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:101
6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.94 ms After last query: 0.06 ms Query memory: 0.006 MB Memory before query: 2.657 MB Rows returned: 28

SELECT ad.attribute_name, pad.value

  FROM xg5ba_eshop_attributes AS a

  INNER JOIN xg5ba_eshop_attributedetails AS ad 
  ON (a.id = ad.attribute_id)

  INNER JOIN xg5ba_eshop_productattributes AS pa 
  ON (a.id = pa.attribute_id)

  INNER JOIN xg5ba_eshop_productattributedetails AS pad 
  ON (pa.id = pad.productattribute_id)

  WHERE a.attributegroup_id = 1 
  AND a.published = 1 
  AND pa.published = 1 
  AND pa.product_id = 5 
  AND ad.language = "en-GB" 
  AND pad.language = 'en-GB'

  ORDER BY a.ordering, pad.value

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pa	ref	PRIMARY,product_id,attribute_id	product_id	5	const	28	100.00	Using where; Using temporary; Using filesort
1	SIMPLE	a	eq_ref	PRIMARY,attributegroup_id	PRIMARY	4	new58872_db.pa.attribute_id	1	100.00	Using where
1	SIMPLE	ad	ref	attribute_id	attribute_id	5	new58872_db.pa.attribute_id	1	100.00	Using where
1	SIMPLE	pad	ref	productattribute_id	productattribute_id	5	new58872_db.pa.id	1	100.00	Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.26 ms
preparing	0.02 ms
Creating tmp table	0.02 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	1.41 ms
Creating sort index	0.04 ms
end	0.00 ms
removing tmp table	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.03 ms
freeing items	0.01 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_eshop/helpers/helper.php:762
10	EshopHelper::getAttributes()	JROOT/components/com_eshop/views/product/view.html.php:270
9	EShopViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:101
6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.25 ms After last query: 0.07 ms Query memory: 0.006 MB Memory before query: 2.680 MB Rows returned: 0

SELECT p.*, pd.product_name, pd.product_alias, pd.product_desc, pd.product_short_desc, pd.meta_key, pd.meta_desc

  FROM xg5ba_eshop_products AS p

  INNER JOIN xg5ba_eshop_productdetails AS pd 
  ON (p.id = pd.product_id)

  INNER JOIN xg5ba_eshop_productrelations AS pr 
  ON (p.id = pr.related_product_id)

  WHERE p.published = 1 
  AND pr.product_id = 5 
  AND pd.language = 'en-GB'

  ORDER BY p.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pr	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	46	100.00	Using where; Using temporary; Using filesort
1	SIMPLE	p	eq_ref	PRIMARY	PRIMARY	4	new58872_db.pr.related_product_id	1	100.00	Using where
1	SIMPLE	pd	ref	product_id	product_id	5	new58872_db.pr.related_product_id	1	100.00	Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
Creating tmp table	0.04 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	1.67 ms
Creating sort index	0.01 ms
end	0.00 ms
removing tmp table	0.30 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_eshop/helpers/helper.php:1159
10	EshopHelper::getProductRelations()	JROOT/components/com_eshop/views/product/view.html.php:274
9	EShopViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:101
6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.26 ms After last query: 0.05 ms Query memory: 0.006 MB Memory before query: 2.684 MB Rows returned: 0

SELECT *

  FROM xg5ba_eshop_reviews

  WHERE product_id = 5 
  AND published = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	xg5ba_eshop_reviews	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	16	100.00	Using where

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.15 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_eshop/helpers/helper.php:1208
10	EshopHelper::getProductReviews()	JROOT/components/com_eshop/views/product/view.html.php:303
9	EShopViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:101
6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.45 ms After last query: 0.22 ms Query memory: 0.006 MB Memory before query: 2.696 MB Rows returned: 1

SELECT m.id, m.manufacturer_email, md.manufacturer_name

  FROM xg5ba_eshop_products AS p

  INNER JOIN xg5ba_eshop_manufacturers AS m 
  ON (p.manufacturer_id = m.id)

  INNER JOIN xg5ba_eshop_manufacturerdetails AS md 
  ON (m.id = md.manufacturer_id)

  WHERE p.id = 5 
  AND md.language = 'en-GB'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	p	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	m	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	md	ref	manufacturer_id	manufacturer_id	5	const	1	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.25 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.07 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
11	JDatabaseDriver->loadObject()	JROOT/components/com_eshop/helpers/helper.php:1129
10	EshopHelper::getProductManufacturer()	JROOT/components/com_eshop/views/product/view.html.php:328
9	EShopViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:101
6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.15 ms After last query: 0.23 ms Query memory: 0.006 MB Memory before query: 2.704 MB Rows returned: 1

SELECT a.category_id

  FROM xg5ba_eshop_productcategories AS a

  INNER JOIN xg5ba_eshop_categories AS b 
  ON (a.category_id = b.id)

  WHERE a.product_id = 5 
  AND a.main_category = 1 
  AND b.published = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ref	product_id,category_id	product_id	5	const	1	100.00	Using where
1	SIMPLE	b	eq_ref	PRIMARY	PRIMARY	4	new58872_db.a.category_id	1	100.00	Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
12	JDatabaseDriver->loadResult()	JROOT/components/com_eshop/helpers/helper.php:1101
11	EshopHelper::getProductCategory()	JROOT/components/com_eshop/helpers/helper.php:4525
10	EshopHelper::getProductsNavigation()	JROOT/components/com_eshop/views/product/view.html.php:342
9	EShopViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:101
6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.48 ms After last query: 0.04 ms Query memory: 0.006 MB Memory before query: 2.711 MB Rows returned: 3

SELECT a.id, b.product_id, b.product_name, b.product_page_title, pc.category_id

  FROM xg5ba_eshop_products AS a

  INNER JOIN xg5ba_eshop_productdetails AS b 
  ON (a.id = b.product_id)

  INNER JOIN xg5ba_eshop_productcategories AS pc 
  ON (a.id = pc.product_id)

  WHERE a.published = 1 
  AND pc.category_id = 1 
  AND b.language = 'en-GB'

  ORDER BY a.ordering ASC,a.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pc	ref	product_id,category_id	category_id	5	const	11	100.00	Using where; Using temporary; Using filesort
1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	4	new58872_db.pc.product_id	1	100.00	Using where
1	SIMPLE	b	ref	product_id	product_id	5	new58872_db.pc.product_id	1	100.00	Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.01 ms
Creating tmp table	0.02 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.20 ms
Creating sort index	0.01 ms
end	0.00 ms
removing tmp table	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.01 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_eshop/helpers/helper.php:4565
10	EshopHelper::getProductsNavigation()	JROOT/components/com_eshop/views/product/view.html.php:342
9	EShopViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:101
6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.31 ms After last query: 0.06 ms Query memory: 0.006 MB Memory before query: 2.717 MB Rows returned: 0

SELECT DISTINCT(label_id)

  FROM xg5ba_eshop_labelelements

  WHERE (element_type = "product" 
  AND element_id = 5) OR (element_type = "manufacturer" 
  AND element_id = (SELECT manufacturer_id 
  FROM xg5ba_eshop_products 
  WHERE id = 5)) OR (element_type = "category" 
  AND element_id IN (SELECT category_id 
  FROM xg5ba_eshop_productcategories 
  WHERE product_id = 5))

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	xg5ba_eshop_labelelements	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where; Using temporary
3	DEPENDENT SUBQUERY	xg5ba_eshop_productcategories	ref	product_id,category_id	product_id	5	const	1	100.00	Using where
2	SUBQUERY	xg5ba_eshop_products	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
Creating tmp table	0.01 ms
executing	0.00 ms
Sending data	0.12 ms
end	0.00 ms
removing tmp table	0.00 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
11	JDatabaseDriver->loadColumn()	JROOT/components/com_eshop/helpers/helper.php:4859
10	EshopHelper::getProductLabels()	JROOT/components/com_eshop/views/product/view.html.php:343
9	EShopViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:101
6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.47 ms After last query: 0.61 ms Query memory: 0.008 MB Memory before query: 2.751 MB Rows returned: 10

SELECT a.id, a.category_parent_id, b.category_alias

  FROM xg5ba_eshop_categories AS a

  INNER JOIN xg5ba_eshop_categorydetails AS b 
  ON (a.id = b.category_id)

  WHERE b.language = 'en-GB'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	10	100.00	NULL
1	SIMPLE	b	ref	category_id	category_id	5	new58872_db.a.id	1	100.00	Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.24 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.01 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_eshop/helpers/helper.php:4605
14	EshopHelper::getCategoryPath()	JROOT/components/com_eshop/helpers/route.php:41
13	EshopRoute::getProductRoute()	JROOT/components/com_eshop/themes/default/views/product/default.php:73
12	include JROOT/components/com_eshop/themes/default/views/product/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_eshop/libraries/mvc/view.php:88
10	EShopView->display()	JROOT/components/com_eshop/views/product/view.html.php:360
9	EShopViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:101
6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.17 ms After last query: 0.26 ms Query memory: 0.009 MB Memory before query: 2.766 MB Rows returned: 1

Duplicate queries: #42

SELECT AVG(rating) as rating

  FROM xg5ba_eshop_reviews

  WHERE product_id = 5 
  AND published = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	xg5ba_eshop_reviews	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	16	100.00	Using where

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
14	JDatabaseDriver->loadResult()	JROOT/components/com_eshop/helpers/helper.php:1229
13	EshopHelper::getProductRating()	JROOT/components/com_eshop/themes/default/views/product/default.php:135
12	include JROOT/components/com_eshop/themes/default/views/product/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_eshop/libraries/mvc/view.php:88
10	EShopView->display()	JROOT/components/com_eshop/views/product/view.html.php:360
9	EShopViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:101
6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT weight_unit

  FROM xg5ba_eshop_weightdetails

  WHERE weight_id = 4 
  AND language = "en-GB"

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	xg5ba_eshop_weightdetails	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	4	100.00	Using where

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.14 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
14	JDatabaseDriver->loadResult()	JROOT/components/com_eshop/helpers/helper.php:583
13	EshopHelper::getWeightUnit()	JROOT/components/com_eshop/themes/default/views/product/default.php:367
12	include JROOT/components/com_eshop/themes/default/views/product/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_eshop/libraries/mvc/view.php:88
10	EShopView->display()	JROOT/components/com_eshop/views/product/view.html.php:360
9	EShopViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:101
6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Duplicate queries: #36 #37

SELECT length_unit

  FROM xg5ba_eshop_lengthdetails

  WHERE length_id = 2 
  AND language = "en-GB"

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	xg5ba_eshop_lengthdetails	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	3	100.00	Using where

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.13 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
14	JDatabaseDriver->loadResult()	JROOT/components/com_eshop/helpers/helper.php:561
13	EshopHelper::getLengthUnit()	JROOT/components/com_eshop/themes/default/views/product/default.php:376
12	include JROOT/components/com_eshop/themes/default/views/product/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_eshop/libraries/mvc/view.php:88
10	EShopView->display()	JROOT/components/com_eshop/views/product/view.html.php:360
9	EShopViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:101
6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Duplicate queries: #35 #37

SELECT length_unit

  FROM xg5ba_eshop_lengthdetails

  WHERE length_id = 2 
  AND language = "en-GB"

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	xg5ba_eshop_lengthdetails	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	3	100.00	Using where

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
14	JDatabaseDriver->loadResult()	JROOT/components/com_eshop/helpers/helper.php:561
13	EshopHelper::getLengthUnit()	JROOT/components/com_eshop/themes/default/views/product/default.php:376
12	include JROOT/components/com_eshop/themes/default/views/product/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_eshop/libraries/mvc/view.php:88
10	EShopView->display()	JROOT/components/com_eshop/views/product/view.html.php:360
9	EShopViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:101
6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Duplicate queries: #35 #36

SELECT length_unit

  FROM xg5ba_eshop_lengthdetails

  WHERE length_id = 2 
  AND language = "en-GB"

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	xg5ba_eshop_lengthdetails	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	3	100.00	Using where

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
14	JDatabaseDriver->loadResult()	JROOT/components/com_eshop/helpers/helper.php:561
13	EshopHelper::getLengthUnit()	JROOT/components/com_eshop/themes/default/views/product/default.php:376
12	include JROOT/components/com_eshop/themes/default/views/product/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_eshop/libraries/mvc/view.php:88
10	EShopView->display()	JROOT/components/com_eshop/views/product/view.html.php:360
9	EShopViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:101
6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.32 ms After last query: 0.31 ms Query memory: 0.008 MB Memory before query: 2.809 MB Rows returned: 1

SELECT price

  FROM xg5ba_eshop_productspecials

  WHERE product_id = 5 
  AND published = 1 
  AND customergroup_id = 1 
  AND (date_start <= "2019-02-19 15:56:10" OR date_start = "0000-00-00 00:00:00") 
  AND (date_end >= "2019-02-19 15:56:10" OR date_end = "0000-00-00 00:00:00")

  ORDER BY priority 
  LIMIT 1

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.15 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
15	JDatabaseDriver->loadResult()	JROOT/components/com_eshop/helpers/helper.php:1744
14	EshopHelper::getSpecialPrice()	JROOT/components/com_eshop/helpers/helper.php:1923
13	EshopHelper::getProductPriceArray()	JROOT/components/com_eshop/themes/default/views/product/default.php:454
12	include JROOT/components/com_eshop/themes/default/views/product/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_eshop/libraries/mvc/view.php:88
10	EShopView->display()	JROOT/components/com_eshop/views/product/view.html.php:360
9	EShopViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:101
6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.68 ms After last query: 0.17 ms Query memory: 0.008 MB Memory before query: 2.821 MB Rows returned: 0

SELECT a.*

  FROM xg5ba_eshop_discounts AS a

  INNER JOIN xg5ba_eshop_discountelements AS b 
  ON (a.id = b.discount_id)

  WHERE a.published = 1 
  AND b.element_type = "product" 
  AND (b.element_id = 5 OR b.element_id = 0) 
  AND ((a.discount_customergroups = "") OR (a.discount_customergroups IS NULL) OR (a.discount_customergroups = "1") OR (a.discount_customergroups LIKE "1,%") OR (a.discount_customergroups LIKE "%,1,%") OR (a.discount_customergroups LIKE "%,1")) 
  AND (a.discount_start_date = "0000-00-00 00:00:00" OR DATE(a.discount_start_date) <= '2019-02-19') 
  AND (a.discount_end_date = "0000-00-00 00:00:00" OR DATE(a.discount_end_date) >= '2019-02-19')

  ORDER BY a.id DESC 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	b	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where; Using temporary; Using filesort
1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	4	new58872_db.b.discount_id	1	100.00	Using where

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
Creating tmp table	0.02 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	1.13 ms
Creating sort index	0.01 ms
end	0.00 ms
removing tmp table	0.29 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
15	JDatabaseDriver->loadObject()	JROOT/components/com_eshop/helpers/helper.php:1769
14	EshopHelper::getSpecialPrice()	JROOT/components/com_eshop/helpers/helper.php:1923
13	EshopHelper::getProductPriceArray()	JROOT/components/com_eshop/themes/default/views/product/default.php:454
12	include JROOT/components/com_eshop/themes/default/views/product/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_eshop/libraries/mvc/view.php:88
10	EShopView->display()	JROOT/components/com_eshop/views/product/view.html.php:360
9	EShopViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:101
6	require_once JROOT/components/com_eshop/eshop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.11 ms After last query: 0.06 ms Query memory: 0.008 MB Memory before query: 2.829 MB Rows returned: 0

Update Interval	60-Second	30-Second	10-Second	5-Second	3-Second
Data	Unlimited	Unlimited	Unlimited	Unlimited	Unlimited
Price	$24.95	$34.95	$39.95	$44.95	$49.95

Shopping Cart

SilverCloud Tag

SilverCloud Tag

Price: $259.00 $199.00

Verified Merchant

Product

Information

Search

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

108 Queries Logged 27.64 ms

68 duplicate found!