Request an Account

If you wish to become a Don Mar customer and are a Picture Framing Retailer. Please click on the link below.

Request an Account Now

Don Mar Special

See What's on Sale this week at Don Mar.

Give us a call at 800.556.7428

Wood

Wood Search

Warning: Cannot use a scalar value as an array in /home/dmcep/public_html/components/com_virtuemart/helpers/cart.php on line 520

Back to: Wood

Notice: Undefined property: TableProducts::$customfields in /home/dmcep/public_html/components/com_virtuemart/views/productdetails/tmpl/default.php on line 256

Warning: count(): Parameter must be an array or an object that implements Countable in /home/dmcep/public_html/components/com_virtuemart/views/productdetails/tmpl/default.php on line 256

1 Beaded Black Renaissance

Item Number:

NC16344

Product Desc:

1 Beaded Black Renaissance

Finish:

Black

Rabbet:

1 3/16

Availability:

Active

Notice: Only variables should be assigned by reference in /home/dmcep/public_html/components/com_virtuemart/views/productdetails/tmpl/default.php on line 383

Length Chop Join

Footage Width			*
Length

Once your cart is submitted. Don Mar will contact you to confirm your order.

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1718349396,
                "last": 1718349396,
                "now": 1718349396
            },
            "client": {
                "forwarded": "18.117.142.230"
            }
        },
        "registry": {
            "com_users": {
                "edit": {
                    "profile": {
                        "id": 0
                    }
                }
            },
            "mod_vm_nb_ajaxsearch": {
                "lang": "en_gb"
            }
        },
        "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
        },
        "jsn_original_id": 0
    },
    "__vm": {
        "manage": 0,
        "vmlastvisitedcategoryid": 1,
        "vmlastvisitedproductids": [
            7773
        ]
    }
}

Profile Information

Time

Memory

Time: 76.19 ms / 76.19 ms Memory: 0.548 MB / 0.93 MB Application: afterLoad

Time: 254.42 ms / 330.62 ms Memory: 4.933 MB / 5.86 MB Application: afterInitialise

Time: 91.28 ms / 421.90 ms Memory: 1.129 MB / 6.99 MB Application: Before JAccess::preloadComponents (all components)

Time: 19.53 ms / 441.43 ms Memory: 0.072 MB / 7.06 MB Application: After JAccess::preloadComponents (all components)

Time: 0.05 ms / 441.48 ms Memory: 0.000 MB / 7.06 MB Application: Before JAccess::getAssetRules (id:16 name:com_menus)

Time: 0.55 ms / 442.03 ms Memory: 0.024 MB / 7.08 MB Application: After JAccess::getAssetRules (id:16 name:com_menus)

Time: 50.12 ms / 492.15 ms Memory: 0.978 MB / 8.06 MB Application: Before JAccess::getAssetRules (id:24 name:com_users)

Time: 0.03 ms / 492.18 ms Memory: 0.002 MB / 8.06 MB Application: After JAccess::getAssetRules (id:24 name:com_users)

Time: 0.46 ms / 492.64 ms Memory: 0.020 MB / 8.08 MB Application: afterRoute

Time: 0.30 ms / 492.94 ms Memory: 0.009 MB / 8.09 MB Application: beforeRenderComponent com_virtuemart

Time: 43.42 ms / 536.36 ms Memory: 1.180 MB / 9.27 MB Application: Before JAccess::getAssetRules (id:1 name:root.1)

Time: 0.06 ms / 536.41 ms Memory: 0.007 MB / 9.28 MB Application: After JAccess::getAssetRules (id:1 name:root.1)

Time: 0.03 ms / 536.44 ms Memory: 0.000 MB / 9.28 MB Application: Before JAccess::getAssetRules (id:98 name:com_virtuemart)

Time: 0.02 ms / 536.45 ms Memory: 0.002 MB / 9.28 MB Application: After JAccess::getAssetRules (id:98 name:com_virtuemart)

Time: 1356.15 ms / 1892.60 ms Memory: 8.118 MB / 17.40 MB Application: afterRenderComponent com_virtuemart

Time: 38.46 ms / 1931.06 ms Memory: 0.352 MB / 17.75 MB Application: afterDispatch

Time: 116.23 ms / 2047.29 ms Memory: 0.286 MB / 18.04 MB Application: beforeRenderModule mod_custom (Footer Bar)

Time: 1.15 ms / 2048.44 ms Memory: 0.042 MB / 18.08 MB Application: afterRenderModule mod_custom (Footer Bar)

Time: 0.09 ms / 2048.54 ms Memory: 0.000 MB / 18.08 MB Application: beforeRenderModule mod_vm_breadz (VM Breadz)

Time: 27.86 ms / 2076.40 ms Memory: 0.205 MB / 18.28 MB Application: afterRenderModule mod_vm_breadz (VM Breadz)

Time: 0.06 ms / 2076.46 ms Memory: 0.000 MB / 18.27 MB Application: beforeRenderModule mod_custom (Inner Page Header)

Time: 29.82 ms / 2106.28 ms Memory: 0.540 MB / 18.81 MB Application: afterRenderModule mod_custom (Inner Page Header)

Time: 0.09 ms / 2106.37 ms Memory: 0.000 MB / 18.81 MB Application: beforeRenderModule mod_banners (banner_468x60)

Time: 46.51 ms / 2152.88 ms Memory: 0.147 MB / 18.96 MB Application: afterRenderModule mod_banners (banner_468x60)

Time: 0.17 ms / 2153.05 ms Memory: 0.007 MB / 18.97 MB Application: beforeRenderModule mod_cherry_picker_cf (Cherry Picker CF)

Time: 1244.42 ms / 3397.47 ms Memory: 0.604 MB / 19.57 MB Application: afterRenderModule mod_cherry_picker_cf (Cherry Picker CF)

Time: 0.07 ms / 3397.54 ms Memory: 0.000 MB / 19.53 MB Application: beforeRenderModule mod_custom (Request an Account)

Time: 1.28 ms / 3398.82 ms Memory: 0.025 MB / 19.56 MB Application: afterRenderModule mod_custom (Request an Account)

Time: 0.04 ms / 3398.86 ms Memory: 0.000 MB / 19.56 MB Application: beforeRenderModule mod_custom (Don Mar Special)

Time: 0.54 ms / 3399.40 ms Memory: 0.003 MB / 19.56 MB Application: afterRenderModule mod_custom (Don Mar Special)

Time: 0.12 ms / 3399.53 ms Memory: 0.001 MB / 19.56 MB Application: beforeRenderModule mod_menu (Main Menu)

Time: 3.74 ms / 3403.27 ms Memory: 0.080 MB / 19.64 MB Application: afterRenderModule mod_menu (Main Menu)

Time: 0.04 ms / 3403.31 ms Memory: 0.000 MB / 19.64 MB Application: beforeRenderModule mod_custom (Top Bar)

Time: 0.22 ms / 3403.53 ms Memory: 0.006 MB / 19.64 MB Application: afterRenderModule mod_custom (Top Bar)

Time: 0.03 ms / 3403.56 ms Memory: 0.002 MB / 19.64 MB Application: beforeRenderModule mod_vm_nb_ajaxsearch (Netbase VM Ajax Search Pro Module)

Time: 0.62 ms / 3404.18 ms Memory: 0.014 MB / 19.66 MB Application: afterRenderModule mod_vm_nb_ajaxsearch (Netbase VM Ajax Search Pro Module)

Time: 74.88 ms / 3479.06 ms Memory: 1.321 MB / 20.98 MB Application: afterRender

Database queries total: 2826.44 ms

Memory Usage

Database Queries

78 Queries Logged 2826.44 ms

5 duplicate found!

3 duplicates: #46 #54 #55

2 duplicates: #49 #50

Query Time: 42.47 ms Query memory: 0.023 MB Memory before query: 2.557 MB Rows returned: 0

SELECT `data`

  FROM `jos_session`

  WHERE `session_id` = '77efc2fc2188276613c8c36a6b9a38a0'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
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:82
10	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:648
9	JSession->_start()	JROOT/libraries/joomla/session/session.php:608
8	JSession->start()	JROOT/libraries/joomla/session/session.php:486
7	JSession->get()	JROOT/libraries/joomla/session/session.php:443
6	JSession->isNew()	JROOT/libraries/cms/application/cms.php:826
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:412
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Query Time: 0.34 ms After last query: 1.59 ms Query memory: 0.019 MB Memory before query: 2.638 MB Rows returned: 0

SELECT `session_id`

  FROM `jos_session`

  WHERE `session_id` = '77efc2fc2188276613c8c36a6b9a38a0' 
  LIMIT 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_session	NULL	const	PRIMARY	PRIMARY	766	const	1	100.00	Using index

Profile

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

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:828
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:412
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Query Time: 21.10 ms After last query: 0.13 ms Query memory: 0.003 MB Memory before query: 2.642 MB

