Symfony Profiler

Query Metrics

68 Database Queries

27 Different statements

4.27 ms Query time

0 Invalid entities

743 Managed entities

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

0.99 ms
(23.31%)

SELECT a0_.id AS id_0 FROM accounting_accounts a0_ WHERE a0_.accounts_id = ? AND UPPER(a0_.name) = UPPER(?) LIMIT 1

Parameters:

[
  2980
  "DRIVER REIMBURSE"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0
FROM
  accounting_accounts a0_
WHERE
  a0_.accounts_id = ?
  AND UPPER(a0_.name) = UPPER(?)
LIMIT
  1

SELECT a0_.id AS id_0 FROM accounting_accounts a0_ WHERE a0_.accounts_id = 2980 AND UPPER(a0_.name) = UPPER('DRIVER REIMBURSE') LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Repository\AccountingAccountsRepository->getAccountIdByName (line 708)
7	App\Service\Payroll\PayrollProcessingService->resolveReimbursementAccountIds (line 2659)
8	App\Service\Payroll\PayrollProcessingService->getReimbursementsByWeek (line 2611)
9	App\Controller\Payroll\PayrollProcessingController->index (line 330)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 208)
13	handle (line 26)

0.43 ms
(9.97%)

SELECT t0.id AS id_1, t0.pay_rate_mi AS pay_rate_mi_2, t0.name AS name_3, t0.mileage AS mileage_4, t0.rate_mty AS rate_mty_5, t0.rate_idd AS rate_idd_6, t0.percent AS percent_7, t0.percent_rate AS percent_rate_8, t0.percent_oth AS percent_oth_9, t0.salary AS salary_10, t0.auto_pay_del AS auto_pay_del_11, t0.check_load_pay AS check_load_pay_12, t0.pay_sel AS pay_sel_13, t0.salary_hr AS salary_hr_14, t0.salary_wk AS salary_wk_15, t0.salary_mo AS salary_mo_16, t0.split AS split_17, t0.lead AS lead_18, t0.per_diem AS per_diem_19, t0.per_dmile AS per_dmile_20, t0.per_doth AS per_doth_21, t0.pay_act_miles AS pay_act_miles_22, t0.pay_other_amount AS pay_other_amount_23, t0.pay_add_amount AS pay_add_amount_24, t0.per_damount AS per_damount_25, t0.tax_fed AS tax_fed_26, t0.tax_st AS tax_st_27, t0.tax_other AS tax_other_28, t0.states_mar AS states_mar_29, t0.states_gal AS states_gal_30, t0.depend AS depend_31, t0.health AS health_32, t0.healthy_amount AS healthy_amount_33, t0.health_mo AS health_mo_34, t0.truck_ins AS truck_ins_35, t0.truck_ins_amount AS truck_ins_amount_36, t0.truck_ins_mo AS truck_ins_mo_37, t0.other_ins AS other_ins_38, t0.other_ins_amount AS other_ins_amount_39, t0.other_ins_mo AS other_ins_mo_40, t0.other_ded AS other_ded_41, t0.other_ded_amount AS other_ded_amount_42, t0.other_ded_mo AS other_ded_mo_43, t0.other_ded2 AS other_ded2_44, t0.other_ded_amount2 AS other_ded_amount2_45, t0.other_ded_mo2 AS other_ded_mo2_46, t0.other_ded_name AS other_ded_name_47, t0.other_ded_name2 AS other_ded_name2_48, t0.check_pay_ad AS check_pay_ad_49, t0.check_pay_salary AS check_pay_salary_50, t0.check_pay_wk AS check_pay_wk_51, t0.check_pay_mo AS check_pay_mo_52, t0.check_pay_semi AS check_pay_semi_53, t0.check_pay_biwk AS check_pay_biwk_54, t0.perc_loading AS perc_loading_55, t0.check_fica AS check_fica_56, t0.check_medi AS check_medi_57, t0.check_futa AS check_futa_58, t0.check_stun AS check_stun_59, t0.fica_perc AS fica_perc_60, t0.medi_perc AS medi_perc_61, t0.futa_perc AS futa_perc_62, t0.unem_perc AS unem_perc_63, t0.fica_base AS fica_base_64, t0.futa_base AS futa_base_65, t0.unem_base AS unem_base_66, t0.open1 AS open1_67, t0.open2 AS open2_68, t0.open3 AS open3_69, t0.open4 AS open4_70, t0.open_check AS open_check_71, t0.table_no AS table_no_72, t0.expemtions AS expemtions_73, t0.other AS other_74, t0.county_tax AS county_tax_75, t0.team AS team_76, t0.other_ded3 AS other_ded3_77, t0.other_ded_mo3 AS other_ded_mo3_78, t0.other_ded_name3 AS other_ded_name3_79, t0.other_ded_amount3 AS other_ded_amount3_80, t0.escrow AS escrow_81, t0.escrow_monthly AS escrow_monthly_82, t0.escrow_deduct AS escrow_deduct_83, t0.escrow_limit AS escrow_limit_84, t0.extra_fed_wh AS extra_fed_wh_85, t0.check_surcharge AS check_surcharge_86, t0.perc_surcharge AS perc_surcharge_87, t0.per_diem_deduct AS per_diem_deduct_88, t0.special_pay AS special_pay_89, t0.az_tax_percent AS az_tax_percent_90, t0.other_tax_name AS other_tax_name_91, t0.pre_tax_on AS pre_tax_on_92, t0.pre_tax_liab AS pre_tax_liab_93, t0.pre_tax_amount AS pre_tax_amount_94, t0.pre_tax_percent AS pre_tax_percent_95, t0.pre_tax_monthly AS pre_tax_monthly_96, t0.pre_tax_employer_on AS pre_tax_employer_on_97, t0.pre_tax_employer_expense AS pre_tax_employer_expense_98, t0.pre_tax_employer_amount AS pre_tax_employer_amount_99, t0.pre_tax_employer_percent AS pre_tax_employer_percent_100, t0.cafeteria_plan AS cafeteria_plan_101, t0.deduct_cafeteria_from_futa AS deduct_cafeteria_from_futa_102, t0.cafeteria_plan_date AS cafeteria_plan_date_103, t0.deduct_cafeteria_from_suta AS deduct_cafeteria_from_suta_104, t0.sales_rep AS sales_rep_105, t0.deduct_pre_tax_from_state AS deduct_pre_tax_from_state_106, t0.fica_perc2 AS fica_perc2_107, t0.rate_bobtail AS rate_bobtail_108, t0.state_id_number AS state_id_number_109, t0.payroll_start_date AS payroll_start_date_110, t0.driver_id AS driver_id_111, t0.pay_owner AS pay_owner_112, t0.accounts_id AS accounts_id_113, t0.driver_id AS driver_id_114, t0.pay_owner AS pay_owner_115, t0.accounts_id AS accounts_id_116 FROM payroll t0 WHERE t0.accounts_id = ? AND t0.driver_id = ? LIMIT 1

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.pay_rate_mi AS pay_rate_mi_2,
  t0.name AS name_3,
  t0.mileage AS mileage_4,
  t0.rate_mty AS rate_mty_5,
  t0.rate_idd AS rate_idd_6,
  t0.percent AS percent_7,
  t0.percent_rate AS percent_rate_8,
  t0.percent_oth AS percent_oth_9,
  t0.salary AS salary_10,
  t0.auto_pay_del AS auto_pay_del_11,
  t0.check_load_pay AS check_load_pay_12,
  t0.pay_sel AS pay_sel_13,
  t0.salary_hr AS salary_hr_14,
  t0.salary_wk AS salary_wk_15,
  t0.salary_mo AS salary_mo_16,
  t0.split AS split_17,
  t0.lead AS lead_18,
  t0.per_diem AS per_diem_19,
  t0.per_dmile AS per_dmile_20,
  t0.per_doth AS per_doth_21,
  t0.pay_act_miles AS pay_act_miles_22,
  t0.pay_other_amount AS pay_other_amount_23,
  t0.pay_add_amount AS pay_add_amount_24,
  t0.per_damount AS per_damount_25,
  t0.tax_fed AS tax_fed_26,
  t0.tax_st AS tax_st_27,
  t0.tax_other AS tax_other_28,
  t0.states_mar AS states_mar_29,
  t0.states_gal AS states_gal_30,
  t0.depend AS depend_31,
  t0.health AS health_32,
  t0.healthy_amount AS healthy_amount_33,
  t0.health_mo AS health_mo_34,
  t0.truck_ins AS truck_ins_35,
  t0.truck_ins_amount AS truck_ins_amount_36,
  t0.truck_ins_mo AS truck_ins_mo_37,
  t0.other_ins AS other_ins_38,
  t0.other_ins_amount AS other_ins_amount_39,
  t0.other_ins_mo AS other_ins_mo_40,
  t0.other_ded AS other_ded_41,
  t0.other_ded_amount AS other_ded_amount_42,
  t0.other_ded_mo AS other_ded_mo_43,
  t0.other_ded2 AS other_ded2_44,
  t0.other_ded_amount2 AS other_ded_amount2_45,
  t0.other_ded_mo2 AS other_ded_mo2_46,
  t0.other_ded_name AS other_ded_name_47,
  t0.other_ded_name2 AS other_ded_name2_48,
  t0.check_pay_ad AS check_pay_ad_49,
  t0.check_pay_salary AS check_pay_salary_50,
  t0.check_pay_wk AS check_pay_wk_51,
  t0.check_pay_mo AS check_pay_mo_52,
  t0.check_pay_semi AS check_pay_semi_53,
  t0.check_pay_biwk AS check_pay_biwk_54,
  t0.perc_loading AS perc_loading_55,
  t0.check_fica AS check_fica_56,
  t0.check_medi AS check_medi_57,
  t0.check_futa AS check_futa_58,
  t0.check_stun AS check_stun_59,
  t0.fica_perc AS fica_perc_60,
  t0.medi_perc AS medi_perc_61,
  t0.futa_perc AS futa_perc_62,
  t0.unem_perc AS unem_perc_63,
  t0.fica_base AS fica_base_64,
  t0.futa_base AS futa_base_65,
  t0.unem_base AS unem_base_66,
  t0.open1 AS open1_67,
  t0.open2 AS open2_68,
  t0.open3 AS open3_69,
  t0.open4 AS open4_70,
  t0.open_check AS open_check_71,
  t0.table_no AS table_no_72,
  t0.expemtions AS expemtions_73,
  t0.other AS other_74,
  t0.county_tax AS county_tax_75,
  t0.team AS team_76,
  t0.other_ded3 AS other_ded3_77,
  t0.other_ded_mo3 AS other_ded_mo3_78,
  t0.other_ded_name3 AS other_ded_name3_79,
  t0.other_ded_amount3 AS other_ded_amount3_80,
  t0.escrow AS escrow_81,
  t0.escrow_monthly AS escrow_monthly_82,
  t0.escrow_deduct AS escrow_deduct_83,
  t0.escrow_limit AS escrow_limit_84,
  t0.extra_fed_wh AS extra_fed_wh_85,
  t0.check_surcharge AS check_surcharge_86,
  t0.perc_surcharge AS perc_surcharge_87,
  t0.per_diem_deduct AS per_diem_deduct_88,
  t0.special_pay AS special_pay_89,
  t0.az_tax_percent AS az_tax_percent_90,
  t0.other_tax_name AS other_tax_name_91,
  t0.pre_tax_on AS pre_tax_on_92,
  t0.pre_tax_liab AS pre_tax_liab_93,
  t0.pre_tax_amount AS pre_tax_amount_94,
  t0.pre_tax_percent AS pre_tax_percent_95,
  t0.pre_tax_monthly AS pre_tax_monthly_96,
  t0.pre_tax_employer_on AS pre_tax_employer_on_97,
  t0.pre_tax_employer_expense AS pre_tax_employer_expense_98,
  t0.pre_tax_employer_amount AS pre_tax_employer_amount_99,
  t0.pre_tax_employer_percent AS pre_tax_employer_percent_100,
  t0.cafeteria_plan AS cafeteria_plan_101,
  t0.deduct_cafeteria_from_futa AS deduct_cafeteria_from_futa_102,
  t0.cafeteria_plan_date AS cafeteria_plan_date_103,
  t0.deduct_cafeteria_from_suta AS deduct_cafeteria_from_suta_104,
  t0.sales_rep AS sales_rep_105,
  t0.deduct_pre_tax_from_state AS deduct_pre_tax_from_state_106,
  t0.fica_perc2 AS fica_perc2_107,
  t0.rate_bobtail AS rate_bobtail_108,
  t0.state_id_number AS state_id_number_109,
  t0.payroll_start_date AS payroll_start_date_110,
  t0.driver_id AS driver_id_111,
  t0.pay_owner AS pay_owner_112,
  t0.accounts_id AS accounts_id_113,
  t0.driver_id AS driver_id_114,
  t0.pay_owner AS pay_owner_115,
  t0.accounts_id AS accounts_id_116
