Julieta y Romeo

Menu:

Loading…

Cigars
Leather & Pearls
Swarovski Pearls

^Featured

Swarovski Pearl Choker (Cream/Bronze)

Julieta y Romeo offers unique, handmade jewelry and premium hand-rolled cigars. We are passionate about our products and know that you will find our passion and integrity reflected in their quality.
Cathy Neff-Siegers

DAS Premium Hand-rolled Cigars

DAS cigars originated on the island of St. Maarten in 2003 and were initially sold only on the island. In 2005, we opened a small retain store in Harbor Springs, Michigan where Cat (Cathy) has maintained...

A Word On Cigars

Long before the discovery of the Americas, cigars have been a sign of pleasure and thanksgiving. The Caribbean Indians after the Areito (Indian ritual dance), would light up tobacco as a form of communication with their...

Glossary of Cigar Terms

Band - The ring of paper with the name of the cigar brand, wrapped near the closed head of the cigar and usually held on with a vegetable based glue. Binder - The portion of a tobacco...

Perfect Gifts_{For both Him and Her}
100% Satisfaction_{Guaranteed Easy Return Policy}
Flat Rate Shipping_{Anywhere in the US}
Call Us For Info_231-838-5661

View Cart

Log in

create an account

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1623920636,
                "last": 1623920636,
                "now": 1623920636
            },
            "token": "N6ZpsyinbrkfTg4VWiWw79PFZdDXDKnh"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Profile Information

Time

Memory

Time: 13.37 ms / 13.37 ms Memory: 1.484 MB / 1.84 MB Application: afterLoad

Time: 408.94 ms / 422.31 ms Memory: 5.329 MB / 7.17 MB Application: afterInitialise

Time: 74.67 ms / 496.98 ms Memory: 1.851 MB / 9.02 MB Application: Before Access::preloadComponents (all components)

Time: 0.80 ms / 497.79 ms Memory: 0.059 MB / 9.08 MB Application: After Access::preloadComponents (all components)

Time: 0.02 ms / 497.81 ms Memory: 0.000 MB / 9.08 MB Application: Before Access::getAssetRules (id:16 name:com_menus)

Time: 0.35 ms / 498.16 ms Memory: 0.024 MB / 9.10 MB Application: After Access::getAssetRules (id:16 name:com_menus)

Time: 3.71 ms / 501.87 ms Memory: 0.473 MB / 9.58 MB Application: afterRoute

Time: 0.51 ms / 502.38 ms Memory: 0.147 MB / 9.72 MB Application: beforeRenderComponent com_content

Time: 4.01 ms / 506.39 ms Memory: 0.594 MB / 10.32 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Time: 0.04 ms / 506.43 ms Memory: 0.007 MB / 10.32 MB Application: After Access::getAssetRules (id:8 name:com_content)

Time: 5.12 ms / 511.55 ms Memory: 0.348 MB / 10.67 MB Application: afterRenderComponent com_content

Time: 1.07 ms / 512.62 ms Memory: 0.104 MB / 10.78 MB Application: afterDispatch

Time: 22.59 ms / 535.21 ms Memory: 2.279 MB / 13.06 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Time: 0.04 ms / 535.25 ms Memory: 0.007 MB / 13.06 MB Application: After Access::getAssetRules (id:1 name:root.1)

Time: 0.02 ms / 535.26 ms Memory: 0.000 MB / 13.06 MB Application: Before Access::getAssetRules (id:207 name:com_virtuemart)

Time: 0.01 ms / 535.27 ms Memory: 0.002 MB / 13.06 MB Application: After Access::getAssetRules (id:207 name:com_virtuemart)

Time: 10.37 ms / 545.64 ms Memory: 0.180 MB / 13.24 MB Application: beforeRenderModule mod_login (Login)

Time: 1.60 ms / 547.24 ms Memory: 0.188 MB / 13.43 MB Application: afterRenderModule mod_login (Login)

Time: 0.04 ms / 547.28 ms Memory: 0.000 MB / 13.43 MB Application: beforeRenderModule mod_custom (Links)

Time: 0.22 ms / 547.50 ms Memory: 0.006 MB / 13.44 MB Application: afterRenderModule mod_custom (Links)

Time: 0.02 ms / 547.52 ms Memory: 0.000 MB / 13.43 MB Application: beforeRenderModule mod_custom (Sign up for our newsletter)

Time: 0.11 ms / 547.63 ms Memory: 0.003 MB / 13.44 MB Application: afterRenderModule mod_custom (Sign up for our newsletter)

Time: 0.03 ms / 547.66 ms Memory: 0.001 MB / 13.44 MB Application: beforeRenderModule mod_custom (Features)

Time: 0.10 ms / 547.76 ms Memory: 0.003 MB / 13.44 MB Application: afterRenderModule mod_custom (Features)

Time: 0.09 ms / 547.85 ms Memory: 0.042 MB / 13.48 MB Application: beforeRenderModule mod_news_pro_gk5 (From our blog)

Time: 5.82 ms / 553.67 ms Memory: 0.583 MB / 14.07 MB Application: afterRenderModule mod_news_pro_gk5 (From our blog)

Time: 0.05 ms / 553.72 ms Memory: 0.000 MB / 13.95 MB Application: beforeRenderModule mod_custom (Unique, Handmade Gifts For Him & Her)

Time: 0.11 ms / 553.84 ms Memory: 0.003 MB / 13.96 MB Application: afterRenderModule mod_custom (Unique, Handmade Gifts For Him & Her)

Time: 0.04 ms / 553.88 ms Memory: 0.003 MB / 13.96 MB Application: beforeRenderModule mod_tabs_gk5 (Featured)

