Symfony Profiler

[
  "route" => "listarWorkScheduleHome"
  "route_parameters" => [
    "_route" => "listarWorkScheduleHome"
    "_controller" => "App\Controller\Admin\DefaultController::listarWorkScheduleHome"
    "_format" => "json"
  ]
  "request_uri" => "https://testing.cagconcrete.com/admin/dashboard/work-schedule"
  "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" => "127.0.0.1"
    "port" => 3306
    "user" => "cag_test_user"
    "password" => "<redacted>"
    "driverOptions" => [
      1002 => "SET sql_mode=(SELECT REPLACE(@@sql_mode, "ONLY_FULL_GROUP_BY", ""))"
    ]
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "cagconcrete_test"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.user_id AS user_id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.email AS email_4, t0.phone AS phone_5, t0.password AS password_6, t0.status AS status_7, t0.estimator AS estimator_8, t0.bond AS bond_9, t0.retainage AS retainage_10, t0.chat AS chat_11, t0.final_qty_approver AS final_qty_approver_12, t0.manage_contacts AS manage_contacts_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.player_id AS player_id_16, t0.push_token AS push_token_17, t0.plataforma AS plataforma_18, t0.imagen AS imagen_19, t0.preferred_lang AS preferred_lang_20, t0.sidebar_color AS sidebar_color_21, t0.rol_id AS rol_id_22 FROM user t0 WHERE t0.user_id = ?"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => 1
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "joanna@cagconcrete.com"
]

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

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

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

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

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

[
  "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\UX\Turbo\Request\RequestListener::__invoke"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Nelmio\CorsBundle\EventListener\CorsListener::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"
]

