Query Metrics
9
Database Queries
8
Different statements
4.30 ms
Query time
2
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.55 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 | 0.48 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.active = ? AND t0.deleted = ?
Parameters:
[ 1 0 ] |
| 3 | 0.27 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM project_type t0
Parameters:
[] |
| 4 | 0.31 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.description AS description_4 FROM settings t0 WHERE t0.name = ?
Parameters:
[
"order_seria"
]
|
| 5 | 1.27 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.nr AS nr_3, t0.pacient AS pacient_4, t0.comment AS comment_5, t0.date_in AS date_in_6, t0.date_out AS date_out_7, t0.date_deadline AS date_deadline_8, t0.urgent AS urgent_9, t0.paid AS paid_10, t0.price AS price_11, t0.color AS color_12, t0.combi AS combi_13, t0.deleted AS deleted_14, t0.nr_seria AS nr_seria_15, t0.doctor_edit AS doctor_edit_16, t0.finish_date AS finish_date_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.emergency_fee_id AS emergency_fee_id_20, t0.project_status_id AS project_status_id_21, t0.doctor_id AS doctor_id_22, t0.project_type_id AS project_type_id_23, t0.quaranteed_repair_id AS quaranteed_repair_id_24, t0.company_id AS company_id_25, t0.creator_user_id AS creator_user_id_26, t0.project_prevision_status_id AS project_prevision_status_id_27 FROM project t0 WHERE t0.deleted = ? AND t0.nr_seria = ? ORDER BY t0.nr DESC LIMIT 1
Parameters:
[ 0 "S2023" ] |
| 6 | 0.27 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM project_type t0
Parameters:
[] |
| 7 | 0.41 ms |
SELECT u0_.username AS username_0, u0_.username_canonical AS username_canonical_1, u0_.email AS email_2, u0_.email_canonical AS email_canonical_3, u0_.enabled AS enabled_4, u0_.salt AS salt_5, u0_.password AS password_6, u0_.last_login AS last_login_7, u0_.confirmation_token AS confirmation_token_8, u0_.password_requested_at AS password_requested_at_9, u0_.roles AS roles_10, u0_.created_at AS created_at_11, u0_.updated_at AS updated_at_12, u0_.id AS id_13, u0_.name AS name_14, u0_.code AS code_15, u0_.language AS language_16, u0_.technical_grade_id AS technical_grade_id_17 FROM user u0_ WHERE u0_.enabled = ?
Parameters:
[
1
]
|
| 8 | 0.47 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.cod_fiscal AS cod_fiscal_3, t0.nr_reg_com AS nr_reg_com_4, t0.address AS address_5, t0.banca AS banca_6, t0.cont_banca AS cont_banca_7, t0.tel AS tel_8, t0.email AS email_9, t0.contact_person AS contact_person_10, t0.legal_entity AS legal_entity_11, t0.contact_person_title AS contact_person_title_12, t0.payer_tva AS payer_tva_13, t0.deleted AS deleted_14, t0.from_romania AS from_romania_15, t0.anaf_str AS anaf_str_16, t0.anaf_nr AS anaf_nr_17, t0.anaf_loc AS anaf_loc_18, t0.anaf_denumire_jud AS anaf_denumire_jud_19, t0.anaf_cod_jud AS anaf_cod_jud_20, t0.anaf_detalii_addresa AS anaf_detalii_addresa_21, t0.anaf_cod_postal AS anaf_cod_postal_22, t0.active AS active_23, t0.location AS location_24, t0.created_at AS created_at_25, t0.updated_at AS updated_at_26, t0.county_id AS county_id_27, t0.city_id AS city_id_28 FROM company t0 INNER JOIN company_user ON t0.id = company_user.company_id WHERE company_user.user_id = ?
Parameters:
[
5
]
|
| 9 | 0.28 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.deleted AS deleted_4 FROM emergency_fee t0 WHERE t0.deleted = ?
Parameters:
[
0
]
|
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\Product | No errors. |
| App\Entity\ProductStageGrade | No errors. |
| App\Entity\ProjectBody | No errors. |
| App\Entity\ProjectType | No errors. |
| App\Entity\Settings | No errors. |
| App\Entity\EmergencyFee | No errors. |
| App\Entity\ProjectStatus | No errors. |
| App\Entity\ProjectSample | No errors. |
| App\Entity\CashInBody | No errors. |
| App\Entity\County | No errors. |
| App\Entity\City | No errors. |