Query Metrics
8
Database Queries
8
Different statements
2.49 ms
Query time
0
Invalid entities
14
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.97 ms |
SELECT t0.id AS id_1, t0.name_company AS name_company_2, t0.mobile AS mobile_3, t0.email AS email_4, t0.location AS location_5, t0.uuid AS uuid_6, t0.actif AS actif_7, t0.vat_number AS vat_number_8, t0.siret AS siret_9, t0.billing_street AS billing_street_10, t0.billing_postal_code AS billing_postal_code_11, t0.billing_city AS billing_city_12, t0.calendar_link AS calendar_link_13, t0.logo AS logo_14, t0.slug AS slug_15, t0.cost_per_wc AS cost_per_wc_16, t0.panel_watt AS panel_watt_17, t0.electricity_price AS electricity_price_18, t0.autoconsumption_ratio AS autoconsumption_ratio_19, t0.show_cost_roi AS show_cost_roi_20, t0.custom_fields_limit AS custom_fields_limit_21 FROM company t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"liverpool"
]
|
| 2 | 0.32 ms |
SELECT c0_.id AS id_0, c0_.stat_date AS stat_date_1, c0_.clicks AS clicks_2, c0_.form_submissions AS form_submissions_3, c0_.updated_at AS updated_at_4, c0_.company_id AS company_id_5 FROM company_link_stats c0_ WHERE c0_.company_id = ? AND c0_.stat_date = ?
Parameters:
[ 17 "2026-07-26 00:00:00" ] |
| 3 | 0.11 ms |
"START TRANSACTION"
Parameters:
[] |
| 4 | 0.21 ms |
UPDATE company_link_stats SET clicks = ?, updated_at = ? WHERE id = ?
Parameters:
[ 4 "2026-07-26 20:13:52" 33 ] |
| 5 | 0.09 ms |
"COMMIT"
Parameters:
[] |
| 6 | 0.30 ms |
SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.montant AS montant_2, a0_.description AS description_3, a0_.url AS url_4, a0_.actif AS actif_5, a0_.position AS position_6, a0_.created_at AS created_at_7, CASE WHEN a0_.company_id IS NULL THEN 0 ELSE 1 END AS sclr_8, a0_.company_id AS company_id_9 FROM aide a0_ WHERE a0_.actif = 1 AND (a0_.company_id IS NULL OR a0_.company_id = ?) ORDER BY sclr_8 ASC, a0_.position ASC, a0_.id ASC
Parameters:
[
17
]
|
| 7 | 0.30 ms |
SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.vat_number AS vat_number_3, t0.email AS email_4, t0.plan AS plan_5, t0.intervale AS intervale_6, t0.stripe_customer_id AS stripe_customer_id_7, t0.stripe_session_id AS stripe_session_id_8, t0.status AS status_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.location AS location_12, t0.billing_street AS billing_street_13, t0.billing_postal_code AS billing_postal_code_14, t0.billing_city AS billing_city_15, t0.mobile AS mobile_16, t0.stripe_subscription_id AS stripe_subscription_id_17, t0.ends_at AS ends_at_18, t0.monthly_amount AS monthly_amount_19, t0.company_id AS company_id_20, t0.promo_code_id AS promo_code_id_21 FROM subscription t0 WHERE t0.company_id = ?
Parameters:
[
17
]
|
| 8 | 0.18 ms |
SELECT e0_.id AS id_0, e0_.libelle AS libelle_1 FROM energy_supplier e0_
Parameters:
[] |
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\EnergySupplier | 10 |
| App\Entity\Company | 1 |
| App\Entity\CompanyLinkStats | 1 |
| App\Entity\Subscription | 1 |
| App\Entity\PromoCode | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Company | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Projets | No errors. |
| App\Entity\Subscription | No errors. |
| App\Entity\CustomFormField | No errors. |
| App\Entity\TrackingLink | No errors. |
| App\Entity\CompanyLinkStats | No errors. |
| App\Entity\Aide | No errors. |
| App\Entity\PromoCode | No errors. |
| App\Entity\EnergySupplier | No errors. |