POST https://kms-rdc.net/api/user/find

Query Metrics

26 Database Queries
7 Different statements
18.41 ms Query time
0 Invalid entities
22 Managed entities

Grouped Statements

Show all queries

Time Count Info
10.67 ms
(57.94%)
20
SELECT t0.id AS id_1, t0.debut_at AS debut_at_2, t0.end_at AS end_at_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.fonction_id AS fonction_id_6, t0.user_id AS user_id_7 FROM fonction_history t0 WHERE t0.user_id = ?
Parameters:
[
  19
]
1.87 ms
(10.18%)
1
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT u0_.id AS id_0, u0_.first_name AS first_name_1, u0_.middle_name AS middle_name_2, u0_.last_name AS last_name_3, u0_.gender AS gender_4, u0_.location AS location_5, u0_.phone AS phone_6, u0_.login AS login_7, u0_.password AS password_8, u0_.roles AS roles_9, u0_.created_at AS created_at_10, u0_.status AS status_11 FROM user u0_ LEFT JOIN city c1_ ON u0_.city_id = c1_.id LEFT JOIN province p2_ ON c1_.province_id = p2_.id LEFT JOIN fonction_history f3_ ON u0_.id = f3_.user_id AND (f3_.status = ?) LEFT JOIN fonction f4_ ON f3_.fonction_id = f4_.id LEFT JOIN service s5_ ON f4_.service_id = s5_.id LEFT JOIN organization o6_ ON s5_.organization_id = o6_.id ORDER BY u0_.last_name ASC) dctrn_result) dctrn_table
Parameters:
[
  "ACTIVE"
]
1.71 ms
(9.27%)
1
SELECT u0_.id AS id_0, u0_.first_name AS first_name_1, u0_.middle_name AS middle_name_2, u0_.last_name AS last_name_3, u0_.gender AS gender_4, u0_.location AS location_5, u0_.phone AS phone_6, u0_.login AS login_7, u0_.password AS password_8, u0_.roles AS roles_9, u0_.created_at AS created_at_10, u0_.status AS status_11, u0_.city_id AS city_id_12, u0_.parking_id AS parking_id_13 FROM user u0_ LEFT JOIN city c1_ ON u0_.city_id = c1_.id LEFT JOIN province p2_ ON c1_.province_id = p2_.id LEFT JOIN fonction_history f3_ ON u0_.id = f3_.user_id AND (f3_.status = ?) LEFT JOIN fonction f4_ ON f3_.fonction_id = f4_.id LEFT JOIN service s5_ ON f4_.service_id = s5_.id LEFT JOIN organization o6_ ON s5_.organization_id = o6_.id WHERE u0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY u0_.last_name ASC
Parameters:
[
  "ACTIVE"
  19
  23
  14
  16
  10
  20
  22
  11
  9
  25
  17
  1
  12
  21
  18
  24
  13
  26
  27
  15
]
1.16 ms
(6.33%)
1
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.created_at AS created_at_4, t0.province_id AS province_id_5 FROM city t0 WHERE t0.id = ?
Parameters:
[
  1
]
1.14 ms
(6.17%)
1
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, last_name_3 FROM (SELECT u0_.id AS id_0, u0_.first_name AS first_name_1, u0_.middle_name AS middle_name_2, u0_.last_name AS last_name_3, u0_.gender AS gender_4, u0_.location AS location_5, u0_.phone AS phone_6, u0_.login AS login_7, u0_.password AS password_8, u0_.roles AS roles_9, u0_.created_at AS created_at_10, u0_.status AS status_11, f1_.id AS id_12, f1_.debut_at AS debut_at_13, f1_.end_at AS end_at_14, f1_.status AS status_15, f1_.created_at AS created_at_16 FROM user u0_ LEFT JOIN city c2_ ON u0_.city_id = c2_.id LEFT JOIN province p3_ ON c2_.province_id = p3_.id LEFT JOIN fonction_history f1_ ON u0_.id = f1_.user_id AND (f1_.status = ?) LEFT JOIN fonction f4_ ON f1_.fonction_id = f4_.id LEFT JOIN service s5_ ON f4_.service_id = s5_.id LEFT JOIN organization o6_ ON s5_.organization_id = o6_.id) dctrn_result_inner ORDER BY last_name_3 ASC) dctrn_result LIMIT 25
Parameters:
[
  "ACTIVE"
]
0.96 ms
(5.21%)
1
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.middle_name AS middle_name_3, t0.last_name AS last_name_4, t0.gender AS gender_5, t0.location AS location_6, t0.phone AS phone_7, t0.login AS login_8, t0.password AS password_9, t0.roles AS roles_10, t0.created_at AS created_at_11, t0.status AS status_12, t0.city_id AS city_id_13, t0.parking_id AS parking_id_14 FROM user t0 WHERE t0.login = ? LIMIT 1
Parameters:
[
  "0899843151"
]
0.90 ms
(4.91%)
1
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.created_at AS created_at_4 FROM province t0 WHERE t0.id = ?
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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\User 20
App\Entity\City 1
App\Entity\Province 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\City No errors.
App\Entity\Parking No errors.
App\Entity\FonctionHistory No errors.
App\Entity\Terminal No errors.
App\Entity\Motor No errors.
App\Entity\MotorMarque No errors.
App\Entity\Province No errors.
App\Entity\Fonction No errors.
App\Entity\Service No errors.
App\Entity\Organization No errors.