Symfony Profiler

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;

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;

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;

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
  40

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 40;

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

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 (19, 14, 15, 17, 16, 11, 13, 12, 9, 8) ORDER BY e0_.date DESC;

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;

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;

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;

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 = 5;

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;