Symfony Profiler

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

Log Messages

"projects"

[
  "route" => "projects"
  "route_parameters" => [
    "_route" => "projects"
    "_controller" => "App\Controller\HomeController::projects"
  ]
  "request_uri" => "https://jptradi.bluelinesoft.be/projects"
  "method" => "GET"
]

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

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

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

[
  "driver" => "pdo_mysql"
  "idle_connection_ttl" => 600
  "host" => "127.0.0.1"
  "port" => 3306
  "user" => "tradi"
  "password" => "<redacted>"
  "driverOptions" => []
  "defaultTableOptions" => []
  "dbname" => "jp_tradi"
  "serverVersion" => "10.11.2-MariaDB"
  "charset" => "utf8mb4"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "tradi"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "jp_tradi"
    "serverVersion" => "10.11.2-MariaDB"
    "charset" => "utf8mb4"
  ]
]

"SELECT MIN(b0_.price) AS sclr_0, MAX(b0_.price) AS sclr_1 FROM building b0_"

[
  "sql" => "SELECT MIN(b0_.price) AS sclr_0, MAX(b0_.price) AS sclr_1 FROM building b0_"
]

"SELECT DISTINCT (b0_.city) AS sclr_0 FROM building b0_ WHERE b0_.city IS NOT NULL"

[
  "sql" => "SELECT DISTINCT (b0_.city) AS sclr_0 FROM building b0_ WHERE b0_.city IS NOT NULL"
]

"SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.street AS street_2, b0_.zip AS zip_3, b0_.city AS city_4, b0_.description AS description_5, b0_.livable_area AS livable_area_6, b0_.land_area AS land_area_7, b0_.number_of_floors AS number_of_floors_8, b0_.number_of_garages AS number_of_garages_9, b0_.living_room_area AS living_room_area_10, b0_.price AS price_11, b0_.type_of_heating AS type_of_heating_12, b0_.gas_connection AS gas_connection_13, b0_.water_connection AS water_connection_14, b0_.equipped_kitchen AS equipped_kitchen_15, b0_.type_of_glazing AS type_of_glazing_16, b0_.active AS active_17, b0_.public_slider_title AS public_slider_title_18, b0_.public_slider_description AS public_slider_description_19, b0_.public_slider_active AS public_slider_active_20, b0_.number_of_bedroom AS number_of_bedroom_21, b0_.country_id AS country_id_22, b0_.peb_id AS peb_id_23, b0_.locality_id AS locality_id_24, b0_.building_type_id AS building_type_id_25, b0_.banner_id AS banner_id_26 FROM building b0_"

[
  "sql" => "SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.street AS street_2, b0_.zip AS zip_3, b0_.city AS city_4, b0_.description AS description_5, b0_.livable_area AS livable_area_6, b0_.land_area AS land_area_7, b0_.number_of_floors AS number_of_floors_8, b0_.number_of_garages AS number_of_garages_9, b0_.living_room_area AS living_room_area_10, b0_.price AS price_11, b0_.type_of_heating AS type_of_heating_12, b0_.gas_connection AS gas_connection_13, b0_.water_connection AS water_connection_14, b0_.equipped_kitchen AS equipped_kitchen_15, b0_.type_of_glazing AS type_of_glazing_16, b0_.active AS active_17, b0_.public_slider_title AS public_slider_title_18, b0_.public_slider_description AS public_slider_description_19, b0_.public_slider_active AS public_slider_active_20, b0_.number_of_bedroom AS number_of_bedroom_21, b0_.country_id AS country_id_22, b0_.peb_id AS peb_id_23, b0_.locality_id AS locality_id_24, b0_.building_type_id AS building_type_id_25, b0_.banner_id AS banner_id_26 FROM building b0_"
]

"SELECT l0_.id AS id_0, l0_.name AS name_1 FROM locality l0_"

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

"SELECT b0_.id AS id_0, b0_.name AS name_1 FROM building_type b0_"

[
  "sql" => "SELECT b0_.id AS id_0, b0_.name AS name_1 FROM building_type b0_"
]

