https://preprod.orishas-finance.com/

Query Metrics

37 Database Queries
15 Different statements
107.28 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 4.66 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.prix AS prix_4, t0.createat AS createat_5, t0.updateat AS updateat_6, t0.image AS image_7, t0.service_id AS service_id_8, t0.partenaire_id AS partenaire_id_9 FROM produit t0
Parameters:
[]
2 0.79 ms
SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.date_debut AS date_debut_2, p0_.date_fin AS date_fin_3, p0_.status AS status_4, p0_.lieu AS lieu_5, p0_.description AS description_6, p0_.created_at AS created_at_7, p0_.formation_id AS formation_id_8 FROM programme_formation p0_ WHERE p0_.status = ? ORDER BY p0_.created_at DESC
Parameters:
[
  1
]
3 0.64 ms
SELECT v0_.id AS id_0, v0_.libelle AS libelle_1, v0_.description AS description_2, v0_.type AS type_3, v0_.youtube AS youtube_4, v0_.file AS file_5, v0_.taille AS taille_6, v0_.thumbnail AS thumbnail_7, v0_.premium AS premium_8, v0_.status AS status_9, v0_.created_at AS created_at_10, v0_.updated_at AS updated_at_11, v0_.vimeo AS vimeo_12, v0_.une AS une_13, v0_.user_id AS user_id_14, v0_.categorie_id AS categorie_id_15 FROM video v0_ WHERE v0_.status = ? AND v0_.une = 1 ORDER BY v0_.id DESC LIMIT 2
Parameters:
[
  1
]
4 0.54 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.presentation AS presentation_3, t0.description AS description_4, t0.logo AS logo_5, t0.status AS status_6, t0.create_at AS create_at_7, t0.update_at AS update_at_8 FROM contenupartenaire t0
Parameters:
[]
5 9.66 ms
SELECT n0_.id AS id_0, n0_.titre AS titre_1, n0_.description AS description_2, n0_.source AS source_3, n0_.date AS date_4, n0_.heure AS heure_5, n0_.image AS image_6, n0_.created_at AS created_at_7, n0_.updated_at AS updated_at_8, n0_.status AS status_9, n0_.premium AS premium_10, n0_.titreimage AS titreimage_11, n0_.notify_at AS notify_at_12, n0_.titre_en AS titre_en_13, n0_.description_en AS description_en_14, n0_.user_id AS user_id_15 FROM news n0_ WHERE n0_.status = ? AND n0_.image IS NOT NULL ORDER BY n0_.created_at DESC LIMIT 12
Parameters:
[
  1
]
6 60.62 ms
SELECT e0_.id AS id_0, e0_.nom AS nom_1, e0_.date AS date_2, e0_.heure AS heure_3, e0_.periode AS periode_4, e0_.importance AS importance_5, e0_.precedente AS precedente_6, e0_.prevision AS prevision_7, e0_.actuelle AS actuelle_8, e0_.source AS source_9, e0_.liensource AS liensource_10, e0_.commentaire AS commentaire_11, e0_.created_at AS created_at_12, e0_.updated_at AS updated_at_13, e0_.status AS status_14, e0_.compaprecedent AS compaprecedent_15, e0_.pays_id AS pays_id_16, e0_.categorie_id AS categorie_id_17, e0_.user_id AS user_id_18 FROM evenement e0_ WHERE e0_.status = ? AND e0_.date = ? ORDER BY e0_.heure ASC LIMIT 15
Parameters:
[
  1
  "2023-05-28"
]
7 0.62 ms
SELECT t0.id AS id_1, t0.message AS message_2, t0.status AS status_3, t0.create_at AS create_at_4, t0.user_id AS user_id_5, t0.news_id AS news_id_6 FROM commentaire t0
Parameters:
[]
8 9.67 ms
SELECT n0_.id AS id_0, n0_.titre AS titre_1, n0_.description AS description_2, n0_.source AS source_3, n0_.date AS date_4, n0_.heure AS heure_5, n0_.image AS image_6, n0_.created_at AS created_at_7, n0_.updated_at AS updated_at_8, n0_.status AS status_9, n0_.premium AS premium_10, n0_.titreimage AS titreimage_11, n0_.notify_at AS notify_at_12, n0_.titre_en AS titre_en_13, n0_.description_en AS description_en_14, n0_.user_id AS user_id_15 FROM news n0_ WHERE n0_.status = ? ORDER BY n0_.created_at DESC LIMIT 6
Parameters:
[
  1
]
9 0.56 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.typeservice AS typeservice_3, t0.description AS description_4, t0.createat AS createat_5, t0.updateat AS updateat_6 FROM service t0
Parameters:
[]
10 0.49 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.debut AS debut_4, t0.fin AS fin_5, t0.support AS support_6, t0.espace AS espace_7, t0.status AS status_8, t0.create_at AS create_at_9, t0.update_at AS update_at_10, t0.type_id AS type_id_11 FROM publicite t0
Parameters:
[]
11 3.47 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.prix AS prix_4, t0.createat AS createat_5, t0.updateat AS updateat_6, t0.image AS image_7, t0.service_id AS service_id_8, t0.partenaire_id AS partenaire_id_9 FROM produit t0
Parameters:
[]
12 0.82 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.type AS type_4, t0.youtube AS youtube_5, t0.file AS file_6, t0.taille AS taille_7, t0.thumbnail AS thumbnail_8, t0.premium AS premium_9, t0.status AS status_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.vimeo AS vimeo_13, t0.une AS une_14, t0.user_id AS user_id_15, t0.categorie_id AS categorie_id_16 FROM video t0
Parameters:
[]
13 0.43 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.slug AS slug_3, t0.libelle_en AS libelle_en_4 FROM typenews t0
Parameters:
[]
14 0.80 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.slug AS slug_3, t0.libelle_en AS libelle_en_4 FROM typenews t0 INNER JOIN news_typenews ON t0.id = news_typenews.typenews_id WHERE news_typenews.news_id = ?
Parameters:
[
  7910
]
15 0.59 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.slug AS slug_3, t0.libelle_en AS libelle_en_4 FROM typenews t0 INNER JOIN news_typenews ON t0.id = news_typenews.typenews_id WHERE news_typenews.news_id = ?
Parameters:
[
  7909
]
16 0.58 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.slug AS slug_3, t0.libelle_en AS libelle_en_4 FROM typenews t0 INNER JOIN news_typenews ON t0.id = news_typenews.typenews_id WHERE news_typenews.news_id = ?
Parameters:
[
  7908
]
17 0.58 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.slug AS slug_3, t0.libelle_en AS libelle_en_4 FROM typenews t0 INNER JOIN news_typenews ON t0.id = news_typenews.typenews_id WHERE news_typenews.news_id = ?
Parameters:
[
  7907
]
18 0.59 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.slug AS slug_3, t0.libelle_en AS libelle_en_4 FROM typenews t0 INNER JOIN news_typenews ON t0.id = news_typenews.typenews_id WHERE news_typenews.news_id = ?
Parameters:
[
  7906
]
19 0.71 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.slug AS slug_3, t0.libelle_en AS libelle_en_4 FROM typenews t0 INNER JOIN news_typenews ON t0.id = news_typenews.typenews_id WHERE news_typenews.news_id = ?
Parameters:
[
  7905
]
20 0.58 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.slug AS slug_3, t0.libelle_en AS libelle_en_4 FROM typenews t0 INNER JOIN news_typenews ON t0.id = news_typenews.typenews_id WHERE news_typenews.news_id = ?
Parameters:
[
  7904
]
21 0.58 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.slug AS slug_3, t0.libelle_en AS libelle_en_4 FROM typenews t0 INNER JOIN news_typenews ON t0.id = news_typenews.typenews_id WHERE news_typenews.news_id = ?
Parameters:
[
  7903
]
22 0.55 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.slug AS slug_3, t0.libelle_en AS libelle_en_4 FROM typenews t0 INNER JOIN news_typenews ON t0.id = news_typenews.typenews_id WHERE news_typenews.news_id = ?
Parameters:
[
  7902
]
23 0.55 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.slug AS slug_3, t0.libelle_en AS libelle_en_4 FROM typenews t0 INNER JOIN news_typenews ON t0.id = news_typenews.typenews_id WHERE news_typenews.news_id = ?
Parameters:
[
  7901
]
24 0.55 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.slug AS slug_3, t0.libelle_en AS libelle_en_4 FROM typenews t0 INNER JOIN news_typenews ON t0.id = news_typenews.typenews_id WHERE news_typenews.news_id = ?
Parameters:
[
  7900
]
25 0.55 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.slug AS slug_3, t0.libelle_en AS libelle_en_4 FROM typenews t0 INNER JOIN news_typenews ON t0.id = news_typenews.typenews_id WHERE news_typenews.news_id = ?
Parameters:
[
  7899
]
26 0.77 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.prix AS prix_4, t0.image AS image_5, t0.video AS video_6, t0.niveau AS niveau_7, t0.objectif AS objectif_8, t0.atouts AS atouts_9, t0.status AS status_10, t0.duree AS duree_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.divers AS divers_14, t0.langue AS langue_15, t0.min AS min_16, t0.max AS max_17, t0.document AS document_18, t0.user_id AS user_id_19 FROM formation t0 WHERE t0.id = ?
Parameters:
[
  1
]
27 0.59 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.slug AS slug_4 FROM categorie_formation t0 INNER JOIN formation_categorie_formation ON t0.id = formation_categorie_formation.categorie_formation_id WHERE formation_categorie_formation.formation_id = ?
Parameters:
[
  1
]
28 0.56 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.prix AS prix_4, t0.image AS image_5, t0.video AS video_6, t0.niveau AS niveau_7, t0.objectif AS objectif_8, t0.atouts AS atouts_9, t0.status AS status_10, t0.duree AS duree_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.divers AS divers_14, t0.langue AS langue_15, t0.min AS min_16, t0.max AS max_17, t0.document AS document_18, t0.user_id AS user_id_19 FROM formation t0 WHERE t0.id = ?
Parameters:
[
  3
]
29 0.71 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.slug AS slug_4 FROM categorie_formation t0 INNER JOIN formation_categorie_formation ON t0.id = formation_categorie_formation.categorie_formation_id WHERE formation_categorie_formation.formation_id = ?
Parameters:
[
  3
]
30 0.56 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.prix AS prix_4, t0.image AS image_5, t0.video AS video_6, t0.niveau AS niveau_7, t0.objectif AS objectif_8, t0.atouts AS atouts_9, t0.status AS status_10, t0.duree AS duree_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.divers AS divers_14, t0.langue AS langue_15, t0.min AS min_16, t0.max AS max_17, t0.document AS document_18, t0.user_id AS user_id_19 FROM formation t0 WHERE t0.id = ?
Parameters:
[
  2
]
31 0.55 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.slug AS slug_4 FROM categorie_formation t0 INNER JOIN formation_categorie_formation ON t0.id = formation_categorie_formation.categorie_formation_id WHERE formation_categorie_formation.formation_id = ?
Parameters:
[
  2
]
32 0.64 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.prix AS prix_4, t0.image AS image_5, t0.video AS video_6, t0.niveau AS niveau_7, t0.objectif AS objectif_8, t0.atouts AS atouts_9, t0.status AS status_10, t0.duree AS duree_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.divers AS divers_14, t0.langue AS langue_15, t0.min AS min_16, t0.max AS max_17, t0.document AS document_18, t0.user_id AS user_id_19 FROM formation t0 WHERE t0.id = ?
Parameters:
[
  5
]
33 0.54 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.slug AS slug_4 FROM categorie_formation t0 INNER JOIN formation_categorie_formation ON t0.id = formation_categorie_formation.categorie_formation_id WHERE formation_categorie_formation.formation_id = ?
Parameters:
[
  5
]
34 0.55 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.prix AS prix_4, t0.image AS image_5, t0.video AS video_6, t0.niveau AS niveau_7, t0.objectif AS objectif_8, t0.atouts AS atouts_9, t0.status AS status_10, t0.duree AS duree_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.divers AS divers_14, t0.langue AS langue_15, t0.min AS min_16, t0.max AS max_17, t0.document AS document_18, t0.user_id AS user_id_19 FROM formation t0 WHERE t0.id = ?
Parameters:
[
  7
]
35 0.54 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.slug AS slug_4 FROM categorie_formation t0 INNER JOIN formation_categorie_formation ON t0.id = formation_categorie_formation.categorie_formation_id WHERE formation_categorie_formation.formation_id = ?
Parameters:
[
  7
]
36 0.56 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.prix AS prix_4, t0.image AS image_5, t0.video AS video_6, t0.niveau AS niveau_7, t0.objectif AS objectif_8, t0.atouts AS atouts_9, t0.status AS status_10, t0.duree AS duree_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.divers AS divers_14, t0.langue AS langue_15, t0.min AS min_16, t0.max AS max_17, t0.document AS document_18, t0.user_id AS user_id_19 FROM formation t0 WHERE t0.id = ?
Parameters:
[
  4
]
37 0.54 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.slug AS slug_4 FROM categorie_formation t0 INNER JOIN formation_categorie_formation ON t0.id = formation_categorie_formation.categorie_formation_id WHERE formation_categorie_formation.formation_id = ?
Parameters:
[
  4
]

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\Video No errors.
App\Entity\ProgrammeFormation No errors.
App\Entity\Produit No errors.
App\Entity\Evenement No errors.
App\Entity\News No errors.
App\Entity\Contenupartenaire No errors.
App\Entity\Commentaire No errors.
App\Entity\Service No errors.
App\Entity\Formation No errors.
App\Entity\User No errors.
App\Entity\CategorieVideo No errors.
App\Entity\VideoVisit No errors.
App\Entity\Typenews No errors.
App\Entity\UserBookmark No errors.
App\Entity\Pays No errors.
App\Entity\Categorie No errors.
App\Entity\Newsletter No errors.
App\Entity\Publicite No errors.
App\Entity\TypePub No errors.
App\Entity\Formateur No errors.
App\Entity\CategorieFormation No errors.
App\Entity\ChapitreFormation No errors.
App\Entity\Organisateur No errors.