0.0008 |
SELECT * FROM `cle_products` WHERE `public` = 1 AND `trash` = 0 AND `slug` = 'cua-luoi-chong-muoi-va-con-trung-co-dinh-he-day-alo-house-01-msp-swd-d' AND `type` = 'product'
|
0.0007 |
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` = '79' AND `cle_relationships`.`object_type` = 'products' AND `cle_relationships`.`value` = 'products_categories' ORDER BY `cle_relationships`.`order`, `cle_relationships`.`created`
|
0.0002 |
SELECT `cle_products_categories`.`id`, `cle_products_categories`.`name`, `cle_products_categories`.`slug` FROM `cle_products_categories` WHERE `public` = 1 AND `lft` <= '2' AND `rgt` >= '67' ORDER BY `level`
|
0.0018 |
SELECT * FROM `cle_relationships` WHERE `category_id` = 'main-nav' AND `object_type` = 'menu'
|
0.0002 |
SELECT * FROM `cle_relationships` WHERE `category_id` = 'main-vertical' AND `object_type` = 'menu'
|
0.0001 |
SELECT * FROM `cle_relationships` WHERE `category_id` = 'menu-mobile' AND `object_type` = 'menu'
|
0.0000 |
SELECT * FROM `cle_group` WHERE `id` = '7'
|
0.0000 |
SELECT * FROM `cle_menu` WHERE `menu_id` = '7' AND `parent_id` = 0 ORDER BY `order`, `created` desc
|
0.0000 |
SELECT * FROM `cle_menu` WHERE `parent_id` = '56' AND `menu_id` = '7' ORDER BY `order`, `created` desc
|
0.0000 |
SELECT * FROM `cle_menu` WHERE `parent_id` = '57' AND `menu_id` = '7' ORDER BY `order`, `created` desc
|
0.0000 |
SELECT * FROM `cle_menu` WHERE `parent_id` = '58' AND `menu_id` = '7' ORDER BY `order`, `created` desc
|
0.0000 |
SELECT * FROM `cle_menu` WHERE `parent_id` = '59' AND `menu_id` = '7' ORDER BY `order`, `created` desc
|
0.0000 |
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` <= '2' AND `rgt` >= '67' ORDER BY `level`
|
0.0002 |
SHOW TABLES FROM `oilnaryihosting_alohousevn`
|
0.0002 |
SELECT * FROM `cle_product_metadata` WHERE `object_id` = '79' AND `meta_key` = 'rating_star'
|
0.0002 |
SELECT * FROM `cle_product_metadata` WHERE `object_id` = '79' AND `meta_key` = 'khuyenmail_content'
|
0.0002 |
SELECT * FROM `cle_rating_star` WHERE `object_id` = '79' 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` = '79' AND `meta_key` = 'rating_star'
|
0.0004 |
SELECT `id` FROM `cle_products_categories` WHERE `lft` >= '2' AND `rgt` <= '67' ORDER BY `order`
|
0.0032 |
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('1', '28', '29', '30', '31', '32', '33', '34', '35', '36', '37', '38', '39', '40', '41', '27', '26', '25', '14', '15', '16', '20', '21', '42', '24', '23', '22', '6', '9', '10', '11', '12', '13') GROUP BY `cle_products`.`id` LIMIT 12
|
0.0002 |
SELECT * FROM `cle_product_metadata` WHERE `object_id` = '9' AND `meta_key` = 'view'
|
0.0002 |
SELECT * FROM `cle_product_metadata` WHERE `object_id` = '9' AND `meta_key` = 'rating_star'
|
0.0002 |
SELECT * FROM `cle_product_metadata` WHERE `object_id` = '10' AND `meta_key` = 'view'
|
0.0002 |
SELECT * FROM `cle_product_metadata` WHERE `object_id` = '10' AND `meta_key` = 'rating_star'
|
0.0002 |
SELECT * FROM `cle_product_metadata` WHERE `object_id` = '11' AND `meta_key` = 'view'
|
0.0004 |
SELECT * FROM `cle_product_metadata` WHERE `object_id` = '11' AND `meta_key` = 'rating_star'
|
0.0002 |
SELECT * FROM `cle_product_metadata` WHERE `object_id` = '12' AND `meta_key` = 'view'
|
0.0002 |
SELECT * FROM `cle_product_metadata` WHERE `object_id` = '12' AND `meta_key` = 'rating_star'
|
0.0002 |
SELECT * FROM `cle_product_metadata` WHERE `object_id` = '13' AND `meta_key` = 'view'
|
0.0001 |
SELECT * FROM `cle_product_metadata` WHERE `object_id` = '13' AND `meta_key` = 'rating_star'
|
0.0004 |
SELECT * FROM `cle_product_metadata` WHERE `object_id` = '14' AND `meta_key` = 'view'
|
0.0002 |
SELECT * FROM `cle_product_metadata` WHERE `object_id` = '14' AND `meta_key` = 'rating_star'
|
0.0002 |
SELECT * FROM `cle_product_metadata` WHERE `object_id` = '15' AND `meta_key` = 'view'
|
0.0002 |
SELECT * FROM `cle_product_metadata` WHERE `object_id` = '15' AND `meta_key` = 'rating_star'
|
0.0003 |
SELECT * FROM `cle_product_metadata` WHERE `object_id` = '16' AND `meta_key` = 'view'
|
0.0002 |
SELECT * FROM `cle_product_metadata` WHERE `object_id` = '16' AND `meta_key` = 'rating_star'
|
0.0002 |
SELECT * FROM `cle_product_metadata` WHERE `object_id` = '17' AND `meta_key` = 'view'
|
0.0003 |
SELECT * FROM `cle_product_metadata` WHERE `object_id` = '17' AND `meta_key` = 'rating_star'
|
0.0003 |
SELECT * FROM `cle_product_metadata` WHERE `object_id` = '18' AND `meta_key` = 'view'
|
0.0002 |
SELECT * FROM `cle_product_metadata` WHERE `object_id` = '18' AND `meta_key` = 'rating_star'
|
0.0002 |
SELECT * FROM `cle_product_metadata` WHERE `object_id` = '19' AND `meta_key` = 'view'
|
0.0003 |
SELECT * FROM `cle_product_metadata` WHERE `object_id` = '19' AND `meta_key` = 'rating_star'
|
0.0002 |
SELECT * FROM `cle_product_metadata` WHERE `object_id` = '20' AND `meta_key` = 'view'
|
0.0001 |
SELECT * FROM `cle_product_metadata` WHERE `object_id` = '20' 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('79')
|
0.0005 |
SELECT * FROM `cle_product_metadata` WHERE `object_id` = '79' AND `meta_key` = 'view'
|
0.0000 |
SELECT * FROM `cle_product_metadata` WHERE `object_id` = '79' 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` = '79' AND `meta_key` = 'post'
|
0.0006 |
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` = '79' AND `meta_key` = 'view' ORDER BY `order`, `created` desc
|
0.0008 |
UPDATE `cle_product_metadata` SET `meta_value` = 593, `updated` = '2023-12-07 21:39:15' WHERE `object_id` = '79' AND `meta_key` = 'view'
|