GET https://demo.churchmanager.fr/pricing

Query Metrics

15 Database Queries
7 Different statements
29.96 ms Query time
0 Invalid entities
1 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
14.64 ms
(48.86%)
1
SELECT p0_.id AS id_0, p0_.label AS label_1, p0_.value_type AS value_type_2, p0_.value AS value_3, p0_.tooltip AS tooltip_4, p0_.position AS position_5, p0_.updated_at AS updated_at_6, p0_.created_at AS created_at_7, p0_.category_id AS category_id_8, p0_.packaging_id AS packaging_id_9 FROM packaging_feature p0_ INNER JOIN packaging_feature_category p1_ ON p0_.category_id = p1_.id INNER JOIN packaging p2_ ON p0_.packaging_id = p2_.id WHERE p0_.packaging_id IN (?, ?, ?) ORDER BY p1_.position ASC, p0_.position ASC
Parameters:
[
  1
  2
  3
]
7.31 ms
(24.39%)
7
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.complete_address AS complete_address_4, t0.number AS number_5, t0.description AS description_6, t0.siret AS siret_7, t0.siren AS siren_8, t0.day_limit_subscription AS day_limit_subscription_9, t0.trial_period_days_time AS trial_period_days_time_10, t0.trial_period_days_status AS trial_period_days_status_11, t0.type AS type_12, t0.website AS website_13, t0.capital_social AS capital_social_14, t0.updated_at AS updated_at_15, t0.created_at AS created_at_16 FROM manager t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
  "manager"
]
3.33 ms
(11.13%)
3
SELECT h0_.id AS id_0, h0_.name AS name_1, h0_.position AS position_2, h0_.type AS type_3, h0_.content AS content_4, h0_.is_active AS is_active_5, h0_.priority AS priority_6, h0_.uuid AS uuid_7, h0_.updated_at AS updated_at_8, h0_.created_at AS created_at_9 FROM head_tag h0_ WHERE h0_.position = ? AND h0_.is_active = ? ORDER BY h0_.priority DESC, h0_.id ASC
Parameters:
[
  "head"
  1
]
1.28 ms
(4.28%)
1
SELECT t0.id AS id_1, t0.author_name AS author_name_2, t0.author_url AS author_url_3, t0.profile_photo_url AS profile_photo_url_4, t0.rating AS rating_5, t0.text AS text_6, t0.time AS time_7, t0.is_active AS is_active_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM google_reviews t0 WHERE t0.is_active = ? ORDER BY t0.rating DESC, t0.created_at DESC LIMIT 50
Parameters:
[
  1
]
1.27 ms
(4.25%)
1
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.meta_title AS meta_title_3, s0_.meta_description AS meta_description_4, s0_.h1 AS h1_5, s0_.content AS content_6, s0_.keywords AS keywords_7, s0_.is_active AS is_active_8, s0_.postal_code AS postal_code_9, s0_.region AS region_10, s0_.country AS country_11, s0_.city_image AS city_image_12, s0_.created_at AS created_at_13, s0_.updated_at AS updated_at_14 FROM seo_city s0_ WHERE s0_.is_active = ? ORDER BY s0_.name ASC
Parameters:
[
  1
]
1.11 ms
(3.71%)
1
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.meta_title AS meta_title_3, s0_.meta_description AS meta_description_4, s0_.h1 AS h1_5, s0_.content AS content_6, s0_.keywords AS keywords_7, s0_.is_active AS is_active_8, s0_.country_code AS country_code_9, s0_.continent AS continent_10, s0_.language AS language_11, s0_.created_at AS created_at_12, s0_.updated_at AS updated_at_13 FROM seo_country s0_ WHERE s0_.is_active = ? ORDER BY s0_.name ASC
Parameters:
[
  1
]
1.01 ms
(3.37%)
1
SELECT t0.id AS id_1, t0.author_name AS author_name_2, t0.author_url AS author_url_3, t0.profile_photo_url AS profile_photo_url_4, t0.rating AS rating_5, t0.text AS text_6, t0.time AS time_7, t0.is_active AS is_active_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM google_reviews t0 WHERE t0.is_active = ? ORDER BY t0.rating DESC, t0.created_at DESC LIMIT 5
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\Manager 1

Entities Mapping

Class Mapping errors
App\Entity\SeoCity No errors.
App\Entity\SeoCountry No errors.
App\Entity\PackagingFeature No errors.
App\Entity\HeadTag No errors.
App\Entity\GoogleReview No errors.
App\Entity\Manager No errors.
App\Entity\SocialMedia No errors.