Query Metrics
7
Database Queries
7
Different statements
1599.65 ms
Query time
0
Invalid entities
5
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1591.48 ms |
SELECT t0.id AS id_1, t0.nombrecliente AS nombrecliente_2, t0.nombres AS nombres_3, t0.apellidos AS apellidos_4, t0.codpostalcliente AS codpostalcliente_5, t0.direccioncliente AS direccioncliente_6, t0.latitud AS latitud_7, t0.longitud AS longitud_8, t0.poblacioncliente AS poblacioncliente_9, t0.provinciacliente AS provinciacliente_10, t0.paiscliente AS paiscliente_11, t0.telefonocliente AS telefonocliente_12, t0.telefono2cliente AS telefono2cliente_13, t0.movilcliente AS movilcliente_14, t0.emailcliente AS emailcliente_15, t0.codmonedaminuta AS codmonedaminuta_16, t0.nifcliente AS nifcliente_17, t0.zona AS zona_18, t0.fechareserva AS fechareserva_19, t0.codcliente AS codcliente_20, t0.direccion2cliente AS direccion2cliente_21, t0.total AS total_22, t0.totalsiniva AS totalsiniva_23, t0.sucursal AS sucursal_24, t0.comentario AS comentario_25, t0.is_finalizada AS is_finalizada_26, t0.metododepago AS metododepago_27, t0.tipodeservicio AS tipodeservicio_28, t0.is_enviado AS is_enviado_29, t0.filename AS filename_30, t0.estado AS estado_31, t0.propinatotal AS propinatotal_32, t0.propinaporcentaje AS propinaporcentaje_33, t0.linkdepago AS linkdepago_34, t0.facturaelectronica AS facturaelectronica_35, t0.DIRECCION_2 AS DIRECCION_2_36, t0.NOMBRE_1 AS NOMBRE_1_37, t0.OTROS_NOMBRES AS OTROS_NOMBRES_38, t0.APELLIDO_1 AS APELLIDO_1_39, t0.APELLIDO_2 AS APELLIDO_2_40, t0.FE_MUNICIPIO AS FE_MUNICIPIO_41, t0.FE_RESPONSABILIDADES AS FE_RESPONSABILIDADES_42, t0.TIPO_DE_DOCUMENTO AS TIPO_DE_DOCUMENTO_43, t0.TIPOPERSONA AS TIPOPERSONA_44, t0.FE_REGIMEN AS FE_REGIMEN_45, t0.FE_DET_TRIBUTARIO AS FE_DET_TRIBUTARIO_46, t0.CUENTA_ALIMENTACION AS CUENTA_ALIMENTACION_47, t0.CENTRO_COSTOS AS CENTRO_COSTOS_48, t0.CENTRO_OPERACION AS CENTRO_OPERACION_49, t0.alias AS alias_50, t0.email_linkdepago AS email_linkdepago_51, t0.nombre_receptor AS nombre_receptor_52, t0.telefono_receptor AS telefono_receptor_53, t0.observaciones_receptor AS observaciones_receptor_54, t0.connector_order_id AS connector_order_id_55, t0.created_at AS created_at_56, t0.updated_at AS updated_at_57, t0.user_id AS user_id_58, t0.connector_store_id AS connector_store_id_59 FROM cabecera t0 WHERE t0.connector_order_id = ? LIMIT 1
Parameters:
[
"0f1519d1-aeff-4407-91d7-a79e3a1e1cc5"
]
|
| 2 | 0.83 ms |
SELECT t0.id AS id_1, t0.connector_order_id AS connector_order_id_2, t0.status AS status_3, t0.webhook_data AS webhook_data_4, t0.event_id AS event_id_5, t0.received_at AS received_at_6, t0.cabecera_id AS cabecera_id_7 FROM connector_order_status t0 WHERE t0.cabecera_id = ? AND t0.connector_order_id = ? ORDER BY t0.received_at DESC LIMIT 1
Parameters:
[ 330715 "0f1519d1-aeff-4407-91d7-a79e3a1e1cc5" ] |
| 3 | 0.17 ms |
"START TRANSACTION"
Parameters:
[] |
| 4 | 0.55 ms |
INSERT INTO connector_order_status (connector_order_id, status, webhook_data, event_id, received_at, cabecera_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters:
[ "0f1519d1-aeff-4407-91d7-a79e3a1e1cc5" "ERROR" "{"orderId":"0f1519d1-aeff-4407-91d7-a79e3a1e1cc5","channelOrderId":"330715","status":"ERROR","date":"2025-10-29T14:35:48.076Z","creator":"frontrest","notes":"","createdAt":"2025-10-29T14:35:48.206Z"}" "31d5ff66-a1c6-4b53-a7e9-d506318fbd2e" "2025-10-29 09:35:51" 330715 ] |
| 5 | 4.54 ms |
INSERT INTO cabecera_status (estado, created_at, updated_at, user_id, cabecera_id) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "ERROR" "2025-10-29 09:35:51" null null 330715 ] |
| 6 | 0.41 ms |
UPDATE cabecera SET is_enviado = ?, estado = ?, updated_at = ? WHERE id = ?
Parameters:
[ 1 "ERROR" "2025-10-29 09:35:51" 330715 ] |
| 7 | 1.67 ms |
"COMMIT"
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Cabecera | 1 |
| App\Entity\User | 1 |
| App\Entity\ConnectorStore | 1 |
| App\Entity\ConnectorOrderStatus | 1 |
| App\Entity\CabeceraStatus | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Cabecera | No errors. |
| App\Entity\User | No errors. |
| App\Entity\ConnectorStore | No errors. |
| App\Entity\Lineas | No errors. |
| App\Entity\CabeceraStatus | No errors. |
| App\Entity\Domicilios | No errors. |
| App\Entity\CabeceraLinkdepago | No errors. |
| App\Entity\ConnectorOrderStatus | No errors. |