Query Metrics
414
Database Queries
10
Different statements
92.38 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
86.49 ms (93.62%) |
405 |
SELECT t0.tipoid AS tipoid_1, t0.numid AS numid_2, t0.nombresrazonsocial AS nombresrazonsocial_3, t0.datosregistro AS datosregistro_4, t0.direccion AS direccion_5, t0.codarea1 AS codarea1_6, t0.numero1 AS numero1_7, t0.codarea2 AS codarea2_8, t0.numero2 AS numero2_9, t0.email AS email_10, t0.edad AS edad_11, t0.sexo AS sexo_12, t0.fechanacimiento AS fechanacimiento_13, t0.id AS id_14 FROM clientes t0 WHERE t0.id = ?
Parameters:
[
659
]
|
1.75 ms (1.90%) |
1 |
SELECT t0.patologia AS patologia_1, t0.sessionid AS sessionid_2, t0.indtitular AS indtitular_3, t0.fecharegistro AS fecharegistro_4, t0.fechaexclusion AS fechaexclusion_5, t0.ncertificado AS ncertificado_6, t0.estatus AS estatus_7, t0.fechaingreso AS fechaingreso_8, t0.id AS id_9, t0.contratos_id AS contratos_id_10, t0.cotizaciones_id AS cotizaciones_id_11, t0.clientes_id AS clientes_id_12 FROM afiliados t0 WHERE t0.contratos_id = ?
Parameters:
[
243
]
|
1.46 ms (1.58%) |
1 |
SELECT t0.tipoid AS tipoid_1, t0.numid AS numid_2, t0.fecharegistro AS fecharegistro_3, t0.fechaestatus AS fechaestatus_4, t0.fechadesde AS fechadesde_5, t0.fechahasta AS fechahasta_6, t0.ncertificado AS ncertificado_7, t0.estatus AS estatus_8, t0.fechaproximafacturacion AS fechaproximafacturacion_9, t0.fechaanulacion AS fechaanulacion_10, t0.causaanulacion AS causaanulacion_11, t0.id AS id_12, t0.contratos_id AS contratos_id_13 FROM certificados t0 WHERE t0.contratos_id = ?
Parameters:
[
243
]
|
0.97 ms (1.05%) |
1 |
SELECT t0.fecharegistro AS fecharegistro_1, t0.observacion AS observacion_2, t0.fechaestatus AS fechaestatus_3, t0.indservicioconrecibopendiente AS indservicioconrecibopendiente_4, t0.vip AS vip_5, t0.id AS id_6, t0.clientes_id AS clientes_id_7, t0.tipofacturacion_id AS tipofacturacion_id_8, t0.formaspago_id AS formaspago_id_9, t0.monedas_id AS monedas_id_10, t0.tiporiesgo_id AS tiporiesgo_id_11, t0.tipocontrato_id AS tipocontrato_id_12, t0.usuarios_id AS usuarios_id_13, t0.cotizaciones_id AS cotizaciones_id_14, t0.estatuscontratos_id AS estatuscontratos_id_15, t0.tipovigencias_id AS tipovigencias_id_16 FROM contratos t0 WHERE t0.id = ?
Parameters:
[
"243"
]
|
0.34 ms (0.37%) |
1 |
SELECT t0.descripcion AS descripcion_1, t0.estatus AS estatus_2, t0.id AS id_3 FROM formaspago t0 WHERE t0.id = ?
Parameters:
[
4
]
|
0.31 ms (0.34%) |
1 |
SELECT t0.descripcion AS descripcion_1, t0.estatus AS estatus_2, t0.id AS id_3 FROM tipofacturacion t0 WHERE t0.id = ?
Parameters:
[
1
]
|
0.30 ms (0.33%) |
1 |
SELECT t0.descripcion AS descripcion_1, t0.estatus AS estatus_2, t0.id AS id_3 FROM tipovigencias t0 WHERE t0.id = ?
Parameters:
[
1
]
|
0.28 ms (0.30%) |
1 |
SELECT t0.descripcion AS descripcion_1, t0.estatus AS estatus_2, t0.id AS id_3 FROM tipocontrato t0 WHERE t0.id = ?
Parameters:
[
2
]
|
0.25 ms (0.27%) |
1 |
SELECT t0.descripcion AS descripcion_1, t0.estatus AS estatus_2, t0.id AS id_3 FROM monedas t0 WHERE t0.id = ?
Parameters:
[
2
]
|
0.23 ms (0.25%) |
1 |
SELECT t0.descripcion AS descripcion_1, t0.estatus AS estatus_2, t0.id AS id_3 FROM estatuscontratos t0 WHERE t0.id = ?
Parameters:
[
2
]
|
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\Contratos | No errors. |
App\Entity\Clientes | No errors. |
App\Entity\Tipofacturacion | No errors. |
App\Entity\Formaspago | No errors. |
App\Entity\Monedas | No errors. |
App\Entity\Tiporiesgo | No errors. |
App\Entity\Tipocontrato | No errors. |
App\Entity\Usuarios | No errors. |
App\Entity\Cotizaciones | No errors. |
App\Entity\Estatuscontratos | No errors. |
App\Entity\Tipovigencias | No errors. |
App\Entity\Afiliados | No errors. |
App\Entity\Certificados | No errors. |