Time: 2.45 ms / 556.33 ms Memory: 0.261 MB / 14.22 MB Application: beforeRenderModule mod_news_pro_gk5 (Tab - Featured Cigars)

Time: 39.68 ms / 596.01 ms Memory: 4.563 MB / 18.78 MB Application: afterRenderModule mod_news_pro_gk5 (Tab - Featured Cigars)

Time: 0.09 ms / 596.11 ms Memory: 0.000 MB / 18.71 MB Application: beforeRenderModule mod_news_pro_gk5 (Tab - leather & pearls)

Time: 14.60 ms / 610.71 ms Memory: 0.850 MB / 19.56 MB Application: afterRenderModule mod_news_pro_gk5 (Tab - leather & pearls)

Time: 0.09 ms / 610.79 ms Memory: 0.000 MB / 19.50 MB Application: beforeRenderModule mod_news_pro_gk5 (Tab - Mother of Pearl)

Time: 13.08 ms / 623.88 ms Memory: 0.825 MB / 20.32 MB Application: afterRenderModule mod_news_pro_gk5 (Tab - Mother of Pearl)

Time: 0.07 ms / 623.95 ms Memory: 0.000 MB / 20.23 MB Application: afterRenderModule mod_tabs_gk5 (Featured)

Time: 0.11 ms / 624.06 ms Memory: 0.000 MB / 20.23 MB Application: beforeRenderModule mod_image_show_gk4 (Julieta)

Time: 1.36 ms / 625.42 ms Memory: 0.151 MB / 20.38 MB Application: afterRenderModule mod_image_show_gk4 (Julieta)

Time: 0.10 ms / 625.53 ms Memory: 0.000 MB / 20.31 MB Application: beforeRenderModule mod_image_show_gk4 (Romeo)

Time: 0.38 ms / 625.91 ms Memory: 0.077 MB / 20.38 MB Application: afterRenderModule mod_image_show_gk4 (Romeo)

Time: 0.05 ms / 625.96 ms Memory: 0.000 MB / 20.29 MB Application: beforeRenderModule mod_virtuemart_search (Search VM)

Time: 1.72 ms / 627.68 ms Memory: 0.122 MB / 20.41 MB Application: afterRenderModule mod_virtuemart_search (Search VM)

Time: 0.11 ms / 627.79 ms Memory: 0.041 MB / 20.46 MB Application: beforeRenderModule mod_news_pro_gk5 (Rotate Products - Men)

Time: 1.80 ms / 629.59 ms Memory: 0.092 MB / 20.55 MB Application: afterRenderModule mod_news_pro_gk5 (Rotate Products - Men)

Time: 0.13 ms / 629.72 ms Memory: 0.000 MB / 20.48 MB Application: beforeRenderModule mod_news_pro_gk5 (Rotate Products - Women)

Time: 337.47 ms / 967.18 ms Memory: 0.097 MB / 20.58 MB Application: afterRenderModule mod_news_pro_gk5 (Rotate Products - Women)

Time: 0.16 ms / 967.35 ms Memory: 0.000 MB / 20.51 MB Application: beforeRenderModule mod_news_pro_gk5 (Rotate Products - Women)

Time: 2.75 ms / 970.10 ms Memory: 0.097 MB / 20.61 MB Application: afterRenderModule mod_news_pro_gk5 (Rotate Products - Women)

Time: 12.55 ms / 982.65 ms Memory: 0.296 MB / 20.91 MB Application: afterRender

Database queries total: 472.20 ms

Memory Usage

Database Queries

159 Queries Logged 472.20 ms

4 duplicate found!

2 duplicates: #20 #159

2 duplicates: #21 #144

Query Time: 0.36 ms Query memory: 0.023 MB Memory before query: 3.314 MB Rows returned: 0

SELECT `data`

  FROM `wxuhk_session`

  WHERE `session_id` = X'3764353132623133313237646131623434313165393431306130383264323765'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	wxuhk_session	const	PRIMARY	PRIMARY	194	const	1

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:1740
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.22 ms After last query: 0.82 ms Query memory: 0.020 MB Memory before query: 3.466 MB Rows returned: 0

SELECT `session_id`

  FROM `wxuhk_session`

  WHERE `session_id` = X'3764353132623133313237646131623434313165393431306130383264323765' 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	wxuhk_session	const	PRIMARY	PRIMARY	194	const	1	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:1740
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: 347.57 ms After last query: 0.07 ms Query memory: 0.004 MB Memory before query: 3.471 MB

INSERT INTO `wxuhk_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'3764353132623133313237646131623434313165393431306130383264323765', 1, 1623920636, 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `wxuhk_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3764353132623133313237646131623434313165393431306130383264323765', 1, 1623920636, 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: 15.19 ms After last query: 2.07 ms Query memory: 0.025 MB Memory before query: 3.663 MB Rows returned: 43

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

  FROM `wxuhk_extensions`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	wxuhk_extensions	ref	extension	extension	82	const	43	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:1701
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.31 ms After last query: 1.64 ms Query memory: 0.021 MB Memory before query: 3.849 MB Rows returned: 3

SELECT id, rules

  FROM `wxuhk_viewlevels`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	wxuhk_viewlevels	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	3

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:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php: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.36 ms After last query: 0.07 ms Query memory: 0.021 MB Memory before query: 3.861 MB Rows returned: 1

SELECT b.id

  FROM wxuhk_usergroups AS a

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

  WHERE a.id = 1

Explain

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

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:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php: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: 1.42 ms After last query: 0.46 ms Query memory: 0.031 MB Memory before query: 3.926 MB Rows returned: 114

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

  FROM wxuhk_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	Extra
