1
0.40 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 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 ASC LIMIT 20 OFFSET 40 ;
Copy
2
0.92 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 :
[
16
3
4
5
6
7
8
9
]
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 (16 , 3 , 4 , 5 , 6 , 7 , 8 , 9 ) ORDER BY b0_ . brewer_id ASC ;
Copy
3
0.65 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.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 = 10 ;
Copy
5
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 = 13 ;
Copy
6
0.35 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