Query Metrics
3
Database Queries
3
Different statements
4.45 ms
Query time
0
Invalid entities
15
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.72 ms |
SELECT t0.id AS id_1, t0.ecoclient_user_id AS ecoclient_user_id_2, t0.username AS username_3, t0.firstname AS firstname_4, t0.lastname AS lastname_5, t0.salutation AS salutation_6, t0.email AS email_7, t0.password AS password_8, t0.user_title AS user_title_9, t0.user_mobile AS user_mobile_10, t0.user_landline AS user_landline_11, t0.enable_ldap_authentication AS enable_ldap_authentication_12, t0.image AS image_13, t0.marker_image AS marker_image_14, t0.small_square_image AS small_square_image_15, t0.image_mime_type AS image_mime_type_16, t0.is_non_human AS is_non_human_17, t0.signature AS signature_18, t0.odoo_employee_id AS odoo_employee_id_19, t0.odoo_user_id AS odoo_user_id_20, t0.disabled_at AS disabled_at_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.deleted_at AS deleted_at_24 FROM user t0 WHERE t0.username = ? LIMIT 1
Parameters:
[
"reuter"
]
|
| 2 | 0.96 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM role t0 INNER JOIN user_role ON t0.id = user_role.role_id WHERE user_role.user_id = ?
Parameters:
[
7
]
|
| 3 | 1.76 ms |
SELECT p0_.created_at AS created_at_0, p0_.id AS id_1, p0_.ecoclient_id AS ecoclient_id_2, p0_.ecoclient_company AS ecoclient_company_3, p0_.ecoclient_backoffice AS ecoclient_backoffice_4, p0_.ecoclient_inspector AS ecoclient_inspector_5, p0_.ecoclient_sales AS ecoclient_sales_6, p0_.project_title AS project_title_7, p0_.project_text AS project_text_8, p0_.project_street AS project_street_9, p0_.project_streetnumber AS project_streetnumber_10, p0_.project_zip AS project_zip_11, p0_.project_city AS project_city_12, p0_.project_country AS project_country_13, st_astext(p0_.project_geocode) AS project_geocode_14, p0_.project_construction_costs AS project_construction_costs_15, p0_.project_note AS project_note_16, p0_.project_status AS project_status_17, p0_.is_deactivated AS is_deactivated_18, p0_.starts_at AS starts_at_19, p0_.ends_at AS ends_at_20, p0_.is_framework_contract AS is_framework_contract_21, p0_.updated_at AS updated_at_22, p0_.deleted_at AS deleted_at_23, u1_.id AS id_24, p0_.company_id AS company_id_25, p0_.user_id AS user_id_26 FROM project p0_ LEFT JOIN project_user p2_ ON p0_.id = p2_.project_id LEFT JOIN user u1_ ON u1_.id = p2_.user_id WHERE (p0_.id = ?) AND (p0_.deleted_at IS NULL)
Parameters:
[
7194
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\User | 10 |
| App\Entity\Role | 3 |
| App\Entity\Project | 1 |
| App\Entity\Company | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Project | No errors. |
| App\Entity\ProjectImage | No errors. |
| App\Entity\InspectionAudio | No errors. |
| App\Entity\ProjectDocument | No errors. |
| App\Entity\Protocol | No errors. |
| App\Entity\Area | No errors. |
| App\Entity\Role | No errors. |
| App\Entity\Permission | No errors. |
| App\Entity\Contact | No errors. |
| App\Entity\UserNotification | No errors. |
| App\Entity\ActivityResource | No errors. |
| App\Entity\Staffing | No errors. |
| App\Entity\Vacation | No errors. |
| App\Entity\Company | No errors. |
| App\Entity\ActivityControl | No errors. |