Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

4.39 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	2.53 ms	SELECT count(DISTINCT (a0_.id)) AS sclr_0 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 ORDER BY a0_.date DESC Parameters: [] View formatted query View runnable query Explain query SELECT count( DISTINCT (a0_.id) ) AS sclr_0 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 ORDER BY a0_.date DESC SELECT count(DISTINCT (a0_.id)) AS sclr_0 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 ORDER BY a0_.date DESC;
2	1.86 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, p1_.target AS target_17, p1_.thumbnailDir AS thumbnailDir_18, p1_.hasThumbnail AS hasThumbnail_19, p1_.id AS id_20, p1_.pages AS pages_21, p1_.downloads AS downloads_22, p1_.reading AS reading_23, p1_.name AS name_24, p1_.dir AS dir_25, p1_.source AS source_26, p1_.size AS size_27, p1_.is_enabled AS is_enabled_28, p1_.is_deleted AS is_deleted_29, p1_.last_update AS last_update_30, p1_.created_at AS created_at_31, p1_.formatSize AS formatSize_32, p1_.mimetype AS mimetype_33, a2_.id AS id_34, a2_.name AS name_35, a2_.slug AS slug_36, a2_.description AS description_37, a2_.isEnabled AS isEnabled_38, a3_.id AS id_39, a3_.title AS title_40, a3_.isEnabled AS isEnabled_41, b4_.id AS id_42, b4_.title AS title_43, b4_.isEnabled AS isEnabled_44, a0_.category_id AS category_id_45, a0_.type_id AS type_id_46, a0_.album_id AS album_id_47, a0_.biblio_id AS biblio_id_48, a0_.qrcode_id AS qrcode_id_49, a0_.generated_pdf_id AS generated_pdf_id_50, a0_.banner_id AS banner_id_51, a0_.sector_id AS sector_id_52, a0_.user_id AS user_id_53, a0_.updatedBy AS updatedBy_54, a2_.banner_id AS banner_id_55 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 a5_ ON a0_.type_id = a5_.id LEFT JOIN albums a3_ ON a0_.album_id = a3_.id LEFT JOIN biblios b4_ ON a0_.biblio_id = b4_.id ORDER BY a0_.date DESC LIMIT 20 Parameters: [] View formatted query View runnable query Explain query 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, p1_.target AS target_17, p1_.thumbnailDir AS thumbnailDir_18, p1_.hasThumbnail AS hasThumbnail_19, p1_.id AS id_20, p1_.pages AS pages_21, p1_.downloads AS downloads_22, p1_.reading AS reading_23, p1_.name AS name_24, p1_.dir AS dir_25, p1_.source AS source_26, p1_.size AS size_27, p1_.is_enabled AS is_enabled_28, p1_.is_deleted AS is_deleted_29, p1_.last_update AS last_update_30, p1_.created_at AS created_at_31, p1_.formatSize AS formatSize_32, p1_.mimetype AS mimetype_33, a2_.id AS id_34, a2_.name AS name_35, a2_.slug AS slug_36, a2_.description AS description_37, a2_.isEnabled AS isEnabled_38, a3_.id AS id_39, a3_.title AS title_40, a3_.isEnabled AS isEnabled_41, b4_.id AS id_42, b4_.title AS title_43, b4_.isEnabled AS isEnabled_44, a0_.category_id AS category_id_45, a0_.type_id AS type_id_46, a0_.album_id AS album_id_47, a0_.biblio_id AS biblio_id_48, a0_.qrcode_id AS qrcode_id_49, a0_.generated_pdf_id AS generated_pdf_id_50, a0_.banner_id AS banner_id_51, a0_.sector_id AS sector_id_52, a0_.user_id AS user_id_53, a0_.updatedBy AS updatedBy_54, a2_.banner_id AS banner_id_55 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 a5_ ON a0_.type_id = a5_.id LEFT JOIN albums a3_ ON a0_.album_id = a3_.id LEFT JOIN biblios b4_ ON a0_.biblio_id = b4_.id ORDER BY a0_.date DESC LIMIT 20 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, p1_.target AS target_17, p1_.thumbnailDir AS thumbnailDir_18, p1_.hasThumbnail AS hasThumbnail_19, p1_.id AS id_20, p1_.pages AS pages_21, p1_.downloads AS downloads_22, p1_.reading AS reading_23, p1_.name AS name_24, p1_.dir AS dir_25, p1_.source AS source_26, p1_.size AS size_27, p1_.is_enabled AS is_enabled_28, p1_.is_deleted AS is_deleted_29, p1_.last_update AS last_update_30, p1_.created_at AS created_at_31, p1_.formatSize AS formatSize_32, p1_.mimetype AS mimetype_33, a2_.id AS id_34, a2_.name AS name_35, a2_.slug AS slug_36, a2_.description AS description_37, a2_.isEnabled AS isEnabled_38, a3_.id AS id_39, a3_.title AS title_40, a3_.isEnabled AS isEnabled_41, b4_.id AS id_42, b4_.title AS title_43, b4_.isEnabled AS isEnabled_44, a0_.category_id AS category_id_45, a0_.type_id AS type_id_46, a0_.album_id AS album_id_47, a0_.biblio_id AS biblio_id_48, a0_.qrcode_id AS qrcode_id_49, a0_.generated_pdf_id AS generated_pdf_id_50, a0_.banner_id AS banner_id_51, a0_.sector_id AS sector_id_52, a0_.user_id AS user_id_53, a0_.updatedBy AS updatedBy_54, a2_.banner_id AS banner_id_55 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 a5_ ON a0_.type_id = a5_.id LEFT JOIN albums a3_ ON a0_.album_id = a3_.id LEFT JOIN biblios b4_ ON a0_.biblio_id = b4_.id ORDER BY a0_.date DESC LIMIT 20;

