| 0.0361 |
SELECT *
FROM `cle_products`
WHERE `slug` = 'cha-bo-ot-xiem-xanh-da-nang'
AND `public` = 1
AND `trash` = 0
AND `type` = 'product'
|
| 0.0018 |
SELECT `cle_products_categories`.*
FROM `cle_relationships`
JOIN `cle_products_categories` ON `cle_relationships`.`category_id` = `cle_products_categories`.`id`
WHERE `cle_relationships`.`object_id` = '6'
AND `cle_relationships`.`object_type` = 'products'
AND `cle_relationships`.`value` = 'products_categories'
ORDER BY `cle_relationships`.`order`, `cle_relationships`.`created`
|
| 0.0012 |
SELECT *
FROM `cle_rating_star`
WHERE `object_type` = 'product'
AND `object_id` = '6'
AND `star` = 5
AND `object_type` <> 'comment'
ORDER BY `order`, `created` desc
LIMIT 5
|
| 0.0001 |
SELECT *
FROM `cle_group`
WHERE `options` = 'main-nav'
AND `object_type` = 'menu'
|
| 0.0008 |
SHOW TABLES FROM `dacsand3_skddb`
|
| 0.0048 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = 6
AND `meta_key` = 'attributes'
|
| 0.0022 |
SELECT `id`, `code`, `title`, `image`, `price`, `price_sale`, `parent_id`, `type`, `weight`
FROM `cle_products`
WHERE `public` = 1
AND `trash` = 0
AND `status` = 'public'
AND `type` = 'variations'
AND `parent_id` = 6
ORDER BY `order`, `created` desc
|
| 0.0003 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '6'
AND `meta_key` = 'default'
|
| 0.0006 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '6'
AND `meta_key` = 'product_related'
|
| 0.0038 |
SELECT *
FROM `cle_products`
WHERE `public` = 1
AND `trash` = 0
AND `type` = 'product'
AND `id` IN(1, 3, 4, 6)
ORDER BY rand()
LIMIT 50
|
| 0.0006 |
SELECT COUNT(*) AS `numrows`
FROM `cle_rating_star`
WHERE `star` = 5
AND `object_type` = 'product'
AND `object_id` = '6'
AND `object_type` <> 'comment'
|
| 0.0005 |
SELECT COUNT(*) AS `numrows`
FROM `cle_rating_star`
WHERE `star` = 4
AND `object_type` = 'product'
AND `object_id` = '6'
AND `object_type` <> 'comment'
|
| 0.0005 |
SELECT COUNT(*) AS `numrows`
FROM `cle_rating_star`
WHERE `star` = 3
AND `object_type` = 'product'
AND `object_id` = '6'
AND `object_type` <> 'comment'
|
| 0.0005 |
SELECT COUNT(*) AS `numrows`
FROM `cle_rating_star`
WHERE `star` = 2
AND `object_type` = 'product'
AND `object_id` = '6'
AND `object_type` <> 'comment'
|
| 0.0054 |
SELECT COUNT(*) AS `numrows`
FROM `cle_rating_star`
WHERE `star` = 1
AND `object_type` = 'product'
AND `object_id` = '6'
AND `object_type` <> 'comment'
|
| 0.0004 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '6'
AND `meta_key` = 'product_selling'
|
| 0.0022 |
SELECT *
FROM `cle_products`
WHERE `public` = 1
AND `trash` = 0
AND `type` = 'product'
AND `id` IN(2, 3, 4, 5, 6, 10)
ORDER BY rand()
LIMIT 50
|
| 0.0006 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '6'
AND `meta_key` = 'post_related'
|
| 0.0007 |
SELECT *
FROM `cle_post`
WHERE `public` = 1
AND `trash` = 0
AND `id` IN(16)
LIMIT 10
|
| 0.0010 |
SELECT *
FROM `cle_products`
WHERE `public` = 1
AND `trash` = 0
AND `type` = 'product'
AND `id` IN('6')
LIMIT 12
|
| 0.0003 |
SELECT *
FROM `cle_widget`
WHERE `sidebar_id` = 'footer-top'
AND `template` = 'theme-store'
ORDER BY `order`
|
| 0.3121 |
SELECT COUNT(*) AS `numrows`
FROM `cle_statistics`
WHERE `visited_timestamp` >= 1752080400
AND `visited_timestamp` <= 1752166799
|
| 5.9836 |
SELECT *
FROM `cle_statistics`
ORDER BY `order`, `created` desc
|
| 0.2105 |
SELECT COUNT(*) AS `numrows`
FROM `cle_statistics`
|
| 0.0009 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '6'
AND `meta_key` = 'views'
ORDER BY `order`, `created` desc
|
| 0.0022 |
UPDATE `cle_product_metadata` SET `meta_value` = 1779, `updated` = '2025-07-10 23:01:15'
WHERE `object_id` = '6'
AND `meta_key` = 'views'
|
ĐÁNH GIÁ SẢN PHẨM