Symfony Profiler

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.slug AS slug_2,
  s0_.icon AS icon_3,
  s0_.status AS status_4,
  s0_.appearance AS appearance_5
FROM
  sport s0_
WHERE
  s0_.status = ?
ORDER BY
  s0_.appearance ASC

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.icon AS icon_3, s0_.status AS status_4, s0_.appearance AS appearance_5 FROM sport s0_ WHERE s0_.status = 'visible' ORDER BY s0_.appearance ASC;

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.slug AS slug_2
FROM
  age a0_

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2 FROM age a0_;

SELECT
  l0_.id AS id_0,
  l0_.name AS name_1,
  l0_.slug AS slug_2
FROM
  LEVEL l0_

SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.slug AS slug_2 FROM LEVEL l0_;

SELECT
  l0_.id AS id_0,
  l0_.name AS name_1,
  l0_.slug AS slug_2
FROM
  language l0_

SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.slug AS slug_2 FROM language l0_;

SELECT
  t0.id AS id_1,
  t0.city AS city_2,
  t0.longitude AS longitude_3,
  t0.latitude AS latitude_4,
  t0.country_code AS country_code_5,
  t0.full_address AS full_address_6,
  t0.place_id AS place_id_7,
  t8.id AS id_9,
  t8.logistic AS logistic_10,
  t8.frequency AS frequency_11,
  t8.status AS status_12,
  t8.created_at AS created_at_13,
  t8.token AS token_14,
  t8.country_code AS country_code_15,
  t8.latitude AS latitude_16,
  t8.longitude AS longitude_17,
  t8.hide_club_info AS hide_club_info_18,
  t8.hide_coach_info AS hide_coach_info_19,
  t8.step_saved AS step_saved_20,
  t8.sended_alert AS sended_alert_21,
  t8.cover AS cover_22,
  t8.visible_to_club AS visible_to_club_23,
  t8.visible_to_coach AS visible_to_coach_24,
  t8.visible_to_operator AS visible_to_operator_25,
  t8.published_at AS published_at_26,
  t8.updated_at AS updated_at_27,
  t8.club_id AS club_id_28,
  t8.address_id AS address_id_29,
  t8.owner_id AS owner_id_30,
  t8.operator_id AS operator_id_31,
  t0.pro_id AS pro_id_32
FROM
  address t0
  LEFT JOIN course t8 ON t8.address_id = t0.id
WHERE
  t0.place_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.city AS city_2, t0.longitude AS longitude_3, t0.latitude AS latitude_4, t0.country_code AS country_code_5, t0.full_address AS full_address_6, t0.place_id AS place_id_7, t8.id AS id_9, t8.logistic AS logistic_10, t8.frequency AS frequency_11, t8.status AS status_12, t8.created_at AS created_at_13, t8.token AS token_14, t8.country_code AS country_code_15, t8.latitude AS latitude_16, t8.longitude AS longitude_17, t8.hide_club_info AS hide_club_info_18, t8.hide_coach_info AS hide_coach_info_19, t8.step_saved AS step_saved_20, t8.sended_alert AS sended_alert_21, t8.cover AS cover_22, t8.visible_to_club AS visible_to_club_23, t8.visible_to_coach AS visible_to_coach_24, t8.visible_to_operator AS visible_to_operator_25, t8.published_at AS published_at_26, t8.updated_at AS updated_at_27, t8.club_id AS club_id_28, t8.address_id AS address_id_29, t8.owner_id AS owner_id_30, t8.operator_id AS operator_id_31, t0.pro_id AS pro_id_32 FROM address t0 LEFT JOIN course t8 ON t8.address_id = t0.id WHERE t0.place_id = 'ChIJA9KNRIL-1BIRb15jJFz1LOI' LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.logistic AS logistic_1,
  c0_.frequency AS frequency_2,
  c0_.status AS status_3,
  c0_.created_at AS created_at_4,
  c0_.token AS token_5,
  c0_.country_code AS country_code_6,
  c0_.latitude AS latitude_7,
  c0_.longitude AS longitude_8,
  c0_.hide_club_info AS hide_club_info_9,
  c0_.hide_coach_info AS hide_coach_info_10,
  c0_.step_saved AS step_saved_11,
  c0_.sended_alert AS sended_alert_12,
  c0_.cover AS cover_13,
  c0_.visible_to_club AS visible_to_club_14,
  c0_.visible_to_coach AS visible_to_coach_15,
  c0_.visible_to_operator AS visible_to_operator_16,
  c0_.published_at AS published_at_17,
  c0_.updated_at AS updated_at_18,
  c0_.club_id AS club_id_19,
  c0_.address_id AS address_id_20,
  c0_.owner_id AS owner_id_21,
  c0_.operator_id AS operator_id_22
