Query Metrics
12
Database Queries
4
Different statements
9.32 ms
Query time
0
Invalid entities
122
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2.13 ms |
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 ]
|
||||||||||||||||||||||||||||||||
| 2 | 1.68 ms |
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"
]
|
||||||||||||||||||||||||||||||||
| 3 | 1.63 ms |
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
]
|
||||||||||||||||||||||||||||||||
| 4 | 0.69 ms |
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
]
|
||||||||||||||||||||||||||||||||
| 5 | 0.40 ms |
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:
[
4
]
|
||||||||||||||||||||||||||||||||
| 6 | 0.22 ms |
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:
[
5
]
|
||||||||||||||||||||||||||||||||
| 7 | 0.49 ms |
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:
[
41
]
|
||||||||||||||||||||||||||||||||
| 8 | 0.46 ms |
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:
[
42
]
|
||||||||||||||||||||||||||||||||
| 9 | 0.41 ms |
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:
[
43
]
|
||||||||||||||||||||||||||||||||
| 10 | 0.41 ms |
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:
[
44
]
|
||||||||||||||||||||||||||||||||
| 11 | 0.41 ms |
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:
[
45
]
|
||||||||||||||||||||||||||||||||
| 12 | 0.39 ms |
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:
[
46
]
|
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 |