https://callcenter.calcoweb.net/articulos?fav=221&sucursal=ENVIGADO%20DOMICILIOS

Query Metrics

3 Database Queries
3 Different statements
0.85 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 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:
[
  158
]
2 0.38 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 WHERE t0.nombre = ? LIMIT 1
Parameters:
[
  "ENVIGADO DOMICILIOS"
]
3 0.25 ms
SELECT a0_.CODARTICULO AS CODARTICULO_0, a0_.DESCRIPCION AS DESCRIPCION_1, f1_.CODFAVORITO AS CODFAVORITO_2, f1_.POSICION AS POSICION_3, c2_.bloqueado AS bloqueado_4 FROM articulos a0_ LEFT JOIN favoritoslin f1_ ON (a0_.CODARTICULO = f1_.CODARTICULO) LEFT JOIN cc_articulos_bloqueados c2_ ON (a0_.CODARTICULO = c2_.codarticulo AND c2_.sucursal = ?) WHERE f1_.CODFAVORITO = ? ORDER BY f1_.POSICION ASC
Parameters:
[
  "C01"
  221
]

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\Articulos No errors.
App\Entity\Favoritoslin No errors.
App\Entity\CcArticulosBloqueados No errors.