Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.firstname AS firstname_5,
  t0.lastname AS lastname_6,
  t0.description AS description_7,
  t0.city AS city_8,
  t0.country AS country_9,
  t0.postal_code AS postal_code_10,
  t0.birth_date AS birth_date_11,
  t0.phone AS phone_12,
  t0.gender AS gender_13,
  t0.admin_public_profile AS admin_public_profile_14,
  t0.stripe_id AS stripe_id_15,
  t0.fti AS fti_16,
  t0.title AS title_17,
  t0.notification_token AS notification_token_18,
  t0.accept_notification AS accept_notification_19,
  t0.google_id AS google_id_20,
  t0.google_name AS google_name_21,
  t0.delete_request_date AS delete_request_date_22,
  t0.created_at AS created_at_23,
  t0.updated_at AS updated_at_24
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.description AS description_7, t0.city AS city_8, t0.country AS country_9, t0.postal_code AS postal_code_10, t0.birth_date AS birth_date_11, t0.phone AS phone_12, t0.gender AS gender_13, t0.admin_public_profile AS admin_public_profile_14, t0.stripe_id AS stripe_id_15, t0.fti AS fti_16, t0.title AS title_17, t0.notification_token AS notification_token_18, t0.accept_notification AS accept_notification_19, t0.google_id AS google_id_20, t0.google_name AS google_name_21, t0.delete_request_date AS delete_request_date_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24 FROM user t0 WHERE t0.id = 8;

SELECT
  t0.id AS id_1,
  t0.club_id AS club_id_2,
  t0.user_id AS user_id_3
FROM
  club_manager t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.club_id AS club_id_2, t0.user_id AS user_id_3 FROM club_manager t0 WHERE t0.user_id = 8;

SELECT
  count(u0_.id) AS sclr_0
FROM
  club c1_
  LEFT JOIN user_club u2_ ON c1_.id = u2_.club_id
  LEFT JOIN user u0_ ON u2_.user_id = u0_.id
WHERE
  u2_.club_id = ?

SELECT count(u0_.id) AS sclr_0 FROM club c1_ LEFT JOIN user_club u2_ ON c1_.id = u2_.club_id LEFT JOIN user u0_ ON u2_.user_id = u0_.id WHERE u2_.club_id = 1;

SELECT
  count(m0_.id) AS sclr_0
FROM
  club c1_
  LEFT JOIN membership m0_ ON c1_.id = m0_.club_id
WHERE
  m0_.club_id = ?

SELECT count(m0_.id) AS sclr_0 FROM club c1_ LEFT JOIN membership m0_ ON c1_.id = m0_.club_id WHERE m0_.club_id = 1;

SELECT
  count(a0_.id) AS sclr_0
FROM
  club c1_
  LEFT JOIN alert a0_ ON c1_.id = a0_.club_id
WHERE
  a0_.status = 'new'
  AND a0_.club_id = ?

SELECT count(a0_.id) AS sclr_0 FROM club c1_ LEFT JOIN alert a0_ ON c1_.id = a0_.club_id WHERE a0_.status = 'new' AND a0_.club_id = 1;

SELECT
  count(a0_.id) AS sclr_0
FROM
  club c1_
  LEFT JOIN alert a0_ ON c1_.id = a0_.club_id
WHERE
  a0_.status = 'validated'
  AND a0_.club_id = ?

SELECT count(a0_.id) AS sclr_0 FROM club c1_ LEFT JOIN alert a0_ ON c1_.id = a0_.club_id WHERE a0_.status = 'validated' AND a0_.club_id = 1;

SELECT
  count(p0_.id) AS sclr_0
FROM
  club c1_
  LEFT JOIN post p0_ ON c1_.id = p0_.club_id
WHERE
  p0_.status = 'online'
  AND p0_.type = 'article'
  AND p0_.club_id = ?

SELECT count(p0_.id) AS sclr_0 FROM club c1_ LEFT JOIN post p0_ ON c1_.id = p0_.club_id WHERE p0_.status = 'online' AND p0_.type = 'article' AND p0_.club_id = 1;

SELECT
  count(p0_.id) AS sclr_0
FROM
  club c1_
  LEFT JOIN post p0_ ON c1_.id = p0_.club_id
WHERE
  p0_.status = 'online'
  AND p0_.type = 'event'
  AND p0_.club_id = ?

SELECT count(p0_.id) AS sclr_0 FROM club c1_ LEFT JOIN post p0_ ON c1_.id = p0_.club_id WHERE p0_.status = 'online' AND p0_.type = 'event' AND p0_.club_id = 1;

SELECT
  count(c0_.id) AS sclr_0
FROM
  club c1_
  LEFT JOIN membership m2_ ON c1_.id = m2_.club_id
  LEFT JOIN company c0_ ON m2_.company_id = c0_.id
WHERE
  m2_.club_id = ?
  AND c0_.status = 'new'

SELECT count(c0_.id) AS sclr_0 FROM club c1_ LEFT JOIN membership m2_ ON c1_.id = m2_.club_id LEFT JOIN company c0_ ON m2_.company_id = c0_.id WHERE m2_.club_id = 1 AND c0_.status = 'new';

SELECT
  count(c0_.id) AS sclr_0
FROM
  club c1_
  LEFT JOIN membership m2_ ON c1_.id = m2_.club_id
  LEFT JOIN company c0_ ON m2_.company_id = c0_.id
WHERE
  m2_.club_id = ?
  AND c0_.status = 'validated'

