GET https://recette26.frenchtaxonline.com/admin/other-declaration/17534/show

Query Metrics

7 Database Queries
7 Different statements
10.11 ms Query time
0 Invalid entities
8 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.79 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.enabled AS enabled_4, t0.salt AS salt_5, t0.password AS password_6, t0.last_login AS last_login_7, t0.confirmation_token AS confirmation_token_8, t0.roles AS roles_9, t0.created_at AS created_at_10, t0.firstname AS firstname_11, t0.lastname AS lastname_12, t0.gender AS gender_13, t0.telephone AS telephone_14, t0.fax AS fax_15, t0.comment AS comment_16, t0.siret AS siret_17, t0.legal_entity AS legal_entity_18, t0.code AS code_19, t0.fip_number AS fip_number_20, t0.activity_start_date AS activity_start_date_21, t0.activity_end_date AS activity_end_date_22, t0.self_tin AS self_tin_23, t0.spouse_tin AS spouse_tin_24, t0.bank_account_iban AS bank_account_iban_25, t0.bank_account_bic AS bank_account_bic_26, t0.bank_account_owner AS bank_account_owner_27, t0.has_no_bank_account AS has_no_bank_account_28, t0.country AS country_29, t0.nationality AS nationality_30, t0.origin AS origin_31, t0.origin_comment AS origin_comment_32 FROM user t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "bertranddilly@yahoo.fr"
]
2 0.73 ms
SELECT t0.id AS id_1, t0.year AS year_2, t0.state AS state_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.validated_at AS validated_at_6, t0.payment_state AS payment_state_7, t0.is_premium AS is_premium_8, t0.admin_comment AS admin_comment_9, t0.admin_payment_comment AS admin_payment_comment_10, t0.has_been_ended_once AS has_been_ended_once_11, t0.admin_state AS admin_state_12, t0.admin_state_updated_at AS admin_state_updated_at_13, t0.admin_payment_state AS admin_payment_state_14, t0.priority AS priority_15, t0.user_id AS user_id_16, t0.pdf_file_id AS pdf_file_id_17, t0.associated_admin_id AS associated_admin_id_18, t0.product_id AS product_id_19, t0.dtype FROM declaration t0 WHERE t0.id = ? AND t0.dtype IN ('other')
Parameters:
[
  "17534"
]
3 0.37 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.enabled AS enabled_4, t0.salt AS salt_5, t0.password AS password_6, t0.last_login AS last_login_7, t0.confirmation_token AS confirmation_token_8, t0.roles AS roles_9, t0.created_at AS created_at_10, t0.firstname AS firstname_11, t0.lastname AS lastname_12, t0.gender AS gender_13, t0.telephone AS telephone_14, t0.fax AS fax_15, t0.comment AS comment_16, t0.siret AS siret_17, t0.legal_entity AS legal_entity_18, t0.code AS code_19, t0.fip_number AS fip_number_20, t0.activity_start_date AS activity_start_date_21, t0.activity_end_date AS activity_end_date_22, t0.self_tin AS self_tin_23, t0.spouse_tin AS spouse_tin_24, t0.bank_account_iban AS bank_account_iban_25, t0.bank_account_bic AS bank_account_bic_26, t0.bank_account_owner AS bank_account_owner_27, t0.has_no_bank_account AS has_no_bank_account_28, t0.country AS country_29, t0.nationality AS nationality_30, t0.origin AS origin_31, t0.origin_comment AS origin_comment_32 FROM user t0 WHERE t0.id = ?
Parameters:
[
  5804
]
4 0.53 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.enabled AS enabled_4 FROM product t0 WHERE t0.id = ?
Parameters:
[
  22
]
5 3.25 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.email AS email_3, t0.pre_tax_total AS pre_tax_total_4, t0.tax_total AS tax_total_5, t0.total AS total_6, t0.declaration_id AS declaration_id_7, t0.user_id AS user_id_8 FROM `order` t0 WHERE t0.declaration_id = ? ORDER BY t0.id DESC
Parameters:
[
  17534
]
6 2.21 ms
SELECT t0.id AS id_1, t0.number AS number_2, t0.amount AS amount_3, t0.created_at AS created_at_4, t0.comment AS comment_5, t0.object AS object_6, t0.applicable_vat AS applicable_vat_7, t0.user_id AS user_id_8, t0.file_id AS file_id_9, t0.declaration_id AS declaration_id_10, t0.related_order_id AS related_order_id_11 FROM invoice t0 WHERE t0.declaration_id = ? ORDER BY t0.id DESC
Parameters:
[
  17534
]
7 2.23 ms
SELECT t0.id AS id_1, t0.step AS step_2, t0.body AS body_3, t0.declaration_id AS declaration_id_4 FROM comment t0 WHERE t0.declaration_id = ?
Parameters:
[
  17534
]

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\User 3
App\Entity\AbstractDeclaration 1
App\Entity\Product 1
App\Entity\Order 1
App\Entity\Invoice 1
App\Entity\FileFTO 1

Entities Mapping