Symfony Profiler

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

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 = 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c2VyX2lkIjoxLCJlbWFpbCI6InVzZXIxQHRlc3RpbmcubG9jYWwiLCJpYXQiOjE3ODk3NjgwODUsImV4cCI6MTc5MDM3Mjg4NX0.79_ZEnnCzKaIo9hmAN-F1VNhwcvn21s-H9CI14OgMHY' LIMIT 1;

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 = ?

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 = 1;

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

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 = 1 AND f2_.function_id = 10 ORDER BY u0_.id ASC LIMIT 1;

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 = ?

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 = 70;

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

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 = 70 AND d0_.date = '2026-09-18' ORDER BY d0_.id DESC LIMIT 1;

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 = ?

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 = 5;

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

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 = 4482 ORDER BY d0_.id ASC;

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 = ?

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 = 1;

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

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 = 4482 ORDER BY d0_.name ASC;

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

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 = 4482 ORDER BY d0_.id ASC;

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 = ?

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 = 521;

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 = ?

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 = 106;

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 = ?

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 = 523;

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 = ?

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 = 41;

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 = ?