To view Cookies, add CookieComponent to Controller
Query | Error | Affected | Num. rows | Took (ms) | Actions |
---|---|---|---|---|---|
SHOW FULL COLUMNS FROM `sitio_productos` | 52 | 52 | 2 | ||
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8mb3_general_ci'; | 1 | 1 | 1 | ||
SHOW FULL COLUMNS FROM `sitio_compras` | 52 | 52 | 2 | ||
SHOW FULL COLUMNS FROM `sitio_variantes` | 5 | 5 | 2 | maybe slow | |
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci'; | 1 | 1 | 1 | ||
SHOW FULL COLUMNS FROM `sitio_productos_compras` | 15 | 15 | 2 | maybe slow | |
SHOW FULL COLUMNS FROM `sitio_compras_variantes` | 13 | 13 | 2 | maybe slow | |
SHOW FULL COLUMNS FROM `sitio_productos_asociados` | 5 | 5 | 2 | maybe slow | |
SHOW FULL COLUMNS FROM `sitio_productos_categorias` | 5 | 5 | 2 | maybe slow | |
SHOW FULL COLUMNS FROM `sitio_parametros` | 3 | 3 | 1 | maybe slow | |
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_spanish_ci'; | 1 | 1 | 1 | ||
SELECT `Parametro`.`parametro`, `Parametro`.`valor` FROM `sitio_parametros` AS `Parametro` WHERE 1 = 1 | 53 | 53 | 1 | ||
SHOW FULL COLUMNS FROM `sitio_colores` | 11 | 11 | 2 | maybe slow | |
SHOW FULL COLUMNS FROM `sitio_galerias` | 6 | 6 | 2 | maybe slow | |
SHOW FULL COLUMNS FROM `sitio_marcas` | 12 | 12 | 2 | maybe slow | |
SHOW FULL COLUMNS FROM `sitio_generos` | 16 | 16 | 2 | maybe slow | |
SHOW FULL COLUMNS FROM `sitio_estilos` | 14 | 14 | 2 | maybe slow | |
SHOW FULL COLUMNS FROM `sitio_categorias` | 22 | 22 | 2 | maybe slow | |
SHOW FULL COLUMNS FROM `sitio_descuentos` | 22 | 22 | 2 | maybe slow | |
SHOW FULL COLUMNS FROM `sitio_categorias_descuentos` | 3 | 3 | 2 | maybe slow | |
SHOW FULL COLUMNS FROM `sitio_categorias_estilos` | 4 | 4 | 2 | maybe slow | |
SHOW FULL COLUMNS FROM `sitio_generos_estilos` | 4 | 4 | 1 | maybe slow | |
SHOW FULL COLUMNS FROM `sitio_stocks` | 10 | 10 | 2 | maybe slow | |
SELECT `Producto`.`id`, `Producto`.`sku`, `Producto`.`hermano`, `Producto`.`nombre`, `Producto`.`categoria_id`, `Producto`.`foto`, `Producto`.`imagen_campana`, `Producto`.`color_id`, `Producto`.`codigo`, `Producto`.`codigo_completo`, `Producto`.`precio`, `Producto`.`oferta`, `Producto`.`precio_oferta`, `Producto`.`slug`, `Producto`.`new`, `Producto`.`descripcion`, `Producto`.`ficha`, `Producto`.`escolar`, `Producto`.`outlet`, `Producto`.`stock_seguridad`, `Producto`.`tipo`, `Producto`.`excluir_descuento`, `Producto`.`grupo`, `Producto`.`pdf`, `Producto`.`catalogo`, `Producto`.`manual`, `Producto`.`certificacion`, `Categoria`.*, `Marca`.`nombre`, `Marca`.`tabla_tallas`, `Genero`.`id`, `Genero`.`nombre`, `CategoriaPadre`.*, `Marca`.`id`, `Color`.`id`, `Color`.`nombre`, `Color`.`codigo`, `Color`.`primario_id`, `Color`.`color` FROM `sitio_productos` AS `Producto` INNER JOIN sitio_categorias AS `Categoria` ON (`Categoria`.`id` = `Producto`.`categoria_id` AND `Categoria`.`publico` = 1) LEFT JOIN sitio_categorias AS `CategoriaPadre` ON (`CategoriaPadre`.`id` = `Categoria`.`parent_id`) LEFT JOIN `sitio_marcas` AS `Marca` ON (`Producto`.`marca_id` = `Marca`.`id`) LEFT JOIN `sitio_colores` AS `Color` ON (`Producto`.`color_id` = `Color`.`id`) LEFT JOIN `sitio_generos` AS `Genero` ON (`Producto`.`genero_id` = `Genero`.`id`) WHERE `Producto`.`activo` = 1 AND ((`Producto`.`slug` = 'polar-gnomo-pullover-farver-ocean') OR (`Producto`.`pdf` = 'polar-gnomo-pullover-farver-ocean')) AND (NOT (`Producto`.`foto` IS NULL) AND NOT (`Producto`.`foto` = '')) ORDER BY `Color`.`id` ASC LIMIT 1 | 1 | 1 | 5 | maybe slow | |
SELECT `Galeria`.`id`, `Galeria`.`imagen`, `Galeria`.`producto_id` FROM `sitio_galerias` AS `Galeria` WHERE `Galeria`.`producto_id` = (313) ORDER BY `Galeria`.`orden` ASC LIMIT 4 | 3 | 3 | 2 | maybe slow | |
SELECT `Stock`.`id`, `Stock`.`talla`, `Stock`.`cantidad`, `Stock`.`sku`, `Stock`.`producto_id` FROM `sitio_stocks` AS `Stock` WHERE `Stock`.`producto_id` = (313) ORDER BY `Stock`.`orden` ASC | 2 | 2 | 1 | maybe slow | |
SELECT `Producto`.`id`, `Producto`.`nombre`, `Producto`.`categoria_id`, `Producto`.`foto`, `Producto`.`color_id`, `Producto`.`codigo`, `Producto`.`slug`, `Color`.`id`, `Color`.`nombre`, `Color`.`codigo`, `Color`.`color` FROM `sitio_productos` AS `Producto` INNER JOIN sitio_categorias AS `Categoria` ON (`Categoria`.`id` = `Producto`.`categoria_id` AND `Categoria`.`publico` = 1) INNER JOIN sitio_stocks AS `Stock` ON (`Stock`.`producto_id` = `Producto`.`id` AND `Stock`.`cantidad` > -100) LEFT JOIN `sitio_colores` AS `Color` ON (`Producto`.`color_id` = `Color`.`id`) WHERE `Producto`.`hermano` IS NULL AND NOT (`Producto`.`hermano` IS NULL) AND `Producto`.`outlet` = 0 AND `Producto`.`activo` = 1 AND NOT (`Producto`.`id` = 313) AND (NOT (`Producto`.`foto` IS NULL) AND NOT (`Producto`.`foto` = '')) GROUP BY `Producto`.`id` | 0 | 0 | 4 | maybe slow | |
SELECT `Categoria`.`id` FROM `sitio_categorias` AS `Categoria` WHERE `Categoria`.`id` IN (59, 60) AND `Categoria`.`publico` = 1 | 0 | 0 | 1 | maybe slow | |
SELECT `Categoria`.`id` FROM `sitio_categorias` AS `Categoria` WHERE `Categoria`.`publico` = 1 AND `Categoria`.`id` = 16 | 0 | 0 | 1 | maybe slow | |
SELECT `Categoria`.`id` FROM `sitio_categorias` AS `Categoria` WHERE `Categoria`.`id` = 2 | 1 | 1 | 1 | ||
SHOW FULL COLUMNS FROM `sitio_homologaciones` | 9 | 9 | 2 | maybe slow | |
SELECT `Homologacion`.`CM`, `Homologacion`.`UK`, `Homologacion`.`US`, `Homologacion`.`EUR`, `Homologacion`.`CL` FROM `sitio_homologaciones` AS `Homologacion` WHERE `genero_id` = 1 AND `categoria_id` = 2 AND `marca_id` = 45 ORDER BY CAST(CM as UNSIGNED) ASC | 0 | 0 | 1 | maybe slow | |
SHOW FULL COLUMNS FROM `sitio_tiendas` | 16 | 16 | 2 | maybe slow | |
SHOW FULL COLUMNS FROM `sitio_comunas` | 13 | 13 | 2 | maybe slow | |
SELECT `Tienda`.`id`, `Tienda`.`nombre`, `Tienda`.`codigo`, `Tienda`.`direccion`, `Tienda`.`telefono`, `Tienda`.`region_id`, `Tienda`.`comuna_id`, `Tienda`.`zona_id`, `Tienda`.`latitud`, `Tienda`.`longitud`, `Tienda`.`horario`, `Tienda`.`imagen`, `Tienda`.`outlet`, `Tienda`.`remodelacion`, `Tienda`.`created`, `Tienda`.`modified`, `Comuna`.`id`, `Comuna`.`nombre`, `Comuna`.`codigo`, `Comuna`.`codigo_empresa`, `Comuna`.`limite`, `Comuna`.`despacho1`, `Comuna`.`despacho2`, `Comuna`.`dias_minimo`, `Comuna`.`dias_maximo`, `Comuna`.`region_id`, `Comuna`.`activo`, `Comuna`.`created`, `Comuna`.`modified` FROM `sitio_tiendas` AS `Tienda` LEFT JOIN `sitio_comunas` AS `Comuna` ON (`Tienda`.`comuna_id` = `Comuna`.`id`) WHERE 1 = 1 | 2 | 2 | 1 | maybe slow | |
SELECT `Producto`.*, `Marca`.* FROM `sitio_productos_asociados` AS `ProductoAsociado` LEFT JOIN sitio_productos AS `Producto` ON (`Producto`.`id` = `ProductoAsociado`.`producto_hijo_id`) LEFT JOIN sitio_marcas AS `Marca` ON (`Marca`.`id` = `Producto`.`marca_id`) WHERE `ProductoAsociado`.`producto_padre_id` = 313 AND `Producto`.`activo` = 1 AND `Producto`.`categoria_id` = 2 AND `Producto`.`marca_id` = 45 AND (NOT (`Producto`.`foto` = '') AND NOT (`Producto`.`foto` IS NULL)) | 0 | 0 | 1 | maybe slow | |
SHOW FULL COLUMNS FROM `sitio_primarios` | 4 | 4 | 2 | maybe slow | |
SELECT `Categoria`.`id`, `Categoria`.`slug`, `Categoria`.`nombre`, `Categoria`.`menu` FROM `sitio_categorias` AS `Categoria` WHERE `Categoria`.`parent_id` = 0 AND `Categoria`.`publico` = 1 AND `Categoria`.`menu` = 1 ORDER BY `Categoria`.`nombre` ASC, `Categoria`.`orden` ASC | 0 | 0 | 1 | maybe slow | |
SELECT `Marca`.`id`, `Marca`.`nombre`, `Marca`.`logo`, `Marca`.`banner`, `Marca`.`tabla_tallas`, `Marca`.`alias`, `Marca`.`slug`, `Marca`.`talla`, `Marca`.`busqueda`, `Marca`.`separa_codigo`, `Marca`.`activo`, `Marca`.`created` FROM `sitio_marcas` AS `Marca` WHERE `logo` != '' AND `activo` = 1 ORDER BY `nombre` asc | 0 | 0 | 1 | maybe slow | |
SHOW FULL COLUMNS FROM `sitio_menus` | 8 | 8 | 2 | maybe slow |
Peak Memory Use 7.22 MB
Message | Memory use |
---|---|
Component initialization | 3.49 MB |
Controller action start | 4.11 MB |
Controller render start | 5.77 MB |
View render complete | 6.13 MB |
Total Request Time: 182 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived) | 53.31 | |
Component initialization and startup | 7.91 | |
Controller action | 69.80 | |
Render Controller Action | 21.43 | |
» Rendering View | 20.73 | |
» » Rendering APP/views/clientes/montero/view.ctp | 4.26 | |
» » » Rendering APP/views/elements/google_view.ctp | 0.14 | |
» » Rendering APP/views/layouts/default.ctp | 16.20 | |
» » » Rendering APP/views/elements/ga.ctp | 0.11 | |
» » » Rendering APP/views/elements/pixel.ctp | 0.18 | |
» » » Rendering APP/views/elements/clientes/montero/new_top.ctp | 1.98 | |
» » » Rendering APP/views/elements/clientes/montero/new_menu.ctp | 5.76 | |
» » » Rendering APP/views/elements/clientes/montero/new_footer.ctp | 5.88 |