SELECT count(c0_.id) AS sclr_0 FROM club c1_ LEFT JOIN membership m2_ ON c1_.id = m2_.club_id LEFT JOIN company c0_ ON m2_.company_id = c0_.id WHERE m2_.club_id = 1 AND c0_.status = 'validated';

SELECT
  count(c0_.id) AS sclr_0
FROM
  club c1_
  LEFT JOIN membership m2_ ON c1_.id = m2_.club_id
  LEFT JOIN company c0_ ON m2_.company_id = c0_.id
WHERE
  m2_.club_id = ?
  AND c0_.status = 'claimed'

SELECT count(c0_.id) AS sclr_0 FROM club c1_ LEFT JOIN membership m2_ ON c1_.id = m2_.club_id LEFT JOIN company c0_ ON m2_.company_id = c0_.id WHERE m2_.club_id = 1 AND c0_.status = 'claimed';

SELECT
  count(c0_.id) AS sclr_0
FROM
  club c1_
  LEFT JOIN membership m2_ ON c1_.id = m2_.club_id
  LEFT JOIN company c3_ ON m2_.company_id = c3_.id
  LEFT JOIN claiming_request c0_ ON c3_.id = c0_.company_id
WHERE
  m2_.club_id = ?
  AND c0_.status = 'new'

SELECT count(c0_.id) AS sclr_0 FROM club c1_ LEFT JOIN membership m2_ ON c1_.id = m2_.club_id LEFT JOIN company c3_ ON m2_.company_id = c3_.id LEFT JOIN claiming_request c0_ ON c3_.id = c0_.company_id WHERE m2_.club_id = 1 AND c0_.status = 'new';

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.theme AS theme_2,
  c0_.home_message AS home_message_3,
  c0_.website AS website_4,
  c0_.phone AS phone_5,
  c0_.email AS email_6,
  c0_.address_id AS address_id_7
FROM
  club c0_
  LEFT JOIN club_manager c1_ ON c0_.id = c1_.club_id
WHERE
  c1_.user_id = ?

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.theme AS theme_2, c0_.home_message AS home_message_3, c0_.website AS website_4, c0_.phone AS phone_5, c0_.email AS email_6, c0_.address_id AS address_id_7 FROM club c0_ LEFT JOIN club_manager c1_ ON c0_.id = c1_.club_id WHERE c1_.user_id = 8;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.main AS main_4,
  t0.visible AS visible_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.image_large_id AS image_large_id_8,
  t0.image_medium_id AS image_medium_id_9,
  t0.image_small_id AS image_small_id_10,
  t0.user_id AS user_id_11,
  t0.company_id AS company_id_12,
  t0.club_id AS club_id_13,
  t0.post_id AS post_id_14,
  t0.ad_id AS ad_id_15,
  t0.deal_id AS deal_id_16,
  t0.widget_id AS widget_id_17,
  t0.alert_id AS alert_id_18,
  t0.club_presentation_id AS club_presentation_id_19
FROM
  photo t0
WHERE
  t0.club_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.main AS main_4, t0.visible AS visible_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.image_large_id AS image_large_id_8, t0.image_medium_id AS image_medium_id_9, t0.image_small_id AS image_small_id_10, t0.user_id AS user_id_11, t0.company_id AS company_id_12, t0.club_id AS club_id_13, t0.post_id AS post_id_14, t0.ad_id AS ad_id_15, t0.deal_id AS deal_id_16, t0.widget_id AS widget_id_17, t0.alert_id AS alert_id_18, t0.club_presentation_id AS club_presentation_id_19 FROM photo t0 WHERE t0.club_id = 1;

SELECT
  t0.id AS id_1,
  t0.filepath AS filepath_2,
  t0.image_type AS image_type_3,
  t0.filename AS filename_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6
FROM
  document t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.filepath AS filepath_2, t0.image_type AS image_type_3, t0.filename AS filename_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM document t0 WHERE t0.id = 272;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.main AS main_4,
  t0.visible AS visible_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.image_large_id AS image_large_id_8,
  t0.image_medium_id AS image_medium_id_9,
  t0.image_small_id AS image_small_id_10,
  t0.user_id AS user_id_11,
  t0.company_id AS company_id_12,
  t0.club_id AS club_id_13,
  t0.post_id AS post_id_14,
  t0.ad_id AS ad_id_15,
  t0.deal_id AS deal_id_16,
  t0.widget_id AS widget_id_17,
  t0.alert_id AS alert_id_18,
  t0.club_presentation_id AS club_presentation_id_19
FROM
  photo t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.main AS main_4, t0.visible AS visible_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.image_large_id AS image_large_id_8, t0.image_medium_id AS image_medium_id_9, t0.image_small_id AS image_small_id_10, t0.user_id AS user_id_11, t0.company_id AS company_id_12, t0.club_id AS club_id_13, t0.post_id AS post_id_14, t0.ad_id AS ad_id_15, t0.deal_id AS deal_id_16, t0.widget_id AS widget_id_17, t0.alert_id AS alert_id_18, t0.club_presentation_id AS club_presentation_id_19 FROM photo t0 WHERE t0.user_id = 8;

SELECT
  t0.id AS id_1,
  t0.filepath AS filepath_2,
  t0.image_type AS image_type_3,
  t0.filename AS filename_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6
FROM
  document t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.filepath AS filepath_2, t0.image_type AS image_type_3, t0.filename AS filename_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM document t0 WHERE t0.id = 277;