Query Metrics

72 Database Queries
12 Different statements
26.00 ms Query time
3 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
8.77 ms
(33.74%)
25
SELECT t0.id AS id_1, t0.position AS position_2, t0.is_page AS is_page_3, t0.title AS title_4, t0.route_name AS route_name_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.enabled AS enabled_8, t0.parent_id AS parent_id_9, t0.element_id AS element_id_10, t0.lien_interne_id AS lien_interne_id_11, t0.created_by_id AS created_by_id_12, t0.updated_by_id AS updated_by_id_13 FROM menu t0 WHERE t0.parent_id = ?
Parameters:
[
  1
]
5.75 ms
(22.10%)
15
SELECT t0.id AS id_1, t0.facebook_url AS facebook_url_2, t0.facebook_enabled AS facebook_enabled_3, t0.twitter_url AS twitter_url_4, t0.twitter_enabled AS twitter_enabled_5, t0.instagram_url AS instagram_url_6, t0.instagram_enabled AS instagram_enabled_7, t0.newletter_enabled AS newletter_enabled_8, t0.email_contact AS email_contact_9, t0.email_guide AS email_guide_10, t0.email_partenaire AS email_partenaire_11, t0.email_donation AS email_donation_12, t0.email_leg AS email_leg_13, t0.maildsn AS maildsn_14, t0.message_leg AS message_leg_15, t0.message_don AS message_don_16, t0.message_guide AS message_guide_17, t0.message_contact AS message_contact_18, t0.message_confirmation AS message_confirmation_19, t0.message_partenaire AS message_partenaire_20, t0.youtube_url AS youtube_url_21, t0.youtube_enabled AS youtube_enabled_22, t0.linkedin_url AS linkedin_url_23, t0.linkedin_enabled AS linkedin_enabled_24 FROM parametre t0 ORDER BY t0.id ASC LIMIT 1
Parameters:
[]
5.53 ms
(21.28%)
18
SELECT t0.id AS id_1, t0.title AS title_2, t0.route_name AS route_name_3, t0.params AS params_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.enabled AS enabled_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9 FROM link t0 WHERE t0.id = ?
Parameters:
[
  10
]
1.58 ms
(6.06%)
4
SELECT t0.id AS id_1, t0.link AS link_2, t0.position AS position_3, t0.promoted AS promoted_4, t0.url AS url_5, t0.url_text AS url_text_6, t0.title AS title_7, t0.content AS content_8, t0.metadata AS metadata_9, t0.slug AS slug_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.enabled AS enabled_13, t0.image_name AS image_name_14, t0.image_original_name AS image_original_name_15, t0.image_mime_type AS image_mime_type_16, t0.image_size AS image_size_17, t0.image_dimensions AS image_dimensions_18, t0.parent_id AS parent_id_19, t0.equipe_id AS equipe_id_20, t0.mediatheque_id AS mediatheque_id_21, t0.created_by_id AS created_by_id_22, t0.updated_by_id AS updated_by_id_23 FROM page t0 WHERE t0.id = ?
Parameters:
[
  2
]
0.72 ms
(2.76%)
1
SELECT t0.id AS id_1, t0.position AS position_2, t0.promoted AS promoted_3, t0.banned AS banned_4, t0.show_banner_title AS show_banner_title_5, t0.title AS title_6, t0.content AS content_7, t0.metadata AS metadata_8, t0.slug AS slug_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.enabled AS enabled_12, t0.image_name AS image_name_13, t0.image_original_name AS image_original_name_14, t0.image_mime_type AS image_mime_type_15, t0.image_size AS image_size_16, t0.image_dimensions AS image_dimensions_17, t0.categorie_actualite_id AS categorie_actualite_id_18, t0.type_id AS type_id_19, t0.mediatheque_id AS mediatheque_id_20, t0.created_by_id AS created_by_id_21, t0.updated_by_id AS updated_by_id_22 FROM actualite t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "colloque-scientifique-international-thiaroye-44-80-ans-apres-souvenirs-et-reflexions-universite-de-parakou"
]
0.70 ms
(2.70%)
1
SELECT t0.id AS id_1, t0.position AS position_2, t0.is_page AS is_page_3, t0.title AS title_4, t0.route_name AS route_name_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.enabled AS enabled_8, t0.parent_id AS parent_id_9, t0.element_id AS element_id_10, t0.lien_interne_id AS lien_interne_id_11, t0.created_by_id AS created_by_id_12, t0.updated_by_id AS updated_by_id_13 FROM menu t0 WHERE t0.enabled = ? ORDER BY t0.parent_id ASC, t0.position ASC, t0.title ASC
Parameters:
[
  1
]
0.69 ms
(2.65%)
2
SELECT t0.id AS id_1, t0.isdefault AS isdefault_2, t0.title AS title_3, t0.content AS content_4, t0.metadata AS metadata_5, t0.slug AS slug_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.enabled AS enabled_9, t0.image_name AS image_name_10, t0.image_original_name AS image_original_name_11, t0.image_mime_type AS image_mime_type_12, t0.image_size AS image_size_13, t0.image_dimensions AS image_dimensions_14, t0.link_id AS link_id_15, t0.created_by_id AS created_by_id_16, t0.updated_by_id AS updated_by_id_17 FROM image_interne t0 WHERE t0.isdefault = ? AND t0.enabled = ? LIMIT 1
Parameters:
[
  1
  1
]
0.67 ms
(2.57%)
2
SELECT t0.id AS id_1, t0.isdefault AS isdefault_2, t0.title AS title_3, t0.content AS content_4, t0.metadata AS metadata_5, t0.slug AS slug_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.enabled AS enabled_9, t0.image_name AS image_name_10, t0.image_original_name AS image_original_name_11, t0.image_mime_type AS image_mime_type_12, t0.image_size AS image_size_13, t0.image_dimensions AS image_dimensions_14, t0.link_id AS link_id_15, t0.created_by_id AS created_by_id_16, t0.updated_by_id AS updated_by_id_17 FROM image_interne t0 WHERE t0.slug = ? AND t0.enabled = ? LIMIT 1
Parameters:
[
  "actualites"
  1
]
0.45 ms
(1.75%)
1
SELECT t0.id AS id_1, t0.position AS position_2, t0.show_title AS show_title_3, t0.title AS title_4, t0.content AS content_5, t0.metadata AS metadata_6, t0.slug AS slug_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.enabled AS enabled_10, t0.image_name AS image_name_11, t0.image_original_name AS image_original_name_12, t0.image_mime_type AS image_mime_type_13, t0.image_size AS image_size_14, t0.image_dimensions AS image_dimensions_15, t0.galerie_id AS galerie_id_16, t0.created_by_id AS created_by_id_17, t0.updated_by_id AS updated_by_id_18 FROM image t0 WHERE t0.galerie_id = ?
Parameters:
[
  3
]
0.43 ms
(1.66%)
1
SELECT t0.id AS id_1, t0.position AS position_2, t0.title AS title_3, t0.content AS content_4, t0.metadata AS metadata_5, t0.slug AS slug_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.enabled AS enabled_9, t0.image_name AS image_name_10, t0.image_original_name AS image_original_name_11, t0.image_mime_type AS image_mime_type_12, t0.image_size AS image_size_13, t0.image_dimensions AS image_dimensions_14, t0.categorie_id AS categorie_id_15, t0.created_by_id AS created_by_id_16, t0.updated_by_id AS updated_by_id_17 FROM galerie t0 WHERE t0.id = ?
Parameters:
[
  3
]
0.39 ms
(1.48%)
1
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.enabled AS enabled_4, t0.title AS title_5, t0.content AS content_6, t0.metadata AS metadata_7, t0.slug AS slug_8, t0.parent_id AS parent_id_9, t0.created_by_id AS created_by_id_10, t0.updated_by_id AS updated_by_id_11 FROM categorie_actualite t0 WHERE t0.id = ?
Parameters:
[
  6
]
0.32 ms
(1.23%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.metadata AS metadata_4, t0.slug AS slug_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.enabled AS enabled_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10 FROM type_actualite t0 WHERE t0.id = ?
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
Vich\UploaderBundle\Entity\File No errors.
App\Entity\Actualite No errors.
App\Entity\CategorieActualite No errors.
App\Entity\TypeActualite No errors.
App\Entity\Galerie No errors.
App\Entity\User
  • The field App\Entity\User#pages is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Page#created_by does not contain the required 'inversedBy="pages"' attribute.
App\Entity\Tag No errors.
App\Entity\Video
  • The association App\Entity\Video#galerie refers to the inverse side field App\Entity\Galerie#videos which does not exist.
App\Entity\Menu No errors.
App\Entity\Page
  • The association App\Entity\Page#equipe refers to the inverse side field App\Entity\CategorieEquipe#pages which does not exist.
App\Entity\Link No errors.
App\Entity\CategorieEquipe No errors.
App\Entity\ImageInterne No errors.
App\Entity\CategorieMedia No errors.
App\Entity\Image No errors.
App\Entity\Parametre No errors.