(default) 4 queries took 4 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT COUNT(*) AS `count` FROM `airtighthubs`.`categories` AS `Category` WHERE `Category`.`id` = 2111
2SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`title`, `Category`.`is_active`, `Category`.`lft`, `Category`.`rght`, `Category`.`created`, `Category`.`modified`, `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`title`, `ParentCategory`.`is_active`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`created`, `ParentCategory`.`modified` FROM `airtighthubs`.`categories` AS `Category` LEFT JOIN `airtighthubs`.`categories` AS `ParentCategory` ON (`Category`.`parent_id` = `ParentCategory`.`id`) WHERE `Category`.`id` = 2 LIMIT 1111
3SELECT `ChildCategory`.`id`, `ChildCategory`.`parent_id`, `ChildCategory`.`title`, `ChildCategory`.`is_active`, `ChildCategory`.`lft`, `ChildCategory`.`rght`, `ChildCategory`.`created`, `ChildCategory`.`modified` FROM `airtighthubs`.`categories` AS `ChildCategory` WHERE `ChildCategory`.`parent_id` = (2)441
4SELECT `Product`.`id`, `Product`.`category_id`, `Product`.`sku`, `Product`.`title`, `Product`.`short_description`, `Product`.`description`, `Product`.`cost`, `Product`.`weight`, `Product`.`lft`, `Product`.`rght`, `Product`.`is_active`, `Product`.`created`, `Product`.`modified` FROM `airtighthubs`.`products` AS `Product` WHERE `Product`.`category_id` = (2)001