| 0.0003 |
SELECT *
FROM (`cle_products`)
WHERE `public` = 1
AND `trash` = 0
AND `slug` = 'tranh-son-dau-bien-hoa-1'
|
| 0.0003 |
SELECT *
FROM (`cle_relationships`)
JOIN `cle_products_categories` ON `cle_relationships`.`category_id` = `cle_products_categories`.`id`
WHERE `cle_relationships`.`object_id` = '13'
AND `cle_relationships`.`object_type` = 'products'
AND `cle_relationships`.`value` = 'products_categories'
ORDER BY `cle_relationships`.`order`, `cle_relationships`.`created`
|
| 0.0001 |
SELECT *
FROM (`cle_system`)
WHERE `option_name` = 'seo_google_masterkey'
|
| 0.0002 |
SELECT *
FROM (`cle_relationships`)
WHERE `category_id` = 'main-nav'
AND `object_type` = 'menu'
|
| 0.0002 |
SELECT *
FROM (`cle_products_categories`)
WHERE `public` = 1
AND `lft` <= '2'
AND `rgt` >= '13'
ORDER BY `level`
|
| 0.0003 |
SELECT *
FROM (`cle_products_categories`)
WHERE `public` = 1
AND `lft` <= '2'
AND `rgt` >= '13'
ORDER BY `level`
|
| 0.0001 |
SELECT *
FROM (`cle_system`)
WHERE `option_name` = 'product_gallery'
|
| 0.0003 |
SHOW TABLES FROM `mythuatl_mythuatluuchuc`
|
| 0.0001 |
SELECT *
FROM (`cle_product_metadata`)
WHERE `object_id` = '13'
AND `meta_key` = 'attributes'
|
| 0.0002 |
SELECT *
FROM (`cle_rating_star`)
WHERE `object_id` = '13'
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` = '13'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM (`cle_rating_star`)
WHERE `star` = 4
AND `object_type` = 'product'
AND `object_id` = '13'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM (`cle_rating_star`)
WHERE `star` = 3
AND `object_type` = 'product'
AND `object_id` = '13'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM (`cle_rating_star`)
WHERE `star` = 2
AND `object_type` = 'product'
AND `object_id` = '13'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM (`cle_rating_star`)
WHERE `star` = 1
AND `object_type` = 'product'
AND `object_id` = '13'
|
| 0.0002 |
SELECT *
FROM (`cle_system`)
WHERE `option_name` = 'product_related'
|
| 0.0002 |
SELECT `category_id`
FROM (`cle_relationships`)
WHERE `object_id` = '13'
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 ('1', '3', '6')
GROUP BY `object_id`
ORDER BY `created`
|
| 0.0003 |
SELECT *
FROM (`cle_products`)
WHERE `id` <> '13'
AND `public` = 1
AND `trash` = 0
AND `cle_products`.`id` IN ('2', '1', '3', '4', '5', '6', '9', '10', '11', '12', '13', '14', '15', '7', '8', '17', '18', '26', '28', '29', '30', '31', '32', '33', '34', '35', '36', '37', '38')
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` = '9'
AND `meta_key` = 'rating_star'
|
| 0.0001 |
SELECT *
FROM (`cle_product_metadata`)
WHERE `object_id` = '10'
AND `meta_key` = 'rating_star'
|
| 0.0001 |
SELECT *
FROM (`cle_products`)
WHERE `public` = 1
AND `trash` = 0
AND `cle_products`.`id` IN ('13')
|
