Attention ! This is a demo store no order shall be fullfilled. Visit www.electronicscomp.com to place an order.

NEMA17 2.6 kg-cm Single Shaft Stepper Motor can provide 2.6 kg-cm of torque at 0.4A current per phase. The stepper motors move in precisely repeatable steps, hence they are the motors of choice for the machines requiring precise position control. 

The motor’s position can be commanded to move or hold at one position with the help of Stepper Motor Drivers. The NEMA17 2.6 kg-cm Stepper Motor provides excellent response to starting, stopping and reversing pulses from the stepper motor driver.

They are very useful in various applications, especially which demands low speed with high precision. Many machines such as 3D Printers, CNC Router and Mills, Camera Platforms, XYZ Plotters, etc.

It is a brushless DC motor, so the life of this motor is dependent upon the life of the bearings. The position control is achieved by a simple Open Loop control mechanism so it doesn’t require complex electronic control circuitry.

The motor’s shaft has been machined for good grip with a pulley, drive gear, etc. and especially avoiding stall or slip. The NEMA17 Stepper Motor 72CM Detachable Cable is not included in this pack, buy it separately.


Features of NEMA17 2.6 kg-cm Single Shaft Stepper Motor:-

  • The input pulse decides the rotation angle of the motor.
  • High accuracy of around 3 to 5% a step.
  • It provides good starting, stopping and reversing.
  • Control of this motor is less costly because of the exclusion of complex control circuitry.
  • The speed is proportional to the frequency of the input pulses.


Note:-

  • The NEMA17 2.6 kg-cm Stepper Motor dimensions and weight may have a ±2% error.
  • Resonances can occur because of improper installment.
  • Not easy to operate at extremely high speeds.


Write a review
Please login or register to review

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

NEMA17 2.6 kg-cm Single Shaft Stepper Motor

  • Product Code: EC-3918
  • Reward Points: 7.35
  • Availability: 124
  • Rs.735.00
  • (Excluding 18% GST)
  • Price in reward points: 735

