Query Metrics
6
Database Queries
6
Different statements
1.48 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.22 ms |
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.nombre AS nombre_5, t0.codvendedor AS codvendedor_6, t0.is_enabled AS is_enabled_7 FROM user t0 WHERE t0.id = ?
Parameters:
[
14
]
|
| 2 | 0.36 ms |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.lat AS lat_3, t0.lng AS lng_4, t0.poligono AS poligono_5, t0.color AS color_6, t0.mon_open_at AS mon_open_at_7, t0.mon_closed_at AS mon_closed_at_8, t0.tue_open_at AS tue_open_at_9, t0.tue_closed_at AS tue_closed_at_10, t0.wed_open_at AS wed_open_at_11, t0.wed_closed_at AS wed_closed_at_12, t0.thu_open_at AS thu_open_at_13, t0.thu_closed_at AS thu_closed_at_14, t0.fri_open_at AS fri_open_at_15, t0.fri_closed_at AS fri_closed_at_16, t0.sat_open_at AS sat_open_at_17, t0.sat_closed_at AS sat_closed_at_18, t0.sun_open_at AS sun_open_at_19, t0.sun_closed_at AS sun_closed_at_20, t0.is_enabled AS is_enabled_21, t0.is_enabled_programming AS is_enabled_programming_22, t0.is_enabled_reservation AS is_enabled_reservation_23, t0.is_active AS is_active_24, t0.delivery_capacity AS delivery_capacity_25, t0.number_delivery_men AS number_delivery_men_26, t0.codalmvent AS codalmvent_27, t0.server AS server_28, t0.server_db AS server_db_29, t0.server_user AS server_user_30, t0.server_pass AS server_pass_31 FROM sucursal t0
Parameters:
[] |
| 3 | 0.35 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.poblacioncliente AS poblacioncliente_7, t0.provinciacliente AS provinciacliente_8, t0.paiscliente AS paiscliente_9, t0.telefonocliente AS telefonocliente_10, t0.telefono2cliente AS telefono2cliente_11, t0.movilcliente AS movilcliente_12, t0.emailcliente AS emailcliente_13, t0.codmonedaminuta AS codmonedaminuta_14, t0.nifcliente AS nifcliente_15, t0.zona AS zona_16, t0.fechareserva AS fechareserva_17, t0.codcliente AS codcliente_18, t0.direccion2cliente AS direccion2cliente_19, t0.total AS total_20, t0.totalsiniva AS totalsiniva_21, t0.sucursal AS sucursal_22, t0.comentario AS comentario_23, t0.is_finalizada AS is_finalizada_24, t0.metododepago AS metododepago_25, t0.tipodeservicio AS tipodeservicio_26, t0.is_enviado AS is_enviado_27, t0.filename AS filename_28, t0.estado AS estado_29, t0.propinatotal AS propinatotal_30, t0.propinaporcentaje AS propinaporcentaje_31, t0.linkdepago AS linkdepago_32, t0.facturaelectronica AS facturaelectronica_33, t0.DIRECCION_2 AS DIRECCION_2_34, t0.NOMBRE_1 AS NOMBRE_1_35, t0.OTROS_NOMBRES AS OTROS_NOMBRES_36, t0.APELLIDO_1 AS APELLIDO_1_37, t0.APELLIDO_2 AS APELLIDO_2_38, t0.FE_MUNICIPIO AS FE_MUNICIPIO_39, t0.FE_RESPONSABILIDADES AS FE_RESPONSABILIDADES_40, t0.TIPO_DE_DOCUMENTO AS TIPO_DE_DOCUMENTO_41, t0.TIPOPERSONA AS TIPOPERSONA_42, t0.FE_REGIMEN AS FE_REGIMEN_43, t0.FE_DET_TRIBUTARIO AS FE_DET_TRIBUTARIO_44, t0.CUENTA_ALIMENTACION AS CUENTA_ALIMENTACION_45, t0.CENTRO_COSTOS AS CENTRO_COSTOS_46, t0.CENTRO_OPERACION AS CENTRO_OPERACION_47, t0.alias AS alias_48, t0.email_linkdepago AS email_linkdepago_49, t0.nombre_receptor AS nombre_receptor_50, t0.telefono_receptor AS telefono_receptor_51, t0.observaciones_receptor AS observaciones_receptor_52, t0.created_at AS created_at_53, t0.updated_at AS updated_at_54, t0.user_id AS user_id_55 FROM cabecera t0 WHERE t0.id = ?
Parameters:
[
"347662"
]
|
| 4 | 0.18 ms |
SELECT t0.id AS id_1, t0.estado AS estado_2, t0.linkdepago AS linkdepago_3, t0.comentario AS comentario_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.cabecera_id AS cabecera_id_7 FROM cabecera_linkdepago t0 WHERE t0.cabecera_id = ?
Parameters:
[
347662
]
|
| 5 | 0.22 ms |
SELECT t0.id AS id_1, t0.create_at AS create_at_2, t0.codarticulo AS codarticulo_3, t0.descripcion AS descripcion_4, t0.codfavorito AS codfavorito_5, t0.precio AS precio_6, t0.preciosiniva AS preciosiniva_7, t0.precioiva AS precioiva_8, t0.codimpuesto AS codimpuesto_9, t0.codmodificador AS codmodificador_10, t0.numlineasmodif AS numlineasmodif_11, t0.codfavoritos AS codfavoritos_12, t0.lft AS lft_13, t0.lvl AS lvl_14, t0.rgt AS rgt_15, t0.unidades AS unidades_16, t0.preciototal AS preciototal_17, t0.posicion AS posicion_18, t0.preciounidad AS preciounidad_19, t0.cabecera_id AS cabecera_id_20, t0.tree_root AS tree_root_21, t0.parent_id AS parent_id_22 FROM lineas t0 WHERE t0.cabecera_id = ? ORDER BY t0.tree_root ASC, t0.lft ASC
Parameters:
[
347662
]
|
| 6 | 0.16 ms |
SELECT t0.id AS id_1, t0.estado AS estado_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.user_id AS user_id_5, t0.cabecera_id AS cabecera_id_6 FROM cabecera_status t0 WHERE t0.cabecera_id = ?
Parameters:
[
347662
]
|
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\User | No errors. |
| App\Entity\Cabecera | No errors. |
| App\Entity\Domicilios | No errors. |
| App\Entity\Sucursal | No errors. |
| App\Entity\Lineas | No errors. |
| App\Entity\CabeceraStatus | No errors. |
| App\Entity\CabeceraLinkdepago | No errors. |