GET https://loumee.ayyma.fr/simulateur/liverpool

Query Metrics

8 Database Queries
8 Different statements
2.49 ms Query time
0 Invalid entities
14 Managed entities

Queries

Group similar statements

# 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.