#▲

Time

Info

2.53 ms

SELECT count(DISTINCT (a0_.id)) AS sclr_0 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 ORDER BY a0_.date DESC

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  count(
    DISTINCT (a0_.id)
  ) AS sclr_0
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
ORDER BY
  a0_.date DESC

SELECT count(DISTINCT (a0_.id)) AS sclr_0 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 ORDER BY a0_.date DESC;

1.86 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, p1_.target AS target_17, p1_.thumbnailDir AS thumbnailDir_18, p1_.hasThumbnail AS hasThumbnail_19, p1_.id AS id_20, p1_.pages AS pages_21, p1_.downloads AS downloads_22, p1_.reading AS reading_23, p1_.name AS name_24, p1_.dir AS dir_25, p1_.source AS source_26, p1_.size AS size_27, p1_.is_enabled AS is_enabled_28, p1_.is_deleted AS is_deleted_29, p1_.last_update AS last_update_30, p1_.created_at AS created_at_31, p1_.formatSize AS formatSize_32, p1_.mimetype AS mimetype_33, a2_.id AS id_34, a2_.name AS name_35, a2_.slug AS slug_36, a2_.description AS description_37, a2_.isEnabled AS isEnabled_38, a3_.id AS id_39, a3_.title AS title_40, a3_.isEnabled AS isEnabled_41, b4_.id AS id_42, b4_.title AS title_43, b4_.isEnabled AS isEnabled_44, a0_.category_id AS category_id_45, a0_.type_id AS type_id_46, a0_.album_id AS album_id_47, a0_.biblio_id AS biblio_id_48, a0_.qrcode_id AS qrcode_id_49, a0_.generated_pdf_id AS generated_pdf_id_50, a0_.banner_id AS banner_id_51, a0_.sector_id AS sector_id_52, a0_.user_id AS user_id_53, a0_.updatedBy AS updatedBy_54, a2_.banner_id AS banner_id_55 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 a5_ ON a0_.type_id = a5_.id LEFT JOIN albums a3_ ON a0_.album_id = a3_.id LEFT JOIN biblios b4_ ON a0_.biblio_id = b4_.id ORDER BY a0_.date DESC LIMIT 20

Parameters:

[]

