Banner: 3' x 15' "Pumpkin Patch"

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1566688735,
                "last": 1566688735,
                "now": 1566688735
            },
            "token": "tOcFESPstDVOVpwgkxSYM4ML4zqT4UWh"
        },
        "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
        },
        "diametric-ef8339a53c9db79bde5438a930d8aa12-presets": null,
        "diametric-ef8339a53c9db79bde5438a930d8aa12-name": null,
        "diametric-ef8339a53c9db79bde5438a930d8aa12-headerpanel-backgroundcolor": null,
        "diametric-ef8339a53c9db79bde5438a930d8aa12-headerpanel-overlay": null,
        "diametric-ef8339a53c9db79bde5438a930d8aa12-headerpanel-accentcolor": null,
        "diametric-ef8339a53c9db79bde5438a930d8aa12-headerpanel-accentoverlay": null,
        "diametric-ef8339a53c9db79bde5438a930d8aa12-headerpanel-pattern": null,
        "diametric-ef8339a53c9db79bde5438a930d8aa12-showcasepanel-backgroundcolor": null,
        "diametric-ef8339a53c9db79bde5438a930d8aa12-showcasepanel-overlay": null,
        "diametric-ef8339a53c9db79bde5438a930d8aa12-showcasepanel-accentcolor": null,
        "diametric-ef8339a53c9db79bde5438a930d8aa12-showcasepanel-accentoverlay": null,
        "diametric-ef8339a53c9db79bde5438a930d8aa12-showcasepanel-pattern": null,
        "diametric-ef8339a53c9db79bde5438a930d8aa12-featurepanel-backgroundcolor": null,
        "diametric-ef8339a53c9db79bde5438a930d8aa12-featurepanel-overlay": null,
        "diametric-ef8339a53c9db79bde5438a930d8aa12-featurepanel-accentcolor": null,
        "diametric-ef8339a53c9db79bde5438a930d8aa12-featurepanel-accentoverlay": null,
        "diametric-ef8339a53c9db79bde5438a930d8aa12-featurepanel-pattern": null,
        "diametric-ef8339a53c9db79bde5438a930d8aa12-menu-overlay": null,
        "diametric-ef8339a53c9db79bde5438a930d8aa12-body-overlay": null,
        "diametric-ef8339a53c9db79bde5438a930d8aa12-body-accentcolor": null,
        "diametric-ef8339a53c9db79bde5438a930d8aa12-body-accentoverlay": null,
        "diametric-ef8339a53c9db79bde5438a930d8aa12-footerpanel-backgroundcolor": null,
        "diametric-ef8339a53c9db79bde5438a930d8aa12-footerpanel-overlay": null,
        "diametric-ef8339a53c9db79bde5438a930d8aa12-footerpanel-accentcolor": null,
        "diametric-ef8339a53c9db79bde5438a930d8aa12-footerpanel-accentoverlay": null,
        "diametric-ef8339a53c9db79bde5438a930d8aa12-footerpanel-pattern": null,
        "diametric-ef8339a53c9db79bde5438a930d8aa12-logostyle": null,
        "diametric-ef8339a53c9db79bde5438a930d8aa12-font-family": null,
        "diametric-ef8339a53c9db79bde5438a930d8aa12-font-size-is": null,
        "diametric-ef8339a53c9db79bde5438a930d8aa12-logo-type": null,
        "diametric-ef8339a53c9db79bde5438a930d8aa12-logo-custom-image": null,
        "diametric-ef8339a53c9db79bde5438a930d8aa12-menu-type": null,
        "diametric-ef8339a53c9db79bde5438a930d8aa12-typography-style": null,
        "gantry-current-template": "rt_diametric"
    }
}

Profile Information

Time

Memory

Time: 92.41 ms / 92.41 ms Memory: 0.507 MB / 0.64 MB Application: afterLoad

Time: 548.65 ms / 641.06 ms Memory: 1.955 MB / 2.59 MB Application: afterInitialise

Time: 133.27 ms / 774.33 ms Memory: 0.509 MB / 3.10 MB Application: afterRoute

Time: 2.93 ms / 777.26 ms Memory: 0.048 MB / 3.15 MB Application: beforeRenderComponent com_mijoshop

Time: 447.80 ms / 1225.07 ms Memory: 2.652 MB / 5.80 MB Application: afterRenderComponent com_mijoshop

Time: 8.70 ms / 1233.77 ms Memory: 0.016 MB / 5.82 MB Application: afterDispatch

Time: 154.80 ms / 1388.57 ms Memory: 1.259 MB / 7.08 MB Application: beforeRenderModule mod_roknavmenu ()

Time: 24.98 ms / 1413.56 ms Memory: 0.258 MB / 7.33 MB Application: afterRenderModule mod_roknavmenu ()

Time: 21.19 ms / 1434.75 ms Memory: 0.015 MB / 7.35 MB Application: beforeRenderModule mod_custom (Copyright C)

Time: 3.98 ms / 1438.73 ms Memory: 0.007 MB / 7.36 MB Application: afterRenderModule mod_custom (Copyright C)

Time: 0.11 ms / 1438.84 ms Memory: 0.000 MB / 7.35 MB Application: beforeRenderModule mod_custom (Account Information)

Time: 7.64 ms / 1446.48 ms Memory: 0.024 MB / 7.38 MB Application: afterRenderModule mod_custom (Account Information)

Time: 0.15 ms / 1446.64 ms Memory: 0.000 MB / 7.38 MB Application: beforeRenderModule mod_custom (Evans Extras)

Time: 3.48 ms / 1450.12 ms Memory: 0.005 MB / 7.38 MB Application: afterRenderModule mod_custom (Evans Extras)

Time: 0.09 ms / 1450.21 ms Memory: 0.000 MB / 7.38 MB Application: beforeRenderModule mod_custom (Customer Service)

Time: 2.71 ms / 1452.92 ms Memory: 0.005 MB / 7.39 MB Application: afterRenderModule mod_custom (Customer Service)

Time: 0.09 ms / 1453.02 ms Memory: 0.000 MB / 7.39 MB Application: beforeRenderModule mod_custom (General Information)

Time: 2.82 ms / 1455.83 ms Memory: 0.005 MB / 7.39 MB Application: afterRenderModule mod_custom (General Information)

Time: 0.13 ms / 1455.97 ms Memory: 0.000 MB / 7.39 MB Application: beforeRenderModule mod_custom (Featured Products (Panel Title))

Time: 2.73 ms / 1458.69 ms Memory: 0.005 MB / 7.39 MB Application: afterRenderModule mod_custom (Featured Products (Panel Title))

Time: 0.05 ms / 1458.74 ms Memory: 0.000 MB / 7.39 MB Application: beforeRenderModule mod_mijoshop (Featured Products)

Time: 73.50 ms / 1532.23 ms Memory: 0.537 MB / 7.93 MB Application: afterRenderModule mod_mijoshop (Featured Products)

Time: 0.17 ms / 1532.40 ms Memory: 0.000 MB / 7.92 MB Application: beforeRenderModule mod_custom (Shop Evans Christmas Supply)

Time: 2.61 ms / 1535.02 ms Memory: 0.005 MB / 7.92 MB Application: afterRenderModule mod_custom (Shop Evans Christmas Supply)

Time: 0.11 ms / 1535.12 ms Memory: 0.000 MB / 7.92 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumb)

