Query Metrics
10
Database Queries
8
Different statements
9.50 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
6.12 ms (64.41%) |
2 |
"COMMIT"
Parameters:
[] |
0.84 ms (8.84%) |
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 = ? AND t0.ncertificado = ?
Parameters:
[ 243 "13822510" ] |
0.80 ms (8.41%) |
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.52 ms (5.43%) |
1 |
UPDATE certificados SET fechaestatus = ?, estatus = ?, fechaanulacion = ?, causaanulacion = ? WHERE id = ?
Parameters:
[ "2025-01-17 18:19:16" "2" "2025-01-17 18:19:16" "01" 5659 ] |
0.42 ms (4.41%) |
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 = ? AND t0.ncertificado = ? AND t0.numid = ? LIMIT 1
Parameters:
[ 243 "13822510" "13822510" ] |
0.29 ms (3.10%) |
1 |
UPDATE afiliados SET fechaexclusion = ?, estatus = ? WHERE id = ?
Parameters:
[ "2025-01-17" "2" 7622 ] |
0.27 ms (2.88%) |
1 |
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:
[
"3050"
]
|
0.24 ms (2.51%) |
2 |
"START TRANSACTION"
Parameters:
[] |
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\Certificados | No errors. |
App\Entity\Cotestatus | No errors. |
App\Entity\Preguntasdesafio | No errors. |
App\Entity\Proveedores | No errors. |
App\Entity\Tipousuarios | No errors. |
App\Entity\Afiliados | No errors. |