13.35 ms (26.54%)
|
1 |
SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.code AS code_2, d0_.description AS description_3, d0_.icon AS icon_4, d0_.color AS color_5, d0_.display_order AS display_order_6, d0_.created_at AS created_at_7, u1_.id AS id_8, u1_.email AS email_9, u1_.roles AS roles_10, u1_.password AS password_11, u1_.full_name AS full_name_12, u1_.created_at AS created_at_13, m2_.id AS id_14, m2_.first_name AS first_name_15, m2_.last_name AS last_name_16, m2_.cin_number AS cin_number_17, m2_.email AS email_18, m2_.phone AS phone_19, m2_.city AS city_20, m2_.address AS address_21, m2_.profession AS profession_22, m2_.membership_type AS membership_type_23, m2_.status AS status_24, m2_.skills AS skills_25, m2_.joined_at AS joined_at_26, m2_.role_in_department AS role_in_department_27, m2_.created_at AS created_at_28, d0_.manager_id AS manager_id_29, m2_.user_id AS user_id_30, m2_.department_id AS department_id_31 FROM department d0_ LEFT JOIN "user" u1_ ON d0_.manager_id = u1_.id LEFT JOIN member m2_ ON d0_.id = m2_.department_id ORDER BY d0_.display_order ASC
SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.code AS code_2, d0_.description AS description_3, d0_.icon AS icon_4, d0_.color AS color_5, d0_.display_order AS display_order_6, d0_.created_at AS created_at_7, u1_.id AS id_8, u1_.email AS email_9, u1_.roles AS roles_10, u1_.password AS password_11, u1_.full_name AS full_name_12, u1_.created_at AS created_at_13, m2_.id AS id_14, m2_.first_name AS first_name_15, m2_.last_name AS last_name_16, m2_.cin_number AS cin_number_17, m2_.email AS email_18, m2_.phone AS phone_19, m2_.city AS city_20, m2_.address AS address_21, m2_.profession AS profession_22, m2_.membership_type AS membership_type_23, m2_.status AS status_24, m2_.skills AS skills_25, m2_.joined_at AS joined_at_26, m2_.role_in_department AS role_in_department_27, m2_.created_at AS created_at_28, d0_.manager_id AS manager_id_29, m2_.user_id AS user_id_30, m2_.department_id AS department_id_31 FROM department d0_ LEFT JOIN "user" u1_ ON d0_.manager_id = u1_.id LEFT JOIN member m2_ ON d0_.id = m2_.department_id ORDER BY d0_.display_order ASC;
|