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`.`category_id` = 116 AND `Article`.`activo` = '1' AND `Article`.`precio` > 0 AND `Article`.`stock` > '0' LIMIT 12 | 0 | 0 | 77 | maybe slow |
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 `gimbelsapqa`.`categories` AS `Category` LEFT JOIN `gimbelsapqa`.`brands` AS `Brand` ON (`Category`.`brand_id` = `Brand`.`id`) WHERE `Category`.`id` = 116 LIMIT 1 | 1 | 1 | 1 | |
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 `gimbelsapqa`.`articles` AS `Article` WHERE `Article`.`category_id` = (116) | 238 | 238 | 83 | maybe slow |
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 `gimbelsapqa`.`categories` AS `Category` LEFT JOIN `gimbelsapqa`.`brands` AS `Brand` ON (`Category`.`brand_id` = `Brand`.`id`) WHERE `Category`.`id` = 7 LIMIT 1 | 1 | 1 | 1 | |
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 `gimbelsapqa`.`articles` AS `Article` WHERE `Article`.`category_id` = (7) | 0 | 0 | 48 | maybe slow |
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 `gimbelsapqa`.`categories` AS `Category` LEFT JOIN `gimbelsapqa`.`brands` AS `Brand` ON (`Category`.`brand_id` = `Brand`.`id`) WHERE `Category`.`id` = 1 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 `gimbelsapqa`.`articles` AS `Article` WHERE `Article`.`category_id` = (1) | 0 | 0 | 48 | 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`.`id` = 3 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 `gimbelsapqa`.`catalogos` AS `Catalogo` WHERE `Catalogo`.`brand_id` = (3) | 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`.`brand_id` = (3) | 32 | 32 | 2 | maybe slow |
SELECT `Sign`.`id`, `Sign`.`name`, `Sign`.`descripcion`, `Sign`.`priority`, `Sign`.`link`, `Sign`.`enable` FROM `gimbelsapqa`.`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 `gimbelsapqa`.`articles` AS `Article` LEFT JOIN `gimbelsapqa`.`categories` AS `Category` ON (`Article`.`category_id` = `Category`.`id`) WHERE `Article`.`activo` = '1' AND `Article`.`novedad` = '1' ORDER BY `Article`.`created` DESC LIMIT 9 | 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 `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 | |