GET https://laposte.wws-stats.netissedev.com/

Query Metrics

8 Database Queries
7 Different statements
134.25 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
82.75 ms
(61.64%)
1
SELECT u0_.id AS id_0, u0_.first_name AS first_name_1, u0_.last_name AS last_name_2, u0_.create_date AS create_date_3, u0_.delete_date AS delete_date_4, u0_.email AS email_5, u0_.group_ancestor_id AS group_ancestor_id_6 FROM `user` u0_ GROUP BY u0_.id
Parameters:
[]
34.13 ms
(25.42%)
1
SELECT DISTINCT id AS id, name FROM `resource`
Parameters:
[]
9.25 ms
(6.89%)
2
SELECT t0.id AS id_1, t0.group_name AS group_name_2, t0.group_level_id AS group_level_id_3, t0.group_level_name AS group_level_name_4, t0.group_type_name AS group_type_name_5, t0.group_ancestor_id AS group_ancestor_id_6 FROM group_ancestor_details t0 WHERE t0.group_type_name = ? ORDER BY t0.group_level_id ASC
Parameters:
[
  "Localisation"
]
4.64 ms
(3.46%)
1
SELECT s.id,t.value FROM `status` s LEFT JOIN translator t ON s.id = t.path_id WHERE t.path = 'status.label' AND lang = 'fr-FR'
Parameters:
[]
1.63 ms
(1.21%)
1
SELECT t0.id AS id_1, t0.tenant_name AS tenant_name_2, t0.tenant_id AS tenant_id_3, t0.last_cron AS last_cron_4, t0.open AS open_5, t0.close AS close_6, t0.logo AS logo_7 FROM general t0 WHERE t0.id = ?
Parameters:
[
  1
]
1.22 ms
(0.91%)
1
SELECT t0.id AS id_1, t0.login AS login_2, t0.date_suspended AS date_suspended_3, t0.password AS password_4, t0.has_access AS has_access_5 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  113798
]
0.64 ms
(0.47%)
1
SELECT t0.id AS id_1, t0.login AS login_2, t0.date_suspended AS date_suspended_3, t0.password AS password_4, t0.has_access AS has_access_5 FROM permission t0 WHERE t0.login = ? LIMIT 1
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\Permission No errors.
App\Entity\GroupAncestorDetails No errors.
App\Entity\Status No errors.
App\Entity\User No errors.
App\Entity\General No errors.
App\Entity\Resource No errors.