- Hits: 119
Hướng dẫn cách kiểm tra cảm biến oxy trên xe oto Toyota
- TRỤ SỞ
- GIỚI THIỆU
- TƯ VẤN & HỎI ĐÁP
- XƯỠNG DỊCH VỤ
- BẢO DƯỠNG CƠ BẢN
- SỬA CHỮA & THAY THẾ
- CHĂM SÓC & LÀM ĐẸP
- CỬA HÀNG
- CÁC GÓI DỊCH VỤ
- PHỤ TÙNG & PHỤ KIỆN
- DẦU NHỚT & PHỤ GIA
- MUA BÁN Ô TÔ
- KHUYẾN MÃI
- THƯ VIỆN
- LIÊN HỆ
THƯ VIỆN
- Home ·
- THƯ VIỆN
- Hits: 1064
Lorem Ipsum is simply dummy text of the printing and typesetting industry. but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.
- Hits: 930
Lorem Ipsum is simply dummy text of the printing and typesetting industry.
- Hits: 738
Lorem Ipsum is simply dummy text of the printing and typesetting industry.
- Hits: 165
Lorem Ipsum is simply dummy text of the printing and typesetting industry.
Page 1 of 2
THƯƠNG HIỆU 1
THÔNG TIN CÔNG TY
CTY TNHH THƯƠNG MẠI DỊCH VỤ XNK VINCAR
-
16C đường số 8, KDC Trung Sơn, Bình Hưng, Bình Chánh, TPHCM.
-
(84) 0888-180388
-
vincar.home@gmail.com
HÀNG NGÀY
GIỜ LÀM VIỆC
| Thứ hai | 07:00 - 17:00 |
|---|---|
| Thứ ba | 07:00 - 17:00 |
| Thứ tư | 07:00 - 17:00 |
| Thứ năm | 07:00 - 17:00 |
| Thứ sáu | 07:00 - 17:00 |
| Thứ bảy | 07:00 - 17:00 |
| Chủ nhật | 07:00 - 12:00 |
Copyright 2021, VINCAR | Trung tâm bảo dưỡng sửa chữa ô tô. Powered by Astroid FrameWork
Joomla! Debug Console
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1624255831,
"last": 1624255831,
"now": 1624255831
},
"token": "9JVjw0mduy3FN6SZyZwGYDuRV111eGBS"
},
"registry": {},
"user": {
"id": 0,
"name": null,
"username": null,
"email": null,
"password": null,
"password_clear": "",
"block": null,
"sendEmail": 0,
"registerDate": null,
"lastvisitDate": null,
"activation": null,
"params": null,
"groups": [],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
}
},
"__vm": {
"vmcart": "{\"cartProductsData\":[],\"vendorId\":0,\"lastVisitedCategoryId\":0,\"virtuemart_shipmentmethod_id\":0,\"virtuemart_paymentmethod_id\":0,\"automaticSelectedShipment\":false,\"automaticSelectedPayment\":false,\"order_number\":null,\"BT\":0,\"ST\":0,\"cartfields\":null,\"couponCode\":\"\",\"_triesValidateCoupon\":[],\"order_language\":\"en-GB\",\"pricesCurrency\":null,\"paymentCurrency\":null,\"_guest\":1,\"_inCheckOut\":false,\"_inConfirm\":false,\"_redirected\":false,\"_dataValidated\":false,\"_confirmDone\":false,\"STsameAsBT\":1,\"selected_shipto\":0,\"_fromCart\":false,\"layout\":\"default\",\"layoutPath\":\"\",\"virtuemart_cart_id\":0,\"orderdoneHtml\":false,\"virtuemart_order_id\":false}"
}
}
Time
Memory
Time: 17.81 ms / 17.81 ms Memory: 2.236 MB / 2.45 MB Application: afterLoad
Time: 70.48 ms / 88.29 ms Memory: 6.641 MB / 9.09 MB Application: afterInitialise
Time: 31.96 ms / 120.25 ms Memory: 3.890 MB / 12.98 MB Application: afterRoute
Time: 6.83 ms / 127.07 ms Memory: 0.439 MB / 13.42 MB Application: beforeRenderComponent com_content
Time: 8.16 ms / 135.23 ms Memory: 1.042 MB / 14.46 MB Application: Before Access::preloadComponents (all components)
Time: 1.59 ms / 136.82 ms Memory: 0.102 MB / 14.56 MB Application: After Access::preloadComponents (all components)
Time: 0.04 ms / 136.86 ms Memory: 0.000 MB / 14.56 MB Application: Before Access::preloadPermissions (com_content)
Time: 0.97 ms / 137.83 ms Memory: 0.113 MB / 14.67 MB Application: After Access::preloadPermissions (com_content)
Time: 0.05 ms / 137.88 ms Memory: 0.000 MB / 14.67 MB Application: Before Access::getAssetRules (id:100 name:com_content.category.8)
Time: 0.72 ms / 138.61 ms Memory: 0.050 MB / 14.72 MB Application: After Access::getAssetRules (id:100 name:com_content.category.8)
Time: 4.86 ms / 143.47 ms Memory: 0.399 MB / 15.12 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Time: 0.06 ms / 143.52 ms Memory: 0.003 MB / 15.12 MB Application: After Access::getAssetRules (id:8 name:com_content)
Time: 77.01 ms / 220.54 ms Memory: 4.210 MB / 19.33 MB Application: afterRenderComponent com_content
Time: 9.25 ms / 229.79 ms Memory: 0.803 MB / 20.13 MB Application: afterDispatch
Time: 35.78 ms / 265.57 ms Memory: 3.555 MB / 23.69 MB Application: Before Access::getAssetRules (id:1 name:root.1)
Time: 0.08 ms / 265.65 ms Memory: 0.009 MB / 23.70 MB Application: After Access::getAssetRules (id:1 name:root.1)
Time: 0.07 ms / 265.72 ms Memory: 0.001 MB / 23.70 MB Application: Before Access::getAssetRules (id:60 name:com_virtuemart)
Time: 0.02 ms / 265.74 ms Memory: 0.003 MB / 23.70 MB Application: After Access::getAssetRules (id:60 name:com_virtuemart)
Time: 355.92 ms / 621.66 ms Memory: 2.164 MB / 25.86 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 1.81 ms / 623.47 ms Memory: 0.092 MB / 25.96 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 6.44 ms / 629.91 ms Memory: 0.000 MB / 25.95 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 0.61 ms / 630.53 ms Memory: 0.010 MB / 25.96 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 595.58 ms / 1226.11 ms Memory: 0.000 MB / 25.14 MB Application: beforeRenderModule mod_custom (Copyright Partners)
Time: 0.76 ms / 1226.87 ms Memory: 0.015 MB / 25.15 MB Application: afterRenderModule mod_custom (Copyright Partners)
Time: 0.09 ms / 1226.95 ms Memory: 0.000 MB / 25.15 MB Application: beforeRenderModule mod_custom (GIỜ LÀM VIỆC)
Time: 0.17 ms / 1227.13 ms Memory: 0.007 MB / 25.16 MB Application: afterRenderModule mod_custom (GIỜ LÀM VIỆC)
Time: 0.11 ms / 1227.24 ms Memory: 0.000 MB / 25.15 MB Application: beforeRenderModule mod_gallery (HÀNG NGÀY)
Time: 0.68 ms / 1227.92 ms Memory: 0.026 MB / 25.18 MB Application: afterRenderModule mod_gallery (HÀNG NGÀY)
Time: 0.10 ms / 1228.02 ms Memory: 0.000 MB / 25.17 MB Application: beforeRenderModule mod_menu (XƯỠNG DỊCH VỤ)
Time: 2.97 ms / 1230.99 ms Memory: 0.138 MB / 25.31 MB Application: afterRenderModule mod_menu (XƯỠNG DỊCH VỤ)
Time: 0.09 ms / 1231.09 ms Memory: 0.000 MB / 25.30 MB Application: beforeRenderModule mod_custom (THÔNG TIN CÔNG TY)
Time: 0.21 ms / 1231.29 ms Memory: 0.007 MB / 25.30 MB Application: afterRenderModule mod_custom (THÔNG TIN CÔNG TY)
Time: 0.09 ms / 1231.38 ms Memory: 0.000 MB / 25.30 MB Application: beforeRenderModule mod_custom (Logo Dưới)
Time: 0.21 ms / 1231.59 ms Memory: 0.008 MB / 25.31 MB Application: afterRenderModule mod_custom (Logo Dưới)
Time: 0.09 ms / 1231.68 ms Memory: 0.000 MB / 25.31 MB Application: beforeRenderModule mod_menu (DỊCH VỤ 1)
Time: 2.84 ms / 1234.52 ms Memory: 0.151 MB / 25.46 MB Application: afterRenderModule mod_menu (DỊCH VỤ 1)
Time: 0.09 ms / 1234.61 ms Memory: 0.000 MB / 25.45 MB Application: beforeRenderModule mod_custom (Bản đồ)
Time: 0.17 ms / 1234.78 ms Memory: 0.007 MB / 25.46 MB Application: afterRenderModule mod_custom (Bản đồ)
Time: 0.09 ms / 1234.87 ms Memory: 0.000 MB / 25.46 MB Application: beforeRenderModule mod_menu (THƯƠNG HIỆU 1)
Time: 2.91 ms / 1237.78 ms Memory: 0.150 MB / 25.61 MB Application: afterRenderModule mod_menu (THƯƠNG HIỆU 1)
Time: 0.09 ms / 1237.87 ms Memory: 0.000 MB / 25.60 MB Application: beforeRenderModule mod_virtuemart_cart (CỬA HÀNG)
Time: 68.19 ms / 1306.06 ms Memory: 7.201 MB / 32.80 MB Application: afterRenderModule mod_virtuemart_cart (CỬA HÀNG)
Time: 0.07 ms / 1306.14 ms Memory: 0.000 MB / 32.79 MB Application: beforeRenderModule mod_menu (Login)
Time: 1.14 ms / 1307.28 ms Memory: 0.023 MB / 32.82 MB Application: afterRenderModule mod_menu (Login)
Time: 0.05 ms / 1307.32 ms Memory: 0.000 MB / 32.81 MB Application: beforeRenderModule mod_login (Login Menu Item { Show With Right Menu })
Time: 2.48 ms / 1309.80 ms Memory: 0.055 MB / 32.87 MB Application: afterRenderModule mod_login (Login Menu Item { Show With Right Menu })
Time: 0.13 ms / 1309.93 ms Memory: 0.000 MB / 32.86 MB Application: beforeRenderModule mod_menu (Offcanvas Menu)
Time: 10.81 ms / 1320.74 ms Memory: 0.026 MB / 32.89 MB Application: afterRenderModule mod_menu (Offcanvas Menu)
Time: 90.41 ms / 1411.15 ms Memory: 0.422 MB / 33.31 MB Application: afterRender
Database queries total: 33.15 ms
34.11 MB (35,771,608 Bytes)
42 Queries Logged 33.15 ms
- Query Time: 0.44 ms Query memory: 0.019 MB Memory before query: 4.693 MB Rows returned: 0
SELECT `data`
FROM `vc_session`
WHERE `session_id` = 't3bje0v587d5i77u9rnhq7quk3'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE vc_session NULL const PRIMARY PRIMARY 194 const 1 100.00 NULL Status Duration starting 0.10 ms checking permissions 0.01 ms Opening tables 0.07 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms executing 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 # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Same as call in the line below. 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php:660 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:620 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:498 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:455 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:758 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:344 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 0.31 ms After last query: 1.87 ms Query memory: 0.011 MB Memory before query: 4.869 MB Rows returned: 0
SELECT `session_id`
FROM `vc_session`
WHERE `session_id` = 't3bje0v587d5i77u9rnhq7quk3'
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE vc_session NULL const PRIMARY PRIMARY 194 const 1 100.00 Using index Status Duration starting 0.08 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 executing 0.01 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.08 ms cleaning up 0.01 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:153 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:760 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:344 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 1.05 ms After last query: 0.17 ms Query memory: 0.010 MB Memory before query: 4.886 MB
INSERT INTO `vc_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('t3bje0v587d5i77u9rnhq7quk3', 1, 1624255831, 0, '', 0)EXPLAIN not possible on query: INSERT INTO `vc_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('t3bje0v587d5i77u9rnhq7quk3', 1, 1624255831, 0, '', 0)Status Duration starting 0.08 ms checking permissions 0.03 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms update 0.07 ms Waiting for query cache lock 0.01 ms update 0.01 ms end 0.00 ms query end 0.75 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Caller File and line number 8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:153 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:760 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:344 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 0.73 ms After last query: 3.57 ms Query memory: 0.014 MB Memory before query: 5.221 MB Rows returned: 43
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `vc_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE vc_extensions NULL ref extension extension 82 const 43 1.00 Using where Status Duration starting 0.09 ms checking permissions 0.01 ms Opening tables 0.09 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.01 ms Sending data 0.23 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:445 10 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() Same as call in the line below. 9 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 8 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Component/ComponentHelper.php:453 7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:519 6 Joomla\CMS\Component\ComponentHelper::getComponents() JROOT/libraries/src/Component/ComponentHelper.php:44 5 Joomla\CMS\Component\ComponentHelper::getComponent() JROOT/libraries/src/Component/ComponentHelper.php:103 4 Joomla\CMS\Component\ComponentHelper::getParams() JROOT/libraries/src/Application/SiteApplication.php:594 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.32 ms After last query: 3.06 ms Query memory: 0.013 MB Memory before query: 5.528 MB Rows returned: 5
SELECT id, rules
FROM `vc_viewlevels`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE vc_viewlevels NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 5 100.00 NULL Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.05 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.03 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 # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:321 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.46 ms After last query: 0.20 ms Query memory: 0.014 MB Memory before query: 5.553 MB Rows returned: 2
SELECT b.id
FROM vc_usergroups AS a
LEFT JOIN vc_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id 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 2 100.00 Using where; Using index Status Duration starting 0.07 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.16 ms init 0.02 ms System lock 0.03 ms optimizing 0.01 ms statistics 0.05 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.04 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:321 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.02 ms After last query: 0.96 ms Query memory: 0.013 MB Memory before query: 5.655 MB Rows returned: 99
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM vc_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE vc_extensions NULL ref extension extension 82 const 134 0.60 Using index condition; Using where; Using filesort Status Duration starting 0.09 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.01 ms Creating sort index 0.60 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.02 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:354 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 7 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Plugin/PluginHelper.php:359 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 2.11 ms After last query: 36.23 ms Query memory: 0.023 MB Memory before query: 9.414 MB Rows returned: 168
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 vc_menu AS m
LEFT JOIN vc_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.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL range idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 5 NULL 211 10.00 Using index condition; Using where; Using filesort 1 SIMPLE e NULL eq_ref PRIMARY PRIMARY 4 vincarsc_garage.m.component_id 1 100.00 Using where Status Duration starting 0.17 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.11 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.11 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 1.45 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 17 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Same as call in the line below. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 14 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:76 13 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 12 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:131 11 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:375 10 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 9 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:64 8 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 7 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:491 6 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:403 5 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/libraries/src/Application/CMSApplication.php:1073 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.39 ms After last query: 26.56 ms Query memory: 0.015 MB Memory before query: 12.966 MB Rows returned: 0
SELECT *
FROM `vc_jdbuilder_configs`
WHERE `type`='global'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 Status Duration starting 0.12 ms checking permissions 0.01 ms Opening tables 0.08 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 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 # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 12 JDatabaseDriver->loadObject() JROOT/plugins/system/jdbuilder/libraries/jdpagebuilder/Helper.php:1954 11 JDPageBuilder\Helper::globalSettings() JROOT/plugins/system/jdbuilder/libraries/jdpagebuilder/Builder.php:51 10 JDPageBuilder\Builder::init() JROOT/plugins/system/jdbuilder/jdbuilder.php:26 9 plgSystemJDBuilder->onAfterRoute() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1122 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.42 ms After last query: 0.77 ms Query memory: 0.018 MB Memory before query: 13.040 MB Rows returned: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `vc_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE vc_extensions NULL ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 NULL Status Duration starting 0.09 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.08 ms preparing 0.01 ms executing 0.00 ms Sending data 0.05 ms end 0.02 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 14 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 13 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Same as call in the line below. 12 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 11 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 10 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 9 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 8 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1129 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.07 ms After last query: 0.31 ms Query memory: 0.012 MB Memory before query: 13.043 MB
UPDATE `vc_extensions`
SET `params` = '{\"mediaversion\":\"658e1764611746dc7751bb95a3e4a579\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE vc_extensions NULL range element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using where Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.05 ms updating 0.07 ms end 0.01 ms Waiting for query cache lock 0.00 ms end 0.01 ms query end 0.70 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 9 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 8 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1129 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.41 ms After last query: 2.32 ms Query memory: 0.009 MB Memory before query: 13.367 MB Rows returned: 1
SELECT *
FROM vc_languages
WHERE published=1
ORDER BY ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE vc_languages NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Using where; Using filesort Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.03 ms System lock 0.02 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.04 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 # Caller File and line number 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 6 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 5 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/libraries/src/Application/SiteApplication.php:330 4 Joomla\CMS\Application\SiteApplication->getParams() JROOT/libraries/src/Application/SiteApplication.php:138 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.43 ms After last query: 0.55 ms Query memory: 0.008 MB Memory before query: 13.408 MB Rows returned: 6
SELECT id, home, template, s.params
FROM vc_template_styles as s
LEFT JOIN vc_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 = 1id 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 8 12.50 Using where 1 SIMPLE e NULL ref element_clientid,element_folder_clientid,extension element_clientid 403 vincarsc_garage.s.template,const 1 4.45 Using index condition; Using where Status Duration starting 0.08 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.05 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.04 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.04 ms cleaning up 0.01 ms # Caller File and line number 6 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 5 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 4 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/libraries/src/Application/SiteApplication.php:168 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.15 ms After last query: 9.11 ms Query memory: 0.025 MB Memory before query: 14.469 MB Rows returned: 43
SELECT `id`,`name`,`rules`,`parent_id`
FROM `vc_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_acym','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jce','com_jdbuilder','com_jdprofiler','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_nextend2','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_smartslider3','com_tags','com_tcpdf','com_templates','com_users','com_virtuemart','com_virtuemart_allinone','com_wrapper')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE vc_assets NULL ALL idx_asset_name NO INDEX KEY COULD BE USED NULL NULL 252 17.46 Using where Status Duration starting 0.11 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.05 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.15 ms preparing 0.01 ms executing 0.00 ms Sending data 0.46 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.11 ms cleaning up 0.01 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 18 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 17 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 16 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 15 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 14 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/category.php:139 13 ContentModelCategory->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440 12 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/libraries/src/MVC/View/CategoryView.php:116 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.54 ms After last query: 0.39 ms Query memory: 0.025 MB Memory before query: 14.561 MB Rows returned: 61
SELECT `id`,`name`,`rules`,`parent_id`
FROM `vc_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE vc_assets NULL ALL idx_asset_name,idx_parent_id NO INDEX KEY COULD BE USED NULL NULL 252 27.27 Using where Status Duration starting 0.07 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.06 ms preparing 0.01 ms executing 0.00 ms Sending data 0.18 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.02 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:359 18 Joomla\CMS\Access\Access::preloadPermissions() JROOT/libraries/src/Access/Access.php:226 17 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:540 16 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 15 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 14 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/category.php:139 13 ContentModelCategory->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440 12 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/libraries/src/MVC/View/CategoryView.php:116 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.97 ms After last query: 2.45 ms Query memory: 0.021 MB Memory before query: 14.803 MB Rows returned: 2
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,( SELECT COUNT(i.`id`)
FROM `vc_content` AS `i`
WHERE i.`catid` = c.id
AND i.state = 1) AS numitems
FROM `vc_categories` AS `s`
INNER JOIN `vc_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.published = 1
AND s.id = 8
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY s NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 Using filesort 1 PRIMARY c NULL ALL cat_idx,idx_left_right NO INDEX KEY COULD BE USED NULL NULL 7 42.86 Using where 2 DEPENDENT SUBQUERY i NULL ref idx_state,idx_catid idx_catid 4 vincarsc_garage.c.id 20 100.00 Using index condition; Using where Status Duration starting 0.19 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.12 ms init 0.05 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.09 ms preparing 0.02 ms Sorting result 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 0.06 ms executing 0.01 ms Sending data 0.03 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.05 ms cleaning up 0.02 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 15 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 14 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/models/category.php:355 13 ContentModelCategory->getCategory() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:122 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.03 ms After last query: 2.68 ms Query memory: 0.022 MB Memory before query: 15.118 MB Rows returned: 5Duplicate queries: #23
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias
FROM vc_content AS a
LEFT JOIN vc_categories AS c
ON c.id = a.catid
LEFT JOIN vc_users AS ua
ON ua.id = a.created_by
LEFT JOIN vc_users AS uam
ON uam.id = a.modified_by
LEFT JOIN vc_categories as parent
ON parent.id = c.parent_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND a.catid = 8
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-06-21 06:10:31')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-06-21 06:10:31')
ORDER BY c.lft,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created
LIMIT 5id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL const PRIMARY,idx_access PRIMARY 4 const 1 100.00 Using filesort 1 SIMPLE a NULL ref idx_access,idx_state,idx_catid idx_catid 4 const 7 16.00 Using index condition; Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 vincarsc_garage.a.created_by 1 100.00 Using where 1 SIMPLE uam NULL eq_ref PRIMARY PRIMARY 4 vincarsc_garage.a.modified_by 1 100.00 Using where 1 SIMPLE parent NULL const PRIMARY PRIMARY 4 const 1 100.00 Using where Status Duration starting 0.19 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.08 ms init 0.07 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.03 ms Creating sort index 0.26 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 16 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_content/models/articles.php:576 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 13 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.55 ms After last query: 2.89 ms Query memory: 0.022 MB Memory before query: 15.480 MB Rows returned: 1Duplicate queries: #24
SELECT COUNT(*)
FROM vc_content AS a
LEFT JOIN vc_categories AS c
ON c.id = a.catid
LEFT JOIN vc_users AS ua
ON ua.id = a.created_by
LEFT JOIN vc_users AS uam
ON uam.id = a.modified_by
LEFT JOIN vc_categories as parent
ON parent.id = c.parent_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND a.catid = 8
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-06-21 06:10:31')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-06-21 06:10:31')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL const PRIMARY,idx_access PRIMARY 4 const 1 100.00 NULL 1 SIMPLE a NULL ref idx_access,idx_state,idx_catid idx_catid 4 const 7 16.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 vincarsc_garage.a.created_by 1 100.00 Using where; Using index 1 SIMPLE uam NULL eq_ref PRIMARY PRIMARY 4 vincarsc_garage.a.modified_by 1 100.00 Using where; Using index 1 SIMPLE parent NULL const PRIMARY PRIMARY 4 const 1 100.00 Using where; Using index Status Duration starting 0.11 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 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.02 ms freeing items 0.06 ms cleaning up 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 17 JDatabaseDriver->loadResult() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:340 16 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() JROOT/libraries/src/MVC/Model/ListModel.php:282 15 Joomla\CMS\MVC\Model\ListModel->getTotal() JROOT/libraries/src/MVC/Model/ListModel.php:232 14 Joomla\CMS\MVC\Model\ListModel->getPagination() JROOT/components/com_content/models/category.php:265 13 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.56 ms After last query: 2.03 ms Query memory: 0.018 MB Memory before query: 15.706 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `vc_contentitem_tag_map` AS m
INNER JOIN `vc_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.category'
AND `m`.`content_item_id` = 8
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type NO INDEX KEY COULD BE USED NULL NULL 3 33.33 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 vincarsc_garage.m.tag_id 1 100.00 Using where Status Duration starting 0.08 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.09 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.03 ms executing 0.00 ms Sending data 0.03 ms end 0.00 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.02 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 12 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/libraries/src/MVC/View/CategoryView.php:229 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.83 ms After last query: 20.11 ms Query memory: 0.026 MB Memory before query: 17.937 MB Rows returned: 2
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `vc_categories` AS `s`
INNER JOIN `vc_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 8
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 Using filesort 1 SIMPLE c NULL ALL cat_idx,idx_access,idx_left_right NO INDEX KEY COULD BE USED NULL NULL 7 71.43 Using where Status Duration starting 0.19 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.04 ms statistics 0.14 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 0.13 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.02 ms # Caller File and line number 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 20 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 19 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_fields/models/fields.php:203 18 FieldsModelFields->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:133 17 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:187 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:135 15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:488 14 PlgSystemFields->onContentPrepare() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:113 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.07 ms After last query: 0.32 ms Query memory: 0.024 MB Memory before query: 17.976 MB Rows returned: 0
SELECT DISTINCT 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, g.note as group_note
FROM vc_fields AS a
LEFT JOIN `vc_languages` AS l
ON l.lang_code = a.language
LEFT JOIN vc_users AS uc
ON uc.id=a.checked_out
LEFT JOIN vc_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN vc_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN vc_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `vc_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (8,0))
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 ASCid 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 temporary; Using filesort 1 SIMPLE l NULL eq_ref idx_langcode idx_langcode 28 vincarsc_garage.a.language 1 100.00 Using where 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 vincarsc_garage.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 vincarsc_garage.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 vincarsc_garage.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 vincarsc_garage.a.group_id 1 100.00 Using where 1 SIMPLE fc NULL ref PRIMARY PRIMARY 4 vincarsc_garage.a.id 1 100.00 Using where; Using index; Distinct Status Duration starting 0.14 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.18 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.16 ms preparing 0.03 ms Creating tmp table 0.05 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.15 ms Creating sort index 0.02 ms end 0.01 ms query end 0.01 ms removing tmp table 0.03 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.02 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 18 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 17 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:135 15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:488 14 PlgSystemFields->onContentPrepare() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:113 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.92 ms After last query: 14.66 ms Query memory: 0.025 MB Memory before query: 18.979 MB Rows returned: 2
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,( SELECT COUNT(i.`id`)
FROM `vc_content` AS `i`
WHERE i.`catid` = c.id
AND i.state = 1) AS numitems
FROM `vc_categories` AS `s`
INNER JOIN `vc_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 8
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY s NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 Using filesort 1 PRIMARY c NULL ALL cat_idx,idx_access,idx_left_right NO INDEX KEY COULD BE USED NULL NULL 7 71.43 Using where 2 DEPENDENT SUBQUERY i NULL ref idx_state,idx_catid idx_catid 4 vincarsc_garage.c.id 20 100.00 Using index condition; Using where Status Duration starting 0.18 ms checking permissions 0.01 ms checking permissions 0.00 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.13 ms preparing 0.04 ms Sorting result 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 0.05 ms executing 0.00 ms Sending data 0.02 ms executing 0.00 ms Sending data 0.07 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.08 ms cleaning up 0.01 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 18 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 17 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/models/category.php:355 16 ContentModelCategory->getCategory() JROOT/components/com_content/models/category.php:230 15 ContentModelCategory->getItems() JROOT/templates/jd_servx/html/com_content/category/blog.php:12 14 include JROOT/templates/jd_servx/html/com_content/category/blog.php JROOT/libraries/src/MVC/View/HtmlView.php:697 13 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 12 Joomla\CMS\MVC\View\HtmlView->display() JROOT/libraries/src/MVC/View/CategoryView.php:245 11 Joomla\CMS\MVC\View\CategoryView->display() JROOT/components/com_content/views/category/view.html.php:250 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.75 ms After last query: 0.71 ms Query memory: 0.025 MB Memory before query: 19.034 MB Rows returned: 5Duplicate queries: #17
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias
FROM vc_content AS a
LEFT JOIN vc_categories AS c
ON c.id = a.catid
LEFT JOIN vc_users AS ua
ON ua.id = a.created_by
LEFT JOIN vc_users AS uam
ON uam.id = a.modified_by
LEFT JOIN vc_categories as parent
ON parent.id = c.parent_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND a.catid = 8
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-06-21 06:10:31')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-06-21 06:10:31')
ORDER BY c.lft,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created
LIMIT 5id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL const PRIMARY,idx_access PRIMARY 4 const 1 100.00 Using filesort 1 SIMPLE a NULL ref idx_access,idx_state,idx_catid idx_catid 4 const 7 16.00 Using index condition; Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 vincarsc_garage.a.created_by 1 100.00 Using where 1 SIMPLE uam NULL eq_ref PRIMARY PRIMARY 4 vincarsc_garage.a.modified_by 1 100.00 Using where 1 SIMPLE parent NULL const PRIMARY PRIMARY 4 const 1 100.00 Using where Status Duration starting 0.16 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.07 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 0.17 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.02 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 18 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 17 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_content/models/articles.php:576 16 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 15 ContentModelCategory->getItems() JROOT/templates/jd_servx/html/com_content/category/blog.php:12 14 include JROOT/templates/jd_servx/html/com_content/category/blog.php JROOT/libraries/src/MVC/View/HtmlView.php:697 13 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 12 Joomla\CMS\MVC\View\HtmlView->display() JROOT/libraries/src/MVC/View/CategoryView.php:245 11 Joomla\CMS\MVC\View\CategoryView->display() JROOT/components/com_content/views/category/view.html.php:250 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.50 ms After last query: 1.70 ms Query memory: 0.025 MB Memory before query: 19.251 MB Rows returned: 1Duplicate queries: #18
SELECT COUNT(*)
FROM vc_content AS a
LEFT JOIN vc_categories AS c
ON c.id = a.catid
LEFT JOIN vc_users AS ua
ON ua.id = a.created_by
LEFT JOIN vc_users AS uam
ON uam.id = a.modified_by
LEFT JOIN vc_categories as parent
ON parent.id = c.parent_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND a.catid = 8
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-06-21 06:10:31')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-06-21 06:10:31')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL const PRIMARY,idx_access PRIMARY 4 const 1 100.00 NULL 1 SIMPLE a NULL ref idx_access,idx_state,idx_catid idx_catid 4 const 7 16.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 vincarsc_garage.a.created_by 1 100.00 Using where; Using index 1 SIMPLE uam NULL eq_ref PRIMARY PRIMARY 4 vincarsc_garage.a.modified_by 1 100.00 Using where; Using index 1 SIMPLE parent NULL const PRIMARY PRIMARY 4 const 1 100.00 Using where; Using index Status Duration starting 0.10 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.01 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.05 ms cleaning up 0.01 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 19 JDatabaseDriver->loadResult() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:340 18 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() JROOT/libraries/src/MVC/Model/ListModel.php:282 17 Joomla\CMS\MVC\Model\ListModel->getTotal() JROOT/libraries/src/MVC/Model/ListModel.php:232 16 Joomla\CMS\MVC\Model\ListModel->getPagination() JROOT/components/com_content/models/category.php:265 15 ContentModelCategory->getItems() JROOT/templates/jd_servx/html/com_content/category/blog.php:12 14 include JROOT/templates/jd_servx/html/com_content/category/blog.php JROOT/libraries/src/MVC/View/HtmlView.php:697 13 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 12 Joomla\CMS\MVC\View\HtmlView->display() JROOT/libraries/src/MVC/View/CategoryView.php:245 11 Joomla\CMS\MVC\View\CategoryView->display() JROOT/components/com_content/views/category/view.html.php:250 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 3.09 ms After last query: 48.78 ms Query memory: 0.023 MB Memory before query: 21.288 MB Rows returned: 61
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM vc_modules AS m
LEFT JOIN vc_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN vc_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2021-06-21 06:10:31')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-06-21 06:10:31')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 294 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL range PRIMARY,published,newsfeeds published 5 NULL 87 1.60 Using index condition; Using where; Using filesort 1 SIMPLE e NULL ref element_clientid,element_folder_clientid element_clientid 403 vincarsc_garage.m.module,const 1 10.00 Using index condition; Using where 1 SIMPLE mm NULL ref PRIMARY PRIMARY 4 vincarsc_garage.m.id 2 40.00 Using where; Using index Status Duration starting 0.29 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.20 ms init 0.07 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.15 ms preparing 0.04 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.02 ms Creating sort index 2.06 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.08 ms cleaning up 0.02 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() Same as call in the line below. 17 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 16 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:432 15 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:362 14 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 13 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/astroid/framework/template.php:429 12 AstroidFrameworkTemplate->renderModulePosition() JROOT/templates/jd_servx/frontend/offcanvas.php:36 11 include JROOT/templates/jd_servx/frontend/offcanvas.php JROOT/libraries/src/Layout/FileLayout.php:125 10 Joomla\CMS\Layout\FileLayout->render() JROOT/libraries/astroid/framework/template.php:726 9 AstroidFrameworkTemplate->loadLayout() JROOT/libraries/astroid/framework/template.php:211 8 AstroidFrameworkTemplate->renderLayout() JROOT/templates/jd_servx/index.php:109 7 require JROOT/templates/jd_servx/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1030 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.24 ms After last query: 17.27 ms Query memory: 0.033 MB Memory before query: 23.388 MB Rows returned: 1
SHOW TABLES LIKE "vc_virtuemart_configs"
EXPLAIN not possible on query: SHOW TABLES LIKE "vc_virtuemart_configs"Status Duration starting 0.16 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.02 ms preparing 0.02 ms executing 0.01 ms checking permissions 0.70 ms Sending data 0.02 ms end 0.01 ms query end 0.03 ms closing tables 0.03 ms removing tmp table 0.03 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.02 ms # Caller File and line number 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 26 JDatabaseDriver->loadResult() JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:722 25 VmTable::checkTableExists() JROOT/administrator/components/com_virtuemart/models/config.php:563 24 VirtueMartModelConfig::checkConfigTableExists() JROOT/administrator/components/com_virtuemart/helpers/config.php:774 23 VmConfig::loadConfig() JROOT/components/com_virtuemart/router.php:884 22 vmrouterHelper::getInstance() JROOT/components/com_virtuemart/router.php:27 21 virtuemartBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 20 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:528 19 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:498 18 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 17 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 16 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:131 15 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:80 14 Joomla\CMS\Router\Route::_() JROOT/modules/mod_menu/helper.php:139 13 ModMenuHelper::getList() JROOT/libraries/astroid/framework/menu.php:545 12 AstroidMenu::getMobileMenu() JROOT/templates/jd_servx/frontend/mobilemenu.php:34 11 include JROOT/templates/jd_servx/frontend/mobilemenu.php JROOT/libraries/src/Layout/FileLayout.php:125 10 Joomla\CMS\Layout\FileLayout->render() JROOT/libraries/astroid/framework/template.php:726 9 AstroidFrameworkTemplate->loadLayout() JROOT/libraries/astroid/framework/template.php:213 8 AstroidFrameworkTemplate->renderLayout() JROOT/templates/jd_servx/index.php:109 7 require JROOT/templates/jd_servx/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1030 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.55 ms After last query: 0.76 ms Query memory: 0.030 MB Memory before query: 23.494 MB Rows returned: 1
SELECT `config`
FROM `vc_virtuemart_configs`
WHERE `virtuemart_config_id` = "1";id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE vc_virtuemart_configs NULL system PRIMARY NO INDEX KEY COULD BE USED NULL NULL 1 100.00 NULL Status Duration starting 0.18 ms checking permissions 0.01 ms Opening tables 0.09 ms init 0.02 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.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.09 ms cleaning up 0.01 ms # Caller File and line number 25 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 24 JDatabaseDriver->loadResult() JROOT/administrator/components/com_virtuemart/helpers/config.php:814 23 VmConfig::loadConfig() JROOT/components/com_virtuemart/router.php:884 22 vmrouterHelper::getInstance() JROOT/components/com_virtuemart/router.php:27 21 virtuemartBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 20 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:528 19 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:498 18 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 17 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 16 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:131 15 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:80 14 Joomla\CMS\Router\Route::_() JROOT/modules/mod_menu/helper.php:139 13 ModMenuHelper::getList() JROOT/libraries/astroid/framework/menu.php:545 12 AstroidMenu::getMobileMenu() JROOT/templates/jd_servx/frontend/mobilemenu.php:34 11 include JROOT/templates/jd_servx/frontend/mobilemenu.php JROOT/libraries/src/Layout/FileLayout.php:125 10 Joomla\CMS\Layout\FileLayout->render() JROOT/libraries/astroid/framework/template.php:726 9 AstroidFrameworkTemplate->loadLayout() JROOT/libraries/astroid/framework/template.php:213 8 AstroidFrameworkTemplate->renderLayout() JROOT/templates/jd_servx/index.php:109 7 require JROOT/templates/jd_servx/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1030 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.71 ms After last query: 2.75 ms Query memory: 0.032 MB Memory before query: 23.721 MB Rows returned: 1
SELECT *
FROM `vc_menu`
WHERE `link` like "index.php?option=com_virtuemart%"
and client_id=0
and published=1
and (language="*" or language = "en-GB" )
AND ( access="1" OR access="5" )
ORDER BY `language` DESCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE vc_menu NULL ref idx_client_id_parent_id_alias_language,idx_language idx_client_id_parent_id_alias_language 1 const 212 0.38 Using index condition; Using where; Using filesort Status Duration starting 0.14 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.11 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.02 ms Creating sort index 1.13 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.08 ms cleaning up 0.01 ms # Caller File and line number 26 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 25 JDatabaseDriver->loadObjectList() JROOT/components/com_virtuemart/router.php:1274 24 vmrouterHelper->setMenuItemId() JROOT/components/com_virtuemart/router.php:860 23 vmrouterHelper->__construct() JROOT/components/com_virtuemart/router.php:889 22 vmrouterHelper::getInstance() JROOT/components/com_virtuemart/router.php:27 21 virtuemartBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 20 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:528 19 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:498 18 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 17 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 16 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:131 15 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:80 14 Joomla\CMS\Router\Route::_() JROOT/modules/mod_menu/helper.php:139 13 ModMenuHelper::getList() JROOT/libraries/astroid/framework/menu.php:545 12 AstroidMenu::getMobileMenu() JROOT/templates/jd_servx/frontend/mobilemenu.php:34 11 include JROOT/templates/jd_servx/frontend/mobilemenu.php JROOT/libraries/src/Layout/FileLayout.php:125 10 Joomla\CMS\Layout\FileLayout->render() JROOT/libraries/astroid/framework/template.php:726 9 AstroidFrameworkTemplate->loadLayout() JROOT/libraries/astroid/framework/template.php:213 8 AstroidFrameworkTemplate->renderLayout() JROOT/templates/jd_servx/index.php:109 7 require JROOT/templates/jd_servx/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1030 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.43 ms After last query: 954.83 ms Query memory: 0.017 MB Memory before query: 25.116 MB
UPDATE `vc_extensions`
SET `params` = '{\"mediaversion\":\"c599c051390a4b981aa137bb36ecf89e\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE vc_extensions NULL range element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using where Status Duration starting 0.15 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.03 ms System lock 0.09 ms updating 0.09 ms end 0.01 ms Waiting for query cache lock 0.00 ms end 0.01 ms query end 0.78 ms closing tables 0.03 ms freeing items 0.10 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 13 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 12 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:349 11 Joomla\CMS\Version->refreshMediaVersion() JROOT/libraries/astroid/framework/helper.php:381 10 AstroidFrameworkHelper::clearCache() JROOT/libraries/astroid/framework/template.php:788 9 AstroidFrameworkTemplate->buildAstroidCSS() JROOT/libraries/astroid/framework/template.php:804 8 AstroidFrameworkTemplate->loadCSSFile() JROOT/templates/jd_servx/index.php:118 7 require JROOT/templates/jd_servx/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1030 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.50 ms After last query: 22.57 ms Query memory: 0.021 MB Memory before query: 26.975 MB Rows returned: 1
SELECT *
FROM `vc_virtuemart_shoppergroups`
WHERE `default` = "2"
AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")
AND `published`="1"id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE vc_virtuemart_shoppergroups NULL ref virtuemart_vendor_id,shared,published published 1 const 3 25.00 Using where Status Duration starting 0.10 ms checking permissions 0.01 ms Opening tables 0.09 ms init 0.03 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.06 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.01 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 16 JDatabaseDriver->loadObject() JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:100 15 VirtueMartModelShopperGroup->getDefault() JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:134 14 VirtueMartModelShopperGroup->appendShopperGroups() JROOT/administrator/components/com_virtuemart/models/user.php:177 13 VirtueMartModelUser->getUser() JROOT/administrator/components/com_virtuemart/models/user.php:111 12 VirtueMartModelUser->getCurrentUser() JROOT/components/com_virtuemart/helpers/cart.php:129 11 VirtueMartCart::getCart() JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:22 10 include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.27 ms After last query: 0.28 ms Query memory: 0.025 MB Memory before query: 27.048 MB Rows returned: 1
SELECT `vc_virtuemart_shoppergroups`.*
FROM `vc_virtuemart_shoppergroups`
WHERE `vc_virtuemart_shoppergroups`.`virtuemart_shoppergroup_id` = "1"id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE vc_virtuemart_shoppergroups NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 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.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.04 ms cleaning up 0.01 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 19 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1042 18 VmTable->load() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1028 17 VmModel->getData() JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:50 16 VirtueMartModelShopperGroup->getShopperGroup() JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:105 15 VirtueMartModelShopperGroup->getDefault() JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:134 14 VirtueMartModelShopperGroup->appendShopperGroups() JROOT/administrator/components/com_virtuemart/models/user.php:177 13 VirtueMartModelUser->getUser() JROOT/administrator/components/com_virtuemart/models/user.php:111 12 VirtueMartModelUser->getCurrentUser() JROOT/components/com_virtuemart/helpers/cart.php:129 11 VirtueMartCart::getCart() JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:22 10 include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.52 ms After last query: 13.20 ms Query memory: 0.025 MB Memory before query: 29.079 MB Rows returned: 1
SELECT *
FROM `vc_virtuemart_currencies` AS c
LEFT JOIN `vc_virtuemart_vendors` AS v
ON c.virtuemart_currency_id = v.vendor_currency
WHERE v.virtuemart_vendor_id = "1"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 Status Duration starting 0.09 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.14 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.01 ms Sending data 0.03 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 # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 19 JDatabaseDriver->loadObject() JROOT/administrator/components/com_virtuemart/models/vendor.php:287 18 VirtueMartModelVendor::getVendorCurrency() JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:53 17 CurrencyDisplay->__construct() JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:106 16 CurrencyDisplay::getInstance() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:79 15 calculationHelper->__construct() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105 14 calculationHelper::getInstance() JROOT/components/com_virtuemart/helpers/cart.php:1551 13 VirtueMartCart->getCartPrices() JROOT/components/com_virtuemart/helpers/cart.php:1654 12 VirtueMartCart->prepareCartData() JROOT/components/com_virtuemart/helpers/cart.php:1779 11 VirtueMartCart->prepareAjaxData() JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:29 10 include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.33 ms After last query: 1.29 ms Query memory: 0.025 MB Memory before query: 29.262 MB Rows returned: 1
SELECT `vc_virtuemart_currencies`.*
FROM `vc_virtuemart_currencies`
WHERE `vc_virtuemart_currencies`.`virtuemart_currency_id` = "144"id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE vc_virtuemart_currencies NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.06 ms System lock 0.03 ms optimizing 0.01 ms statistics 0.03 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.04 ms cleaning up 0.01 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 19 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1042 18 VmTable->load() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1028 17 VmModel->getData() JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:122 16 CurrencyDisplay::getInstance() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:79 15 calculationHelper->__construct() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105 14 calculationHelper::getInstance() JROOT/components/com_virtuemart/helpers/cart.php:1551 13 VirtueMartCart->getCartPrices() JROOT/components/com_virtuemart/helpers/cart.php:1654 12 VirtueMartCart->prepareCartData() JROOT/components/com_virtuemart/helpers/cart.php:1779 11 VirtueMartCart->prepareAjaxData() JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:29 10 include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.04 ms After last query: 3.14 ms Query memory: 0.033 MB Memory before query: 29.636 MB Rows returned: 31
SHOW FULL COLUMNS
FROM `vc_virtuemart_userfields`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `vc_virtuemart_userfields`Status Duration starting 0.10 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.14 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.11 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.03 ms checking permissions 0.03 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.08 ms end 0.01 ms query end 0.01 ms closing tables 0.00 ms removing tmp table 0.05 ms closing tables 0.02 ms freeing items 0.05 ms cleaning up 0.02 ms # Caller File and line number 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 26 JDatabaseDriver->loadAssocList() JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:683 25 VmTable->showFullColumns() JROOT/administrator/components/com_virtuemart/tables/userfields.php:41 24 TableUserfields->__construct() JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:209 23 VmTable::getInstance() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:432 22 VmModel->_createTable() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:394 21 VmModel->getTable() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:600 20 VmModel->setMainTable() JROOT/administrator/components/com_virtuemart/models/userfields.php:49 19 VirtueMartModelUserfields->__construct() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:552 18 VmModel::getModel() JROOT/components/com_virtuemart/helpers/cart.php:252 17 VirtueMartCart->prepareAddressFieldsInCart() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:271 16 calculationHelper->setCountryState() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90 15 calculationHelper->__construct() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105 14 calculationHelper::getInstance() JROOT/components/com_virtuemart/helpers/cart.php:1551 13 VirtueMartCart->getCartPrices() JROOT/components/com_virtuemart/helpers/cart.php:1654 12 VirtueMartCart->prepareCartData() JROOT/components/com_virtuemart/helpers/cart.php:1779 11 VirtueMartCart->prepareAjaxData() JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:29 10 include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.59 ms After last query: 0.43 ms Query memory: 0.027 MB Memory before query: 29.731 MB Rows returned: 21
SELECT *
FROM `vc_virtuemart_userfields`
WHERE 1 = 1
AND `account`="1"
AND published = 1
AND FIND_IN_SET(name, 'address_type') = 0
ORDER BY orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE vc_virtuemart_userfields NULL ref published,account account 1 const 22 89.29 Using index condition; Using where; Using filesort Status Duration starting 0.08 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.06 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 0.21 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.02 ms # Caller File and line number 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:497 20 VmModel->_getList() JROOT/administrator/components/com_virtuemart/models/userfields.php:602 19 VirtueMartModelUserfields->getUserFields() JROOT/administrator/components/com_virtuemart/models/userfields.php:487 18 VirtueMartModelUserfields->getUserFieldsFor() JROOT/components/com_virtuemart/helpers/cart.php:263 17 VirtueMartCart->prepareAddressFieldsInCart() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:271 16 calculationHelper->setCountryState() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90 15 calculationHelper->__construct() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105 14 calculationHelper::getInstance() JROOT/components/com_virtuemart/helpers/cart.php:1551 13 VirtueMartCart->getCartPrices() JROOT/components/com_virtuemart/helpers/cart.php:1654 12 VirtueMartCart->prepareCartData() JROOT/components/com_virtuemart/helpers/cart.php:1779 11 VirtueMartCart->prepareAjaxData() JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:29 10 include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.39 ms After last query: 0.81 ms Query memory: 0.026 MB Memory before query: 29.910 MB Rows returned: 2
SELECT `fieldtitle`, `fieldvalue`
FROM `vc_virtuemart_userfield_values`
WHERE `virtuemart_userfield_id` = 23
ORDER BY `ordering`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE vc_virtuemart_userfield_values NULL ref virtuemart_userfield_id virtuemart_userfield_id 4 const 2 100.00 Using index condition; Using filesort Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.06 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.04 ms cleaning up 0.01 ms # Caller File and line number 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:497 19 VmModel->_getList() JROOT/administrator/components/com_virtuemart/models/userfields.php:1027 18 VirtueMartModelUserfields->getUserFieldsFilled() JROOT/components/com_virtuemart/helpers/cart.php:268 17 VirtueMartCart->prepareAddressFieldsInCart() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:271 16 calculationHelper->setCountryState() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90 15 calculationHelper->__construct() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105 14 calculationHelper::getInstance() JROOT/components/com_virtuemart/helpers/cart.php:1551 13 VirtueMartCart->getCartPrices() JROOT/components/com_virtuemart/helpers/cart.php:1654 12 VirtueMartCart->prepareCartData() JROOT/components/com_virtuemart/helpers/cart.php:1779 11 VirtueMartCart->prepareAjaxData() JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:29 10 include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.96 ms After last query: 2.00 ms Query memory: 0.028 MB Memory before query: 30.158 MB Rows returned: 245
SELECT *
FROM `vc_virtuemart_countries`
WHERE `published` = 1
ORDER BY country_name ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE vc_virtuemart_countries NULL ALL published NO INDEX KEY COULD BE USED NULL NULL 245 99.18 Using where; Using filesort Status Duration starting 0.10 ms checking permissions 0.01 ms Opening tables 0.07 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.01 ms Creating sort index 0.53 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 # Caller File and line number 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:856 21 VmModel->exeSortSearchListQuery() JROOT/administrator/components/com_virtuemart/models/country.php:111 20 VirtueMartModelCountry->getCountries() JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:144 19 shopFunctionsF::renderCountryList() JROOT/administrator/components/com_virtuemart/models/userfields.php:836 18 VirtueMartModelUserfields->getUserFieldsFilled() JROOT/components/com_virtuemart/helpers/cart.php:268 17 VirtueMartCart->prepareAddressFieldsInCart() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:271 16 calculationHelper->setCountryState() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90 15 calculationHelper->__construct() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105 14 calculationHelper::getInstance() JROOT/components/com_virtuemart/helpers/cart.php:1551 13 VirtueMartCart->getCartPrices() JROOT/components/com_virtuemart/helpers/cart.php:1654 12 VirtueMartCart->prepareCartData() JROOT/components/com_virtuemart/helpers/cart.php:1779 11 VirtueMartCart->prepareAjaxData() JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:29 10 include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.69 ms After last query: 5.92 ms Query memory: 0.029 MB Memory before query: 31.133 MB Rows returned: 14
SELECT *
FROM `vc_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 orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE vc_virtuemart_userfields NULL ref published,shipment shipment 1 const 14 89.29 Using index condition; Using where; Using filesort Status Duration starting 0.10 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.08 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 0.15 ms end 0.01 ms query end 0.02 ms closing tables 0.03 ms freeing items 0.07 ms cleaning up 0.01 ms # Caller File and line number 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:497 20 VmModel->_getList() JROOT/administrator/components/com_virtuemart/models/userfields.php:602 19 VirtueMartModelUserfields->getUserFields() JROOT/administrator/components/com_virtuemart/models/userfields.php:493 18 VirtueMartModelUserfields->getUserFieldsFor() JROOT/components/com_virtuemart/helpers/cart.php:263 17 VirtueMartCart->prepareAddressFieldsInCart() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:271 16 calculationHelper->setCountryState() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90 15 calculationHelper->__construct() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105 14 calculationHelper::getInstance() JROOT/components/com_virtuemart/helpers/cart.php:1551 13 VirtueMartCart->getCartPrices() JROOT/components/com_virtuemart/helpers/cart.php:1654 12 VirtueMartCart->prepareCartData() JROOT/components/com_virtuemart/helpers/cart.php:1779 11 VirtueMartCart->prepareAjaxData() JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:29 10 include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.60 ms After last query: 3.61 ms Query memory: 0.022 MB Memory before query: 31.433 MB Rows returned: 4
SELECT c.*
FROM vc_virtuemart_calcs as c
LEFT JOIN vc_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 <= "2021-06-21 06:10:31" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2021-06-21 06:10:31" )
AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)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 3 43.75 Using where Status Duration starting 0.11 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.14 ms init 0.04 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.08 ms preparing 0.02 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.05 ms cleaning up 0.02 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 17 JDatabaseDriver->loadAssocList() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:171 16 calculationHelper->setVendorId() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:91 15 calculationHelper->__construct() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105 14 calculationHelper::getInstance() JROOT/components/com_virtuemart/helpers/cart.php:1551 13 VirtueMartCart->getCartPrices() JROOT/components/com_virtuemart/helpers/cart.php:1654 12 VirtueMartCart->prepareCartData() JROOT/components/com_virtuemart/helpers/cart.php:1779 11 VirtueMartCart->prepareAjaxData() JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:29 10 include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.42 ms After last query: 0.15 ms Query memory: 0.021 MB Memory before query: 31.488 MB Rows returned: 0
SELECT *
FROM vc_virtuemart_calcs
LEFT JOIN vc_virtuemart_calc_shoppergroups using(virtuemart_calc_id)
WHERE `calc_kind`="DBTaxBill"
AND `published`="1"
AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2021-06-21 06:10:31" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2021-06-21 06:10:31" )
AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE vc_virtuemart_calc_shoppergroups NULL system virtuemart_calc_id NO INDEX KEY COULD BE USED NULL NULL 0 0.00 const row not found 1 SIMPLE vc_virtuemart_calcs NULL ref virtuemart_vendor_id,published,calc_kind,shared,publish_up,publish_down calc_kind 50 const 1 32.81 Using where Status Duration starting 0.09 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.04 ms System lock 0.01 ms optimizing 0.07 ms statistics 0.06 ms preparing 0.02 ms executing 0.01 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.01 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 16 JDatabaseDriver->loadAssocList() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1359 15 calculationHelper->gatherEffectingRulesForBill() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:750 14 calculationHelper->getCheckoutPrices() JROOT/components/com_virtuemart/helpers/cart.php:1555 13 VirtueMartCart->getCartPrices() JROOT/components/com_virtuemart/helpers/cart.php:1654 12 VirtueMartCart->prepareCartData() JROOT/components/com_virtuemart/helpers/cart.php:1779 11 VirtueMartCart->prepareAjaxData() JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:29 10 include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.42 ms After last query: 0.11 ms Query memory: 0.021 MB Memory before query: 31.511 MB Rows returned: 0
SELECT *
FROM vc_virtuemart_calcs
LEFT JOIN vc_virtuemart_calc_shoppergroups using(virtuemart_calc_id)
WHERE `calc_kind`="TaxBill"
AND `published`="1"
AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2021-06-21 06:10:31" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2021-06-21 06:10:31" )
AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE vc_virtuemart_calc_shoppergroups NULL system virtuemart_calc_id NO INDEX KEY COULD BE USED NULL NULL 0 0.00 const row not found 1 SIMPLE vc_virtuemart_calcs NULL ref virtuemart_vendor_id,published,calc_kind,shared,publish_up,publish_down calc_kind 50 const 1 32.81 Using where Status Duration starting 0.08 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.02 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 16 JDatabaseDriver->loadAssocList() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1359 15 calculationHelper->gatherEffectingRulesForBill() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:751 14 calculationHelper->getCheckoutPrices() JROOT/components/com_virtuemart/helpers/cart.php:1555 13 VirtueMartCart->getCartPrices() JROOT/components/com_virtuemart/helpers/cart.php:1654 12 VirtueMartCart->prepareCartData() JROOT/components/com_virtuemart/helpers/cart.php:1779 11 VirtueMartCart->prepareAjaxData() JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:29 10 include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.36 ms After last query: 0.09 ms Query memory: 0.021 MB Memory before query: 31.533 MB Rows returned: 0
SELECT *
FROM vc_virtuemart_calcs
LEFT JOIN vc_virtuemart_calc_shoppergroups using(virtuemart_calc_id)
WHERE `calc_kind`="DATaxBill"
AND `published`="1"
AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2021-06-21 06:10:31" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2021-06-21 06:10:31" )
AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE vc_virtuemart_calc_shoppergroups NULL system virtuemart_calc_id NO INDEX KEY COULD BE USED NULL NULL 0 0.00 const row not found 1 SIMPLE vc_virtuemart_calcs NULL ref virtuemart_vendor_id,published,calc_kind,shared,publish_up,publish_down calc_kind 50 const 1 32.81 Using where Status Duration starting 0.06 ms checking permissions 0.01 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 0.09 ms preparing 0.02 ms executing 0.01 ms Sending data 0.02 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 # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 16 JDatabaseDriver->loadAssocList() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1359 15 calculationHelper->gatherEffectingRulesForBill() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:752 14 calculationHelper->getCheckoutPrices() JROOT/components/com_virtuemart/helpers/cart.php:1555 13 VirtueMartCart->getCartPrices() JROOT/components/com_virtuemart/helpers/cart.php:1654 12 VirtueMartCart->prepareCartData() JROOT/components/com_virtuemart/helpers/cart.php:1779 11 VirtueMartCart->prepareAjaxData() JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:29 10 include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
34 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
3 × SELECT *
FROM vc_virtuemart_calcs
LEFT JOIN vc_virtuemart_calc_shoppergroups using(virtuemart_calc_id)2 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias
FROM vc_content AS a
LEFT JOIN vc_categories AS c
ON c.id = a.catid
LEFT JOIN vc_users AS ua
ON ua.id = a.created_by
LEFT JOIN vc_users AS uam
ON uam.id = a.modified_by
LEFT JOIN vc_categories as parent
ON parent.id = c.parent_id2 × SELECT *
FROM `vc_virtuemart_userfields`2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `vc_assets`2 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,( SELECT COUNT(i.`id`)
FROM `vc_content` AS `i`2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `vc_extensions`2 × SELECT COUNT(*)
FROM vc_content AS a
LEFT JOIN vc_categories AS c
ON c.id = a.catid
LEFT JOIN vc_users AS ua
ON ua.id = a.created_by
LEFT JOIN vc_users AS uam
ON uam.id = a.modified_by
LEFT JOIN vc_categories as parent
ON parent.id = c.parent_id1 × SELECT *
FROM `vc_menu`1 × SELECT `config`
FROM `vc_virtuemart_configs`1 × SELECT *
FROM `vc_virtuemart_shoppergroups`1 × SELECT *
FROM `vc_virtuemart_currencies` AS c
LEFT JOIN `vc_virtuemart_vendors` AS v
ON c.virtuemart_currency_id = v.vendor_currency1 × SELECT *
FROM `vc_virtuemart_countries`1 × SELECT c.*
FROM vc_virtuemart_calcs as c
LEFT JOIN vc_virtuemart_calc_shoppergroups as cs
ON cs.virtuemart_calc_id=c.virtuemart_calc_id1 × SELECT `fieldtitle`, `fieldvalue`
FROM `vc_virtuemart_userfield_values`1 × SELECT `vc_virtuemart_currencies`.*
FROM `vc_virtuemart_currencies`1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM vc_modules AS m
LEFT JOIN vc_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN vc_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT `vc_virtuemart_shoppergroups`.*
FROM `vc_virtuemart_shoppergroups`1 × SELECT `m`.`tag_id`,`t`.*
FROM `vc_contentitem_tag_map` AS m
INNER JOIN `vc_tags` AS t
ON `m`.`tag_id` = `t`.`id`1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM vc_extensions1 × SELECT b.id
FROM vc_usergroups AS a
LEFT JOIN vc_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT id, rules
FROM `vc_viewlevels1 × SELECT `session_id`
FROM `vc_session`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 vc_menu AS m
LEFT JOIN vc_extensions AS e
ON m.component_id = e.extension_id1 × SELECT *
FROM `vc_jdbuilder_configs`1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `vc_categories` AS `s`
INNER JOIN `vc_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)1 × SELECT `data`
FROM `vc_session`1 × SELECT id, home, template, s.params
FROM vc_template_styles as s
LEFT JOIN vc_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT *
FROM vc_languages1 × SELECT DISTINCT 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, g.note as group_note
FROM vc_fields AS a
LEFT JOIN `vc_languages` AS l
ON l.lang_code = a.language
LEFT JOIN vc_users AS uc
ON uc.id=a.checked_out
LEFT JOIN vc_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN vc_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN vc_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `vc_fields_categories` AS fc
ON fc.field_id = a.id
OTHER Tables:
1 × SHOW FULL COLUMNS
FROM `vc_virtuemart_userfields1 × UPDATE `vc_extensions`
SET `params` = '{\"mediaversion\":\"c599c051390a4b981aa137bb36ecf89e\"}'1 × SHOW TABLES LIKE "vc_virtuemart_configs
1 × UPDATE `vc_extensions`
SET `params` = '{\"mediaversion\":\"658e1764611746dc7751bb95a3e4a579\"}'1 × INSERT INTO `vc_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('t3bje0v587d5i77u9rnhq7quk3', 1, 1624255831, 0, '', 0