FROM
  payroll t0
WHERE
  t0.accounts_id = ?
  AND t0.driver_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.pay_rate_mi AS pay_rate_mi_2, t0.name AS name_3, t0.mileage AS mileage_4, t0.rate_mty AS rate_mty_5, t0.rate_idd AS rate_idd_6, t0.percent AS percent_7, t0.percent_rate AS percent_rate_8, t0.percent_oth AS percent_oth_9, t0.salary AS salary_10, t0.auto_pay_del AS auto_pay_del_11, t0.check_load_pay AS check_load_pay_12, t0.pay_sel AS pay_sel_13, t0.salary_hr AS salary_hr_14, t0.salary_wk AS salary_wk_15, t0.salary_mo AS salary_mo_16, t0.split AS split_17, t0.lead AS lead_18, t0.per_diem AS per_diem_19, t0.per_dmile AS per_dmile_20, t0.per_doth AS per_doth_21, t0.pay_act_miles AS pay_act_miles_22, t0.pay_other_amount AS pay_other_amount_23, t0.pay_add_amount AS pay_add_amount_24, t0.per_damount AS per_damount_25, t0.tax_fed AS tax_fed_26, t0.tax_st AS tax_st_27, t0.tax_other AS tax_other_28, t0.states_mar AS states_mar_29, t0.states_gal AS states_gal_30, t0.depend AS depend_31, t0.health AS health_32, t0.healthy_amount AS healthy_amount_33, t0.health_mo AS health_mo_34, t0.truck_ins AS truck_ins_35, t0.truck_ins_amount AS truck_ins_amount_36, t0.truck_ins_mo AS truck_ins_mo_37, t0.other_ins AS other_ins_38, t0.other_ins_amount AS other_ins_amount_39, t0.other_ins_mo AS other_ins_mo_40, t0.other_ded AS other_ded_41, t0.other_ded_amount AS other_ded_amount_42, t0.other_ded_mo AS other_ded_mo_43, t0.other_ded2 AS other_ded2_44, t0.other_ded_amount2 AS other_ded_amount2_45, t0.other_ded_mo2 AS other_ded_mo2_46, t0.other_ded_name AS other_ded_name_47, t0.other_ded_name2 AS other_ded_name2_48, t0.check_pay_ad AS check_pay_ad_49, t0.check_pay_salary AS check_pay_salary_50, t0.check_pay_wk AS check_pay_wk_51, t0.check_pay_mo AS check_pay_mo_52, t0.check_pay_semi AS check_pay_semi_53, t0.check_pay_biwk AS check_pay_biwk_54, t0.perc_loading AS perc_loading_55, t0.check_fica AS check_fica_56, t0.check_medi AS check_medi_57, t0.check_futa AS check_futa_58, t0.check_stun AS check_stun_59, t0.fica_perc AS fica_perc_60, t0.medi_perc AS medi_perc_61, t0.futa_perc AS futa_perc_62, t0.unem_perc AS unem_perc_63, t0.fica_base AS fica_base_64, t0.futa_base AS futa_base_65, t0.unem_base AS unem_base_66, t0.open1 AS open1_67, t0.open2 AS open2_68, t0.open3 AS open3_69, t0.open4 AS open4_70, t0.open_check AS open_check_71, t0.table_no AS table_no_72, t0.expemtions AS expemtions_73, t0.other AS other_74, t0.county_tax AS county_tax_75, t0.team AS team_76, t0.other_ded3 AS other_ded3_77, t0.other_ded_mo3 AS other_ded_mo3_78, t0.other_ded_name3 AS other_ded_name3_79, t0.other_ded_amount3 AS other_ded_amount3_80, t0.escrow AS escrow_81, t0.escrow_monthly AS escrow_monthly_82, t0.escrow_deduct AS escrow_deduct_83, t0.escrow_limit AS escrow_limit_84, t0.extra_fed_wh AS extra_fed_wh_85, t0.check_surcharge AS check_surcharge_86, t0.perc_surcharge AS perc_surcharge_87, t0.per_diem_deduct AS per_diem_deduct_88, t0.special_pay AS special_pay_89, t0.az_tax_percent AS az_tax_percent_90, t0.other_tax_name AS other_tax_name_91, t0.pre_tax_on AS pre_tax_on_92, t0.pre_tax_liab AS pre_tax_liab_93, t0.pre_tax_amount AS pre_tax_amount_94, t0.pre_tax_percent AS pre_tax_percent_95, t0.pre_tax_monthly AS pre_tax_monthly_96, t0.pre_tax_employer_on AS pre_tax_employer_on_97, t0.pre_tax_employer_expense AS pre_tax_employer_expense_98, t0.pre_tax_employer_amount AS pre_tax_employer_amount_99, t0.pre_tax_employer_percent AS pre_tax_employer_percent_100, t0.cafeteria_plan AS cafeteria_plan_101, t0.deduct_cafeteria_from_futa AS deduct_cafeteria_from_futa_102, t0.cafeteria_plan_date AS cafeteria_plan_date_103, t0.deduct_cafeteria_from_suta AS deduct_cafeteria_from_suta_104, t0.sales_rep AS sales_rep_105, t0.deduct_pre_tax_from_state AS deduct_pre_tax_from_state_106, t0.fica_perc2 AS fica_perc2_107, t0.rate_bobtail AS rate_bobtail_108, t0.state_id_number AS state_id_number_109, t0.payroll_start_date AS payroll_start_date_110, t0.driver_id AS driver_id_111, t0.pay_owner AS pay_owner_112, t0.accounts_id AS accounts_id_113, t0.driver_id AS driver_id_114, t0.pay_owner AS pay_owner_115, t0.accounts_id AS accounts_id_116 FROM payroll t0 WHERE t0.accounts_id = 2980 AND t0.driver_id = 23204 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Controller\Payroll\PayrollProcessingController->index (line 216)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 208)
8	handle (line 26)

0.39 ms
(9.04%)

SELECT t0.id AS id_1, t0.accounts_id AS accounts_id_2, t0.address_id AS address_id_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.driver_code AS driver_code_6, t0.options AS options_7, t0.fast_id AS fast_id_8, t0.middle_name AS middle_name_9, t0.suffix AS suffix_10, t0.email_address AS email_address_11, t0.memo AS memo_12, t0.date_hired AS date_hired_13, t0.date_terminated AS date_terminated_14, t0.date_of_birth AS date_of_birth_15, t0.license_expiry AS license_expiry_16, t0.medical_exam_due AS medical_exam_due_17, t0.updated AS updated_18, t0.license_state AS license_state_19, t0.sms_carrier AS sms_carrier_20, t0.vacation_days_due AS vacation_days_due_21, t0.vacation_days_taken AS vacation_days_taken_22, t0.is_active AS is_active_23, t0.is_deleted AS is_deleted_24 FROM drivers t0 WHERE t0.id = ? AND t0.accounts_id = ? LIMIT 1

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.accounts_id AS accounts_id_2,
  t0.address_id AS address_id_3,
  t0.first_name AS first_name_4,
  t0.last_name AS last_name_5,
  t0.driver_code AS driver_code_6,
  t0.options AS options_7,
  t0.fast_id AS fast_id_8,
  t0.middle_name AS middle_name_9,
  t0.suffix AS suffix_10,
  t0.email_address AS email_address_11,
  t0.memo AS memo_12,
  t0.date_hired AS date_hired_13,
  t0.date_terminated AS date_terminated_14,
  t0.date_of_birth AS date_of_birth_15,
  t0.license_expiry AS license_expiry_16,
  t0.medical_exam_due AS medical_exam_due_17,
  t0.updated AS updated_18,
  t0.license_state AS license_state_19,
  t0.sms_carrier AS sms_carrier_20,
  t0.vacation_days_due AS vacation_days_due_21,
  t0.vacation_days_taken AS vacation_days_taken_22,
  t0.is_active AS is_active_23,
  t0.is_deleted AS is_deleted_24
FROM
  drivers t0
WHERE
  t0.id = ?
  AND t0.accounts_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.accounts_id AS accounts_id_2, t0.address_id AS address_id_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.driver_code AS driver_code_6, t0.options AS options_7, t0.fast_id AS fast_id_8, t0.middle_name AS middle_name_9, t0.suffix AS suffix_10, t0.email_address AS email_address_11, t0.memo AS memo_12, t0.date_hired AS date_hired_13, t0.date_terminated AS date_terminated_14, t0.date_of_birth AS date_of_birth_15, t0.license_expiry AS license_expiry_16, t0.medical_exam_due AS medical_exam_due_17, t0.updated AS updated_18, t0.license_state AS license_state_19, t0.sms_carrier AS sms_carrier_20, t0.vacation_days_due AS vacation_days_due_21, t0.vacation_days_taken AS vacation_days_taken_22, t0.is_active AS is_active_23, t0.is_deleted AS is_deleted_24 FROM drivers t0 WHERE t0.id = 23204 AND t0.accounts_id = 2980 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Service\Payroll\PayrollProcessingService->getDriverDetails (line 184)
5	App\Controller\Payroll\PayrollProcessingController->index (line 260)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 208)
9	handle (line 26)

0.35 ms
(8.23%)

SELECT p0_.id AS id_0, p0_.pay_date AS pay_date_1, p0_.check_no AS check_no_2, p0_.pmnt_no AS pmnt_no_3, p0_.gross AS gross_4, p0_.fed_tax AS fed_tax_5, p0_.ss_tax AS ss_tax_6, p0_.ss_tax2 AS ss_tax2_7, p0_.medi_tax AS medi_tax_8, p0_.futa_tax AS futa_tax_9, p0_.ss_inc_tax AS ss_inc_tax_10, p0_.ss_unem_tax AS ss_unem_tax_11, p0_.oth_tax AS oth_tax_12, p0_.hins AS hins_13, p0_.tins AS tins_14, p0_.oins AS oins_15, p0_.other1 AS other1_16, p0_.other2 AS other2_17, p0_.draws AS draws_18, p0_.reimb AS reimb_19, p0_.net_paid AS net_paid_20, p0_.ded_tot AS ded_tot_21, p0_.escrow AS escrow_22, p0_.per_diem AS per_diem_23, p0_.runtime_settings AS runtime_settings_24, p0_.box12a_code AS box12a_code_25, p0_.box12a_amount AS box12a_amount_26, p0_.box12b_code AS box12b_code_27, p0_.box12b_amount AS box12b_amount_28, p0_.box12c_code AS box12c_code_29, p0_.box12c_amount AS box12c_amount_30, p0_.box12d_code AS box12d_code_31, p0_.box12d_amount AS box12d_amount_32, p0_.accounts_id AS accounts_id_33, p0_.drivers_id AS drivers_id_34, p0_.accounts_id AS accounts_id_35, p0_.drivers_id AS drivers_id_36 FROM payroll_paid p0_ WHERE p0_.accounts_id = ? AND p0_.drivers_id = ? AND p0_.pmnt_no = ? ORDER BY p0_.id DESC LIMIT 1

Parameters:

