Symfony Profiler

[
  "route" => "app_jobs"
  "route_parameters" => [
    "_route" => "app_jobs"
    "_controller" => "App\Controller\JobController::index"
  ]
  "request_uri" => "https://bill.flexzob.com/jobs"
  "method" => "GET"
]

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

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\AppUserAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\AppUserAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "HWI\Bundle\OAuthBundle\Security\Http\Authenticator\OAuthAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "HWI\Bundle\OAuthBundle\Security\Http\Authenticator\OAuthAuthenticator"
]

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

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

[
  "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\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" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "charset" => "utf8mb4"
    "use_savepoints" => true
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "locumuser"
    "password" => "<redacted>"
    "driverOptions" => []
    "serverVersion" => "8.0.32"
    "defaultTableOptions" => []
    "dbname" => "test"
  ]
]

[
  "sql" => "SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0 FROM (SELECT DISTINCT b0_.id AS id_0, b0_.title AS title_1, b0_.description AS description_2, b0_.status AS status_3, b0_.country AS country_4, b0_.state AS state_5, b0_.city AS city_6, b0_.street_address AS street_address_7, b0_.expiration_date AS expiration_date_8, b0_.highlight AS highlight_9, b0_.schedule AS schedule_10, b0_.start_date AS start_date_11, b0_.year_of_experience AS year_of_experience_12, b0_.pay_rate AS pay_rate_13, b0_.work_type AS work_type_14, b0_.need AS need_15, b0_.pay_rate_hourly AS pay_rate_hourly_16, b0_.pay_rate_daily AS pay_rate_daily_17, b0_.annual_salary AS annual_salary_18, b0_.monthly_salary AS monthly_salary_19, b0_.salary_type AS salary_type_20, b0_.blocked AS blocked_21, b0_.job_id AS job_id_22, b0_.verified AS verified_23, b0_.is_mediated AS is_mediated_24, b0_.`rank` AS rank_25, b0_.created_at AS created_at_26, b0_.updated_at AS updated_at_27, b1_.id AS id_28, b1_.status AS status_29, b1_.commission_rate AS commission_rate_30, b1_.assigned_at AS assigned_at_31, b2_.id AS id_32, b2_.status AS status_33, b2_.applied_at AS applied_at_34, b2_.hired_at AS hired_at_35, b2_.document_requested_at AS document_requested_at_36, b2_.document_provided_at AS document_provided_at_37, b2_.one_file_requested_at AS one_file_requested_at_38, b2_.one_file_provided_at AS one_file_provided_at_39, b2_.contract_sent_at AS contract_sent_at_40, b2_.contract_file_name AS contract_file_name_41, b2_.contract_signed_at AS contract_signed_at_42, b2_.contract_signed_file_name AS contract_signed_file_name_43, b2_.`rank` AS rank_44, b2_.archived_at AS archived_at_45, b2_.is_archived AS is_archived_46, b2_.created_at AS created_at_47, b2_.updated_at AS updated_at_48 FROM b_job b0_ LEFT JOIN b_job_recruiter b1_ ON (b1_.job_id = b0_.id) LEFT JOIN b_application b2_ ON (b2_.job_id = b0_.id) WHERE 1 = 1 AND b0_.blocked = ? AND b0_.verified = ? AND b0_.status = ?) dctrn_result_inner ORDER BY id_0 DESC) dctrn_result LIMIT 25"
  "params" => [
    1 => 0
    2 => 1
    3 => "published"
  ]
  "types" => [
    1 => 5
    2 => 5
    3 => 2
  ]
]