FROM
  course c0_
  INNER JOIN user u1_ ON c0_.owner_id = u1_.id
  LEFT JOIN coach c2_ ON u1_.id = c2_.id
  LEFT JOIN club c3_ ON u1_.id = c3_.id
  LEFT JOIN operator o4_ ON u1_.id = o4_.id
  LEFT JOIN trainee t5_ ON u1_.id = t5_.id
  LEFT JOIN admin a6_ ON u1_.id = a6_.id
  INNER JOIN pro_info p7_ ON u1_.pro_info_id = p7_.id
WHERE
  c0_.status LIKE 'active'
  AND u1_.status = ?
  AND p7_.have_subscription = ?
  AND p7_.is_hidden = ?
  AND (
    6353 * 2 * ASIN(
      SQRT(
        POWER(
          SIN(
            (c0_.latitude - ?) * PI() / 180 / 2
          ),
          2
        ) + COS(
          c0_.latitude * PI() / 180
        ) * COS(
          ? * PI() / 180
        ) * POWER(
          SIN(
            (c0_.longitude - ?) * PI() / 180 / 2
          ),
          2
        )
      )
    )
  ) <= ?
  AND p7_.is_hidden = ?

SELECT c0_.id AS id_0, c0_.logistic AS logistic_1, c0_.frequency AS frequency_2, c0_.status AS status_3, c0_.created_at AS created_at_4, c0_.token AS token_5, c0_.country_code AS country_code_6, c0_.latitude AS latitude_7, c0_.longitude AS longitude_8, c0_.hide_club_info AS hide_club_info_9, c0_.hide_coach_info AS hide_coach_info_10, c0_.step_saved AS step_saved_11, c0_.sended_alert AS sended_alert_12, c0_.cover AS cover_13, c0_.visible_to_club AS visible_to_club_14, c0_.visible_to_coach AS visible_to_coach_15, c0_.visible_to_operator AS visible_to_operator_16, c0_.published_at AS published_at_17, c0_.updated_at AS updated_at_18, c0_.club_id AS club_id_19, c0_.address_id AS address_id_20, c0_.owner_id AS owner_id_21, c0_.operator_id AS operator_id_22 FROM course c0_ INNER JOIN user u1_ ON c0_.owner_id = u1_.id LEFT JOIN coach c2_ ON u1_.id = c2_.id LEFT JOIN club c3_ ON u1_.id = c3_.id LEFT JOIN operator o4_ ON u1_.id = o4_.id LEFT JOIN trainee t5_ ON u1_.id = t5_.id LEFT JOIN admin a6_ ON u1_.id = a6_.id INNER JOIN pro_info p7_ ON u1_.pro_info_id = p7_.id WHERE c0_.status LIKE 'active' AND u1_.status = 'online' AND p7_.have_subscription = 1 AND p7_.is_hidden = 0 AND (6353 * 2 * ASIN(SQRT(POWER(SIN((c0_.latitude - 41.87194) * PI() / 180 / 2), 2) + COS(c0_.latitude * PI() / 180) * COS(41.87194 * PI() / 180) * POWER(SIN((c0_.longitude - 12.56738) * PI() / 180 / 2), 2)))) <= 80 AND p7_.is_hidden = 0;

