Redirect 302 redirect from POST @sonata_user_admin_security_check (748dd8)

GET https://erp.valdental.ro/admin/app/project/project_add

Query Metrics

9 Database Queries
8 Different statements
4.30 ms Query time
2 Invalid entities

Queries

Group similar statements

# 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
  • 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\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.