Time: 11.24 ms / 1546.36 ms Memory: 0.047 MB / 7.97 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumb)

Time: 0.11 ms / 1546.47 ms Memory: 0.000 MB / 7.95 MB Application: beforeRenderModule mod_mijoshop (Mini Shopping Cart)

Time: 37.99 ms / 1584.47 ms Memory: 0.016 MB / 7.96 MB Application: afterRenderModule mod_mijoshop (Mini Shopping Cart)

Time: 0.15 ms / 1584.61 ms Memory: 0.000 MB / 7.96 MB Application: beforeRenderModule mod_custom (Evans Logo)

Time: 2.41 ms / 1587.03 ms Memory: 0.005 MB / 7.96 MB Application: afterRenderModule mod_custom (Evans Logo)

Time: 26.54 ms / 1613.57 ms Memory: 0.178 MB / 8.14 MB Application: afterRender

Database queries total: 132.85 ms

Memory Usage

Database Queries

101 Queries Logged 132.85 ms

25 duplicate found!

2 duplicates: #8 #9

2 duplicates: #14 #16

4 duplicates: #21 #65 #66 #67

3 duplicates: #33 #64 #98

4 duplicates: #42 #45 #48 #51

4 duplicates: #43 #46 #49 #52

4 duplicates: #44 #47 #50 #53

2 duplicates: #60 #99

Query Time: 0.50 ms Query memory: 0.013 MB Memory before query: 0.970 MB Rows returned: 0

SELECT `data`

  FROM `mov2g_session`

  WHERE `session_id` = 'cqs6rd1enrrd5op556orst5pq1'

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.32 ms After last query: 6.57 ms Query memory: 0.008 MB Memory before query: 1.004 MB Rows returned: 0

SELECT `session_id`

  FROM `mov2g_session`

  WHERE `session_id` = 'cqs6rd1enrrd5op556orst5pq1' 
  LIMIT 1

Explain

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

Profile

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

Call Stack

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

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

Query Time: 9.16 ms After last query: 0.19 ms Query memory: 0.006 MB Memory before query: 1.014 MB

INSERT INTO `mov2g_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('cqs6rd1enrrd5op556orst5pq1', 1, 1566688735, 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `mov2g_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('cqs6rd1enrrd5op556orst5pq1', 1, 1566688735, 0, '', 0)

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.00 ms
init	0.01 ms
update	0.06 ms
Waiting for query cache lock	0.00 ms
update	0.01 ms
end	0.00 ms
query end	8.74 ms
closing tables	0.03 ms
freeing items	0.15 ms
logging slow query	0.01 ms
cleaning up	0.00 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:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT\libraries\src\Application\CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT\libraries\src\Application\CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT\libraries\src\Application\SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT\libraries\src\Application\CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT\libraries\src\Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT\index.php:46

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

Query Time: 1.00 ms After last query: 17.54 ms Query memory: 0.019 MB Memory before query: 1.068 MB Rows returned: 45

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

  FROM `mov2g_extensions`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mov2g_extensions	ref	extension	extension	82	const	45	Using where

Profile

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

Call Stack

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

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

Query Time: 0.56 ms After last query: 12.32 ms Query memory: 0.009 MB Memory before query: 1.135 MB Rows returned: 3

SELECT id, rules

  FROM `mov2g_viewlevels`

Explain

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

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
System lock	0.02 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.12 ms
logging slow query	0.01 ms
cleaning up	0.00 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:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT\libraries\src\Plugin\PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT\libraries\src\Plugin\PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT\libraries\src\Application\SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 0.43 ms After last query: 0.37 ms Query memory: 0.010 MB Memory before query: 1.149 MB Rows returned: 1

SELECT b.id

  FROM mov2g_usergroups AS a

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

  WHERE a.id = 1

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.10 ms
logging slow query	0.00 ms
cleaning up	0.00 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:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT\libraries\src\Plugin\PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT\libraries\src\Plugin\PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT\libraries\src\Application\SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 2.26 ms After last query: 2.50 ms Query memory: 0.012 MB Memory before query: 1.180 MB Rows returned: 110

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

  FROM mov2g_extensions

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

  ORDER BY ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mov2g_extensions	ref	extension	extension	82	const	135	Using where; Using filesort

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.03 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.00 ms
Sorting result	0.80 ms
Sending data	1.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.09 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

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

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

Query Time: 0.63 ms After last query: 107.10 ms Query memory: 0.012 MB Memory before query: 1.625 MB Rows returned: 1

Duplicate queries: #9

SELECT template

  FROM mov2g_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT\libraries\rokcommon\RokCommon\PlatformInfo\Joomla.php:31
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT\libraries\rokcommon\RokCommon\PlatformInfo\Joomla.php:105
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT\libraries\rokcommon\RokCommon\Service.php:71
10	RokCommon_Service::getContainer()	JROOT\libraries\rokcommon\include.php:38
9	require_once JROOT\libraries\rokcommon\include.php	JROOT\plugins\system\rokcommon\rokcommon.php:95
8	plgSystemRokCommon->loadCommonLib()	JROOT\plugins\system\rokcommon\rokcommon.php:53
7	plgSystemRokCommon->__construct()	JROOT\libraries\src\Plugin\PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT\libraries\src\Plugin\PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT\libraries\src\Application\CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 0.43 ms After last query: 0.24 ms Query memory: 0.013 MB Memory before query: 1.637 MB Rows returned: 1

Duplicate queries: #8

SELECT template

  FROM mov2g_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT\libraries\rokcommon\RokCommon\PlatformInfo\Joomla.php:31
13	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT\libraries\rokcommon\RokCommon\PlatformInfo\Joomla.php:67
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath()	JROOT\libraries\rokcommon\RokCommon\PlatformInfo\Joomla.php:106
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT\libraries\rokcommon\RokCommon\Service.php:71
10	RokCommon_Service::getContainer()	JROOT\libraries\rokcommon\include.php:38
9	require_once JROOT\libraries\rokcommon\include.php	JROOT\plugins\system\rokcommon\rokcommon.php:95
8	plgSystemRokCommon->loadCommonLib()	JROOT\plugins\system\rokcommon\rokcommon.php:53
7	plgSystemRokCommon->__construct()	JROOT\libraries\src\Plugin\PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT\libraries\src\Plugin\PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT\libraries\src\Application\CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 0.71 ms After last query: 29.33 ms Query memory: 0.010 MB Memory before query: 1.761 MB Rows returned: 4

SELECT extension, file, type

  FROM mov2g_rokcommon_configs

  ORDER BY priority

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\rokcommon\rokcommon.php:131
8	plgSystemRokCommon->processRegisteredConfigs()	JROOT\plugins\system\rokcommon\rokcommon.php:75
7	plgSystemRokCommon->__construct()	JROOT\libraries\src\Plugin\PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT\libraries\src\Plugin\PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT\libraries\src\Application\CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 0.55 ms After last query: 34.51 ms Query memory: 0.008 MB Memory before query: 2.095 MB Rows returned: 1

SELECT `enabled`

  FROM `mov2g_extensions`

  WHERE `element` = 'com_akeeba' 
  AND `type` = 'component'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT\plugins\system\backuponupdate\backuponupdate.php:71
7	require_once JROOT\plugins\system\backuponupdate\backuponupdate.php	JROOT\libraries\src\Plugin\PluginHelper.php:253
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT\libraries\src\Plugin\PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT\libraries\src\Application\CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 4.66 ms After last query: 46.74 ms Query memory: 0.015 MB Memory before query: 2.343 MB Rows returned: 18

