POST https://testing.cagconcrete.com/admin/dashboard/work-schedule

Query Metrics

16 Database Queries
6 Different statements
13.10 ms Query time
0 Invalid entities
20 Managed entities

Grouped Statements

Show all queries

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