Redirect 302 redirect from POST @app_login (d24320)

GET http://todo.betterb.dev/private/actions/

Response
200 OK
IP
172.18.0.2
Profiled on
Token
c53271

Query Metrics

18 Database Queries
6 Different statements
11.20 ms Query time
0 Invalid entities
58 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.63 ms 
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.password AS password_5, t0.is_active AS is_active_6, t0.roles AS roles_7, t0.uuid AS uuid_8, t0.groupe_id AS groupe_id_9 FROM `user` t0 WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
2 0.93 ms 
SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.is_commun AS is_commun_2, c0_.uuid AS uuid_3, c0_.owner_id AS owner_id_4 FROM categorie c0_ LEFT JOIN `user` u1_ ON c0_.owner_id = u1_.id WHERE c0_.owner_id = ? OR (c0_.is_commun = ? AND u1_.groupe_id = ?) ORDER BY c0_.nom ASC
Parameters: 
[
  1
  1
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
3 1.87 ms 
SELECT a0_.id AS id_0, a0_.date AS date_1, a0_.nom AS nom_2, a0_.detail AS detail_3, a0_.is_done AS is_done_4, a0_.echeance AS echeance_5, a0_.done_at AS done_at_6, a0_.code AS code_7, a0_.periodicite_en_mois AS periodicite_en_mois_8, a0_.avancement AS avancement_9, a0_.uuid AS uuid_10, a0_.categorie_id AS categorie_id_11, a0_.demandeur_id AS demandeur_id_12, a0_.pilote_id AS pilote_id_13 FROM action a0_ LEFT JOIN `user` u1_ ON a0_.demandeur_id = u1_.id LEFT JOIN `user` u2_ ON a0_.pilote_id = u2_.id WHERE u1_.groupe_id = ? OR u2_.groupe_id = ? ORDER BY a0_.is_done ASC, a0_.echeance ASC
Parameters: 
[
  1
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
4 0.87 ms 
SELECT a0_.id AS id_0, a0_.date AS date_1, a0_.nom AS nom_2, a0_.detail AS detail_3, a0_.is_done AS is_done_4, a0_.echeance AS echeance_5, a0_.done_at AS done_at_6, a0_.code AS code_7, a0_.periodicite_en_mois AS periodicite_en_mois_8, a0_.avancement AS avancement_9, a0_.uuid AS uuid_10, a0_.categorie_id AS categorie_id_11, a0_.demandeur_id AS demandeur_id_12, a0_.pilote_id AS pilote_id_13 FROM action a0_ LEFT JOIN `user` u1_ ON a0_.demandeur_id = u1_.id LEFT JOIN `user` u2_ ON a0_.pilote_id = u2_.id WHERE (u1_.groupe_id = ? OR u2_.groupe_id = ?) AND a0_.categorie_id = ?
Parameters: 
[
  1
  1
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
5 0.56 ms 
SELECT a0_.id AS id_0, a0_.date AS date_1, a0_.nom AS nom_2, a0_.detail AS detail_3, a0_.is_done AS is_done_4, a0_.echeance AS echeance_5, a0_.done_at AS done_at_6, a0_.code AS code_7, a0_.periodicite_en_mois AS periodicite_en_mois_8, a0_.avancement AS avancement_9, a0_.uuid AS uuid_10, a0_.categorie_id AS categorie_id_11, a0_.demandeur_id AS demandeur_id_12, a0_.pilote_id AS pilote_id_13 FROM action a0_ LEFT JOIN `user` u1_ ON a0_.demandeur_id = u1_.id LEFT JOIN `user` u2_ ON a0_.pilote_id = u2_.id WHERE (u1_.groupe_id = ? OR u2_.groupe_id = ?) AND a0_.categorie_id = ?
Parameters: 
[
  1
  1
  30
]
View formatted query    View runnable query    Explain query    View query backtrace
6 0.51 ms 
SELECT a0_.id AS id_0, a0_.date AS date_1, a0_.nom AS nom_2, a0_.detail AS detail_3, a0_.is_done AS is_done_4, a0_.echeance AS echeance_5, a0_.done_at AS done_at_6, a0_.code AS code_7, a0_.periodicite_en_mois AS periodicite_en_mois_8, a0_.avancement AS avancement_9, a0_.uuid AS uuid_10, a0_.categorie_id AS categorie_id_11, a0_.demandeur_id AS demandeur_id_12, a0_.pilote_id AS pilote_id_13 FROM action a0_ LEFT JOIN `user` u1_ ON a0_.demandeur_id = u1_.id LEFT JOIN `user` u2_ ON a0_.pilote_id = u2_.id WHERE (u1_.groupe_id = ? OR u2_.groupe_id = ?) AND a0_.categorie_id = ?
Parameters: 
[
  1
  1
  25
]
View formatted query    View runnable query    Explain query    View query backtrace
7 0.56 ms 
SELECT a0_.id AS id_0, a0_.date AS date_1, a0_.nom AS nom_2, a0_.detail AS detail_3, a0_.is_done AS is_done_4, a0_.echeance AS echeance_5, a0_.done_at AS done_at_6, a0_.code AS code_7, a0_.periodicite_en_mois AS periodicite_en_mois_8, a0_.avancement AS avancement_9, a0_.uuid AS uuid_10, a0_.categorie_id AS categorie_id_11, a0_.demandeur_id AS demandeur_id_12, a0_.pilote_id AS pilote_id_13 FROM action a0_ LEFT JOIN `user` u1_ ON a0_.demandeur_id = u1_.id LEFT JOIN `user` u2_ ON a0_.pilote_id = u2_.id WHERE (u1_.groupe_id = ? OR u2_.groupe_id = ?) AND a0_.categorie_id = ?
Parameters: 
[
  1
  1
  4
]
View formatted query    View runnable query    Explain query    View query backtrace
8 0.58 ms 
SELECT a0_.id AS id_0, a0_.date AS date_1, a0_.nom AS nom_2, a0_.detail AS detail_3, a0_.is_done AS is_done_4, a0_.echeance AS echeance_5, a0_.done_at AS done_at_6, a0_.code AS code_7, a0_.periodicite_en_mois AS periodicite_en_mois_8, a0_.avancement AS avancement_9, a0_.uuid AS uuid_10, a0_.categorie_id AS categorie_id_11, a0_.demandeur_id AS demandeur_id_12, a0_.pilote_id AS pilote_id_13 FROM action a0_ LEFT JOIN `user` u1_ ON a0_.demandeur_id = u1_.id LEFT JOIN `user` u2_ ON a0_.pilote_id = u2_.id WHERE (u1_.groupe_id = ? OR u2_.groupe_id = ?) AND a0_.categorie_id = ?
Parameters: 
[
  1
  1
  16
]
View formatted query    View runnable query    Explain query    View query backtrace
9 0.54 ms 
SELECT a0_.id AS id_0, a0_.date AS date_1, a0_.nom AS nom_2, a0_.detail AS detail_3, a0_.is_done AS is_done_4, a0_.echeance AS echeance_5, a0_.done_at AS done_at_6, a0_.code AS code_7, a0_.periodicite_en_mois AS periodicite_en_mois_8, a0_.avancement AS avancement_9, a0_.uuid AS uuid_10, a0_.categorie_id AS categorie_id_11, a0_.demandeur_id AS demandeur_id_12, a0_.pilote_id AS pilote_id_13 FROM action a0_ LEFT JOIN `user` u1_ ON a0_.demandeur_id = u1_.id LEFT JOIN `user` u2_ ON a0_.pilote_id = u2_.id WHERE (u1_.groupe_id = ? OR u2_.groupe_id = ?) AND a0_.categorie_id = ?
Parameters: 
[
  1
  1
  10
]
View formatted query    View runnable query    Explain query    View query backtrace
10 0.68 ms 
SELECT a0_.id AS id_0, a0_.date AS date_1, a0_.nom AS nom_2, a0_.detail AS detail_3, a0_.is_done AS is_done_4, a0_.echeance AS echeance_5, a0_.done_at AS done_at_6, a0_.code AS code_7, a0_.periodicite_en_mois AS periodicite_en_mois_8, a0_.avancement AS avancement_9, a0_.uuid AS uuid_10, a0_.categorie_id AS categorie_id_11, a0_.demandeur_id AS demandeur_id_12, a0_.pilote_id AS pilote_id_13 FROM action a0_ LEFT JOIN `user` u1_ ON a0_.demandeur_id = u1_.id LEFT JOIN `user` u2_ ON a0_.pilote_id = u2_.id WHERE (u1_.groupe_id = ? OR u2_.groupe_id = ?) AND a0_.categorie_id = ?
Parameters: 
[
  1
  1
  17
]
View formatted query    View runnable query    Explain query    View query backtrace
11 0.64 ms 
SELECT a0_.id AS id_0, a0_.date AS date_1, a0_.nom AS nom_2, a0_.detail AS detail_3, a0_.is_done AS is_done_4, a0_.echeance AS echeance_5, a0_.done_at AS done_at_6, a0_.code AS code_7, a0_.periodicite_en_mois AS periodicite_en_mois_8, a0_.avancement AS avancement_9, a0_.uuid AS uuid_10, a0_.categorie_id AS categorie_id_11, a0_.demandeur_id AS demandeur_id_12, a0_.pilote_id AS pilote_id_13 FROM action a0_ LEFT JOIN `user` u1_ ON a0_.demandeur_id = u1_.id LEFT JOIN `user` u2_ ON a0_.pilote_id = u2_.id WHERE (u1_.groupe_id = ? OR u2_.groupe_id = ?) AND a0_.categorie_id = ?
Parameters: 
[
  1
  1
  9
]
View formatted query    View runnable query    Explain query    View query backtrace
12 0.39 ms 
SELECT a0_.id AS id_0, a0_.date AS date_1, a0_.nom AS nom_2, a0_.detail AS detail_3, a0_.is_done AS is_done_4, a0_.echeance AS echeance_5, a0_.done_at AS done_at_6, a0_.code AS code_7, a0_.periodicite_en_mois AS periodicite_en_mois_8, a0_.avancement AS avancement_9, a0_.uuid AS uuid_10, a0_.categorie_id AS categorie_id_11, a0_.demandeur_id AS demandeur_id_12, a0_.pilote_id AS pilote_id_13 FROM action a0_ LEFT JOIN `user` u1_ ON a0_.demandeur_id = u1_.id LEFT JOIN `user` u2_ ON a0_.pilote_id = u2_.id WHERE (u1_.groupe_id = ? OR u2_.groupe_id = ?) AND a0_.categorie_id = ?
Parameters: 
[
  1
  1
  29
]
View formatted query    View runnable query    Explain query    View query backtrace
13 0.33 ms 
SELECT a0_.id AS id_0, a0_.date AS date_1, a0_.nom AS nom_2, a0_.detail AS detail_3, a0_.is_done AS is_done_4, a0_.echeance AS echeance_5, a0_.done_at AS done_at_6, a0_.code AS code_7, a0_.periodicite_en_mois AS periodicite_en_mois_8, a0_.avancement AS avancement_9, a0_.uuid AS uuid_10, a0_.categorie_id AS categorie_id_11, a0_.demandeur_id AS demandeur_id_12, a0_.pilote_id AS pilote_id_13 FROM action a0_ LEFT JOIN `user` u1_ ON a0_.demandeur_id = u1_.id LEFT JOIN `user` u2_ ON a0_.pilote_id = u2_.id WHERE (u1_.groupe_id = ? OR u2_.groupe_id = ?) AND a0_.categorie_id = ?
Parameters: 
[
  1
  1
  19
]
View formatted query    View runnable query    Explain query    View query backtrace
14 0.31 ms 
SELECT a0_.id AS id_0, a0_.date AS date_1, a0_.nom AS nom_2, a0_.detail AS detail_3, a0_.is_done AS is_done_4, a0_.echeance AS echeance_5, a0_.done_at AS done_at_6, a0_.code AS code_7, a0_.periodicite_en_mois AS periodicite_en_mois_8, a0_.avancement AS avancement_9, a0_.uuid AS uuid_10, a0_.categorie_id AS categorie_id_11, a0_.demandeur_id AS demandeur_id_12, a0_.pilote_id AS pilote_id_13 FROM action a0_ LEFT JOIN `user` u1_ ON a0_.demandeur_id = u1_.id LEFT JOIN `user` u2_ ON a0_.pilote_id = u2_.id WHERE (u1_.groupe_id = ? OR u2_.groupe_id = ?) AND a0_.categorie_id = ?
Parameters: 
[
  1
  1
  18
]
View formatted query    View runnable query    Explain query    View query backtrace
15 0.31 ms 
SELECT a0_.id AS id_0, a0_.date AS date_1, a0_.nom AS nom_2, a0_.detail AS detail_3, a0_.is_done AS is_done_4, a0_.echeance AS echeance_5, a0_.done_at AS done_at_6, a0_.code AS code_7, a0_.periodicite_en_mois AS periodicite_en_mois_8, a0_.avancement AS avancement_9, a0_.uuid AS uuid_10, a0_.categorie_id AS categorie_id_11, a0_.demandeur_id AS demandeur_id_12, a0_.pilote_id AS pilote_id_13 FROM action a0_ LEFT JOIN `user` u1_ ON a0_.demandeur_id = u1_.id LEFT JOIN `user` u2_ ON a0_.pilote_id = u2_.id WHERE (u1_.groupe_id = ? OR u2_.groupe_id = ?) AND a0_.categorie_id = ?
Parameters: 
[
  1
  1
  11
]
View formatted query    View runnable query    Explain query    View query backtrace
16 0.33 ms 
SELECT a0_.id AS id_0, a0_.date AS date_1, a0_.nom AS nom_2, a0_.detail AS detail_3, a0_.is_done AS is_done_4, a0_.echeance AS echeance_5, a0_.done_at AS done_at_6, a0_.code AS code_7, a0_.periodicite_en_mois AS periodicite_en_mois_8, a0_.avancement AS avancement_9, a0_.uuid AS uuid_10, a0_.categorie_id AS categorie_id_11, a0_.demandeur_id AS demandeur_id_12, a0_.pilote_id AS pilote_id_13 FROM action a0_ LEFT JOIN `user` u1_ ON a0_.demandeur_id = u1_.id LEFT JOIN `user` u2_ ON a0_.pilote_id = u2_.id WHERE (u1_.groupe_id = ? OR u2_.groupe_id = ?) AND a0_.categorie_id = ?
Parameters: 
[
  1
  1
  14
]
View formatted query    View runnable query    Explain query    View query backtrace
17 0.45 ms 
SELECT a0_.id AS id_0, a0_.date AS date_1, a0_.nom AS nom_2, a0_.detail AS detail_3, a0_.is_done AS is_done_4, a0_.echeance AS echeance_5, a0_.done_at AS done_at_6, a0_.code AS code_7, a0_.periodicite_en_mois AS periodicite_en_mois_8, a0_.avancement AS avancement_9, a0_.uuid AS uuid_10, a0_.categorie_id AS categorie_id_11, a0_.demandeur_id AS demandeur_id_12, a0_.pilote_id AS pilote_id_13 FROM action a0_ LEFT JOIN `user` u1_ ON a0_.demandeur_id = u1_.id LEFT JOIN `user` u2_ ON a0_.pilote_id = u2_.id WHERE u1_.groupe_id = ? OR u2_.groupe_id = ?
Parameters: 
[
  1
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
18 0.71 ms 
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.is_active AS is_active_3, t0.uuid AS uuid_4, t0.owner_id AS owner_id_5 FROM groupe t0 WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Action 43
App\Entity\Categorie 13
App\Entity\User 1
App\Entity\Groupe 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Groupe No errors.
App\Entity\Action No errors.
App\Entity\Categorie No errors.