Symfony Profiler

[
  "route" => "cargarDatosDataTrackingApp"
  "route_parameters" => [
    "_route" => "cargarDatosDataTrackingApp"
    "_controller" => "App\Controller\App\DataTrackingController::cargarDatos"
    "_format" => "json"
    "lang" => "en"
  ]
  "request_uri" => "https://testing.cagconcrete.com/api/en/data-tracking/cargarDatos?date=2026-09-18&project_id=70"
  "method" => "GET"
]

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

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

[
  "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.id AS id_1, t0.token AS token_2, t0.expires_at AS expires_at_3, t0.user_id AS user_id_4 FROM user_access_token t0 WHERE t0.token = ? LIMIT 1"
  "params" => [
    1 => "eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c2VyX2lkIjoxLCJlbWFpbCI6InVzZXIxQHRlc3RpbmcubG9jYWwiLCJpYXQiOjE3ODk3NjgwODUsImV4cCI6MTc5MDM3Mjg4NX0.79_ZEnnCzKaIo9hmAN-F1VNhwcvn21s-H9CI14OgMHY"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "event" => "Symfony\Component\Security\Http\Event\CheckPassportEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\UserProviderListener::checkPassport"
]

[
  "event" => "Symfony\Component\Security\Http\Event\CheckPassportEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\UserProviderListener::checkPassport"
]

[
  "event" => "Symfony\Component\Security\Http\Event\CheckPassportEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\CsrfProtectionListener::checkPassport"
]

[
  "event" => "Symfony\Component\Security\Http\Event\CheckPassportEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\UserCheckerListener::preCheckCredentials"
]

[
  "event" => "Symfony\Component\Security\Http\Event\CheckPassportEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\CheckCredentialsListener::checkPassport"
]

[
  "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.sms_opt_in AS sms_opt_in_13, t0.manage_contacts AS manage_contacts_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.player_id AS player_id_17, t0.push_token AS push_token_18, t0.plataforma AS plataforma_19, t0.imagen AS imagen_20, t0.preferred_lang AS preferred_lang_21, t0.sidebar_color AS sidebar_color_22, t0.rol_id AS rol_id_23, t0.employee_id AS employee_id_24 FROM user t0 WHERE t0.user_id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "event" => "security.authentication.success"
  "listener" => "Symfony\Component\Security\Http\EventListener\UserCheckerListener::postCheckCredentials"
]

[
  "token" => Symfony\Component\Security\Http\Authenticator\Token\PostAuthenticationToken {#190
    -user: Proxies\__CG__\App\Entity\Usuario {#135 …}
    -roleNames: [
      "ROLE_ADMIN"
    ]
    -attributes: []
    -firewallName: "api"
  }
  "authenticator" => "App\Security\TokenAuthenticator"
]

[
  "event" => "Symfony\Component\Security\Http\Event\LoginSuccessEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\PasswordMigratingListener::onLoginSuccess"
]

[
  "authenticator" => "App\Security\TokenAuthenticator"
]

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

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

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

[
  "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 => 1
    2 => 10
  ]
  "types" => [
    1 => 1
    2 => 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.certified_payroll_we_are AS certified_payroll_we_are_45, t0.wage_determination_no AS wage_determination_no_46, t0.contractor_business_name AS contractor_business_name_47, t0.contractor_business_address AS contractor_business_address_48, t0.signatory_name AS signatory_name_49, t0.signatory_title AS signatory_title_50, t0.signatory_phone AS signatory_phone_51, t0.signatory_email AS signatory_email_52, t0.company_id AS company_id_53, t0.inspector_id AS inspector_id_54, t0.city_id AS city_id_55, t0.vendor_id AS vendor_id_56, t0.concrete_class_id AS concrete_class_id_57 FROM project t0 WHERE t0.project_id = ?"
  "params" => [
    1 => 70
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT d0_.id AS id_0, d0_.date AS date_1, d0_.station_number AS station_number_2, d0_.measured_by AS measured_by_3, d0_.crew_lead AS crew_lead_4, d0_.notes AS notes_5, d0_.other_materials AS other_materials_6, d0_.conc_vendor AS conc_vendor_7, d0_.total_conc_used AS total_conc_used_8, d0_.conc_price AS conc_price_9, d0_.total_stamps AS total_stamps_10, d0_.total_people AS total_people_11, d0_.overhead_price AS overhead_price_12, d0_.color_used AS color_used_13, d0_.color_price AS color_price_14, d0_.pending AS pending_15, d0_.prepwork AS prepwork_16, d0_.latitude AS latitude_17, d0_.longitude AS longitude_18, d0_.created_at AS created_at_19, d0_.updated_at AS updated_at_20, d0_.project_id AS project_id_21, d0_.inspector_id AS inspector_id_22, d0_.overhead_price_id AS overhead_price_id_23 FROM data_tracking d0_ INNER JOIN project p1_ ON d0_.project_id = p1_.project_id WHERE p1_.project_id = ? AND d0_.date = ? ORDER BY d0_.id DESC LIMIT 1"
  "params" => [
    1 => 70
    2 => "2026-09-18"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "SELECT t0.company_id AS company_id_1, t0.name AS name_2, t0.phone AS phone_3, t0.address AS address_4, t0.contact_name AS contact_name_5, t0.contact_email AS contact_email_6, t0.email AS email_7, t0.website AS website_8, t0.originated_from_estimates AS originated_from_estimates_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM company t0 WHERE t0.company_id = ?"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT d0_.id AS id_0, d0_.hours AS hours_1, d0_.hourly_rate AS hourly_rate_2, d0_.role AS role_3, d0_.color AS color_4, d0_.employee_id AS employee_id_5, d0_.subcontractor_employee_id AS subcontractor_employee_id_6, d0_.data_tracking_id AS data_tracking_id_7, d0_.lead_labor_id AS lead_labor_id_8 FROM data_tracking_labor d0_ LEFT JOIN data_tracking d1_ ON d0_.data_tracking_id = d1_.id WHERE d1_.id = ? ORDER BY d0_.id ASC"
  "params" => [
    1 => 4482
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.employee_id AS employee_id_1, t0.name AS name_2, t0.nickname AS nickname_3, t0.hourly_rate AS hourly_rate_4, t0.position AS position_5, t0.color AS color_6, t0.address AS address_7, t0.phone AS phone_8, t0.cert_rate_type AS cert_rate_type_9, t0.social_security_number AS social_security_number_10, t0.apprentice_percentage AS apprentice_percentage_11, t0.work_code AS work_code_12, t0.gender AS gender_13, t0.date_hired AS date_hired_14, t0.date_terminated AS date_terminated_15, t0.reason_terminated AS reason_terminated_16, t0.time_card_notes AS time_card_notes_17, t0.regular_rate_per_hour AS regular_rate_per_hour_18, t0.overtime_rate_per_hour AS overtime_rate_per_hour_19, t0.special_rate_per_hour AS special_rate_per_hour_20, t0.trade_licenses_info AS trade_licenses_info_21, t0.notes AS notes_22, t0.is_osha_10_certified AS is_osha_10_certified_23, t0.is_veteran AS is_veteran_24, t0.status AS status_25, t0.federal_filing_status AS federal_filing_status_26, t0.federal_allowances AS federal_allowances_27, t0.federal_additional_withholding AS federal_additional_withholding_28, t0.w4_2020_or_later AS w4_2020_or_later_29, t0.w4_multiple_jobs_step2 AS w4_multiple_jobs_step2_30, t0.w4_dependents_amount AS w4_dependents_amount_31, t0.w4_other_income_less_deductions AS w4_other_income_less_deductions_32, t0.nonresident_alien AS nonresident_alien_33, t0.do_not_withhold_fit AS do_not_withhold_fit_34, t0.do_not_withhold_fica AS do_not_withhold_fica_35, t0.role_id AS role_id_36, t0.race_id AS race_id_37 FROM employee t0 WHERE t0.employee_id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.file AS file_2, d0_.note AS note_3, d0_.latitude AS latitude_4, d0_.longitude AS longitude_5, d0_.taken_at AS taken_at_6, d0_.created_at AS created_at_7, d0_.data_tracking_id AS data_tracking_id_8, d0_.data_tracking_item_id AS data_tracking_item_id_9, d0_.data_tracking_conc_vendor_id AS data_tracking_conc_vendor_id_10 FROM data_tracking_attachment d0_ LEFT JOIN data_tracking d1_ ON d0_.data_tracking_id = d1_.id WHERE d1_.id = ? ORDER BY d0_.name ASC"
  "params" => [
    1 => 4482
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT d0_.id AS id_0, d0_.quantity AS quantity_1, d0_.punch_quantity AS punch_quantity_2, d0_.is_partial AS is_partial_3, d0_.price AS price_4, d0_.notes AS notes_5, d0_.project_item_id AS project_item_id_6, d0_.data_tracking_id AS data_tracking_id_7 FROM data_tracking_item d0_ LEFT JOIN data_tracking d1_ ON d0_.data_tracking_id = d1_.id WHERE d1_.id = ? ORDER BY d0_.id ASC"
  "params" => [
    1 => 4482
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.quantity_old AS quantity_old_3, t0.price AS price_4, t0.price_old AS price_old_5, t0.yield_calculation AS yield_calculation_6, t0.principal AS principal_7, t0.change_order AS change_order_8, t0.item_type AS item_type_9, t0.change_order_date AS change_order_date_10, t0.internal_note AS internal_note_11, t0.note_updated_at AS note_updated_at_12, t0.apply_retainage AS apply_retainage_13, t0.bonded AS bonded_14, t0.code AS code_15, t0.contract_name AS contract_name_16, t0.note_updated_by AS note_updated_by_17, t0.project_id AS project_id_18, t0.item_id AS item_id_19, t0.equation_id AS equation_id_20 FROM project_item t0 WHERE t0.id = ?"
  "params" => [
    1 => 521
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.item_id AS item_id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.status AS status_5, t0.bond AS bond_6, t0.yield_calculation AS yield_calculation_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.txn_id AS txn_id_10, t0.edit_sequence AS edit_sequence_11, t0.unit_id AS unit_id_12, t0.equation_id AS equation_id_13 FROM item t0 WHERE t0.item_id = ?"
  "params" => [
    1 => 106
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.quantity_old AS quantity_old_3, t0.price AS price_4, t0.price_old AS price_old_5, t0.yield_calculation AS yield_calculation_6, t0.principal AS principal_7, t0.change_order AS change_order_8, t0.item_type AS item_type_9, t0.change_order_date AS change_order_date_10, t0.internal_note AS internal_note_11, t0.note_updated_at AS note_updated_at_12, t0.apply_retainage AS apply_retainage_13, t0.bonded AS bonded_14, t0.code AS code_15, t0.contract_name AS contract_name_16, t0.note_updated_by AS note_updated_by_17, t0.project_id AS project_id_18, t0.item_id AS item_id_19, t0.equation_id AS equation_id_20 FROM project_item t0 WHERE t0.id = ?"
  "params" => [
    1 => 523
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.item_id AS item_id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.status AS status_5, t0.bond AS bond_6, t0.yield_calculation AS yield_calculation_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.txn_id AS txn_id_10, t0.edit_sequence AS edit_sequence_11, t0.unit_id AS unit_id_12, t0.equation_id AS equation_id_13 FROM item t0 WHERE t0.item_id = ?"
  "params" => [
    1 => 41
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.quantity_old AS quantity_old_3, t0.price AS price_4, t0.price_old AS price_old_5, t0.yield_calculation AS yield_calculation_6, t0.principal AS principal_7, t0.change_order AS change_order_8, t0.item_type AS item_type_9, t0.change_order_date AS change_order_date_10, t0.internal_note AS internal_note_11, t0.note_updated_at AS note_updated_at_12, t0.apply_retainage AS apply_retainage_13, t0.bonded AS bonded_14, t0.code AS code_15, t0.contract_name AS contract_name_16, t0.note_updated_by AS note_updated_by_17, t0.project_id AS project_id_18, t0.item_id AS item_id_19, t0.equation_id AS equation_id_20 FROM project_item t0 WHERE t0.id = ?"
  "params" => [
    1 => 2204
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.item_id AS item_id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.status AS status_5, t0.bond AS bond_6, t0.yield_calculation AS yield_calculation_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.txn_id AS txn_id_10, t0.edit_sequence AS edit_sequence_11, t0.unit_id AS unit_id_12, t0.equation_id AS equation_id_13 FROM item t0 WHERE t0.item_id = ?"
  "params" => [
    1 => 101
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.quantity_old AS quantity_old_3, t0.price AS price_4, t0.price_old AS price_old_5, t0.yield_calculation AS yield_calculation_6, t0.principal AS principal_7, t0.change_order AS change_order_8, t0.item_type AS item_type_9, t0.change_order_date AS change_order_date_10, t0.internal_note AS internal_note_11, t0.note_updated_at AS note_updated_at_12, t0.apply_retainage AS apply_retainage_13, t0.bonded AS bonded_14, t0.code AS code_15, t0.contract_name AS contract_name_16, t0.note_updated_by AS note_updated_by_17, t0.project_id AS project_id_18, t0.item_id AS item_id_19, t0.equation_id AS equation_id_20 FROM project_item t0 WHERE t0.id = ?"
  "params" => [
    1 => 522
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.item_id AS item_id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.status AS status_5, t0.bond AS bond_6, t0.yield_calculation AS yield_calculation_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.txn_id AS txn_id_10, t0.edit_sequence AS edit_sequence_11, t0.unit_id AS unit_id_12, t0.equation_id AS equation_id_13 FROM item t0 WHERE t0.item_id = ?"
  "params" => [
    1 => 40
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT d0_.id AS id_0, d0_.conc_vendor AS conc_vendor_1, d0_.total_conc_used AS total_conc_used_2, d0_.conc_price AS conc_price_3, d0_.data_tracking_id AS data_tracking_id_4, d0_.vendor_id AS vendor_id_5, d0_.city_id AS city_id_6 FROM data_tracking_conc_vendor d0_ LEFT JOIN data_tracking d1_ ON d0_.data_tracking_id = d1_.id WHERE d1_.id = ? ORDER BY d0_.id ASC"
  "params" => [
    1 => 4482
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.vendor_id AS vendor_id_1, t0.name AS name_2, t0.phone AS phone_3, t0.address AS address_4, t0.contact_name AS contact_name_5, t0.contact_email AS contact_email_6 FROM concrete_vendor t0 WHERE t0.vendor_id = ?"
  "params" => [
    1 => 32
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.vendor_id AS vendor_id_1, t0.name AS name_2, t0.phone AS phone_3, t0.address AS address_4, t0.contact_name AS contact_name_5, t0.contact_email AS contact_email_6 FROM concrete_vendor t0 WHERE t0.vendor_id = ?"
  "params" => [
    1 => 25
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT e0_.employee_id AS employee_id_0, e0_.name AS name_1, e0_.nickname AS nickname_2, e0_.hourly_rate AS hourly_rate_3, e0_.position AS position_4, e0_.color AS color_5, e0_.address AS address_6, e0_.phone AS phone_7, e0_.cert_rate_type AS cert_rate_type_8, e0_.social_security_number AS social_security_number_9, e0_.apprentice_percentage AS apprentice_percentage_10, e0_.work_code AS work_code_11, e0_.gender AS gender_12, e0_.date_hired AS date_hired_13, e0_.date_terminated AS date_terminated_14, e0_.reason_terminated AS reason_terminated_15, e0_.time_card_notes AS time_card_notes_16, e0_.regular_rate_per_hour AS regular_rate_per_hour_17, e0_.overtime_rate_per_hour AS overtime_rate_per_hour_18, e0_.special_rate_per_hour AS special_rate_per_hour_19, e0_.trade_licenses_info AS trade_licenses_info_20, e0_.notes AS notes_21, e0_.is_osha_10_certified AS is_osha_10_certified_22, e0_.is_veteran AS is_veteran_23, e0_.status AS status_24, e0_.federal_filing_status AS federal_filing_status_25, e0_.federal_allowances AS federal_allowances_26, e0_.federal_additional_withholding AS federal_additional_withholding_27, e0_.w4_2020_or_later AS w4_2020_or_later_28, e0_.w4_multiple_jobs_step2 AS w4_multiple_jobs_step2_29, e0_.w4_dependents_amount AS w4_dependents_amount_30, e0_.w4_other_income_less_deductions AS w4_other_income_less_deductions_31, e0_.nonresident_alien AS nonresident_alien_32, e0_.do_not_withhold_fit AS do_not_withhold_fit_33, e0_.do_not_withhold_fica AS do_not_withhold_fica_34, e0_.role_id AS role_id_35, e0_.race_id AS race_id_36 FROM employee e0_ LEFT JOIN employee_role e1_ ON e0_.role_id = e1_.role_id WHERE e0_.status = 1 ORDER BY e0_.name ASC"
]

[
  "sql" => "SELECT t0.role_id AS role_id_1, t0.description AS description_2, t0.status AS status_3 FROM employee_role t0 WHERE t0.role_id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.role_id AS role_id_1, t0.description AS description_2, t0.status AS status_3 FROM employee_role t0 WHERE t0.role_id = ?"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.role_id AS role_id_1, t0.description AS description_2, t0.status AS status_3 FROM employee_role t0 WHERE t0.role_id = ?"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.role_id AS role_id_1, t0.description AS description_2, t0.status AS status_3 FROM employee_role t0 WHERE t0.role_id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.role_id AS role_id_1, t0.description AS description_2, t0.status AS status_3 FROM employee_role t0 WHERE t0.role_id = ?"
  "params" => [
    1 => 9
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.role_id AS role_id_1, t0.description AS description_2, t0.status AS status_3 FROM employee_role t0 WHERE t0.role_id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.role_id AS role_id_1, t0.description AS description_2, t0.status AS status_3 FROM employee_role t0 WHERE t0.role_id = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT s0_.subcontractor_id AS subcontractor_id_0, s0_.name AS name_1, s0_.phone AS phone_2, s0_.address AS address_3, s0_.contact_name AS contact_name_4, s0_.contact_email AS contact_email_5, s0_.company_name AS company_name_6, s0_.company_phone AS company_phone_7, s0_.company_address AS company_address_8, s0_.color AS color_9, s0_.created_at AS created_at_10, s0_.updated_at AS updated_at_11 FROM subcontractor s0_ ORDER BY s0_.name ASC"
]

[
  "sql" => "SELECT s0_.subcontractor_employee_id AS subcontractor_employee_id_0, s0_.name AS name_1, s0_.hourly_rate AS hourly_rate_2, s0_.position AS position_3, s0_.subcontractor_id AS subcontractor_id_4 FROM subcontractor_employee s0_ LEFT JOIN subcontractor s1_ ON s0_.subcontractor_id = s1_.subcontractor_id WHERE s1_.subcontractor_id = ? ORDER BY s0_.name ASC"
  "params" => [
    1 => 11
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT s0_.subcontractor_employee_id AS subcontractor_employee_id_0, s0_.name AS name_1, s0_.hourly_rate AS hourly_rate_2, s0_.position AS position_3, s0_.subcontractor_id AS subcontractor_id_4 FROM subcontractor_employee s0_ LEFT JOIN subcontractor s1_ ON s0_.subcontractor_id = s1_.subcontractor_id WHERE s1_.subcontractor_id = ? ORDER BY s0_.name ASC"
  "params" => [
    1 => 10
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT s0_.subcontractor_employee_id AS subcontractor_employee_id_0, s0_.name AS name_1, s0_.hourly_rate AS hourly_rate_2, s0_.position AS position_3, s0_.subcontractor_id AS subcontractor_id_4 FROM subcontractor_employee s0_ LEFT JOIN subcontractor s1_ ON s0_.subcontractor_id = s1_.subcontractor_id WHERE s1_.subcontractor_id = ? ORDER BY s0_.name ASC"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT s0_.subcontractor_employee_id AS subcontractor_employee_id_0, s0_.name AS name_1, s0_.hourly_rate AS hourly_rate_2, s0_.position AS position_3, s0_.subcontractor_id AS subcontractor_id_4 FROM subcontractor_employee s0_ LEFT JOIN subcontractor s1_ ON s0_.subcontractor_id = s1_.subcontractor_id WHERE s1_.subcontractor_id = ? ORDER BY s0_.name ASC"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT s0_.subcontractor_employee_id AS subcontractor_employee_id_0, s0_.name AS name_1, s0_.hourly_rate AS hourly_rate_2, s0_.position AS position_3, s0_.subcontractor_id AS subcontractor_id_4 FROM subcontractor_employee s0_ LEFT JOIN subcontractor s1_ ON s0_.subcontractor_id = s1_.subcontractor_id WHERE s1_.subcontractor_id = ? ORDER BY s0_.name ASC"
  "params" => [
    1 => 8
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT s0_.subcontractor_employee_id AS subcontractor_employee_id_0, s0_.name AS name_1, s0_.hourly_rate AS hourly_rate_2, s0_.position AS position_3, s0_.subcontractor_id AS subcontractor_id_4 FROM subcontractor_employee s0_ LEFT JOIN subcontractor s1_ ON s0_.subcontractor_id = s1_.subcontractor_id WHERE s1_.subcontractor_id = ? ORDER BY s0_.name ASC"
  "params" => [
    1 => 9
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT s0_.subcontractor_employee_id AS subcontractor_employee_id_0, s0_.name AS name_1, s0_.hourly_rate AS hourly_rate_2, s0_.position AS position_3, s0_.subcontractor_id AS subcontractor_id_4 FROM subcontractor_employee s0_ LEFT JOIN subcontractor s1_ ON s0_.subcontractor_id = s1_.subcontractor_id WHERE s1_.subcontractor_id = ? ORDER BY s0_.name ASC"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT s0_.subcontractor_employee_id AS subcontractor_employee_id_0, s0_.name AS name_1, s0_.hourly_rate AS hourly_rate_2, s0_.position AS position_3, s0_.subcontractor_id AS subcontractor_id_4 FROM subcontractor_employee s0_ LEFT JOIN subcontractor s1_ ON s0_.subcontractor_id = s1_.subcontractor_id WHERE s1_.subcontractor_id = ? ORDER BY s0_.name ASC"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT s0_.subcontractor_employee_id AS subcontractor_employee_id_0, s0_.name AS name_1, s0_.hourly_rate AS hourly_rate_2, s0_.position AS position_3, s0_.subcontractor_id AS subcontractor_id_4 FROM subcontractor_employee s0_ LEFT JOIN subcontractor s1_ ON s0_.subcontractor_id = s1_.subcontractor_id WHERE s1_.subcontractor_id = ? ORDER BY s0_.name ASC"
  "params" => [
    1 => 7
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT s0_.subcontractor_employee_id AS subcontractor_employee_id_0, s0_.name AS name_1, s0_.hourly_rate AS hourly_rate_2, s0_.position AS position_3, s0_.subcontractor_id AS subcontractor_id_4 FROM subcontractor_employee s0_ LEFT JOIN subcontractor s1_ ON s0_.subcontractor_id = s1_.subcontractor_id WHERE s1_.subcontractor_id = ? ORDER BY s0_.name ASC"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT s0_.subcontractor_employee_id AS subcontractor_employee_id_0, s0_.name AS name_1, s0_.hourly_rate AS hourly_rate_2, s0_.position AS position_3, s0_.subcontractor_id AS subcontractor_id_4 FROM subcontractor_employee s0_ LEFT JOIN subcontractor s1_ ON s0_.subcontractor_id = s1_.subcontractor_id WHERE s1_.subcontractor_id = ? ORDER BY s0_.name ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.quantity AS quantity_1, p0_.quantity_old AS quantity_old_2, p0_.price AS price_3, p0_.price_old AS price_old_4, p0_.yield_calculation AS yield_calculation_5, p0_.principal AS principal_6, p0_.change_order AS change_order_7, p0_.item_type AS item_type_8, p0_.change_order_date AS change_order_date_9, p0_.internal_note AS internal_note_10, p0_.note_updated_at AS note_updated_at_11, p0_.apply_retainage AS apply_retainage_12, p0_.bonded AS bonded_13, p0_.code AS code_14, p0_.contract_name AS contract_name_15, p0_.note_updated_by AS note_updated_by_16, p0_.project_id AS project_id_17, p0_.item_id AS item_id_18, p0_.equation_id AS equation_id_19 FROM project_item p0_ LEFT JOIN project p1_ ON p0_.project_id = p1_.project_id WHERE p1_.project_id = ? ORDER BY p0_.id ASC"
  "params" => [
    1 => 70
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.concrete_start_date AS concrete_start_date_1, p0_.concrete_quote_price_escalator AS concrete_quote_price_escalator_2, p0_.concrete_time_period_every_n AS concrete_time_period_every_n_3, p0_.concrete_time_period_unit AS concrete_time_period_unit_4, p0_.updated_at_concrete_quote_price AS updated_at_concrete_quote_price_5, p0_.position AS position_6, p0_.project_id AS project_id_7, p0_.vendor_id AS vendor_id_8 FROM project_concrete_vendor p0_ LEFT JOIN project p1_ ON p0_.project_id = p1_.project_id LEFT JOIN concrete_vendor c2_ ON p0_.vendor_id = c2_.vendor_id WHERE p1_.project_id = ? ORDER BY p0_.position ASC, p0_.id ASC"
  "params" => [
    1 => 70
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT c0_.vendor_id AS vendor_id_0, c0_.name AS name_1, c0_.phone AS phone_2, c0_.address AS address_3, c0_.contact_name AS contact_name_4, c0_.contact_email AS contact_email_5 FROM concrete_vendor c0_ ORDER BY c0_.name ASC"
]

[
  "sql" => "SELECT c0_.county_id AS county_id_0, c0_.description AS description_1, c0_.city AS city_2, c0_.status AS status_3, c0_.latitude AS latitude_4, c0_.longitude AS longitude_5, c0_.district_id AS district_id_6, c0_.state_id AS state_id_7 FROM county c0_ LEFT JOIN district d1_ ON c0_.district_id = d1_.district_id WHERE c0_.city IS NOT NULL AND TRIM(c0_.city) <> ? AND c0_.status = ? ORDER BY c0_.city ASC"
  "params" => [
    1 => ""
    2 => 1
  ]
  "types" => [
    1 => 2
    2 => 1
  ]
]

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