1
1.18 ms
SELECT count (DISTINCT e0_ . id ) AS sclr_0 FROM event e0_ LEFT JOIN tribe t1_ ON e0_ . tribe_id = t1_ . id WHERE e0_ . date > = CURRENT_TIMESTAMP
SELECT count (DISTINCT e0_ . id ) AS sclr_0 FROM event e0_ LEFT JOIN tribe t1_ ON e0_ . tribe_id = t1_ . id WHERE e0_ . date > = CURRENT_TIMESTAMP ;
Copy
2
0.58 ms
SELECT DISTINCT e0_ . id AS id_0 , e0_ . date AS date_1 FROM event e0_ LEFT JOIN tribe t1_ ON e0_ . tribe_id = t1_ . id WHERE e0_ . date > = CURRENT_TIMESTAMP ORDER BY e0_ . date ASC LIMIT 10
SELECT DISTINCT e0_ . id AS id_0 , e0_ . date AS date_1 FROM event e0_ LEFT JOIN tribe t1_ ON e0_ . tribe_id = t1_ . id WHERE e0_ . date > = CURRENT_TIMESTAMP ORDER BY e0_ . date ASC LIMIT 10 ;
Copy
3
0.73 ms
SELECT count (DISTINCT e0_ . id ) AS sclr_0 FROM event e0_ LEFT JOIN tribe t1_ ON e0_ . tribe_id = t1_ . id WHERE e0_ . date < CURRENT_TIMESTAMP
SELECT count (DISTINCT e0_ . id ) AS sclr_0 FROM event e0_ LEFT JOIN tribe t1_ ON e0_ . tribe_id = t1_ . id WHERE e0_ . date < CURRENT_TIMESTAMP ;
Copy
4
0.69 ms
SELECT DISTINCT e0_ . id AS id_0 , e0_ . date AS date_1 FROM event e0_ LEFT JOIN tribe t1_ ON e0_ . tribe_id = t1_ . id WHERE e0_ . date < CURRENT_TIMESTAMP ORDER BY e0_ . date DESC LIMIT 10 OFFSET 10
SELECT DISTINCT e0_ . id AS id_0 , e0_ . date AS date_1 FROM event e0_ LEFT JOIN tribe t1_ ON e0_ . tribe_id = t1_ . id WHERE e0_ . date < CURRENT_TIMESTAMP ORDER BY e0_ . date DESC LIMIT 10 OFFSET 10 ;
Copy
5
0.99 ms
SELECT e0_ . id AS id_0 , e0_ . title AS title_1 , e0_ . date AS date_2 , e0_ . description AS description_3 , e0_ . city AS city_4 , e0_ . address AS address_5 , e0_ . background_picture AS background_picture_6 , e0_ . is_validated AS is_validated_7 , e0_ . slug AS slug_8 , e0_ . summary AS summary_9 , e0_ . announcement AS announcement_10 , e0_ . remind AS remind_11 , e0_ . attendees_count AS attendees_count_12 , e0_ . price AS price_13 , e0_ . poster AS poster_14 , e0_ . host_id AS host_id_15 , e0_ . tribe_id AS tribe_id_16 , e0_ . category_id AS category_id_17 FROM event e0_ LEFT JOIN tribe t1_ ON e0_ . tribe_id = t1_ . id WHERE e0_ . date < CURRENT_TIMESTAMP AND e0_ . id IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) ORDER BY e0_ . date DESC
Parameters :
[
48
43
47
45
46
44
41
25
39
42
]
SELECT e0_ . id AS id_0 , e0_ . title AS title_1 , e0_ . date AS date_2 , e0_ . description AS description_3 , e0_ . city AS city_4 , e0_ . address AS address_5 , e0_ . background_picture AS background_picture_6 , e0_ . is_validated AS is_validated_7 , e0_ . slug AS slug_8 , e0_ . summary AS summary_9 , e0_ . announcement AS announcement_10 , e0_ . remind AS remind_11 , e0_ . attendees_count AS attendees_count_12 , e0_ . price AS price_13 , e0_ . poster AS poster_14 , e0_ . host_id AS host_id_15 , e0_ . tribe_id AS tribe_id_16 , e0_ . category_id AS category_id_17 FROM event e0_ LEFT JOIN tribe t1_ ON e0_ . tribe_id = t1_ . id WHERE e0_ . date < CURRENT_TIMESTAMP AND e0_ . id IN (48 , 43 , 47 , 45 , 46 , 44 , 41 , 25 , 39 , 42 ) ORDER BY e0_ . date DESC ;
Copy
6
1.09 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . description AS description_3 , t0 . background_picture AS background_picture_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 , t0 . is_validated AS is_validated_7 , t0 . city AS city_8 , t0 . is_published AS is_published_9 , t0 . slug AS slug_10 , t0 . country AS country_11 , t0 . summary AS summary_12 , t0 . events_count AS events_count_13 , t0 . followers_count AS followers_count_14 , t0 . host_id AS host_id_15 FROM tribe t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . description AS description_3 , t0 . background_picture AS background_picture_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 , t0 . is_validated AS is_validated_7 , t0 . city AS city_8 , t0 . is_published AS is_published_9 , t0 . slug AS slug_10 , t0 . country AS country_11 , t0 . summary AS summary_12 , t0 . events_count AS events_count_13 , t0 . followers_count AS followers_count_14 , t0 . host_id AS host_id_15 FROM tribe t0 WHERE t0 . id = 1 ;
Copy
7
0.42 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . description AS description_3 , t0 . background_picture AS background_picture_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 , t0 . is_validated AS is_validated_7 , t0 . city AS city_8 , t0 . is_published AS is_published_9 , t0 . slug AS slug_10 , t0 . country AS country_11 , t0 . summary AS summary_12 , t0 . events_count AS events_count_13 , t0 . followers_count AS followers_count_14 , t0 . host_id AS host_id_15 FROM tribe t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . description AS description_3 , t0 . background_picture AS background_picture_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 , t0 . is_validated AS is_validated_7 , t0 . city AS city_8 , t0 . is_published AS is_published_9 , t0 . slug AS slug_10 , t0 . country AS country_11 , t0 . summary AS summary_12 , t0 . events_count AS events_count_13 , t0 . followers_count AS followers_count_14 , t0 . host_id AS host_id_15 FROM tribe t0 WHERE t0 . id = 7 ;
Copy
8
0.58 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . description AS description_3 , t0 . background_picture AS background_picture_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 , t0 . is_validated AS is_validated_7 , t0 . city AS city_8 , t0 . is_published AS is_published_9 , t0 . slug AS slug_10 , t0 . country AS country_11 , t0 . summary AS summary_12 , t0 . events_count AS events_count_13 , t0 . followers_count AS followers_count_14 , t0 . host_id AS host_id_15 FROM tribe t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . description AS description_3 , t0 . background_picture AS background_picture_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 , t0 . is_validated AS is_validated_7 , t0 . city AS city_8 , t0 . is_published AS is_published_9 , t0 . slug AS slug_10 , t0 . country AS country_11 , t0 . summary AS summary_12 , t0 . events_count AS events_count_13 , t0 . followers_count AS followers_count_14 , t0 . host_id AS host_id_15 FROM tribe t0 WHERE t0 . id = 11 ;
Copy
9
0.36 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . description AS description_3 , t0 . background_picture AS background_picture_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 , t0 . is_validated AS is_validated_7 , t0 . city AS city_8 , t0 . is_published AS is_published_9 , t0 . slug AS slug_10 , t0 . country AS country_11 , t0 . summary AS summary_12 , t0 . events_count AS events_count_13 , t0 . followers_count AS followers_count_14 , t0 . host_id AS host_id_15 FROM tribe t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . description AS description_3 , t0 . background_picture AS background_picture_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 , t0 . is_validated AS is_validated_7 , t0 . city AS city_8 , t0 . is_published AS is_published_9 , t0 . slug AS slug_10 , t0 . country AS country_11 , t0 . summary AS summary_12 , t0 . events_count AS events_count_13 , t0 . followers_count AS followers_count_14 , t0 . host_id AS host_id_15 FROM tribe t0 WHERE t0 . id = 2 ;
Copy
10
0.39 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . description AS description_3 , t0 . background_picture AS background_picture_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 , t0 . is_validated AS is_validated_7 , t0 . city AS city_8 , t0 . is_published AS is_published_9 , t0 . slug AS slug_10 , t0 . country AS country_11 , t0 . summary AS summary_12 , t0 . events_count AS events_count_13 , t0 . followers_count AS followers_count_14 , t0 . host_id AS host_id_15 FROM tribe t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . description AS description_3 , t0 . background_picture AS background_picture_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 , t0 . is_validated AS is_validated_7 , t0 . city AS city_8 , t0 . is_published AS is_published_9 , t0 . slug AS slug_10 , t0 . country AS country_11 , t0 . summary AS summary_12 , t0 . events_count AS events_count_13 , t0 . followers_count AS followers_count_14 , t0 . host_id AS host_id_15 FROM tribe t0 WHERE t0 . id = 12 ;
Copy
11
0.39 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . description AS description_3 , t0 . background_picture AS background_picture_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 , t0 . is_validated AS is_validated_7 , t0 . city AS city_8 , t0 . is_published AS is_published_9 , t0 . slug AS slug_10 , t0 . country AS country_11 , t0 . summary AS summary_12 , t0 . events_count AS events_count_13 , t0 . followers_count AS followers_count_14 , t0 . host_id AS host_id_15 FROM tribe t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . description AS description_3 , t0 . background_picture AS background_picture_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 , t0 . is_validated AS is_validated_7 , t0 . city AS city_8 , t0 . is_published AS is_published_9 , t0 . slug AS slug_10 , t0 . country AS country_11 , t0 . summary AS summary_12 , t0 . events_count AS events_count_13 , t0 . followers_count AS followers_count_14 , t0 . host_id AS host_id_15 FROM tribe t0 WHERE t0 . id = 10 ;
Copy
12
0.35 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . description AS description_3 , t0 . background_picture AS background_picture_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 , t0 . is_validated AS is_validated_7 , t0 . city AS city_8 , t0 . is_published AS is_published_9 , t0 . slug AS slug_10 , t0 . country AS country_11 , t0 . summary AS summary_12 , t0 . events_count AS events_count_13 , t0 . followers_count AS followers_count_14 , t0 . host_id AS host_id_15 FROM tribe t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . description AS description_3 , t0 . background_picture AS background_picture_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 , t0 . is_validated AS is_validated_7 , t0 . city AS city_8 , t0 . is_published AS is_published_9 , t0 . slug AS slug_10 , t0 . country AS country_11 , t0 . summary AS summary_12 , t0 . events_count AS events_count_13 , t0 . followers_count AS followers_count_14 , t0 . host_id AS host_id_15 FROM tribe t0 WHERE t0 . id = 3 ;
Copy