[
  2980
  23204
  "WARTCR01071126"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.pay_date AS pay_date_1,
  p0_.check_no AS check_no_2,
  p0_.pmnt_no AS pmnt_no_3,
  p0_.gross AS gross_4,
  p0_.fed_tax AS fed_tax_5,
  p0_.ss_tax AS ss_tax_6,
  p0_.ss_tax2 AS ss_tax2_7,
  p0_.medi_tax AS medi_tax_8,
  p0_.futa_tax AS futa_tax_9,
  p0_.ss_inc_tax AS ss_inc_tax_10,
  p0_.ss_unem_tax AS ss_unem_tax_11,
  p0_.oth_tax AS oth_tax_12,
  p0_.hins AS hins_13,
  p0_.tins AS tins_14,
  p0_.oins AS oins_15,
  p0_.other1 AS other1_16,
  p0_.other2 AS other2_17,
  p0_.draws AS draws_18,
  p0_.reimb AS reimb_19,
  p0_.net_paid AS net_paid_20,
  p0_.ded_tot AS ded_tot_21,
  p0_.escrow AS escrow_22,
  p0_.per_diem AS per_diem_23,
  p0_.runtime_settings AS runtime_settings_24,
  p0_.box12a_code AS box12a_code_25,
  p0_.box12a_amount AS box12a_amount_26,
  p0_.box12b_code AS box12b_code_27,
  p0_.box12b_amount AS box12b_amount_28,
  p0_.box12c_code AS box12c_code_29,
  p0_.box12c_amount AS box12c_amount_30,
  p0_.box12d_code AS box12d_code_31,
  p0_.box12d_amount AS box12d_amount_32,
  p0_.accounts_id AS accounts_id_33,
  p0_.drivers_id AS drivers_id_34,
  p0_.accounts_id AS accounts_id_35,
  p0_.drivers_id AS drivers_id_36
FROM
  payroll_paid p0_
WHERE
  p0_.accounts_id = ?
  AND p0_.drivers_id = ?
  AND p0_.pmnt_no = ?
ORDER BY
  p0_.id DESC
LIMIT
  1

SELECT p0_.id AS id_0, p0_.pay_date AS pay_date_1, p0_.check_no AS check_no_2, p0_.pmnt_no AS pmnt_no_3, p0_.gross AS gross_4, p0_.fed_tax AS fed_tax_5, p0_.ss_tax AS ss_tax_6, p0_.ss_tax2 AS ss_tax2_7, p0_.medi_tax AS medi_tax_8, p0_.futa_tax AS futa_tax_9, p0_.ss_inc_tax AS ss_inc_tax_10, p0_.ss_unem_tax AS ss_unem_tax_11, p0_.oth_tax AS oth_tax_12, p0_.hins AS hins_13, p0_.tins AS tins_14, p0_.oins AS oins_15, p0_.other1 AS other1_16, p0_.other2 AS other2_17, p0_.draws AS draws_18, p0_.reimb AS reimb_19, p0_.net_paid AS net_paid_20, p0_.ded_tot AS ded_tot_21, p0_.escrow AS escrow_22, p0_.per_diem AS per_diem_23, p0_.runtime_settings AS runtime_settings_24, p0_.box12a_code AS box12a_code_25, p0_.box12a_amount AS box12a_amount_26, p0_.box12b_code AS box12b_code_27, p0_.box12b_amount AS box12b_amount_28, p0_.box12c_code AS box12c_code_29, p0_.box12c_amount AS box12c_amount_30, p0_.box12d_code AS box12d_code_31, p0_.box12d_amount AS box12d_amount_32, p0_.accounts_id AS accounts_id_33, p0_.drivers_id AS drivers_id_34, p0_.accounts_id AS accounts_id_35, p0_.drivers_id AS drivers_id_36 FROM payroll_paid p0_ WHERE p0_.accounts_id = 2980 AND p0_.drivers_id = 23204 AND p0_.pmnt_no = 'WARTCR01071126' ORDER BY p0_.id DESC LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Service\Payroll\PayrollProcessingService->getExistingPayrollRecord (line 1239)
7	App\Service\Payroll\PayrollProcessingService->isWeekSettled (line 1181)
8	App\Service\Payroll\PayrollProcessingService->getReimbursementsByWeek (line 2620)
9	App\Controller\Payroll\PayrollProcessingController->index (line 330)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 208)
13	handle (line 26)

0.19 ms
(4.45%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.id_federal AS id_federal_3, t0.id_mc AS id_mc_4, t0.id_dot AS id_dot_5, t0.id_ifta AS id_ifta_6, t0.is_active AS is_active_7, t0.is_deleted AS is_deleted_8, t0.subscription_state AS subscription_state_9, t0.secondary_address AS secondary_address_10, t0.secondary_suite AS secondary_suite_11, t0.secondary_city AS secondary_city_12, t0.secondary_state AS secondary_state_13, t0.secondary_zip AS secondary_zip_14, t0.id_federal_essence AS id_federal_essence_15, t0.state_id_number AS state_id_number_16, t0.user_count AS user_count_17, t0.secondary_phone AS secondary_phone_18, t0.secondary_fax AS secondary_fax_19, t0.address_accounts AS address_accounts_20 FROM accounts t0 WHERE t0.id = ?

Parameters:

[
  2980
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.id_federal AS id_federal_3,
  t0.id_mc AS id_mc_4,
  t0.id_dot AS id_dot_5,
  t0.id_ifta AS id_ifta_6,
  t0.is_active AS is_active_7,
  t0.is_deleted AS is_deleted_8,
  t0.subscription_state AS subscription_state_9,
  t0.secondary_address AS secondary_address_10,
  t0.secondary_suite AS secondary_suite_11,
  t0.secondary_city AS secondary_city_12,
  t0.secondary_state AS secondary_state_13,
  t0.secondary_zip AS secondary_zip_14,
  t0.id_federal_essence AS id_federal_essence_15,
  t0.state_id_number AS state_id_number_16,
  t0.user_count AS user_count_17,
  t0.secondary_phone AS secondary_phone_18,
  t0.secondary_fax AS secondary_fax_19,
  t0.address_accounts AS address_accounts_20
FROM
  accounts t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.id_federal AS id_federal_3, t0.id_mc AS id_mc_4, t0.id_dot AS id_dot_5, t0.id_ifta AS id_ifta_6, t0.is_active AS is_active_7, t0.is_deleted AS is_deleted_8, t0.subscription_state AS subscription_state_9, t0.secondary_address AS secondary_address_10, t0.secondary_suite AS secondary_suite_11, t0.secondary_city AS secondary_city_12, t0.secondary_state AS secondary_state_13, t0.secondary_zip AS secondary_zip_14, t0.id_federal_essence AS id_federal_essence_15, t0.state_id_number AS state_id_number_16, t0.user_count AS user_count_17, t0.secondary_phone AS secondary_phone_18, t0.secondary_fax AS secondary_fax_19, t0.address_accounts AS address_accounts_20 FROM accounts t0 WHERE t0.id = 2980;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 289)
4	Proxies\__CG__\App\Entity\Accounts::Doctrine\ORM\Proxy\{closure} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 100)
6	Proxies\__CG__\App\Entity\Accounts->__get (line 184)
7	App\Entity\Accounts->allowsWrite (line 156)
8	Twig\Extension\CoreExtension->getAttribute (line 1918)
9	__TwigTemplate_a2ac796fdc0ddd7b5d886a88167c0e61::block_base_body (line 228)
10	Twig\Template->yieldBlock (line 456)
11	__TwigTemplate_ae7f8c61e8726e5277cd4eef9443a437->doDisplay (line 271)
12	Twig\Template->yield (line 411)
13	__TwigTemplate_a2ac796fdc0ddd7b5d886a88167c0e61->doDisplay (line 54)
14	Twig\Template->yield (line 411)
15	__TwigTemplate_74506549765f588bb44140c4c0258cd6->doDisplay (line 55)
16	Twig\Template->yield (line 411)
17	Twig\Template->display (line 366)
18	Twig\Template->render (line 381)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
24	App\Controller\Payroll\PayrollProcessingController->index (line 558)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 208)
28	handle (line 26)

0.19 ms
(4.38%)

SELECT d0_.id AS id_0, d0_.accounts_id AS accounts_id_1, d0_.address_id AS address_id_2, d0_.first_name AS first_name_3, d0_.last_name AS last_name_4, d0_.driver_code AS driver_code_5, d0_.options AS options_6, d0_.fast_id AS fast_id_7, d0_.middle_name AS middle_name_8, d0_.suffix AS suffix_9, d0_.email_address AS email_address_10, d0_.memo AS memo_11, d0_.date_hired AS date_hired_12, d0_.date_terminated AS date_terminated_13, d0_.date_of_birth AS date_of_birth_14, d0_.license_expiry AS license_expiry_15, d0_.medical_exam_due AS medical_exam_due_16, d0_.updated AS updated_17, d0_.license_state AS license_state_18, d0_.sms_carrier AS sms_carrier_19, d0_.vacation_days_due AS vacation_days_due_20, d0_.vacation_days_taken AS vacation_days_taken_21, d0_.is_active AS is_active_22, d0_.is_deleted AS is_deleted_23 FROM drivers d0_ WHERE d0_.accounts_id = ? AND d0_.is_active = ? AND d0_.is_deleted = ? AND d0_.date_terminated IS NULL ORDER BY d0_.first_name ASC, d0_.last_name ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  d0_.id AS id_0,
  d0_.accounts_id AS accounts_id_1,
  d0_.address_id AS address_id_2,
  d0_.first_name AS first_name_3,
  d0_.last_name AS last_name_4,
  d0_.driver_code AS driver_code_5,
  d0_.options AS options_6,
  d0_.fast_id AS fast_id_7,
  d0_.middle_name AS middle_name_8,
  d0_.suffix AS suffix_9,
  d0_.email_address AS email_address_10,
  d0_.memo AS memo_11,
  d0_.date_hired AS date_hired_12,
  d0_.date_terminated AS date_terminated_13,
  d0_.date_of_birth AS date_of_birth_14,
  d0_.license_expiry AS license_expiry_15,
  d0_.medical_exam_due AS medical_exam_due_16,
  d0_.updated AS updated_17,
  d0_.license_state AS license_state_18,
  d0_.sms_carrier AS sms_carrier_19,
  d0_.vacation_days_due AS vacation_days_due_20,
  d0_.vacation_days_taken AS vacation_days_taken_21,
  d0_.is_active AS is_active_22,
  d0_.is_deleted AS is_deleted_23
FROM
  drivers d0_
WHERE
  d0_.accounts_id = ?
  AND d0_.is_active = ?
  AND d0_.is_deleted = ?
  AND d0_.date_terminated IS NULL
ORDER BY
  d0_.first_name ASC,
  d0_.last_name ASC

SELECT d0_.id AS id_0, d0_.accounts_id AS accounts_id_1, d0_.address_id AS address_id_2, d0_.first_name AS first_name_3, d0_.last_name AS last_name_4, d0_.driver_code AS driver_code_5, d0_.options AS options_6, d0_.fast_id AS fast_id_7, d0_.middle_name AS middle_name_8, d0_.suffix AS suffix_9, d0_.email_address AS email_address_10, d0_.memo AS memo_11, d0_.date_hired AS date_hired_12, d0_.date_terminated AS date_terminated_13, d0_.date_of_birth AS date_of_birth_14, d0_.license_expiry AS license_expiry_15, d0_.medical_exam_due AS medical_exam_due_16, d0_.updated AS updated_17, d0_.license_state AS license_state_18, d0_.sms_carrier AS sms_carrier_19, d0_.vacation_days_due AS vacation_days_due_20, d0_.vacation_days_taken AS vacation_days_taken_21, d0_.is_active AS is_active_22, d0_.is_deleted AS is_deleted_23 FROM drivers d0_ WHERE d0_.accounts_id = 2980 AND d0_.is_active = 1 AND d0_.is_deleted = 0 AND d0_.date_terminated IS NULL ORDER BY d0_.first_name ASC, d0_.last_name ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Service\Payroll\PayrollProcessingService->getActiveDriversList (line 134)
7	App\Controller\Payroll\PayrollProcessingController->index (line 125)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 208)
11	handle (line 26)

0.15 ms
(3.49%)

SELECT p0_.id AS id_0, p0_.week_end AS week_end_1, p0_.amount AS amount_2, p0_.memo AS memo_3, p0_.check_number AS check_number_4, p0_.paid_on AS paid_on_5, p0_.pmnt_no AS pmnt_no_6, p0_.truck_id AS truck_id_7, p0_.pro_numbers_id AS pro_numbers_id_8, p0_.charge_to_account AS charge_to_account_9, p0_.driver_id AS driver_id_10, p0_.accounts_id AS accounts_id_11, p0_.truck_id AS truck_id_12, p0_.pro_numbers_id AS pro_numbers_id_13, p0_.charge_to_account AS charge_to_account_14, p0_.driver_id AS driver_id_15, p0_.accounts_id AS accounts_id_16 FROM payroll_deductions_taken p0_ WHERE p0_.accounts_id = ? AND (p0_.week_end BETWEEN ? AND ?) AND p0_.driver_id = ? ORDER BY p0_.id DESC LIMIT 20

