Symfony Profiler

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

SELECT
  d0_.id AS id_0,
  d0_.conc_vendor AS conc_vendor_1,
  d0_.total_conc_used AS total_conc_used_2,
  d0_.conc_price AS conc_price_3,
  d0_.data_tracking_id AS data_tracking_id_4,
  d0_.vendor_id AS vendor_id_5,
  d0_.city_id AS city_id_6
FROM
  data_tracking_conc_vendor d0_
  LEFT JOIN data_tracking d1_ ON d0_.data_tracking_id = d1_.id
WHERE
  d1_.id = ?
ORDER BY
  d0_.id ASC

SELECT d0_.id AS id_0, d0_.conc_vendor AS conc_vendor_1, d0_.total_conc_used AS total_conc_used_2, d0_.conc_price AS conc_price_3, d0_.data_tracking_id AS data_tracking_id_4, d0_.vendor_id AS vendor_id_5, d0_.city_id AS city_id_6 FROM data_tracking_conc_vendor d0_ LEFT JOIN data_tracking d1_ ON d0_.data_tracking_id = d1_.id WHERE d1_.id = 4483 ORDER BY d0_.id ASC;

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

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 = ?
ORDER BY
  d0_.date DESC,
  d0_.id DESC
LIMIT
  20

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 = 127 ORDER BY d0_.date DESC, d0_.id DESC LIMIT 20;

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.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.eyJ1c2VyX2lkIjoxLCJlbWFpbCI6InVzZXIxQHRlc3RpbmcubG9jYWwiLCJpYXQiOjE3ODk4NzQ2NDksImV4cCI6MTc5MDQ3OTQ0OX0.oKhl8vVWiUu_-tlA336yy7zYW5ZgIHXm0WzSkaGdCsY' 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
  COUNT(d0_.id) AS sclr_0
FROM
  data_tracking d0_
  INNER JOIN project p1_ ON d0_.project_id = p1_.project_id
WHERE
  p1_.project_id = ?

SELECT COUNT(d0_.id) AS sclr_0 FROM data_tracking d0_ INNER JOIN project p1_ ON d0_.project_id = p1_.project_id WHERE p1_.project_id = 127;