Symfony Profiler

[
  "route" => "app_jobs"
  "route_parameters" => [
    "_route" => "app_jobs"
    "_controller" => "App\Controller\JobController::index"
  ]
  "request_uri" => "http://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" => "App\EventSubscriber\MfaSubscriber::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.request"
  "listener" => "App\EventSubscriber\SubscriptionCheckSubscriber::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_1 FROM (SELECT DISTINCT id_1 FROM (SELECT DISTINCT b0_.status_mode AS status_mode_0, b0_.id AS id_1, b0_.title AS title_2, b0_.description AS description_3, b0_.status AS status_4, b0_.country AS country_5, b0_.state AS state_6, b0_.city AS city_7, b0_.street_address AS street_address_8, b0_.expiration_date AS expiration_date_9, b0_.highlight AS highlight_10, b0_.schedule AS schedule_11, b0_.start_date AS start_date_12, b0_.year_of_experience AS year_of_experience_13, b0_.pay_rate AS pay_rate_14, b0_.work_type AS work_type_15, b0_.need AS need_16, b0_.pay_rate_hourly AS pay_rate_hourly_17, b0_.pay_rate_daily AS pay_rate_daily_18, b0_.annual_salary AS annual_salary_19, b0_.monthly_salary AS monthly_salary_20, b0_.salary_type AS salary_type_21, b0_.blocked AS blocked_22, b0_.job_id AS job_id_23, b0_.verified AS verified_24, b0_.is_mediated AS is_mediated_25, b0_.`rank` AS rank_26, b0_.archived_at AS archived_at_27, b0_.is_archived AS is_archived_28, b0_.agency_payout_status AS agency_payout_status_29, b0_.agency_payout_amount AS agency_payout_amount_30, b0_.agency_payout_date AS agency_payout_date_31, b0_.agency_payout_reference AS agency_payout_reference_32, b0_.created_at AS created_at_33, b0_.updated_at AS updated_at_34, b1_.id AS id_35, b1_.status AS status_36, b1_.commission_rate AS commission_rate_37, b1_.assigned_at AS assigned_at_38, b1_.payout_status AS payout_status_39, b1_.payout_amount AS payout_amount_40, b1_.payout_date AS payout_date_41, b1_.payout_reference AS payout_reference_42, b2_.employer_status AS employer_status_43, b2_.recruiter_status AS recruiter_status_44, b2_.staffing_agency_status AS staffing_agency_status_45, b2_.id AS id_46, b2_.status AS status_47, b2_.applied_at AS applied_at_48, b2_.hired_at AS hired_at_49, b2_.document_requested_at AS document_requested_at_50, b2_.document_provided_at AS document_provided_at_51, b2_.one_file_requested_at AS one_file_requested_at_52, b2_.one_file_provided_at AS one_file_provided_at_53, b2_.contract_sent_at AS contract_sent_at_54, b2_.contract_file_name AS contract_file_name_55, b2_.contract_url AS contract_url_56, b2_.contract_signed_at AS contract_signed_at_57, b2_.contract_signed_file_name AS contract_signed_file_name_58, b2_.`rank` AS rank_59, b2_.archived_at AS archived_at_60, b2_.is_rewards_awarded AS is_rewards_awarded_61, b2_.is_archived AS is_archived_62, b2_.created_at AS created_at_63, b2_.updated_at AS updated_at_64 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 b0_.archived_at IS NULL AND b0_.blocked = ? AND b0_.verified = ? AND b0_.status = ? AND ((b0_.is_mediated = 0 OR (b0_.is_mediated = 1 AND (b0_.id IN (NULL) OR b0_.assigned_recruiter_id IS NOT NULL OR EXISTS (SELECT 1 AS sclr_65 FROM b_job_recruiter b3_ WHERE b3_.job_id = b0_.id AND b3_.status IN (?, ?, ?, ?)) OR EXISTS (SELECT 2 AS sclr_66 FROM b_application b4_ WHERE b4_.job_id = b0_.id AND b4_.recruiter_id IS NOT NULL AND b4_.status IN (?, ?, ?))))))) dctrn_result_inner ORDER BY id_1 DESC) dctrn_result LIMIT 25"
  "params" => [
    1 => 0
    2 => 1
    3 => "published"
    4 => "Accepted"
    5 => "Completed"
    6 => "accepted"
    7 => "completed"
    8 => "accepted"
    9 => "completed"
    10 => "hired"
  ]
  "types" => [
    1 => 5
    2 => 5
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
  ]
]

