Symfony Profiler

SELECT
  COUNT(*)
FROM
  product_category t
WHERE
  t.category_id = ?

SELECT COUNT(*) FROM product_category t WHERE t.category_id = 1001;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.image_width AS image_width_3,
  t0.image_height AS image_height_4,
  t0.type AS type_5,
  t0.bytes AS bytes_6,
  t0.created_at AS created_at_7,
  t0.is_tested AS is_tested_8,
  t0.title AS title_9,
  t0.description AS description_10,
  t0.priority AS priority_11,
  t0.filename_original AS filename_original_12,
  t0.checked AS checked_13,
  t0.file_display_id AS file_display_id_14,
  t0.file_preview_id AS file_preview_id_15
FROM
  file t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.image_width AS image_width_3, t0.image_height AS image_height_4, t0.type AS type_5, t0.bytes AS bytes_6, t0.created_at AS created_at_7, t0.is_tested AS is_tested_8, t0.title AS title_9, t0.description AS description_10, t0.priority AS priority_11, t0.filename_original AS filename_original_12, t0.checked AS checked_13, t0.file_display_id AS file_display_id_14, t0.file_preview_id AS file_preview_id_15 FROM file t0 WHERE t0.id = 91088;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.sort AS sort_3,
  t0.slug AS slug_4,
  t0.s1_code AS s1_code_5,
  t0.is_published AS is_published_6,
  t0.intro AS intro_7,
  t0.description AS description_8,
  t0.previous_id AS previous_id_9,
  t0.is_root AS is_root_10,
  t0.is_catalogue AS is_catalogue_11,
  t0.title AS title_12,
  t0.name_in_navigation AS name_in_navigation_13,
  t0.temp_products_count AS temp_products_count_14,
  t0.temp_price_min AS temp_price_min_15,
  t0.temp_price_max AS temp_price_max_16,
  t0.is_drop_down AS is_drop_down_17,
  t0.path_redirect AS path_redirect_18,
  t0.is_actual AS is_actual_19,
  t0.is_on_main AS is_on_main_20,
  t0.temp_file_list_name AS temp_file_list_name_21,
  t0.category_id AS category_id_22,
  t0.file_intro_id AS file_intro_id_23,
  t0.file_description_id AS file_description_id_24,
  t0.link_id AS link_id_25,
  t0.file_list_id AS file_list_id_26,
  t0.file_icon_id AS file_icon_id_27,
  t0.file_actual_id AS file_actual_id_28,
  t0.file_catalogue_id AS file_catalogue_id_29,
  t0.file_application_id AS file_application_id_30
FROM
  category t0
WHERE
  t0.category_id IS NULL
  AND t0.is_published = ?
  AND t0.is_catalogue = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.sort AS sort_3, t0.slug AS slug_4, t0.s1_code AS s1_code_5, t0.is_published AS is_published_6, t0.intro AS intro_7, t0.description AS description_8, t0.previous_id AS previous_id_9, t0.is_root AS is_root_10, t0.is_catalogue AS is_catalogue_11, t0.title AS title_12, t0.name_in_navigation AS name_in_navigation_13, t0.temp_products_count AS temp_products_count_14, t0.temp_price_min AS temp_price_min_15, t0.temp_price_max AS temp_price_max_16, t0.is_drop_down AS is_drop_down_17, t0.path_redirect AS path_redirect_18, t0.is_actual AS is_actual_19, t0.is_on_main AS is_on_main_20, t0.temp_file_list_name AS temp_file_list_name_21, t0.category_id AS category_id_22, t0.file_intro_id AS file_intro_id_23, t0.file_description_id AS file_description_id_24, t0.link_id AS link_id_25, t0.file_list_id AS file_list_id_26, t0.file_icon_id AS file_icon_id_27, t0.file_actual_id AS file_actual_id_28, t0.file_catalogue_id AS file_catalogue_id_29, t0.file_application_id AS file_application_id_30 FROM category t0 WHERE t0.category_id IS NULL AND t0.is_published = 1 AND t0.is_catalogue = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.sort AS sort_3,
  t0.slug AS slug_4,
  t0.s1_code AS s1_code_5,
  t0.is_published AS is_published_6,
  t0.intro AS intro_7,
  t0.description AS description_8,
  t0.previous_id AS previous_id_9,
  t0.is_root AS is_root_10,
  t0.is_catalogue AS is_catalogue_11,
  t0.title AS title_12,
  t0.name_in_navigation AS name_in_navigation_13,
  t0.temp_products_count AS temp_products_count_14,
  t0.temp_price_min AS temp_price_min_15,
  t0.temp_price_max AS temp_price_max_16,
  t0.is_drop_down AS is_drop_down_17,
  t0.path_redirect AS path_redirect_18,
  t0.is_actual AS is_actual_19,
  t0.is_on_main AS is_on_main_20,
  t0.temp_file_list_name AS temp_file_list_name_21,
  t0.category_id AS category_id_22,
  t0.file_intro_id AS file_intro_id_23,
  t0.file_description_id AS file_description_id_24,
  t0.link_id AS link_id_25,
  t0.file_list_id AS file_list_id_26,
  t0.file_icon_id AS file_icon_id_27,
  t0.file_actual_id AS file_actual_id_28,
  t0.file_catalogue_id AS file_catalogue_id_29,
  t0.file_application_id AS file_application_id_30
FROM
  category t0
WHERE
  t0.category_id = ?
ORDER BY
  t0.sort ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.sort AS sort_3, t0.slug AS slug_4, t0.s1_code AS s1_code_5, t0.is_published AS is_published_6, t0.intro AS intro_7, t0.description AS description_8, t0.previous_id AS previous_id_9, t0.is_root AS is_root_10, t0.is_catalogue AS is_catalogue_11, t0.title AS title_12, t0.name_in_navigation AS name_in_navigation_13, t0.temp_products_count AS temp_products_count_14, t0.temp_price_min AS temp_price_min_15, t0.temp_price_max AS temp_price_max_16, t0.is_drop_down AS is_drop_down_17, t0.path_redirect AS path_redirect_18, t0.is_actual AS is_actual_19, t0.is_on_main AS is_on_main_20, t0.temp_file_list_name AS temp_file_list_name_21, t0.category_id AS category_id_22, t0.file_intro_id AS file_intro_id_23, t0.file_description_id AS file_description_id_24, t0.link_id AS link_id_25, t0.file_list_id AS file_list_id_26, t0.file_icon_id AS file_icon_id_27, t0.file_actual_id AS file_actual_id_28, t0.file_catalogue_id AS file_catalogue_id_29, t0.file_application_id AS file_application_id_30 FROM category t0 WHERE t0.category_id = 1001 ORDER BY t0.sort ASC;