https://preprod.orishas-finance.com/actualite/7247?lang=fr

Query Metrics

20 Database Queries
11 Different statements
83.00 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
35.55 ms
(42.83%)
1
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_ INNER JOIN news_typenews n2_ ON n0_.id = n2_.news_id INNER JOIN typenews t1_ ON t1_.id = n2_.typenews_id WHERE n0_.id <> ? AND t1_.id IN (?) ORDER BY n0_.date DESC LIMIT 9
Parameters:
[
  7247
  5
]
32.38 ms
(39.01%)
1
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_ INNER JOIN news_typenews n2_ ON n0_.id = n2_.news_id INNER JOIN typenews t1_ ON t1_.id = n2_.typenews_id WHERE n0_.id <> ? AND n0_.image IS NOT NULL AND t1_.id IN (?) ORDER BY n0_.date DESC LIMIT 3
Parameters:
[
  7247
  5
]
5.64 ms
(6.80%)
1
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:
[]
4.17 ms
(5.02%)
10
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:
[
  7247
]
1.55 ms
(1.87%)
1
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.source AS source_4, t0.date AS date_5, t0.heure AS heure_6, t0.image AS image_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.status AS status_10, t0.premium AS premium_11, t0.titreimage AS titreimage_12, t0.notify_at AS notify_at_13, t0.titre_en AS titre_en_14, t0.description_en AS description_en_15, t0.user_id AS user_id_16 FROM news t0 WHERE t0.id = ?
Parameters:
[
  "7247"
]
0.85 ms
(1.02%)
1
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:
[]
0.66 ms
(0.80%)
1
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:
[]
0.66 ms
(0.79%)
1
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:
[]
0.64 ms
(0.77%)
1
SELECT COUNT(c0_.id) AS sclr_0 FROM commentaire c0_ WHERE c0_.status = ? AND c0_.news_id = ?
Parameters:
[
  1
  "7247"
]
0.45 ms
(0.55%)
1
SELECT c0_.id AS id_0, c0_.message AS message_1, c0_.status AS status_2, c0_.create_at AS create_at_3, c0_.user_id AS user_id_4, c0_.news_id AS news_id_5 FROM commentaire c0_ WHERE c0_.status = ? AND c0_.news_id = ? ORDER BY c0_.id DESC LIMIT 10
Parameters:
[
  1
  "7247"
]
0.45 ms
(0.54%)
1
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:
[]

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\News No errors.
App\Entity\User No errors.
App\Entity\Typenews No errors.
App\Entity\Commentaire No errors.
App\Entity\UserBookmark No errors.
App\Entity\Service No errors.
App\Entity\Produit No errors.
App\Entity\Newsletter No errors.
App\Entity\Publicite No errors.
App\Entity\TypePub No errors.
App\Entity\Contenupartenaire No errors.
App\Entity\Video No errors.
App\Entity\CategorieVideo No errors.
App\Entity\VideoVisit No errors.