1 (0.723)
SET time_zone = '+00:00'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/framework.php:84
2 (1.369)
SELECT *
FROM fhj6_translation
WHERE store_id = '0' AND language_id = '0' AND (route = 'engb' OR route = '')
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/translation.php:6
3 (64.639)
SELECT `data`
FROM `fhj6_session`
WHERE `session_id` = 'fb08fe4735c4e73347e38a0e99' AND `expire` > '2025-10-21 23:28:12'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/session/db.php:16
4 (1.792)
SELECT *
FROM fhj6_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://ssd.3tc.vn/'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/controller/startup/startup.php:6
5 (21.419)
SELECT *
FROM `fhj6_setting`
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/controller/startup/startup.php:25
6 (1.347)
SET time_zone = '+07:00'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/controller/startup/startup.php:40
7 (3.002)
SELECT *
FROM fhj6_currency
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/currency.php:10
8 (3.823)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM fhj6_tax_rule tr1
LEFT JOIN fhj6_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN fhj6_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN fhj6_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN fhj6_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/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/tax.php:16
9 (1.055)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM fhj6_tax_rule tr1
LEFT JOIN fhj6_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN fhj6_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN fhj6_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN fhj6_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/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/tax.php:44
10 (2.537)
SELECT *
FROM fhj6_weight_class wc
LEFT JOIN fhj6_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id)
WHERE wcd.language_id = '2'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/weight.php:10
11 (1.601)
SELECT *
FROM fhj6_length_class mc
LEFT JOIN fhj6_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id)
WHERE mcd.language_id = '2'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/length.php:10
12 (384.964)
DELETE
FROM fhj6_cart
WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:15
13 (11.428)
SELECT *
FROM `fhj6_event`
WHERE `trigger` LIKE 'catalog/%' AND status = '1'
ORDER BY `sort_order` ASC
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/setting/event.php:4
14 (6.942)
SELECT *
FROM fhj6_seo_url
WHERE keyword = 'o-cung-wd-my-passport-wireless-pro-4tb' AND store_id = '0'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/controller/startup/seo_url.php:61
15 (2.232)
SELECT
count(*) AS total
FROM
`fhj6_journal3_skin`
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/journal3/settings.php:112
16 (1.652)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
17 (2.507)
SELECT *
FROM fhj6_product_to_layout
WHERE product_id = '542' AND store_id = '0'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/model/catalog/product.php:411
18 (5.233)
SELECT *
FROM fhj6_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/layout.php:4
19 (3.092)
SELECT
layout_id,
layout_data
FROM
`fhj6_journal3_layout`
WHERE
`layout_id` = '2'
OR `layout_id` = -1
ORDER BY
`layout_id` DESC
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/journal3/layout.php:122
20 (1.695)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
21 (0.927)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
22 (0.862)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/css'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
23 (2.088)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
24 (2.455)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
25 (1.595)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
26 (1.352)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
27 (1.724)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
28 (1.565)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
29 (1.609)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
30 (3.102)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
31 (1.371)
SELECT *
FROM fhj6_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'product/product' OR route = 'vi-vn')
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/translation.php:6
32 (53.096)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM fhj6_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 fhj6_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 fhj6_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM fhj6_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM fhj6_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 fhj6_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 fhj6_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 fhj6_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM fhj6_product p
LEFT JOIN fhj6_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN fhj6_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN fhj6_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '542' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/model/catalog/product.php:8
33 (7.341)
SELECT *
FROM fhj6_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'product/compare' OR route = 'vi-vn')
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/translation.php:6
34 (4.451)
SELECT *
FROM `fhj6_journal3_module`
WHERE `module_id` = '277'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/journal3/module.php:8
35 (1.554)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
36 (1.693)
SELECT *
FROM `fhj6_journal3_module`
WHERE `module_id` = '273'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/journal3/module.php:8
37 (10.601)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM fhj6_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 fhj6_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 fhj6_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM fhj6_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM fhj6_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 fhj6_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 fhj6_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 fhj6_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM fhj6_product p
LEFT JOIN fhj6_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN fhj6_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN fhj6_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '542' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/model/catalog/product.php:8
38 (5.407)
SELECT ag.attribute_group_id, agd.name
FROM fhj6_product_attribute pa
LEFT JOIN fhj6_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN fhj6_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN fhj6_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '542' AND agd.language_id = '2' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/model/catalog/product.php:316
39 (10.380)
SELECT a.attribute_id, ad.name, pa.text
FROM fhj6_product_attribute pa
LEFT JOIN fhj6_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN fhj6_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '542' AND a.attribute_group_id = '11' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY pa.product_attribute_id ,a.sort_order, ad.name
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/model/catalog/product.php:321
40 (1.185)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/product_blocks_attributes'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
41 (4.152)
SELECT *
FROM fhj6_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'product/product' OR route = 'vi-vn')
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/translation.php:6
42 (10.155)
SELECT COUNT(review_id) as count, rating
FROM fhj6_review
WHERE product_id = '542' AND parent_id = '0' GROUP BY rating
ORDER BY rating DESC
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/controller/journal3/product_tabs.php:173
43 (4.163)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/product_blocks_reviews'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
44 (1.224)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
45 (4.572)
SELECT *
FROM `fhj6_journal3_module`
WHERE `module_id` = '274'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/journal3/module.php:8
46 (15.766)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
47 (3.582)
SELECT *
FROM `fhj6_journal3_module`
WHERE `module_id` = '275'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/journal3/module.php:8
48 (9.313)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
49 (5.879)
SELECT *
FROM `fhj6_journal3_module`
WHERE `module_id` = '276'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/journal3/module.php:8
50 (1.833)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
51 (1.380)
SELECT *
FROM fhj6_product_custom_tab
WHERE product_id = '542'
ORDER BY id ASC
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/model/catalog/product.php:388
52 (5.500)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/product_tabs'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
53 (26.703)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
54 (3.013)
SELECT *
FROM fhj6_product_custom_tab
WHERE product_id = '542'
ORDER BY id ASC
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/model/catalog/product.php:388
55 (1.156)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/product_tabs'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
56 (9.804)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
57 (3.567)
SELECT *
FROM fhj6_manufacturer m
LEFT JOIN fhj6_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '0' AND m2s.store_id = '0'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/catalog/manufacturer.php:4
58 (4.297)
SELECT *
FROM fhj6_product_to_category
WHERE product_id = '542'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/model/catalog/product.php:428
59 (4.263)
SELECT DISTINCT *
FROM fhj6_category c
LEFT JOIN fhj6_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN fhj6_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '72' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/catalog/category.php:4
60 (3.109)
SELECT DISTINCT *
FROM fhj6_category c
LEFT JOIN fhj6_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN fhj6_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '175' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/catalog/category.php:4
61 (1.305)
SELECT DISTINCT *
FROM fhj6_category c
LEFT JOIN fhj6_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN fhj6_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/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/catalog/category.php:4
62 (1.851)
SELECT DISTINCT *
FROM fhj6_category c
LEFT JOIN fhj6_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN fhj6_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '72' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/catalog/category.php:4
63 (1.944)
SELECT DISTINCT *
FROM fhj6_category c
LEFT JOIN fhj6_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN fhj6_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '175' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/catalog/category.php:4
64 (7.460)
SELECT *
FROM fhj6_seo_url
WHERE `query` = 'category_id=175' AND store_id = '0' AND language_id = '2'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/controller/startup/seo_url.php:331
65 (2.220)
SELECT DISTINCT *
FROM fhj6_category c
LEFT JOIN fhj6_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN fhj6_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '72' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/catalog/category.php:4
66 (2.749)
SELECT *
FROM fhj6_seo_url
WHERE `query` = 'category_id=175' AND store_id = '0' AND language_id = '2'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/controller/startup/seo_url.php:331
67 (2.671)
SELECT *
FROM fhj6_seo_url
WHERE `query` = 'category_id=72' AND store_id = '0' AND language_id = '2'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/controller/startup/seo_url.php:331
68 (6.000)
SELECT *
FROM fhj6_seo_url
WHERE `query` = 'product_id=542' AND store_id = '0' AND language_id = '2'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/controller/startup/seo_url.php:243
69 (0.918)
SELECT *
FROM fhj6_seo_url
WHERE `query` = 'product_id=542' AND store_id = '0' AND language_id = '2'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/controller/startup/seo_url.php:243
70 (0.798)
SELECT *
FROM fhj6_seo_url
WHERE `query` = 'manufacturer_id=0' AND store_id = '0' AND language_id = '2'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/controller/startup/seo_url.php:243
71 (1.747)
SELECT *
FROM fhj6_product_image
WHERE product_id = '542'
ORDER BY sort_order ASC
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/model/catalog/product.php:393
72 (2.209)
SELECT *
FROM fhj6_product_custom_tab
WHERE product_id = '542'
ORDER BY id ASC
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/model/catalog/product.php:388
73 (1.751)
SELECT *
FROM fhj6_product_discount
WHERE product_id = '542' 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/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/model/catalog/product.php:381
74 (2.734)
SELECT *
FROM fhj6_product_option po
LEFT JOIN `fhj6_option` o ON (po.option_id = o.option_id)
LEFT JOIN fhj6_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '542' AND od.language_id = '2'
ORDER BY o.sort_order
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/model/catalog/product.php:344
75 (2.771)
SELECT COUNT(review_id) as count, rating
FROM fhj6_review
WHERE product_id = '542' AND parent_id = '0' GROUP BY rating
ORDER BY rating DESC
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/controller/product/product.php:641
76 (2.315)
SELECT *
FROM fhj6_seo_url
WHERE `query` = 'product_id=542' AND store_id = '0' AND language_id = '2'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/controller/startup/seo_url.php:243
77 (2.349)
SELECT ag.attribute_group_id, agd.name
FROM fhj6_product_attribute pa
LEFT JOIN fhj6_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN fhj6_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN fhj6_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '542' AND agd.language_id = '2' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/model/catalog/product.php:316
78 (6.188)
SELECT a.attribute_id, ad.name, pa.text
FROM fhj6_product_attribute pa
LEFT JOIN fhj6_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN fhj6_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '542' AND a.attribute_group_id = '11' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY pa.product_attribute_id ,a.sort_order, ad.name
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/model/catalog/product.php:321
79 (2.057)
SELECT rd.*
FROM fhj6_product_recurring pr JOIN fhj6_recurring_description rd ON (rd.language_id = 2 AND rd.recurring_id = pr.recurring_id) JOIN fhj6_recurring r ON r.recurring_id = rd.recurring_id
WHERE pr.product_id = 542 AND status = '1' AND pr.customer_group_id = '1'
ORDER BY sort_order ASC
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/model/catalog/product.php:542
80 (2.667)
UPDATE fhj6_product SET viewed = (viewed + 1)
WHERE product_id = '542'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/model/catalog/product.php:4
81 (3.696)
SELECT
SUM(op.quantity) AS quantity
FROM `fhj6_order_product` op
LEFT JOIN `fhj6_order` o ON op.order_id = o.order_id
WHERE o.order_status_id <> 0 AND op.product_id = '542'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/journal3/opencart/model.php:48
82 (6.480)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/info_blocks'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
83 (2.836)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
84 (3.141)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/title'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
85 (7.068)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
86 (2.767)
SELECT *
FROM fhj6_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'product/product' OR route = 'vi-vn')
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/translation.php:6
87 (5.286)
SELECT *
FROM fhj6_seo_url
WHERE `query` = 'product_id=1114' AND store_id = '0' AND language_id = '2'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/controller/startup/seo_url.php:243
88 (1.536)
SELECT *
FROM fhj6_seo_url
WHERE `query` = 'product_id=1233' AND store_id = '0' AND language_id = '2'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/controller/startup/seo_url.php:243
89 (1.682)
SELECT *
FROM fhj6_seo_url
WHERE `query` = 'product_id=438' AND store_id = '0' AND language_id = '2'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/controller/startup/seo_url.php:243
90 (2.235)
SELECT *
FROM fhj6_seo_url
WHERE `query` = 'product_id=889' AND store_id = '0' AND language_id = '2'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/controller/startup/seo_url.php:243
91 (1.966)
SELECT *
FROM fhj6_seo_url
WHERE `query` = 'product_id=939' AND store_id = '0' AND language_id = '2'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/controller/startup/seo_url.php:243
92 (1.667)
SELECT *
FROM fhj6_seo_url
WHERE `query` = 'product_id=1269' AND store_id = '0' AND language_id = '2'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/controller/startup/seo_url.php:243
93 (2.253)
SELECT *
FROM fhj6_seo_url
WHERE `query` = 'product_id=1373' AND store_id = '0' AND language_id = '2'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/controller/startup/seo_url.php:243
94 (3.679)
SELECT *
FROM fhj6_seo_url
WHERE `query` = 'product_id=163' AND store_id = '0' AND language_id = '2'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/controller/startup/seo_url.php:243
95 (1.798)
SELECT *
FROM fhj6_seo_url
WHERE `query` = 'product_id=871' AND store_id = '0' AND language_id = '2'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/controller/startup/seo_url.php:243
96 (2.517)
SELECT *
FROM fhj6_seo_url
WHERE `query` = 'product_id=502' AND store_id = '0' AND language_id = '2'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/controller/startup/seo_url.php:243
97 (3.696)
SELECT *
FROM fhj6_seo_url
WHERE `query` = 'product_id=110' AND store_id = '0' AND language_id = '2'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/controller/startup/seo_url.php:243
98 (2.365)
SELECT *
FROM fhj6_seo_url
WHERE `query` = 'product_id=1025' AND store_id = '0' AND language_id = '2'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/controller/startup/seo_url.php:243
99 (4.490)
SELECT *
FROM fhj6_seo_url
WHERE `query` = 'product_id=4' AND store_id = '0' AND language_id = '2'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/controller/startup/seo_url.php:243
100 (1.901)
SELECT *
FROM fhj6_seo_url
WHERE `query` = 'product_id=556' AND store_id = '0' AND language_id = '2'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/controller/startup/seo_url.php:243
101 (3.024)
SELECT *
FROM fhj6_seo_url
WHERE `query` = 'product_id=960' AND store_id = '0' AND language_id = '2'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/controller/startup/seo_url.php:243
102 (4.627)
SELECT *
FROM fhj6_seo_url
WHERE `query` = 'product_id=1470' AND store_id = '0' AND language_id = '2'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/controller/startup/seo_url.php:243
103 (2.264)
SELECT *
FROM fhj6_seo_url
WHERE `query` = 'product_id=427' AND store_id = '0' AND language_id = '2'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/controller/startup/seo_url.php:243
104 (2.576)
SELECT *
FROM fhj6_seo_url
WHERE `query` = 'product_id=524' AND store_id = '0' AND language_id = '2'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/controller/startup/seo_url.php:243
105 (2.540)
SELECT *
FROM fhj6_seo_url
WHERE `query` = 'product_id=242' AND store_id = '0' AND language_id = '2'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/controller/startup/seo_url.php:243
106 (2.987)
SELECT *
FROM fhj6_seo_url
WHERE `query` = 'product_id=1004' AND store_id = '0' AND language_id = '2'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/controller/startup/seo_url.php:243
107 (3.230)
SELECT *
FROM fhj6_seo_url
WHERE `query` = 'product_id=480' AND store_id = '0' AND language_id = '2'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/controller/startup/seo_url.php:243
108 (2.698)
SELECT *
FROM fhj6_seo_url
WHERE `query` = 'product_id=1068' AND store_id = '0' AND language_id = '2'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/controller/startup/seo_url.php:243
109 (2.436)
SELECT *
FROM fhj6_seo_url
WHERE `query` = 'product_id=1532' AND store_id = '0' AND language_id = '2'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/controller/startup/seo_url.php:243
110 (7.553)
SELECT *
FROM fhj6_seo_url
WHERE `query` = 'product_id=13' AND store_id = '0' AND language_id = '2'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/controller/startup/seo_url.php:243
111 (1.952)
SELECT *
FROM fhj6_seo_url
WHERE `query` = 'product_id=1151' AND store_id = '0' AND language_id = '2'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/controller/startup/seo_url.php:243
112 (1.422)
SELECT *
FROM fhj6_seo_url
WHERE `query` = 'product_id=1096' AND store_id = '0' AND language_id = '2'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/controller/startup/seo_url.php:243
113 (3.821)
SELECT *
FROM fhj6_seo_url
WHERE `query` = 'product_id=1415' AND store_id = '0' AND language_id = '2'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/controller/startup/seo_url.php:243
114 (1.227)
SELECT *
FROM fhj6_seo_url
WHERE `query` = 'product_id=1542' AND store_id = '0' AND language_id = '2'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/controller/startup/seo_url.php:243
115 (1.915)
SELECT *
FROM fhj6_seo_url
WHERE `query` = 'product_id=440' AND store_id = '0' AND language_id = '2'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/controller/startup/seo_url.php:243
116 (1.604)
SELECT *
FROM fhj6_seo_url
WHERE `query` = 'product_id=912' AND store_id = '0' AND language_id = '2'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/controller/startup/seo_url.php:243
117 (1.867)
SELECT *
FROM fhj6_seo_url
WHERE `query` = 'product_id=1593' AND store_id = '0' AND language_id = '2'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/controller/startup/seo_url.php:243
118 (3.445)
SELECT *
FROM fhj6_seo_url
WHERE `query` = 'product_id=1089' AND store_id = '0' AND language_id = '2'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/controller/startup/seo_url.php:243
119 (1.057)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/products'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
120 (1.607)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
121 (1.456)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/layout'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
122 (0.874)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'common/column_right'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
123 (2.676)
SELECT *
FROM fhj6_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'product/product' OR route = 'vi-vn')
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/translation.php:6
124 (6.834)
SELECT
c.category_id
FROM `fhj6_category` c
LEFT JOIN `fhj6_category_to_store` c2s ON (c.category_id = c2s.category_id)
LEFT JOIN `fhj6_product_to_category` p2c ON (c.category_id = p2c.category_id)
LEFT JOIN `fhj6_product` p ON (p2c.product_id = p.product_id)
LEFT JOIN `fhj6_product_to_store` p2s ON (p.product_id = p2s.product_id)
WHERE
p2c.product_id IN (542)
AND c.status = '1'
AND c2s.store_id = '0'
AND p.status = '1'
AND p.date_available <= NOW()
AND p2s.store_id = '0'
GROUP BY
c.category_id
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/model/journal3/product.php:233
125 (247.448)
SELECT *
FROM `fhj6_product` p
LEFT JOIN `fhj6_product_description` pd ON (p.product_id = pd.product_id)
LEFT JOIN `fhj6_product_to_store` p2s ON (p.product_id = p2s.product_id)
LEFT JOIN `fhj6_product_to_category` p2c ON (p.product_id = p2c.product_id)
LEFT JOIN `fhj6_category` c ON (c.category_id = p2c.category_id)
LEFT JOIN `fhj6_category_to_store` c2s ON (c.category_id = c2s.category_id)
WHERE
c.category_id IN (72, 83, 86, 140, 149)
AND p.status = '1'
AND p.date_available <= NOW()
AND pd.language_id = '2'
AND p2s.store_id = '0'
AND c.status = '1'
AND c2s.store_id = '0'
AND p.product_id != '542'
ORDER BY p.sort_order ASC, LCASE(pd.name) ASC
LIMIT 0, 5
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/model/journal3/product.php:275
126 (54.207)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM fhj6_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 fhj6_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 fhj6_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1' LIMIT 1) AS reward, (SELECT ss.name
FROM fhj6_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM fhj6_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 fhj6_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 fhj6_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 fhj6_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM fhj6_product p
LEFT JOIN fhj6_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN fhj6_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN fhj6_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id IN (145,146,147,90,7) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/model/journal3/product.php:27
127 (12.514)
SELECT *
FROM fhj6_seo_url
WHERE `query` = 'product_id=145' AND store_id = '0' AND language_id = '2'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/controller/startup/seo_url.php:243
128 (3.574)
SELECT *
FROM fhj6_seo_url
WHERE `query` = 'product_id=146' AND store_id = '0' AND language_id = '2'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/controller/startup/seo_url.php:243
129 (6.690)
SELECT *
FROM fhj6_seo_url
WHERE `query` = 'product_id=147' AND store_id = '0' AND language_id = '2'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/controller/startup/seo_url.php:243
130 (9.245)
SELECT *
FROM fhj6_seo_url
WHERE `query` = 'product_id=90' AND store_id = '0' AND language_id = '2'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/controller/startup/seo_url.php:243
131 (2.364)
SELECT *
FROM fhj6_seo_url
WHERE `query` = 'product_id=7' AND store_id = '0' AND language_id = '2'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/controller/startup/seo_url.php:243
132 (1.830)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/products'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
133 (3.206)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
134 (2.184)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/layout'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
135 (1.689)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'common/bottom'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
136 (2.500)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
137 (1.834)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
138 (1.815)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
139 (1.849)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
140 (1.251)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
141 (0.793)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
142 (0.982)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
143 (0.938)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
144 (0.832)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
145 (1.224)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
146 (1.835)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
147 (1.412)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
148 (1.617)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
149 (3.472)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
150 (1.192)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
151 (2.031)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
152 (0.802)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/layout'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
153 (2.054)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
154 (1.808)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
155 (1.077)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
156 (1.249)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
157 (1.479)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
158 (2.046)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
159 (3.017)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
160 (1.319)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
161 (1.231)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/layout'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
162 (1.072)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
163 (1.387)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
164 (0.714)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
165 (1.410)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
166 (0.818)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
167 (1.238)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
168 (0.518)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
169 (1.195)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
170 (0.633)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/layout'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
171 (8.304)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
172 (3.182)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
173 (0.747)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
174 (1.418)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
175 (1.035)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
176 (0.735)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
177 (0.822)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
178 (0.884)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
179 (0.393)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/layout'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
180 (6.391)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
181 (2.129)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
182 (2.795)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
183 (3.745)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
184 (1.780)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
185 (1.694)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
186 (1.962)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
187 (2.359)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
188 (0.973)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/layout'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
189 (0.822)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
190 (1.092)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
191 (0.649)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/layout'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
192 (1.421)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
193 (1.229)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
194 (0.837)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
195 (1.152)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
196 (1.433)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/layout'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
197 (0.959)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
198 (0.980)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
199 (1.121)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
200 (2.571)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
201 (0.639)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
202 (1.693)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
203 (1.886)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/layout'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
204 (1.173)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
205 (1.089)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
206 (0.959)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/layout'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
207 (0.490)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/main_menu'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
208 (1.462)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
209 (1.928)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/main_menu'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
210 (1.271)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
211 (0.938)
SELECT *
FROM `fhj6_journal3_module`
WHERE `module_id` = '0'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/journal3/module.php:8
212 (2.158)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
213 (0.875)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/top_menu'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
214 (1.322)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
215 (0.875)
SELECT *
FROM `fhj6_journal3_module`
WHERE `module_id` = '0'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/journal3/module.php:8
216 (1.012)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
217 (0.860)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/top_menu'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
218 (0.889)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
219 (1.279)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/top_menu'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
220 (1.454)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
221 (1.508)
SELECT *
FROM fhj6_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'product/product' OR route = 'vi-vn')
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/translation.php:6
222 (2.733)
SELECT
p.product_id
FROM `fhj6_product` p
LEFT JOIN `fhj6_product_to_store` p2s ON (p.product_id = p2s.product_id)
WHERE
p.product_id IN (542)
AND p.status = '1'
AND p.date_available <= NOW()
AND p2s.store_id = '0'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/model/journal3/product.php:414
223 (16.637)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM fhj6_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 fhj6_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 fhj6_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1' LIMIT 1) AS reward, (SELECT ss.name
FROM fhj6_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM fhj6_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 fhj6_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 fhj6_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 fhj6_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM fhj6_product p
LEFT JOIN fhj6_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN fhj6_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN fhj6_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id IN (542) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/model/journal3/product.php:27
224 (1.978)
SELECT *
FROM fhj6_seo_url
WHERE `query` = 'product_id=542' AND store_id = '0' AND language_id = '2'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/controller/startup/seo_url.php:243
225 (0.708)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/side_products'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
226 (1.180)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
227 (0.725)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/info_blocks'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
228 (1.885)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
229 (0.893)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
230 (1.398)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
231 (0.929)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
232 (1.038)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
233 (1.002)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/info_blocks'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
234 (1.010)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
235 (0.756)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/newsletter'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
236 (4.494)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
237 (1.269)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
238 (2.102)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
239 (0.913)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/icons_menu'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
240 (1.119)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
241 (1.096)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
242 (1.197)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
243 (1.258)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/layout'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
244 (1.871)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
245 (2.165)
SELECT *
FROM fhj6_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/footer' OR route = 'vi-vn')
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/translation.php:6
246 (0.880)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'common/footer'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
247 (2.300)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
248 (1.602)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
249 (2.055)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
250 (1.289)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
251 (2.076)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
252 (2.480)
SELECT *
FROM fhj6_setting
WHERE store_id = '0' AND `code` = 'd_social_login'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/setting/setting.php:6
253 (1.315)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'extension/module/d_social_login'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
254 (2.795)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
255 (1.602)
SELECT *
FROM fhj6_extension
WHERE `type` = 'analytics'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/setting/extension.php:4
256 (0.845)
SELECT *
FROM fhj6_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/header' OR route = 'vi-vn')
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/translation.php:6
257 (1.881)
SELECT *
FROM fhj6_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/language' OR route = 'vi-vn')
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/translation.php:6
258 (2.522)
SELECT *
FROM fhj6_seo_url
WHERE `query` = 'product_id=542' AND store_id = '0' AND language_id = '2'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/controller/startup/seo_url.php:243
259 (0.896)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'common/language'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
260 (1.395)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
261 (0.616)
SELECT *
FROM fhj6_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/currency' OR route = 'vi-vn')
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/translation.php:6
262 (2.004)
SELECT *
FROM fhj6_seo_url
WHERE `query` = 'product_id=542' AND store_id = '0' AND language_id = '2'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/controller/startup/seo_url.php:243
263 (1.061)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'common/currency'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
264 (0.958)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
265 (1.130)
SELECT *
FROM fhj6_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/search' OR route = 'vi-vn')
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/translation.php:6
266 (0.802)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'common/search'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
267 (1.741)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
268 (1.632)
SELECT *
FROM fhj6_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/cart' OR route = 'vi-vn')
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/translation.php:6
269 (1.191)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
270 (1.361)
SELECT *
FROM fhj6_extension
WHERE `type` = 'total'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/setting/extension.php:4
271 (0.683)
SELECT *
FROM fhj6_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/total/sub_total' OR route = 'vi-vn')
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/translation.php:6
272 (1.044)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
273 (1.150)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
274 (1.455)
SELECT *
FROM fhj6_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/total/total' OR route = 'vi-vn')
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/translation.php:6
275 (1.277)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
276 (1.105)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
277 (1.628)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
278 (1.307)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'common/cart'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
279 (1.251)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
280 (0.986)
SELECT *
FROM fhj6_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/menu' OR route = 'vi-vn')
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/translation.php:6
281 (1.524)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'common/menu'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
282 (1.034)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
283 (0.822)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'common/header'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
284 (11.444)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM fhj6_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 fhj6_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 fhj6_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM fhj6_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM fhj6_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 fhj6_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 fhj6_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 fhj6_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM fhj6_product p
LEFT JOIN fhj6_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN fhj6_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN fhj6_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '542' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/model/catalog/product.php:8
285 (2.818)
SELECT *
FROM fhj6_seo_url
WHERE `query` = 'product_id=542' AND store_id = '0' AND language_id = '2'
/home/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/controller/startup/seo_url.php:243
286 (1.864)
SELECT r.review_id, r.author, r.rating, r.text, p.product_id, pd.name, p.price, p.image, r.date_added
FROM fhj6_review r
LEFT JOIN fhj6_product p ON (r.product_id = p.product_id)
LEFT JOIN fhj6_product_description pd ON (p.product_id = pd.product_id)
WHERE
p.product_id = '542'
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/ssd3tc/domains/ssd.3tc.vn/storage/modification/catalog/controller/journal3/seo.php:323
287 (1.359)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
288 (3.555)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
289 (1.327)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
290 (1.188)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
291 (1.479)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
292 (1.942)
SELECT *
FROM fhj6_setting
WHERE store_id = '0' AND `code` = 'advertise_google'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/setting/setting.php:6
293 (2.115)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
294 (1.426)
SELECT *
FROM fhj6_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'product/product'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/theme.php:4
295 (1.395)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
296 (1.038)
SELECT *
FROM fhj6_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/header' OR route = 'vi-vn')
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/design/translation.php:6
297 (1.293)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36
298 (2.344)
SELECT *
FROM fhj6_setting
WHERE store_id = '0' AND `code` = 'advertise_google'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/catalog/model/setting/setting.php:6
299 (1.765)
SELECT *
FROM fhj6_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fb08fe4735c4e73347e38a0e99'
/home/ssd3tc/domains/ssd.3tc.vn/public_html/system/library/cart/cart.php:36