GET https://erp.valdental.ro/admin/app/project/project_list?_=1781525718158

Query Metrics

79 Database Queries
7 Different statements
25.75 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 0.53 ms
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.id AS id_14, t0.name AS name_15, t0.code AS code_16, t0.language AS language_17, t0.technical_grade_id AS technical_grade_id_18 FROM user t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  5
]
2 1.50 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.nr AS nr_2, p0_.pacient AS pacient_3, p0_.comment AS comment_4, p0_.date_in AS date_in_5, p0_.date_out AS date_out_6, p0_.date_deadline AS date_deadline_7, p0_.urgent AS urgent_8, p0_.paid AS paid_9, p0_.price AS price_10, p0_.color AS color_11, p0_.combi AS combi_12, p0_.deleted AS deleted_13, p0_.nr_seria AS nr_seria_14, p0_.doctor_edit AS doctor_edit_15, p0_.finish_date AS finish_date_16, p0_.created_at AS created_at_17, p0_.updated_at AS updated_at_18, p0_.emergency_fee_id AS emergency_fee_id_19, p0_.project_status_id AS project_status_id_20, p0_.doctor_id AS doctor_id_21, p0_.project_type_id AS project_type_id_22, p0_.quaranteed_repair_id AS quaranteed_repair_id_23, p0_.company_id AS company_id_24, p0_.creator_user_id AS creator_user_id_25, p0_.project_prevision_status_id AS project_prevision_status_id_26 FROM project p0_ LEFT JOIN project_status p1_ ON p0_.project_status_id = p1_.id WHERE p1_.id NOT IN (?, ?) AND p0_.deleted = ? ORDER BY p1_.position ASC, p0_.updated_at DESC
Parameters:
[
  10
  11
  0
]
3 0.43 ms
SELECT t0.id AS id_1, t0.product_qty AS product_qty_2, t0.product_price AS product_price_3, t0.rejected AS rejected_4, t0.project_id AS project_id_5, t0.product_id AS product_id_6 FROM project_body t0 WHERE t0.project_id = ?
Parameters:
[
  2056
]
4 0.37 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.active AS active_4, t0.multiplied_by_teeth_nr AS multiplied_by_teeth_nr_5, t0.deleted AS deleted_6, t0.warning_deadline_hour AS warning_deadline_hour_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM product t0 WHERE t0.id = ?
Parameters:
[
  59
]
5 0.42 ms
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.id AS id_14, t0.name AS name_15, t0.code AS code_16, t0.language AS language_17, t0.technical_grade_id AS technical_grade_id_18 FROM user t0 WHERE t0.id = ?
Parameters:
[
  38
]
6 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3, t0.doctor_position AS doctor_position_4 FROM project_status t0 WHERE t0.id = ?
Parameters:
[
  3
]
7 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM project_type t0 WHERE t0.id = ?
Parameters:
[
  1
]
8 0.33 ms
SELECT t0.id AS id_1, t0.product_qty AS product_qty_2, t0.product_price AS product_price_3, t0.rejected AS rejected_4, t0.project_id AS project_id_5, t0.product_id AS product_id_6 FROM project_body t0 WHERE t0.project_id = ?
Parameters:
[
  2037
]
9 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.active AS active_4, t0.multiplied_by_teeth_nr AS multiplied_by_teeth_nr_5, t0.deleted AS deleted_6, t0.warning_deadline_hour AS warning_deadline_hour_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM product t0 WHERE t0.id = ?
Parameters:
[
  82
]
10 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.active AS active_4, t0.multiplied_by_teeth_nr AS multiplied_by_teeth_nr_5, t0.deleted AS deleted_6, t0.warning_deadline_hour AS warning_deadline_hour_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM product t0 WHERE t0.id = ?
Parameters:
[
  80
]
11 0.30 ms
SELECT t0.id AS id_1, t0.product_qty AS product_qty_2, t0.product_price AS product_price_3, t0.rejected AS rejected_4, t0.project_id AS project_id_5, t0.product_id AS product_id_6 FROM project_body t0 WHERE t0.project_id = ?
Parameters:
[
  2038
]
12 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.active AS active_4, t0.multiplied_by_teeth_nr AS multiplied_by_teeth_nr_5, t0.deleted AS deleted_6, t0.warning_deadline_hour AS warning_deadline_hour_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM product t0 WHERE t0.id = ?
Parameters:
[
  88
]
13 0.30 ms
SELECT t0.id AS id_1, t0.product_qty AS product_qty_2, t0.product_price AS product_price_3, t0.rejected AS rejected_4, t0.project_id AS project_id_5, t0.product_id AS product_id_6 FROM project_body t0 WHERE t0.project_id = ?
Parameters:
[
  2039
]
14 0.30 ms
SELECT t0.id AS id_1, t0.product_qty AS product_qty_2, t0.product_price AS product_price_3, t0.rejected AS rejected_4, t0.project_id AS project_id_5, t0.product_id AS product_id_6 FROM project_body t0 WHERE t0.project_id = ?
Parameters:
[
  2057
]
15 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.active AS active_4, t0.multiplied_by_teeth_nr AS multiplied_by_teeth_nr_5, t0.deleted AS deleted_6, t0.warning_deadline_hour AS warning_deadline_hour_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM product t0 WHERE t0.id = ?
Parameters:
[
  68
]
16 0.30 ms
SELECT t0.id AS id_1, t0.product_qty AS product_qty_2, t0.product_price AS product_price_3, t0.rejected AS rejected_4, t0.project_id AS project_id_5, t0.product_id AS product_id_6 FROM project_body t0 WHERE t0.project_id = ?
Parameters:
[
  2073
]
17 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.active AS active_4, t0.multiplied_by_teeth_nr AS multiplied_by_teeth_nr_5, t0.deleted AS deleted_6, t0.warning_deadline_hour AS warning_deadline_hour_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM product t0 WHERE t0.id = ?
Parameters:
[
  4
]
18 0.33 ms
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.id AS id_14, t0.name AS name_15, t0.code AS code_16, t0.language AS language_17, t0.technical_grade_id AS technical_grade_id_18 FROM user t0 WHERE t0.id = ?
Parameters:
[
  28
]
19 0.30 ms
SELECT t0.id AS id_1, t0.product_qty AS product_qty_2, t0.product_price AS product_price_3, t0.rejected AS rejected_4, t0.project_id AS project_id_5, t0.product_id AS product_id_6 FROM project_body t0 WHERE t0.project_id = ?
Parameters:
[
  2072
]
20 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.active AS active_4, t0.multiplied_by_teeth_nr AS multiplied_by_teeth_nr_5, t0.deleted AS deleted_6, t0.warning_deadline_hour AS warning_deadline_hour_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM product t0 WHERE t0.id = ?
Parameters:
[
  18
]
21 0.29 ms
SELECT t0.id AS id_1, t0.product_qty AS product_qty_2, t0.product_price AS product_price_3, t0.rejected AS rejected_4, t0.project_id AS project_id_5, t0.product_id AS product_id_6 FROM project_body t0 WHERE t0.project_id = ?
Parameters:
[
  2071
]
22 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.active AS active_4, t0.multiplied_by_teeth_nr AS multiplied_by_teeth_nr_5, t0.deleted AS deleted_6, t0.warning_deadline_hour AS warning_deadline_hour_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM product t0 WHERE t0.id = ?
Parameters:
[
  84
]
23 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.active AS active_4, t0.multiplied_by_teeth_nr AS multiplied_by_teeth_nr_5, t0.deleted AS deleted_6, t0.warning_deadline_hour AS warning_deadline_hour_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM product t0 WHERE t0.id = ?
Parameters:
[
  48
]
24 0.34 ms
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.id AS id_14, t0.name AS name_15, t0.code AS code_16, t0.language AS language_17, t0.technical_grade_id AS technical_grade_id_18 FROM user t0 WHERE t0.id = ?
Parameters:
[
  27
]
25 0.30 ms
SELECT t0.id AS id_1, t0.product_qty AS product_qty_2, t0.product_price AS product_price_3, t0.rejected AS rejected_4, t0.project_id AS project_id_5, t0.product_id AS product_id_6 FROM project_body t0 WHERE t0.project_id = ?
Parameters:
[
  2070
]
26 0.33 ms
SELECT t0.id AS id_1, t0.product_qty AS product_qty_2, t0.product_price AS product_price_3, t0.rejected AS rejected_4, t0.project_id AS project_id_5, t0.product_id AS product_id_6 FROM project_body t0 WHERE t0.project_id = ?
Parameters:
[
  2051
]
27 0.30 ms
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.id AS id_14, t0.name AS name_15, t0.code AS code_16, t0.language AS language_17, t0.technical_grade_id AS technical_grade_id_18 FROM user t0 WHERE t0.id = ?
Parameters:
[
  14
]
28 0.33 ms
SELECT t0.id AS id_1, t0.product_qty AS product_qty_2, t0.product_price AS product_price_3, t0.rejected AS rejected_4, t0.project_id AS project_id_5, t0.product_id AS product_id_6 FROM project_body t0 WHERE t0.project_id = ?
Parameters:
[
  2069
]
29 0.25 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3, t0.doctor_position AS doctor_position_4 FROM project_status t0 WHERE t0.id = ?
Parameters:
[
  1
]
30 0.32 ms
SELECT t0.id AS id_1, t0.product_qty AS product_qty_2, t0.product_price AS product_price_3, t0.rejected AS rejected_4, t0.project_id AS project_id_5, t0.product_id AS product_id_6 FROM project_body t0 WHERE t0.project_id = ?
Parameters:
[
  2068
]
31 0.31 ms
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.id AS id_14, t0.name AS name_15, t0.code AS code_16, t0.language AS language_17, t0.technical_grade_id AS technical_grade_id_18 FROM user t0 WHERE t0.id = ?
Parameters:
[
  16
]
32 0.32 ms
SELECT t0.id AS id_1, t0.product_qty AS product_qty_2, t0.product_price AS product_price_3, t0.rejected AS rejected_4, t0.project_id AS project_id_5, t0.product_id AS product_id_6 FROM project_body t0 WHERE t0.project_id = ?
Parameters:
[
  2067
]
33 0.30 ms
SELECT t0.id AS id_1, t0.product_qty AS product_qty_2, t0.product_price AS product_price_3, t0.rejected AS rejected_4, t0.project_id AS project_id_5, t0.product_id AS product_id_6 FROM project_body t0 WHERE t0.project_id = ?
Parameters:
[
  2066
]
34 0.33 ms
SELECT t0.id AS id_1, t0.product_qty AS product_qty_2, t0.product_price AS product_price_3, t0.rejected AS rejected_4, t0.project_id AS project_id_5, t0.product_id AS product_id_6 FROM project_body t0 WHERE t0.project_id = ?
Parameters:
[
  2065
]
35 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.active AS active_4, t0.multiplied_by_teeth_nr AS multiplied_by_teeth_nr_5, t0.deleted AS deleted_6, t0.warning_deadline_hour AS warning_deadline_hour_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM product t0 WHERE t0.id = ?
Parameters:
[
  40
]
36 0.33 ms
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.id AS id_14, t0.name AS name_15, t0.code AS code_16, t0.language AS language_17, t0.technical_grade_id AS technical_grade_id_18 FROM user t0 WHERE t0.id = ?
Parameters:
[
  29
]
37 0.29 ms
SELECT t0.id AS id_1, t0.product_qty AS product_qty_2, t0.product_price AS product_price_3, t0.rejected AS rejected_4, t0.project_id AS project_id_5, t0.product_id AS product_id_6 FROM project_body t0 WHERE t0.project_id = ?
Parameters:
[
  2043
]
38 0.32 ms
SELECT t0.id AS id_1, t0.product_qty AS product_qty_2, t0.product_price AS product_price_3, t0.rejected AS rejected_4, t0.project_id AS project_id_5, t0.product_id AS product_id_6 FROM project_body t0 WHERE t0.project_id = ?
Parameters:
[
  2064
]
39 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.active AS active_4, t0.multiplied_by_teeth_nr AS multiplied_by_teeth_nr_5, t0.deleted AS deleted_6, t0.warning_deadline_hour AS warning_deadline_hour_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM product t0 WHERE t0.id = ?
Parameters:
[
  39
]
40 0.33 ms
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.id AS id_14, t0.name AS name_15, t0.code AS code_16, t0.language AS language_17, t0.technical_grade_id AS technical_grade_id_18 FROM user t0 WHERE t0.id = ?
Parameters:
[
  52
]
41 0.32 ms
SELECT t0.id AS id_1, t0.product_qty AS product_qty_2, t0.product_price AS product_price_3, t0.rejected AS rejected_4, t0.project_id AS project_id_5, t0.product_id AS product_id_6 FROM project_body t0 WHERE t0.project_id = ?
Parameters:
[
  2053
]
42 0.31 ms
SELECT t0.id AS id_1, t0.product_qty AS product_qty_2, t0.product_price AS product_price_3, t0.rejected AS rejected_4, t0.project_id AS project_id_5, t0.product_id AS product_id_6 FROM project_body t0 WHERE t0.project_id = ?
Parameters:
[
  2063
]
43 0.30 ms
SELECT t0.id AS id_1, t0.product_qty AS product_qty_2, t0.product_price AS product_price_3, t0.rejected AS rejected_4, t0.project_id AS project_id_5, t0.product_id AS product_id_6 FROM project_body t0 WHERE t0.project_id = ?
Parameters:
[
  2062
]
44 0.32 ms
SELECT t0.id AS id_1, t0.product_qty AS product_qty_2, t0.product_price AS product_price_3, t0.rejected AS rejected_4, t0.project_id AS project_id_5, t0.product_id AS product_id_6 FROM project_body t0 WHERE t0.project_id = ?
Parameters:
[
  2061
]
45 0.29 ms
SELECT t0.id AS id_1, t0.product_qty AS product_qty_2, t0.product_price AS product_price_3, t0.rejected AS rejected_4, t0.project_id AS project_id_5, t0.product_id AS product_id_6 FROM project_body t0 WHERE t0.project_id = ?
Parameters:
[
  2060
]
46 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.active AS active_4, t0.multiplied_by_teeth_nr AS multiplied_by_teeth_nr_5, t0.deleted AS deleted_6, t0.warning_deadline_hour AS warning_deadline_hour_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM product t0 WHERE t0.id = ?
Parameters:
[
  21
]
47 0.30 ms
SELECT t0.id AS id_1, t0.product_qty AS product_qty_2, t0.product_price AS product_price_3, t0.rejected AS rejected_4, t0.project_id AS project_id_5, t0.product_id AS product_id_6 FROM project_body t0 WHERE t0.project_id = ?
Parameters:
[
  2059
]
48 0.31 ms
SELECT t0.id AS id_1, t0.product_qty AS product_qty_2, t0.product_price AS product_price_3, t0.rejected AS rejected_4, t0.project_id AS project_id_5, t0.product_id AS product_id_6 FROM project_body t0 WHERE t0.project_id = ?
Parameters:
[
  2058
]
49 0.31 ms
SELECT t0.id AS id_1, t0.product_qty AS product_qty_2, t0.product_price AS product_price_3, t0.rejected AS rejected_4, t0.project_id AS project_id_5, t0.product_id AS product_id_6 FROM project_body t0 WHERE t0.project_id = ?
Parameters:
[
  1986
]
50 0.31 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.active AS active_4, t0.multiplied_by_teeth_nr AS multiplied_by_teeth_nr_5, t0.deleted AS deleted_6, t0.warning_deadline_hour AS warning_deadline_hour_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM product t0 WHERE t0.id = ?
Parameters:
[
  25
]
51 0.31 ms
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.id AS id_14, t0.name AS name_15, t0.code AS code_16, t0.language AS language_17, t0.technical_grade_id AS technical_grade_id_18 FROM user t0 WHERE t0.id = ?
Parameters:
[
  33
]
52 0.33 ms
SELECT t0.id AS id_1, t0.product_qty AS product_qty_2, t0.product_price AS product_price_3, t0.rejected AS rejected_4, t0.project_id AS project_id_5, t0.product_id AS product_id_6 FROM project_body t0 WHERE t0.project_id = ?
Parameters:
[
  2055
]
53 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.active AS active_4, t0.multiplied_by_teeth_nr AS multiplied_by_teeth_nr_5, t0.deleted AS deleted_6, t0.warning_deadline_hour AS warning_deadline_hour_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM product t0 WHERE t0.id = ?
Parameters:
[
  42
]
54 0.32 ms
SELECT t0.id AS id_1, t0.product_qty AS product_qty_2, t0.product_price AS product_price_3, t0.rejected AS rejected_4, t0.project_id AS project_id_5, t0.product_id AS product_id_6 FROM project_body t0 WHERE t0.project_id = ?
Parameters:
[
  2054
]
55 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.active AS active_4, t0.multiplied_by_teeth_nr AS multiplied_by_teeth_nr_5, t0.deleted AS deleted_6, t0.warning_deadline_hour AS warning_deadline_hour_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM product t0 WHERE t0.id = ?
Parameters:
[
  30
]
56 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.active AS active_4, t0.multiplied_by_teeth_nr AS multiplied_by_teeth_nr_5, t0.deleted AS deleted_6, t0.warning_deadline_hour AS warning_deadline_hour_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM product t0 WHERE t0.id = ?
Parameters:
[
  31
]
57 0.31 ms
SELECT t0.id AS id_1, t0.product_qty AS product_qty_2, t0.product_price AS product_price_3, t0.rejected AS rejected_4, t0.project_id AS project_id_5, t0.product_id AS product_id_6 FROM project_body t0 WHERE t0.project_id = ?
Parameters:
[
  2052
]
58 0.31 ms
SELECT t0.id AS id_1, t0.product_qty AS product_qty_2, t0.product_price AS product_price_3, t0.rejected AS rejected_4, t0.project_id AS project_id_5, t0.product_id AS product_id_6 FROM project_body t0 WHERE t0.project_id = ?
Parameters:
[
  2047
]
59 0.31 ms
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.id AS id_14, t0.name AS name_15, t0.code AS code_16, t0.language AS language_17, t0.technical_grade_id AS technical_grade_id_18 FROM user t0 WHERE t0.id = ?
Parameters:
[
  40
]
60 0.34 ms
SELECT t0.id AS id_1, t0.product_qty AS product_qty_2, t0.product_price AS product_price_3, t0.rejected AS rejected_4, t0.project_id AS project_id_5, t0.product_id AS product_id_6 FROM project_body t0 WHERE t0.project_id = ?
Parameters:
[
  2045
]
61 0.31 ms
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.id AS id_14, t0.name AS name_15, t0.code AS code_16, t0.language AS language_17, t0.technical_grade_id AS technical_grade_id_18 FROM user t0 WHERE t0.id = ?
Parameters:
[
  41
]
62 0.33 ms
SELECT t0.id AS id_1, t0.product_qty AS product_qty_2, t0.product_price AS product_price_3, t0.rejected AS rejected_4, t0.project_id AS project_id_5, t0.product_id AS product_id_6 FROM project_body t0 WHERE t0.project_id = ?
Parameters:
[
  2040
]
63 0.30 ms
SELECT t0.id AS id_1, t0.product_qty AS product_qty_2, t0.product_price AS product_price_3, t0.rejected AS rejected_4, t0.project_id AS project_id_5, t0.product_id AS product_id_6 FROM project_body t0 WHERE t0.project_id = ?
Parameters:
[
  1992
]
64 0.31 ms
SELECT t0.id AS id_1, t0.product_qty AS product_qty_2, t0.product_price AS product_price_3, t0.rejected AS rejected_4, t0.project_id AS project_id_5, t0.product_id AS product_id_6 FROM project_body t0 WHERE t0.project_id = ?
Parameters:
[
  2028
]
65 0.34 ms
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.id AS id_14, t0.name AS name_15, t0.code AS code_16, t0.language AS language_17, t0.technical_grade_id AS technical_grade_id_18 FROM user t0 WHERE t0.id = ?
Parameters:
[
  56
]
66 0.31 ms
SELECT t0.id AS id_1, t0.product_qty AS product_qty_2, t0.product_price AS product_price_3, t0.rejected AS rejected_4, t0.project_id AS project_id_5, t0.product_id AS product_id_6 FROM project_body t0 WHERE t0.project_id = ?
Parameters:
[
  2014
]
67 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.active AS active_4, t0.multiplied_by_teeth_nr AS multiplied_by_teeth_nr_5, t0.deleted AS deleted_6, t0.warning_deadline_hour AS warning_deadline_hour_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM product t0 WHERE t0.id = ?
Parameters:
[
  49
]
68 0.32 ms
SELECT t0.id AS id_1, t0.product_qty AS product_qty_2, t0.product_price AS product_price_3, t0.rejected AS rejected_4, t0.project_id AS project_id_5, t0.product_id AS product_id_6 FROM project_body t0 WHERE t0.project_id = ?
Parameters:
[
  2025
]
69 0.29 ms
SELECT t0.id AS id_1, t0.product_qty AS product_qty_2, t0.product_price AS product_price_3, t0.rejected AS rejected_4, t0.project_id AS project_id_5, t0.product_id AS product_id_6 FROM project_body t0 WHERE t0.project_id = ?
Parameters:
[
  2024
]
70 0.33 ms
SELECT t0.id AS id_1, t0.product_qty AS product_qty_2, t0.product_price AS product_price_3, t0.rejected AS rejected_4, t0.project_id AS project_id_5, t0.product_id AS product_id_6 FROM project_body t0 WHERE t0.project_id = ?
Parameters:
[
  1985
]
71 0.30 ms
SELECT t0.id AS id_1, t0.product_qty AS product_qty_2, t0.product_price AS product_price_3, t0.rejected AS rejected_4, t0.project_id AS project_id_5, t0.product_id AS product_id_6 FROM project_body t0 WHERE t0.project_id = ?
Parameters:
[
  2012
]
72 0.32 ms
SELECT t0.id AS id_1, t0.product_qty AS product_qty_2, t0.product_price AS product_price_3, t0.rejected AS rejected_4, t0.project_id AS project_id_5, t0.product_id AS product_id_6 FROM project_body t0 WHERE t0.project_id = ?
Parameters:
[
  2006
]
73 0.30 ms
SELECT t0.id AS id_1, t0.product_qty AS product_qty_2, t0.product_price AS product_price_3, t0.rejected AS rejected_4, t0.project_id AS project_id_5, t0.product_id AS product_id_6 FROM project_body t0 WHERE t0.project_id = ?
Parameters:
[
  2001
]
74 0.33 ms
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.id AS id_14, t0.name AS name_15, t0.code AS code_16, t0.language AS language_17, t0.technical_grade_id AS technical_grade_id_18 FROM user t0 WHERE t0.id = ?
Parameters:
[
  21
]
75 0.29 ms
SELECT t0.id AS id_1, t0.product_qty AS product_qty_2, t0.product_price AS product_price_3, t0.rejected AS rejected_4, t0.project_id AS project_id_5, t0.product_id AS product_id_6 FROM project_body t0 WHERE t0.project_id = ?
Parameters:
[
  1879
]
76 0.31 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.active AS active_4, t0.multiplied_by_teeth_nr AS multiplied_by_teeth_nr_5, t0.deleted AS deleted_6, t0.warning_deadline_hour AS warning_deadline_hour_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM product t0 WHERE t0.id = ?
Parameters:
[
  14
]
77 0.29 ms
SELECT t0.id AS id_1, t0.product_qty AS product_qty_2, t0.product_price AS product_price_3, t0.rejected AS rejected_4, t0.project_id AS project_id_5, t0.product_id AS product_id_6 FROM project_body t0 WHERE t0.project_id = ?
Parameters:
[
  1728
]
78 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.active AS active_4, t0.multiplied_by_teeth_nr AS multiplied_by_teeth_nr_5, t0.deleted AS deleted_6, t0.warning_deadline_hour AS warning_deadline_hour_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM product t0 WHERE t0.id = ?
Parameters:
[
  76
]
79 0.30 ms
SELECT t0.id AS id_1, t0.product_qty AS product_qty_2, t0.product_price AS product_price_3, t0.rejected AS rejected_4, t0.project_id AS project_id_5, t0.product_id AS product_id_6 FROM project_body t0 WHERE t0.project_id = ?
Parameters:
[
  1968
]

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
Sonata\UserBundle\Entity\BaseUser No errors.
App\Entity\User No errors.
App\Entity\TechnicalGrade
  • The association App\Entity\TechnicalGrade#productStageGrades refers to the owning side field App\Entity\ProductStageGrade#technicalGrade which does not exist.
App\Entity\Company
  • The association App\Entity\Company#users refers to the owning side field App\Entity\User#company which does not exist.
App\Entity\BasicMaterialInOut No errors.
App\Entity\CashOut No errors.
App\Entity\CashIn No errors.
App\Entity\Task No errors.
App\Entity\Project No errors.
App\Entity\FixedPaidEmployee No errors.
App\Entity\Loans No errors.
App\Entity\WorkStageType No errors.
App\Entity\ProjectStatus No errors.
App\Entity\EmergencyFee No errors.
App\Entity\ProjectType No errors.
App\Entity\ProjectBody No errors.
App\Entity\ProjectSample No errors.
App\Entity\CashInBody No errors.
App\Entity\Product No errors.
App\Entity\Tooth No errors.
App\Entity\ProductStageGrade No errors.