Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.preview_fragment AS preview_fragment_2,
  t0.updated_at AS updated_at_3,
  t0.title AS title_4,
  t0.slug AS slug_5,
  t0.subtitle AS subtitle_6,
  t0.frontend_description AS frontend_description_7,
  t0.frontend_description_short AS frontend_description_short_8,
  t0.is_recommended AS is_recommended_9,
  t0.is_most_bought AS is_most_bought_10,
  t0.logo AS logo_11,
  t0.background AS background_12,
  t0.partner_logo AS partner_logo_13,
  t0.default_quantity_ticket AS default_quantity_ticket_14,
  t0.custom_scripts AS custom_scripts_15,
  t0.is_hidden AS is_hidden_16,
  t0.number_of_access_to_last_releases AS number_of_access_to_last_releases_17,
  t0.use_html_landing AS use_html_landing_18,
  t0.custom_head AS custom_head_19,
  t0.custom_css AS custom_css_20,
  t0.custom_landing AS custom_landing_21,
  t0.landing_full_width AS landing_full_width_22,
  t0.portal_settings_id AS portal_settings_id_23,
  t0.coupon_default_id AS coupon_default_id_24,
  t25.id AS id_26,
  t25.is_active AS is_active_27,
  t25.short_body AS short_body_28,
  t25.body AS body_29,
  t25.testimonials_custom AS testimonials_custom_30,
  t25.category_name AS category_name_31,
  t25.category_slug AS category_slug_32,
  t25.position AS position_33,
  t25.image_name AS image_name_34,
  t25.banner_name AS banner_name_35,
  t25.banner_link AS banner_link_36,
  t25.banner_html AS banner_html_37,
  t25.updated_at AS updated_at_38,
  t25.default_for_us AS default_for_us_39,
  t25.parent_id AS parent_id_40,
  t25.portal_settings_id AS portal_settings_id_41,
  t25.recommended_product_association_id AS recommended_product_association_id_42,
  t25.language_id AS language_id_43,
  t0.category_master_id AS category_master_id_44,
  t45.id AS id_46,
  t45.is_active AS is_active_47,
  t45.name AS name_48,
  t45.portal_settings_id AS portal_settings_id_49,
  t45.category_id AS category_id_50,
  t45.product_association_id AS product_association_id_51,
  t45.product_main_type_id AS product_main_type_id_52,
  t45.template_type_id AS template_type_id_53,
  t0.product_main_type_id AS product_main_type_id_54,
  t55.id AS id_56,
  t55.title AS title_57,
  t55.description AS description_58,
  t55.head_scripts AS head_scripts_59,
  t55.body_scripts AS body_scripts_60,
  t55.created_at AS created_at_61,
  t55.updated_at AS updated_at_62,
  t55.product_association_id AS product_association_id_63,
  t55.category_id AS category_id_64,
  t55.template_type_id AS template_type_id_65
