Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Article`.`id`, `Article`.`activo`, `Article`.`name`, `Article`.`codigo`, `Article`.`descripcion`, `Article`.`unidad_medida`, `Article`.`precio`, `Article`.`descuento_base`, `Article`.`oferta_mensual`, `Article`.`promocion`, `Article`.`escalas_promocion`, `Article`.`descuentos`, `Article`.`clave_impuesto`, `Article`.`category_id`, `Article`.`hoja_venta`, `Article`.`marca_propia`, `Article`.`clave_marca`, `Article`.`clave_linea`, `Article`.`clave_sublinea`, `Article`.`clave_grupo`, `Article`.`clave_subgrupo`, `Article`.`jerarquia`, `Article`.`created`, `Article`.`modified`, `Article`.`stock`, `Article`.`oferta`, `Article`.`volumenes`, `Article`.`escalas`, `Article`.`montos`, `Article`.`url`, `Article`.`marca`, `Article`.`pdv`, `Article`.`img`, `Article`.`novedad`, `Article`.`recomendado`, `Article`.`sector`, `Article`.`active`, `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`code`, `Category`.`imagen`, `Category`.`brand_id`, `Category`.`created`, `Category`.`modified`, `Category`.`jerarquia`, `Category`.`menu`, `Category`.`activo`, `Category`.`activo_landing` FROM `gimbelsapqa`.`articles` AS `Article` LEFT JOIN `gimbelsapqa`.`categories` AS `Category` ON (`Article`.`category_id` = `Category`.`id`) WHERE `Article`.`id` = 24727 LIMIT 1 | 1 | 1 | 1 | |
SELECT `Image`.`id`, `Image`.`name`, `Image`.`article_id`, `Image`.`created`, `Image`.`modified` FROM `gimbelsapqa`.`images` AS `Image` WHERE `Image`.`article_id` = (24727) ORDER BY `Image`.`name` ASC | 1 | 1 | 33 | maybe slow |
SELECT `Paper`.`id`, `Paper`.`name`, `Paper`.`catalogo_id`, `Paper`.`indice`, `Paper`.`url`, `Paper`.`created`, `Paper`.`modified`, `Catalogo`.`id`, `Catalogo`.`name`, `Catalogo`.`brand_id`, `Catalogo`.`image`, `Catalogo`.`carpeta`, `Catalogo`.`created`, `Catalogo`.`modified`, `Catalogo`.`pdf`, `Catalogo`.`epub`, `Catalogo`.`mobi`, `Catalogo`.`web` FROM `gimbelsapqa`.`papers` AS `Paper` LEFT JOIN `gimbelsapqa`.`catalogos` AS `Catalogo` ON (`Paper`.`catalogo_id` = `Catalogo`.`id`) WHERE `Paper`.`name` = 'AG00400.pdf' LIMIT 1 | 1 | 1 | 1 | |
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`code`, `Category`.`imagen`, `Category`.`brand_id`, `Category`.`created`, `Category`.`modified`, `Category`.`jerarquia`, `Category`.`menu`, `Category`.`activo`, `Category`.`activo_landing` FROM `gimbelsapqa`.`categories` AS `Category` WHERE `Category`.`id` = 1768 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`code`, `Category`.`imagen`, `Category`.`brand_id`, `Category`.`created`, `Category`.`modified`, `Category`.`jerarquia`, `Category`.`menu`, `Category`.`activo`, `Category`.`activo_landing` FROM `gimbelsapqa`.`categories` AS `Category` WHERE `Category`.`id` = 1664 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`code`, `Category`.`imagen`, `Category`.`brand_id`, `Category`.`created`, `Category`.`modified`, `Category`.`jerarquia`, `Category`.`menu`, `Category`.`activo`, `Category`.`activo_landing` FROM `gimbelsapqa`.`categories` AS `Category` WHERE `Category`.`id` = 932 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Brand`.`id`, `Brand`.`name`, `Brand`.`clave`, `Brand`.`image`, `Brand`.`color`, `Brand`.`logo`, `Brand`.`imagen_menu`, `Brand`.`sloga`, `Brand`.`facebook`, `Brand`.`iframe_facebook`, `Brand`.`twitter`, `Brand`.`youtube`, `Brand`.`instagram`, `Brand`.`created`, `Brand`.`modified`, `Brand`.`orden`, `Brand`.`layout`, `Brand`.`cabecera`, `Brand`.`clase`, `Brand`.`activo_menu`, `Brand`.`activo_home`, `Brand`.`producto_recomendado`, `Brand`.`imagen_recomendado`, `Brand`.`producto_nuevo`, `Brand`.`imagen_nuevo`, `Brand`.`button_venta` FROM `gimbelsapqa`.`brands` AS `Brand` WHERE `Brand`.`id` = 4 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Article`.`id`, `Article`.`activo`, `Article`.`name`, `Article`.`codigo`, `Article`.`descripcion`, `Article`.`unidad_medida`, `Article`.`precio`, `Article`.`descuento_base`, `Article`.`oferta_mensual`, `Article`.`promocion`, `Article`.`escalas_promocion`, `Article`.`descuentos`, `Article`.`clave_impuesto`, `Article`.`category_id`, `Article`.`hoja_venta`, `Article`.`marca_propia`, `Article`.`clave_marca`, `Article`.`clave_linea`, `Article`.`clave_sublinea`, `Article`.`clave_grupo`, `Article`.`clave_subgrupo`, `Article`.`jerarquia`, `Article`.`created`, `Article`.`modified`, `Article`.`stock`, `Article`.`oferta`, `Article`.`volumenes`, `Article`.`escalas`, `Article`.`montos`, `Article`.`url`, `Article`.`marca`, `Article`.`pdv`, `Article`.`img`, `Article`.`novedad`, `Article`.`recomendado`, `Article`.`sector`, `Article`.`active`, `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`code`, `Category`.`imagen`, `Category`.`brand_id`, `Category`.`created`, `Category`.`modified`, `Category`.`jerarquia`, `Category`.`menu`, `Category`.`activo`, `Category`.`activo_landing` FROM `gimbelsapqa`.`articles` AS `Article` LEFT JOIN `gimbelsapqa`.`categories` AS `Category` ON (`Article`.`category_id` = `Category`.`id`) WHERE `Article`.`activo` = '1' AND `Article`.`category_id` = 1768 AND `Article`.`precio` > 0 AND `Article`.`id` <> 24727 LIMIT 9 | 9 | 9 | 75 | maybe slow |
SELECT `Image`.`id`, `Image`.`name`, `Image`.`article_id`, `Image`.`created`, `Image`.`modified` FROM `gimbelsapqa`.`images` AS `Image` WHERE `Image`.`article_id` IN (24725, 24726, 24728, 24729, 24730, 24731, 24733, 24734, 24735) ORDER BY `Image`.`name` ASC | 11 | 11 | 23 | maybe slow |
SELECT `Brand`.`id`, `Brand`.`name`, `Brand`.`clave`, `Brand`.`image`, `Brand`.`color`, `Brand`.`logo`, `Brand`.`imagen_menu`, `Brand`.`sloga`, `Brand`.`facebook`, `Brand`.`iframe_facebook`, `Brand`.`twitter`, `Brand`.`youtube`, `Brand`.`instagram`, `Brand`.`created`, `Brand`.`modified`, `Brand`.`orden`, `Brand`.`layout`, `Brand`.`cabecera`, `Brand`.`clase`, `Brand`.`activo_menu`, `Brand`.`activo_home`, `Brand`.`producto_recomendado`, `Brand`.`imagen_recomendado`, `Brand`.`producto_nuevo`, `Brand`.`imagen_nuevo`, `Brand`.`button_venta` FROM `gimbelsapqa`.`brands` AS `Brand` WHERE `Brand`.`activo_menu` = '1' ORDER BY `Brand`.`orden` ASC | 6 | 6 | 0 | |
SELECT `Catalogo`.`id`, `Catalogo`.`name`, `Catalogo`.`brand_id`, `Catalogo`.`image`, `Catalogo`.`carpeta`, `Catalogo`.`created`, `Catalogo`.`modified`, `Catalogo`.`pdf`, `Catalogo`.`epub`, `Catalogo`.`mobi`, `Catalogo`.`web` FROM `gimbelsapqa`.`catalogos` AS `Catalogo` WHERE `Catalogo`.`brand_id` IN (1, 4, 7, 2, 3, 5) | 16 | 16 | 0 | |
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`code`, `Category`.`imagen`, `Category`.`brand_id`, `Category`.`created`, `Category`.`modified`, `Category`.`jerarquia`, `Category`.`menu`, `Category`.`activo`, `Category`.`activo_landing` FROM `gimbelsapqa`.`categories` AS `Category` WHERE `Category`.`brand_id` IN (1, 4, 7, 2, 3, 5) | 2333 | 2333 | 2 | |