Symfony Profiler

SELECT
  u0_.id AS id_0,
  u0_.name AS name_1,
  u0_.slug AS slug_2,
  u0_.email AS email_3,
  u0_.created_at AS created_at_4,
  u0_.updated_at AS updated_at_5,
  u0_.theme_bg_color AS theme_bg_color_6,
  u0_.theme_text_color AS theme_text_color_7,
  u0_.contrast_bg_color AS contrast_bg_color_8,
  u0_.contrast_text_color AS contrast_text_color_9,
  u0_.opacity_color AS opacity_color_10,
  u0_.locale AS locale_11,
  u0_.paid AS paid_12,
  u0_.is_active AS is_active_13,
  u0_.domain AS domain_14,
  u0_.frontend_domain AS frontend_domain_15,
  u0_.username AS username_16,
  u1_.id AS id_17,
  u1_.`name` AS name_18,
  u1_.slug AS slug_19,
  u1_.`email` AS email_20,
  u1_.`address` AS address_21,
  u1_.`phone` AS phone_22,
  u1_.website AS website_23,
  u1_.created_at AS created_at_24,
  u1_.updated_at AS updated_at_25,
  m2_.`name` AS name_26,
  m2_.`version` AS version_27,
  m2_.slug AS slug_28,
  m2_.`startDate` AS startDate_29,
  m2_.`endDate` AS endDate_30,
  m2_.enabled AS enabled_31,
  m2_.submenu AS submenu_32,
  m2_.preprod AS preprod_33,
  m2_.singlepagemode AS singlepagemode_34,
  m2_.paid AS paid_35,
  m2_.talk AS talk_36,
  m2_.audio AS audio_37,
  m2_.coverscaling AS coverscaling_38,
  m2_.locale AS locale_39,
  m2_.title AS title_40,
  m2_.metatitle AS metatitle_41,
  m2_.javascript AS javascript_42,
  m2_.stylesheet AS stylesheet_43,
  m2_.commonstylesheet AS commonstylesheet_44,
  m2_.css AS css_45,
  m2_.image_json AS image_json_46,
  m2_.theme_bg_color AS theme_bg_color_47,
  m2_.theme_text_color AS theme_text_color_48,
  m2_.contrast_bg_color AS contrast_bg_color_49,
  m2_.contrast_text_color AS contrast_text_color_50,
  m2_.use_ui_contrast_color AS use_ui_contrast_color_51,
  m2_.use_media_contrast_color AS use_media_contrast_color_52,
  m2_.use_sidebar_contrast_color AS use_sidebar_contrast_color_53,
  m2_.media_icon_color AS media_icon_color_54,
  m2_.opacity_color AS opacity_color_55,
  m2_.theme_css AS theme_css_56,
  m2_.offset AS offset_57,
  m2_.pagination AS pagination_58,
  m2_.fontsize AS fontsize_59,
  m2_.link AS link_60,
  m2_.id AS id_61,
  m2_.created_at AS created_at_62,
  m2_.total_pages AS total_pages_63,
  m2_.width AS width_64,
  m2_.height AS height_65,
  m2_.updated_at AS updated_at_66,
  m2_.bg_json AS bg_json_67,
  m2_.product_json AS product_json_68,
  m2_.modal AS modal_69,
  m2_.font_json AS font_json_70,
  m2_.catalog AS catalog_71,
  m2_.currency AS currency_72,
  m2_.website AS website_73,
  u0_.logo AS logo_74,
  u0_.user_id AS user_id_75,
  u1_.logo AS logo_76,
  u1_.publisherstore AS publisherstore_77,
  m2_.cover AS cover_78,
  m2_.download AS download_79,
  m2_.toc_id AS toc_id_80,
  m2_.collection AS collection_81,
  m2_.publisher AS publisher_82,
  m2_.logo AS logo_83
FROM
  user_publisher_store u0_
  INNER JOIN user_publisher u1_ ON u0_.id = u1_.publisherstore
  INNER JOIN magazine m2_ ON u1_.id = m2_.publisher
WHERE
  u0_.slug = ?
  AND m2_.enabled = ?
ORDER BY
  m2_.`startDate` DESC,
  u1_.created_at DESC

SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.email AS email_3, u0_.created_at AS created_at_4, u0_.updated_at AS updated_at_5, u0_.theme_bg_color AS theme_bg_color_6, u0_.theme_text_color AS theme_text_color_7, u0_.contrast_bg_color AS contrast_bg_color_8, u0_.contrast_text_color AS contrast_text_color_9, u0_.opacity_color AS opacity_color_10, u0_.locale AS locale_11, u0_.paid AS paid_12, u0_.is_active AS is_active_13, u0_.domain AS domain_14, u0_.frontend_domain AS frontend_domain_15, u0_.username AS username_16, u1_.id AS id_17, u1_.`name` AS name_18, u1_.slug AS slug_19, u1_.`email` AS email_20, u1_.`address` AS address_21, u1_.`phone` AS phone_22, u1_.website AS website_23, u1_.created_at AS created_at_24, u1_.updated_at AS updated_at_25, m2_.`name` AS name_26, m2_.`version` AS version_27, m2_.slug AS slug_28, m2_.`startDate` AS startDate_29, m2_.`endDate` AS endDate_30, m2_.enabled AS enabled_31, m2_.submenu AS submenu_32, m2_.preprod AS preprod_33, m2_.singlepagemode AS singlepagemode_34, m2_.paid AS paid_35, m2_.talk AS talk_36, m2_.audio AS audio_37, m2_.coverscaling AS coverscaling_38, m2_.locale AS locale_39, m2_.title AS title_40, m2_.metatitle AS metatitle_41, m2_.javascript AS javascript_42, m2_.stylesheet AS stylesheet_43, m2_.commonstylesheet AS commonstylesheet_44, m2_.css AS css_45, m2_.image_json AS image_json_46, m2_.theme_bg_color AS theme_bg_color_47, m2_.theme_text_color AS theme_text_color_48, m2_.contrast_bg_color AS contrast_bg_color_49, m2_.contrast_text_color AS contrast_text_color_50, m2_.use_ui_contrast_color AS use_ui_contrast_color_51, m2_.use_media_contrast_color AS use_media_contrast_color_52, m2_.use_sidebar_contrast_color AS use_sidebar_contrast_color_53, m2_.media_icon_color AS media_icon_color_54, m2_.opacity_color AS opacity_color_55, m2_.theme_css AS theme_css_56, m2_.offset AS offset_57, m2_.pagination AS pagination_58, m2_.fontsize AS fontsize_59, m2_.link AS link_60, m2_.id AS id_61, m2_.created_at AS created_at_62, m2_.total_pages AS total_pages_63, m2_.width AS width_64, m2_.height AS height_65, m2_.updated_at AS updated_at_66, m2_.bg_json AS bg_json_67, m2_.product_json AS product_json_68, m2_.modal AS modal_69, m2_.font_json AS font_json_70, m2_.catalog AS catalog_71, m2_.currency AS currency_72, m2_.website AS website_73, u0_.logo AS logo_74, u0_.user_id AS user_id_75, u1_.logo AS logo_76, u1_.publisherstore AS publisherstore_77, m2_.cover AS cover_78, m2_.download AS download_79, m2_.toc_id AS toc_id_80, m2_.collection AS collection_81, m2_.publisher AS publisher_82, m2_.logo AS logo_83 FROM user_publisher_store u0_ INNER JOIN user_publisher u1_ ON u0_.id = u1_.publisherstore INNER JOIN magazine m2_ ON u1_.id = m2_.publisher WHERE u0_.slug = 'la-poste-mob-le' AND m2_.enabled = 1 ORDER BY m2_.`startDate` DESC, u1_.created_at DESC;

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
  INNER JOIN translation_group ON t0.id = translation_group.magazine_target
WHERE
  translation_group.magazine_source = ?

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 INNER JOIN translation_group ON t0.id = translation_group.magazine_target WHERE translation_group.magazine_source = 1392;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.name AS name_4,
  t0.type AS type_5,
  t0.period AS period_6,
  t0.started_at AS started_at_7,
  t0.favorite AS favorite_8,
  t0.user_id AS user_id_9,
  t0.magazine AS magazine_10
FROM
  subscription t0
WHERE
  t0.magazine = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.name AS name_4, t0.type AS type_5, t0.period AS period_6, t0.started_at AS started_at_7, t0.favorite AS favorite_8, t0.user_id AS user_id_9, t0.magazine AS magazine_10 FROM subscription t0 WHERE t0.magazine = 1392;

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 = ?

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 = 19145;

SELECT
  t0.id AS id_1,
  t0.`name` AS name_2,
  t0.`description` AS description_3,
  t0.`css` AS css_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.master AS master_7
FROM
  editor_commoncss t0
WHERE
  t0.master = ?

SELECT t0.id AS id_1, t0.`name` AS name_2, t0.`description` AS description_3, t0.`css` AS css_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.master AS master_7 FROM editor_commoncss t0 WHERE t0.master = 31;

SELECT
  DISTINCT m0_.locale AS locale_0
FROM
  user_publisher_store u1_
  LEFT JOIN user_publisher u2_ ON u1_.id = u2_.publisherstore
  LEFT JOIN magazine m0_ ON u2_.id = m0_.publisher
WHERE
  u2_.publisherstore = ?

SELECT DISTINCT m0_.locale AS locale_0 FROM user_publisher_store u1_ LEFT JOIN user_publisher u2_ ON u1_.id = u2_.publisherstore LEFT JOIN magazine m0_ ON u2_.id = m0_.publisher WHERE u2_.publisherstore = 11;