Query Metrics
7
Database Queries
7
Different statements
10.11 ms
Query time
0
Invalid entities
8
Managed entities
Queries
| #▲ | 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
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\AbstractDeclaration | No errors. |
| App\Entity\Person | No errors. |
| App\Entity\RealEstateProperty | No errors. |
| App\Entity\Invoice | No errors. |
| App\Entity\Company | No errors. |
| App\Entity\Shareholder | No errors. |
| App\Entity\OtherDeclaration | No errors. |
| App\Entity\FileFTO | No errors. |
| App\Entity\Product | No errors. |
| App\Entity\Comment | No errors. |
| App\Entity\AdministrativeForm | No errors. |
| App\Entity\Order | No errors. |
| App\Entity\DeclarationDocument | No errors. |
| App\Entity\Payment | No errors. |
| App\Entity\OrderItem | No errors. |