Bạn không có sản phẩm nào trong giỏ hàng của bạn.
Điện thoại: 0394969435
Dạ cẩm: 1000mg
Lá khôi: 1000mg
Chè dây: 800mg
Bạch linh: 800mg
Chỉ thực: 500mg
La bạc tử: 300mg
Cam thảo: 200mg
Hỗ trợ giảm acid dịch vị, bảo vệ niêm mạc dạ dày, giúp giảm viêm loét dạ dày - tá tràng
Người bị viêm loét dạ dày - tá tràng, trào ngược dạ dày thực quản với các biểu hiện: đầy bụng, ợ hơi, ợ chua, khó tiêu, đau thượng vị.
Thường dùng: Ngày 2-3 lần mỗi lần 2-4 viên, uống vào buổi sáng và buổi tối. Uống sau ăn 60 phút. Nên dùng liên tục để đạt hiệu quả cao Sau đó nên chuyển sang dùng duy trì.
Dùng duy trì: Ngày 2 viên, chia 2 lần, uống vào buổi sáng và buổi tối. Uống sau ăn 15-30 phút. Nên dùng duy trì từ 2-3 tháng để có hiệu quả tốt
Bảo quản: nơi khô ráo, thoáng mát, tránh nguồn nhiệt, tránh ánh sáng trực tiếp
KLTB viên: 480mg
Tiêu chuẩn: TCCS
Số ĐKSP: 5355/2019/ĐKSP
Mã vạch: 8938528383003
Sản xuất tại: Công ty TNHH Dược phẩm Smard
Công ty chịu trách nhiệm về chất lượng sản phẩm: Công ty TNHH thương mại và y dược Bảo An
Lưu ý: thực phẩm này không phải là thuốc không có tác dụng thay thế thuốc chữa bệnh, không dùng cho người mẫn cảm với bất kỳ thành phần nào của sản phẩm.
Hạn chế uống rượu bia, chất kích thích, hút thuốc lá, ăn đồ cay chua nóng, thức khuya.
-----------------------------------------------------------------
Dạ cẩm: Dạ cẩm giúp giảm đau dạ dày (Do trung hoà được lượng axit trong dạ dày)
Tác dụng hỗ trợ điều trị viêm dạ dày (bớt ợ chua, giúp liền vết loét), Điều trị loét mồm, loét lưỡi do viêm nhiễm hoặc do nhiệt
Lá khôi: Điều trị đau dạ dày, viêm loét dạ dày, hành tá tràng, Tác dụng trung hòa, làm giảm tiết acid dịch vị trong dạ dày, Phục hồi viêm loét bên trong dạ dày, giúp vết viêm dạ dày sớm liền
Chè dây: Chè dây có nhiều công dụng, nhưng tác dụng chính của vị thuốc này là hiệu quả tiêu viêm giải độc. Sử dụng hiệu quả nhất trong điều trị chứng viêm loét dạ dày, đầy hơi, ăn uống khó tiêu, trào ngược dạ dày. Dưới đây là những tác dụng chính của vị thuốc này:
+ Giảm ợ hơi, ợ chua, đau rát thượng vị
+ Giảm trào ngược dạ dày
+ Hỗ trợ điều trị viêm loét dạ dày
+ Tăng cường chức năng hệ tiêu hóa
+ Tác dụng giải độc trong cơ thể
+ Tác dụng an thần, điều trị mất ngủ
+ Tác dụng ổn định huyết áp, điều trị huyết áp cao.
Chè dây có tác dụng diệt vi trùng, vi khuẩn, giảm độ axit tại dạ dày, giúp cho bệnh viêm loét dạ dày tá tràng dễ liền sẹo; cắt cơn đau do viêm loét hành tá tràng đạt 93,4%, với Alusi (loại thuốc chuyên trị bệnh viêm loét hành tá tràng hiện nay) là 89%, thời gian cắt cơn đau trung bình của chè Dây từ 8 đến 9 ngày, và Alusi là 17 ngày.
Theo kinh nghiệm dân gian chè dây có giá trị về mặt dược liệu rất quý; giúp tiêu hoá tốt, dễ ngủ, những người bị bệnh viêm loét dạ dày tá tràng, uống một thời gian dài thấy bệnh đỡ dần và hết đau.
Cao chè dây không gây ngộ độc cấp tính, không ảnh hưởng tới các chỉ tiêu hóa sinh, huyết học, cổ truyền và sinh sản khi dùng thuốc trong thời gian dài. Các nghiên cứu trên lâm sàng cũng đều cho thấy chè dây không thấy có các tác dụng phụ như đầy bụng, nôn mửa hoặc khó chịu, mệt mỏi, nhức đầu hoặc các biểu hiện dị ứng.
Giai đoạn 1 Kháng viêm giảm đau: Hỗ trợ ức chế và hỗ trợ kháng khuẩn HP nguyên nhân chính gây bệnh và gây ung thư. Tăng cường sự tiết dịch nhầy bảo vệ lớp niêm mạc của dạ dày. Kháng viêm giảm đau đào thải màng viêm ra ngoài theo đường tiêu hóa
Giai đoạn 2 Làm lành: Các tinh chất thẩm thấu vào thành dạ dày, hỗ trợ làm lành các ổ viêm, liền các vết loét. Cân bằng dịch vị acid. Thanh lọc làm sạch dạ dày.
Giai đoạn 3 Hỗ trợ phục hồi và ngăn ngừa tái phát: Hỗ trợ phục hồi và tái tạo lại lớp niêm mạc, dạ dày khỏe mạnh và hoạt động ổn định trở lại. Hỗ trợ giải độc gan mật, Ngoài ra giúp ăn ngon, ngủ tốt, bổ tỳ cơ thể. Tăng sức đề kháng và hỗ trợ ngăn ngừa bệnh tái phát.
Hầu hết các khách hàng chỉ cần sử dụng Dạ dày Bảo an đều phản hổi bệnh thuyên giảm rõ rệt, kiên trì sử dụng hết 1 liệu trình là đã có thể thấy các biểu hiện khó chịu giảm hẳn. Một số rất nhỏ khách hàng bị nặng phải sử dụng kéo dài theo chỉ định của chúng tôi và tất cả đều cho kết quả tích cực.
+ Được sản xuất tại nhà máy đạt chuẩn GMP với quy trình sản xuất nghiêm ngặt, tỉ mỉ.
+ SP đã được Bộ Y tế cấp chứng nhận lưu hành số: 5355/2019/ĐKSP
+ Sản phẩm có nguồn gốc thảo dược thiên nhiên đảm bảo an toàn
+ Sản phẩm được bào chế thành dạng viên con nhọng dễ sử dụng tiện lợi khi bảo quản
70% người Việt Nam mắc các bệnh về Dạ Dày. Hơn một nửa số đó là Trào Ngược Dạ Dày, Viêm Hang Vị Dạ Dày, Nhiễm Cầu Khuẩn HP. Nhiều ca chủ quan không điều trị hoặc điều trị sai phương pháp dẫn đến số trường hợp mắc mới ung thư tăng nhanh từ 68.000 ca năm 2000 lên 126.000 năm 2010, và dự kiến vượt qua 190.000 ca vào 2020. Chủ yếu là Biến Chứng Từ Thủng Dạ Dày, Xuất Huyết Dạ Dày dẫn đến Ung Thư Dạ Dày...
Ước tính 70% người trưởng thành ở Việt nam nhiễm khuẩn HP và nếu không hỗ trợ điều trị dứt khuẩn thì dẫn đến 20% sẽ bị viêm loét dạ dày và khoảng 2% trong đó có khả năng sẽ bị ung thư dạ dày.
Cụ thể là 90% số người bị viêm dạ dày có sự hiện diện của vi khuẩn HP. Tương tự, tỉ lệ này chiếm 75%-85% trong bệnh loét dạ dày-tá tràng; còn trong biến chứng thủng do loét dạ dày-tá tràng thì sự hiện diện của HP chiếm 80%-95% trường hợp.
Điều tồi tệ cho chúng ta là thường khuẩn HP lây nhiễm trong cả gia đình...đó là lý do rất nhiều trường hợp cả vợ chồng và con cái đều có triệu chứng đau dạ dày.
Chính xác bệnh dạ dày không lây nhưng vi khuẩn HP gây ra bệnh dạ dày lại lây từ người này sang người khác. Khuẩn HP có trong nước bọt, trong mãng cao răng hay trong niêm mạc dạ dày...nên với tập quán ăn chung bát, chung nước chấm...là cơ hội tuyệt vời để khuẩn HP phát tán cho người thân của mình.
Thủ phạm khuẩn HP gây đau dạ dày và nguy hiểm cần loại bỏ ngay.
Các bệnh nhân dùng nhiều rượu bia, stress tinh thần sẽ điều trị càng khó khăn hơn và bệnh viêm loét dạ dày tá tràng sẽ tái đi tái lại nhiều lần. Như vậy thì các vết thương ngày càng bị tổn thương sâu hơn, qua thời gian sẽ làm teo, sơ các niêm mạc dạ dày và thay thế bằng các tế bào ruột hay còn gọi là dị sản ruột và đây chính là nguyên nhân ung thư dạ dày tá tràng ở các bệnh nhân có dương tính với
- Mua từ 3 hộp giá 200k/1 hộp miễn phí vận chuyển khu vực Hà Nội
- Mua Từ 5 hộp giá 180k/1hộp miễn phí vận chuyển toàn quốc
- Mua từ 10 hộp hoặc cộng dồn cho khách hàng đang dùng sản phẩm 170k
Hỗ trợ trong suốt quá trình sử dụng, Thanh toán khi nhận sản phẩm
Điện thoại: 0394969435
Fax: 0394969435
Website:thuocnamvietnam.com.vn
![]() | Hôm nay | 58 |
![]() | Hôm qua | 72 |
![]() | Tuần | 111 |
![]() | Tháng | 1291 |
![]() | Tổng | 220909 |
{ "__default": { "session": { "counter": 1, "timer": { "start": 1611057587, "last": 1611057587, "now": 1611057587 }, "client": { "forwarded": "54.208.73.179" }, "token": "IIyh28Ccx4RMkNCwuYi3CRW2dNAH8mkY" }, "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 }, "js_id_currency_orig": "1", "js_id_currency": "1", "js_history_sel_lang": "vi-VN", "js_prev_user_id": 0, "jshop_checked_language": [ "en-GB", "vi-VN" ], "jshop_end_page_buy_product": "\/thuc-pham-bao-ve-suc-khoe\/product\/view\/143\/509.html", "product_back_value": [] } }
SELECT `data`
FROM `veneno_session`
WHERE `session_id` = 'uqc52hkfvolmkb7vde8dplaie1'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | veneno_session | const | PRIMARY | PRIMARY | 766 | const | 1 |
# | Caller | File and line number |
---|---|---|
16 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
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:755 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:134 |
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:343 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
SELECT `session_id`
FROM `veneno_session`
WHERE `session_id` = 'uqc52hkfvolmkb7vde8dplaie1'
LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | veneno_session | const | PRIMARY | PRIMARY | 766 | const | 1 | Using index |
# | Caller | File and line number |
---|---|---|
9 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
8 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Session/MetadataManager.php:74 |
7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:152 |
6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:757 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:134 |
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:343 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
INSERT INTO `veneno_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('uqc52hkfvolmkb7vde8dplaie1', 1, '1611057587', 0, '', 0)
# | Caller | File and line number |
---|---|---|
8 | JDatabaseDriverMysql->execute() | JROOT/libraries/src/Session/MetadataManager.php:116 |
7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:152 |
6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:757 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:134 |
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:343 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `veneno_extensions`
WHERE `type` = 'component'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | veneno_extensions | ref | extension | extension | 82 | const | 36 | Using index condition |
# | Caller | File and line number |
---|---|---|
12 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Component/ComponentHelper.php:423 |
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:431 |
7 | Joomla\CMS\Component\ComponentHelper::load() | JROOT/libraries/src/Component/ComponentHelper.php:497 |
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:596 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT id, rules
FROM `veneno_viewlevels`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | veneno_viewlevels | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 5 |
# | Caller | File and line number |
---|---|---|
10 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1496 |
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:310 |
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:606 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT b.id
FROM veneno_usergroups AS a
LEFT JOIN veneno_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | b | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 2 | Using where |
# | Caller | File and line number |
---|---|---|
11 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1540 |
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:310 |
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:606 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM veneno_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1)
ORDER BY ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | veneno_extensions | ref | extension | extension | 82 | const | 111 | Using index condition; Using where; Using filesort |
# | Caller | File and line number |
---|---|---|
11 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Plugin/PluginHelper.php:343 |
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:348 |
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:606 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `veneno_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | veneno_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | Using index condition |
# | Caller | File and line number |
---|---|---|
18 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
17 | JDatabaseDriver->loadObject() | JROOT/libraries/src/Helper/LibraryHelper.php:167 |
16 | Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() | Same as call in the line below. |
15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/LibraryHelper.php:175 |
13 | Joomla\CMS\Helper\LibraryHelper::loadLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:43 |
12 | Joomla\CMS\Helper\LibraryHelper::getLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:90 |
11 | Joomla\CMS\Helper\LibraryHelper::getParams() | JROOT/libraries/src/Version.php:321 |
10 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
9 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
8 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/backup/backup.php:4 |
7 | require_once JROOT/plugins/system/backup/backup.php | JROOT/libraries/src/Plugin/PluginHelper.php:253 |
6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:622 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:688 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
UPDATE `veneno_extensions`
SET `params` = '{\"mediaversion\":\"2dc350ae4fd49e3febe412e60f600208\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
# | Caller | File and line number |
---|---|---|
13 | JDatabaseDriverMysql->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 |
12 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 |
11 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 |
10 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
9 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
8 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/backup/backup.php:4 |
7 | require_once JROOT/plugins/system/backup/backup.php | JROOT/libraries/src/Plugin/PluginHelper.php:253 |
6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:622 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:688 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
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 veneno_menu AS m
LEFT JOIN veneno_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 172 | Using index condition; Using where; Using filesort |
1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | duocphaph_1.m.component_id | 1 | Using where |
# | Caller | File and line number |
---|---|---|
26 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
25 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Menu/SiteMenu.php:93 |
24 | Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() | Same as call in the line below. |
23 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
22 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Menu/SiteMenu.php:101 |
21 | Joomla\CMS\Menu\SiteMenu->load() | JROOT/libraries/src/Menu/AbstractMenu.php:76 |
20 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT/libraries/src/Menu/SiteMenu.php:62 |
19 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT/libraries/src/Menu/AbstractMenu.php:131 |
18 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:374 |
17 | Joomla\CMS\Application\CMSApplication->getMenu() | JROOT/libraries/src/Application/SiteApplication.php:275 |
16 | Joomla\CMS\Application\SiteApplication->getMenu() | JROOT/libraries/src/Application/SiteApplication.php:436 |
15 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT/plugins/system/helix/core/helix.php:65 |
14 | Helix::themeName() | JROOT/plugins/system/helix/core/helix.php:114 |
13 | Helix::themePath() | JROOT/plugins/system/helix/core/helix.php:302 |
12 | Helix::_Import() | JROOT/plugins/system/helix/core/helix.php:290 |
11 | Helix::Import() | JROOT/plugins/system/helix/core/helix.php:1592 |
10 | Helix::loadHelixOverwrite() | JROOT/plugins/system/helix/helix.php:22 |
9 | plgSystemHelix->onAfterInitialise() | Same as call in the line below. |
8 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:623 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:688 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT id, home, template, s.params
FROM veneno_template_styles as s
LEFT JOIN veneno_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | extension | 82 | const | 5 | Using index condition; Using where |
1 | SIMPLE | s | ALL | idx_template | NO INDEX KEY COULD BE USED | NULL | NULL | 5 | Using where; Using join buffer (flat, BNL join) |
# | Caller | File and line number |
---|---|---|
17 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Application/SiteApplication.php:488 |
15 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT/plugins/system/helix/core/helix.php:65 |
14 | Helix::themeName() | JROOT/plugins/system/helix/core/helix.php:114 |
13 | Helix::themePath() | JROOT/plugins/system/helix/core/helix.php:302 |
12 | Helix::_Import() | JROOT/plugins/system/helix/core/helix.php:290 |
11 | Helix::Import() | JROOT/plugins/system/helix/core/helix.php:1592 |
10 | Helix::loadHelixOverwrite() | JROOT/plugins/system/helix/helix.php:22 |
9 | plgSystemHelix->onAfterInitialise() | Same as call in the line below. |
8 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:623 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:688 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SHOW FULL COLUMNS
FROM `veneno_jshopping_config`
# | Caller | File and line number |
---|---|---|
20 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:430 |
18 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
17 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
16 | Joomla\CMS\Table\Table->__construct() | JROOT/components/com_jshopping/tables/config.php:14 |
15 | jshopConfig->__construct() | JROOT/components/com_jshopping/lib/factory.php:24 |
14 | JSFactory::getConfig() | JROOT/components/com_jshopping/lib/factory.php:143 |
13 | JSFactory::reloadConfigFieldTLF() | JROOT/components/com_jshopping/lib/factory.php:166 |
12 | JSFactory::loadLanguageFile() | JROOT/components/com_jshopping/lib/functions.php:1546 |
11 | initLoadJoomshoppingLanguageFile() | JROOT/components/com_jshopping/router.php:210 |
10 | jshoppingParseRoute() | JROOT/libraries/src/Component/Router/RouterLegacy.php:105 |
9 | Joomla\CMS\Component\Router\RouterLegacy->parse() | JROOT/libraries/src/Router/SiteRouter.php:437 |
8 | Joomla\CMS\Router\SiteRouter->parseSefRoute() | JROOT/libraries/src/Router/Router.php:482 |
7 | Joomla\CMS\Router\Router->_parseSefRoute() | JROOT/libraries/src/Router/Router.php:227 |
6 | Joomla\CMS\Router\Router->parse() | JROOT/libraries/src/Router/SiteRouter.php:138 |
5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1071 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:798 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM veneno_jshopping_config
WHERE `id` = '1'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | veneno_jshopping_config | system | PRIMARY | NO INDEX KEY COULD BE USED | NULL | NULL | 1 |
# | Caller | File and line number |
---|---|---|
17 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1455 |
16 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:731 |
15 | Joomla\CMS\Table\Table->load() | JROOT/components/com_jshopping/lib/factory.php:30 |
14 | JSFactory::getConfig() | JROOT/components/com_jshopping/lib/factory.php:143 |
13 | JSFactory::reloadConfigFieldTLF() | JROOT/components/com_jshopping/lib/factory.php:166 |
12 | JSFactory::loadLanguageFile() | JROOT/components/com_jshopping/lib/functions.php:1546 |
11 | initLoadJoomshoppingLanguageFile() | JROOT/components/com_jshopping/router.php:210 |
10 | jshoppingParseRoute() | JROOT/libraries/src/Component/Router/RouterLegacy.php:105 |
9 | Joomla\CMS\Component\Router\RouterLegacy->parse() | JROOT/libraries/src/Router/SiteRouter.php:437 |
8 | Joomla\CMS\Router\SiteRouter->parseSefRoute() | JROOT/libraries/src/Router/Router.php:482 |
7 | Joomla\CMS\Router\Router->_parseSefRoute() | JROOT/libraries/src/Router/Router.php:227 |
6 | Joomla\CMS\Router\Router->parse() | JROOT/libraries/src/Router/SiteRouter.php:138 |
5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1071 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:798 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SHOW FULL COLUMNS
FROM `veneno_jshopping_currencies`
# | Caller | File and line number |
---|---|---|
24 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
23 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:430 |
22 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
21 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
20 | Joomla\CMS\Table\Table->__construct() | JROOT/components/com_jshopping/tables/currency.php:14 |
19 | jshopCurrency->__construct() | JROOT/libraries/src/Table/Table.php:312 |
18 | Joomla\CMS\Table\Table::getInstance() | JROOT/components/com_jshopping/lib/factory.php:600 |
17 | JSFactory::getTable() | JROOT/components/com_jshopping/lib/factory.php:548 |
16 | JSFactory::getAllCurrency() | JROOT/components/com_jshopping/tables/config.php:53 |
15 | jshopConfig->loadCurrencyValue() | JROOT/components/com_jshopping/lib/factory.php:32 |
14 | JSFactory::getConfig() | JROOT/components/com_jshopping/lib/factory.php:143 |
13 | JSFactory::reloadConfigFieldTLF() | JROOT/components/com_jshopping/lib/factory.php:166 |
12 | JSFactory::loadLanguageFile() | JROOT/components/com_jshopping/lib/functions.php:1546 |
11 | initLoadJoomshoppingLanguageFile() | JROOT/components/com_jshopping/router.php:210 |
10 | jshoppingParseRoute() | JROOT/libraries/src/Component/Router/RouterLegacy.php:105 |
9 | Joomla\CMS\Component\Router\RouterLegacy->parse() | JROOT/libraries/src/Router/SiteRouter.php:437 |
8 | Joomla\CMS\Router\SiteRouter->parseSefRoute() | JROOT/libraries/src/Router/Router.php:482 |
7 | Joomla\CMS\Router\Router->_parseSefRoute() | JROOT/libraries/src/Router/Router.php:227 |
6 | Joomla\CMS\Router\Router->parse() | JROOT/libraries/src/Router/SiteRouter.php:138 |
5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1071 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:798 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value
FROM `veneno_jshopping_currencies`
WHERE currency_publish = '1'
ORDER BY currency_ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | veneno_jshopping_currencies | system | currency_publish | NO INDEX KEY COULD BE USED | NULL | NULL | 1 |
# | Caller | File and line number |
---|---|---|
19 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
18 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jshopping/tables/currency.php:22 |
17 | jshopCurrency->getAllCurrencies() | JROOT/components/com_jshopping/lib/factory.php:549 |
16 | JSFactory::getAllCurrency() | JROOT/components/com_jshopping/tables/config.php:53 |
15 | jshopConfig->loadCurrencyValue() | JROOT/components/com_jshopping/lib/factory.php:32 |
14 | JSFactory::getConfig() | JROOT/components/com_jshopping/lib/factory.php:143 |
13 | JSFactory::reloadConfigFieldTLF() | JROOT/components/com_jshopping/lib/factory.php:166 |
12 | JSFactory::loadLanguageFile() | JROOT/components/com_jshopping/lib/functions.php:1546 |
11 | initLoadJoomshoppingLanguageFile() | JROOT/components/com_jshopping/router.php:210 |
10 | jshoppingParseRoute() | JROOT/libraries/src/Component/Router/RouterLegacy.php:105 |
9 | Joomla\CMS\Component\Router\RouterLegacy->parse() | JROOT/libraries/src/Router/SiteRouter.php:437 |
8 | Joomla\CMS\Router\SiteRouter->parseSefRoute() | JROOT/libraries/src/Router/Router.php:482 |
7 | Joomla\CMS\Router\Router->_parseSefRoute() | JROOT/libraries/src/Router/Router.php:227 |
6 | Joomla\CMS\Router\Router->parse() | JROOT/libraries/src/Router/SiteRouter.php:138 |
5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1071 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:798 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SHOW FULL COLUMNS
FROM `veneno_jshopping_users`
# | Caller | File and line number |
---|---|---|
24 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
23 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:430 |
22 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
21 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
20 | Joomla\CMS\Table\Table->__construct() | JROOT/components/com_jshopping/tables/usershopbase.php:14 |
19 | jshopUserShopBase->__construct() | JROOT/components/com_jshopping/tables/usershop.php:15 |
18 | jshopUserShop->__construct() | JROOT/components/com_jshopping/lib/factory.php:47 |
17 | JSFactory::getUserShop() | JROOT/components/com_jshopping/tables/config.php:67 |
16 | jshopConfig->getDisplayPriceFront() | JROOT/components/com_jshopping/tables/config.php:288 |
15 | jshopConfig->parseConfigVars() | JROOT/components/com_jshopping/lib/factory.php:35 |
14 | JSFactory::getConfig() | JROOT/components/com_jshopping/lib/factory.php:143 |
13 | JSFactory::reloadConfigFieldTLF() | JROOT/components/com_jshopping/lib/factory.php:166 |
12 | JSFactory::loadLanguageFile() | JROOT/components/com_jshopping/lib/functions.php:1546 |
11 | initLoadJoomshoppingLanguageFile() | JROOT/components/com_jshopping/router.php:210 |
10 | jshoppingParseRoute() | JROOT/libraries/src/Component/Router/RouterLegacy.php:105 |
9 | Joomla\CMS\Component\Router\RouterLegacy->parse() | JROOT/libraries/src/Router/SiteRouter.php:437 |
8 | Joomla\CMS\Router\SiteRouter->parseSefRoute() | JROOT/libraries/src/Router/Router.php:482 |
7 | Joomla\CMS\Router\Router->_parseSefRoute() | JROOT/libraries/src/Router/Router.php:227 |
6 | Joomla\CMS\Router\Router->parse() | JROOT/libraries/src/Router/SiteRouter.php:138 |
5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1071 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:798 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SHOW FULL COLUMNS
FROM `veneno_jshopping_users`
# | Caller | File and line number |
---|---|---|
24 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
23 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:430 |
22 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
21 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
20 | Joomla\CMS\Table\Table->__construct() | JROOT/components/com_jshopping/tables/usershopbase.php:14 |
19 | jshopUserShopBase->__construct() | JROOT/components/com_jshopping/models/userguest.php:16 |
18 | jshopUserGust->__construct() | JROOT/components/com_jshopping/lib/factory.php:66 |
17 | JSFactory::getUserShopGuest() | JROOT/components/com_jshopping/tables/config.php:71 |
16 | jshopConfig->getDisplayPriceFront() | JROOT/components/com_jshopping/tables/config.php:288 |
15 | jshopConfig->parseConfigVars() | JROOT/components/com_jshopping/lib/factory.php:35 |
14 | JSFactory::getConfig() | JROOT/components/com_jshopping/lib/factory.php:143 |
13 | JSFactory::reloadConfigFieldTLF() | JROOT/components/com_jshopping/lib/factory.php:166 |
12 | JSFactory::loadLanguageFile() | JROOT/components/com_jshopping/lib/functions.php:1546 |
11 | initLoadJoomshoppingLanguageFile() | JROOT/components/com_jshopping/router.php:210 |
10 | jshoppingParseRoute() | JROOT/libraries/src/Component/Router/RouterLegacy.php:105 |
9 | Joomla\CMS\Component\Router\RouterLegacy->parse() | JROOT/libraries/src/Router/SiteRouter.php:437 |
8 | Joomla\CMS\Router\SiteRouter->parseSefRoute() | JROOT/libraries/src/Router/Router.php:482 |
7 | Joomla\CMS\Router\Router->_parseSefRoute() | JROOT/libraries/src/Router/Router.php:227 |
6 | Joomla\CMS\Router\Router->parse() | JROOT/libraries/src/Router/SiteRouter.php:138 |
5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1071 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:798 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SHOW FULL COLUMNS
FROM `veneno_jshopping_usergroups`
# | Caller | File and line number |
---|---|---|
26 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
25 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:430 |
24 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
23 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
22 | Joomla\CMS\Table\Table->__construct() | JROOT/components/com_jshopping/tables/usergroup.php:14 |
21 | jshopUserGroup->__construct() | JROOT/libraries/src/Table/Table.php:312 |
20 | Joomla\CMS\Table\Table::getInstance() | JROOT/components/com_jshopping/lib/factory.php:600 |
19 | JSFactory::getTable() | JROOT/components/com_jshopping/models/userguest.php:30 |
18 | jshopUserGust->load() | JROOT/components/com_jshopping/lib/factory.php:67 |
17 | JSFactory::getUserShopGuest() | JROOT/components/com_jshopping/tables/config.php:71 |
16 | jshopConfig->getDisplayPriceFront() | JROOT/components/com_jshopping/tables/config.php:288 |
15 | jshopConfig->parseConfigVars() | JROOT/components/com_jshopping/lib/factory.php:35 |
14 | JSFactory::getConfig() | JROOT/components/com_jshopping/lib/factory.php:143 |
13 | JSFactory::reloadConfigFieldTLF() | JROOT/components/com_jshopping/lib/factory.php:166 |
12 | JSFactory::loadLanguageFile() | JROOT/components/com_jshopping/lib/functions.php:1546 |
11 | initLoadJoomshoppingLanguageFile() | JROOT/components/com_jshopping/router.php:210 |
10 | jshoppingParseRoute() | JROOT/libraries/src/Component/Router/RouterLegacy.php:105 |
9 | Joomla\CMS\Component\Router\RouterLegacy->parse() | JROOT/libraries/src/Router/SiteRouter.php:437 |
8 | Joomla\CMS\Router\SiteRouter->parseSefRoute() | JROOT/libraries/src/Router/Router.php:482 |
7 | Joomla\CMS\Router\Router->_parseSefRoute() | JROOT/libraries/src/Router/Router.php:227 |
6 | Joomla\CMS\Router\Router->parse() | JROOT/libraries/src/Router/SiteRouter.php:138 |
5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1071 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:798 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SHOW FULL COLUMNS
FROM `veneno_jshopping_config_display_prices`
# | Caller | File and line number |
---|---|---|
24 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
23 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:430 |
22 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
21 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
20 | Joomla\CMS\Table\Table->__construct() | JROOT/components/com_jshopping/tables/configdisplayprice.php:19 |
19 | jshopConfigDisplayPrice->__construct() | JROOT/libraries/src/Table/Table.php:312 |
18 | Joomla\CMS\Table\Table::getInstance() | JROOT/components/com_jshopping/lib/factory.php:600 |
17 | JSFactory::getTable() | JROOT/components/com_jshopping/tables/config.php:79 |
16 | jshopConfig->getDisplayPriceFront() | JROOT/components/com_jshopping/tables/config.php:288 |
15 | jshopConfig->parseConfigVars() | JROOT/components/com_jshopping/lib/factory.php:35 |
14 | JSFactory::getConfig() | JROOT/components/com_jshopping/lib/factory.php:143 |
13 | JSFactory::reloadConfigFieldTLF() | JROOT/components/com_jshopping/lib/factory.php:166 |
12 | JSFactory::loadLanguageFile() | JROOT/components/com_jshopping/lib/functions.php:1546 |
11 | initLoadJoomshoppingLanguageFile() | JROOT/components/com_jshopping/router.php:210 |
10 | jshoppingParseRoute() | JROOT/libraries/src/Component/Router/RouterLegacy.php:105 |
9 | Joomla\CMS\Component\Router\RouterLegacy->parse() | JROOT/libraries/src/Router/SiteRouter.php:437 |
8 | Joomla\CMS\Router\SiteRouter->parseSefRoute() | JROOT/libraries/src/Router/Router.php:482 |
7 | Joomla\CMS\Router\Router->_parseSefRoute() | JROOT/libraries/src/Router/Router.php:227 |
6 | Joomla\CMS\Router\Router->parse() | JROOT/libraries/src/Router/SiteRouter.php:138 |
5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1071 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:798 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM `veneno_jshopping_config_display_prices`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | veneno_jshopping_config_display_prices | system | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 |
# | Caller | File and line number |
---|---|---|
19 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
18 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jshopping/tables/configdisplayprice.php:38 |
17 | jshopConfigDisplayPrice->getList() | JROOT/components/com_jshopping/tables/config.php:80 |
16 | jshopConfig->getDisplayPriceFront() | JROOT/components/com_jshopping/tables/config.php:288 |
15 | jshopConfig->parseConfigVars() | JROOT/components/com_jshopping/lib/factory.php:35 |
14 | JSFactory::getConfig() | JROOT/components/com_jshopping/lib/factory.php:143 |
13 | JSFactory::reloadConfigFieldTLF() | JROOT/components/com_jshopping/lib/factory.php:166 |
12 | JSFactory::loadLanguageFile() | JROOT/components/com_jshopping/lib/functions.php:1546 |
11 | initLoadJoomshoppingLanguageFile() | JROOT/components/com_jshopping/router.php:210 |
10 | jshoppingParseRoute() | JROOT/libraries/src/Component/Router/RouterLegacy.php:105 |
9 | Joomla\CMS\Component\Router\RouterLegacy->parse() | JROOT/libraries/src/Router/SiteRouter.php:437 |
8 | Joomla\CMS\Router\SiteRouter->parseSefRoute() | JROOT/libraries/src/Router/Router.php:482 |
7 | Joomla\CMS\Router\Router->_parseSefRoute() | JROOT/libraries/src/Router/Router.php:227 |
6 | Joomla\CMS\Router\Router->parse() | JROOT/libraries/src/Router/SiteRouter.php:138 |
5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1071 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:798 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
select product_id as id, `alias_vi-VN` as alias
from veneno_jshopping_products
where `alias_vi-VN`!=''
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | veneno_jshopping_products | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 65 | Using where |
# | Caller | File and line number |
---|---|---|
17 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
16 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jshopping/lib/factory.php:276 |
15 | JSFactory::getAliasProduct() | JROOT/plugins/jshoppingrouter/jshopping_product_seo/jshopping_product_seo.php:42 |
14 | plgJshoppingRouterJshopping_product_seo->onBeforeParseRoute() | 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_jshopping/router.php:216 |
10 | jshoppingParseRoute() | JROOT/libraries/src/Component/Router/RouterLegacy.php:105 |
9 | Joomla\CMS\Component\Router\RouterLegacy->parse() | JROOT/libraries/src/Router/SiteRouter.php:437 |
8 | Joomla\CMS\Router\SiteRouter->parseSefRoute() | JROOT/libraries/src/Router/Router.php:482 |
7 | Joomla\CMS\Router\Router->_parseSefRoute() | JROOT/libraries/src/Router/Router.php:227 |
6 | Joomla\CMS\Router\Router->parse() | JROOT/libraries/src/Router/SiteRouter.php:138 |
5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1071 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:798 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM veneno_languages
WHERE published=1
ORDER BY ordering ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | veneno_languages | system | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 |
# | Caller | File and line number |
---|---|---|
7 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
select *
from veneno_jshopping_languages
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | veneno_jshopping_languages | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 2 |
# | Caller | File and line number |
---|---|---|
10 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
9 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jshopping/lib/functions.php:281 |
8 | installNewLanguages() | JROOT/components/com_jshopping/loadparams.php:32 |
7 | require JROOT/components/com_jshopping/loadparams.php | JROOT/components/com_jshopping/jshopping.php:16 |
6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SHOW FULL COLUMNS
FROM `veneno_jshopping_products`
# | Caller | File and line number |
---|---|---|
16 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:430 |
14 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
13 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
12 | Joomla\CMS\Table\Table->__construct() | JROOT/components/com_jshopping/tables/product.php:15 |
11 | jshopProduct->__construct() | JROOT/libraries/src/Table/Table.php:312 |
10 | Joomla\CMS\Table\Table::getInstance() | JROOT/components/com_jshopping/lib/factory.php:600 |
9 | JSFactory::getTable() | JROOT/components/com_jshopping/controllers/product.php:44 |
8 | JshoppingControllerProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jshopping/jshopping.php:25 |
6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM veneno_jshopping_products
WHERE `product_id` = '509'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | veneno_jshopping_products | const | PRIMARY | PRIMARY | 4 | const | 1 |
# | Caller | File and line number |
---|---|---|
11 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1455 |
10 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:731 |
9 | Joomla\CMS\Table\Table->load() | JROOT/components/com_jshopping/controllers/product.php:45 |
8 | JshoppingControllerProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jshopping/jshopping.php:25 |
6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SHOW FULL COLUMNS
FROM `veneno_jshopping_categories`
# | Caller | File and line number |
---|---|---|
16 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:430 |
14 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
13 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
12 | Joomla\CMS\Table\Table->__construct() | JROOT/components/com_jshopping/tables/category.php:15 |
11 | jshopCategory->__construct() | JROOT/libraries/src/Table/Table.php:312 |
10 | Joomla\CMS\Table\Table::getInstance() | JROOT/components/com_jshopping/lib/factory.php:600 |
9 | JSFactory::getTable() | JROOT/components/com_jshopping/controllers/product.php:47 |
8 | JshoppingControllerProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jshopping/jshopping.php:25 |
6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM veneno_jshopping_categories
WHERE `category_id` = '143'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | veneno_jshopping_categories | const | PRIMARY | PRIMARY | 4 | const | 1 |
# | Caller | File and line number |
---|---|---|
11 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1455 |
10 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:731 |
9 | Joomla\CMS\Table\Table->load() | JROOT/components/com_jshopping/controllers/product.php:48 |
8 | JshoppingControllerProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jshopping/jshopping.php:25 |
6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM `veneno_jshopping_products_to_categories`
WHERE product_id='509'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | veneno_jshopping_products_to_categories | ref | PRIMARY,product_id,product_id_2 | product_id_2 | 4 | const | 1 | Using index |
# | Caller | File and line number |
---|---|---|
12 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
11 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jshopping/tables/product.php:253 |
10 | jshopProduct->getCategories() | JROOT/components/com_jshopping/models/productshop.php:79 |
9 | jshopProductShop->getCategories() | JROOT/components/com_jshopping/controllers/product.php:53 |
8 | JshoppingControllerProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jshopping/jshopping.php:25 |
6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT prod.product_id, pr_cat.category_id, prod.`name_vi-VN` as name, prod.`short_description_vi-VN` as short_description, prod.product_ean, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices
FROM `veneno_jshopping_products_relations` AS relation
INNER JOIN `veneno_jshopping_products` AS prod
ON relation.product_related_id = prod.product_id
LEFT JOIN `veneno_jshopping_products_to_categories` AS pr_cat
ON pr_cat.product_id = relation.product_related_id
LEFT JOIN `veneno_jshopping_categories` AS cat
ON pr_cat.category_id = cat.category_id
WHERE relation.product_id = '509'
AND cat.category_publish='1'
AND prod.product_publish = '1'
AND prod.access IN (1,1)
AND cat.access IN (1,1)
group by prod.product_id
order by relation.id
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | relation | ref | product_id,product_id_2,product_related_id | product_id | 4 | const | 1 | Using where; Using temporary; Using filesort |
1 | SIMPLE | prod | eq_ref | PRIMARY,product_publish,access | PRIMARY | 4 | duocphaph_1.relation.product_related_id | 1 | Using where |
1 | SIMPLE | pr_cat | ref | PRIMARY,category_id,product_id,product_id_2 | PRIMARY | 4 | duocphaph_1.relation.product_related_id | 1 | Using index |
1 | SIMPLE | cat | eq_ref | PRIMARY,category_publish,access,category_publish_2 | PRIMARY | 4 | duocphaph_1.pr_cat.category_id | 1 | Using where |
# | Caller | File and line number |
---|---|---|
13 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
12 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jshopping/tables/product.php:812 |
11 | jshopProduct->getRelatedProducts() | JROOT/components/com_jshopping/tables/product.php:493 |
10 | jshopProduct->getExtendsData() | JROOT/components/com_jshopping/models/productshop.php:101 |
9 | jshopProductShop->prepareView() | JROOT/components/com_jshopping/controllers/product.php:55 |
8 | JshoppingControllerProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jshopping/jshopping.php:25 |
6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SHOW FULL COLUMNS
FROM `veneno_jshopping_taxes`
# | Caller | File and line number |
---|---|---|
21 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:430 |
19 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
18 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
17 | Joomla\CMS\Table\Table->__construct() | JROOT/components/com_jshopping/tables/tax.php:14 |
16 | jshopTax->__construct() | JROOT/libraries/src/Table/Table.php:312 |
15 | Joomla\CMS\Table\Table::getInstance() | JROOT/components/com_jshopping/lib/factory.php:600 |
14 | JSFactory::getTable() | JROOT/components/com_jshopping/lib/factory.php:342 |
13 | JSFactory::getAllTaxes() | JROOT/components/com_jshopping/lib/functions.php:645 |
12 | listProductUpdateData() | JROOT/components/com_jshopping/tables/product.php:816 |
11 | jshopProduct->getRelatedProducts() | JROOT/components/com_jshopping/tables/product.php:493 |
10 | jshopProduct->getExtendsData() | JROOT/components/com_jshopping/models/productshop.php:101 |
9 | jshopProductShop->prepareView() | JROOT/components/com_jshopping/controllers/product.php:55 |
8 | JshoppingControllerProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jshopping/jshopping.php:25 |
6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT tax_id, tax_name, tax_value
FROM `veneno_jshopping_taxes`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | veneno_jshopping_taxes | system | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 |
# | Caller | File and line number |
---|---|---|
17 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
16 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jshopping/tables/tax.php:21 |
15 | jshopTax->getAllTaxes() | JROOT/components/com_jshopping/lib/factory.php:328 |
14 | JSFactory::getAllTaxesOriginal() | JROOT/components/com_jshopping/lib/factory.php:343 |
13 | JSFactory::getAllTaxes() | JROOT/components/com_jshopping/lib/functions.php:645 |
12 | listProductUpdateData() | JROOT/components/com_jshopping/tables/product.php:816 |
11 | jshopProduct->getRelatedProducts() | JROOT/components/com_jshopping/tables/product.php:493 |
10 | jshopProduct->getExtendsData() | JROOT/components/com_jshopping/models/productshop.php:101 |
9 | jshopProductShop->prepareView() | JROOT/components/com_jshopping/controllers/product.php:55 |
8 | JshoppingControllerProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jshopping/jshopping.php:25 |
6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SHOW FULL COLUMNS
FROM `veneno_jshopping_products_reviews`
# | Caller | File and line number |
---|---|---|
17 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:430 |
15 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
14 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
13 | Joomla\CMS\Table\Table->__construct() | JROOT/components/com_jshopping/tables/review.php:14 |
12 | jshopReview->__construct() | JROOT/libraries/src/Table/Table.php:312 |
11 | Joomla\CMS\Table\Table::getInstance() | JROOT/components/com_jshopping/lib/factory.php:600 |
10 | JSFactory::getTable() | JROOT/components/com_jshopping/models/productshop.php:114 |
9 | jshopProductShop->prepareView() | JROOT/components/com_jshopping/controllers/product.php:55 |
8 | JshoppingControllerProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jshopping/jshopping.php:25 |
6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SHOW FULL COLUMNS
FROM `veneno_jshopping_product_labels`
# | Caller | File and line number |
---|---|---|
18 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:430 |
16 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
15 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
14 | Joomla\CMS\Table\Table->__construct() | JROOT/components/com_jshopping/tables/productlabel.php:14 |
13 | jshopProductLabel->__construct() | JROOT/libraries/src/Table/Table.php:312 |
12 | Joomla\CMS\Table\Table::getInstance() | JROOT/components/com_jshopping/lib/factory.php:600 |
11 | JSFactory::getTable() | JROOT/components/com_jshopping/lib/functions.php:616 |
10 | getNameImageLabel() | JROOT/components/com_jshopping/models/productshop.php:177 |
9 | jshopProductShop->prepareView() | JROOT/components/com_jshopping/controllers/product.php:55 |
8 | JshoppingControllerProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jshopping/jshopping.php:25 |
6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT id, image, `name_vi-VN` as name
FROM `veneno_jshopping_product_labels`
ORDER BY name
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | veneno_jshopping_product_labels | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 2 | Using filesort |
# | Caller | File and line number |
---|---|---|
13 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
12 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jshopping/tables/productlabel.php:22 |
11 | jshopProductLabel->getListLabels() | JROOT/components/com_jshopping/lib/functions.php:617 |
10 | getNameImageLabel() | JROOT/components/com_jshopping/models/productshop.php:177 |
9 | jshopProductShop->prepareView() | JROOT/components/com_jshopping/controllers/product.php:55 |
8 | JshoppingControllerProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jshopping/jshopping.php:25 |
6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
select id,link
from veneno_menu
where `type`='component'
and published=1
and link like '%option=com_jshopping%'
and client_id=0
and (language='*' or language='vi-VN')
and access IN (1,1)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | veneno_menu | ref | idx_client_id_parent_id_alias_language,idx_language | idx_client_id_parent_id_alias_language | 1 | const | 173 | Using index condition; Using where |
# | Caller | File and line number |
---|---|---|
15 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
14 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jshopping/lib/shop_item_menu.php:130 |
13 | shopItemMenu->getList() | JROOT/components/com_jshopping/lib/shop_item_menu.php:41 |
12 | shopItemMenu->init() | JROOT/components/com_jshopping/lib/shop_item_menu.php:35 |
11 | shopItemMenu::getInstance() | JROOT/components/com_jshopping/lib/functions.php:387 |
10 | getShopMainPageItemid() | JROOT/components/com_jshopping/helpers/metadata.php:263 |
9 | JshopHelpersMetadata::product() | JROOT/components/com_jshopping/controllers/product.php:66 |
8 | JshoppingControllerProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jshopping/jshopping.php:25 |
6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
select category_id as id, `alias_vi-VN` as alias
from veneno_jshopping_categories
where `alias_vi-VN`!=''
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | veneno_jshopping_categories | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 24 | Using where |
# | Caller | File and line number |
---|---|---|
21 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
20 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jshopping/lib/factory.php:242 |
19 | JSFactory::getAliasCategory() | JROOT/components/com_jshopping/router.php:58 |
18 | jshoppingBuildRoute() | JROOT/libraries/src/Component/Router/RouterLegacy.php:69 |
17 | Joomla\CMS\Component\Router\RouterLegacy->build() | JROOT/libraries/src/Router/SiteRouter.php:528 |
16 | Joomla\CMS\Router\SiteRouter->buildSefRoute() | JROOT/libraries/src/Router/SiteRouter.php:498 |
15 | Joomla\CMS\Router\SiteRouter->_buildSefRoute() | JROOT/libraries/src/Router/Router.php:281 |
14 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:154 |
13 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:66 |
12 | Joomla\CMS\Router\Route::_() | JROOT/components/com_jshopping/lib/functions.php:479 |
11 | SEFLink() | JROOT/components/com_jshopping/lib/functions.php:139 |
10 | appendExtendPathWay() | JROOT/components/com_jshopping/helpers/metadata.php:264 |
9 | JshopHelpersMetadata::product() | JROOT/components/com_jshopping/controllers/product.php:66 |
8 | JshoppingControllerProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jshopping/jshopping.php:25 |
6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
UPDATE veneno_jshopping_products
SET `hits` = (`hits` + 1)
WHERE `product_id` = '509'
# | Caller | File and line number |
---|---|---|
10 | JDatabaseDriverMysql->execute() | JROOT/libraries/src/Table/Table.php:1242 |
9 | Joomla\CMS\Table\Table->hit() | JROOT/components/com_jshopping/controllers/product.php:68 |
8 | JshoppingControllerProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jshopping/jshopping.php:25 |
6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT I.*, IF(P.image=I.image_name,0,1) as sort
FROM `veneno_jshopping_products_images` as I
left join `veneno_jshopping_products` as P
on P.product_id=I.product_id
WHERE I.product_id = '509'
ORDER BY sort, I.ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | I | ref | product_id | product_id | 4 | const | 1 | Using temporary; Using filesort |
1 | SIMPLE | P | eq_ref | PRIMARY | PRIMARY | 4 | duocphaph_1.I.product_id | 1 |
# | Caller | File and line number |
---|---|---|
11 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
10 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jshopping/tables/product.php:333 |
9 | jshopProduct->getImages() | JROOT/components/com_jshopping/controllers/product.php:78 |
8 | JshoppingControllerProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jshopping/jshopping.php:25 |
6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT video_name, video_id, video_preview, video_code
FROM `veneno_jshopping_products_videos`
WHERE product_id = '509'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
# | Caller | File and line number |
---|---|---|
11 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
10 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jshopping/tables/product.php:352 |
9 | jshopProduct->getVideos() | JROOT/components/com_jshopping/controllers/product.php:79 |
8 | JshoppingControllerProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jshopping/jshopping.php:25 |
6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM `veneno_jshopping_products_files`
WHERE product_id = '509'
and demo!=''
order by `ordering`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
# | Caller | File and line number |
---|---|---|
11 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
10 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jshopping/tables/product.php:380 |
9 | jshopProduct->getDemoFiles() | JROOT/components/com_jshopping/controllers/product.php:80 |
8 | JshoppingControllerProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jshopping/jshopping.php:25 |
6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT count(review_id)
FROM `veneno_jshopping_products_reviews`
WHERE product_id = '509'
and publish='1'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | veneno_jshopping_products_reviews | ref | product_id,publish | product_id | 4 | const | 1 | Using where |
# | Caller | File and line number |
---|---|---|
12 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
11 | JDatabaseDriver->loadResult() | JROOT/components/com_jshopping/tables/product.php:1039 |
10 | jshopProduct->getReviewsCount() | JROOT/components/com_jshopping/models/productreviewlist.php:86 |
9 | jshopProductReviewList->load() | JROOT/components/com_jshopping/controllers/product.php:110 |
8 | JshoppingControllerProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jshopping/jshopping.php:25 |
6 | require_once JROOT/components/com_jshopping/jshopping.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |