1
0.42 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 ASC LIMIT 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 ASC LIMIT 20 ;
Copy
2
0.47 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 ASC
Parameters :
[
1
2
45
46
47
48
17
18
19
20
21
22
23
24
31
32
33
34
35
36
]
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 (1 , 2 , 45 , 46 , 47 , 48 , 17 , 18 , 19 , 20 , 21 , 22 , 23 , 24 , 31 , 32 , 33 , 34 , 35 , 36 ) ORDER BY b0_ . brewer_id ASC ;
Copy
3
0.33 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.44 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 = 1 ;
Copy
5
0.32 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 = 2 ;
Copy
6
0.32 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
7
0.34 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