Facebook

×
  BENCHMARKS  
Loading Time: Base Classes  0.0099
Controller Execution Time ( Products / Index )  0.0605
Total Execution Time  0.0704
  MEMORY USAGE  
10.13M bytes
  CLASS/METHOD  
products/index
  URI STRING  
cua-luoi-cuon-ngang-02-canh
  GET DATA  
No GET data exists
  POST DATA  
No POST data exists
  DATABASE:  oilnaryihosting_alohousevn (products:$db)   QUERIES: 29 (0.0041 )  (Show)
  DUPLICATE QUERIES: oilnaryihosting_alohousevn (products:$db)  
[4]  SELECT `id` FROM `cle_products_categories` WHERE `lft` >= '6' AND `rgt` <= '7' 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('15') 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('15') 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` <= '6' AND `rgt` >= '7' ORDER BY `level`
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)