2.47 ms (70.18%)
|
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.full_name AS full_name_5, t0.profile AS profile_6, t0.token AS token_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t10.id AS id_11, t10.cree_le AS cree_le_12, t10.modifie_le AS modifie_le_13, t10.nom_complet AS nom_complet_14, t10.email AS email_15, t10.telephone AS telephone_16, t10.adresse AS adresse_17, t10.rccm AS rccm_18, t10.type AS type_19, t10.token AS token_20, t10.company_name AS company_name_21, t10.contact_name AS contact_name_22, t10.contact_email AS contact_email_23, t10.contact_phone AS contact_phone_24, t10.linked_user_id AS linked_user_id_25, t10.structure_id AS structure_id_26, t0.structure_id AS structure_id_27 FROM "user" t0 LEFT JOIN clients t10 ON t10.linked_user_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.full_name AS full_name_5, t0.profile AS profile_6, t0.token AS token_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t10.id AS id_11, t10.cree_le AS cree_le_12, t10.modifie_le AS modifie_le_13, t10.nom_complet AS nom_complet_14, t10.email AS email_15, t10.telephone AS telephone_16, t10.adresse AS adresse_17, t10.rccm AS rccm_18, t10.type AS type_19, t10.token AS token_20, t10.company_name AS company_name_21, t10.contact_name AS contact_name_22, t10.contact_email AS contact_email_23, t10.contact_phone AS contact_phone_24, t10.linked_user_id AS linked_user_id_25, t10.structure_id AS structure_id_26, t0.structure_id AS structure_id_27 FROM "user" t0 LEFT JOIN clients t10 ON t10.linked_user_id = t0.id WHERE t0.id = 3;
|
1.05 ms (29.82%)
|
1 |
SELECT t0.id AS id_1, t0.message AS message_2, t0.is_read AS is_read_3, t0.reference AS reference_4, t0.created_at AS created_at_5, t0.related_user_id AS related_user_id_6 FROM notification t0 WHERE t0.related_user_id = ? AND t0.is_read = ? ORDER BY t0.created_at DESC LIMIT 5
SELECT t0.id AS id_1, t0.message AS message_2, t0.is_read AS is_read_3, t0.reference AS reference_4, t0.created_at AS created_at_5, t0.related_user_id AS related_user_id_6 FROM notification t0 WHERE t0.related_user_id = 3 AND t0.is_read = 0 ORDER BY t0.created_at DESC LIMIT 5;
|