1.65 ms (21.24%)
|
1 |
SELECT t0.id AS id_2, t0.year AS year_3, t0.days_min AS days_min_4, t0.description AS description_5, t0.reference AS reference_6, t0.status AS status_7, t0.price AS price_8, t0.registration_number AS registration_number_9, t0.registration_letter AS registration_letter_10, t0.registration_city_code AS registration_city_code_11, t0.created_at AS created_at_12, t0.city_id AS city_id_13, t0.agency_id AS agency_id_14, t0.model_id AS model_id_15, t0.discriminator_type, t1.seats_nbr AS seats_nbr_16, t1.doors_nbr AS doors_nbr_17, t1.child_seat AS child_seat_18, t1.gear_box AS gear_box_19, t1.fuel AS fuel_20, t1.type AS type_21 FROM vehicle t0 LEFT JOIN car t1 ON t0.id = t1.id WHERE t0.id = ?
Parameters: [
"019bd724-3ceb-72b6-ba4b-67e59a9a53e8"
]
SELECT t0.id AS id_2, t0.year AS year_3, t0.days_min AS days_min_4, t0.description AS description_5, t0.reference AS reference_6, t0.status AS status_7, t0.price AS price_8, t0.registration_number AS registration_number_9, t0.registration_letter AS registration_letter_10, t0.registration_city_code AS registration_city_code_11, t0.created_at AS created_at_12, t0.city_id AS city_id_13, t0.agency_id AS agency_id_14, t0.model_id AS model_id_15, t0.discriminator_type, t1.seats_nbr AS seats_nbr_16, t1.doors_nbr AS doors_nbr_17, t1.child_seat AS child_seat_18, t1.gear_box AS gear_box_19, t1.fuel AS fuel_20, t1.type AS type_21 FROM vehicle t0 LEFT JOIN car t1 ON t0.id = t1.id WHERE t0.id = '019bd724-3ceb-72b6-ba4b-67e59a9a53e8';
|
1.10 ms (14.11%)
|
1 |
SELECT t1.id AS id_2, t1.email AS email_3, t1.roles AS roles_4, t1.password AS password_5, t1.is_email_verified AS is_email_verified_6, t1.is_phone_verified AS is_phone_verified_7, t1.email_verification_token AS email_verification_token_8, t1.phone_verification_token AS phone_verification_token_9, t1.status AS status_10, t1.pending_email AS pending_email_11, t1.pending_phone AS pending_phone_12, t1.reference AS reference_13, t1.created_at AS created_at_14, t1.last_name AS last_name_15, t1.first_name AS first_name_16, t1.phone AS phone_17, t0.name AS name_18, t0.profile_picture AS profile_picture_19, t0.description AS description_20, t0.slug AS slug_21, t0.is_visible AS is_visible_22, t1.discriminator_type FROM agency t0 INNER JOIN user t1 ON t0.id = t1.id WHERE t1.id = ?
Parameters: [
"019bd724-3715-7380-812d-4036cbef3751"
]
SELECT t1.id AS id_2, t1.email AS email_3, t1.roles AS roles_4, t1.password AS password_5, t1.is_email_verified AS is_email_verified_6, t1.is_phone_verified AS is_phone_verified_7, t1.email_verification_token AS email_verification_token_8, t1.phone_verification_token AS phone_verification_token_9, t1.status AS status_10, t1.pending_email AS pending_email_11, t1.pending_phone AS pending_phone_12, t1.reference AS reference_13, t1.created_at AS created_at_14, t1.last_name AS last_name_15, t1.first_name AS first_name_16, t1.phone AS phone_17, t0.name AS name_18, t0.profile_picture AS profile_picture_19, t0.description AS description_20, t0.slug AS slug_21, t0.is_visible AS is_visible_22, t1.discriminator_type FROM agency t0 INNER JOIN user t1 ON t0.id = t1.id WHERE t1.id = '019bd724-3715-7380-812d-4036cbef3751';
|
0.58 ms (7.46%)
|
1 |
SELECT t0.id AS id_1, t0.rating AS rating_2, t0.comment AS comment_3, t0.reference AS reference_4, t0.created_at AS created_at_5, t0.client_id AS client_id_6, t0.agency_id AS agency_id_7 FROM review t0 WHERE t0.agency_id = ? ORDER BY t0.created_at DESC
Parameters: [
"019bd724-3715-7380-812d-4036cbef3751"
]
SELECT t0.id AS id_1, t0.rating AS rating_2, t0.comment AS comment_3, t0.reference AS reference_4, t0.created_at AS created_at_5, t0.client_id AS client_id_6, t0.agency_id AS agency_id_7 FROM review t0 WHERE t0.agency_id = '019bd724-3715-7380-812d-4036cbef3751' ORDER BY t0.created_at DESC;
|