GET https://develop.la-vallee-enchantee.fr/actualites

Query Metrics

9 Database Queries
6 Different statements
3.23 ms Query time
4 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.93 ms
(28.84%)
4
SELECT t0.id AS id_1, t0.name AS name_2 FROM article_category t0 WHERE t0.id = ?
Parameters:
[
  4
]
0.81 ms
(25.12%)
1
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, created_at_12 FROM (SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.summary AS summary_2, a0_.published AS published_3, a0_.picture_name AS picture_name_4, a0_.picture_size AS picture_size_5, a0_.picture_updated_at AS picture_updated_at_6, a0_.picture_alt AS picture_alt_7, a0_.meta_title AS meta_title_8, a0_.meta_description AS meta_description_9, a0_.slug AS slug_10, a0_.updated_at AS updated_at_11, a0_.created_at AS created_at_12 FROM article a0_ WHERE a0_.published = ?) dctrn_result_inner ORDER BY created_at_12 DESC) dctrn_result LIMIT 6
Parameters:
[
  1
]
0.59 ms
(18.40%)
1
SELECT t0.id AS id_1, t0.page_name AS page_name_2, t0.route AS route_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.h1_enabled AS h1_enabled_6, t0.h1 AS h1_7 FROM seopage t0 WHERE t0.route = ? LIMIT 1
Parameters:
[
  "app_article_list"
]
0.33 ms
(10.13%)
1
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.summary AS summary_2, a0_.published AS published_3, a0_.picture_name AS picture_name_4, a0_.picture_size AS picture_size_5, a0_.picture_updated_at AS picture_updated_at_6, a0_.picture_alt AS picture_alt_7, a0_.meta_title AS meta_title_8, a0_.meta_description AS meta_description_9, a0_.slug AS slug_10, a0_.updated_at AS updated_at_11, a0_.created_at AS created_at_12, a0_.updated_by_id AS updated_by_id_13, a0_.created_by_id AS created_by_id_14, a0_.article_category_id AS article_category_id_15 FROM article a0_ WHERE a0_.published = ? AND a0_.id IN (?, ?, ?, ?) ORDER BY a0_.created_at DESC
Parameters:
[
  1
  4
  3
  2
  1
]
0.31 ms
(9.48%)
1
SELECT t0.id AS id_1, t0.phone AS phone_2, t0.email AS email_3, t0.address_street AS address_street_4, t0.zipcode AS zipcode_5, t0.city AS city_6, t0.legal_site_name AS legal_site_name_7, t0.legal_siret AS legal_siret_8, t0.legal_siren AS legal_siren_9, t0.legal_rcs AS legal_rcs_10, t0.legal_address AS legal_address_11, t0.legal_zipcode AS legal_zipcode_12, t0.legal_city AS legal_city_13, t0.legal_phone AS legal_phone_14, t0.legal_email AS legal_email_15, t0.legal_publication_owner AS legal_publication_owner_16, t0.legal_site_url AS legal_site_url_17, t0.default_title AS default_title_18, t0.default_meta_desc AS default_meta_desc_19, t0.schedules_days AS schedules_days_20, t0.schedules_hours AS schedules_hours_21 FROM site_settings t0
Parameters:
[]
0.26 ms
(8.02%)
1
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.summary AS summary_2, a0_.published AS published_3, a0_.picture_name AS picture_name_4, a0_.picture_size AS picture_size_5, a0_.picture_updated_at AS picture_updated_at_6, a0_.picture_alt AS picture_alt_7, a0_.meta_title AS meta_title_8, a0_.meta_description AS meta_description_9, a0_.slug AS slug_10, a0_.updated_at AS updated_at_11, a0_.created_at AS created_at_12 FROM article a0_ WHERE a0_.published = ? ORDER BY a0_.created_at DESC) dctrn_result) dctrn_table
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.

Entities Mapping

Class Mapping errors
Cofondateur\SocleTechniqueBundle\Entity\SEOPage No errors.
App\Entity\SEOPage No errors.
Cofondateur\SocleTechniqueBundle\Entity\SiteSettings No errors.
App\Entity\SiteSettings No errors.
Cofondateur\SocleTechniqueBundle\Entity\Blog\Article
  • The target entity 'Cofondateur\SocleTechniqueBundle\Entity\User' specified on Cofondateur\SocleTechniqueBundle\Entity\Blog\Article#updatedBy is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
App\Entity\Blog\Article
  • The target entity 'Cofondateur\SocleTechniqueBundle\Entity\User' specified on App\Entity\Blog\Article#updatedBy is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
Cofondateur\SocleTechniqueBundle\Entity\User No errors.
App\Entity\ArticleCategory No errors.
Cofondateur\SocleTechniqueBundle\Entity\Blog\ArticleParagraph
  • The target entity 'Cofondateur\SocleTechniqueBundle\Entity\Blog\Article' specified on Cofondateur\SocleTechniqueBundle\Entity\Blog\ArticleParagraph#article is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
App\Entity\Blog\ArticleParagraph
  • The target entity 'Cofondateur\SocleTechniqueBundle\Entity\Blog\Article' specified on App\Entity\Blog\ArticleParagraph#article is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
App\Entity\ArticleGalleryItem No errors.