Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.is_published AS is_published_4,
  t0.sort AS sort_5,
  t0.brand_id AS brand_id_6,
  t0.brand_series_category_id AS brand_series_category_id_7,
  t0.intro_file_id AS intro_file_id_8,
  t0.description_file_id AS description_file_id_9
FROM
  brand_series_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_published AS is_published_4, t0.sort AS sort_5, t0.brand_id AS brand_id_6, t0.brand_series_category_id AS brand_series_category_id_7, t0.intro_file_id AS intro_file_id_8, t0.description_file_id AS description_file_id_9 FROM brand_series_category t0 WHERE t0.id = '1';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.is_published AS is_published_4,
  t0.created_at AS created_at_5,
  t0.sort AS sort_6,
  t0.intro AS intro_7,
  t0.description AS description_8,
  t0.title AS title_9,
  t0.description_product_all AS description_product_all_10,
  t0.brand_id AS brand_id_11,
  t0.file_id AS file_id_12,
  t0.brand_series_group_id AS brand_series_group_id_13,
  t0.intro_file_id AS intro_file_id_14,
  t0.brand_series_id AS brand_series_id_15
FROM
  brand_series t0
  INNER JOIN brand_series_brand_series_category ON t0.id = brand_series_brand_series_category.brand_series_id
WHERE
  brand_series_brand_series_category.brand_series_category_id = ?
ORDER BY
  t0.sort ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_published AS is_published_4, t0.created_at AS created_at_5, t0.sort AS sort_6, t0.intro AS intro_7, t0.description AS description_8, t0.title AS title_9, t0.description_product_all AS description_product_all_10, t0.brand_id AS brand_id_11, t0.file_id AS file_id_12, t0.brand_series_group_id AS brand_series_group_id_13, t0.intro_file_id AS intro_file_id_14, t0.brand_series_id AS brand_series_id_15 FROM brand_series t0 INNER JOIN brand_series_brand_series_category ON t0.id = brand_series_brand_series_category.brand_series_id WHERE brand_series_brand_series_category.brand_series_category_id = 1 ORDER BY t0.sort ASC;

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
  INNER JOIN brand_series_product_file ON t0.id = brand_series_product_file.file_id
WHERE
  brand_series_product_file.brand_series_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 INNER JOIN brand_series_product_file ON t0.id = brand_series_product_file.file_id WHERE brand_series_product_file.brand_series_id = 6;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.is_published AS is_published_4,
  t0.sort AS sort_5,
  t0.brand_id AS brand_id_6,
  t0.brand_series_category_id AS brand_series_category_id_7,
  t0.intro_file_id AS intro_file_id_8,
  t0.description_file_id AS description_file_id_9
FROM
  brand_series_category t0
  INNER JOIN brand_series_brand_series_category ON t0.id = brand_series_brand_series_category.brand_series_category_id
WHERE
  brand_series_brand_series_category.brand_series_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_published AS is_published_4, t0.sort AS sort_5, t0.brand_id AS brand_id_6, t0.brand_series_category_id AS brand_series_category_id_7, t0.intro_file_id AS intro_file_id_8, t0.description_file_id AS description_file_id_9 FROM brand_series_category t0 INNER JOIN brand_series_brand_series_category ON t0.id = brand_series_brand_series_category.brand_series_category_id WHERE brand_series_brand_series_category.brand_series_id = 6;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.is_published AS is_published_4,
  t0.created_at AS created_at_5,
  t0.sort AS sort_6,
  t0.intro AS intro_7,
  t0.description AS description_8,
  t0.title AS title_9,
  t0.description_product_all AS description_product_all_10,
  t0.brand_id AS brand_id_11,
  t0.file_id AS file_id_12,
  t0.brand_series_group_id AS brand_series_group_id_13,
  t0.intro_file_id AS intro_file_id_14,
  t0.brand_series_id AS brand_series_id_15
FROM
  brand_series t0
WHERE
  t0.brand_series_id = ?
ORDER BY
  t0.sort ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_published AS is_published_4, t0.created_at AS created_at_5, t0.sort AS sort_6, t0.intro AS intro_7, t0.description AS description_8, t0.title AS title_9, t0.description_product_all AS description_product_all_10, t0.brand_id AS brand_id_11, t0.file_id AS file_id_12, t0.brand_series_group_id AS brand_series_group_id_13, t0.intro_file_id AS intro_file_id_14, t0.brand_series_id AS brand_series_id_15 FROM brand_series t0 WHERE t0.brand_series_id = 6 ORDER BY t0.sort ASC;

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
  INNER JOIN brand_series_file ON t0.id = brand_series_file.file_id
