GET http://asin.olasoft.net/article/8/une-delegation-guot-congo-recue-asin/

Query Metrics

7 Database Queries
7 Different statements
13.10 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 4.63 ms
SELECT t0.isOnFrontPage AS isOnFrontPage_1, t0.isVisible AS isVisible_2, t0.isDeleted AS isDeleted_3, t0.youtube AS youtube_4, t0.flickr AS flickr_5, t0.URL AS URL_6, t0.soundcloud AS soundcloud_7, t0.hasGeneratedPdf AS hasGeneratedPdf_8, t0.id AS id_9, t0.title AS title_10, t0.description AS description_11, t0.content AS content_12, t0.slug AS slug_13, t0.date AS date_14, t0.createdAt AS createdAt_15, t0.lastUpdate AS lastUpdate_16, t0.isEnabled AS isEnabled_17, t0.category_id AS category_id_18, t19.id AS id_20, t19.name AS name_21, t19.slug AS slug_22, t19.description AS description_23, t19.isEnabled AS isEnabled_24, t19.banner_id AS banner_id_25, t0.type_id AS type_id_26, t27.id AS id_28, t27.name AS name_29, t27.slug AS slug_30, t0.album_id AS album_id_31, t32.id AS id_33, t32.title AS title_34, t32.isEnabled AS isEnabled_35, t0.biblio_id AS biblio_id_36, t37.id AS id_38, t37.title AS title_39, t37.isEnabled AS isEnabled_40, t0.qrcode_id AS qrcode_id_41, t42.target AS target_43, t42.thumbnailDir AS thumbnailDir_44, t42.hasThumbnail AS hasThumbnail_45, t42.id AS id_46, t42.pages AS pages_47, t42.downloads AS downloads_48, t42.reading AS reading_49, t42.name AS name_50, t42.dir AS dir_51, t42.source AS source_52, t42.size AS size_53, t42.is_enabled AS is_enabled_54, t42.is_deleted AS is_deleted_55, t42.last_update AS last_update_56, t42.created_at AS created_at_57, t42.formatSize AS formatSize_58, t42.mimetype AS mimetype_59, t0.generated_pdf_id AS generated_pdf_id_60, t61.id AS id_62, t61.target AS target_63, t61.pages AS pages_64, t61.downloads AS downloads_65, t61.reading AS reading_66, t61.name AS name_67, t61.dir AS dir_68, t61.source AS source_69, t61.size AS size_70, t61.is_enabled AS is_enabled_71, t61.is_deleted AS is_deleted_72, t61.last_update AS last_update_73, t61.created_at AS created_at_74, t61.formatSize AS formatSize_75, t61.mimetype AS mimetype_76, t0.banner_id AS banner_id_77, t78.target AS target_79, t78.thumbnailDir AS thumbnailDir_80, t78.hasThumbnail AS hasThumbnail_81, t78.id AS id_82, t78.pages AS pages_83, t78.downloads AS downloads_84, t78.reading AS reading_85, t78.name AS name_86, t78.dir AS dir_87, t78.source AS source_88, t78.size AS size_89, t78.is_enabled AS is_enabled_90, t78.is_deleted AS is_deleted_91, t78.last_update AS last_update_92, t78.created_at AS created_at_93, t78.formatSize AS formatSize_94, t78.mimetype AS mimetype_95, t0.sector_id AS sector_id_96, t0.user_id AS user_id_97, t98.id AS id_99, t98.fName AS fName_100, t98.lName AS lName_101, t98.phone AS phone_102, t98.createdAt AS createdAt_103, t98.lastLogin AS lastLogin_104, t98.password AS password_105, t98.token AS token_106, t98.sex AS sex_107, t98.isEnabled AS isEnabled_108, t98.email AS email_109, t98.profile_id AS profile_id_110, t0.updatedBy AS updatedBy_111 FROM articles t0 LEFT JOIN articles_categories t19 ON t0.category_id = t19.id LEFT JOIN articles_types t27 ON t0.type_id = t27.id LEFT JOIN albums t32 ON t0.album_id = t32.id LEFT JOIN biblios t37 ON t0.biblio_id = t37.id LEFT JOIN picture t42 ON t0.qrcode_id = t42.id LEFT JOIN file t61 ON t0.generated_pdf_id = t61.id LEFT JOIN picture t78 ON t0.banner_id = t78.id LEFT JOIN users t98 ON t0.user_id = t98.id WHERE t0.id = ?
Parameters:
0 of 0
[ "8" ]
2 3.03 ms
SELECT a0_.isOnFrontPage AS isOnFrontPage_0, a0_.isVisible AS isVisible_1, a0_.isDeleted AS isDeleted_2, a0_.youtube AS youtube_3, a0_.flickr AS flickr_4, a0_.URL AS URL_5, a0_.soundcloud AS soundcloud_6, a0_.hasGeneratedPdf AS hasGeneratedPdf_7, a0_.id AS id_8, a0_.title AS title_9, a0_.description AS description_10, a0_.content AS content_11, a0_.slug AS slug_12, a0_.date AS date_13, a0_.createdAt AS createdAt_14, a0_.lastUpdate AS lastUpdate_15, a0_.isEnabled AS isEnabled_16, a0_.category_id AS category_id_17, a0_.type_id AS type_id_18, a0_.album_id AS album_id_19, a0_.biblio_id AS biblio_id_20, a0_.qrcode_id AS qrcode_id_21, a0_.generated_pdf_id AS generated_pdf_id_22, a0_.banner_id AS banner_id_23, a0_.sector_id AS sector_id_24, a0_.user_id AS user_id_25, a0_.updatedBy AS updatedBy_26 FROM articles a0_ LEFT JOIN picture p1_ ON a0_.banner_id = p1_.id LEFT JOIN articles_categories a2_ ON a0_.category_id = a2_.id LEFT JOIN articles_types a3_ ON a0_.type_id = a3_.id LEFT JOIN albums a4_ ON a0_.album_id = a4_.id LEFT JOIN biblios b5_ ON a0_.biblio_id = b5_.id WHERE a0_.date <= '2024-08-08 03:22:59' AND a0_.isEnabled = 1 ORDER BY a0_.date DESC LIMIT 6
Parameters:
[]
3 1.01 ms
SELECT t0.target AS target_1, t0.thumbnailDir AS thumbnailDir_2, t0.hasThumbnail AS hasThumbnail_3, t0.id AS id_4, t0.pages AS pages_5, t0.downloads AS downloads_6, t0.reading AS reading_7, t0.name AS name_8, t0.dir AS dir_9, t0.source AS source_10, t0.size AS size_11, t0.is_enabled AS is_enabled_12, t0.is_deleted AS is_deleted_13, t0.last_update AS last_update_14, t0.created_at AS created_at_15, t0.formatSize AS formatSize_16, t0.mimetype AS mimetype_17 FROM picture t0 WHERE t0.id IN (?, ?, ?, ?, ?)
Parameters:
0 of 0
[ 18 19 14 20 21 ]
4 1.14 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.isEnabled AS isEnabled_5, t0.banner_id AS banner_id_6 FROM articles_categories t0 WHERE t0.isEnabled = ?
Parameters:
0 of 0
[ 1 ]
5 1.04 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.slug AS slug_4, t0.isEnabled AS isEnabled_5 FROM opportunities_categories t0 WHERE t0.isEnabled = ?
Parameters:
0 of 0
[ 1 ]
6 1.20 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.slug AS slug_4 FROM resources_categories t0
Parameters:
[]
7 1.05 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.slug AS slug_4, t0.isEnabled AS isEnabled_5 FROM videos_categories t0 WHERE t0.isEnabled = ?
Parameters:
0 of 0
[ 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
App\Entity\OSEntity No errors.
App\Entity\Articles No errors.
App\Entity\ArticlesCategories No errors.
App\Entity\OSFile No errors.
App\Entity\Picture No errors.
App\Entity\ArticlesTypes No errors.
App\Entity\Albums No errors.
App\Entity\Biblios No errors.
App\Entity\File No errors.
App\Entity\Sectors No errors.
App\Entity\Users No errors.
App\Entity\Profiles No errors.
App\Entity\Tags No errors.
App\Entity\OpportunitiesCategories No errors.
App\Entity\ResourcesCategories No errors.
App\Entity\VideosCategories No errors.
App\Entity\Resources No errors.
App\Entity\Subscribers No errors.