Symfony Profiler

[
  "route" => "app_admin_places_contact_stats"
  "route_parameters" => [
    "_route" => "app_admin_places_contact_stats"
    "_controller" => "App\Controller\AdminController::placesContactStats"
  ]
  "request_uri" => "https://osm-labo.cipherbliss.com/admin/places-contact-stats"
  "method" => "GET"
]

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

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

[
  "event" => "kernel.request"
  "listener" => "App\EventSubscriber\WikiRedirectSubscriber::onKernelRequest"
]

[
  "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\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.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" => "Symfony\Component\HttpKernel\Controller\ArgumentResolver\RequestPayloadValueResolver::onKernelControllerArguments"
]

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

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "sf"
    "password" => "<redacted>"
    "driverOptions" => [
      1002 => "SET NAMES utf8mb4"
      1000 => true
      "PDO::ATTR_TIMEOUT" => 300
      "PDO::ATTR_PERSISTENT" => false
      "PDO::MYSQL_ATTR_USE_BUFFERED_QUERY" => true
      "PDO::MYSQL_ATTR_INIT_COMMAND" => "SET SESSION wait_timeout=300, interactive_timeout=300"
    ]
    "defaultTableOptions" => []
    "dbname" => "osm_my_commerce"
    "serverVersion" => "15"
    "charset" => "utf8"
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM place p0_"
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM place p0_ WHERE p0_.email IS NOT NULL AND p0_.email <> ''"
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM place p0_ WHERE p0_.email IS NULL OR p0_.email = ''"
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM place p0_ WHERE p0_.email IS NOT NULL AND p0_.email <> '' AND (p0_.opted_out = 0 OR p0_.opted_out IS NULL) AND (p0_.dead = 0 OR p0_.dead IS NULL)"
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM place p0_ WHERE p0_.opted_out = 1"
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM place p0_ WHERE p0_.email IS NOT NULL AND p0_.email <> '' AND (p0_.opted_out = 0 OR p0_.opted_out IS NULL) AND (p0_.dead = 0 OR p0_.dead IS NULL) AND p0_.osm_data_date IS NOT NULL AND p0_.osm_data_date <= ?"
  "params" => [
    1 => "2026-01-13 03:21:54"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#859
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM place p0_ WHERE p0_.email IS NOT NULL AND p0_.email <> '' AND (p0_.opted_out = 0 OR p0_.opted_out IS NULL) AND (p0_.dead = 0 OR p0_.dead IS NULL) AND p0_.osm_data_date IS NOT NULL AND p0_.osm_data_date <= ?"
  "params" => [
    1 => "2025-07-13 03:21:54"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#859
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM place p0_ WHERE p0_.email IS NOT NULL AND p0_.email <> '' AND (p0_.opted_out = 0 OR p0_.opted_out IS NULL) AND (p0_.dead = 0 OR p0_.dead IS NULL) AND p0_.osm_data_date IS NOT NULL AND p0_.osm_data_date <= ?"
  "params" => [
    1 => "2024-07-13 03:21:54"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#859
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM place p0_ WHERE p0_.email IS NOT NULL AND p0_.email <> '' AND (p0_.opted_out = 0 OR p0_.opted_out IS NULL) AND (p0_.dead = 0 OR p0_.dead IS NULL) AND p0_.osm_data_date IS NOT NULL AND p0_.osm_data_date <= ?"
  "params" => [
    1 => "2023-07-13 03:21:54"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#859
      +name: "STRING"
    }
  ]
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_pgsql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 5432
    "user" => "osmpgsql"
    "password" => "<redacted>"
    "driverOptions" => [
      1002 => "SET NAMES utf8mb4"
      "PDO::ATTR_TIMEOUT" => 600
      "PDO::ATTR_PERSISTENT" => false
    ]
    "defaultTableOptions" => []
    "dbname" => "osmpgsql"
    "serverVersion" => "16"
    "charset" => "utf8"
  ]
]

[
  "sql" => "SELECT 1"
]

[
  "sql" => "SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = 'public' AND table_name = 'osm_object_meta'"
]

