Facebook

×
  BENCHMARKS  
Loading Time: Base Classes  0.0089
Controller Execution Time ( Products / Index )  0.0609
Total Execution Time  0.0698
  MEMORY USAGE  
10.12M bytes
  CLASS/METHOD  
products/index
  URI STRING  
cua-luoi-mo-quay-he-chong-cat-nhom-he-mong-01-canh-swg-d1
  GET DATA  
No GET data exists
  POST DATA  
No POST data exists
  DATABASE:  oilnaryihosting_alohousevn (products:$db)   QUERIES: 24 (0.0061 )  (Hide)
0.0005   SELECT `id`
FROM `cle_products_categories`
WHERE `lft` >= '58'
AND `rgt` <= '59'
ORDER BY `order
0.0006   SELECT `cle_relationships`.`category_id`, count( DISTINCT object_id ) as count
FROM 
`cle_relationships`
JOIN `cle_productsON `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_idIN('39')
GROUP BY `cle_relationships`.`category_id
0.0000   SELECT `id`
FROM `cle_products_categories`
WHERE `lft` >= '58'
AND `rgt` <= '59'
ORDER BY `order
0.0000   SELECT `cle_relationships`.`category_id`, count( DISTINCT object_id ) as count
FROM 
`cle_relationships`
JOIN `cle_productsON `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_idIN('39')
GROUP BY `cle_relationships`.`category_id
0.0000   SELECT `id`
FROM `cle_products_categories`
WHERE `lft` >= '58'
AND `rgt` <= '59'
ORDER BY `order
0.0009   SELECT `cle_products`.*
FROM `cle_products`
JOIN `cle_relationshipsON `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_idIN('39')
GROUP BY `cle_products`.`id`
ORDER BY `cle_products`.`order`, `cle_products`.`createddesc
 LIMIT 16 
0.0000   SELECT `id`
FROM `cle_products_categories`
WHERE `lft` >= '58'
AND `rgt` <= '59'
ORDER BY `order
0.0001   SELECT `cle_products`.*
FROM `cle_products`
JOIN `cle_relationshipsON `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_idIN('39')
GROUP BY `cle_products`.`id`
ORDER BY `cle_products`.`order`, `cle_products`.`createddesc
 LIMIT 16 
0.0003   SELECT `cle_products_categories`.`id`, `cle_products_categories`.`name`, `cle_products_categories`.`slug`
FROM `cle_products_categories`
WHERE `public` = 1
AND `lft` <= '58'
AND `rgt` >= '59'
ORDER BY `level
0.0002   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.0004   SELECT *
FROM `cle_group`
WHERE `id` = '7' 
0.0003   SELECT *
FROM `cle_menu`
WHERE `menu_id` = '7'
AND `parent_id` = 0
ORDER BY 
`order`, `createddesc 
0.0003   SELECT *
FROM `cle_menu`
WHERE `parent_id` = '56'
AND `menu_id` = '7'
ORDER BY `order`, `createddesc 
0.0002   SELECT *
FROM `cle_menu`
WHERE `parent_id` = '57'
AND `menu_id` = '7'
ORDER BY `order`, `createddesc 
0.0002   SELECT *
FROM `cle_menu`
WHERE `parent_id` = '58'
AND `menu_id` = '7'
ORDER BY `order`, `createddesc 
0.0004   SELECT *
FROM `cle_menu`
WHERE `parent_id` = '59'
AND `menu_id` = '7'
ORDER BY `order`, `createddesc 
0.0002   SELECT *
FROM `cle_menu`
WHERE `parent_id` = '60'
AND `menu_id` = '7'
ORDER BY `order`, `createddesc 
0.0001   SELECT `cle_products_categories`.`id`, `cle_products_categories`.`name`, `cle_products_categories`.`slug`
FROM `cle_products_categories`
WHERE `public` = 1
AND `lft` <= '58'
AND `rgt` >= '59'
ORDER BY `level
0.0002   SHOW TABLES FROM `oilnaryihosting_alohousevn
0.0002   SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '76'
AND `meta_key` = 'view' 
0.0002   SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '76'
AND `meta_key` = 'rating_star' 
0.0002   SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '74'
AND `meta_key` = 'view' 
0.0002   SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '74'
AND `meta_key` = 'rating_star' 
  DUPLICATE QUERIES: oilnaryihosting_alohousevn (products:$db)  
[4]  SELECT `id` FROM `cle_products_categories` WHERE `lft` >= '58' AND `rgt` <= '59' ORDER BY `order`
[2]  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('39') GROUP BY `cle_relationships`.`category_id`
[2]  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('39') GROUP BY `cle_products`.`id` ORDER BY `cle_products`.`order`, `cle_products`.`created` desc LIMIT 16
[2]  SELECT `cle_products_categories`.`id`, `cle_products_categories`.`name`, `cle_products_categories`.`slug` FROM `cle_products_categories` WHERE `public` = 1 AND `lft` <= '58' AND `rgt` >= '59' ORDER BY `level`
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)