No post data.
No querystring data.
To view Cookies, add CookieComponent to Controller
Query | Affected | Num. rows | Took (ms) | Actions |
---|---|---|---|---|
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`.`parent_id` = 458 AND `Category`.`ACTIVO` = '1' ORDER BY `Category`.`name` ASC | 36 | 36 | 3 | maybe slow |
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` IN (2282, 970, 992, 993, 966, 973, 983, 962, 961, 981, 991, 985, 989, 972, 960, 963, 984, 957, 980, 971, 978, 959, 969, 459, 974, 987, 965, 977, 2447, 956, 979, 958, 990, 988, 964, 982) | 280 | 280 | 57 | 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` = 458 ORDER BY `Category`.`name` ASC 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` = (458) | 0 | 0 | 49 | 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` = 63 ORDER BY `Category`.`name` ASC 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` = (63) | 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`.`id` = 2 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` = (2) | 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` = (2) | 348 | 348 | 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 |
Peak Memory Use 13.52 MB
Message | Memory use |
---|---|
Component initialization | 906 KB |
Controller action start | 1.20 MB |
Controller render start | 3.20 MB |
Component initialization #2 | 3.54 MB |
Controller action start #2 | 3.55 MB |
View render complete | 6.62 MB |
Total Request Time: 252 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 33.22 | |
Event: Controller.initialize | 0.15 | |
Event: Controller.startup | 5.58 | |
Controller action | 130.73 | |
Event: Controller.beforeRender | 19.74 | |
» Processing toolbar data | 19.64 | |
Rendering View | 37.71 | |
» Event: View.beforeRender | 0.02 | |
» Rendering APP/View/Store/subgrupos.ctp | 4.60 | |
» Event: View.afterRender | 0.01 | |
» Event: View.beforeLayout | 0.01 | |
» Rendering APP/View/Layouts/store.ctp | 32.50 | |
» » Rendering APP/View/Elements/Front-end/header.ctp | 28.68 | |
» » » Rendering APP/View/Elements/Front-end/customer_menu.ctp | 3.79 | |
» » » Rendering APP/View/Elements/Front-end/social_networks.ctp | 0.20 | |
» » » Rendering APP/View/Elements/Front-end/menu.ctp | 24.11 | |
» » » » Event: Controller.initialize #2 | 0.07 | |
» » » » Event: Controller.startup #2 | 0.13 | |
Controller action #2 | 0.00 | |
» » » » » Event: Controller.shutdown | 0.02 | |
» » » » » Rendering APP/View/Elements/Front-end/search.ctp | 0.52 | |
» » » Rendering APP/View/Elements/store/title.ctp | 0.19 | |
» » » Rendering APP/View/Elements/Front-end/newsletters_form.ctp | 1.72 | |
» » » Rendering APP/View/Elements/Front-end/footer.ctp | 0.67 | |
» » » » Rendering APP/View/Elements/Front-end/social_networks.ctp #2 | 0.18 | |
» » » Rendering APP/View/Elements/Front-end/social_networks_r.ctp | 0.16 | |
Event: View.afterLayout | 0.00 |