Parameters:

[
  2980
  "2026-07-11 00:00:00"
  "2026-07-11 23:59:59"
  23204
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.week_end AS week_end_1,
  p0_.amount AS amount_2,
  p0_.memo AS memo_3,
  p0_.check_number AS check_number_4,
  p0_.paid_on AS paid_on_5,
  p0_.pmnt_no AS pmnt_no_6,
  p0_.truck_id AS truck_id_7,
  p0_.pro_numbers_id AS pro_numbers_id_8,
  p0_.charge_to_account AS charge_to_account_9,
  p0_.driver_id AS driver_id_10,
  p0_.accounts_id AS accounts_id_11,
  p0_.truck_id AS truck_id_12,
  p0_.pro_numbers_id AS pro_numbers_id_13,
  p0_.charge_to_account AS charge_to_account_14,
  p0_.driver_id AS driver_id_15,
  p0_.accounts_id AS accounts_id_16
FROM
  payroll_deductions_taken p0_
WHERE
  p0_.accounts_id = ?
  AND (
    p0_.week_end BETWEEN ?
    AND ?
  )
  AND p0_.driver_id = ?
ORDER BY
  p0_.id DESC
LIMIT
  20

SELECT p0_.id AS id_0, p0_.week_end AS week_end_1, p0_.amount AS amount_2, p0_.memo AS memo_3, p0_.check_number AS check_number_4, p0_.paid_on AS paid_on_5, p0_.pmnt_no AS pmnt_no_6, p0_.truck_id AS truck_id_7, p0_.pro_numbers_id AS pro_numbers_id_8, p0_.charge_to_account AS charge_to_account_9, p0_.driver_id AS driver_id_10, p0_.accounts_id AS accounts_id_11, p0_.truck_id AS truck_id_12, p0_.pro_numbers_id AS pro_numbers_id_13, p0_.charge_to_account AS charge_to_account_14, p0_.driver_id AS driver_id_15, p0_.accounts_id AS accounts_id_16 FROM payroll_deductions_taken p0_ WHERE p0_.accounts_id = 2980 AND (p0_.week_end BETWEEN '2026-07-11 00:00:00' AND '2026-07-11 23:59:59') AND p0_.driver_id = 23204 ORDER BY p0_.id DESC LIMIT 20;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\PayrolldeductionstakenRepository->findByAccountAndWeek (line 103)
7	App\Service\Payroll\PayrollProcessingService->getDeductionsByWeek (line 2080)
8	App\Controller\Payroll\PayrollProcessingController->index (line 320)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 208)
12	handle (line 26)

0.13 ms
(3.07%)

SELECT p0_.id AS id_0, p0_.week_end AS week_end_1, p0_.type AS type_2, p0_.rate1 AS rate1_3, p0_.rate2 AS rate2_4, p0_.pay1 AS pay1_5, p0_.pay2 AS pay2_6, p0_.truck_id AS truck_id_7, p0_.pro_number_id AS pro_number_id_8, p1_.pro_number AS pro_number_9, p0_.accounts_id AS accounts_id_10, p0_.driver_id AS driver_id_11 FROM payroll_miles_paid p0_ LEFT JOIN pro_numbers p1_ ON p0_.pro_number_id = p1_.id WHERE p0_.accounts_id = ? AND (p0_.week_end BETWEEN ? AND ?) AND p0_.driver_id = ? ORDER BY p0_.id DESC

Parameters:

[
  2980
  "2026-07-11 00:00:00"
  "2026-07-11 23:59:59"
  23204
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.week_end AS week_end_1,
  p0_.type AS type_2,
  p0_.rate1 AS rate1_3,
  p0_.rate2 AS rate2_4,
  p0_.pay1 AS pay1_5,
  p0_.pay2 AS pay2_6,
  p0_.truck_id AS truck_id_7,
  p0_.pro_number_id AS pro_number_id_8,
  p1_.pro_number AS pro_number_9,
  p0_.accounts_id AS accounts_id_10,
  p0_.driver_id AS driver_id_11
FROM
  payroll_miles_paid p0_
  LEFT JOIN pro_numbers p1_ ON p0_.pro_number_id = p1_.id
WHERE
  p0_.accounts_id = ?
  AND (
    p0_.week_end BETWEEN ?
    AND ?
  )
  AND p0_.driver_id = ?
ORDER BY
  p0_.id DESC

SELECT p0_.id AS id_0, p0_.week_end AS week_end_1, p0_.type AS type_2, p0_.rate1 AS rate1_3, p0_.rate2 AS rate2_4, p0_.pay1 AS pay1_5, p0_.pay2 AS pay2_6, p0_.truck_id AS truck_id_7, p0_.pro_number_id AS pro_number_id_8, p1_.pro_number AS pro_number_9, p0_.accounts_id AS accounts_id_10, p0_.driver_id AS driver_id_11 FROM payroll_miles_paid p0_ LEFT JOIN pro_numbers p1_ ON p0_.pro_number_id = p1_.id WHERE p0_.accounts_id = 2980 AND (p0_.week_end BETWEEN '2026-07-11 00:00:00' AND '2026-07-11 23:59:59') AND p0_.driver_id = 23204 ORDER BY p0_.id DESC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getArrayResult (line 700)
6	App\Repository\PayrollmilespaidRepository->findByWeekEndWithFilters (line 119)
7	App\Service\Payroll\PayrollProcessingService->getMileagePaysByWeek (line 398)
8	App\Controller\Payroll\PayrollProcessingController->index (line 277)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 208)
12	handle (line 26)

0.11 ms
(2.68%)

SELECT t0.id AS id_1, t0.pro_number AS pro_number_2, t0.accounts_id AS accounts_id_3, t0.accounts_id AS accounts_id_4 FROM pro_numbers t0 WHERE t0.accounts_id = ? ORDER BY t0.pro_number DESC LIMIT 500

Parameters:

[
  2980
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.pro_number AS pro_number_2,
  t0.accounts_id AS accounts_id_3,
  t0.accounts_id AS accounts_id_4
FROM
  pro_numbers t0
WHERE
  t0.accounts_id = ?
ORDER BY
  t0.pro_number DESC
LIMIT
  500

SELECT t0.id AS id_1, t0.pro_number AS pro_number_2, t0.accounts_id AS accounts_id_3, t0.accounts_id AS accounts_id_4 FROM pro_numbers t0 WHERE t0.accounts_id = 2980 ORDER BY t0.pro_number DESC LIMIT 500;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Service\Payroll\PayrollProcessingService->getAvailableProNumbers (line 160)
5	App\Controller\Payroll\PayrollProcessingController->index (line 376)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 208)
9	handle (line 26)

0.11 ms
(2.62%)

SELECT t0.id AS id_1, t0.setup_complete AS setup_complete_2, t0.email AS email_3, t0.password AS password_4, t0.original_data AS original_data_5, t0.accounts_id AS accounts_id_6, t0.drivers_id AS drivers_id_7, t0.customers_id AS customers_id_8, t0.accounts_id AS accounts_id_9, t0.drivers_id AS drivers_id_10, t0.customers_id AS customers_id_11 FROM nelco_credentials t0 WHERE t0.accounts_id = ? LIMIT 1

Parameters:

[
  2980
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.setup_complete AS setup_complete_2,
  t0.email AS email_3,
  t0.password AS password_4,
  t0.original_data AS original_data_5,
  t0.accounts_id AS accounts_id_6,
  t0.drivers_id AS drivers_id_7,
  t0.customers_id AS customers_id_8,
  t0.accounts_id AS accounts_id_9,
  t0.drivers_id AS drivers_id_10,
  t0.customers_id AS customers_id_11
FROM
  nelco_credentials t0
WHERE
  t0.accounts_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.setup_complete AS setup_complete_2, t0.email AS email_3, t0.password AS password_4, t0.original_data AS original_data_5, t0.accounts_id AS accounts_id_6, t0.drivers_id AS drivers_id_7, t0.customers_id AS customers_id_8, t0.accounts_id AS accounts_id_9, t0.drivers_id AS drivers_id_10, t0.customers_id AS customers_id_11 FROM nelco_credentials t0 WHERE t0.accounts_id = 2980 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Service\NelcoCredentialsService->hasCredentials (line 78)
5	App\Controller\Payroll\PayrollProcessingController->index (line 586)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 208)
9	handle (line 26)

0.11 ms
(2.55%)

SELECT p0_.id AS id_0, p0_.week_end AS week_end_1, p0_.amount AS amount_2, p0_.memo AS memo_3, p0_.pay_for AS pay_for_4, p0_.check_number AS check_number_5, p0_.paid_on AS paid_on_6, p0_.pmnt_no AS pmnt_no_7, p0_.trucks_id AS trucks_id_8, p0_.pro_number_id AS pro_number_id_9, p0_.driver_id AS driver_id_10, p0_.accounts_id AS accounts_id_11, p0_.trucks_id AS trucks_id_12, p0_.pro_number_id AS pro_number_id_13, p0_.driver_id AS driver_id_14, p0_.accounts_id AS accounts_id_15 FROM payroll_other_paid p0_ WHERE p0_.accounts_id = ? AND (p0_.week_end BETWEEN ? AND ?) AND p0_.driver_id = ? ORDER BY p0_.id DESC

Parameters:

[
  2980
  "2026-07-11 00:00:00"
  "2026-07-11 23:59:59"
  23204
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.week_end AS week_end_1,
  p0_.amount AS amount_2,
  p0_.memo AS memo_3,
  p0_.pay_for AS pay_for_4,
  p0_.check_number AS check_number_5,
  p0_.paid_on AS paid_on_6,
  p0_.pmnt_no AS pmnt_no_7,
  p0_.trucks_id AS trucks_id_8,
  p0_.pro_number_id AS pro_number_id_9,
  p0_.driver_id AS driver_id_10,
  p0_.accounts_id AS accounts_id_11,
  p0_.trucks_id AS trucks_id_12,
  p0_.pro_number_id AS pro_number_id_13,
  p0_.driver_id AS driver_id_14,
  p0_.accounts_id AS accounts_id_15
FROM
  payroll_other_paid p0_
WHERE
  p0_.accounts_id = ?
  AND (
    p0_.week_end BETWEEN ?
    AND ?
  )
  AND p0_.driver_id = ?
ORDER BY
  p0_.id DESC

SELECT p0_.id AS id_0, p0_.week_end AS week_end_1, p0_.amount AS amount_2, p0_.memo AS memo_3, p0_.pay_for AS pay_for_4, p0_.check_number AS check_number_5, p0_.paid_on AS paid_on_6, p0_.pmnt_no AS pmnt_no_7, p0_.trucks_id AS trucks_id_8, p0_.pro_number_id AS pro_number_id_9, p0_.driver_id AS driver_id_10, p0_.accounts_id AS accounts_id_11, p0_.trucks_id AS trucks_id_12, p0_.pro_number_id AS pro_number_id_13, p0_.driver_id AS driver_id_14, p0_.accounts_id AS accounts_id_15 FROM payroll_other_paid p0_ WHERE p0_.accounts_id = 2980 AND (p0_.week_end BETWEEN '2026-07-11 00:00:00' AND '2026-07-11 23:59:59') AND p0_.driver_id = 23204 ORDER BY p0_.id DESC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\PayrollotherpaidRepository->findByAccountAndWeek (line 93)
7	App\Service\Payroll\PayrollProcessingService->getOtherPaysByWeek (line 1824)
8	App\Controller\Payroll\PayrollProcessingController->index (line 298)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 208)
12	handle (line 26)

0.11 ms
(2.46%)

SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.salt AS salt_4, t0.email AS email_5, t0.email_validated AS email_validated_6, t0.is_active AS is_active_7, t0.is_deleted AS is_deleted_8, t0.timestamp AS timestamp_9, t0.login_count AS login_count_10, t0.last_login AS last_login_11, t0.user_session_id AS user_session_id_12, t0.last_login_ua_hash AS last_login_ua_hash_13, t0.permission_level AS permission_level_14, t0.type AS type_15, t0.is_driver AS is_driver_16, t0.security_question AS security_question_17, t0.security_answer AS security_answer_18, t0.company_name AS company_name_19, t0.setup_status AS setup_status_20, t0.user_permissions AS user_permissions_21, t0.tutor_list AS tutor_list_22, t0.subscription_id AS subscription_id_23, t0.billing_cycle AS billing_cycle_24, t0.failedAttempts AS failedAttempts_25, t0.lockoutUntil AS lockoutUntil_26, t0.resetToken AS resetToken_27, t0.tokenRequestedAt AS tokenRequestedAt_28, t0.forcePasswordChange AS forcePasswordChange_29, t0.account AS account_30, t0.user_preferences_id AS user_preferences_id_31 FROM users t0 WHERE t0.id = ?

