ReikiUsui.ro - Asociatia Reiki Usui

We have updated our Politica de cookies. We use cookies to ensure that we give you the best experience on our website. This includes cookies from third party social media websites and advertising. SUch third-party cookies may track your use of this site.

No items found in the cart

We use cookies on our website. Some of them are essential for the operation of the site, while others help us to improve this site and the user experience (tracking cookies). You can decide for yourself whether you want to allow cookies or not. Please note that if you reject them, you may not be able to use all the functionalities of the site.

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1701463153,
                "last": 1701463153,
                "now": 1701463153
            },
            "token": "X8Qu5xWmftzb0VqVFR33GDJdqygY6LZU"
        },
        "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
        },
        "plg_system_languagefilter": {
            "language": "en-GB"
        }
    },
    "__j2store": {
        "currency": "RON",
        "old_sessionid": "77bcf3dde1e2c0a95504656b5cac9c6b",
        "cart_id": {
            "cart": 462042
        },
        "billing_country_id": "175",
        "shipping_country_id": "175",
        "billing_zone_id": "2686",
        "shipping_zone_id": "2686",
        "shipping_postcode": null,
        "force_calculate_shipping": null,
        "shipping_methods": [
            {
                "element": "shipping_free",
                "name": "Free shipping",
                "code": "",
                "price": 0,
                "tax": 0,
                "extra": 0,
                "total": 0
            }
        ],
        "shipping_values": []
    }
}

Profile Information

Time

Memory

Time: 9.51 ms / 9.51 ms Memory: 0.413 MB / 0.74 MB Application: afterLoad

Time: 69.41 ms / 78.91 ms Memory: 1.663 MB / 2.40 MB Application: afterInitialise

Time: 7.06 ms / 85.98 ms Memory: 0.182 MB / 2.58 MB Application: Before Access::preloadComponents (all components)

Time: 1.83 ms / 87.81 ms Memory: 0.063 MB / 2.65 MB Application: After Access::preloadComponents (all components)

Time: 0.06 ms / 87.87 ms Memory: -0.002 MB / 2.64 MB Application: Before Access::getAssetRules (id:16 name:com_menus)

Time: 0.60 ms / 88.47 ms Memory: 0.008 MB / 2.65 MB Application: After Access::getAssetRules (id:16 name:com_menus)

Time: 2.62 ms / 91.10 ms Memory: 0.023 MB / 2.67 MB Application: afterRoute

Time: 5.93 ms / 97.03 ms Memory: 0.010 MB / 2.68 MB Application: beforeRenderComponent com_j2store

Time: 43.32 ms / 140.34 ms Memory: 1.078 MB / 3.76 MB Application: Before Access::getAssetRules (id:107 name:com_j2store)

Time: 0.07 ms / 140.41 ms Memory: 0.008 MB / 3.77 MB Application: After Access::getAssetRules (id:107 name:com_j2store)

Time: 129.25 ms / 269.66 ms Memory: 1.562 MB / 5.33 MB Application: afterRenderComponent com_j2store

Time: 2.34 ms / 272.00 ms Memory: 0.013 MB / 5.35 MB Application: afterDispatch

Time: 9.33 ms / 281.34 ms Memory: 0.242 MB / 5.59 MB Application: beforeRenderModule mod_menu (Main Menu)

Time: 9.65 ms / 290.99 ms Memory: 0.207 MB / 5.80 MB Application: afterRenderModule mod_menu (Main Menu)

Time: 8.74 ms / 299.73 ms Memory: 0.101 MB / 5.90 MB Application: beforeRenderModule mod_gtranslate (GTranslate)

Time: 0.31 ms / 300.04 ms Memory: 0.046 MB / 5.94 MB Application: afterRenderModule mod_gtranslate (GTranslate)

Time: 0.24 ms / 300.28 ms Memory: -0.053 MB / 5.89 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 0.98 ms / 301.26 ms Memory: 0.011 MB / 5.90 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 0.17 ms / 301.43 ms Memory: 0.001 MB / 5.90 MB Application: beforeRenderModule mod_j2store_cart (Donatia mea)

Time: 9.98 ms / 311.42 ms Memory: 0.147 MB / 6.05 MB Application: afterRenderModule mod_j2store_cart (Donatia mea)

Time: 0.28 ms / 311.69 ms Memory: -0.003 MB / 6.04 MB Application: beforeRenderModule mod_custom (Copyright)

Time: 4.48 ms / 316.18 ms Memory: 0.006 MB / 6.05 MB Application: afterRenderModule mod_custom (Copyright)

Time: 0.20 ms / 316.38 ms Memory: 0.002 MB / 6.05 MB Application: beforeRenderModule mod_menu (Meniu Mobil)

Time: 2.76 ms / 319.13 ms Memory: 0.015 MB / 6.07 MB Application: afterRenderModule mod_menu (Meniu Mobil)

Time: 20.21 ms / 339.34 ms Memory: 0.082 MB / 6.15 MB Application: afterRender

Database queries total: 94.70 ms

Memory Usage

Database Queries

38 Queries Logged 94.70 ms

4 duplicate found!

2 duplicates: #14 #15

2 duplicates: #27 #28

Query Time: 1.06 ms Query memory: 0.023 MB Memory before query: 1.019 MB Rows returned: 0

SELECT `data`

  FROM `m4yzh_session`

  WHERE `session_id` = X'3737626366336464653165326330613935353034363536623563616339633662'

Explain

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

Profile

Status	Duration
Starting	0.20 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.03 ms
Executing	0.24 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.13 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

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:661
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Query Time: 1.02 ms After last query: 0.68 ms Query memory: 0.020 MB Memory before query: 1.033 MB Rows returned: 0

SELECT `session_id`

  FROM `m4yzh_session`

  WHERE `session_id` = X'3737626366336464653165326330613935353034363536623563616339633662' 
  LIMIT 1

Explain

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

Profile

Status	Duration
Starting	0.16 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.02 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.35 ms
Updating status	0.03 ms
Reset for next command	0.03 ms

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:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Query Time: 1.27 ms After last query: 0.17 ms Query memory: 0.004 MB Memory before query: 1.038 MB

INSERT INTO `m4yzh_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'3737626366336464653165326330613935353034363536623563616339633662', 1, 1701463153, 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `m4yzh_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3737626366336464653165326330613935353034363536623563616339633662', 1, 1701463153, 0, '', 0)

Profile

Status	Duration
Starting	0.40 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init for update	0.03 ms
Update	0.10 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.32 ms
closing tables	0.03 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.13 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Call Stack

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

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

Query Time: 1.27 ms After last query: 4.76 ms Query memory: 0.021 MB Memory before query: 1.114 MB Rows returned: 5

SELECT id, rules

  FROM `m4yzh_viewlevels`

Explain

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

Profile

Status	Duration
Starting	0.18 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.03 ms
Optimizing	0.24 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.02 ms
Sending data	0.07 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.15 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Call Stack

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

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

Query Time: 0.96 ms After last query: 0.12 ms Query memory: 0.021 MB Memory before query: 1.126 MB Rows returned: 2

SELECT b.id

  FROM m4yzh_usergroups AS a

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

  WHERE a.id = 9

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	2	Using where; Using index

Profile

Status	Duration
Starting	0.22 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.09 ms
Preparing	0.02 ms
Unlocking tables	0.02 ms
Preparing	0.04 ms
Executing	0.02 ms
Sending data	0.05 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.14 ms
Updating status	0.03 ms
Reset for next command	0.03 ms

Call Stack

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

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

Query Time: 0.82 ms After last query: 33.16 ms Query memory: 0.031 MB Memory before query: 2.167 MB Rows returned: 95

SELECT *

  FROM m4yzh_j2store_configurations

Explain

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

Profile

Status	Duration
Starting	0.15 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.16 ms
End of update loop	0.01 ms
Query end	0.02 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.09 ms
Updating status	0.02 ms
Reset for next command	0.04 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_j2store/helpers/config.php:20
12	J2Config->__construct()	JROOT/administrator/components/com_j2store/helpers/config.php:28
11	J2Config::getInstance()	JROOT/administrator/components/com_j2store/helpers/j2store.php:72
10	J2Store::config()	JROOT/plugins/system/j2store/j2store.php:187
9	plgSystemJ2Store->onJ2StoreCronTask()	JROOT/plugins/system/j2store/j2store.php:167
8	plgSystemJ2Store->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:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.52 ms After last query: 3.84 ms Query memory: 0.069 MB Memory before query: 2.254 MB Rows returned: 38

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

  LEFT JOIN m4yzh_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	45	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	reikiusu_joomla.m.component_id	1	Using where

Profile

