0.41 ms (18.24%)
|
1 |
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.description AS description_3, t0.attendance_id AS attendance_id_4, t0.received_by_id AS received_by_id_5 FROM business_done t0 WHERE t0.attendance_id = ?
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.description AS description_3, t0.attendance_id AS attendance_id_4, t0.received_by_id AS received_by_id_5 FROM business_done t0 WHERE t0.attendance_id = 12;
|
0.37 ms (16.39%)
|
1 |
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.nombre AS nombre_5, t0.apaterno AS apaterno_6, t0.amaterno AS amaterno_7, t0.email AS email_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11, t0.specialty AS specialty_12, t0.company AS company_13, t0.phone AS phone_14, t0.sphere_id AS sphere_id_15, t0.bni_group_id AS bni_group_id_16 FROM `user` t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.nombre AS nombre_5, t0.apaterno AS apaterno_6, t0.amaterno AS amaterno_7, t0.email AS email_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11, t0.specialty AS specialty_12, t0.company AS company_13, t0.phone AS phone_14, t0.sphere_id AS sphere_id_15, t0.bni_group_id AS bni_group_id_16 FROM `user` t0 WHERE t0.id = 27;
|
0.35 ms (15.64%)
|
1 |
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.nombre AS nombre_4, u0_.apaterno AS apaterno_5, u0_.amaterno AS amaterno_6, u0_.email AS email_7, u0_.created_at AS created_at_8, u0_.updated_at AS updated_at_9, u0_.deleted_at AS deleted_at_10, u0_.specialty AS specialty_11, u0_.company AS company_12, u0_.phone AS phone_13, u0_.sphere_id AS sphere_id_14, u0_.bni_group_id AS bni_group_id_15 FROM `user` u0_ WHERE u0_.deleted_at IS NULL AND u0_.bni_group_id = ? ORDER BY u0_.nombre ASC
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.nombre AS nombre_4, u0_.apaterno AS apaterno_5, u0_.amaterno AS amaterno_6, u0_.email AS email_7, u0_.created_at AS created_at_8, u0_.updated_at AS updated_at_9, u0_.deleted_at AS deleted_at_10, u0_.specialty AS specialty_11, u0_.company AS company_12, u0_.phone AS phone_13, u0_.sphere_id AS sphere_id_14, u0_.bni_group_id AS bni_group_id_15 FROM `user` u0_ WHERE u0_.deleted_at IS NULL AND u0_.bni_group_id = 1 ORDER BY u0_.nombre ASC;
|
0.33 ms (14.74%)
|
1 |
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.nombre AS nombre_4, u0_.apaterno AS apaterno_5, u0_.amaterno AS amaterno_6, u0_.email AS email_7, u0_.created_at AS created_at_8, u0_.updated_at AS updated_at_9, u0_.deleted_at AS deleted_at_10, u0_.specialty AS specialty_11, u0_.company AS company_12, u0_.phone AS phone_13, u0_.sphere_id AS sphere_id_14, u0_.bni_group_id AS bni_group_id_15 FROM `user` u0_ WHERE u0_.deleted_at IS NULL AND u0_.sphere_id = ? AND u0_.id <> ? ORDER BY u0_.nombre ASC
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.nombre AS nombre_4, u0_.apaterno AS apaterno_5, u0_.amaterno AS amaterno_6, u0_.email AS email_7, u0_.created_at AS created_at_8, u0_.updated_at AS updated_at_9, u0_.deleted_at AS deleted_at_10, u0_.specialty AS specialty_11, u0_.company AS company_12, u0_.phone AS phone_13, u0_.sphere_id AS sphere_id_14, u0_.bni_group_id AS bni_group_id_15 FROM `user` u0_ WHERE u0_.deleted_at IS NULL AND u0_.sphere_id = 6 AND u0_.id <> 27 ORDER BY u0_.nombre ASC;
|
0.31 ms (13.51%)
|
1 |
SELECT t0.id AS id_1, t0.status AS status_2, t0.type AS type_3, t0.business_closed AS business_closed_4, t0.referrals_given AS referrals_given_5, t0.guest_name AS guest_name_6, t0.guest_company AS guest_company_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10, t0.user_id AS user_id_11, t0.meeting_id AS meeting_id_12, t0.invited_by_id AS invited_by_id_13 FROM attendance t0 WHERE t0.user_id = ? AND t0.meeting_id = ? AND t0.deleted_at IS NULL LIMIT 1
SELECT t0.id AS id_1, t0.status AS status_2, t0.type AS type_3, t0.business_closed AS business_closed_4, t0.referrals_given AS referrals_given_5, t0.guest_name AS guest_name_6, t0.guest_company AS guest_company_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10, t0.user_id AS user_id_11, t0.meeting_id AS meeting_id_12, t0.invited_by_id AS invited_by_id_13 FROM attendance t0 WHERE t0.user_id = 27 AND t0.meeting_id = 1 AND t0.deleted_at IS NULL LIMIT 1;
|
0.26 ms (11.30%)
|
1 |
SELECT t0.id AS id_1, t0.date AS date_2, t0.qr_token AS qr_token_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.start_time AS start_time_8, t0.bni_group_id AS bni_group_id_9 FROM meeting t0 WHERE t0.qr_token = ? AND t0.status = ? LIMIT 1
Parameters: [
"1cf31d0bf388a0bf3d1a6c3d467664"
"OPEN"
]
SELECT t0.id AS id_1, t0.date AS date_2, t0.qr_token AS qr_token_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.start_time AS start_time_8, t0.bni_group_id AS bni_group_id_9 FROM meeting t0 WHERE t0.qr_token = '1cf31d0bf388a0bf3d1a6c3d467664' AND t0.status = 'OPEN' LIMIT 1;
|
0.23 ms (10.19%)
|
1 |
SELECT t0.id AS id_1, t0.contact_name AS contact_name_2, t0.contact_phone AS contact_phone_3, t0.description AS description_4, t0.referred_user_id AS referred_user_id_5, t0.attendance_id AS attendance_id_6 FROM reference t0 WHERE t0.attendance_id = ?
SELECT t0.id AS id_1, t0.contact_name AS contact_name_2, t0.contact_phone AS contact_phone_3, t0.description AS description_4, t0.referred_user_id AS referred_user_id_5, t0.attendance_id AS attendance_id_6 FROM reference t0 WHERE t0.attendance_id = 12;
|