
11-11-2022
Query | Error | Affected | Num. rows | Took (ms) | Actions |
---|---|---|---|---|---|
SHOW FULL COLUMNS FROM `publicaciones` | 13 | 13 | 1 | maybe slow | |
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8mb3_unicode_ci'; | 1 | 1 | 1 | ||
SHOW FULL COLUMNS FROM `sedes` | 15 | 15 | 1 | maybe slow | |
SHOW FULL COLUMNS FROM `administrativos` | 9 | 9 | 1 | maybe slow | |
SHOW FULL COLUMNS FROM `usuarios` | 22 | 22 | 1 | ||
SHOW FULL COLUMNS FROM `roles` | 4 | 4 | 1 | maybe slow | |
SHOW FULL COLUMNS FROM `admins` | 5 | 5 | 1 | maybe slow | |
SHOW FULL COLUMNS FROM `asesores` | 12 | 12 | 1 | maybe slow | |
SHOW FULL COLUMNS FROM `descargas_archivos` | 16 | 16 | 1 | maybe slow | |
SHOW FULL COLUMNS FROM `descargas_categorias` | 2 | 2 | 1 | maybe slow | |
SHOW FULL COLUMNS FROM `clientes` | 13 | 13 | 1 | maybe slow | |
SHOW FULL COLUMNS FROM `gestor_de_citas_citas` | 12 | 12 | 1 | maybe slow | |
SHOW FULL COLUMNS FROM `estaticos` | 12 | 12 | 1 | maybe slow | |
SHOW FULL COLUMNS FROM `contenido_noticias` | 15 | 15 | 1 | maybe slow | |
SHOW FULL COLUMNS FROM `contenido_etiquetas` | 5 | 5 | 1 | maybe slow | |
SHOW FULL COLUMNS FROM `contenido_etiquetados` | 3 | 3 | 1 | maybe slow | |
SHOW FULL COLUMNS FROM `contenido_eventos` | 18 | 18 | 2 | maybe slow | |
SHOW FULL COLUMNS FROM `configuraciones` | 12 | 12 | 1 | maybe slow | |
SELECT `Publicacione`.`id` FROM `publicaciones` AS `Publicacione` WHERE `Publicacione`.`slug` = 'ACTUALIDAD-FISCAL-OCTUBRE-22' LIMIT 1 | 1 | 1 | 1 | ||
SELECT `Publicacione`.`id`, `Publicacione`.`sede_id`, `Publicacione`.`categoria`, `Publicacione`.`title`, `Publicacione`.`slug`, `Publicacione`.`desc`, `Publicacione`.`file`, `Publicacione`.`foto`, `Publicacione`.`thumb`, `Publicacione`.`created`, `Publicacione`.`modified`, `Publicacione`.`active`, `Publicacione`.`destacado` FROM `publicaciones` AS `Publicacione` WHERE `Publicacione`.`id` = '636e426a-f96c-4b1e-982e-573b1f189b86' LIMIT 1 | 1 | 1 | 1 | ||
SELECT `Publicacione`.`id`, `Publicacione`.`sede_id`, `Publicacione`.`categoria`, `Publicacione`.`title`, `Publicacione`.`slug`, `Publicacione`.`desc`, `Publicacione`.`file`, `Publicacione`.`foto`, `Publicacione`.`thumb`, `Publicacione`.`created`, `Publicacione`.`modified`, `Publicacione`.`active`, `Publicacione`.`destacado`, `Sede`.`id`, `Sede`.`title`, `Sede`.`slug`, `Sede`.`desc`, `Sede`.`foto`, `Sede`.`thumb`, `Sede`.`telefono`, `Sede`.`fax`, `Sede`.`mail`, `Sede`.`direccion`, `Sede`.`localidad`, `Sede`.`twitter`, `Sede`.`facebook`, `Sede`.`google`, `Sede`.`linkedin` FROM `publicaciones` AS `Publicacione` LEFT JOIN `sedes` AS `Sede` ON (`Publicacione`.`sede_id` = `Sede`.`id`) WHERE `Publicacione`.`created` < '2022-11-11 13:39:06' ORDER BY `Publicacione`.`created` DESC LIMIT 1 | 1 | 1 | 2 | maybe slow | |
SELECT `Publicacione`.`id`, `Publicacione`.`sede_id`, `Publicacione`.`categoria`, `Publicacione`.`title`, `Publicacione`.`slug`, `Publicacione`.`desc`, `Publicacione`.`file`, `Publicacione`.`foto`, `Publicacione`.`thumb`, `Publicacione`.`created`, `Publicacione`.`modified`, `Publicacione`.`active`, `Publicacione`.`destacado`, `Sede`.`id`, `Sede`.`title`, `Sede`.`slug`, `Sede`.`desc`, `Sede`.`foto`, `Sede`.`thumb`, `Sede`.`telefono`, `Sede`.`fax`, `Sede`.`mail`, `Sede`.`direccion`, `Sede`.`localidad`, `Sede`.`twitter`, `Sede`.`facebook`, `Sede`.`google`, `Sede`.`linkedin` FROM `publicaciones` AS `Publicacione` LEFT JOIN `sedes` AS `Sede` ON (`Publicacione`.`sede_id` = `Sede`.`id`) WHERE `Publicacione`.`created` >= '2022-09-29 08:44:56' AND `Publicacione`.`created` != '2022-11-11 13:39:06' ORDER BY `Publicacione`.`created` ASC LIMIT 2 | 2 | 2 | 2 | ||
SELECT `Configuracione`.`nombre` FROM `configuraciones` AS `Configuracione` WHERE `Configuracione`.`id` = 1 LIMIT 1 | 1 | 1 | 0 | ||
SELECT `Sede`.`id`, `Sede`.`title`, `Sede`.`slug`, `Sede`.`desc`, `Sede`.`foto`, `Sede`.`thumb`, `Sede`.`telefono`, `Sede`.`fax`, `Sede`.`mail`, `Sede`.`direccion`, `Sede`.`localidad`, `Sede`.`twitter`, `Sede`.`facebook`, `Sede`.`google`, `Sede`.`linkedin` FROM `sedes` AS `Sede` WHERE `Sede`.`title` = 'Sevilla' LIMIT 1 | 1 | 1 | 1 | ||
SELECT `Administrativo`.`id`, `Administrativo`.`usuario_id`, `Administrativo`.`sede_id`, `Administrativo`.`desc`, `Administrativo`.`slug`, `Administrativo`.`created`, `Administrativo`.`modified`, `Administrativo`.`active`, `Administrativo`.`posicion` FROM `administrativos` AS `Administrativo` WHERE `Administrativo`.`sede_id` = ('9e1bf5bc-a545-11e3-96b7-812638a79f27') | 3 | 3 | 0 | ||
SELECT `Asesore`.`id`, `Asesore`.`usuario_id`, `Asesore`.`slug`, `Asesore`.`sede_id`, `Asesore`.`area`, `Asesore`.`desc`, `Asesore`.`inicio_citas`, `Asesore`.`fin_citas`, `Asesore`.`created`, `Asesore`.`modified`, `Asesore`.`active`, `Asesore`.`posicion` FROM `asesores` AS `Asesore` WHERE `Asesore`.`sede_id` = ('9e1bf5bc-a545-11e3-96b7-812638a79f27') | 8 | 8 | 0 | ||
SELECT `Publicacione`.`id`, `Publicacione`.`sede_id`, `Publicacione`.`categoria`, `Publicacione`.`title`, `Publicacione`.`slug`, `Publicacione`.`desc`, `Publicacione`.`file`, `Publicacione`.`foto`, `Publicacione`.`thumb`, `Publicacione`.`created`, `Publicacione`.`modified`, `Publicacione`.`active`, `Publicacione`.`destacado` FROM `publicaciones` AS `Publicacione` WHERE `Publicacione`.`sede_id` = ('9e1bf5bc-a545-11e3-96b7-812638a79f27') | 0 | 0 | 1 | maybe slow | |
SELECT `Estatico`.`id`, `Estatico`.`sede_id`, `Estatico`.`posicion`, `Estatico`.`title`, `Estatico`.`texto`, `Estatico`.`action`, `Estatico`.`foto`, `Estatico`.`thumb`, `Estatico`.`width`, `Estatico`.`created`, `Estatico`.`modified`, `Estatico`.`active` FROM `estaticos` AS `Estatico` WHERE `Estatico`.`sede_id` = ('9e1bf5bc-a545-11e3-96b7-812638a79f27') | 10 | 10 | 1 | maybe slow | |
SELECT `Noticia`.`id`, `Noticia`.`admin_id`, `Noticia`.`categoria_id`, `Noticia`.`sede_id`, `Noticia`.`title`, `Noticia`.`intro`, `Noticia`.`body`, `Noticia`.`slug`, `Noticia`.`foto`, `Noticia`.`thumb`, `Noticia`.`file`, `Noticia`.`video`, `Noticia`.`created`, `Noticia`.`modified`, `Noticia`.`active` FROM `contenido_noticias` AS `Noticia` WHERE `Noticia`.`sede_id` = ('9e1bf5bc-a545-11e3-96b7-812638a79f27') | 2 | 2 | 1 | maybe slow | |
SELECT `Evento`.`id`, `Evento`.`admin_id`, `Evento`.`categoria_id`, `Evento`.`sede_id`, `Evento`.`title`, `Evento`.`body`, `Evento`.`inicio`, `Evento`.`hora_inicio`, `Evento`.`fin`, `Evento`.`hora_fin`, `Evento`.`dia_completo`, `Evento`.`localizacion`, `Evento`.`slug`, `Evento`.`foto`, `Evento`.`thumb`, `Evento`.`created`, `Evento`.`modified`, `Evento`.`active` FROM `contenido_eventos` AS `Evento` WHERE `Evento`.`sede_id` = ('9e1bf5bc-a545-11e3-96b7-812638a79f27') | 0 | 0 | 0 | ||
SELECT `Configuracione`.`nombre` FROM `configuraciones` AS `Configuracione` WHERE `Configuracione`.`id` = 1 LIMIT 1 | 1 | 1 | 0 | ||
SELECT `Sede`.`id`, `Sede`.`title`, `Sede`.`slug`, `Sede`.`desc`, `Sede`.`foto`, `Sede`.`thumb`, `Sede`.`telefono`, `Sede`.`fax`, `Sede`.`mail`, `Sede`.`direccion`, `Sede`.`localidad`, `Sede`.`twitter`, `Sede`.`facebook`, `Sede`.`google`, `Sede`.`linkedin` FROM `sedes` AS `Sede` WHERE `Sede`.`title` = 'Sevilla' LIMIT 1 | 1 | 1 | 0 | ||
SELECT `Administrativo`.`id`, `Administrativo`.`usuario_id`, `Administrativo`.`sede_id`, `Administrativo`.`desc`, `Administrativo`.`slug`, `Administrativo`.`created`, `Administrativo`.`modified`, `Administrativo`.`active`, `Administrativo`.`posicion` FROM `administrativos` AS `Administrativo` WHERE `Administrativo`.`sede_id` = ('9e1bf5bc-a545-11e3-96b7-812638a79f27') | 3 | 3 | 0 | ||
SELECT `Asesore`.`id`, `Asesore`.`usuario_id`, `Asesore`.`slug`, `Asesore`.`sede_id`, `Asesore`.`area`, `Asesore`.`desc`, `Asesore`.`inicio_citas`, `Asesore`.`fin_citas`, `Asesore`.`created`, `Asesore`.`modified`, `Asesore`.`active`, `Asesore`.`posicion` FROM `asesores` AS `Asesore` WHERE `Asesore`.`sede_id` = ('9e1bf5bc-a545-11e3-96b7-812638a79f27') | 8 | 8 | 1 | maybe slow | |
SELECT `Publicacione`.`id`, `Publicacione`.`sede_id`, `Publicacione`.`categoria`, `Publicacione`.`title`, `Publicacione`.`slug`, `Publicacione`.`desc`, `Publicacione`.`file`, `Publicacione`.`foto`, `Publicacione`.`thumb`, `Publicacione`.`created`, `Publicacione`.`modified`, `Publicacione`.`active`, `Publicacione`.`destacado` FROM `publicaciones` AS `Publicacione` WHERE `Publicacione`.`sede_id` = ('9e1bf5bc-a545-11e3-96b7-812638a79f27') | 0 | 0 | 1 | maybe slow | |
SELECT `Estatico`.`id`, `Estatico`.`sede_id`, `Estatico`.`posicion`, `Estatico`.`title`, `Estatico`.`texto`, `Estatico`.`action`, `Estatico`.`foto`, `Estatico`.`thumb`, `Estatico`.`width`, `Estatico`.`created`, `Estatico`.`modified`, `Estatico`.`active` FROM `estaticos` AS `Estatico` WHERE `Estatico`.`sede_id` = ('9e1bf5bc-a545-11e3-96b7-812638a79f27') | 10 | 10 | 1 | maybe slow | |
SELECT `Noticia`.`id`, `Noticia`.`admin_id`, `Noticia`.`categoria_id`, `Noticia`.`sede_id`, `Noticia`.`title`, `Noticia`.`intro`, `Noticia`.`body`, `Noticia`.`slug`, `Noticia`.`foto`, `Noticia`.`thumb`, `Noticia`.`file`, `Noticia`.`video`, `Noticia`.`created`, `Noticia`.`modified`, `Noticia`.`active` FROM `contenido_noticias` AS `Noticia` WHERE `Noticia`.`sede_id` = ('9e1bf5bc-a545-11e3-96b7-812638a79f27') | 2 | 2 | 1 | maybe slow | |
SELECT `Evento`.`id`, `Evento`.`admin_id`, `Evento`.`categoria_id`, `Evento`.`sede_id`, `Evento`.`title`, `Evento`.`body`, `Evento`.`inicio`, `Evento`.`hora_inicio`, `Evento`.`fin`, `Evento`.`hora_fin`, `Evento`.`dia_completo`, `Evento`.`localizacion`, `Evento`.`slug`, `Evento`.`foto`, `Evento`.`thumb`, `Evento`.`created`, `Evento`.`modified`, `Evento`.`active` FROM `contenido_eventos` AS `Evento` WHERE `Evento`.`sede_id` = ('9e1bf5bc-a545-11e3-96b7-812638a79f27') | 0 | 0 | 1 | maybe slow | |
SELECT `Configuracione`.`nombre` FROM `configuraciones` AS `Configuracione` WHERE `Configuracione`.`id` = 1 LIMIT 1 | 1 | 1 | 0 | ||
SELECT `Configuracione`.`nombre` FROM `configuraciones` AS `Configuracione` WHERE `Configuracione`.`id` = 1 LIMIT 1 | 1 | 1 | 0 |
Peak Memory Use 11.22 MB
Message | Memory use |
---|---|
Component initialization | 7.51 MB |
Controller action start | 7.57 MB |
Controller render start | 7.65 MB |
Component initialization #2 | 9.05 MB |
Controller action start #2 | 9.06 MB |
Component initialization #3 | 9.20 MB |
Controller action start #3 | 9.22 MB |
Component initialization #4 | 9.41 MB |
Controller action start #4 | 9.42 MB |
Component initialization #5 | 9.97 MB |
Controller action start #5 | 9.99 MB |
Component initialization #6 | 10.04 MB |
Controller action start #6 | 10.05 MB |
Component initialization #7 | 10.20 MB |
Controller action start #7 | 10.21 MB |
Component initialization #8 | 10.18 MB |
Controller action start #8 | 10.19 MB |
View render complete | 10.12 MB |
Total Request Time: 745 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived) | 399.33 | |
Component initialization and startup | 21.06 | |
Controller action | 13.95 | |
Render Controller Action | 208.08 | |
» Rendering View | 200.71 | |
» » Rendering APP/views/publicaciones/view.ctp | 27.78 | |
» » Rendering APP/views/layouts/default.ctp | 172.20 | |
» » » Component initialization and startup #2 | 8.28 | |
Controller action #2 | 0.00 | |
» » » » Rendering APP/views/elements/metatags.ctp | 0.49 | |
» » » » Rendering APP/views/elements/analytics.ctp | 0.31 | |
» » » » Rendering APP/views/elements/cookies.ctp | 1.17 | |
» » » » Rendering APP/views/elements/header.ctp | 138.29 | |
» » » » » Component initialization and startup #3 | 8.79 | |
Controller action #3 | 0.00 | |
» » » » » » Component initialization and startup #4 | 8.73 | |
Controller action #4 | 0.00 | |
» » » » » » » Rendering APP/views/elements/menu.ctp | 97.37 | |
» » » » » » » » Component initialization and startup #5 | 11.15 | |
Controller action #5 | 0.00 | |
» » » » » » » » » Component initialization and startup #6 | 9.27 | |
Controller action #6 | 0.00 | |
» » » » » » » » » » Component initialization and startup #7 | 12.97 | |
Controller action #7 | 0.00 | |
» » » » » » » » » Rendering APP/views/elements/footer.ctp | 15.63 | |
» » » » » » » » » » Component initialization and startup #8 | 8.95 | |
Controller action #8 | 0.00 |