Parameters:

[
  3765
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.password AS password_3,
  t0.salt AS salt_4,
  t0.email AS email_5,
  t0.email_validated AS email_validated_6,
  t0.is_active AS is_active_7,
  t0.is_deleted AS is_deleted_8,
  t0.timestamp AS timestamp_9,
  t0.login_count AS login_count_10,
  t0.last_login AS last_login_11,
  t0.user_session_id AS user_session_id_12,
  t0.last_login_ua_hash AS last_login_ua_hash_13,
  t0.permission_level AS permission_level_14,
  t0.type AS type_15,
  t0.is_driver AS is_driver_16,
  t0.security_question AS security_question_17,
  t0.security_answer AS security_answer_18,
  t0.company_name AS company_name_19,
  t0.setup_status AS setup_status_20,
  t0.user_permissions AS user_permissions_21,
  t0.tutor_list AS tutor_list_22,
  t0.subscription_id AS subscription_id_23,
  t0.billing_cycle AS billing_cycle_24,
  t0.failedAttempts AS failedAttempts_25,
  t0.lockoutUntil AS lockoutUntil_26,
  t0.resetToken AS resetToken_27,
  t0.tokenRequestedAt AS tokenRequestedAt_28,
  t0.forcePasswordChange AS forcePasswordChange_29,
  t0.account AS account_30,
  t0.user_preferences_id AS user_preferences_id_31
FROM
  users t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.salt AS salt_4, t0.email AS email_5, t0.email_validated AS email_validated_6, t0.is_active AS is_active_7, t0.is_deleted AS is_deleted_8, t0.timestamp AS timestamp_9, t0.login_count AS login_count_10, t0.last_login AS last_login_11, t0.user_session_id AS user_session_id_12, t0.last_login_ua_hash AS last_login_ua_hash_13, t0.permission_level AS permission_level_14, t0.type AS type_15, t0.is_driver AS is_driver_16, t0.security_question AS security_question_17, t0.security_answer AS security_answer_18, t0.company_name AS company_name_19, t0.setup_status AS setup_status_20, t0.user_permissions AS user_permissions_21, t0.tutor_list AS tutor_list_22, t0.subscription_id AS subscription_id_23, t0.billing_cycle AS billing_cycle_24, t0.failedAttempts AS failedAttempts_25, t0.lockoutUntil AS lockoutUntil_26, t0.resetToken AS resetToken_27, t0.tokenRequestedAt AS tokenRequestedAt_28, t0.forcePasswordChange AS forcePasswordChange_29, t0.account AS account_30, t0.user_preferences_id AS user_preferences_id_31 FROM users t0 WHERE t0.id = 3765;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 99)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 229)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 134)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 60)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 80)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 95)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 142)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 208)
20	handle (line 26)

0.10 ms
(2.25%)

SELECT m0_.pro_numbers_id AS sclr_0, SUM(m0_.miles) AS sclr_1 FROM miles m0_ WHERE m0_.accounts_id = ? AND m0_.pro_numbers_id IN (?, ?) GROUP BY m0_.pro_numbers_id

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.pro_numbers_id AS sclr_0,
  SUM(m0_.miles) AS sclr_1
FROM
  miles m0_
WHERE
  m0_.accounts_id = ?
  AND m0_.pro_numbers_id IN (?, ?)
GROUP BY
  m0_.pro_numbers_id

SELECT m0_.pro_numbers_id AS sclr_0, SUM(m0_.miles) AS sclr_1 FROM miles m0_ WHERE m0_.accounts_id = 2980 AND m0_.pro_numbers_id IN (1290183, 1167407) GROUP BY m0_.pro_numbers_id;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\MilesRepository->getMilesByProNumbers (line 190)
7	App\Service\Payroll\PayrollProcessingService->getMileagePaysByWeek (line 419)
8	App\Controller\Payroll\PayrollProcessingController->index (line 277)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 208)
12	handle (line 26)

0.09 ms
(2.06%)

SELECT p0_.id AS id_0, p0_.pay_date AS pay_date_1, p0_.check_no AS check_no_2, p0_.pmnt_no AS pmnt_no_3, p0_.gross AS gross_4, p0_.fed_tax AS fed_tax_5, p0_.ss_tax AS ss_tax_6, p0_.ss_tax2 AS ss_tax2_7, p0_.medi_tax AS medi_tax_8, p0_.futa_tax AS futa_tax_9, p0_.ss_inc_tax AS ss_inc_tax_10, p0_.ss_unem_tax AS ss_unem_tax_11, p0_.oth_tax AS oth_tax_12, p0_.hins AS hins_13, p0_.tins AS tins_14, p0_.oins AS oins_15, p0_.other1 AS other1_16, p0_.other2 AS other2_17, p0_.draws AS draws_18, p0_.reimb AS reimb_19, p0_.net_paid AS net_paid_20, p0_.ded_tot AS ded_tot_21, p0_.escrow AS escrow_22, p0_.per_diem AS per_diem_23, p0_.runtime_settings AS runtime_settings_24, p0_.box12a_code AS box12a_code_25, p0_.box12a_amount AS box12a_amount_26, p0_.box12b_code AS box12b_code_27, p0_.box12b_amount AS box12b_amount_28, p0_.box12c_code AS box12c_code_29, p0_.box12c_amount AS box12c_amount_30, p0_.box12d_code AS box12d_code_31, p0_.box12d_amount AS box12d_amount_32, p0_.accounts_id AS accounts_id_33, p0_.drivers_id AS drivers_id_34, p0_.accounts_id AS accounts_id_35, p0_.drivers_id AS drivers_id_36 FROM payroll_paid p0_ WHERE p0_.accounts_id = ? AND p0_.drivers_id = ? AND p0_.pay_date >= ? AND p0_.pay_date < ?

Parameters:

[
  2980
  23204
  "2026-01-01 00:00:00"
  "2026-07-11 00:00:00"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.pay_date AS pay_date_1,
  p0_.check_no AS check_no_2,
  p0_.pmnt_no AS pmnt_no_3,
  p0_.gross AS gross_4,
  p0_.fed_tax AS fed_tax_5,
  p0_.ss_tax AS ss_tax_6,
  p0_.ss_tax2 AS ss_tax2_7,
  p0_.medi_tax AS medi_tax_8,
  p0_.futa_tax AS futa_tax_9,
  p0_.ss_inc_tax AS ss_inc_tax_10,
  p0_.ss_unem_tax AS ss_unem_tax_11,
  p0_.oth_tax AS oth_tax_12,
  p0_.hins AS hins_13,
  p0_.tins AS tins_14,
  p0_.oins AS oins_15,
  p0_.other1 AS other1_16,
  p0_.other2 AS other2_17,
  p0_.draws AS draws_18,
  p0_.reimb AS reimb_19,
  p0_.net_paid AS net_paid_20,
  p0_.ded_tot AS ded_tot_21,
  p0_.escrow AS escrow_22,
  p0_.per_diem AS per_diem_23,
  p0_.runtime_settings AS runtime_settings_24,
  p0_.box12a_code AS box12a_code_25,
  p0_.box12a_amount AS box12a_amount_26,
  p0_.box12b_code AS box12b_code_27,
  p0_.box12b_amount AS box12b_amount_28,
  p0_.box12c_code AS box12c_code_29,
  p0_.box12c_amount AS box12c_amount_30,
  p0_.box12d_code AS box12d_code_31,
  p0_.box12d_amount AS box12d_amount_32,
  p0_.accounts_id AS accounts_id_33,
  p0_.drivers_id AS drivers_id_34,
  p0_.accounts_id AS accounts_id_35,
  p0_.drivers_id AS drivers_id_36
FROM
  payroll_paid p0_
WHERE
  p0_.accounts_id = ?
  AND p0_.drivers_id = ?
  AND p0_.pay_date >= ?
  AND p0_.pay_date < ?

SELECT p0_.id AS id_0, p0_.pay_date AS pay_date_1, p0_.check_no AS check_no_2, p0_.pmnt_no AS pmnt_no_3, p0_.gross AS gross_4, p0_.fed_tax AS fed_tax_5, p0_.ss_tax AS ss_tax_6, p0_.ss_tax2 AS ss_tax2_7, p0_.medi_tax AS medi_tax_8, p0_.futa_tax AS futa_tax_9, p0_.ss_inc_tax AS ss_inc_tax_10, p0_.ss_unem_tax AS ss_unem_tax_11, p0_.oth_tax AS oth_tax_12, p0_.hins AS hins_13, p0_.tins AS tins_14, p0_.oins AS oins_15, p0_.other1 AS other1_16, p0_.other2 AS other2_17, p0_.draws AS draws_18, p0_.reimb AS reimb_19, p0_.net_paid AS net_paid_20, p0_.ded_tot AS ded_tot_21, p0_.escrow AS escrow_22, p0_.per_diem AS per_diem_23, p0_.runtime_settings AS runtime_settings_24, p0_.box12a_code AS box12a_code_25, p0_.box12a_amount AS box12a_amount_26, p0_.box12b_code AS box12b_code_27, p0_.box12b_amount AS box12b_amount_28, p0_.box12c_code AS box12c_code_29, p0_.box12c_amount AS box12c_amount_30, p0_.box12d_code AS box12d_code_31, p0_.box12d_amount AS box12d_amount_32, p0_.accounts_id AS accounts_id_33, p0_.drivers_id AS drivers_id_34, p0_.accounts_id AS accounts_id_35, p0_.drivers_id AS drivers_id_36 FROM payroll_paid p0_ WHERE p0_.accounts_id = 2980 AND p0_.drivers_id = 23204 AND p0_.pay_date >= '2026-01-01 00:00:00' AND p0_.pay_date < '2026-07-11 00:00:00';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Service\Payroll\TaxCalculationService->calculateYTDPay (line 167)
7	App\Service\Payroll\TaxCalculationService->calculateDriverTaxes (line 87)
8	App\Service\Payroll\PayrollProcessingService->calculatePayrollSummary (line 913)
9	App\Controller\Payroll\PayrollProcessingController->index (line 354)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 208)
13	handle (line 26)

0.08 ms
(1.90%)

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.type AS type_2, a0_.gl_number AS gl_number_3, a0_.balance AS balance_4, a0_.is_chargeto AS is_chargeto_5, a0_.is_active AS is_active_6, a0_.budget AS budget_7, a0_.accounts_id AS accounts_id_8 FROM accounting_accounts a0_ WHERE a0_.accounts_id = ? AND (a0_.type = ? OR a0_.is_chargeto = 1) AND a0_.is_active = 1 ORDER BY a0_.name ASC

Parameters:

[
  2980
  "expense"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.type AS type_2,
  a0_.gl_number AS gl_number_3,
  a0_.balance AS balance_4,
  a0_.is_chargeto AS is_chargeto_5,
  a0_.is_active AS is_active_6,
  a0_.budget AS budget_7,
  a0_.accounts_id AS accounts_id_8
FROM
  accounting_accounts a0_
WHERE
  a0_.accounts_id = ?
  AND (
    a0_.type = ?
    OR a0_.is_chargeto = 1
  )
  AND a0_.is_active = 1
ORDER BY
  a0_.name ASC

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.type AS type_2, a0_.gl_number AS gl_number_3, a0_.balance AS balance_4, a0_.is_chargeto AS is_chargeto_5, a0_.is_active AS is_active_6, a0_.budget AS budget_7, a0_.accounts_id AS accounts_id_8 FROM accounting_accounts a0_ WHERE a0_.accounts_id = 2980 AND (a0_.type = 'expense' OR a0_.is_chargeto = 1) AND a0_.is_active = 1 ORDER BY a0_.name ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Service\Payroll\PayrollProcessingService->getExpenseAccountsForForm (line 345)
7	App\Controller\Payroll\PayrollProcessingController->index (line 381)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 208)
11	handle (line 26)

0.08 ms
(1.83%)

