Query Metrics

12 Database Queries
5 Different statements
410.64 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.27 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:
[
  8
]
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 218.50 ms
SELECT DISTINCT c0_.id AS id_0, c0_.created_at AS created_at_1 FROM cabecera c0_ WHERE c0_.sucursal = (?) ORDER BY c0_.created_at DESC LIMIT 30
Parameters:
[
  "POBLADO"
]
4 1.18 ms
SELECT c0_.id AS id_0, c0_.nombrecliente AS nombrecliente_1, c0_.nombres AS nombres_2, c0_.apellidos AS apellidos_3, c0_.codpostalcliente AS codpostalcliente_4, c0_.direccioncliente AS direccioncliente_5, c0_.poblacioncliente AS poblacioncliente_6, c0_.provinciacliente AS provinciacliente_7, c0_.paiscliente AS paiscliente_8, c0_.telefonocliente AS telefonocliente_9, c0_.telefono2cliente AS telefono2cliente_10, c0_.movilcliente AS movilcliente_11, c0_.emailcliente AS emailcliente_12, c0_.codmonedaminuta AS codmonedaminuta_13, c0_.nifcliente AS nifcliente_14, c0_.zona AS zona_15, c0_.fechareserva AS fechareserva_16, c0_.codcliente AS codcliente_17, c0_.direccion2cliente AS direccion2cliente_18, c0_.total AS total_19, c0_.totalsiniva AS totalsiniva_20, c0_.sucursal AS sucursal_21, c0_.comentario AS comentario_22, c0_.is_finalizada AS is_finalizada_23, c0_.metododepago AS metododepago_24, c0_.tipodeservicio AS tipodeservicio_25, c0_.is_enviado AS is_enviado_26, c0_.filename AS filename_27, c0_.estado AS estado_28, c0_.propinatotal AS propinatotal_29, c0_.propinaporcentaje AS propinaporcentaje_30, c0_.linkdepago AS linkdepago_31, c0_.facturaelectronica AS facturaelectronica_32, c0_.DIRECCION_2 AS DIRECCION_2_33, c0_.NOMBRE_1 AS NOMBRE_1_34, c0_.OTROS_NOMBRES AS OTROS_NOMBRES_35, c0_.APELLIDO_1 AS APELLIDO_1_36, c0_.APELLIDO_2 AS APELLIDO_2_37, c0_.FE_MUNICIPIO AS FE_MUNICIPIO_38, c0_.FE_RESPONSABILIDADES AS FE_RESPONSABILIDADES_39, c0_.TIPO_DE_DOCUMENTO AS TIPO_DE_DOCUMENTO_40, c0_.TIPOPERSONA AS TIPOPERSONA_41, c0_.FE_REGIMEN AS FE_REGIMEN_42, c0_.FE_DET_TRIBUTARIO AS FE_DET_TRIBUTARIO_43, c0_.CUENTA_ALIMENTACION AS CUENTA_ALIMENTACION_44, c0_.CENTRO_COSTOS AS CENTRO_COSTOS_45, c0_.CENTRO_OPERACION AS CENTRO_OPERACION_46, c0_.alias AS alias_47, c0_.email_linkdepago AS email_linkdepago_48, c0_.nombre_receptor AS nombre_receptor_49, c0_.telefono_receptor AS telefono_receptor_50, c0_.observaciones_receptor AS observaciones_receptor_51, c0_.created_at AS created_at_52, c0_.updated_at AS updated_at_53, c0_.user_id AS user_id_54 FROM cabecera c0_ WHERE c0_.sucursal = (?) AND c0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY c0_.created_at DESC
Parameters:
[
  "POBLADO"
  369356
  369349
  369326
  369307
  369302
  369288
  369286
  369285
  369277
  369275
  369268
  369250
  369247
  369245
  369231
  369227
  369225
  369224
  369205
  369203
  369199
  369191
  369184
  369183
  369167
  369162
  369151
  369148
  369147
  369136
]
5 188.84 ms
SELECT count(c0_.id) AS sclr_0 FROM cabecera c0_ WHERE c0_.sucursal = (?)
Parameters:
[
  "POBLADO"
]
6 0.30 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:
[
  165
]
7 0.21 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:
[
  19
]
8 0.19 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:
[
  24
]
9 0.19 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:
[
  158
]
10 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:
[
  155
]
11 0.17 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:
[
  12
]
12 0.20 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:
[
  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.

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.