POST https://dev-requeteur.optindata.fr/admin/users/019ecb3f-4f8e-73ee-b8e0-39c370b79e56/saleRef?r=admin%2Fusers%2F019ecb3f-4f8e-73ee-b8e0-39c370b79e56%2FsaleRef

Query Metrics

6 Database Queries
4 Different statements
2.21 ms Query time
1 Invalid entities
42 Managed entities

Queries

Group similar statements

# Time Info
1 0.45 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.value AS value_2, s0_.description AS description_3 FROM system_setting s0_ WHERE s0_.name = ?
Parameters:
[
  "api.gocad.username"
]
2 0.17 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.value AS value_2, s0_.description AS description_3 FROM system_setting s0_ WHERE s0_.name = ?
Parameters:
[
  "api.gocad.password"
]
3 0.25 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.enabled AS enabled_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.email_token AS email_token_8, t0.is_password_set AS is_password_set_9, t0.email_token_date AS email_token_date_10, t11.id AS id_12, t11.firstname AS firstname_13, t11.lastname AS lastname_14, t11.email AS email_15, t11.phone AS phone_16, t11.user_id AS user_id_17, t11.function_id AS function_id_18, t11.address_id AS address_id_19, t0.default_btob_territory_id AS default_btob_territory_id_20, t0.default_btoc_territory_id AS default_btoc_territory_id_21, t0.login_message_id AS login_message_id_22 FROM `user` t0 LEFT JOIN profile t11 ON t11.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  b"\x01žË9“À{©©±õ·\x12òõU"
]
4 0.48 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.enabled AS enabled_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.email_token AS email_token_8, t0.is_password_set AS is_password_set_9, t0.email_token_date AS email_token_date_10, t11.id AS id_12, t11.firstname AS firstname_13, t11.lastname AS lastname_14, t11.email AS email_15, t11.phone AS phone_16, t11.user_id AS user_id_17, t11.function_id AS function_id_18, t11.address_id AS address_id_19, t0.default_btob_territory_id AS default_btob_territory_id_20, t0.default_btoc_territory_id AS default_btoc_territory_id_21, t0.login_message_id AS login_message_id_22 FROM `user` t0 LEFT JOIN profile t11 ON t11.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  b"\x01žË?OŽsî¸à9Ãp·žV"
]
5 0.34 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.social_reason AS social_reason_3, t0.commercial_name AS commercial_name_4, t0.enabled AS enabled_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.subscribed AS subscribed_8, t0.subscription AS subscription_9, t0.license_siv AS license_siv_10, t0.subscription_type AS subscription_type_11, t0.phone AS phone_12, t0.netsuite_id AS netsuite_id_13, t0.netsuite_periodicity AS netsuite_periodicity_14, t0.network_id AS network_id_15, t16.id AS id_17, t16.code AS code_18, t16.name AS name_19, t16.description AS description_20, t16.enabled AS enabled_21, t16.logo AS logo_22, t16.icon AS icon_23, t16.menu_logo AS menu_logo_24, t16.gocad_id AS gocad_id_25, t16.gocad_server_id AS gocad_server_id_26, t16.db_sources AS db_sources_27, t16.conditions_generales AS conditions_generales_28, t16.devis_payment_mode AS devis_payment_mode_29, t16.devis_legal_payment_mention AS devis_legal_payment_mention_30, t16.devis_bottom_page AS devis_bottom_page_31, t16.devis_logo AS devis_logo_32, t16.reduction AS reduction_33, t16.devis_code AS devis_code_34, t16.free_fiche AS free_fiche_35, t16.decimal_precision AS decimal_precision_36, t16.default_subscription_price_id AS default_subscription_price_id_37, t16.type_id AS type_id_38, t16.billing_information_id AS billing_information_id_39, t16.subscription_price_id AS subscription_price_id_40, t0.subscription_price_id AS subscription_price_id_41, t0.alternative_billing_information_id AS alternative_billing_information_id_42, t0.split_id AS split_id_43, t0.type_id AS type_id_44 FROM sale_ref t0 INNER JOIN network t16 ON t0.network_id = t16.id INNER JOIN user_sale_ref ON t0.id = user_sale_ref.sale_ref_id WHERE user_sale_ref.user_id = ?
Parameters:
[
  b"\x01žË?OŽsî¸à9Ãp·žV"
]
6 0.53 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.social_reason AS social_reason_3, t0.enabled AS enabled_4, t0.iban AS iban_5, t0.bic AS bic_6, t0.bank_label AS bank_label_7, t0.sale_ref_id AS sale_ref_id_8, t0.type_id AS type_id_9, t0.address_id AS address_id_10 FROM billing_information t0 WHERE t0.sale_ref_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  2
  89
  90
  91
  92
  93
  94
  131
  143
]

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\Address 10
App\Entity\BillingInformation 10
App\Entity\SaleRef 9
App\Entity\Referential 5
App\Entity\SystemSetting 2
App\Entity\User 2
App\Entity\Profile 2
App\Entity\Network 1
App\Entity\Price 1

Entities Mapping

Class Mapping errors
App\Entity\SystemSetting No errors.
App\Entity\User
  • The association App\Entity\User#loginMessage refers to the inverse side field App\Entity\LoginMessage#viewedUsers which does not exist.
App\Entity\Profile No errors.
App\Entity\Referential No errors.
App\Entity\RefProfileFunction No errors.
App\Entity\Address No errors.
App\Entity\Territory No errors.
App\Entity\LoginMessage No errors.
App\Entity\SaleRef No errors.
App\Entity\UserConnections No errors.
App\Entity\Network No errors.
App\Entity\Price No errors.
App\Entity\RefNetworkType No errors.
App\Entity\BillingInformation No errors.
App\Entity\RefMapType No errors.
App\Entity\RefSaleRefType No errors.
App\Entity\PriceGrid No errors.
App\Entity\NetworkFixedFee No errors.
App\Entity\RefBillingInformation No errors.