Symfony Profiler

[
  "route" => "app_service_show"
  "route_parameters" => [
    "_route" => "app_service_show"
    "_controller" => "App\Controller\ServiceController::show"
    "slug" => "fetishes-and-bdsm"
  ]
  "request_uri" => "https://beta.pretoriaescorts.co.za/service/fetishes-and-bdsm"
  "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" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "pretoriaescorts_db2"
    "password" => "<redacted>"
    "driverOptions" => []
    "serverVersion" => "10.11.2-MariaDB"
    "defaultTableOptions" => []
    "dbname" => "pretoriaescorts_db2"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.created_at AS created_at_3, s0_.updated_at AS updated_at_4 FROM service s0_ WHERE s0_.slug = ?"
  "params" => [
    1 => "fetishes-and-bdsm"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#861
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.description AS description_3, p0_.profile_image AS profile_image_4, p0_.bio AS bio_5, p0_.portfolio_link AS portfolio_link_6, p0_.instagram_handle AS instagram_handle_7, p0_.availability_notes AS availability_notes_8, p0_.publish_start_at AS publish_start_at_9, p0_.publish_end_at AS publish_end_at_10, p0_.status AS status_11, p0_.created_at AS created_at_12, p0_.updated_at AS updated_at_13, p0_.is_verified AS is_verified_14, p0_.verified_at AS verified_at_15, p0_.view_count AS view_count_16, p0_.favorite_count AS favorite_count_17, p0_.contact_count AS contact_count_18, p0_.average_rating AS average_rating_19, p0_.review_count AS review_count_20, p0_.phone1 AS phone1_21, p0_.whatsapp AS whatsapp_22, p0_.contact_email AS contact_email_23, p0_.instagram AS instagram_24, p0_.facebook AS facebook_25, p0_.x AS x_26, p0_.webpage AS webpage_27, p0_.phone2 AS phone2_28, p0_.user_id AS user_id_29, p0_.venue_id AS venue_id_30 FROM profile p0_ INNER JOIN profile_service p1_ ON p0_.id = p1_.profile_id WHERE p1_.service_id = ? AND p0_.status = ? ORDER BY p0_.created_at DESC"
  "params" => [
    1 => 4
    2 => 10
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#946
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#946}
  ]
]

[
  "sql" => "SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2, a0_.created_at AS created_at_3, a0_.updated_at AS updated_at_4 FROM area a0_ ORDER BY a0_.name ASC"
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.created_at AS created_at_3, s0_.updated_at AS updated_at_4 FROM service s0_ ORDER BY s0_.name ASC"
]

[
  "sql" => "SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.position AS position_2, b0_.image_path AS image_path_3, b0_.link_url AS link_url_4, b0_.start_date AS start_date_5, b0_.end_date AS end_date_6, b0_.is_active AS is_active_7, b0_.click_count AS click_count_8, b0_.view_count AS view_count_9, b0_.sort_order AS sort_order_10, b0_.created_at AS created_at_11 FROM banner b0_ WHERE b0_.is_active = 1 AND ((b0_.start_date IS NULL OR b0_.start_date <= ?)) AND ((b0_.end_date IS NULL OR b0_.end_date >= ?)) AND b0_.position = ? ORDER BY b0_.sort_order ASC"
  "params" => [
    1 => 1780470751
    2 => 1780470751
    3 => "header"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#946
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#946}
    3 => Doctrine\DBAL\ParameterType {#861
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT a0_.id AS id_0, a0_.page_type AS page_type_1, a0_.slot_name AS slot_name_2, a0_.display_name AS display_name_3, a0_.rotation_mode AS rotation_mode_4, a0_.allowed_formats AS allowed_formats_5, a0_.dimensions AS dimensions_6, a0_.is_active AS is_active_7, a0_.created_at AS created_at_8 FROM ad_slot a0_ WHERE a0_.page_type = ? AND a0_.slot_name = ? AND a0_.is_active = 1"
  "params" => [
    1 => "service_profile"
    2 => "service_profile-top-landscape"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#861
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#861}
  ]
]

[
  "sql" => "SELECT a0_.id AS id_0, a0_.priority AS priority_1, a0_.start_at AS start_at_2, a0_.end_at AS end_at_3, a0_.is_active AS is_active_4, a0_.created_at AS created_at_5, a0_.advert_id AS advert_id_6, a0_.ad_slot_id AS ad_slot_id_7 FROM ad_schedule a0_ INNER JOIN advert a1_ ON a0_.advert_id = a1_.id INNER JOIN ad_slot a2_ ON a0_.ad_slot_id = a2_.id WHERE a2_.page_type = ? AND a2_.slot_name = ? AND a2_.is_active = 1 AND a0_.is_active = 1 AND a1_.is_active = 1 AND ((a0_.start_at IS NULL OR a0_.start_at <= ?)) AND ((a0_.end_at IS NULL OR a0_.end_at >= ?)) ORDER BY a0_.priority DESC, a0_.created_at ASC"
  "params" => [
    1 => "service_profile"
    2 => "service_profile-top-landscape"
    3 => "2026-06-03 09:12:31"
    4 => "2026-06-03 09:12:31"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#861
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#861}
    3 => Doctrine\DBAL\ParameterType {#861}
    4 => Doctrine\DBAL\ParameterType {#861}
  ]
]

[
  "sql" => "SELECT a0_.id AS id_0, a0_.page_type AS page_type_1, a0_.slot_name AS slot_name_2, a0_.display_name AS display_name_3, a0_.rotation_mode AS rotation_mode_4, a0_.allowed_formats AS allowed_formats_5, a0_.dimensions AS dimensions_6, a0_.is_active AS is_active_7, a0_.created_at AS created_at_8 FROM ad_slot a0_ WHERE a0_.page_type = ? AND a0_.slot_name = ? AND a0_.is_active = 1"
  "params" => [
    1 => "service_profile"
    2 => "service_profile-top-portrait"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#861
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#861}
  ]
]

[
  "sql" => "SELECT a0_.id AS id_0, a0_.priority AS priority_1, a0_.start_at AS start_at_2, a0_.end_at AS end_at_3, a0_.is_active AS is_active_4, a0_.created_at AS created_at_5, a0_.advert_id AS advert_id_6, a0_.ad_slot_id AS ad_slot_id_7 FROM ad_schedule a0_ INNER JOIN advert a1_ ON a0_.advert_id = a1_.id INNER JOIN ad_slot a2_ ON a0_.ad_slot_id = a2_.id WHERE a2_.page_type = ? AND a2_.slot_name = ? AND a2_.is_active = 1 AND a0_.is_active = 1 AND a1_.is_active = 1 AND ((a0_.start_at IS NULL OR a0_.start_at <= ?)) AND ((a0_.end_at IS NULL OR a0_.end_at >= ?)) ORDER BY a0_.priority DESC, a0_.created_at ASC"
  "params" => [
    1 => "service_profile"
    2 => "service_profile-top-portrait"
    3 => "2026-06-03 09:12:31"
    4 => "2026-06-03 09:12:31"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#861
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#861}
    3 => Doctrine\DBAL\ParameterType {#861}
    4 => Doctrine\DBAL\ParameterType {#861}
  ]
]

[
  "sql" => "SELECT a0_.id AS id_0, a0_.page_type AS page_type_1, a0_.slot_name AS slot_name_2, a0_.display_name AS display_name_3, a0_.rotation_mode AS rotation_mode_4, a0_.allowed_formats AS allowed_formats_5, a0_.dimensions AS dimensions_6, a0_.is_active AS is_active_7, a0_.created_at AS created_at_8 FROM ad_slot a0_ WHERE a0_.page_type = ? AND a0_.slot_name = ? AND a0_.is_active = 1"
  "params" => [
    1 => "service_profile"
    2 => "service_profile-bottom-landscape"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#861
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#861}
  ]
]

[
  "sql" => "SELECT a0_.id AS id_0, a0_.priority AS priority_1, a0_.start_at AS start_at_2, a0_.end_at AS end_at_3, a0_.is_active AS is_active_4, a0_.created_at AS created_at_5, a0_.advert_id AS advert_id_6, a0_.ad_slot_id AS ad_slot_id_7 FROM ad_schedule a0_ INNER JOIN advert a1_ ON a0_.advert_id = a1_.id INNER JOIN ad_slot a2_ ON a0_.ad_slot_id = a2_.id WHERE a2_.page_type = ? AND a2_.slot_name = ? AND a2_.is_active = 1 AND a0_.is_active = 1 AND a1_.is_active = 1 AND ((a0_.start_at IS NULL OR a0_.start_at <= ?)) AND ((a0_.end_at IS NULL OR a0_.end_at >= ?)) ORDER BY a0_.priority DESC, a0_.created_at ASC"
  "params" => [
    1 => "service_profile"
    2 => "service_profile-bottom-landscape"
    3 => "2026-06-03 09:12:31"
    4 => "2026-06-03 09:12:31"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#861
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#861}
    3 => Doctrine\DBAL\ParameterType {#861}
    4 => Doctrine\DBAL\ParameterType {#861}
  ]
]

[
  "sql" => "SELECT a0_.id AS id_0, a0_.page_type AS page_type_1, a0_.slot_name AS slot_name_2, a0_.display_name AS display_name_3, a0_.rotation_mode AS rotation_mode_4, a0_.allowed_formats AS allowed_formats_5, a0_.dimensions AS dimensions_6, a0_.is_active AS is_active_7, a0_.created_at AS created_at_8 FROM ad_slot a0_ WHERE a0_.page_type = ? AND a0_.slot_name = ? AND a0_.is_active = 1"
  "params" => [
    1 => "service_profile"
    2 => "service_profile-bottom-portrait"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#861
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#861}
  ]
]

[
  "sql" => "SELECT a0_.id AS id_0, a0_.priority AS priority_1, a0_.start_at AS start_at_2, a0_.end_at AS end_at_3, a0_.is_active AS is_active_4, a0_.created_at AS created_at_5, a0_.advert_id AS advert_id_6, a0_.ad_slot_id AS ad_slot_id_7 FROM ad_schedule a0_ INNER JOIN advert a1_ ON a0_.advert_id = a1_.id INNER JOIN ad_slot a2_ ON a0_.ad_slot_id = a2_.id WHERE a2_.page_type = ? AND a2_.slot_name = ? AND a2_.is_active = 1 AND a0_.is_active = 1 AND a1_.is_active = 1 AND ((a0_.start_at IS NULL OR a0_.start_at <= ?)) AND ((a0_.end_at IS NULL OR a0_.end_at >= ?)) ORDER BY a0_.priority DESC, a0_.created_at ASC"
  "params" => [
    1 => "service_profile"
    2 => "service_profile-bottom-portrait"
    3 => "2026-06-03 09:12:31"
    4 => "2026-06-03 09:12:31"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#861
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#861}
    3 => Doctrine\DBAL\ParameterType {#861}
    4 => Doctrine\DBAL\ParameterType {#861}
  ]
]

[
  "sql" => "SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.position AS position_2, b0_.image_path AS image_path_3, b0_.link_url AS link_url_4, b0_.start_date AS start_date_5, b0_.end_date AS end_date_6, b0_.is_active AS is_active_7, b0_.click_count AS click_count_8, b0_.view_count AS view_count_9, b0_.sort_order AS sort_order_10, b0_.created_at AS created_at_11 FROM banner b0_ WHERE b0_.is_active = 1 AND ((b0_.start_date IS NULL OR b0_.start_date <= ?)) AND ((b0_.end_date IS NULL OR b0_.end_date >= ?)) AND b0_.position = ? ORDER BY b0_.sort_order ASC"
  "params" => [
    1 => 1780470751
    2 => 1780470751
    3 => "footer"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#946
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#946}
    3 => Doctrine\DBAL\ParameterType {#861
      +name: "STRING"
    }
  ]
]