View formatted query View runnable query Explain query

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,
  p1_.target AS target_17,
  p1_.thumbnailDir AS thumbnailDir_18,
  p1_.hasThumbnail AS hasThumbnail_19,
  p1_.id AS id_20,
  p1_.pages AS pages_21,
  p1_.downloads AS downloads_22,
  p1_.reading AS reading_23,
  p1_.name AS name_24,
  p1_.dir AS dir_25,
  p1_.source AS source_26,
  p1_.size AS size_27,
  p1_.is_enabled AS is_enabled_28,
  p1_.is_deleted AS is_deleted_29,
  p1_.last_update AS last_update_30,
  p1_.created_at AS created_at_31,
  p1_.formatSize AS formatSize_32,
  p1_.mimetype AS mimetype_33,
  a2_.id AS id_34,
  a2_.name AS name_35,
  a2_.slug AS slug_36,
  a2_.description AS description_37,
  a2_.isEnabled AS isEnabled_38,
  a3_.id AS id_39,
  a3_.title AS title_40,
  a3_.isEnabled AS isEnabled_41,
  b4_.id AS id_42,
  b4_.title AS title_43,
  b4_.isEnabled AS isEnabled_44,
  a0_.category_id AS category_id_45,
  a0_.type_id AS type_id_46,
  a0_.album_id AS album_id_47,
  a0_.biblio_id AS biblio_id_48,
  a0_.qrcode_id AS qrcode_id_49,
  a0_.generated_pdf_id AS generated_pdf_id_50,
  a0_.banner_id AS banner_id_51,
  a0_.sector_id AS sector_id_52,
  a0_.user_id AS user_id_53,
  a0_.updatedBy AS updatedBy_54,
  a2_.banner_id AS banner_id_55
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 a5_ ON a0_.type_id = a5_.id
  LEFT JOIN albums a3_ ON a0_.album_id = a3_.id
  LEFT JOIN biblios b4_ ON a0_.biblio_id = b4_.id
ORDER BY
  a0_.date DESC
LIMIT
  20

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, p1_.target AS target_17, p1_.thumbnailDir AS thumbnailDir_18, p1_.hasThumbnail AS hasThumbnail_19, p1_.id AS id_20, p1_.pages AS pages_21, p1_.downloads AS downloads_22, p1_.reading AS reading_23, p1_.name AS name_24, p1_.dir AS dir_25, p1_.source AS source_26, p1_.size AS size_27, p1_.is_enabled AS is_enabled_28, p1_.is_deleted AS is_deleted_29, p1_.last_update AS last_update_30, p1_.created_at AS created_at_31, p1_.formatSize AS formatSize_32, p1_.mimetype AS mimetype_33, a2_.id AS id_34, a2_.name AS name_35, a2_.slug AS slug_36, a2_.description AS description_37, a2_.isEnabled AS isEnabled_38, a3_.id AS id_39, a3_.title AS title_40, a3_.isEnabled AS isEnabled_41, b4_.id AS id_42, b4_.title AS title_43, b4_.isEnabled AS isEnabled_44, a0_.category_id AS category_id_45, a0_.type_id AS type_id_46, a0_.album_id AS album_id_47, a0_.biblio_id AS biblio_id_48, a0_.qrcode_id AS qrcode_id_49, a0_.generated_pdf_id AS generated_pdf_id_50, a0_.banner_id AS banner_id_51, a0_.sector_id AS sector_id_52, a0_.user_id AS user_id_53, a0_.updatedBy AS updatedBy_54, a2_.banner_id AS banner_id_55 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 a5_ ON a0_.type_id = a5_.id LEFT JOIN albums a3_ ON a0_.album_id = a3_.id LEFT JOIN biblios b4_ ON a0_.biblio_id = b4_.id ORDER BY a0_.date DESC LIMIT 20;

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\OSFile	No errors.
App\Entity\Picture	No errors.
App\Entity\ArticlesCategories	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\Tags	No errors.

Symfony Profiler

GET https://asin.olasoft.net/os-admin/articles/

Configuration Settings

Theme