1
0.44 ms
SELECT DISTINCT b0_ . id AS id_0 , b0_ . brewer_id AS sclr_1 FROM beer b0_ LEFT JOIN brewer b1_ ON b0_ . brewer_id = b1_ . id ORDER BY b0_ . brewer_id DESC LIMIT 20 OFFSET 20
SELECT DISTINCT b0_ . id AS id_0 , b0_ . brewer_id AS sclr_1 FROM beer b0_ LEFT JOIN brewer b1_ ON b0_ . brewer_id = b1_ . id ORDER BY b0_ . brewer_id DESC LIMIT 20 OFFSET 20 ;
Copy
2
0.46 ms
SELECT b0_ . id AS id_0 , b0_ . name AS name_1 , b0_ . alcool AS alcool_2 , b0_ . type AS type_3 , b0_ . position AS position_4 , b0_ . brewer_id AS brewer_id_5 FROM beer b0_ LEFT JOIN brewer b1_ ON b0_ . brewer_id = b1_ . id WHERE b0_ . id IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) ORDER BY b0_ . brewer_id DESC
Parameters :
[
44
43
42
41
40
39
38
37
36
35
34
33
32
31
24
23
22
21
20
19
]
SELECT b0_ . id AS id_0 , b0_ . name AS name_1 , b0_ . alcool AS alcool_2 , b0_ . type AS type_3 , b0_ . position AS position_4 , b0_ . brewer_id AS brewer_id_5 FROM beer b0_ LEFT JOIN brewer b1_ ON b0_ . brewer_id = b1_ . id WHERE b0_ . id IN (44 , 43 , 42 , 41 , 40 , 39 , 38 , 37 , 36 , 35 , 34 , 33 , 32 , 31 , 24 , 23 , 22 , 21 , 20 , 19 ) ORDER BY b0_ . brewer_id DESC ;
Copy
3
0.32 ms
SELECT count (DISTINCT b0_ . id ) AS sclr_0 FROM beer b0_ LEFT JOIN brewer b1_ ON b0_ . brewer_id = b1_ . id
SELECT count (DISTINCT b0_ . id ) AS sclr_0 FROM beer b0_ LEFT JOIN brewer b1_ ON b0_ . brewer_id = b1_ . id ;
Copy
4
0.31 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . logo AS logo_3 , t0 . locality AS locality_4 , t0 . position AS position_5 , t0 . latitude AS latitude_6 , t0 . longitude AS longitude_7 , t0 . facebook AS facebook_8 , t0 . instagram AS instagram_9 , t0 . website AS website_10 , t0 . untapped AS untapped_11 , t0 . twitter AS twitter_12 , t0 . white_bg AS white_bg_13 FROM brewer t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . logo AS logo_3 , t0 . locality AS locality_4 , t0 . position AS position_5 , t0 . latitude AS latitude_6 , t0 . longitude AS longitude_7 , t0 . facebook AS facebook_8 , t0 . instagram AS instagram_9 , t0 . website AS website_10 , t0 . untapped AS untapped_11 , t0 . twitter AS twitter_12 , t0 . white_bg AS white_bg_13 FROM brewer t0 WHERE t0 . id = 5 ;
Copy
5
0.40 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . logo AS logo_3 , t0 . locality AS locality_4 , t0 . position AS position_5 , t0 . latitude AS latitude_6 , t0 . longitude AS longitude_7 , t0 . facebook AS facebook_8 , t0 . instagram AS instagram_9 , t0 . website AS website_10 , t0 . untapped AS untapped_11 , t0 . twitter AS twitter_12 , t0 . white_bg AS white_bg_13 FROM brewer t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . logo AS logo_3 , t0 . locality AS locality_4 , t0 . position AS position_5 , t0 . latitude AS latitude_6 , t0 . longitude AS longitude_7 , t0 . facebook AS facebook_8 , t0 . instagram AS instagram_9 , t0 . website AS website_10 , t0 . untapped AS untapped_11 , t0 . twitter AS twitter_12 , t0 . white_bg AS white_bg_13 FROM brewer t0 WHERE t0 . id = 4 ;
Copy
6
0.38 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . logo AS logo_3 , t0 . locality AS locality_4 , t0 . position AS position_5 , t0 . latitude AS latitude_6 , t0 . longitude AS longitude_7 , t0 . facebook AS facebook_8 , t0 . instagram AS instagram_9 , t0 . website AS website_10 , t0 . untapped AS untapped_11 , t0 . twitter AS twitter_12 , t0 . white_bg AS white_bg_13 FROM brewer t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . logo AS logo_3 , t0 . locality AS locality_4 , t0 . position AS position_5 , t0 . latitude AS latitude_6 , t0 . longitude AS longitude_7 , t0 . facebook AS facebook_8 , t0 . instagram AS instagram_9 , t0 . website AS website_10 , t0 . untapped AS untapped_11 , t0 . twitter AS twitter_12 , t0 . white_bg AS white_bg_13 FROM brewer t0 WHERE t0 . id = 3 ;
Copy