Symfony Profiler

[
  "route" => "spinner_front_county"
  "route_parameters" => [
    "_route" => "spinner_front_county"
    "_controller" => "App\Controller\Frontend\FrontendController::countyAction"
    "countypermalink" => "Östergötland"
  ]
  "request_uri" => "https://fsd6.webbamboo.net/Flyttst%C3%A4dning-%C3%96sterg%C3%B6tland"
  "method" => "GET"
]

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

[
  "firewall_name" => "main"
  "authenticator" => "Webbamboo\SpinnersCommon\Security\SecurityAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Webbamboo\SpinnersCommon\Security\SecurityAuthenticator"
]

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

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

[
  "params" => [
    "driver" => "pdo_mysql"
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "root"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "fsd6_staging"
    "serverVersion" => "mariadb-10.3.11"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.fromurl AS fromurl_2, t0.tourl AS tourl_3, t0.timestamp AS timestamp_4 FROM general t0"
]

[
  "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\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.request"
  "listener" => "Webbamboo\SpinnersCommon\Services\RequestListener::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\IsGrantedAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::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.link AS link_3, t0.permalink AS permalink_4, t0.manualmetatitle AS manualmetatitle_5, t0.manualmetadescription AS manualmetadescription_6, t0.manualh1 AS manualh1_7, t0.manualcontentone AS manualcontentone_8, t0.manualcontenttwo AS manualcontenttwo_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.manualthumbnail AS manualthumbnail_12, t0.manualthumbnailname AS manualthumbnailname_13, t0.manualthumbnailalt AS manualthumbnailalt_14, t0.manual AS manual_15, t0.metatitle_id AS metatitle_id_16, t0.metadescription_id AS metadescription_id_17, t0.h1_id AS h1_id_18, t0.contentone_id AS contentone_id_19, t0.contenttwo_id AS contenttwo_id_20, t0.thumbnail_id AS thumbnail_id_21 FROM Counties t0"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.link AS link_3, t0.permalink AS permalink_4, t0.manualmetatitle AS manualmetatitle_5, t0.manualmetadescription AS manualmetadescription_6, t0.manualh1 AS manualh1_7, t0.manualcontentone AS manualcontentone_8, t0.manualcontenttwo AS manualcontenttwo_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.manualthumbnail AS manualthumbnail_12, t0.manualthumbnailname AS manualthumbnailname_13, t0.manualthumbnailalt AS manualthumbnailalt_14, t0.manual AS manual_15, t0.metatitle_id AS metatitle_id_16, t0.metadescription_id AS metadescription_id_17, t0.h1_id AS h1_id_18, t0.contentone_id AS contentone_id_19, t0.contenttwo_id AS contenttwo_id_20, t0.thumbnail_id AS thumbnail_id_21 FROM Counties t0 WHERE t0.permalink = ? LIMIT 1"
  "params" => [
    1 => "%C3%96sterg%C3%B6tland"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.link AS link_3, t0.permalink AS permalink_4, t0.manualmetatitle AS manualmetatitle_5, t0.manualmetadescription AS manualmetadescription_6, t0.manualh1 AS manualh1_7, t0.manualcontentone AS manualcontentone_8, t0.manualcontenttwo AS manualcontenttwo_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.manualthumbnail AS manualthumbnail_12, t0.manualthumbnailname AS manualthumbnailname_13, t0.manualthumbnailalt AS manualthumbnailalt_14, t0.manual AS manual_15, t0.metatitle_id AS metatitle_id_16, t0.metadescription_id AS metadescription_id_17, t0.h1_id AS h1_id_18, t0.contentone_id AS contentone_id_19, t0.contenttwo_id AS contenttwo_id_20, t0.thumbnail_id AS thumbnail_id_21 FROM Counties t0 WHERE t0.permalink = ? LIMIT 1"
  "params" => [
    1 => "%C3%96sterg%C3%B6tland"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.geonameid AS geonameid_1, c0_.name AS name_2, c0_.latitude AS latitude_3, c0_.longitude AS longitude_4, c0_.featureclass AS featureclass_5, c0_.featurecode AS featurecode_6, c0_.link AS link_7, c0_.permalink AS permalink_8, c0_.manualmetatitle AS manualmetatitle_9, c0_.manualmetadescription AS manualmetadescription_10, c0_.manualh1 AS manualh1_11, c0_.manualcontentone AS manualcontentone_12, c0_.manualcontenttwo AS manualcontenttwo_13, c0_.manualcontentthree AS manualcontentthree_14, c0_.manualthumbnail AS manualthumbnail_15, c0_.manualthumbnailname AS manualthumbnailname_16, c0_.manualthumbnailalt AS manualthumbnailalt_17, c0_.manual AS manual_18, c0_.population AS population_19, c0_.county_id AS county_id_20, c0_.metatitle_id AS metatitle_id_21, c0_.metadescription_id AS metadescription_id_22, c0_.h1_id AS h1_id_23, c0_.contentone_id AS contentone_id_24, c0_.contenttwo_id AS contenttwo_id_25, c0_.contentthree_id AS contentthree_id_26, c0_.thumbnail_id AS thumbnail_id_27, c0_.h2interesting_id AS h2interesting_id_28 FROM City c0_ WHERE c0_.county_id = 21 ORDER BY c0_.name ASC"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.setting AS setting_2, t0.value AS value_3 FROM Generalsettings t0 WHERE t0.setting = ? LIMIT 1"
  "params" => [
    1 => "MenuHeading"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.metatitle AS metatitle_3, t0.permalink AS permalink_4, t0.content AS content_5, t0.metadescription AS metadescription_6, t0.menuname AS menuname_7, t0.published AS published_8 FROM Page t0"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.setting AS setting_2, t0.value AS value_3 FROM Generalsettings t0 WHERE t0.setting = ? LIMIT 1"
  "params" => [
    1 => "Analytics"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.setting AS setting_2, t0.value AS value_3 FROM Generalsettings t0 WHERE t0.setting = ? LIMIT 1"
  "params" => [
    1 => "HeaderAlt"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.setting AS setting_2, t0.value AS value_3 FROM Generalsettings t0 WHERE t0.setting = ? LIMIT 1"
  "params" => [
    1 => "formData"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.setting AS setting_2, t0.value AS value_3 FROM Articlesettings t0"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.link AS link_3, t0.permalink AS permalink_4, t0.manualmetatitle AS manualmetatitle_5, t0.manualmetadescription AS manualmetadescription_6, t0.manualh1 AS manualh1_7, t0.manualcontentone AS manualcontentone_8, t0.manualcontenttwo AS manualcontenttwo_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.manualthumbnail AS manualthumbnail_12, t0.manualthumbnailname AS manualthumbnailname_13, t0.manualthumbnailalt AS manualthumbnailalt_14, t0.manual AS manual_15, t0.metatitle_id AS metatitle_id_16, t0.metadescription_id AS metadescription_id_17, t0.h1_id AS h1_id_18, t0.contentone_id AS contentone_id_19, t0.contenttwo_id AS contenttwo_id_20, t0.thumbnail_id AS thumbnail_id_21 FROM Counties t0 WHERE t0.permalink = ? LIMIT 1"
  "params" => [
    1 => "%C3%96sterg%C3%B6tland"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.geonameid AS geonameid_1, c0_.name AS name_2, c0_.latitude AS latitude_3, c0_.longitude AS longitude_4, c0_.featureclass AS featureclass_5, c0_.featurecode AS featurecode_6, c0_.link AS link_7, c0_.permalink AS permalink_8, c0_.manualmetatitle AS manualmetatitle_9, c0_.manualmetadescription AS manualmetadescription_10, c0_.manualh1 AS manualh1_11, c0_.manualcontentone AS manualcontentone_12, c0_.manualcontenttwo AS manualcontenttwo_13, c0_.manualcontentthree AS manualcontentthree_14, c0_.manualthumbnail AS manualthumbnail_15, c0_.manualthumbnailname AS manualthumbnailname_16, c0_.manualthumbnailalt AS manualthumbnailalt_17, c0_.manual AS manual_18, c0_.population AS population_19, c0_.county_id AS county_id_20, c0_.metatitle_id AS metatitle_id_21, c0_.metadescription_id AS metadescription_id_22, c0_.h1_id AS h1_id_23, c0_.contentone_id AS contentone_id_24, c0_.contenttwo_id AS contenttwo_id_25, c0_.contentthree_id AS contentthree_id_26, c0_.thumbnail_id AS thumbnail_id_27, c0_.h2interesting_id AS h2interesting_id_28 FROM City c0_ WHERE c0_.county_id = 21 ORDER BY c0_.population DESC LIMIT 10"
]

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

[
  "sql" => "SELECT t0.id AS id_1, t0.description AS description_2 FROM Metadescriptioncounty t0 WHERE t0.id = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2 FROM Metatitlecounty t0 WHERE t0.id = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => 1
  ]
]

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

[
  "sql" => "SELECT t0.id AS id_1, t0.h1 AS h1_2 FROM H1county t0 WHERE t0.id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.content AS content_2 FROM Contentpartonecounty t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.content AS content_2 FROM Contentparttwocounty t0 WHERE t0.id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.path AS path_2, t0.alt_id AS alt_id_3, t0.name_id AS name_id_4 FROM Countythumbnail t0 WHERE t0.id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => 1
  ]
]

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

[
  "sql" => "SELECT t0.id AS id_1, t0.alt AS alt_2 FROM Countythumbnailalt t0 WHERE t0.id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 1
  ]
]

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