Query Metrics
4
Database Queries
4
Different statements
7.69 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
2.77 ms (36.08%) |
1 |
SELECT t0.token AS token_1, t0.expire AS expire_2, t0.lifetime AS lifetime_3, t0.user_id AS user_id_4, t0.tablet_id AS tablet_id_5 FROM api_token t0 WHERE t0.token = ? LIMIT 1
Parameters:
[
"7b400796b66145700a155511240366fd897ac53a00e336fa3b58859894ed79d5"
]
|
|
2.17 ms (28.23%) |
1 |
SELECT l0_.id AS id_0, l0_.type AS type_1, l0_.title AS title_2, l0_.phone AS phone_3, l0_.marker_color AS marker_color_4, a1_.id AS id_5, a1_.company AS company_6, a1_.responsible_person AS responsible_person_7, a1_.address AS address_8, a1_.city AS city_9, a1_.postalcode AS postalcode_10, a1_.country AS country_11, a1_.latitude AS latitude_12, a1_.longitude AS longitude_13, a1_.nav_latitude AS nav_latitude_14, a1_.nav_longitude AS nav_longitude_15, ST_AsBinary(a1_.point) AS point_16, l0_.address_id AS address_id_17 FROM location l0_ INNER JOIN address a1_ ON l0_.address_id = a1_.id ORDER BY l0_.id ASC LIMIT 100 OFFSET 100
Parameters:
[] |
|
2.15 ms (27.97%) |
1 |
SELECT count(DISTINCT l0_.id) AS sclr_0 FROM location l0_ INNER JOIN address a1_ ON l0_.address_id = a1_.id
Parameters:
[] |
|
0.59 ms (7.71%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.status AS status_5, t0.deleted AS deleted_6 FROM `user` t0 WHERE t0.id = ? AND ((t0.deleted IS NULL))
Parameters:
[
17
]
|
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\Location | No errors. |
| App\Entity\ApiToken | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Tablet | No errors. |
| App\Entity\Address | No errors. |
| App\Entity\Delivery | No errors. |