SELECT
  t0.id AS id_1,
  t0.city AS city_2,
  t0.longitude AS longitude_3,
  t0.latitude AS latitude_4,
  t0.country_code AS country_code_5,
  t0.full_address AS full_address_6,
  t0.place_id AS place_id_7,
  t8.id AS id_9,
  t8.logistic AS logistic_10,
  t8.frequency AS frequency_11,
  t8.status AS status_12,
  t8.created_at AS created_at_13,
  t8.token AS token_14,
  t8.country_code AS country_code_15,
  t8.latitude AS latitude_16,
  t8.longitude AS longitude_17,
  t8.hide_club_info AS hide_club_info_18,
  t8.hide_coach_info AS hide_coach_info_19,
  t8.step_saved AS step_saved_20,
  t8.sended_alert AS sended_alert_21,
  t8.cover AS cover_22,
  t8.visible_to_club AS visible_to_club_23,
  t8.visible_to_coach AS visible_to_coach_24,
  t8.visible_to_operator AS visible_to_operator_25,
  t8.published_at AS published_at_26,
  t8.updated_at AS updated_at_27,
  t8.club_id AS club_id_28,
  t8.address_id AS address_id_29,
  t8.owner_id AS owner_id_30,
  t8.operator_id AS operator_id_31,
  t0.pro_id AS pro_id_32
FROM
  address t0
  LEFT JOIN course t8 ON t8.address_id = t0.id
WHERE
  t0.place_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.city AS city_2, t0.longitude AS longitude_3, t0.latitude AS latitude_4, t0.country_code AS country_code_5, t0.full_address AS full_address_6, t0.place_id AS place_id_7, t8.id AS id_9, t8.logistic AS logistic_10, t8.frequency AS frequency_11, t8.status AS status_12, t8.created_at AS created_at_13, t8.token AS token_14, t8.country_code AS country_code_15, t8.latitude AS latitude_16, t8.longitude AS longitude_17, t8.hide_club_info AS hide_club_info_18, t8.hide_coach_info AS hide_coach_info_19, t8.step_saved AS step_saved_20, t8.sended_alert AS sended_alert_21, t8.cover AS cover_22, t8.visible_to_club AS visible_to_club_23, t8.visible_to_coach AS visible_to_coach_24, t8.visible_to_operator AS visible_to_operator_25, t8.published_at AS published_at_26, t8.updated_at AS updated_at_27, t8.club_id AS club_id_28, t8.address_id AS address_id_29, t8.owner_id AS owner_id_30, t8.operator_id AS operator_id_31, t0.pro_id AS pro_id_32 FROM address t0 LEFT JOIN course t8 ON t8.address_id = t0.id WHERE t0.place_id = 'ChIJA9KNRIL-1BIRb15jJFz1LOI' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.city AS city_2,
  t0.longitude AS longitude_3,
  t0.latitude AS latitude_4,
  t0.country_code AS country_code_5,
  t0.full_address AS full_address_6,
  t0.place_id AS place_id_7,
  t8.id AS id_9,
  t8.logistic AS logistic_10,
  t8.frequency AS frequency_11,
  t8.status AS status_12,
  t8.created_at AS created_at_13,
  t8.token AS token_14,
  t8.country_code AS country_code_15,
  t8.latitude AS latitude_16,
  t8.longitude AS longitude_17,
  t8.hide_club_info AS hide_club_info_18,
  t8.hide_coach_info AS hide_coach_info_19,
  t8.step_saved AS step_saved_20,
  t8.sended_alert AS sended_alert_21,
  t8.cover AS cover_22,
  t8.visible_to_club AS visible_to_club_23,
  t8.visible_to_coach AS visible_to_coach_24,
  t8.visible_to_operator AS visible_to_operator_25,
  t8.published_at AS published_at_26,
  t8.updated_at AS updated_at_27,
  t8.club_id AS club_id_28,
  t8.address_id AS address_id_29,
  t8.owner_id AS owner_id_30,
  t8.operator_id AS operator_id_31,
  t0.pro_id AS pro_id_32
FROM
  address t0
  LEFT JOIN course t8 ON t8.address_id = t0.id