[
  "sql" => "SELECT DISTINCT b0_.status_mode AS status_mode_0, b0_.id AS id_1, b0_.title AS title_2, b0_.description AS description_3, b0_.status AS status_4, b0_.country AS country_5, b0_.state AS state_6, b0_.city AS city_7, b0_.street_address AS street_address_8, b0_.expiration_date AS expiration_date_9, b0_.highlight AS highlight_10, b0_.schedule AS schedule_11, b0_.start_date AS start_date_12, b0_.year_of_experience AS year_of_experience_13, b0_.pay_rate AS pay_rate_14, b0_.work_type AS work_type_15, b0_.need AS need_16, b0_.pay_rate_hourly AS pay_rate_hourly_17, b0_.pay_rate_daily AS pay_rate_daily_18, b0_.annual_salary AS annual_salary_19, b0_.monthly_salary AS monthly_salary_20, b0_.salary_type AS salary_type_21, b0_.blocked AS blocked_22, b0_.job_id AS job_id_23, b0_.verified AS verified_24, b0_.is_mediated AS is_mediated_25, b0_.`rank` AS rank_26, b0_.archived_at AS archived_at_27, b0_.is_archived AS is_archived_28, b0_.agency_payout_status AS agency_payout_status_29, b0_.agency_payout_amount AS agency_payout_amount_30, b0_.agency_payout_date AS agency_payout_date_31, b0_.agency_payout_reference AS agency_payout_reference_32, b0_.created_at AS created_at_33, b0_.updated_at AS updated_at_34, b0_.user_id AS user_id_35, b0_.employer_id AS employer_id_36, b0_.staffing_agency_id AS staffing_agency_id_37, b0_.profession_id AS profession_id_38, b0_.speciality_id AS speciality_id_39, b0_.assigned_recruiter_id AS assigned_recruiter_id_40 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 b0_.archived_at IS NULL AND b0_.blocked = ? AND b0_.verified = ? AND b0_.status = ? AND ((b0_.is_mediated = 0 OR (b0_.is_mediated = 1 AND (b0_.id IN (NULL) OR b0_.assigned_recruiter_id IS NOT NULL OR EXISTS (SELECT 1 AS sclr_41 FROM b_job_recruiter b3_ WHERE b3_.job_id = b0_.id AND b3_.status IN (?, ?, ?, ?)) OR EXISTS (SELECT 2 AS sclr_42 FROM b_application b4_ WHERE b4_.job_id = b0_.id AND b4_.recruiter_id IS NOT NULL AND b4_.status IN (?, ?, ?)))))) AND b0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY b0_.id DESC"
  "params" => [
    1 => 0
    2 => 1
    3 => "published"
    4 => "Accepted"
    5 => "Completed"
    6 => "accepted"
    7 => "completed"
    8 => "accepted"
    9 => "completed"
    10 => "hired"
    11 => b"\x1F\x13z¸K<nd™m\x037ék™\x11"
    12 => b"\x1F\x13;U™§ad¦ÞýZ˜õ1\t"
    13 => b"""
      \x1F\x13\x15韞dF½a…\x18\n
      }ï°
      """
    14 => b"\x1F\x13\x08ïNndö•+]¡å\x1A\x00‹"
    15 => b"\x1F\x13\x02 Õûdæª@wóB² O"
    16 => b"\x1F\x12°Ð,é`\x14…ïgÐÈÙl'"
    17 => b"\x1F\x12░ù¨éi÷ª)Ø\x13½éx╣"
    18 => b"\x1F\x12«]¶çcö©×\x7F<™2r¹"
    19 => b"\x1F\x12_¹Ø1cjÅ╝}¾¥âÓ‗"
    20 => b"\x1F\x12L\x070fbØ“\x00\x03’K°4È"
    21 => b"\x1F\x12\x18Ðdøbê²]\x07XIþµi"
    22 => b"\x1F\x11îú’\x02e’ª°=• F¤Ó"
    23 => b"\x1F\x11íü–Þnz¶F+Í:Õ_ø"
    24 => b"\x1F\x11Þ‰D\x19m>†š\x11~žÎ²l"
    25 => b"\x1F\x11¡\x16~Çj\x12ü¾ß«óÙ┼\x05"
    26 => b"\x1F\x11^\x0F:ýj\‰2ÅÏâÄ€8"
  ]
  "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
  ]
]

[
  "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_1 FROM (SELECT DISTINCT b0_.status_mode AS status_mode_0, b0_.id AS id_1, b0_.title AS title_2, b0_.description AS description_3, b0_.status AS status_4, b0_.country AS country_5, b0_.state AS state_6, b0_.city AS city_7, b0_.street_address AS street_address_8, b0_.expiration_date AS expiration_date_9, b0_.highlight AS highlight_10, b0_.schedule AS schedule_11, b0_.start_date AS start_date_12, b0_.year_of_experience AS year_of_experience_13, b0_.pay_rate AS pay_rate_14, b0_.work_type AS work_type_15, b0_.need AS need_16, b0_.pay_rate_hourly AS pay_rate_hourly_17, b0_.pay_rate_daily AS pay_rate_daily_18, b0_.annual_salary AS annual_salary_19, b0_.monthly_salary AS monthly_salary_20, b0_.salary_type AS salary_type_21, b0_.blocked AS blocked_22, b0_.job_id AS job_id_23, b0_.verified AS verified_24, b0_.is_mediated AS is_mediated_25, b0_.`rank` AS rank_26, b0_.archived_at AS archived_at_27, b0_.is_archived AS is_archived_28, b0_.agency_payout_status AS agency_payout_status_29, b0_.agency_payout_amount AS agency_payout_amount_30, b0_.agency_payout_date AS agency_payout_date_31, b0_.agency_payout_reference AS agency_payout_reference_32, b0_.created_at AS created_at_33, b0_.updated_at AS updated_at_34 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 b0_.archived_at IS NULL AND b0_.blocked = ? AND b0_.verified = ? AND b0_.status = ? AND ((b0_.is_mediated = 0 OR (b0_.is_mediated = 1 AND (b0_.id IN (NULL) OR b0_.assigned_recruiter_id IS NOT NULL OR EXISTS (SELECT 1 AS sclr_35 FROM b_job_recruiter b3_ WHERE b3_.job_id = b0_.id AND b3_.status IN (?, ?, ?, ?)) OR EXISTS (SELECT 2 AS sclr_36 FROM b_application b4_ WHERE b4_.job_id = b0_.id AND b4_.recruiter_id IS NOT NULL AND b4_.status IN (?, ?, ?)))))) ORDER BY b0_.id DESC) dctrn_result) dctrn_table"
  "params" => [
    1 => 0
    2 => 1
    3 => "published"
    4 => "Accepted"
    5 => "Completed"
    6 => "accepted"
    7 => "completed"
    8 => "accepted"
    9 => "completed"
    10 => "hired"
  ]
  "types" => [
    1 => 5
    2 => 5
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 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"
]