Symfony Profiler

SELECT
  m0_.id AS id_0,
  m0_.title AS title_1,
  m0_.places AS places_2,
  m0_.description AS description_3,
  m0_.fees AS fees_4,
  m0_.started AS started_5,
  m0_.latitude AS latitude_6,
  m0_.longitude AS longitude_7,
  m0_.duration AS duration_8,
  m0_.terrain_type AS terrain_type_9,
  m0_.type AS type_10,
  m0_.amount AS amount_11,
  m0_.playersnumber AS playersnumber_12,
  m0_.min_age AS min_age_13,
  m0_.max_age AS max_age_14,
  m0_.result_home AS result_home_15,
  m0_.result_away AS result_away_16,
  m0_.created AS created_17,
  -(
    (
      ACOS(
        SIN(
          ? * PI() / 180
        ) * SIN(
          m0_.latitude * PI() / 180
        ) + COS(
          ? * PI() / 180
        ) * COS(
          m0_.latitude * PI() / 180
        ) * COS(
          (? - m0_.longitude) * PI() / 180
        )
      ) * 180 / PI()
    ) * 60 * 1.1515 * 1.609344
  ) AS sclr_18,
  m0_.id AS id_19,
  m0_.title AS title_20,
  m0_.progress AS progress_21,
  m0_.description AS description_22,
  m0_.fees AS fees_23,
  m0_.started AS started_24,
  m0_.latitude AS latitude_25,
  m0_.longitude AS longitude_26,
  m0_.duration AS duration_27,
  m0_.terrain_type AS terrain_type_28,
  m0_.type AS type_29,
  m0_.amount AS amount_30,
  m0_.playersnumber AS playersnumber_31,
  m0_.min_age AS min_age_32,
  m0_.max_age AS max_age_33,
  m0_.places AS places_34,
  m0_.result_home AS result_home_35,
  m0_.result_away AS result_away_36,
  m0_.created AS created_37,
  m0_.enabled AS enabled_38,
  m0_.hasPaid AS hasPaid_39,
  u1_.id AS id_40,
  u1_.email AS email_41,
  u1_.fname AS fname_42,
  u1_.lname AS lname_43,
  u1_.phone AS phone_44,
  u1_.birthday AS birthday_45,
  u1_.weight AS weight_46,
  u1_.height AS height_47,
  u1_.latitude AS latitude_48,
  u1_.longitude AS longitude_49,
  u1_.position AS position_50,
  u1_.positionalt AS positionalt_51,
  u1_.foot AS foot_52,
  u1_.speed AS speed_53,
  u1_.shooting AS shooting_54,
  u1_.physicality AS physicality_55,
  u1_.defending AS defending_56,
  u1_.dribbling AS dribbling_57,
  u1_.passing AS passing_58,
  u1_.note AS note_59,
  u1_.enabled AS enabled_60,
  u1_.notification_messages AS notification_messages_61,
  u1_.notification_invitations AS notification_invitations_62,
  u1_.notification_general AS notification_general_63,
  u1_.roles AS roles_64,
  u1_.password AS password_65,
  u1_.created AS created_66,
  u1_.notified AS notified_67,
  u1_.type AS type_68,
  u1_.local AS local_69,
  u1_.status AS status_70,
  u1_.token AS token_71,
  u1_.is_verified AS is_verified_72,
  u1_.is_trusted AS is_trusted_73,
  m0_.motm_id AS motm_id_74,
  m0_.organizer_id AS organizer_id_75,
  u1_.media_id AS media_id_76
FROM
  matche_table m0_
  LEFT JOIN user_table u1_ ON m0_.organizer_id = u1_.id
  LEFT JOIN media_table m2_ ON u1_.media_id = m2_.id
WHERE
  m0_.enabled = 1
  AND m0_.started > ?
ORDER BY
  sclr_18 DESC,
  m0_.started ASC,
  m0_.id ASC
LIMIT
  10

SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.places AS places_2, m0_.description AS description_3, m0_.fees AS fees_4, m0_.started AS started_5, m0_.latitude AS latitude_6, m0_.longitude AS longitude_7, m0_.duration AS duration_8, m0_.terrain_type AS terrain_type_9, m0_.type AS type_10, m0_.amount AS amount_11, m0_.playersnumber AS playersnumber_12, m0_.min_age AS min_age_13, m0_.max_age AS max_age_14, m0_.result_home AS result_home_15, m0_.result_away AS result_away_16, m0_.created AS created_17, -((ACOS(SIN('37.4219983' * PI() / 180) * SIN(m0_.latitude * PI() / 180) + COS('37.4219983' * PI() / 180) * COS(m0_.latitude * PI() / 180) * COS(('-122.084' - m0_.longitude) * PI() / 180)) * 180 / PI()) * 60 * 1.1515 * 1.609344) AS sclr_18, m0_.id AS id_19, m0_.title AS title_20, m0_.progress AS progress_21, m0_.description AS description_22, m0_.fees AS fees_23, m0_.started AS started_24, m0_.latitude AS latitude_25, m0_.longitude AS longitude_26, m0_.duration AS duration_27, m0_.terrain_type AS terrain_type_28, m0_.type AS type_29, m0_.amount AS amount_30, m0_.playersnumber AS playersnumber_31, m0_.min_age AS min_age_32, m0_.max_age AS max_age_33, m0_.places AS places_34, m0_.result_home AS result_home_35, m0_.result_away AS result_away_36, m0_.created AS created_37, m0_.enabled AS enabled_38, m0_.hasPaid AS hasPaid_39, u1_.id AS id_40, u1_.email AS email_41, u1_.fname AS fname_42, u1_.lname AS lname_43, u1_.phone AS phone_44, u1_.birthday AS birthday_45, u1_.weight AS weight_46, u1_.height AS height_47, u1_.latitude AS latitude_48, u1_.longitude AS longitude_49, u1_.position AS position_50, u1_.positionalt AS positionalt_51, u1_.foot AS foot_52, u1_.speed AS speed_53, u1_.shooting AS shooting_54, u1_.physicality AS physicality_55, u1_.defending AS defending_56, u1_.dribbling AS dribbling_57, u1_.passing AS passing_58, u1_.note AS note_59, u1_.enabled AS enabled_60, u1_.notification_messages AS notification_messages_61, u1_.notification_invitations AS notification_invitations_62, u1_.notification_general AS notification_general_63, u1_.roles AS roles_64, u1_.password AS password_65, u1_.created AS created_66, u1_.notified AS notified_67, u1_.type AS type_68, u1_.local AS local_69, u1_.status AS status_70, u1_.token AS token_71, u1_.is_verified AS is_verified_72, u1_.is_trusted AS is_trusted_73, m0_.motm_id AS motm_id_74, m0_.organizer_id AS organizer_id_75, u1_.media_id AS media_id_76 FROM matche_table m0_ LEFT JOIN user_table u1_ ON m0_.organizer_id = u1_.id LEFT JOIN media_table m2_ ON u1_.media_id = m2_.id WHERE m0_.enabled = 1 AND m0_.started > '2026-01-12 17:25:32' ORDER BY sclr_18 DESC, m0_.started ASC, m0_.id ASC LIMIT 10;

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.url AS url_3,
  t0.type AS type_4,
  t0.extension AS extension_5,
  t0.date AS date_6,
  t0.enabled AS enabled_7
FROM
  media_table t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.url AS url_3, t0.type AS type_4, t0.extension AS extension_5, t0.date AS date_6, t0.enabled AS enabled_7 FROM media_table t0 WHERE t0.id = 14;

SELECT
  v0_.id AS id_0,
  v0_.created AS created_1,
  v0_.enabled AS enabled_2,
  v0_.duration AS duration_3,
  v0_.views AS views_4,
  v0_.likes AS likes_5,
  RAND() AS sclr_6,
  v0_.media_id AS media_id_7,
  v0_.video_id AS video_id_8,
  v0_.user_id AS user_id_9
FROM
  video_table v0_
