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

Query Metrics

5 Database Queries
5 Different statements
0.58 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.23 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 0.08 ms
SELECT DISTINCT s0_.source_shop_id AS source_shop_id_0 FROM shipment s0_ WHERE s0_.target_shop_id = ? AND s0_.reception_date IS NULL
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 (?)
Parameters:
[
  2
]
4 0.09 ms
SELECT t0.id AS id_1, t0.count_id AS count_id_2, t0.count_date AS count_date_3, t0.date_done AS date_done_4, t0.start_time AS start_time_5, t0.finish_time AS finish_time_6, t0.total_items_to_count AS total_items_to_count_7, t0.total_items_counted AS total_items_counted_8, t0.total_items_manualy_added AS total_items_manualy_added_9, t0.total_items_validated AS total_items_validated_10, t0.total_accuracy_percentage AS total_accuracy_percentage_11, t0.count_type AS count_type_12, t0.shop_id AS shop_id_13 FROM count t0 WHERE t0.shop_id = ?
Parameters:
[
  2
]
5 0.10 ms
SELECT t0.id AS id_1, t0.target_shop_id AS target_shop_id_2, t0.source_shop_id AS source_shop_id_3, t0.shipment_id AS shipment_id_4, t0.shipment_type AS shipment_type_5, t0.is_rfid AS is_rfid_6, t0.shipment_date AS shipment_date_7, t0.reception_date AS reception_date_8, t0.total_items_sent AS total_items_sent_9, t0.total_items_received AS total_items_received_10, t0.total_items_manually_received AS total_items_manually_received_11, t0.total_items_validated AS total_items_validated_12, t0.accuracy_percentage AS accuracy_percentage_13, t0.shop_id AS shop_id_14 FROM shipment t0 WHERE t0.shop_id = ?
Parameters:
[
  2
]

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.
App\Entity\Count No errors.
App\Entity\CountLines No errors.
App\Entity\ShipmentLine No errors.