SHOW FULL COLUMNS 
  FROM `mov2g_extensions`

Explain

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

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	2.26 ms
System lock	0.01 ms
init	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.06 ms
checking permissions	0.12 ms
checking permissions	0.06 ms
checking permissions	0.06 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.04 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.06 ms
checking permissions	0.04 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
Sending data	0.11 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	1.10 ms
closing tables	0.01 ms
freeing items	0.20 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT\libraries\joomla\database\driver\mysqli.php:445
14	JDatabaseDriverMysqli->getTableColumns()	JROOT\libraries\src\Table\Table.php:245
13	Joomla\CMS\Table\Table->getFields()	JROOT\libraries\src\Table\Table.php:164
12	Joomla\CMS\Table\Table->__construct()	JROOT\libraries\src\Table\Extension.php:32
11	Joomla\CMS\Table\Extension->__construct()	JROOT\libraries\src\Table\Table.php:312
10	Joomla\CMS\Table\Table::getInstance()	JROOT\plugins\system\roksprocket\roksprocket.php:45
9	plgSystemRokSprocket->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 0.46 ms After last query: 5.09 ms Query memory: 0.010 MB Memory before query: 2.386 MB Rows returned: 1

SELECT `extension_id`

  FROM `mov2g_extensions`

  WHERE type = 'component' 
  AND element = 'com_roksprocket'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT\libraries\src\Table\Extension.php:124
10	Joomla\CMS\Table\Extension->find()	JROOT\plugins\system\roksprocket\roksprocket.php:49
9	plgSystemRokSprocket->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 0.31 ms After last query: 0.20 ms Query memory: 0.013 MB Memory before query: 2.397 MB Rows returned: 1

Duplicate queries: #16

SELECT *

  FROM mov2g_extensions

  WHERE `extension_id` = '10035'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1465
11	JDatabaseDriver->loadAssoc()	JROOT\libraries\src\Table\Table.php:731
10	Joomla\CMS\Table\Table->load()	JROOT\plugins\system\roksprocket\roksprocket.php:54
9	plgSystemRokSprocket->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 0.30 ms After last query: 0.20 ms Query memory: 0.010 MB Memory before query: 2.406 MB Rows returned: 1

SELECT `extension_id`

  FROM `mov2g_extensions`

  WHERE type = 'module' 
  AND element = 'mod_roksprocket'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT\libraries\src\Table\Extension.php:124
10	Joomla\CMS\Table\Extension->find()	JROOT\plugins\system\roksprocket\roksprocket.php:72
9	plgSystemRokSprocket->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 0.25 ms After last query: 0.20 ms Query memory: 0.013 MB Memory before query: 2.416 MB Rows returned: 1

Duplicate queries: #14

SELECT *

  FROM mov2g_extensions

  WHERE `extension_id` = '10035'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1465
11	JDatabaseDriver->loadAssoc()	JROOT\libraries\src\Table\Table.php:731
10	Joomla\CMS\Table\Table->load()	JROOT\plugins\system\roksprocket\roksprocket.php:76
9	plgSystemRokSprocket->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 1.20 ms After last query: 180.07 ms Query memory: 0.019 MB Memory before query: 2.647 MB Rows returned: 5

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

  LEFT JOIN mov2g_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	90	Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	j_evanschristmas.m.component_id	1

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
System lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.00 ms
Sorting result	0.35 ms
Sending data	0.13 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.23 ms
logging slow query	0.01 ms
cleaning up	0.00 ms

Call Stack

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

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

Query Time: 0.59 ms After last query: 46.21 ms Query memory: 0.017 MB Memory before query: 2.827 MB Rows returned: 1

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

  FROM `mov2g_extensions`

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1662
20	JDatabaseDriver->loadObject()	JROOT\libraries\src\Helper\LibraryHelper.php:167
19	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
18	call_user_func_array()	JROOT\libraries\src\Cache\Controller\CallbackController.php:173
17	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT\libraries\src\Helper\LibraryHelper.php:175
16	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT\libraries\src\Helper\LibraryHelper.php:43
15	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT\libraries\src\Helper\LibraryHelper.php:90
14	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT\libraries\src\Version.php:321
13	Joomla\CMS\Version->getMediaVersion()	JROOT\libraries\src\Factory.php:778
12	Joomla\CMS\Factory::createDocument()	JROOT\libraries\src\Factory.php:234
11	Joomla\CMS\Factory::getDocument()	JROOT\plugins\system\mijoshopjquery\mijoshopjquery.php:184
10	plgSystemMijoshopJquery->_checkUp()	JROOT\plugins\system\mijoshopjquery\mijoshopjquery.php:36
9	plgSystemMijoshopJquery->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT\libraries\src\Application\SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT\libraries\src\Application\SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 9.10 ms After last query: 0.30 ms Query memory: 0.012 MB Memory before query: 2.826 MB

UPDATE `mov2g_extensions`

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

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

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.00 ms
init	0.05 ms
Updating	0.05 ms
end	0.00 ms
Waiting for query cache lock	0.00 ms
end	0.01 ms
query end	8.76 ms
closing tables	0.01 ms
freeing items	0.07 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

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

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

Query Time: 1.31 ms After last query: 8.50 ms Query memory: 0.015 MB Memory before query: 2.902 MB Rows returned: 11

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

  FROM mov2g_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2019-08-24 23:18:55') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-08-24 23:18:55') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 214 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	range	PRIMARY,published,newsfeeds	published	5	NULL	21	Using where; Using filesort
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	j_evanschristmas.m.module,const	1	Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	j_evanschristmas.m.id	4	Using where; Using index

Profile

Status	Duration
starting	0.14 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
System lock	0.01 ms
init	0.06 ms
optimizing	0.04 ms
statistics	0.14 ms
preparing	0.03 ms
executing	0.00 ms
Sorting result	0.12 ms
Sending data	0.40 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.11 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
16	JDatabaseDriver->loadObjectList()	Same as call in the line below.
15	call_user_func_array()	JROOT\libraries\src\Cache\Controller\CallbackController.php:173
14	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT\libraries\src\Helper\ModuleHelper.php:432
13	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT\libraries\src\Helper\ModuleHelper.php:362
12	Joomla\CMS\Helper\ModuleHelper::load()	JROOT\libraries\src\Helper\ModuleHelper.php:37
11	Joomla\CMS\Helper\ModuleHelper::getModule()	JROOT\plugins\system\mijoshopjquery\mijoshopjquery.php:213
10	plgSystemMijoshopJquery->_checkUp()	JROOT\plugins\system\mijoshopjquery\mijoshopjquery.php:36
9	plgSystemMijoshopJquery->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT\libraries\src\Application\SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT\libraries\src\Application\SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 0.71 ms After last query: 8.12 ms Query memory: 0.016 MB Memory before query: 2.967 MB Rows returned: 10

Duplicate queries: #65 #66 #67

SELECT id, home, template, s.params

  FROM mov2g_template_styles as s

  LEFT JOIN mov2g_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	13	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	j_evanschristmas.s.template,const	1	Using where

Profile

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

Call Stack

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

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

Query Time: 28.61 ms After last query: 12.38 ms Query memory: 0.016 MB Memory before query: 3.040 MB Rows returned: 247

SHOW TABLES

Explain

