POST https://staging.baustellensicherheit.ecoprotec.de/api/processes

Query Metrics

7 Database Queries
7 Different statements
8.41 ms Query time
8 Invalid entities
10 Managed entities

Queries

Group similar statements

# Time Info
1 0.84 ms
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.ecoclient_user_id AS ecoclient_user_id_3, t0.username AS username_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.salutation AS salutation_7, t0.user_title AS user_title_8, t0.email AS email_9, t0.user_mobile AS user_mobile_10, t0.user_landline AS user_landline_11, t0.image AS image_12, t0.marker_image AS marker_image_13, t0.small_square_image AS small_square_image_14, t0.image_mime_type AS image_mime_type_15, t0.signature AS signature_16, t0.password AS password_17, t0.enable_ldap_authentication AS enable_ldap_authentication_18, t0.is_non_human AS is_non_human_19, t0.odoo_employee_id AS odoo_employee_id_20, t0.odoo_user_id AS odoo_user_id_21, t0.disabled_at AS disabled_at_22, t0.settings AS settings_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.deleted_at AS deleted_at_26 FROM user t0 WHERE t0.username = ? LIMIT 1
Parameters:
[
  "reuter"
]
2 0.65 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 0.47 ms
SELECT t0.id AS id_1, t0.executed_at AS executed_at_2, t0.finished_at AS finished_at_3, t0.inspection_description AS inspection_description_4, t0.inspection_duration AS inspection_duration_5, t0.sent_at AS sent_at_6, t0.position AS position_7, t0.additional_protocol_fields AS additional_protocol_fields_8, t0.odoo_reference AS odoo_reference_9, t0.post_process_duration AS post_process_duration_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deleted_at AS deleted_at_13, t0.area_id AS area_id_14, t0.inspection_previous_id AS inspection_previous_id_15, t0.inspection_executed_by_id AS inspection_executed_by_id_16, t0.created_by_user_id AS created_by_user_id_17, t0.updated_by_user_id AS updated_by_user_id_18, t0.sent_by_user_id AS sent_by_user_id_19 FROM inspection t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  71170
]
4 0.39 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.current_place AS current_place_3, t0.payload AS payload_4, t0.progress AS progress_5, t0.target_class AS target_class_6, t0.target_id AS target_id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.area_id AS area_id_10, t0.project_id AS project_id_11 FROM app_process t0 WHERE t0.target_class = ? AND t0.target_id = ? AND t0.type = ? LIMIT 1
Parameters:
[
  "App\Entity\Inspection"
  71170
  "odoo_inspection_sync"
]
5 0.18 ms
"START TRANSACTION"
Parameters:
[]
6 0.55 ms
UPDATE app_process SET current_place = ?, progress = ? WHERE id = ?
Parameters:
[
  "running"
  0
  6
]
7 5.33 ms
"COMMIT"
Parameters:
[]

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 3
App\Entity\Role 3
App\Entity\Inspection 1
App\Entity\Area 1
App\Entity\Process 1
App\Entity\Project 1

Entities Mapping

Class Mapping errors
App\Entity\RefreshToken No errors.
App\Entity\User No errors.
App\Entity\Role No errors.
App\Entity\Permission No errors.
App\Entity\Process No errors.
App\Entity\Inspection
  • The field App\Entity\Inspection#media is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Media#inspection does not contain the required 'inversedBy="media"' attribute.
App\Entity\Area
  • The field App\Entity\Area#media is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Media#area does not contain the required 'inversedBy="media"' attribute.
  • The mappings App\Entity\Area#projectImage and App\Entity\ProjectImage#areas are inconsistent with each other.
  • The mappings App\Entity\Area#projectDocument and App\Entity\ProjectDocument#areas are inconsistent with each other.
App\Entity\InspectionDefect No errors.
App\Entity\Media No errors.
App\Entity\ProjectImage
  • The association App\Entity\ProjectImage#areas refers to the owning side field App\Entity\Area#projectImages which does not exist.
App\Entity\InspectionAudio
  • The association App\Entity\InspectionAudio#user refers to the inverse side field App\Entity\User#inspectionAudio which does not exist.
App\Entity\ProjectDocument
  • The association App\Entity\ProjectDocument#areas refers to the owning side field App\Entity\Area#projectDocuments which does not exist.
App\Entity\InspectionCondition No errors.
App\Entity\Protocol
  • The association App\Entity\Protocol#User refers to the inverse side field App\Entity\User#protocols which does not exist.
App\Entity\Checklist No errors.
App\Entity\Contact
  • The association App\Entity\Contact#favoriteUsers refers to the inverse side field App\Entity\User#favoriteContacts which does not exist.
App\Entity\Project
  • The field App\Entity\Project#media is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Media#project does not contain the required 'inversedBy="media"' attribute.
  • The association App\Entity\Project#projectMembers refers to the inverse side field App\Entity\User#assignedProjects which does not exist.
  • The association App\Entity\Project#user refers to the inverse side field App\Entity\User#projects which does not exist.