1
0.43 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 40
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 40 ;
Copy
2
0.35 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 :
[
18
17
48
47
46
45
2
1
]
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 (18 , 17 , 48 , 47 , 46 , 45 , 2 , 1 ) ORDER BY b0_ . brewer_id DESC ;
Copy
3
0.29 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.25 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
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 = 2 ;
Copy
6
0.24 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