POST https://jonathan-websource.websrc.fr/admin/customers/api/datas

Query Metrics

104 Database Queries
5 Different statements
23.27 ms Query time
9 Invalid entities
1062 Managed entities

Grouped Statements

Show all queries

Time Count Info
11.05 ms
(47.49%)
50
SELECT t0.username AS username_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.lastname AS lastname_5, t0.firstname AS firstname_6, t0.last_login AS last_login_7, t0.password_request_at AS password_request_at_8, t0.token AS token_9, t0.api_key AS api_key_10, t0.last_activity AS last_activity_11, t0.newsletter AS newsletter_12, t0.avatar AS avatar_13, t0.phone AS phone_14, t0.poste AS poste_15, t0.bio AS bio_16, t0.url AS url_17, t0.linkedin AS linkedin_18, t0.twitter AS twitter_19, t0.works_for AS works_for_20, t0.stripe_account AS stripe_account_21, t0.id AS id_22, t0.date_created AS date_created_23, t0.date_updated AS date_updated_24, t0.active AS active_25, t0.customer_id AS customer_id_26 FROM user t0 WHERE t0.customer_id = ?
Parameters:
[
  1045
]
9.16 ms
(39.37%)
50
SELECT t0.email AS email_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.main AS main_4, t0.id AS id_5, t0.customer_id AS customer_id_6 FROM customers_contacts t0 WHERE t0.customer_id = ?
Parameters:
[
  1045
]
2.43 ms
(10.45%)
2
SELECT c0_.name AS name_0, c0_.tva AS tva_1, c0_.siret AS siret_2, c0_.address AS address_3, c0_.address2 AS address2_4, c0_.zip_code AS zip_code_5, c0_.city AS city_6, c0_.country AS country_7, c0_.website AS website_8, c0_.phone AS phone_9, c0_.type AS type_10, c0_.firstname AS firstname_11, c0_.lastname AS lastname_12, c0_.email AS email_13, c0_.stripe_customer_key AS stripe_customer_key_14, c0_.id AS id_15, c0_.date_created AS date_created_16, c0_.date_updated AS date_updated_17 FROM customers c0_ WHERE c0_.email LIKE ? OR c0_.name LIKE ? OR c0_.tva LIKE ? OR c0_.firstname LIKE ? OR c0_.lastname LIKE ? OR c0_.siret LIKE ? OR c0_.address LIKE ? OR c0_.address2 LIKE ? OR c0_.zip_code LIKE ? OR c0_.city LIKE ? OR c0_.country LIKE ? OR c0_.website LIKE ? OR c0_.phone LIKE ? OR c0_.type LIKE ? OR c0_.date_created LIKE ? OR c0_.date_updated LIKE ?
Parameters:
[
  "%%"
  "%%"
  "%%"
  "%%"
  "%%"
  "%%"
  "%%"
  "%%"
  "%%"
  "%%"
  "%%"
  "%%"
  "%%"
  "%%"
  "%%"
  "%%"
]
0.38 ms
(1.63%)
1
SELECT c0_.name AS name_0, c0_.tva AS tva_1, c0_.siret AS siret_2, c0_.address AS address_3, c0_.address2 AS address2_4, c0_.zip_code AS zip_code_5, c0_.city AS city_6, c0_.country AS country_7, c0_.website AS website_8, c0_.phone AS phone_9, c0_.type AS type_10, c0_.firstname AS firstname_11, c0_.lastname AS lastname_12, c0_.email AS email_13, c0_.stripe_customer_key AS stripe_customer_key_14, c0_.id AS id_15, c0_.date_created AS date_created_16, c0_.date_updated AS date_updated_17 FROM customers c0_ WHERE c0_.email LIKE ? OR c0_.name LIKE ? OR c0_.tva LIKE ? OR c0_.firstname LIKE ? OR c0_.lastname LIKE ? OR c0_.siret LIKE ? OR c0_.address LIKE ? OR c0_.address2 LIKE ? OR c0_.zip_code LIKE ? OR c0_.city LIKE ? OR c0_.country LIKE ? OR c0_.website LIKE ? OR c0_.phone LIKE ? OR c0_.type LIKE ? OR c0_.date_created LIKE ? OR c0_.date_updated LIKE ? ORDER BY c0_.id DESC LIMIT 50
Parameters:
[
  "%%"
  "%%"
  "%%"
  "%%"
  "%%"
  "%%"
  "%%"
  "%%"
  "%%"
  "%%"
  "%%"
  "%%"
  "%%"
  "%%"
  "%%"
  "%%"
]
0.25 ms
(1.06%)
1
SELECT t0.username AS username_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.lastname AS lastname_5, t0.firstname AS firstname_6, t0.last_login AS last_login_7, t0.password_request_at AS password_request_at_8, t0.token AS token_9, t0.api_key AS api_key_10, t0.last_activity AS last_activity_11, t0.newsletter AS newsletter_12, t0.avatar AS avatar_13, t0.phone AS phone_14, t0.poste AS poste_15, t0.bio AS bio_16, t0.url AS url_17, t0.linkedin AS linkedin_18, t0.twitter AS twitter_19, t0.works_for AS works_for_20, t0.stripe_account AS stripe_account_21, t0.id AS id_22, t0.date_created AS date_created_23, t0.date_updated AS date_updated_24, t0.active AS active_25, t0.customer_id AS customer_id_26 FROM user t0 WHERE t0.id = ?
Parameters:
[
  1
]

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\Customers 1022
App\Entity\CustomersContacts 33
App\Entity\User 7

Entities Mapping

Class Mapping errors
App\Entity\User
  • The association App\Entity\User#webhostings refers to the owning side field App\Entity\Webhostings#users which does not exist.
  • The association App\Entity\User#domains refers to the owning side field App\Entity\WebhostingsDomains#users which does not exist.
  • The field App\Entity\User#carts is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Cart#user does not contain the required 'inversedBy: "carts"' attribute.
App\Entity\Customers
  • The mappings App\Entity\Customers#customersContacts and App\Entity\CustomersContacts#customer are inconsistent with each other.
App\Entity\Webhostings
  • The mappings App\Entity\Webhostings#user and App\Entity\User#webhostings are inconsistent with each other.
App\Entity\WebhostingsDomains
  • The mappings App\Entity\WebhostingsDomains#user and App\Entity\User#domains are inconsistent with each other.
App\Entity\Cart No errors.
App\Entity\Modules
  • The field App\Entity\Modules#cartDetails is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\CartDetails#module does not contain the required 'inversedBy: "cartDetails"' attribute.
App\Entity\Themes
  • The association App\Entity\Themes#reviews refers to the inverse side field App\Entity\Reviews#themes which does not exist.
App\Entity\Downloads No errors.
App\Entity\Formation No errors.
App\Entity\Quotes
  • The field 'App\Entity\Quotes#tva' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\Invoices
  • The field 'App\Entity\Invoices#tva' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The association App\Entity\Invoices#cart refers to the inverse side field App\Entity\Cart#invoices which does not exist.
App\Entity\Contracts No errors.
App\Entity\Payments No errors.
App\Entity\CustomersContacts
  • The association App\Entity\CustomersContacts#customer refers to the inverse side field App\Entity\Customers#contacts which does not exist.
App\Entity\ContactsEmails No errors.