| 0.0019 |
SELECT *
FROM (`cle_products`)
WHERE `public` = 1
AND `trash` = 0
AND `slug` = 'tranh-ca-cuu-ngu-quan-hoi'
|
| 0.0008 |
SELECT *
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.0004 |
SELECT *
FROM (`cle_system`)
WHERE `option_name` = 'seo_google_masterkey'
|
| 0.0001 |
SELECT *
FROM (`cle_relationships`)
WHERE `category_id` = 'main-nav'
AND `object_type` = 'menu'
|
| 0.0001 |
SELECT *
FROM (`cle_products_categories`)
WHERE `public` = 1
AND `lft` <= '7'
AND `rgt` >= '8'
ORDER BY `level`
|
| 0.0001 |
SELECT *
FROM (`cle_products_categories`)
WHERE `public` = 1
AND `lft` <= '7'
AND `rgt` >= '8'
ORDER BY `level`
|
| 0.0003 |
SELECT *
FROM (`cle_system`)
WHERE `option_name` = 'product_gallery'
|
| 0.0004 |
SHOW TABLES FROM `mythuatl_mythuatluuchuc`
|
| 0.0017 |
SELECT *
FROM (`cle_product_metadata`)
WHERE `object_id` = '6'
AND `meta_key` = 'attributes'
|
| 0.0012 |
SELECT *
FROM (`cle_rating_star`)
WHERE `object_id` = '6'
AND `object_type` = 'product'
AND `status` = 'public'
ORDER BY `order`, `created` desc
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM (`cle_rating_star`)
WHERE `star` = 5
AND `object_type` = 'product'
AND `object_id` = '6'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM (`cle_rating_star`)
WHERE `star` = 4
AND `object_type` = 'product'
AND `object_id` = '6'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM (`cle_rating_star`)
WHERE `star` = 3
AND `object_type` = 'product'
AND `object_id` = '6'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM (`cle_rating_star`)
WHERE `star` = 2
AND `object_type` = 'product'
AND `object_id` = '6'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM (`cle_rating_star`)
WHERE `star` = 1
AND `object_type` = 'product'
AND `object_id` = '6'
|
| 0.0005 |
SELECT *
FROM (`cle_system`)
WHERE `option_name` = 'product_related'
|
| 0.0002 |
SELECT `category_id`
FROM (`cle_relationships`)
WHERE `object_id` = '6'
AND `object_type` = 'products'
GROUP BY `category_id`
ORDER BY `order`, `created` desc
|
| 0.0002 |
SELECT `object_id`
FROM (`cle_relationships`)
WHERE `object_type` = 'products'
AND `value` = 'products_categories'
AND `category_id` IN ('5', '1')
GROUP BY `object_id`
ORDER BY `created`
|
| 0.0003 |
SELECT *
FROM (`cle_products`)
WHERE `id` <> '6'
AND `public` = 1
AND `trash` = 0
AND `cle_products`.`id` IN ('2', '1', '3', '4', '5', '6', '11', '12', '13', '14', '15', '7', '8', '28', '29', '31', '32', '36', '37')
LIMIT 12
|
| 0.0001 |
SELECT *
FROM (`cle_product_metadata`)
WHERE `object_id` = '1'
AND `meta_key` = 'rating_star'
|
| 0.0001 |
SELECT *
FROM (`cle_product_metadata`)
WHERE `object_id` = '2'
AND `meta_key` = 'rating_star'
|
| 0.0001 |
SELECT *
FROM (`cle_product_metadata`)
WHERE `object_id` = '3'
AND `meta_key` = 'rating_star'
|
| 0.0001 |
SELECT *
FROM (`cle_product_metadata`)
WHERE `object_id` = '4'
AND `meta_key` = 'rating_star'
|
| 0.0001 |
SELECT *
FROM (`cle_product_metadata`)
WHERE `object_id` = '5'
AND `meta_key` = 'rating_star'
|
| 0.0001 |
SELECT *
FROM (`cle_product_metadata`)
WHERE `object_id` = '14'
AND `meta_key` = 'rating_star'
|
| 0.0001 |
SELECT *
FROM (`cle_product_metadata`)
WHERE `object_id` = '15'
AND `meta_key` = 'rating_star'
|
| 0.0001 |
SELECT *
FROM (`cle_products`)
WHERE `public` = 1
AND `trash` = 0
AND `cle_products`.`id` IN ('6')
|
