GET https://demo.churchmanager.fr/blog/post/pourquoi-utiliser-une-application-de-gestion-pour-son-eglise

Query Metrics

13 Database Queries
7 Different statements
10.80 ms Query time
0 Invalid entities
6 Managed entities

Grouped Statements

Show all queries

Time Count Info
2.96 ms
(27.41%)
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"
]
2.48 ms
(22.95%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.updated_at AS updated_at_4, t0.created_at AS created_at_5 FROM tag t0 INNER JOIN tag_post ON t0.id = tag_post.tag_id WHERE tag_post.post_id = ?
Parameters:
[
  1
]
1.91 ms
(17.71%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.short_description AS short_description_5, t0.thumbnail AS thumbnail_6, t0.main_image AS main_image_7, t0.published AS published_8, t0.featured AS featured_9, t0.updated_at AS updated_at_10, t0.created_at AS created_at_11, t0.category_id AS category_id_12 FROM post t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "pourquoi-utiliser-une-application-de-gestion-pour-son-eglise"
]
1.49 ms
(13.79%)
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
]
0.84 ms
(7.73%)
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
]
0.73 ms
(6.79%)
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
]
0.39 ms
(3.61%)
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\Tag 4
App\Entity\Post 1
App\Entity\Manager 1

Entities Mapping

Class Mapping errors
App\Entity\SeoCity No errors.
App\Entity\SeoCountry No errors.
App\Entity\Post No errors.
App\Entity\Category No errors.
App\Entity\Viewer No errors.
App\Entity\Like No errors.
App\Entity\Tag No errors.
App\Entity\GoogleReview No errors.
App\Entity\Manager No errors.
App\Entity\SocialMedia No errors.