Symfony Profiler

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "localhost"
    "port" => 3306
    "user" => "fsboinc_adminDev"
    "password" => "<redacted>"
    "driverOptions" => [
      "PDO::MYSQL_ATTR_INIT_COMMAND" => "SET NAMES utf8mb4 COLLATE utf8mb4_unicode_ci"
    ]
    "defaultTableOptions" => [
      "charset" => "utf8mb4"
      "collate" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "fsboinc_fsbo"
    "serverVersion" => "10.6.23-MariaDB"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT i0_.id AS id_0, i0_.ip_address AS ip_address_1, i0_.reason AS reason_2, i0_.created_at AS created_at_3, i0_.expires_at AS expires_at_4, i0_.is_active AS is_active_5, i0_.created_by_id AS created_by_id_6 FROM `ip_blacklist` i0_ WHERE i0_.ip_address = ? AND i0_.is_active = 1 AND ((i0_.expires_at IS NULL OR i0_.expires_at > ?))"
  "params" => [
    1 => "66.249.73.130"
    2 => "2026-07-29 07:07:18"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "route" => "app_search"
  "route_parameters" => [
    "_route" => "app_search"
    "category" => "generator-jackery-explorer"
    "_controller" => "App\Controller\SearchController::search"
  ]
  "request_uri" => "https://dev.fsbo.ca/search/generator-jackery-explorer?page=1&sort=date_new"
  "method" => "GET"
]

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

[
  "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"
]

[
  "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\UX\Turbo\Request\RequestListener::__invoke"
]

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

[
  "event" => "kernel.request"
  "listener" => "App\EventSubscriber\IpBlacklistSubscriber::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" => "App\EventSubscriber\GeoIpSubscriber::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" => "App\EventSubscriber\UserActivitySubscriber::onUserActivity"
]

[
  "event" => "kernel.request"
  "listener" => "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::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" => "ContainerToKQ9Od\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments"
]

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

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.label AS label_5, t0.sort_order AS sort_order_6, t0.listing_type_enabled AS listing_type_enabled_7, t0.parent_id AS parent_id_8, t0.form_id AS form_id_9 FROM category t0 WHERE t0.slug = ? LIMIT 1"
  "params" => [
    1 => "generator-jackery-explorer"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "parentId" => null
  "searchTerm" => ""
  "latitude" => null
  "longitude" => null
  "radius" => 50
  "provinceId" => null
  "locationType" => "city"
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.parent_id AS sclr_3 FROM category c0_ ORDER BY c0_.name ASC"
]

[
  "sql" => """
    SELECT c.id as category_id,\n
                    COUNT(DISTINCT CASE WHEN l.id IS NOT NULL AND u.id IS NOT NULL  THEN l.id ELSE NULL END) as count FROM category c LEFT JOIN listing l ON l.category_id = c.id AND l.is_active = 1 LEFT JOIN user u ON l.owner_id = u.id AND u.is_active = 1 LEFT JOIN price_type pt ON l.price_type_id = pt.id LEFT JOIN listing_type lt ON l.listing_type_id = lt.id GROUP BY c.id
    """
]

[
  [
    "category_id" => 1
    "count" => 38
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.label AS label_5, t0.sort_order AS sort_order_6, t0.listing_type_enabled AS listing_type_enabled_7, t0.parent_id AS parent_id_8, t0.form_id AS form_id_9 FROM category t0 WHERE t0.parent_id = ?"
  "params" => [
    1 => 1228
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT COUNT(l0_.id) AS sclr_0 FROM listing l0_ LEFT JOIN `user` u1_ ON l0_.owner_id = u1_.id LEFT JOIN category c2_ ON l0_.category_id = c2_.id LEFT JOIN listing_type l3_ ON l0_.listing_type_id = l3_.id WHERE l0_.is_active = 1 AND u1_.is_active = 1 AND l0_.category_id = ? ORDER BY l0_.updated_at DESC"
  "params" => [
    1 => 1228
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.slug AS slug_2, l0_.description AS description_3, l0_.price AS price_4, l0_.is_active AS is_active_5, l0_.fields AS fields_6, l0_.latitude AS latitude_7, l0_.longitude AS longitude_8, l0_.lookup AS lookup_9, l0_.is_business AS is_business_10, l0_.url AS url_11, l0_.phone_number AS phone_number_12, l0_.condition_rating AS condition_rating_13, l0_.media_url AS media_url_14, l0_.created_at AS created_at_15, l0_.updated_at AS updated_at_16, u1_.id AS id_17, u1_.email AS email_18, u1_.slug AS slug_19, u1_.roles AS roles_20, u1_.password AS password_21, u1_.forsalebyowner_user_id AS forsalebyowner_user_id_22, u1_.first_name AS first_name_23, u1_.last_name AS last_name_24, u1_.user_name AS user_name_25, u1_.phone AS phone_26, u1_.created_at AS created_at_27, u1_.google_id AS google_id_28, u1_.avatar AS avatar_29, u1_.tagline AS tagline_30, u1_.is_active AS is_active_31, u1_.confirmation_token AS confirmation_token_32, u1_.confirmation_token_expires_at AS confirmation_token_expires_at_33, u1_.promo_code AS promo_code_34, u1_.show_phone_in_brochure AS show_phone_in_brochure_35, u1_.default_search_view AS default_search_view_36, u1_.description AS description_37, u1_.website_address AS website_address_38, u1_.allow_non_verified AS allow_non_verified_39, u1_.latitude AS latitude_40, u1_.longitude AS longitude_41, u1_.address AS address_42, u1_.show_address_in_brochure AS show_address_in_brochure_43, c2_.id AS id_44, c2_.name AS name_45, c2_.slug AS slug_46, c2_.is_active AS is_active_47, c2_.label AS label_48, c2_.sort_order AS sort_order_49, c2_.listing_type_enabled AS listing_type_enabled_50, l0_.owner_id AS owner_id_51, l0_.category_id AS category_id_52, l0_.location_id AS location_id_53, l0_.listing_type_id AS listing_type_id_54, l0_.offer_type_id AS offer_type_id_55, l0_.price_type_id AS price_type_id_56, l0_.state_id AS state_id_57, l0_.status_id AS status_id_58, c2_.parent_id AS parent_id_59, c2_.form_id AS form_id_60 FROM listing l0_ LEFT JOIN `user` u1_ ON l0_.owner_id = u1_.id LEFT JOIN category c2_ ON l0_.category_id = c2_.id LEFT JOIN listing_type l3_ ON l0_.listing_type_id = l3_.id WHERE l0_.is_active = 1 AND u1_.is_active = 1 AND l0_.category_id = ? ORDER BY l0_.updated_at DESC"
  "params" => [
    1 => 1228
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.is_value AS is_value_2, COUNT(l1_.id) AS sclr_3 FROM price_type p0_ INNER JOIN listing l1_ ON p0_.id = l1_.price_type_id GROUP BY p0_.id"
]

[
  "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 t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.label AS label_5, t0.sort_order AS sort_order_6, t0.listing_type_enabled AS listing_type_enabled_7, t0.parent_id AS parent_id_8, t0.form_id AS form_id_9 FROM category t0 WHERE t0.id = ?"
  "params" => [
    1 => 1081
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.label AS label_5, t0.sort_order AS sort_order_6, t0.listing_type_enabled AS listing_type_enabled_7, t0.parent_id AS parent_id_8, t0.form_id AS form_id_9 FROM category t0 WHERE t0.id = ?"
  "params" => [
    1 => 393
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.label AS label_5, t0.sort_order AS sort_order_6, t0.listing_type_enabled AS listing_type_enabled_7, t0.parent_id AS parent_id_8, t0.form_id AS form_id_9 FROM category t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2 FROM category_form t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

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

[
  "event" => "kernel.response"
  "listener" => "App\EventSubscriber\TurboFrameCacheSubscriber::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\Security\Http\RememberMe\ResponseListener::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"
]