Menu
Your Cart

LifeSmart door open/close sensor

LifeSmart door open/close sensor
LifeSmart door open/close sensor
LifeSmart door open/close sensor
LifeSmart door open/close sensor
LifeSmart door open/close sensor
LifeSmart door open/close sensor
LifeSmart door open/close sensor
LifeSmart door open/close sensor
LifeSmart door open/close sensor
LifeSmart door open/close sensor
LifeSmart door open/close sensor
LifeSmart door open/close sensor
LifeSmart door open/close sensor
LifeSmart door open/close sensor
LifeSmart door open/close sensor
  • Stock: In Stock
Call for pricing

Custom Tabs

Promotion

Support consulting to choose to buy products online.

Phone consultation 1900 29 99 68

Payment Delivery

Ship within the city: 60 minutes fast package and same day delivery.

Ship to other provinces: 24h-72h (with express ship) See details

Ship COD / garage according to customer requirements.

Simple installation LifeSmart Door/Window Sensor combines a magnetic sensor and a vibration sensor that detects when a door or window is opened and can automatically notify on your LifeSmart App. It can also be used to trigger events with other smart devices, including a camera that takes snapshots when it detects an unusual door opening, controls lighting, activates home mode and more. .

LifeSmart's CUBE Door/Window Sensor can send notifications through your Life Smart App when it detects an open door/window. It can also be used to trigger events with other smart devices, such as creating snapshots with the Smart Wi-Fi Home Camera of anyone entering your home. The machine is equipped with a vibration sensor. If someone tries to break in, you can get an instant notification. It is also a CUBE Clicker. A simple click can trigger a series of actions by smart devices. With the help of LifeSmart Cloud services and other amazing technologies.

It also integrates a 1-touch button to switch scenes, for example, when you close the door to go out, the phone is not carried, just one button is needed for all devices in the family to automatically turn off, or automatically activate. security context, anti-theft......

FUNCTION CHARACTERISTICS

  • Remote alarm when detecting open or vibrate
  • Real-time feedback on door/window status
  • Notifications and profile search via the app
  • One button for intelligent scene control
  • Compatible with Apple Homekit


SPECIFICATIONS
Product CodeLS058WH
Power SupplyCR2450 battery, 3V
Battery lifeUp to 5 years
SensorMagnetic sensor, vibration sensor
DiscoverDoor and window detection
Radio ProtocolCoSS
Signal Range (Open Field)200m
Colormilk white
Size38.4 * 38.4 * 14.6mm

Write a review