EXPLAIN not possible on query: SHOW TABLES

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.22 ms
System lock	0.01 ms
init	0.00 ms
optimizing	0.00 ms
statistics	0.00 ms
preparing	0.00 ms
executing	0.01 ms
checking permissions	27.90 ms
Sending data	0.11 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.01 ms
closing tables	0.00 ms
freeing items	0.15 ms
logging slow query	0.00 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1550
16	JDatabaseDriver->loadColumn()	JROOT\libraries\joomla\database\driver\mysqli.php:502
15	JDatabaseDriverMysqli->getTableList()	JROOT\components\com_mijoshop\mijoshop\base.php:169
14	MijoShopBase->getConfig()	JROOT\components\com_mijoshop\mijoshop\db.php:259
13	MijoShopDb->getDbo()	JROOT\components\com_mijoshop\mijoshop\base.php:574
12	MijoShopBase->getStoreId()	JROOT\components\com_mijoshop\mijoshop\router.php:492
11	MijoShopRouter->getItemid()	JROOT\components\com_mijoshop\mijoshop\base.php:618
10	MijoShopBase->isAdmin()	JROOT\plugins\system\mijoshopjquery\mijoshopjquery.php:141
9	plgSystemMijoshopJquery->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT\libraries\src\Application\SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT\libraries\src\Application\SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 0.35 ms After last query: 0.41 ms Query memory: 0.013 MB Memory before query: 3.082 MB Rows returned: 1

SELECT `value` 
  FROM `mov2g_mijoshop_setting` 
  WHERE `key` = 'config_mijoshop'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT\components\com_mijoshop\mijoshop\base.php:173
14	MijoShopBase->getConfig()	JROOT\components\com_mijoshop\mijoshop\db.php:259
13	MijoShopDb->getDbo()	JROOT\components\com_mijoshop\mijoshop\base.php:574
12	MijoShopBase->getStoreId()	JROOT\components\com_mijoshop\mijoshop\router.php:492
11	MijoShopRouter->getItemid()	JROOT\components\com_mijoshop\mijoshop\base.php:618
10	MijoShopBase->isAdmin()	JROOT\plugins\system\mijoshopjquery\mijoshopjquery.php:141
9	plgSystemMijoshopJquery->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT\libraries\src\Application\SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT\libraries\src\Application\SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 0.22 ms After last query: 0.18 ms Query memory: 0.011 MB Memory before query: 3.067 MB Rows returned: 0

SELECT store_id 
  FROM mov2g_mijoshop_store 
  WHERE REPLACE(`url`, 'www.', '') = 'http://evanschristmas.com/'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT\components\com_mijoshop\mijoshop\base.php:584
12	MijoShopBase->getStoreId()	JROOT\components\com_mijoshop\mijoshop\router.php:492
11	MijoShopRouter->getItemid()	JROOT\components\com_mijoshop\mijoshop\base.php:618
10	MijoShopBase->isAdmin()	JROOT\plugins\system\mijoshopjquery\mijoshopjquery.php:141
9	plgSystemMijoshopJquery->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT\libraries\src\Application\SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT\libraries\src\Application\SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 0.30 ms After last query: 2.22 ms Query memory: 0.014 MB Memory before query: 3.106 MB Rows returned: 8

SELECT * 
  FROM mov2g_rokcandy 
  WHERE published=1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT\administrator\components\com_rokcandy\helpers\rokcandy.php:27
14	RokCandyHelper::getUserMacros()	Same as call in the line below.
13	call_user_func_array()	JROOT\libraries\src\Cache\Controller\CallbackController.php:173
12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT\libraries\src\Cache\Controller\CallbackController.php:45
11	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT\administrator\components\com_rokcandy\helpers\rokcandy.php:17
10	RokCandyHelper::getMacros()	JROOT\plugins\system\rokcandy\rokcandy.php:28
9	plgSystemRokCandy->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT\libraries\src\Application\SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT\libraries\src\Application\SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 0.31 ms After last query: 1.07 ms Query memory: 0.009 MB Memory before query: 3.107 MB Rows returned: 1

SELECT *

  FROM mov2g_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

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

Call Stack

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

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

Query Time: 2.16 ms After last query: 113.78 ms Query memory: 0.020 MB Memory before query: 4.805 MB Rows returned: 263

SELECT * 
  FROM mov2g_mijoshop_setting 
  WHERE store_id = '0' OR store_id = '0' 
  ORDER BY store_id ASC

Explain

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

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sorting result	0.17 ms
Sending data	1.53 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.09 ms
logging slow query	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1506
13	JDatabaseDriver->loadAssocList()	JROOT\components\com_mijoshop\opencart\system\library\db.php:25
12	DB->query()	JROOT\components\com_mijoshop\mijoshop\opencart.php:117
11	MijoShopOpencart->__construct()	JROOT\components\com_mijoshop\mijoshop\mijoshop.php:25
10	MijoShop::get()	JROOT\components\com_mijoshop\mijoshop\mijoshop.php:42
9	MijoShop::getClass()	JROOT\components\com_mijoshop\opencart\index.php:12
8	require_once JROOT\components\com_mijoshop\opencart\index.php	JROOT\components\com_mijoshop\mijoshop\site.php:32
7	require_once JROOT\components\com_mijoshop\mijoshop\site.php	JROOT\components\com_mijoshop\mijoshop.php:18
6	require_once JROOT\components\com_mijoshop\mijoshop.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 0.35 ms After last query: 1.63 ms Query memory: 0.017 MB Memory before query: 5.092 MB Rows returned: 1

SELECT * 
  FROM mov2g_languages 
  WHERE published = 1 
  ORDER BY ordering, title

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1506
15	JDatabaseDriver->loadAssocList()	JROOT\components\com_mijoshop\mijoshop\db.php:243
14	MijoShopDb->run()	JROOT\components\com_mijoshop\mijoshop\db.php:176
13	MijoShopDb->_getLanguageList()	JROOT\components\com_mijoshop\mijoshop\db.php:160
12	MijoShopDb->getLanguageList()	JROOT\components\com_mijoshop\mijoshop\opencart.php:181
11	MijoShopOpencart->__construct()	JROOT\components\com_mijoshop\mijoshop\mijoshop.php:25
10	MijoShop::get()	JROOT\components\com_mijoshop\mijoshop\mijoshop.php:42
9	MijoShop::getClass()	JROOT\components\com_mijoshop\opencart\index.php:12
8	require_once JROOT\components\com_mijoshop\opencart\index.php	JROOT\components\com_mijoshop\mijoshop\site.php:32
7	require_once JROOT\components\com_mijoshop\mijoshop\site.php	JROOT\components\com_mijoshop\mijoshop.php:18
6	require_once JROOT\components\com_mijoshop\mijoshop.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 0.27 ms After last query: 0.15 ms Query memory: 0.017 MB Memory before query: 5.108 MB Rows returned: 1