WHERE
  brand_series_file.brand_series_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 INNER JOIN brand_series_file ON t0.id = brand_series_file.file_id WHERE brand_series_file.brand_series_id = 6;

SELECT
  t0.id AS id_1,
  t0.is_published AS is_published_2,
  t0.is_on_sale AS is_on_sale_3,
  t0.name AS name_4,
  t0.s1_code AS s1_code_5,
  t0.description AS description_6,
  t0.is_description_unique AS is_description_unique_7,
  t0.product_code AS product_code_8,
  t0.seo_name AS seo_name_9,
  t0.seo_description AS seo_description_10,
  t0.previous_id AS previous_id_11,
  t0.created_at AS created_at_12,
  t0.price_value AS price_value_13,
  t0.price_value_client AS price_value_client_14,
  t0.imported_at AS imported_at_15,
  t0.set_categories_at AS set_categories_at_16,
  t0.is_archives AS is_archives_17,
  t0.temp_price_value AS temp_price_value_18,
  t0.updated_at AS updated_at_19,
  t0.is_api_image AS is_api_image_20,
  t0.file_order AS file_order_21,
  t0.slug AS slug_22,
  t0.unit AS unit_23,
  t0.replaced_s1_code AS replaced_s1_code_24,
  t0.is_show_price AS is_show_price_25,
  t0.is_service AS is_service_26,
  t0.promo_description AS promo_description_27,
  t0.s1_slug AS s1_slug_28,
  t0.is_actual AS is_actual_29,
  t0.ratio AS ratio_30,
  t0.shop_count AS shop_count_31,
  t0.is_sale AS is_sale_32,
  t0.is_sale_admin AS is_sale_admin_33,
  t0.direct_code AS direct_code_34,
  t0.temp_product_code_duplicates AS temp_product_code_duplicates_35,
  t0.brand_id AS brand_id_36,
  t0.file_list_id AS file_list_id_37,
  t0.currency_id AS currency_id_38,
  t0.currency_client_id AS currency_client_id_39,
  t0.country_id AS country_id_40,
  t0.brand_series_id AS brand_series_id_41,
  t0.model_id AS model_id_42
FROM
  product t0
WHERE
  (
    t0.is_published = ?
    AND t0.brand_series_id = ?
  )

SELECT t0.id AS id_1, t0.is_published AS is_published_2, t0.is_on_sale AS is_on_sale_3, t0.name AS name_4, t0.s1_code AS s1_code_5, t0.description AS description_6, t0.is_description_unique AS is_description_unique_7, t0.product_code AS product_code_8, t0.seo_name AS seo_name_9, t0.seo_description AS seo_description_10, t0.previous_id AS previous_id_11, t0.created_at AS created_at_12, t0.price_value AS price_value_13, t0.price_value_client AS price_value_client_14, t0.imported_at AS imported_at_15, t0.set_categories_at AS set_categories_at_16, t0.is_archives AS is_archives_17, t0.temp_price_value AS temp_price_value_18, t0.updated_at AS updated_at_19, t0.is_api_image AS is_api_image_20, t0.file_order AS file_order_21, t0.slug AS slug_22, t0.unit AS unit_23, t0.replaced_s1_code AS replaced_s1_code_24, t0.is_show_price AS is_show_price_25, t0.is_service AS is_service_26, t0.promo_description AS promo_description_27, t0.s1_slug AS s1_slug_28, t0.is_actual AS is_actual_29, t0.ratio AS ratio_30, t0.shop_count AS shop_count_31, t0.is_sale AS is_sale_32, t0.is_sale_admin AS is_sale_admin_33, t0.direct_code AS direct_code_34, t0.temp_product_code_duplicates AS temp_product_code_duplicates_35, t0.brand_id AS brand_id_36, t0.file_list_id AS file_list_id_37, t0.currency_id AS currency_id_38, t0.currency_client_id AS currency_client_id_39, t0.country_id AS country_id_40, t0.brand_series_id AS brand_series_id_41, t0.model_id AS model_id_42 FROM product t0 WHERE (t0.is_published = 1 AND t0.brand_series_id = 6);