GET http://192.168.2.8:8888/cron/notificationsDocuments/dshsqcfqs44567vsd437Vdfdfsgvs47653

Response
200 OK
IP
192.168.2.8
Profiled on
Token
8f9e3f

Query Metrics

1 Database Queries
1 Different statements
30.94 ms Query time
5 Invalid entities
17 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
30.94 ms
(100.00%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.needs_an_answer AS needs_an_answer_4, t0.deadline AS deadline_5, t0.created_at AS created_at_6, t0.deleted AS deleted_7, t0.response_received AS response_received_8, t0.invoice_number AS invoice_number_9, t0.invoice_date AS invoice_date_10, t0.invoice_amount_letter AS invoice_amount_letter_11, t0.manager AS manager_12, t0.contract AS contract_13, t0.remarks AS remarks_14, t0.client_address AS client_address_15, t0.tva0 AS tva0_16, t0.tva6 AS tva6_17, t0.tva21 AS tva21_18, t0.designation AS designation_19, t0.sent_to_client AS sent_to_client_20, t0.total_amount AS total_amount_21, t0.invoice_amounts_combined AS invoice_amounts_combined_22, t0.adjudicator AS adjudicator_23, t0.deposit AS deposit_24, t0.mail_status_id AS mail_status_id_25, t0.chief_id AS chief_id_26, t0.created_by_id AS created_by_id_27, t0.invoice_id AS invoice_id_28, t0.progress_annex_id AS progress_annex_id_29 FROM mail t0 WHERE t0.response_received = ? AND t0.needs_an_answer = ? AND t0.deleted = ?
Parameters: 
[
  0
  1
  0
]
View formatted query    View runnable query    Explain query

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\Mail 8
App\Entity\MailStatus 5
App\Entity\User 4

Entities Mapping

Class Mapping errors
App\Entity\Mail
  • The mappings App\Entity\Mail#createdBy and App\Entity\User#createMail are inconsistent with each other.
App\Entity\MailStatus No errors.
App\Entity\User
  • The association App\Entity\User#constructionSites refers to the owning side field App\Entity\ConstructionSite#projectManager which is not defined as association, but as field.
  • The association App\Entity\User#constructionSites refers to the owning side field App\Entity\ConstructionSite#projectManager which does not exist.
  • The association App\Entity\User#createMail refers to the owning side field App\Entity\Mail#created_by which does not exist.
  • The field App\Entity\User#invoiceTypeUsers is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\InvoiceTypeUser#user does not contain the required 'inversedBy="invoiceTypeUsers"' attribute.
App\Entity\Invoice
  • The association App\Entity\Invoice#invoiceAmounts refers to the owning side field App\Entity\InvoiceAmount#invoice which does not exist.
App\Entity\Progress
  • The association App\Entity\Progress#reviewFormulas refers to the owning side field App\Entity\ReviewFormula#progress which does not exist.
App\Entity\ConstructionSite
  • The mappings App\Entity\ConstructionSite#contractingAuthority and App\Entity\Company#constructionSites are inconsistent with each other.
  • The mappings App\Entity\ConstructionSite#chief and App\Entity\User#constructionSites are inconsistent with each other.
  • The association App\Entity\ConstructionSite#constructionSites refers to the owning side field App\Entity\ConstructionSite#constructionSiteOffer which does not exist.
  • The mappings App\Entity\ConstructionSite#secondChief and App\Entity\User#constructionSites are inconsistent with each other.
App\Entity\ReturnMailStatus No errors.
App\Entity\Reminder No errors.
App\Entity\ReturnMailMessage No errors.
App\Entity\HistoryAction No errors.
App\Entity\InvoiceAmount No errors.