https://akwabacheznous.com/cit/site/public/la-cote-d-ivoire

Query Metrics

16 Database Queries
8 Different statements
2.98 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.98 ms
SELECT p0_.name AS name_0, p0_.filename AS filename_1, p0_.online AS online_2, p0_.menu_id AS menu_id_3, p0_.menu_name AS menu_name_4, p0_.content AS content_5, p0_.bandeaufile AS bandeaufile_6, p0_.extrait AS extrait_7, p0_.id AS id_8, p0_.ordre AS ordre_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, p0_.slug AS slug_12 FROM pages p0_ WHERE p0_.id = ? AND p0_.online = 1
Parameters:
[
  1
]
2 0.23 ms
SELECT p0_.name AS name_0, p0_.filename AS filename_1, p0_.online AS online_2, p0_.menu_id AS menu_id_3, p0_.menu_name AS menu_name_4, p0_.content AS content_5, p0_.bandeaufile AS bandeaufile_6, p0_.extrait AS extrait_7, p0_.id AS id_8, p0_.ordre AS ordre_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, p0_.slug AS slug_12 FROM pages p0_ WHERE p0_.id = ? AND p0_.online = 1
Parameters:
[
  2
]
3 0.34 ms
SELECT i0_.name AS name_0, i0_.link AS link_1, i0_.extrait AS extrait_2, i0_.content AS content_3, i0_.filename AS filename_4, i0_.online AS online_5, i0_.views AS views_6, i0_.id AS id_7, i0_.ordre AS ordre_8, i0_.created_at AS created_at_9, i0_.updated_at AS updated_at_10, i0_.slug AS slug_11, i0_.user_id AS user_id_12, i0_.updated_by_id AS updated_by_id_13 FROM institutions i0_ WHERE i0_.online = 1 LIMIT 36
Parameters:
[]
4 0.25 ms
SELECT s0_.name AS name_0, s0_.content AS content_1, s0_.filename AS filename_2, s0_.online AS online_3, s0_.id AS id_4, s0_.ordre AS ordre_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.slug AS slug_8 FROM symbolesetats s0_ WHERE s0_.online = 1 LIMIT 36
Parameters:
[]
5 0.15 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.telephone AS telephone_4, t0.cellulaire AS cellulaire_5, t0.email AS email_6, t0.filename AS filename_7, t0.adresses AS adresses_8, t0.updated_at AS updated_at_9, t0.complements AS complements_10, t0.activite AS activite_11, t0.slogan AS slogan_12, t0.keywords AS keywords_13, t0.facebook AS facebook_14, t0.twitter AS twitter_15, t0.googleplus AS googleplus_16, t0.instagram AS instagram_17, t0.youtube AS youtube_18, t0.incontournable_text_fond AS incontournable_text_fond_19, t0.incontournable_text_title AS incontournable_text_title_20, t0.incontournable_text_content AS incontournable_text_content_21, t0.filenamepopup AS filenamepopup_22, t0.video_popup AS video_popup_23, t0.type_popup AS type_popup_24, t0.enable_popup AS enable_popup_25 FROM parametres t0 WHERE t0.id = ?
Parameters:
[
  1
]
6 0.10 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.link AS link_3, t0.filename AS filename_4, t0.position AS position_5, t0.online AS online_6, t0.updated_at AS updated_at_7 FROM publicites t0 WHERE t0.online = ? AND t0.position = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[
  1
  3
]
7 0.07 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.link AS link_3, t0.filename AS filename_4, t0.position AS position_5, t0.online AS online_6, t0.updated_at AS updated_at_7 FROM publicites t0 WHERE t0.online = ? AND t0.position = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[
  1
  3
]
8 0.20 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.description AS description_3, c0_.ordre AS ordre_4, c0_.menu AS menu_5, c0_.filename AS filename_6, c0_.updated_at AS updated_at_7, c0_.laus AS laus_8, a1_.name AS name_9, a1_.slug AS slug_10, a1_.extrait AS extrait_11, a1_.urlvideo AS urlvideo_12, a1_.content AS content_13, a1_.filename AS filename_14, a1_.online AS online_15, a1_.views AS views_16, a1_.circuitslies AS circuitslies_17, a1_.bandeaufile AS bandeaufile_18, a1_.featured AS featured_19, a1_.incontournable AS incontournable_20, a1_.incontournablename AS incontournablename_21, a1_.id AS id_22, a1_.ordre AS ordre_23, a1_.created_at AS created_at_24, a1_.updated_at AS updated_at_25, a1_.user_id AS user_id_26, a1_.updated_by_id AS updated_by_id_27, a1_.categories_id AS categories_id_28 FROM categoriearticles c0_ LEFT JOIN articles a1_ ON c0_.id = a1_.categories_id WHERE c0_.menu = ? ORDER BY c0_.ordre ASC
Parameters:
[
  0
]
9 0.16 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.description AS description_3, c0_.ordre AS ordre_4, c0_.menu AS menu_5, c0_.filename AS filename_6, c0_.updated_at AS updated_at_7, c0_.laus AS laus_8, a1_.name AS name_9, a1_.slug AS slug_10, a1_.extrait AS extrait_11, a1_.urlvideo AS urlvideo_12, a1_.content AS content_13, a1_.filename AS filename_14, a1_.online AS online_15, a1_.views AS views_16, a1_.circuitslies AS circuitslies_17, a1_.bandeaufile AS bandeaufile_18, a1_.featured AS featured_19, a1_.incontournable AS incontournable_20, a1_.incontournablename AS incontournablename_21, a1_.id AS id_22, a1_.ordre AS ordre_23, a1_.created_at AS created_at_24, a1_.updated_at AS updated_at_25, a1_.user_id AS user_id_26, a1_.updated_by_id AS updated_by_id_27, a1_.categories_id AS categories_id_28 FROM categoriearticles c0_ LEFT JOIN articles a1_ ON c0_.id = a1_.categories_id WHERE c0_.menu = ? ORDER BY c0_.ordre ASC
Parameters:
[
  1
]
10 0.07 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.link AS link_3, t0.filename AS filename_4, t0.position AS position_5, t0.online AS online_6, t0.updated_at AS updated_at_7 FROM publicites t0 WHERE t0.online = ? AND t0.position = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[
  1
  4
]
11 0.05 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.link AS link_3, t0.filename AS filename_4, t0.position AS position_5, t0.online AS online_6, t0.updated_at AS updated_at_7 FROM publicites t0 WHERE t0.online = ? AND t0.position = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[
  1
  4
]
12 0.07 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.filename AS filename_5, t0.filenamecover AS filenamecover_6, t0.documents AS documents_7, t0.documentcover AS documentcover_8, t0.ordre AS ordre_9, t0.online AS online_10, t0.menu AS menu_11, t0.updated_at AS updated_at_12, t0.role AS role_13 FROM categorieposts t0 WHERE t0.menu = ? AND t0.online = ? ORDER BY t0.ordre ASC
Parameters:
[
  0
  1
]
13 0.07 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.filename AS filename_5, t0.filenamecover AS filenamecover_6, t0.documents AS documents_7, t0.documentcover AS documentcover_8, t0.ordre AS ordre_9, t0.online AS online_10, t0.menu AS menu_11, t0.updated_at AS updated_at_12, t0.role AS role_13 FROM categorieposts t0 WHERE t0.menu = ? AND t0.online = ? ORDER BY t0.ordre ASC
Parameters:
[
  1
  1
]
14 0.07 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.filename AS filename_5, t0.filenamecover AS filenamecover_6, t0.documents AS documents_7, t0.documentcover AS documentcover_8, t0.ordre AS ordre_9, t0.online AS online_10, t0.menu AS menu_11, t0.updated_at AS updated_at_12, t0.role AS role_13 FROM categorieposts t0 WHERE t0.menu = ? AND t0.online = ? ORDER BY t0.ordre ASC
Parameters:
[
  2
  1
]
15 0.07 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.filename AS filename_5, t0.filenamecover AS filenamecover_6, t0.documents AS documents_7, t0.documentcover AS documentcover_8, t0.ordre AS ordre_9, t0.online AS online_10, t0.menu AS menu_11, t0.updated_at AS updated_at_12, t0.role AS role_13 FROM categorieposts t0 WHERE t0.menu = ? AND t0.online = ? ORDER BY t0.ordre ASC
Parameters:
[
  3
  1
]
16 0.11 ms
SELECT t0.name AS name_1, t0.filename AS filename_2, t0.online AS online_3, t0.menu_id AS menu_id_4, t0.menu_name AS menu_name_5, t0.content AS content_6, t0.bandeaufile AS bandeaufile_7, t0.extrait AS extrait_8, t0.id AS id_9, t0.ordre AS ordre_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.slug AS slug_13 FROM pages t0 WHERE t0.online = ? AND t0.menu_id = ? ORDER BY t0.ordre ASC
Parameters:
[
  1
  2
]

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
App\Entity\User No errors.
App\Entity\Actualites\Actualites No errors.
App\Entity\Articles\Articles No errors.
App\Entity\Hotels\Hotels
  • The mappings App\Entity\Hotels\Hotels#typechambres and App\Entity\Typechambres#hotels are inconsistent with each other.
App\Entity\Posts\Posts No errors.
App\Entity\Pages\Pages No errors.
App\Entity\Directions No errors.
App\Entity\Distinctions\Distinctions No errors.
App\Entity\Documentations No errors.
App\Entity\Partenaires No errors.
App\Entity\Brochures No errors.
App\Entity\Salons\Salons No errors.
App\Entity\Categorieimages No errors.
App\Entity\Institutions No errors.
App\Entity\Symboles\Symbolesetats No errors.
App\Entity\Restaurants\Restaurants No errors.
App\Entity\Pages\Mediapages No errors.
App\Entity\Symboles\Mediassymboles No errors.
App\Entity\Parametres\Titles No errors.
App\Entity\Publicites\Publicites No errors.
App\Entity\Articles\Categoriearticles No errors.
App\Entity\Posts\Categorieposts No errors.
App\Entity\Salons\Categoriesalons No errors.
App\Entity\Actualites\Categories No errors.
App\Entity\Mainsliders No errors.
App\Entity\Parametres No errors.
App\Entity\Articles\Mediaarticles No errors.