Shaft Assembly Agitator LG

Brand: LG
Product Code: AHR72909401
MPN:
EAN: AHR72909401
Found it cheaper ?
₪120.00

  • Availability: In Stock


Shipping and payment
Pickup

Pickup

Pickup from our shop

Cash

Cash

Cash payment upon receipt of products in our store

Courier delivery

Courier delivery

Courier delivery

Credit Card

Credit Card

We work with all major credit cards

Shaft Assembly Agitator LG AHR72909401

Fit To:

VR6140LV, VR5942L, VR6170LVM, VR5901, VR6480VMN

There are no reviews for this product.

Write a review

Note: HTML is not translated!
    Bad           Good


Related Products
Queries: 460, Total time: 1,343.167 ms [By time] [By id] [By file]
1 (0.535)
SELECT `data`
FROM `oc_session`
WHERE session_id = '641dcf8d811308414b98f275d9' AND expire > 1574047152
/home/sakit/public_html/system/library/session/db.php:21
2 (0.208)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/home/sakit/public_html/system/library/openbay.php:61
3 (0.139)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '0' AND (route = 'engb' OR route = '')
/home/sakit/public_html/catalog/model/design/translation.php:6
4 (0.141)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/home/sakit/public_html/system/library/openbay.php:61
5 (0.129)
SELECT `data`
FROM `oc_session`
WHERE session_id = '4a530b6f750fd8577e6c57fa94' AND expire > 1574047152
/home/sakit/public_html/system/library/session/db.php:21
6 (0.106)
SELECT *
FROM oc_store
WHERE REPLACE(`url`, 'www.', '') = 'http://sakit.co.il/'
/home/sakit/storage/modification/catalog/controller/startup/startup.php:8
7 (27.262)
SELECT *
FROM `oc_setting`
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
/home/sakit/storage/modification/catalog/controller/startup/startup.php:28
8 (0.308)
SELECT *
FROM oc_language
WHERE status = '1'
ORDER BY sort_order, name
/home/sakit/public_html/catalog/model/localisation/language.php:15
9 (5.656)
SELECT *
FROM oc_currency
/home/sakit/public_html/system/library/cart/currency.php:10
10 (0.502)
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 = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '104' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0')
ORDER BY tr1.priority ASC
/home/sakit/storage/modification/system/library/cart/tax.php:22
11 (0.330)
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 = '104' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0')
ORDER BY tr1.priority ASC
/home/sakit/storage/modification/system/library/cart/tax.php:50
12 (0.284)
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'
/home/sakit/public_html/system/library/cart/weight.php:10
13 (0.202)
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'
/home/sakit/public_html/system/library/cart/length.php:10
14 (0.190)
DELETE
FROM oc_cart
WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)
/home/sakit/public_html/system/library/cart/cart.php:15
15 (0.262)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/home/sakit/public_html/system/library/openbay.php:61
16 (0.187)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '4a530b6f750fd8577e6c57fa94'
/home/sakit/public_html/system/library/cart/cart.php:36
17 (0.144)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '4a530b6f750fd8577e6c57fa94'
/home/sakit/public_html/system/library/cart/cart.php:36
18 (0.383)
SELECT *
FROM oc_seo_url
WHERE keyword = 'shaft-assembly-agitator-lg' AND language_id = 1 AND store_id = 0
/home/sakit/public_html/system/library/google_marketing_tools/master.php:383
19 (0.224)
SELECT *
FROM oc_seo_url
WHERE keyword = 'shaft-assembly-agitator-lg' AND language_id = 1 AND store_id = 0
/home/sakit/public_html/system/library/google_marketing_tools/master.php:749
20 (0.172)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '4a530b6f750fd8577e6c57fa94'
/home/sakit/public_html/system/library/cart/cart.php:36
21 (0.146)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '4a530b6f750fd8577e6c57fa94'
/home/sakit/public_html/system/library/cart/cart.php:36
22 (0.222)
SELECT *
FROM oc_seo_url
WHERE keyword = 'shaft-assembly-agitator-lg' AND language_id = 1 AND store_id = 0
/home/sakit/public_html/system/library/google_marketing_tools/master.php:383
23 (0.216)
SELECT *
FROM oc_seo_url
WHERE keyword = 'shaft-assembly-agitator-lg' AND language_id = 1 AND store_id = 0
/home/sakit/public_html/system/library/google_marketing_tools/master.php:749
24 (0.159)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '4a530b6f750fd8577e6c57fa94'
/home/sakit/public_html/system/library/cart/cart.php:36
25 (0.140)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '4a530b6f750fd8577e6c57fa94'
/home/sakit/public_html/system/library/cart/cart.php:36
26 (0.215)
SELECT *
FROM oc_seo_url
WHERE keyword = 'shaft-assembly-agitator-lg' AND language_id = 1 AND store_id = 0
/home/sakit/public_html/system/library/google_marketing_tools/master.php:383
27 (0.215)
SELECT *
FROM oc_seo_url
WHERE keyword = 'shaft-assembly-agitator-lg' AND language_id = 1 AND store_id = 0
/home/sakit/public_html/system/library/google_marketing_tools/master.php:749
28 (0.149)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '4a530b6f750fd8577e6c57fa94'
/home/sakit/public_html/system/library/cart/cart.php:36
29 (0.160)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '4a530b6f750fd8577e6c57fa94'
/home/sakit/public_html/system/library/cart/cart.php:36
30 (0.215)
SELECT *
FROM oc_seo_url
WHERE keyword = 'shaft-assembly-agitator-lg' AND language_id = 1 AND store_id = 0
/home/sakit/public_html/system/library/google_marketing_tools/master.php:383
31 (0.225)
SELECT *
FROM oc_seo_url
WHERE keyword = 'shaft-assembly-agitator-lg' AND language_id = 1 AND store_id = 0
/home/sakit/public_html/system/library/google_marketing_tools/master.php:749
32 (0.152)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '4a530b6f750fd8577e6c57fa94'
/home/sakit/public_html/system/library/cart/cart.php:36
33 (0.137)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '4a530b6f750fd8577e6c57fa94'
/home/sakit/public_html/system/library/cart/cart.php:36
34 (0.228)
SELECT *
FROM oc_seo_url
WHERE keyword = 'shaft-assembly-agitator-lg' AND language_id = 1 AND store_id = 0
/home/sakit/public_html/system/library/google_marketing_tools/master.php:383
35 (0.213)
SELECT *
FROM oc_seo_url
WHERE keyword = 'shaft-assembly-agitator-lg' AND language_id = 1 AND store_id = 0
/home/sakit/public_html/system/library/google_marketing_tools/master.php:749
36 (0.146)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '4a530b6f750fd8577e6c57fa94'
/home/sakit/public_html/system/library/cart/cart.php:36
37 (0.137)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '4a530b6f750fd8577e6c57fa94'
/home/sakit/public_html/system/library/cart/cart.php:36
38 (0.230)
SELECT *
FROM oc_seo_url
WHERE keyword = 'shaft-assembly-agitator-lg' AND language_id = 1 AND store_id = 0
/home/sakit/public_html/system/library/google_marketing_tools/master.php:383
39 (0.216)
SELECT *
FROM oc_seo_url
WHERE keyword = 'shaft-assembly-agitator-lg' AND language_id = 1 AND store_id = 0
/home/sakit/public_html/system/library/google_marketing_tools/master.php:749
40 (0.152)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '4a530b6f750fd8577e6c57fa94'
/home/sakit/public_html/system/library/cart/cart.php:36
41 (0.137)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '4a530b6f750fd8577e6c57fa94'
/home/sakit/public_html/system/library/cart/cart.php:36
42 (0.224)
SELECT *
FROM oc_seo_url
WHERE keyword = 'shaft-assembly-agitator-lg' AND language_id = 1 AND store_id = 0
/home/sakit/public_html/system/library/google_marketing_tools/master.php:383
43 (0.217)
SELECT *
FROM oc_seo_url
WHERE keyword = 'shaft-assembly-agitator-lg' AND language_id = 1 AND store_id = 0
/home/sakit/public_html/system/library/google_marketing_tools/master.php:749
44 (0.148)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '4a530b6f750fd8577e6c57fa94'
/home/sakit/public_html/system/library/cart/cart.php:36
45 (0.136)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '4a530b6f750fd8577e6c57fa94'
/home/sakit/public_html/system/library/cart/cart.php:36
46 (0.209)
SELECT *
FROM oc_seo_url
WHERE keyword = 'shaft-assembly-agitator-lg' AND language_id = 1 AND store_id = 0
/home/sakit/public_html/system/library/google_marketing_tools/master.php:383
47 (0.234)
SELECT *
FROM oc_seo_url
WHERE keyword = 'shaft-assembly-agitator-lg' AND language_id = 1 AND store_id = 0
/home/sakit/public_html/system/library/google_marketing_tools/master.php:749
48 (0.159)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '4a530b6f750fd8577e6c57fa94'
/home/sakit/public_html/system/library/cart/cart.php:36
49 (0.142)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '4a530b6f750fd8577e6c57fa94'
/home/sakit/public_html/system/library/cart/cart.php:36
50 (0.215)
SELECT *
FROM oc_seo_url
WHERE keyword = 'shaft-assembly-agitator-lg' AND language_id = 1 AND store_id = 0
/home/sakit/public_html/system/library/google_marketing_tools/master.php:383
51 (0.239)
SELECT *
FROM oc_seo_url
WHERE keyword = 'shaft-assembly-agitator-lg' AND language_id = 1 AND store_id = 0
/home/sakit/public_html/system/library/google_marketing_tools/master.php:749
52 (0.148)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '4a530b6f750fd8577e6c57fa94'
/home/sakit/public_html/system/library/cart/cart.php:36
53 (0.136)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '4a530b6f750fd8577e6c57fa94'
/home/sakit/public_html/system/library/cart/cart.php:36
54 (0.216)
SELECT *
FROM oc_seo_url
WHERE keyword = 'shaft-assembly-agitator-lg' AND language_id = 1 AND store_id = 0
/home/sakit/public_html/system/library/google_marketing_tools/master.php:383
55 (0.250)
SELECT *
FROM oc_seo_url
WHERE keyword = 'shaft-assembly-agitator-lg' AND language_id = 1 AND store_id = 0
/home/sakit/public_html/system/library/google_marketing_tools/master.php:749
56 (1.086)
SELECT *
FROM `oc_event`
WHERE `trigger` LIKE 'catalog/%' AND status = '1'
ORDER BY `sort_order` ASC
/home/sakit/public_html/catalog/model/setting/event.php:4
57 (12.353)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'abandonedcarts'
/home/sakit/public_html/catalog/model/setting/setting.php:6
58 (0.387)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
59 (12.001)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
60 (0.392)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module_url.php:13
61 (12.160)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
62 (0.414)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
63 (12.322)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
64 (0.107)
SELECT *
FROM oc_store
ORDER BY url
/home/sakit/public_html/catalog/model/setting/store.php:7
65 (0.236)
SELECT *
FROM oc_language
WHERE status = '1'
ORDER BY sort_order, name
/home/sakit/public_html/catalog/model/localisation/language.php:15
66 (0.356)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
67 (12.022)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
68 (0.729)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
69 (12.677)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
70 (6.737)
SELECT *
FROM oc_store
ORDER BY url
/home/sakit/public_html/catalog/model/setting/store.php:7
71 (0.469)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module_url.php:13
72 (14.108)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
73 (0.382)
SELECT query as route, store_id, language_id, keyword
FROM oc_seo_url
WHERE keyword = 'shaft-assembly-agitator-lg'
/home/sakit/public_html/catalog/model/extension/d_seo_module/d_seo_module_url.php:325
74 (0.213)
SELECT *
FROM oc_language
WHERE language_id = '1'
/home/sakit/public_html/catalog/model/localisation/language.php:4
75 (0.166)
SELECT category_id
FROM oc_d_product_category
WHERE product_id = '1510'
/home/sakit/public_html/catalog/model/extension/d_seo_module/d_seo_module_url.php:159
76 (0.719)
SELECT GROUP_CONCAT(c.category_id
ORDER BY level SEPARATOR '_') as category_path
FROM oc_category_path cp
LEFT JOIN oc_category c ON (cp.path_id = c.category_id)
WHERE cp.category_id = '63' GROUP BY cp.category_id
/home/sakit/public_html/catalog/model/extension/d_seo_module/d_seo_module_url.php:144
77 (0.230)
SELECT *
FROM oc_d_url_redirect
WHERE url_from = 'sakit.co.il/shaft-assembly-agitator-lg'
/home/sakit/public_html/catalog/model/extension/d_seo_module/d_seo_module_url.php:230
78 (0.160)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/notifywhenavailable' OR route = 'en-gb')
/home/sakit/public_html/catalog/model/design/translation.php:6
79 (0.136)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/question_answer' OR route = 'en-gb')
/home/sakit/public_html/catalog/model/design/translation.php:6
80 (0.129)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'product/product' OR route = 'en-gb')
/home/sakit/public_html/catalog/model/design/translation.php:6
81 (1.073)
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 = '2' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/home/sakit/public_html/catalog/model/catalog/category.php:4
82 (0.461)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
83 (14.380)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
84 (0.421)
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 = '45' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/home/sakit/public_html/catalog/model/catalog/category.php:4
85 (0.457)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
86 (18.447)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
87 (0.642)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '63' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/home/sakit/public_html/catalog/model/catalog/category.php:4
88 (0.459)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
89 (16.526)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
90 (1.194)
SELECT DISTINCT *, pd.name AS name, (SELECT allow_order
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = 1) AS stock_allow_order, 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 pr.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,(SELECT date_end
FROM oc_product_special
WHERE product_id = '1510' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, price ASC LIMIT 1) AS date_end, 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 = '1510' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/sakit/storage/modification/catalog/model/catalog/product.php:39
91 (0.143)
SELECT `name`
FROM oc_manufacturer_description
WHERE language_id = '1' AND manufacturer_id = '21'
/home/sakit/storage/modification/catalog/model/catalog/product.php:41
92 (0.551)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
93 (12.374)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
94 (0.138)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/notifywhenavailable' OR route = 'en-gb')
/home/sakit/public_html/catalog/model/design/translation.php:6
95 (0.124)
SELECT `stock_status_id`
FROM `oc_product`
WHERE `product_id` = 1510
/home/sakit/public_html/catalog/controller/extension/module/notifywhenavailable.php:663
96 (0.128)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/questions_and_answers' OR route = 'en-gb')
/home/sakit/public_html/catalog/model/design/translation.php:6
97 (0.219)
SELECT *
FROM `oc_module`
WHERE `code` = 'questions_and_answers'
ORDER BY `name`
/home/sakit/public_html/catalog/model/extension/module/questions_and_answers.php:7
98 (0.122)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/questions_and_answers' OR route = 'en-gb')
/home/sakit/public_html/catalog/model/design/translation.php:6
99 (1.395)
SELECT COUNT(DISTINCT q.question_id) AS total
FROM oc_question q
LEFT JOIN oc_question_text qt ON (q.question_id = qt.question_id)
LEFT JOIN oc_question_to_product q2p ON (q.question_id = q2p.question_id)
LEFT JOIN oc_question_to_store q2s ON (q.question_id = q2s.question_id)
WHERE q2s.store_id = '0' AND q2p.product_id = '1510' AND q.status = '1' AND qt.language_id = '1'
/home/sakit/public_html/catalog/model/extension/module/questions_and_answers.php:314
100 (4.137)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'newstore' AND route = 'extension/module/qap/module'
/home/sakit/public_html/catalog/model/design/theme.php:4
101 (0.232)
SELECT DISTINCT *
FROM oc_product_tabs_ns ptn
LEFT JOIN oc_tabs_ns tn ON (tn.tabs_ns_id = ptn.tabs_ns_id)
LEFT JOIN oc_tabs_description_ns tdn ON (tdn.tabs_ns_id = ptn.tabs_ns_id)
WHERE ptn.product_id = '1510' AND ptn.language_id = '1' AND tdn.language_id = '1' AND tn.status = '1'
/home/sakit/public_html/catalog/model/catalog/product_tabs.php:5
102 (0.149)
SELECT status
FROM oc_modification
WHERE `code`='NS->QUICK-ORDER'
/home/sakit/public_html/catalog/model/ns/moduleonoff.php:12
103 (0.126)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'ns/newstorelang' OR route = 'en-gb')
/home/sakit/public_html/catalog/model/design/translation.php:6
104 (0.212)
SELECT SUM(quantity) AS total
FROM oc_order_product op
WHERE op.product_id = '1510'
/home/sakit/storage/modification/catalog/model/catalog/product.php:460
105 (0.180)
SELECT DISTINCT *
FROM oc_product_tabs_ns ptn
LEFT JOIN oc_tabs_ns tn ON (tn.tabs_ns_id = ptn.tabs_ns_id)
LEFT JOIN oc_tabs_description_ns tdn ON (tdn.tabs_ns_id = ptn.tabs_ns_id)
WHERE ptn.product_id = '1510' AND ptn.language_id = '1' AND tdn.language_id = '1' AND tn.status = '1'
/home/sakit/public_html/catalog/model/catalog/product_tabs.php:5
106 (0.225)
SELECT *
FROM oc_product_image
WHERE product_id = '1510'
ORDER BY sort_order ASC
/home/sakit/storage/modification/catalog/model/catalog/product.php:668
107 (0.259)
SELECT *
FROM oc_product_discount
WHERE product_id = '1510' 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
/home/sakit/storage/modification/catalog/model/catalog/product.php:631
108 (8.072)
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 = '1510' AND od.language_id = '1'
ORDER BY o.sort_order
/home/sakit/storage/modification/catalog/model/catalog/product.php:549
109 (1.729)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/notifywhenavailable' OR route = 'en-gb')
/home/sakit/public_html/catalog/model/design/translation.php:6
110 (12.834)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/captcha/google' OR route = 'en-gb')
/home/sakit/public_html/catalog/model/design/translation.php:6
111 (0.173)
SELECT *
FROM oc_language
WHERE language_id = '1'
/home/sakit/public_html/catalog/model/localisation/language.php:4
112 (0.119)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'newstore' AND route = 'extension/captcha/google'
/home/sakit/public_html/catalog/model/design/theme.php:4
113 (0.351)
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 = '1510' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/sakit/storage/modification/catalog/model/catalog/product.php:521
114 (0.502)
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 = '1510' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/sakit/storage/modification/catalog/model/catalog/product.php:707
115 (1.069)
SELECT DISTINCT *, pd.name AS name, (SELECT allow_order
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = 1) AS stock_allow_order, 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 pr.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,(SELECT date_end
FROM oc_product_special
WHERE product_id = '1134' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, price ASC LIMIT 1) AS date_end, 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 = '1134' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/sakit/storage/modification/catalog/model/catalog/product.php:39
116 (0.145)
SELECT `name`
FROM oc_manufacturer_description
WHERE language_id = '1' AND manufacturer_id = '21'
/home/sakit/storage/modification/catalog/model/catalog/product.php:41
117 (0.448)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
118 (11.920)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
119 (0.146)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/notifywhenavailable' OR route = 'en-gb')
/home/sakit/public_html/catalog/model/design/translation.php:6
120 (0.126)
SELECT `stock_status_id`
FROM `oc_product`
WHERE `product_id` = 1134
/home/sakit/public_html/catalog/controller/extension/module/notifywhenavailable.php:663
121 (1.031)
SELECT DISTINCT *, pd.name AS name, (SELECT allow_order
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = 1) AS stock_allow_order, 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 pr.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,(SELECT date_end
FROM oc_product_special
WHERE product_id = '1136' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, price ASC LIMIT 1) AS date_end, 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 = '1136' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/sakit/storage/modification/catalog/model/catalog/product.php:39
122 (0.142)
SELECT `name`
FROM oc_manufacturer_description
WHERE language_id = '1' AND manufacturer_id = '21'
/home/sakit/storage/modification/catalog/model/catalog/product.php:41
123 (0.432)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
124 (12.829)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
125 (0.136)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/notifywhenavailable' OR route = 'en-gb')
/home/sakit/public_html/catalog/model/design/translation.php:6
126 (0.120)
SELECT `stock_status_id`
FROM `oc_product`
WHERE `product_id` = 1136
/home/sakit/public_html/catalog/controller/extension/module/notifywhenavailable.php:663
127 (1.051)
SELECT DISTINCT *, pd.name AS name, (SELECT allow_order
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = 1) AS stock_allow_order, 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 pr.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,(SELECT date_end
FROM oc_product_special
WHERE product_id = '1700' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, price ASC LIMIT 1) AS date_end, 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 = '1700' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/sakit/storage/modification/catalog/model/catalog/product.php:39
128 (0.135)
SELECT `name`
FROM oc_manufacturer_description
WHERE language_id = '1' AND manufacturer_id = '21'
/home/sakit/storage/modification/catalog/model/catalog/product.php:41
129 (0.425)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
130 (12.204)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
131 (0.216)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/notifywhenavailable' OR route = 'en-gb')
/home/sakit/public_html/catalog/model/design/translation.php:6
132 (0.139)
SELECT `stock_status_id`
FROM `oc_product`
WHERE `product_id` = 1700
/home/sakit/public_html/catalog/controller/extension/module/notifywhenavailable.php:663
133 (1.332)
SELECT DISTINCT *, pd.name AS name, (SELECT allow_order
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = 1) AS stock_allow_order, 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 pr.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,(SELECT date_end
FROM oc_product_special
WHERE product_id = '1754' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, price ASC LIMIT 1) AS date_end, 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 = '1754' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/sakit/storage/modification/catalog/model/catalog/product.php:39
134 (0.157)
SELECT `name`
FROM oc_manufacturer_description
WHERE language_id = '1' AND manufacturer_id = '21'
/home/sakit/storage/modification/catalog/model/catalog/product.php:41
135 (2.494)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
136 (12.501)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
137 (0.192)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/notifywhenavailable' OR route = 'en-gb')
/home/sakit/public_html/catalog/model/design/translation.php:6
138 (0.146)
SELECT `stock_status_id`
FROM `oc_product`
WHERE `product_id` = 1754
/home/sakit/public_html/catalog/controller/extension/module/notifywhenavailable.php:663
139 (1.165)
SELECT DISTINCT *, pd.name AS name, (SELECT allow_order
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = 1) AS stock_allow_order, 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 pr.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,(SELECT date_end
FROM oc_product_special
WHERE product_id = '1765' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, price ASC LIMIT 1) AS date_end, 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 = '1765' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/sakit/storage/modification/catalog/model/catalog/product.php:39
140 (0.180)
SELECT `name`
FROM oc_manufacturer_description
WHERE language_id = '1' AND manufacturer_id = '21'
/home/sakit/storage/modification/catalog/model/catalog/product.php:41
141 (0.450)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
142 (19.625)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
143 (2.192)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/notifywhenavailable' OR route = 'en-gb')
/home/sakit/public_html/catalog/model/design/translation.php:6
144 (1.354)
SELECT `stock_status_id`
FROM `oc_product`
WHERE `product_id` = 1765
/home/sakit/public_html/catalog/controller/extension/module/notifywhenavailable.php:663
145 (1.181)
SELECT DISTINCT *, pd.name AS name, (SELECT allow_order
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = 1) AS stock_allow_order, 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 pr.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,(SELECT date_end
FROM oc_product_special
WHERE product_id = '1976' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, price ASC LIMIT 1) AS date_end, 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 = '1976' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/sakit/storage/modification/catalog/model/catalog/product.php:39
146 (0.138)
SELECT `name`
FROM oc_manufacturer_description
WHERE language_id = '1' AND manufacturer_id = '21'
/home/sakit/storage/modification/catalog/model/catalog/product.php:41
147 (0.424)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
148 (12.715)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
149 (0.215)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/notifywhenavailable' OR route = 'en-gb')
/home/sakit/public_html/catalog/model/design/translation.php:6
150 (0.316)
SELECT `stock_status_id`
FROM `oc_product`
WHERE `product_id` = 1976
/home/sakit/public_html/catalog/controller/extension/module/notifywhenavailable.php:663
151 (0.493)
SELECT SUM(quantity) AS total
FROM oc_order_product op
WHERE op.product_id = '1134'
/home/sakit/storage/modification/catalog/model/catalog/product.php:460
152 (0.150)
SELECT *
FROM oc_product_image
WHERE product_id = '1134'
ORDER BY sort_order ASC
/home/sakit/storage/modification/catalog/model/catalog/product.php:668
153 (0.434)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
154 (12.314)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
155 (0.117)
SELECT *
FROM oc_store
ORDER BY url
/home/sakit/public_html/catalog/model/setting/store.php:7
156 (0.232)
SELECT *
FROM oc_language
WHERE status = '1'
ORDER BY sort_order, name
/home/sakit/public_html/catalog/model/localisation/language.php:15
157 (0.418)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
158 (12.002)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
159 (0.198)
SELECT *
FROM oc_store
ORDER BY url
/home/sakit/public_html/catalog/model/setting/store.php:7
160 (0.387)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module_url.php:13
161 (11.828)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
162 (0.371)
SELECT query as route, store_id, language_id, keyword
FROM oc_seo_url
WHERE query = 'product_id=1134' AND language_id = '1'
/home/sakit/public_html/catalog/model/extension/d_seo_module/d_seo_module_url.php:325
163 (0.337)
SELECT SUM(quantity) AS total
FROM oc_order_product op
WHERE op.product_id = '1136'
/home/sakit/storage/modification/catalog/model/catalog/product.php:460
164 (0.152)
SELECT *
FROM oc_product_image
WHERE product_id = '1136'
ORDER BY sort_order ASC
/home/sakit/storage/modification/catalog/model/catalog/product.php:668
165 (0.432)
SELECT SUM(quantity) AS total
FROM oc_order_product op
WHERE op.product_id = '1700'
/home/sakit/storage/modification/catalog/model/catalog/product.php:460
166 (1.148)
SELECT *
FROM oc_product_image
WHERE product_id = '1700'
ORDER BY sort_order ASC
/home/sakit/storage/modification/catalog/model/catalog/product.php:668
167 (0.215)
SELECT SUM(quantity) AS total
FROM oc_order_product op
WHERE op.product_id = '1754'
/home/sakit/storage/modification/catalog/model/catalog/product.php:460
168 (0.140)
SELECT *
FROM oc_product_image
WHERE product_id = '1754'
ORDER BY sort_order ASC
/home/sakit/storage/modification/catalog/model/catalog/product.php:668
169 (0.466)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
170 (12.270)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
171 (0.129)
SELECT *
FROM oc_store
ORDER BY url
/home/sakit/public_html/catalog/model/setting/store.php:7
172 (0.265)
SELECT *
FROM oc_language
WHERE status = '1'
ORDER BY sort_order, name
/home/sakit/public_html/catalog/model/localisation/language.php:15
173 (0.453)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
174 (18.323)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
175 (0.666)
SELECT *
FROM oc_store
ORDER BY url
/home/sakit/public_html/catalog/model/setting/store.php:7
176 (0.419)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module_url.php:13
177 (13.309)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
178 (4.744)
SELECT query as route, store_id, language_id, keyword
FROM oc_seo_url
WHERE query = 'product_id=1754' AND language_id = '1'
/home/sakit/public_html/catalog/model/extension/d_seo_module/d_seo_module_url.php:325
179 (2.012)
SELECT SUM(quantity) AS total
FROM oc_order_product op
WHERE op.product_id = '1765'
/home/sakit/storage/modification/catalog/model/catalog/product.php:460
180 (1.599)
SELECT *
FROM oc_product_image
WHERE product_id = '1765'
ORDER BY sort_order ASC
/home/sakit/storage/modification/catalog/model/catalog/product.php:668
181 (0.285)
SELECT SUM(quantity) AS total
FROM oc_order_product op
WHERE op.product_id = '1976'
/home/sakit/storage/modification/catalog/model/catalog/product.php:460
182 (1.292)
SELECT *
FROM oc_product_image
WHERE product_id = '1976'
ORDER BY sort_order ASC
/home/sakit/storage/modification/catalog/model/catalog/product.php:668
183 (8.480)
SELECT rd.*
FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id
WHERE pr.product_id = 1510 AND status = '1' AND pr.customer_group_id = '1'
ORDER BY sort_order ASC
/home/sakit/storage/modification/catalog/model/catalog/product.php:995
184 (0.337)
UPDATE oc_product SET viewed = (viewed + 1)
WHERE product_id = '1510'
/home/sakit/storage/modification/catalog/model/catalog/product.php:4
185 (1.870)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'product/product_accessory' OR route = 'en-gb')
/home/sakit/public_html/catalog/model/design/translation.php:6
186 (1.252)
SELECT *
FROM oc_product_accessory pac
LEFT JOIN oc_product p ON (pac.accessory_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (pac.product_id = p2s.product_id)
WHERE pac.product_id = '1510' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pac.status = '1'
ORDER BY pac.sort_order ASC
/home/sakit/public_html/catalog/model/catalog/product_accessory.php:8
187 (0.768)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'newstore' AND route = 'product/product_accessory'
/home/sakit/public_html/catalog/model/design/theme.php:4
188 (0.759)
SELECT `model`
FROM `oc_product`
WHERE product_id = 1510
/home/sakit/public_html/system/library/google_marketing_tools/master.php:512
189 (0.615)
SELECT `name`
FROM `oc_product_description`
WHERE product_id = 1510 AND language_id = 1
/home/sakit/public_html/system/library/google_marketing_tools/master.php:519
190 (0.713)
SELECT pr.tax_class_id
FROM oc_product pr
WHERE pr.product_id = 1134
/home/sakit/public_html/system/library/google_marketing_tools/master.php:680
191 (1.684)
SELECT DISTINCT *, pd.name AS name, (SELECT allow_order
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = 1) AS stock_allow_order, 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 pr.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,(SELECT date_end
FROM oc_product_special
WHERE product_id = '1134' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, price ASC LIMIT 1) AS date_end, 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 = '1134' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/sakit/storage/modification/catalog/model/catalog/product.php:39
192 (0.715)
SELECT `name`
FROM oc_manufacturer_description
WHERE language_id = '1' AND manufacturer_id = '21'
/home/sakit/storage/modification/catalog/model/catalog/product.php:41
193 (3.179)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
194 (12.476)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
195 (1.949)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/notifywhenavailable' OR route = 'en-gb')
/home/sakit/public_html/catalog/model/design/translation.php:6
196 (0.219)
SELECT `stock_status_id`
FROM `oc_product`
WHERE `product_id` = 1134
/home/sakit/public_html/catalog/controller/extension/module/notifywhenavailable.php:663
197 (0.389)
SELECT ma.name
FROM oc_product pr
LEFT JOIN oc_manufacturer ma ON (pr.manufacturer_id = ma.manufacturer_id)
WHERE pr.product_id = 1134
/home/sakit/public_html/system/library/google_marketing_tools/master.php:670
198 (0.841)
SELECT *
FROM oc_product_to_category
WHERE product_id = '1134'
/home/sakit/storage/modification/catalog/model/catalog/product.php:789
199 (0.547)
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 = '220' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/home/sakit/public_html/catalog/model/catalog/category.php:4
200 (2.332)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
201 (15.306)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
202 (0.334)
SELECT pr.tax_class_id
FROM oc_product pr
WHERE pr.product_id = 1136
/home/sakit/public_html/system/library/google_marketing_tools/master.php:680
203 (1.279)
SELECT DISTINCT *, pd.name AS name, (SELECT allow_order
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = 1) AS stock_allow_order, 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 pr.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,(SELECT date_end
FROM oc_product_special
WHERE product_id = '1136' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, price ASC LIMIT 1) AS date_end, 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 = '1136' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/sakit/storage/modification/catalog/model/catalog/product.php:39
204 (0.142)
SELECT `name`
FROM oc_manufacturer_description
WHERE language_id = '1' AND manufacturer_id = '21'
/home/sakit/storage/modification/catalog/model/catalog/product.php:41
205 (0.410)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
206 (12.371)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
207 (0.913)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/notifywhenavailable' OR route = 'en-gb')
/home/sakit/public_html/catalog/model/design/translation.php:6
208 (0.356)
SELECT `stock_status_id`
FROM `oc_product`
WHERE `product_id` = 1136
/home/sakit/public_html/catalog/controller/extension/module/notifywhenavailable.php:663
209 (0.157)
SELECT ma.name
FROM oc_product pr
LEFT JOIN oc_manufacturer ma ON (pr.manufacturer_id = ma.manufacturer_id)
WHERE pr.product_id = 1136
/home/sakit/public_html/system/library/google_marketing_tools/master.php:670
210 (0.140)
SELECT *
FROM oc_product_to_category
WHERE product_id = '1136'
/home/sakit/storage/modification/catalog/model/catalog/product.php:789
211 (0.271)
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 = '220' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/home/sakit/public_html/catalog/model/catalog/category.php:4
212 (0.424)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
213 (13.929)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
214 (0.182)
SELECT pr.tax_class_id
FROM oc_product pr
WHERE pr.product_id = 1700
/home/sakit/public_html/system/library/google_marketing_tools/master.php:680
215 (1.156)
SELECT DISTINCT *, pd.name AS name, (SELECT allow_order
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = 1) AS stock_allow_order, 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 pr.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,(SELECT date_end
FROM oc_product_special
WHERE product_id = '1700' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, price ASC LIMIT 1) AS date_end, 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 = '1700' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/sakit/storage/modification/catalog/model/catalog/product.php:39
216 (0.148)
SELECT `name`
FROM oc_manufacturer_description
WHERE language_id = '1' AND manufacturer_id = '21'
/home/sakit/storage/modification/catalog/model/catalog/product.php:41
217 (0.407)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
218 (13.448)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
219 (0.523)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/notifywhenavailable' OR route = 'en-gb')
/home/sakit/public_html/catalog/model/design/translation.php:6
220 (5.220)
SELECT `stock_status_id`
FROM `oc_product`
WHERE `product_id` = 1700
/home/sakit/public_html/catalog/controller/extension/module/notifywhenavailable.php:663
221 (0.157)
SELECT ma.name
FROM oc_product pr
LEFT JOIN oc_manufacturer ma ON (pr.manufacturer_id = ma.manufacturer_id)
WHERE pr.product_id = 1700
/home/sakit/public_html/system/library/google_marketing_tools/master.php:670
222 (0.132)
SELECT *
FROM oc_product_to_category
WHERE product_id = '1700'
/home/sakit/storage/modification/catalog/model/catalog/product.php:789
223 (0.233)
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 = '220' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/home/sakit/public_html/catalog/model/catalog/category.php:4
224 (0.381)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
225 (16.033)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
226 (0.158)
SELECT pr.tax_class_id
FROM oc_product pr
WHERE pr.product_id = 1754
/home/sakit/public_html/system/library/google_marketing_tools/master.php:680
227 (1.123)
SELECT DISTINCT *, pd.name AS name, (SELECT allow_order
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = 1) AS stock_allow_order, 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 pr.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,(SELECT date_end
FROM oc_product_special
WHERE product_id = '1754' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, price ASC LIMIT 1) AS date_end, 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 = '1754' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/sakit/storage/modification/catalog/model/catalog/product.php:39
228 (0.145)
SELECT `name`
FROM oc_manufacturer_description
WHERE language_id = '1' AND manufacturer_id = '21'
/home/sakit/storage/modification/catalog/model/catalog/product.php:41
229 (0.408)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
230 (11.931)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
231 (12.096)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/notifywhenavailable' OR route = 'en-gb')
/home/sakit/public_html/catalog/model/design/translation.php:6
232 (0.133)
SELECT `stock_status_id`
FROM `oc_product`
WHERE `product_id` = 1754
/home/sakit/public_html/catalog/controller/extension/module/notifywhenavailable.php:663
233 (0.151)
SELECT ma.name
FROM oc_product pr
LEFT JOIN oc_manufacturer ma ON (pr.manufacturer_id = ma.manufacturer_id)
WHERE pr.product_id = 1754
/home/sakit/public_html/system/library/google_marketing_tools/master.php:670
234 (0.134)
SELECT *
FROM oc_product_to_category
WHERE product_id = '1754'
/home/sakit/storage/modification/catalog/model/catalog/product.php:789
235 (0.247)
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 = '220' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/home/sakit/public_html/catalog/model/catalog/category.php:4
236 (0.394)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
237 (11.922)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
238 (0.139)
SELECT pr.tax_class_id
FROM oc_product pr
WHERE pr.product_id = 1765
/home/sakit/public_html/system/library/google_marketing_tools/master.php:680
239 (1.072)
SELECT DISTINCT *, pd.name AS name, (SELECT allow_order
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = 1) AS stock_allow_order, 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 pr.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,(SELECT date_end
FROM oc_product_special
WHERE product_id = '1765' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, price ASC LIMIT 1) AS date_end, 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 = '1765' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/sakit/storage/modification/catalog/model/catalog/product.php:39
240 (0.144)
SELECT `name`
FROM oc_manufacturer_description
WHERE language_id = '1' AND manufacturer_id = '21'
/home/sakit/storage/modification/catalog/model/catalog/product.php:41
241 (0.387)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
242 (17.978)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
243 (0.130)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/notifywhenavailable' OR route = 'en-gb')
/home/sakit/public_html/catalog/model/design/translation.php:6
244 (0.121)
SELECT `stock_status_id`
FROM `oc_product`
WHERE `product_id` = 1765
/home/sakit/public_html/catalog/controller/extension/module/notifywhenavailable.php:663
245 (0.145)
SELECT ma.name
FROM oc_product pr
LEFT JOIN oc_manufacturer ma ON (pr.manufacturer_id = ma.manufacturer_id)
WHERE pr.product_id = 1765
/home/sakit/public_html/system/library/google_marketing_tools/master.php:670
246 (0.374)
SELECT *
FROM oc_product_to_category
WHERE product_id = '1765'
/home/sakit/storage/modification/catalog/model/catalog/product.php:789
247 (0.239)
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 = '220' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/home/sakit/public_html/catalog/model/catalog/category.php:4
248 (7.657)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
249 (12.026)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
250 (0.137)
SELECT pr.tax_class_id
FROM oc_product pr
WHERE pr.product_id = 1976
/home/sakit/public_html/system/library/google_marketing_tools/master.php:680
251 (0.928)
SELECT DISTINCT *, pd.name AS name, (SELECT allow_order
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = 1) AS stock_allow_order, 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 pr.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,(SELECT date_end
FROM oc_product_special
WHERE product_id = '1976' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, price ASC LIMIT 1) AS date_end, 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 = '1976' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/sakit/storage/modification/catalog/model/catalog/product.php:39
252 (0.137)
SELECT `name`
FROM oc_manufacturer_description
WHERE language_id = '1' AND manufacturer_id = '21'
/home/sakit/storage/modification/catalog/model/catalog/product.php:41
253 (0.357)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
254 (11.780)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
255 (0.141)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/notifywhenavailable' OR route = 'en-gb')
/home/sakit/public_html/catalog/model/design/translation.php:6
256 (0.129)
SELECT `stock_status_id`
FROM `oc_product`
WHERE `product_id` = 1976
/home/sakit/public_html/catalog/controller/extension/module/notifywhenavailable.php:663
257 (0.154)
SELECT ma.name
FROM oc_product pr
LEFT JOIN oc_manufacturer ma ON (pr.manufacturer_id = ma.manufacturer_id)
WHERE pr.product_id = 1976
/home/sakit/public_html/system/library/google_marketing_tools/master.php:670
258 (0.134)
SELECT *
FROM oc_product_to_category
WHERE product_id = '1976'
/home/sakit/storage/modification/catalog/model/catalog/product.php:789
259 (0.221)
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 = '220' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/home/sakit/public_html/catalog/model/catalog/category.php:4
260 (0.376)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
261 (11.771)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
262 (0.138)
SELECT `model`
FROM `oc_product`
WHERE product_id = 1510
/home/sakit/public_html/system/library/google_marketing_tools/master.php:512
263 (0.136)
SELECT `name`
FROM `oc_product_description`
WHERE product_id = 1510 AND language_id = 1
/home/sakit/public_html/system/library/google_marketing_tools/master.php:519
264 (0.146)
SELECT ma.name
FROM oc_product pr
LEFT JOIN oc_manufacturer ma ON (pr.manufacturer_id = ma.manufacturer_id)
WHERE pr.product_id = 1510
/home/sakit/public_html/system/library/google_marketing_tools/master.php:670
265 (0.134)
SELECT *
FROM oc_product_to_category
WHERE product_id = '1510'
/home/sakit/storage/modification/catalog/model/catalog/product.php:789
266 (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 = '63' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/home/sakit/public_html/catalog/model/catalog/category.php:4
267 (0.364)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
268 (12.199)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
269 (0.305)
SELECT r.review_id, r.author, r.rating, r.text, r.plus, r.purchased, r.minus, r.admin_reply, p.product_id, pd.name, p.price, p.image, r.date_added
FROM oc_review r
LEFT JOIN oc_product p ON (r.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
WHERE p.product_id = '1510' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '1'
ORDER BY r.date_added DESC LIMIT 0,20
/home/sakit/storage/modification/catalog/model/catalog/review.php:59
270 (0.147)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '1510' AND store_id = '0'
/home/sakit/storage/modification/catalog/model/catalog/product.php:748
271 (0.175)
SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/sakit/public_html/catalog/model/design/layout.php:4
272 (0.187)
SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'column_left'
ORDER BY sort_order
/home/sakit/public_html/catalog/model/design/layout.php:14
273 (0.116)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'newstore' AND route = 'common/column_left'
/home/sakit/public_html/catalog/model/design/theme.php:4
274 (0.129)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '1510' AND store_id = '0'
/home/sakit/storage/modification/catalog/model/catalog/product.php:748
275 (0.158)
SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/sakit/public_html/catalog/model/design/layout.php:4
276 (0.178)
SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'column_right'
ORDER BY sort_order
/home/sakit/public_html/catalog/model/design/layout.php:14
277 (0.110)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'newstore' AND route = 'common/column_right'
/home/sakit/public_html/catalog/model/design/theme.php:4
278 (0.138)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '1510' AND store_id = '0'
/home/sakit/storage/modification/catalog/model/catalog/product.php:748
279 (0.158)
SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/sakit/public_html/catalog/model/design/layout.php:4
280 (0.168)
SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'content_top'
ORDER BY sort_order
/home/sakit/public_html/catalog/model/design/layout.php:14
281 (0.112)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'newstore' AND route = 'common/content_top'
/home/sakit/public_html/catalog/model/design/theme.php:4
282 (0.125)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '1510' AND store_id = '0'
/home/sakit/storage/modification/catalog/model/catalog/product.php:748
283 (0.156)
SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/sakit/public_html/catalog/model/design/layout.php:4
284 (0.207)
SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'content_bottom'
ORDER BY sort_order
/home/sakit/public_html/catalog/model/design/layout.php:14
285 (0.129)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/productbundles' OR route = 'en-gb')
/home/sakit/public_html/catalog/model/design/translation.php:6
286 (0.199)
SELECT *
FROM `oc_pb_bundles`
WHERE `store_id`='0' AND `products` != '' AND `status`= '1' AND `date_available` <= NOW() AND `products_show` LIKE '%"1510"%' LIMIT 0, 2
/home/sakit/public_html/catalog/model/extension/module/productbundles.php:92
287 (0.122)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'newstore' AND route = 'extension/module/productbundles/productbundles'
/home/sakit/public_html/catalog/model/design/theme.php:4
288 (0.113)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'newstore' AND route = 'common/content_bottom'
/home/sakit/public_html/catalog/model/design/theme.php:4
289 (0.116)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'common/footer' OR route = 'en-gb')
/home/sakit/public_html/catalog/model/design/translation.php:6
290 (0.112)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'ns/newstorelang' OR route = 'en-gb')
/home/sakit/public_html/catalog/model/design/translation.php:6
291 (6.127)
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
/home/sakit/public_html/catalog/model/catalog/information.php:10
292 (0.440)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
293 (12.367)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
294 (12.242)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/questions_and_answers' OR route = 'en-gb')
/home/sakit/public_html/catalog/model/design/translation.php:6
295 (0.371)
DELETE
FROM `oc_customer_online`
WHERE date_added < '2019-11-18 02:19:13'
/home/sakit/public_html/catalog/model/tool/online.php:4
296 (0.163)
REPLACE INTO `oc_customer_online` SET `ip` = '3.92.92.168', `customer_id` = '0', `url` = 'http://sakit.co.il/shaft-assembly-agitator-lg', `referer` = '', `date_added` = '2019-11-18 03:19:13'
/home/sakit/public_html/catalog/model/tool/online.php:6
297 (0.163)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/accessibility' OR route = 'en-gb')
/home/sakit/public_html/catalog/model/design/translation.php:6
298 (1.281)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'newstore' AND route = 'extension/module/accessibility'
/home/sakit/public_html/catalog/model/design/theme.php:4
299 (4.093)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
300 (11.923)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
301 (0.125)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'newstore' AND route = 'common/footer'
/home/sakit/public_html/catalog/model/design/theme.php:4
302 (0.397)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
303 (11.843)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
304 (0.144)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/mmos_attachmanager' OR route = 'en-gb')
/home/sakit/public_html/catalog/model/design/translation.php:6
305 (0.132)
SELECT *
FROM oc_product_attach_file
WHERE product_id = '1510'
/home/sakit/public_html/catalog/controller/extension/module/mmos_attachmanager.php:229
306 (0.129)
SELECT *
FROM oc_product_attach_extendlink
WHERE product_id = '1510'
/home/sakit/public_html/catalog/controller/extension/module/mmos_attachmanager.php:236
307 (0.113)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'newstore' AND route = 'mmosolution/mmos_attachmanager'
/home/sakit/public_html/catalog/model/design/theme.php:4
308 (12.439)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'module_ianalytics'
/home/sakit/public_html/catalog/model/setting/setting.php:6
309 (14.575)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'module_ianalytics_state'
/home/sakit/public_html/catalog/model/setting/setting.php:6
310 (0.226)
SELECT *
FROM `oc_ianalytics_visits_data`
WHERE `date` = '2019-11-18' AND `stage` = '0' AND `store_id` = '0'
/home/sakit/public_html/catalog/controller/extension/module/ianalytics.php:66
311 (0.221)
UPDATE `oc_ianalytics_visits_data` SET `unique_visits`=unique_visits+1, `impressions`=impressions+1 , `referers_other`=referers_other+1
WHERE `date`='2019-11-18' AND `stage` = '0' AND `store_id` = '0'
/home/sakit/public_html/catalog/controller/extension/module/ianalytics.php:103
312 (0.143)
INSERT INTO oc_ianalytics_funnel_data (stage,date,time,from_ip,spoken_languages,store_id) VALUES ("0","2019-11-18","03:19:13","3.92.92.168","en-US,en;q=0.5","0")
/home/sakit/public_html/catalog/controller/extension/module/ianalytics.php:285
313 (1.208)
SELECT DISTINCT *, pd.name AS name, (SELECT allow_order
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = 1) AS stock_allow_order, 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 pr.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,(SELECT date_end
FROM oc_product_special
WHERE product_id = '1510' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, price ASC LIMIT 1) AS date_end, 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 = '1510' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/sakit/storage/modification/catalog/model/catalog/product.php:39
314 (0.140)
SELECT `name`
FROM oc_manufacturer_description
WHERE language_id = '1' AND manufacturer_id = '21'
/home/sakit/storage/modification/catalog/model/catalog/product.php:41
315 (0.416)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
316 (12.152)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
317 (0.132)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/notifywhenavailable' OR route = 'en-gb')
/home/sakit/public_html/catalog/model/design/translation.php:6
318 (0.117)
SELECT `stock_status_id`
FROM `oc_product`
WHERE `product_id` = 1510
/home/sakit/public_html/catalog/controller/extension/module/notifywhenavailable.php:663
319 (0.138)
INSERT INTO oc_ianalytics_product_opens (date,time,from_ip,spoken_languages,product_id,product_name,product_model,product_price,product_quantity,product_stock_status,store_id) VALUES ("2019-11-18","03:19:13","3.92.92.168","en-US,en;q=0.5","1510","Shaft Assembly Agitator LG","AHR72909401","120.0000","3","Out Of Stock","0")
/home/sakit/public_html/catalog/controller/extension/module/ianalytics.php:285
320 (0.182)
SELECT *
FROM `oc_module`
WHERE `code` = 'isearch'
ORDER BY `name`
/home/sakit/public_html/catalog/model/extension/module/isearch.php:737
321 (0.168)
SELECT *
FROM `oc_module`
WHERE `code` = 'isearch'
ORDER BY `name`
/home/sakit/public_html/catalog/model/extension/module/isearch.php:737
322 (0.152)
SELECT *
FROM oc_extension
WHERE `type` = 'analytics'
/home/sakit/public_html/catalog/model/setting/extension.php:4
323 (0.127)
SELECT status
FROM oc_modification
WHERE `code`='NS > CALLBACK'
/home/sakit/public_html/catalog/model/ns/moduleonoff.php:4
324 (0.122)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'ns/newstorelang' OR route = 'en-gb')
/home/sakit/public_html/catalog/model/design/translation.php:6
325 (1.521)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'product/category' OR route = 'en-gb')
/home/sakit/public_html/catalog/model/design/translation.php:6
326 (0.119)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'common/header' OR route = 'en-gb')
/home/sakit/public_html/catalog/model/design/translation.php:6
327 (0.125)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/questions_and_answers' OR route = 'en-gb')
/home/sakit/public_html/catalog/model/design/translation.php:6
328 (0.119)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'common/language' OR route = 'en-gb')
/home/sakit/public_html/catalog/model/design/translation.php:6
329 (0.212)
SELECT *
FROM oc_language
WHERE status = '1'
ORDER BY sort_order, name
/home/sakit/public_html/catalog/model/localisation/language.php:15
330 (0.118)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'newstore' AND route = 'common/language'
/home/sakit/public_html/catalog/model/design/theme.php:4
331 (0.129)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'common/currency' OR route = 'en-gb')
/home/sakit/public_html/catalog/model/design/translation.php:6
332 (0.109)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'newstore' AND route = 'common/currency'
/home/sakit/public_html/catalog/model/design/theme.php:4
333 (0.123)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'common/search' OR route = 'en-gb')
/home/sakit/public_html/catalog/model/design/translation.php:6
334 (0.126)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'ns/newstorelang' OR route = 'en-gb')
/home/sakit/public_html/catalog/model/design/translation.php:6
335 (6.056)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (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)
/home/sakit/public_html/catalog/model/catalog/category.php:10
336 (3.325)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
337 (15.038)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
338 (3.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 = '9' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/sakit/public_html/catalog/model/catalog/category.php:10
339 (0.391)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
340 (20.928)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
341 (5.172)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '8' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/sakit/public_html/catalog/model/catalog/category.php:10
342 (1.227)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
343 (12.236)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
344 (6.209)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '12' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/sakit/public_html/catalog/model/catalog/category.php:10
345 (0.388)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
346 (14.634)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
347 (4.170)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '5' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/sakit/public_html/catalog/model/catalog/category.php:10
348 (0.420)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
349 (16.927)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
350 (6.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 = '10' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/sakit/public_html/catalog/model/catalog/category.php:10
351 (0.869)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
352 (13.346)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
353 (4.847)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '11' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/sakit/public_html/catalog/model/catalog/category.php:10
354 (0.447)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
355 (16.361)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
356 (5.773)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '2' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/sakit/public_html/catalog/model/catalog/category.php:10
357 (0.381)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
358 (12.149)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
359 (5.669)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '4' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/sakit/public_html/catalog/model/catalog/category.php:10
360 (0.749)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
361 (12.282)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
362 (6.547)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/sakit/public_html/catalog/model/catalog/category.php:10
363 (0.408)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
364 (13.583)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
365 (0.325)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'newstore' AND route = 'common/search'
/home/sakit/public_html/catalog/model/design/theme.php:4
366 (0.476)
SELECT *
FROM `oc_module`
WHERE `code` = 'isearch'
ORDER BY `name`
/home/sakit/public_html/catalog/model/extension/module/isearch.php:737
367 (0.137)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'common/cart' OR route = 'en-gb')
/home/sakit/public_html/catalog/model/design/translation.php:6
368 (0.185)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '4a530b6f750fd8577e6c57fa94'
/home/sakit/public_html/system/library/cart/cart.php:36
369 (0.263)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/home/sakit/public_html/catalog/model/setting/extension.php:4
370 (0.142)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/sub_total' OR route = 'en-gb')
/home/sakit/public_html/catalog/model/design/translation.php:6
371 (0.151)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '4a530b6f750fd8577e6c57fa94'
/home/sakit/public_html/system/library/cart/cart.php:36
372 (0.163)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '4a530b6f750fd8577e6c57fa94'
/home/sakit/public_html/system/library/cart/cart.php:36
373 (0.154)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '4a530b6f750fd8577e6c57fa94'
/home/sakit/public_html/system/library/cart/cart.php:36
374 (0.588)
SELECT *
FROM `oc_pb_bundles`
WHERE `store_id`='0' AND `products` != '' AND `status`= '1' AND `date_available` <= NOW()
ORDER BY `sort_order` ASC
/home/sakit/public_html/catalog/model/extension/module/productbundles.php:92
375 (0.201)
SELECT count(*) as total
from oc_product
WHERE product_id IN (1470,1470) AND status = '1' AND quantity > '0'
/home/sakit/public_html/catalog/model/extension/module/productbundles.php:45
376 (0.180)
SELECT count(*) as total
from oc_product
WHERE product_id IN (1610,1610) AND status = '1' AND quantity > '0'
/home/sakit/public_html/catalog/model/extension/module/productbundles.php:45
377 (0.155)
SELECT count(*) as total
from oc_product
WHERE product_id IN (1470,1470,1470) AND status = '1' AND quantity > '0'
/home/sakit/public_html/catalog/model/extension/module/productbundles.php:45
378 (0.159)
SELECT count(*) as total
from oc_product
WHERE product_id IN (667,667) AND status = '1' AND quantity > '0'
/home/sakit/public_html/catalog/model/extension/module/productbundles.php:45
379 (0.149)
SELECT count(*) as total
from oc_product
WHERE product_id IN (661,661) AND status = '1' AND quantity > '0'
/home/sakit/public_html/catalog/model/extension/module/productbundles.php:45
380 (0.152)
SELECT count(*) as total
from oc_product
WHERE product_id IN (1489,1489) AND status = '1' AND quantity > '0'
/home/sakit/public_html/catalog/model/extension/module/productbundles.php:45
381 (0.183)
SELECT count(*) as total
from oc_product
WHERE product_id IN (1619,1619,1619) AND status = '1' AND quantity > '0'
/home/sakit/public_html/catalog/model/extension/module/productbundles.php:45
382 (0.159)
SELECT count(*) as total
from oc_product
WHERE product_id IN (1619,1619,1621) AND status = '1' AND quantity > '0'
/home/sakit/public_html/catalog/model/extension/module/productbundles.php:45
383 (0.161)
SELECT count(*) as total
from oc_product
WHERE product_id IN (1619,1619,1621,1621) AND status = '1' AND quantity > '0'
/home/sakit/public_html/catalog/model/extension/module/productbundles.php:45
384 (0.162)
SELECT count(*) as total
from oc_product
WHERE product_id IN (1621,1621,1619,1619,1619) AND status = '1' AND quantity > '0'
/home/sakit/public_html/catalog/model/extension/module/productbundles.php:45
385 (0.163)
SELECT count(*) as total
from oc_product
WHERE product_id IN (1619,1619,1619,1619,1621) AND status = '1' AND quantity > '0'
/home/sakit/public_html/catalog/model/extension/module/productbundles.php:45
386 (0.168)
SELECT count(*) as total
from oc_product
WHERE product_id IN (1619,1619,1619,1619,1619,1619) AND status = '1' AND quantity > '0'
/home/sakit/public_html/catalog/model/extension/module/productbundles.php:45
387 (0.254)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/credit' OR route = 'en-gb')
/home/sakit/public_html/catalog/model/design/translation.php:6
388 (0.321)
SELECT SUM(amount) AS total
FROM oc_customer_transaction
WHERE customer_id = '0'
/home/sakit/public_html/system/library/cart/customer.php:122
389 (0.118)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/total' OR route = 'en-gb')
/home/sakit/public_html/catalog/model/design/translation.php:6
390 (0.166)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '4a530b6f750fd8577e6c57fa94'
/home/sakit/public_html/system/library/cart/cart.php:36
391 (0.118)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'ns/newstorelang' OR route = 'en-gb')
/home/sakit/public_html/catalog/model/design/translation.php:6
392 (0.142)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '4a530b6f750fd8577e6c57fa94'
/home/sakit/public_html/system/library/cart/cart.php:36
393 (0.144)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '4a530b6f750fd8577e6c57fa94'
/home/sakit/public_html/system/library/cart/cart.php:36
394 (0.119)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'newstore' AND route = 'common/cart'
/home/sakit/public_html/catalog/model/design/theme.php:4
395 (0.118)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'common/menu' OR route = 'en-gb')
/home/sakit/public_html/catalog/model/design/translation.php:6
396 (8.884)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (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)
/home/sakit/public_html/catalog/model/catalog/category.php:10
397 (0.416)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
398 (12.431)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
399 (10.847)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '9' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/sakit/public_html/catalog/model/catalog/category.php:10
400 (0.374)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
401 (12.327)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
402 (5.697)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '8' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/sakit/public_html/catalog/model/catalog/category.php:10
403 (0.566)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
404 (12.552)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
405 (5.567)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '12' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/sakit/public_html/catalog/model/catalog/category.php:10
406 (0.377)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
407 (12.851)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
408 (4.842)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '5' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/sakit/public_html/catalog/model/catalog/category.php:10
409 (0.399)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
410 (12.510)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
411 (6.916)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '10' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/sakit/public_html/catalog/model/catalog/category.php:10
412 (0.475)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
413 (12.450)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
414 (6.510)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '11' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/sakit/public_html/catalog/model/catalog/category.php:10
415 (0.378)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
416 (12.379)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
417 (5.358)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '2' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/sakit/public_html/catalog/model/catalog/category.php:10
418 (0.939)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
419 (12.146)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
420 (4.795)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '4' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/sakit/public_html/catalog/model/catalog/category.php:10
421 (0.421)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
422 (13.648)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
423 (6.991)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '7' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/sakit/public_html/catalog/model/catalog/category.php:10
424 (0.480)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
425 (13.315)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
426 (0.142)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'newstore' AND route = 'common/menu'
/home/sakit/public_html/catalog/model/design/theme.php:4
427 (0.394)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
428 (11.996)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
429 (0.142)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'newstore' AND route = 'common/header'
/home/sakit/public_html/catalog/model/design/theme.php:4
430 (0.366)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
431 (11.958)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
432 (0.245)
SELECT *
FROM oc_language
WHERE status = '1'
ORDER BY sort_order, name
/home/sakit/public_html/catalog/model/localisation/language.php:15
433 (0.430)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
434 (15.561)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
435 (6.501)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/notifywhenavailable' OR route = 'en-gb')
/home/sakit/public_html/catalog/model/design/translation.php:6
436 (7.842)
SELECT DISTINCT *, pd.name AS name, (SELECT allow_order
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = 1) AS stock_allow_order, 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 pr.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,(SELECT date_end
FROM oc_product_special
WHERE product_id = '1510' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, price ASC LIMIT 1) AS date_end, 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 = '1510' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/sakit/storage/modification/catalog/model/catalog/product.php:39
437 (0.212)
SELECT `name`
FROM oc_manufacturer_description
WHERE language_id = '1' AND manufacturer_id = '21'
/home/sakit/storage/modification/catalog/model/catalog/product.php:41
438 (0.412)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
439 (12.501)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
440 (0.222)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/notifywhenavailable' OR route = 'en-gb')
/home/sakit/public_html/catalog/model/design/translation.php:6
441 (0.186)
SELECT `stock_status_id`
FROM `oc_product`
WHERE `product_id` = 1510
/home/sakit/public_html/catalog/controller/extension/module/notifywhenavailable.php:663
442 (0.173)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'newstore' AND route = 'product/product'
/home/sakit/public_html/catalog/model/design/theme.php:4
443 (0.612)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
444 (14.145)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
445 (0.150)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'product/product' OR route = 'en-gb')
/home/sakit/public_html/catalog/model/design/translation.php:6
446 (0.267)
SELECT COUNT(*) AS total
FROM oc_review r
LEFT JOIN oc_product p ON (r.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
WHERE p.product_id = '1510' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '1'
/home/sakit/storage/modification/catalog/model/catalog/review.php:65
447 (0.343)
SELECT r.review_id, r.author, r.rating, r.text, r.plus, r.purchased, r.minus, r.admin_reply, p.product_id, pd.name, p.price, p.image, r.date_added
FROM oc_review r
LEFT JOIN oc_product p ON (r.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
WHERE p.product_id = '1510' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '1'
ORDER BY r.date_added DESC LIMIT 0,5
/home/sakit/storage/modification/catalog/model/catalog/review.php:59
448 (0.125)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'newstore' AND route = 'product/review'
/home/sakit/public_html/catalog/model/design/theme.php:4
449 (9.292)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module.php:13
450 (11.941)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
451 (0.114)
SELECT *
FROM oc_store
ORDER BY url
/home/sakit/public_html/catalog/model/setting/store.php:7
452 (0.240)
SELECT *
FROM oc_language
WHERE status = '1'
ORDER BY sort_order, name
/home/sakit/public_html/catalog/model/localisation/language.php:15
453 (0.421)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module_meta.php:13
454 (12.494)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
455 (0.121)
SELECT *
FROM oc_store
ORDER BY url
/home/sakit/public_html/catalog/model/setting/store.php:7
456 (0.387)
SELECT *
FROM oc_extension
ORDER BY code
/home/sakit/public_html/catalog/model/extension/module/d_seo_module_meta.php:13
457 (14.033)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/sakit/public_html/catalog/model/setting/setting.php:6
458 (0.181)
SELECT *
FROM oc_product_description
WHERE product_id = '1510' AND language_id = '1'
/home/sakit/public_html/catalog/model/extension/d_seo_module/d_seo_module_meta.php:182
459 (0.423)
SELECT *
FROM oc_d_meta_data
WHERE route = 'product_id=1510' AND language_id = '1'
/home/sakit/public_html/catalog/model/extension/d_seo_module/d_seo_module_meta.php:447
460 (0.868)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/notifywhenavailable' OR route = 'en-gb')
/home/sakit/public_html/catalog/model/design/translation.php:6