Query Metrics

3 Database Queries
3 Different statements
26.93 ms Query time
7 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 0.74 ms
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.department AS department_4, t0.position AS position_5, t0.email AS email_6, t0.password AS password_7, t0.phone AS phone_8, t0.mobile AS mobile_9, t0.website AS website_10, t0.roles AS roles_11, t0.activation_token AS activation_token_12, t0.activation_token_created_at AS activation_token_created_at_13, t0.is_enabled AS is_enabled_14, t0.expire_at AS expire_at_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.application_master AS application_master_18, t0.lang AS lang_19, t0.customer_associated  AS customer_associated_20, t0.hide_in_pa AS hide_in_pa_21, t0.is_hotline AS is_hotline_22, t0.customer_id AS customer_id_23, t0.profile_picture_id AS profile_picture_id_24 FROM user t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "bechir.f@axelites.com"
]
2 20.42 ms
SELECT i0_.id AS id_0, i0_.model AS model_1, i0_.status AS status_2, i0_.created_at AS created_at_3, i0_.updated_at AS updated_at_4, i0_.message AS message_5, i0_.file AS file_6, i0_.site_id AS site_id_7, i0_.params AS params_8, i0_.document_id AS document_id_9, i0_.user_id AS user_id_10 FROM import i0_ WHERE i0_.site_id = ? AND i0_.model = ? AND i0_.status IN (?, ?) ORDER BY i0_.id ASC LIMIT 30
Parameters:
[
  "38319"
  "App\Command\EvaluationImportCommand"
  "processing"
  "pending"
]
3 5.76 ms
SELECT count(i0_.id) AS sclr_0 FROM import i0_ WHERE i0_.site_id = ? AND i0_.model = ? AND i0_.status IN (?, ?)
Parameters:
[
  "38319"
  "App\Command\EvaluationImportCommand"
  "processing"
  "pending"
]

Database Connections

Name Service
default doctrine.dbal.default_connection
bechir doctrine.dbal.bechir_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
bechir doctrine.orm.bechir_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class Mapping errors
App\Entity\Import No errors.
App\Entity\User
  • The association App\Entity\User#exports refers to the owning side field App\Entity\Export#userId which does not exist.
App\Entity\Customer
  • The field App\Entity\Customer#sites is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Site#customer does not contain the required 'inversedBy="sites"' attribute.
App\Entity\Media No errors.
App\Entity\UserSite No errors.
App\Entity\Export
  • The mappings App\Entity\Export#user and App\Entity\User#exports are inconsistent with each other.
App\Entity\Affectation
  • The mappings App\Entity\Affectation#createdBy and App\Entity\User#affectations are inconsistent with each other.
App\Entity\Discussion
  • The field App\Entity\Discussion#messages is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Message#discussion does not contain the required 'inversedBy="messages"' attribute.
App\Entity\SiteQuestions No errors.
App\Entity\ActionPlan
  • The field App\Entity\ActionPlan#evaluation is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Evaluation#actionPlans does not contain the required 'mappedBy="evaluation"' attribute.
App\Entity\Site
  • The field App\Entity\Site#evaluations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Evaluation#site does not contain the required 'inversedBy="evaluations"' attribute.
App\Entity\Document No errors.

bechir entity manager

Class Mapping errors
App\Entity\Import No errors.