GET https://misako-rfid.s2.webimpacto.es/api/shipments/pending/shops?sourceShopId=999

Query Metrics

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

Queries

Group similar statements

# Time Info
1 0.25 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.shop_id AS shop_id_5 FROM user t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "prueba_noadmin@webimpacto.es"
]
2 5.46 ms
SELECT DISTINCT s0_.shop_id AS sclr_0 FROM shipment s0_ WHERE s0_.source_shop_id = ? AND s0_.reception_date IS NULL AND s0_.target_shop_id = 999
Parameters:
[
  999
]
3 0.08 ms
SELECT t0.id_shop AS id_shop_1, t0.name AS name_2, t0.close_date AS close_date_3, t0.zone_id AS zone_id_4, t0.tipo_pos AS tipo_pos_5, t0.outlet AS outlet_6 FROM shop t0 WHERE t0.id_shop IN (NULL)
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\Shipment No errors.
App\Entity\User No errors.
App\Entity\Shop No errors.