0/5
You have this product?
5
(0)
4
(0)
3
(0)
2
(0)
1
(0)
Queries: 162, Total time: 78.140 ms [By time] [By id] [By file]
1 (0.117)
SET time_zone = '+00:00'
/home/lifesmart/domains/lifesmart.vn/public_html/system/framework.php:84
2 (0.419)
SELECT *
FROM ttq_translation
WHERE store_id = '0' AND language_id = '0' AND (route = 'engb' OR route = '')
/home/lifesmart/domains/lifesmart.vn/public_html/catalog/model/design/translation.php:6
3 (0.871)
SELECT `data`
FROM `ttq_session`
WHERE `session_id` = 'a2fe5a20532978f33f5ad9b9a4' AND `expire` > '2024-10-10 07:39:11'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/session/db.php:16
4 (0.270)
SELECT *
FROM ttq_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://lifesmart.vn/'
/home/lifesmart/domains/lifesmart.vn/storage/modification/catalog/controller/startup/startup.php:6
5 (1.660)
SELECT *
FROM `ttq_setting`
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
/home/lifesmart/domains/lifesmart.vn/storage/modification/catalog/controller/startup/startup.php:25
6 (0.180)
SET time_zone = '+07:00'
/home/lifesmart/domains/lifesmart.vn/storage/modification/catalog/controller/startup/startup.php:40
7 (0.384)
SELECT *
FROM ttq_currency
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/currency.php:10
8 (0.504)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM ttq_tax_rule tr1
LEFT JOIN ttq_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN ttq_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN ttq_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN ttq_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/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/tax.php:16
9 (0.283)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM ttq_tax_rule tr1
LEFT JOIN ttq_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN ttq_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN ttq_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN ttq_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/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/tax.php:44
10 (0.445)
SELECT *
FROM ttq_weight_class wc
LEFT JOIN ttq_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id)
WHERE wcd.language_id = '1'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/weight.php:10
11 (0.284)
SELECT *
FROM ttq_length_class mc
LEFT JOIN ttq_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id)
WHERE mcd.language_id = '1'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/length.php:10
12 (0.363)
DELETE
FROM ttq_cart
WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:15
13 (0.582)
SELECT *
FROM `ttq_event`
WHERE `trigger` LIKE 'catalog/%' AND status = '1'
ORDER BY `sort_order` ASC
/home/lifesmart/domains/lifesmart.vn/public_html/catalog/model/setting/event.php:4
14 (0.517)
SELECT *
FROM ttq_seo_url
WHERE keyword = 'lifesmart-door-open-close-sensor' AND store_id = '0'
/home/lifesmart/domains/lifesmart.vn/storage/modification/catalog/controller/startup/seo_url.php:61
15 (0.255)
SELECT count(*) AS total
FROM `ttq_journal3_skin`
/home/lifesmart/domains/lifesmart.vn/public_html/catalog/model/journal3/settings.php:112
16 (0.667)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
17 (1.343)
SELECT *
FROM ttq_product_to_layout
WHERE product_id = '46' AND store_id = '0'
/home/lifesmart/domains/lifesmart.vn/storage/modification/catalog/model/catalog/product.php:411
18 (0.457)
SELECT *
FROM ttq_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/lifesmart/domains/lifesmart.vn/public_html/catalog/model/design/layout.php:4
19 (0.320)
SELECT layout_id, layout_data
FROM `ttq_journal3_layout`
WHERE `layout_id` = '2' OR `layout_id` = -1
ORDER BY `layout_id` DESC
/home/lifesmart/domains/lifesmart.vn/public_html/catalog/model/journal3/layout.php:122
20 (0.304)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
21 (0.344)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
22 (0.233)
SELECT *
FROM ttq_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/css'
/home/lifesmart/domains/lifesmart.vn/public_html/catalog/model/design/theme.php:4
23 (0.338)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
24 (0.443)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
25 (0.712)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
26 (0.572)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
27 (0.413)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
28 (0.296)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
29 (0.366)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
30 (0.305)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
31 (0.317)
SELECT *
FROM ttq_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'product/product' OR route = 'en-gb')
/home/lifesmart/domains/lifesmart.vn/public_html/catalog/model/design/translation.php:6
32 (5.348)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM ttq_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 ttq_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 ttq_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM ttq_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM ttq_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM ttq_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM ttq_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 ttq_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM ttq_product p
LEFT JOIN ttq_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN ttq_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN ttq_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '46' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/lifesmart/domains/lifesmart.vn/storage/modification/catalog/model/catalog/product.php:8
33 (0.235)
SELECT *
FROM ttq_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'product/compare' OR route = 'en-gb')
/home/lifesmart/domains/lifesmart.vn/public_html/catalog/model/design/translation.php:6
34 (0.370)
SELECT *
FROM `ttq_journal3_module`
WHERE `module_id` = '273'
/home/lifesmart/domains/lifesmart.vn/public_html/catalog/model/journal3/module.php:8
35 (1.023)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM ttq_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 ttq_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 ttq_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM ttq_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM ttq_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM ttq_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM ttq_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 ttq_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM ttq_product p
LEFT JOIN ttq_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN ttq_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN ttq_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '46' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/lifesmart/domains/lifesmart.vn/storage/modification/catalog/model/catalog/product.php:8
36 (2.091)
SELECT ag.attribute_group_id, agd.name
FROM ttq_product_attribute pa
LEFT JOIN ttq_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN ttq_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN ttq_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '46' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/lifesmart/domains/lifesmart.vn/storage/modification/catalog/model/catalog/product.php:316
37 (1.630)
SELECT a.attribute_id, ad.name, pa.text
FROM ttq_product_attribute pa
LEFT JOIN ttq_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN ttq_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '46' AND a.attribute_group_id = '1' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY pa.product_attribute_id ,a.sort_order, ad.name
/home/lifesmart/domains/lifesmart.vn/storage/modification/catalog/model/catalog/product.php:321
38 (0.266)
SELECT *
FROM ttq_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/product_blocks_attributes'
/home/lifesmart/domains/lifesmart.vn/public_html/catalog/model/design/theme.php:4
39 (0.324)
SELECT *
FROM ttq_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'product/product' OR route = 'en-gb')
/home/lifesmart/domains/lifesmart.vn/public_html/catalog/model/design/translation.php:6
40 (0.333)
SELECT COUNT(review_id) as count, rating
FROM ttq_review
WHERE product_id = '46' AND parent_id = '0' GROUP BY rating
ORDER BY rating DESC
/home/lifesmart/domains/lifesmart.vn/storage/modification/catalog/controller/journal3/product_tabs.php:173
41 (0.291)
SELECT *
FROM ttq_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/product_blocks_reviews'
/home/lifesmart/domains/lifesmart.vn/public_html/catalog/model/design/theme.php:4
42 (0.366)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
43 (0.347)
SELECT *
FROM `ttq_journal3_module`
WHERE `module_id` = '274'
/home/lifesmart/domains/lifesmart.vn/public_html/catalog/model/journal3/module.php:8
44 (0.402)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
45 (0.328)
SELECT *
FROM `ttq_journal3_module`
WHERE `module_id` = '275'
/home/lifesmart/domains/lifesmart.vn/public_html/catalog/model/journal3/module.php:8
46 (0.351)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
47 (0.464)
SELECT *
FROM `ttq_journal3_module`
WHERE `module_id` = '276'
/home/lifesmart/domains/lifesmart.vn/public_html/catalog/model/journal3/module.php:8
48 (0.433)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
49 (2.391)
SELECT *
FROM ttq_product_custom_tab
WHERE product_id = '46'
ORDER BY id ASC
/home/lifesmart/domains/lifesmart.vn/storage/modification/catalog/model/catalog/product.php:388
50 (0.261)
SELECT *
FROM ttq_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/product_tabs'
/home/lifesmart/domains/lifesmart.vn/public_html/catalog/model/design/theme.php:4
51 (0.303)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
52 (0.255)
SELECT *
FROM ttq_product_custom_tab
WHERE product_id = '46'
ORDER BY id ASC
/home/lifesmart/domains/lifesmart.vn/storage/modification/catalog/model/catalog/product.php:388
53 (0.241)
SELECT *
FROM ttq_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/product_tabs'
/home/lifesmart/domains/lifesmart.vn/public_html/catalog/model/design/theme.php:4
54 (0.322)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
55 (0.658)
SELECT *
FROM ttq_manufacturer m
LEFT JOIN ttq_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '0' AND m2s.store_id = '0'
/home/lifesmart/domains/lifesmart.vn/public_html/catalog/model/catalog/manufacturer.php:4
56 (0.666)
SELECT *
FROM ttq_product_to_category
WHERE product_id = '46'
/home/lifesmart/domains/lifesmart.vn/storage/modification/catalog/model/catalog/product.php:428
57 (1.294)
SELECT DISTINCT *
FROM ttq_category c
LEFT JOIN ttq_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ttq_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '8' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/home/lifesmart/domains/lifesmart.vn/public_html/catalog/model/catalog/category.php:4
58 (0.264)
SELECT DISTINCT *
FROM ttq_category c
LEFT JOIN ttq_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ttq_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/home/lifesmart/domains/lifesmart.vn/public_html/catalog/model/catalog/category.php:4
59 (0.289)
SELECT DISTINCT *
FROM ttq_category c
LEFT JOIN ttq_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ttq_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '8' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/home/lifesmart/domains/lifesmart.vn/public_html/catalog/model/catalog/category.php:4
60 (0.269)
SELECT DISTINCT *
FROM ttq_category c
LEFT JOIN ttq_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ttq_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '8' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/home/lifesmart/domains/lifesmart.vn/public_html/catalog/model/catalog/category.php:4
61 (0.352)
SELECT *
FROM ttq_seo_url
WHERE `query` = 'category_id=8' AND store_id = '0' AND language_id = '1'
/home/lifesmart/domains/lifesmart.vn/storage/modification/catalog/controller/startup/seo_url.php:331
62 (0.286)
SELECT *
FROM ttq_seo_url
WHERE `query` = 'product_id=46' AND store_id = '0' AND language_id = '1'
/home/lifesmart/domains/lifesmart.vn/storage/modification/catalog/controller/startup/seo_url.php:243
63 (0.307)
SELECT *
FROM ttq_seo_url
WHERE `query` = 'product_id=46' AND store_id = '0' AND language_id = '1'
/home/lifesmart/domains/lifesmart.vn/storage/modification/catalog/controller/startup/seo_url.php:243
64 (0.314)
SELECT *
FROM ttq_seo_url
WHERE `query` = 'manufacturer_id=0' AND store_id = '0' AND language_id = '1'
/home/lifesmart/domains/lifesmart.vn/storage/modification/catalog/controller/startup/seo_url.php:243
65 (0.723)
SELECT *
FROM ttq_product_image
WHERE product_id = '46'
ORDER BY sort_order ASC
/home/lifesmart/domains/lifesmart.vn/storage/modification/catalog/model/catalog/product.php:393
66 (0.478)
SELECT *
FROM ttq_product_custom_tab
WHERE product_id = '46'
ORDER BY id ASC
/home/lifesmart/domains/lifesmart.vn/storage/modification/catalog/model/catalog/product.php:388
67 (0.311)
SELECT *
FROM ttq_product_discount
WHERE product_id = '46' 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/lifesmart/domains/lifesmart.vn/storage/modification/catalog/model/catalog/product.php:381
68 (1.329)
SELECT *
FROM ttq_product_option po
LEFT JOIN `ttq_option` o ON (po.option_id = o.option_id)
LEFT JOIN ttq_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '46' AND od.language_id = '1'
ORDER BY o.sort_order
/home/lifesmart/domains/lifesmart.vn/storage/modification/catalog/model/catalog/product.php:344
69 (0.390)
SELECT COUNT(review_id) as count, rating
FROM ttq_review
WHERE product_id = '46' AND parent_id = '0' GROUP BY rating
ORDER BY rating DESC
/home/lifesmart/domains/lifesmart.vn/storage/modification/catalog/controller/product/product.php:641
70 (0.340)
SELECT *
FROM ttq_seo_url
WHERE `query` = 'product_id=46' AND store_id = '0' AND language_id = '1'
/home/lifesmart/domains/lifesmart.vn/storage/modification/catalog/controller/startup/seo_url.php:243
71 (0.840)
SELECT ag.attribute_group_id, agd.name
FROM ttq_product_attribute pa
LEFT JOIN ttq_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN ttq_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN ttq_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '46' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/lifesmart/domains/lifesmart.vn/storage/modification/catalog/model/catalog/product.php:316
72 (1.264)
SELECT a.attribute_id, ad.name, pa.text
FROM ttq_product_attribute pa
LEFT JOIN ttq_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN ttq_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '46' AND a.attribute_group_id = '1' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY pa.product_attribute_id ,a.sort_order, ad.name
/home/lifesmart/domains/lifesmart.vn/storage/modification/catalog/model/catalog/product.php:321
73 (1.305)
SELECT rd.*
FROM ttq_product_recurring pr JOIN ttq_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN ttq_recurring r ON r.recurring_id = rd.recurring_id
WHERE pr.product_id = 46 AND status = '1' AND pr.customer_group_id = '1'
ORDER BY sort_order ASC
/home/lifesmart/domains/lifesmart.vn/storage/modification/catalog/model/catalog/product.php:542
74 (0.371)
UPDATE ttq_product SET viewed = (viewed + 1)
WHERE product_id = '46'
/home/lifesmart/domains/lifesmart.vn/storage/modification/catalog/model/catalog/product.php:4
75 (1.395)
SELECT SUM(op.quantity) AS quantity
FROM `ttq_order_product` op
LEFT JOIN `ttq_order` o ON op.order_id = o.order_id
WHERE o.order_status_id <> 0 AND op.product_id = '46'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/journal3/opencart/model.php:48
76 (0.453)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
77 (0.427)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
78 (0.524)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
79 (0.323)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
80 (0.370)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
81 (0.366)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
82 (0.366)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
83 (0.432)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
84 (0.321)
SELECT *
FROM ttq_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/main_menu'
/home/lifesmart/domains/lifesmart.vn/public_html/catalog/model/design/theme.php:4
85 (0.356)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
86 (0.240)
SELECT *
FROM `ttq_journal3_module`
WHERE `module_id` = '0'
/home/lifesmart/domains/lifesmart.vn/public_html/catalog/model/journal3/module.php:8
87 (0.309)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
88 (0.245)
SELECT *
FROM ttq_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/top_menu'
/home/lifesmart/domains/lifesmart.vn/public_html/catalog/model/design/theme.php:4
89 (0.395)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
90 (0.311)
SELECT *
FROM `ttq_journal3_module`
WHERE `module_id` = '0'
/home/lifesmart/domains/lifesmart.vn/public_html/catalog/model/journal3/module.php:8
91 (0.384)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
92 (0.315)
SELECT *
FROM ttq_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/top_menu'
/home/lifesmart/domains/lifesmart.vn/public_html/catalog/model/design/theme.php:4
93 (0.317)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
94 (0.264)
SELECT *
FROM ttq_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/top_menu'
/home/lifesmart/domains/lifesmart.vn/public_html/catalog/model/design/theme.php:4
95 (0.455)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
96 (0.271)
SELECT *
FROM ttq_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/info_blocks'
/home/lifesmart/domains/lifesmart.vn/public_html/catalog/model/design/theme.php:4
97 (0.330)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
98 (0.275)
SELECT *
FROM ttq_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/info_blocks'
/home/lifesmart/domains/lifesmart.vn/public_html/catalog/model/design/theme.php:4
99 (0.366)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
100 (0.269)
SELECT *
FROM ttq_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'
/home/lifesmart/domains/lifesmart.vn/public_html/catalog/model/design/theme.php:4
101 (0.353)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
102 (0.279)
SELECT *
FROM ttq_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/newsletter'
/home/lifesmart/domains/lifesmart.vn/public_html/catalog/model/design/theme.php:4
103 (0.310)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
104 (0.280)
SELECT *
FROM ttq_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'
/home/lifesmart/domains/lifesmart.vn/public_html/catalog/model/design/theme.php:4
105 (0.320)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
106 (0.288)
SELECT *
FROM ttq_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/layout'
/home/lifesmart/domains/lifesmart.vn/public_html/catalog/model/design/theme.php:4
107 (0.353)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
108 (0.341)
SELECT *
FROM ttq_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'common/footer' OR route = 'en-gb')
/home/lifesmart/domains/lifesmart.vn/public_html/catalog/model/design/translation.php:6
109 (0.327)
SELECT *
FROM ttq_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'common/footer'
/home/lifesmart/domains/lifesmart.vn/public_html/catalog/model/design/theme.php:4
110 (0.466)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
111 (0.382)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
112 (0.439)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
113 (0.419)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
114 (0.321)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
115 (0.493)
SELECT *
FROM ttq_setting
WHERE store_id = '0' AND `code` = 'd_social_login'
/home/lifesmart/domains/lifesmart.vn/public_html/catalog/model/setting/setting.php:6
116 (0.278)
SELECT *
FROM ttq_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'extension/module/d_social_login'
/home/lifesmart/domains/lifesmart.vn/public_html/catalog/model/design/theme.php:4
117 (0.348)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
118 (0.276)
SELECT *
FROM ttq_extension
WHERE `type` = 'analytics'
/home/lifesmart/domains/lifesmart.vn/public_html/catalog/model/setting/extension.php:4
119 (0.289)
SELECT *
FROM ttq_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'common/header' OR route = 'en-gb')
/home/lifesmart/domains/lifesmart.vn/public_html/catalog/model/design/translation.php:6
120 (0.438)
SELECT *
FROM ttq_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'common/language' OR route = 'en-gb')
/home/lifesmart/domains/lifesmart.vn/public_html/catalog/model/design/translation.php:6
121 (0.538)
SELECT *
FROM ttq_seo_url
WHERE `query` = 'product_id=46' AND store_id = '0' AND language_id = '1'
/home/lifesmart/domains/lifesmart.vn/storage/modification/catalog/controller/startup/seo_url.php:243
122 (0.271)
SELECT *
FROM ttq_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'common/language'
/home/lifesmart/domains/lifesmart.vn/public_html/catalog/model/design/theme.php:4
123 (0.392)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
124 (0.260)
SELECT *
FROM ttq_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'common/currency' OR route = 'en-gb')
/home/lifesmart/domains/lifesmart.vn/public_html/catalog/model/design/translation.php:6
125 (0.428)
SELECT *
FROM ttq_seo_url
WHERE `query` = 'product_id=46' AND store_id = '0' AND language_id = '1'
/home/lifesmart/domains/lifesmart.vn/storage/modification/catalog/controller/startup/seo_url.php:243
126 (0.302)
SELECT *
FROM ttq_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'common/currency'
/home/lifesmart/domains/lifesmart.vn/public_html/catalog/model/design/theme.php:4
127 (0.357)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
128 (0.292)
SELECT *
FROM ttq_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'common/search' OR route = 'en-gb')
/home/lifesmart/domains/lifesmart.vn/public_html/catalog/model/design/translation.php:6
129 (0.375)
SELECT *
FROM ttq_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'common/search'
/home/lifesmart/domains/lifesmart.vn/public_html/catalog/model/design/theme.php:4
130 (0.317)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
131 (0.302)
SELECT *
FROM ttq_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'common/cart' OR route = 'en-gb')
/home/lifesmart/domains/lifesmart.vn/public_html/catalog/model/design/translation.php:6
132 (0.257)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
133 (0.223)
SELECT *
FROM ttq_extension
WHERE `type` = 'total'
/home/lifesmart/domains/lifesmart.vn/public_html/catalog/model/setting/extension.php:4
134 (0.290)
SELECT *
FROM ttq_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/sub_total' OR route = 'en-gb')
/home/lifesmart/domains/lifesmart.vn/public_html/catalog/model/design/translation.php:6
135 (0.323)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
136 (0.316)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
137 (0.320)
SELECT *
FROM ttq_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/total' OR route = 'en-gb')
/home/lifesmart/domains/lifesmart.vn/public_html/catalog/model/design/translation.php:6
138 (0.265)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
139 (0.347)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
140 (0.253)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
141 (0.263)
SELECT *
FROM ttq_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'common/cart'
/home/lifesmart/domains/lifesmart.vn/public_html/catalog/model/design/theme.php:4
142 (0.361)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
143 (0.263)
SELECT *
FROM ttq_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'common/menu' OR route = 'en-gb')
/home/lifesmart/domains/lifesmart.vn/public_html/catalog/model/design/translation.php:6
144 (0.275)
SELECT *
FROM ttq_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'common/menu'
/home/lifesmart/domains/lifesmart.vn/public_html/catalog/model/design/theme.php:4
145 (0.345)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
146 (0.269)
SELECT *
FROM ttq_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'common/header'
/home/lifesmart/domains/lifesmart.vn/public_html/catalog/model/design/theme.php:4
147 (1.381)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM ttq_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 ttq_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 ttq_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM ttq_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM ttq_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM ttq_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM ttq_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 ttq_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM ttq_product p
LEFT JOIN ttq_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN ttq_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN ttq_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '46' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/lifesmart/domains/lifesmart.vn/storage/modification/catalog/model/catalog/product.php:8
148 (0.436)
SELECT *
FROM ttq_seo_url
WHERE `query` = 'product_id=46' AND store_id = '0' AND language_id = '1'
/home/lifesmart/domains/lifesmart.vn/storage/modification/catalog/controller/startup/seo_url.php:243
149 (0.447)
SELECT r.review_id, r.author, r.rating, r.text, p.product_id, pd.name, p.price, p.image, r.date_added
FROM ttq_review r
LEFT JOIN ttq_product p ON (r.product_id = p.product_id)
LEFT JOIN ttq_product_description pd ON (p.product_id = pd.product_id)
WHERE p.product_id = '46' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '1'
ORDER BY r.date_added DESC LIMIT 1
/home/lifesmart/domains/lifesmart.vn/storage/modification/catalog/controller/journal3/seo.php:323
150 (0.341)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
151 (0.320)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
152 (0.735)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
153 (0.382)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
154 (0.463)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
155 (0.703)
SELECT *
FROM ttq_setting
WHERE store_id = '0' AND `code` = 'advertise_google'
/home/lifesmart/domains/lifesmart.vn/public_html/catalog/model/setting/setting.php:6
156 (0.404)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
157 (0.290)
SELECT *
FROM ttq_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'product/product'
/home/lifesmart/domains/lifesmart.vn/public_html/catalog/model/design/theme.php:4
158 (0.444)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
159 (0.418)
SELECT *
FROM ttq_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'common/header' OR route = 'en-gb')
/home/lifesmart/domains/lifesmart.vn/public_html/catalog/model/design/translation.php:6
160 (0.331)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36
161 (0.410)
SELECT *
FROM ttq_setting
WHERE store_id = '0' AND `code` = 'advertise_google'
/home/lifesmart/domains/lifesmart.vn/public_html/catalog/model/setting/setting.php:6
162 (0.362)
SELECT *
FROM ttq_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a2fe5a20532978f33f5ad9b9a4'
/home/lifesmart/domains/lifesmart.vn/public_html/system/library/cart/cart.php:36