| 0.0052 |
SELECT * FROM `cle_products` WHERE `public` = 1 AND `trash` = 0 AND `slug` = 'khuon-silicon-hoa-nhieu-m-u-moi-hot' AND `type` = 'product'
|
| 0.0006 |
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` = '1210' 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_relationships` WHERE `category_id` = 'main-nav' AND `object_type` = 'menu'
|
| 0.0030 |
SELECT * FROM `cle_gallerys` WHERE `object_id` = '1210' AND `object_type` = 'products' ORDER BY `order`, `created` desc
|
| 0.0013 |
SHOW TABLES FROM `banhyeuc6921_db`
|
| 0.0018 |
SELECT * FROM `cle_product_metadata` WHERE `object_id` = 1210 AND `meta_key` = 'attributes'
|
| 0.0002 |
SELECT * FROM `cle_wcmc_options` WHERE `id` = 9
|
| 0.0006 |
SELECT * FROM `cle_relationships` WHERE `object_id` = 1210 AND `category_id` = 'attribute_op_9' AND `object_type` = 'attributes' ORDER BY `order`, `created` desc
|
| 0.0006 |
SELECT * FROM `cle_relationships` WHERE `object_id` = 1210 AND `category_id` = 'attribute_op_9' AND `object_type` = 'attributes' ORDER BY `order`, `created` desc
|
| 0.0002 |
SELECT `id`, `title`, `value`, `image`, `type`, `order` FROM `cle_wcmc_options_item` WHERE `id` IN('344', '345', '346', '347', '348', '349') ORDER BY `order`
|
| 0.0002 |
SELECT * FROM `cle_wcmc_options` WHERE `id` = 4
|
| 0.0007 |
SELECT * FROM `cle_relationships` WHERE `object_id` = 1210 AND `category_id` = 'attribute_op_4' AND `object_type` = 'attributes' ORDER BY `order`, `created` desc
|
| 0.0006 |
SELECT * FROM `cle_relationships` WHERE `object_id` = 1210 AND `category_id` = 'attribute_op_4' AND `object_type` = 'attributes' ORDER BY `order`, `created` desc
|
| 0.0002 |
SELECT `id`, `title`, `value`, `image`, `type`, `order` FROM `cle_wcmc_options_item` WHERE `id` IN('350', '351', '352') ORDER BY `order`
|
| 0.0032 |
SELECT `id`, `code`, `title`, `image`, `price`, `price_sale`, `parent_id`, `type` FROM `cle_products` WHERE `public` = 1 AND `trash` = 0 AND `status` = 'public' AND `type` = 'variations' AND `parent_id` = 1210 ORDER BY `order`, `created` desc
|
| 0.0018 |
SELECT * FROM `cle_product_metadata` WHERE `object_id` = '1225' ORDER BY `order`, `created` desc
|
| 0.0018 |
SELECT * FROM `cle_product_metadata` WHERE `object_id` = '1224' ORDER BY `order`, `created` desc
|
| 0.0017 |
SELECT * FROM `cle_product_metadata` WHERE `object_id` = '1223' ORDER BY `order`, `created` desc
|
| 0.0018 |
SELECT * FROM `cle_product_metadata` WHERE `object_id` = '1222' ORDER BY `order`, `created` desc
|
| 0.0018 |
SELECT * FROM `cle_product_metadata` WHERE `object_id` = '1221' ORDER BY `order`, `created` desc
|
| 0.0017 |
SELECT * FROM `cle_product_metadata` WHERE `object_id` = '1220' ORDER BY `order`, `created` desc
|
| 0.0017 |
SELECT * FROM `cle_product_metadata` WHERE `object_id` = '1219' ORDER BY `order`, `created` desc
|
| 0.0017 |
SELECT * FROM `cle_product_metadata` WHERE `object_id` = '1218' ORDER BY `order`, `created` desc
|
| 0.0017 |
SELECT * FROM `cle_product_metadata` WHERE `object_id` = '1217' ORDER BY `order`, `created` desc
|
| 0.0017 |
SELECT * FROM `cle_product_metadata` WHERE `object_id` = '1216' ORDER BY `order`, `created` desc
|
| 0.0017 |
SELECT * FROM `cle_product_metadata` WHERE `object_id` = '1215' ORDER BY `order`, `created` desc
|
| 0.0017 |
SELECT * FROM `cle_product_metadata` WHERE `object_id` = '1214' ORDER BY `order`, `created` desc
|
| 0.0002 |
SELECT * FROM `cle_products` WHERE `public` = 1 AND `trash` = 0 AND `type` = 'product' AND `cle_products`.`id` IN('27', '1210')
|
| 0.0007 |
SELECT `object`.* FROM `cle_products` as object INNER JOIN `cle_relationships` as relationship INNER JOIN `cle_relationships` as relationship2 WHERE object.id <> 1210 AND object.`id` = relationship.`object_id` AND relationship2.`category_id` = relationship.`category_id` AND relationship2.`object_id` = 1210 AND relationship2.`object_type` = 'products' GROUP BY relationship2.`category_id`, relationship.object_id LIMIT 12
|