| 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`.`id` = 25397 LIMIT 1 | 1 | 1 | 1 | |
| SELECT `Image`.`id`, `Image`.`name`, `Image`.`article_id`, `Image`.`created`, `Image`.`modified` FROM `gimbelsap`.`images` AS `Image` WHERE `Image`.`article_id` = (25397) ORDER BY `Image`.`name` ASC | 1 | 1 | 22 | maybe slow |
| SELECT `Paper`.`id`, `Paper`.`name`, `Paper`.`catalogo_id`, `Paper`.`indice`, `Paper`.`url`, `Paper`.`created`, `Paper`.`modified`, `Catalogo`.`id`, `Catalogo`.`name`, `Catalogo`.`orden`, `Catalogo`.`brand_id`, `Catalogo`.`image`, `Catalogo`.`carpeta`, `Catalogo`.`created`, `Catalogo`.`modified`, `Catalogo`.`pdf`, `Catalogo`.`epub`, `Catalogo`.`mobi`, `Catalogo`.`web` FROM `gimbelsap`.`papers` AS `Paper` LEFT JOIN `gimbelsap`.`catalogos` AS `Catalogo` ON (`Paper`.`catalogo_id` = `Catalogo`.`id`) WHERE `Paper`.`name` = 'AG50000.pdf' LIMIT 1 | 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` FROM `gimbelsap`.`categories` AS `Category` WHERE `Category`.`id` = 2107 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 `gimbelsap`.`categories` AS `Category` WHERE `Category`.`id` = 1230 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 `gimbelsap`.`categories` AS `Category` WHERE `Category`.`id` = 904 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 `gimbelsap`.`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 `gimbelsap`.`articles` AS `Article` LEFT JOIN `gimbelsap`.`categories` AS `Category` ON (`Article`.`category_id` = `Category`.`id`) WHERE `Article`.`activo` = '1' AND `Article`.`category_id` = 2107 AND `Article`.`precio` > 0 AND `Article`.`id` <> 25397 LIMIT 9 | 9 | 9 | 41 | maybe slow |
| SELECT `Image`.`id`, `Image`.`name`, `Image`.`article_id`, `Image`.`created`, `Image`.`modified` FROM `gimbelsap`.`images` AS `Image` WHERE `Image`.`article_id` IN (19602, 22305, 22306, 22307, 22388, 22389, 22393, 22394, 22398) ORDER BY `Image`.`name` ASC | 9 | 9 | 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`.`orden`, `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) | 11 | 11 | 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) | 2784 | 2784 | 3 | |
Productos Relacionados
