GET https://areaprivada.marlocertificaciones.com/

Query Metrics

5 Database Queries
4 Different statements
2.29 ms Query time
2 Invalid entities
20 Managed entities

Queries

Group similar statements

# Time Info
1 0.95 ms
SELECT t0.id AS id_1, t0.fecha_convocatoria AS fecha_convocatoria_2, t0.fecha_documentacion AS fecha_documentacion_3, t0.referencia AS referencia_4, t0.estado AS estado_5, t0.visible AS visible_6, t0.solicitudes_max AS solicitudes_max_7, t0.texto_documentacion AS texto_documentacion_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.certificacion_id AS certificacion_id_11, t0.centro_id AS centro_id_12, t0.documento_id AS documento_id_13, t0.acta_id AS acta_id_14 FROM convocatoria t0
Parameters:
[]
2 0.42 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.referencia AS referencia_3, t0.texto AS texto_4, t0.deleted_at AS deleted_at_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM certificacion t0 WHERE t0.id = ?
Parameters:
[
  1
]
3 0.23 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.referencia AS referencia_3, t0.domicilio AS domicilio_4, t0.poblacion AS poblacion_5, t0.usuario_id AS usuario_id_6 FROM centro t0 WHERE t0.id = ?
Parameters:
[
  1
]
4 0.38 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.filename_original AS filename_original_3, t0.view_filename AS view_filename_4, t0.path AS path_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.certificacion_id AS certificacion_id_8, t9.id AS id_10, t9.fecha_convocatoria AS fecha_convocatoria_11, t9.fecha_documentacion AS fecha_documentacion_12, t9.referencia AS referencia_13, t9.estado AS estado_14, t9.visible AS visible_15, t9.solicitudes_max AS solicitudes_max_16, t9.texto_documentacion AS texto_documentacion_17, t9.created_at AS created_at_18, t9.updated_at AS updated_at_19, t9.certificacion_id AS certificacion_id_20, t9.centro_id AS centro_id_21, t9.documento_id AS documento_id_22, t9.acta_id AS acta_id_23, t0.categoria_id AS categoria_id_24, t25.id AS id_26, t25.numero_certificado AS numero_certificado_27, t25.fecha_expedicion AS fecha_expedicion_28, t25.fecha_renovacion AS fecha_renovacion_29, t25.fecha_caducidad AS fecha_caducidad_30, t25.created_at AS created_at_31, t25.updated_at AS updated_at_32, t25.certificacion_id AS certificacion_id_33, t25.profesional_id AS profesional_id_34, t25.documento_id AS documento_id_35 FROM documento t0 LEFT JOIN convocatoria t9 ON t9.documento_id = t0.id LEFT JOIN certificado t25 ON t25.documento_id = t0.id WHERE t0.id = ?
Parameters:
[
  9
]
5 0.31 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.filename_original AS filename_original_3, t0.view_filename AS view_filename_4, t0.path AS path_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.certificacion_id AS certificacion_id_8, t9.id AS id_10, t9.fecha_convocatoria AS fecha_convocatoria_11, t9.fecha_documentacion AS fecha_documentacion_12, t9.referencia AS referencia_13, t9.estado AS estado_14, t9.visible AS visible_15, t9.solicitudes_max AS solicitudes_max_16, t9.texto_documentacion AS texto_documentacion_17, t9.created_at AS created_at_18, t9.updated_at AS updated_at_19, t9.certificacion_id AS certificacion_id_20, t9.centro_id AS centro_id_21, t9.documento_id AS documento_id_22, t9.acta_id AS acta_id_23, t0.categoria_id AS categoria_id_24, t25.id AS id_26, t25.numero_certificado AS numero_certificado_27, t25.fecha_expedicion AS fecha_expedicion_28, t25.fecha_renovacion AS fecha_renovacion_29, t25.fecha_caducidad AS fecha_caducidad_30, t25.created_at AS created_at_31, t25.updated_at AS updated_at_32, t25.certificacion_id AS certificacion_id_33, t25.profesional_id AS profesional_id_34, t25.documento_id AS documento_id_35 FROM documento t0 LEFT JOIN convocatoria t9 ON t9.documento_id = t0.id LEFT JOIN certificado t25 ON t25.documento_id = t0.id WHERE t0.id = ?
Parameters:
[
  10
]

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\Convocatoria 6
App\Entity\Documento 6
App\Entity\Centro 3
App\Entity\Certificacion 2
App\Entity\Acta 1
App\Entity\Usuario 1
App\Entity\Categoria 1

Entities Mapping

Class Mapping errors
App\Entity\Convocatoria No errors.
App\Entity\Certificacion No errors.
App\Entity\Centro No errors.
App\Entity\Documento
  • The field App\Entity\Documento#convocatoria is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Convocatoria#documento does not contain the required 'inversedBy="convocatoria"' attribute.
  • The field App\Entity\Documento#certificado is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Certificado#documento does not contain the required 'inversedBy="certificado"' attribute.
App\Entity\Acta
  • The field App\Entity\Acta#convocatoria is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Convocatoria#acta does not contain the required 'inversedBy="convocatoria"' attribute.
App\Entity\Plaza No errors.
Sonata\UserBundle\Entity\BaseUser3 No errors.
App\Entity\Usuario No errors.
App\Entity\EmailAvisoEnviado No errors.
App\Entity\Interes No errors.
App\Entity\Certificado No errors.
App\Entity\Categoria No errors.