Symfony Profiler

[
  "route" => "directory"
  "route_parameters" => [
    "_route" => "directory"
    "_controller" => "App\Controller\Front\ProController::directory"
    "_locale" => "fr"
  ]
  "request_uri" => "https://racket-trip.eu/fr/directory?page=2"
  "method" => "GET"
]

[
  "firewall_name" => "main"
  "authenticators" => 2
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\FormLoginAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\FormLoginAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\RememberMeAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\RememberMeAuthenticator"
]

[
  "params" => [
    "charset" => "utf8mb4"
    "driver" => "pdo_mysql"
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "rackettrip"
    "password" => "<redacted>"
    "driverOptions" => []
    "serverVersion" => "5.7"
    "defaultTableOptions" => [
      "charset" => "utf8mb4"
      "collate" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "rackettrip"
  ]
]

[
  "sql" => "SELECT a0_.country_code AS country_code_0 FROM address a0_ INNER JOIN user u1_ ON a0_.id = u1_.address_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 WHERE u1_.is_pro = 1 OR a0_.pro_id IS NOT NULL GROUP BY a0_.country_code ORDER BY count(a0_.country_code) DESC"
]

[
  "sql" => "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"
  "params" => [
    1 => "visible"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.slug AS slug_2 FROM language l0_"
]

[
  "sql" => "SELECT u0_.id AS id_0, u0_.firstname AS firstname_1, u0_.lastname AS lastname_2, u0_.telephone AS telephone_3, u0_.email AS email_4, u0_.password AS password_5, u0_.activated AS activated_6, u0_.notification AS notification_7, u0_.registered_at AS registered_at_8, u0_.token AS token_9, u0_.photo AS photo_10, u0_.slug AS slug_11, u0_.is_pro AS is_pro_12, u0_.has_access AS has_access_13, u0_.status AS status_14, u0_.has_accepted_terms AS has_accepted_terms_15, u0_.is_ambassador AS is_ambassador_16, u0_.language AS language_17, u0_.timezone AS timezone_18, u0_.phone_code AS phone_code_19, u0_.newsletter AS newsletter_20, c1_.is_mobile AS is_mobile_21, o3_.is_mobile AS is_mobile_22, t4_.birth_date AS birth_date_23, t4_.country AS country_24, t4_.show_phone AS show_phone_25, t4_.show_email AS show_email_26, a5_.has_already_logged_in AS has_already_logged_in_27, a5_.need_review AS need_review_28, a5_.is_editor AS is_editor_29, count(c6_.id) AS sclr_30, u0_.type AS type_31, u0_.address_id AS address_id_32, u0_.pro_info_id AS pro_info_id_33, u0_.stripe_info_id AS stripe_info_id_34 FROM user u0_ LEFT JOIN coach c1_ ON u0_.id = c1_.id LEFT JOIN club c2_ ON u0_.id = c2_.id LEFT JOIN operator o3_ ON u0_.id = o3_.id LEFT JOIN trainee t4_ ON u0_.id = t4_.id LEFT JOIN admin a5_ ON u0_.id = a5_.id INNER JOIN pro_info p7_ ON u0_.pro_info_id = p7_.id LEFT JOIN course c6_ ON u0_.id = c6_.owner_id AND (c6_.status = ?) WHERE u0_.activated = ? AND u0_.is_pro = ? AND u0_.status = ? AND p7_.have_subscription = ? AND p7_.is_hidden = ? AND p7_.page_visible = ? GROUP BY u0_.id, u0_.firstname, u0_.lastname, u0_.telephone, u0_.email, u0_.password, u0_.activated, u0_.notification, u0_.registered_at, u0_.token, u0_.photo, u0_.slug, u0_.is_pro, u0_.has_access, u0_.status, u0_.has_accepted_terms, u0_.is_ambassador, u0_.language, u0_.timezone, u0_.phone_code, u0_.newsletter, u0_.address_id, u0_.pro_info_id, u0_.stripe_info_id ORDER BY sclr_30 DESC"
  "params" => [
    1 => "active"
    2 => 1
    3 => 1
    4 => "online"
    5 => 1
    6 => 0
    7 => 1
  ]
  "types" => [
    1 => 2
    2 => 5
    3 => 5
    4 => 2
    5 => 5
    6 => 5
    7 => 5
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.image AS image_5, t0.owner_id AS owner_id_6, t0.address_id AS address_id_7, t0.created_by_club_id AS created_by_club_id_8, t0.created_by_operator_id AS created_by_operator_id_9 FROM coach_info t0 WHERE t0.owner_id = ?"
  "params" => [
    1 => 207
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.swimmingpool AS swimmingpool_3, t0.gym AS gym_4, t0.restaurant AS restaurant_5, t0.bar AS bar_6, t0.seminar_room AS seminar_room_7, t0.insurance AS insurance_8, t0.description AS description_9, t0.created_at AS created_at_10, t0.image AS image_11, t0.owner_id AS owner_id_12, t0.address_id AS address_id_13, t0.created_by_coach_id AS created_by_coach_id_14, t0.created_by_operator_id AS created_by_operator_id_15 FROM club_info t0 WHERE t0.owner_id = ?"
  "params" => [
    1 => 209
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.owner_id AS owner_id_4 FROM operator_info t0 WHERE t0.owner_id = ?"
  "params" => [
    1 => 211
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.swimmingpool AS swimmingpool_3, t0.gym AS gym_4, t0.restaurant AS restaurant_5, t0.bar AS bar_6, t0.seminar_room AS seminar_room_7, t0.insurance AS insurance_8, t0.description AS description_9, t0.created_at AS created_at_10, t0.image AS image_11, t0.owner_id AS owner_id_12, t0.address_id AS address_id_13, t0.created_by_coach_id AS created_by_coach_id_14, t0.created_by_operator_id AS created_by_operator_id_15 FROM club_info t0 WHERE t0.owner_id = ?"
  "params" => [
    1 => 213
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.image AS image_5, t0.owner_id AS owner_id_6, t0.address_id AS address_id_7, t0.created_by_club_id AS created_by_club_id_8, t0.created_by_operator_id AS created_by_operator_id_9 FROM coach_info t0 WHERE t0.owner_id = ?"
  "params" => [
    1 => 214
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.swimmingpool AS swimmingpool_3, t0.gym AS gym_4, t0.restaurant AS restaurant_5, t0.bar AS bar_6, t0.seminar_room AS seminar_room_7, t0.insurance AS insurance_8, t0.description AS description_9, t0.created_at AS created_at_10, t0.image AS image_11, t0.owner_id AS owner_id_12, t0.address_id AS address_id_13, t0.created_by_coach_id AS created_by_coach_id_14, t0.created_by_operator_id AS created_by_operator_id_15 FROM club_info t0 WHERE t0.owner_id = ?"
  "params" => [
    1 => 215
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.image AS image_5, t0.owner_id AS owner_id_6, t0.address_id AS address_id_7, t0.created_by_club_id AS created_by_club_id_8, t0.created_by_operator_id AS created_by_operator_id_9 FROM coach_info t0 WHERE t0.owner_id = ?"
  "params" => [
    1 => 216
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.owner_id AS owner_id_4 FROM operator_info t0 WHERE t0.owner_id = ?"
  "params" => [
    1 => 219
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.swimmingpool AS swimmingpool_3, t0.gym AS gym_4, t0.restaurant AS restaurant_5, t0.bar AS bar_6, t0.seminar_room AS seminar_room_7, t0.insurance AS insurance_8, t0.description AS description_9, t0.created_at AS created_at_10, t0.image AS image_11, t0.owner_id AS owner_id_12, t0.address_id AS address_id_13, t0.created_by_coach_id AS created_by_coach_id_14, t0.created_by_operator_id AS created_by_operator_id_15 FROM club_info t0 WHERE t0.owner_id = ?"
  "params" => [
    1 => 225
  ]
  "types" => [
    1 => 1
  ]
]