Symfony Profiler

[
  "route" => "business_roles"
  "route_parameters" => [
    "_route" => "business_roles"
    "_controller" => "App\Controller\EmployeeRoleController::index"
    "id" => "CRIHNO6XCH"
  ]
  "request_uri" => "https://mynine.pawelbrothers.com/business/CRIHNO6XCH/roles"
  "method" => "POST"
]

[
  "key" => "_security_main"
  "token_class" => "Symfony\Component\Security\Core\Authentication\Token\UsernamePasswordToken"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "192.168.1.143"
    "port" => 3306
    "user" => "pawelb"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "myninepawel"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.emp_number AS emp_number_3, t0.url AS url_4, t0.first_name AS first_name_5, t0.second_name AS second_name_6, t0.full_name AS full_name_7, t0.index_no AS index_no_8, t0.email AS email_9, t0.username AS username_10, t0.description AS description_11, t0.password AS password_12, t0.nationality AS nationality_13, t0.study_medium AS study_medium_14, t0.birth_date AS birth_date_15, t0.nic AS nic_16, t0.code AS code_17, t0.sex AS sex_18, t0.address AS address_19, t0.tel AS tel_20, t0.mob AS mob_21, t0.sms_number AS sms_number_22, t0.lan_number AS lan_number_23, t0.sms_usage AS sms_usage_24, t0.stream AS stream_25, t0.exam_year AS exam_year_26, t0.dark_mode AS dark_mode_27, t0.id_paid AS id_paid_28, t0.id_delivered AS id_delivered_29, t0.id_stu_delivered AS id_stu_delivered_30, t0.id_stu_delivered_on AS id_stu_delivered_on_31, t0.id_printed AS id_printed_32, t0.box_id AS box_id_33, t0.send_sms AS send_sms_34, t0.sms_limit AS sms_limit_35, t0.admission AS admission_36, t0.join_date AS join_date_37, t0.image_path AS image_path_38, t0.media_folder AS media_folder_39, t0.last_sesson AS last_sesson_40, t0.raw_password AS raw_password_41, t0.permission AS permission_42, t0.lang AS lang_43, t0.lecturers AS lecturers_44, t0.custom_field1 AS custom_field1_45, t0.deduct AS deduct_46, t0.permissions AS permissions_47, t0.sms_code AS sms_code_48, t0.roles AS roles_49, t0.sms_code_exp AS sms_code_exp_50, t0.father_name AS father_name_51, t0.father_occupation AS father_occupation_52, t0.father_present_address AS father_present_address_53, t0.father_mobile_number AS father_mobile_number_54, t0.father_email AS father_email_55, t0.mother_name AS mother_name_56, t0.mother_occupation AS mother_occupation_57, t0.mother_present_address AS mother_present_address_58, t0.mother_mobile_number AS mother_mobile_number_59, t0.mother_email AS mother_email_60, t0.guardian_kinship AS guardian_kinship_61, t0.guardian_name AS guardian_name_62, t0.guardian_occupation AS guardian_occupation_63, t0.guardian_present_address AS guardian_present_address_64, t0.guardian_mobile_number AS guardian_mobile_number_65, t0.guardian_email AS guardian_email_66, t0.university AS university_67, t0.university_year AS university_year_68, t0.work_started_on AS work_started_on_69, t0.is_active AS is_active_70, t0.passport_number AS passport_number_71, t0.epf_number AS epf_number_72, t0.employment_type AS employment_type_73, t0.resignation_date AS resignation_date_74, t0.department_id AS department_id_75, t0.branch_id AS branch_id_76, t0.designation_id AS designation_id_77 FROM mynine_users t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "EMP-0001"
]

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

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

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

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

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

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

[
  "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" => "App\EventListener\SessionSecurityListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventListener\AuthenticationRedirectListener::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" => "ContainerQqfoyYV\RequestPayloadValueResolverGhost3590451::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.business_key AS business_key_3, t0.employee_prefix AS employee_prefix_4, t0.legal_name AS legal_name_5, t0.registration_number AS registration_number_6, t0.logo AS logo_7, t0.address_line1 AS address_line1_8, t0.address_line2 AS address_line2_9, t0.city AS city_10, t0.district AS district_11, t0.postal_code AS postal_code_12, t0.country AS country_13, t0.primary_contact_name AS primary_contact_name_14, t0.primary_contact_phone AS primary_contact_phone_15, t0.primary_contact_email AS primary_contact_email_16, t0.general_phone AS general_phone_17, t0.email AS email_18, t0.website AS website_19, t0.industry AS industry_20, t0.timezone AS timezone_21, t0.currency AS currency_22, t0.status AS status_23, t0.default_working_days AS default_working_days_24, t0.default_work_start_time AS default_work_start_time_25, t0.default_work_end_time AS default_work_end_time_26, t0.payroll_frequency AS payroll_frequency_27, t0.payroll_day AS payroll_day_28, t0.epf_employer_number AS epf_employer_number_29, t0.tax_identification_number AS tax_identification_number_30, t0.sms_addon_enabled AS sms_addon_enabled_31, t0.push_notifications_enabled AS push_notifications_enabled_32, t0.sms_credits AS sms_credits_33, t0.sms_features AS sms_features_34, t0.subscription_package AS subscription_package_35, t0.employee_limit AS employee_limit_36, t0.annual_fee_per_employee AS annual_fee_per_employee_37, t0.billing_currency AS billing_currency_38, t0.free_trial_enabled AS free_trial_enabled_39, t0.trial_start_date AS trial_start_date_40, t0.trial_end_date AS trial_end_date_41, t0.next_billing_date AS next_billing_date_42, t0.created_at AS created_at_43, t0.updated_at AS updated_at_44, t0.created_by AS created_by_45 FROM mynine_business t0 WHERE t0.business_key = ? LIMIT 1"
  "params" => [
    1 => "CRIHNO6XCH"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.active AS active_4, t0.permissions AS permissions_5, t0.business_id AS business_id_6 FROM mynine_employee_role t0 WHERE t0.business_id = ? AND t0.code = ? LIMIT 1"
  "params" => [
    1 => 1
    2 => "OPSM"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.active AS active_4, t0.permissions AS permissions_5, t0.business_id AS business_id_6 FROM mynine_employee_role t0 WHERE t0.business_id = ? AND t0.name = ? LIMIT 1"
  "params" => [
    1 => 1
    2 => "Operations Manager"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "INSERT INTO mynine_employee_role (name, code, active, permissions, business_id) VALUES (?, ?, ?, ?, ?)"
  "params" => [
    1 => "Operations Manager"
    2 => "OPSM"
    3 => 1
    4 => "["business.view","employees.view","leave.view","teams.view","teams.manage","tasks.view","tasks.manage","shifts.view","shifts.manage","roster.view","roster.manage","attendance.view","attendance.manage","sms.view","sms.send","sms.retry","sms.templates.manage","sms.settings.manage","reports.view"]"
    5 => 1
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 5
    4 => 2
    5 => 1
  ]
]

[
  "key" => "_security_main"
]

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