WHERE
  v0_.enabled = 1
ORDER BY
  sclr_6 ASC
LIMIT
  15

SELECT v0_.id AS id_0, v0_.created AS created_1, v0_.enabled AS enabled_2, v0_.duration AS duration_3, v0_.views AS views_4, v0_.likes AS likes_5, RAND() AS sclr_6, v0_.media_id AS media_id_7, v0_.video_id AS video_id_8, v0_.user_id AS user_id_9 FROM video_table v0_ WHERE v0_.enabled = 1 ORDER BY sclr_6 ASC LIMIT 15;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.fname AS fname_3,
  t0.lname AS lname_4,
  t0.phone AS phone_5,
  t0.birthday AS birthday_6,
  t0.weight AS weight_7,
  t0.height AS height_8,
  t0.latitude AS latitude_9,
  t0.longitude AS longitude_10,
  t0.position AS position_11,
  t0.positionalt AS positionalt_12,
  t0.foot AS foot_13,
  t0.speed AS speed_14,
  t0.shooting AS shooting_15,
  t0.physicality AS physicality_16,
  t0.defending AS defending_17,
  t0.dribbling AS dribbling_18,
  t0.passing AS passing_19,
  t0.note AS note_20,
  t0.enabled AS enabled_21,
  t0.notification_messages AS notification_messages_22,
  t0.notification_invitations AS notification_invitations_23,
  t0.notification_general AS notification_general_24,
  t0.roles AS roles_25,
  t0.password AS password_26,
  t0.created AS created_27,
  t0.notified AS notified_28,
  t0.type AS type_29,
  t0.local AS local_30,
  t0.status AS status_31,
  t0.token AS token_32,
  t0.is_verified AS is_verified_33,
  t0.is_trusted AS is_trusted_34,
  t0.media_id AS media_id_35,
  t36.id AS id_37,
  t36.created AS created_38,
  t36.send AS send_39,
  t36.amount AS amount_40,
  t36.user_id AS user_id_41
FROM
  user_table t0
  LEFT JOIN wallet_table t36 ON t36.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.fname AS fname_3, t0.lname AS lname_4, t0.phone AS phone_5, t0.birthday AS birthday_6, t0.weight AS weight_7, t0.height AS height_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.position AS position_11, t0.positionalt AS positionalt_12, t0.foot AS foot_13, t0.speed AS speed_14, t0.shooting AS shooting_15, t0.physicality AS physicality_16, t0.defending AS defending_17, t0.dribbling AS dribbling_18, t0.passing AS passing_19, t0.note AS note_20, t0.enabled AS enabled_21, t0.notification_messages AS notification_messages_22, t0.notification_invitations AS notification_invitations_23, t0.notification_general AS notification_general_24, t0.roles AS roles_25, t0.password AS password_26, t0.created AS created_27, t0.notified AS notified_28, t0.type AS type_29, t0.local AS local_30, t0.status AS status_31, t0.token AS token_32, t0.is_verified AS is_verified_33, t0.is_trusted AS is_trusted_34, t0.media_id AS media_id_35, t36.id AS id_37, t36.created AS created_38, t36.send AS send_39, t36.amount AS amount_40, t36.user_id AS user_id_41 FROM user_table t0 LEFT JOIN wallet_table t36 ON t36.user_id = t0.id WHERE t0.id = 22;

SELECT
  t0.id AS id_1,
  t0.content AS content_2,
  t0.created AS created_3,
  t0.enabled AS enabled_4,
  t0.video_id AS video_id_5,
  t0.user_id AS user_id_6
FROM
  comment_table t0
WHERE
  t0.video_id = ?

SELECT t0.id AS id_1, t0.content AS content_2, t0.created AS created_3, t0.enabled AS enabled_4, t0.video_id AS video_id_5, t0.user_id AS user_id_6 FROM comment_table t0 WHERE t0.video_id = 1;

