Main Category





(default) 6 queries took 0 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`slug`, `Category`.`description`, `Category`.`created`, `Category`.`modified` FROM `shop`.`categories` AS `Category` WHERE `Category`.`slug` = 'main' LIMIT 1110
2SELECT `Category`.`lft`, `Category`.`rght` FROM `shop`.`categories` AS `Category` WHERE `Category`.`id` = 1 LIMIT 1110
3SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`slug`, `Category`.`description`, `Category`.`created`, `Category`.`modified` FROM `shop`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`lft` <= 1 AND `Category`.`rght` >= 6 ORDER BY `Category`.`lft` asc110
4SELECT `Category`.`lft`, `Category`.`rght` FROM `shop`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 1 LIMIT 1110
5SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`slug`, `Category`.`description`, `Category`.`created`, `Category`.`modified` FROM `shop`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 6 AND `Category`.`lft` > 1 ORDER BY `Category`.`lft` asc220
6SELECT `Product`.`id`, `Product`.`category_id`, `Product`.`brand_id`, `Product`.`name`, `Product`.`slug`, `Product`.`description`, `Product`.`image`, `Product`.`price`, `Product`.`weight`, `Product`.`tags`, `Product`.`views`, `Product`.`active`, `Product`.`created`, `Product`.`modified` FROM `shop`.`products` AS `Product` WHERE `Product`.`category_id` IN (2, 3, 1) ORDER BY `Product`.`name` ASC LIMIT 5018180