https://preprod.mrmagz.com/view/magazine/nos-essentiels-op-29?detail=false&pagination=8&provider=preprod

Query Metrics

14 Database Queries
4 Different statements
4.51 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.45 ms
SELECT t0.`name` AS name_1, t0.`version` AS version_2, t0.slug AS slug_3, t0.`startDate` AS startDate_4, t0.`endDate` AS endDate_5, t0.enabled AS enabled_6, t0.submenu AS submenu_7, t0.preprod AS preprod_8, t0.singlepagemode AS singlepagemode_9, t0.paid AS paid_10, t0.talk AS talk_11, t0.audio AS audio_12, t0.coverscaling AS coverscaling_13, t0.locale AS locale_14, t0.title AS title_15, t0.metatitle AS metatitle_16, t0.javascript AS javascript_17, t0.stylesheet AS stylesheet_18, t0.commonstylesheet AS commonstylesheet_19, t0.css AS css_20, t0.image_json AS image_json_21, t0.theme_bg_color AS theme_bg_color_22, t0.theme_text_color AS theme_text_color_23, t0.contrast_bg_color AS contrast_bg_color_24, t0.contrast_text_color AS contrast_text_color_25, t0.use_ui_contrast_color AS use_ui_contrast_color_26, t0.use_media_contrast_color AS use_media_contrast_color_27, t0.use_sidebar_contrast_color AS use_sidebar_contrast_color_28, t0.media_icon_color AS media_icon_color_29, t0.opacity_color AS opacity_color_30, t0.theme_css AS theme_css_31, t0.offset AS offset_32, t0.pagination AS pagination_33, t0.fontsize AS fontsize_34, t0.link AS link_35, t0.id AS id_36, t0.created_at AS created_at_37, t0.total_pages AS total_pages_38, t0.width AS width_39, t0.height AS height_40, t0.updated_at AS updated_at_41, t0.bg_json AS bg_json_42, t0.product_json AS product_json_43, t0.modal AS modal_44, t0.font_json AS font_json_45, t0.catalog AS catalog_46, t0.currency AS currency_47, t0.website AS website_48, t0.cover AS cover_49, t0.download AS download_50, t0.toc_id AS toc_id_51, t0.collection AS collection_52, t0.publisher AS publisher_53, t0.logo AS logo_54 FROM magazine t0 WHERE t0.slug = ? AND t0.paid = ? LIMIT 1
Parameters:
[
  "nos-essentiels-op-29"
  0
]
2 0.59 ms
SELECT m0_.id AS id_0, m0_.route_name AS route_name_1, m0_.page_alias AS page_alias_2, m0_.`pageno` AS pageno_3, m0_.`position` AS position_4, m0_.`name` AS name_5, m0_.content AS content_6, m0_.slug AS slug_7, m0_.pdfpage AS pdfpage_8, m0_.javascript AS javascript_9, m0_.stylesheet AS stylesheet_10, m0_.enabled AS enabled_11, m0_.bookmarked AS bookmarked_12, m0_.`template` AS template_13, m0_.opposite_icon_color AS opposite_icon_color_14, m0_.created_at AS created_at_15, m0_.updated_at AS updated_at_16, m0_.modal AS modal_17, m0_.image_list AS image_list_18, m0_.thumbnail AS thumbnail_19, m0_.magazine AS magazine_20, m0_.gallery AS gallery_21 FROM magazine_page m0_ INNER JOIN magazine m1_ ON m0_.magazine = m1_.id WHERE m1_.slug = ? ORDER BY m0_.`position` ASC LIMIT 10 OFFSET 71
Parameters:
[
  "nos-essentiels-op-29"
]
3 0.31 ms
SELECT t0.position AS position_1, t0.enabled AS enabled_2, t0.updated_at AS updated_at_3, t0.created_at AS created_at_4, t0.id AS id_5, t0.gallery_id AS gallery_id_6, t0.media_id AS media_id_7 FROM media__gallery_media t0 WHERE t0.gallery_id = ?
Parameters:
[
  1345
]
4 0.31 ms
SELECT t0.name AS name_1, t0.description AS description_2, t0.enabled AS enabled_3, t0.provider_name AS provider_name_4, t0.provider_status AS provider_status_5, t0.provider_reference AS provider_reference_6, t0.provider_metadata AS provider_metadata_7, t0.width AS width_8, t0.height AS height_9, t0.length AS length_10, t0.content_type AS content_type_11, t0.content_size AS content_size_12, t0.copyright AS copyright_13, t0.author_name AS author_name_14, t0.context AS context_15, t0.cdn_is_flushable AS cdn_is_flushable_16, t0.cdn_flush_identifier AS cdn_flush_identifier_17, t0.cdn_flush_at AS cdn_flush_at_18, t0.cdn_status AS cdn_status_19, t0.updated_at AS updated_at_20, t0.created_at AS created_at_21, t0.id AS id_22, t0.thumbnail AS thumbnail_23, t0.collection AS collection_24, t0.category_id AS category_id_25 FROM media__media t0 WHERE t0.id = ?
Parameters:
[
  50942
]
5 0.31 ms
SELECT t0.name AS name_1, t0.description AS description_2, t0.enabled AS enabled_3, t0.provider_name AS provider_name_4, t0.provider_status AS provider_status_5, t0.provider_reference AS provider_reference_6, t0.provider_metadata AS provider_metadata_7, t0.width AS width_8, t0.height AS height_9, t0.length AS length_10, t0.content_type AS content_type_11, t0.content_size AS content_size_12, t0.copyright AS copyright_13, t0.author_name AS author_name_14, t0.context AS context_15, t0.cdn_is_flushable AS cdn_is_flushable_16, t0.cdn_flush_identifier AS cdn_flush_identifier_17, t0.cdn_flush_at AS cdn_flush_at_18, t0.cdn_status AS cdn_status_19, t0.updated_at AS updated_at_20, t0.created_at AS created_at_21, t0.id AS id_22, t0.thumbnail AS thumbnail_23, t0.collection AS collection_24, t0.category_id AS category_id_25 FROM media__media t0 WHERE t0.id = ?
Parameters:
[
  50935
]
6 0.27 ms
SELECT t0.name AS name_1, t0.description AS description_2, t0.enabled AS enabled_3, t0.provider_name AS provider_name_4, t0.provider_status AS provider_status_5, t0.provider_reference AS provider_reference_6, t0.provider_metadata AS provider_metadata_7, t0.width AS width_8, t0.height AS height_9, t0.length AS length_10, t0.content_type AS content_type_11, t0.content_size AS content_size_12, t0.copyright AS copyright_13, t0.author_name AS author_name_14, t0.context AS context_15, t0.cdn_is_flushable AS cdn_is_flushable_16, t0.cdn_flush_identifier AS cdn_flush_identifier_17, t0.cdn_flush_at AS cdn_flush_at_18, t0.cdn_status AS cdn_status_19, t0.updated_at AS updated_at_20, t0.created_at AS created_at_21, t0.id AS id_22, t0.thumbnail AS thumbnail_23, t0.collection AS collection_24, t0.category_id AS category_id_25 FROM media__media t0 WHERE t0.id = ?
Parameters:
[
  50936
]
7 0.28 ms
SELECT t0.name AS name_1, t0.description AS description_2, t0.enabled AS enabled_3, t0.provider_name AS provider_name_4, t0.provider_status AS provider_status_5, t0.provider_reference AS provider_reference_6, t0.provider_metadata AS provider_metadata_7, t0.width AS width_8, t0.height AS height_9, t0.length AS length_10, t0.content_type AS content_type_11, t0.content_size AS content_size_12, t0.copyright AS copyright_13, t0.author_name AS author_name_14, t0.context AS context_15, t0.cdn_is_flushable AS cdn_is_flushable_16, t0.cdn_flush_identifier AS cdn_flush_identifier_17, t0.cdn_flush_at AS cdn_flush_at_18, t0.cdn_status AS cdn_status_19, t0.updated_at AS updated_at_20, t0.created_at AS created_at_21, t0.id AS id_22, t0.thumbnail AS thumbnail_23, t0.collection AS collection_24, t0.category_id AS category_id_25 FROM media__media t0 WHERE t0.id = ?
Parameters:
[
  50937
]
8 0.34 ms
SELECT t0.name AS name_1, t0.description AS description_2, t0.enabled AS enabled_3, t0.provider_name AS provider_name_4, t0.provider_status AS provider_status_5, t0.provider_reference AS provider_reference_6, t0.provider_metadata AS provider_metadata_7, t0.width AS width_8, t0.height AS height_9, t0.length AS length_10, t0.content_type AS content_type_11, t0.content_size AS content_size_12, t0.copyright AS copyright_13, t0.author_name AS author_name_14, t0.context AS context_15, t0.cdn_is_flushable AS cdn_is_flushable_16, t0.cdn_flush_identifier AS cdn_flush_identifier_17, t0.cdn_flush_at AS cdn_flush_at_18, t0.cdn_status AS cdn_status_19, t0.updated_at AS updated_at_20, t0.created_at AS created_at_21, t0.id AS id_22, t0.thumbnail AS thumbnail_23, t0.collection AS collection_24, t0.category_id AS category_id_25 FROM media__media t0 WHERE t0.id = ?
Parameters:
[
  50938
]
9 0.37 ms
SELECT t0.name AS name_1, t0.description AS description_2, t0.enabled AS enabled_3, t0.provider_name AS provider_name_4, t0.provider_status AS provider_status_5, t0.provider_reference AS provider_reference_6, t0.provider_metadata AS provider_metadata_7, t0.width AS width_8, t0.height AS height_9, t0.length AS length_10, t0.content_type AS content_type_11, t0.content_size AS content_size_12, t0.copyright AS copyright_13, t0.author_name AS author_name_14, t0.context AS context_15, t0.cdn_is_flushable AS cdn_is_flushable_16, t0.cdn_flush_identifier AS cdn_flush_identifier_17, t0.cdn_flush_at AS cdn_flush_at_18, t0.cdn_status AS cdn_status_19, t0.updated_at AS updated_at_20, t0.created_at AS created_at_21, t0.id AS id_22, t0.thumbnail AS thumbnail_23, t0.collection AS collection_24, t0.category_id AS category_id_25 FROM media__media t0 WHERE t0.id = ?
Parameters:
[
  50939
]
10 0.31 ms
SELECT t0.name AS name_1, t0.description AS description_2, t0.enabled AS enabled_3, t0.provider_name AS provider_name_4, t0.provider_status AS provider_status_5, t0.provider_reference AS provider_reference_6, t0.provider_metadata AS provider_metadata_7, t0.width AS width_8, t0.height AS height_9, t0.length AS length_10, t0.content_type AS content_type_11, t0.content_size AS content_size_12, t0.copyright AS copyright_13, t0.author_name AS author_name_14, t0.context AS context_15, t0.cdn_is_flushable AS cdn_is_flushable_16, t0.cdn_flush_identifier AS cdn_flush_identifier_17, t0.cdn_flush_at AS cdn_flush_at_18, t0.cdn_status AS cdn_status_19, t0.updated_at AS updated_at_20, t0.created_at AS created_at_21, t0.id AS id_22, t0.thumbnail AS thumbnail_23, t0.collection AS collection_24, t0.category_id AS category_id_25 FROM media__media t0 WHERE t0.id = ?
Parameters:
[
  50940
]
11 0.26 ms
SELECT t0.name AS name_1, t0.description AS description_2, t0.enabled AS enabled_3, t0.provider_name AS provider_name_4, t0.provider_status AS provider_status_5, t0.provider_reference AS provider_reference_6, t0.provider_metadata AS provider_metadata_7, t0.width AS width_8, t0.height AS height_9, t0.length AS length_10, t0.content_type AS content_type_11, t0.content_size AS content_size_12, t0.copyright AS copyright_13, t0.author_name AS author_name_14, t0.context AS context_15, t0.cdn_is_flushable AS cdn_is_flushable_16, t0.cdn_flush_identifier AS cdn_flush_identifier_17, t0.cdn_flush_at AS cdn_flush_at_18, t0.cdn_status AS cdn_status_19, t0.updated_at AS updated_at_20, t0.created_at AS created_at_21, t0.id AS id_22, t0.thumbnail AS thumbnail_23, t0.collection AS collection_24, t0.category_id AS category_id_25 FROM media__media t0 WHERE t0.id = ?
Parameters:
[
  50941
]
12 0.24 ms
SELECT t0.name AS name_1, t0.description AS description_2, t0.enabled AS enabled_3, t0.provider_name AS provider_name_4, t0.provider_status AS provider_status_5, t0.provider_reference AS provider_reference_6, t0.provider_metadata AS provider_metadata_7, t0.width AS width_8, t0.height AS height_9, t0.length AS length_10, t0.content_type AS content_type_11, t0.content_size AS content_size_12, t0.copyright AS copyright_13, t0.author_name AS author_name_14, t0.context AS context_15, t0.cdn_is_flushable AS cdn_is_flushable_16, t0.cdn_flush_identifier AS cdn_flush_identifier_17, t0.cdn_flush_at AS cdn_flush_at_18, t0.cdn_status AS cdn_status_19, t0.updated_at AS updated_at_20, t0.created_at AS created_at_21, t0.id AS id_22, t0.thumbnail AS thumbnail_23, t0.collection AS collection_24, t0.category_id AS category_id_25 FROM media__media t0 WHERE t0.id = ?
Parameters:
[
  50943
]
13 0.24 ms
SELECT t0.name AS name_1, t0.description AS description_2, t0.enabled AS enabled_3, t0.provider_name AS provider_name_4, t0.provider_status AS provider_status_5, t0.provider_reference AS provider_reference_6, t0.provider_metadata AS provider_metadata_7, t0.width AS width_8, t0.height AS height_9, t0.length AS length_10, t0.content_type AS content_type_11, t0.content_size AS content_size_12, t0.copyright AS copyright_13, t0.author_name AS author_name_14, t0.context AS context_15, t0.cdn_is_flushable AS cdn_is_flushable_16, t0.cdn_flush_identifier AS cdn_flush_identifier_17, t0.cdn_flush_at AS cdn_flush_at_18, t0.cdn_status AS cdn_status_19, t0.updated_at AS updated_at_20, t0.created_at AS created_at_21, t0.id AS id_22, t0.thumbnail AS thumbnail_23, t0.collection AS collection_24, t0.category_id AS category_id_25 FROM media__media t0 WHERE t0.id = ?
Parameters:
[
  50944
]
14 0.23 ms
SELECT t0.name AS name_1, t0.description AS description_2, t0.enabled AS enabled_3, t0.provider_name AS provider_name_4, t0.provider_status AS provider_status_5, t0.provider_reference AS provider_reference_6, t0.provider_metadata AS provider_metadata_7, t0.width AS width_8, t0.height AS height_9, t0.length AS length_10, t0.content_type AS content_type_11, t0.content_size AS content_size_12, t0.copyright AS copyright_13, t0.author_name AS author_name_14, t0.context AS context_15, t0.cdn_is_flushable AS cdn_is_flushable_16, t0.cdn_flush_identifier AS cdn_flush_identifier_17, t0.cdn_flush_at AS cdn_flush_at_18, t0.cdn_status AS cdn_status_19, t0.updated_at AS updated_at_20, t0.created_at AS created_at_21, t0.id AS id_22, t0.thumbnail AS thumbnail_23, t0.collection AS collection_24, t0.category_id AS category_id_25 FROM media__media t0 WHERE t0.id = ?
Parameters:
[
  50945
]

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\Magazine\Magazine No errors.
Sonata\MediaBundle\Entity\BaseMedia No errors.
App\Application\Sonata\MediaBundle\Entity\Media No errors.
App\Entity\Magazine\TOC No errors.
Sonata\ClassificationBundle\Entity\BaseCollection No errors.
App\Entity\Sonata\Classification\Collection No errors.
App\Entity\Project\Publisher No errors.
App\Entity\Admin\Editor\Block No errors.
App\Entity\Magazine\MagazinePage No errors.
App\Entity\Account\Subscription No errors.
App\Entity\Admin\Product No errors.
Sonata\MediaBundle\Entity\BaseGallery No errors.
App\Application\Sonata\MediaBundle\Entity\Gallery No errors.
Sonata\MediaBundle\Entity\BaseGalleryHasMedia No errors.
App\Application\Sonata\MediaBundle\Entity\GalleryHasMedia No errors.
Sonata\ClassificationBundle\Entity\BaseCategory No errors.
App\Entity\Sonata\Classification\Category No errors.