Query Metrics
3
Database Queries
3
Different statements
5.25 ms
Query time
3
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
3.88 ms (73.80%) |
1 |
SELECT t0_.id AS id_0, t0_.weclapp_id AS weclapp_id_1, t0_.description AS description_2, t0_.startdate AS startdate_3, t0_.end_date AS end_date_4, t0_.uploaded_to_weclapp AS uploaded_to_weclapp_5, t0_.open_points AS open_points_6, t0_.billable AS billable_7, t0_.performance_record_id AS performance_record_id_8, t0_.send_date AS send_date_9, t0_.status AS status_10, t0_.performance_record_number AS performance_record_number_11, t0_.duration AS duration_12, t0_.hash_id AS hash_id_13, t0_.start_pause AS start_pause_14, t0_.end_pause AS end_pause_15, t0_.pause AS pause_16, t0_.comment AS comment_17, t0_.sales_order_id AS sales_order_id_18, t0_.sales_order_position_id AS sales_order_position_id_19, t0_.sales_order_position_task_id AS sales_order_position_task_id_20, t0_.sales_order AS sales_order_21, t0_.upload_inforamtions AS upload_inforamtions_22, t0_.article_id AS article_id_23, t0_.customer_id AS customer_id_24, t0_.responsible_user_id AS responsible_user_id_25, t0_.responsible_person_id AS responsible_person_id_26, t0_.customer_responsible_person_id AS customer_responsible_person_id_27 FROM time_record t0_ WHERE (t0_.startdate BETWEEN ? AND ?) AND t0_.responsible_user_id = ? AND t0_.status IN (?, ?)
Parameters:
[ "2025-12-01 00:00:00" "2025-12-31 23:59:59" null "send" "received" ]
|
||||||||||||||||||||||||||||
|
1.00 ms (19.04%) |
1 |
SELECT t0.id AS id_1, t0.description AS description_2, t0.estimated_duration_in_hours AS estimated_duration_in_hours_3, t0.status AS status_4, t0.quotation_status AS quotation_status_5, t0.quotation_number AS quotation_number_6, t0.quotation_id AS quotation_id_7, t0.scheduled_date AS scheduled_date_8, t0.responsible_person_id AS responsible_person_id_9, t0.customer_id AS customer_id_10, t0.consultant_id AS consultant_id_11 FROM open_point t0 WHERE t0.consultant_id IS NULL
Parameters:
[]
|
||||||||||||||||||||||||||||
|
0.38 ms (7.16%) |
1 |
SELECT t0_.id AS id_0, t0_.weclapp_id AS weclapp_id_1, t0_.description AS description_2, t0_.startdate AS startdate_3, t0_.end_date AS end_date_4, t0_.uploaded_to_weclapp AS uploaded_to_weclapp_5, t0_.open_points AS open_points_6, t0_.billable AS billable_7, t0_.performance_record_id AS performance_record_id_8, t0_.send_date AS send_date_9, t0_.status AS status_10, t0_.performance_record_number AS performance_record_number_11, t0_.duration AS duration_12, t0_.hash_id AS hash_id_13, t0_.start_pause AS start_pause_14, t0_.end_pause AS end_pause_15, t0_.pause AS pause_16, t0_.comment AS comment_17, t0_.sales_order_id AS sales_order_id_18, t0_.sales_order_position_id AS sales_order_position_id_19, t0_.sales_order_position_task_id AS sales_order_position_task_id_20, t0_.sales_order AS sales_order_21, t0_.upload_inforamtions AS upload_inforamtions_22, t0_.article_id AS article_id_23, t0_.customer_id AS customer_id_24, t0_.responsible_user_id AS responsible_user_id_25, t0_.responsible_person_id AS responsible_person_id_26, t0_.customer_responsible_person_id AS customer_responsible_person_id_27 FROM time_record t0_ WHERE (t0_.startdate BETWEEN ? AND ?) AND t0_.responsible_user_id = ?
Parameters:
[ "2025-12-01 00:00:00" "2025-12-31 23:59:59" null ]
|
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\TimeRecord |
|
| App\Entity\Article | No errors. |
| App\Entity\Customer | No errors. |
| App\Entity\User |
|
| App\Entity\Contact | No errors. |
| App\Entity\OpenPoint |
|
| App\Entity\SalesOrderPosition | No errors. |