1
0.32 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
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 ;
Copy
2
0.34 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 :
[
9
8
7
6
5
4
3
16
15
14
13
12
11
10
30
29
28
27
26
25
]
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 (9 , 8 , 7 , 6 , 5 , 4 , 3 , 16 , 15 , 14 , 13 , 12 , 11 , 10 , 30 , 29 , 28 , 27 , 26 , 25 ) ORDER BY b0_ . brewer_id DESC ;
Copy
3
0.24 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.23 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 = 17 ;
Copy
5
0.23 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 = 13 ;
Copy
6
0.30 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 = 10 ;
Copy
7
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 = 8 ;
Copy
8
0.28 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 = 6 ;
Copy