Sữa Tắm Tràm Trà Trị Mụn Lưng CallMeHua 330ml
Sữa Tắm Tràm Trà Trị Mụn Lưng CallMeHua 330ml
Tổng quan thông số
Chiết xuất Tràm Trà có tính chất kháng khuẩn giúp làm dịu vết mẩn đỏ, mụn đang sưng tấy, làm sạch các lớp tế bào chết, bã nhờn trên da từ đó giúp giảm tình trạng mụn lưng và mụn cơ thể. Tinh chất Glycerin giúp thúc đẩy quá trình phục hồi cho các làn da đang bị kích ứng, duy trì độ ẩm trên hàng rào bảo vệ da giúp da chống lại các tác nhân gây hại
Không chứa
- không sulfate
- không dầu khoáng
- không paraben
- không vi hạt nhựa
Thích Hợp Với
- Mọi loại da
- Da có vấn đề về mụn cơ thể
ĐÁNH GIÁ TỪ KHÁCH HÀNG ĐÃ MUA
Sữa tắm Tràm Trà CallMeHua
Sữa tắm Tràm Trà CallMeHua nhẹ nhàng tẩy đi tế bào già cỗi trên da, hỗ trợ làm giảm các loại nốt mụn lưng, mụn cơ thể, hỗ trợ làm giảm thâm mụn. Niacinamide có trong sản phẩm giúp cung cấp nhẹ độ ẩm cho da, củng cố hàng rào bảo vệ da tự nhiên, và thúc đẩy quá trình phục hồi da. Từ đó giúp cân bằng dầu thừa trên da, ngăn mụn cơ thể quay lại. Sử dụng sản phẩm đều đặn để có thể giúp cải thiện tình trạng da không đều màu, giúp bạn sở hữu làn da mềm mại, không sần sùi. Hãy để chúng mình nâng niu và chăm sóc cho làn da bạn.
SẢN PHẨM BẠN XEM GẦN ĐÂY
Sữa tắm Tràm Trà CallMeHuaSữa tắm Tràm Trà CallMeHua nhẹ nhàng tẩy đi tế bào già cỗi trên da, hỗ trợ làm giảm các loại nốt mụn lưng, mụn cơ thể, ..
215.000₫
1 (0.156)
SET time_zone = '+00:00'
/home/mrlpqflkhosting/public_html/callmehua.com/system/framework.php:84
2 (0.540)
SELECT *
FROM dsd34_translation
WHERE store_id = '0' AND language_id = '0' AND (route = 'engb' OR route = '')
FROM dsd34_translation
WHERE store_id = '0' AND language_id = '0' AND (route = 'engb' OR route = '')
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/translation.php:6
3 (0.823)
SELECT `data`
FROM `dsd34_session`
WHERE `session_id` = 'cdb1f6e32c659aa428d0d5a936' AND `expire` > '2023-03-20 16:36:01'
FROM `dsd34_session`
WHERE `session_id` = 'cdb1f6e32c659aa428d0d5a936' AND `expire` > '2023-03-20 16:36:01'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/session/db.php:16
4 (0.322)
SELECT *
FROM dsd34_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://callmehua.com/'
FROM dsd34_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://callmehua.com/'
/home/mrlpqflkhosting/public_html/callmehua.com/storage/modification/catalog/controller/startup/startup.php:6
5 (3.229)
SELECT *
FROM `dsd34_setting`
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
FROM `dsd34_setting`
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
/home/mrlpqflkhosting/public_html/callmehua.com/storage/modification/catalog/controller/startup/startup.php:25
6 (0.265)
SET time_zone = '+07:00'
/home/mrlpqflkhosting/public_html/callmehua.com/storage/modification/catalog/controller/startup/startup.php:40
7 (0.300)
SELECT *
FROM dsd34_currency
FROM dsd34_currency
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/currency.php:10
8 (0.549)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM dsd34_tax_rule tr1
LEFT JOIN dsd34_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN dsd34_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN dsd34_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN dsd34_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 = '230' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '202')
ORDER BY tr1.priority ASC
FROM dsd34_tax_rule tr1
LEFT JOIN dsd34_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN dsd34_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN dsd34_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN dsd34_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 = '230' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '202')
ORDER BY tr1.priority ASC
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/tax.php:16
9 (0.311)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM dsd34_tax_rule tr1
LEFT JOIN dsd34_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN dsd34_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN dsd34_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN dsd34_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 = '230' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '202')
ORDER BY tr1.priority ASC
FROM dsd34_tax_rule tr1
LEFT JOIN dsd34_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN dsd34_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN dsd34_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN dsd34_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 = '230' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '202')
ORDER BY tr1.priority ASC
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/tax.php:44
10 (0.510)
SELECT *
FROM dsd34_weight_class wc
LEFT JOIN dsd34_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id)
WHERE wcd.language_id = '2'
FROM dsd34_weight_class wc
LEFT JOIN dsd34_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id)
WHERE wcd.language_id = '2'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/weight.php:10
11 (0.318)
SELECT *
FROM dsd34_length_class mc
LEFT JOIN dsd34_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id)
WHERE mcd.language_id = '2'
FROM dsd34_length_class mc
LEFT JOIN dsd34_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id)
WHERE mcd.language_id = '2'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/length.php:10
12 (0.333)
DELETE
FROM dsd34_cart
WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)
FROM dsd34_cart
WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:15
13 (0.577)
SELECT *
FROM `dsd34_event`
WHERE `trigger` LIKE 'catalog/%' AND status = '1'
ORDER BY `sort_order` ASC
FROM `dsd34_event`
WHERE `trigger` LIKE 'catalog/%' AND status = '1'
ORDER BY `sort_order` ASC
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/setting/event.php:4
14 (0.562)
SELECT *
FROM dsd34_seo_url
WHERE keyword = 'sua-tam-tram-tra-tri-mun-lung-callmehua-330ml' AND store_id = '0'
FROM dsd34_seo_url
WHERE keyword = 'sua-tam-tram-tra-tri-mun-lung-callmehua-330ml' AND store_id = '0'
/home/mrlpqflkhosting/public_html/callmehua.com/storage/modification/catalog/controller/startup/seo_url.php:61
15 (0.352)
SELECT
count(*) AS total
FROM `dsd34_journal3_skin`
FROM `dsd34_journal3_skin`
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/journal3/settings.php:112
16 (0.529)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
17 (0.326)
SELECT *
FROM dsd34_product_to_layout
WHERE product_id = '12' AND store_id = '0'
FROM dsd34_product_to_layout
WHERE product_id = '12' AND store_id = '0'
/home/mrlpqflkhosting/public_html/callmehua.com/storage/modification/catalog/model/catalog/product.php:411
18 (0.448)
SELECT *
FROM dsd34_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
FROM dsd34_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/layout.php:4
19 (0.508)
SELECT
layout_id,
layout_data
FROM `dsd34_journal3_layout`
WHERE `layout_id` = '2' OR `layout_id` = -1
ORDER BY `layout_id` DESC
FROM `dsd34_journal3_layout`
WHERE `layout_id` = '2' OR `layout_id` = -1
ORDER BY `layout_id` DESC
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/journal3/layout.php:122
20 (0.180)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
21 (0.158)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
22 (0.299)
SELECT *
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/css'
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/css'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/theme.php:4
23 (0.125)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
24 (0.118)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
25 (0.092)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
26 (0.093)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
27 (0.088)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
28 (0.089)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
29 (0.091)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
30 (0.106)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
31 (0.559)
SELECT *
FROM dsd34_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'product/product' OR route = 'vi-vn')
FROM dsd34_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'product/product' OR route = 'vi-vn')
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/translation.php:6
32 (1.099)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM dsd34_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 dsd34_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 dsd34_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM dsd34_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM dsd34_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM dsd34_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM dsd34_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' AND r1.parent_id = '0' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM dsd34_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM dsd34_product p
LEFT JOIN dsd34_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN dsd34_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN dsd34_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '12' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
FROM dsd34_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 dsd34_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 dsd34_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM dsd34_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM dsd34_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM dsd34_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM dsd34_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' AND r1.parent_id = '0' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM dsd34_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM dsd34_product p
LEFT JOIN dsd34_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN dsd34_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN dsd34_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '12' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/mrlpqflkhosting/public_html/callmehua.com/storage/modification/catalog/model/catalog/product.php:8
33 (0.369)
SELECT *
FROM dsd34_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'product/compare' OR route = 'vi-vn')
FROM dsd34_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'product/compare' OR route = 'vi-vn')
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/translation.php:6
34 (0.506)
SELECT *
FROM `dsd34_journal3_module`
WHERE `module_id` = '274'
FROM `dsd34_journal3_module`
WHERE `module_id` = '274'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/journal3/module.php:8
35 (1.006)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM dsd34_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 dsd34_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 dsd34_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM dsd34_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM dsd34_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM dsd34_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM dsd34_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' AND r1.parent_id = '0' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM dsd34_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM dsd34_product p
LEFT JOIN dsd34_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN dsd34_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN dsd34_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '12' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
FROM dsd34_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 dsd34_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 dsd34_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM dsd34_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM dsd34_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM dsd34_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM dsd34_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' AND r1.parent_id = '0' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM dsd34_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM dsd34_product p
LEFT JOIN dsd34_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN dsd34_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN dsd34_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '12' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/mrlpqflkhosting/public_html/callmehua.com/storage/modification/catalog/model/catalog/product.php:8
36 (0.700)
SELECT ag.attribute_group_id, agd.name
FROM dsd34_product_attribute pa
LEFT JOIN dsd34_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN dsd34_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN dsd34_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '12' AND agd.language_id = '2' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
FROM dsd34_product_attribute pa
LEFT JOIN dsd34_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN dsd34_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN dsd34_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '12' AND agd.language_id = '2' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/mrlpqflkhosting/public_html/callmehua.com/storage/modification/catalog/model/catalog/product.php:316
37 (0.733)
SELECT *
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/product_blocks_attributes'
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/product_blocks_attributes'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/theme.php:4
38 (0.121)
SELECT *
FROM dsd34_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'product/product' OR route = 'vi-vn')
FROM dsd34_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'product/product' OR route = 'vi-vn')
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/translation.php:6
39 (0.269)
SELECT COUNT(review_id) as count, rating
FROM dsd34_review
WHERE product_id = '12' AND parent_id = '0' GROUP BY rating
ORDER BY rating DESC
FROM dsd34_review
WHERE product_id = '12' AND parent_id = '0' GROUP BY rating
ORDER BY rating DESC
/home/mrlpqflkhosting/public_html/callmehua.com/storage/modification/catalog/controller/journal3/product_tabs.php:173
40 (0.180)
SELECT *
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/product_blocks_reviews'
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/product_blocks_reviews'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/theme.php:4
41 (0.127)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
42 (0.305)
SELECT *
FROM `dsd34_journal3_module`
WHERE `module_id` = '275'
FROM `dsd34_journal3_module`
WHERE `module_id` = '275'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/journal3/module.php:8
43 (0.111)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
44 (0.278)
SELECT *
FROM `dsd34_journal3_module`
WHERE `module_id` = '453'
FROM `dsd34_journal3_module`
WHERE `module_id` = '453'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/journal3/module.php:8
45 (0.110)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
46 (0.287)
SELECT *
FROM `dsd34_journal3_module`
WHERE `module_id` = '459'
FROM `dsd34_journal3_module`
WHERE `module_id` = '459'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/journal3/module.php:8
47 (0.132)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
48 (0.668)
SELECT *
FROM dsd34_product_custom_tab
WHERE product_id = '12'
ORDER BY id ASC
FROM dsd34_product_custom_tab
WHERE product_id = '12'
ORDER BY id ASC
/home/mrlpqflkhosting/public_html/callmehua.com/storage/modification/catalog/model/catalog/product.php:388
49 (0.362)
SELECT *
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/product_tabs'
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/product_tabs'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/theme.php:4
50 (0.119)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
51 (0.081)
SELECT *
FROM dsd34_product_custom_tab
WHERE product_id = '12'
ORDER BY id ASC
FROM dsd34_product_custom_tab
WHERE product_id = '12'
ORDER BY id ASC
/home/mrlpqflkhosting/public_html/callmehua.com/storage/modification/catalog/model/catalog/product.php:388
52 (0.061)
SELECT *
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/product_tabs'
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/product_tabs'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/theme.php:4
53 (0.115)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
54 (0.307)
SELECT *
FROM dsd34_manufacturer m
LEFT JOIN dsd34_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '0' AND m2s.store_id = '0'
FROM dsd34_manufacturer m
LEFT JOIN dsd34_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '0' AND m2s.store_id = '0'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/catalog/manufacturer.php:4
55 (0.236)
SELECT *
FROM dsd34_product_to_category
WHERE product_id = '12'
FROM dsd34_product_to_category
WHERE product_id = '12'
/home/mrlpqflkhosting/public_html/callmehua.com/storage/modification/catalog/model/catalog/product.php:428
56 (0.338)
SELECT DISTINCT *
FROM dsd34_category c
LEFT JOIN dsd34_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN dsd34_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '8' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
FROM dsd34_category c
LEFT JOIN dsd34_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN dsd34_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '8' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/catalog/category.php:4
57 (0.254)
SELECT DISTINCT *
FROM dsd34_category c
LEFT JOIN dsd34_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN dsd34_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '0' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
FROM dsd34_category c
LEFT JOIN dsd34_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN dsd34_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '0' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/catalog/category.php:4
58 (0.070)
SELECT DISTINCT *
FROM dsd34_category c
LEFT JOIN dsd34_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN dsd34_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '8' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
FROM dsd34_category c
LEFT JOIN dsd34_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN dsd34_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '8' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/catalog/category.php:4
59 (0.099)
SELECT DISTINCT *
FROM dsd34_category c
LEFT JOIN dsd34_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN dsd34_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '8' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
FROM dsd34_category c
LEFT JOIN dsd34_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN dsd34_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '8' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/catalog/category.php:4
60 (0.373)
SELECT *
FROM dsd34_seo_url
WHERE `query` = 'category_id=8' AND store_id = '0' AND language_id = '2'
FROM dsd34_seo_url
WHERE `query` = 'category_id=8' AND store_id = '0' AND language_id = '2'
/home/mrlpqflkhosting/public_html/callmehua.com/storage/modification/catalog/controller/startup/seo_url.php:331
61 (0.258)
SELECT *
FROM dsd34_seo_url
WHERE `query` = 'product_id=12' AND store_id = '0' AND language_id = '2'
FROM dsd34_seo_url
WHERE `query` = 'product_id=12' AND store_id = '0' AND language_id = '2'
/home/mrlpqflkhosting/public_html/callmehua.com/storage/modification/catalog/controller/startup/seo_url.php:243
62 (0.065)
SELECT *
FROM dsd34_seo_url
WHERE `query` = 'product_id=12' AND store_id = '0' AND language_id = '2'
FROM dsd34_seo_url
WHERE `query` = 'product_id=12' AND store_id = '0' AND language_id = '2'
/home/mrlpqflkhosting/public_html/callmehua.com/storage/modification/catalog/controller/startup/seo_url.php:243
63 (0.942)
SELECT *
FROM dsd34_seo_url
WHERE `query` = 'manufacturer_id=0' AND store_id = '0' AND language_id = '2'
FROM dsd34_seo_url
WHERE `query` = 'manufacturer_id=0' AND store_id = '0' AND language_id = '2'
/home/mrlpqflkhosting/public_html/callmehua.com/storage/modification/catalog/controller/startup/seo_url.php:243
64 (0.330)
SELECT *
FROM dsd34_product_image
WHERE product_id = '12'
ORDER BY sort_order ASC
FROM dsd34_product_image
WHERE product_id = '12'
ORDER BY sort_order ASC
/home/mrlpqflkhosting/public_html/callmehua.com/storage/modification/catalog/model/catalog/product.php:393
65 (0.114)
SELECT *
FROM dsd34_product_custom_tab
WHERE product_id = '12'
ORDER BY id ASC
FROM dsd34_product_custom_tab
WHERE product_id = '12'
ORDER BY id ASC
/home/mrlpqflkhosting/public_html/callmehua.com/storage/modification/catalog/model/catalog/product.php:388
66 (0.284)
SELECT *
FROM dsd34_product_discount
WHERE product_id = '12' 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
FROM dsd34_product_discount
WHERE product_id = '12' 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/mrlpqflkhosting/public_html/callmehua.com/storage/modification/catalog/model/catalog/product.php:381
67 (0.507)
SELECT *
FROM dsd34_product_option po
LEFT JOIN `dsd34_option` o ON (po.option_id = o.option_id)
LEFT JOIN dsd34_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '12' AND od.language_id = '2'
ORDER BY o.sort_order
FROM dsd34_product_option po
LEFT JOIN `dsd34_option` o ON (po.option_id = o.option_id)
LEFT JOIN dsd34_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '12' AND od.language_id = '2'
ORDER BY o.sort_order
/home/mrlpqflkhosting/public_html/callmehua.com/storage/modification/catalog/model/catalog/product.php:344
68 (0.096)
SELECT COUNT(review_id) as count, rating
FROM dsd34_review
WHERE product_id = '12' AND parent_id = '0' GROUP BY rating
ORDER BY rating DESC
FROM dsd34_review
WHERE product_id = '12' AND parent_id = '0' GROUP BY rating
ORDER BY rating DESC
/home/mrlpqflkhosting/public_html/callmehua.com/storage/modification/catalog/controller/product/product.php:642
69 (0.090)
SELECT *
FROM dsd34_seo_url
WHERE `query` = 'product_id=12' AND store_id = '0' AND language_id = '2'
FROM dsd34_seo_url
WHERE `query` = 'product_id=12' AND store_id = '0' AND language_id = '2'
/home/mrlpqflkhosting/public_html/callmehua.com/storage/modification/catalog/controller/startup/seo_url.php:243
70 (0.065)
SELECT ag.attribute_group_id, agd.name
FROM dsd34_product_attribute pa
LEFT JOIN dsd34_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN dsd34_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN dsd34_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '12' AND agd.language_id = '2' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
FROM dsd34_product_attribute pa
LEFT JOIN dsd34_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN dsd34_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN dsd34_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '12' AND agd.language_id = '2' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/mrlpqflkhosting/public_html/callmehua.com/storage/modification/catalog/model/catalog/product.php:316
71 (0.248)
SELECT rd.*
FROM dsd34_product_recurring pr JOIN dsd34_recurring_description rd ON (rd.language_id = 2 AND rd.recurring_id = pr.recurring_id) JOIN dsd34_recurring r ON r.recurring_id = rd.recurring_id
WHERE pr.product_id = 12 AND status = '1' AND pr.customer_group_id = '1'
ORDER BY sort_order ASC
FROM dsd34_product_recurring pr JOIN dsd34_recurring_description rd ON (rd.language_id = 2 AND rd.recurring_id = pr.recurring_id) JOIN dsd34_recurring r ON r.recurring_id = rd.recurring_id
WHERE pr.product_id = 12 AND status = '1' AND pr.customer_group_id = '1'
ORDER BY sort_order ASC
/home/mrlpqflkhosting/public_html/callmehua.com/storage/modification/catalog/model/catalog/product.php:542
72 (0.231)
UPDATE dsd34_product SET viewed = (viewed + 1)
WHERE product_id = '12'
WHERE product_id = '12'
/home/mrlpqflkhosting/public_html/callmehua.com/storage/modification/catalog/model/catalog/product.php:4
73 (0.570)
SELECT
SUM(op.quantity) AS quantity
FROM `dsd34_order_product` op
LEFT JOIN `dsd34_order` o ON op.order_id = o.order_id
WHERE o.order_status_id <> 0 AND op.product_id = '12'
FROM `dsd34_order_product` op
LEFT JOIN `dsd34_order` o ON op.order_id = o.order_id
WHERE o.order_status_id <> 0 AND op.product_id = '12'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/journal3/opencart/model.php:48
74 (0.269)
SELECT *
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/title'
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/title'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/theme.php:4
75 (0.102)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
76 (0.102)
SELECT *
FROM dsd34_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'product/product' OR route = 'vi-vn')
FROM dsd34_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'product/product' OR route = 'vi-vn')
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/translation.php:6
77 (0.280)
SELECT
p.product_id
FROM `dsd34_product` p
LEFT JOIN `dsd34_product_to_store` p2s ON (p.product_id = p2s.product_id)
WHERE p.product_id IN (12) AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
FROM `dsd34_product` p
LEFT JOIN `dsd34_product_to_store` p2s ON (p.product_id = p2s.product_id)
WHERE p.product_id IN (12) AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/mrlpqflkhosting/public_html/callmehua.com/storage/modification/catalog/model/journal3/product.php:414
78 (1.229)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM dsd34_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 dsd34_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 dsd34_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1' LIMIT 1) AS reward, (SELECT ss.name
FROM dsd34_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM dsd34_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM dsd34_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM dsd34_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 dsd34_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM dsd34_product p
LEFT JOIN dsd34_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN dsd34_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN dsd34_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id IN (12) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
FROM dsd34_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 dsd34_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 dsd34_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1' LIMIT 1) AS reward, (SELECT ss.name
FROM dsd34_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM dsd34_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM dsd34_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM dsd34_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 dsd34_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM dsd34_product p
LEFT JOIN dsd34_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN dsd34_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN dsd34_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id IN (12) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/mrlpqflkhosting/public_html/callmehua.com/storage/modification/catalog/model/journal3/product.php:27
79 (0.113)
SELECT *
FROM dsd34_seo_url
WHERE `query` = 'product_id=12' AND store_id = '0' AND language_id = '2'
FROM dsd34_seo_url
WHERE `query` = 'product_id=12' AND store_id = '0' AND language_id = '2'
/home/mrlpqflkhosting/public_html/callmehua.com/storage/modification/catalog/controller/startup/seo_url.php:243
80 (0.301)
SELECT *
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/products'
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/products'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/theme.php:4
81 (0.113)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
82 (0.204)
SELECT *
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/layout'
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/layout'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/theme.php:4
83 (0.392)
SELECT *
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'common/content_bottom'
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'common/content_bottom'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/theme.php:4
84 (0.099)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
85 (0.079)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
86 (0.116)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
87 (0.060)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
88 (0.095)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
89 (0.061)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
90 (0.085)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
91 (0.061)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
92 (0.232)
SELECT *
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/theme.php:4
93 (0.100)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
94 (0.061)
SELECT *
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/layout'
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/layout'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/theme.php:4
95 (0.060)
SELECT *
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/theme.php:4
96 (0.058)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
97 (0.097)
SELECT *
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/layout'
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/layout'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/theme.php:4
98 (0.095)
SELECT *
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/theme.php:4
99 (0.086)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
100 (0.057)
SELECT *
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/layout'
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/layout'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/theme.php:4
101 (0.071)
SELECT *
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/theme.php:4
102 (0.085)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
103 (0.055)
SELECT *
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/layout'
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/layout'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/theme.php:4
104 (0.381)
SELECT *
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/main_menu'
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/main_menu'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/theme.php:4
105 (0.117)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
106 (0.103)
SELECT *
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/theme.php:4
107 (0.085)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
108 (0.055)
SELECT *
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/layout'
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/layout'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/theme.php:4
109 (0.114)
SELECT *
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/theme.php:4
110 (0.088)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
111 (0.059)
SELECT *
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/layout'
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/layout'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/theme.php:4
112 (0.122)
SELECT *
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/theme.php:4
113 (0.117)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
114 (0.059)
SELECT *
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/layout'
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/layout'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/theme.php:4
115 (0.064)
SELECT *
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/main_menu'
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/main_menu'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/theme.php:4
116 (0.084)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
117 (0.055)
SELECT *
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/main_menu'
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/main_menu'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/theme.php:4
118 (0.114)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
119 (0.113)
SELECT *
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/main_menu'
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/main_menu'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/theme.php:4
120 (0.066)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
121 (0.467)
SELECT *
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/top_menu'
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/top_menu'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/theme.php:4
122 (0.077)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
123 (0.084)
SELECT *
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/top_menu'
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/top_menu'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/theme.php:4
124 (0.067)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
125 (0.330)
SELECT *
FROM `dsd34_journal3_module`
WHERE `module_id` = '0'
FROM `dsd34_journal3_module`
WHERE `module_id` = '0'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/journal3/module.php:8
126 (0.062)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
127 (0.073)
SELECT *
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/top_menu'
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/top_menu'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/theme.php:4
128 (0.065)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
129 (0.264)
SELECT *
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/form'
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/form'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/theme.php:4
130 (0.090)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
131 (0.086)
SELECT *
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/theme.php:4
132 (0.063)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
133 (0.636)
SELECT *
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/icons_menu'
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/icons_menu'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/theme.php:4
134 (0.079)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
135 (0.059)
SELECT *
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/theme.php:4
136 (0.132)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
137 (0.065)
SELECT *
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/theme.php:4
138 (0.085)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
139 (0.071)
SELECT *
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/theme.php:4
140 (0.083)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
141 (0.199)
SELECT *
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/info_blocks'
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/info_blocks'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/theme.php:4
142 (0.154)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
143 (0.064)
SELECT *
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/layout'
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/layout'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/theme.php:4
144 (0.083)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
145 (0.194)
SELECT *
FROM dsd34_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/footer' OR route = 'vi-vn')
FROM dsd34_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/footer' OR route = 'vi-vn')
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/translation.php:6
146 (0.281)
SELECT *
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'common/footer'
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'common/footer'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/theme.php:4
147 (0.118)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
148 (0.063)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
149 (0.061)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
150 (0.061)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
151 (0.053)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
152 (0.513)
SELECT *
FROM dsd34_setting
WHERE store_id = '0' AND `code` = 'd_social_login'
FROM dsd34_setting
WHERE store_id = '0' AND `code` = 'd_social_login'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/setting/setting.php:6
153 (0.216)
SELECT *
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'extension/module/d_social_login'
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'extension/module/d_social_login'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/theme.php:4
154 (0.076)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
155 (0.207)
SELECT *
FROM dsd34_extension
WHERE `type` = 'analytics'
FROM dsd34_extension
WHERE `type` = 'analytics'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/setting/extension.php:4
156 (0.065)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
157 (0.225)
SELECT *
FROM dsd34_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/header' OR route = 'vi-vn')
FROM dsd34_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/header' OR route = 'vi-vn')
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/translation.php:6
158 (0.442)
SELECT *
FROM dsd34_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/language' OR route = 'vi-vn')
FROM dsd34_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/language' OR route = 'vi-vn')
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/translation.php:6
159 (0.127)
SELECT *
FROM dsd34_seo_url
WHERE `query` = 'product_id=12' AND store_id = '0' AND language_id = '2'
FROM dsd34_seo_url
WHERE `query` = 'product_id=12' AND store_id = '0' AND language_id = '2'
/home/mrlpqflkhosting/public_html/callmehua.com/storage/modification/catalog/controller/startup/seo_url.php:243
160 (0.172)
SELECT *
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'common/language'
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'common/language'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/theme.php:4
161 (0.438)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
162 (0.217)
SELECT *
FROM dsd34_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/currency' OR route = 'vi-vn')
FROM dsd34_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/currency' OR route = 'vi-vn')
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/translation.php:6
163 (0.085)
SELECT *
FROM dsd34_seo_url
WHERE `query` = 'product_id=12' AND store_id = '0' AND language_id = '2'
FROM dsd34_seo_url
WHERE `query` = 'product_id=12' AND store_id = '0' AND language_id = '2'
/home/mrlpqflkhosting/public_html/callmehua.com/storage/modification/catalog/controller/startup/seo_url.php:243
164 (0.199)
SELECT *
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'common/currency'
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'common/currency'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/theme.php:4
165 (0.078)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
166 (0.290)
SELECT *
FROM dsd34_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'product/search' OR route = 'vi-vn')
FROM dsd34_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'product/search' OR route = 'vi-vn')
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/translation.php:6
167 (0.438)
SELECT *
FROM dsd34_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/search' OR route = 'vi-vn')
FROM dsd34_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/search' OR route = 'vi-vn')
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/translation.php:6
168 (0.205)
SELECT *
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'common/search'
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'common/search'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/theme.php:4
169 (0.095)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
170 (0.206)
SELECT *
FROM dsd34_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/cart' OR route = 'vi-vn')
FROM dsd34_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/cart' OR route = 'vi-vn')
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/translation.php:6
171 (0.067)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
172 (0.191)
SELECT *
FROM dsd34_extension
WHERE `type` = 'total'
FROM dsd34_extension
WHERE `type` = 'total'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/setting/extension.php:4
173 (0.185)
SELECT *
FROM dsd34_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/total/sub_total' OR route = 'vi-vn')
FROM dsd34_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/total/sub_total' OR route = 'vi-vn')
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/translation.php:6
174 (0.070)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
175 (0.061)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
176 (0.263)
SELECT *
FROM dsd34_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/total/total' OR route = 'vi-vn')
FROM dsd34_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/total/total' OR route = 'vi-vn')
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/translation.php:6
177 (0.073)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
178 (0.056)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
179 (0.064)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
180 (0.364)
SELECT *
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'common/cart'
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'common/cart'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/theme.php:4
181 (0.118)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
182 (0.432)
SELECT *
FROM dsd34_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/menu' OR route = 'vi-vn')
FROM dsd34_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/menu' OR route = 'vi-vn')
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/translation.php:6
183 (0.294)
SELECT *
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'common/menu'
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'common/menu'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/theme.php:4
184 (0.069)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
185 (0.308)
SELECT *
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'common/header'
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'common/header'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/theme.php:4
186 (1.393)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM dsd34_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 dsd34_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 dsd34_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM dsd34_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM dsd34_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM dsd34_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM dsd34_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' AND r1.parent_id = '0' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM dsd34_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM dsd34_product p
LEFT JOIN dsd34_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN dsd34_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN dsd34_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '12' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
FROM dsd34_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 dsd34_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 dsd34_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM dsd34_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM dsd34_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM dsd34_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM dsd34_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' AND r1.parent_id = '0' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM dsd34_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM dsd34_product p
LEFT JOIN dsd34_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN dsd34_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN dsd34_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '12' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/mrlpqflkhosting/public_html/callmehua.com/storage/modification/catalog/model/catalog/product.php:8
187 (0.084)
SELECT *
FROM dsd34_seo_url
WHERE `query` = 'product_id=12' AND store_id = '0' AND language_id = '2'
FROM dsd34_seo_url
WHERE `query` = 'product_id=12' AND store_id = '0' AND language_id = '2'
/home/mrlpqflkhosting/public_html/callmehua.com/storage/modification/catalog/controller/startup/seo_url.php:243
188 (0.457)
SELECT r.review_id, r.author, r.rating, r.text, p.product_id, pd.name, p.price, p.image, r.date_added
FROM dsd34_review r
LEFT JOIN dsd34_product p ON (r.product_id = p.product_id)
LEFT JOIN dsd34_product_description pd ON (p.product_id = pd.product_id)
WHERE p.product_id = '12' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '2'
ORDER BY r.date_added DESC LIMIT 1
FROM dsd34_review r
LEFT JOIN dsd34_product p ON (r.product_id = p.product_id)
LEFT JOIN dsd34_product_description pd ON (p.product_id = pd.product_id)
WHERE p.product_id = '12' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '2'
ORDER BY r.date_added DESC LIMIT 1
/home/mrlpqflkhosting/public_html/callmehua.com/storage/modification/catalog/controller/journal3/seo.php:323
189 (0.089)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
190 (0.112)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
191 (0.136)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
192 (0.078)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
193 (0.117)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
194 (0.455)
SELECT *
FROM dsd34_setting
WHERE store_id = '0' AND `code` = 'advertise_google'
FROM dsd34_setting
WHERE store_id = '0' AND `code` = 'advertise_google'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/setting/setting.php:6
195 (0.083)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
196 (0.367)
SELECT *
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'product/product'
FROM dsd34_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'product/product'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/theme.php:4
197 (0.095)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
198 (0.091)
SELECT *
FROM dsd34_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/header' OR route = 'vi-vn')
FROM dsd34_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/header' OR route = 'vi-vn')
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/design/translation.php:6
199 (0.113)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36
200 (0.121)
SELECT *
FROM dsd34_setting
WHERE store_id = '0' AND `code` = 'advertise_google'
FROM dsd34_setting
WHERE store_id = '0' AND `code` = 'advertise_google'
/home/mrlpqflkhosting/public_html/callmehua.com/catalog/model/setting/setting.php:6
201 (0.065)
SELECT *
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
FROM dsd34_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cdb1f6e32c659aa428d0d5a936'
/home/mrlpqflkhosting/public_html/callmehua.com/system/library/cart/cart.php:36