Status	Duration
Starting	0.24 ms
checking permissions	0.09 ms
Opening tables	0.05 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.05 ms
Sorting result	0.04 ms
Executing	0.02 ms
Sending data	0.03 ms
Creating sort index	0.52 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.01 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.12 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
18	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
12	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
11	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:145
8	PlgSystemLanguageFilter->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:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.29 ms After last query: 9.17 ms Query memory: 0.027 MB Memory before query: 2.587 MB Rows returned: 42

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

  FROM `m4yzh_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_convertforms','com_cpanel','com_fields','com_finder','com_gantry','com_installer','com_j2store','com_jce','com_joomlaupdate','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_search','com_sitemapgenerator','com_tags','com_templates','com_users','com_weblinks','com_wrapper')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m4yzh_assets	ALL	idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	143	Using where

Profile

Status	Duration
Starting	0.22 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.05 ms
Optimizing	0.02 ms
Statistics	0.14 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.21 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.11 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
15	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
14	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
13	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
12	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
11	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/advancedmodules/src/Document.php:30
10	RegularLabs\Plugin\System\AdvancedModules\Document::loadFrontEditScript()	JROOT/plugins/system/advancedmodules/advancedmodules.php:95
9	PlgSystemAdvancedModules->handleOnAfterRoute()	JROOT/libraries/regularlabs/src/SystemPlugin.php:192
8	RegularLabs\Library\SystemPlugin->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.29 ms After last query: 1.43 ms Query memory: 0.006 MB Memory before query: 2.654 MB

UPDATE `m4yzh_extensions`

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

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

Explain

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

Profile

Status	Duration
Starting	0.33 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init for update	0.08 ms
Updating	0.09 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.47 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.09 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

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/j2store/j2store.php:80
8	plgSystemJ2Store->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 5.31 ms After last query: 1.05 ms Query memory: 0.019 MB Memory before query: 2.679 MB Rows returned: 4

SELECT id, home, template, s.params

  FROM m4yzh_template_styles as s

  LEFT JOIN m4yzh_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	6	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	reikiusu_joomla.s.template,const	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.14 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.04 ms
Optimizing	0.04 ms
Statistics	0.11 ms
Preparing	0.05 ms
Executing	0.01 ms
Sending data	2.93 ms
End of update loop	1.04 ms
Query end	0.02 ms
Commit	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.14 ms
Updating status	0.23 ms
Reset for next command	0.03 ms

Call Stack

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

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

Query Time: 0.77 ms After last query: 8.76 ms Query memory: 0.025 MB Memory before query: 3.177 MB Rows returned: 1

SELECT `extension_id`,`name`,`enabled`,`params`

  FROM m4yzh_extensions

  WHERE `type` = 'plugin' 
  AND `element` = 'osyoutube' 
  AND `folder` = 'content'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m4yzh_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.17 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.08 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.09 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
19	JDatabaseDriver->loadObject()	JROOT/libraries/allediaframework/Framework/Joomla/Extension/Generic.php:170
18	Alledia\Framework\Joomla\Extension\Generic->getDataFromDatabase()	JROOT/libraries/allediaframework/Framework/Joomla/Extension/Generic.php:140
17	Alledia\Framework\Joomla\Extension\Generic->__construct()	JROOT/libraries/allediaframework/Framework/Joomla/Extension/Licensed.php:62
16	Alledia\Framework\Joomla\Extension\Licensed->__construct()	JROOT/libraries/allediaframework/Framework/Factory.php:63
15	Alledia\Framework\Factory::getExtension()	JROOT/libraries/allediaframework/Framework/Joomla/Extension/AbstractPlugin.php:85
14	Alledia\Framework\Joomla\Extension\AbstractPlugin->loadExtension()	JROOT/libraries/allediaframework/Framework/Joomla/Extension/AbstractPlugin.php:56
13	Alledia\Framework\Joomla\Extension\AbstractPlugin->init()	JROOT/plugins/content/osyoutube/library/BasePlugin.php:56
12	Alledia\OSYouTube\BasePlugin->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
11	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
10	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/administrator/components/com_j2store/helpers/plugin.php:206
9	J2Plugins->importCatalogPlugins()	JROOT/administrator/components/com_j2store/helpers/plugin.php:211
8	J2Plugins->event()	JROOT/administrator/components/com_j2store/helpers/strapper.php:82
7	J2StoreStrapper::addJS()	JROOT/components/com_j2store/j2store.php:23
6	require_once JROOT/components/com_j2store/j2store.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 4.71 ms After last query: 4.89 ms Query memory: 0.021 MB Memory before query: 3.478 MB Rows returned: 1

SELECT template 
  FROM m4yzh_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	m4yzh_template_styles	ALL	idx_client_id,idx_client_id_home	NO INDEX KEY COULD BE USED	NULL	NULL	6	Using where

Profile

Status	Duration
Starting	0.14 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.09 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_j2store/helpers/strapper.php:169
8	J2StoreStrapper::getDefaultTemplate()	JROOT/administrator/components/com_j2store/helpers/strapper.php:137
7	J2StoreStrapper::addCSS()	JROOT/components/com_j2store/j2store.php:24
6	require_once JROOT/components/com_j2store/j2store.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 5.42 ms After last query: 25.48 ms Query memory: 0.033 MB Memory before query: 3.800 MB Rows returned: 149

SHOW TABLES

Explain

EXPLAIN not possible on query: SHOW TABLES

Profile

Status	Duration
Starting	0.17 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Filling schema table	0.02 ms
checking permissions	4.09 ms
Executing	0.02 ms
Sending data	0.08 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.02 ms
Removing tmp table	0.03 ms
closing tables	0.01 ms
Unlocking tables	0.03 ms
closing tables	0.01 ms
Starting cleanup	0.23 ms
Freeing items	0.12 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
28	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:505
27	JDatabaseDriverMysqli->getTableList()	JROOT/libraries/f0f/database/driver/joomla.php:251
26	F0FDatabaseDriverJoomla->getTableList()	JROOT/libraries/f0f/table/table.php:2082
25	F0FTable->getTableFields()	JROOT/libraries/f0f/table/table.php:536
24	F0FTable->__construct()	JROOT/libraries/f0f/table/table.php:433
23	F0FTable::getAnInstance()	JROOT/libraries/f0f/model/model.php:2037
22	F0FModel->_createTable()	JROOT/libraries/f0f/model/model.php:1994
21	F0FModel->getTable()	JROOT/libraries/f0f/model/model.php:2062
20	F0FModel->buildQuery()	JROOT/libraries/f0f/model/model.php:1219
19	F0FModel->getItemList()	JROOT/libraries/f0f/model/model.php:1204
18	F0FModel->getList()	JROOT/administrator/components/com_j2store/helpers/currency.php:33
17	J2Currency->__construct()	JROOT/administrator/components/com_j2store/helpers/currency.php:53
16	J2Currency::getInstance()	JROOT/administrator/components/com_j2store/helpers/j2store.php:57
15	J2Store::currency()	JROOT/components/com_j2store/views/carts/view.html.php:23
14	J2StoreViewCarts->onDisplay()	JROOT/libraries/f0f/view/raw.php:167
13	F0FViewRaw->onBrowse()	JROOT/libraries/f0f/view/raw.php:110
12	F0FViewRaw->display()	JROOT/libraries/f0f/controller/controller.php:1125
11	F0FController->display()	JROOT/libraries/f0f/controller/controller.php:1165
10	F0FController->browse()	JROOT/libraries/f0f/controller/controller.php:967
9	F0FController->execute()	JROOT/components/com_j2store/controllers/carts.php:19
8	J2StoreControllerCarts->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_j2store/j2store.php:25
6	require_once JROOT/components/com_j2store/j2store.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.31 ms After last query: 0.16 ms Query memory: 0.031 MB Memory before query: 3.831 MB Rows returned: 17

Duplicate queries: #15

SHOW FULL COLUMNS 
  FROM `m4yzh_j2store_currencies`

Explain

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

Profile

Status	Duration
Starting	0.38 ms
checking permissions	0.02 ms
closing tables	0.01 ms
Opening tables	0.69 ms
After opening tables	0.23 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Filling schema table	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
checking permissions	0.13 ms
closing tables	0.02 ms
Executing	0.03 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Removing tmp table	0.21 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.11 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
28	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
27	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/f0f/database/driver/joomla.php:229
26	F0FDatabaseDriverJoomla->getTableColumns()	JROOT/libraries/f0f/table/table.php:2162
25	F0FTable->getTableFields()	JROOT/libraries/f0f/table/table.php:536
24	F0FTable->__construct()	JROOT/libraries/f0f/table/table.php:433
23	F0FTable::getAnInstance()	JROOT/libraries/f0f/model/model.php:2037
22	F0FModel->_createTable()	JROOT/libraries/f0f/model/model.php:1994
21	F0FModel->getTable()	JROOT/libraries/f0f/model/model.php:2062
20	F0FModel->buildQuery()	JROOT/libraries/f0f/model/model.php:1219
19	F0FModel->getItemList()	JROOT/libraries/f0f/model/model.php:1204
18	F0FModel->getList()	JROOT/administrator/components/com_j2store/helpers/currency.php:33
17	J2Currency->__construct()	JROOT/administrator/components/com_j2store/helpers/currency.php:53
16	J2Currency::getInstance()	JROOT/administrator/components/com_j2store/helpers/j2store.php:57
15	J2Store::currency()	JROOT/components/com_j2store/views/carts/view.html.php:23
14	J2StoreViewCarts->onDisplay()	JROOT/libraries/f0f/view/raw.php:167
13	F0FViewRaw->onBrowse()	JROOT/libraries/f0f/view/raw.php:110
12	F0FViewRaw->display()	JROOT/libraries/f0f/controller/controller.php:1125
11	F0FController->display()	JROOT/libraries/f0f/controller/controller.php:1165
10	F0FController->browse()	JROOT/libraries/f0f/controller/controller.php:967
9	F0FController->execute()	JROOT/components/com_j2store/controllers/carts.php:19
8	J2StoreControllerCarts->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_j2store/j2store.php:25
6	require_once JROOT/components/com_j2store/j2store.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.71 ms After last query: 8.00 ms Query memory: 0.031 MB Memory before query: 3.947 MB Rows returned: 17

Duplicate queries: #14

SHOW FULL COLUMNS 
  FROM `m4yzh_j2store_currencies`

Explain

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

Profile

Status	Duration
Starting	0.15 ms
checking permissions	0.01 ms
closing tables	0.01 ms
Opening tables	0.67 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Filling schema table	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
checking permissions	0.11 ms
closing tables	0.02 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Removing tmp table	0.21 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.09 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
27	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
26	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/f0f/database/driver/joomla.php:229
25	F0FDatabaseDriverJoomla->getTableColumns()	JROOT/administrator/components/com_j2store/models/currencies.php:117
24	J2StoreModelCurrencies->getTableFields()	JROOT/libraries/f0f/model/behavior/filters.php:37
23	F0FModelBehaviorFilters->onAfterBuildQuery()	JROOT/libraries/f0f/utils/observable/event.php:63
22	F0FUtilsObservableEvent->update()	JROOT/libraries/f0f/utils/observable/dispatcher.php:146
21	F0FUtilsObservableDispatcher->trigger()	JROOT/libraries/f0f/model/model.php:2114
20	F0FModel->buildQuery()	JROOT/libraries/f0f/model/model.php:1219
19	F0FModel->getItemList()	JROOT/libraries/f0f/model/model.php:1204
18	F0FModel->getList()	JROOT/administrator/components/com_j2store/helpers/currency.php:33
17	J2Currency->__construct()	JROOT/administrator/components/com_j2store/helpers/currency.php:53
16	J2Currency::getInstance()	JROOT/administrator/components/com_j2store/helpers/j2store.php:57
15	J2Store::currency()	JROOT/components/com_j2store/views/carts/view.html.php:23
14	J2StoreViewCarts->onDisplay()	JROOT/libraries/f0f/view/raw.php:167
13	F0FViewRaw->onBrowse()	JROOT/libraries/f0f/view/raw.php:110
12	F0FViewRaw->display()	JROOT/libraries/f0f/controller/controller.php:1125
11	F0FController->display()	JROOT/libraries/f0f/controller/controller.php:1165
10	F0FController->browse()	JROOT/libraries/f0f/controller/controller.php:967
9	F0FController->execute()	JROOT/components/com_j2store/controllers/carts.php:19
8	J2StoreControllerCarts->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_j2store/j2store.php:25
6	require_once JROOT/components/com_j2store/j2store.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.80 ms After last query: 12.21 ms Query memory: 0.026 MB Memory before query: 4.182 MB Rows returned: 1

SELECT `m4yzh_j2store_currencies`.*

  FROM `m4yzh_j2store_currencies`

  WHERE (`enabled` = '1')

  ORDER BY `j2store_currency_id` ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m4yzh_j2store_currencies	index	NULL	PRIMARY	4	NULL	1	Using where

Profile

Status	Duration
Starting	0.17 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.03 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.10 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/f0f/database/driver/joomla.php:321
21	F0FDatabaseDriverJoomla->loadObjectList()	JROOT/libraries/f0f/model/model.php:1953
20	F0FModel->_getList()	JROOT/libraries/f0f/model/model.php:1225
19	F0FModel->getItemList()	JROOT/libraries/f0f/model/model.php:1204
18	F0FModel->getList()	JROOT/administrator/components/com_j2store/helpers/currency.php:33
17	J2Currency->__construct()	JROOT/administrator/components/com_j2store/helpers/currency.php:53
16	J2Currency::getInstance()	JROOT/administrator/components/com_j2store/helpers/j2store.php:57
15	J2Store::currency()	JROOT/components/com_j2store/views/carts/view.html.php:23
14	J2StoreViewCarts->onDisplay()	JROOT/libraries/f0f/view/raw.php:167
13	F0FViewRaw->onBrowse()	JROOT/libraries/f0f/view/raw.php:110
12	F0FViewRaw->display()	JROOT/libraries/f0f/controller/controller.php:1125
11	F0FController->display()	JROOT/libraries/f0f/controller/controller.php:1165
10	F0FController->browse()	JROOT/libraries/f0f/controller/controller.php:967
9	F0FController->execute()	JROOT/components/com_j2store/controllers/carts.php:19
8	J2StoreControllerCarts->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_j2store/j2store.php:25
6	require_once JROOT/components/com_j2store/j2store.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.82 ms After last query: 5.40 ms Query memory: 0.029 MB Memory before query: 4.251 MB Rows returned: 12

SHOW FULL COLUMNS 
  FROM `m4yzh_j2store_carts`

Explain

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

Profile

Status	Duration
Starting	0.13 ms
checking permissions	0.01 ms
closing tables	0.01 ms
Opening tables	0.59 ms
After opening tables	0.03 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Filling schema table	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
checking permissions	0.14 ms
closing tables	0.02 ms
Executing	0.02 ms
Sending data	0.06 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
closing tables	0.02 ms
Removing tmp table	0.30 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.13 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/f0f/database/driver/joomla.php:229
21	F0FDatabaseDriverJoomla->getTableColumns()	JROOT/libraries/f0f/table/table.php:2162
20	F0FTable->getTableFields()	JROOT/libraries/f0f/table/table.php:536
19	F0FTable->__construct()	JROOT/libraries/f0f/table/table.php:433
18	F0FTable::getAnInstance()	JROOT/libraries/f0f/table/table.php:255
17	F0FTable::getInstance()	JROOT/administrator/components/com_j2store/models/carts.php:288
16	J2StoreModelCarts->getCart()	JROOT/administrator/components/com_j2store/models/coupons.php:651
15	J2StoreModelCoupons->get_coupon()	JROOT/components/com_j2store/views/carts/view.html.php:62
14	J2StoreViewCarts->onDisplay()	JROOT/libraries/f0f/view/raw.php:167
13	F0FViewRaw->onBrowse()	JROOT/libraries/f0f/view/raw.php:110
12	F0FViewRaw->display()	JROOT/libraries/f0f/controller/controller.php:1125
11	F0FController->display()	JROOT/libraries/f0f/controller/controller.php:1165
10	F0FController->browse()	JROOT/libraries/f0f/controller/controller.php:967
9	F0FController->execute()	JROOT/components/com_j2store/controllers/carts.php:19
8	J2StoreControllerCarts->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_j2store/j2store.php:25
6	require_once JROOT/components/com_j2store/j2store.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.94 ms After last query: 1.05 ms Query memory: 0.025 MB Memory before query: 4.294 MB Rows returned: 0

SELECT m4yzh_j2store_carts.*

  FROM m4yzh_j2store_carts

  WHERE `m4yzh_j2store_carts`.`user_id` = '0' 
  AND `m4yzh_j2store_carts`.`session_id` = '77bcf3dde1e2c0a95504656b5cac9c6b' 
  AND `m4yzh_j2store_carts`.`cart_type` = 'cart'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m4yzh_j2store_carts	ref	session_id,user_id,session_cart_type,user_session_type	session_id	767	const	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.18 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.21 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.11 ms
Updating status	0.03 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
19	JDatabaseDriver->loadAssoc()	JROOT/libraries/f0f/database/driver/joomla.php:291
18	F0FDatabaseDriverJoomla->loadAssoc()	JROOT/libraries/f0f/table/table.php:949
17	F0FTable->load()	JROOT/administrator/components/com_j2store/models/carts.php:289
16	J2StoreModelCarts->getCart()	JROOT/administrator/components/com_j2store/models/coupons.php:651
15	J2StoreModelCoupons->get_coupon()	JROOT/components/com_j2store/views/carts/view.html.php:62
14	J2StoreViewCarts->onDisplay()	JROOT/libraries/f0f/view/raw.php:167
13	F0FViewRaw->onBrowse()	JROOT/libraries/f0f/view/raw.php:110
12	F0FViewRaw->display()	JROOT/libraries/f0f/controller/controller.php:1125
11	F0FController->display()	JROOT/libraries/f0f/controller/controller.php:1165
10	F0FController->browse()	JROOT/libraries/f0f/controller/controller.php:967
9	F0FController->execute()	JROOT/components/com_j2store/controllers/carts.php:19
8	J2StoreControllerCarts->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_j2store/j2store.php:25
6	require_once JROOT/components/com_j2store/j2store.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 5.08 ms After last query: 0.25 ms Query memory: 0.009 MB Memory before query: 4.306 MB

INSERT INTO `m4yzh_j2store_carts`
(`user_id`,`session_id`,`cart_type`,`created_on`,`customer_ip`,`cart_browser`,`cart_analytics`) 
  VALUES 
('0','77bcf3dde1e2c0a95504656b5cac9c6b','cart','2023-12-01 20:39:13','3.233.221.90','','{\"is_mobile\":false}')

Explain

EXPLAIN not possible on query: INSERT INTO `m4yzh_j2store_carts` (`user_id`,`session_id`,`cart_type`,`created_on`,`customer_ip`,`cart_browser`,`cart_analytics`) VALUES ('0','77bcf3dde1e2c0a95504656b5cac9c6b','cart','2023-12-01 20:39:13','3.233.221.90','','{\"is_mobile\":false}')

Profile

Status	Duration
Starting	0.14 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init for update	0.03 ms
Update	0.09 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	2.47 ms
closing tables	1.21 ms
Unlocking tables	0.40 ms
closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.51 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1421
19	JDatabaseDriver->insertObject()	JROOT/libraries/f0f/database/driver/joomla.php:281
18	F0FDatabaseDriverJoomla->insertObject()	JROOT/libraries/f0f/table/table.php:1303
17	F0FTable->store()	JROOT/administrator/components/com_j2store/models/carts.php:301
16	J2StoreModelCarts->getCart()	JROOT/administrator/components/com_j2store/models/coupons.php:651
15	J2StoreModelCoupons->get_coupon()	JROOT/components/com_j2store/views/carts/view.html.php:62
14	J2StoreViewCarts->onDisplay()	JROOT/libraries/f0f/view/raw.php:167
13	F0FViewRaw->onBrowse()	JROOT/libraries/f0f/view/raw.php:110
12	F0FViewRaw->display()	JROOT/libraries/f0f/controller/controller.php:1125
11	F0FController->display()	JROOT/libraries/f0f/controller/controller.php:1165
10	F0FController->browse()	JROOT/libraries/f0f/controller/controller.php:967
9	F0FController->execute()	JROOT/components/com_j2store/controllers/carts.php:19
8	J2StoreControllerCarts->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_j2store/j2store.php:25
6	require_once JROOT/components/com_j2store/j2store.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 3.24 ms After last query: 1.71 ms Query memory: 0.025 MB Memory before query: 4.446 MB Rows returned: 0

SELECT tbl.*, variant.j2store_variant_id, variant.sku, variant.price, variant.pricing_calculator, variant.shipping, variant.weight, variant.length, variant.width, variant.height, variant.length_class_id, variant.weight_class_id, variant.quantity_restriction , variant.min_sale_qty, variant.max_sale_qty, variant.use_store_config_min_sale_qty, variant.use_store_config_max_sale_qty, variant.use_store_config_notify_qty, variant.manage_stock, variant.allow_backorder, product.product_type, product.product_source, product.product_source_id, product.has_options, product.up_sells, product.cross_sells, product.taxprofile_id, product.vendor_id, product.manufacturer_id, product.params as product_params, product.visibility, productimage.thumb_image, stock.on_hold as quantity_on_hold, stock.quantity as available_quantity

  FROM m4yzh_j2store_cartitems as tbl

  INNER JOIN m4yzh_j2store_variants AS variant 
  ON tbl.variant_id = variant.j2store_variant_id

  INNER JOIN m4yzh_j2store_products AS product 
  ON tbl.product_id = product.j2store_product_id

  LEFT 
  OUTER JOIN m4yzh_j2store_productimages AS productimage 
  ON product.j2store_product_id = productimage.product_id

  LEFT 
  OUTER JOIN m4yzh_j2store_productquantities AS stock 
  ON variant.j2store_variant_id = stock.variant_id

  WHERE tbl.cart_id= '462042' 
  AND product.enabled =1 
  AND product.visibility=1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tbl	ref	cart_id,product_id,variant_id	cart_id	4	const	1
1	SIMPLE	product	eq_ref	PRIMARY	PRIMARY	4	reikiusu_joomla.tbl.product_id	1	Using where
1	SIMPLE	productimage	ref	productimage_product_id	productimage_product_id	5	reikiusu_joomla.product.j2store_product_id	1
1	SIMPLE	variant	eq_ref	PRIMARY	PRIMARY	4	reikiusu_joomla.tbl.variant_id	1	Using where
1	SIMPLE	stock	eq_ref	stock_variant_id	stock_variant_id	4	reikiusu_joomla.variant.j2store_variant_id	1

Profile

Status	Duration
Starting	0.27 ms
checking permissions	0.02 ms
Opening tables	1.49 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.03 ms
Opening tables	0.23 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.12 ms
Unlocking tables	0.02 ms
closing tables	0.03 ms
init	0.07 ms
Optimizing	0.04 ms
Statistics	0.09 ms
Preparing	0.05 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.14 ms
Updating status	0.23 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/f0f/database/driver/joomla.php:321
19	F0FDatabaseDriverJoomla->loadObjectList()	JROOT/libraries/f0f/model/model.php:1953
18	F0FModel->_getList()	JROOT/libraries/f0f/model/model.php:1225
17	F0FModel->getItemList()	JROOT/libraries/f0f/model/model.php:1204
16	F0FModel->getList()	JROOT/administrator/components/com_j2store/models/carts.php:333
15	J2StoreModelCarts->getItems()	JROOT/components/com_j2store/views/carts/view.html.php:87
14	J2StoreViewCarts->onDisplay()	JROOT/libraries/f0f/view/raw.php:167
13	F0FViewRaw->onBrowse()	JROOT/libraries/f0f/view/raw.php:110
12	F0FViewRaw->display()	JROOT/libraries/f0f/controller/controller.php:1125
11	F0FController->display()	JROOT/libraries/f0f/controller/controller.php:1165
10	F0FController->browse()	JROOT/libraries/f0f/controller/controller.php:967
9	F0FController->execute()	JROOT/components/com_j2store/controllers/carts.php:19
8	J2StoreControllerCarts->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_j2store/j2store.php:25
6	require_once JROOT/components/com_j2store/j2store.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.66 ms After last query: 4.40 ms Query memory: 0.034 MB Memory before query: 4.492 MB Rows returned: 45

SHOW FULL COLUMNS 
  FROM `m4yzh_j2store_orders`

Explain

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

Profile

Status	Duration
Starting	0.39 ms
checking permissions	0.02 ms
closing tables	0.02 ms
Opening tables	0.75 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Filling schema table	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
checking permissions	0.23 ms
closing tables	0.02 ms
Executing	0.01 ms
Sending data	0.09 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Removing tmp table	0.32 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.02 ms
Freeing items	0.34 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
20	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/f0f/database/driver/joomla.php:229
19	F0FDatabaseDriverJoomla->getTableColumns()	JROOT/libraries/f0f/table/table.php:2162
18	F0FTable->getTableFields()	JROOT/libraries/f0f/table/table.php:536
17	F0FTable->__construct()	JROOT/libraries/f0f/table/table.php:433
16	F0FTable::getAnInstance()	JROOT/administrator/components/com_j2store/models/orders.php:36
15	J2StoreModelOrders->populateOrder()	JROOT/components/com_j2store/views/carts/view.html.php:119
14	J2StoreViewCarts->onDisplay()	JROOT/libraries/f0f/view/raw.php:167
13	F0FViewRaw->onBrowse()	JROOT/libraries/f0f/view/raw.php:110
12	F0FViewRaw->display()	JROOT/libraries/f0f/controller/controller.php:1125
11	F0FController->display()	JROOT/libraries/f0f/controller/controller.php:1165
10	F0FController->browse()	JROOT/libraries/f0f/controller/controller.php:967
9	F0FController->execute()	JROOT/components/com_j2store/controllers/carts.php:19
8	J2StoreControllerCarts->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_j2store/j2store.php:25
6	require_once JROOT/components/com_j2store/j2store.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 6.55 ms After last query: 2.36 ms Query memory: 0.035 MB Memory before query: 4.671 MB Rows returned: 38

SHOW FULL COLUMNS 
  FROM `m4yzh_j2store_orderinfos`

Explain

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

Profile

Status	Duration
Starting	0.18 ms
checking permissions	0.02 ms
closing tables	0.02 ms
Opening tables	0.72 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.03 ms
Executing	0.01 ms
Filling schema table	0.02 ms
Opening tables	0.03 ms
After opening tables	1.79 ms
checking permissions	2.20 ms
closing tables	0.03 ms
Executing	0.02 ms
Sending data	0.30 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Removing tmp table	0.47 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.37 ms
Updating status	0.03 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
23	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/f0f/database/driver/joomla.php:229
22	F0FDatabaseDriverJoomla->getTableColumns()	JROOT/libraries/f0f/table/table.php:2162
21	F0FTable->getTableFields()	JROOT/libraries/f0f/table/table.php:536
20	F0FTable->__construct()	JROOT/administrator/components/com_j2store/tables/orderinfo.php:29
19	J2storeTableOrderinfo->__construct()	JROOT/libraries/f0f/table/table.php:433
18	F0FTable::getAnInstance()	JROOT/administrator/components/com_j2store/tables/order.php:1121
17	J2StoreTableOrder->setOrderInformation()	JROOT/administrator/components/com_j2store/tables/order.php:224
16	J2StoreTableOrder->getTotals()	JROOT/administrator/components/com_j2store/models/orders.php:58
15	J2StoreModelOrders->populateOrder()	JROOT/components/com_j2store/views/carts/view.html.php:119
14	J2StoreViewCarts->onDisplay()	JROOT/libraries/f0f/view/raw.php:167
13	F0FViewRaw->onBrowse()	JROOT/libraries/f0f/view/raw.php:110
12	F0FViewRaw->display()	JROOT/libraries/f0f/controller/controller.php:1125
11	F0FController->display()	JROOT/libraries/f0f/controller/controller.php:1165
10	F0FController->browse()	JROOT/libraries/f0f/controller/controller.php:967
9	F0FController->execute()	JROOT/components/com_j2store/controllers/carts.php:19
8	J2StoreControllerCarts->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_j2store/j2store.php:25
6	require_once JROOT/components/com_j2store/j2store.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.05 ms After last query: 0.49 ms Query memory: 0.028 MB Memory before query: 4.731 MB Rows returned: 6

SHOW FULL COLUMNS 
  FROM `m4yzh_j2store_countries`

Explain

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

Profile

Status	Duration
Starting	0.17 ms
checking permissions	0.02 ms
closing tables	0.02 ms
Opening tables	0.70 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.02 ms
Optimizing	0.03 ms
Statistics	0.02 ms
Preparing	0.03 ms
Executing	0.02 ms
Filling schema table	0.04 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
checking permissions	0.11 ms
closing tables	0.02 ms
Executing	0.02 ms
Sending data	0.06 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
closing tables	0.02 ms
Removing tmp table	0.30 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.13 ms
Updating status	0.48 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
24	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/f0f/database/driver/joomla.php:229
23	F0FDatabaseDriverJoomla->getTableColumns()	JROOT/libraries/f0f/table/table.php:2162
22	F0FTable->getTableFields()	JROOT/libraries/f0f/table/table.php:2360
21	F0FTable->getQueryJoinFields()	JROOT/libraries/f0f/table/table.php:539
20	F0FTable->__construct()	JROOT/administrator/components/com_j2store/tables/orderinfo.php:29
19	J2storeTableOrderinfo->__construct()	JROOT/libraries/f0f/table/table.php:433
18	F0FTable::getAnInstance()	JROOT/administrator/components/com_j2store/tables/order.php:1121
17	J2StoreTableOrder->setOrderInformation()	JROOT/administrator/components/com_j2store/tables/order.php:224
16	J2StoreTableOrder->getTotals()	JROOT/administrator/components/com_j2store/models/orders.php:58
15	J2StoreModelOrders->populateOrder()	JROOT/components/com_j2store/views/carts/view.html.php:119
14	J2StoreViewCarts->onDisplay()	JROOT/libraries/f0f/view/raw.php:167
13	F0FViewRaw->onBrowse()	JROOT/libraries/f0f/view/raw.php:110
12	F0FViewRaw->display()	JROOT/libraries/f0f/controller/controller.php:1125
11	F0FController->display()	JROOT/libraries/f0f/controller/controller.php:1165
10	F0FController->browse()	JROOT/libraries/f0f/controller/controller.php:967
9	F0FController->execute()	JROOT/components/com_j2store/controllers/carts.php:19
8	J2StoreControllerCarts->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_j2store/j2store.php:25
6	require_once JROOT/components/com_j2store/j2store.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 8.55 ms After last query: 0.37 ms Query memory: 0.028 MB Memory before query: 4.748 MB Rows returned: 6

SHOW FULL COLUMNS 
  FROM `m4yzh_j2store_zones`

Explain

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

Profile

Status	Duration
Starting	0.17 ms
checking permissions	0.02 ms
closing tables	0.02 ms
Opening tables	6.91 ms
After opening tables	0.04 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.04 ms
Executing	0.02 ms
Filling schema table	0.03 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
checking permissions	0.13 ms
closing tables	0.03 ms
Executing	0.02 ms
Sending data	0.09 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
closing tables	0.02 ms
Removing tmp table	0.38 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.16 ms
Updating status	1.50 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
24	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/f0f/database/driver/joomla.php:229
23	F0FDatabaseDriverJoomla->getTableColumns()	JROOT/libraries/f0f/table/table.php:2162
22	F0FTable->getTableFields()	JROOT/libraries/f0f/table/table.php:2360
21	F0FTable->getQueryJoinFields()	JROOT/libraries/f0f/table/table.php:539
20	F0FTable->__construct()	JROOT/administrator/components/com_j2store/tables/orderinfo.php:29
19	J2storeTableOrderinfo->__construct()	JROOT/libraries/f0f/table/table.php:433
18	F0FTable::getAnInstance()	JROOT/administrator/components/com_j2store/tables/order.php:1121
17	J2StoreTableOrder->setOrderInformation()	JROOT/administrator/components/com_j2store/tables/order.php:224
16	J2StoreTableOrder->getTotals()	JROOT/administrator/components/com_j2store/models/orders.php:58
15	J2StoreModelOrders->populateOrder()	JROOT/components/com_j2store/views/carts/view.html.php:119
14	J2StoreViewCarts->onDisplay()	JROOT/libraries/f0f/view/raw.php:167
13	F0FViewRaw->onBrowse()	JROOT/libraries/f0f/view/raw.php:110
12	F0FViewRaw->display()	JROOT/libraries/f0f/controller/controller.php:1125
11	F0FController->display()	JROOT/libraries/f0f/controller/controller.php:1165
10	F0FController->browse()	JROOT/libraries/f0f/controller/controller.php:967
9	F0FController->execute()	JROOT/components/com_j2store/controllers/carts.php:19
8	J2StoreControllerCarts->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_j2store/j2store.php:25
6	require_once JROOT/components/com_j2store/j2store.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 6.40 ms After last query: 1.16 ms Query memory: 0.030 MB Memory before query: 4.784 MB Rows returned: 18

SHOW FULL COLUMNS 
  FROM `m4yzh_j2store_addresses`

Explain

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

Profile

Status	Duration
Starting	0.15 ms
checking permissions	0.02 ms
closing tables	0.01 ms
Opening tables	0.76 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Filling schema table	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
checking permissions	0.14 ms
closing tables	0.02 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.02 ms
Removing tmp table	0.19 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	4.15 ms
Updating status	0.22 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
23	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/f0f/database/driver/joomla.php:229
22	F0FDatabaseDriverJoomla->getTableColumns()	JROOT/libraries/f0f/table/table.php:2162
21	F0FTable->getTableFields()	JROOT/libraries/f0f/table/table.php:536
20	F0FTable->__construct()	JROOT/administrator/components/com_j2store/tables/customer.php:18
19	J2StoreTableCustomer->__construct()	JROOT/libraries/f0f/table/table.php:433
18	F0FTable::getAnInstance()	JROOT/administrator/components/com_j2store/tables/order.php:515
17	J2StoreTableOrder->getOrderProductTotals()	JROOT/administrator/components/com_j2store/tables/order.php:226
16	J2StoreTableOrder->getTotals()	JROOT/administrator/components/com_j2store/models/orders.php:58
15	J2StoreModelOrders->populateOrder()	JROOT/components/com_j2store/views/carts/view.html.php:119
14	J2StoreViewCarts->onDisplay()	JROOT/libraries/f0f/view/raw.php:167
13	F0FViewRaw->onBrowse()	JROOT/libraries/f0f/view/raw.php:110
12	F0FViewRaw->display()	JROOT/libraries/f0f/controller/controller.php:1125
11	F0FController->display()	JROOT/libraries/f0f/controller/controller.php:1165
10	F0FController->browse()	JROOT/libraries/f0f/controller/controller.php:967
9	F0FController->execute()	JROOT/components/com_j2store/controllers/carts.php:19
8	J2StoreControllerCarts->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_j2store/j2store.php:25
6	require_once JROOT/components/com_j2store/j2store.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.93 ms After last query: 1.41 ms Query memory: 0.027 MB Memory before query: 4.855 MB Rows returned: 2

SELECT shipping.extension_id,shipping.name,shipping.type,shipping.folder,shipping.element,shipping.params,shipping.enabled,shipping.ordering

  FROM m4yzh_extensions as shipping

  WHERE shipping.type='plugin' 
  AND shipping.element LIKE 'shipping_%' 
  AND shipping.folder='j2store'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	shipping	range	element_clientid,element_folder_clientid,extension	element_clientid	402	NULL	2	Using index condition; Using where

Profile

Status	Duration
Starting	0.21 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.10 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.11 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.13 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/f0f/database/driver/joomla.php:321
22	F0FDatabaseDriverJoomla->loadObjectList()	JROOT/libraries/f0f/model/model.php:1953
21	F0FModel->_getList()	JROOT/libraries/f0f/model/model.php:1225
20	F0FModel->getItemList()	JROOT/libraries/f0f/model/model.php:1204
19	F0FModel->getList()	JROOT/administrator/components/com_j2store/models/shippings.php:82
18	J2StoreModelShippings->getShippingRates()	JROOT/administrator/components/com_j2store/tables/order.php:987
17	J2StoreTableOrder->getOrderShippingTotals()	JROOT/administrator/components/com_j2store/tables/order.php:229
16	J2StoreTableOrder->getTotals()	JROOT/administrator/components/com_j2store/models/orders.php:58
15	J2StoreModelOrders->populateOrder()	JROOT/components/com_j2store/views/carts/view.html.php:119
14	J2StoreViewCarts->onDisplay()	JROOT/libraries/f0f/view/raw.php:167
13	F0FViewRaw->onBrowse()	JROOT/libraries/f0f/view/raw.php:110
12	F0FViewRaw->display()	JROOT/libraries/f0f/controller/controller.php:1125
11	F0FController->display()	JROOT/libraries/f0f/controller/controller.php:1165
10	F0FController->browse()	JROOT/libraries/f0f/controller/controller.php:967
9	F0FController->execute()	JROOT/components/com_j2store/controllers/carts.php:19
8	J2StoreControllerCarts->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_j2store/j2store.php:25
6	require_once JROOT/components/com_j2store/j2store.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.33 ms After last query: 0.82 ms Query memory: 0.028 MB Memory before query: 4.872 MB Rows returned: 0

Duplicate queries: #28

SELECT gz.*,gzr.*

  FROM m4yzh_j2store_geozones AS gz

  LEFT JOIN m4yzh_j2store_geozonerules AS gzr 
  ON gzr.geozone_id = gz.j2store_geozone_id

  WHERE gzr.country_id='175' 
  AND (gzr.zone_id=0 OR gzr.zone_id='2686')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	gz	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1
1	SIMPLE	gzr	ref	georule	georule	8	reikiusu_joomla.gz.j2store_geozone_id,const	1	Using where; Using index

Profile

Status	Duration
Starting	0.20 ms
checking permissions	0.02 ms
Opening tables	1.13 ms
After opening tables	0.03 ms
System lock	0.02 ms
table lock	0.02 ms
Opening tables	0.07 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.06 ms
Unlocking tables	0.02 ms
closing tables	0.03 ms
init	0.06 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.05 ms
Executing	0.02 ms
Sending data	0.05 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.03 ms
closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.14 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
26	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_j2store/tables/order.php:1505
25	J2StoreTableOrder->getGeoZones()	JROOT/administrator/components/com_j2store/tables/order.php:1421
24	J2StoreTableOrder->setGeozones()	JROOT/administrator/components/com_j2store/tables/order.php:1396
23	J2StoreTableOrder->setAddress()	JROOT/plugins/j2store/shipping_free/shipping_free.php:55
22	plgJ2StoreShipping_Free->onJ2StoreGetShippingOptions()	JROOT/libraries/joomla/event/event.php:70
21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
20	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
19	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_j2store/models/shippings.php:89
18	J2StoreModelShippings->getShippingRates()	JROOT/administrator/components/com_j2store/tables/order.php:987
17	J2StoreTableOrder->getOrderShippingTotals()	JROOT/administrator/components/com_j2store/tables/order.php:229
16	J2StoreTableOrder->getTotals()	JROOT/administrator/components/com_j2store/models/orders.php:58
15	J2StoreModelOrders->populateOrder()	JROOT/components/com_j2store/views/carts/view.html.php:119
14	J2StoreViewCarts->onDisplay()	JROOT/libraries/f0f/view/raw.php:167
13	F0FViewRaw->onBrowse()	JROOT/libraries/f0f/view/raw.php:110
12	F0FViewRaw->display()	JROOT/libraries/f0f/controller/controller.php:1125
11	F0FController->display()	JROOT/libraries/f0f/controller/controller.php:1165
10	F0FController->browse()	JROOT/libraries/f0f/controller/controller.php:967
9	F0FController->execute()	JROOT/components/com_j2store/controllers/carts.php:19
8	J2StoreControllerCarts->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_j2store/j2store.php:25
6	require_once JROOT/components/com_j2store/j2store.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 5.34 ms After last query: 0.09 ms Query memory: 0.028 MB Memory before query: 4.885 MB Rows returned: 0

Duplicate queries: #27

SELECT gz.*,gzr.*

  FROM m4yzh_j2store_geozones AS gz

  LEFT JOIN m4yzh_j2store_geozonerules AS gzr 
  ON gzr.geozone_id = gz.j2store_geozone_id

  WHERE gzr.country_id='175' 
  AND (gzr.zone_id=0 OR gzr.zone_id='2686')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	gz	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1
1	SIMPLE	gzr	ref	georule	georule	8	reikiusu_joomla.gz.j2store_geozone_id,const	1	Using where; Using index

Profile

Status	Duration
Starting	3.88 ms
checking permissions	0.23 ms
Opening tables	0.42 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.04 ms
Preparing	0.03 ms
Executing	0.02 ms
Sending data	0.03 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
closing tables	0.24 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.14 ms
Updating status	0.03 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
26	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_j2store/tables/order.php:1505
25	J2StoreTableOrder->getGeoZones()	JROOT/administrator/components/com_j2store/tables/order.php:1424
24	J2StoreTableOrder->setGeozones()	JROOT/administrator/components/com_j2store/tables/order.php:1396
23	J2StoreTableOrder->setAddress()	JROOT/plugins/j2store/shipping_free/shipping_free.php:55
22	plgJ2StoreShipping_Free->onJ2StoreGetShippingOptions()	JROOT/libraries/joomla/event/event.php:70
21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
20	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
19	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_j2store/models/shippings.php:89
18	J2StoreModelShippings->getShippingRates()	JROOT/administrator/components/com_j2store/tables/order.php:987
17	J2StoreTableOrder->getOrderShippingTotals()	JROOT/administrator/components/com_j2store/tables/order.php:229
16	J2StoreTableOrder->getTotals()	JROOT/administrator/components/com_j2store/models/orders.php:58
15	J2StoreModelOrders->populateOrder()	JROOT/components/com_j2store/views/carts/view.html.php:119
14	J2StoreViewCarts->onDisplay()	JROOT/libraries/f0f/view/raw.php:167
13	F0FViewRaw->onBrowse()	JROOT/libraries/f0f/view/raw.php:110
12	F0FViewRaw->display()	JROOT/libraries/f0f/controller/controller.php:1125
11	F0FController->display()	JROOT/libraries/f0f/controller/controller.php:1165
10	F0FController->browse()	JROOT/libraries/f0f/controller/controller.php:967
9	F0FController->execute()	JROOT/components/com_j2store/controllers/carts.php:19
8	J2StoreControllerCarts->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_j2store/j2store.php:25
6	require_once JROOT/components/com_j2store/j2store.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.75 ms After last query: 0.97 ms Query memory: 0.028 MB Memory before query: 4.986 MB Rows returned: 0

SELECT tbl.*, taxclass.taxprofile_name 

  FROM m4yzh_j2store_shippingmethods as tbl

  LEFT JOIN m4yzh_j2store_taxprofiles AS taxclass 
  ON tbl.tax_class_id = taxclass.j2store_taxprofile_id

  WHERE tbl.published = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tbl	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where
1	SIMPLE	taxclass	eq_ref	PRIMARY	PRIMARY	4	reikiusu_joomla.tbl.tax_class_id	1

Profile

Status	Duration
Starting	0.18 ms
checking permissions	0.02 ms
Opening tables	0.77 ms
After opening tables	0.03 ms
System lock	0.02 ms
table lock	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.05 ms
Unlocking tables	0.02 ms
closing tables	0.03 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.03 ms
Executing	0.02 ms
Sending data	0.05 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.14 ms
Updating status	1.08 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
26	JDatabaseDriver->loadObjectList()	JROOT/plugins/j2store/shipping_standard/shipping_standard/models/shippingmethods.php:130
25	J2StoreModelShippingMethods->_getList()	JROOT/libraries/f0f/model/model.php:1225
24	F0FModel->getItemList()	JROOT/libraries/f0f/model/model.php:1204
23	F0FModel->getList()	JROOT/plugins/j2store/shipping_standard/shipping_standard.php:131
22	plgJ2StoreShipping_Standard->onJ2StoreGetShippingRates()	JROOT/libraries/joomla/event/event.php:70
21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
20	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
19	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_j2store/models/shippings.php:92
18	J2StoreModelShippings->getShippingRates()	JROOT/administrator/components/com_j2store/tables/order.php:987
17	J2StoreTableOrder->getOrderShippingTotals()	JROOT/administrator/components/com_j2store/tables/order.php:229
16	J2StoreTableOrder->getTotals()	JROOT/administrator/components/com_j2store/models/orders.php:58
15	J2StoreModelOrders->populateOrder()	JROOT/components/com_j2store/views/carts/view.html.php:119
14	J2StoreViewCarts->onDisplay()	JROOT/libraries/f0f/view/raw.php:167
13	F0FViewRaw->onBrowse()	JROOT/libraries/f0f/view/raw.php:110
12	F0FViewRaw->display()	JROOT/libraries/f0f/controller/controller.php:1125
11	F0FController->display()	JROOT/libraries/f0f/controller/controller.php:1165
10	F0FController->browse()	JROOT/libraries/f0f/controller/controller.php:967
9	F0FController->execute()	JROOT/components/com_j2store/controllers/carts.php:19
8	J2StoreControllerCarts->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_j2store/j2store.php:25
6	require_once JROOT/components/com_j2store/j2store.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.90 ms After last query: 15.75 ms Query memory: 0.045 MB Memory before query: 5.170 MB Rows returned: 11

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

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

  LEFT JOIN m4yzh_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 
  AND m.language IN ('en-GB','*')

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	published,newsfeeds,idx_language	NO INDEX KEY COULD BE USED	NULL	NULL	32	Using where; Using filesort
1	SIMPLE	am	eq_ref	PRIMARY	PRIMARY	4	reikiusu_joomla.m.id	1	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	reikiusu_joomla.m.module,const	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.26 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.03 ms
init	0.08 ms
Optimizing	0.05 ms
Statistics	0.13 ms
Preparing	0.06 ms
Sorting result	0.02 ms
Executing	0.02 ms
Sending data	0.02 ms
Creating sort index	0.54 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.13 ms
Updating status	0.03 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:278
23	PlgSystemAdvancedModuleHelper->getModuleList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:60
22	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
21	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
20	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Helper/ModuleHelper.php:366
19	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
18	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/administrator/components/com_j2store/helpers/modules.php:38
17	J2Modules->loadposition()	JROOT/components/com_j2store/views/carts/tmpl/default.php:28
16	include JROOT/components/com_j2store/views/carts/tmpl/default.php	JROOT/libraries/f0f/view/view.php:442
15	F0FView->loadAnyTemplate()	JROOT/libraries/f0f/view/view.php:843
14	F0FView->loadTemplate()	JROOT/libraries/f0f/view/view.php:474
13	F0FView->display()	JROOT/libraries/f0f/view/raw.php:128
12	F0FViewRaw->display()	JROOT/libraries/f0f/controller/controller.php:1125
11	F0FController->display()	JROOT/libraries/f0f/controller/controller.php:1165
10	F0FController->browse()	JROOT/libraries/f0f/controller/controller.php:967
9	F0FController->execute()	JROOT/components/com_j2store/controllers/carts.php:19
8	J2StoreControllerCarts->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_j2store/j2store.php:25
6	require_once JROOT/components/com_j2store/j2store.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 4.85 ms After last query: 3.96 ms Query memory: 0.028 MB Memory before query: 5.309 MB Rows returned: 1

SELECT a.mirror_id

  FROM m4yzh_advancedmodules AS a

  WHERE a.moduleid = 102

Explain

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

Profile

Status	Duration
Starting	0.22 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	2.22 ms
init	1.59 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.02 ms
Unlocking tables	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.35 ms
Updating status	0.03 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
25	JDatabaseDriver->loadResult()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:239
24	PlgSystemAdvancedModuleHelper->getMirrorModuleIdById()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:491
23	PlgSystemAdvancedModuleHelper->setMirrorParams()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:103
22	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
21	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
20	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Helper/ModuleHelper.php:366
19	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
18	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/administrator/components/com_j2store/helpers/modules.php:38
17	J2Modules->loadposition()	JROOT/components/com_j2store/views/carts/tmpl/default.php:28
16	include JROOT/components/com_j2store/views/carts/tmpl/default.php	JROOT/libraries/f0f/view/view.php:442
15	F0FView->loadAnyTemplate()	JROOT/libraries/f0f/view/view.php:843
14	F0FView->loadTemplate()	JROOT/libraries/f0f/view/view.php:474
13	F0FView->display()	JROOT/libraries/f0f/view/raw.php:128
12	F0FViewRaw->display()	JROOT/libraries/f0f/controller/controller.php:1125
11	F0FController->display()	JROOT/libraries/f0f/controller/controller.php:1165
10	F0FController->browse()	JROOT/libraries/f0f/controller/controller.php:967
9	F0FController->execute()	JROOT/components/com_j2store/controllers/carts.php:19
8	J2StoreControllerCarts->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_j2store/j2store.php:25
6	require_once JROOT/components/com_j2store/j2store.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.90 ms After last query: 0.49 ms Query memory: 0.028 MB Memory before query: 5.345 MB Rows returned: 1

SELECT a.mirror_id

  FROM m4yzh_advancedmodules AS a

  WHERE a.moduleid = 105

Explain

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

Profile

Status	Duration
Starting	0.16 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.03 ms
table lock	0.03 ms
init	0.05 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.02 ms
Unlocking tables	0.02 ms
Preparing	0.02 ms
Executing	0.02 ms
Sending data	0.02 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.01 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.14 ms
Updating status	0.03 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
25	JDatabaseDriver->loadResult()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:239
24	PlgSystemAdvancedModuleHelper->getMirrorModuleIdById()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:491
23	PlgSystemAdvancedModuleHelper->setMirrorParams()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:103
22	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
21	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
20	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Helper/ModuleHelper.php:366
19	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
18	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/administrator/components/com_j2store/helpers/modules.php:38
17	J2Modules->loadposition()	JROOT/components/com_j2store/views/carts/tmpl/default.php:28
16	include JROOT/components/com_j2store/views/carts/tmpl/default.php	JROOT/libraries/f0f/view/view.php:442
15	F0FView->loadAnyTemplate()	JROOT/libraries/f0f/view/view.php:843
14	F0FView->loadTemplate()	JROOT/libraries/f0f/view/view.php:474
13	F0FView->display()	JROOT/libraries/f0f/view/raw.php:128
12	F0FViewRaw->display()	JROOT/libraries/f0f/controller/controller.php:1125
11	F0FController->display()	JROOT/libraries/f0f/controller/controller.php:1165
10	F0FController->browse()	JROOT/libraries/f0f/controller/controller.php:967
9	F0FController->execute()	JROOT/components/com_j2store/controllers/carts.php:19
8	J2StoreControllerCarts->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_j2store/j2store.php:25
6	require_once JROOT/components/com_j2store/j2store.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.91 ms After last query: 0.07 ms Query memory: 0.029 MB Memory before query: 5.363 MB Rows returned: 1

SELECT a.params

  FROM m4yzh_advancedmodules AS a

  WHERE a.moduleid = 105

Explain

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

Profile

Status	Duration
Starting	0.18 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.04 ms
Optimizing	0.05 ms
Statistics	0.08 ms
Preparing	0.02 ms
Unlocking tables	0.02 ms
Preparing	0.02 ms
Executing	0.02 ms
Sending data	0.03 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.15 ms
Updating status	0.03 ms
Reset for next command	0.04 ms

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
25	JDatabaseDriver->loadResult()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:191
24	PlgSystemAdvancedModuleHelper->getAdvancedParamsById()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:527
23	PlgSystemAdvancedModuleHelper->setMirrorParams()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:103
22	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
21	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
20	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Helper/ModuleHelper.php:366
19	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
18	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/administrator/components/com_j2store/helpers/modules.php:38
17	J2Modules->loadposition()	JROOT/components/com_j2store/views/carts/tmpl/default.php:28
16	include JROOT/components/com_j2store/views/carts/tmpl/default.php	JROOT/libraries/f0f/view/view.php:442
15	F0FView->loadAnyTemplate()	JROOT/libraries/f0f/view/view.php:843
14	F0FView->loadTemplate()	JROOT/libraries/f0f/view/view.php:474
13	F0FView->display()	JROOT/libraries/f0f/view/raw.php:128
12	F0FViewRaw->display()	JROOT/libraries/f0f/controller/controller.php:1125
11	F0FController->display()	JROOT/libraries/f0f/controller/controller.php:1165
10	F0FController->browse()	JROOT/libraries/f0f/controller/controller.php:967
9	F0FController->execute()	JROOT/components/com_j2store/controllers/carts.php:19
8	J2StoreControllerCarts->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_j2store/j2store.php:25
6	require_once JROOT/components/com_j2store/j2store.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.99 ms After last query: 1.23 ms Query memory: 0.020 MB Memory before query: 5.336 MB Rows returned: 1

SELECT language,id

  FROM `m4yzh_menu`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m4yzh_menu	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	85	Using where

Profile

Status	Duration
Starting	0.17 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.04 ms
Optimizing	0.05 ms
Statistics	0.07 ms
Preparing	0.05 ms
Executing	0.01 ms
Sending data	0.15 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.14 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
8	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.11 ms After last query: 37.83 ms Query memory: 0.026 MB Memory before query: 6.052 MB Rows returned: 1

SELECT params

  FROM m4yzh_modules

  WHERE module='mod_j2store_cart' 
  AND published = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m4yzh_modules	ref	published,newsfeeds	newsfeeds	204	const,const	1	Using index condition

Profile

Status	Duration
Starting	0.26 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.10 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.12 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
19	JDatabaseDriver->loadResult()	JROOT/modules/mod_j2store_cart/helper.php:98
18	modJ2StoreCartHelper::getModuleParams()	JROOT/modules/mod_j2store_cart/helper.php:31
17	modJ2StoreCartHelper::getItems()	JROOT/modules/mod_j2store_cart/mod_j2store_cart.php:67
16	include JROOT/modules/mod_j2store_cart/mod_j2store_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_avenue/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_avenue/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/yoo_avenue/warp/systems/joomla/layouts/widgets.php	JROOT/templates/yoo_avenue/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_avenue/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/yoo_avenue/layouts/theme.php:125
9	include JROOT/templates/yoo_avenue/layouts/theme.php	JROOT/templates/yoo_avenue/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_avenue/index.php:16
7	require JROOT/templates/yoo_avenue/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.96 ms After last query: 16.54 ms Query memory: 0.026 MB Memory before query: 6.041 MB Rows returned: 8

SHOW FULL COLUMNS 
  FROM `m4yzh_template_styles`

Explain

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

Profile

Status	Duration
Starting	0.17 ms
checking permissions	0.03 ms
closing tables	0.01 ms
Opening tables	0.52 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Filling schema table	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
checking permissions	0.10 ms
closing tables	0.02 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Removing tmp table	0.60 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.09 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
18	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
17	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_templates/tables/style.php:30
16	TemplatesTableStyle->__construct()	JROOT/libraries/src/Table/Table.php:328
15	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/gantry/gantry.php:194
14	plgSystemGantry->getTable()	JROOT/plugins/system/gantry/gantry.php:165
13	plgSystemGantry->isGantryTemplate()	JROOT/plugins/system/gantry/gantry.php:234
12	plgSystemGantry->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.80 ms After last query: 0.32 ms Query memory: 0.023 MB Memory before query: 6.062 MB Rows returned: 1

SELECT *

  FROM m4yzh_template_styles

  WHERE `id` = '11'

Explain

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

Profile

Status	Duration
Starting	0.14 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.13 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
15	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
14	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/gantry/gantry.php:168
13	plgSystemGantry->isGantryTemplate()	JROOT/plugins/system/gantry/gantry.php:234
12	plgSystemGantry->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.12 ms After last query: 6.40 ms Query memory: 0.025 MB Memory before query: 6.129 MB Rows returned: 2

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `m4yzh_categories` AS `s`

  INNER JOIN `m4yzh_categories` AS `c` 
  ON (s.lft < c.lft 
  AND c.lft < s.rgt 
  AND c.language IN ('en-GB','*')) OR (c.lft <= s.lft 
  AND s.rgt <= c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id = 2

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right,idx_language	idx_left_right	4	NULL	3	Using index condition; Using where

Profile

Status	Duration
Starting	0.23 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.03 ms
init	0.06 ms
Optimizing	0.06 ms
Statistics	0.15 ms
Preparing	0.02 ms
Unlocking tables	0.01 ms
Preparing	0.04 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.08 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.13 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
17	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
16	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/helpers/legacyrouter.php:173
15	ContentRouterRulesLegacy->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
14	Joomla\CMS\Component\Router\RouterView->build()	JROOT/libraries/src/Router/SiteRouter.php:532
13	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
12	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

35 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

2 × SELECT a.mirror_id 
  FROM m4yzh_advancedmodules AS a

2 × SELECT gz.*,gzr.* 
  FROM m4yzh_j2store_geozones AS gz 
  LEFT JOIN m4yzh_j2store_geozonerules AS gzr 
  ON gzr.geozone_id = gz.j2store_geozone_id

1 × SELECT `data` 
  FROM `m4yzh_session`

1 × SELECT tbl.*, variant.j2store_variant_id, variant.sku, variant.price, variant.pricing_calculator, variant.shipping, variant.weight, variant.length, variant.width, variant.height, variant.length_class_id, variant.weight_class_id, variant.quantity_restriction , variant.min_sale_qty, variant.max_sale_qty, variant.use_store_config_min_sale_qty, variant.use_store_config_max_sale_qty, variant.use_store_config_notify_qty, variant.manage_stock, variant.allow_backorder, product.product_type, product.product_source, product.product_source_id, product.has_options, product.up_sells, product.cross_sells, product.taxprofile_id, product.vendor_id, product.manufacturer_id, product.params as product_params, product.visibility, productimage.thumb_image, stock.on_hold as quantity_on_hold, stock.quantity as available_quantity 
  FROM m4yzh_j2store_cartitems as tbl 
  INNER JOIN m4yzh_j2store_variants AS variant 
  ON tbl.variant_id = variant.j2store_variant_id 
  INNER JOIN m4yzh_j2store_products AS product 
  ON tbl.product_id = product.j2store_product_id 
  LEFT 
  OUTER JOIN m4yzh_j2store_productimages AS productimage 
  ON product.j2store_product_id = productimage.product_id 
  LEFT 
  OUTER JOIN m4yzh_j2store_productquantities AS stock 
  ON variant.j2store_variant_id = stock.variant_id

1 × SELECT * 
  FROM m4yzh_template_styles

1 × SELECT params 
  FROM m4yzh_modules

1 × SELECT language,id 
  FROM `m4yzh_menu`

1 × SELECT a.params 
  FROM m4yzh_advancedmodules AS a

1 × 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 m4yzh_modules AS m 
  LEFT JOIN m4yzh_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id 
  LEFT JOIN m4yzh_advancedmodules as am 
  ON am.moduleid = m.id

1 × SELECT tbl.*, taxclass.taxprofile_name  
  FROM m4yzh_j2store_shippingmethods as tbl 
  LEFT JOIN m4yzh_j2store_taxprofiles AS taxclass 
  ON tbl.tax_class_id = taxclass.j2store_taxprofile_id

1 × SELECT shipping.extension_id,shipping.name,shipping.type,shipping.folder,shipping.element,shipping.params,shipping.enabled,shipping.ordering 
  FROM m4yzh_extensions as shipping

1 × SELECT m4yzh_j2store_carts.* 
  FROM m4yzh_j2store_carts

1 × SELECT `session_id` 
  FROM `m4yzh_session`

1 × SELECT `m4yzh_j2store_currencies`.* 
  FROM `m4yzh_j2store_currencies`

1 × SELECT template 
  FROM m4yzh_template_styles

1 × SELECT `extension_id`,`name`,`enabled`,`params` 
  FROM m4yzh_extensions

1 × SELECT id, home, template, s.params 
  FROM m4yzh_template_styles as s 
  LEFT JOIN m4yzh_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `m4yzh_assets`

1 × 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 m4yzh_menu AS m 
  LEFT JOIN m4yzh_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT * 
  FROM m4yzh_j2store_configuration

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

1 × SELECT id, rules 
  FROM `m4yzh_viewlevels

1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM `m4yzh_categories` AS `s` 
  INNER JOIN `m4yzh_categories` AS `c` 
  ON (s.lft < c.lft 
  AND c.lft < s.rgt 
  AND c.language IN ('en-GB','*')) OR (c.lft <= s.lft 
  AND s.rgt <= c.rgt)

OTHER Tables:

2 × SHOW FULL COLUMNS 
  FROM `m4yzh_j2store_currencies

1 × INSERT INTO `m4yzh_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'3737626366336464653165326330613935353034363536623563616339633662', 1, 1701463153, 0, '', 0

1 × UPDATE `m4yzh_extensions` 
  SET `params` = '{\"mediaversion\":\"ea74c43642424e90b0ea6b576203f84e\"}'

```
1 × SHOW TABLE
```

1 × SHOW FULL COLUMNS 
  FROM `m4yzh_j2store_carts

1 × INSERT INTO `m4yzh_j2store_carts` (`user_id`,`session_id`,`cart_type`,`created_on`,`customer_ip`,`cart_browser`,`cart_analytics`) 
  VALUES  ('0','77bcf3dde1e2c0a95504656b5cac9c6b','cart','2023-12-01 20:39:13','3.233.221.90','','{\"is_mobile\":false}'

1 × SHOW FULL COLUMNS 
  FROM `m4yzh_j2store_orders

1 × SHOW FULL COLUMNS 
  FROM `m4yzh_j2store_orderinfos

1 × SHOW FULL COLUMNS 
  FROM `m4yzh_j2store_countries

1 × SHOW FULL COLUMNS 
  FROM `m4yzh_j2store_zones

1 × SHOW FULL COLUMNS 
  FROM `m4yzh_j2store_addresses

1 × SHOW FULL COLUMNS 
  FROM `m4yzh_template_styles