Query Metrics
7
Database Queries
6
Different statements
2.84 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.55 ms |
SELECT t0.pagina_id AS pagina_id_1, t0.titulo AS titulo_2, t0.descripcion AS descripcion_3, t0.url AS url_4, t0.tags AS tags_5, t0.empresa_id AS empresa_id_6 FROM seo_on_page t0 WHERE t0.url = ? LIMIT 1
Parameters:
[
"listadoblog"
]
|
2 | 0.52 ms |
SELECT b0_.blog_id AS blog_id_0, b0_.nombre AS nombre_1, b0_.descripcion AS descripcion_2, b0_.titulo AS titulo_3, b0_.descripcion_seo AS descripcion_seo_4, b0_.tags AS tags_5, b0_.imagen AS imagen_6, b0_.estado AS estado_7, b0_.url AS url_8, b0_.created_at AS created_at_9, b0_.updated_at AS updated_at_10, b0_.empresa_id AS empresa_id_11, b0_.autor_id AS autor_id_12 FROM blog b0_ LEFT JOIN empresa e1_ ON b0_.empresa_id = e1_.empresa_id WHERE b0_.estado = 1 AND e1_.empresa_id = ? ORDER BY b0_.created_at DESC
Parameters:
[
"1"
]
|
3 | 0.29 ms |
SELECT b0_.id AS id_0, b0_.imagen AS imagen_1, b0_.blog_id AS blog_id_2 FROM blog_imagen b0_ LEFT JOIN blog b1_ ON b0_.blog_id = b1_.blog_id WHERE b1_.blog_id = ? ORDER BY b0_.id ASC
Parameters:
[
3
]
|
4 | 0.35 ms |
SELECT t0.usuario_id AS usuario_id_1, t0.nombre AS nombre_2, t0.apellidos AS apellidos_3, t0.email AS email_4, t0.telefono AS telefono_5, t0.password AS password_6, t0.habilitado AS habilitado_7, t0.fecharegistro AS fecharegistro_8, t0.fechaultimologin AS fechaultimologin_9, t0.rol_id AS rol_id_10, t0.empresa_id AS empresa_id_11 FROM usuario t0 WHERE t0.usuario_id = ?
Parameters:
[
1
]
|
5 | 0.33 ms |
SELECT b0_.id AS id_0, b0_.imagen AS imagen_1, b0_.blog_id AS blog_id_2 FROM blog_imagen b0_ LEFT JOIN blog b1_ ON b0_.blog_id = b1_.blog_id WHERE b1_.blog_id = ? ORDER BY b0_.id ASC
Parameters:
[
1
]
|
6 | 0.35 ms |
SELECT t0.empresa_id AS empresa_id_1, t0.nombre AS nombre_2, t0.direccion AS direccion_3, t0.ciudad AS ciudad_4, t0.estado AS estado_5, t0.codigo_postal AS codigo_postal_6, t0.email AS email_7, t0.telefono AS telefono_8, t0.logo AS logo_9, t0.url AS url_10 FROM empresa t0 WHERE t0.empresa_id = ?
Parameters:
[
1
]
|
7 | 0.45 ms |
SELECT r0_.redsocial_id AS redsocial_id_0, r0_.facebook AS facebook_1, r0_.activarfacebook AS activarfacebook_2, r0_.youtube AS youtube_3, r0_.activaryoutube AS activaryoutube_4, r0_.twitter AS twitter_5, r0_.activartwitter AS activartwitter_6, r0_.flickr AS flickr_7, r0_.activarflickr AS activarflickr_8, r0_.instagram AS instagram_9, r0_.activarinstagram AS activarinstagram_10, r0_.linkedin AS linkedin_11, r0_.activarlinkedin AS activarlinkedin_12, r0_.soundcloud AS soundcloud_13, r0_.activarsoundcloud AS activarsoundcloud_14, r0_.tumblr AS tumblr_15, r0_.activartumblr AS activartumblr_16, r0_.vimeo AS vimeo_17, r0_.activarvimeo AS activarvimeo_18, r0_.google AS google_19, r0_.activargoogle AS activargoogle_20, r0_.empresa_id AS empresa_id_21 FROM redsocial r0_ LEFT JOIN empresa e1_ ON r0_.empresa_id = e1_.empresa_id WHERE e1_.empresa_id = ?
Parameters:
[
"1"
]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\SeoOnPage | No errors. |
App\Entity\Empresa | No errors. |
App\Entity\Blog | No errors. |
App\Entity\Usuario | No errors. |
App\Entity\BlogImagen | No errors. |
App\Entity\Rol | No errors. |
App\Entity\Redsocial | No errors. |