Symfony Profiler

[
  "route" => "search.city"
  "route_parameters" => [
    "_route" => "search.city"
    "_controller" => "App\Controller\SearchController::city"
    "_locale" => "fr"
    "city" => "liege-4000"
  ]
  "request_uri" => "https://test.123loger.com/location/liege-4000/"
  "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"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bridge\Doctrine\Middleware\IdleConnection\Listener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelRequestPrettyUrls"
]

[
  "event" => "kernel.request"
  "listener" => "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsCsrfTokenValidAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "ContainerXETRgo7\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "params" => [
    "driver" => "pdo_pgsql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 5432
    "user" => "panda"
    "password" => "<redacted>"
    "driverOptions" => []
    "serverVersion" => "15"
    "defaultTableOptions" => []
    "dbname" => "123loger"
    "charset" => "utf8"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.zipcode AS zipcode_2, t0.locality AS locality_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.osm AS osm_6, t0.tier AS tier_7, t0.city AS city_8, t0.slug AS slug_9, t0.search AS search_10, t0.area AS area_11, t0.state AS state_12, t0.illustration AS illustration_13, t0.priority AS priority_14 FROM locality t0 WHERE t0.slug = ? LIMIT 1"
  "params" => [
    1 => "liege-4000"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT DISTINCT l0_.locality AS locality_0, l0_.city AS city_1, l0_.slug AS slug_2, l0_.zipcode AS zipcode_3, l0_.latitude AS latitude_4, l0_.longitude AS longitude_5 FROM locality l0_ WHERE l0_.latitude > ? AND l0_.latitude < ? AND l0_.longitude > ? AND l0_.longitude < ? AND l0_.slug <> ? AND (l0_.slug LIKE ? OR l0_.slug LIKE ? OR l0_.slug LIKE ? OR l0_.slug LIKE ? OR l0_.slug LIKE ? OR l0_.slug LIKE ? OR l0_.slug LIKE ? OR l0_.slug LIKE ? OR l0_.slug LIKE ? OR l0_.slug LIKE ?) ORDER BY l0_.zipcode ASC, l0_.city ASC"
  "params" => [
    1 => 50.573229147349
    2 => 50.716959652651
    3 => 5.4602808995448
    4 => 5.6869415004552
    5 => "liege-4000"
    6 => "%0%"
    7 => "%1%"
    8 => "%2%"
    9 => "%3%"
    10 => "%4%"
    11 => "%5%"
    12 => "%6%"
    13 => "%7%"
    14 => "%8%"
    15 => "%9%"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
    12 => 2
    13 => 2
    14 => 2
    15 => 2
  ]
]

[
  "sql" => "SELECT MAX(p0_.rent) AS sclr_0 FROM property p0_ LEFT JOIN address a1_ ON p0_.address_id = a1_.id WHERE p0_.status = 2 AND a1_.city IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND a1_.zipcode IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => "Liège"
    2 => "Glain"
    3 => "Rocourt"
    4 => "Bressoux"
    5 => "Jupille-sur-Meuse"
    6 => "Wandre"
    7 => "Grivegnée"
    8 => "Angleur"
    9 => "Chênée"
    10 => "Herstal"
    11 => "Milmort"
    12 => "Vottem"
    13 => "Liers"
    14 => "Chaudfontaine"
    15 => "Vaux-sous-Chèvremont"
    16 => "Embourg"
    17 => "Seraing"
    18 => "Jemeppe-sur-Meuse"
    19 => "Ougrée"
    20 => "Awans"
    21 => "Othée"
    22 => "Flémalle"
    23 => "Flémalle-Grande"
    24 => "Montegnée"
    25 => "Saint-Nicolas"
    26 => "Tilleur"
    27 => "Ans"
    28 => "Loncin"
    29 => "Alleur"
    30 => "Xhendremael"
    31 => "Juprelle"
    32 => "Lantin"
    33 => "Voroux-lez-Liers"
    34 => "Villers-Saint-Siméon"
    35 => "Fexhe-Slins"
    36 => "Grâce-Berleur"
    37 => "Grâce-Hollogne"
    38 => "Hollogne-aux-Pierres"
    39 => "Argenteau"
    40 => "Cheratte"
    41 => "Bellaire"
    42 => "Beyne-Heusay"
    43 => "Queue-du-Bois"
    44 => "Fléron"
    45 => "Magnée"
    46 => "Romsée"
    47 => "Saive"
    48 => "Hermée"
    49 => "Oupeye"
    50 => "Hermalle-sous-Argenteau"
    51 => "Vivegnis"
    52 => "4000"
    53 => "4000"
    54 => "4000"
    55 => "4020"
    56 => "4020"
    57 => "4020"
    58 => "4030"
    59 => "4031"
    60 => "4032"
    61 => "4040"
    62 => "4041"
    63 => "4041"
    64 => "4042"
    65 => "4050"
    66 => "4051"
    67 => "4053"
    68 => "4100"
    69 => "4101"
    70 => "4102"
    71 => "4340"
    72 => "4340"
    73 => "4400"
    74 => "4400"
    75 => "4420"
    76 => "4420"
    77 => "4420"
    78 => "4430"
    79 => "4431"
    80 => "4432"
    81 => "4432"
    82 => "4450"
    83 => "4450"
    84 => "4451"
    85 => "4453"
    86 => "4458"
    87 => "4460"
    88 => "4460"
    89 => "4460"
    90 => "4601"
    91 => "4602"
    92 => "4610"
    93 => "4610"
    94 => "4610"
    95 => "4620"
    96 => "4623"
    97 => "4624"
    98 => "4671"
    99 => "4680"
    100 => "4680"
    101 => "4681"
    102 => "4683"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
    12 => 2
    13 => 2
    14 => 2
    15 => 2
    16 => 2
    17 => 2
    18 => 2
    19 => 2
    20 => 2
    21 => 2
    22 => 2
    23 => 2
    24 => 2
    25 => 2
    26 => 2
    27 => 2
    28 => 2
    29 => 2
    30 => 2
    31 => 2
    32 => 2
    33 => 2
    34 => 2
    35 => 2
    36 => 2
    37 => 2
    38 => 2
    39 => 2
    40 => 2
    41 => 2
    42 => 2
    43 => 2
    44 => 2
    45 => 2
    46 => 2
    47 => 2
    48 => 2
    49 => 2
    50 => 2
    51 => 2
    52 => 2
    53 => 2
    54 => 2
    55 => 2
    56 => 2
    57 => 2
    58 => 2
    59 => 2
    60 => 2
    61 => 2
    62 => 2
    63 => 2
    64 => 2
    65 => 2
    66 => 2
    67 => 2
    68 => 2
    69 => 2
    70 => 2
    71 => 2
    72 => 2
    73 => 2
    74 => 2
    75 => 2
    76 => 2
    77 => 2
    78 => 2
    79 => 2
    80 => 2
    81 => 2
    82 => 2
    83 => 2
    84 => 2
    85 => 2
    86 => 2
    87 => 2
    88 => 2
    89 => 2
    90 => 2
    91 => 2
    92 => 2
    93 => 2
    94 => 2
    95 => 2
    96 => 2
    97 => 2
    98 => 2
    99 => 2
    100 => 2
    101 => 2
    102 => 2
  ]
]

[
  "sql" => "SELECT MIN(p0_.rent) AS sclr_0 FROM property p0_ LEFT JOIN address a1_ ON p0_.address_id = a1_.id WHERE p0_.status = 2 AND a1_.city IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND a1_.zipcode IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => "Liège"
    2 => "Glain"
    3 => "Rocourt"
    4 => "Bressoux"
    5 => "Jupille-sur-Meuse"
    6 => "Wandre"
    7 => "Grivegnée"
    8 => "Angleur"
    9 => "Chênée"
    10 => "Herstal"
    11 => "Milmort"
    12 => "Vottem"
    13 => "Liers"
    14 => "Chaudfontaine"
    15 => "Vaux-sous-Chèvremont"
    16 => "Embourg"
    17 => "Seraing"
    18 => "Jemeppe-sur-Meuse"
    19 => "Ougrée"
    20 => "Awans"
    21 => "Othée"
    22 => "Flémalle"
    23 => "Flémalle-Grande"
    24 => "Montegnée"
    25 => "Saint-Nicolas"
    26 => "Tilleur"
    27 => "Ans"
    28 => "Loncin"
    29 => "Alleur"
    30 => "Xhendremael"
    31 => "Juprelle"
    32 => "Lantin"
    33 => "Voroux-lez-Liers"
    34 => "Villers-Saint-Siméon"
    35 => "Fexhe-Slins"
    36 => "Grâce-Berleur"
    37 => "Grâce-Hollogne"
    38 => "Hollogne-aux-Pierres"
    39 => "Argenteau"
    40 => "Cheratte"
    41 => "Bellaire"
    42 => "Beyne-Heusay"
    43 => "Queue-du-Bois"
    44 => "Fléron"
    45 => "Magnée"
    46 => "Romsée"
    47 => "Saive"
    48 => "Hermée"
    49 => "Oupeye"
    50 => "Hermalle-sous-Argenteau"
    51 => "Vivegnis"
    52 => "4000"
    53 => "4000"
    54 => "4000"
    55 => "4020"
    56 => "4020"
    57 => "4020"
    58 => "4030"
    59 => "4031"
    60 => "4032"
    61 => "4040"
    62 => "4041"
    63 => "4041"
    64 => "4042"
    65 => "4050"
    66 => "4051"
    67 => "4053"
    68 => "4100"
    69 => "4101"
    70 => "4102"
    71 => "4340"
    72 => "4340"
    73 => "4400"
    74 => "4400"
    75 => "4420"
    76 => "4420"
    77 => "4420"
    78 => "4430"
    79 => "4431"
    80 => "4432"
    81 => "4432"
    82 => "4450"
    83 => "4450"
    84 => "4451"
    85 => "4453"
    86 => "4458"
    87 => "4460"
    88 => "4460"
    89 => "4460"
    90 => "4601"
    91 => "4602"
    92 => "4610"
    93 => "4610"
    94 => "4610"
    95 => "4620"
    96 => "4623"
    97 => "4624"
    98 => "4671"
    99 => "4680"
    100 => "4680"
    101 => "4681"
    102 => "4683"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
    12 => 2
    13 => 2
    14 => 2
    15 => 2
    16 => 2
    17 => 2
    18 => 2
    19 => 2
    20 => 2
    21 => 2
    22 => 2
    23 => 2
    24 => 2
    25 => 2
    26 => 2
    27 => 2
    28 => 2
    29 => 2
    30 => 2
    31 => 2
    32 => 2
    33 => 2
    34 => 2
    35 => 2
    36 => 2
    37 => 2
    38 => 2
    39 => 2
    40 => 2
    41 => 2
    42 => 2
    43 => 2
    44 => 2
    45 => 2
    46 => 2
    47 => 2
    48 => 2
    49 => 2
    50 => 2
    51 => 2
    52 => 2
    53 => 2
    54 => 2
    55 => 2
    56 => 2
    57 => 2
    58 => 2
    59 => 2
    60 => 2
    61 => 2
    62 => 2
    63 => 2
    64 => 2
    65 => 2
    66 => 2
    67 => 2
    68 => 2
    69 => 2
    70 => 2
    71 => 2
    72 => 2
    73 => 2
    74 => 2
    75 => 2
    76 => 2
    77 => 2
    78 => 2
    79 => 2
    80 => 2
    81 => 2
    82 => 2
    83 => 2
    84 => 2
    85 => 2
    86 => 2
    87 => 2
    88 => 2
    89 => 2
    90 => 2
    91 => 2
    92 => 2
    93 => 2
    94 => 2
    95 => 2
    96 => 2
    97 => 2
    98 => 2
    99 => 2
    100 => 2
    101 => 2
    102 => 2
  ]
]

