GET https://kapeci-alu.asb-digital.fr/

Query Metrics

27 Database Queries
13 Different statements
6.62 ms Query time
1 Invalid entities
36 Managed entities

Queries

Group similar statements

# Time Info
1 0.28 ms
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_homepage"
]
2 0.26 ms
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.global_activity_description AS global_activity_description_20 FROM site_settings t0
Parameters:
[]
3 0.28 ms
SELECT t0.id AS id_1, t0.intro_over_title AS intro_over_title_2, t0.intro_title AS intro_title_3, t0.intro_summary AS intro_summary_4, t0.intro_link_title AS intro_link_title_5, t0.intro_picture1_name AS intro_picture1_name_6, t0.intro_picture1_size AS intro_picture1_size_7, t0.intro_picture1_updated_at AS intro_picture1_updated_at_8, t0.intro_picture1_alt AS intro_picture1_alt_9, t0.intro_picture2_name AS intro_picture2_name_10, t0.intro_picture2_size AS intro_picture2_size_11, t0.intro_picture2_updated_at AS intro_picture2_updated_at_12, t0.intro_picture2_alt AS intro_picture2_alt_13, t0.intro_picture3_name AS intro_picture3_name_14, t0.intro_picture3_size AS intro_picture3_size_15, t0.intro_picture3_updated_at AS intro_picture3_updated_at_16, t0.intro_picture3_alt AS intro_picture3_alt_17, t0.activities_over_title AS activities_over_title_18, t0.activities_title AS activities_title_19, t0.activities_summary AS activities_summary_20, t0.references_over_title AS references_over_title_21, t0.references_title AS references_title_22, t0.references_summary AS references_summary_23, t0.articles_over_title AS articles_over_title_24, t0.articles_title AS articles_title_25, t0.articles_summary AS articles_summary_26, t0.meta_title AS meta_title_27, t0.meta_description AS meta_description_28 FROM homepage t0
Parameters:
[]
4 0.30 ms
SELECT t0.position AS position_1, t0.id AS id_2, t0.over_title AS over_title_3, t0.title AS title_4, t0.summary AS summary_5, t0.picture_name AS picture_name_6, t0.picture_size AS picture_size_7, t0.picture_updated_at AS picture_updated_at_8, t0.picture_alt AS picture_alt_9, t0.card_section_title AS card_section_title_10, t0.regulations_title AS regulations_title_11, t0.refs_title AS refs_title_12, t0.last_block_title AS last_block_title_13, t0.last_block_summary AS last_block_summary_14, t0.last_block_link_title AS last_block_link_title_15, t0.last_block_link_target AS last_block_link_target_16, t0.meta_title AS meta_title_17, t0.meta_description AS meta_description_18, t0.slug AS slug_19, t0.category_id AS category_id_20 FROM activity t0 ORDER BY t0.position ASC
Parameters:
[]
5 0.31 ms
SELECT t0.position AS position_1, t0.id AS id_2, t0.over_title AS over_title_3, t0.title AS title_4, t0.summary AS summary_5, t0.picture_name AS picture_name_6, t0.picture_size AS picture_size_7, t0.picture_updated_at AS picture_updated_at_8, t0.picture_alt AS picture_alt_9, t0.card_section_title AS card_section_title_10, t0.regulations_title AS regulations_title_11, t0.refs_title AS refs_title_12, t0.last_block_title AS last_block_title_13, t0.last_block_summary AS last_block_summary_14, t0.last_block_link_title AS last_block_link_title_15, t0.last_block_link_target AS last_block_link_target_16, t0.meta_title AS meta_title_17, t0.meta_description AS meta_description_18, t0.slug AS slug_19, t0.category_id AS category_id_20 FROM activity t0 ORDER BY t0.position ASC
Parameters:
[]
6 0.26 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.logo_name AS logo_name_3, t0.logo_size AS logo_size_4, t0.logo_updated_at AS logo_updated_at_5, t0.logo_alt AS logo_alt_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8 FROM activity_category t0
Parameters:
[]
7 0.26 ms
SELECT t0.position AS position_1, t0.id AS id_2, t0.over_title AS over_title_3, t0.title AS title_4, t0.summary AS summary_5, t0.picture_name AS picture_name_6, t0.picture_size AS picture_size_7, t0.picture_updated_at AS picture_updated_at_8, t0.picture_alt AS picture_alt_9, t0.card_section_title AS card_section_title_10, t0.regulations_title AS regulations_title_11, t0.refs_title AS refs_title_12, t0.last_block_title AS last_block_title_13, t0.last_block_summary AS last_block_summary_14, t0.last_block_link_title AS last_block_link_title_15, t0.last_block_link_target AS last_block_link_target_16, t0.meta_title AS meta_title_17, t0.meta_description AS meta_description_18, t0.slug AS slug_19, t0.category_id AS category_id_20 FROM activity t0 WHERE t0.category_id = ?
Parameters:
[
  1
]
8 0.26 ms
SELECT t0.position AS position_1, t0.id AS id_2, t0.over_title AS over_title_3, t0.title AS title_4, t0.summary AS summary_5, t0.picture_name AS picture_name_6, t0.picture_size AS picture_size_7, t0.picture_updated_at AS picture_updated_at_8, t0.picture_alt AS picture_alt_9, t0.card_section_title AS card_section_title_10, t0.regulations_title AS regulations_title_11, t0.refs_title AS refs_title_12, t0.last_block_title AS last_block_title_13, t0.last_block_summary AS last_block_summary_14, t0.last_block_link_title AS last_block_link_title_15, t0.last_block_link_target AS last_block_link_target_16, t0.meta_title AS meta_title_17, t0.meta_description AS meta_description_18, t0.slug AS slug_19, t0.category_id AS category_id_20 FROM activity t0 WHERE t0.category_id = ?
Parameters:
[
  2
]
9 0.28 ms
SELECT t0.position AS position_1, t0.id AS id_2, t0.over_title AS over_title_3, t0.title AS title_4, t0.summary AS summary_5, t0.picture_name AS picture_name_6, t0.picture_size AS picture_size_7, t0.picture_updated_at AS picture_updated_at_8, t0.picture_alt AS picture_alt_9, t0.card_section_title AS card_section_title_10, t0.regulations_title AS regulations_title_11, t0.refs_title AS refs_title_12, t0.last_block_title AS last_block_title_13, t0.last_block_summary AS last_block_summary_14, t0.last_block_link_title AS last_block_link_title_15, t0.last_block_link_target AS last_block_link_target_16, t0.meta_title AS meta_title_17, t0.meta_description AS meta_description_18, t0.slug AS slug_19, t0.category_id AS category_id_20 FROM activity t0 WHERE t0.category_id = ?
Parameters:
[
  3
]
10 0.19 ms
SELECT t0.position AS position_1, t0.id AS id_2, t0.over_title AS over_title_3, t0.title AS title_4, t0.summary AS summary_5, t0.picture_name AS picture_name_6, t0.picture_size AS picture_size_7, t0.picture_updated_at AS picture_updated_at_8, t0.picture_alt AS picture_alt_9, t0.card_section_title AS card_section_title_10, t0.regulations_title AS regulations_title_11, t0.refs_title AS refs_title_12, t0.last_block_title AS last_block_title_13, t0.last_block_summary AS last_block_summary_14, t0.last_block_link_title AS last_block_link_title_15, t0.last_block_link_target AS last_block_link_target_16, t0.meta_title AS meta_title_17, t0.meta_description AS meta_description_18, t0.slug AS slug_19, t0.category_id AS category_id_20 FROM activity t0 WHERE t0.category_id = ?
Parameters:
[
  4
]
11 0.25 ms
SELECT t0.position AS position_1, t0.id AS id_2, t0.over_title AS over_title_3, t0.title AS title_4, t0.summary AS summary_5, t0.picture_name AS picture_name_6, t0.picture_size AS picture_size_7, t0.picture_updated_at AS picture_updated_at_8, t0.picture_alt AS picture_alt_9, t0.card_section_title AS card_section_title_10, t0.regulations_title AS regulations_title_11, t0.refs_title AS refs_title_12, t0.last_block_title AS last_block_title_13, t0.last_block_summary AS last_block_summary_14, t0.last_block_link_title AS last_block_link_title_15, t0.last_block_link_target AS last_block_link_target_16, t0.meta_title AS meta_title_17, t0.meta_description AS meta_description_18, t0.slug AS slug_19, t0.category_id AS category_id_20 FROM activity t0 WHERE t0.category_id = ?
Parameters:
[
  5
]
12 0.19 ms
SELECT t0.position AS position_1, t0.id AS id_2, t0.over_title AS over_title_3, t0.title AS title_4, t0.summary AS summary_5, t0.picture_name AS picture_name_6, t0.picture_size AS picture_size_7, t0.picture_updated_at AS picture_updated_at_8, t0.picture_alt AS picture_alt_9, t0.card_section_title AS card_section_title_10, t0.regulations_title AS regulations_title_11, t0.refs_title AS refs_title_12, t0.last_block_title AS last_block_title_13, t0.last_block_summary AS last_block_summary_14, t0.last_block_link_title AS last_block_link_title_15, t0.last_block_link_target AS last_block_link_target_16, t0.meta_title AS meta_title_17, t0.meta_description AS meta_description_18, t0.slug AS slug_19, t0.category_id AS category_id_20 FROM activity t0 WHERE t0.category_id = ?
Parameters:
[
  6
]
13 0.25 ms
SELECT t0.position AS position_1, t0.id AS id_2, t0.over_title AS over_title_3, t0.title AS title_4, t0.summary AS summary_5, t0.picture_name AS picture_name_6, t0.picture_size AS picture_size_7, t0.picture_updated_at AS picture_updated_at_8, t0.picture_alt AS picture_alt_9, t0.card_section_title AS card_section_title_10, t0.regulations_title AS regulations_title_11, t0.refs_title AS refs_title_12, t0.last_block_title AS last_block_title_13, t0.last_block_summary AS last_block_summary_14, t0.last_block_link_title AS last_block_link_title_15, t0.last_block_link_target AS last_block_link_target_16, t0.meta_title AS meta_title_17, t0.meta_description AS meta_description_18, t0.slug AS slug_19, t0.category_id AS category_id_20 FROM activity t0 WHERE t0.category_id = ?
Parameters:
[
  7
]
14 0.16 ms
SELECT t0.position AS position_1, t0.id AS id_2, t0.over_title AS over_title_3, t0.title AS title_4, t0.summary AS summary_5, t0.picture_name AS picture_name_6, t0.picture_size AS picture_size_7, t0.picture_updated_at AS picture_updated_at_8, t0.picture_alt AS picture_alt_9, t0.card_section_title AS card_section_title_10, t0.regulations_title AS regulations_title_11, t0.refs_title AS refs_title_12, t0.last_block_title AS last_block_title_13, t0.last_block_summary AS last_block_summary_14, t0.last_block_link_title AS last_block_link_title_15, t0.last_block_link_target AS last_block_link_target_16, t0.meta_title AS meta_title_17, t0.meta_description AS meta_description_18, t0.slug AS slug_19, t0.category_id AS category_id_20 FROM activity t0 WHERE t0.category_id = ?
Parameters:
[
  8
]
15 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.over_title AS over_title_3, t0.title AS title_4, t0.summary AS summary_5, t0.picture_name AS picture_name_6, t0.picture_size AS picture_size_7, t0.picture_updated_at AS picture_updated_at_8, t0.picture_alt AS picture_alt_9, t0.icon_name AS icon_name_10, t0.icon_size AS icon_size_11, t0.icon_updated_at AS icon_updated_at_12, t0.icon_alt AS icon_alt_13, t0.card_section_title AS card_section_title_14, t0.last_block_title AS last_block_title_15, t0.last_block_summary AS last_block_summary_16, t0.last_block_picture_name AS last_block_picture_name_17, t0.last_block_picture_size AS last_block_picture_size_18, t0.last_block_picture_updated_at AS last_block_picture_updated_at_19, t0.last_block_picture_alt AS last_block_picture_alt_20, t0.last_block_link_title AS last_block_link_title_21, t0.last_block_link_target AS last_block_link_target_22, t0.meta_title AS meta_title_23, t0.meta_description AS meta_description_24, t0.slug AS slug_25 FROM building_type t0
Parameters:
[]
16 0.27 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.summary AS summary_3, t0.export AS export_4, t0.gallery_over_title AS gallery_over_title_5, t0.gallery_title AS gallery_title_6, t0.gallery_content AS gallery_content_7, t0.picture_name AS picture_name_8, t0.picture_size AS picture_size_9, t0.picture_updated_at AS picture_updated_at_10, t0.picture_alt AS picture_alt_11, t0.published_at AS published_at_12, t0.created_at AS created_at_13, t0.meta_title AS meta_title_14, t0.meta_description AS meta_description_15, t0.slug AS slug_16, t0.is_published AS is_published_17, t0.sub_category_id AS sub_category_id_18, t0.homepage_id AS homepage_id_19 FROM reference t0 WHERE t0.homepage_id = ?
Parameters:
[
  1
]
17 0.26 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.position AS position_5, t0.slug AS slug_6 FROM reference_category t0 INNER JOIN reference_category_link ON t0.id = reference_category_link.reference_category_id WHERE reference_category_link.reference_id = ? ORDER BY t0.position ASC
Parameters:
[
  1
]
18 0.23 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.position AS position_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6 FROM reference_sub_category t0 WHERE t0.id = ?
Parameters:
[
  2
]
19 0.24 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.position AS position_5, t0.slug AS slug_6 FROM reference_category t0 INNER JOIN reference_category_link ON t0.id = reference_category_link.reference_category_id WHERE reference_category_link.reference_id = ? ORDER BY t0.position ASC
Parameters:
[
  2
]
20 0.25 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.summary AS summary_3, t0.published AS published_4, t0.picture_name AS picture_name_5, t0.picture_size AS picture_size_6, t0.picture_updated_at AS picture_updated_at_7, t0.picture_alt AS picture_alt_8, t0.export AS export_9, t0.gallery_over_title AS gallery_over_title_10, t0.gallery_title AS gallery_title_11, t0.gallery_content AS gallery_content_12, t0.published_at AS published_at_13, t0.meta_title AS meta_title_14, t0.meta_description AS meta_description_15, t0.slug AS slug_16, t0.updated_at AS updated_at_17, t0.created_at AS created_at_18, t0.updated_by_id AS updated_by_id_19, t0.created_by_id AS created_by_id_20 FROM article t0 WHERE t0.published = ? ORDER BY t0.published_at DESC LIMIT 4
Parameters:
[
  1
]
21 0.27 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.picture_name AS picture_name_3, t0.picture_size AS picture_size_4, t0.picture_updated_at AS picture_updated_at_5, t0.picture_alt AS picture_alt_6, t0.position AS position_7 FROM partner t0 ORDER BY t0.position ASC
Parameters:
[]
22 0.22 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.picture_name AS picture_name_3, t0.picture_size AS picture_size_4, t0.picture_updated_at AS picture_updated_at_5, t0.picture_alt AS picture_alt_6, t0.position AS position_7 FROM partner t0 ORDER BY t0.position ASC
Parameters:
[]
23 0.13 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.picture_name AS picture_name_3, t0.picture_size AS picture_size_4, t0.picture_updated_at AS picture_updated_at_5, t0.picture_alt AS picture_alt_6, t0.position AS position_7 FROM partner t0 ORDER BY t0.position ASC
Parameters:
[]
24 0.23 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.picture_name AS picture_name_3, t0.picture_size AS picture_size_4, t0.picture_updated_at AS picture_updated_at_5, t0.picture_alt AS picture_alt_6, t0.position AS position_7 FROM partner t0 ORDER BY t0.position ASC
Parameters:
[]
25 0.15 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.picture_name AS picture_name_3, t0.picture_size AS picture_size_4, t0.picture_updated_at AS picture_updated_at_5, t0.picture_alt AS picture_alt_6, t0.position AS position_7 FROM partner t0 ORDER BY t0.position ASC
Parameters:
[]
26 0.26 ms
SELECT t0.position AS position_1, t0.id AS id_2, t0.over_title AS over_title_3, t0.title AS title_4, t0.summary AS summary_5, t0.picture_name AS picture_name_6, t0.picture_size AS picture_size_7, t0.picture_updated_at AS picture_updated_at_8, t0.picture_alt AS picture_alt_9, t0.card_section_title AS card_section_title_10, t0.regulations_title AS regulations_title_11, t0.refs_title AS refs_title_12, t0.last_block_title AS last_block_title_13, t0.last_block_summary AS last_block_summary_14, t0.last_block_link_title AS last_block_link_title_15, t0.last_block_link_target AS last_block_link_target_16, t0.meta_title AS meta_title_17, t0.meta_description AS meta_description_18, t0.slug AS slug_19, t0.category_id AS category_id_20 FROM activity t0
Parameters:
[]
27 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.over_title AS over_title_3, t0.title AS title_4, t0.summary AS summary_5, t0.picture_name AS picture_name_6, t0.picture_size AS picture_size_7, t0.picture_updated_at AS picture_updated_at_8, t0.picture_alt AS picture_alt_9, t0.icon_name AS icon_name_10, t0.icon_size AS icon_size_11, t0.icon_updated_at AS icon_updated_at_12, t0.icon_alt AS icon_alt_13, t0.card_section_title AS card_section_title_14, t0.last_block_title AS last_block_title_15, t0.last_block_summary AS last_block_summary_16, t0.last_block_picture_name AS last_block_picture_name_17, t0.last_block_picture_size AS last_block_picture_size_18, t0.last_block_picture_updated_at AS last_block_picture_updated_at_19, t0.last_block_picture_alt AS last_block_picture_alt_20, t0.last_block_link_title AS last_block_link_title_21, t0.last_block_link_target AS last_block_link_target_22, t0.meta_title AS meta_title_23, t0.meta_description AS meta_description_24, t0.slug AS slug_25 FROM building_type t0
Parameters:
[]

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\Activity 8
App\Entity\ActivityCategory 8
App\Entity\Partner 7
App\Entity\ReferenceCategory 3
App\Entity\Blog\Article 3
App\Entity\Reference 2
Cofondateur\SocleTechniqueBundle\Entity\User 2
App\Entity\SiteSettings 1
App\Entity\Homepage 1
App\Entity\ReferenceSubCategory 1

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.
App\Entity\Homepage No errors.
App\Entity\Reference No errors.
App\Entity\Activity No errors.
App\Entity\ActivityCategory No errors.
App\Entity\ActivityParagraph No errors.
App\Entity\ActivityCard No errors.
App\Entity\ActivityBlock No errors.
App\Entity\Regulation No errors.
App\Entity\BuildingType No errors.
App\Entity\ReferenceSubCategory No errors.
App\Entity\ReferenceCategory No errors.
App\Entity\ReferenceMedia No errors.
App\Entity\ReferenceParagraph No errors.
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\Blog\ArticleMedia No errors.
App\Entity\Blog\ArticleParagraph No errors.
App\Entity\Partner No errors.