Query Metrics
16
Database Queries
6
Different statements
13.10 ms
Query time
0
Invalid entities
20
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
5.22 ms (39.86%) |
1 |
SELECT s0_.schedule_id AS schedule_id_0, s0_.description AS description_1, s0_.location AS location_2, s0_.latitud AS latitud_3, s0_.longitud AS longitud_4, s0_.day AS day_5, s0_.hour AS hour_6, s0_.quantity AS quantity_7, s0_.notes AS notes_8, s0_.highpriority AS highpriority_9, s0_.project_id AS project_id_10, s0_.project_contact_id AS project_contact_id_11, s0_.vendor_id AS vendor_id_12, s0_.employee_id AS employee_id_13 FROM schedule s0_ LEFT JOIN project p1_ ON s0_.project_id = p1_.project_id LEFT JOIN project_contact p2_ ON s0_.project_contact_id = p2_.contact_id LEFT JOIN concrete_vendor c3_ ON s0_.vendor_id = c3_.vendor_id WHERE s0_.day >= ? AND s0_.day <= ? ORDER BY s0_.day DESC
Parameters:
[ "2026-08-17 00:00:00" "2026-08-23 23:59:59" ]
|
||||||||||||||||||||||||||||||||
|
3.27 ms (24.95%) |
10 |
SELECT s0_.id AS id_0, s0_.schedule_id AS schedule_id_1, s0_.employee_id AS employee_id_2 FROM schedule_employee s0_ LEFT JOIN schedule s1_ ON s0_.schedule_id = s1_.schedule_id LEFT JOIN employee e2_ ON s0_.employee_id = e2_.employee_id WHERE s1_.schedule_id = ? ORDER BY e2_.name ASC
Parameters:
[
7598
]
|
||||||||||||||||||||||||||||||||
|
2.95 ms (22.52%) |
1 |
SELECT COUNT(s0_.schedule_id) AS sclr_0 FROM schedule s0_ LEFT JOIN project p1_ ON s0_.project_id = p1_.project_id LEFT JOIN project_contact p2_ ON s0_.project_contact_id = p2_.contact_id LEFT JOIN concrete_vendor c3_ ON s0_.vendor_id = c3_.vendor_id WHERE s0_.day >= ? AND s0_.day <= ?
Parameters:
[ "2026-08-17 00:00:00" "2026-08-23 23:59:59" ]
|
||||||||||||||||||||||||||||||||
|
0.69 ms (5.27%) |
2 |
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.company_id AS company_id_45, t0.inspector_id AS inspector_id_46, t0.city_id AS city_id_47, t0.vendor_id AS vendor_id_48, t0.concrete_class_id AS concrete_class_id_49 FROM project t0 WHERE t0.project_id = ?
Parameters:
[
500
]
|
||||||||||||||||||||||||||||||||
|
0.57 ms (4.31%) |
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:
[ 6 1 ] |
||||||||||||||||||||||||||||||||
|
0.40 ms (3.08%) |
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.manage_contacts AS manage_contacts_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.player_id AS player_id_16, t0.push_token AS push_token_17, t0.plataforma AS plataforma_18, t0.imagen AS imagen_19, t0.preferred_lang AS preferred_lang_20, t0.sidebar_color AS sidebar_color_21, t0.rol_id AS rol_id_22 FROM user t0 WHERE t0.user_id = ?
Parameters:
[
6
]
|
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\Schedule | 10 |
| App\Entity\Project | 2 |
| App\Entity\Company | 2 |
| App\Entity\Usuario | 1 |
| App\Entity\Rol | 1 |
| App\Entity\PermisoUsuario | 1 |
| App\Entity\Funcion | 1 |
| App\Entity\ProjectContact | 1 |
| App\Entity\ConcreteVendor | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Usuario | No errors. |
| App\Entity\Rol | No errors. |
| App\Entity\PermisoUsuario | No errors. |
| App\Entity\Funcion | No errors. |
| App\Entity\Schedule | No errors. |
| App\Entity\Project | No errors. |
| App\Entity\ProjectContact | No errors. |
| App\Entity\ConcreteVendor | No errors. |
| App\Entity\Employee | No errors. |
| App\Entity\ScheduleEmployee | No errors. |
| App\Entity\Company | No errors. |
| App\Entity\Inspector | No errors. |
| App\Entity\County | No errors. |
| App\Entity\ConcreteClass | No errors. |