Query Metrics

2 Database Queries
2 Different statements
1.10 ms Query time
6 Invalid entities
2 Managed entities

Queries

Group similar statements

default connection

# Time Info
1 0.50 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.u_date AS u_date_5, t0.id AS id_6, t0.sira AS sira_7, t0.code AS code_8, t0.del AS del_9, t0.name AS name_10, t0.url AS url_11, t0.short_name AS short_name_12, t0.site_title AS site_title_13, t0.site_description AS site_description_14 FROM web_site t0 WHERE t0.id = ?
Parameters:
[
  2
]
2 0.61 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.u_date AS u_date_5, t0.id AS id_6, t0.sira AS sira_7, t0.code AS code_8, t0.del AS del_9, t0.title AS title_10, t0.meta_title AS meta_title_11, t0.meta_description AS meta_description_12, t0.site_id AS site_id_13 FROM web_page_source t0 WHERE t0.site_id = ? AND t0.title = ? LIMIT 1
Parameters:
[
  2
  "contact"
]

Database Connections

Name Service
default doctrine.dbal.default_connection
logging doctrine.dbal.logging_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\WebSite 1
App\Entity\WebPageSource 1

Entities Mapping

Class Mapping errors
App\Entity\BaseEntity No errors.
App\Entity\WebSite
  • The mappings App\Entity\WebSite#webCategoryShows and App\Entity\WebCategoryBanner#webSite are inconsistent with each other.
App\Entity\Samples No errors.
App\Entity\CustomerOrder No errors.
App\Entity\CustomerProforma
  • The association App\Entity\CustomerProforma#customer refers to the inverse side field App\Entity\Customer#proforma which does not exist.
  • The association App\Entity\CustomerProforma#paymentTerm refers to the inverse side field App\Entity\PaymentTerm#customerProforma which does not exist.
  • The association App\Entity\CustomerProforma#shippingMethod refers to the inverse side field App\Entity\ShippingMethod#customerProforma which does not exist.
  • The association App\Entity\CustomerProforma#orderStage refers to the inverse side field App\Entity\OrderStage#customerProforma which does not exist.
  • The association App\Entity\CustomerProforma#warehouse refers to the inverse side field App\Entity\Warehouse#customerProforma which does not exist.
  • The association App\Entity\CustomerProforma#contact refers to the inverse side field App\Entity\CustomerContact#customerProforma which does not exist.
  • The association App\Entity\CustomerProforma#multiCurrency refers to the inverse side field App\Entity\MultiCurrency#customerProforma which does not exist.
  • The association App\Entity\CustomerProforma#shipToList refers to the inverse side field App\Entity\CustomerShipToList#customerProforma which does not exist.
  • The association App\Entity\CustomerProforma#postCode refers to the inverse side field App\Entity\PostCode#customerProforma which does not exist.
App\Entity\CustomerInvoice No errors.
App\Entity\WebOrder No errors.
App\Entity\WebCategoryBanner
  • The association App\Entity\WebCategoryBanner#category refers to the inverse side field App\Entity\Category#webCategoryBanners which does not exist.
App\Entity\WebFaq No errors.
App\Entity\WebPageSource No errors.
App\Entity\WebContactForm No errors.
App\Entity\WebBanner No errors.
App\Entity\WebBlogCategory No errors.
App\Entity\WebBlog No errors.
App\Entity\WebSocial No errors.
App\Entity\WebItem
  • The association App\Entity\WebItem#categories refers to the inverse side field App\Entity\Category#webItems which does not exist.
App\Entity\WebItemDetail
  • The association App\Entity\WebItemDetail#item refers to the inverse side field App\Entity\Item#webItemDetails which does not exist.
  • The association App\Entity\WebItemDetail#zoneCourier refers to the inverse side field App\Entity\ZoneCourier#webItemDetails which does not exist.
App\Entity\WebItemInfoOption No errors.
App\Entity\WebLabel No errors.
App\Entity\WebCareDelivery No errors.
App\Entity\WebItemReview No errors.
App\Entity\WebItemQuestion No errors.
App\Entity\WebPage No errors.
App\Entity\Customer No errors.
App\Entity\CustomerContact
  • The mappings App\Entity\CustomerContact#customerNotes and App\Entity\CustomerNotes#contact are inconsistent with each other.