(default) 4 queries took 7 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `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` = 12 LIMIT 1114
2SELECT `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` = (12)000
3SELECT `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` = (12)34341
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`, `Category`.`id`, `Category`.`parent_id`, `Category`.`title`, `Category`.`is_active`, `Category`.`lft`, `Category`.`rght`, `Category`.`created`, `Category`.`modified` FROM `airtighthubs`.`products` AS `Product` LEFT JOIN `airtighthubs`.`categories` AS `Category` ON (`Product`.`category_id` = `Category`.`id`) WHERE `Product`.`category_id` = 12 AND `Product`.`is_active` = '1'34342