Query Metrics
6
Database Queries
6
Different statements
23.57 ms
Query time
0
Invalid entities
10
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
16.81 ms (71.34%) |
1 |
SELECT t0.nombre AS nombre_1, t0.original AS original_2, t0.peso AS peso_3, t0.id AS id_4, t0.proyecto_id AS proyecto_id_5 FROM documento_proyecto t0 WHERE t0.proyecto_id = ?
Parameters:
[
2
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (8.42%) |
1 |
SELECT t0.id AS id_1, t0.nombre_fiscal AS nombre_fiscal_2, t0.nombre_comercial AS nombre_comercial_3, t0.nif AS nif_4, t0.actividad_empresarial AS actividad_empresarial_5, t0.nombre_representante_legal AS nombre_representante_legal_6, t0.cargo_representante_legal AS cargo_representante_legal_7, t0.telefono_representante_legal AS telefono_representante_legal_8, t0.fecha_creacion AS fecha_creacion_9, t0.fecha_incorporacion_cluster AS fecha_incorporacion_cluster_10, t0.email AS email_11, t0.email_comercial AS email_comercial_12, t0.pagina_web AS pagina_web_13, t0.video_promocional AS video_promocional_14, t0.logo AS logo_15, t0.personal_laboral AS personal_laboral_16, t0.personal_laboral_mujeres AS personal_laboral_mujeres_17, t0.personal_laboral_hombres AS personal_laboral_hombres_18, t0.volumen_facturacion_anual AS volumen_facturacion_anual_19, t0.sello_pyme_innovadora AS sello_pyme_innovadora_20, t0.caducidad_sello_pyme_innovadora AS caducidad_sello_pyme_innovadora_21, t0.deducciones_fiscales AS deducciones_fiscales_22, t0.proveedor_homologado AS proveedor_homologado_23, t0.dispone_certificacion AS dispone_certificacion_24, t0.visible AS visible_25, t0.facebook AS facebook_26, t0.linkedin AS linkedin_27, t0.instagram AS instagram_28, t0.twitter AS twitter_29, t0.deshabilitar AS deshabilitar_30, t0.tipo_empresa_id AS tipo_empresa_id_31 FROM empresa t0 WHERE t0.id = ?
Parameters:
[
23
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (6.59%) |
1 |
SELECT e0_.id AS id_0, e0_.nombre_fiscal AS nombre_fiscal_1, e0_.nombre_comercial AS nombre_comercial_2, e0_.nif AS nif_3, e0_.actividad_empresarial AS actividad_empresarial_4, e0_.nombre_representante_legal AS nombre_representante_legal_5, e0_.cargo_representante_legal AS cargo_representante_legal_6, e0_.telefono_representante_legal AS telefono_representante_legal_7, e0_.fecha_creacion AS fecha_creacion_8, e0_.fecha_incorporacion_cluster AS fecha_incorporacion_cluster_9, e0_.email AS email_10, e0_.email_comercial AS email_comercial_11, e0_.pagina_web AS pagina_web_12, e0_.video_promocional AS video_promocional_13, e0_.logo AS logo_14, e0_.personal_laboral AS personal_laboral_15, e0_.personal_laboral_mujeres AS personal_laboral_mujeres_16, e0_.personal_laboral_hombres AS personal_laboral_hombres_17, e0_.volumen_facturacion_anual AS volumen_facturacion_anual_18, e0_.sello_pyme_innovadora AS sello_pyme_innovadora_19, e0_.caducidad_sello_pyme_innovadora AS caducidad_sello_pyme_innovadora_20, e0_.deducciones_fiscales AS deducciones_fiscales_21, e0_.proveedor_homologado AS proveedor_homologado_22, e0_.dispone_certificacion AS dispone_certificacion_23, e0_.visible AS visible_24, e0_.facebook AS facebook_25, e0_.linkedin AS linkedin_26, e0_.instagram AS instagram_27, e0_.twitter AS twitter_28, e0_.deshabilitar AS deshabilitar_29, e0_.tipo_empresa_id AS tipo_empresa_id_30 FROM empresa e0_ WHERE e0_.visible = 1 AND (e0_.deshabilitar = 0 OR e0_.deshabilitar IS NULL) ORDER BY e0_.id DESC LIMIT 4
Parameters:
[]
|
||||||||||||||||||||||||||||||
|
1.51 ms (6.42%) |
1 |
SELECT t0.nombre AS nombre_1, t0.original AS original_2, t0.peso AS peso_3, t0.id AS id_4, t0.proyecto_id AS proyecto_id_5 FROM imagen_proyecto t0 WHERE t0.proyecto_id = ?
Parameters:
[
2
]
|
||||||||||||||||||||||||||||||
|
1.09 ms (4.63%) |
1 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.fecha AS fecha_4, t0.subvencionado AS subvencionado_5, t0.url AS url_6, t0.observaciones AS observaciones_7, t0.colaboracion AS colaboracion_8, t0.fecha_publica AS fecha_publica_9, t0.visible AS visible_10, t0.empresa_id AS empresa_id_11, t0.trl_id AS trl_id_12, t0.convocatoria_id AS convocatoria_id_13 FROM proyecto t0 WHERE t0.id = ?
Parameters:
[
"2"
]
|
||||||||||||||||||||||||||||||
|
0.61 ms (2.60%) |
1 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.fecha AS fecha_4, t0.subvencionado AS subvencionado_5, t0.url AS url_6, t0.observaciones AS observaciones_7, t0.colaboracion AS colaboracion_8, t0.fecha_publica AS fecha_publica_9, t0.visible AS visible_10, t0.empresa_id AS empresa_id_11, t0.trl_id AS trl_id_12, t0.convocatoria_id AS convocatoria_id_13 FROM proyecto t0 WHERE t0.empresa_id = ?
Parameters:
[
23
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Empresa | 5 |
| App\Entity\TipoEmpresa | 3 |
| App\Entity\Proyecto | 1 |
| App\Entity\Trl | 1 |