WHERE
  t0.place_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.city AS city_2, t0.longitude AS longitude_3, t0.latitude AS latitude_4, t0.country_code AS country_code_5, t0.full_address AS full_address_6, t0.place_id AS place_id_7, t8.id AS id_9, t8.logistic AS logistic_10, t8.frequency AS frequency_11, t8.status AS status_12, t8.created_at AS created_at_13, t8.token AS token_14, t8.country_code AS country_code_15, t8.latitude AS latitude_16, t8.longitude AS longitude_17, t8.hide_club_info AS hide_club_info_18, t8.hide_coach_info AS hide_coach_info_19, t8.step_saved AS step_saved_20, t8.sended_alert AS sended_alert_21, t8.cover AS cover_22, t8.visible_to_club AS visible_to_club_23, t8.visible_to_coach AS visible_to_coach_24, t8.visible_to_operator AS visible_to_operator_25, t8.published_at AS published_at_26, t8.updated_at AS updated_at_27, t8.club_id AS club_id_28, t8.address_id AS address_id_29, t8.owner_id AS owner_id_30, t8.operator_id AS operator_id_31, t0.pro_id AS pro_id_32 FROM address t0 LEFT JOIN course t8 ON t8.address_id = t0.id WHERE t0.place_id = 'ChIJA9KNRIL-1BIRb15jJFz1LOI' LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.logistic AS logistic_1,
  c0_.frequency AS frequency_2,
  c0_.status AS status_3,
  c0_.created_at AS created_at_4,
  c0_.token AS token_5,
  c0_.country_code AS country_code_6,
  c0_.latitude AS latitude_7,
  c0_.longitude AS longitude_8,
  c0_.hide_club_info AS hide_club_info_9,
  c0_.hide_coach_info AS hide_coach_info_10,
  c0_.step_saved AS step_saved_11,
  c0_.sended_alert AS sended_alert_12,
  c0_.cover AS cover_13,
  c0_.visible_to_club AS visible_to_club_14,
  c0_.visible_to_coach AS visible_to_coach_15,
  c0_.visible_to_operator AS visible_to_operator_16,
  c0_.published_at AS published_at_17,
  c0_.updated_at AS updated_at_18,
  c0_.club_id AS club_id_19,
  c0_.address_id AS address_id_20,
  c0_.owner_id AS owner_id_21,
  c0_.operator_id AS operator_id_22
FROM
  course c0_
  INNER JOIN user u1_ ON c0_.owner_id = u1_.id
  LEFT JOIN coach c2_ ON u1_.id = c2_.id
  LEFT JOIN club c3_ ON u1_.id = c3_.id
  LEFT JOIN operator o4_ ON u1_.id = o4_.id
  LEFT JOIN trainee t5_ ON u1_.id = t5_.id
  LEFT JOIN admin a6_ ON u1_.id = a6_.id
  INNER JOIN pro_info p7_ ON u1_.pro_info_id = p7_.id
WHERE
  c0_.status LIKE 'active'
  AND u1_.status = ?
  AND p7_.have_subscription = ?
  AND p7_.is_hidden = ?
  AND c0_.country_code = ?
  AND p7_.is_hidden = ?

SELECT c0_.id AS id_0, c0_.logistic AS logistic_1, c0_.frequency AS frequency_2, c0_.status AS status_3, c0_.created_at AS created_at_4, c0_.token AS token_5, c0_.country_code AS country_code_6, c0_.latitude AS latitude_7, c0_.longitude AS longitude_8, c0_.hide_club_info AS hide_club_info_9, c0_.hide_coach_info AS hide_coach_info_10, c0_.step_saved AS step_saved_11, c0_.sended_alert AS sended_alert_12, c0_.cover AS cover_13, c0_.visible_to_club AS visible_to_club_14, c0_.visible_to_coach AS visible_to_coach_15, c0_.visible_to_operator AS visible_to_operator_16, c0_.published_at AS published_at_17, c0_.updated_at AS updated_at_18, c0_.club_id AS club_id_19, c0_.address_id AS address_id_20, c0_.owner_id AS owner_id_21, c0_.operator_id AS operator_id_22 FROM course c0_ INNER JOIN user u1_ ON c0_.owner_id = u1_.id LEFT JOIN coach c2_ ON u1_.id = c2_.id LEFT JOIN club c3_ ON u1_.id = c3_.id LEFT JOIN operator o4_ ON u1_.id = o4_.id LEFT JOIN trainee t5_ ON u1_.id = t5_.id LEFT JOIN admin a6_ ON u1_.id = a6_.id INNER JOIN pro_info p7_ ON u1_.pro_info_id = p7_.id WHERE c0_.status LIKE 'active' AND u1_.status = 'online' AND p7_.have_subscription = 1 AND p7_.is_hidden = 0 AND c0_.country_code = 'IT' AND p7_.is_hidden = 0;

