Symfony Profiler

[
  "route" => "app_home"
  "route_parameters" => [
    "_route" => "app_home"
    "_controller" => "App\Controller\HomeController::index"
  ]
  "request_uri" => "https://www.lcdtracking.fr/"
  "method" => "GET"
]

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

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

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

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

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

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "fredy34560"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "prodTest_lcdplatform"
    "serverVersion" => "mariadb-11.8.6"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.domain_name AS domain_name_2, t0.mode AS mode_3, t0.registrar AS registrar_4, t0.status AS status_5, t0.registrar_domain_id AS registrar_domain_id_6, t0.dns_configured AS dns_configured_7, t0.ssl_enabled AS ssl_enabled_8, t0.auto_renew AS auto_renew_9, t0.transfer_auth_code AS transfer_auth_code_10, t0.last_error AS last_error_11, t0.registered_at AS registered_at_12, t0.expires_at AS expires_at_13, t0.activated_at AS activated_at_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.website_id AS website_id_17 FROM domain t0 WHERE t0.domain_name = ? LIMIT 1"
  "params" => [
    1 => "lcdtracking.fr"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#769
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.slug AS slug_3, t0.hero_eyebrow AS hero_eyebrow_4, t0.headline AS headline_5, t0.property_eyebrow AS property_eyebrow_6, t0.property_title AS property_title_7, t0.property_introduction AS property_introduction_8, t0.description AS description_9, t0.gallery_eyebrow AS gallery_eyebrow_10, t0.gallery_title AS gallery_title_11, t0.gallery_introduction AS gallery_introduction_12, t0.location_eyebrow AS location_eyebrow_13, t0.location_title AS location_title_14, t0.location_description AS location_description_15, t0.contact_email AS contact_email_16, t0.contact_phone AS contact_phone_17, t0.contact_address AS contact_address_18, t0.primary_color AS primary_color_19, t0.secondary_color AS secondary_color_20, t0.seo_title AS seo_title_21, t0.seo_description AS seo_description_22, t0.direct_booking_enabled AS direct_booking_enabled_23, t0.published AS published_24, t0.published_at AS published_at_25, t0.preview_image AS preview_image_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.property_id AS property_id_29, t0.theme_id AS theme_id_30, t31.id AS id_32, t31.domain_name AS domain_name_33, t31.mode AS mode_34, t31.registrar AS registrar_35, t31.status AS status_36, t31.registrar_domain_id AS registrar_domain_id_37, t31.dns_configured AS dns_configured_38, t31.ssl_enabled AS ssl_enabled_39, t31.auto_renew AS auto_renew_40, t31.transfer_auth_code AS transfer_auth_code_41, t31.last_error AS last_error_42, t31.registered_at AS registered_at_43, t31.expires_at AS expires_at_44, t31.activated_at AS activated_at_45, t31.created_at AS created_at_46, t31.updated_at AS updated_at_47, t31.website_id AS website_id_48 FROM property_website t0 LEFT JOIN domain t31 ON t31.website_id = t0.id WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#771
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.preview_image AS preview_image_5, t0.template_name AS template_name_6, t0.primary_color AS primary_color_7, t0.secondary_color AS secondary_color_8, t0.active AS active_9, t0.position AS position_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM website_theme t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#771
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.address AS address_4, t0.zip_code AS zip_code_5, t0.city AS city_6, t0.country AS country_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.capacity AS capacity_10, t0.bedrooms AS bedrooms_11, t0.bathrooms AS bathrooms_12, t0.surface AS surface_13, t0.nightly_rate AS nightly_rate_14, t0.included_guests AS included_guests_15, t0.extra_guest_fee AS extra_guest_fee_16, t0.cleaning_fee AS cleaning_fee_17, t0.nearby_place1 AS nearby_place1_18, t0.nearby_place1_time AS nearby_place1_time_19, t0.nearby_place2 AS nearby_place2_20, t0.nearby_place2_time AS nearby_place2_time_21, t0.nearby_place3 AS nearby_place3_22, t0.nearby_place3_time AS nearby_place3_time_23, t0.nearby_place4 AS nearby_place4_24, t0.nearby_place4_time AS nearby_place4_time_25, t0.arrival_time AS arrival_time_26, t0.departure_time AS departure_time_27, t0.minimum_nights AS minimum_nights_28, t0.maximum_nights AS maximum_nights_29, t0.minimum_booking_notice_days AS minimum_booking_notice_days_30, t0.maximum_booking_advance_days AS maximum_booking_advance_days_31, t0.cancellation_policy AS cancellation_policy_32, t0.custom_cancellation_policy AS custom_cancellation_policy_33, t0.ical_export_token AS ical_export_token_34, t0.ical_export_enabled AS ical_export_enabled_35, t0.active AS active_36, t0.created_at AS created_at_37, t0.updated_at AS updated_at_38, t0.owner_id AS owner_id_39, t40.id AS id_41, t40.site_name AS site_name_42, t40.slug AS slug_43, t40.hero_eyebrow AS hero_eyebrow_44, t40.headline AS headline_45, t40.property_eyebrow AS property_eyebrow_46, t40.property_title AS property_title_47, t40.property_introduction AS property_introduction_48, t40.description AS description_49, t40.gallery_eyebrow AS gallery_eyebrow_50, t40.gallery_title AS gallery_title_51, t40.gallery_introduction AS gallery_introduction_52, t40.location_eyebrow AS location_eyebrow_53, t40.location_title AS location_title_54, t40.location_description AS location_description_55, t40.contact_email AS contact_email_56, t40.contact_phone AS contact_phone_57, t40.contact_address AS contact_address_58, t40.primary_color AS primary_color_59, t40.secondary_color AS secondary_color_60, t40.seo_title AS seo_title_61, t40.seo_description AS seo_description_62, t40.direct_booking_enabled AS direct_booking_enabled_63, t40.published AS published_64, t40.published_at AS published_at_65, t40.preview_image AS preview_image_66, t40.created_at AS created_at_67, t40.updated_at AS updated_at_68, t40.property_id AS property_id_69, t40.theme_id AS theme_id_70 FROM property t0 LEFT JOIN property_website t40 ON t40.property_id = t0.id WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#771
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.filename AS filename_2, t0.original_name AS original_name_3, t0.alt AS alt_4, t0.caption AS caption_5, t0.position AS position_6, t0.active AS active_7, t0.hero AS hero_8, t0.presentation AS presentation_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.property_id AS property_id_12 FROM property_media t0 WHERE t0.property_id = ? ORDER BY t0.position ASC, t0.created_at ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#771
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.icon AS icon_3, t0.description AS description_4, t0.active AS active_5 FROM amenity t0 INNER JOIN property_amenity ON t0.id = property_amenity.amenity_id WHERE property_amenity.property_id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#771
      +name: "INTEGER"
    }
  ]
]