Symfony Profiler

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "varsity"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "varsity"
    "serverversion" => "mariadb-10.11.7charset=utf8mb4"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT s0_.identifier AS identifier_0, s0_.type AS type_1, s0_.label AS label_2, s0_.value AS value_3, s0_.id AS id_4, s0_.uuid AS uuid_5, s0_.created AS created_6, s0_.modified AS modified_7 FROM system_config s0_"
]

[
  "route" => "frontend_search_bycountry_byservice"
  "route_parameters" => [
    "_route" => "frontend_search_bycountry_byservice"
    "country_slug" => "kiribati"
    "service_slug" => "locksmiths"
    "_controller" => "App\Controller\Frontend\Search\SearchController::search"
  ]
  "request_uri" => "https://varsity.cwd-dev.com/search/kiribati/locksmiths"
  "method" => "GET"
]

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

[
  "firewall_name" => "frontend"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\FormLoginAuthenticator"
]

[
  "firewall_name" => "frontend"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\FormLoginAuthenticator"
]

[
  "firewall_name" => "frontend"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\HttpBasicAuthenticator"
]

[
  "firewall_name" => "frontend"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\HttpBasicAuthenticator"
]

[
  "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" => "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" => "Container0GFx49W\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments"
]

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

[
  "sql" => "SELECT s0_.name AS name_0, s0_.slug AS slug_1, s0_.description AS description_2, s0_.import_matches AS import_matches_3, s0_.id AS id_4, s0_.uuid AS uuid_5, s0_.created AS created_6, s0_.modified AS modified_7 FROM services_service s0_ ORDER BY s0_.name ASC"
]

[
  "sql" => "SELECT s0_.name AS name_0, s0_.slug AS slug_1, s0_.description AS description_2, s0_.import_matches AS import_matches_3, s0_.id AS id_4, s0_.uuid AS uuid_5, s0_.created AS created_6, s0_.modified AS modified_7 FROM services_service s0_ WHERE s0_.slug = ? LIMIT 1"
  "params" => [
    1 => "locksmiths"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "event" => "knp_pager.before"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\SortableSubscriber::before"
]

[
  "event" => "knp_pager.before"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Filtration\FiltrationSubscriber::before"
]

[
  "event" => "knp_pager.before"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\PaginationSubscriber::before"
]

[
  "sql" => "SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_21 FROM (SELECT l0_.reference AS reference_0, l0_.legacy_reference AS legacy_reference_1, l0_.is_published AS is_published_2, l0_.is_pending AS is_pending_3, l0_.title AS title_4, l0_.summary AS summary_5, l0_.address1 AS address1_6, l0_.address2 AS address2_7, l0_.city AS city_8, l0_.region AS region_9, l0_.postcode AS postcode_10, l0_.country AS country_11, l0_.website AS website_12, l0_.contact_name AS contact_name_13, l0_.primary_number AS primary_number_14, l0_.secondary_number AS secondary_number_15, l0_.tertiary_number AS tertiary_number_16, l0_.email AS email_17, l0_.latitude AS latitude_18, l0_.longitude AS longitude_19, l0_.legacy_listing AS legacy_listing_20, l0_.id AS id_21, l0_.uuid AS uuid_22, l0_.created AS created_23, l0_.modified AS modified_24 FROM listings_listing l0_ LEFT JOIN listing_service l2_ ON l0_.id = l2_.listing_id LEFT JOIN services_service s1_ ON s1_.id = l2_.service_id WHERE l0_.is_published = ? AND l0_.country = ? AND s1_.id = ? ORDER BY l0_.created DESC) dctrn_result) dctrn_table"
  "params" => [
    1 => 1
    2 => "KI"
    3 => 4
  ]
  "types" => [
    1 => 5
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT DISTINCT id_21 FROM (SELECT DISTINCT id_21, created_23 FROM (SELECT l0_.reference AS reference_0, l0_.legacy_reference AS legacy_reference_1, l0_.is_published AS is_published_2, l0_.is_pending AS is_pending_3, l0_.title AS title_4, l0_.summary AS summary_5, l0_.address1 AS address1_6, l0_.address2 AS address2_7, l0_.city AS city_8, l0_.region AS region_9, l0_.postcode AS postcode_10, l0_.country AS country_11, l0_.website AS website_12, l0_.contact_name AS contact_name_13, l0_.primary_number AS primary_number_14, l0_.secondary_number AS secondary_number_15, l0_.tertiary_number AS tertiary_number_16, l0_.email AS email_17, l0_.latitude AS latitude_18, l0_.longitude AS longitude_19, l0_.legacy_listing AS legacy_listing_20, l0_.id AS id_21, l0_.uuid AS uuid_22, l0_.created AS created_23, l0_.modified AS modified_24, s1_.name AS name_25, s1_.slug AS slug_26, s1_.description AS description_27, s1_.import_matches AS import_matches_28, s1_.id AS id_29, s1_.uuid AS uuid_30, s1_.created AS created_31, s1_.modified AS modified_32 FROM listings_listing l0_ LEFT JOIN listing_service l2_ ON l0_.id = l2_.listing_id LEFT JOIN services_service s1_ ON s1_.id = l2_.service_id WHERE l0_.is_published = ? AND l0_.country = ? AND s1_.id = ?) dctrn_result_inner ORDER BY created_23 DESC) dctrn_result LIMIT 50"
  "params" => [
    1 => 1
    2 => "KI"
    3 => 4
  ]
  "types" => [
    1 => 5
    2 => 2
    3 => 1
  ]
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QueryBuilderSubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ODM\MongoDB\QueryBuilderSubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ODM\PHPCR\QueryBuilderSubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\DBALQueryBuilderSubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\Doctrine\ORM\QuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\Doctrine\ODM\MongoDB\QuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\ElasticaQuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\PropelQuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\SolariumQuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\ArraySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Filtration\Doctrine\ORM\QuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Filtration\PropelQuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Callback\CallbackSubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ODM\MongoDB\QuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ODM\PHPCR\QuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\CollectionSubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\PropelQuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\SolariumQuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\ElasticaQuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\ArraySubscriber::items"
]

[
  "event" => "knp_pager.pagination"
  "listener" => "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::pagination"
]

[
  "event" => "knp_pager.pagination"
  "listener" => "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::pagination"
]

[
  "event" => "knp_pager.pagination"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\PaginationSubscriber::pagination"
]

[
  "sql" => "SELECT l0_.start_date AS start_date_0, l0_.end_date AS end_date_1, l0_.type AS type_2, l0_.duration AS duration_3, l0_.country AS country_4, l0_.id AS id_5, l0_.uuid AS uuid_6, l0_.created AS created_7, l0_.modified AS modified_8, l0_.listing_id AS listing_id_9, l0_.service_id AS service_id_10 FROM listings_upgrade l0_ WHERE l0_.type = ? AND l0_.country = ? AND l0_.service_id = ? AND l0_.start_date <= ? AND l0_.end_date >= ?"
  "params" => [
    1 => "premium"
    2 => "KI"
    3 => 4
    4 => "2025-12-27 12:33:57"
    5 => "2025-12-27 12:33:57"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
    4 => 2
    5 => 2
  ]
]

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

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

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::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"
]