SELECT
  c0_.id AS id_0,
  c0_.logistic AS logistic_1,
  c0_.frequency AS frequency_2,
  c0_.status AS status_3,
  c0_.created_at AS created_at_4,
  c0_.token AS token_5,
  c0_.country_code AS country_code_6,
  c0_.latitude AS latitude_7,
  c0_.longitude AS longitude_8,
  c0_.hide_club_info AS hide_club_info_9,
  c0_.hide_coach_info AS hide_coach_info_10,
  c0_.step_saved AS step_saved_11,
  c0_.sended_alert AS sended_alert_12,
  c0_.cover AS cover_13,
  c0_.visible_to_club AS visible_to_club_14,
  c0_.visible_to_coach AS visible_to_coach_15,
  c0_.visible_to_operator AS visible_to_operator_16,
  c0_.published_at AS published_at_17,
  c0_.updated_at AS updated_at_18,
  c0_.club_id AS club_id_19,
  c0_.address_id AS address_id_20,
  c0_.owner_id AS owner_id_21,
  c0_.operator_id AS operator_id_22
FROM
  course c0_
  INNER JOIN user u1_ ON c0_.owner_id = u1_.id
  LEFT JOIN coach c2_ ON u1_.id = c2_.id
  LEFT JOIN club c3_ ON u1_.id = c3_.id
  LEFT JOIN operator o4_ ON u1_.id = o4_.id
  LEFT JOIN trainee t5_ ON u1_.id = t5_.id
  LEFT JOIN admin a6_ ON u1_.id = a6_.id
  INNER JOIN pro_info p7_ ON u1_.pro_info_id = p7_.id
  INNER JOIN featured_course f8_ ON c0_.id = f8_.course_id
  INNER JOIN featured_offer f9_ ON f8_.featured_offer_id = f9_.id
WHERE
  c0_.status LIKE 'active'
  AND u1_.status = ?
  AND p7_.have_subscription = ?
  AND p7_.is_hidden = ?
  AND f9_.type = ?
  AND f8_.status = ?
  AND c0_.country_code = ?
ORDER BY
  c0_.created_at DESC

SELECT c0_.id AS id_0, c0_.logistic AS logistic_1, c0_.frequency AS frequency_2, c0_.status AS status_3, c0_.created_at AS created_at_4, c0_.token AS token_5, c0_.country_code AS country_code_6, c0_.latitude AS latitude_7, c0_.longitude AS longitude_8, c0_.hide_club_info AS hide_club_info_9, c0_.hide_coach_info AS hide_coach_info_10, c0_.step_saved AS step_saved_11, c0_.sended_alert AS sended_alert_12, c0_.cover AS cover_13, c0_.visible_to_club AS visible_to_club_14, c0_.visible_to_coach AS visible_to_coach_15, c0_.visible_to_operator AS visible_to_operator_16, c0_.published_at AS published_at_17, c0_.updated_at AS updated_at_18, c0_.club_id AS club_id_19, c0_.address_id AS address_id_20, c0_.owner_id AS owner_id_21, c0_.operator_id AS operator_id_22 FROM course c0_ INNER JOIN user u1_ ON c0_.owner_id = u1_.id LEFT JOIN coach c2_ ON u1_.id = c2_.id LEFT JOIN club c3_ ON u1_.id = c3_.id LEFT JOIN operator o4_ ON u1_.id = o4_.id LEFT JOIN trainee t5_ ON u1_.id = t5_.id LEFT JOIN admin a6_ ON u1_.id = a6_.id INNER JOIN pro_info p7_ ON u1_.pro_info_id = p7_.id INNER JOIN featured_course f8_ ON c0_.id = f8_.course_id INNER JOIN featured_offer f9_ ON f8_.featured_offer_id = f9_.id WHERE c0_.status LIKE 'active' AND u1_.status = 'online' AND p7_.have_subscription = 1 AND p7_.is_hidden = 0 AND f9_.type = 'research' AND f8_.status = 'active' AND c0_.country_code = 'IT' ORDER BY c0_.created_at DESC;