SELECT * 
  FROM mov2g_languages  
  ORDER BY ordering, title

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1506
16	JDatabaseDriver->loadAssocList()	JROOT\components\com_mijoshop\mijoshop\db.php:243
15	MijoShopDb->run()	JROOT\components\com_mijoshop\mijoshop\db.php:176
14	MijoShopDb->_getLanguageList()	JROOT\components\com_mijoshop\mijoshop\db.php:151
13	MijoShopDb->getLanguageList()	JROOT\components\com_mijoshop\mijoshop\db.php:197
12	MijoShopDb->getLanguage()	JROOT\components\com_mijoshop\mijoshop\opencart.php:188
11	MijoShopOpencart->__construct()	JROOT\components\com_mijoshop\mijoshop\mijoshop.php:25
10	MijoShop::get()	JROOT\components\com_mijoshop\mijoshop\mijoshop.php:42
9	MijoShop::getClass()	JROOT\components\com_mijoshop\opencart\index.php:12
8	require_once JROOT\components\com_mijoshop\opencart\index.php	JROOT\components\com_mijoshop\mijoshop\site.php:32
7	require_once JROOT\components\com_mijoshop\mijoshop\site.php	JROOT\components\com_mijoshop\mijoshop.php:18
6	require_once JROOT\components\com_mijoshop\mijoshop.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 0.47 ms After last query: 8.14 ms Query memory: 0.015 MB Memory before query: 5.132 MB Rows returned: 3

SELECT * 
  FROM mov2g_mijoshop_currency

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1506
14	JDatabaseDriver->loadAssocList()	JROOT\components\com_mijoshop\opencart\system\library\db.php:25
13	DB->query()	JROOT\components\com_mijoshop\opencart\vqmod\vqcache\vq2-system_library_currency.php:23
12	Currency->__construct()	JROOT\components\com_mijoshop\mijoshop\opencart.php:295
11	MijoShopOpencart->__construct()	JROOT\components\com_mijoshop\mijoshop\mijoshop.php:25
10	MijoShop::get()	JROOT\components\com_mijoshop\mijoshop\mijoshop.php:42
9	MijoShop::getClass()	JROOT\components\com_mijoshop\opencart\index.php:12
8	require_once JROOT\components\com_mijoshop\opencart\index.php	JROOT\components\com_mijoshop\mijoshop\site.php:32
7	require_once JROOT\components\com_mijoshop\mijoshop\site.php	JROOT\components\com_mijoshop\mijoshop.php:18
6	require_once JROOT\components\com_mijoshop\mijoshop.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 0.35 ms After last query: 0.20 ms Query memory: 0.014 MB Memory before query: 5.149 MB Rows returned: 4

SELECT * 
  FROM mov2g_mijoshop_weight_class wc 
  LEFT JOIN mov2g_mijoshop_weight_class_description wcd 
  ON (wc.weight_class_id = wcd.weight_class_id) 
  WHERE wcd.language_id = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	wcd	ref	PRIMARY,language_idd	language_idd	4	const	3	Using where
1	SIMPLE	wc	eq_ref	PRIMARY	PRIMARY	4	j_evanschristmas.wcd.weight_class_id	1

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1506
14	JDatabaseDriver->loadAssocList()	JROOT\components\com_mijoshop\opencart\system\library\db.php:25
13	DB->query()	JROOT\components\com_mijoshop\opencart\system\library\weight.php:19
12	Weight->__construct()	JROOT\components\com_mijoshop\mijoshop\opencart.php:305
11	MijoShopOpencart->__construct()	JROOT\components\com_mijoshop\mijoshop\mijoshop.php:25
10	MijoShop::get()	JROOT\components\com_mijoshop\mijoshop\mijoshop.php:42
9	MijoShop::getClass()	JROOT\components\com_mijoshop\opencart\index.php:12
8	require_once JROOT\components\com_mijoshop\opencart\index.php	JROOT\components\com_mijoshop\mijoshop\site.php:32
7	require_once JROOT\components\com_mijoshop\mijoshop\site.php	JROOT\components\com_mijoshop\mijoshop.php:18
6	require_once JROOT\components\com_mijoshop\mijoshop.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 0.29 ms After last query: 0.18 ms Query memory: 0.014 MB Memory before query: 5.165 MB Rows returned: 3

SELECT * 
  FROM mov2g_mijoshop_length_class mc 
  LEFT JOIN mov2g_mijoshop_length_class_description mcd 
  ON (mc.length_class_id = mcd.length_class_id) 
  WHERE mcd.language_id = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mcd	ref	PRIMARY,language_idd	language_idd	4	const	2	Using where
1	SIMPLE	mc	eq_ref	PRIMARY	PRIMARY	4	j_evanschristmas.mcd.length_class_id	1

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1506
14	JDatabaseDriver->loadAssocList()	JROOT\components\com_mijoshop\opencart\system\library\db.php:25
13	DB->query()	JROOT\components\com_mijoshop\opencart\system\library\length.php:19
12	Length->__construct()	JROOT\components\com_mijoshop\mijoshop\opencart.php:309
11	MijoShopOpencart->__construct()	JROOT\components\com_mijoshop\mijoshop\mijoshop.php:25
10	MijoShop::get()	JROOT\components\com_mijoshop\mijoshop\mijoshop.php:42
9	MijoShop::getClass()	JROOT\components\com_mijoshop\opencart\index.php:12
8	require_once JROOT\components\com_mijoshop\opencart\index.php	JROOT\components\com_mijoshop\mijoshop\site.php:32
7	require_once JROOT\components\com_mijoshop\mijoshop\site.php	JROOT\components\com_mijoshop\mijoshop.php:18
6	require_once JROOT\components\com_mijoshop\mijoshop.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 1.15 ms After last query: 27.64 ms Query memory: 0.024 MB Memory before query: 5.004 MB Rows returned: 1

Duplicate queries: #64 #98

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price 
  FROM mov2g_mijoshop_product_discount pd2 
  WHERE pd2.product_id = p.product_id 
  AND pd2.customer_group_id = '1' 
  AND pd2.quantity = '1' 
  AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) 
  AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) 
  ORDER BY pd2.priority ASC, pd2.price ASC 
  LIMIT 1) AS discount, (SELECT price 
  FROM mov2g_mijoshop_product_special ps 
  WHERE ps.product_id = p.product_id 
  AND ps.customer_group_id = '1' 
  AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) 
  AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) 
  ORDER BY ps.priority ASC, ps.price ASC 
  LIMIT 1) AS special, (SELECT points 
  FROM mov2g_mijoshop_product_reward pr 
  WHERE pr.product_id = p.product_id 
  AND customer_group_id = '1') AS reward, (SELECT ss.name 
  FROM mov2g_mijoshop_stock_status ss 
  WHERE ss.stock_status_id = p.stock_status_id 
  AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit 
  FROM mov2g_mijoshop_weight_class_description wcd 
  WHERE p.weight_class_id = wcd.weight_class_id 
  AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit 
  FROM mov2g_mijoshop_length_class_description lcd 
  WHERE p.length_class_id = lcd.length_class_id 
  AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total 
  FROM mov2g_mijoshop_review r1 
  WHERE r1.product_id = p.product_id 
  AND r1.status = '1' 
  GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total 
  FROM mov2g_mijoshop_review r2 
  WHERE r2.product_id = p.product_id 
  AND r2.status = '1' 
  GROUP BY r2.product_id) AS reviews, p.sort_order 
  FROM mov2g_mijoshop_product p 
  LEFT JOIN mov2g_mijoshop_product_description pd 
  ON (p.product_id = pd.product_id) 
  LEFT JOIN mov2g_mijoshop_product_to_store p2s 
  ON (p.product_id = p2s.product_id) 
  LEFT JOIN mov2g_mijoshop_manufacturer m 
  ON (p.manufacturer_id = m.manufacturer_id) 
  WHERE p.product_id = '290' 
  AND pd.language_id = '1' 
  AND p.status = '1' 
  AND p.date_available <= NOW() 
  AND p2s.store_id = '0'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	p	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	pd	const	PRIMARY,language_idd	PRIMARY	8	const,const	1
