| 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 `gimbelsap`.`articles` AS `Article` LEFT JOIN `gimbelsap`.`categories` AS `Category` ON (`Article`.`category_id` = `Category`.`id`) WHERE `Article`.`category_id` = 1769 AND `Article`.`activo` = '1' AND `Article`.`precio` > 0 ORDER BY `Article`.`created` desc LIMIT 132, 12 | 12 | 12 | 20 | maybe slow |
| SELECT `Image`.`id`, `Image`.`name`, `Image`.`article_id`, `Image`.`created`, `Image`.`modified` FROM `gimbelsap`.`images` AS `Image` WHERE `Image`.`article_id` IN (28947, 1300, 22548, 23828, 28948, 1301, 22549, 23829, 24341, 26645, 28949, 1302) ORDER BY `Image`.`name` ASC | 13 | 13 | 23 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `gimbelsap`.`articles` AS `Article` LEFT JOIN `gimbelsap`.`categories` AS `Category` ON (`Article`.`category_id` = `Category`.`id`) WHERE `Article`.`category_id` = 1769 AND `Article`.`activo` = '1' AND `Article`.`precio` > 0 | 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`, `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 `gimbelsap`.`categories` AS `Category` LEFT JOIN `gimbelsap`.`brands` AS `Brand` ON (`Category`.`brand_id` = `Brand`.`id`) WHERE `Category`.`id` = 1769 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` FROM `gimbelsap`.`articles` AS `Article` WHERE `Article`.`category_id` = (1769) | 1929 | 1929 | 4 | |
| 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`, `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 `gimbelsap`.`categories` AS `Category` LEFT JOIN `gimbelsap`.`brands` AS `Brand` ON (`Category`.`brand_id` = `Brand`.`id`) WHERE `Category`.`id` = 937 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` FROM `gimbelsap`.`articles` AS `Article` WHERE `Article`.`category_id` = (937) | 0 | 0 | 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`, `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 `gimbelsap`.`categories` AS `Category` LEFT JOIN `gimbelsap`.`brands` AS `Brand` ON (`Category`.`brand_id` = `Brand`.`id`) WHERE `Category`.`id` = 932 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` FROM `gimbelsap`.`articles` AS `Article` WHERE `Article`.`category_id` = (932) | 0 | 0 | 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 `gimbelsap`.`brands` AS `Brand` WHERE `Brand`.`id` = 4 LIMIT 1 | 1 | 1 | 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 `gimbelsap`.`catalogos` AS `Catalogo` WHERE `Catalogo`.`brand_id` = (4) | 4 | 4 | 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 `gimbelsap`.`categories` AS `Category` WHERE `Category`.`brand_id` = (4) | 506 | 506 | 1 | |
| SELECT `Sign`.`id`, `Sign`.`name`, `Sign`.`descripcion`, `Sign`.`priority`, `Sign`.`link`, `Sign`.`enable` FROM `gimbelsap`.`signs` AS `Sign` WHERE `Sign`.`enable` = '1' ORDER BY `Sign`.`priority` ASC LIMIT 9 | 3 | 3 | 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 `gimbelsap`.`articles` AS `Article` LEFT JOIN `gimbelsap`.`categories` AS `Category` ON (`Article`.`category_id` = `Category`.`id`) WHERE `Article`.`activo` = '1' AND `Article`.`novedad` = '1' ORDER BY `Article`.`created` DESC LIMIT 9 | 7 | 7 | 0 | |
| SELECT `Image`.`id`, `Image`.`name`, `Image`.`article_id`, `Image`.`created`, `Image`.`modified` FROM `gimbelsap`.`images` AS `Image` WHERE `Image`.`article_id` IN (32319, 32313, 32315, 32280, 32085, 32283, 32308) ORDER BY `Image`.`name` ASC | 31 | 31 | 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 `gimbelsap`.`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 `gimbelsap`.`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 `gimbelsap`.`categories` AS `Category` WHERE `Category`.`brand_id` IN (1, 4, 7, 2, 3, 5) | 2504 | 2504 | 3 | |