SELECT a0_.id AS id_0, a0_.number AS number_1, a0_.date AS date_2, a0_.type AS type_3, a0_.amount AS amount_4, a0_.payment_method AS payment_method_5, a0_.check_number AS check_number_6, a0_.memo AS memo_7, a0_.is_reconciled AS is_reconciled_8, a0_.is_cleared AS is_cleared_9, a0_.timestamp AS timestamp_10, a0_.is_deleted AS is_deleted_11, a0_.program_info AS program_info_12, a0_.is_cleared_chargeto AS is_cleared_chargeto_13, a0_.is_check_printed AS is_check_printed_14, a0_.invoice_number AS invoice_number_15, a0_.advance AS advance_16, a0_.excempt AS excempt_17, a0_.credit_cleared AS credit_cleared_18, a0_.trailer_number AS trailer_number_19, p1_.id AS id_20, p1_.pro_number AS pro_number_21, p1_.accounts_id AS accounts_id_22, a2_.id AS id_23, a2_.name AS name_24, a2_.type AS type_25, a2_.gl_number AS gl_number_26, a2_.balance AS balance_27, a2_.is_chargeto AS is_chargeto_28, a2_.is_active AS is_active_29, a2_.budget AS budget_30, a0_.payment_account_transactions AS payment_account_transactions_31, a0_.pro_number_transactions AS pro_number_transactions_32, a0_.truck_id_transactions AS truck_id_transactions_33, a0_.accounts_id AS accounts_id_34, a0_.user_transactions AS user_transactions_35, a0_.charge_to_account AS charge_to_account_36, a0_.check_info AS check_info_37, a0_.drivers_id AS drivers_id_38, p1_.accounts_id AS accounts_id_39, a2_.accounts_id AS accounts_id_40 FROM accounting_transactions a0_ LEFT JOIN pro_numbers p1_ ON a0_.pro_number_transactions = p1_.id LEFT JOIN accounting_accounts a2_ ON a0_.charge_to_account = a2_.id WHERE a0_.accounts_id = ? AND a0_.drivers_id = ? AND a0_.is_deleted = 0 AND (a0_.program_info = ? OR ((a0_.program_info LIKE ? OR a0_.program_info LIKE ?) AND a0_.charge_to_account = ? AND a0_.charge_to_account NOT IN (?, ?))) ORDER BY a0_.date ASC, a0_.id ASC LIMIT 1

Parameters:

[
  2980
  23204
  "DRIVER REIMBURSE"
  "%07/11/2026"
  "%7/11/2026"
  146247
  146194
  198179
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.number AS number_1,
  a0_.date AS date_2,
  a0_.type AS type_3,
  a0_.amount AS amount_4,
  a0_.payment_method AS payment_method_5,
  a0_.check_number AS check_number_6,
  a0_.memo AS memo_7,
  a0_.is_reconciled AS is_reconciled_8,
  a0_.is_cleared AS is_cleared_9,
  a0_.timestamp AS timestamp_10,
  a0_.is_deleted AS is_deleted_11,
  a0_.program_info AS program_info_12,
  a0_.is_cleared_chargeto AS is_cleared_chargeto_13,
  a0_.is_check_printed AS is_check_printed_14,
  a0_.invoice_number AS invoice_number_15,
  a0_.advance AS advance_16,
  a0_.excempt AS excempt_17,
  a0_.credit_cleared AS credit_cleared_18,
  a0_.trailer_number AS trailer_number_19,
  p1_.id AS id_20,
  p1_.pro_number AS pro_number_21,
  p1_.accounts_id AS accounts_id_22,
  a2_.id AS id_23,
  a2_.name AS name_24,
  a2_.type AS type_25,
  a2_.gl_number AS gl_number_26,
  a2_.balance AS balance_27,
  a2_.is_chargeto AS is_chargeto_28,
  a2_.is_active AS is_active_29,
  a2_.budget AS budget_30,
  a0_.payment_account_transactions AS payment_account_transactions_31,
  a0_.pro_number_transactions AS pro_number_transactions_32,
  a0_.truck_id_transactions AS truck_id_transactions_33,
  a0_.accounts_id AS accounts_id_34,
  a0_.user_transactions AS user_transactions_35,
  a0_.charge_to_account AS charge_to_account_36,
  a0_.check_info AS check_info_37,
  a0_.drivers_id AS drivers_id_38,
  p1_.accounts_id AS accounts_id_39,
  a2_.accounts_id AS accounts_id_40
FROM
  accounting_transactions a0_
  LEFT JOIN pro_numbers p1_ ON a0_.pro_number_transactions = p1_.id
  LEFT JOIN accounting_accounts a2_ ON a0_.charge_to_account = a2_.id
WHERE
  a0_.accounts_id = ?
  AND a0_.drivers_id = ?
  AND a0_.is_deleted = 0
  AND (
    a0_.program_info = ?
    OR (
      (
        a0_.program_info LIKE ?
        OR a0_.program_info LIKE ?
      )
      AND a0_.charge_to_account = ?
      AND a0_.charge_to_account NOT IN (?, ?)
    )
  )
ORDER BY
  a0_.date ASC,
  a0_.id ASC
LIMIT
  1

SELECT a0_.id AS id_0, a0_.number AS number_1, a0_.date AS date_2, a0_.type AS type_3, a0_.amount AS amount_4, a0_.payment_method AS payment_method_5, a0_.check_number AS check_number_6, a0_.memo AS memo_7, a0_.is_reconciled AS is_reconciled_8, a0_.is_cleared AS is_cleared_9, a0_.timestamp AS timestamp_10, a0_.is_deleted AS is_deleted_11, a0_.program_info AS program_info_12, a0_.is_cleared_chargeto AS is_cleared_chargeto_13, a0_.is_check_printed AS is_check_printed_14, a0_.invoice_number AS invoice_number_15, a0_.advance AS advance_16, a0_.excempt AS excempt_17, a0_.credit_cleared AS credit_cleared_18, a0_.trailer_number AS trailer_number_19, p1_.id AS id_20, p1_.pro_number AS pro_number_21, p1_.accounts_id AS accounts_id_22, a2_.id AS id_23, a2_.name AS name_24, a2_.type AS type_25, a2_.gl_number AS gl_number_26, a2_.balance AS balance_27, a2_.is_chargeto AS is_chargeto_28, a2_.is_active AS is_active_29, a2_.budget AS budget_30, a0_.payment_account_transactions AS payment_account_transactions_31, a0_.pro_number_transactions AS pro_number_transactions_32, a0_.truck_id_transactions AS truck_id_transactions_33, a0_.accounts_id AS accounts_id_34, a0_.user_transactions AS user_transactions_35, a0_.charge_to_account AS charge_to_account_36, a0_.check_info AS check_info_37, a0_.drivers_id AS drivers_id_38, p1_.accounts_id AS accounts_id_39, a2_.accounts_id AS accounts_id_40 FROM accounting_transactions a0_ LEFT JOIN pro_numbers p1_ ON a0_.pro_number_transactions = p1_.id LEFT JOIN accounting_accounts a2_ ON a0_.charge_to_account = a2_.id WHERE a0_.accounts_id = 2980 AND a0_.drivers_id = 23204 AND a0_.is_deleted = 0 AND (a0_.program_info = 'DRIVER REIMBURSE' OR ((a0_.program_info LIKE '%07/11/2026' OR a0_.program_info LIKE '%7/11/2026') AND a0_.charge_to_account = 146247 AND a0_.charge_to_account NOT IN (146194, 198179))) ORDER BY a0_.date ASC, a0_.id ASC LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\AccountingTransactionsRepository->findOutstandingReimbursementsForDriverWeek (line 71)
7	App\Service\Payroll\PayrollProcessingService->getReimbursementsByWeek (line 2633)
8	App\Controller\Payroll\PayrollProcessingController->index (line 330)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 208)
12	handle (line 26)

0.08 ms
(1.83%)

SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.period AS period_2, p0_.allow_amount AS allow_amount_3, p0_.status AS status_4, p0_.is_over AS is_over_5, p0_.is_under AS is_under_6, p0_.base AS base_7, p0_.perc AS perc_8, p0_.state AS state_9, p0_.state_stded AS state_stded_10 FROM payroll_federal_tax p0_ WHERE p0_.type = ? AND p0_.period = ? ORDER BY p0_.is_over ASC

Parameters:

[
  "FED 26"
  "WEEKLY"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.type AS type_1,
  p0_.period AS period_2,
  p0_.allow_amount AS allow_amount_3,
  p0_.status AS status_4,
  p0_.is_over AS is_over_5,
  p0_.is_under AS is_under_6,
  p0_.base AS base_7,
  p0_.perc AS perc_8,
  p0_.state AS state_9,
  p0_.state_stded AS state_stded_10
FROM
  payroll_federal_tax p0_
WHERE
  p0_.type = ?
  AND p0_.period = ?
ORDER BY
  p0_.is_over ASC

SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.period AS period_2, p0_.allow_amount AS allow_amount_3, p0_.status AS status_4, p0_.is_over AS is_over_5, p0_.is_under AS is_under_6, p0_.base AS base_7, p0_.perc AS perc_8, p0_.state AS state_9, p0_.state_stded AS state_stded_10 FROM payroll_federal_tax p0_ WHERE p0_.type = 'FED 26' AND p0_.period = 'WEEKLY' ORDER BY p0_.is_over ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\PayrollFederalTaxRepository->findByTypeAndPeriod (line 74)
7	App\Service\Payroll\TaxCalculationService->calculateFederalTax (line 343)
8	App\Service\Payroll\TaxCalculationService->calculateDriverTaxes (line 105)
9	App\Service\Payroll\PayrollProcessingService->calculatePayrollSummary (line 913)
10	App\Controller\Payroll\PayrollProcessingController->index (line 354)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 208)
14	handle (line 26)

0.08 ms
(1.81%)

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.type AS type_2, a0_.gl_number AS gl_number_3, a0_.balance AS balance_4, a0_.is_chargeto AS is_chargeto_5, a0_.is_active AS is_active_6, a0_.budget AS budget_7, a0_.accounts_id AS accounts_id_8 FROM accounting_accounts a0_ WHERE a0_.accounts_id = ? AND a0_.type IN (?, ?, ?) AND a0_.is_active = 1 ORDER BY a0_.name ASC

Parameters:

[
  2980
  "cash"
  "check"
  "savings"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.type AS type_2,
  a0_.gl_number AS gl_number_3,
  a0_.balance AS balance_4,
  a0_.is_chargeto AS is_chargeto_5,
  a0_.is_active AS is_active_6,
  a0_.budget AS budget_7,
  a0_.accounts_id AS accounts_id_8
FROM
  accounting_accounts a0_
WHERE
  a0_.accounts_id = ?
  AND a0_.type IN (?, ?, ?)
  AND a0_.is_active = 1
ORDER BY
  a0_.name ASC

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.type AS type_2, a0_.gl_number AS gl_number_3, a0_.balance AS balance_4, a0_.is_chargeto AS is_chargeto_5, a0_.is_active AS is_active_6, a0_.budget AS budget_7, a0_.accounts_id AS accounts_id_8 FROM accounting_accounts a0_ WHERE a0_.accounts_id = 2980 AND a0_.type IN ('cash', 'check', 'savings') AND a0_.is_active = 1 ORDER BY a0_.name ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Service\Payroll\PayrollProcessingService->getPaymentAccounts (line 331)
7	App\Controller\Payroll\PayrollProcessingController->index (line 371)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 208)
11	handle (line 26)

0.07 ms
(1.57%)

