GET https://pep.devlogiciel.com/tarifs

Query Metrics

12 Database Queries
4 Different statements
9.32 ms Query time
0 Invalid entities
122 Managed entities

Grouped Statements

Show all queries

Time Count Info
4.20 ms
(45.09%)
7
SELECT f0_.id AS id_0, f0_.code AS code_1, f0_.label AS label_2, f0_.description AS description_3, f0_.type AS type_4, f0_.created_at AS created_at_5, f0_.updated_at AS updated_at_6, f0_.deleted_at AS deleted_at_7, f0_.deleted AS deleted_8 FROM functionality f0_ INNER JOIN functionality_tag f2_ ON f0_.id = f2_.functionality_id INNER JOIN tag t1_ ON t1_.id = f2_.tag_id WHERE t1_.id = ?
Parameters:
[
  40
]
2.13 ms
(22.80%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.badge_label AS badge_label_3, t0.monthly_price AS monthly_price_4, t0.currency AS currency_5, t0.position AS position_6, t0.is_active AS is_active_7, t0.is_published AS is_published_8, t0.cta_label AS cta_label_9, t0.cta_url AS cta_url_10, t0.level AS level_11, t0.stripe_product_id AS stripe_product_id_12, t0.stripe_price_monthly_id AS stripe_price_monthly_id_13, t0.stripe_price_annual_id AS stripe_price_annual_id_14, t0.stripe_tax_rate_id AS stripe_tax_rate_id_15, t0.monthly_rate AS monthly_rate_16, t0.features AS features_17 FROM pricing_plan t0 WHERE t0.is_active = ? AND t0.is_published = ? ORDER BY t0.position ASC
Parameters:
[
  1
  1
]
1.68 ms
(18.07%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.color AS color_4, t0.context AS context_5 FROM tag t0 WHERE t0.context = ? ORDER BY t0.id ASC
Parameters:
[
  "pricing"
]
1.31 ms
(14.04%)
3
SELECT t0.id AS id_1, t0.numeric_value AS numeric_value_2, t0.is_enabled AS is_enabled_3, t0.plan_id AS plan_id_4, t0.functionality_id AS functionality_id_5 FROM plan_feature t0 WHERE t0.plan_id = ?
Parameters:
[
  3
]

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\PlanFeature 84
App\Entity\Functionality 28
App\Entity\Tag 7
App\Entity\PricingPlan 3