https://preprod.mrmagz.com/admin/product/ppicker?magazine=1443&page=1

Query Metrics

3 Database Queries
3 Different statements
0.91 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.33 ms
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.date_of_birth AS date_of_birth_14, t0.firstname AS firstname_15, t0.lastname AS lastname_16, t0.website AS website_17, t0.biography AS biography_18, t0.gender AS gender_19, t0.locale AS locale_20, t0.timezone AS timezone_21, t0.phone AS phone_22, t0.facebook_uid AS facebook_uid_23, t0.facebook_name AS facebook_name_24, t0.facebook_data AS facebook_data_25, t0.twitter_uid AS twitter_uid_26, t0.twitter_name AS twitter_name_27, t0.twitter_data AS twitter_data_28, t0.gplus_uid AS gplus_uid_29, t0.gplus_name AS gplus_name_30, t0.gplus_data AS gplus_data_31, t0.token AS token_32, t0.two_step_code AS two_step_code_33, t0.id AS id_34, t0.fullname AS fullname_35, t0.country AS country_36, t0.is_publisher AS is_publisher_37, t0.publisherstore_id AS publisherstore_id_38 FROM fos_user_user t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  3
]
2 0.22 ms
SELECT t0.name AS name_1, t0.roles AS roles_2, t0.id AS id_3 FROM fos_user_group t0 INNER JOIN fos_user_user_group ON t0.id = fos_user_user_group.group_id WHERE fos_user_user_group.user_id = ?
Parameters:
[
  3
]
3 0.36 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.id = ?
Parameters:
[
  "1443"
]

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
FOS\UserBundle\Model\User No errors.
Sonata\UserBundle\Entity\BaseUser No errors.
App\Application\Sonata\UserBundle\Entity\User No errors.
App\Entity\Project\PublisherStore No errors.
FOS\UserBundle\Model\Group No errors.
Sonata\UserBundle\Entity\BaseGroup No errors.
App\Application\Sonata\UserBundle\Entity\Group No 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.