Query Metrics
3
Database Queries
3
Different statements
77.41 ms
Query time
1
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
75.31 ms (97.28%) |
1 |
SELECT p0_.id AS id_0, w1_.id AS id_1, p0_.number AS number_2, p0_.is_in_delivery AS is_in_delivery_3, p0_.description AS description_4, w1_.sender_name AS sender_name_5, w1_.sender_phone_number AS sender_phone_number_6, w1_.receiver_name AS receiver_name_7, w1_.receiver_phone_number AS receiver_phone_number_8, s2_.id AS id_9, s2_.station_name AS station_name_10, s3_.id AS id_11, s3_.station_name AS station_name_12, DATE_FORMAT(w1_.created_at, '%Y-%m-%d %H:%i:%s') AS sclr_13, u4_.id AS id_14, t5_.id AS id_15, t5_.amount AS amount_16, w1_.is_collected AS is_collected_17, o6_.id AS id_18, w1_.percel_count AS percel_count_19 FROM parcel p0_ INNER JOIN way_bill w1_ ON p0_.way_bill_id = w1_.id INNER JOIN station s2_ ON w1_.from_station_id = s2_.id INNER JOIN station s3_ ON w1_.to_station_id = s3_.id INNER JOIN user u4_ ON w1_.created_by = u4_.id INNER JOIN transaction t5_ ON w1_.id = t5_.way_bill_id INNER JOIN organization o6_ ON w1_.organization_id = o6_.id WHERE p0_.id > ? AND w1_.from_station_id = ? ORDER BY w1_.id DESC LIMIT 5000
Parameters:
[ "826276" "15" ] |
1.17 ms (1.51%) |
1 |
SELECT v0_.id AS id_0, v0_.reg_number AS reg_number_1, v0_.passenger_capacity AS passenger_capacity_2 FROM vehicle v0_ WHERE v0_.id > ?
Parameters:
[
"2232"
]
|
0.94 ms (1.21%) |
1 |
SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.created_at AS created_at_4, t0.roles AS roles_5, t0.email AS email_6, t0.person_id AS person_id_7 FROM user t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
117
]
|
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\Person | No errors. |
App\Entity\Vehicle | No errors. |
App\Entity\Parcel | No errors. |
App\Entity\WayBill |
|
App\Entity\Station | No errors. |
App\Entity\Transaction | No errors. |
App\Entity\Organization | No errors. |