1	PRIMARY	p2s	const	PRIMARY,store_idd	PRIMARY	8	const,const	1	Using index
1	PRIMARY	m	const	PRIMARY	PRIMARY	4	const	0	unique row not found
9	DEPENDENT SUBQUERY	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
8	DEPENDENT SUBQUERY	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
7	DEPENDENT SUBQUERY	lcd	const	PRIMARY,language_idd	PRIMARY	8	const,const	1
6	DEPENDENT SUBQUERY	wcd	const	PRIMARY,language_idd	PRIMARY	8	const,const	1
5	DEPENDENT SUBQUERY	ss	const	PRIMARY,language_idd	PRIMARY	8	const,const	1
4	DEPENDENT SUBQUERY	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
3	DEPENDENT SUBQUERY	ps	ref	product_id,customer_group_idd	product_id	4	const	1	Using where; Using filesort
2	DEPENDENT SUBQUERY	pd2	ref	product_id,customer_group_idd	product_id	4	const	1	Using where; Using filesort

Profile

Status	Duration
starting	0.21 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
System lock	0.02 ms
init	0.12 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.04 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.00 ms
Sorting result	0.03 ms
Sending data	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.00 ms
Sorting result	0.01 ms
Sending data	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.00 ms
optimizing	0.00 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
optimizing	0.00 ms
statistics	0.02 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.00 ms
optimizing	0.00 ms
statistics	0.02 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.00 ms
optimizing	0.00 ms
statistics	0.00 ms
preparing	0.00 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.11 ms
logging slow query	0.00 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1506
16	JDatabaseDriver->loadAssocList()	JROOT\components\com_mijoshop\opencart\system\library\db.php:25
15	DB->query()	JROOT\components\com_mijoshop\opencart\catalog\model\catalog\product.php:24
14	ModelCatalogProduct->getProduct()	JROOT\components\com_mijoshop\opencart\vqmod\vqcache\vq2-catalog_controller_product_product.php:186
13	ControllerProductProduct->index()	Same as call in the line below.
12	call_user_func_array()	JROOT\components\com_mijoshop\opencart\vqmod\vqcache\vq2-system_engine_front.php:58
11	Front->execute()	JROOT\components\com_mijoshop\opencart\vqmod\vqcache\vq2-system_engine_front.php:39
10	Front->dispatch()	JROOT\components\com_mijoshop\mijoshop\opencart.php:361
9	MijoShopOpencart->loadFront()	JROOT\components\com_mijoshop\opencart\index.php:12
8	require_once JROOT\components\com_mijoshop\opencart\index.php	JROOT\components\com_mijoshop\mijoshop\site.php:32
7	require_once JROOT\components\com_mijoshop\mijoshop\site.php	JROOT\components\com_mijoshop\mijoshop.php:18
6	require_once JROOT\components\com_mijoshop\mijoshop.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

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

SELECT category_id 
  FROM mov2g_mijoshop_product_to_category 
  WHERE product_id = 290 
  LIMIT 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1740
20	JDatabaseDriver->loadResult()	JROOT\components\com_mijoshop\mijoshop\db.php:243
19	MijoShopDb->run()	JROOT\components\com_mijoshop\mijoshop\db.php:93
18	MijoShopDb->getProductCategoryId()	JROOT\components\com_mijoshop\mijoshop\router.php:503
17	MijoShopRouter->getItemid()	JROOT\components\com_mijoshop\mijoshop\router.php:409
16	MijoShopRouter->route()	JROOT\components\com_mijoshop\mijoshop\router.php:339
15	MijoShopRouter->rewrite()	JROOT\components\com_mijoshop\opencart\system\library\url.php:40
14	Url->link()	JROOT\components\com_mijoshop\opencart\vqmod\vqcache\vq2-catalog_controller_product_product.php:241
13	ControllerProductProduct->index()	Same as call in the line below.
12	call_user_func_array()	JROOT\components\com_mijoshop\opencart\vqmod\vqcache\vq2-system_engine_front.php:58
11	Front->execute()	JROOT\components\com_mijoshop\opencart\vqmod\vqcache\vq2-system_engine_front.php:39
10	Front->dispatch()	JROOT\components\com_mijoshop\mijoshop\opencart.php:361
9	MijoShopOpencart->loadFront()	JROOT\components\com_mijoshop\opencart\index.php:12
8	require_once JROOT\components\com_mijoshop\opencart\index.php	JROOT\components\com_mijoshop\mijoshop\site.php:32
7	require_once JROOT\components\com_mijoshop\mijoshop\site.php	JROOT\components\com_mijoshop\mijoshop.php:18
6	require_once JROOT\components\com_mijoshop\mijoshop.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 1.07 ms After last query: 0.56 ms Query memory: 0.023 MB Memory before query: 5.041 MB Rows returned: 1

SELECT keyword 
  FROM mov2g_mijoshop_url_alias 
  WHERE query = 'product_id=290' 
  AND language_id = '1' 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mov2g_mijoshop_url_alias	ref	language_idd	language_idd	4	const	681	Using where

Profile

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

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1740
28	JDatabaseDriver->loadResult()	JROOT\components\com_mijoshop\mijoshop\db.php:243
27	MijoShopDb->run()	JROOT\components\com_mijoshop\mijoshop\db.php:66
26	MijoShopDb->getRecordAlias()	JROOT\components\com_mijoshop\mijoshop\router.php:104
25	MijoShopRouter->buildRoute()	JROOT\components\com_mijoshop\router.php:15
24	MijoshopBuildRoute()	JROOT\libraries\src\Component\Router\RouterLegacy.php:69
23	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT\libraries\src\Router\SiteRouter.php:528
22	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT\libraries\src\Router\SiteRouter.php:498
21	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT\libraries\src\Router\Router.php:281
20	Joomla\CMS\Router\Router->build()	JROOT\libraries\src\Router\SiteRouter.php:154
19	Joomla\CMS\Router\SiteRouter->build()	JROOT\libraries\src\Router\Route.php:144
18	Joomla\CMS\Router\Route::link()	JROOT\libraries\src\Router\Route.php:93
17	Joomla\CMS\Router\Route::_()	JROOT\components\com_mijoshop\mijoshop\router.php:462
16	MijoShopRouter->route()	JROOT\components\com_mijoshop\mijoshop\router.php:339
15	MijoShopRouter->rewrite()	JROOT\components\com_mijoshop\opencart\system\library\url.php:40
14	Url->link()	JROOT\components\com_mijoshop\opencart\vqmod\vqcache\vq2-catalog_controller_product_product.php:241
13	ControllerProductProduct->index()	Same as call in the line below.
12	call_user_func_array()	JROOT\components\com_mijoshop\opencart\vqmod\vqcache\vq2-system_engine_front.php:58
11	Front->execute()	JROOT\components\com_mijoshop\opencart\vqmod\vqcache\vq2-system_engine_front.php:39
10	Front->dispatch()	JROOT\components\com_mijoshop\mijoshop\opencart.php:361
9	MijoShopOpencart->loadFront()	JROOT\components\com_mijoshop\opencart\index.php:12
8	require_once JROOT\components\com_mijoshop\opencart\index.php	JROOT\components\com_mijoshop\mijoshop\site.php:32
7	require_once JROOT\components\com_mijoshop\mijoshop\site.php	JROOT\components\com_mijoshop\mijoshop.php:18
6	require_once JROOT\components\com_mijoshop\mijoshop.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 0.43 ms After last query: 13.98 ms Query memory: 0.015 MB Memory before query: 5.095 MB Rows returned: 0