1	SIMPLE	wxuhk_extensions	ref	extension	extension	82	const	158	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:1701
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.41 ms After last query: 19.05 ms Query memory: 0.025 MB Memory before query: 6.329 MB Rows returned: 1

SELECT id,template 
  FROM wxuhk_template_styles 
  WHERE client_id=0 
  AND home=1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	wxuhk_template_styles	ALL	idx_client_id,idx_client_id_home	NO INDEX KEY COULD BE USED	NULL	NULL	5	Using where

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_widgetkit/widgetkit.php:23
16	plgSystemWidgetkit->{closure}()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Container.php:240
15	YOOtheme\Framework\Container->offsetGet()	JROOT/administrator/components/com_widgetkit/src/Application.php:49
14	YOOtheme\Widgetkit\Application->YOOtheme\Widgetkit\{closure}()	Same as call in the line below.
13	call_user_func_array()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Event/EventDispatcher.php:113
12	YOOtheme\Framework\Event\EventDispatcher->trigger()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Application.php:149
11	YOOtheme\Framework\Application->boot()	JROOT/administrator/components/com_widgetkit/widgetkit.php:91
10	include JROOT/administrator/components/com_widgetkit/widgetkit.php	JROOT/administrator/components/com_widgetkit/widgetkit-app.php:6
9	include JROOT/administrator/components/com_widgetkit/widgetkit-app.php	JROOT/plugins/system/widgetkit/widgetkit.php:9
8	plgSystemWidgetkit->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.45 ms After last query: 8.97 ms Query memory: 0.096 MB Memory before query: 7.348 MB Rows returned: 76

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 wxuhk_menu AS m

  LEFT JOIN wxuhk_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	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	2	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	cats_db.m.component_id	1	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:1701
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.40 ms After last query: 7.30 ms Query memory: 0.024 MB Memory before query: 8.386 MB Rows returned: 1

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

  FROM `wxuhk_extensions`

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

