Symfony Profiler

[
  "route" => "frontend_job_offers_pl"
  "route_parameters" => [
    "_route" => "frontend_job_offers_pl"
    "_controller" => "App\Controller\Frontend\JobOffersController::jobOfferAction"
    "slug" => "programista-abap"
  ]
  "request_uri" => "https://ipopema.bloomnet.pl/oferty-pracy/programista-abap"
  "method" => "GET"
]

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

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

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

[
  "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\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.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" => "ContainerGBxUs2c\RequestPayloadValueResolverGhost3590451::onKernelControllerArguments"
]

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

[
  "params" => [
    "driver" => "pdo_mysql"
    "host" => "localhost"
    "port" => 3306
    "dbname" => "ipopema2"
    "user" => "ipopema2"
    "password" => "<redacted>"
    "charset" => "utf8mb4"
    "use_savepoints" => true
    "idle_connection_ttl" => 600
    "driverOptions" => []
    "defaultTableOptions" => []
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.place AS place_3, t0.specialization AS specialization_4, t0.main_site AS main_site_5, t0.active AS active_6, t0.slug AS slug_7, t0.meta_title AS meta_title_8, t0.meta_keywords AS meta_keywords_9, t0.meta_description AS meta_description_10, t0.other_meta_tags AS other_meta_tags_11, t0.lang AS lang_12, t0.created_at AS created_at_13, t0.updatedAt AS updatedAt_14, t0.job_position_id AS job_position_id_15 FROM job_offers t0 WHERE t0.lang = ? AND t0.active = ? AND t0.slug = ? ORDER BY t0.created_at DESC LIMIT 1"
  "params" => [
    1 => "pl"
    2 => 1
    3 => "programista-abap"
  ]
  "types" => [
    1 => 2
    2 => 5
    3 => 2
  ]
]

[
  "sql" => "SELECT count(j0_.id) AS sclr_0 FROM job_offers j0_ WHERE j0_.active = ? AND j0_.lang LIKE ? AND j0_.job_position_id = ? AND j0_.id <> ?"
  "params" => [
    1 => 1
    2 => "pl"
    3 => 2
    4 => 3
  ]
  "types" => [
    1 => 5
    2 => 2
    3 => 1
    4 => 1
  ]
]

[
  "sql" => "SELECT j0_.id AS id_0, j0_.name AS name_1, j0_.place AS place_2, j0_.specialization AS specialization_3, j0_.main_site AS main_site_4, j0_.active AS active_5, j0_.slug AS slug_6, j0_.meta_title AS meta_title_7, j0_.meta_keywords AS meta_keywords_8, j0_.meta_description AS meta_description_9, j0_.other_meta_tags AS other_meta_tags_10, j0_.lang AS lang_11, j0_.created_at AS created_at_12, j0_.updatedAt AS updatedAt_13, j0_.job_position_id AS job_position_id_14 FROM job_offers j0_ WHERE j0_.id <> ? AND j0_.active = ? AND j0_.lang LIKE ? AND j0_.job_position_id = ? ORDER BY j0_.created_at DESC LIMIT 2"
  "params" => [
    1 => 3
    2 => 1
    3 => "pl"
    4 => 2
  ]
  "types" => [
    1 => 1
    2 => 5
    3 => 2
    4 => 1
  ]
]

[
  "sql" => "SELECT t0.lang AS lang_1, t0.id AS id_2, t0.label AS label_3, t0.url AS url_4, t0.seo_title AS seo_title_5, t0.seo_description AS seo_description_6, t0.seo_keywords AS seo_keywords_7, t0.enabled AS enabled_8, t0.position AS position_9, t0.icon AS icon_10, t0.parent_id AS parent_id_11 FROM menu_item t0 WHERE t0.url = ? AND t0.lang = ? AND t0.enabled = ? LIMIT 1"
  "params" => [
    1 => "/oferty-pracy/programista-abap"
    2 => "pl"
    3 => 1
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 5
  ]
]

[
  "sql" => "SELECT m0_.lang AS lang_0, m0_.id AS id_1, m0_.label AS label_2, m0_.url AS url_3, m0_.seo_title AS seo_title_4, m0_.seo_description AS seo_description_5, m0_.seo_keywords AS seo_keywords_6, m0_.enabled AS enabled_7, m0_.position AS position_8, m0_.icon AS icon_9, m0_.parent_id AS parent_id_10 FROM menu_item m0_ WHERE m0_.lang = ? ORDER BY m0_.parent_id ASC, m0_.position ASC"
  "params" => [
    1 => "pl"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT m0_.lang AS lang_0, m0_.id AS id_1, m0_.label AS label_2, m0_.url AS url_3, m0_.seo_title AS seo_title_4, m0_.seo_description AS seo_description_5, m0_.seo_keywords AS seo_keywords_6, m0_.enabled AS enabled_7, m0_.position AS position_8, m0_.icon AS icon_9, m0_.parent_id AS parent_id_10 FROM menu_item m0_ WHERE m0_.lang = ? ORDER BY m0_.parent_id ASC, m0_.position ASC"
  "params" => [
    1 => "pl"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT m0_.lang AS lang_0, m0_.id AS id_1, m0_.label AS label_2, m0_.url AS url_3, m0_.seo_title AS seo_title_4, m0_.seo_description AS seo_description_5, m0_.seo_keywords AS seo_keywords_6, m0_.enabled AS enabled_7, m0_.position AS position_8, m0_.icon AS icon_9, m0_.parent_id AS parent_id_10 FROM menu_item m0_ WHERE m0_.lang = ? ORDER BY m0_.parent_id ASC, m0_.position ASC"
  "params" => [
    1 => "pl"
  ]
  "types" => [
    1 => 2
  ]
]

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

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

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

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

[
  "sql" => "SELECT t0.id AS id_1, t0.hash_id AS hash_id_2, t0.lang AS lang_3, t0.content AS content_4, t0.location AS location_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM editable_blocks t0 WHERE t0.hash_id = ? AND t0.lang = ? AND t0.location = ? LIMIT 1"
  "params" => [
    1 => "b33388c3ad5b"
    2 => "pl"
    3 => "/oferty-pracy/programista-abap"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.hash_id AS hash_id_2, t0.lang AS lang_3, t0.content AS content_4, t0.location AS location_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM editable_blocks t0 WHERE t0.hash_id = ? AND t0.lang = ? AND t0.location = ? LIMIT 1"
  "params" => [
    1 => "bfa708a8fb7d"
    2 => "pl"
    3 => "/oferty-pracy/programista-abap"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.hash_id AS hash_id_2, t0.lang AS lang_3, t0.content AS content_4, t0.location AS location_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM editable_blocks t0 WHERE t0.hash_id = ? AND t0.lang = ? AND t0.location = ? LIMIT 1"
  "params" => [
    1 => "8a3f1583ca10"
    2 => "pl"
    3 => "/oferty-pracy/programista-abap"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.hash_id AS hash_id_2, t0.lang AS lang_3, t0.content AS content_4, t0.location AS location_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM editable_blocks t0 WHERE t0.hash_id = ? AND t0.lang = ? AND t0.location = ? LIMIT 1"
  "params" => [
    1 => "8f9c5da98c7e"
    2 => "pl"
    3 => "/oferty-pracy/programista-abap"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.hash_id AS hash_id_2, t0.lang AS lang_3, t0.content AS content_4, t0.location AS location_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM editable_blocks t0 WHERE t0.hash_id = ? AND t0.lang = ? AND t0.location = ? LIMIT 1"
  "params" => [
    1 => "c5b3f5d1011e"
    2 => "pl"
    3 => "/oferty-pracy/programista-abap"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.hash_id AS hash_id_2, t0.lang AS lang_3, t0.content AS content_4, t0.location AS location_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM editable_blocks t0 WHERE t0.hash_id = ? AND t0.lang = ? AND t0.location = ? LIMIT 1"
  "params" => [
    1 => "9d296aaf2e78"
    2 => "pl"
    3 => "/oferty-pracy/programista-abap"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

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

[
  "event" => "kernel.response"
  "listener" => "App\EventListener\CspHeaderListener::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"
]