| 0.0024 |
SELECT `id` FROM `cle_products_categories` WHERE `lft` >= '2' AND `rgt` <= '131' ORDER BY `order`
|
| 0.0301 |
SELECT `cle_relationships`.`category_id`, count( DISTINCT object_id ) as count FROM `cle_relationships` JOIN `cle_products` ON `cle_relationships`.`object_id` = `cle_products`.`id` WHERE `type` = 'product' AND `cle_relationships`.`object_type` = 'products' AND `cle_relationships`.`value` = 'products_categories' AND `cle_relationships`.`category_id` IN('2', '99', '116', '115', '114', '113', '108', '107', '105', '106', '129', '102', '111', '133', '98', '91', '112', '110', '109', '100', '104', '103', '135', '137', '130', '128', '127', '126', '125', '124', '123', '122', '134', '136', '121', '120', '131', '132', '119', '118', '117', '101', '78', '8', '9', '10', '11', '12', '13', '14', '15', '42', '43', '89', '82', '47', '48', '49', '58', '59', '61', '62', '90', '81', '80') GROUP BY `cle_relationships`.`category_id`
|
| 0.0005 |
SELECT `id` FROM `cle_products_categories` WHERE `lft` >= '2' AND `rgt` <= '131' ORDER BY `order`
|
| 0.0325 |
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('2', '99', '116', '115', '114', '113', '108', '107', '105', '106', '129', '102', '111', '133', '98', '91', '112', '110', '109', '100', '104', '103', '135', '137', '130', '128', '127', '126', '125', '124', '123', '122', '134', '136', '121', '120', '131', '132', '119', '118', '117', '101', '78', '8', '9', '10', '11', '12', '13', '14', '15', '42', '43', '89', '82', '47', '48', '49', '58', '59', '61', '62', '90', '81', '80') GROUP BY `cle_products`.`id` ORDER BY `cle_products`.`order`, `cle_products`.`created` desc LIMIT 544, 16
|
| 0.0004 |
SELECT * FROM `cle_relationships` WHERE `category_id` = 'main-nav' AND `object_type` = 'menu'
|
| 0.0005 |
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` >= '131' ORDER BY `level`
|