1
4.54 ms
SELECT r0_ . id AS id_0 , r0_ . reference AS reference_1 , r0_ . date_rdv AS date_rdv_2 , r0_ . status AS status_3 , r0_ . total_price AS total_price_4 , r0_ . total_duration AS total_duration_5 , r0_ . comment AS comment_6 , r0_ . guest_firstname AS guest_firstname_7 , r0_ . guest_lastname AS guest_lastname_8 , r0_ . guest_email AS guest_email_9 , r0_ . guest_phone AS guest_phone_10 , r0_ . visit_address AS visit_address_11 , r0_ . client_id AS client_id_12 FROM reservation r0_ WHERE r0_ . status IN (? , ? , ? ) ORDER BY r0_ . date_rdv ASC
Parameters :
[
"CONFIRMED "
"PENDING_PAYMENT "
"PENDING "
]
SELECT r0_ . id AS id_0 , r0_ . reference AS reference_1 , r0_ . date_rdv AS date_rdv_2 , r0_ . status AS status_3 , r0_ . total_price AS total_price_4 , r0_ . total_duration AS total_duration_5 , r0_ . comment AS comment_6 , r0_ . guest_firstname AS guest_firstname_7 , r0_ . guest_lastname AS guest_lastname_8 , r0_ . guest_email AS guest_email_9 , r0_ . guest_phone AS guest_phone_10 , r0_ . visit_address AS visit_address_11 , r0_ . client_id AS client_id_12 FROM reservation r0_ WHERE r0_ . status IN ('CONFIRMED' , 'PENDING_PAYMENT' , 'PENDING' ) ORDER BY r0_ . date_rdv ASC ;
Copy
2
10.75 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . price AS price_4 , t0 . duration AS duration_5 , t0 . active AS active_6 , t0 . relation AS relation_7 , t0 . category_id AS category_id_8 FROM service t0 INNER JOIN reservation_service ON t0 . id = reservation_service . service_id WHERE reservation_service . reservation_id = ?
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . price AS price_4 , t0 . duration AS duration_5 , t0 . active AS active_6 , t0 . relation AS relation_7 , t0 . category_id AS category_id_8 FROM service t0 INNER JOIN reservation_service ON t0 . id = reservation_service . service_id WHERE reservation_service . reservation_id = 108 ;
Copy
3
0.73 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . price AS price_4 , t0 . duration AS duration_5 , t0 . active AS active_6 , t0 . relation AS relation_7 , t0 . category_id AS category_id_8 FROM service t0 INNER JOIN reservation_service ON t0 . id = reservation_service . service_id WHERE reservation_service . reservation_id = ?
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . price AS price_4 , t0 . duration AS duration_5 , t0 . active AS active_6 , t0 . relation AS relation_7 , t0 . category_id AS category_id_8 FROM service t0 INNER JOIN reservation_service ON t0 . id = reservation_service . service_id WHERE reservation_service . reservation_id = 96 ;
Copy
4
9.95 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . price AS price_4 , t0 . duration AS duration_5 , t0 . active AS active_6 , t0 . relation AS relation_7 , t0 . category_id AS category_id_8 FROM service t0 INNER JOIN reservation_service ON t0 . id = reservation_service . service_id WHERE reservation_service . reservation_id = ?
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . price AS price_4 , t0 . duration AS duration_5 , t0 . active AS active_6 , t0 . relation AS relation_7 , t0 . category_id AS category_id_8 FROM service t0 INNER JOIN reservation_service ON t0 . id = reservation_service . service_id WHERE reservation_service . reservation_id = 117 ;
Copy
5
3.45 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . price AS price_4 , t0 . duration AS duration_5 , t0 . active AS active_6 , t0 . relation AS relation_7 , t0 . category_id AS category_id_8 FROM service t0 INNER JOIN reservation_service ON t0 . id = reservation_service . service_id WHERE reservation_service . reservation_id = ?
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . price AS price_4 , t0 . duration AS duration_5 , t0 . active AS active_6 , t0 . relation AS relation_7 , t0 . category_id AS category_id_8 FROM service t0 INNER JOIN reservation_service ON t0 . id = reservation_service . service_id WHERE reservation_service . reservation_id = 118 ;
Copy
6
0.59 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . price AS price_4 , t0 . duration AS duration_5 , t0 . active AS active_6 , t0 . relation AS relation_7 , t0 . category_id AS category_id_8 FROM service t0 INNER JOIN reservation_service ON t0 . id = reservation_service . service_id WHERE reservation_service . reservation_id = ?
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . price AS price_4 , t0 . duration AS duration_5 , t0 . active AS active_6 , t0 . relation AS relation_7 , t0 . category_id AS category_id_8 FROM service t0 INNER JOIN reservation_service ON t0 . id = reservation_service . service_id WHERE reservation_service . reservation_id = 112 ;
Copy
7
0.50 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . price AS price_4 , t0 . duration AS duration_5 , t0 . active AS active_6 , t0 . relation AS relation_7 , t0 . category_id AS category_id_8 FROM service t0 INNER JOIN reservation_service ON t0 . id = reservation_service . service_id WHERE reservation_service . reservation_id = ?
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . price AS price_4 , t0 . duration AS duration_5 , t0 . active AS active_6 , t0 . relation AS relation_7 , t0 . category_id AS category_id_8 FROM service t0 INNER JOIN reservation_service ON t0 . id = reservation_service . service_id WHERE reservation_service . reservation_id = 101 ;
Copy
8
0.56 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . price AS price_4 , t0 . duration AS duration_5 , t0 . active AS active_6 , t0 . relation AS relation_7 , t0 . category_id AS category_id_8 FROM service t0 INNER JOIN reservation_service ON t0 . id = reservation_service . service_id WHERE reservation_service . reservation_id = ?
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . price AS price_4 , t0 . duration AS duration_5 , t0 . active AS active_6 , t0 . relation AS relation_7 , t0 . category_id AS category_id_8 FROM service t0 INNER JOIN reservation_service ON t0 . id = reservation_service . service_id WHERE reservation_service . reservation_id = 109 ;
Copy
9
1.64 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . price AS price_4 , t0 . duration AS duration_5 , t0 . active AS active_6 , t0 . relation AS relation_7 , t0 . category_id AS category_id_8 FROM service t0 INNER JOIN reservation_service ON t0 . id = reservation_service . service_id WHERE reservation_service . reservation_id = ?
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . price AS price_4 , t0 . duration AS duration_5 , t0 . active AS active_6 , t0 . relation AS relation_7 , t0 . category_id AS category_id_8 FROM service t0 INNER JOIN reservation_service ON t0 . id = reservation_service . service_id WHERE reservation_service . reservation_id = 107 ;
Copy
10
3.82 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . price AS price_4 , t0 . duration AS duration_5 , t0 . active AS active_6 , t0 . relation AS relation_7 , t0 . category_id AS category_id_8 FROM service t0 INNER JOIN reservation_service ON t0 . id = reservation_service . service_id WHERE reservation_service . reservation_id = ?
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . price AS price_4 , t0 . duration AS duration_5 , t0 . active AS active_6 , t0 . relation AS relation_7 , t0 . category_id AS category_id_8 FROM service t0 INNER JOIN reservation_service ON t0 . id = reservation_service . service_id WHERE reservation_service . reservation_id = 105 ;
Copy
11
2.18 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . price AS price_4 , t0 . duration AS duration_5 , t0 . active AS active_6 , t0 . relation AS relation_7 , t0 . category_id AS category_id_8 FROM service t0 INNER JOIN reservation_service ON t0 . id = reservation_service . service_id WHERE reservation_service . reservation_id = ?
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . price AS price_4 , t0 . duration AS duration_5 , t0 . active AS active_6 , t0 . relation AS relation_7 , t0 . category_id AS category_id_8 FROM service t0 INNER JOIN reservation_service ON t0 . id = reservation_service . service_id WHERE reservation_service . reservation_id = 110 ;
Copy
12
0.61 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . price AS price_4 , t0 . duration AS duration_5 , t0 . active AS active_6 , t0 . relation AS relation_7 , t0 . category_id AS category_id_8 FROM service t0 INNER JOIN reservation_service ON t0 . id = reservation_service . service_id WHERE reservation_service . reservation_id = ?
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . price AS price_4 , t0 . duration AS duration_5 , t0 . active AS active_6 , t0 . relation AS relation_7 , t0 . category_id AS category_id_8 FROM service t0 INNER JOIN reservation_service ON t0 . id = reservation_service . service_id WHERE reservation_service . reservation_id = 97 ;
Copy
13
1.16 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . price AS price_4 , t0 . duration AS duration_5 , t0 . active AS active_6 , t0 . relation AS relation_7 , t0 . category_id AS category_id_8 FROM service t0 INNER JOIN reservation_service ON t0 . id = reservation_service . service_id WHERE reservation_service . reservation_id = ?
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . price AS price_4 , t0 . duration AS duration_5 , t0 . active AS active_6 , t0 . relation AS relation_7 , t0 . category_id AS category_id_8 FROM service t0 INNER JOIN reservation_service ON t0 . id = reservation_service . service_id WHERE reservation_service . reservation_id = 115 ;
Copy
14
2.38 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . price AS price_4 , t0 . duration AS duration_5 , t0 . active AS active_6 , t0 . relation AS relation_7 , t0 . category_id AS category_id_8 FROM service t0 INNER JOIN reservation_service ON t0 . id = reservation_service . service_id WHERE reservation_service . reservation_id = ?
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . price AS price_4 , t0 . duration AS duration_5 , t0 . active AS active_6 , t0 . relation AS relation_7 , t0 . category_id AS category_id_8 FROM service t0 INNER JOIN reservation_service ON t0 . id = reservation_service . service_id WHERE reservation_service . reservation_id = 106 ;
Copy