Query Metrics
45
Database Queries
22
Different statements
13.75 ms
Query time
0
Invalid entities
411
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
3.25 ms (23.66%) |
11 |
SELECT s0_.subcontractor_employee_id AS subcontractor_employee_id_0, s0_.name AS name_1, s0_.hourly_rate AS hourly_rate_2, s0_.position AS position_3, s0_.subcontractor_id AS subcontractor_id_4 FROM subcontractor_employee s0_ LEFT JOIN subcontractor s1_ ON s0_.subcontractor_id = s1_.subcontractor_id WHERE s1_.subcontractor_id = ? ORDER BY s0_.name ASC
Parameters:
[
11
]
|
||||||||||||||||||||||||||||||||||
|
1.38 ms (10.01%) |
7 |
SELECT t0.role_id AS role_id_1, t0.description AS description_2, t0.status AS status_3 FROM employee_role t0 WHERE t0.role_id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||||
|
0.98 ms (7.09%) |
4 |
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 = ?
Parameters:
[
521
]
|
||||||||||||||||||||||||||||||||||
|
0.88 ms (6.38%) |
4 |
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 = ?
Parameters:
[
106
]
|
||||||||||||||||||||||||||||||||||
|
0.87 ms (6.32%) |
1 |
SELECT e0_.employee_id AS employee_id_0, e0_.name AS name_1, e0_.nickname AS nickname_2, e0_.hourly_rate AS hourly_rate_3, e0_.position AS position_4, e0_.color AS color_5, e0_.address AS address_6, e0_.phone AS phone_7, e0_.cert_rate_type AS cert_rate_type_8, e0_.social_security_number AS social_security_number_9, e0_.apprentice_percentage AS apprentice_percentage_10, e0_.work_code AS work_code_11, e0_.gender AS gender_12, e0_.date_hired AS date_hired_13, e0_.date_terminated AS date_terminated_14, e0_.reason_terminated AS reason_terminated_15, e0_.time_card_notes AS time_card_notes_16, e0_.regular_rate_per_hour AS regular_rate_per_hour_17, e0_.overtime_rate_per_hour AS overtime_rate_per_hour_18, e0_.special_rate_per_hour AS special_rate_per_hour_19, e0_.trade_licenses_info AS trade_licenses_info_20, e0_.notes AS notes_21, e0_.is_osha_10_certified AS is_osha_10_certified_22, e0_.is_veteran AS is_veteran_23, e0_.status AS status_24, e0_.federal_filing_status AS federal_filing_status_25, e0_.federal_allowances AS federal_allowances_26, e0_.federal_additional_withholding AS federal_additional_withholding_27, e0_.w4_2020_or_later AS w4_2020_or_later_28, e0_.w4_multiple_jobs_step2 AS w4_multiple_jobs_step2_29, e0_.w4_dependents_amount AS w4_dependents_amount_30, e0_.w4_other_income_less_deductions AS w4_other_income_less_deductions_31, e0_.nonresident_alien AS nonresident_alien_32, e0_.do_not_withhold_fit AS do_not_withhold_fit_33, e0_.do_not_withhold_fica AS do_not_withhold_fica_34, e0_.role_id AS role_id_35, e0_.race_id AS race_id_36 FROM employee e0_ LEFT JOIN employee_role e1_ ON e0_.role_id = e1_.role_id WHERE e0_.status = 1 ORDER BY e0_.name ASC
Parameters:
[] |
||||||||||||||||||||||||||||||||||
|
0.61 ms (4.41%) |
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
Parameters:
[ 1 10 ] |
||||||||||||||||||||||||||||||||||
|
0.60 ms (4.40%) |
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
Parameters:
[
"eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c2VyX2lkIjoxLCJlbWFpbCI6InVzZXIxQHRlc3RpbmcubG9jYWwiLCJpYXQiOjE3ODk3NjgwODUsImV4cCI6MTc5MDM3Mjg4NX0.79_ZEnnCzKaIo9hmAN-F1VNhwcvn21s-H9CI14OgMHY"
]
|
||||||||||||||||||||||||||||||||||
|
0.49 ms (3.56%) |
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 = ?
Parameters:
[
70
]
|
||||||||||||||||||||||||||||||||||
|
0.42 ms (3.06%) |
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 = ? AND d0_.date = ? ORDER BY d0_.id DESC LIMIT 1
Parameters:
[ 70 "2026-09-18" ]
|
||||||||||||||||||||||||||||||||||
|
0.41 ms (3.02%) |
2 |
SELECT t0.vendor_id AS vendor_id_1, t0.name AS name_2, t0.phone AS phone_3, t0.address AS address_4, t0.contact_name AS contact_name_5, t0.contact_email AS contact_email_6 FROM concrete_vendor t0 WHERE t0.vendor_id = ?
Parameters:
[
32
]
|
||||||||||||||||||||||||||||||||||
|
0.41 ms (2.95%) |
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 = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||||
|
0.39 ms (2.86%) |
1 |
SELECT c0_.county_id AS county_id_0, c0_.description AS description_1, c0_.city AS city_2, c0_.status AS status_3, c0_.latitude AS latitude_4, c0_.longitude AS longitude_5, c0_.district_id AS district_id_6, c0_.state_id AS state_id_7 FROM county c0_ LEFT JOIN district d1_ ON c0_.district_id = d1_.district_id WHERE c0_.city IS NOT NULL AND TRIM(c0_.city) <> ? AND c0_.status = ? ORDER BY c0_.city ASC
Parameters:
[
""
1
]
|
||||||||||||||||||||||||||||||||||
|
0.34 ms (2.51%) |
1 |
SELECT p0_.id AS id_0, p0_.quantity AS quantity_1, p0_.quantity_old AS quantity_old_2, p0_.price AS price_3, p0_.price_old AS price_old_4, p0_.yield_calculation AS yield_calculation_5, p0_.principal AS principal_6, p0_.change_order AS change_order_7, p0_.item_type AS item_type_8, p0_.change_order_date AS change_order_date_9, p0_.internal_note AS internal_note_10, p0_.note_updated_at AS note_updated_at_11, p0_.apply_retainage AS apply_retainage_12, p0_.bonded AS bonded_13, p0_.code AS code_14, p0_.contract_name AS contract_name_15, p0_.note_updated_by AS note_updated_by_16, p0_.project_id AS project_id_17, p0_.item_id AS item_id_18, p0_.equation_id AS equation_id_19 FROM project_item p0_ LEFT JOIN project p1_ ON p0_.project_id = p1_.project_id WHERE p1_.project_id = ? ORDER BY p0_.id ASC
Parameters:
[
70
]
|
||||||||||||||||||||||||||||||||||
|
0.34 ms (2.48%) |
1 |
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 = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||||
|
0.33 ms (2.41%) |
1 |
SELECT p0_.id AS id_0, p0_.concrete_start_date AS concrete_start_date_1, p0_.concrete_quote_price_escalator AS concrete_quote_price_escalator_2, p0_.concrete_time_period_every_n AS concrete_time_period_every_n_3, p0_.concrete_time_period_unit AS concrete_time_period_unit_4, p0_.updated_at_concrete_quote_price AS updated_at_concrete_quote_price_5, p0_.position AS position_6, p0_.project_id AS project_id_7, p0_.vendor_id AS vendor_id_8 FROM project_concrete_vendor p0_ LEFT JOIN project p1_ ON p0_.project_id = p1_.project_id LEFT JOIN concrete_vendor c2_ ON p0_.vendor_id = c2_.vendor_id WHERE p1_.project_id = ? ORDER BY p0_.position ASC, p0_.id ASC
Parameters:
[
70
]
|
||||||||||||||||||||||||||||||||||
|
0.32 ms (2.36%) |
1 |
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
Parameters:
[
4482
]
|
||||||||||||||||||||||||||||||||||
|
0.32 ms (2.36%) |
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
Parameters:
[
4482
]
|
||||||||||||||||||||||||||||||||||
|
0.31 ms (2.24%) |
1 |
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
Parameters:
[
4482
]
|
||||||||||||||||||||||||||||||||||
|
0.28 ms (2.07%) |
1 |
SELECT c0_.vendor_id AS vendor_id_0, c0_.name AS name_1, c0_.phone AS phone_2, c0_.address AS address_3, c0_.contact_name AS contact_name_4, c0_.contact_email AS contact_email_5 FROM concrete_vendor c0_ ORDER BY c0_.name ASC
Parameters:
[] |
||||||||||||||||||||||||||||||||||
|
0.28 ms (2.06%) |
1 |
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
Parameters:
[
4482
]
|
||||||||||||||||||||||||||||||||||
|
0.26 ms (1.93%) |
1 |
SELECT s0_.subcontractor_id AS subcontractor_id_0, s0_.name AS name_1, s0_.phone AS phone_2, s0_.address AS address_3, s0_.contact_name AS contact_name_4, s0_.contact_email AS contact_email_5, s0_.company_name AS company_name_6, s0_.company_phone AS company_phone_7, s0_.company_address AS company_address_8, s0_.color AS color_9, s0_.created_at AS created_at_10, s0_.updated_at AS updated_at_11 FROM subcontractor s0_ ORDER BY s0_.name ASC
Parameters:
[] |
||||||||||||||||||||||||||||||||||
|
0.26 ms (1.88%) |
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 = ?
Parameters:
[
5
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Employee | 190 |
| App\Entity\SubcontractorEmployee | 95 |
| App\Entity\ConcreteVendor | 47 |
| App\Entity\County | 23 |
| App\Entity\Subcontractor | 11 |
| App\Entity\EmployeeRole | 7 |
| App\Entity\District | 6 |
| App\Entity\DataTrackingItem | 4 |
| App\Entity\ProjectItem | 4 |
| App\Entity\Item | 4 |
| App\Entity\Equation | 3 |
| App\Entity\Unit | 3 |
| App\Entity\DataTrackingAttachment | 2 |
| App\Entity\DataTrackingConcVendor | 2 |
| App\Entity\AccessToken | 1 |
| App\Entity\Usuario | 1 |
| App\Entity\Rol | 1 |
| App\Entity\PermisoUsuario | 1 |
| App\Entity\Funcion | 1 |
| App\Entity\Project | 1 |
| App\Entity\Company | 1 |
| App\Entity\DataTracking | 1 |
| App\Entity\DataTrackingLabor | 1 |
| App\Entity\State | 1 |