INSERT INTO `jos_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('77efc2fc2188276613c8c36a6b9a38a0', 1, '1718349396', 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('77efc2fc2188276613c8c36a6b9a38a0', 1, '1718349396', 0, '', 0)

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
update	0.13 ms
end	0.01 ms
query end	20.77 ms
closing tables	0.03 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:216
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:828
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:412
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Query Time: 10.83 ms After last query: 3.05 ms Query memory: 0.040 MB Memory before query: 2.813 MB Rows returned: 47

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

  FROM `jos_extensions`

  WHERE `type` = 'component'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_extensions	NULL	ref	extension	extension	82	const	47	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/component/helper.php:452
8	JComponentHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:460
6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:111
4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:593
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.45 ms After last query: 3.01 ms Query memory: 0.021 MB Memory before query: 3.006 MB Rows returned: 2

SELECT b.id

  FROM jos_usergroups AS a

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

  WHERE a.id = 9

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:978
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:1047
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.24 ms After last query: 0.80 ms Query memory: 0.021 MB Memory before query: 3.052 MB Rows returned: 5

SELECT id, rules

  FROM `jos_viewlevels`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:1064
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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: 0.16 ms Query memory: 0.030 MB Memory before query: 3.079 MB Rows returned: 108

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

  FROM jos_extensions

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

  ORDER BY ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_extensions	NULL	ref	extension	extension	82	const	146	0.60	Using index condition; Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:311
8	JPluginHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/plugin/helper.php:316
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 38.87 ms After last query: 106.16 ms Query memory: 0.032 MB Memory before query: 6.036 MB Rows returned: 16

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

  LEFT JOIN jos_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	53	3.33	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	dmcep_test_joomla37.m.component_id	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:88
16	JMenuSite->{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
15	JCacheControllerCallback->get()	JROOT/libraries/cms/menu/site.php:96
14	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
13	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
12	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:129
11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:443
10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:59
8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:198
7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:549
6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:402
5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1142
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 19.24 ms After last query: 50.26 ms Query memory: 0.028 MB Memory before query: 7.004 MB Rows returned: 47

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

  FROM `jos_assets`

  WHERE `name` IN ('com_admin','com_advancedmodules','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_creativecontactform','com_csvi','com_customfilters','com_fields','com_finder','com_installer','com_jce','com_joomlaupdate','com_jsn','com_k2','com_languages','com_login','com_magiczoomplus','com_mailto','com_media','com_menus','com_messages','com_migrateme','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_tcpdf','com_templates','com_users','com_virtuemart','com_virtuemart_allinone','com_virtuemart_magicscroll','com_virtuemart_magiczoomplus','com_weblinks','com_wrapper') OR `parent_id` = 0

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_assets	NULL	ALL	idx_asset_name,idx_parent_id	NO INDEX KEY COULD BE USED	NULL	NULL	172	55.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:427
17	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:211
16	JAccess::preload()	JROOT/libraries/joomla/access/access.php:529
15	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
14	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
13	JUser->authorise()	JROOT/plugins/system/advancedmodules/src/Document.php:28
12	RegularLabs\AdvancedModules\Document::loadFrontEditScript()	JROOT/plugins/system/advancedmodules/src/Helper.php:32
11	RegularLabs\AdvancedModules\Helper->onAfterRoute()	Same as call in the line below.
10	call_user_func_array()	JROOT/plugins/system/advancedmodules/src/Plugin.php:110
9	RegularLabs\AdvancedModules\Plugin->run()	JROOT/plugins/system/advancedmodules/src/Plugin.php:54
8	RegularLabs\AdvancedModules\Plugin->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1152
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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: 2.29 ms Query memory: 0.024 MB Memory before query: 7.559 MB Rows returned: 1

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

  FROM `jos_extensions`

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

Profile

Status	Duration
starting	0.08 ms
checking permissions	0.03 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 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.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
17	JDatabaseDriver->loadObject()	JROOT/libraries/cms/library/helper.php:166
16	JLibraryHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
15	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:174
14	JLibraryHelper::loadLibrary()	JROOT/libraries/cms/library/helper.php:42
13	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:89
12	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:270
11	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
10	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
9	JFactory::getDocument()	JROOT/plugins/system/k2/k2.php:40
8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1152
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 12.67 ms After last query: 0.16 ms Query memory: 0.006 MB Memory before query: 7.559 MB

UPDATE `jos_extensions`

  SET `params` = '{\"mediaversion\":\"7334ed89194f387dcf06b90a7e7d5a34\"}'

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	jos_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.06 ms
updating	0.07 ms
end	0.01 ms
query end	12.34 ms
closing tables	0.03 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:116
13	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:321
12	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:280
11	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
10	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
9	JFactory::getDocument()	JROOT/plugins/system/k2/k2.php:40
8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1152
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 21.13 ms After last query: 3.39 ms Query memory: 0.022 MB Memory before query: 7.806 MB Rows returned: 1

SELECT *

  FROM jos_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:148
12	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:327
11	JApplicationSite->getParams()	JROOT/components/com_k2/helpers/utilities.php:305
10	K2HelperUtilities::getParams()	JROOT/administrator/components/com_k2/helpers/html.php:56
9	K2HelperHTML::loadjQuery()	JROOT/plugins/system/k2/k2.php:45
8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1152
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 5.22 ms After last query: 3.48 ms Query memory: 0.024 MB Memory before query: 7.997 MB Rows returned: 2

SELECT id, home, template, s.params

  FROM jos_template_styles as s

  LEFT JOIN jos_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	4	25.00	Using where
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	dmcep_test_joomla37.s.template,const	1	4.40	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:485
17	JApplicationSite->getTemplate()	JROOT/libraries/cms/html/html.php:359
16	JHtml::includeRelativeFiles()	JROOT/libraries/cms/html/html.php:706
15	JHtml::script()	JROOT/libraries/cms/html/html.php:233
14	JHtml::call()	JROOT/libraries/cms/html/html.php:140
13	JHtml::_()	JROOT/libraries/cms/html/jquery.php:52
12	JHtmlJquery::framework()	JROOT/libraries/cms/html/html.php:233
11	JHtml::call()	JROOT/libraries/cms/html/html.php:140
10	JHtml::_()	JROOT/administrator/components/com_k2/helpers/html.php:79
9	K2HelperHTML::loadjQuery()	JROOT/plugins/system/k2/k2.php:45
8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1152
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 5.07 ms After last query: 40.42 ms Query memory: 0.021 MB Memory before query: 9.212 MB Rows returned: 1

SHOW TABLES LIKE "jos_virtuemart_configs"

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
10	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:700
9	VmTable::checkTableExists()	JROOT/administrator/components/com_virtuemart/models/config.php:562
8	VirtueMartModelConfig::checkConfigTableExists()	JROOT/administrator/components/com_virtuemart/helpers/config.php:946
7	VmConfig::loadConfig()	JROOT/components/com_virtuemart/virtuemart.php:24
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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.08 ms Query memory: 0.020 MB Memory before query: 9.223 MB Rows returned: 1

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

Explain

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

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 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.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
8	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/config.php:994
7	VmConfig::loadConfig()	JROOT/components/com_virtuemart/virtuemart.php:24
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 29.67 ms After last query: 46.20 ms Query memory: 0.024 MB Memory before query: 10.844 MB Rows returned: 1

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_virtuemart_shoppergroups	NULL	ref	virtuemart_vendor_id,shared,published	published	1	const	6	14.29	Using where

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 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.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
16	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:102
15	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:136
14	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:163
13	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:114
12	VirtueMartModelUser->getCurrentUser()	JROOT/administrator/components/com_virtuemart/models/product.php:1369
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1002
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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.026 MB Memory before query: 10.887 MB Rows returned: 1

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
19	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1024
18	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:998
17	VmModel->getData()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:52
16	VirtueMartModelShopperGroup->getShopperGroup()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:107
15	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:136
14	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:163
13	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:114
12	VirtueMartModelUser->getCurrentUser()	JROOT/administrator/components/com_virtuemart/models/product.php:1369
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1002
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.42 ms After last query: 1.27 ms Query memory: 0.023 MB Memory before query: 10.975 MB Rows returned: 1

SELECT `jos_virtuemart_products`.* ,`jos_virtuemart_products_en_gb`.*  
  FROM `jos_virtuemart_products` 
  INNER JOIN `jos_virtuemart_products_en_gb` using (`virtuemart_product_id`) 
  WHERE `jos_virtuemart_products`.`virtuemart_product_id` = "7773"

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_virtuemart_products	NULL	const	PRIMARY,virtuemart_product_id	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	jos_virtuemart_products_en_gb	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
13	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1024
12	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1397
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1002
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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.99 ms Query memory: 0.022 MB Memory before query: 11.049 MB Rows returned: 1

SELECT `virtuemart_media_id` 
  FROM `jos_virtuemart_product_medias` 
  WHERE `virtuemart_product_id` = "7773" 
  ORDER BY `ordering`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_virtuemart_product_medias	NULL	ref	virtuemart_product_id,ordering	ordering	4	const	1	100.00	Using index condition

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
13	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
12	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1402
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1002
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.16 ms After last query: 0.23 ms Query memory: 0.022 MB Memory before query: 11.081 MB Rows returned: 0

SELECT `virtuemart_shoppergroup_id` 
  FROM `jos_virtuemart_product_shoppergroups` 
  WHERE `virtuemart_product_id` = "7773"

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
13	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
12	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1405
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1002
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.45 ms After last query: 0.13 ms Query memory: 0.023 MB Memory before query: 11.095 MB Rows returned: 1

SELECT * 
  FROM `jos_virtuemart_product_prices` 
  WHERE `virtuemart_product_id` = "7773"  
  AND ( `virtuemart_shoppergroup_id` ="1" OR  `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")  
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2024-06-14 07:16:36" )
		        
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-06-14 07:16:36" ) ) 
  ORDER BY `product_price` DESC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_virtuemart_product_prices	NULL	ref	virtuemart_product_id,virtuemart_shoppergroup_id,product_price_publish_up,product_price_publish_down	virtuemart_product_id	4	const	1	99.94	Using index condition; Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
14	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1201
13	VirtueMartModelProduct->loadProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1220
12	VirtueMartModelProduct->getRawProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1420
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1002
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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.28 ms Query memory: 0.022 MB Memory before query: 11.193 MB Rows returned: 0

SELECT `virtuemart_manufacturer_id` 
  FROM `jos_virtuemart_product_manufacturers` 
  WHERE `virtuemart_product_id` = "7773"

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_virtuemart_product_manufacturers	NULL	ref	virtuemart_product_id	virtuemart_product_id	5	const	1	100.00	Using index

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 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.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
13	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
12	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1424
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1002
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.23 ms After last query: 0.05 ms Query memory: 0.023 MB Memory before query: 11.207 MB Rows returned: 1

SELECT * 
  FROM `jos_virtuemart_product_categories`  
  WHERE `virtuemart_product_id` = 7773

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 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.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
14	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1663
13	VirtueMartModelProduct::getProductCategoryIds()	JROOT/administrator/components/com_virtuemart/models/product.php:1640
12	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1440
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1002
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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.65 ms Query memory: 0.023 MB Memory before query: 11.289 MB Rows returned: 1

SELECT `jos_virtuemart_categories`.* ,`jos_virtuemart_categories_en_gb`.*  
  FROM `jos_virtuemart_categories` 
  INNER JOIN `jos_virtuemart_categories_en_gb` using (`virtuemart_category_id`) 
  WHERE `jos_virtuemart_categories`.`virtuemart_category_id` = "1"

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1024
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1644
12	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1440
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1002
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.79 ms After last query: 3.29 ms Query memory: 0.031 MB Memory before query: 11.477 MB Rows returned: 15

SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
		c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
		field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`
		
  FROM `jos_virtuemart_customs` AS c 
  LEFT JOIN `jos_virtuemart_product_customfields` AS field 
  ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` 
  WHERE field.`virtuemart_product_id` IN (7773) 
  AND c.`published` = "1"  
  ORDER BY field.`ordering` ASC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	field	NULL	ref	virtuemart_product_id,virtuemart_custom_id	virtuemart_product_id	4	const	13	100.00	Using index condition; Using where
1	SIMPLE	c	NULL	eq_ref	PRIMARY,published	PRIMARY	4	dmcep_test_joomla37.field.virtuemart_custom_id	1	96.55	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/models/customfields.php:146
12	VirtueMartModelCustomfields->getCustomEmbeddedProductCustomFields()	JROOT/administrator/components/com_virtuemart/models/product.php:2620
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1088
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 18.56 ms After last query: 5.32 ms Query memory: 0.025 MB Memory before query: 11.903 MB Rows returned: 1

SELECT *  
  FROM `jos_virtuemart_currencies` AS c
			
  LEFT JOIN `jos_virtuemart_vendors` AS v 
  ON  c.virtuemart_currency_id = v.vendor_currency
			
  WHERE v.virtuemart_vendor_id = "1"

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	v	NULL	system	PRIMARY,vendor_currency	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL
1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
17	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/vendor.php:264
16	VirtueMartModelVendor::getVendorCurrency()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:53
15	CurrencyDisplay->__construct()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:103
14	CurrencyDisplay::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:79
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2627
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1088
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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: 1.19 ms Query memory: 0.025 MB Memory before query: 11.999 MB Rows returned: 1

SELECT `jos_virtuemart_currencies`.*  
  FROM `jos_virtuemart_currencies`  
  WHERE `jos_virtuemart_currencies`.`virtuemart_currency_id` = "144"

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
17	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1024
16	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:998
15	VmModel->getData()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:119
14	CurrencyDisplay::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:79
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2627
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1088
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 22.56 ms After last query: 6.85 ms Query memory: 0.024 MB Memory before query: 12.463 MB Rows returned: 0

SELECT cartData

  FROM `jos_virtuemart_carts`

  WHERE virtuemart_user_id=0

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
16	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/helpers/cart.php:440
15	VirtueMartCart::getCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:255
14	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2627
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1088
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.82 ms After last query: 3.01 ms Query memory: 0.035 MB Memory before query: 12.717 MB Rows returned: 31

SHOW FULL COLUMNS  
  FROM `jos_virtuemart_userfields`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
24	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:661
23	VmTable->showFullColumns()	JROOT/administrator/components/com_virtuemart/tables/userfields.php:43
22	TableUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:218
21	VmTable::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:430
20	VmModel->_createTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:392
19	VmModel->getTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:598
18	VmModel->setMainTable()	JROOT/administrator/components/com_virtuemart/models/userfields.php:51
17	VirtueMartModelUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:550
16	VmModel::getModel()	JROOT/components/com_virtuemart/helpers/cart.php:1714
15	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:260
14	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2627
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1088
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.66 ms After last query: 0.19 ms Query memory: 0.037 MB Memory before query: 12.765 MB Rows returned: 23

SELECT * 
  FROM `jos_virtuemart_userfields` 
  WHERE 1 = 1 
  AND `account`=1 
  AND published = 1 
  AND FIND_IN_SET(name, 'address_type,name,username,password,password2,user_is_vendor,delimiter_userinfo') = 0  
  ORDER BY ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_virtuemart_userfields	NULL	ref	published,account	published	1	const	30	85.00	Using index condition; Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:495
18	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:602
17	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:493
16	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:1725
15	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:260
14	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2627
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1088
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.24 ms After last query: 0.30 ms Query memory: 0.025 MB Memory before query: 12.832 MB Rows returned: 2

SELECT `fieldtitle`, `fieldvalue` 
  FROM `jos_virtuemart_userfield_values` 
  WHERE `virtuemart_userfield_id` = 23 
  ORDER BY `ordering`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_virtuemart_userfield_values	NULL	ref	virtuemart_userfield_id	virtuemart_userfield_id	4	const	2	100.00	Using index condition; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
18	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:495
17	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:1020
16	VirtueMartModelUserfields->getUserFieldsFilled()	JROOT/components/com_virtuemart/helpers/cart.php:1727
15	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:260
14	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2627
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1088
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 11.94 ms After last query: 1.92 ms Query memory: 0.096 MB Memory before query: 12.972 MB Rows returned: 245

SELECT * 
  FROM `jos_virtuemart_countries`
 
  WHERE `published` = 1

 
  ORDER BY country_name ASC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_virtuemart_countries	NULL	ALL	published	NO INDEX KEY COULD BE USED	NULL	NULL	245	99.18	Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
