Query Metrics
4
Database Queries
4
Different statements
15.22 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 7.40 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.password AS password_4, t0.ministry AS ministry_5, t0.customer AS customer_6, t0.object AS object_7, t0.object_work_titleholder AS object_work_titleholder_8, t0.description AS description_9, t0.description_work_titleholder AS description_work_titleholder_10, t0.layout AS layout_11, t0.is_locked AS is_locked_12, t0.is_deleted AS is_deleted_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.locked_at AS locked_at_16, t0.deleted_at AS deleted_at_17, t0.mission_contract AS mission_contract_18, t0.mission_market AS mission_market_19, t0.mission_contract_start AS mission_contract_start_20, t0.mission_contract_end AS mission_contract_end_21, t0.mission_amount AS mission_amount_22, t0.company_name AS company_name_23, t0.company_address AS company_address_24, t0.company_email AS company_email_25, t0.company_phone AS company_phone_26, t0.company_contract AS company_contract_27, t0.company_amount AS company_amount_28, t0.contract_price_currency AS contract_price_currency_29, t0.tmp_type AS tmp_type_30, t0.tmp_type_contract AS tmp_type_contract_31, t0.company_currency AS company_currency_32, t0.contract_price_currency_other AS contract_price_currency_other_33, t0.company_currency_other AS company_currency_other_34, t0.company_works_start AS company_works_start_35, t0.works_end AS works_end_36, t0.lifebase_infrastructure AS lifebase_infrastructure_37, t0.lifebase_safety AS lifebase_safety_38, t0.lifebase_epi AS lifebase_epi_39, t0.lifebase_date AS lifebase_date_40, t0.lifebase_place AS lifebase_place_41, t0.lifebase_description AS lifebase_description_42, t0.lifebase_other AS lifebase_other_43, t0.mobile_infrastructure AS mobile_infrastructure_44, t0.mobile_safety AS mobile_safety_45, t0.mobile_epi AS mobile_epi_46, t0.mobile_date AS mobile_date_47, t0.mobile_place AS mobile_place_48, t0.mobile_description AS mobile_description_49, t0.mobile_other AS mobile_other_50, t0.owner_id AS owner_id_51 FROM project t0 WHERE t0.id = ?
Parameters:
[
"1"
]
|
2 | 4.15 ms |
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.plain_password AS plain_password_4, u0_.name AS name_5, u0_.organization AS organization_6, u0_.is_deleted AS is_deleted_7, u0_.created_at AS created_at_8, u0_.updated_at AS updated_at_9, u0_.deleted_at AS deleted_at_10, u0_.role_id AS role_id_11 FROM user u0_ WHERE u0_.is_deleted = 0 AND u0_.roles NOT LIKE ?
Parameters:
[
"%"ROLE_ADMIN"%"
]
|
3 | 0.96 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.plain_password AS plain_password_5, t0.name AS name_6, t0.organization AS organization_7, t0.is_deleted AS is_deleted_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11, t0.role_id AS role_id_12 FROM user t0 WHERE t0.id = ?
Parameters:
[
1
]
|
4 | 2.71 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.date AS date_3, t0.amendment_type AS amendment_type_4, t0.reason AS reason_5, t0.created_at AS created_at_6, t0.project_id AS project_id_7 FROM amendment t0 WHERE t0.project_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 |
---|---|
App\Entity\Project | No errors. |
App\Entity\User | No errors. |
App\Entity\Amendment | No errors. |
App\Entity\Team | No errors. |
App\Entity\Material | No errors. |
App\Entity\Document | No errors. |
App\Entity\Photo | No errors. |
App\Entity\Work | No errors. |
App\Entity\Dossier | No errors. |
App\Entity\Schedule | No errors. |
App\Entity\ExecutiveStaff | No errors. |
App\Entity\Equipment | No errors. |
App\Entity\Implantation | No errors. |
App\Entity\Meeting | No errors. |
App\Entity\Observation | No errors. |
App\Entity\Breakpoint | No errors. |
App\Entity\TechnicalReception | No errors. |
App\Entity\ProvisionalReception | No errors. |
App\Entity\MaterialsReception | No errors. |
App\Entity\Visitor | No errors. |
App\Entity\Role | No errors. |
App\Entity\Historic | No errors. |