Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• Doctrine 1
• HTTP Client
• Debug
• Emails
• Notifications
• Configuration

Log Messages

"list_residential_complexes"

[
  "route" => "list_residential_complexes"
  "route_parameters" => [
    "_route" => "list_residential_complexes"
    "_controller" => "App\Controller\ResidentialComplexController::listResidentialComplexes"
    "_locale" => "en"
  ]
  "request_uri" => "https://imobiliare.n46.net/en/residential-complexes"
  "method" => "GET"
]

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

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

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

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

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

[
  "driver" => "pdo_mysql"
  "charset" => "utf8mb4"
  "idle_connection_ttl" => 600
  "host" => "127.0.0.1"
  "port" => 3306
  "user" => "1007-imobiliare"
  "password" => "<redacted>"
  "driverOptions" => []
  "serverVersion" => "mariadb-10.11.15"
  "defaultTableOptions" => [
    "charset" => "utf8mb4"
    "collation" => "utf8mb4_unicode_ci"
    "engine" => "InnoDB"
  ]
  "dbname" => "1007-imobiliare"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "charset" => "utf8mb4"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "1007-imobiliare"
    "password" => "<redacted>"
    "driverOptions" => []
    "serverVersion" => "mariadb-10.11.15"
    "defaultTableOptions" => [
      "charset" => "utf8mb4"
      "collation" => "utf8mb4_unicode_ci"
      "engine" => "InnoDB"
    ]
    "dbname" => "1007-imobiliare"
  ]
]

"SELECT a0_.id AS id_0, a0_.cadastral_id AS cadastral_id_1, ST_AsText(a0_.multipolygon_moldref) AS multipolygon_moldref_2, ST_AsText(a0_.multipolygon) AS multipolygon_3, ST_AsText(a0_.centroid) AS centroid_4, a0_.land_area AS land_area_5, a0_.name AS name_6, a0_.rcslug AS rcslug_7, a0_.address AS address_8, a0_.instagram_reel_id AS instagram_reel_id_9, a0_.price_per_square_meter AS price_per_square_meter_10, a0_.completion_date AS completion_date_11, a0_.is_sold_out AS is_sold_out_12, a0_.client_status AS client_status_13, a0_.server_status AS server_status_14, a0_.views AS views_15, a0_.created_at AS created_at_16, a0_.updated_at AS updated_at_17, a0_.company_id AS company_id_18, a0_.locality_id AS locality_id_19 FROM ax_residential_complex a0_ WHERE a0_.client_status = ? AND a0_.server_status = ? ORDER BY a0_.name ASC LIMIT 10"

[
  1 => "active"
  2 => "ok"
]

[
  1 => Doctrine\DBAL\ParameterType {#994
    +name: "STRING"
  }
  2 => Doctrine\DBAL\ParameterType {#994}
]

[
  "sql" => "SELECT a0_.id AS id_0, a0_.cadastral_id AS cadastral_id_1, ST_AsText(a0_.multipolygon_moldref) AS multipolygon_moldref_2, ST_AsText(a0_.multipolygon) AS multipolygon_3, ST_AsText(a0_.centroid) AS centroid_4, a0_.land_area AS land_area_5, a0_.name AS name_6, a0_.rcslug AS rcslug_7, a0_.address AS address_8, a0_.instagram_reel_id AS instagram_reel_id_9, a0_.price_per_square_meter AS price_per_square_meter_10, a0_.completion_date AS completion_date_11, a0_.is_sold_out AS is_sold_out_12, a0_.client_status AS client_status_13, a0_.server_status AS server_status_14, a0_.views AS views_15, a0_.created_at AS created_at_16, a0_.updated_at AS updated_at_17, a0_.company_id AS company_id_18, a0_.locality_id AS locality_id_19 FROM ax_residential_complex a0_ WHERE a0_.client_status = ? AND a0_.server_status = ? ORDER BY a0_.name ASC LIMIT 10"
  "params" => [
    1 => "active"
    2 => "ok"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#994
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#994}
  ]
]

"SELECT count(*) AS sclr_0 FROM ax_residential_complex a0_ WHERE a0_.client_status = ? AND a0_.server_status = ?"

[
  1 => "active"
  2 => "ok"
]

[
  1 => Doctrine\DBAL\ParameterType {#994
    +name: "STRING"
  }
  2 => Doctrine\DBAL\ParameterType {#994}
]

[
  "sql" => "SELECT count(*) AS sclr_0 FROM ax_residential_complex a0_ WHERE a0_.client_status = ? AND a0_.server_status = ?"
  "params" => [
    1 => "active"
    2 => "ok"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#994
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#994}
  ]
]

"SELECT a0_.id AS id_0, a0_.slug AS slug_1, a0_.name AS name_2 FROM ax_district a0_"

[
  "sql" => "SELECT a0_.id AS id_0, a0_.slug AS slug_1, a0_.name AS name_2 FROM ax_district a0_"
]