20	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:846
19	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/country.php:113
18	VirtueMartModelCountry->getCountries()	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:146
17	shopFunctionsF::renderCountryList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:840
16	VirtueMartModelUserfields->getUserFieldsFilled()	JROOT/components/com_virtuemart/helpers/cart.php:1727
15	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:260
14	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2627
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1088
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.66 ms After last query: 2.95 ms Query memory: 0.034 MB Memory before query: 13.330 MB Rows returned: 14

SELECT * 
  FROM `jos_virtuemart_userfields` 
  WHERE 1 = 1 
  AND `shipment`=1 
  AND published = 1 
  AND FIND_IN_SET(name, 'address_type,name,username,password,password2,user_is_vendor,delimiter_userinfo') = 0  
  ORDER BY ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_virtuemart_userfields	NULL	ref	published,shipment	shipment	1	const	14	75.00	Using index condition; Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:495
18	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:602
17	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:499
16	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:1725
15	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:260
14	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2627
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1088
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 12.74 ms After last query: 2.78 ms Query memory: 0.023 MB Memory before query: 13.464 MB Rows returned: 0

SELECT c.* 
  FROM jos_virtuemart_calcs as c 
  LEFT JOIN jos_virtuemart_calc_shoppergroups as cs 
  ON cs.virtuemart_calc_id=c.virtuemart_calc_id 
  WHERE `calc_kind` IN ('Marge','Tax','VatTax','DBTax','DATax' )
                
  AND `published`="1"
                
  AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
				
  AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2024-06-14 07:16:36" )
				
  AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-06-14 07:16:36" )
 
  AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cs	NULL	system	virtuemart_calc_id	NO INDEX KEY COULD BE USED	NULL	NULL	0	0.00	const row not found
1	SIMPLE	c	NULL	ref	virtuemart_vendor_id,published,calc_kind,shared,publish_up,publish_down	published	1	const	1	75.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
15	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:184
14	calculationHelper->setVendorId()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:91
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2627
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1088
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 5.95 ms After last query: 6.91 ms Query memory: 0.023 MB Memory before query: 13.843 MB Rows returned: 1

SELECT `jos_virtuemart_medias`.*  
  FROM `jos_virtuemart_medias`  
  WHERE `jos_virtuemart_medias`.`virtuemart_media_id` = "15573"

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1024
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/media.php:98
12	VirtueMartModelMedia->createMediaByIds()	JROOT/administrator/components/com_virtuemart/models/media.php:415
11	VirtueMartModelMedia->attachImages()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1163
10	VmModel->addImages()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:137
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 28.40 ms After last query: 10.82 ms Query memory: 0.066 MB Memory before query: 14.497 MB Rows returned: 30

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

  FROM jos_modules AS m

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

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

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

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	published,newsfeeds	published	5	NULL	36	10.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	dmcep_test_joomla37.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	am	NULL	eq_ref	PRIMARY	PRIMARY	4	dmcep_test_joomla37.m.id	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
22	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:402
21	PlgSystemAdvancedModuleHelper->getModuleList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:123
20	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
19	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
18	JApplicationBase->triggerEvent()	JROOT/libraries/cms/module/helper.php:355
17	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:34
16	JModuleHelper::getModule()	JROOT/modules/mod_cherry_picker_cf/models/config.php:2
15	cherrypicker_cf\Config->init()	JROOT/plugins/vmcustom/cherrypicker/cherrypicker.php:43
14	plgVmCustomCherrypicker->__construct()	JROOT/libraries/cms/plugin/helper.php:255
13	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
12	JPluginHelper::importPlugin()	JROOT/administrator/components/com_virtuemart/models/product.php:695
11	VirtueMartModelProduct->sortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/product.php:1866
10	VirtueMartModelProduct->getNeighborProducts()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:158
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 12.09 ms After last query: 6.74 ms Query memory: 0.026 MB Memory before query: 14.922 MB Rows returned: 1

SELECT a.mirror_id

  FROM jos_advancedmodules AS a

  WHERE a.moduleid = 136

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
23	JDatabaseDriver->loadResult()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:452
22	PlgSystemAdvancedModuleHelper->getMirrorModuleIdById()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:253
21	PlgSystemAdvancedModuleHelper->setMirrorParams()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:164
20	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
19	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
18	JApplicationBase->triggerEvent()	JROOT/libraries/cms/module/helper.php:355
17	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:34
16	JModuleHelper::getModule()	JROOT/modules/mod_cherry_picker_cf/models/config.php:2
15	cherrypicker_cf\Config->init()	JROOT/plugins/vmcustom/cherrypicker/cherrypicker.php:43
14	plgVmCustomCherrypicker->__construct()	JROOT/libraries/cms/plugin/helper.php:255
13	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
12	JPluginHelper::importPlugin()	JROOT/administrator/components/com_virtuemart/models/product.php:695
11	VirtueMartModelProduct->sortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/product.php:1866
10	VirtueMartModelProduct->getNeighborProducts()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:158
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 12.19 ms After last query: 0.11 ms Query memory: 0.026 MB Memory before query: 14.945 MB Rows returned: 1

SELECT a.params

  FROM jos_advancedmodules AS a

  WHERE a.moduleid = 136

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
23	JDatabaseDriver->loadResult()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:499
22	PlgSystemAdvancedModuleHelper->getAdvancedParamsById()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:289
21	PlgSystemAdvancedModuleHelper->setMirrorParams()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:164
20	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
19	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
18	JApplicationBase->triggerEvent()	JROOT/libraries/cms/module/helper.php:355
17	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:34
16	JModuleHelper::getModule()	JROOT/modules/mod_cherry_picker_cf/models/config.php:2
15	cherrypicker_cf\Config->init()	JROOT/plugins/vmcustom/cherrypicker/cherrypicker.php:43
14	plgVmCustomCherrypicker->__construct()	JROOT/libraries/cms/plugin/helper.php:255
13	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
12	JPluginHelper::importPlugin()	JROOT/administrator/components/com_virtuemart/models/product.php:695
11	VirtueMartModelProduct->sortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/product.php:1866
10	VirtueMartModelProduct->getNeighborProducts()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:158
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 17.06 ms After last query: 4.19 ms Query memory: 0.027 MB Memory before query: 15.134 MB Rows returned: 21

SELECT cstm.`virtuemart_custom_id`, cstm.`custom_parent_id`, cstm.`custom_title`, cstm.`custom_desc`, cstm.`ordering`, parent_cstm.`custom_title` as parent_title 
  FROM `jos_virtuemart_customs` as cstm

  LEFT JOIN (SELECT `virtuemart_custom_id`, `custom_title`, `ordering` 
  FROM `jos_virtuemart_customs` 
  WHERE `field_type`='P' OR `field_type`='G') as parent_cstm 
  on cstm.`custom_parent_id`=parent_cstm.`virtuemart_custom_id`

  WHERE cstm.`field_type` IN('S', 'V') 
  AND cstm.`published`=1

  ORDER BY parent_cstm.`ordering`, parent_cstm.`virtuemart_custom_id`, cstm.`ordering`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cstm	NULL	ALL	field_type,published	NO INDEX KEY COULD BE USED	NULL	NULL	29	69.92	Using where; Using temporary; Using filesort
1	SIMPLE	jos_virtuemart_customs	NULL	eq_ref	PRIMARY,field_type	PRIMARY	4	dmcep_test_joomla37.cstm.custom_parent_id	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
18	JDatabaseDriver->loadAssocList()	JROOT/modules/mod_cherry_picker_cf/models/customfields.php:288
17	cherrypicker_cf\CustomFields->getList()	JROOT/modules/mod_cherry_picker_cf/models/customfields.php:308
16	cherrypicker_cf\CustomFields->listOfSelected()	JROOT/modules/mod_cherry_picker_cf/models/customfields.php:325
15	cherrypicker_cf\CustomFields->sqlJoins()	JROOT/plugins/vmcustom/cherrypicker/cherrypicker.php:85
14	plgVmCustomCherrypicker->plgVmBeforeProductSearch()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/administrator/components/com_virtuemart/models/product.php:697
11	VirtueMartModelProduct->sortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/product.php:1866
10	VirtueMartModelProduct->getNeighborProducts()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:158
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 382.69 ms After last query: 1.84 ms Query memory: 0.021 MB Memory before query: 15.831 MB Rows returned: 0

SELECT p.`virtuemart_product_id`, `l`.`product_name`,`p`.product_sku 
  FROM `jos_virtuemart_products` as p 
  LEFT JOIN `jos_virtuemart_products_en_gb` as l 
  ON l.`virtuemart_product_id` = p.`virtuemart_product_id` 
  LEFT JOIN `jos_virtuemart_product_shoppergroups` as ps 
  ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`  
  LEFT JOIN `jos_virtuemart_product_categories` as pc 
  ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id` JOIN (SELECT `virtuemart_product_id` 
  FROM `jos_virtuemart_product_customfields` 
  WHERE (`virtuemart_custom_id`=14 
  AND FIND_IN_SET('Black', REPLACE(`customfield_value`, ';', ','))) OR (`virtuemart_custom_id`=6 
  AND FIND_IN_SET('Active', REPLACE(`customfield_value`, ';', ','))) OR (`virtuemart_custom_id`=15 
  AND FIND_IN_SET('-1', REPLACE(`customfield_value`, ';', ','))) OR (`virtuemart_custom_id`=16 
  AND FIND_IN_SET('-1', REPLACE(`customfield_value`, ';', ','))) OR (`virtuemart_custom_id`=17 
  AND 1=1) OR (`virtuemart_custom_id`=18 
  AND 1=1) 
  GROUP BY `virtuemart_product_id` 
  HAVING COUNT(*) = 6) as filters 
  ON p.`virtuemart_product_id`=filters.`virtuemart_product_id` 
  WHERE ( `pc`.`virtuemart_category_id` = 1 
  AND  ( `ps`.`virtuemart_shoppergroup_id`= "1"  OR `ps`.`virtuemart_shoppergroup_id` IS NULL  )  
  AND  p.`published`="1" ) 
  AND p.`virtuemart_product_id`!="7773"  
  AND `p`.product_sku <= "NC16344"  
  ORDER BY `p`.product_sku DESC, p.`virtuemart_product_id` DESC 
  LIMIT 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	ps	NULL	system	virtuemart_product_id	NO INDEX KEY COULD BE USED	NULL	NULL	0	0.00	const row not found
1	PRIMARY	pc	NULL	index	virtuemart_product_id	virtuemart_product_id	8	NULL	5082	10.00	Using where; Using index; Using temporary; Using filesort
1	PRIMARY	p	NULL	eq_ref	PRIMARY,published,virtuemart_product_id,product_sku	PRIMARY	4	dmcep_test_joomla37.pc.virtuemart_product_id	1	51.88	Using where
1	PRIMARY	l	NULL	eq_ref	PRIMARY	PRIMARY	4	dmcep_test_joomla37.pc.virtuemart_product_id	1	100.00	NULL
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	dmcep_test_joomla37.pc.virtuemart_product_id	10	100.00	Using where; Using index
2	DERIVED	jos_virtuemart_product_customfields	NULL	ALL	virtuemart_product_id,virtuemart_custom_id	NO INDEX KEY COULD BE USED	NULL	NULL	102649	27.90	Using where; Using temporary; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
11	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1939
10	VirtueMartModelProduct->getNeighborProducts()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:158
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 553.15 ms After last query: 0.10 ms Query memory: 0.021 MB Memory before query: 15.844 MB Rows returned: 0

SELECT p.`virtuemart_product_id`, `l`.`product_name`,`p`.product_sku 
  FROM `jos_virtuemart_products` as p 
  LEFT JOIN `jos_virtuemart_products_en_gb` as l 
  ON l.`virtuemart_product_id` = p.`virtuemart_product_id` 
  LEFT JOIN `jos_virtuemart_product_shoppergroups` as ps 
  ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`  
  LEFT JOIN `jos_virtuemart_product_categories` as pc 
  ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id` JOIN (SELECT `virtuemart_product_id` 
  FROM `jos_virtuemart_product_customfields` 
  WHERE (`virtuemart_custom_id`=14 
  AND FIND_IN_SET('Black', REPLACE(`customfield_value`, ';', ','))) OR (`virtuemart_custom_id`=6 
  AND FIND_IN_SET('Active', REPLACE(`customfield_value`, ';', ','))) OR (`virtuemart_custom_id`=15 
  AND FIND_IN_SET('-1', REPLACE(`customfield_value`, ';', ','))) OR (`virtuemart_custom_id`=16 
  AND FIND_IN_SET('-1', REPLACE(`customfield_value`, ';', ','))) OR (`virtuemart_custom_id`=17 
  AND 1=1) OR (`virtuemart_custom_id`=18 
  AND 1=1) 
  GROUP BY `virtuemart_product_id` 
  HAVING COUNT(*) = 6) as filters 
  ON p.`virtuemart_product_id`=filters.`virtuemart_product_id` 
  WHERE ( `pc`.`virtuemart_category_id` = 1 
  AND  ( `ps`.`virtuemart_shoppergroup_id`= "1"  OR `ps`.`virtuemart_shoppergroup_id` IS NULL  )  
  AND  p.`published`="1" ) 
  AND p.`virtuemart_product_id`!="7773"  
  AND `p`.product_sku >= "NC16344"  
  ORDER BY `p`.product_sku ASC, p.`virtuemart_product_id` ASC 
  LIMIT 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	ps	NULL	system	virtuemart_product_id	NO INDEX KEY COULD BE USED	NULL	NULL	0	0.00	const row not found
