Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`name`, `ProductCategory`.`enabled`, `ProductCategory`.`display`, `ProductCategory`.`created`, `ProductCategory`.`modified`, (`I18n__name`.`content`) AS `ProductCategory__i18n_name` FROM `bertotto_bertotto`.`product_categories` AS `ProductCategory` INNER JOIN `bertotto_bertotto`.`i18n` AS `I18n__name` ON (`ProductCategory`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'ProductCategory' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'spa') WHERE `ProductCategory`.`display` = '1' ORDER BY `ProductCategory`.`lft` ASC | 28 | 28 | 5 | maybe slow |
SELECT `Service`.`id`, `Service`.`title`, `Service`.`text`, `Service`.`enabled`, `Service`.`created`, `Service`.`modified`, (`I18n__title`.`content`) AS `Service__i18n_title`, (`I18n__text`.`content`) AS `Service__i18n_text` FROM `bertotto_bertotto`.`services` AS `Service` INNER JOIN `bertotto_bertotto`.`i18n` AS `I18n__title` ON (`Service`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Service' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'spa') INNER JOIN `bertotto_bertotto`.`i18n` AS `I18n__text` ON (`Service`.`id` = `I18n__text`.`foreign_key` AND `I18n__text`.`model` = 'Service' AND `I18n__text`.`field` = 'text' AND `I18n__text`.`locale` = 'spa') WHERE 1 = 1 ORDER BY `Service`.`id` ASC LIMIT 1 | 1 | 1 | 5 | maybe slow |
SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`name`, `ProductCategory`.`enabled`, `ProductCategory`.`display`, `ProductCategory`.`created`, `ProductCategory`.`modified`, (`I18n__name`.`content`) AS `ProductCategory__i18n_name` FROM `bertotto_bertotto`.`product_categories` AS `ProductCategory` INNER JOIN `bertotto_bertotto`.`i18n` AS `I18n__name` ON (`ProductCategory`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'ProductCategory' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'spa') WHERE `ProductCategory`.`id` = 62 ORDER BY `ProductCategory`.`lft` ASC LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`name`, `ProductCategory`.`enabled`, `ProductCategory`.`display`, `ProductCategory`.`created`, `ProductCategory`.`modified`, (`I18n__name`.`content`) AS `ProductCategory__i18n_name` FROM `bertotto_bertotto`.`product_categories` AS `ProductCategory` INNER JOIN `bertotto_bertotto`.`i18n` AS `I18n__name` ON (`ProductCategory`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'ProductCategory' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'spa') WHERE `ProductCategory`.`id` = 62 ORDER BY `ProductCategory`.`lft` ASC LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `Product`.`id`, `Product`.`name`, `Product`.`description`, `Product`.`enabled`, `Product`.`hightlighted`, `Product`.`product_category_id`, `Product`.`created`, `Product`.`modified`, (`I18n__name`.`content`) AS `Product__i18n_name`, (`I18n__description`.`content`) AS `Product__i18n_description` FROM `bertotto_bertotto`.`products` AS `Product` INNER JOIN `bertotto_bertotto`.`i18n` AS `I18n__name` ON (`Product`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Product' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'spa') INNER JOIN `bertotto_bertotto`.`i18n` AS `I18n__description` ON (`Product`.`id` = `I18n__description`.`foreign_key` AND `I18n__description`.`model` = 'Product' AND `I18n__description`.`field` = 'description' AND `I18n__description`.`locale` = 'spa') WHERE `Product`.`product_category_id` = 62 AND `Product`.`enabled` = '1' LIMIT 1 | 1 | 1 | 3 | maybe slow |
SELECT `ProductCategory`.`lft`, `ProductCategory`.`rght` FROM `bertotto_bertotto`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 62 ORDER BY `ProductCategory`.`lft` ASC LIMIT 1 | 1 | 1 | 0 | |
SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`name`, `ProductCategory`.`enabled`, `ProductCategory`.`display`, `ProductCategory`.`created`, `ProductCategory`.`modified`, (`I18n__name`.`content`) AS `ProductCategory__i18n_name` FROM `bertotto_bertotto`.`product_categories` AS `ProductCategory` INNER JOIN `bertotto_bertotto`.`i18n` AS `I18n__name` ON (`ProductCategory`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'ProductCategory' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'spa') WHERE 1 = 1 AND `ProductCategory`.`lft` <= 46 AND `ProductCategory`.`rght` >= 47 ORDER BY `ProductCategory`.`lft` asc | 2 | 2 | 4 | maybe slow |
SELECT `Product`.`id`, `Product`.`name`, `Product`.`description`, `Product`.`enabled`, `Product`.`hightlighted`, `Product`.`product_category_id`, `Product`.`created`, `Product`.`modified`, (`I18n__name`.`content`) AS `Product__i18n_name`, (`I18n__description`.`content`) AS `Product__i18n_description` FROM `bertotto_bertotto`.`products` AS `Product` INNER JOIN `bertotto_bertotto`.`i18n` AS `I18n__name` ON (`Product`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Product' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'spa') INNER JOIN `bertotto_bertotto`.`i18n` AS `I18n__description` ON (`Product`.`id` = `I18n__description`.`foreign_key` AND `I18n__description`.`model` = 'Product' AND `I18n__description`.`field` = 'description' AND `I18n__description`.`locale` = 'spa') WHERE `Product`.`enabled` = '1' AND `Product`.`product_category_id` = 62 LIMIT 160 | 20 | 20 | 8 | maybe slow |
SELECT `BrwImage`.`id`, `BrwImage`.`name`, `BrwImage`.`record_id`, `BrwImage`.`model`, `BrwImage`.`description`, `BrwImage`.`category_code`, `BrwImage`.`created`, `BrwImage`.`modified` FROM `bertotto_bertotto`.`brw_images` AS `BrwImage` WHERE `BrwImage`.`model` = 'Product' AND `BrwImage`.`record_id` IN (41, 39, 40, 37, 38, 35, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55) | 20 | 20 | 1 | maybe slow |
SELECT COUNT(DISTINCT(`Product`.`id`)) AS count FROM `bertotto_bertotto`.`products` AS `Product` INNER JOIN `bertotto_bertotto`.`i18n` AS `I18nModel` ON (`Product`.`id` = `I18nModel`.`foreign_key` AND `I18nModel`.`model` = 'Product' AND `I18nModel`.`locale` = 'spa') WHERE `Product`.`enabled` = '1' AND `Product`.`product_category_id` = 62 | 1 | 1 | 5 | maybe slow |
SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`name`, `ProductCategory`.`enabled`, `ProductCategory`.`display`, `ProductCategory`.`created`, `ProductCategory`.`modified`, (`I18n__name`.`content`) AS `ProductCategory__i18n_name` FROM `bertotto_bertotto`.`product_categories` AS `ProductCategory` INNER JOIN `bertotto_bertotto`.`i18n` AS `I18n__name` ON (`ProductCategory`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'ProductCategory' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'spa') WHERE 1 = 1 AND `ProductCategory`.`parent_id` = 62 ORDER BY `ProductCategory`.`lft` asc | 0 | 0 | 4 | maybe slow |
SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`name`, `ProductCategory`.`enabled`, `ProductCategory`.`display`, `ProductCategory`.`created`, `ProductCategory`.`modified`, (`I18n__name`.`content`) AS `ProductCategory__i18n_name` FROM `bertotto_bertotto`.`product_categories` AS `ProductCategory` INNER JOIN `bertotto_bertotto`.`i18n` AS `I18n__name` ON (`ProductCategory`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'ProductCategory' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'spa') WHERE `ProductCategory`.`display` = '1' AND `ProductCategory`.`id` IS NULL ORDER BY `ProductCategory`.`lft` ASC | 0 | 0 | 0 | |
SELECT `ProductCategory`.`lft`, `ProductCategory`.`rght` FROM `bertotto_bertotto`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 62 ORDER BY `ProductCategory`.`lft` ASC LIMIT 1 | 1 | 1 | 0 | |
SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`name`, `ProductCategory`.`enabled`, `ProductCategory`.`display`, `ProductCategory`.`created`, `ProductCategory`.`modified`, (`I18n__name`.`content`) AS `ProductCategory__i18n_name` FROM `bertotto_bertotto`.`product_categories` AS `ProductCategory` INNER JOIN `bertotto_bertotto`.`i18n` AS `I18n__name` ON (`ProductCategory`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'ProductCategory' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'spa') WHERE 1 = 1 AND `ProductCategory`.`lft` <= 46 AND `ProductCategory`.`rght` >= 47 ORDER BY `ProductCategory`.`lft` asc | 2 | 2 | 3 | maybe slow |