| 0.0011 |
SELECT *
FROM `cle_products`
WHERE `public` = 1
AND `trash` = 0
AND `slug` = 'cua-lua-4'
AND `type` = 'product'
|
| 0.0005 |
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` = '28'
AND `cle_relationships`.`object_type` = 'products'
AND `cle_relationships`.`value` = 'products_categories'
ORDER BY `cle_relationships`.`order`, `cle_relationships`.`created`
|
| 0.0003 |
SELECT `cle_products_categories`.`id`, `cle_products_categories`.`name`, `cle_products_categories`.`slug`
FROM `cle_products_categories`
WHERE `public` = 1
AND `lft` <= '39'
AND `rgt` >= '52'
ORDER BY `level`
|
| 0.0003 |
SELECT *
FROM `cle_relationships`
WHERE `category_id` = 'main-nav'
AND `object_type` = 'menu'
|
| 0.0002 |
SELECT *
FROM `cle_relationships`
WHERE `category_id` = 'menu-mobile'
AND `object_type` = 'menu'
|
| 0.0001 |
SELECT *
FROM `cle_group`
WHERE `id` = '7'
|
| 0.0003 |
SELECT *
FROM `cle_menu`
WHERE `menu_id` = '7'
AND `parent_id` = 0
ORDER BY `order`, `created` desc
|
| 0.0002 |
SELECT *
FROM `cle_menu`
WHERE `parent_id` = '56'
AND `menu_id` = '7'
ORDER BY `order`, `created` desc
|
| 0.0002 |
SELECT *
FROM `cle_menu`
WHERE `parent_id` = '57'
AND `menu_id` = '7'
ORDER BY `order`, `created` desc
|
| 0.0002 |
SELECT *
FROM `cle_menu`
WHERE `parent_id` = '58'
AND `menu_id` = '7'
ORDER BY `order`, `created` desc
|
| 0.0002 |
SELECT *
FROM `cle_menu`
WHERE `parent_id` = '59'
AND `menu_id` = '7'
ORDER BY `order`, `created` desc
|
| 0.0002 |
SELECT *
FROM `cle_menu`
WHERE `parent_id` = '60'
AND `menu_id` = '7'
ORDER BY `order`, `created` desc
|
| 0.0000 |
SELECT `cle_products_categories`.`id`, `cle_products_categories`.`name`, `cle_products_categories`.`slug`
FROM `cle_products_categories`
WHERE `public` = 1
AND `lft` <= '39'
AND `rgt` >= '52'
ORDER BY `level`
|
| 0.0002 |
SHOW TABLES FROM `oilnaryihosting_alohousevn`
|
| 0.0002 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '28'
AND `meta_key` = 'rating_star'
|
| 0.0002 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '28'
AND `meta_key` = 'khuyenmail_content'
|
| 0.0002 |
SELECT *
FROM `cle_rating_star`
WHERE `object_id` = '28'
AND `object_type` = 'product'
AND `status` = 'public'
AND `object_type` <> 'comment'
ORDER BY `order`, `created` desc
|
| 0.0000 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '28'
AND `meta_key` = 'rating_star'
|
| 0.0002 |
SELECT `id`
FROM `cle_products_categories`
WHERE `lft` >= '39'
AND `rgt` <= '52'
ORDER BY `order`
|
| 0.0014 |
SELECT `cle_products`.*
FROM `cle_products`
JOIN `cle_relationships` ON `cle_relationships`.`object_id` = `cle_products`.`id`
WHERE `public` = 1
AND `trash` = 0
AND `type` = 'product'
AND `cle_relationships`.`object_type` = 'products'
AND `cle_relationships`.`value` = 'products_categories'
AND `cle_relationships`.`category_id` IN('31', '32', '33', '34', '35', '36', '12')
GROUP BY `cle_products`.`id`
LIMIT 12
|
| 0.0002 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '11'
AND `meta_key` = 'view'
|
| 0.0002 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '11'
AND `meta_key` = 'rating_star'
|
| 0.0002 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '22'
AND `meta_key` = 'view'
|
| 0.0002 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '22'
AND `meta_key` = 'rating_star'
|
| 0.0002 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '23'
AND `meta_key` = 'view'
|
| 0.0002 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '23'
AND `meta_key` = 'rating_star'
|
| 0.0002 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '24'
AND `meta_key` = 'view'
|
| 0.0002 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '24'
AND `meta_key` = 'rating_star'
|
| 0.0002 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '25'
AND `meta_key` = 'view'
|
| 0.0001 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '25'
AND `meta_key` = 'rating_star'
|
| 0.0002 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '26'
AND `meta_key` = 'view'
|
| 0.0001 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '26'
AND `meta_key` = 'rating_star'
|
| 0.0002 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '27'
AND `meta_key` = 'view'
|
| 0.0001 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '27'
AND `meta_key` = 'rating_star'
|
| 0.0002 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '28'
AND `meta_key` = 'view'
|
| 0.0001 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '28'
AND `meta_key` = 'rating_star'
|
| 0.0002 |
SELECT *
FROM `cle_products`
WHERE `public` = 1
AND `trash` = 0
AND `type` = 'product'
AND `cle_products`.`id` IN('28')
|
| 0.0000 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '28'
AND `meta_key` = 'rating_star'
|
| 0.0005 |
SELECT `id`, `slug`, `title`, `image`, `price`, `price_sale`
FROM `cle_products`
WHERE `public` = 1
AND `trash` = 0
AND `status2` = 1
AND `type` = 'product'
ORDER BY `order`, `created` desc
LIMIT 5
|
| 0.0002 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '28'
AND `meta_key` = 'post'
|
| 0.0004 |
SELECT *
FROM `cle_post`
WHERE `public` = 1
AND `trash` = 0
AND `id` IN('23', '31')
|
| 0.0004 |
SELECT `id`, `slug`, `title`
FROM `cle_post`
WHERE `public` = 1
AND `trash` = 0
AND `post_type` = 'question'
ORDER BY `order`, `created` desc
LIMIT 5
|
| 0.0002 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '28'
AND `meta_key` = 'view'
ORDER BY `order`, `created` desc
|
| 0.0005 |
UPDATE `cle_product_metadata` SET `meta_value` = 532, `updated` = '2023-12-07 20:28:16'
WHERE `object_id` = '28'
AND `meta_key` = 'view'
|
Chống Cắt Nhôm Dày 02 Cánh 
