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

    MT8870 DTMF Decoder Module is a very tiny module that is based on MT8870 DTMF decoder ic. The module offers a 3.5mm audio connector to connect an audio source. The DTMF Signal in the audio source is decoded and the digital outputs on the module, indicate the key pressed. You may connect a phone to the module and the module will output the key(0-9, *, #, A, B, C or D)pressed on the audio source. This module is suitable for modem interfaces, mobile radios and other DTMF related applications. Can be used to build mobile controlled robots, home automation projects, IVR style applications, etc 

    This component is ideally suited to adding dual tone multi-frequency (DTMF) decoding to your project. This detection module interprets the incoming tone and produces a coded output that can be connected to all manner of microcontrollers.

    DTMF is commonly found in touch tone devices such as a phone. The tone is a combination of two separate sine waves that produce a unique signal that can be transmitted or heard. When the module receives the signal it is able to decode it and produce a binary output that can be used in other devices. The module shows the state of the signal through onboard LEDs.

    As an idea, you can connect up a mobile phone via 3.5mm to 3.5mm cable to the module. Dialling into the phone from a second mobile and then using the keypad will produce the tones on the original phone. The tones in the call can then be interpreted by the module, allowing you to control all manner of projects. The pins are suited to standard sockets with a pin pitch of 2.54mm.

    The MT8870 Tone Decoder is a kind of commonly used multi-frequency decode IC product developed by the MITEL company. It is a complete DTMF receiver. After it received the DTMF signal, it will divide the signal into high-frequency group and low-frequency group and send the signal to the digital decoder which can figure out the key value then send it to the outside Bus via four lines( Q1, Q2, Q3, Q4) as the binary form.

    Specifications & Features of MT8870 DTMF Decoder Module:-
    • Working voltage: 5V
    • Power Consumption: 500MW(MAX)r: 500 mw (MAX)
    • On-board voice input interface
    • On-board LED, it is very convenient to check the output state.
    • Onboard 5 x LED indicators for easy viewing output state
    • Operating Temperature : -40-+85 °C
    • IO Drive : Current Maximum 10mA.
    • PCB Size : 25.4x25.4MM
    • This decoding module is for mobile and fixed telephone voice dialing decoding function
    • Designed specifically for ARDUINO Board. Can also be used for other MCUs(AVR PIC MSP430 STM32 ARM7/9/10/11 FPGA/CPLD)
    • Low power consumption
    • Internal gain setting amplifier
    • Adjustable guard time
    •  Central office quality
    • Onboard 3.5mm input interface
    • 5 Channel interface
    • On-board MT8870 frequency decoder chip
    • Power-down mode
    • Inhibit mode
    • Does not require external circuits or wiring, it can be inserted directly into the UNO/MEGA2560/DUE board to use.
    • 12-Digital outputs decode mobile and fixed telephone keys (0-9, * #). Also, another 4 Digital output(ABCD) can use “DTMF Dial” for Software control.

    Write a review
    Please login or register to review

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

    MT8870 DTMF Decoder Module

    • Product Code: EC-3211
    • Reward Points: 1.07
    • Availability: 42
    • Rs.107.00
    • (Excluding 18% GST)
    • Price in reward points: 107

    • Wholesale Pricing
      Select Quantity Discount Price per piece
      1 - 9 0% 107.0000
      10 - 24 4% Rs.103.00
      25 - 49 9% Rs.97.00
      50 - 99 16% Rs.90.00
      100+ 23% Rs.82.00

    Queries: 133, Total time: 97.770 ms [By time] [By id] [By file]
    1 (0.312)
    SELECT *
    FROM oc_store
    WHERE REPLACE(`url`, 'www.', '') = 'http://electronicscomp.in/'
    /var/www/html/index.php:44
    2 (10.467)
    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.303)
    SELECT *
    FROM `oc_language`
    WHERE status = '1'
    /var/www/html/index.php:153
    4 (0.351)
    SELECT *
    FROM oc_currency
    /var/www/html/system/library/currency.php:13
    5 (0.652)
    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.466)
    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.356)
    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.243)
    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.678)
    SELECT *
    FROM oc_setting
    WHERE store_id = '0' AND `code` = 'PersistentCart'
    /var/www/html/system/storage/modification/system/library/cart.php:74
    10 (0.248)
    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.631)
    SELECT *
    FROM oc_setting
    WHERE store_id = '0' AND `code` = 'PersistentCart'
    /var/www/html/system/storage/modification/system/library/cart.php:74
    12 (0.779)
    SELECT *
    FROM oc_setting
    WHERE store_id = '0' AND `code` = 'PersistentCart'
    /var/www/html/system/storage/modification/system/library/cart.php:74
    13 (0.192)
    SELECT *
    FROM oc_extension
    WHERE `type` = 'openbay'
    /var/www/html/system/library/openbay.php:117
    14 (0.212)
    SELECT *
    FROM oc_event
    /var/www/html/index.php:254
    15 (2.092)
    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 = '3284' 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.677)
    SELECT *
    FROM oc_setting
    WHERE store_id = '0' AND `code` = 'PriceAlert'
    /var/www/html/catalog/model/setting/setting.php:6
    17 (0.571)
    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 = '3284'
    ORDER BY d DESC
    /var/www/html/system/storage/modification/catalog/model/catalog/product.php:702
    18 (0.314)
    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 = '387' 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.345)
    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 = '118' 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.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 = '197' 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.188)
    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.224)
    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 = '387' 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.307)
    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 = '197' 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.217)
    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 = '118' 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.298)
    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 = '387' 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.324)
    SELECT *
    FROM oc_product_image
    WHERE product_id = '3284'
    ORDER BY sort_order ASC
    /var/www/html/system/storage/modification/catalog/model/catalog/product.php:715
    27 (0.386)
    SELECT *
    FROM oc_product_discount
    WHERE product_id = '3284' 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.198)
    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 = '3284' AND od.language_id = '1'
    ORDER BY o.sort_order
    /var/www/html/system/storage/modification/catalog/model/catalog/product.php:664
    29 (0.305)
    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 = '3284' 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.347)
    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 = '3284' 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.219)
    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` = 3284 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.247)
    UPDATE oc_product SET viewed = (viewed + 1)
    WHERE product_id = '3284'
    /var/www/html/system/storage/modification/catalog/model/catalog/product.php:4
    33 (0.251)
    SELECT *
    FROM oc_product_to_layout
    WHERE product_id = '3284' AND store_id = '0'
    /var/www/html/system/storage/modification/catalog/model/catalog/product.php:733
    34 (0.227)
    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.186)
    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.147)
    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.232)
    SELECT *
    FROM oc_product_to_layout
    WHERE product_id = '3284' AND store_id = '0'
    /var/www/html/system/storage/modification/catalog/model/catalog/product.php:733
    38 (0.200)
    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.226)
    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.180)
    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.234)
    SELECT *
    FROM oc_product_to_layout
    WHERE product_id = '3284' AND store_id = '0'
    /var/www/html/system/storage/modification/catalog/model/catalog/product.php:733
    42 (0.242)
    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.183)
    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.178)
    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.190)
    SELECT *
    FROM oc_product_to_layout
    WHERE product_id = '3284' AND store_id = '0'
    /var/www/html/system/storage/modification/catalog/model/catalog/product.php:733
    46 (0.191)
    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.233)
    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.146)
    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.309)
    SELECT *
    FROM `oc_pb_bundles`
    WHERE `store_id`='0' AND `products` != '' AND `status`= '1' AND `date_available` <= NOW() AND `products_show` LIKE '%"3284"%' LIMIT 0, 5
    /var/www/html/catalog/model/module/productbundles.php:92
    50 (0.163)
    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.755)
    SELECT *
    FROM oc_setting
    WHERE store_id = '0' AND `code` = 'alsobought'
    /var/www/html/catalog/model/setting/setting.php:6
    52 (1.966)
    SELECT *
    FROM `oc_alsobought`
    WHERE `low` = 3284 OR `high` = 3284
    ORDER BY `number` DESC LIMIT 8
    /var/www/html/catalog/controller/module/alsobought.php:174
    53 (2.333)
    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 = '798' 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.626)
    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
    55 (2.299)
    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 = '192' 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.573)
    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 = '124' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    /var/www/html/system/storage/modification/catalog/model/catalog/product.php:15
    57 (2.003)
    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 = '421' 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 (2.156)
    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 = '956' 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 (2.516)
    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 = '191' 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.862)
    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 = '228' 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.279)
    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.223)
    SELECT *
    FROM oc_prediction
    WHERE flag = 'flag'
    /var/www/html/catalog/model/raprediction/raorder.php:14
    63 (0.210)
    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.154)
    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.328)
    SELECT *
    FROM oc_cart
    WHERE customer_id = '0' AND session_id = '52tbkn2r9jj2n45bo2i0o6drv5'
    /var/www/html/system/storage/modification/system/library/cart.php:145
    66 (0.685)
    SELECT *
    FROM oc_setting
    WHERE store_id = '0' AND `code` = 'abandonedcarts'
    /var/www/html/catalog/model/setting/setting.php:6
    67 (2.205)
    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.445)
    DELETE
    FROM `oc_customer_online`
    WHERE date_added < '2021-10-27 15:17:08'
    /var/www/html/catalog/model/tool/online.php:4
    69 (0.264)
    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=3284', `referer` = '', `date_added` = '2021-10-27 16:17:08'
    /var/www/html/catalog/model/tool/online.php:6
    70 (0.149)
    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.232)
    SELECT *
    FROM oc_extension
    WHERE `type` = 'analytics'
    /var/www/html/catalog/model/extension/extension.php:4
    72 (0.262)
    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.232)
    SELECT *
    FROM oc_colorskin
    where status = 1
    /var/www/html/catalog/model/catalog/colorskin.php:16
    74 (1.400)
    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.211)
    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.262)
    SELECT *
    FROM oc_category c
    LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
    LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
    WHERE c.parent_id = '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.076)
    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.861)
    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.906)
    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.777)
    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 (1.014)
    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.389)
    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.523)
    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.181)
    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.957)
    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.255)
    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.887)
    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.681)
    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.939)
    SELECT *
    FROM oc_category c
    LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
    LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
    WHERE c.parent_id = '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.080)
    SELECT *
    FROM oc_category c
    LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
    LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
    WHERE c.parent_id = '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.061)
    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.963)
    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.103)
    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.334)
    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.227)
    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 (0.922)
    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.932)
    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.838)
    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.940)
    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 (1.004)
    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.899)
    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.805)
    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.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 = '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.072)
    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.828)
    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.952)
    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.284)
    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.156)
    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.227)
    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.306)
    SELECT *
    FROM oc_cart
    WHERE customer_id = '0' AND session_id = '52tbkn2r9jj2n45bo2i0o6drv5'
    /var/www/html/system/storage/modification/system/library/cart.php:145
    112 (0.226)
    SELECT *
    FROM oc_extension
    WHERE `type` = 'total'
    /var/www/html/catalog/model/extension/extension.php:4
    113 (0.299)
    SELECT *
    FROM oc_cart
    WHERE customer_id = '0' AND session_id = '52tbkn2r9jj2n45bo2i0o6drv5'
    /var/www/html/system/storage/modification/system/library/cart.php:145
    114 (0.289)
    SELECT *
    FROM oc_cart
    WHERE customer_id = '0' AND session_id = '52tbkn2r9jj2n45bo2i0o6drv5'
    /var/www/html/system/storage/modification/system/library/cart.php:145
    115 (0.393)
    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.355)
    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.300)
    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.272)
    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.254)
    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.305)
    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.274)
    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.283)
    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.279)
    SELECT *
    FROM oc_cart
    WHERE customer_id = '0' AND session_id = '52tbkn2r9jj2n45bo2i0o6drv5'
    /var/www/html/system/storage/modification/system/library/cart.php:145
    124 (0.150)
    SELECT SUM(amount) AS total
    FROM oc_customer_transaction
    WHERE customer_id = '0'
    /var/www/html/system/library/customer.php:159
    125 (0.225)
    SELECT *
    FROM oc_cart
    WHERE customer_id = '0' AND session_id = '52tbkn2r9jj2n45bo2i0o6drv5'
    /var/www/html/system/storage/modification/system/library/cart.php:145
    126 (0.262)
    SELECT *
    FROM oc_cart
    WHERE customer_id = '0' AND session_id = '52tbkn2r9jj2n45bo2i0o6drv5'
    /var/www/html/system/storage/modification/system/library/cart.php:145
    127 (0.194)
    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.191)
    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.711)
    SELECT *
    FROM oc_setting
    WHERE store_id = '0' AND `code` = 'advertise_google'
    /var/www/html/catalog/model/setting/setting.php:6
    130 (0.152)
    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.179)
    select raavalue
    from oc_raa_config
    where raakey = 'isretargeting'
    /var/www/html/catalog/model/raprediction/raonsite.php:984
    132 (0.288)
    SELECT category_id
    FROM oc_category_description
    where name='Audio Amplifier Module'
    /var/www/html/catalog/model/raprediction/raorder.php:21
    133 (0.702)
    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: 97.770 ms [By time] [By id] [By file]
    1 (0.312)
    SELECT *
    FROM oc_store
    WHERE REPLACE(`url`, 'www.', '') = 'http://electronicscomp.in/'
    /var/www/html/index.php:44
    2 (10.467)
    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.303)
    SELECT *
    FROM `oc_language`
    WHERE status = '1'
    /var/www/html/index.php:153
    4 (0.351)
    SELECT *
    FROM oc_currency
    /var/www/html/system/library/currency.php:13
    5 (0.652)
    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.466)
    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.356)
    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.243)
    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.678)
    SELECT *
    FROM oc_setting
    WHERE store_id = '0' AND `code` = 'PersistentCart'
    /var/www/html/system/storage/modification/system/library/cart.php:74
    10 (0.248)
    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.631)
    SELECT *
    FROM oc_setting
    WHERE store_id = '0' AND `code` = 'PersistentCart'
    /var/www/html/system/storage/modification/system/library/cart.php:74
    12 (0.779)
    SELECT *
    FROM oc_setting
    WHERE store_id = '0' AND `code` = 'PersistentCart'
    /var/www/html/system/storage/modification/system/library/cart.php:74
    13 (0.192)
    SELECT *
    FROM oc_extension
    WHERE `type` = 'openbay'
    /var/www/html/system/library/openbay.php:117
    14 (0.212)
    SELECT *
    FROM oc_event
    /var/www/html/index.php:254
    15 (2.092)
    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 = '3284' 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.677)
    SELECT *
    FROM oc_setting
    WHERE store_id = '0' AND `code` = 'PriceAlert'
    /var/www/html/catalog/model/setting/setting.php:6
    17 (0.571)
    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 = '3284'
    ORDER BY d DESC
    /var/www/html/system/storage/modification/catalog/model/catalog/product.php:702
    18 (0.314)
    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 = '387' 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.345)
    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 = '118' 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.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 = '197' 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.188)
    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.224)
    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 = '387' 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.307)
    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 = '197' 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.217)
    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 = '118' 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.298)
    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 = '387' 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.324)
    SELECT *
    FROM oc_product_image
    WHERE product_id = '3284'
    ORDER BY sort_order ASC
    /var/www/html/system/storage/modification/catalog/model/catalog/product.php:715
    27 (0.386)
    SELECT *
    FROM oc_product_discount
    WHERE product_id = '3284' 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.198)
    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 = '3284' AND od.language_id = '1'
    ORDER BY o.sort_order
    /var/www/html/system/storage/modification/catalog/model/catalog/product.php:664
    29 (0.305)
    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 = '3284' 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.347)
    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 = '3284' 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.219)
    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` = 3284 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.247)
    UPDATE oc_product SET viewed = (viewed + 1)
    WHERE product_id = '3284'
    /var/www/html/system/storage/modification/catalog/model/catalog/product.php:4
    33 (0.251)
    SELECT *
    FROM oc_product_to_layout
    WHERE product_id = '3284' AND store_id = '0'
    /var/www/html/system/storage/modification/catalog/model/catalog/product.php:733
    34 (0.227)
    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.186)
    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.147)
    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.232)
    SELECT *
    FROM oc_product_to_layout
    WHERE product_id = '3284' AND store_id = '0'
    /var/www/html/system/storage/modification/catalog/model/catalog/product.php:733
    38 (0.200)
    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.226)
    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.180)
    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.234)
    SELECT *
    FROM oc_product_to_layout
    WHERE product_id = '3284' AND store_id = '0'
    /var/www/html/system/storage/modification/catalog/model/catalog/product.php:733
    42 (0.242)
    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.183)
    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.178)
    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.190)
    SELECT *
    FROM oc_product_to_layout
    WHERE product_id = '3284' AND store_id = '0'
    /var/www/html/system/storage/modification/catalog/model/catalog/product.php:733
    46 (0.191)
    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.233)
    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.146)
    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.309)
    SELECT *
    FROM `oc_pb_bundles`
    WHERE `store_id`='0' AND `products` != '' AND `status`= '1' AND `date_available` <= NOW() AND `products_show` LIKE '%"3284"%' LIMIT 0, 5
    /var/www/html/catalog/model/module/productbundles.php:92
    50 (0.163)
    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.755)
    SELECT *
    FROM oc_setting
    WHERE store_id = '0' AND `code` = 'alsobought'
    /var/www/html/catalog/model/setting/setting.php:6
    52 (1.966)
    SELECT *
    FROM `oc_alsobought`
    WHERE `low` = 3284 OR `high` = 3284
    ORDER BY `number` DESC LIMIT 8
    /var/www/html/catalog/controller/module/alsobought.php:174
    53 (2.333)
    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 = '798' 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.626)
    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
    55 (2.299)
    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 = '192' 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.573)
    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 = '124' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    /var/www/html/system/storage/modification/catalog/model/catalog/product.php:15
    57 (2.003)
    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 = '421' 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 (2.156)
    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 = '956' 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 (2.516)
    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 = '191' 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.862)
    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 = '228' 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.279)
    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.223)
    SELECT *
    FROM oc_prediction
    WHERE flag = 'flag'
    /var/www/html/catalog/model/raprediction/raorder.php:14
    63 (0.210)
    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.154)
    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.328)
    SELECT *
    FROM oc_cart
    WHERE customer_id = '0' AND session_id = '52tbkn2r9jj2n45bo2i0o6drv5'
    /var/www/html/system/storage/modification/system/library/cart.php:145
    66 (0.685)
    SELECT *
    FROM oc_setting
    WHERE store_id = '0' AND `code` = 'abandonedcarts'
    /var/www/html/catalog/model/setting/setting.php:6
    67 (2.205)
    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.445)
    DELETE
    FROM `oc_customer_online`
    WHERE date_added < '2021-10-27 15:17:08'
    /var/www/html/catalog/model/tool/online.php:4
    69 (0.264)
    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=3284', `referer` = '', `date_added` = '2021-10-27 16:17:08'
    /var/www/html/catalog/model/tool/online.php:6
    70 (0.149)
    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.232)
    SELECT *
    FROM oc_extension
    WHERE `type` = 'analytics'
    /var/www/html/catalog/model/extension/extension.php:4
    72 (0.262)
    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.232)
    SELECT *
    FROM oc_colorskin
    where status = 1
    /var/www/html/catalog/model/catalog/colorskin.php:16
    74 (1.400)
    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.211)
    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.262)
    SELECT *
    FROM oc_category c
    LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
    LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
    WHERE c.parent_id = '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.076)
    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.861)
    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.906)
    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.777)
    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 (1.014)
    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.389)
    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.523)
    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.181)
    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.957)
    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.255)
    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.887)
    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.681)
    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.939)
    SELECT *
    FROM oc_category c
    LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
    LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
    WHERE c.parent_id = '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.080)
    SELECT *
    FROM oc_category c
    LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
    LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
    WHERE c.parent_id = '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.061)
    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.963)
    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.103)
    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.334)
    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.227)
    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 (0.922)
    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.932)
    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.838)
    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.940)
    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 (1.004)
    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.899)
    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.805)
    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.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 = '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.072)
    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.828)
    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.952)
    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.284)
    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.156)
    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.227)
    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.306)
    SELECT *
    FROM oc_cart
    WHERE customer_id = '0' AND session_id = '52tbkn2r9jj2n45bo2i0o6drv5'
    /var/www/html/system/storage/modification/system/library/cart.php:145
    112 (0.226)
    SELECT *
    FROM oc_extension
    WHERE `type` = 'total'
    /var/www/html/catalog/model/extension/extension.php:4
    113 (0.299)
    SELECT *
    FROM oc_cart
    WHERE customer_id = '0' AND session_id = '52tbkn2r9jj2n45bo2i0o6drv5'
    /var/www/html/system/storage/modification/system/library/cart.php:145
    114 (0.289)
    SELECT *
    FROM oc_cart
    WHERE customer_id = '0' AND session_id = '52tbkn2r9jj2n45bo2i0o6drv5'
    /var/www/html/system/storage/modification/system/library/cart.php:145
    115 (0.393)
    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.355)
    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.300)
    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.272)
    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.254)
    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.305)
    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.274)
    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.283)
    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.279)
    SELECT *
    FROM oc_cart
    WHERE customer_id = '0' AND session_id = '52tbkn2r9jj2n45bo2i0o6drv5'
    /var/www/html/system/storage/modification/system/library/cart.php:145
    124 (0.150)
    SELECT SUM(amount) AS total
    FROM oc_customer_transaction
    WHERE customer_id = '0'
    /var/www/html/system/library/customer.php:159
    125 (0.225)
    SELECT *
    FROM oc_cart
    WHERE customer_id = '0' AND session_id = '52tbkn2r9jj2n45bo2i0o6drv5'
    /var/www/html/system/storage/modification/system/library/cart.php:145
    126 (0.262)
    SELECT *
    FROM oc_cart
    WHERE customer_id = '0' AND session_id = '52tbkn2r9jj2n45bo2i0o6drv5'
    /var/www/html/system/storage/modification/system/library/cart.php:145
    127 (0.194)
    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.191)
    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.711)
    SELECT *
    FROM oc_setting
    WHERE store_id = '0' AND `code` = 'advertise_google'
    /var/www/html/catalog/model/setting/setting.php:6
    130 (0.152)
    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.179)
    select raavalue
    from oc_raa_config
    where raakey = 'isretargeting'
    /var/www/html/catalog/model/raprediction/raonsite.php:984
    132 (0.288)
    SELECT category_id
    FROM oc_category_description
    where name='Audio Amplifier Module'
    /var/www/html/catalog/model/raprediction/raorder.php:21
    133 (0.702)
    SELECT *
    FROM oc_setting
    WHERE store_id = '0' AND `code` = 'advertise_google'
    /var/www/html/catalog/model/setting/setting.php:6