[
  "sql" => "SELECT u0_.id AS id_0, u0_.view_permission AS view_permission_1, u0_.add_permission AS add_permission_2, u0_.edit_permission AS edit_permission_3, u0_.delete_permission AS delete_permission_4, u0_.function_id AS function_id_5, u0_.user_id AS user_id_6 FROM user_permission u0_ LEFT JOIN user u1_ ON u0_.user_id = u1_.user_id LEFT JOIN `function` f2_ ON u0_.function_id = f2_.function_id WHERE u1_.user_id = ? AND f2_.function_id = ? ORDER BY u0_.id ASC LIMIT 1"
  "params" => [
    1 => 6
    2 => 1
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "event" => "kernel.controller"
  "listener" => "App\EventSubscriber\RequireAdminPermissionSubscriber::onKernelController"
]

[
  "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" => "Container2Y86oNd\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments"
]

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

[
  "sql" => "SELECT s0_.schedule_id AS schedule_id_0, s0_.description AS description_1, s0_.location AS location_2, s0_.latitud AS latitud_3, s0_.longitud AS longitud_4, s0_.day AS day_5, s0_.hour AS hour_6, s0_.quantity AS quantity_7, s0_.notes AS notes_8, s0_.highpriority AS highpriority_9, s0_.project_id AS project_id_10, s0_.project_contact_id AS project_contact_id_11, s0_.vendor_id AS vendor_id_12, s0_.employee_id AS employee_id_13 FROM schedule s0_ LEFT JOIN project p1_ ON s0_.project_id = p1_.project_id LEFT JOIN project_contact p2_ ON s0_.project_contact_id = p2_.contact_id LEFT JOIN concrete_vendor c3_ ON s0_.vendor_id = c3_.vendor_id WHERE s0_.day >= ? AND s0_.day <= ? ORDER BY s0_.day DESC"
  "params" => [
    1 => "2026-08-17 00:00:00"
    2 => "2026-08-23 23:59:59"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT COUNT(s0_.schedule_id) AS sclr_0 FROM schedule s0_ LEFT JOIN project p1_ ON s0_.project_id = p1_.project_id LEFT JOIN project_contact p2_ ON s0_.project_contact_id = p2_.contact_id LEFT JOIN concrete_vendor c3_ ON s0_.vendor_id = c3_.vendor_id WHERE s0_.day >= ? AND s0_.day <= ?"
  "params" => [
    1 => "2026-08-17 00:00:00"
    2 => "2026-08-23 23:59:59"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.schedule_id AS schedule_id_1, s0_.employee_id AS employee_id_2 FROM schedule_employee s0_ LEFT JOIN schedule s1_ ON s0_.schedule_id = s1_.schedule_id LEFT JOIN employee e2_ ON s0_.employee_id = e2_.employee_id WHERE s1_.schedule_id = ? ORDER BY e2_.name ASC"
  "params" => [
    1 => 7598
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.project_id AS project_id_1, t0.project_number AS project_number_2, t0.project_id_number AS project_id_number_3, t0.name AS name_4, t0.description AS description_5, t0.location AS location_6, t0.owner AS owner_7, t0.subcontract AS subcontract_8, t0.federal_funding AS federal_funding_9, t0.county AS county_10, t0.resurfacing AS resurfacing_11, t0.invoice_contact AS invoice_contact_12, t0.certified_payrolls AS certified_payrolls_13, t0.start_date AS start_date_14, t0.end_date AS end_date_15, t0.due_date AS due_date_16, t0.manager AS manager_17, t0.status AS status_18, t0.po_number AS po_number_19, t0.po_cg AS po_cg_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.contract_amount AS contract_amount_23, t0.est_gross_margin_percentage AS est_gross_margin_percentage_24, t0.proposal_number AS proposal_number_25, t0.concrete_quote_price AS concrete_quote_price_26, t0.concrete_start_date AS concrete_start_date_27, t0.concrete_quote_price_escalator AS concrete_quote_price_escalator_28, t0.concrete_time_period_every_n AS concrete_time_period_every_n_29, t0.concrete_time_period_unit AS concrete_time_period_unit_30, t0.updated_at_concrete_quote_price AS updated_at_concrete_quote_price_31, t0.retainage AS retainage_32, t0.retainage_percentage AS retainage_percentage_33, t0.retainage_adjustment_percentage AS retainage_adjustment_percentage_34, t0.retainage_adjustment_completion AS retainage_adjustment_completion_35, t0.prevailing_wage AS prevailing_wage_36, t0.prevailing_rate AS prevailing_rate_37, t0.bond_exceeded AS bond_exceeded_38, t0.start_address AS start_address_39, t0.start_latitude AS start_latitude_40, t0.start_longitude AS start_longitude_41, t0.end_address AS end_address_42, t0.end_latitude AS end_latitude_43, t0.end_longitude AS end_longitude_44, t0.company_id AS company_id_45, t0.inspector_id AS inspector_id_46, t0.city_id AS city_id_47, t0.vendor_id AS vendor_id_48, t0.concrete_class_id AS concrete_class_id_49 FROM project t0 WHERE t0.project_id = ?"
  "params" => [
    1 => 500
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.schedule_id AS schedule_id_1, s0_.employee_id AS employee_id_2 FROM schedule_employee s0_ LEFT JOIN schedule s1_ ON s0_.schedule_id = s1_.schedule_id LEFT JOIN employee e2_ ON s0_.employee_id = e2_.employee_id WHERE s1_.schedule_id = ? ORDER BY e2_.name ASC"
  "params" => [
    1 => 7603
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.project_id AS project_id_1, t0.project_number AS project_number_2, t0.project_id_number AS project_id_number_3, t0.name AS name_4, t0.description AS description_5, t0.location AS location_6, t0.owner AS owner_7, t0.subcontract AS subcontract_8, t0.federal_funding AS federal_funding_9, t0.county AS county_10, t0.resurfacing AS resurfacing_11, t0.invoice_contact AS invoice_contact_12, t0.certified_payrolls AS certified_payrolls_13, t0.start_date AS start_date_14, t0.end_date AS end_date_15, t0.due_date AS due_date_16, t0.manager AS manager_17, t0.status AS status_18, t0.po_number AS po_number_19, t0.po_cg AS po_cg_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.contract_amount AS contract_amount_23, t0.est_gross_margin_percentage AS est_gross_margin_percentage_24, t0.proposal_number AS proposal_number_25, t0.concrete_quote_price AS concrete_quote_price_26, t0.concrete_start_date AS concrete_start_date_27, t0.concrete_quote_price_escalator AS concrete_quote_price_escalator_28, t0.concrete_time_period_every_n AS concrete_time_period_every_n_29, t0.concrete_time_period_unit AS concrete_time_period_unit_30, t0.updated_at_concrete_quote_price AS updated_at_concrete_quote_price_31, t0.retainage AS retainage_32, t0.retainage_percentage AS retainage_percentage_33, t0.retainage_adjustment_percentage AS retainage_adjustment_percentage_34, t0.retainage_adjustment_completion AS retainage_adjustment_completion_35, t0.prevailing_wage AS prevailing_wage_36, t0.prevailing_rate AS prevailing_rate_37, t0.bond_exceeded AS bond_exceeded_38, t0.start_address AS start_address_39, t0.start_latitude AS start_latitude_40, t0.start_longitude AS start_longitude_41, t0.end_address AS end_address_42, t0.end_latitude AS end_latitude_43, t0.end_longitude AS end_longitude_44, t0.company_id AS company_id_45, t0.inspector_id AS inspector_id_46, t0.city_id AS city_id_47, t0.vendor_id AS vendor_id_48, t0.concrete_class_id AS concrete_class_id_49 FROM project t0 WHERE t0.project_id = ?"
  "params" => [
    1 => 38
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.schedule_id AS schedule_id_1, s0_.employee_id AS employee_id_2 FROM schedule_employee s0_ LEFT JOIN schedule s1_ ON s0_.schedule_id = s1_.schedule_id LEFT JOIN employee e2_ ON s0_.employee_id = e2_.employee_id WHERE s1_.schedule_id = ? ORDER BY e2_.name ASC"
  "params" => [
    1 => 7597
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.schedule_id AS schedule_id_1, s0_.employee_id AS employee_id_2 FROM schedule_employee s0_ LEFT JOIN schedule s1_ ON s0_.schedule_id = s1_.schedule_id LEFT JOIN employee e2_ ON s0_.employee_id = e2_.employee_id WHERE s1_.schedule_id = ? ORDER BY e2_.name ASC"
  "params" => [
    1 => 7602
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.schedule_id AS schedule_id_1, s0_.employee_id AS employee_id_2 FROM schedule_employee s0_ LEFT JOIN schedule s1_ ON s0_.schedule_id = s1_.schedule_id LEFT JOIN employee e2_ ON s0_.employee_id = e2_.employee_id WHERE s1_.schedule_id = ? ORDER BY e2_.name ASC"
  "params" => [
    1 => 7596
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.schedule_id AS schedule_id_1, s0_.employee_id AS employee_id_2 FROM schedule_employee s0_ LEFT JOIN schedule s1_ ON s0_.schedule_id = s1_.schedule_id LEFT JOIN employee e2_ ON s0_.employee_id = e2_.employee_id WHERE s1_.schedule_id = ? ORDER BY e2_.name ASC"
  "params" => [
    1 => 7601
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.schedule_id AS schedule_id_1, s0_.employee_id AS employee_id_2 FROM schedule_employee s0_ LEFT JOIN schedule s1_ ON s0_.schedule_id = s1_.schedule_id LEFT JOIN employee e2_ ON s0_.employee_id = e2_.employee_id WHERE s1_.schedule_id = ? ORDER BY e2_.name ASC"
  "params" => [
    1 => 7595
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.schedule_id AS schedule_id_1, s0_.employee_id AS employee_id_2 FROM schedule_employee s0_ LEFT JOIN schedule s1_ ON s0_.schedule_id = s1_.schedule_id LEFT JOIN employee e2_ ON s0_.employee_id = e2_.employee_id WHERE s1_.schedule_id = ? ORDER BY e2_.name ASC"
  "params" => [
    1 => 7600
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.schedule_id AS schedule_id_1, s0_.employee_id AS employee_id_2 FROM schedule_employee s0_ LEFT JOIN schedule s1_ ON s0_.schedule_id = s1_.schedule_id LEFT JOIN employee e2_ ON s0_.employee_id = e2_.employee_id WHERE s1_.schedule_id = ? ORDER BY e2_.name ASC"
  "params" => [
    1 => 7594
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.schedule_id AS schedule_id_1, s0_.employee_id AS employee_id_2 FROM schedule_employee s0_ LEFT JOIN schedule s1_ ON s0_.schedule_id = s1_.schedule_id LEFT JOIN employee e2_ ON s0_.employee_id = e2_.employee_id WHERE s1_.schedule_id = ? ORDER BY e2_.name ASC"
  "params" => [
    1 => 7599
  ]
  "types" => [
    1 => 1
  ]
]

[
  "key" => "_security_main"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Csrf\SameOriginCsrfTokenManager::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Nelmio\CorsBundle\EventListener\CorsListener::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" => "Nelmio\CorsBundle\EventListener\CacheableResponseVaryListener::onResponse"
]

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