Attention!! This is a demo store, No order shall be fullfilled. To place an order please visit www.electronicscomp.com.
  • TNY278PN IC - Power Integrations Off Line Switcher IC

The TNY278PN incorporates a 700 V power MOSFET, oscillator, high voltage switched current source, current limit (user selectable) and thermal shutdown circuitry. The IC family uses an ON/OFF control scheme and offers a design fl exible solution with a low system cost and extended power capability.

Features:-

 Simple ON/OFF control, no loop compensation needed

 Selectable current limit through BP/M capacitor value

 Higher current limit extends peak power or, in open  frame applications, maximum continuous power Lower current limit improves efficiency in enclosed     adapters/chargers

 Allows optimum TNY278PN choice by swapping devices with no other circuit redesign Tight I2f parameter tolerance reduces system cost

 Maximizes MOSFET and magnetic power delivery 

 Minimizes max overload power, reducing cost of transformer, primary clamp & secondary components ON-time extension – extends low line regulation range/hold-up time to reduce input bulk capacitance

 Self-biased: no bias winding or bias components

 Frequency jittering reduces EMI filter costs

 Pin-out simplifies heat sinking to the PCB SOURCE pins are electrically quiet for low EMI

Specification:-

Symbol Parameter Min Type Max Units
VBP BYPASS Pin Voltage 5.6 5.85 6.15 V
VBPH BYPASS Pin Voltage Hysteresis 0.80 0.95 1.2 V
VSHUNT BP/M Pin Shunt Voltage 6 6.4 6.7 V
ICH1 BP/M Pin Charge Current -8.3 -5.4 -2.5 m A


Related Document:-

TNY278PN IC Data Sheet

Brand/Manufacturer Generic
Country Of Origin China
Packer / Importer Address Constflick Technologies Limited, Building No 13 and 14, 3rd Floor, 2nd Main, Siddaiah Road, Bangalore, Karnataka - 560027 India.
MRP Rs. 88.5 (Inclusive of all Taxes)
Write a review
Please login or register to review

* Product Images are shown for illustrative purposes only and may differ from actual product.

TNY278PN IC - Power Integrations Off Line Switcher IC

  • Product Code: EC-2561
  • Availability: 1388
  • Rs.75.00
  • (Excluding 18% GST)