1	PRIMARY	pc	NULL	index	virtuemart_product_id	virtuemart_product_id	8	NULL	5082	10.00	Using where; Using index; Using temporary; Using filesort
1	PRIMARY	p	NULL	eq_ref	PRIMARY,published,virtuemart_product_id,product_sku	PRIMARY	4	dmcep_test_joomla37.pc.virtuemart_product_id	1	48.10	Using where
1	PRIMARY	l	NULL	eq_ref	PRIMARY	PRIMARY	4	dmcep_test_joomla37.pc.virtuemart_product_id	1	100.00	NULL
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	dmcep_test_joomla37.pc.virtuemart_product_id	10	100.00	Using where; Using index
2	DERIVED	jos_virtuemart_product_customfields	NULL	ALL	virtuemart_product_id,virtuemart_custom_id	NO INDEX KEY COULD BE USED	NULL	NULL	102649	27.90	Using where; Using temporary; Using filesort

Profile

Status	Duration
starting	0.17 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
Opening tables	0.03 ms
init	0.10 ms
System lock	0.01 ms
optimizing	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.02 ms
Creating tmp table	0.02 ms
Sorting result	0.02 ms
statistics	0.20 ms
preparing	0.03 ms
Creating tmp table	0.02 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.06 ms
executing	0.01 ms
Sending data	499.76 ms
Creating sort index	47.37 ms
Creating sort index	0.04 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.01 ms
query end	0.01 ms
removing tmp table	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
11	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1939
10	VirtueMartModelProduct->getNeighborProducts()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:158
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 32.84 ms After last query: 2.04 ms Query memory: 0.022 MB Memory before query: 15.988 MB Rows returned: 1

SELECT `virtuemart_media_id` 
  FROM `jos_virtuemart_category_medias` 
  WHERE `virtuemart_category_id` = "1" 
  ORDER BY `ordering`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_virtuemart_category_medias	NULL	ref	virtuemart_category_id,ordering	ordering	4	const	1	100.00	Using index condition

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
12	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
11	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/category.php:74
10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:192
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.20 ms After last query: 0.10 ms Query memory: 0.021 MB Memory before query: 16.007 MB Rows returned: 0

SELECT `category_child_id`
			
  FROM `jos_virtuemart_category_categories`
			
  WHERE `category_parent_id` = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_virtuemart_category_categories	NULL	ref	category_parent_id	category_parent_id	4	const	1	100.00	Using index

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_virtuemart/models/category.php:700
11	VirtueMartModelCategory->hasChildren()	JROOT/administrator/components/com_virtuemart/models/category.php:94
10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:192
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 8.36 ms After last query: 0.06 ms Query memory: 0.022 MB Memory before query: 16.020 MB Rows returned: 1

SELECT count(jos_virtuemart_products.virtuemart_product_id) AS total
			
  FROM `jos_virtuemart_products`, `jos_virtuemart_product_categories`
			
  WHERE `jos_virtuemart_products`.`virtuemart_vendor_id` = "1"
			
  AND `jos_virtuemart_product_categories`.`virtuemart_category_id` = 1
			
  AND `jos_virtuemart_products`.`virtuemart_product_id` = `jos_virtuemart_product_categories`.`virtuemart_product_id`
			
  AND `jos_virtuemart_products`.`published` = "1"

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_virtuemart_product_categories	NULL	index	virtuemart_product_id	virtuemart_product_id	8	NULL	5082	10.00	Using where; Using index
1	SIMPLE	jos_virtuemart_products	NULL	eq_ref	PRIMARY,virtuemart_vendor_id,published,virtuemart_product_id	PRIMARY	4	dmcep_test_joomla37.jos_virtuemart_product_categories.virtuemart_product_id	1	99.92	Using where

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/models/category.php:430
11	VirtueMartModelCategory->countProducts()	JROOT/administrator/components/com_virtuemart/models/category.php:101
10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:192
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 11.12 ms After last query: 0.08 ms Query memory: 0.022 MB Memory before query: 16.034 MB Rows returned: 1

SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
				
  FROM  jos_virtuemart_category_categories AS `xref`
				
  WHERE `xref`.`category_child_id`= 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
13	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:805
12	VirtueMartModelCategory->getCategoryRecurse()	JROOT/administrator/components/com_virtuemart/models/category.php:729
11	VirtueMartModelCategory->getParentsList()	JROOT/administrator/components/com_virtuemart/models/category.php:104
10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:192
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.20 ms After last query: 0.11 ms Query memory: 0.022 MB Memory before query: 16.055 MB Rows returned: 1

Duplicate queries: #54 #55

SELECT `virtuemart_category_id`, `category_name`  
  FROM `jos_virtuemart_categories_en_gb` as l 
  WHERE `virtuemart_category_id`= 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
12	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:774
11	VirtueMartModelCategory->getParentsList()	JROOT/administrator/components/com_virtuemart/models/category.php:104
10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:192
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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.11 ms Query memory: 0.023 MB Memory before query: 16.070 MB Rows returned: 1

SELECT `jos_virtuemart_medias`.*  
  FROM `jos_virtuemart_medias`  
  WHERE `jos_virtuemart_medias`.`virtuemart_media_id` = "14801"

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	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.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1024
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/media.php:98
12	VirtueMartModelMedia->createMediaByIds()	JROOT/administrator/components/com_virtuemart/models/media.php:415
11	VirtueMartModelMedia->attachImages()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1163
10	VmModel->addImages()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:195
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 31.04 ms After last query: 41.47 ms Query memory: 0.023 MB Memory before query: 16.953 MB Rows returned: 1

SELECT i.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`,
			j.`params`, j.`custom_data`, j.`system_data`, j.`checked_out`, j.`checked_out_time`, j.`state`,  s.virtuemart_shoppergroup_id , l.* 
 
  FROM   `jos_virtuemart_shipmentmethods` as i  
  LEFT JOIN `jos_virtuemart_shipmentmethods_en_gb` as l 
  ON l.`virtuemart_shipmentmethod_id` = i.`virtuemart_shipmentmethod_id` 
 
  LEFT JOIN `jos_extensions` as j 
  ON j.`extension_id` =  i.`shipment_jplugin_id`  
 
  LEFT 
  OUTER JOIN `jos_virtuemart_shipmentmethod_shoppergroups` AS s 
  ON i.`virtuemart_shipmentmethod_id` = s.`virtuemart_shipmentmethod_id`  
  WHERE i.`published` = "1" 
  AND j.`element` = "weight_countries"
	    						
  AND  (i.`virtuemart_vendor_id` = "1" OR i.`virtuemart_vendor_id` = "0" OR i.`shared` = "1")
	    						
  AND  ( s.`virtuemart_shoppergroup_id`= "1" OR (s.`virtuemart_shoppergroup_id`) IS NULL ) 
  GROUP BY i.`virtuemart_shipmentmethod_id` 
  ORDER BY i.`ordering`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	i	NULL	system	shipment_jplugin_id	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL
1	SIMPLE	s	NULL	system	virtuemart_shipmentmethod_id	NO INDEX KEY COULD BE USED	NULL	NULL	0	0.00	const row not found
1	SIMPLE	l	NULL	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL
1	SIMPLE	j	NULL	const	PRIMARY,element_clientid,element_folder_clientid	PRIMARY	4	const	1	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:544
13	vmPSPlugin->getPluginMethods()	JROOT/plugins/vmshipment/weight_countries/weight_countries.php:424
12	plgVmShipmentWeight_countries->plgVmOnProductDisplayShipment()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:337
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 25.42 ms After last query: 50.49 ms Query memory: 0.024 MB Memory before query: 18.019 MB Rows returned: 74

Duplicate queries: #50

select distinct cf.customfield_value 
  from jos_virtuemart_product_customfields cf 
  inner join jos_virtuemart_customs cu 
  on cf.virtuemart_custom_id = cu.virtuemart_custom_id 
  inner join jos_virtuemart_product_categories pcx 
  on cf.virtuemart_product_id=pcx.virtuemart_product_id   
  inner join jos_virtuemart_categories  c 
  on pcx.virtuemart_category_id=c.virtuemart_category_id  
  where cu.virtuemart_custom_id=14 
  and cf.customfield_value is not null 
  and cf.customfield_value <>'' 
  and c.virtuemart_category_id='1'   
  order by 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cu	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index; Using temporary; Using filesort
1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index
1	SIMPLE	cf	NULL	ref	virtuemart_product_id,virtuemart_custom_id	virtuemart_custom_id	4	const	4745	81.00	Using index condition; Using where
1	SIMPLE	pcx	NULL	eq_ref	virtuemart_product_id	virtuemart_product_id	8	dmcep_test_joomla37.cf.virtuemart_product_id,const	1	100.00	Using where; Using index; Distinct

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
9	JDatabase->query()	JROOT/templates/beez3/wood_selector.php:51
8	require JROOT/templates/beez3/wood_selector.php	JROOT/templates/beez3/index.php:530
7	require JROOT/templates/beez3/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1099
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 84.45 ms After last query: 0.07 ms Query memory: 0.024 MB Memory before query: 18.031 MB Rows returned: 74

Duplicate queries: #49

select distinct cf.customfield_value 
  from jos_virtuemart_product_customfields cf 
  inner join jos_virtuemart_customs cu 
  on cf.virtuemart_custom_id = cu.virtuemart_custom_id 
  inner join jos_virtuemart_product_categories pcx 
  on cf.virtuemart_product_id=pcx.virtuemart_product_id   
  inner join jos_virtuemart_categories  c 
  on pcx.virtuemart_category_id=c.virtuemart_category_id  
  where cu.virtuemart_custom_id=14 
  and cf.customfield_value is not null 
  and cf.customfield_value <>'' 
  and c.virtuemart_category_id='1'   
  order by 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cu	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index; Using temporary; Using filesort
1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index
1	SIMPLE	cf	NULL	ref	virtuemart_product_id,virtuemart_custom_id	virtuemart_custom_id	4	const	4745	81.00	Using index condition; Using where
1	SIMPLE	pcx	NULL	eq_ref	virtuemart_product_id	virtuemart_product_id	8	dmcep_test_joomla37.cf.virtuemart_product_id,const	1	100.00	Using where; Using index; Distinct

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1791
9	JDatabaseDriver->loadRowList()	JROOT/templates/beez3/wood_selector.php:60
8	require JROOT/templates/beez3/wood_selector.php	JROOT/templates/beez3/index.php:530
7	require JROOT/templates/beez3/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1099
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.33 ms After last query: 5.09 ms Query memory: 0.022 MB Memory before query: 18.203 MB Rows returned: 1

SHOW TABLES LIKE '%_vm_product_type_parameter%'

Explain

EXPLAIN not possible on query: SHOW TABLES LIKE '%_vm_product_type_parameter%'

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
13	JDatabaseDriver->loadResult()	JROOT/modules/mod_vm_breadz/controller.php:549
12	chpBreadzController->retrieveProductTypeFields()	JROOT/modules/mod_vm_breadz/controller.php:32
11	chpBreadzController->__construct()	JROOT/modules/mod_vm_breadz/mod_vm_breadz.php:40
10	include JROOT/modules/mod_vm_breadz/mod_vm_breadz.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1113
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 22.17 ms After last query: 0.06 ms Query memory: 0.117 MB Memory before query: 18.217 MB Rows returned: 77

SELECT * 
  FROM `jos_vm_product_type_parameter`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
13	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_vm_breadz/controller.php:566
12	chpBreadzController->retrieveProductTypeFields()	JROOT/modules/mod_vm_breadz/controller.php:32
11	chpBreadzController->__construct()	JROOT/modules/mod_vm_breadz/mod_vm_breadz.php:40
10	include JROOT/modules/mod_vm_breadz/mod_vm_breadz.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1113
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.36 ms After last query: 0.35 ms Query memory: 0.022 MB Memory before query: 18.232 MB Rows returned: 0

SELECT * 
  FROM `jos_virtuemart_customs` 
  WHERE `custom_parent_id` IN (SELECT `virtuemart_custom_id` 
  FROM `jos_virtuemart_customs` 
  WHERE `custom_parent_id`=0 
  AND `field_type`='P')

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_virtuemart_customs	NULL	ref	PRIMARY,custom_parent_id,field_type	field_type	8	const	1	27.59	Using where
1	SIMPLE	jos_virtuemart_customs	NULL	ref	custom_parent_id	custom_parent_id	4	dmcep_test_joomla37.jos_virtuemart_customs.virtuemart_custom_id	5	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
13	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_vm_breadz/controller.php:605
12	chpBreadzController->retrieveCustomFields()	JROOT/modules/mod_vm_breadz/controller.php:33
11	chpBreadzController->__construct()	JROOT/modules/mod_vm_breadz/mod_vm_breadz.php:40
10	include JROOT/modules/mod_vm_breadz/mod_vm_breadz.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1113
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.19 ms After last query: 0.23 ms Query memory: 0.022 MB Memory before query: 18.259 MB Rows returned: 1

Duplicate queries: #46 #55

SELECT `virtuemart_category_id`, `category_name`  
  FROM `jos_virtuemart_categories_en_gb` as l 
  WHERE `virtuemart_category_id`= 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
13	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:774
12	VirtueMartModelCategory->getParentsList()	JROOT/modules/mod_vm_breadz/controller.php:68
11	chpBreadzController->getWoodSearch()	JROOT/modules/mod_vm_breadz/mod_vm_breadz.php:42
10	include JROOT/modules/mod_vm_breadz/mod_vm_breadz.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1113
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.20 ms After last query: 0.18 ms Query memory: 0.022 MB Memory before query: 18.282 MB Rows returned: 1

Duplicate queries: #46 #54

SELECT `virtuemart_category_id`, `category_name`  
  FROM `jos_virtuemart_categories_en_gb` as l 
  WHERE `virtuemart_category_id`= 1

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 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.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
13	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:774
12	VirtueMartModelCategory->getParentsList()	JROOT/modules/mod_vm_breadz/controller.php:155
11	chpBreadzController->getCategories()	JROOT/modules/mod_vm_breadz/mod_vm_breadz.php:45
10	include JROOT/modules/mod_vm_breadz/mod_vm_breadz.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1113
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.19 ms After last query: 0.14 ms Query memory: 0.022 MB Memory before query: 18.293 MB Rows returned: 1

SELECT `product_name` 
  FROM `jos_virtuemart_products_en_gb` 
  WHERE `virtuemart_product_id`=7773

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
13	JDatabaseDriver->loadResult()	JROOT/modules/mod_vm_breadz/controller.php:540
12	chpBreadzController->getProductName()	JROOT/modules/mod_vm_breadz/controller.php:525
11	chpBreadzController->getProductData()	JROOT/modules/mod_vm_breadz/mod_vm_breadz.php:54
10	include JROOT/modules/mod_vm_breadz/mod_vm_breadz.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1113
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 20.98 ms After last query: 8.80 ms Query memory: 0.026 MB Memory before query: 18.760 MB Rows returned: 0

SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state

  FROM jos_fields AS a

  LEFT JOIN `jos_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN jos_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN jos_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN jos_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN jos_fields_groups AS g 
  ON g.id = a.group_id

  WHERE a.context = 'mod_custom.content' 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering DESC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using index condition; Using where; Using filesort
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	dmcep_test_joomla37.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	dmcep_test_joomla37.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	dmcep_test_joomla37.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	dmcep_test_joomla37.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	dmcep_test_joomla37.a.group_id	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
20	JModelLegacy->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
19	FieldsModelFields->_getList()	JROOT/libraries/legacy/model/list.php:186
18	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
17	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
16	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
15	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
14	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
13	JHtmlContent::prepare()	JROOT/libraries/cms/html/html.php:233
12	JHtml::call()	JROOT/libraries/cms/html/html.php:140
11	JHtml::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1113
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 6.14 ms After last query: 2.51 ms Query memory: 0.022 MB Memory before query: 18.892 MB Rows returned: 0

SELECT *

  FROM jos_banners

  WHERE '2024-06-14 07:16:36' >= 'reset' 
  AND `reset` != '0000-00-00 00:00:00' 
  AND `reset`!= NULL 
  AND (`checked_out` = 0 OR `checked_out` = 0)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE

Profile

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.07 ms
System lock	0.01 ms
optimizing	0.02 ms
executing	0.08 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_banners/helpers/banners.php:79
11	BannersHelper::updateReset()	JROOT/modules/mod_banners/mod_banners.php:19
10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1113
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 11.10 ms After last query: 1.14 ms Query memory: 0.023 MB Memory before query: 18.953 MB Rows returned: 1

SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions

  FROM jos_banners as a

  LEFT JOIN jos_banner_clients AS cl 
  ON cl.id = a.cid

  WHERE a.state=1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-06-14 07:16:36') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-06-14 07:16:36') 
  AND (a.imptotal = 0 OR a.impmade <= a.imptotal) 
  AND a.cid = 1 
  AND cl.state = 1 
  AND a.catid IN (3)

  ORDER BY a.sticky DESC,a.ordering 
  LIMIT 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cl	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using filesort
1	SIMPLE	a	NULL	ref	idx_state,idx_banner_catid	idx_state	1	const	1	50.00	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
14	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:186
13	JModelList->getItems()	JROOT/components/com_banners/models/banners.php:205
12	BannersModelBanners->getItems()	JROOT/modules/mod_banners/helper.php:44
11	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1113
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 24.96 ms After last query: 0.19 ms Query memory: 0.006 MB Memory before query: 18.972 MB

UPDATE jos_banners

  SET impmade = (impmade + 1)

  WHERE id IN (9)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	jos_banners	NULL	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.04 ms
updating	0.07 ms
end	0.01 ms
query end	24.56 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/components/com_banners/models/banners.php:249
12	BannersModelBanners->impress()	JROOT/modules/mod_banners/helper.php:48
11	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1113
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.86 ms After last query: 4.97 ms Query memory: 0.026 MB Memory before query: 19.227 MB Rows returned: 20

SELECT c.`virtuemart_custom_id`, `custom_parent_id`, c.`custom_title`, c.`custom_desc` as ctitle, p.`custom_title` as ptitle, p.`custom_desc` as pdesc, c.`ordering` 
  FROM `jos_virtuemart_customs` as c 
  LEFT JOIN (SELECT `virtuemart_custom_id`, `custom_title`, `custom_desc`, `ordering` 
  FROM `jos_virtuemart_customs` 
  WHERE `custom_parent_id`=0 
  AND `field_type`='P' OR `field_type`='G') as p 
  on c.`custom_parent_id`=p.`virtuemart_custom_id` 
  WHERE `is_hidden`=0 
  AND c.`field_type` IN('S', 'V') 
  ORDER BY p.`ordering`, c.`ordering`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	ALL	field_type	NO INDEX KEY COULD BE USED	NULL	NULL	29	7.24	Using where; Using temporary; Using filesort
1	SIMPLE	jos_virtuemart_customs	NULL	eq_ref	PRIMARY,custom_parent_id,field_type	PRIMARY	4	dmcep_test_joomla37.c.custom_parent_id	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
15	JDatabaseDriver->loadAssocList()	JROOT/modules/mod_cherry_picker_cf/models/filterData.php:207
14	cherrypicker_cf\CPFilterData->getCustomFieldsRawData()	JROOT/modules/mod_cherry_picker_cf/models/filterData.php:223
13	cherrypicker_cf\CPFilterData->getSortedCustomFieldsData()	JROOT/modules/mod_cherry_picker_cf/models/filterData.php:72
12	cherrypicker_cf\CPFilterData->initFiltersData()	JROOT/modules/mod_cherry_picker_cf/controllers/CPModuleController.php:25
11	cherrypicker_cf\CPModuleController->run()	JROOT/modules/mod_cherry_picker_cf/mod_cherry_picker_cf.php:77
10	include JROOT/modules/mod_cherry_picker_cf/mod_cherry_picker_cf.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1113
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.14 ms After last query: 0.32 ms Query memory: 0.007 MB Memory before query: 19.279 MB

DROP TABLE IF EXISTS `jos_cp_filters`

Explain

EXPLAIN not possible on query: DROP TABLE IF EXISTS `jos_cp_filters`

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.05 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
15	JDatabase->query()	JROOT/modules/mod_cherry_picker_cf/models/filterData.php:772
14	cherrypicker_cf\CPFilterData->deleteFiltersTable()	JROOT/modules/mod_cherry_picker_cf/models/filterData.php:697
13	cherrypicker_cf\CPFilterData->buildFilterTable()	JROOT/modules/mod_cherry_picker_cf/models/filterData.php:82
12	cherrypicker_cf\CPFilterData->initFiltersData()	JROOT/modules/mod_cherry_picker_cf/controllers/CPModuleController.php:25
11	cherrypicker_cf\CPModuleController->run()	JROOT/modules/mod_cherry_picker_cf/mod_cherry_picker_cf.php:77
10	include JROOT/modules/mod_cherry_picker_cf/mod_cherry_picker_cf.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1113
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1188.54 ms After last query: 0.10 ms Query memory: 0.007 MB Memory before query: 19.318 MB

CREATE TEMPORARY TABLE `jos_cp_filters` (`virtuemart_product_id` int(11) NOT NULL, `item_number` varchar(255) DEFAULT NULL, `ornament` varchar(255) DEFAULT NULL, `rabbet` varchar(255) DEFAULT NULL, `sub-category` varchar(255) DEFAULT NULL, `unit` varchar(255) DEFAULT NULL, `sheet_price` varchar(255) DEFAULT NULL, `qb1_price` varchar(255) DEFAULT NULL, `qb2_price` varchar(255) DEFAULT NULL, `qb3_price` varchar(255) DEFAULT NULL, `chop_price` varchar(255) DEFAULT NULL, `join_price` varchar(255) DEFAULT NULL, `pack` varchar(255) DEFAULT NULL, `vendor_name` varchar(255) DEFAULT NULL, `size` varchar(255) DEFAULT NULL, `type` varchar(255) DEFAULT NULL, `core` varchar(255) DEFAULT NULL, `thickness` varchar(255) DEFAULT NULL, `category` varchar(255) DEFAULT NULL, `finish` varchar(255) DEFAULT NULL, `availability` varchar(255) DEFAULT NULL, PRIMARY KEY (`virtuemart_product_id`), KEY `idx_item_number` (`item_number`), KEY `idx_ornament` (`ornament`), KEY `idx_rabbet` (`rabbet`), KEY `idx_sub-category` (`sub-category`), KEY `idx_unit` (`unit`), KEY `idx_sheet_price` (`sheet_price`), KEY `idx_qb1_price` (`qb1_price`), KEY `idx_qb2_price` (`qb2_price`), KEY `idx_qb3_price` (`qb3_price`), KEY `idx_chop_price` (`chop_price`), KEY `idx_join_price` (`join_price`), KEY `idx_pack` (`pack`), KEY `idx_vendor_name` (`vendor_name`), KEY `idx_size` (`size`), KEY `idx_type` (`type`), KEY `idx_core` (`core`), KEY `idx_thickness` (`thickness`), KEY `idx_category` (`category`), KEY `idx_finish` (`finish`), KEY `idx_availability` (`availability`)) ENGINE=MyISAM  DEFAULT CHARSET=utf8 (SELECT  vpc.`virtuemart_product_id`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=4, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `item_number`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=15, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `ornament`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=16, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `rabbet`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=9, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `sub-category`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=10, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `unit`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=19, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `sheet_price`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=20, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `qb1_price`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=21, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `qb2_price`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=22, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `qb3_price`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=17, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `chop_price`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=18, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `join_price`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=30, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `pack`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=5, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `vendor_name`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=11, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `size`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=7, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `type`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=12, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `core`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=13, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `thickness`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=8, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `category`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=14, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `finish`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=6, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `availability` 
  FROM (`jos_virtuemart_product_customfields` as vpc) JOIN `jos_virtuemart_customs` as vc USING (`virtuemart_custom_id`) JOIN `jos_virtuemart_products` as p USING (`virtuemart_product_id`) JOIN `jos_virtuemart_product_categories` as vpcat USING(`virtuemart_product_id`) 
  WHERE p.`published`=1 
  AND vpcat.`virtuemart_category_id`=1 
  AND vc.`custom_parent_id` IN (27, 26, 31, 28, 24) 
  GROUP BY vpc.`virtuemart_product_id`)

