https://www.zpriceauditor.com/api/getPlaces?company=JMT&latitude=43.3152191&longitude=-0.4304843

Query Metrics

4 Database Queries
4 Different statements
7.20 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.06 ms
(28.57%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.lang AS lang_5, t0.nom AS nom_6, t0.prenom AS prenom_7 FROM `user` t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "[email protected]"
]
1.75 ms
(24.37%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.lang AS lang_5, t0.nom AS nom_6, t0.prenom AS prenom_7 FROM `user` t0 WHERE t0.email = ?
Parameters:
[
  "[email protected]"
]
1.72 ms
(23.92%)
1
SELECT t0.id AS id_1, t0.role AS role_2, t0.user_id AS user_id_3, t0.project_id AS project_id_4 FROM `user_project` t0 WHERE t0.user_id IN (?) AND t0.project_id = ?
Parameters:
[
  128
  5
]
1.67 ms
(23.14%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.catalog_allowed AS catalog_allowed_4, t0.last_updated AS last_updated_5, t0.last_update_alert AS last_update_alert_6, t0.competitors AS competitors_7, t0.is_active AS is_active_8 FROM project t0 WHERE t0.id = ?
Parameters:
[
  5
]

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\UserProject No errors.
App\Entity\Project No errors.