Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Category`.`id`, `Category`.`name`, `Category`.`short_description`, `Category`.`keywords`, `Category`.`file`, `Category`.`created`, `Category`.`modified`, `Category`.`created_by`, `Category`.`modified_by`, `Category`.`priority`, `Category`.`published`, (`I18n__name_loc`.`content`) AS `Category__i18n_name_loc`, (`I18n__short_description_loc`.`content`) AS `Category__i18n_short_description_loc`, `CreatedBy`.`id`, `CreatedBy`.`username`, `CreatedBy`.`password`, `CreatedBy`.`email`, `CreatedBy`.`created`, `CreatedBy`.`modified`, `CreatedBy`.`created_by`, `CreatedBy`.`modified_by`, `CreatedBy`.`deleted`, `CreatedBy`.`role`, `ModifiedBy`.`id`, `ModifiedBy`.`username`, `ModifiedBy`.`password`, `ModifiedBy`.`email`, `ModifiedBy`.`created`, `ModifiedBy`.`modified`, `ModifiedBy`.`created_by`, `ModifiedBy`.`modified_by`, `ModifiedBy`.`deleted`, `ModifiedBy`.`role` FROM `Sql1040305_3`.`categories` AS `Category` LEFT JOIN `Sql1040305_3`.`users` AS `CreatedBy` ON (`Category`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `Sql1040305_3`.`users` AS `ModifiedBy` ON (`Category`.`modified_by` = `ModifiedBy`.`id`) INNER JOIN `Sql1040305_3`.`i18n` AS `I18n__name_loc` ON (`Category`.`id` = `I18n__name_loc`.`foreign_key` AND `I18n__name_loc`.`model` = 'Category' AND `I18n__name_loc`.`field` = 'name' AND `I18n__name_loc`.`locale` = 'ita') INNER JOIN `Sql1040305_3`.`i18n` AS `I18n__short_description_loc` ON (`Category`.`id` = `I18n__short_description_loc`.`foreign_key` AND `I18n__short_description_loc`.`model` = 'Category' AND `I18n__short_description_loc`.`field` = 'short_description' AND `I18n__short_description_loc`.`locale` = 'ita') WHERE `published` = '1' ORDER BY `priority` ASC, `name` ASC | 0 | 0 | 1 | maybe slow |
SELECT `Area`.`code`, (`I18n__name`.`content`) AS `Area__i18n_name` FROM `Sql1040305_3`.`areas` AS `Area` INNER JOIN `Sql1040305_3`.`i18n` AS `I18n__name` ON (`Area`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Area' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'ita') WHERE `published` = '1' ORDER BY `name` ASC | 1 | 1 | 1 | |
SELECT `Slider`.`id`, `Slider`.`title`, `Slider`.`price`, `Slider`.`description`, `Slider`.`button_text`, `Slider`.`url`, `Slider`.`file`, `Slider`.`type`, `Slider`.`order`, `Slider`.`published`, `Slider`.`created`, `Slider`.`modified`, `Slider`.`created_by`, `Slider`.`modified_by`, (`I18n__title_loc`.`content`) AS `Slider__i18n_title_loc`, (`I18n__description_loc`.`content`) AS `Slider__i18n_description_loc`, (`I18n__button_text_loc`.`content`) AS `Slider__i18n_button_text_loc`, (`I18n__url_loc`.`content`) AS `Slider__i18n_url_loc`, `CreatedBy`.`id`, `CreatedBy`.`username`, `CreatedBy`.`password`, `CreatedBy`.`email`, `CreatedBy`.`created`, `CreatedBy`.`modified`, `CreatedBy`.`created_by`, `CreatedBy`.`modified_by`, `CreatedBy`.`deleted`, `CreatedBy`.`role`, `ModifiedBy`.`id`, `ModifiedBy`.`username`, `ModifiedBy`.`password`, `ModifiedBy`.`email`, `ModifiedBy`.`created`, `ModifiedBy`.`modified`, `ModifiedBy`.`created_by`, `ModifiedBy`.`modified_by`, `ModifiedBy`.`deleted`, `ModifiedBy`.`role` FROM `Sql1040305_3`.`sliders` AS `Slider` LEFT JOIN `Sql1040305_3`.`users` AS `CreatedBy` ON (`Slider`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `Sql1040305_3`.`users` AS `ModifiedBy` ON (`Slider`.`modified_by` = `ModifiedBy`.`id`) INNER JOIN `Sql1040305_3`.`i18n` AS `I18n__title_loc` ON (`Slider`.`id` = `I18n__title_loc`.`foreign_key` AND `I18n__title_loc`.`model` = 'Slider' AND `I18n__title_loc`.`field` = 'title' AND `I18n__title_loc`.`locale` = 'ita') INNER JOIN `Sql1040305_3`.`i18n` AS `I18n__description_loc` ON (`Slider`.`id` = `I18n__description_loc`.`foreign_key` AND `I18n__description_loc`.`model` = 'Slider' AND `I18n__description_loc`.`field` = 'description' AND `I18n__description_loc`.`locale` = 'ita') INNER JOIN `Sql1040305_3`.`i18n` AS `I18n__button_text_loc` ON (`Slider`.`id` = `I18n__button_text_loc`.`foreign_key` AND `I18n__button_text_loc`.`model` = 'Slider' AND `I18n__button_text_loc`.`field` = 'button_text' AND `I18n__button_text_loc`.`locale` = 'ita') INNER JOIN `Sql1040305_3`.`i18n` AS `I18n__url_loc` ON (`Slider`.`id` = `I18n__url_loc`.`foreign_key` AND `I18n__url_loc`.`model` = 'Slider' AND `I18n__url_loc`.`field` = 'url' AND `I18n__url_loc`.`locale` = 'ita') WHERE `published` = '1' ORDER BY `order` ASC, `title` ASC | 0 | 0 | 1 | maybe slow |
SELECT `Product`.`id`, `Product`.`name`, `Product`.`short_description`, `Product`.`long_description`, `Product`.`keywords`, `Product`.`file`, `Product`.`created`, `Product`.`modified`, `Product`.`created_by`, `Product`.`modified_by`, `Product`.`published`, `Product`.`vetrina`, `Product`.`category_id`, `Product`.`price_tier_id`, `Product`.`quantity_price`, `Product`.`priority`, (`I18n__name_loc`.`content`) AS `Product__i18n_name_loc`, (`I18n__short_description_loc`.`content`) AS `Product__i18n_short_description_loc`, (`I18n__long_description_loc`.`content`) AS `Product__i18n_long_description_loc`, `Category`.`id`, `Category`.`name`, `Category`.`short_description`, `Category`.`keywords`, `Category`.`file`, `Category`.`created`, `Category`.`modified`, `Category`.`created_by`, `Category`.`modified_by`, `Category`.`priority`, `Category`.`published`, `CreatedBy`.`id`, `CreatedBy`.`username`, `CreatedBy`.`password`, `CreatedBy`.`email`, `CreatedBy`.`created`, `CreatedBy`.`modified`, `CreatedBy`.`created_by`, `CreatedBy`.`modified_by`, `CreatedBy`.`deleted`, `CreatedBy`.`role`, `ModifiedBy`.`id`, `ModifiedBy`.`username`, `ModifiedBy`.`password`, `ModifiedBy`.`email`, `ModifiedBy`.`created`, `ModifiedBy`.`modified`, `ModifiedBy`.`created_by`, `ModifiedBy`.`modified_by`, `ModifiedBy`.`deleted`, `ModifiedBy`.`role` FROM `Sql1040305_3`.`products` AS `Product` LEFT JOIN `Sql1040305_3`.`categories` AS `Category` ON (`Product`.`category_id` = `Category`.`id`) LEFT JOIN `Sql1040305_3`.`users` AS `CreatedBy` ON (`Product`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `Sql1040305_3`.`users` AS `ModifiedBy` ON (`Product`.`modified_by` = `ModifiedBy`.`id`) INNER JOIN `Sql1040305_3`.`i18n` AS `I18n__name_loc` ON (`Product`.`id` = `I18n__name_loc`.`foreign_key` AND `I18n__name_loc`.`model` = 'Product' AND `I18n__name_loc`.`field` = 'name' AND `I18n__name_loc`.`locale` = 'ita') INNER JOIN `Sql1040305_3`.`i18n` AS `I18n__short_description_loc` ON (`Product`.`id` = `I18n__short_description_loc`.`foreign_key` AND `I18n__short_description_loc`.`model` = 'Product' AND `I18n__short_description_loc`.`field` = 'short_description' AND `I18n__short_description_loc`.`locale` = 'ita') INNER JOIN `Sql1040305_3`.`i18n` AS `I18n__long_description_loc` ON (`Product`.`id` = `I18n__long_description_loc`.`foreign_key` AND `I18n__long_description_loc`.`model` = 'Product' AND `I18n__long_description_loc`.`field` = 'long_description' AND `I18n__long_description_loc`.`locale` = 'ita') WHERE `Category`.`published` = '1' AND `Product`.`published` = '1' AND `Product`.`vetrina` = '1' ORDER BY `Product`.`priority` ASC, `Product`.`name` ASC | 0 | 0 | 1 | maybe slow |