Queries: 133, Total time: 94.521 ms [By time] [By id] [By file]
1 (0.283)
SELECT *
FROM oc_store
WHERE REPLACE(`url`, 'www.', '') = 'http://electronicscomp.in/'
/var/www/html/index.php:44
2 (9.921)
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.266)
SELECT *
FROM `oc_language`
WHERE status = '1'
/var/www/html/index.php:153
4 (0.184)
SELECT *
FROM oc_currency
/var/www/html/system/library/currency.php:13
5 (0.586)
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.609)
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.386)
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.256)
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 (0.706)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'PersistentCart'
/var/www/html/system/storage/modification/system/library/cart.php:74
10 (0.236)
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 (0.667)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'PersistentCart'
/var/www/html/system/storage/modification/system/library/cart.php:74
12 (0.860)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'PersistentCart'
/var/www/html/system/storage/modification/system/library/cart.php:74
13 (0.185)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/var/www/html/system/library/openbay.php:117
14 (0.156)
SELECT *
FROM oc_event
/var/www/html/index.php:254
15 (1.966)
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 = '4326' 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 (0.715)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'PriceAlert'
/var/www/html/catalog/model/setting/setting.php:6
17 (0.569)
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 = '4326'
ORDER BY d DESC
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:702
18 (0.362)
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 = '115' 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.317)
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 = '63' 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.313)
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 = '199' 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.300)
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.256)
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 = '115' 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.278)
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 = '199' 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.234)
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 = '63' 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.318)
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 = '115' 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.267)
SELECT *
FROM oc_product_image
WHERE product_id = '4326'
ORDER BY sort_order ASC
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:715
27 (0.288)
SELECT *
FROM oc_product_discount
WHERE product_id = '4326' 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:709
28 (0.251)
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 = '4326' AND od.language_id = '1'
ORDER BY o.sort_order
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:664
29 (0.300)
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 = '4326' 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:636
30 (0.355)
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 = '4326' 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:723
31 (0.193)
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` = 4326 AND `status` = 1 AND `customer_group_id` = 1
ORDER BY `sort_order` ASC
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:1144
32 (0.266)
UPDATE oc_product SET viewed = (viewed + 1)
WHERE product_id = '4326'
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:4
33 (0.211)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '4326' AND store_id = '0'
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:733
34 (0.254)
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
35 (0.288)
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
36 (0.150)
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
37 (0.215)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '4326' AND store_id = '0'
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:733
38 (0.260)
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
39 (0.217)
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
40 (0.178)
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
41 (0.239)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '4326' AND store_id = '0'
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:733
42 (0.206)
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
43 (0.327)
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
44 (0.212)
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
45 (0.237)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '4326' AND store_id = '0'
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:733
46 (0.204)
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
47 (0.203)
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
48 (0.150)
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
49 (0.474)
SELECT *
FROM `oc_pb_bundles`
WHERE `store_id`='0' AND `products` != '' AND `status`= '1' AND `date_available` <= NOW() AND `products_show` LIKE '%"4326"%' LIMIT 0, 5
/var/www/html/catalog/model/module/productbundles.php:92
50 (0.168)
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
51 (0.737)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'alsobought'
/var/www/html/catalog/model/setting/setting.php:6
52 (1.002)
SELECT *
FROM `oc_alsobought`
WHERE `low` = 4326 OR `high` = 4326
ORDER BY `number` DESC LIMIT 8
/var/www/html/catalog/controller/module/alsobought.php:174
53 (2.253)
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 = '3128' 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
54 (2.521)
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 = '156' 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 (1.860)
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 = '342' 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.300)
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 = '524' 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 (1.999)
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 = '1209' 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.863)
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 = '2170' 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.804)
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 = '3130' 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.769)
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 = '3145' 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 (0.247)
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
62 (0.181)
SELECT *
FROM oc_prediction
WHERE flag = 'flag'
/var/www/html/catalog/model/raprediction/raorder.php:14
63 (0.146)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'module/raprediction'
/var/www/html/catalog/model/extension/module/d_twig_manager.php:4
64 (0.151)
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
65 (0.294)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '3ckh05den0gobpi948kvvcik51'
/var/www/html/system/storage/modification/system/library/cart.php:145
66 (0.721)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'abandonedcarts'
/var/www/html/catalog/model/setting/setting.php:6
67 (2.025)
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
68 (0.374)
DELETE
FROM `oc_customer_online`
WHERE date_added < '2021-10-27 14:50:04'
/var/www/html/catalog/model/tool/online.php:4
69 (0.232)
REPLACE INTO `oc_customer_online` SET `ip` = '3.238.204.31', `customer_id` = '0', `url` = 'http://www.electronicscomp.in/index.php?route=product/product&product_id=4326', `referer` = '', `date_added` = '2021-10-27 15:50:04'
/var/www/html/catalog/model/tool/online.php:6
70 (0.151)
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
71 (0.219)
SELECT *
FROM oc_extension
WHERE `type` = 'analytics'
/var/www/html/catalog/model/extension/extension.php:4
72 (0.215)
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
73 (0.208)
SELECT *
FROM oc_colorskin
where status = 1
/var/www/html/catalog/model/catalog/colorskin.php:16
74 (1.245)
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
75 (1.032)
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
76 (1.142)
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
77 (1.132)
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
78 (0.827)
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
79 (0.935)
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
80 (0.817)
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
81 (0.834)
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
82 (0.960)
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
83 (1.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 = '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
84 (1.538)
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
85 (1.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 = '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
86 (0.961)
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
87 (1.203)
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
88 (0.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 = '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
89 (1.786)
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
90 (0.905)
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
91 (1.308)
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
92 (1.282)
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
93 (0.816)
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
94 (1.077)
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
95 (1.345)
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
96 (1.424)
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
97 (1.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 = '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
98 (0.945)
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
99 (0.945)
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
100 (0.875)
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
101 (0.895)
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
102 (0.974)
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
103 (0.858)
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
104 (1.085)
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
105 (1.101)
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
106 (0.971)
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
107 (0.737)
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
108 (0.286)
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
109 (0.229)
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
110 (0.228)
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
111 (0.330)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '3ckh05den0gobpi948kvvcik51'
/var/www/html/system/storage/modification/system/library/cart.php:145
112 (0.207)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/var/www/html/catalog/model/extension/extension.php:4
113 (0.239)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '3ckh05den0gobpi948kvvcik51'
/var/www/html/system/storage/modification/system/library/cart.php:145
114 (0.366)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '3ckh05den0gobpi948kvvcik51'
/var/www/html/system/storage/modification/system/library/cart.php:145
115 (0.416)
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
116 (0.338)
SELECT count(*) as total
from oc_product
WHERE product_id IN (3421,3520) AND status = '1' AND quantity > '0'
/var/www/html/catalog/model/module/productbundles.php:45
117 (0.307)
SELECT count(*) as total
from oc_product
WHERE product_id IN (2745,1651,1658,3201,1662,1661) AND status = '1' AND quantity > '0'
/var/www/html/catalog/model/module/productbundles.php:45
118 (0.281)
SELECT count(*) as total
from oc_product
WHERE product_id IN (1232,711,3189) AND status = '1' AND quantity > '0'
/var/www/html/catalog/model/module/productbundles.php:45
119 (0.235)
SELECT count(*) as total
from oc_product
WHERE product_id IN (1233,711,3170) AND status = '1' AND quantity > '0'
/var/www/html/catalog/model/module/productbundles.php:45
120 (0.337)
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
121 (0.220)
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
122 (0.219)
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
123 (0.304)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '3ckh05den0gobpi948kvvcik51'
/var/www/html/system/storage/modification/system/library/cart.php:145
124 (0.171)
SELECT SUM(amount) AS total
FROM oc_customer_transaction
WHERE customer_id = '0'
/var/www/html/system/library/customer.php:159
125 (0.276)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '3ckh05den0gobpi948kvvcik51'
/var/www/html/system/storage/modification/system/library/cart.php:145
126 (0.229)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '3ckh05den0gobpi948kvvcik51'
/var/www/html/system/storage/modification/system/library/cart.php:145
127 (0.147)
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
128 (0.162)
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
129 (0.696)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'advertise_google'
/var/www/html/catalog/model/setting/setting.php:6
130 (0.188)
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
131 (0.246)
select raavalue
from oc_raa_config
where raakey = 'isretargeting'
/var/www/html/catalog/model/raprediction/raonsite.php:984
132 (0.393)
SELECT category_id
FROM oc_category_description
where name='Stepper Motor'
/var/www/html/catalog/model/raprediction/raorder.php:21
133 (0.704)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'advertise_google'
/var/www/html/catalog/model/setting/setting.php:6
Queries: 133, Total time: 94.521 ms [By time] [By id] [By file]
1 (0.283)
SELECT *
FROM oc_store
WHERE REPLACE(`url`, 'www.', '') = 'http://electronicscomp.in/'
/var/www/html/index.php:44
2 (9.921)
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.266)
SELECT *
FROM `oc_language`
WHERE status = '1'
/var/www/html/index.php:153
4 (0.184)
SELECT *
FROM oc_currency
/var/www/html/system/library/currency.php:13
5 (0.586)
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.609)
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.386)
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.256)
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 (0.706)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'PersistentCart'
/var/www/html/system/storage/modification/system/library/cart.php:74
10 (0.236)
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 (0.667)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'PersistentCart'
/var/www/html/system/storage/modification/system/library/cart.php:74
12 (0.860)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'PersistentCart'
/var/www/html/system/storage/modification/system/library/cart.php:74
13 (0.185)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/var/www/html/system/library/openbay.php:117
14 (0.156)
SELECT *
FROM oc_event
/var/www/html/index.php:254
15 (1.966)
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 = '4326' 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 (0.715)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'PriceAlert'
/var/www/html/catalog/model/setting/setting.php:6
17 (0.569)
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 = '4326'
ORDER BY d DESC
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:702
18 (0.362)
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 = '115' 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.317)
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 = '63' 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.313)
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 = '199' 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.300)
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.256)
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 = '115' 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.278)
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 = '199' 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.234)
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 = '63' 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.318)
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 = '115' 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.267)
SELECT *
FROM oc_product_image
WHERE product_id = '4326'
ORDER BY sort_order ASC
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:715
27 (0.288)
SELECT *
FROM oc_product_discount
WHERE product_id = '4326' 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:709
28 (0.251)
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 = '4326' AND od.language_id = '1'
ORDER BY o.sort_order
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:664
29 (0.300)
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 = '4326' 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:636
30 (0.355)
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 = '4326' 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:723
31 (0.193)
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` = 4326 AND `status` = 1 AND `customer_group_id` = 1
ORDER BY `sort_order` ASC
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:1144
32 (0.266)
UPDATE oc_product SET viewed = (viewed + 1)
WHERE product_id = '4326'
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:4
33 (0.211)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '4326' AND store_id = '0'
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:733
34 (0.254)
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
35 (0.288)
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
36 (0.150)
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
37 (0.215)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '4326' AND store_id = '0'
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:733
38 (0.260)
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
39 (0.217)
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
40 (0.178)
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
41 (0.239)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '4326' AND store_id = '0'
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:733
42 (0.206)
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
43 (0.327)
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
44 (0.212)
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
45 (0.237)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '4326' AND store_id = '0'
/var/www/html/system/storage/modification/catalog/model/catalog/product.php:733
46 (0.204)
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
47 (0.203)
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
48 (0.150)
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
49 (0.474)
SELECT *
FROM `oc_pb_bundles`
WHERE `store_id`='0' AND `products` != '' AND `status`= '1' AND `date_available` <= NOW() AND `products_show` LIKE '%"4326"%' LIMIT 0, 5
/var/www/html/catalog/model/module/productbundles.php:92
50 (0.168)
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
51 (0.737)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'alsobought'
/var/www/html/catalog/model/setting/setting.php:6
52 (1.002)
SELECT *
FROM `oc_alsobought`
WHERE `low` = 4326 OR `high` = 4326
ORDER BY `number` DESC LIMIT 8
/var/www/html/catalog/controller/module/alsobought.php:174
53 (2.253)
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 = '3128' 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
54 (2.521)
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 = '156' 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 (1.860)
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 = '342' 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.300)
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 = '524' 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 (1.999)
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 = '1209' 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.863)
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 = '2170' 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.804)
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 = '3130' 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.769)
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 = '3145' 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 (0.247)
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
62 (0.181)
SELECT *
FROM oc_prediction
WHERE flag = 'flag'
/var/www/html/catalog/model/raprediction/raorder.php:14
63 (0.146)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'module/raprediction'
/var/www/html/catalog/model/extension/module/d_twig_manager.php:4
64 (0.151)
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
65 (0.294)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '3ckh05den0gobpi948kvvcik51'
/var/www/html/system/storage/modification/system/library/cart.php:145
66 (0.721)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'abandonedcarts'
/var/www/html/catalog/model/setting/setting.php:6
67 (2.025)
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
68 (0.374)
DELETE
FROM `oc_customer_online`
WHERE date_added < '2021-10-27 14:50:04'
/var/www/html/catalog/model/tool/online.php:4
69 (0.232)
REPLACE INTO `oc_customer_online` SET `ip` = '3.238.204.31', `customer_id` = '0', `url` = 'http://www.electronicscomp.in/index.php?route=product/product&product_id=4326', `referer` = '', `date_added` = '2021-10-27 15:50:04'
/var/www/html/catalog/model/tool/online.php:6
70 (0.151)
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
71 (0.219)
SELECT *
FROM oc_extension
WHERE `type` = 'analytics'
/var/www/html/catalog/model/extension/extension.php:4
72 (0.215)
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
73 (0.208)
SELECT *
FROM oc_colorskin
where status = 1
/var/www/html/catalog/model/catalog/colorskin.php:16
74 (1.245)
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
75 (1.032)
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
76 (1.142)
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
77 (1.132)
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
78 (0.827)
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
79 (0.935)
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
80 (0.817)
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
81 (0.834)
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
82 (0.960)
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
83 (1.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 = '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
84 (1.538)
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
85 (1.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 = '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
86 (0.961)
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
87 (1.203)
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
88 (0.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 = '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
89 (1.786)
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
90 (0.905)
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
91 (1.308)
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
92 (1.282)
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
93 (0.816)
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
94 (1.077)
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
95 (1.345)
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
96 (1.424)
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
97 (1.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 = '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
98 (0.945)
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
99 (0.945)
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
100 (0.875)
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
101 (0.895)
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
102 (0.974)
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
103 (0.858)
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
104 (1.085)
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
105 (1.101)
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
106 (0.971)
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
107 (0.737)
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
108 (0.286)
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
109 (0.229)
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
110 (0.228)
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
111 (0.330)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '3ckh05den0gobpi948kvvcik51'
/var/www/html/system/storage/modification/system/library/cart.php:145
112 (0.207)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/var/www/html/catalog/model/extension/extension.php:4
113 (0.239)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '3ckh05den0gobpi948kvvcik51'
/var/www/html/system/storage/modification/system/library/cart.php:145
114 (0.366)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '3ckh05den0gobpi948kvvcik51'
/var/www/html/system/storage/modification/system/library/cart.php:145
115 (0.416)
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
116 (0.338)
SELECT count(*) as total
from oc_product
WHERE product_id IN (3421,3520) AND status = '1' AND quantity > '0'
/var/www/html/catalog/model/module/productbundles.php:45
117 (0.307)
SELECT count(*) as total
from oc_product
WHERE product_id IN (2745,1651,1658,3201,1662,1661) AND status = '1' AND quantity > '0'
/var/www/html/catalog/model/module/productbundles.php:45
118 (0.281)
SELECT count(*) as total
from oc_product
WHERE product_id IN (1232,711,3189) AND status = '1' AND quantity > '0'
/var/www/html/catalog/model/module/productbundles.php:45
119 (0.235)
SELECT count(*) as total
from oc_product
WHERE product_id IN (1233,711,3170) AND status = '1' AND quantity > '0'
/var/www/html/catalog/model/module/productbundles.php:45
120 (0.337)
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
121 (0.220)
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
122 (0.219)
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
123 (0.304)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '3ckh05den0gobpi948kvvcik51'
/var/www/html/system/storage/modification/system/library/cart.php:145
124 (0.171)
SELECT SUM(amount) AS total
FROM oc_customer_transaction
WHERE customer_id = '0'
/var/www/html/system/library/customer.php:159
125 (0.276)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '3ckh05den0gobpi948kvvcik51'
/var/www/html/system/storage/modification/system/library/cart.php:145
126 (0.229)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '3ckh05den0gobpi948kvvcik51'
/var/www/html/system/storage/modification/system/library/cart.php:145
127 (0.147)
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
128 (0.162)
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
129 (0.696)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'advertise_google'
/var/www/html/catalog/model/setting/setting.php:6
130 (0.188)
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
131 (0.246)
select raavalue
from oc_raa_config
where raakey = 'isretargeting'
/var/www/html/catalog/model/raprediction/raonsite.php:984
132 (0.393)
SELECT category_id
FROM oc_category_description
where name='Stepper Motor'
/var/www/html/catalog/model/raprediction/raorder.php:21
133 (0.704)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'advertise_google'
/var/www/html/catalog/model/setting/setting.php:6