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
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 = 'ACTIVE') 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;
|
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
]
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 = 'ACTIVE') 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 (19, 23, 14, 16, 10, 20, 22, 11, 9, 25, 17, 1, 12, 21, 18, 24, 13, 26, 27, 15) ORDER BY u0_.last_name ASC;
|
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
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 = 'ACTIVE') 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;
|
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"
]
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 = '0899843151' LIMIT 1;
|