Queries: 157, Total time: 214.512 ms [By time] [By id] [By file]
1 (0.467)
SELECT *
FROM oc_store
WHERE REPLACE(`url`, 'www.', '') = 'http://electronicscomp.in/'
/var/www/html/index.php:44
2 (11.456)
SELECT *
FROM `oc_setting`
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
/var/www/html/index.php:54
3 (0.793)
SELECT *
FROM `oc_language`
WHERE status = '1'
/var/www/html/index.php:153
4 (0.905)
SELECT *
FROM oc_currency
/var/www/html/system/library/currency.php:13
5 (1.096)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'payment' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '99' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1483')
ORDER BY tr1.priority ASC
/var/www/html/system/library/tax.php:40
6 (0.664)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '99' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1483')
ORDER BY tr1.priority ASC
/var/www/html/system/library/tax.php:54
7 (0.422)
SELECT *
FROM oc_weight_class wc
LEFT JOIN oc_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id)
WHERE wcd.language_id = '1'
/var/www/html/system/library/weight.php:9
8 (0.585)
SELECT *
FROM oc_length_class mc
LEFT JOIN oc_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id)
WHERE mcd.language_id = '1'
/var/www/html/system/library/length.php:9
9 (1.402)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'PersistentCart'
/var/www/html/system/storage/modification/system/library/cart.php:74
10 (0.686)
DELETE
FROM oc_cart
WHERE customer_id = '0' AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)
/var/www/html/system/storage/modification/system/library/cart.php:122
11 (1.188)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'PersistentCart'
/var/www/html/system/storage/modification/system/library/cart.php:74
12 (1.054)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'PersistentCart'
/var/www/html/system/storage/modification/system/library/cart.php:74
13 (0.627)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/var/www/html/system/library/openbay.php:117
14 (0.507)
SELECT *
FROM oc_event
/var/www/html/index.php:254
15 (1.740)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '2680' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:15
16 (1.241)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'PriceAlert'
/var/www/html/catalog/model/setting/setting.php:6
17 (1.027)
SELECT pc.*, (!ISNULL(t1.parent_id) + !ISNULL(t2.parent_id) + !ISNULL(t3.parent_id) + !ISNULL(t4.parent_id) + !ISNULL(t5.parent_id))*1000 + IF(t1.sort_order>0,(1000-t1.sort_order),0) + IF(t2.sort_order>0,(1000-t2.sort_order),0) + IF(t3.sort_order>0,(1000-t3.sort_order),0) + IF(t4.sort_order>0,(1000-t4.sort_order),0) + IF(t5.sort_order>0,(1000-t5.sort_order),0) AS d
FROM oc_product_to_category pc
LEFT JOIN oc_category t1 ON t1.category_id = pc.category_id
LEFT JOIN oc_category t2 ON t1.parent_id = t2.category_id
LEFT JOIN oc_category t3 ON t2.parent_id = t3.category_id
LEFT JOIN oc_category t4 ON t3.parent_id = t4.category_id
LEFT JOIN oc_category t5 ON t4.parent_id = t5.category_id
WHERE product_id = '2680'
ORDER BY d DESC
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:718
18 (0.928)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '218' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:11
19 (0.827)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '59' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:11
20 (0.550)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '198' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:11
21 (0.343)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:11
22 (0.469)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '218' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:11
23 (0.428)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '198' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:11
24 (0.461)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '59' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:11
25 (0.375)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '218' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:11
26 (0.486)
SELECT *
FROM oc_product_image
WHERE product_id = '2680'
ORDER BY sort_order ASC
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:731
27 (0.480)
SELECT *
FROM oc_product_discount
WHERE product_id = '2680' AND customer_group_id = '1' AND quantity > 1 AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY quantity ASC, priority ASC, price ASC
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:725
28 (0.379)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '2680' AND od.language_id = '1'
ORDER BY o.sort_order
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:680
29 (0.616)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '2680' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:652
30 (0.301)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '2680' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:657
31 (0.738)
SELECT *
FROM oc_product_related pr
LEFT JOIN oc_product p ON (pr.related_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pr.product_id = '2680' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:739
32 (0.361)
SELECT `pd`.*
FROM `oc_product_recurring` `pp` JOIN `oc_recurring_description` `pd` ON `pd`.`language_id` = 1 AND `pd`.`recurring_id` = `pp`.`recurring_id` JOIN `oc_recurring` `p` ON `p`.`recurring_id` = `pd`.`recurring_id`
WHERE `product_id` = 2680 AND `status` = 1 AND `customer_group_id` = 1
ORDER BY `sort_order` ASC
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:1170
33 (0.510)
UPDATE oc_product SET viewed = (viewed + 1)
WHERE product_id = '2680'
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:4
34 (0.288)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '2680' AND store_id = '0'
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:749
35 (0.400)
SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/html/catalog/model/design/layout.php:4
36 (0.215)
SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'column_left'
ORDER BY sort_order
/var/www/html/catalog/model/design/layout.php:14
37 (0.390)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'common/column_left'
/var/www/html/catalog/model/extension/module/d_twig_manager.php:4
38 (0.271)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '2680' AND store_id = '0'
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:749
39 (0.392)
SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/html/catalog/model/design/layout.php:4
40 (0.259)
SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'column_right'
ORDER BY sort_order
/var/www/html/catalog/model/design/layout.php:14
41 (0.318)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'common/column_right'
/var/www/html/catalog/model/extension/module/d_twig_manager.php:4
42 (0.264)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '2680' AND store_id = '0'
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:749
43 (0.324)
SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/html/catalog/model/design/layout.php:4
44 (0.330)
SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'content_top'
ORDER BY sort_order
/var/www/html/catalog/model/design/layout.php:14
45 (0.363)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'common/content_top'
/var/www/html/catalog/model/extension/module/d_twig_manager.php:4
46 (0.275)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '2680' AND store_id = '0'
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:749
47 (0.396)
SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/html/catalog/model/design/layout.php:4
48 (0.232)
SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'content_bottom'
ORDER BY sort_order
/var/www/html/catalog/model/design/layout.php:14
49 (0.395)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'module/mcafee_secure'
/var/www/html/catalog/model/extension/module/d_twig_manager.php:4
50 (0.888)
SELECT *
FROM `oc_pb_bundles`
WHERE `store_id`='0' AND `products` != '' AND `status`= '1' AND `date_available` <= NOW() AND `products_show` LIKE '%"2680"%' LIMIT 0, 5
/var/www/html/catalog/model/module/productbundles.php:92
51 (0.731)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'module/productbundles/productbundles'
/var/www/html/catalog/model/extension/module/d_twig_manager.php:4
52 (1.352)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'alsobought'
/var/www/html/catalog/model/setting/setting.php:6
53 (1.960)
SELECT *
FROM `oc_alsobought`
WHERE `low` = 2680 OR `high` = 2680
ORDER BY `number` DESC LIMIT 8
/var/www/html/catalog/controller/module/alsobought.php:174
54 (1.935)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1503' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:15
55 (2.265)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '2677' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:15
56 (2.328)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1500' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:15
57 (2.182)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '2679' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:15
58 (1.820)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1881' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:15
59 (1.980)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '128' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:15
60 (1.779)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '2675' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:15
61 (2.286)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '320' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:15
62 (0.543)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'module/alsobought'
/var/www/html/catalog/model/extension/module/d_twig_manager.php:4
63 (0.464)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'common/content_bottom'
/var/www/html/catalog/model/extension/module/d_twig_manager.php:4
64 (0.604)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '8uijt35gioacav3ugqs38pvv80'
/var/www/html/system/storage/modification/system/library/cart.php:145
65 (1.125)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'abandonedcarts'
/var/www/html/catalog/model/setting/setting.php:6
66 (4.770)
SELECT *
FROM oc_information i
LEFT JOIN oc_information_description id ON (i.information_id = id.information_id)
LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'
ORDER BY i.sort_order, LCASE(id.title) ASC
/var/www/html/catalog/model/catalog/information.php:10
67 (0.846)
DELETE
FROM `oc_customer_online`
WHERE date_added < '2022-08-10 09:46:48'
/var/www/html/catalog/model/tool/online.php:4
68 (0.576)
REPLACE INTO `oc_customer_online` SET `ip` = '3.238.252.196', `customer_id` = '0', `url` = 'http://www.electronicscomp.in/index.php?route=product/product&product_id=2680', `referer` = '', `date_added` = '2022-08-10 10:46:48'
/var/www/html/catalog/model/tool/online.php:6
69 (0.682)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'common/footer'
/var/www/html/catalog/model/extension/module/d_twig_manager.php:4
70 (0.928)
SELECT *
FROM oc_extension
WHERE `type` = 'analytics'
/var/www/html/system/storage/modification/catalog/model/extension/extension.php:4
71 (0.916)
SELECT ww.amount, o.currency_code, o.currency_value
FROM oc_wk_wallet ww
LEFT JOIN oc_order o ON (ww.order_id = o.order_id)
WHERE ww.type = 'C' AND ww.customer_id = '' AND ww.cashback_status <> 2 AND status = '1' AND zero_wallet = '0'
/var/www/html/catalog/model/account/wk_wallet_system.php:107
72 (0.394)
SELECT ww.amount, o.currency_code, o.currency_value
FROM oc_wk_wallet ww
LEFT JOIN oc_order o ON (ww.order_id = o.order_id)
WHERE ww.type = 'D' AND ww.customer_id = '' AND status = '1' AND zero_wallet = '0'
/var/www/html/catalog/model/account/wk_wallet_system.php:116
73 (0.407)
CREATE TABLE IF NOT EXISTS oc_colorskin ( `skin_id` int(11) NOT NULL AUTO_INCREMENT, `skinname` varchar(64) NOT NULL, `status` int(3) NOT NULL, PRIMARY KEY (`skin_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
/var/www/html/catalog/model/catalog/colorskin.php:12
74 (0.327)
SELECT *
FROM oc_colorskin
where status = 1
/var/www/html/catalog/model/catalog/colorskin.php:16
75 (2.751)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
76 (2.223)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '196' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
77 (2.675)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '110' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
78 (2.086)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '88' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
79 (2.326)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '345' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
80 (2.268)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '129' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
81 (2.105)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '379' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
82 (2.011)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '131' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
83 (1.877)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '459' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
84 (2.057)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '113' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
85 (1.675)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '376' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
86 (1.677)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '378' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
87 (2.189)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '197' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
88 (2.629)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '118' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
89 (3.354)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '92' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
90 (2.750)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '61' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
91 (2.237)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '533' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
92 (2.080)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '436' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
93 (1.967)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '163' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
94 (2.446)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '198' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
95 (2.541)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '59' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
96 (2.162)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '62' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
97 (2.648)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '89' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
98 (2.228)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '64' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
99 (2.235)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '134' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
100 (2.083)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '151' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
101 (2.661)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '96' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
102 (2.058)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '65' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
103 (2.825)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '133' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
104 (2.542)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '235' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
105 (2.495)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '276' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
106 (2.414)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '123' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
107 (2.046)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '98' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
108 (1.752)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '248' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
109 (1.803)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '95' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
110 (1.909)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '140' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
111 (2.239)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '199' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
112 (2.017)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '490' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
113 (1.656)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '67' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
114 (2.296)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '63' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
115 (2.467)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '136' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
116 (2.050)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '461' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
117 (2.173)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '450' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
118 (1.851)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '132' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
119 (2.624)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '371' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
120 (2.262)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '373' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
121 (1.745)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '374' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
122 (1.712)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '405' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
123 (1.894)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '403' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
124 (2.159)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '406' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
125 (1.831)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '372' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
126 (1.779)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '404' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
127 (1.939)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '516' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
128 (1.750)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '447' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
129 (1.809)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '412' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
130 (1.516)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '416' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
131 (1.496)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '414' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
132 (1.791)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '415' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
133 (1.618)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '413' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
134 (1.496)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '417' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
135 (1.808)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '277' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
136 (0.532)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'common/language'
/var/www/html/catalog/model/extension/module/d_twig_manager.php:4
137 (0.594)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'common/currency'
/var/www/html/catalog/model/extension/module/d_twig_manager.php:4
138 (0.566)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'common/search'
/var/www/html/catalog/model/extension/module/d_twig_manager.php:4
139 (0.571)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '8uijt35gioacav3ugqs38pvv80'
/var/www/html/system/storage/modification/system/library/cart.php:145
140 (0.425)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/var/www/html/system/storage/modification/catalog/model/extension/extension.php:4
141 (0.368)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '8uijt35gioacav3ugqs38pvv80'
/var/www/html/system/storage/modification/system/library/cart.php:145
142 (0.359)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '8uijt35gioacav3ugqs38pvv80'
/var/www/html/system/storage/modification/system/library/cart.php:145
143 (0.529)
SELECT *
FROM `oc_pb_bundles`
WHERE `store_id`='0' AND `products` != '' AND `status`= '1' AND `date_available` <= NOW()
ORDER BY `sort_order` ASC
/var/www/html/catalog/model/module/productbundles.php:92
144 (0.495)
SELECT count(*) as total
from oc_product
WHERE product_id IN (1493,749,749,749,749,1496,1496,1496,1496,751,752,2330,2694,747,747) AND status = '1' AND quantity > '0'
/var/www/html/catalog/model/module/productbundles.php:45
145 (0.326)
SELECT count(*) as total
from oc_product
WHERE product_id IN (3137,3917) AND status = '1' AND quantity > '0'
/var/www/html/catalog/model/module/productbundles.php:45
146 (0.310)
SELECT count(*) as total
from oc_product
WHERE product_id IN (2106,2107) AND status = '1' AND quantity > '0'
/var/www/html/catalog/model/module/productbundles.php:45
147 (0.425)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '8uijt35gioacav3ugqs38pvv80'
/var/www/html/system/storage/modification/system/library/cart.php:145
148 (0.232)
SELECT SUM(amount) AS total
FROM oc_customer_transaction
WHERE customer_id = '0'
/var/www/html/system/library/customer.php:159
149 (0.374)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '8uijt35gioacav3ugqs38pvv80'
/var/www/html/system/storage/modification/system/library/cart.php:145
150 (0.355)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '8uijt35gioacav3ugqs38pvv80'
/var/www/html/system/storage/modification/system/library/cart.php:145
151 (0.385)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'common/cart'
/var/www/html/catalog/model/extension/module/d_twig_manager.php:4
152 (0.342)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'common/header'
/var/www/html/catalog/model/extension/module/d_twig_manager.php:4
153 (1.237)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'advertise_google'
/var/www/html/catalog/model/setting/setting.php:6
154 (0.665)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'product/product'
/var/www/html/catalog/model/extension/module/d_twig_manager.php:4
155 (0.733)
select raavalue
from oc_raa_config
where raakey = 'isretargeting'
/var/www/html/catalog/model/raprediction/raonsite.php:984
156 (0.545)
SELECT category_id
FROM oc_category_description
where name='Power Integration IC'
/var/www/html/catalog/model/raprediction/raorder.php:21
157 (1.070)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'advertise_google'
/var/www/html/catalog/model/setting/setting.php:6
Queries: 157, Total time: 214.512 ms [By time] [By id] [By file]
1 (0.467)
SELECT *
FROM oc_store
WHERE REPLACE(`url`, 'www.', '') = 'http://electronicscomp.in/'
/var/www/html/index.php:44
2 (11.456)
SELECT *
FROM `oc_setting`
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
/var/www/html/index.php:54
3 (0.793)
SELECT *
FROM `oc_language`
WHERE status = '1'
/var/www/html/index.php:153
4 (0.905)
SELECT *
FROM oc_currency
/var/www/html/system/library/currency.php:13
5 (1.096)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'payment' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '99' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1483')
ORDER BY tr1.priority ASC
/var/www/html/system/library/tax.php:40
6 (0.664)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '99' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1483')
ORDER BY tr1.priority ASC
/var/www/html/system/library/tax.php:54
7 (0.422)
SELECT *
FROM oc_weight_class wc
LEFT JOIN oc_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id)
WHERE wcd.language_id = '1'
/var/www/html/system/library/weight.php:9
8 (0.585)
SELECT *
FROM oc_length_class mc
LEFT JOIN oc_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id)
WHERE mcd.language_id = '1'
/var/www/html/system/library/length.php:9
9 (1.402)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'PersistentCart'
/var/www/html/system/storage/modification/system/library/cart.php:74
10 (0.686)
DELETE
FROM oc_cart
WHERE customer_id = '0' AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)
/var/www/html/system/storage/modification/system/library/cart.php:122
11 (1.188)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'PersistentCart'
/var/www/html/system/storage/modification/system/library/cart.php:74
12 (1.054)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'PersistentCart'
/var/www/html/system/storage/modification/system/library/cart.php:74
13 (0.627)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/var/www/html/system/library/openbay.php:117
14 (0.507)
SELECT *
FROM oc_event
/var/www/html/index.php:254
15 (1.740)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '2680' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:15
16 (1.241)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'PriceAlert'
/var/www/html/catalog/model/setting/setting.php:6
17 (1.027)
SELECT pc.*, (!ISNULL(t1.parent_id) + !ISNULL(t2.parent_id) + !ISNULL(t3.parent_id) + !ISNULL(t4.parent_id) + !ISNULL(t5.parent_id))*1000 + IF(t1.sort_order>0,(1000-t1.sort_order),0) + IF(t2.sort_order>0,(1000-t2.sort_order),0) + IF(t3.sort_order>0,(1000-t3.sort_order),0) + IF(t4.sort_order>0,(1000-t4.sort_order),0) + IF(t5.sort_order>0,(1000-t5.sort_order),0) AS d
FROM oc_product_to_category pc
LEFT JOIN oc_category t1 ON t1.category_id = pc.category_id
LEFT JOIN oc_category t2 ON t1.parent_id = t2.category_id
LEFT JOIN oc_category t3 ON t2.parent_id = t3.category_id
LEFT JOIN oc_category t4 ON t3.parent_id = t4.category_id
LEFT JOIN oc_category t5 ON t4.parent_id = t5.category_id
WHERE product_id = '2680'
ORDER BY d DESC
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:718
18 (0.928)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '218' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:11
19 (0.827)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '59' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:11
20 (0.550)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '198' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:11
21 (0.343)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:11
22 (0.469)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '218' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:11
23 (0.428)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '198' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:11
24 (0.461)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '59' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:11
25 (0.375)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '218' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:11
26 (0.486)
SELECT *
FROM oc_product_image
WHERE product_id = '2680'
ORDER BY sort_order ASC
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:731
27 (0.480)
SELECT *
FROM oc_product_discount
WHERE product_id = '2680' AND customer_group_id = '1' AND quantity > 1 AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY quantity ASC, priority ASC, price ASC
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:725
28 (0.379)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '2680' AND od.language_id = '1'
ORDER BY o.sort_order
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:680
29 (0.616)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '2680' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:652
30 (0.301)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '2680' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:657
31 (0.738)
SELECT *
FROM oc_product_related pr
LEFT JOIN oc_product p ON (pr.related_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pr.product_id = '2680' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:739
32 (0.361)
SELECT `pd`.*
FROM `oc_product_recurring` `pp` JOIN `oc_recurring_description` `pd` ON `pd`.`language_id` = 1 AND `pd`.`recurring_id` = `pp`.`recurring_id` JOIN `oc_recurring` `p` ON `p`.`recurring_id` = `pd`.`recurring_id`
WHERE `product_id` = 2680 AND `status` = 1 AND `customer_group_id` = 1
ORDER BY `sort_order` ASC
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:1170
33 (0.510)
UPDATE oc_product SET viewed = (viewed + 1)
WHERE product_id = '2680'
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:4
34 (0.288)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '2680' AND store_id = '0'
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:749
35 (0.400)
SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/html/catalog/model/design/layout.php:4
36 (0.215)
SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'column_left'
ORDER BY sort_order
/var/www/html/catalog/model/design/layout.php:14
37 (0.390)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'common/column_left'
/var/www/html/catalog/model/extension/module/d_twig_manager.php:4
38 (0.271)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '2680' AND store_id = '0'
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:749
39 (0.392)
SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/html/catalog/model/design/layout.php:4
40 (0.259)
SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'column_right'
ORDER BY sort_order
/var/www/html/catalog/model/design/layout.php:14
41 (0.318)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'common/column_right'
/var/www/html/catalog/model/extension/module/d_twig_manager.php:4
42 (0.264)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '2680' AND store_id = '0'
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:749
43 (0.324)
SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/html/catalog/model/design/layout.php:4
44 (0.330)
SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'content_top'
ORDER BY sort_order
/var/www/html/catalog/model/design/layout.php:14
45 (0.363)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'common/content_top'
/var/www/html/catalog/model/extension/module/d_twig_manager.php:4
46 (0.275)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '2680' AND store_id = '0'
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:749
47 (0.396)
SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/html/catalog/model/design/layout.php:4
48 (0.232)
SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'content_bottom'
ORDER BY sort_order
/var/www/html/catalog/model/design/layout.php:14
49 (0.395)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'module/mcafee_secure'
/var/www/html/catalog/model/extension/module/d_twig_manager.php:4
50 (0.888)
SELECT *
FROM `oc_pb_bundles`
WHERE `store_id`='0' AND `products` != '' AND `status`= '1' AND `date_available` <= NOW() AND `products_show` LIKE '%"2680"%' LIMIT 0, 5
/var/www/html/catalog/model/module/productbundles.php:92
51 (0.731)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'module/productbundles/productbundles'
/var/www/html/catalog/model/extension/module/d_twig_manager.php:4
52 (1.352)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'alsobought'
/var/www/html/catalog/model/setting/setting.php:6
53 (1.960)
SELECT *
FROM `oc_alsobought`
WHERE `low` = 2680 OR `high` = 2680
ORDER BY `number` DESC LIMIT 8
/var/www/html/catalog/controller/module/alsobought.php:174
54 (1.935)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1503' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:15
55 (2.265)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '2677' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:15
56 (2.328)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1500' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:15
57 (2.182)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '2679' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:15
58 (1.820)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1881' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:15
59 (1.980)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '128' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:15
60 (1.779)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '2675' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:15
61 (2.286)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '320' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:15
62 (0.543)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'module/alsobought'
/var/www/html/catalog/model/extension/module/d_twig_manager.php:4
63 (0.464)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'common/content_bottom'
/var/www/html/catalog/model/extension/module/d_twig_manager.php:4
64 (0.604)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '8uijt35gioacav3ugqs38pvv80'
/var/www/html/system/storage/modification/system/library/cart.php:145
65 (1.125)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'abandonedcarts'
/var/www/html/catalog/model/setting/setting.php:6
66 (4.770)
SELECT *
FROM oc_information i
LEFT JOIN oc_information_description id ON (i.information_id = id.information_id)
LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'
ORDER BY i.sort_order, LCASE(id.title) ASC
/var/www/html/catalog/model/catalog/information.php:10
67 (0.846)
DELETE
FROM `oc_customer_online`
WHERE date_added < '2022-08-10 09:46:48'
/var/www/html/catalog/model/tool/online.php:4
68 (0.576)
REPLACE INTO `oc_customer_online` SET `ip` = '3.238.252.196', `customer_id` = '0', `url` = 'http://www.electronicscomp.in/index.php?route=product/product&product_id=2680', `referer` = '', `date_added` = '2022-08-10 10:46:48'
/var/www/html/catalog/model/tool/online.php:6
69 (0.682)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'common/footer'
/var/www/html/catalog/model/extension/module/d_twig_manager.php:4
70 (0.928)
SELECT *
FROM oc_extension
WHERE `type` = 'analytics'
/var/www/html/system/storage/modification/catalog/model/extension/extension.php:4
71 (0.916)
SELECT ww.amount, o.currency_code, o.currency_value
FROM oc_wk_wallet ww
LEFT JOIN oc_order o ON (ww.order_id = o.order_id)
WHERE ww.type = 'C' AND ww.customer_id = '' AND ww.cashback_status <> 2 AND status = '1' AND zero_wallet = '0'
/var/www/html/catalog/model/account/wk_wallet_system.php:107
72 (0.394)
SELECT ww.amount, o.currency_code, o.currency_value
FROM oc_wk_wallet ww
LEFT JOIN oc_order o ON (ww.order_id = o.order_id)
WHERE ww.type = 'D' AND ww.customer_id = '' AND status = '1' AND zero_wallet = '0'
/var/www/html/catalog/model/account/wk_wallet_system.php:116
73 (0.407)
CREATE TABLE IF NOT EXISTS oc_colorskin ( `skin_id` int(11) NOT NULL AUTO_INCREMENT, `skinname` varchar(64) NOT NULL, `status` int(3) NOT NULL, PRIMARY KEY (`skin_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
/var/www/html/catalog/model/catalog/colorskin.php:12
74 (0.327)
SELECT *
FROM oc_colorskin
where status = 1
/var/www/html/catalog/model/catalog/colorskin.php:16
75 (2.751)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
76 (2.223)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '196' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
77 (2.675)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '110' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
78 (2.086)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '88' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
79 (2.326)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '345' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
80 (2.268)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '129' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
81 (2.105)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '379' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
82 (2.011)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '131' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
83 (1.877)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '459' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
84 (2.057)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '113' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
85 (1.675)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '376' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
86 (1.677)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '378' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
87 (2.189)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '197' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
88 (2.629)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '118' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
89 (3.354)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '92' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
90 (2.750)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '61' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
91 (2.237)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '533' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
92 (2.080)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '436' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
93 (1.967)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '163' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
94 (2.446)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '198' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
95 (2.541)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '59' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
96 (2.162)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '62' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
97 (2.648)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '89' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
98 (2.228)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '64' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
99 (2.235)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '134' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
100 (2.083)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '151' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
101 (2.661)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '96' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
102 (2.058)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '65' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
103 (2.825)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '133' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
104 (2.542)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '235' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
105 (2.495)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '276' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
106 (2.414)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '123' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
107 (2.046)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '98' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
108 (1.752)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '248' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
109 (1.803)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '95' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
110 (1.909)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '140' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
111 (2.239)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '199' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
112 (2.017)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '490' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
113 (1.656)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '67' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
114 (2.296)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '63' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
115 (2.467)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '136' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
116 (2.050)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '461' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
117 (2.173)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '450' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
118 (1.851)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '132' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
119 (2.624)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '371' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
120 (2.262)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '373' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
121 (1.745)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '374' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
122 (1.712)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '405' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
123 (1.894)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '403' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
124 (2.159)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '406' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
125 (1.831)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '372' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
126 (1.779)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '404' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
127 (1.939)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '516' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
128 (1.750)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '447' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
129 (1.809)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '412' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
130 (1.516)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '416' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
131 (1.496)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '414' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
132 (1.791)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '415' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
133 (1.618)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '413' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
134 (1.496)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '417' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
135 (1.808)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '277' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/html/system/storage/modification/catalog/model/catalog/category.php:17
136 (0.532)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'common/language'
/var/www/html/catalog/model/extension/module/d_twig_manager.php:4
137 (0.594)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'common/currency'
/var/www/html/catalog/model/extension/module/d_twig_manager.php:4
138 (0.566)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'common/search'
/var/www/html/catalog/model/extension/module/d_twig_manager.php:4
139 (0.571)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '8uijt35gioacav3ugqs38pvv80'
/var/www/html/system/storage/modification/system/library/cart.php:145
140 (0.425)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/var/www/html/system/storage/modification/catalog/model/extension/extension.php:4
141 (0.368)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '8uijt35gioacav3ugqs38pvv80'
/var/www/html/system/storage/modification/system/library/cart.php:145
142 (0.359)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '8uijt35gioacav3ugqs38pvv80'
/var/www/html/system/storage/modification/system/library/cart.php:145
143 (0.529)
SELECT *
FROM `oc_pb_bundles`
WHERE `store_id`='0' AND `products` != '' AND `status`= '1' AND `date_available` <= NOW()
ORDER BY `sort_order` ASC
/var/www/html/catalog/model/module/productbundles.php:92
144 (0.495)
SELECT count(*) as total
from oc_product
WHERE product_id IN (1493,749,749,749,749,1496,1496,1496,1496,751,752,2330,2694,747,747) AND status = '1' AND quantity > '0'
/var/www/html/catalog/model/module/productbundles.php:45
145 (0.326)
SELECT count(*) as total
from oc_product
WHERE product_id IN (3137,3917) AND status = '1' AND quantity > '0'
/var/www/html/catalog/model/module/productbundles.php:45
146 (0.310)
SELECT count(*) as total
from oc_product
WHERE product_id IN (2106,2107) AND status = '1' AND quantity > '0'
/var/www/html/catalog/model/module/productbundles.php:45
147 (0.425)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '8uijt35gioacav3ugqs38pvv80'
/var/www/html/system/storage/modification/system/library/cart.php:145
148 (0.232)
SELECT SUM(amount) AS total
FROM oc_customer_transaction
WHERE customer_id = '0'
/var/www/html/system/library/customer.php:159
149 (0.374)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '8uijt35gioacav3ugqs38pvv80'
/var/www/html/system/storage/modification/system/library/cart.php:145
150 (0.355)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '8uijt35gioacav3ugqs38pvv80'
/var/www/html/system/storage/modification/system/library/cart.php:145
151 (0.385)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'common/cart'
/var/www/html/catalog/model/extension/module/d_twig_manager.php:4
152 (0.342)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'common/header'
/var/www/html/catalog/model/extension/module/d_twig_manager.php:4
153 (1.237)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'advertise_google'
/var/www/html/catalog/model/setting/setting.php:6
154 (0.665)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'product/product'
/var/www/html/catalog/model/extension/module/d_twig_manager.php:4
155 (0.733)
select raavalue
from oc_raa_config
where raakey = 'isretargeting'
/var/www/html/catalog/model/raprediction/raonsite.php:984
156 (0.545)
SELECT category_id
FROM oc_category_description
where name='Power Integration IC'
/var/www/html/catalog/model/raprediction/raorder.php:21
157 (1.070)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'advertise_google'
/var/www/html/catalog/model/setting/setting.php:6