SELECT * 
  FROM mov2g_mijoshop_product_image 
  WHERE product_id = '290' 
  ORDER BY sort_order ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mov2g_mijoshop_product_image	ref	product_idd	product_idd	4	const	1	Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1506
16	JDatabaseDriver->loadAssocList()	JROOT\components\com_mijoshop\opencart\system\library\db.php:25
15	DB->query()	JROOT\components\com_mijoshop\opencart\catalog\model\catalog\product.php:442
14	ModelCatalogProduct->getProductImages()	JROOT\components\com_mijoshop\opencart\vqmod\vqcache\vq2-catalog_controller_product_product.php:327
13	ControllerProductProduct->index()	Same as call in the line below.
12	call_user_func_array()	JROOT\components\com_mijoshop\opencart\vqmod\vqcache\vq2-system_engine_front.php:58
11	Front->execute()	JROOT\components\com_mijoshop\opencart\vqmod\vqcache\vq2-system_engine_front.php:39
10	Front->dispatch()	JROOT\components\com_mijoshop\mijoshop\opencart.php:361
9	MijoShopOpencart->loadFront()	JROOT\components\com_mijoshop\opencart\index.php:12
8	require_once JROOT\components\com_mijoshop\opencart\index.php	JROOT\components\com_mijoshop\mijoshop\site.php:32
7	require_once JROOT\components\com_mijoshop\mijoshop\site.php	JROOT\components\com_mijoshop\mijoshop.php:18
6	require_once JROOT\components\com_mijoshop\mijoshop.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 0.31 ms After last query: 0.39 ms Query memory: 0.016 MB Memory before query: 5.110 MB Rows returned: 0

SELECT * 
  FROM mov2g_mijoshop_product_discount 
  WHERE product_id = '290' 
  AND customer_group_id = '1' 
  AND quantity > 1 
  AND ((date_start = '0000-00-00' OR date_start < NOW()) 
  AND (date_end = '0000-00-00' OR date_end > NOW())) 
  ORDER BY quantity ASC, priority ASC, price ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mov2g_mijoshop_product_discount	ref	product_id,customer_group_idd	product_id	4	const	1	Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1506
16	JDatabaseDriver->loadAssocList()	JROOT\components\com_mijoshop\opencart\system\library\db.php:25
15	DB->query()	JROOT\components\com_mijoshop\opencart\catalog\model\catalog\product.php:436
14	ModelCatalogProduct->getProductDiscounts()	JROOT\components\com_mijoshop\opencart\vqmod\vqcache\vq2-catalog_controller_product_product.php:354
13	ControllerProductProduct->index()	Same as call in the line below.
12	call_user_func_array()	JROOT\components\com_mijoshop\opencart\vqmod\vqcache\vq2-system_engine_front.php:58
11	Front->execute()	JROOT\components\com_mijoshop\opencart\vqmod\vqcache\vq2-system_engine_front.php:39
10	Front->dispatch()	JROOT\components\com_mijoshop\mijoshop\opencart.php:361
9	MijoShopOpencart->loadFront()	JROOT\components\com_mijoshop\opencart\index.php:12
8	require_once JROOT\components\com_mijoshop\opencart\index.php	JROOT\components\com_mijoshop\mijoshop\site.php:32
7	require_once JROOT\components\com_mijoshop\mijoshop\site.php	JROOT\components\com_mijoshop\mijoshop.php:18
6	require_once JROOT\components\com_mijoshop\mijoshop.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 2.30 ms After last query: 0.16 ms Query memory: 0.016 MB Memory before query: 5.124 MB Rows returned: 0

SELECT * 
  FROM mov2g_mijoshop_product_option po 
  LEFT JOIN `mov2g_mijoshop_option` o 
  ON (po.option_id = o.option_id) 
  LEFT JOIN mov2g_mijoshop_option_description od 
  ON (o.option_id = od.option_id) 
  WHERE po.product_id = '290' 
  AND od.language_id = '1' 
  ORDER BY o.sort_order

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	po	ref	product_idd,option_idd	product_idd	4	const	1	Using temporary; Using filesort
1	SIMPLE	o	eq_ref	PRIMARY	PRIMARY	4	j_evanschristmas.po.option_id	1	Using where
1	SIMPLE	od	eq_ref	PRIMARY,language_idd	PRIMARY	8	j_evanschristmas.o.option_id,const	1	Using where

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
Creating tmp table	1.46 ms
executing	0.00 ms
Copying to tmp table	0.02 ms
Sorting result	0.02 ms
Sending data	0.01 ms
end	0.00 ms
removing tmp table	0.45 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.08 ms
logging slow query	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1506
16	JDatabaseDriver->loadAssocList()	JROOT\components\com_mijoshop\opencart\system\library\db.php:25
15	DB->query()	JROOT\components\com_mijoshop\opencart\catalog\model\catalog\product.php:383
14	ModelCatalogProduct->getProductOptions()	JROOT\components\com_mijoshop\opencart\vqmod\vqcache\vq2-catalog_controller_product_product.php:367
13	ControllerProductProduct->index()	Same as call in the line below.
12	call_user_func_array()	JROOT\components\com_mijoshop\opencart\vqmod\vqcache\vq2-system_engine_front.php:58
11	Front->execute()	JROOT\components\com_mijoshop\opencart\vqmod\vqcache\vq2-system_engine_front.php:39
10	Front->dispatch()	JROOT\components\com_mijoshop\mijoshop\opencart.php:361
9	MijoShopOpencart->loadFront()	JROOT\components\com_mijoshop\opencart\index.php:12
8	require_once JROOT\components\com_mijoshop\opencart\index.php	JROOT\components\com_mijoshop\mijoshop\site.php:32
7	require_once JROOT\components\com_mijoshop\mijoshop\site.php	JROOT\components\com_mijoshop\mijoshop.php:18
6	require_once JROOT\components\com_mijoshop\mijoshop.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 0.28 ms After last query: 0.24 ms Query memory: 0.015 MB Memory before query: 5.139 MB Rows returned: 0

SELECT ag.attribute_group_id, agd.name 
  FROM mov2g_mijoshop_product_attribute pa 
  LEFT JOIN mov2g_mijoshop_attribute a 
  ON (pa.attribute_id = a.attribute_id) 
  LEFT JOIN mov2g_mijoshop_attribute_group ag 
  ON (a.attribute_group_id = ag.attribute_group_id) 
  LEFT JOIN mov2g_mijoshop_attribute_group_description agd 
  ON (ag.attribute_group_id = agd.attribute_group_id) 
  WHERE pa.product_id = '290' 
  AND agd.language_id = '1' 
  GROUP BY ag.attribute_group_id 
  ORDER BY ag.sort_order, agd.name

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1506
16	JDatabaseDriver->loadAssocList()	JROOT\components\com_mijoshop\opencart\system\library\db.php:25
15	DB->query()	JROOT\components\com_mijoshop\opencart\catalog\model\catalog\product.php:355
14	ModelCatalogProduct->getProductAttributes()	JROOT\components\com_mijoshop\opencart\vqmod\vqcache\vq2-catalog_controller_product_product.php:420
13	ControllerProductProduct->index()	Same as call in the line below.
12	call_user_func_array()	JROOT\components\com_mijoshop\opencart\vqmod\vqcache\vq2-system_engine_front.php:58
11	Front->execute()	JROOT\components\com_mijoshop\opencart\vqmod\vqcache\vq2-system_engine_front.php:39
10	Front->dispatch()	JROOT\components\com_mijoshop\mijoshop\opencart.php:361
9	MijoShopOpencart->loadFront()	JROOT\components\com_mijoshop\opencart\index.php:12
8	require_once JROOT\components\com_mijoshop\opencart\index.php	JROOT\components\com_mijoshop\mijoshop\site.php:32
7	require_once JROOT\components\com_mijoshop\mijoshop\site.php	JROOT\components\com_mijoshop\mijoshop.php:18
6	require_once JROOT\components\com_mijoshop\mijoshop.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 0.37 ms After last query: 0.18 ms Query memory: 0.021 MB Memory before query: 5.153 MB Rows returned: 0