[
  "sql" => """
    SELECT\n
                COUNT(*)                                                                  AS total,\n
                COUNT(*) FILTER (WHERE COALESCE(tags->'email','') <> '' OR COALESCE(tags->'contact:email','') <> '')  AS with_email,\n
                COUNT(*) FILTER (WHERE COALESCE(tags->'phone','') <> '' OR COALESCE(tags->'contact:phone','') <> '')  AS with_phone,\n
                COUNT(*) FILTER (WHERE COALESCE(tags->'website','') <> '' OR COALESCE(tags->'contact:website','') <> ''\n
                                    OR COALESCE(tags->'url','') <> '' OR COALESCE(tags->'contact:url','') <> '')      AS with_website,\n
                COUNT(*) FILTER (WHERE COALESCE(tags->'opening_hours','') <> '')                                       AS with_opening_hours,\n
                COUNT(*) FILTER (WHERE\n
                    (COALESCE(tags->'addr:street','') <> '' AND COALESCE(tags->'addr:housenumber','') <> '')\n
                 OR (COALESCE(tags->'contact:street','') <> '' AND COALESCE(tags->'contact:housenumber','') <> '')\n
                )                                                                                                     AS with_address,\n
                COUNT(*) FILTER (WHERE COALESCE(tags->'ref:FR:SIRET','') <> '')                                        AS with_siret,\n
                COUNT(*) FILTER (WHERE COALESCE(tags->'wheelchair','') <> '')                                          AS with_wheelchair,\n
                COUNT(*) FILTER (WHERE (tags->'amenity') = ANY(ARRAY['library','townhall','restaurant','fast_food','cafe','fuel','pharmacy','bank','bar','hospital','post_office','clinic','pub','car_wash','ice_cream','driving_school','cinema','car_rental','nightclub','bureau_de_change','studio','internet_cafe','money_transfer','casino','vehicle_inspection','frozen_food','boat_rental','coworking_space','workshop','personal_service','camping','dancing_school','training','ski_school','ski_rental','dive_centre','driver_training','nursing_home','funeral_hall','doctors','dentist','theatre','kindergarten','language_school','stripclub','veterinary','convenience','supermarket','clothes','hairdresser','car_repair','bakery','beauty','car','hardware','mobile_phone','butcher','furniture','car_parts','alcohol','florist','scooter','variety_store','electronics','shoes','optician','jewelry','mall','gift','doityourself','greengrocer','books','bicycle','chemist','department_store','laundry','travel_agency','stationery','pet','sports','confectionery','tyres','cosmetics','computer','tailor','tobacco','storage_rental','dry_cleaning','trade','copyshop','motorcycle','funeral_directors','beverages','newsagent','garden_centre','massage','pastry','interior_decoration','general','deli','toys','houseware','wine','seafood','pawnbroker','tattoo','paint','wholesale','photo','second_hand','bed','kitchen','outdoor','fabric','antiques','coffee','gas','e-cigarette','perfumery','craft','hearing_aids','money_lender','appliance','electrical','tea','motorcycle_repair','boutique','baby_goods','bag','musical_instrument','dairy','pet_grooming','music','carpet','rental','fashion_accessories','cheese','chocolate','medical_supply','leather','sewing','cannabis','locksmith','games','video_games','hifi','window_blind','caravan','tool_hire','household_linen','bathroom_furnishing','shoe_repair','watches','nutrition_supplements','fishing','erotic','frame','grocery','boat','repair','weapons','gold_buyer','lighting','pottery','security','groundskeeping','herbalist','curtain','health_food','flooring','printer_ink','anime','camera','scuba_diving','candles','printing','garden_furniture','food','estate_agent','insurance','it','accountant','employment_agency','tax_advisor','financial','advertising_agency','logistics','newspaper','financial_advisor','consulting','travel_agent','coworking','moving_company','lawyer','architect','construction_company','credit_broker','graphic_design','property_management','cleaning']::text[]))                                          AS cat_amenity,\n
                COUNT(*) FILTER (WHERE exist(tags, 'shop') AND COALESCE(tags->'shop','') NOT ILIKE '%vacant%' AND COALESCE(tags->'shop','') <> '') AS cat_shop,\n
                COUNT(*) FILTER (WHERE (tags->'tourism') = ANY(ARRAY['hotel','hostel','motel','wilderness_hut','yes','chalet','gallery','guest_house','museum','zoo','theme_park','aquarium','alpine_hut','apartment']::text[]))                                          AS cat_tourism,\n
                COUNT(*) FILTER (WHERE exist(tags, 'healthcare') AND COALESCE(tags->'healthcare','') <> '')             AS cat_healthcare,\n
                COUNT(*) FILTER (WHERE exist(tags, 'office') AND COALESCE(tags->'office','') <> '')                     AS cat_office,\n
                COUNT(*) FILTER (WHERE (tags->'information') = 'office')                                                AS cat_information_office\n
            FROM osm_object_meta\n
            WHERE (\n
                  (tags->'amenity') = ANY(ARRAY['library','townhall','restaurant','fast_food','cafe','fuel','pharmacy','bank','bar','hospital','post_office','clinic','pub','car_wash','ice_cream','driving_school','cinema','car_rental','nightclub','bureau_de_change','studio','internet_cafe','money_transfer','casino','vehicle_inspection','frozen_food','boat_rental','coworking_space','workshop','personal_service','camping','dancing_school','training','ski_school','ski_rental','dive_centre','driver_training','nursing_home','funeral_hall','doctors','dentist','theatre','kindergarten','language_school','stripclub','veterinary','convenience','supermarket','clothes','hairdresser','car_repair','bakery','beauty','car','hardware','mobile_phone','butcher','furniture','car_parts','alcohol','florist','scooter','variety_store','electronics','shoes','optician','jewelry','mall','gift','doityourself','greengrocer','books','bicycle','chemist','department_store','laundry','travel_agency','stationery','pet','sports','confectionery','tyres','cosmetics','computer','tailor','tobacco','storage_rental','dry_cleaning','trade','copyshop','motorcycle','funeral_directors','beverages','newsagent','garden_centre','massage','pastry','interior_decoration','general','deli','toys','houseware','wine','seafood','pawnbroker','tattoo','paint','wholesale','photo','second_hand','bed','kitchen','outdoor','fabric','antiques','coffee','gas','e-cigarette','perfumery','craft','hearing_aids','money_lender','appliance','electrical','tea','motorcycle_repair','boutique','baby_goods','bag','musical_instrument','dairy','pet_grooming','music','carpet','rental','fashion_accessories','cheese','chocolate','medical_supply','leather','sewing','cannabis','locksmith','games','video_games','hifi','window_blind','caravan','tool_hire','household_linen','bathroom_furnishing','shoe_repair','watches','nutrition_supplements','fishing','erotic','frame','grocery','boat','repair','weapons','gold_buyer','lighting','pottery','security','groundskeeping','herbalist','curtain','health_food','flooring','printer_ink','anime','camera','scuba_diving','candles','printing','garden_furniture','food','estate_agent','insurance','it','accountant','employment_agency','tax_advisor','financial','advertising_agency','logistics','newspaper','financial_advisor','consulting','travel_agent','coworking','moving_company','lawyer','architect','construction_company','credit_broker','graphic_design','property_management','cleaning']::text[])\n
               OR (exist(tags, 'shop') AND COALESCE(tags->'shop','') NOT ILIKE '%vacant%' AND COALESCE(tags->'shop','') <> '')\n
               OR (tags->'tourism') = ANY(ARRAY['hotel','hostel','motel','wilderness_hut','yes','chalet','gallery','guest_house','museum','zoo','theme_park','aquarium','alpine_hut','apartment']::text[])\n
               OR (exist(tags, 'healthcare') AND COALESCE(tags->'healthcare','') <> '')\n
               OR (tags->'information') = 'office'\n
               OR (exist(tags, 'office') AND COALESCE(tags->'office','') <> '')\n
            )
    """
]

