Query Metrics
240
Database Queries
5
Different statements
41.43 ms
Query time
10
Invalid entities
925
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
37.43 ms (90.34%) |
236 |
SELECT t0.quantity AS quantity_1, t0.price AS price_2, t0.tva AS tva_3, t0.discount_amount AS discount_amount_4, t0.discount_type AS discount_type_5, t0.total_ht AS total_ht_6, t0.total_ttc AS total_ttc_7, t0.description AS description_8, t0.id AS id_9, t0.quote_id AS quote_id_10 FROM quotes_lines t0 WHERE t0.quote_id = ?
Parameters:
[
928
]
|
|
1.67 ms (4.04%) |
1 |
SELECT q0_.validity AS validity_0, q0_.tva AS tva_1, q0_.discount_amount AS discount_amount_2, q0_.discount_type AS discount_type_3, q0_.payment_method AS payment_method_4, q0_.status AS status_5, q0_.reference AS reference_6, q0_.acompte_ht AS acompte_ht_7, q0_.universign_tx AS universign_tx_8, q0_.sms_code AS sms_code_9, q0_.sms_retry AS sms_retry_10, q0_.sms_phone AS sms_phone_11, q0_.id AS id_12, q0_.token AS token_13, q0_.date_created AS date_created_14, q0_.date_updated AS date_updated_15, q0_.customer_id AS customer_id_16 FROM quotes q0_ WHERE (q0_.date_created BETWEEN ? AND ?) AND q0_.status <> ?
Parameters:
[ "2025-02-15 00:00:00" "2026-02-15 23:59:59" "Provisoire" ] |
|
1.31 ms (3.16%) |
1 |
SELECT p0_.payment_intent AS payment_intent_0, p0_.status AS status_1, p0_.amount AS amount_2, p0_.id AS id_3, p0_.date_created AS date_created_4, p0_.date_updated AS date_updated_5, p0_.invoice_id AS invoice_id_6, p0_.customer_id AS customer_id_7, p0_.webhosting_id AS webhosting_id_8 FROM payments p0_ WHERE (p0_.date_created BETWEEN ? AND ?) AND p0_.status = ? ORDER BY p0_.date_created ASC
Parameters:
[ "2025-02-15 00:00:00" "2026-02-15 23:59:59" "succeeded" ] |
|
0.83 ms (2.00%) |
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_.date_created BETWEEN ? AND ?
Parameters:
[ "2025-02-15 00:00:00" "2026-02-15 23:59:59" ] |
|
0.19 ms (0.46%) |
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 | 276 |
| App\Entity\QuotesLines | 257 |
| App\Entity\Quotes | 236 |
| App\Entity\Payments | 78 |
| App\Entity\Invoices | 77 |
| App\Entity\User | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User |
|
| App\Entity\Customers |
|
| App\Entity\Webhostings |
|
| App\Entity\WebhostingsDomains |
|
| App\Entity\Cart | No errors. |
| App\Entity\Modules |
|
| App\Entity\Themes |
|
| App\Entity\Downloads | No errors. |
| App\Entity\Formation | No errors. |
| App\Entity\Quotes |
|
| App\Entity\Invoices |
|
| App\Entity\Contracts | No errors. |
| App\Entity\Payments | No errors. |
| App\Entity\CustomersContacts |
|
| App\Entity\QuotesLines |
|
| App\Entity\ContactsEmails | No errors. |