[
  "sql" => "SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.uid AS uid_1, p0_.created_at AS created_at_2, p0_.updated_at AS updated_at_3, p0_.status AS status_4, p0_.state AS state_5, p0_.type AS type_6, p0_.area AS area_7, p0_.rooms AS rooms_8, p0_.floor AS floor_9, p0_.elevator AS elevator_10, p0_.furnished AS furnished_11, p0_.heating AS heating_12, p0_.equipments AS equipments_13, p0_.benefits AS benefits_14, p0_.rent AS rent_15, p0_.charges AS charges_16, p0_.services AS services_17, p0_.availability_date AS availability_date_18, p0_.description AS description_19, p0_.title AS title_20, p0_.active AS active_21, p0_.score AS score_22, p0_.extrafields AS extrafields_23 FROM property p0_ LEFT JOIN address a1_ ON p0_.address_id = a1_.id WHERE p0_.status = 2 AND a1_.city IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND a1_.slug IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.active DESC, CASE WHEN a1_.slug = ? THEN 1 ELSE 0 END DESC, CASE WHEN a1_.city LIKE ? THEN 1 ELSE 0 END DESC, p0_.score DESC, p0_.created_at DESC) dctrn_result) dctrn_table"
  "params" => [
    1 => "Liège"
    2 => "Glain"
    3 => "Rocourt"
    4 => "Bressoux"
    5 => "Jupille-sur-Meuse"
    6 => "Wandre"
    7 => "Grivegnée"
    8 => "Angleur"
    9 => "Chênée"
    10 => "Herstal"
    11 => "Milmort"
    12 => "Vottem"
    13 => "Liers"
    14 => "Chaudfontaine"
    15 => "Vaux-sous-Chèvremont"
    16 => "Embourg"
    17 => "Seraing"
    18 => "Jemeppe-sur-Meuse"
    19 => "Ougrée"
    20 => "Awans"
    21 => "Othée"
    22 => "Flémalle"
    23 => "Flémalle-Grande"
    24 => "Montegnée"
    25 => "Saint-Nicolas"
    26 => "Tilleur"
    27 => "Ans"
    28 => "Loncin"
    29 => "Alleur"
    30 => "Xhendremael"
    31 => "Juprelle"
    32 => "Lantin"
    33 => "Voroux-lez-Liers"
    34 => "Villers-Saint-Siméon"
    35 => "Fexhe-Slins"
    36 => "Grâce-Berleur"
    37 => "Grâce-Hollogne"
    38 => "Hollogne-aux-Pierres"
    39 => "Argenteau"
    40 => "Cheratte"
    41 => "Bellaire"
    42 => "Beyne-Heusay"
    43 => "Queue-du-Bois"
    44 => "Fléron"
    45 => "Magnée"
    46 => "Romsée"
    47 => "Saive"
    48 => "Hermée"
    49 => "Oupeye"
    50 => "Hermalle-sous-Argenteau"
    51 => "Vivegnis"
    52 => "liege-4000"
    53 => "glain-4000"
    54 => "rocourt-4000"
    55 => "bressoux-4020"
    56 => "jupille-sur-meuse-4020"
    57 => "wandre-4020"
    58 => "grivegnee-4030"
    59 => "angleur-4031"
    60 => "chenee-4032"
    61 => "herstal-4040"
    62 => "milmort-4041"
    63 => "vottem-4041"
    64 => "liers-4042"
    65 => "chaudfontaine-4050"
    66 => "vaux-sous-chevremont-4051"
    67 => "embourg-4053"
    68 => "seraing-4100"
    69 => "jemeppe-sur-meuse-4101"
    70 => "ougree-4102"
    71 => "awans-4340"
    72 => "othee-4340"
    73 => "flemalle-4400"
    74 => "flemalle-grande-4400"
    75 => "montegnee-4420"
    76 => "saint-nicolas-4420"
    77 => "tilleur-4420"
    78 => "ans-4430"
    79 => "loncin-4431"
    80 => "alleur-4432"
    81 => "xhendremael-4432"
    82 => "juprelle-4450"
    83 => "lantin-4450"
    84 => "voroux-lez-liers-4451"
    85 => "villers-saint-simeon-4453"
    86 => "fexhe-slins-4458"
    87 => "grace-berleur-4460"
    88 => "grace-hollogne-4460"
    89 => "hollogne-aux-pierres-4460"
    90 => "argenteau-4601"
    91 => "cheratte-4602"
    92 => "bellaire-4610"
    93 => "beyne-heusay-4610"
    94 => "queue-du-bois-4610"
    95 => "fleron-4620"
    96 => "magnee-4623"
    97 => "romsee-4624"
    98 => "saive-4671"
    99 => "hermee-4680"
    100 => "oupeye-4680"
    101 => "hermalle-sous-argenteau-4681"
    102 => "vivegnis-4683"
    103 => "liege-4000"
    104 => "Liège%"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
    12 => 2
    13 => 2
    14 => 2
    15 => 2
    16 => 2
    17 => 2
    18 => 2
    19 => 2
    20 => 2
    21 => 2
    22 => 2
    23 => 2
    24 => 2
    25 => 2
    26 => 2
    27 => 2
    28 => 2
    29 => 2
    30 => 2
    31 => 2
    32 => 2
    33 => 2
    34 => 2
    35 => 2
    36 => 2
    37 => 2
    38 => 2
    39 => 2
    40 => 2
    41 => 2
    42 => 2
    43 => 2
    44 => 2
    45 => 2
    46 => 2
    47 => 2
    48 => 2
    49 => 2
    50 => 2
    51 => 2
    52 => 2
    53 => 2
    54 => 2
    55 => 2
    56 => 2
    57 => 2
    58 => 2
    59 => 2
    60 => 2
    61 => 2
    62 => 2
    63 => 2
    64 => 2
    65 => 2
    66 => 2
    67 => 2
    68 => 2
    69 => 2
    70 => 2
    71 => 2
    72 => 2
    73 => 2
    74 => 2
    75 => 2
    76 => 2
    77 => 2
    78 => 2
    79 => 2
    80 => 2
    81 => 2
    82 => 2
    83 => 2
    84 => 2
    85 => 2
    86 => 2
    87 => 2
    88 => 2
    89 => 2
    90 => 2
    91 => 2
    92 => 2
    93 => 2
    94 => 2
    95 => 2
    96 => 2
    97 => 2
    98 => 2
    99 => 2
    100 => 2
    101 => 2
    102 => 2
    103 => 2
    104 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.zipcode AS zipcode_2, t0.locality AS locality_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.osm AS osm_6, t0.tier AS tier_7, t0.city AS city_8, t0.slug AS slug_9, t0.search AS search_10, t0.area AS area_11, t0.state AS state_12, t0.illustration AS illustration_13, t0.priority AS priority_14 FROM locality t0 WHERE t0.city = ? AND t0.zipcode = ? LIMIT 1"
  "params" => [
    1 => "Liège"
    2 => "4000"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.type AS type_2, t0.content AS content_3, t0.h1 AS h1_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.canonical AS canonical_7, t0.locality_id AS locality_id_8 FROM locality_description t0 WHERE t0.locality_id = ? AND t0.type IS NULL LIMIT 1"
  "params" => [
    1 => 741
  ]
  "types" => [
    1 => 1
  ]
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "sql" => "SELECT DISTINCT id_0, MIN(sclr_24) AS dctrn_minrownum FROM (SELECT p0_.id AS id_0, p0_.uid AS uid_1, p0_.created_at AS created_at_2, p0_.updated_at AS updated_at_3, p0_.status AS status_4, p0_.state AS state_5, p0_.type AS type_6, p0_.area AS area_7, p0_.rooms AS rooms_8, p0_.floor AS floor_9, p0_.elevator AS elevator_10, p0_.furnished AS furnished_11, p0_.heating AS heating_12, p0_.equipments AS equipments_13, p0_.benefits AS benefits_14, p0_.rent AS rent_15, p0_.charges AS charges_16, p0_.services AS services_17, p0_.availability_date AS availability_date_18, p0_.description AS description_19, p0_.title AS title_20, p0_.active AS active_21, p0_.score AS score_22, p0_.extrafields AS extrafields_23, ROW_NUMBER() OVER(ORDER BY p0_.active DESC, CASE WHEN a1_.slug = ? THEN 1 ELSE 0 END DESC, CASE WHEN a1_.city LIKE ? THEN 1 ELSE 0 END DESC, p0_.score DESC, p0_.created_at DESC) AS sclr_24 FROM property p0_ LEFT JOIN address a1_ ON p0_.address_id = a1_.id WHERE p0_.status = 2 AND a1_.city IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND a1_.slug IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC LIMIT 20"
  "params" => [
    1 => "liege-4000"
    2 => "Liège%"
    3 => "Liège"
    4 => "Glain"
    5 => "Rocourt"
    6 => "Bressoux"
    7 => "Jupille-sur-Meuse"
    8 => "Wandre"
    9 => "Grivegnée"
    10 => "Angleur"
    11 => "Chênée"
    12 => "Herstal"
    13 => "Milmort"
    14 => "Vottem"
    15 => "Liers"
    16 => "Chaudfontaine"
    17 => "Vaux-sous-Chèvremont"
    18 => "Embourg"
    19 => "Seraing"
    20 => "Jemeppe-sur-Meuse"
    21 => "Ougrée"
    22 => "Awans"
    23 => "Othée"
    24 => "Flémalle"
    25 => "Flémalle-Grande"
    26 => "Montegnée"
    27 => "Saint-Nicolas"
    28 => "Tilleur"
    29 => "Ans"
    30 => "Loncin"
    31 => "Alleur"
    32 => "Xhendremael"
    33 => "Juprelle"
    34 => "Lantin"
    35 => "Voroux-lez-Liers"
    36 => "Villers-Saint-Siméon"
    37 => "Fexhe-Slins"
    38 => "Grâce-Berleur"
    39 => "Grâce-Hollogne"
    40 => "Hollogne-aux-Pierres"
    41 => "Argenteau"
    42 => "Cheratte"
    43 => "Bellaire"
    44 => "Beyne-Heusay"
    45 => "Queue-du-Bois"
    46 => "Fléron"
    47 => "Magnée"
    48 => "Romsée"
    49 => "Saive"
    50 => "Hermée"
    51 => "Oupeye"
    52 => "Hermalle-sous-Argenteau"
    53 => "Vivegnis"
    54 => "liege-4000"
    55 => "glain-4000"
    56 => "rocourt-4000"
    57 => "bressoux-4020"
    58 => "jupille-sur-meuse-4020"
    59 => "wandre-4020"
    60 => "grivegnee-4030"
    61 => "angleur-4031"
    62 => "chenee-4032"
    63 => "herstal-4040"
    64 => "milmort-4041"
    65 => "vottem-4041"
    66 => "liers-4042"
    67 => "chaudfontaine-4050"
    68 => "vaux-sous-chevremont-4051"
    69 => "embourg-4053"
    70 => "seraing-4100"
    71 => "jemeppe-sur-meuse-4101"
    72 => "ougree-4102"
    73 => "awans-4340"
    74 => "othee-4340"
    75 => "flemalle-4400"
    76 => "flemalle-grande-4400"
    77 => "montegnee-4420"
    78 => "saint-nicolas-4420"
    79 => "tilleur-4420"
    80 => "ans-4430"
    81 => "loncin-4431"
    82 => "alleur-4432"
    83 => "xhendremael-4432"
    84 => "juprelle-4450"
    85 => "lantin-4450"
    86 => "voroux-lez-liers-4451"
    87 => "villers-saint-simeon-4453"
    88 => "fexhe-slins-4458"
    89 => "grace-berleur-4460"
    90 => "grace-hollogne-4460"
    91 => "hollogne-aux-pierres-4460"
    92 => "argenteau-4601"
    93 => "cheratte-4602"
    94 => "bellaire-4610"
    95 => "beyne-heusay-4610"
    96 => "queue-du-bois-4610"
    97 => "fleron-4620"
    98 => "magnee-4623"
    99 => "romsee-4624"
    100 => "saive-4671"
    101 => "hermee-4680"
    102 => "oupeye-4680"
    103 => "hermalle-sous-argenteau-4681"
    104 => "vivegnis-4683"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
    12 => 2
    13 => 2
    14 => 2
    15 => 2
    16 => 2
    17 => 2
    18 => 2
    19 => 2
    20 => 2
    21 => 2
    22 => 2
    23 => 2
    24 => 2
    25 => 2
    26 => 2
    27 => 2
    28 => 2
    29 => 2
    30 => 2
    31 => 2
    32 => 2
    33 => 2
    34 => 2
    35 => 2
    36 => 2
    37 => 2
    38 => 2
    39 => 2
    40 => 2
    41 => 2
    42 => 2
    43 => 2
    44 => 2
    45 => 2
    46 => 2
    47 => 2
    48 => 2
    49 => 2
    50 => 2
    51 => 2
    52 => 2
    53 => 2
    54 => 2
    55 => 2
    56 => 2
    57 => 2
    58 => 2
    59 => 2
    60 => 2
    61 => 2
    62 => 2
    63 => 2
    64 => 2
    65 => 2
    66 => 2
    67 => 2
    68 => 2
    69 => 2
    70 => 2
    71 => 2
    72 => 2
    73 => 2
    74 => 2
    75 => 2
    76 => 2
    77 => 2
    78 => 2
    79 => 2
    80 => 2
    81 => 2
    82 => 2
    83 => 2
    84 => 2
    85 => 2
    86 => 2
    87 => 2
    88 => 2
    89 => 2
    90 => 2
    91 => 2
    92 => 2
    93 => 2
    94 => 2
    95 => 2
    96 => 2
    97 => 2
    98 => 2
    99 => 2
    100 => 2
    101 => 2
    102 => 2
    103 => 2
    104 => 2
  ]
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Csrf\SameOriginCsrfTokenManager::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::removeCspHeader"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"
]