[
  "sql" => "SELECT 1"
]

[
  "sql" => "SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = 'public' AND table_name = 'osm_object_meta'"
]

[
  "sql" => """
    SELECT (tags->'amenity') AS value, COUNT(*) AS count\n
                    FROM osm_object_meta\n
                    WHERE (tags->'amenity') = ANY(ARRAY['library','townhall','restaurant','fast_food','cafe','fuel','pharmacy','bank','bar','hospital','post_office','clinic','pub','car_wash','ice_cream','driving_school','cinema','car_rental','nightclub','bureau_de_change','studio','internet_cafe','money_transfer','casino','vehicle_inspection','frozen_food','boat_rental','coworking_space','workshop','personal_service','camping','dancing_school','training','ski_school','ski_rental','dive_centre','driver_training','nursing_home','funeral_hall','doctors','dentist','theatre','kindergarten','language_school','stripclub','veterinary','convenience','supermarket','clothes','hairdresser','car_repair','bakery','beauty','car','hardware','mobile_phone','butcher','furniture','car_parts','alcohol','florist','scooter','variety_store','electronics','shoes','optician','jewelry','mall','gift','doityourself','greengrocer','books','bicycle','chemist','department_store','laundry','travel_agency','stationery','pet','sports','confectionery','tyres','cosmetics','computer','tailor','tobacco','storage_rental','dry_cleaning','trade','copyshop','motorcycle','funeral_directors','beverages','newsagent','garden_centre','massage','pastry','interior_decoration','general','deli','toys','houseware','wine','seafood','pawnbroker','tattoo','paint','wholesale','photo','second_hand','bed','kitchen','outdoor','fabric','antiques','coffee','gas','e-cigarette','perfumery','craft','hearing_aids','money_lender','appliance','electrical','tea','motorcycle_repair','boutique','baby_goods','bag','musical_instrument','dairy','pet_grooming','music','carpet','rental','fashion_accessories','cheese','chocolate','medical_supply','leather','sewing','cannabis','locksmith','games','video_games','hifi','window_blind','caravan','tool_hire','household_linen','bathroom_furnishing','shoe_repair','watches','nutrition_supplements','fishing','erotic','frame','grocery','boat','repair','weapons','gold_buyer','lighting','pottery','security','groundskeeping','herbalist','curtain','health_food','flooring','printer_ink','anime','camera','scuba_diving','candles','printing','garden_furniture','food','estate_agent','insurance','it','accountant','employment_agency','tax_advisor','financial','advertising_agency','logistics','newspaper','financial_advisor','consulting','travel_agent','coworking','moving_company','lawyer','architect','construction_company','credit_broker','graphic_design','property_management','cleaning']::text[])\n
                    GROUP BY value ORDER BY count DESC LIMIT ?
    """
  "params" => [
    1 => 15
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#859
      +name: "STRING"
    }
  ]
]

[
  "sql" => """
    SELECT (tags->'shop') AS value, COUNT(*) AS count\n
                    FROM osm_object_meta\n
                    WHERE exist(tags, 'shop') AND COALESCE(tags->'shop','') NOT ILIKE '%vacant%' AND COALESCE(tags->'shop','') <> ''\n
                    GROUP BY value ORDER BY count DESC LIMIT ?
    """
  "params" => [
    1 => 15
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#859
      +name: "STRING"
    }
  ]
]

[
  "sql" => """
    SELECT (tags->'tourism') AS value, COUNT(*) AS count\n
                    FROM osm_object_meta\n
                    WHERE (tags->'tourism') = ANY(ARRAY['hotel','hostel','motel','wilderness_hut','yes','chalet','gallery','guest_house','museum','zoo','theme_park','aquarium','alpine_hut','apartment']::text[])\n
                    GROUP BY value ORDER BY count DESC LIMIT ?
    """
  "params" => [
    1 => 15
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#859
      +name: "STRING"
    }
  ]
]

[
  "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\WebpackEncoreBundle\EventListener\ResetAssetsEventListener::resetAssets"
]

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