1
2.90 ms
SELECT DISTINCT r0_ . id AS id_0 , r0_ . id AS id_1 FROM reservation r0_ ORDER BY r0_ . id ASC LIMIT 20
SELECT DISTINCT r0_ . id AS id_0 , r0_ . id AS id_1 FROM reservation r0_ ORDER BY r0_ . id ASC LIMIT 20 ;
Copy
2
1.46 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_ . id IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) ORDER BY r0_ . id ASC
Parameters :
[
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
]
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_ . id IN (96 , 97 , 98 , 99 , 100 , 101 , 102 , 103 , 104 , 105 , 106 , 107 , 108 , 109 , 110 , 111 , 112 , 113 , 114 , 115 ) ORDER BY r0_ . id ASC ;
Copy
3
0.56 ms
SELECT count (* ) AS sclr_0 FROM reservation r0_
SELECT count (* ) AS sclr_0 FROM reservation r0_ ;
Copy
4
1.60 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
5
1.15 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
6
0.99 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 = 98 ;
Copy
7
0.79 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 = 99 ;
Copy
8
0.65 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 = 100 ;
Copy
9
0.78 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
10
1.33 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 = 102 ;
Copy
11
1.25 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 = 103 ;
Copy
12
1.01 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 = 104 ;
Copy
13
0.71 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
14
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 = 106 ;
Copy
15
0.70 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
16
0.71 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
17
0.62 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
18
0.63 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
19
0.71 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 = 111 ;
Copy
20
0.90 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
21
0.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 = 113 ;
Copy
22
0.68 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 = 114 ;
Copy
23
0.66 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