SELECT
  t0.id AS id_1,
  t0.banknumber AS banknumber_2,
  t0.bankaccount AS bankaccount_3,
  t0.bankname AS bankname_4,
  t0.appname AS appname_5,
  t0.login AS login_6,
  t0.maxsession AS maxsession_7,
  t0.currency AS currency_8,
  t0.cashaccount AS cashaccount_9,
  t0.paypalclientid AS paypalclientid_10,
  t0.paypalclientsecret AS paypalclientsecret_11,
  t0.paypalaccount AS paypalaccount_12,
  t0.stripeapikey AS stripeapikey_13,
  t0.manual AS manual_14,
  t0.stripe AS stripe_15,
  t0.paypal AS paypal_16,
  t0.gpay AS gpay_17,
  t0.stripepublickey AS stripepublickey_18,
  t0.paypalsandbox AS paypalsandbox_19,
  t0.appdescription AS appdescription_20,
  t0.googleplay AS googleplay_21,
  t0.privacypolicy AS privacypolicy_22,
  t0.refundpolicy AS refundpolicy_23,
  t0.conditions AS conditions_24,
  t0.faq AS faq_25,
  t0.firebasekey AS firebasekey_26,
  t0.rewardedid AS rewardedid_27,
  t0.rewardedtype AS rewardedtype_28,
  t0.bannerid AS bannerid_29,
  t0.bannertype AS bannertype_30,
  t0.nativeid AS nativeid_31,
  t0.nativeitem AS nativeitem_32,
  t0.nativetype AS nativetype_33,
  t0.interstitialid AS interstitialid_34,
  t0.interstitialtype AS interstitialtype_35,
  t0.interstitialclick AS interstitialclick_36,
  t0.themoviedbkey AS themoviedbkey_37,
  t0.themoviedblang AS themoviedblang_38,
  t0.header AS header_39,
  t0.media_id AS media_id_40,
  t0.logo_id AS logo_id_41
FROM
  settings_table t0
LIMIT
  1

SELECT t0.id AS id_1, t0.banknumber AS banknumber_2, t0.bankaccount AS bankaccount_3, t0.bankname AS bankname_4, t0.appname AS appname_5, t0.login AS login_6, t0.maxsession AS maxsession_7, t0.currency AS currency_8, t0.cashaccount AS cashaccount_9, t0.paypalclientid AS paypalclientid_10, t0.paypalclientsecret AS paypalclientsecret_11, t0.paypalaccount AS paypalaccount_12, t0.stripeapikey AS stripeapikey_13, t0.manual AS manual_14, t0.stripe AS stripe_15, t0.paypal AS paypal_16, t0.gpay AS gpay_17, t0.stripepublickey AS stripepublickey_18, t0.paypalsandbox AS paypalsandbox_19, t0.appdescription AS appdescription_20, t0.googleplay AS googleplay_21, t0.privacypolicy AS privacypolicy_22, t0.refundpolicy AS refundpolicy_23, t0.conditions AS conditions_24, t0.faq AS faq_25, t0.firebasekey AS firebasekey_26, t0.rewardedid AS rewardedid_27, t0.rewardedtype AS rewardedtype_28, t0.bannerid AS bannerid_29, t0.bannertype AS bannertype_30, t0.nativeid AS nativeid_31, t0.nativeitem AS nativeitem_32, t0.nativetype AS nativetype_33, t0.interstitialid AS interstitialid_34, t0.interstitialtype AS interstitialtype_35, t0.interstitialclick AS interstitialclick_36, t0.themoviedbkey AS themoviedbkey_37, t0.themoviedblang AS themoviedblang_38, t0.header AS header_39, t0.media_id AS media_id_40, t0.logo_id AS logo_id_41 FROM settings_table t0 LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.date AS date_1,
  p0_.user_id AS user_id_2
FROM
  potm_table p0_
WHERE
  p0_.date > ?
  AND p0_.date < ?
LIMIT
  1

SELECT p0_.id AS id_0, p0_.date AS date_1, p0_.user_id AS user_id_2 FROM potm_table p0_ WHERE p0_.date > '2025-12-01 17:25:32' AND p0_.date < '2025-12-31 17:25:32' LIMIT 1;