Query Metrics
5
Database Queries
5
Different statements
0.58 ms
Query time
0
Invalid entities
Queries
| #▲ | 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. |