"SELECT t0.id AS id_1, t0.filename AS filename_2, t0.original_filename AS original_filename_3, t0.mime_type AS mime_type_4, t0.position AS position_5, t0.building_id AS building_id_6 FROM building_picture t0 WHERE t0.building_id = ? ORDER BY t0.position ASC"

[
  1 => 1
]

[
  1 => Doctrine\DBAL\ParameterType {#1390
    +name: "INTEGER"
  }
]

[
  "sql" => "SELECT t0.id AS id_1, t0.filename AS filename_2, t0.original_filename AS original_filename_3, t0.mime_type AS mime_type_4, t0.position AS position_5, t0.building_id AS building_id_6 FROM building_picture t0 WHERE t0.building_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1390
      +name: "INTEGER"
    }
  ]
]

"SELECT t0.id AS id_1, t0.name AS name_2 FROM peb t0 WHERE t0.id = ?"

[
  1 => 8
]

[
  1 => Doctrine\DBAL\ParameterType {#1390
    +name: "INTEGER"
  }
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2 FROM peb t0 WHERE t0.id = ?"
  "params" => [
    1 => 8
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1390
      +name: "INTEGER"
    }
  ]
]

"SELECT t0.id AS id_1, t0.filename AS filename_2, t0.original_filename AS original_filename_3, t0.mime_type AS mime_type_4, t0.position AS position_5, t0.building_id AS building_id_6 FROM building_picture t0 WHERE t0.building_id = ? ORDER BY t0.position ASC"

[
  1 => 2
]

[
  1 => Doctrine\DBAL\ParameterType {#1390
    +name: "INTEGER"
  }
]

[
  "sql" => "SELECT t0.id AS id_1, t0.filename AS filename_2, t0.original_filename AS original_filename_3, t0.mime_type AS mime_type_4, t0.position AS position_5, t0.building_id AS building_id_6 FROM building_picture t0 WHERE t0.building_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1390
      +name: "INTEGER"
    }
  ]
]

"SELECT t0.id AS id_1, t0.name AS name_2 FROM peb t0 WHERE t0.id = ?"

[
  1 => 9
]

[
  1 => Doctrine\DBAL\ParameterType {#1390
    +name: "INTEGER"
  }
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2 FROM peb t0 WHERE t0.id = ?"
  "params" => [
    1 => 9
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1390
      +name: "INTEGER"
    }
  ]
]

"SELECT t0.id AS id_1, t0.filename AS filename_2, t0.original_filename AS original_filename_3, t0.mime_type AS mime_type_4, t0.position AS position_5, t0.building_id AS building_id_6 FROM building_picture t0 WHERE t0.building_id = ? ORDER BY t0.position ASC"

[
  1 => 3
]

[
  1 => Doctrine\DBAL\ParameterType {#1390
    +name: "INTEGER"
  }
]

[
  "sql" => "SELECT t0.id AS id_1, t0.filename AS filename_2, t0.original_filename AS original_filename_3, t0.mime_type AS mime_type_4, t0.position AS position_5, t0.building_id AS building_id_6 FROM building_picture t0 WHERE t0.building_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1390
      +name: "INTEGER"
    }
  ]
]

"SELECT t0.id AS id_1, t0.name AS name_2 FROM peb t0 WHERE t0.id = ?"

[
  1 => 1
]

[
  1 => Doctrine\DBAL\ParameterType {#1390
    +name: "INTEGER"
  }
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2 FROM peb t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1390
      +name: "INTEGER"
    }
  ]
]

"SELECT t0.id AS id_1, t0.filename AS filename_2, t0.original_filename AS original_filename_3, t0.mime_type AS mime_type_4, t0.position AS position_5, t0.building_id AS building_id_6 FROM building_picture t0 WHERE t0.building_id = ? ORDER BY t0.position ASC"

[
  1 => 4
]

[
  1 => Doctrine\DBAL\ParameterType {#1390
    +name: "INTEGER"
  }
]

[
  "sql" => "SELECT t0.id AS id_1, t0.filename AS filename_2, t0.original_filename AS original_filename_3, t0.mime_type AS mime_type_4, t0.position AS position_5, t0.building_id AS building_id_6 FROM building_picture t0 WHERE t0.building_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1390
      +name: "INTEGER"
    }
  ]
]