[
  "sql" => "SELECT DISTINCT b0_.id AS id_0, b0_.title AS title_1, b0_.description AS description_2, b0_.status AS status_3, b0_.country AS country_4, b0_.state AS state_5, b0_.city AS city_6, b0_.street_address AS street_address_7, b0_.expiration_date AS expiration_date_8, b0_.highlight AS highlight_9, b0_.schedule AS schedule_10, b0_.start_date AS start_date_11, b0_.year_of_experience AS year_of_experience_12, b0_.pay_rate AS pay_rate_13, b0_.work_type AS work_type_14, b0_.need AS need_15, b0_.pay_rate_hourly AS pay_rate_hourly_16, b0_.pay_rate_daily AS pay_rate_daily_17, b0_.annual_salary AS annual_salary_18, b0_.monthly_salary AS monthly_salary_19, b0_.salary_type AS salary_type_20, b0_.blocked AS blocked_21, b0_.job_id AS job_id_22, b0_.verified AS verified_23, b0_.is_mediated AS is_mediated_24, b0_.`rank` AS rank_25, b0_.created_at AS created_at_26, b0_.updated_at AS updated_at_27, b0_.user_id AS user_id_28, b0_.employer_id AS employer_id_29, b0_.profession_id AS profession_id_30, b0_.speciality_id AS speciality_id_31, b0_.assigned_recruiter_id AS assigned_recruiter_id_32 FROM b_job b0_ LEFT JOIN b_job_recruiter b1_ ON (b1_.job_id = b0_.id) LEFT JOIN b_application b2_ ON (b2_.job_id = b0_.id) WHERE 1 = 1 AND b0_.blocked = ? AND b0_.verified = ? AND b0_.status = ? AND b0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY b0_.id DESC"
  "params" => [
    1 => 0
    2 => 1
    3 => "published"
    4 => b"\x1F\x0F\x00E†™e0¯Ú¹Ub2Çê"
    5 => b"\x1F\x0EÊuq4gJŽ&•\x05"y“x"
    6 => b"\x1F\x0EqôÚ;cø½fÇC\tºPT"
    7 => b"\x1F\x0Ee”Ë¿bÈ¢\e…­›#g\"
    8 => b"\x1F\x0Ede¿Àg,œ‚;£‡@úv"
    9 => b"\x1F\x0Ed]&ÈnPŽ#›\x08WžÍ“"
    10 => b"\x1F\x0E\x14c$Þiê±|—¬Iä\x12\x1E"
    11 => b"\x01—\x07ò§Ý|ò«Ák|\x05¹&£"
    12 => b"\x01û³à\x0Eçp·É\e5\x01\x12¶¸├"
    13 => b"\x01–ú²¢6r¼œt>Š2m#d"
    14 => b"\x01û·;Cıx×Ékærà>&;"
    15 => b"\x01–ؾ8xw\x11ºµù\x14o\fIl"
    16 => b"\x01–ؾ8xw\x11ºµù\x14n»\x15Ì"
    17 => b"\x01–ؾ8xw\x11ºµù\x14mæ\x15‡"
    18 => b"\x01–ؾ8wvފܦido\rÆ"
    19 => b"\x01–ؾ8wvފܦic§\x04`"
    20 => b"\x01–ؾ8wvފܦic?ÔJ"
    21 => b"\x01–ؾ8vv\x03¬gŽœ\x06ºyì"
    22 => b"\x01–ؾ8vv\x03¬gŽœ\x060Àf"
    23 => b"\x01–ؾ8jwã½_ÍȬuËý"
    24 => b"\x01–ؾ8jwã½_ÍÈ«°\x1D&"
    25 => b"\x01–ؾ8jwã½_ÍÈ«_Ò¸"
    26 => b"\x01–ؾ8i{\x1D°\x02†\x0E:Qß4"
    27 => b"\x01–ؾ8i{\x1D°\x02†\x0E9¦êî"
    28 => b"\x01–ؾ8i{\x1D°\x02†\x0E9QÊ+"
  ]
  "types" => [
    1 => 5
    2 => 5
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
    12 => 2
    13 => 2
    14 => 2
    15 => 2
    16 => 2
    17 => 2
    18 => 2
    19 => 2
    20 => 2
    21 => 2
    22 => 2
    23 => 2
    24 => 2
    25 => 2
    26 => 2
    27 => 2
    28 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3 FROM b_profession t0 ORDER BY t0.position ASC"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.profession_id AS profession_id_3 FROM b_speciality t0 ORDER BY t0.name ASC"
]

[
  "sql" => "SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT DISTINCT b0_.id AS id_0, b0_.title AS title_1, b0_.description AS description_2, b0_.status AS status_3, b0_.country AS country_4, b0_.state AS state_5, b0_.city AS city_6, b0_.street_address AS street_address_7, b0_.expiration_date AS expiration_date_8, b0_.highlight AS highlight_9, b0_.schedule AS schedule_10, b0_.start_date AS start_date_11, b0_.year_of_experience AS year_of_experience_12, b0_.pay_rate AS pay_rate_13, b0_.work_type AS work_type_14, b0_.need AS need_15, b0_.pay_rate_hourly AS pay_rate_hourly_16, b0_.pay_rate_daily AS pay_rate_daily_17, b0_.annual_salary AS annual_salary_18, b0_.monthly_salary AS monthly_salary_19, b0_.salary_type AS salary_type_20, b0_.blocked AS blocked_21, b0_.job_id AS job_id_22, b0_.verified AS verified_23, b0_.is_mediated AS is_mediated_24, b0_.`rank` AS rank_25, b0_.created_at AS created_at_26, b0_.updated_at AS updated_at_27 FROM b_job b0_ LEFT JOIN b_job_recruiter b1_ ON (b1_.job_id = b0_.id) LEFT JOIN b_application b2_ ON (b2_.job_id = b0_.id) WHERE 1 = 1 AND b0_.blocked = ? AND b0_.verified = ? AND b0_.status = ? ORDER BY b0_.id DESC) dctrn_result) dctrn_table"
  "params" => [
    1 => 0
    2 => 1
    3 => "published"
  ]
  "types" => [
    1 => 5
    2 => 5
    3 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.config_key AS config_key_2, t0.config_value AS config_value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM b_config t0"
]

[
  "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\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\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"
]