https://stage.princplaninc.eu/marincev-gric

Query Metrics

2 Database Queries
2 Different statements
0.67 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.36 ms
(53.94%)
1
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.description AS description_4, t0.created_at AS created_at_5, t0.coordinates AS coordinates_6, t0.elevation AS elevation_7 FROM spot t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "marincev-gric"
]
0.31 ms
(46.06%)
1
SELECT a0_.id AS id_0, u1_.id AS id_1, u1_.code AS code_2, u1_.name AS name_3, s2_.id AS id_4, max(a0_.created_at) AS sclr_5, count(a0_.id) AS sclr_6 FROM approach a0_ INNER JOIN "user" u1_ ON a0_.approach_user_id = u1_.id INNER JOIN spot s2_ ON a0_.spot_id = s2_.id WHERE s2_.id = ? GROUP BY u1_.id ORDER BY sclr_5 DESC
Parameters:
[
  1
]

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\Spot No errors.
App\Entity\Approach No errors.
App\Entity\User No errors.