Explain

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

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:1662
18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{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/Helper/LibraryHelper.php:175
14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/k2/k2.php:388
8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 57.57 ms After last query: 0.14 ms Query memory: 0.006 MB Memory before query: 8.379 MB

UPDATE `wxuhk_extensions`

  SET `params` = '{\"mediaversion\":\"55f8badb20b266b3239d82c061246a6b\"}'

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

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.39 ms After last query: 2.74 ms Query memory: 0.022 MB Memory before query: 8.757 MB Rows returned: 1

SELECT *

  FROM wxuhk_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
12	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
11	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/components/com_k2/helpers/utilities.php:243
10	K2HelperUtilities::getParams()	JROOT/administrator/components/com_k2/helpers/html.php:53
9	K2HelperHTML::loadHeadIncludes()	JROOT/plugins/system/k2/k2.php:404
8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.40 ms After last query: 2.06 ms Query memory: 0.025 MB Memory before query: 8.983 MB Rows returned: 3

SELECT id, home, template, s.params

  FROM wxuhk_template_styles as s

  LEFT JOIN wxuhk_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	Extra
1	SIMPLE	s	ALL	idx_template,idx_client_id,idx_client_id_home	NO INDEX KEY COULD BE USED	NULL	NULL	5	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	cats_db.s.template,const	1	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
19	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/HTML/HTMLHelper.php:365
18	Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles()	JROOT/libraries/src/HTML/HTMLHelper.php:712
17	Joomla\CMS\HTML\HTMLHelper::script()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/cms/html/jquery.php:52
13	JHtmlJquery::framework()	Same as call in the line below.
12	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
11	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
10	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/administrator/components/com_k2/helpers/html.php:71
9	K2HelperHTML::loadHeadIncludes()	JROOT/plugins/system/k2/k2.php:404
8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.65 ms After last query: 0.83 ms Query memory: 0.028 MB Memory before query: 9.027 MB Rows returned: 43

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `wxuhk_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_advancedmodules','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jce','com_joomlaupdate','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_rereplacer','com_search','com_tags','com_tcpdf','com_templates','com_users','com_virtuemart','com_virtuemart_allinone','com_widgetkit','com_wrapper')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	wxuhk_assets	ALL	idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	144	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:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
17	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
16	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
15	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
14	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
13	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/advancedmodules/src/Document.php:28
12	RegularLabs\Plugin\System\AdvancedModules\Document::loadFrontEditScript()	JROOT/plugins/system/advancedmodules/src/Helper.php:32
11	RegularLabs\Plugin\System\AdvancedModules\Helper->onAfterRoute()	Same as call in the line below.
10	call_user_func_array()	JROOT/plugins/system/advancedmodules/src/Plugin.php:97
9	RegularLabs\Plugin\System\AdvancedModules\Plugin->run()	JROOT/plugins/system/advancedmodules/advancedmodules.php:64
8	PlgSystemAdvancedModules->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.17 ms After last query: 9.29 ms Query memory: 0.024 MB Memory before query: 10.389 MB Rows returned: 0

SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,
							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count

  FROM wxuhk_content AS a

  LEFT JOIN wxuhk_categories AS c 
  ON c.id = a.catid

  LEFT JOIN wxuhk_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN wxuhk_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN wxuhk_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN wxuhk_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.featured = 1 
  AND a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-06-17 09:03:57') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-06-17 09:03:57')

  ORDER BY c.lft,  
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC , a.created DESC  
  LIMIT 12

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid,idx_featured_catid,jr_listing_count	idx_state	1	const	2	Using where; Using temporary; Using filesort
1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	cats_db.a.catid	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	cats_db.a.created_by	1	Using where
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	cats_db.a.modified_by	1	Using where
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	cats_db.c.parent_id	1	Using where
1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	cats_db.a.id	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
15	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
14	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:126
12	ContentModelFeatured->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:56
10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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.40 ms After last query: 0.73 ms Query memory: 0.023 MB Memory before query: 10.475 MB Rows returned: 1

SELECT COUNT(*)

  FROM wxuhk_content AS a

  LEFT JOIN wxuhk_categories AS c 
  ON c.id = a.catid

  LEFT JOIN wxuhk_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN wxuhk_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN wxuhk_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN wxuhk_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.featured = 1 
  AND a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-06-17 09:03:57') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-06-17 09:03:57')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid,idx_featured_catid,jr_listing_count	idx_state	1	const	2	Using where
1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	cats_db.a.catid	1	Using where

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:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:340
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:282
13	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:232
12	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:57
10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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.40 ms After last query: 12.54 ms Query memory: 0.320 MB Memory before query: 11.468 MB Rows returned: 42

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

  FROM wxuhk_modules AS m

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

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

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

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	range	published,newsfeeds	published	6	NULL	42	Using index condition; Using where; Using filesort
1	SIMPLE	am	eq_ref	PRIMARY	PRIMARY	4	cats_db.m.id	1	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	cats_db.m.module,const	1	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:404
19	PlgSystemAdvancedModuleHelper->getModuleList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:123
18	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
17	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
16	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Helper/ModuleHelper.php:357
15	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
14	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:591
13	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/gk_storefront/lib/framework/helper.api.php:36
12	GKTemplateAPI->modules()	JROOT/templates/gk_storefront/lib/framework/helper.layout.php:55
11	GKTemplateLayout->generateLayoutWidths()	JROOT/templates/gk_storefront/layouts/default.php:56
10	include JROOT/templates/gk_storefront/layouts/default.php	JROOT/templates/gk_storefront/lib/gk.framework.php:136
9	GKTemplate->getLayout()	JROOT/templates/gk_storefront/lib/gk.framework.php:88
8	GKTemplate->__construct()	JROOT/templates/gk_storefront/index.php:25
7	require JROOT/templates/gk_storefront/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.60 ms After last query: 10.19 ms Query memory: 0.027 MB Memory before query: 12.898 MB Rows returned: 1

SHOW TABLES LIKE "wxuhk_virtuemart_configs"

Explain

EXPLAIN not possible on query: SHOW TABLES LIKE "wxuhk_virtuemart_configs"

Profile

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

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
24	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:722
23	VmTable::checkTableExists()	JROOT/administrator/components/com_virtuemart/models/config.php:563
22	VirtueMartModelConfig::checkConfigTableExists()	JROOT/administrator/components/com_virtuemart/helpers/config.php:774
21	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:884
20	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:27
19	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
18	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
17	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
16	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/templates/gk_storefront/lib/menu/GKBase.class.php:129
11	GKMenuBase->loadMenu()	JROOT/templates/gk_storefront/layouts/default.php:97
10	include JROOT/templates/gk_storefront/layouts/default.php	JROOT/templates/gk_storefront/lib/gk.framework.php:136
9	GKTemplate->getLayout()	JROOT/templates/gk_storefront/lib/gk.framework.php:88
8	GKTemplate->__construct()	JROOT/templates/gk_storefront/index.php:25
7	require JROOT/templates/gk_storefront/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.24 ms After last query: 0.33 ms Query memory: 0.026 MB Memory before query: 12.946 MB Rows returned: 1

SELECT `config` 
  FROM `wxuhk_virtuemart_configs` 
  WHERE `virtuemart_config_id` = "1";

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	wxuhk_virtuemart_configs	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1

Profile

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
22	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/config.php:814
21	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:884
20	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:27
19	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
18	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
17	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
16	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/templates/gk_storefront/lib/menu/GKBase.class.php:129
11	GKMenuBase->loadMenu()	JROOT/templates/gk_storefront/layouts/default.php:97
10	include JROOT/templates/gk_storefront/layouts/default.php	JROOT/templates/gk_storefront/lib/gk.framework.php:136
9	GKTemplate->getLayout()	JROOT/templates/gk_storefront/lib/gk.framework.php:88
8	GKTemplate->__construct()	JROOT/templates/gk_storefront/index.php:25
7	require JROOT/templates/gk_storefront/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.95 ms After last query: 0.90 ms Query memory: 0.035 MB Memory before query: 13.074 MB Rows returned: 12

Duplicate queries: #159

SELECT * 
  FROM `wxuhk_menu` 
  WHERE `link` like "index.php?option=com_virtuemart%" 
  and client_id=0 
  and published=1 
  and (language="*" or language = "en-GB" ) 
  AND ( access="1" )  
  ORDER BY `language` DESC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	wxuhk_menu	ref	idx_client_id_parent_id_alias_language,idx_language	idx_client_id_parent_id_alias_language	1	const	163	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
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1274
22	vmrouterHelper->setMenuItemId()	JROOT/components/com_virtuemart/router.php:860
21	vmrouterHelper->__construct()	JROOT/components/com_virtuemart/router.php:889
20	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:27
19	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
18	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
17	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
16	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/templates/gk_storefront/lib/menu/GKBase.class.php:129
11	GKMenuBase->loadMenu()	JROOT/templates/gk_storefront/layouts/default.php:97
10	include JROOT/templates/gk_storefront/layouts/default.php	JROOT/templates/gk_storefront/lib/gk.framework.php:136
9	GKTemplate->getLayout()	JROOT/templates/gk_storefront/lib/gk.framework.php:88
8	GKTemplate->__construct()	JROOT/templates/gk_storefront/index.php:25
7	require JROOT/templates/gk_storefront/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.34 ms After last query: 14.03 ms Query memory: 0.022 MB Memory before query: 13.950 MB Rows returned: 5

Duplicate queries: #144

SELECT 
					c.id AS CID
				
  FROM 
					wxuhk_k2_categories AS c
				
  LEFT JOIN 
					wxuhk_k2_items AS content 
					
  ON 
					c.id = content.catid 	
				 
				
  WHERE 
					1=1 
					 
  AND ( c.id = 27) 
					
  AND 
					c.published = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY,category,published	PRIMARY	4	const	1
1	SIMPLE	content	ref	catid	catid	4	const	5	Using index

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:81
12	NSP_GK5_com_k2_Model::getSources()	JROOT/modules/mod_news_pro_gk5/helper.php:100
11	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:27
10	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.36 ms After last query: 0.08 ms Query memory: 0.022 MB Memory before query: 13.959 MB Rows returned: 3

SELECT
			content.id AS id				
		
  FROM 
			wxuhk_k2_items AS content 
			
			
		
  WHERE 
			content.published = 1 
  AND content.trash = 0
                 
  AND content.access IN (1,1)    
		 		
  AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2021-06-17 09:03:57' )
				
  AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2021-06-17 09:03:57' )
			 
  AND (  content.catid = 27 ) 
			
			 
			
			
		
			
		
		
  ORDER BY 
			 content.created DESC 
		
  LIMIT
			0,3;

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	content	ref	item,catid	catid	4	const	5	Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
13	JDatabaseDriver->loadAssocList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:266
12	NSP_GK5_com_k2_Model::getArticles()	JROOT/modules/mod_news_pro_gk5/helper.php:114
11	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:27
10	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.51 ms After last query: 0.03 ms Query memory: 0.023 MB Memory before query: 13.970 MB Rows returned: 3

SELECT
			content.id AS id,
			content.alias AS alias,
			content.title AS title, 
			content.introtext AS text,
			content.created AS date, 
			content.publish_up AS date_publish,
			content.hits AS hits,
			content.featured AS frontpage,
			content.access AS access,
			content.catid AS cid,
			content.video AS video,
			content.plugins AS plugins,
			categories.name AS catname, 
			categories.image AS cat_image,
			categories.alias AS cat_alias,
			users.email AS author_email,
			content.created_by_alias AS author_alias,
			users.name AS author_username,
			content.created_by AS author_id,
			content_rating.rating_sum AS rating_sum,
			content_rating.rating_count AS rating_count		
		
  FROM 
			wxuhk_k2_items AS content 
			
  LEFT JOIN 
				wxuhk_k2_categories AS categories 
				
  ON categories.id = content.catid 
			
  LEFT JOIN 
				wxuhk_users AS users 
				
  ON users.id = content.created_by 			
			
  LEFT JOIN 
				wxuhk_k2_rating AS content_rating 
				
  ON content_rating.itemID = content.id
		
  WHERE 
			1=1
			 
  AND ( content.id = 268 OR  content.id = 269 OR  content.id = 278)
		
  ORDER BY 
			 content.created DESC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	content	range	PRIMARY	PRIMARY	4	NULL	3	Using index condition; Using where; Using filesort
1	SIMPLE	categories	eq_ref	PRIMARY	PRIMARY	4	cats_db.content.catid	1	Using where
1	SIMPLE	users	eq_ref	PRIMARY	PRIMARY	4	cats_db.content.created_by	1
1	SIMPLE	content_rating	eq_ref	PRIMARY	PRIMARY	4	cats_db.content.id	1

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
13	JDatabaseDriver->loadAssocList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:325
12	NSP_GK5_com_k2_Model::getArticles()	JROOT/modules/mod_news_pro_gk5/helper.php:114
11	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:27
10	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.35 ms After last query: 3.41 ms Query memory: 0.026 MB Memory before query: 14.130 MB Rows returned: 0

SELECT r.*

  FROM wxuhk_rereplacer AS r

  WHERE r.published = 1 
  AND (r.area = 'articles')

  ORDER BY r.ordering, r.id

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rereplacer/src/Items.php:45
20	RegularLabs\Plugin\System\ReReplacer\Items::getItemList()	JROOT/plugins/system/rereplacer/rereplacer.php:100
19	PlgSystemReReplacer->handleOnContentPrepare()	JROOT/libraries/regularlabs/src/Plugin.php:157
18	RegularLabs\Library\Plugin->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
16	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
15	JHtmlContent::prepare()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
13	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
12	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_tabs_gk5/helper.php:122
11	TabsGK5Helper->render()	JROOT/modules/mod_tabs_gk5/mod_tabs_gk5.php:24
10	include JROOT/modules/mod_tabs_gk5/mod_tabs_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.36 ms After last query: 1.33 ms Query memory: 0.026 MB Memory before query: 14.348 MB Rows returned: 1

SELECT DISTINCT 
			c.virtuemart_category_id AS CID
		
  FROM 
			wxuhk_virtuemart_product_categories AS cx
		
  LEFT JOIN 
            wxuhk_virtuemart_categories_en_gb AS c
            
  ON
            cx.virtuemart_category_id = c.virtuemart_category_id
		
  LEFT JOIN 
			wxuhk_virtuemart_products_en_gb AS content 
			
  ON 
			cx.virtuemart_product_id = content.virtuemart_product_id 
        
  LEFT JOIN
            wxuhk_virtuemart_categories AS cat
            
  ON
            c.virtuemart_category_id = cat.virtuemart_category_id
		
  WHERE 
			(  c.virtuemart_category_id = 18 )

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1	Using index; Using temporary
1	SIMPLE	cx	index	NULL	virtuemart_product_id	8	NULL	200	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_virtuemart/model.php:84
18	NSP_GK5_com_virtuemart_Model::getSources()	JROOT/modules/mod_news_pro_gk5/helper.php:100
17	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:27
16	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/modules/mod_tabs_gk5/tmpl/module.php:22
14	require JROOT/modules/mod_tabs_gk5/tmpl/module.php	JROOT/modules/mod_tabs_gk5/helper.php:213
13	TabsGK5Helper->moduleRender()	JROOT/modules/mod_tabs_gk5/tmpl/default.php:39
12	require JROOT/modules/mod_tabs_gk5/tmpl/default.php	JROOT/modules/mod_tabs_gk5/helper.php:202
11	TabsGK5Helper->render()	JROOT/modules/mod_tabs_gk5/mod_tabs_gk5.php:24
10	include JROOT/modules/mod_tabs_gk5/mod_tabs_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.83 ms After last query: 0.05 ms Query memory: 0.027 MB Memory before query: 14.363 MB Rows returned: 4

SELECT DISTINCT
            content.virtuemart_product_id AS id,
            content.product_name AS title,
            content.product_desc AS text,
            contentR.modified_on AS date,
            contentR.created_on AS date_publish,
            contentR.product_special AS featured,
			manufacturer.mf_name AS manufacturer,
			manufacturer.virtuemart_manufacturer_id AS manufacturer_id
		
  FROM 
			wxuhk_virtuemart_products_en_gb AS content 
            
  LEFT JOIN
                wxuhk_virtuemart_product_categories AS category
                
  ON
                category.virtuemart_product_id = content.virtuemart_product_id
            
            
  LEFT JOIN
                wxuhk_virtuemart_product_manufacturers AS manufacturer_x
                
  ON
                content.virtuemart_product_id = manufacturer_x.virtuemart_product_id
            
  LEFT JOIN
                wxuhk_virtuemart_manufacturers_en_gb AS manufacturer
                
  ON
                manufacturer_x.virtuemart_manufacturer_id = manufacturer.virtuemart_manufacturer_id
            
  LEFT JOIN
                wxuhk_virtuemart_products AS contentR	
                
  ON
                contentR.virtuemart_product_id = content.virtuemart_product_id
            
  LEFT JOIN
                wxuhk_virtuemart_product_shoppergroups AS psgroup
                
  ON 
                psgroup.virtuemart_product_id = content.virtuemart_product_id
            
  LEFT JOIN
                wxuhk_virtuemart_shoppergroups AS sgroup
                
  ON 
                sgroup.virtuemart_shoppergroup_id = psgroup.virtuemart_shoppergroup_id
		
  WHERE
            contentR.published = 1
			
  AND  ( category.virtuemart_category_id = 18) 
			 
  AND contentR.product_special = 1  
			
			
			
		
  ORDER BY 
			 RAND() 
		
  LIMIT
			0,4;

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	psgroup	system	virtuemart_product_id	NO INDEX KEY COULD BE USED	NULL	NULL	0	Const row not found; Using temporary; Using filesort
1	SIMPLE	contentR	ref	PRIMARY,product_special,published	product_special	1	const	19	Using where
1	SIMPLE	content	eq_ref	PRIMARY	PRIMARY	4	cats_db.contentR.virtuemart_product_id	1
1	SIMPLE	category	eq_ref	virtuemart_product_id	virtuemart_product_id	8	cats_db.contentR.virtuemart_product_id,const	1	Using index
1	SIMPLE	manufacturer_x	ref	virtuemart_product_id	virtuemart_product_id	5	cats_db.contentR.virtuemart_product_id	11	Using where; Using index
1	SIMPLE	manufacturer	eq_ref	PRIMARY	PRIMARY	4	cats_db.manufacturer_x.virtuemart_manufacturer_id	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
19	JDatabaseDriver->loadAssocList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_virtuemart/model.php:271
18	NSP_GK5_com_virtuemart_Model::getArticles()	JROOT/modules/mod_news_pro_gk5/helper.php:114
17	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:27
16	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/modules/mod_tabs_gk5/tmpl/module.php:22
14	require JROOT/modules/mod_tabs_gk5/tmpl/module.php	JROOT/modules/mod_tabs_gk5/helper.php:213
13	TabsGK5Helper->moduleRender()	JROOT/modules/mod_tabs_gk5/tmpl/default.php:39
12	require JROOT/modules/mod_tabs_gk5/tmpl/default.php	JROOT/modules/mod_tabs_gk5/helper.php:202
11	TabsGK5Helper->render()	JROOT/modules/mod_tabs_gk5/mod_tabs_gk5.php:24
10	include JROOT/modules/mod_tabs_gk5/mod_tabs_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.35 ms After last query: 0.03 ms Query memory: 0.026 MB Memory before query: 14.378 MB Rows returned: 4

SELECT DISTINCT
		    content.virtuemart_product_id AS id,
			cat.virtuemart_category_id AS cid,
			cat.category_name AS cat_name
		
  FROM 
			wxuhk_virtuemart_products AS content 
			
  LEFT JOIN 
				wxuhk_virtuemart_product_categories AS category_xref
				
  ON 
		        category_xref.virtuemart_product_id = content.virtuemart_product_id 
			
  LEFT JOIN 
				wxuhk_virtuemart_categories AS category 
				
  ON 
		        category_xref.virtuemart_category_id = category.virtuemart_category_id 	
            
  LEFT JOIN
                wxuhk_virtuemart_categories_en_gb AS cat
                
  ON
                category_xref.virtuemart_category_id = cat.virtuemart_category_id
		
  WHERE
			( content.virtuemart_product_id = 165 OR content.virtuemart_product_id = 166 OR content.virtuemart_product_id = 163 OR content.virtuemart_product_id = 167)
			
  AND category.published = '1' 
		
  ORDER BY 
			content.virtuemart_product_id ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	category_xref	range	virtuemart_product_id	virtuemart_product_id	4	NULL	4	Using where; Using index; Using temporary
1	SIMPLE	content	eq_ref	PRIMARY	PRIMARY	4	cats_db.category_xref.virtuemart_product_id	1	Using index
1	SIMPLE	cat	eq_ref	PRIMARY	PRIMARY	4	cats_db.category_xref.virtuemart_category_id	1
1	SIMPLE	category	eq_ref	PRIMARY,published	PRIMARY	4	cats_db.category_xref.virtuemart_category_id	1	Using where; Distinct

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
19	JDatabaseDriver->loadAssocList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_virtuemart/model.php:325
18	NSP_GK5_com_virtuemart_Model::getArticles()	JROOT/modules/mod_news_pro_gk5/helper.php:114
17	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:27
16	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/modules/mod_tabs_gk5/tmpl/module.php:22
14	require JROOT/modules/mod_tabs_gk5/tmpl/module.php	JROOT/modules/mod_tabs_gk5/helper.php:213
13	TabsGK5Helper->moduleRender()	JROOT/modules/mod_tabs_gk5/tmpl/default.php:39
12	require JROOT/modules/mod_tabs_gk5/tmpl/default.php	JROOT/modules/mod_tabs_gk5/helper.php:202
11	TabsGK5Helper->render()	JROOT/modules/mod_tabs_gk5/mod_tabs_gk5.php:24
10	include JROOT/modules/mod_tabs_gk5/mod_tabs_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.31 ms After last query: 0.04 ms Query memory: 0.026 MB Memory before query: 14.398 MB Rows returned: 4

SELECT `m`.`file_url` AS `image`, `pm`.`ordering` AS `ordering`, `content`.`virtuemart_product_id` AS `id`

  FROM wxuhk_virtuemart_products AS content

  LEFT JOIN wxuhk_virtuemart_product_medias AS `pm` 
  ON `pm`.`virtuemart_product_id` = `content`.`virtuemart_product_id`

  LEFT JOIN wxuhk_virtuemart_medias AS `m` 
  ON `m`.`virtuemart_media_id` = `pm`.`virtuemart_media_id`

  WHERE  content.virtuemart_product_id = 165 OR content.virtuemart_product_id = 166 OR content.virtuemart_product_id = 163 OR content.virtuemart_product_id = 167

  ORDER BY `content`.`virtuemart_product_id` ASC, `pm`.`ordering` DESC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	content	range	PRIMARY	PRIMARY	4	NULL	4	Using where; Using index; Using temporary; Using filesort
1	SIMPLE	pm	ref	virtuemart_product_id,ordering	virtuemart_product_id	4	cats_db.content.virtuemart_product_id	1
1	SIMPLE	m	eq_ref	PRIMARY	PRIMARY	4	cats_db.pm.virtuemart_media_id	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
19	JDatabaseDriver->loadAssocList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_virtuemart/model.php:369
18	NSP_GK5_com_virtuemart_Model::getArticles()	JROOT/modules/mod_news_pro_gk5/helper.php:114
17	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:27
16	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/modules/mod_tabs_gk5/tmpl/module.php:22
14	require JROOT/modules/mod_tabs_gk5/tmpl/module.php	JROOT/modules/mod_tabs_gk5/helper.php:213
13	TabsGK5Helper->moduleRender()	JROOT/modules/mod_tabs_gk5/tmpl/default.php:39
12	require JROOT/modules/mod_tabs_gk5/tmpl/default.php	JROOT/modules/mod_tabs_gk5/helper.php:202
11	TabsGK5Helper->render()	JROOT/modules/mod_tabs_gk5/mod_tabs_gk5.php:24
10	include JROOT/modules/mod_tabs_gk5/mod_tabs_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.43 ms After last query: 10.87 ms Query memory: 0.029 MB Memory before query: 16.139 MB Rows returned: 1

SELECT * 
  FROM `wxuhk_virtuemart_shoppergroups` 
  WHERE `default` = "2" 
  AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")  
  AND `published`="1"

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	wxuhk_virtuemart_shoppergroups	ref	virtuemart_vendor_id,shared,published	published	1	const	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
27	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:100
26	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:134
25	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:177
24	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:111
23	VirtueMartModelUser->getCurrentUser()	JROOT/administrator/components/com_virtuemart/models/product.php:1391
22	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1024
21	VirtueMartModelProduct->getProduct()	JROOT/templates/gk_storefront/html/mod_news_pro_gk5/com_virtuemart/view.php:138
20	NSP_GK5_com_virtuemart_View::store()	JROOT/templates/gk_storefront/html/mod_news_pro_gk5/com_virtuemart/view.php:91
19	NSP_GK5_com_virtuemart_View::info()	JROOT/modules/mod_news_pro_gk5/data_sources/com_virtuemart/controller.php:45
18	NSP_GK5_com_virtuemart_Controller->initialize()	JROOT/modules/mod_news_pro_gk5/helper.php:180
17	NSP_GK5_Helper->renderLayout()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:28
16	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/modules/mod_tabs_gk5/tmpl/module.php:22
14	require JROOT/modules/mod_tabs_gk5/tmpl/module.php	JROOT/modules/mod_tabs_gk5/helper.php:213
13	TabsGK5Helper->moduleRender()	JROOT/modules/mod_tabs_gk5/tmpl/default.php:39
12	require JROOT/modules/mod_tabs_gk5/tmpl/default.php	JROOT/modules/mod_tabs_gk5/helper.php:202
11	TabsGK5Helper->render()	JROOT/modules/mod_tabs_gk5/mod_tabs_gk5.php:24
10	include JROOT/modules/mod_tabs_gk5/mod_tabs_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.22 ms After last query: 0.76 ms Query memory: 0.031 MB Memory before query: 16.262 MB Rows returned: 1

SELECT `wxuhk_virtuemart_shoppergroups`.*  
  FROM `wxuhk_virtuemart_shoppergroups`  
  WHERE `wxuhk_virtuemart_shoppergroups`.`virtuemart_shoppergroup_id` = "1"

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	wxuhk_virtuemart_shoppergroups	const	PRIMARY	PRIMARY	4	const	1

Profile

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

Call Stack

#	Caller	File and line number
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
30	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1042
29	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1028
28	VmModel->getData()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:50
27	VirtueMartModelShopperGroup->getShopperGroup()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:105
26	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:134
25	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:177
24	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:111
23	VirtueMartModelUser->getCurrentUser()	JROOT/administrator/components/com_virtuemart/models/product.php:1391
22	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1024
21	VirtueMartModelProduct->getProduct()	JROOT/templates/gk_storefront/html/mod_news_pro_gk5/com_virtuemart/view.php:138
20	NSP_GK5_com_virtuemart_View::store()	JROOT/templates/gk_storefront/html/mod_news_pro_gk5/com_virtuemart/view.php:91
19	NSP_GK5_com_virtuemart_View::info()	JROOT/modules/mod_news_pro_gk5/data_sources/com_virtuemart/controller.php:45
18	NSP_GK5_com_virtuemart_Controller->initialize()	JROOT/modules/mod_news_pro_gk5/helper.php:180
17	NSP_GK5_Helper->renderLayout()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:28
16	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/modules/mod_tabs_gk5/tmpl/module.php:22
14	require JROOT/modules/mod_tabs_gk5/tmpl/module.php	JROOT/modules/mod_tabs_gk5/helper.php:213
13	TabsGK5Helper->moduleRender()	JROOT/modules/mod_tabs_gk5/tmpl/default.php:39
12	require JROOT/modules/mod_tabs_gk5/tmpl/default.php	JROOT/modules/mod_tabs_gk5/helper.php:202
11	TabsGK5Helper->render()	JROOT/modules/mod_tabs_gk5/mod_tabs_gk5.php:24
10	include JROOT/modules/mod_tabs_gk5/mod_tabs_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.38 ms After last query: 0.47 ms Query memory: 0.029 MB Memory before query: 16.457 MB Rows returned: 1

SELECT `wxuhk_virtuemart_products`.* ,`wxuhk_virtuemart_products_en_gb`.*  
  FROM `wxuhk_virtuemart_products` 
  INNER JOIN `wxuhk_virtuemart_products_en_gb` using (`virtuemart_product_id`) 
  WHERE `wxuhk_virtuemart_products`.`virtuemart_product_id` = "165"

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	wxuhk_virtuemart_products	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	wxuhk_virtuemart_products_en_gb	const	PRIMARY	PRIMARY	4	const	1

Profile

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

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
24	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1042
23	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1419
22	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1024
21	VirtueMartModelProduct->getProduct()	JROOT/templates/gk_storefront/html/mod_news_pro_gk5/com_virtuemart/view.php:138
20	NSP_GK5_com_virtuemart_View::store()	JROOT/templates/gk_storefront/html/mod_news_pro_gk5/com_virtuemart/view.php:91
19	NSP_GK5_com_virtuemart_View::info()	JROOT/modules/mod_news_pro_gk5/data_sources/com_virtuemart/controller.php:45
18	NSP_GK5_com_virtuemart_Controller->initialize()	JROOT/modules/mod_news_pro_gk5/helper.php:180
17	NSP_GK5_Helper->renderLayout()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:28
16	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/modules/mod_tabs_gk5/tmpl/module.php:22
14	require JROOT/modules/mod_tabs_gk5/tmpl/module.php	JROOT/modules/mod_tabs_gk5/helper.php:213
13	TabsGK5Helper->moduleRender()	JROOT/modules/mod_tabs_gk5/tmpl/default.php:39
12	require JROOT/modules/mod_tabs_gk5/tmpl/default.php	JROOT/modules/mod_tabs_gk5/helper.php:202
11	TabsGK5Helper->render()	JROOT/modules/mod_tabs_gk5/mod_tabs_gk5.php:24
10	include JROOT/modules/mod_tabs_gk5/mod_tabs_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.26 ms After last query: 0.43 ms Query memory: 0.028 MB Memory before query: 16.526 MB Rows returned: 1

Julieta y Romeo

Suede and Pearl Fringe Necklace

Swarovski Pearl Choker (Light Grey)

DAS Premium Hand-rolled Cigars

Featured

Toro

Robusto

Candy Gordo

Corona

Suede and Pearl Fringe Necklace

Suede and Pearl Bolero (Black/White)

Suede and Pearl Bolero (Light Grey/Peaco…

Suede and Pearl Bolero (Brown)

Swarovski Pearl Choker (Cream)

Swarovski Pearl Choker (Light Grey)

Swarovski Pearl Choker (Bronze)

Swarovski Pearl Choker (Cream/Bronze)

Unique, Handmade Gifts For Him & Her

DAS Premium Hand-rolled Cigars

A Word On Cigars

Glossary of Cigar Terms

Customer Care

Our Policies

My Account

Log in

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

159 Queries Logged 472.20 ms

4 duplicate found!