Explain

EXPLAIN not possible on query: CREATE TEMPORARY TABLE `jos_cp_filters` (`virtuemart_product_id` int(11) NOT NULL, `item_number` varchar(255) DEFAULT NULL, `ornament` varchar(255) DEFAULT NULL, `rabbet` varchar(255) DEFAULT NULL, `sub-category` varchar(255) DEFAULT NULL, `unit` varchar(255) DEFAULT NULL, `sheet_price` varchar(255) DEFAULT NULL, `qb1_price` varchar(255) DEFAULT NULL, `qb2_price` varchar(255) DEFAULT NULL, `qb3_price` varchar(255) DEFAULT NULL, `chop_price` varchar(255) DEFAULT NULL, `join_price` varchar(255) DEFAULT NULL, `pack` varchar(255) DEFAULT NULL, `vendor_name` varchar(255) DEFAULT NULL, `size` varchar(255) DEFAULT NULL, `type` varchar(255) DEFAULT NULL, `core` varchar(255) DEFAULT NULL, `thickness` varchar(255) DEFAULT NULL, `category` varchar(255) DEFAULT NULL, `finish` varchar(255) DEFAULT NULL, `availability` varchar(255) DEFAULT NULL, PRIMARY KEY (`virtuemart_product_id`), KEY `idx_item_number` (`item_number`), KEY `idx_ornament` (`ornament`), KEY `idx_rabbet` (`rabbet`), KEY `idx_sub-category` (`sub-category`), KEY `idx_unit` (`unit`), KEY `idx_sheet_price` (`sheet_price`), KEY `idx_qb1_price` (`qb1_price`), KEY `idx_qb2_price` (`qb2_price`), KEY `idx_qb3_price` (`qb3_price`), KEY `idx_chop_price` (`chop_price`), KEY `idx_join_price` (`join_price`), KEY `idx_pack` (`pack`), KEY `idx_vendor_name` (`vendor_name`), KEY `idx_size` (`size`), KEY `idx_type` (`type`), KEY `idx_core` (`core`), KEY `idx_thickness` (`thickness`), KEY `idx_category` (`category`), KEY `idx_finish` (`finish`), KEY `idx_availability` (`availability`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 (SELECT vpc.`virtuemart_product_id`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=4, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `item_number`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=15, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `ornament`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=16, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `rabbet`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=9, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `sub-category`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=10, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `unit`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=19, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `sheet_price`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=20, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `qb1_price`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=21, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `qb2_price`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=22, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `qb3_price`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=17, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `chop_price`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=18, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `join_price`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=30, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `pack`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=5, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `vendor_name`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=11, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `size`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=7, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `type`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=12, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `core`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=13, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `thickness`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=8, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `category`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=14, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `finish`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=6, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `availability` FROM (`jos_virtuemart_product_customfields` as vpc) JOIN `jos_virtuemart_customs` as vc USING (`virtuemart_custom_id`) JOIN `jos_virtuemart_products` as p USING (`virtuemart_product_id`) JOIN `jos_virtuemart_product_categories` as vpcat USING(`virtuemart_product_id`) WHERE p.`published`=1 AND vpcat.`virtuemart_category_id`=1 AND vc.`custom_parent_id` IN (27, 26, 31, 28, 24) GROUP BY vpc.`virtuemart_product_id`)

Profile

Status	Duration
starting	0.32 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
Opening tables	0.02 ms
init	0.31 ms
creating table	0.83 ms
After create	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.12 ms
preparing	0.02 ms
Creating tmp table	0.97 ms
Sorting result	0.01 ms
executing	0.00 ms
System lock	0.01 ms
Sending data	826.41 ms
Creating sort index	270.46 ms
Creating index	0.02 ms
Repair by sorting	88.15 ms
Saving state	0.03 ms
Creating index	0.01 ms
Creating sort index	0.01 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.14 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
removing tmp table	0.03 ms
freeing items	0.01 ms
removing tmp table	0.02 ms
freeing items	0.01 ms
removing tmp table	0.02 ms
freeing items	0.01 ms
removing tmp table	0.02 ms
freeing items	0.01 ms
removing tmp table	0.02 ms
freeing items	0.01 ms
removing tmp table	0.02 ms
freeing items	0.01 ms
removing tmp table	0.02 ms
freeing items	0.01 ms
removing tmp table	0.02 ms
freeing items	0.01 ms
removing tmp table	0.02 ms
freeing items	0.01 ms
removing tmp table	0.02 ms
freeing items	0.01 ms
removing tmp table	0.02 ms
freeing items	0.01 ms
removing tmp table	0.02 ms
freeing items	0.01 ms
removing tmp table	0.02 ms
freeing items	0.01 ms
removing tmp table	0.02 ms
freeing items	0.01 ms
removing tmp table	0.02 ms
freeing items	0.01 ms
removing tmp table	0.02 ms
freeing items	0.01 ms
removing tmp table	0.02 ms
freeing items	0.03 ms
removing tmp table	0.02 ms
freeing items	0.01 ms
removing tmp table	0.02 ms
freeing items	0.01 ms
removing tmp table	0.02 ms
freeing items	0.18 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
14	JDatabase->query()	JROOT/modules/mod_cherry_picker_cf/models/filterData.php:711
13	cherrypicker_cf\CPFilterData->buildFilterTable()	JROOT/modules/mod_cherry_picker_cf/models/filterData.php:82
12	cherrypicker_cf\CPFilterData->initFiltersData()	JROOT/modules/mod_cherry_picker_cf/controllers/CPModuleController.php:25
11	cherrypicker_cf\CPModuleController->run()	JROOT/modules/mod_cherry_picker_cf/mod_cherry_picker_cf.php:77
10	include JROOT/modules/mod_cherry_picker_cf/mod_cherry_picker_cf.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1113
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.67 ms After last query: 0.12 ms Query memory: 0.023 MB Memory before query: 19.311 MB Rows returned: 0

SELECT `ornament` 
  FROM `jos_cp_filters` 
  WHERE `ornament` LIKE '%;%' 
  LIMIT 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_cp_filters	NULL	index	NULL	idx_ornament	768	NULL	1246	11.11	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
15	JDatabaseDriver->loadResult()	JROOT/modules/mod_cherry_picker_cf/models/filterData.php:310
14	cherrypicker_cf\CPFilterData->customFieldHasMultiAssignedFilters()	JROOT/modules/mod_cherry_picker_cf/models/filterData.php:294
13	cherrypicker_cf\CPFilterData->fetchCFMultiAssignedStatus()	JROOT/modules/mod_cherry_picker_cf/models/filterData.php:86
12	cherrypicker_cf\CPFilterData->initFiltersData()	JROOT/modules/mod_cherry_picker_cf/controllers/CPModuleController.php:25
11	cherrypicker_cf\CPModuleController->run()	JROOT/modules/mod_cherry_picker_cf/mod_cherry_picker_cf.php:77
10	include JROOT/modules/mod_cherry_picker_cf/mod_cherry_picker_cf.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1113
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.74 ms After last query: 0.05 ms Query memory: 0.028 MB Memory before query: 19.336 MB Rows returned: 0

SELECT `rabbet` 
  FROM `jos_cp_filters` 
  WHERE `rabbet` LIKE '%;%' 
  LIMIT 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_cp_filters	NULL	index	NULL	idx_rabbet	768	NULL	1246	11.11	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
15	JDatabaseDriver->loadResult()	JROOT/modules/mod_cherry_picker_cf/models/filterData.php:310
14	cherrypicker_cf\CPFilterData->customFieldHasMultiAssignedFilters()	JROOT/modules/mod_cherry_picker_cf/models/filterData.php:294
13	cherrypicker_cf\CPFilterData->fetchCFMultiAssignedStatus()	JROOT/modules/mod_cherry_picker_cf/models/filterData.php:86
12	cherrypicker_cf\CPFilterData->initFiltersData()	JROOT/modules/mod_cherry_picker_cf/controllers/CPModuleController.php:25
11	cherrypicker_cf\CPModuleController->run()	JROOT/modules/mod_cherry_picker_cf/mod_cherry_picker_cf.php:77
10	include JROOT/modules/mod_cherry_picker_cf/mod_cherry_picker_cf.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1113
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.77 ms After last query: 0.05 ms Query memory: 0.023 MB Memory before query: 19.358 MB Rows returned: 0

SELECT `finish` 
  FROM `jos_cp_filters` 
  WHERE `finish` LIKE '%;%' 
  LIMIT 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_cp_filters	NULL	index	NULL	idx_finish	768	NULL	1246	11.11	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
15	JDatabaseDriver->loadResult()	JROOT/modules/mod_cherry_picker_cf/models/filterData.php:310
14	cherrypicker_cf\CPFilterData->customFieldHasMultiAssignedFilters()	JROOT/modules/mod_cherry_picker_cf/models/filterData.php:294
13	cherrypicker_cf\CPFilterData->fetchCFMultiAssignedStatus()	JROOT/modules/mod_cherry_picker_cf/models/filterData.php:86
12	cherrypicker_cf\CPFilterData->initFiltersData()	JROOT/modules/mod_cherry_picker_cf/controllers/CPModuleController.php:25
11	cherrypicker_cf\CPModuleController->run()	JROOT/modules/mod_cherry_picker_cf/mod_cherry_picker_cf.php:77
10	include JROOT/modules/mod_cherry_picker_cf/mod_cherry_picker_cf.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1113
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.80 ms After last query: 0.05 ms Query memory: 0.023 MB Memory before query: 19.374 MB Rows returned: 0

SELECT `availability` 
  FROM `jos_cp_filters` 
  WHERE `availability` LIKE '%;%' 
  LIMIT 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_cp_filters	NULL	index	NULL	idx_availability	768	NULL	1246	11.11	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
15	JDatabaseDriver->loadResult()	JROOT/modules/mod_cherry_picker_cf/models/filterData.php:310
14	cherrypicker_cf\CPFilterData->customFieldHasMultiAssignedFilters()	JROOT/modules/mod_cherry_picker_cf/models/filterData.php:294
13	cherrypicker_cf\CPFilterData->fetchCFMultiAssignedStatus()	JROOT/modules/mod_cherry_picker_cf/models/filterData.php:86
12	cherrypicker_cf\CPFilterData->initFiltersData()	JROOT/modules/mod_cherry_picker_cf/controllers/CPModuleController.php:25
11	cherrypicker_cf\CPModuleController->run()	JROOT/modules/mod_cherry_picker_cf/mod_cherry_picker_cf.php:77
10	include JROOT/modules/mod_cherry_picker_cf/mod_cherry_picker_cf.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1113
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 16.85 ms After last query: 2.26 ms Query memory: 0.023 MB Memory before query: 19.509 MB Rows returned: 0

SELECT `vendor_name` as name, COUNT(DISTINCT `virtuemart_product_id`) as count 
  FROM `jos_cp_filters` 
  WHERE `vendor_name`<>'' 
  AND `ornament` IN ('-1') 
  AND `rabbet` IN ('-1') 
  AND `finish` IN ('Black') 
  AND `availability` IN ('Active') 
  GROUP BY `vendor_name`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_cp_filters	NULL	ref	idx_ornament,idx_rabbet,idx_vendor_name,idx_finish,idx_availability	idx_ornament	768	const	1	5.00	Using index condition; Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
15	JDatabaseDriver->loadAssocList()	JROOT/modules/mod_cherry_picker_cf/models/filterModel.php:240
14	cherrypicker_cf\CPFilterModel->getFiltersNameAndCountData()	JROOT/modules/mod_cherry_picker_cf/models/filterModel.php:115
13	cherrypicker_cf\CPFilterModel->getActiveFilterDataForCustomField()	JROOT/modules/mod_cherry_picker_cf/models/filterModel.php:82
12	cherrypicker_cf\CPFilterModel->getFiltersCollection()	JROOT/modules/mod_cherry_picker_cf/controllers/CPModuleController.php:48
11	cherrypicker_cf\CPModuleController->run()	JROOT/modules/mod_cherry_picker_cf/mod_cherry_picker_cf.php:77
10	include JROOT/modules/mod_cherry_picker_cf/mod_cherry_picker_cf.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1113
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 20.11 ms After last query: 0.13 ms Query memory: 0.023 MB Memory before query: 19.525 MB Rows returned: 0

SELECT `size` as name, COUNT(DISTINCT `virtuemart_product_id`) as count 
  FROM `jos_cp_filters` 
  WHERE `size`<>'' 
  AND `ornament` IN ('-1') 
  AND `rabbet` IN ('-1') 
  AND `finish` IN ('Black') 
  AND `availability` IN ('Active') 
  GROUP BY `size`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_cp_filters	NULL	ref	idx_ornament,idx_rabbet,idx_size,idx_finish,idx_availability	idx_ornament	768	const	1	5.00	Using index condition; Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
15	JDatabaseDriver->loadAssocList()	JROOT/modules/mod_cherry_picker_cf/models/filterModel.php:240
14	cherrypicker_cf\CPFilterModel->getFiltersNameAndCountData()	JROOT/modules/mod_cherry_picker_cf/models/filterModel.php:115
13	cherrypicker_cf\CPFilterModel->getActiveFilterDataForCustomField()	JROOT/modules/mod_cherry_picker_cf/models/filterModel.php:82
12	cherrypicker_cf\CPFilterModel->getFiltersCollection()	JROOT/modules/mod_cherry_picker_cf/controllers/CPModuleController.php:48
11	cherrypicker_cf\CPModuleController->run()	JROOT/modules/mod_cherry_picker_cf/mod_cherry_picker_cf.php:77
10	include JROOT/modules/mod_cherry_picker_cf/mod_cherry_picker_cf.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1113
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.67 ms After last query: 0.14 ms Query memory: 0.023 MB Memory before query: 19.541 MB Rows returned: 0

SELECT `type` as name, COUNT(DISTINCT `virtuemart_product_id`) as count 
  FROM `jos_cp_filters` 
  WHERE `type`<>'' 
  AND `ornament` IN ('-1') 
  AND `rabbet` IN ('-1') 
  AND `finish` IN ('Black') 
  AND `availability` IN ('Active') 
  GROUP BY `type`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_cp_filters	NULL	ref	idx_ornament,idx_rabbet,idx_type,idx_finish,idx_availability	idx_ornament	768	const	1	5.00	Using index condition; Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
15	JDatabaseDriver->loadAssocList()	JROOT/modules/mod_cherry_picker_cf/models/filterModel.php:240
14	cherrypicker_cf\CPFilterModel->getFiltersNameAndCountData()	JROOT/modules/mod_cherry_picker_cf/models/filterModel.php:115
13	cherrypicker_cf\CPFilterModel->getActiveFilterDataForCustomField()	JROOT/modules/mod_cherry_picker_cf/models/filterModel.php:82
12	cherrypicker_cf\CPFilterModel->getFiltersCollection()	JROOT/modules/mod_cherry_picker_cf/controllers/CPModuleController.php:48
11	cherrypicker_cf\CPModuleController->run()	JROOT/modules/mod_cherry_picker_cf/mod_cherry_picker_cf.php:77
10	include JROOT/modules/mod_cherry_picker_cf/mod_cherry_picker_cf.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1113
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.33 ms After last query: 0.09 ms Query memory: 0.023 MB Memory before query: 19.557 MB Rows returned: 0

SELECT `core` as name, COUNT(DISTINCT `virtuemart_product_id`) as count 
  FROM `jos_cp_filters` 
  WHERE `core`<>'' 
  AND `ornament` IN ('-1') 
  AND `rabbet` IN ('-1') 
  AND `finish` IN ('Black') 
  AND `availability` IN ('Active') 
  GROUP BY `core`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_cp_filters	NULL	ref	idx_ornament,idx_rabbet,idx_core,idx_finish,idx_availability	idx_ornament	768	const	1	5.00	Using index condition; Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
15	JDatabaseDriver->loadAssocList()	JROOT/modules/mod_cherry_picker_cf/models/filterModel.php:240
14	cherrypicker_cf\CPFilterModel->getFiltersNameAndCountData()	JROOT/modules/mod_cherry_picker_cf/models/filterModel.php:115
13	cherrypicker_cf\CPFilterModel->getActiveFilterDataForCustomField()	JROOT/modules/mod_cherry_picker_cf/models/filterModel.php:82
12	cherrypicker_cf\CPFilterModel->getFiltersCollection()	JROOT/modules/mod_cherry_picker_cf/controllers/CPModuleController.php:48
11	cherrypicker_cf\CPModuleController->run()	JROOT/modules/mod_cherry_picker_cf/mod_cherry_picker_cf.php:77
10	include JROOT/modules/mod_cherry_picker_cf/mod_cherry_picker_cf.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1113
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.27 ms After last query: 0.10 ms Query memory: 0.023 MB Memory before query: 19.573 MB Rows returned: 0

SELECT `thickness` as name, COUNT(DISTINCT `virtuemart_product_id`) as count 
  FROM `jos_cp_filters` 
  WHERE `thickness`<>'' 
  AND `ornament` IN ('-1') 
  AND `rabbet` IN ('-1') 
  AND `finish` IN ('Black') 
  AND `availability` IN ('Active') 
  GROUP BY `thickness`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_cp_filters	NULL	ref	idx_ornament,idx_rabbet,idx_thickness,idx_finish,idx_availability	idx_ornament	768	const	1	5.00	Using index condition; Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
15	JDatabaseDriver->loadAssocList()	JROOT/modules/mod_cherry_picker_cf/models/filterModel.php:240
14	cherrypicker_cf\CPFilterModel->getFiltersNameAndCountData()	JROOT/modules/mod_cherry_picker_cf/models/filterModel.php:115
13	cherrypicker_cf\CPFilterModel->getActiveFilterDataForCustomField()	JROOT/modules/mod_cherry_picker_cf/models/filterModel.php:82
12	cherrypicker_cf\CPFilterModel->getFiltersCollection()	JROOT/modules/mod_cherry_picker_cf/controllers/CPModuleController.php:48
11	cherrypicker_cf\CPModuleController->run()	JROOT/modules/mod_cherry_picker_cf/mod_cherry_picker_cf.php:77
10	include JROOT/modules/mod_cherry_picker_cf/mod_cherry_picker_cf.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1113
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.25 ms After last query: 0.08 ms Query memory: 0.023 MB Memory before query: 19.589 MB Rows returned: 0

SELECT `category` as name, COUNT(DISTINCT `virtuemart_product_id`) as count 
  FROM `jos_cp_filters` 
  WHERE `category`<>'' 
  AND `ornament` IN ('-1') 
  AND `rabbet` IN ('-1') 
  AND `finish` IN ('Black') 
  AND `availability` IN ('Active') 
  GROUP BY `category`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_cp_filters	NULL	ref	idx_ornament,idx_rabbet,idx_category,idx_finish,idx_availability	idx_ornament	768	const	1	5.00	Using index condition; Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
15	JDatabaseDriver->loadAssocList()	JROOT/modules/mod_cherry_picker_cf/models/filterModel.php:240
14	cherrypicker_cf\CPFilterModel->getFiltersNameAndCountData()	JROOT/modules/mod_cherry_picker_cf/models/filterModel.php:115
13	cherrypicker_cf\CPFilterModel->getActiveFilterDataForCustomField()	JROOT/modules/mod_cherry_picker_cf/models/filterModel.php:82
12	cherrypicker_cf\CPFilterModel->getFiltersCollection()	JROOT/modules/mod_cherry_picker_cf/controllers/CPModuleController.php:48
11	cherrypicker_cf\CPModuleController->run()	JROOT/modules/mod_cherry_picker_cf/mod_cherry_picker_cf.php:77
10	include JROOT/modules/mod_cherry_picker_cf/mod_cherry_picker_cf.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1113
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.97 ms After last query: 0.08 ms Query memory: 0.023 MB Memory before query: 19.605 MB Rows returned: 0

SELECT `finish` as name, COUNT(DISTINCT `virtuemart_product_id`) as count 
  FROM `jos_cp_filters` 
  WHERE `finish`<>'' 
  AND `ornament` IN ('-1') 
  AND `rabbet` IN ('-1') 
  AND `availability` IN ('Active') 
  GROUP BY `finish`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_cp_filters	NULL	ref	idx_ornament,idx_rabbet,idx_finish,idx_availability	idx_ornament	768	const	1	5.00	Using index condition; Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
15	JDatabaseDriver->loadAssocList()	JROOT/modules/mod_cherry_picker_cf/models/filterModel.php:240
14	cherrypicker_cf\CPFilterModel->getFiltersNameAndCountData()	JROOT/modules/mod_cherry_picker_cf/models/filterModel.php:115
13	cherrypicker_cf\CPFilterModel->getActiveFilterDataForCustomField()	JROOT/modules/mod_cherry_picker_cf/models/filterModel.php:82
12	cherrypicker_cf\CPFilterModel->getFiltersCollection()	JROOT/modules/mod_cherry_picker_cf/controllers/CPModuleController.php:48
11	cherrypicker_cf\CPModuleController->run()	JROOT/modules/mod_cherry_picker_cf/mod_cherry_picker_cf.php:77
10	include JROOT/modules/mod_cherry_picker_cf/mod_cherry_picker_cf.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1113
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.84 ms After last query: 0.08 ms Query memory: 0.023 MB Memory before query: 19.621 MB Rows returned: 0

SELECT `availability` as name, COUNT(DISTINCT `virtuemart_product_id`) as count 
  FROM `jos_cp_filters` 
  WHERE `availability`<>'' 
  AND `ornament` IN ('-1') 
  AND `rabbet` IN ('-1') 
  AND `finish` IN ('Black') 
  GROUP BY `availability`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_cp_filters	NULL	ref	idx_ornament,idx_rabbet,idx_finish,idx_availability	idx_ornament	768	const	1	5.00	Using index condition; Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
15	JDatabaseDriver->loadAssocList()	JROOT/modules/mod_cherry_picker_cf/models/filterModel.php:240
14	cherrypicker_cf\CPFilterModel->getFiltersNameAndCountData()	JROOT/modules/mod_cherry_picker_cf/models/filterModel.php:115
13	cherrypicker_cf\CPFilterModel->getActiveFilterDataForCustomField()	JROOT/modules/mod_cherry_picker_cf/models/filterModel.php:82
12	cherrypicker_cf\CPFilterModel->getFiltersCollection()	JROOT/modules/mod_cherry_picker_cf/controllers/CPModuleController.php:48
11	cherrypicker_cf\CPModuleController->run()	JROOT/modules/mod_cherry_picker_cf/mod_cherry_picker_cf.php:77
10	include JROOT/modules/mod_cherry_picker_cf/mod_cherry_picker_cf.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1113
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 15.04 ms After last query: 18.42 ms Query memory: 0.035 MB Memory before query: 20.325 MB Rows returned: 182

SELECT `profile`, `name`, `value` 
  FROM `jos_virtuemart_magiczoomplus_config`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
9	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/vmmagiczoomplus/vmmagiczoomplus.php:374
8	PlgSystemVMMagicZoomPlus->getToolObj()	JROOT/plugins/system/vmmagiczoomplus/vmmagiczoomplus.php:81
7	PlgSystemVMMagicZoomPlus->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1119
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.45 ms After last query: 43.97 ms Query memory: 0.024 MB Memory before query: 20.760 MB Rows returned: 62

SELECT `profile`, `name`, `value` 
  FROM `jos_virtuemart_magicscroll_config`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
9	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/vmmagicscroll/vmmagicscroll.php:256
8	PlgSystemVMMagicScroll->getToolObj()	JROOT/plugins/system/vmmagicscroll/vmmagicscroll.php:81
7	PlgSystemVMMagicScroll->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1119
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->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: 1.12 ms Query memory: 0.023 MB Memory before query: 20.934 MB Rows returned: 35

SELECT `profile`, `name`, `value` 
  FROM `jos_magiczoomplus_config` 
  WHERE `disabled`='0'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_magiczoomplus_config	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	35	10.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
9	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/magiczoomplus/magiczoomplus.php:131
8	PlgSystemMagicZoomPlus->getToolMagicZoomPlusForJoomla()	JROOT/plugins/system/magiczoomplus/magiczoomplus.php:68
7	PlgSystemMagicZoomPlus->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1119
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

71 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

3 × SELECT `virtuemart_category_id`, `category_name`  
  FROM `jos_virtuemart_categories_en_gb` as l

2 × SELECT p.`virtuemart_product_id`, `l`.`product_name`,`p`.product_sku 
  FROM `jos_virtuemart_products` as p 
  LEFT JOIN `jos_virtuemart_products_en_gb` as l 
  ON l.`virtuemart_product_id` = p.`virtuemart_product_id` 
  LEFT JOIN `jos_virtuemart_product_shoppergroups` as ps 
  ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`  
  LEFT JOIN `jos_virtuemart_product_categories` as pc 
  ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id` JOIN (SELECT `virtuemart_product_id` 
  FROM `jos_virtuemart_product_customfields`

2 × SELECT * 
  FROM `jos_virtuemart_userfields`

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `jos_extensions`

2 × SELECT `jos_virtuemart_medias`.*  
  FROM `jos_virtuemart_medias`

2 × select distinct cf.customfield_value 
  from jos_virtuemart_product_customfields cf 
  inner join jos_virtuemart_customs cu 
  on cf.virtuemart_custom_id = cu.virtuemart_custom_id 
  inner join jos_virtuemart_product_categories pcx 
  on cf.virtuemart_product_id=pcx.virtuemart_product_id   
  inner join jos_virtuemart_categories  c 
  on pcx.virtuemart_category_id=c.virtuemart_category_id

```
1 × SELECT * 
  FROM jos_banners
```

1 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state 
  FROM jos_fields AS a 
  LEFT JOIN `jos_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN jos_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN jos_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN jos_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN jos_fields_groups AS g 
  ON g.id = a.group_id

1 × SELECT `product_name` 
  FROM `jos_virtuemart_products_en_gb`

1 × SELECT * 
  FROM `jos_virtuemart_customs`

1 × SELECT `data` 
  FROM `jos_session`

1 × SELECT * 
  FROM `jos_vm_product_type_parameter

1 × SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions 
  FROM jos_banners as a 
  LEFT JOIN jos_banner_clients AS cl 
  ON cl.id = a.cid

1 × SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`     
  FROM  jos_virtuemart_category_categories AS `xref`

1 × SELECT count(jos_virtuemart_products.virtuemart_product_id) AS total    
  FROM `jos_virtuemart_products`, `jos_virtuemart_product_categories`

1 × SELECT `category_child_id`    
  FROM `jos_virtuemart_category_categories`

1 × SELECT i.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`,    j.`params`, j.`custom_data`, j.`system_data`, j.`checked_out`, j.`checked_out_time`, j.`state`,  s.virtuemart_shoppergroup_id , l.*   
  FROM   `jos_virtuemart_shipmentmethods` as i  
  LEFT JOIN `jos_virtuemart_shipmentmethods_en_gb` as l 
  ON l.`virtuemart_shipmentmethod_id` = i.`virtuemart_shipmentmethod_id`   
  LEFT JOIN `jos_extensions` as j 
  ON j.`extension_id` =  i.`shipment_jplugin_id`    
  LEFT 
  OUTER JOIN `jos_virtuemart_shipmentmethod_shoppergroups` AS s 
  ON i.`virtuemart_shipmentmethod_id` = s.`virtuemart_shipmentmethod_id`

1 × SELECT `ornament` 
  FROM `jos_cp_filters`

1 × SELECT c.`virtuemart_custom_id`, `custom_parent_id`, c.`custom_title`, c.`custom_desc` as ctitle, p.`custom_title` as ptitle, p.`custom_desc` as pdesc, c.`ordering` 
  FROM `jos_virtuemart_customs` as c 
  LEFT JOIN (SELECT `virtuemart_custom_id`, `custom_title`, `custom_desc`, `ordering` 
  FROM `jos_virtuemart_customs`

1 × SELECT `rabbet` 
  FROM `jos_cp_filters`

1 × SELECT `finish` 
  FROM `jos_cp_filters`

1 × SELECT `availability` 
  FROM `jos_cp_filters`

1 × SELECT `vendor_name` as name, COUNT(DISTINCT `virtuemart_product_id`) as count 
  FROM `jos_cp_filters`

1 × SELECT `size` as name, COUNT(DISTINCT `virtuemart_product_id`) as count 
  FROM `jos_cp_filters`

1 × SELECT `type` as name, COUNT(DISTINCT `virtuemart_product_id`) as count 
  FROM `jos_cp_filters`

1 × SELECT `core` as name, COUNT(DISTINCT `virtuemart_product_id`) as count 
  FROM `jos_cp_filters`

1 × SELECT `thickness` as name, COUNT(DISTINCT `virtuemart_product_id`) as count 
  FROM `jos_cp_filters`

1 × SELECT `category` as name, COUNT(DISTINCT `virtuemart_product_id`) as count 
  FROM `jos_cp_filters`

1 × SELECT `finish` as name, COUNT(DISTINCT `virtuemart_product_id`) as count 
  FROM `jos_cp_filters`

1 × SELECT `availability` as name, COUNT(DISTINCT `virtuemart_product_id`) as count 
  FROM `jos_cp_filters`

1 × SELECT `profile`, `name`, `value` 
  FROM `jos_virtuemart_magiczoomplus_config

1 × SELECT `profile`, `name`, `value` 
  FROM `jos_virtuemart_magicscroll_config

1 × SELECT `virtuemart_media_id` 
  FROM `jos_virtuemart_category_medias`

1 × SELECT a.params 
  FROM jos_advancedmodules AS a

1 × SELECT cstm.`virtuemart_custom_id`, cstm.`custom_parent_id`, cstm.`custom_title`, cstm.`custom_desc`, cstm.`ordering`, parent_cstm.`custom_title` as parent_title 
  FROM `jos_virtuemart_customs` as cstm 
  LEFT JOIN (SELECT `virtuemart_custom_id`, `custom_title`, `ordering` 
  FROM `jos_virtuemart_customs`

1 × SELECT `virtuemart_shoppergroup_id` 
  FROM `jos_virtuemart_product_shoppergroups`

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

1 × SELECT id, rules 
  FROM `jos_viewlevels

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` 
  FROM jos_extensions

1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM jos_menu AS m 
  LEFT JOIN jos_extensions AS e 
  ON m.component_id = e.extension_id

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

```
1 × SELECT * 
  FROM jos_languages
```

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

1 × SELECT `config` 
  FROM `jos_virtuemart_configs`

1 × SELECT * 
  FROM `jos_virtuemart_shoppergroups`

1 × SELECT `jos_virtuemart_shoppergroups`.*  
  FROM `jos_virtuemart_shoppergroups`

1 × SELECT `jos_virtuemart_products`.* ,`jos_virtuemart_products_en_gb`.*  
  FROM `jos_virtuemart_products` 
  INNER JOIN `jos_virtuemart_products_en_gb` using (`virtuemart_product_id`)

1 × SELECT `virtuemart_media_id` 
  FROM `jos_virtuemart_product_medias`

1 × SELECT * 
  FROM `jos_virtuemart_product_prices`

1 × SELECT `session_id` 
  FROM `jos_session`

1 × SELECT `virtuemart_manufacturer_id` 
  FROM `jos_virtuemart_product_manufacturers`

1 × SELECT * 
  FROM `jos_virtuemart_product_categories`

1 × SELECT `jos_virtuemart_categories`.* ,`jos_virtuemart_categories_en_gb`.*  
  FROM `jos_virtuemart_categories` 
  INNER JOIN `jos_virtuemart_categories_en_gb` using (`virtuemart_category_id`)

1 × SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,   c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,   field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`   
  FROM `jos_virtuemart_customs` AS c 
  LEFT JOIN `jos_virtuemart_product_customfields` AS field 
  ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id`

1 × SELECT *  
  FROM `jos_virtuemart_currencies` AS c    
  LEFT JOIN `jos_virtuemart_vendors` AS v 
  ON  c.virtuemart_currency_id = v.vendor_currency

1 × SELECT `jos_virtuemart_currencies`.*  
  FROM `jos_virtuemart_currencies`

1 × SELECT cartData 
  FROM `jos_virtuemart_carts`

1 × SELECT `fieldtitle`, `fieldvalue` 
  FROM `jos_virtuemart_userfield_values`

1 × SELECT * 
  FROM `jos_virtuemart_countries`

1 × SELECT c.* 
  FROM jos_virtuemart_calcs as c 
  LEFT JOIN jos_virtuemart_calc_shoppergroups as cs 
  ON cs.virtuemart_calc_id=c.virtuemart_calc_id

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params as advancedparams, 0 as menuid, m.publish_up, m.publish_down 
  FROM jos_modules AS m 
  LEFT JOIN jos_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id 
  LEFT JOIN jos_advancedmodules as am 
  ON am.moduleid = m.id

1 × SELECT a.mirror_id 
  FROM jos_advancedmodules AS a

1 × SELECT `profile`, `name`, `value` 
  FROM `jos_magiczoomplus_config`

OTHER Tables:

1 × INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('77efc2fc2188276613c8c36a6b9a38a0', 1, '1718349396', 0, '', 0

1 × UPDATE `jos_extensions` 
  SET `params` = '{\"mediaversion\":\"7334ed89194f387dcf06b90a7e7d5a34\"}'

1 × SHOW TABLES LIKE "jos_virtuemart_configs

1 × SHOW FULL COLUMNS  
  FROM `jos_virtuemart_userfields

1 × SHOW TABLES LIKE '%_vm_product_type_parameter%

1 × UPDATE jos_banners 
  SET impmade = (impmade + 1)

1 × DROP TABLE IF EXISTS `jos_cp_filters

1 × CREATE TEMPORARY TABLE `jos_cp_filters` (`virtuemart_product_id` int(11) NOT NULL, `item_number` varchar(255) DEFAULT NULL, `ornament` varchar(255) DEFAULT NULL, `rabbet` varchar(255) DEFAULT NULL, `sub-category` varchar(255) DEFAULT NULL, `unit` varchar(255) DEFAULT NULL, `sheet_price` varchar(255) DEFAULT NULL, `qb1_price` varchar(255) DEFAULT NULL, `qb2_price` varchar(255) DEFAULT NULL, `qb3_price` varchar(255) DEFAULT NULL, `chop_price` varchar(255) DEFAULT NULL, `join_price` varchar(255) DEFAULT NULL, `pack` varchar(255) DEFAULT NULL, `vendor_name` varchar(255) DEFAULT NULL, `size` varchar(255) DEFAULT NULL, `type` varchar(255) DEFAULT NULL, `core` varchar(255) DEFAULT NULL, `thickness` varchar(255) DEFAULT NULL, `category` varchar(255) DEFAULT NULL, `finish` varchar(255) DEFAULT NULL, `availability` varchar(255) DEFAULT NULL, PRIMARY KEY (`virtuemart_product_id`), KEY `idx_item_number` (`item_number`), KEY `idx_ornament` (`ornament`), KEY `idx_rabbet` (`rabbet`), KEY `idx_sub-category` (`sub-category`), KEY `idx_unit` (`unit`), KEY `idx_sheet_price` (`sheet_price`), KEY `idx_qb1_price` (`qb1_price`), KEY `idx_qb2_price` (`qb2_price`), KEY `idx_qb3_price` (`qb3_price`), KEY `idx_chop_price` (`chop_price`), KEY `idx_join_price` (`join_price`), KEY `idx_pack` (`pack`), KEY `idx_vendor_name` (`vendor_name`), KEY `idx_size` (`size`), KEY `idx_type` (`type`), KEY `idx_core` (`core`), KEY `idx_thickness` (`thickness`), KEY `idx_category` (`category`), KEY `idx_finish` (`finish`), KEY `idx_availability` (`availability`)) ENGINE=MyISAM  DEFAULT CHARSET=utf8 (SELECT  vpc.`virtuemart_product_id`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=4, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `item_number`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=15, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `ornament`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=16, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `rabbet`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=9, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `sub-category`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=10, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `unit`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=19, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `sheet_price`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=20, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `qb1_price`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=21, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `qb2_price`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=22, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `qb3_price`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=17, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `chop_price`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=18, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `join_price`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=30, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `pack`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=5, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `vendor_name`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=11, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `size`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=7, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `type`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=12, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `core`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=13, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `thickness`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=8, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `category`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=14, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `finish`, GROUP_CONCAT( IF( vpc.`virtuemart_custom_id`=6, vpc.`customfield_value`, NULL ) SEPARATOR ';' ) AS `availability` 
  FROM (`jos_virtuemart_product_customfields` as vpc) JOIN `jos_virtuemart_customs` as vc USING (`virtuemart_custom_id`) JOIN `jos_virtuemart_products` as p USING (`virtuemart_product_id`) JOIN `jos_virtuemart_product_categories` as vpcat USING(`virtuemart_product_id`)

Nav view search

Navigation

Search

Wood Search

1 Beaded Black Renaissance

Item Number:

NC16344

Product Desc:

1 Beaded Black Renaissance

Finish:

Black

Rabbet:

1 3/16

Availability:

Active

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

78 Queries Logged 2826.44 ms

5 duplicate found!

71 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables:

Log Messages

0 messages logged

Wood Search

1 Beaded Black Renaissance

Item Number: NC16344

Product Desc: 1 Beaded Black Renaissance

Finish: Black

Rabbet: 1 3/16

Availability: Active

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

78 Queries Logged 2826.44 ms

5 duplicate found!

71 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables:

Log Messages

0 messages logged

Item Number:

NC16344

Product Desc:

1 Beaded Black Renaissance

Finish:

Black

Rabbet:

1 3/16

Availability:

Active