https://app-beta.sigmatex.ma/

Query Metrics

10 Database Queries
3 Different statements
10.27 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.96 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.active AS active_5, t0.google_id AS google_id_6, t0.avatar_name AS avatar_name_7, t0.user_role_id AS user_role_id_8, t9.id AS id_10, t9.first_name AS first_name_11, t9.last_name AS last_name_12, t9.date_of_birth AS date_of_birth_13, t9.city_of_birth AS city_of_birth_14, t9.gender AS gender_15, t9.number_of_childrens AS number_of_childrens_16, t9.phone_number AS phone_number_17, t9.cin AS cin_18, t9.cnss AS cnss_19, t9.relation_ship_status AS relation_ship_status_20, t9.picture AS picture_21, t9.date_old AS date_old_22, t9.date_cnss AS date_cnss_23, t9.registration_number AS registration_number_24, t9.created_at AS created_at_25, t9.updated_at AS updated_at_26, t9.user_id AS user_id_27, t9.last_history_id AS last_history_id_28 FROM user t0 LEFT JOIN employee t9 ON t9.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  3
]
2 0.81 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.active AS active_5, t0.google_id AS google_id_6, t0.avatar_name AS avatar_name_7, t0.user_role_id AS user_role_id_8, t9.id AS id_10, t9.first_name AS first_name_11, t9.last_name AS last_name_12, t9.date_of_birth AS date_of_birth_13, t9.city_of_birth AS city_of_birth_14, t9.gender AS gender_15, t9.number_of_childrens AS number_of_childrens_16, t9.phone_number AS phone_number_17, t9.cin AS cin_18, t9.cnss AS cnss_19, t9.relation_ship_status AS relation_ship_status_20, t9.picture AS picture_21, t9.date_old AS date_old_22, t9.date_cnss AS date_cnss_23, t9.registration_number AS registration_number_24, t9.created_at AS created_at_25, t9.updated_at AS updated_at_26, t9.user_id AS user_id_27, t9.last_history_id AS last_history_id_28 FROM user t0 LEFT JOIN employee t9 ON t9.user_id = t0.id WHERE t0.email = ? LIMIT 1
Parameters:
[
  "n.bouaziz@sigmatex.ma"
]
3 0.44 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.permissions AS permissions_3 FROM user_role t0 WHERE t0.id = ?
Parameters:
[
  3
]
4 0.97 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.active AS active_5, t0.google_id AS google_id_6, t0.avatar_name AS avatar_name_7, t0.user_role_id AS user_role_id_8, t9.id AS id_10, t9.first_name AS first_name_11, t9.last_name AS last_name_12, t9.date_of_birth AS date_of_birth_13, t9.city_of_birth AS city_of_birth_14, t9.gender AS gender_15, t9.number_of_childrens AS number_of_childrens_16, t9.phone_number AS phone_number_17, t9.cin AS cin_18, t9.cnss AS cnss_19, t9.relation_ship_status AS relation_ship_status_20, t9.picture AS picture_21, t9.date_old AS date_old_22, t9.date_cnss AS date_cnss_23, t9.registration_number AS registration_number_24, t9.created_at AS created_at_25, t9.updated_at AS updated_at_26, t9.user_id AS user_id_27, t9.last_history_id AS last_history_id_28 FROM user t0 LEFT JOIN employee t9 ON t9.user_id = t0.id WHERE t0.email = ? LIMIT 1
Parameters:
[
  "n.bouaziz@sigmatex.ma"
]
5 0.91 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.active AS active_5, t0.google_id AS google_id_6, t0.avatar_name AS avatar_name_7, t0.user_role_id AS user_role_id_8, t9.id AS id_10, t9.first_name AS first_name_11, t9.last_name AS last_name_12, t9.date_of_birth AS date_of_birth_13, t9.city_of_birth AS city_of_birth_14, t9.gender AS gender_15, t9.number_of_childrens AS number_of_childrens_16, t9.phone_number AS phone_number_17, t9.cin AS cin_18, t9.cnss AS cnss_19, t9.relation_ship_status AS relation_ship_status_20, t9.picture AS picture_21, t9.date_old AS date_old_22, t9.date_cnss AS date_cnss_23, t9.registration_number AS registration_number_24, t9.created_at AS created_at_25, t9.updated_at AS updated_at_26, t9.user_id AS user_id_27, t9.last_history_id AS last_history_id_28 FROM user t0 LEFT JOIN employee t9 ON t9.user_id = t0.id WHERE t0.email = ? LIMIT 1
Parameters:
[
  "n.bouaziz@sigmatex.ma"
]
6 1.46 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.active AS active_5, t0.google_id AS google_id_6, t0.avatar_name AS avatar_name_7, t0.user_role_id AS user_role_id_8, t9.id AS id_10, t9.first_name AS first_name_11, t9.last_name AS last_name_12, t9.date_of_birth AS date_of_birth_13, t9.city_of_birth AS city_of_birth_14, t9.gender AS gender_15, t9.number_of_childrens AS number_of_childrens_16, t9.phone_number AS phone_number_17, t9.cin AS cin_18, t9.cnss AS cnss_19, t9.relation_ship_status AS relation_ship_status_20, t9.picture AS picture_21, t9.date_old AS date_old_22, t9.date_cnss AS date_cnss_23, t9.registration_number AS registration_number_24, t9.created_at AS created_at_25, t9.updated_at AS updated_at_26, t9.user_id AS user_id_27, t9.last_history_id AS last_history_id_28 FROM user t0 LEFT JOIN employee t9 ON t9.user_id = t0.id WHERE t0.email = ? LIMIT 1
Parameters:
[
  "n.bouaziz@sigmatex.ma"
]
7 0.42 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.active AS active_5, t0.google_id AS google_id_6, t0.avatar_name AS avatar_name_7, t0.user_role_id AS user_role_id_8, t9.id AS id_10, t9.first_name AS first_name_11, t9.last_name AS last_name_12, t9.date_of_birth AS date_of_birth_13, t9.city_of_birth AS city_of_birth_14, t9.gender AS gender_15, t9.number_of_childrens AS number_of_childrens_16, t9.phone_number AS phone_number_17, t9.cin AS cin_18, t9.cnss AS cnss_19, t9.relation_ship_status AS relation_ship_status_20, t9.picture AS picture_21, t9.date_old AS date_old_22, t9.date_cnss AS date_cnss_23, t9.registration_number AS registration_number_24, t9.created_at AS created_at_25, t9.updated_at AS updated_at_26, t9.user_id AS user_id_27, t9.last_history_id AS last_history_id_28 FROM user t0 LEFT JOIN employee t9 ON t9.user_id = t0.id WHERE t0.email = ? LIMIT 1
Parameters:
[
  "n.bouaziz@sigmatex.ma"
]
8 1.62 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.active AS active_5, t0.google_id AS google_id_6, t0.avatar_name AS avatar_name_7, t0.user_role_id AS user_role_id_8, t9.id AS id_10, t9.first_name AS first_name_11, t9.last_name AS last_name_12, t9.date_of_birth AS date_of_birth_13, t9.city_of_birth AS city_of_birth_14, t9.gender AS gender_15, t9.number_of_childrens AS number_of_childrens_16, t9.phone_number AS phone_number_17, t9.cin AS cin_18, t9.cnss AS cnss_19, t9.relation_ship_status AS relation_ship_status_20, t9.picture AS picture_21, t9.date_old AS date_old_22, t9.date_cnss AS date_cnss_23, t9.registration_number AS registration_number_24, t9.created_at AS created_at_25, t9.updated_at AS updated_at_26, t9.user_id AS user_id_27, t9.last_history_id AS last_history_id_28 FROM user t0 LEFT JOIN employee t9 ON t9.user_id = t0.id WHERE t0.email = ? LIMIT 1
Parameters:
[
  "n.bouaziz@sigmatex.ma"
]
9 1.03 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.active AS active_5, t0.google_id AS google_id_6, t0.avatar_name AS avatar_name_7, t0.user_role_id AS user_role_id_8, t9.id AS id_10, t9.first_name AS first_name_11, t9.last_name AS last_name_12, t9.date_of_birth AS date_of_birth_13, t9.city_of_birth AS city_of_birth_14, t9.gender AS gender_15, t9.number_of_childrens AS number_of_childrens_16, t9.phone_number AS phone_number_17, t9.cin AS cin_18, t9.cnss AS cnss_19, t9.relation_ship_status AS relation_ship_status_20, t9.picture AS picture_21, t9.date_old AS date_old_22, t9.date_cnss AS date_cnss_23, t9.registration_number AS registration_number_24, t9.created_at AS created_at_25, t9.updated_at AS updated_at_26, t9.user_id AS user_id_27, t9.last_history_id AS last_history_id_28 FROM user t0 LEFT JOIN employee t9 ON t9.user_id = t0.id WHERE t0.email = ? LIMIT 1
Parameters:
[
  "n.bouaziz@sigmatex.ma"
]
10 1.65 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.active AS active_5, t0.google_id AS google_id_6, t0.avatar_name AS avatar_name_7, t0.user_role_id AS user_role_id_8, t9.id AS id_10, t9.first_name AS first_name_11, t9.last_name AS last_name_12, t9.date_of_birth AS date_of_birth_13, t9.city_of_birth AS city_of_birth_14, t9.gender AS gender_15, t9.number_of_childrens AS number_of_childrens_16, t9.phone_number AS phone_number_17, t9.cin AS cin_18, t9.cnss AS cnss_19, t9.relation_ship_status AS relation_ship_status_20, t9.picture AS picture_21, t9.date_old AS date_old_22, t9.date_cnss AS date_cnss_23, t9.registration_number AS registration_number_24, t9.created_at AS created_at_25, t9.updated_at AS updated_at_26, t9.user_id AS user_id_27, t9.last_history_id AS last_history_id_28 FROM user t0 LEFT JOIN employee t9 ON t9.user_id = t0.id WHERE t0.email = ? LIMIT 1
Parameters:
[
  "n.bouaziz@sigmatex.ma"
]

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\UserRole No errors.
App\Entity\Employee No errors.
App\Entity\EmployeeHistory No errors.
App\Entity\EmployeeHourLog No errors.
App\Entity\EmployeeAdvance No errors.