SELECT * 
  FROM mov2g_mijoshop_product_related pr 
  LEFT JOIN mov2g_mijoshop_product p 
  ON (pr.related_id = p.product_id) 
  LEFT JOIN mov2g_mijoshop_product_to_store p2s 
  ON (p.product_id = p2s.product_id) 
  WHERE pr.product_id = '290' 
  AND p.status = '1' 
  AND p.date_available <= NOW() 
  AND p2s.store_id = '0'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pr	ref	PRIMARY,related_idd	PRIMARY	4	const	1	Using index
1	SIMPLE	p	eq_ref	PRIMARY	PRIMARY	4	j_evanschristmas.pr.related_id	1	Using where
1	SIMPLE	p2s	eq_ref	PRIMARY,store_idd	PRIMARY	8	j_evanschristmas.pr.related_id,const	1	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1506
16	JDatabaseDriver->loadAssocList()	JROOT\components\com_mijoshop\opencart\system\library\db.php:25
15	DB->query()	JROOT\components\com_mijoshop\opencart\catalog\model\catalog\product.php:450
14	ModelCatalogProduct->getProductRelated()	JROOT\components\com_mijoshop\opencart\vqmod\vqcache\vq2-catalog_controller_product_product.php:424
13	ControllerProductProduct->index()	Same as call in the line below.
12	call_user_func_array()	JROOT\components\com_mijoshop\opencart\vqmod\vqcache\vq2-system_engine_front.php:58
11	Front->execute()	JROOT\components\com_mijoshop\opencart\vqmod\vqcache\vq2-system_engine_front.php:39
10	Front->dispatch()	JROOT\components\com_mijoshop\mijoshop\opencart.php:361
9	MijoShopOpencart->loadFront()	JROOT\components\com_mijoshop\opencart\index.php:12
8	require_once JROOT\components\com_mijoshop\opencart\index.php	JROOT\components\com_mijoshop\mijoshop\site.php:32
7	require_once JROOT\components\com_mijoshop\mijoshop\site.php	JROOT\components\com_mijoshop\mijoshop.php:18
6	require_once JROOT\components\com_mijoshop\mijoshop.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 0.33 ms After last query: 1.62 ms Query memory: 0.013 MB Memory before query: 5.172 MB

UPDATE mov2g_mijoshop_product 
  SET viewed = (viewed + 1) 
  WHERE product_id = '290'

Explain

EXPLAIN not possible on query: UPDATE mov2g_mijoshop_product SET viewed = (viewed + 1) WHERE product_id = '290'

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.02 ms
Updating	0.05 ms
end	0.00 ms
Waiting for query cache lock	0.00 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.08 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT\components\com_mijoshop\opencart\system\library\db.php:33
15	DB->query()	JROOT\components\com_mijoshop\opencart\catalog\model\catalog\product.php:14
14	ModelCatalogProduct->updateViewed()	JROOT\components\com_mijoshop\opencart\vqmod\vqcache\vq2-catalog_controller_product_product.php:476
13	ControllerProductProduct->index()	Same as call in the line below.
12	call_user_func_array()	JROOT\components\com_mijoshop\opencart\vqmod\vqcache\vq2-system_engine_front.php:58
11	Front->execute()	JROOT\components\com_mijoshop\opencart\vqmod\vqcache\vq2-system_engine_front.php:39
10	Front->dispatch()	JROOT\components\com_mijoshop\mijoshop\opencart.php:361
9	MijoShopOpencart->loadFront()	JROOT\components\com_mijoshop\opencart\index.php:12
8	require_once JROOT\components\com_mijoshop\opencart\index.php	JROOT\components\com_mijoshop\mijoshop\site.php:32
7	require_once JROOT\components\com_mijoshop\mijoshop\site.php	JROOT\components\com_mijoshop\mijoshop.php:18
6	require_once JROOT\components\com_mijoshop\mijoshop.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 0.35 ms After last query: 11.96 ms Query memory: 0.017 MB Memory before query: 5.195 MB Rows returned: 0

Duplicate queries: #45 #48 #51

SELECT * 
  FROM mov2g_mijoshop_product_to_layout 
  WHERE product_id = '290' 
  AND store_id = '0'

Explain

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

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.07 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1506
19	JDatabaseDriver->loadAssocList()	JROOT\components\com_mijoshop\opencart\system\library\db.php:25
18	DB->query()	JROOT\components\com_mijoshop\opencart\catalog\model\catalog\product.php:460
17	ModelCatalogProduct->getProductLayoutId()	JROOT\components\com_mijoshop\opencart\vqmod\vqcache\vq2-catalog_controller_common_column_left.php:34
16	ControllerCommonColumnLeft->index()	JROOT\components\com_mijoshop\opencart\vqmod\vqcache\vq2-system_engine_controller.php:53
15	Controller->getChild()	JROOT\components\com_mijoshop\opencart\vqmod\vqcache\vq2-system_engine_controller.php:64
14	Controller->render()	JROOT\components\com_mijoshop\opencart\vqmod\vqcache\vq2-catalog_controller_product_product.php:496
13	ControllerProductProduct->index()	Same as call in the line below.
12	call_user_func_array()	JROOT\components\com_mijoshop\opencart\vqmod\vqcache\vq2-system_engine_front.php:58
11	Front->execute()	JROOT\components\com_mijoshop\opencart\vqmod\vqcache\vq2-system_engine_front.php:39
10	Front->dispatch()	JROOT\components\com_mijoshop\mijoshop\opencart.php:361
9	MijoShopOpencart->loadFront()	JROOT\components\com_mijoshop\opencart\index.php:12
8	require_once JROOT\components\com_mijoshop\opencart\index.php	JROOT\components\com_mijoshop\mijoshop\site.php:32
7	require_once JROOT\components\com_mijoshop\mijoshop\site.php	JROOT\components\com_mijoshop\mijoshop.php:18
6	require_once JROOT\components\com_mijoshop\mijoshop.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 0.38 ms After last query: 0.24 ms Query memory: 0.017 MB Memory before query: 5.211 MB Rows returned: 1

Shopping Cart

Shop Evans Christmas Supply

Shopping Cart

Banner: 3' x 15' "Pumpkin Patch"

Write a review

Information

Customer Service

Extras

My Account

General Information

Customer Service

Evans Extras

Account Information

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

101 Queries Logged 132.85 ms

25 duplicate found!