SELECT a0_.id AS id_0, a0_.number AS number_1, a0_.date AS date_2, a0_.type AS type_3, a0_.amount AS amount_4, a0_.payment_method AS payment_method_5, a0_.check_number AS check_number_6, a0_.memo AS memo_7, a0_.is_reconciled AS is_reconciled_8, a0_.is_cleared AS is_cleared_9, a0_.timestamp AS timestamp_10, a0_.is_deleted AS is_deleted_11, a0_.program_info AS program_info_12, a0_.is_cleared_chargeto AS is_cleared_chargeto_13, a0_.is_check_printed AS is_check_printed_14, a0_.invoice_number AS invoice_number_15, a0_.advance AS advance_16, a0_.excempt AS excempt_17, a0_.credit_cleared AS credit_cleared_18, a0_.trailer_number AS trailer_number_19, p1_.id AS id_20, p1_.pro_number AS pro_number_21, p1_.accounts_id AS accounts_id_22, a2_.id AS id_23, a2_.name AS name_24, a2_.type AS type_25, a2_.gl_number AS gl_number_26, a2_.balance AS balance_27, a2_.is_chargeto AS is_chargeto_28, a2_.is_active AS is_active_29, a2_.budget AS budget_30, a0_.payment_account_transactions AS payment_account_transactions_31, a0_.pro_number_transactions AS pro_number_transactions_32, a0_.truck_id_transactions AS truck_id_transactions_33, a0_.accounts_id AS accounts_id_34, a0_.user_transactions AS user_transactions_35, a0_.charge_to_account AS charge_to_account_36, a0_.check_info AS check_info_37, a0_.drivers_id AS drivers_id_38, p1_.accounts_id AS accounts_id_39, a2_.accounts_id AS accounts_id_40 FROM accounting_transactions a0_ LEFT JOIN pro_numbers p1_ ON a0_.pro_number_transactions = p1_.id LEFT JOIN accounting_accounts a2_ ON a0_.charge_to_account = a2_.id WHERE a0_.accounts_id = ? AND a0_.drivers_id = ? AND a0_.is_deleted = 0 AND (a0_.program_info = ? OR ((a0_.program_info LIKE ? OR a0_.program_info LIKE ?) AND a0_.charge_to_account = ? AND a0_.charge_to_account NOT IN (?, ?))) AND (a0_.date BETWEEN ? AND ?) AND a0_.program_info NOT LIKE ? ORDER BY a0_.date ASC, a0_.id ASC

Parameters:

[
  2980
  23204
  "DRIVER REIMBURSE"
  "%07/11/2026"
  "%7/11/2026"
  146247
  146194
  198179
  "2026-07-05 00:00:00"
  "2026-07-11 23:59:59"
  "SETTLED%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.number AS number_1,
  a0_.date AS date_2,
  a0_.type AS type_3,
  a0_.amount AS amount_4,
  a0_.payment_method AS payment_method_5,
  a0_.check_number AS check_number_6,
  a0_.memo AS memo_7,
  a0_.is_reconciled AS is_reconciled_8,
  a0_.is_cleared AS is_cleared_9,
  a0_.timestamp AS timestamp_10,
  a0_.is_deleted AS is_deleted_11,
  a0_.program_info AS program_info_12,
  a0_.is_cleared_chargeto AS is_cleared_chargeto_13,
  a0_.is_check_printed AS is_check_printed_14,
  a0_.invoice_number AS invoice_number_15,
  a0_.advance AS advance_16,
  a0_.excempt AS excempt_17,
  a0_.credit_cleared AS credit_cleared_18,
  a0_.trailer_number AS trailer_number_19,
  p1_.id AS id_20,
  p1_.pro_number AS pro_number_21,
  p1_.accounts_id AS accounts_id_22,
  a2_.id AS id_23,
  a2_.name AS name_24,
  a2_.type AS type_25,
  a2_.gl_number AS gl_number_26,
  a2_.balance AS balance_27,
  a2_.is_chargeto AS is_chargeto_28,
  a2_.is_active AS is_active_29,
  a2_.budget AS budget_30,
  a0_.payment_account_transactions AS payment_account_transactions_31,
  a0_.pro_number_transactions AS pro_number_transactions_32,
  a0_.truck_id_transactions AS truck_id_transactions_33,
  a0_.accounts_id AS accounts_id_34,
  a0_.user_transactions AS user_transactions_35,
  a0_.charge_to_account AS charge_to_account_36,
  a0_.check_info AS check_info_37,
  a0_.drivers_id AS drivers_id_38,
  p1_.accounts_id AS accounts_id_39,
  a2_.accounts_id AS accounts_id_40
FROM
  accounting_transactions a0_
  LEFT JOIN pro_numbers p1_ ON a0_.pro_number_transactions = p1_.id
  LEFT JOIN accounting_accounts a2_ ON a0_.charge_to_account = a2_.id
WHERE
  a0_.accounts_id = ?
  AND a0_.drivers_id = ?
  AND a0_.is_deleted = 0
  AND (
    a0_.program_info = ?
    OR (
      (
        a0_.program_info LIKE ?
        OR a0_.program_info LIKE ?
      )
      AND a0_.charge_to_account = ?
      AND a0_.charge_to_account NOT IN (?, ?)
    )
  )
  AND (
    a0_.date BETWEEN ?
    AND ?
  )
  AND a0_.program_info NOT LIKE ?
ORDER BY
  a0_.date ASC,
  a0_.id ASC

SELECT a0_.id AS id_0, a0_.number AS number_1, a0_.date AS date_2, a0_.type AS type_3, a0_.amount AS amount_4, a0_.payment_method AS payment_method_5, a0_.check_number AS check_number_6, a0_.memo AS memo_7, a0_.is_reconciled AS is_reconciled_8, a0_.is_cleared AS is_cleared_9, a0_.timestamp AS timestamp_10, a0_.is_deleted AS is_deleted_11, a0_.program_info AS program_info_12, a0_.is_cleared_chargeto AS is_cleared_chargeto_13, a0_.is_check_printed AS is_check_printed_14, a0_.invoice_number AS invoice_number_15, a0_.advance AS advance_16, a0_.excempt AS excempt_17, a0_.credit_cleared AS credit_cleared_18, a0_.trailer_number AS trailer_number_19, p1_.id AS id_20, p1_.pro_number AS pro_number_21, p1_.accounts_id AS accounts_id_22, a2_.id AS id_23, a2_.name AS name_24, a2_.type AS type_25, a2_.gl_number AS gl_number_26, a2_.balance AS balance_27, a2_.is_chargeto AS is_chargeto_28, a2_.is_active AS is_active_29, a2_.budget AS budget_30, a0_.payment_account_transactions AS payment_account_transactions_31, a0_.pro_number_transactions AS pro_number_transactions_32, a0_.truck_id_transactions AS truck_id_transactions_33, a0_.accounts_id AS accounts_id_34, a0_.user_transactions AS user_transactions_35, a0_.charge_to_account AS charge_to_account_36, a0_.check_info AS check_info_37, a0_.drivers_id AS drivers_id_38, p1_.accounts_id AS accounts_id_39, a2_.accounts_id AS accounts_id_40 FROM accounting_transactions a0_ LEFT JOIN pro_numbers p1_ ON a0_.pro_number_transactions = p1_.id LEFT JOIN accounting_accounts a2_ ON a0_.charge_to_account = a2_.id WHERE a0_.accounts_id = 2980 AND a0_.drivers_id = 23204 AND a0_.is_deleted = 0 AND (a0_.program_info = 'DRIVER REIMBURSE' OR ((a0_.program_info LIKE '%07/11/2026' OR a0_.program_info LIKE '%7/11/2026') AND a0_.charge_to_account = 146247 AND a0_.charge_to_account NOT IN (146194, 198179))) AND (a0_.date BETWEEN '2026-07-05 00:00:00' AND '2026-07-11 23:59:59') AND a0_.program_info NOT LIKE 'SETTLED%' ORDER BY a0_.date ASC, a0_.id ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\AccountingTransactionsRepository->findOutstandingReimbursementsDatedInWeek (line 182)
7	App\Service\Payroll\PayrollProcessingService->getReimbursementsForWeekSettlement (line 2766)
8	App\Service\Payroll\PayrollProcessingService->calculatePayrollSummary (line 870)
9	App\Controller\Payroll\PayrollProcessingController->index (line 354)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 208)
13	handle (line 26)

0.07 ms
(1.57%)

SELECT t0_.id AS id_0, t0_.make AS make_1, t0_.model AS model_2, t0_.year AS year_3, t0_.vin AS vin_4, t0_.license AS license_5, t0_.weight AS weight_6, t0_.tire_size AS tire_size_7, t0_.haul_weight AS haul_weight_8, t0_.interval_oil_change AS interval_oil_change_9, t0_.interval_lube AS interval_lube_10, t0_.interval_full_inspection AS interval_full_inspection_11, t0_.ifta_exemption AS ifta_exemption_12, t0_.esn AS esn_13, t0_.notes AS notes_14, t0_.is_active AS is_active_15, t0_.is_deleted AS is_deleted_16, t0_.truck_number AS truck_number_17, t0_.accounts_id AS accounts_id_18, t0_.truck_financial_id AS truck_financial_id_19, t0_.accounts_id AS accounts_id_20, t0_.truck_financial_id AS truck_financial_id_21 FROM trucks t0_ WHERE t0_.accounts_id = ? AND t0_.is_deleted = 0 ORDER BY t0_.truck_number ASC

Parameters:

[
  2980
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.make AS make_1,
  t0_.model AS model_2,
  t0_.year AS year_3,
  t0_.vin AS vin_4,
  t0_.license AS license_5,
  t0_.weight AS weight_6,
  t0_.tire_size AS tire_size_7,
  t0_.haul_weight AS haul_weight_8,
  t0_.interval_oil_change AS interval_oil_change_9,
  t0_.interval_lube AS interval_lube_10,
  t0_.interval_full_inspection AS interval_full_inspection_11,
  t0_.ifta_exemption AS ifta_exemption_12,
  t0_.esn AS esn_13,
  t0_.notes AS notes_14,
  t0_.is_active AS is_active_15,
  t0_.is_deleted AS is_deleted_16,
  t0_.truck_number AS truck_number_17,
  t0_.accounts_id AS accounts_id_18,
  t0_.truck_financial_id AS truck_financial_id_19,
  t0_.accounts_id AS accounts_id_20,
  t0_.truck_financial_id AS truck_financial_id_21
FROM
  trucks t0_
WHERE
  t0_.accounts_id = ?
  AND t0_.is_deleted = 0
ORDER BY
  t0_.truck_number ASC

SELECT t0_.id AS id_0, t0_.make AS make_1, t0_.model AS model_2, t0_.year AS year_3, t0_.vin AS vin_4, t0_.license AS license_5, t0_.weight AS weight_6, t0_.tire_size AS tire_size_7, t0_.haul_weight AS haul_weight_8, t0_.interval_oil_change AS interval_oil_change_9, t0_.interval_lube AS interval_lube_10, t0_.interval_full_inspection AS interval_full_inspection_11, t0_.ifta_exemption AS ifta_exemption_12, t0_.esn AS esn_13, t0_.notes AS notes_14, t0_.is_active AS is_active_15, t0_.is_deleted AS is_deleted_16, t0_.truck_number AS truck_number_17, t0_.accounts_id AS accounts_id_18, t0_.truck_financial_id AS truck_financial_id_19, t0_.accounts_id AS accounts_id_20, t0_.truck_financial_id AS truck_financial_id_21 FROM trucks t0_ WHERE t0_.accounts_id = 2980 AND t0_.is_deleted = 0 ORDER BY t0_.truck_number ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\TrucksRepository->findByAccountId (line 342)
7	App\Service\Payroll\PayrollProcessingService->getAvailableTrucks (line 300)
8	App\Controller\Payroll\PayrollProcessingController->index (line 366)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 208)
12	handle (line 26)

0.06 ms
(1.36%)

SELECT DISTINCT p0_.week_end AS week_end_0 FROM payroll_miles_paid p0_ WHERE p0_.accounts_id = ? AND p0_.week_end IS NOT NULL AND p0_.driver_id = ? ORDER BY p0_.week_end DESC LIMIT 12

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT p0_.week_end AS week_end_0
FROM
  payroll_miles_paid p0_
WHERE
  p0_.accounts_id = ?
  AND p0_.week_end IS NOT NULL
  AND p0_.driver_id = ?
ORDER BY
  p0_.week_end DESC
LIMIT
  12

SELECT DISTINCT p0_.week_end AS week_end_0 FROM payroll_miles_paid p0_ WHERE p0_.accounts_id = 2980 AND p0_.week_end IS NOT NULL AND p0_.driver_id = 23204 ORDER BY p0_.week_end DESC LIMIT 12;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\PayrollmilespaidRepository->getRecentWeekEnds (line 202)
7	App\Service\Payroll\PayrollProcessingService->getRecentPayrollWeeks (line 366)
8	App\Controller\Payroll\PayrollProcessingController->index (line 361)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 208)
12	handle (line 26)

0.06 ms
(1.31%)

