Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Setting`.`id`, `Setting`.`title`, `Setting`.`value` FROM `impresos_site18`.`settings` AS `Setting` WHERE `Setting`.`id` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Setting`.`id`, `Setting`.`title`, `Setting`.`value` FROM `impresos_site18`.`settings` AS `Setting` WHERE `Setting`.`id` = 2 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Setting`.`id`, `Setting`.`title`, `Setting`.`value` FROM `impresos_site18`.`settings` AS `Setting` WHERE `Setting`.`id` = 3 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Setting`.`id`, `Setting`.`title`, `Setting`.`value` FROM `impresos_site18`.`settings` AS `Setting` WHERE `Setting`.`id` = 6 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Setting`.`id`, `Setting`.`title`, `Setting`.`value` FROM `impresos_site18`.`settings` AS `Setting` WHERE `Setting`.`id` = 4 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Section`.`id`, `Section`.`seccion`, `Section`.`title_admin`, `Section`.`title1`, `Section`.`title2`, `Section`.`text1`, `Section`.`text2`, `Section`.`text3`, `Section`.`picture1`, `Section`.`picture2`, `Section`.`url1`, `Section`.`url2`, `Section`.`file1`, `Section`.`target1`, `Section`.`file2`, `Section`.`target2`, `Section`.`meta_title`, `Section`.`meta_description`, `Section`.`meta_keywords` FROM `impresos_site18`.`sections` AS `Section` WHERE `Section`.`id` = 5 ORDER BY `Section`.`title_admin` ASC LIMIT 1 | 1 | 1 | 0 | |
SELECT `GeneralSeo`.`id`, `GeneralSeo`.`text` FROM `impresos_site18`.`general_seos` AS `GeneralSeo` WHERE `active` = 1 ORDER BY `GeneralSeo`.`position` ASC | 0 | 0 | 0 | |
SELECT `Product`.`id`, `Product`.`subcategory_id`, `Product`.`title`, `Product`.`text`, `Product`.`picture`, `Product`.`url`, `Product`.`meta_title`, `Product`.`meta_description`, `Product`.`meta_keywords`, `Product`.`featured`, `Product`.`position`, `Subcategory`.`id`, `Subcategory`.`category_id`, `Subcategory`.`title`, `Subcategory`.`picture1`, `Subcategory`.`picture2`, `Subcategory`.`url`, `Subcategory`.`position` FROM `impresos_site18`.`products` AS `Product` LEFT JOIN `impresos_site18`.`subcategories` AS `Subcategory` ON (`Product`.`subcategory_id` = `Subcategory`.`id`) WHERE `Product`.`url` = 'etiqueta-medipiel' ORDER BY `Product`.`position` ASC LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `Related`.`id`, `Related`.`subcategory_id`, `Related`.`title`, `Related`.`text`, `Related`.`picture`, `Related`.`url`, `Related`.`meta_title`, `Related`.`meta_description`, `Related`.`meta_keywords`, `Related`.`featured`, `Related`.`position`, `products_relateds`.`product_id`, `products_relateds`.`related_id` FROM `impresos_site18`.`products` AS `Related` JOIN `impresos_site18`.`products_relateds` AS `products_relateds` ON (`products_relateds`.`product_id` = 586 AND `products_relateds`.`related_id` = `Related`.`id`) | 0 | 0 | 0 | |
SELECT `Product`.`id`, `Product`.`subcategory_id`, `Product`.`title`, `Product`.`text`, `Product`.`picture`, `Product`.`url`, `Product`.`meta_title`, `Product`.`meta_description`, `Product`.`meta_keywords`, `Product`.`featured`, `Product`.`position`, `Subcategory`.`id`, `Subcategory`.`category_id`, `Subcategory`.`title`, `Subcategory`.`picture1`, `Subcategory`.`picture2`, `Subcategory`.`url`, `Subcategory`.`position` FROM `impresos_site18`.`products` AS `Product` LEFT JOIN `impresos_site18`.`subcategories` AS `Subcategory` ON (`Product`.`subcategory_id` = `Subcategory`.`id`) WHERE `Product`.`id` = 586 ORDER BY `Product`.`position` ASC LIMIT 1 | 1 | 1 | 0 | |
SELECT `Related`.`id`, `Related`.`subcategory_id`, `Related`.`title`, `Related`.`text`, `Related`.`picture`, `Related`.`url`, `Related`.`meta_title`, `Related`.`meta_description`, `Related`.`meta_keywords`, `Related`.`featured`, `Related`.`position`, `products_relateds`.`product_id`, `products_relateds`.`related_id` FROM `impresos_site18`.`products` AS `Related` JOIN `impresos_site18`.`products_relateds` AS `products_relateds` ON (`products_relateds`.`product_id` = 586 AND `products_relateds`.`related_id` = `Related`.`id`) | 0 | 0 | 0 | |
SELECT `Category`.`id`, `Category`.`title`, `Category`.`text`, `Category`.`picture1`, `Category`.`picture2`, `Category`.`picture3`, `Category`.`url`, `Category`.`meta_title`, `Category`.`meta_description`, `Category`.`meta_keywords`, `Category`.`position` FROM `impresos_site18`.`categories` AS `Category` WHERE 1 = 1 ORDER BY `Category`.`position` ASC | 2 | 2 | 0 | |
SELECT `Product`.`id`, `Product`.`subcategory_id`, `Product`.`title`, `Product`.`text`, `Product`.`picture`, `Product`.`url`, `Product`.`meta_title`, `Product`.`meta_description`, `Product`.`meta_keywords`, `Product`.`featured`, `Product`.`position` FROM `impresos_site18`.`products` AS `Product` WHERE `subcategory_id` = 27 AND `position` < 1 ORDER BY `Product`.`position` ASC | 0 | 0 | 0 | |
SELECT `Product`.`id`, `Product`.`subcategory_id`, `Product`.`title`, `Product`.`text`, `Product`.`picture`, `Product`.`url`, `Product`.`meta_title`, `Product`.`meta_description`, `Product`.`meta_keywords`, `Product`.`featured`, `Product`.`position` FROM `impresos_site18`.`products` AS `Product` WHERE `subcategory_id` = 27 AND `position` > 1 ORDER BY `Product`.`position` ASC | 4 | 4 | 0 | |
1 duplicate queries run.