FROM
  product_association t0
  LEFT JOIN category t25 ON t25.recommended_product_association_id = t0.id
  LEFT JOIN templates t45 ON t45.product_association_id = t0.id
  LEFT JOIN meta_tags t55 ON t55.product_association_id = t0.id
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.preview_fragment AS preview_fragment_2, t0.updated_at AS updated_at_3, t0.title AS title_4, t0.slug AS slug_5, t0.subtitle AS subtitle_6, t0.frontend_description AS frontend_description_7, t0.frontend_description_short AS frontend_description_short_8, t0.is_recommended AS is_recommended_9, t0.is_most_bought AS is_most_bought_10, t0.logo AS logo_11, t0.background AS background_12, t0.partner_logo AS partner_logo_13, t0.default_quantity_ticket AS default_quantity_ticket_14, t0.custom_scripts AS custom_scripts_15, t0.is_hidden AS is_hidden_16, t0.number_of_access_to_last_releases AS number_of_access_to_last_releases_17, t0.use_html_landing AS use_html_landing_18, t0.custom_head AS custom_head_19, t0.custom_css AS custom_css_20, t0.custom_landing AS custom_landing_21, t0.landing_full_width AS landing_full_width_22, t0.portal_settings_id AS portal_settings_id_23, t0.coupon_default_id AS coupon_default_id_24, t25.id AS id_26, t25.is_active AS is_active_27, t25.short_body AS short_body_28, t25.body AS body_29, t25.testimonials_custom AS testimonials_custom_30, t25.category_name AS category_name_31, t25.category_slug AS category_slug_32, t25.position AS position_33, t25.image_name AS image_name_34, t25.banner_name AS banner_name_35, t25.banner_link AS banner_link_36, t25.banner_html AS banner_html_37, t25.updated_at AS updated_at_38, t25.default_for_us AS default_for_us_39, t25.parent_id AS parent_id_40, t25.portal_settings_id AS portal_settings_id_41, t25.recommended_product_association_id AS recommended_product_association_id_42, t25.language_id AS language_id_43, t0.category_master_id AS category_master_id_44, t45.id AS id_46, t45.is_active AS is_active_47, t45.name AS name_48, t45.portal_settings_id AS portal_settings_id_49, t45.category_id AS category_id_50, t45.product_association_id AS product_association_id_51, t45.product_main_type_id AS product_main_type_id_52, t45.template_type_id AS template_type_id_53, t0.product_main_type_id AS product_main_type_id_54, t55.id AS id_56, t55.title AS title_57, t55.description AS description_58, t55.head_scripts AS head_scripts_59, t55.body_scripts AS body_scripts_60, t55.created_at AS created_at_61, t55.updated_at AS updated_at_62, t55.product_association_id AS product_association_id_63, t55.category_id AS category_id_64, t55.template_type_id AS template_type_id_65 FROM product_association t0 LEFT JOIN category t25 ON t25.recommended_product_association_id = t0.id LEFT JOIN templates t45 ON t45.product_association_id = t0.id LEFT JOIN meta_tags t55 ON t55.product_association_id = t0.id WHERE t0.slug = 'fbcef163b1b6e88.pdf' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.short_body AS short_body_3,
  t0.body AS body_4,
  t0.testimonials_custom AS testimonials_custom_5,
  t0.category_name AS category_name_6,
  t0.category_slug AS category_slug_7,
  t0.position AS position_8,
  t0.image_name AS image_name_9,
  t0.banner_name AS banner_name_10,
  t0.banner_link AS banner_link_11,
  t0.banner_html AS banner_html_12,
  t0.updated_at AS updated_at_13,
  t0.default_for_us AS default_for_us_14,
  t0.parent_id AS parent_id_15,
  t16.id AS id_17,
  t16.is_active AS is_active_18,
  t16.name AS name_19,
  t16.portal_settings_id AS portal_settings_id_20,
  t16.category_id AS category_id_21,
  t16.product_association_id AS product_association_id_22,
  t16.product_main_type_id AS product_main_type_id_23,
  t16.template_type_id AS template_type_id_24,
  t0.portal_settings_id AS portal_settings_id_25,
  t0.recommended_product_association_id AS recommended_product_association_id_26,
  t0.language_id AS language_id_27,
  t28.id AS id_29,
  t28.is_active AS is_active_30,
  t28.name AS name_31,
  t28.native AS native_32,
  t28.slug AS slug_33,
  t28.code AS code_34,
  t28.short AS short_35,
  t28.created_at AS created_at_36,
  t28.updated_at AS updated_at_37,
  t38.id AS id_39,
  t38.title AS title_40,
  t38.description AS description_41,
  t38.head_scripts AS head_scripts_42,
  t38.body_scripts AS body_scripts_43,
  t38.created_at AS created_at_44,
  t38.updated_at AS updated_at_45,
  t38.product_association_id AS product_association_id_46,
  t38.category_id AS category_id_47,
  t38.template_type_id AS template_type_id_48
FROM
  category t0
  LEFT JOIN templates t16 ON t16.category_id = t0.id
  LEFT JOIN language t28 ON t0.language_id = t28.id
  LEFT JOIN meta_tags t38 ON t38.category_id = t0.id
WHERE
  t0.category_slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.short_body AS short_body_3, t0.body AS body_4, t0.testimonials_custom AS testimonials_custom_5, t0.category_name AS category_name_6, t0.category_slug AS category_slug_7, t0.position AS position_8, t0.image_name AS image_name_9, t0.banner_name AS banner_name_10, t0.banner_link AS banner_link_11, t0.banner_html AS banner_html_12, t0.updated_at AS updated_at_13, t0.default_for_us AS default_for_us_14, t0.parent_id AS parent_id_15, t16.id AS id_17, t16.is_active AS is_active_18, t16.name AS name_19, t16.portal_settings_id AS portal_settings_id_20, t16.category_id AS category_id_21, t16.product_association_id AS product_association_id_22, t16.product_main_type_id AS product_main_type_id_23, t16.template_type_id AS template_type_id_24, t0.portal_settings_id AS portal_settings_id_25, t0.recommended_product_association_id AS recommended_product_association_id_26, t0.language_id AS language_id_27, t28.id AS id_29, t28.is_active AS is_active_30, t28.name AS name_31, t28.native AS native_32, t28.slug AS slug_33, t28.code AS code_34, t28.short AS short_35, t28.created_at AS created_at_36, t28.updated_at AS updated_at_37, t38.id AS id_39, t38.title AS title_40, t38.description AS description_41, t38.head_scripts AS head_scripts_42, t38.body_scripts AS body_scripts_43, t38.created_at AS created_at_44, t38.updated_at AS updated_at_45, t38.product_association_id AS product_association_id_46, t38.category_id AS category_id_47, t38.template_type_id AS template_type_id_48 FROM category t0 LEFT JOIN templates t16 ON t16.category_id = t0.id LEFT JOIN language t28 ON t0.language_id = t28.id LEFT JOIN meta_tags t38 ON t38.category_id = t0.id WHERE t0.category_slug = 'productCmsFiles' LIMIT 1;