SELECT t0.id AS id_1, t0.street AS street_2, t0.street2 AS street2_3, t0.city AS city_4, t0.state AS state_5, t0.zip_code AS zip_code_6, t0.country AS country_7, t0.first_name AS first_name_8, t0.middle_name AS middle_name_9, t0.last_name AS last_name_10, t0.phone_primary AS phone_primary_11, t0.phone_secondary AS phone_secondary_12, t0.phone_fax AS phone_fax_13, t0.type AS type_14, t0.extension1 AS extension1_15, t0.extension2 AS extension2_16, t0.account_id_address AS account_id_address_17 FROM addresses t0 WHERE t0.id = ?

Parameters:

[
  910565
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.street AS street_2,
  t0.street2 AS street2_3,
  t0.city AS city_4,
  t0.state AS state_5,
  t0.zip_code AS zip_code_6,
  t0.country AS country_7,
  t0.first_name AS first_name_8,
  t0.middle_name AS middle_name_9,
  t0.last_name AS last_name_10,
  t0.phone_primary AS phone_primary_11,
  t0.phone_secondary AS phone_secondary_12,
  t0.phone_fax AS phone_fax_13,
  t0.type AS type_14,
  t0.extension1 AS extension1_15,
  t0.extension2 AS extension2_16,
  t0.account_id_address AS account_id_address_17
FROM
  addresses t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.street AS street_2, t0.street2 AS street2_3, t0.city AS city_4, t0.state AS state_5, t0.zip_code AS zip_code_6, t0.country AS country_7, t0.first_name AS first_name_8, t0.middle_name AS middle_name_9, t0.last_name AS last_name_10, t0.phone_primary AS phone_primary_11, t0.phone_secondary AS phone_secondary_12, t0.phone_fax AS phone_fax_13, t0.type AS type_14, t0.extension1 AS extension1_15, t0.extension2 AS extension2_16, t0.account_id_address AS account_id_address_17 FROM addresses t0 WHERE t0.id = 910565;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	App\Service\Payroll\PayrollProcessingService->getDriverDetails (line 196)
7	App\Controller\Payroll\PayrollProcessingController->index (line 260)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 208)
11	handle (line 26)

0.06 ms
(1.31%)

SELECT t0_.truck_number AS truck_number_0 FROM payroll_miles_paid p1_ LEFT JOIN trucks t0_ ON p1_.truck_id = t0_.id WHERE p1_.accounts_id = ? AND p1_.driver_id = ? AND (p1_.week_end BETWEEN ? AND ?) ORDER BY p1_.id DESC LIMIT 1

Parameters:

[
  2980
  23204
  "2026-07-11 00:00:00"
  "2026-07-11 23:59:59"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.truck_number AS truck_number_0
FROM
  payroll_miles_paid p1_
  LEFT JOIN trucks t0_ ON p1_.truck_id = t0_.id
WHERE
  p1_.accounts_id = ?
  AND p1_.driver_id = ?
  AND (
    p1_.week_end BETWEEN ?
    AND ?
  )
ORDER BY
  p1_.id DESC
LIMIT
  1

SELECT t0_.truck_number AS truck_number_0 FROM payroll_miles_paid p1_ LEFT JOIN trucks t0_ ON p1_.truck_id = t0_.id WHERE p1_.accounts_id = 2980 AND p1_.driver_id = 23204 AND (p1_.week_end BETWEEN '2026-07-11 00:00:00' AND '2026-07-11 23:59:59') ORDER BY p1_.id DESC LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Service\Payroll\PayrollProcessingService->getTruckAndPaymentNumber (line 247)
7	App\Controller\Payroll\PayrollProcessingController->index (line 270)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 208)
11	handle (line 26)

0.06 ms
(1.31%)

SELECT COUNT(a0_.id) AS sclr_0 FROM accounting_transactions a0_ WHERE a0_.accounts_id = ? AND a0_.drivers_id = ? AND a0_.is_deleted = 0 AND (a0_.program_info = ? OR ((a0_.program_info LIKE ? OR a0_.program_info LIKE ?) AND a0_.charge_to_account = ? AND a0_.charge_to_account NOT IN (?, ?)))

Parameters:

[
  2980
  23204
  "DRIVER REIMBURSE"
  "%07/11/2026"
  "%7/11/2026"
  146247
  146194
  198179
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  accounting_transactions a0_
WHERE
  a0_.accounts_id = ?
  AND a0_.drivers_id = ?
  AND a0_.is_deleted = 0
  AND (
    a0_.program_info = ?
    OR (
      (
        a0_.program_info LIKE ?
        OR a0_.program_info LIKE ?
      )
      AND a0_.charge_to_account = ?
      AND a0_.charge_to_account NOT IN (?, ?)
    )
  )

SELECT COUNT(a0_.id) AS sclr_0 FROM accounting_transactions a0_ WHERE a0_.accounts_id = 2980 AND a0_.drivers_id = 23204 AND a0_.is_deleted = 0 AND (a0_.program_info = 'DRIVER REIMBURSE' OR ((a0_.program_info LIKE '%07/11/2026' OR a0_.program_info LIKE '%7/11/2026') AND a0_.charge_to_account = 146247 AND a0_.charge_to_account NOT IN (146194, 198179)));

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Repository\AccountingTransactionsRepository->countOutstandingReimbursementsForDriverWeek (line 102)
8	App\Service\Payroll\PayrollProcessingService->getReimbursementsCount (line 2699)
9	App\Controller\Payroll\PayrollProcessingController->index (line 337)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 208)
13	handle (line 26)

0.05 ms
(1.27%)

SELECT t0.id AS id_1, t0.week_end AS week_end_2, t0.amount AS amount_3, t0.memo AS memo_4, t0.pymnt_for AS pymnt_for_5, t0.trucks_id AS trucks_id_6, t0.accounts_id AS accounts_id_7, t0.pro_numbers_id AS pro_numbers_id_8, t0.trucks_id AS trucks_id_9, t0.accounts_id AS accounts_id_10, t0.pro_numbers_id AS pro_numbers_id_11 FROM settlements_otherpay t0 WHERE t0.accounts_id = ? AND t0.trucks_id = ? AND t0.week_end = ? AND t0.pymnt_for = ? ORDER BY t0.id DESC

Parameters:

[
  2980
  23469
  "2026-07-11"
  "surcharge"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.week_end AS week_end_2,
  t0.amount AS amount_3,
  t0.memo AS memo_4,
  t0.pymnt_for AS pymnt_for_5,
  t0.trucks_id AS trucks_id_6,
  t0.accounts_id AS accounts_id_7,
  t0.pro_numbers_id AS pro_numbers_id_8,
  t0.trucks_id AS trucks_id_9,
  t0.accounts_id AS accounts_id_10,
  t0.pro_numbers_id AS pro_numbers_id_11
FROM
  settlements_otherpay t0
WHERE
  t0.accounts_id = ?
  AND t0.trucks_id = ?
  AND t0.week_end = ?
  AND t0.pymnt_for = ?
ORDER BY
  t0.id DESC

SELECT t0.id AS id_1, t0.week_end AS week_end_2, t0.amount AS amount_3, t0.memo AS memo_4, t0.pymnt_for AS pymnt_for_5, t0.trucks_id AS trucks_id_6, t0.accounts_id AS accounts_id_7, t0.pro_numbers_id AS pro_numbers_id_8, t0.trucks_id AS trucks_id_9, t0.accounts_id AS accounts_id_10, t0.pro_numbers_id AS pro_numbers_id_11 FROM settlements_otherpay t0 WHERE t0.accounts_id = 2980 AND t0.trucks_id = 23469 AND t0.week_end = '2026-07-11' AND t0.pymnt_for = 'surcharge' ORDER BY t0.id DESC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Controller\Payroll\PayrollProcessingController->index (line 309)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 208)
8	handle (line 26)

0.05 ms
(1.20%)

SELECT p0_.pmnt_no AS pmnt_no_0 FROM payroll_paid p0_ WHERE p0_.accounts_id = ? AND p0_.drivers_id = ? ORDER BY p0_.pay_date DESC LIMIT 1

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.pmnt_no AS pmnt_no_0
FROM
  payroll_paid p0_
WHERE
  p0_.accounts_id = ?
  AND p0_.drivers_id = ?
ORDER BY
  p0_.pay_date DESC
LIMIT
  1

SELECT p0_.pmnt_no AS pmnt_no_0 FROM payroll_paid p0_ WHERE p0_.accounts_id = 2980 AND p0_.drivers_id = 23204 ORDER BY p0_.pay_date DESC LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Service\Payroll\PayrollProcessingService->getTruckAndPaymentNumber (line 264)
7	App\Controller\Payroll\PayrollProcessingController->index (line 270)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 208)
11	handle (line 26)

0.05 ms
(1.15%)

SELECT COUNT(a0_.id) AS sclr_0 FROM accounting_transactions a0_ WHERE a0_.accounts_id = ? AND a0_.drivers_id = ? AND a0_.is_deleted = 0 AND (a0_.program_info = ? OR ((a0_.program_info LIKE ? OR a0_.program_info LIKE ?) AND a0_.charge_to_account = ? AND a0_.charge_to_account NOT IN (?, ?))) AND a0_.program_info NOT LIKE ?

Parameters:

[
  2980
  23204
  "DRIVER REIMBURSE"
  "%07/11/2026"
  "%7/11/2026"
  146247
  146194
  198179
  "SETTLED%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  accounting_transactions a0_
WHERE
  a0_.accounts_id = ?
  AND a0_.drivers_id = ?
  AND a0_.is_deleted = 0
  AND (
    a0_.program_info = ?
    OR (
      (
        a0_.program_info LIKE ?
        OR a0_.program_info LIKE ?
      )
      AND a0_.charge_to_account = ?
      AND a0_.charge_to_account NOT IN (?, ?)
    )
  )
  AND a0_.program_info NOT LIKE ?

SELECT COUNT(a0_.id) AS sclr_0 FROM accounting_transactions a0_ WHERE a0_.accounts_id = 2980 AND a0_.drivers_id = 23204 AND a0_.is_deleted = 0 AND (a0_.program_info = 'DRIVER REIMBURSE' OR ((a0_.program_info LIKE '%07/11/2026' OR a0_.program_info LIKE '%7/11/2026') AND a0_.charge_to_account = 146247 AND a0_.charge_to_account NOT IN (146194, 198179))) AND a0_.program_info NOT LIKE 'SETTLED%';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Repository\AccountingTransactionsRepository->countOutstandingReimbursementsForDriverWeek (line 102)
8	App\Service\Payroll\PayrollProcessingService->hasUnpaidReimbursementsForWeek (line 2729)
9	App\Controller\Payroll\PayrollProcessingController->index (line 346)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 208)
13	handle (line 26)

Database Connections

Name	Service
default	doctrine.dbal.default_connection
sessions	doctrine.dbal.sessions_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
sessions	doctrine.orm.sessions_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\ProNumbers	500
App\Entity\AccountingAccounts	138
App\Entity\Trucks	31
App\Entity\PayrollPaid	25
App\Entity\TrucksFinancials	18
App\Entity\PayrollFederalTax	14
App\Entity\Drivers	10
App\Entity\Addresses	2
App\Entity\Users	1
App\Entity\Accounts	1
App\Entity\UserPreferences	1
App\Entity\Payroll	1
App\Entity\NelcoCredentials	1

sessions entity manager

Class	Amount of managed objects

Entities Mapping

default entity manager

Class	Mapping errors
App\Entity\Users	No errors.
App\Entity\Accounts	No errors.
App\Entity\UserPreferences	No errors.
App\Entity\Drivers	No errors.
App\Entity\Payroll	No errors.
App\Entity\Customers	No errors.
App\Entity\Addresses	No errors.
App\Entity\PayrollMilesPaid	No errors.
App\Entity\Trucks	No errors.
App\Entity\PayrollPaid	No errors.
App\Entity\ProNumbers	No errors.
App\Entity\Miles	No errors.
App\Entity\PayrollOtherPaid	No errors.
App\Entity\SettlementsOtherpay	No errors.
App\Entity\PayrollDeductionsTaken	No errors.
App\Entity\AccountingAccounts	No errors.
App\Entity\AccountingTransactions	No errors.
App\Entity\PayrollFederalTax	No errors.
App\Entity\TrucksFinancials	No errors.
App\Entity\NelcoCredentials	No errors.

sessions entity manager

No loaded entities.

Symfony Profiler

GET https://app.george.truckershelper.net/payroll/run/?payroll_processing_form%5Bdriver_id%5D=23204&payroll_processing_form%5Bweek_end%5D=2026-07-11

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

sessions entity manager

Entities Mapping

default entity manager

sessions entity manager