Query Metrics
79
Database Queries
7
Different statements
25.75 ms
Query time
2
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
13.44 ms (52.20%) |
43 |
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
]
|
|
5.51 ms (21.41%) |
19 |
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
]
|
|
3.94 ms (15.32%) |
12 |
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
]
|
|
1.50 ms (5.81%) |
1 |
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 ] |
|
0.54 ms (2.09%) |
2 |
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
]
|
|
0.53 ms (2.04%) |
1 |
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
]
|
|
0.29 ms (1.12%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM project_type t0 WHERE t0.id = ?
Parameters:
[
1
]
|
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 |
|
| App\Entity\Company |
|
| 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. |