Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.id0 AS id0_3,
  t0.id1 AS id1_4,
  t0.code AS code_5,
  t0.internal_name AS internal_name_6,
  t0.price AS price_7,
  t0.diy_recipe0 AS diy_recipe0_8,
  t0.diy_recipe1 AS diy_recipe1_9,
  t0.id_item AS id_item_10,
  t0.en AS en_11,
  t0.es AS es_12,
  t0.de AS de_13,
  t0.fr AS fr_14,
  t0.it AS it_15,
  t0.ru AS ru_16,
  t0.nl AS nl_17
FROM
  acnh_items t0
WHERE
  t0.id0 = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.id0 AS id0_3, t0.id1 AS id1_4, t0.code AS code_5, t0.internal_name AS internal_name_6, t0.price AS price_7, t0.diy_recipe0 AS diy_recipe0_8, t0.diy_recipe1 AS diy_recipe1_9, t0.id_item AS id_item_10, t0.en AS en_11, t0.es AS es_12, t0.de AS de_13, t0.fr AS fr_14, t0.it AS it_15, t0.ru AS ru_16, t0.nl AS nl_17 FROM acnh_items t0 WHERE t0.id0 = 10074 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.variation AS variation_3,
  t0.diy AS diy_4,
  t0.buy AS buy_5,
  t0.sell AS sell_6,
  t0.color1 AS color1_7,
  t0.color2 AS color2_8,
  t0.size AS size_9,
  t0.source AS source_10,
  t0.source_notes AS source_notes_11,
  t0.seasonal_availability AS seasonal_availability_12,
  t0.version AS version_13,
  t0.style AS style_14,
  t0.label_themes AS label_themes_15,
  t0.type AS type_16,
  t0.catalog AS catalog_17,
  t0.filename AS filename_18,
  t0.internal_id AS internal_id_19,
  t0.unique_entry_id AS unique_entry_id_20,
  t0.category AS category_21,
  t0.table_id AS table_id_22
FROM
  data_clothing t0
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.variation AS variation_3, t0.diy AS diy_4, t0.buy AS buy_5, t0.sell AS sell_6, t0.color1 AS color1_7, t0.color2 AS color2_8, t0.size AS size_9, t0.source AS source_10, t0.source_notes AS source_notes_11, t0.seasonal_availability AS seasonal_availability_12, t0.version AS version_13, t0.style AS style_14, t0.label_themes AS label_themes_15, t0.type AS type_16, t0.catalog AS catalog_17, t0.filename AS filename_18, t0.internal_id AS internal_id_19, t0.unique_entry_id AS unique_entry_id_20, t0.category AS category_21, t0.table_id AS table_id_22 FROM data_clothing t0 ORDER BY t0.name ASC;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          d0_.id AS id_0,
          d0_.name AS name_1,
          d0_.variation AS variation_2,
          d0_.diy AS diy_3,
          d0_.buy AS buy_4,
          d0_.sell AS sell_5,
          d0_.color1 AS color1_6,
          d0_.color2 AS color2_7,
          d0_.size AS size_8,
          d0_.source AS source_9,
          d0_.source_notes AS source_notes_10,
          d0_.seasonal_availability AS seasonal_availability_11,
          d0_.version AS version_12,
          d0_.style AS style_13,
          d0_.label_themes AS label_themes_14,
          d0_.type AS type_15,
          d0_.catalog AS catalog_16,
          d0_.filename AS filename_17,
          d0_.internal_id AS internal_id_18,
          d0_.unique_entry_id AS unique_entry_id_19,
          d0_.category AS category_20,
          d0_.table_id AS table_id_21
        FROM
          data_clothing d0_
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.variation AS variation_2, d0_.diy AS diy_3, d0_.buy AS buy_4, d0_.sell AS sell_5, d0_.color1 AS color1_6, d0_.color2 AS color2_7, d0_.size AS size_8, d0_.source AS source_9, d0_.source_notes AS source_notes_10, d0_.seasonal_availability AS seasonal_availability_11, d0_.version AS version_12, d0_.style AS style_13, d0_.label_themes AS label_themes_14, d0_.type AS type_15, d0_.catalog AS catalog_16, d0_.filename AS filename_17, d0_.internal_id AS internal_id_18, d0_.unique_entry_id AS unique_entry_id_19, d0_.category AS category_20, d0_.table_id AS table_id_21 FROM data_clothing d0_) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      d0_.id AS id_0,
      d0_.name AS name_1,
      d0_.variation AS variation_2,
      d0_.diy AS diy_3,
      d0_.buy AS buy_4,
      d0_.sell AS sell_5,
      d0_.color1 AS color1_6,
      d0_.color2 AS color2_7,
      d0_.size AS size_8,
      d0_.source AS source_9,
      d0_.source_notes AS source_notes_10,
      d0_.seasonal_availability AS seasonal_availability_11,
      d0_.version AS version_12,
      d0_.style AS style_13,
      d0_.label_themes AS label_themes_14,
      d0_.type AS type_15,
      d0_.catalog AS catalog_16,
      d0_.filename AS filename_17,
      d0_.internal_id AS internal_id_18,
      d0_.unique_entry_id AS unique_entry_id_19,
      d0_.category AS category_20,
      d0_.table_id AS table_id_21
    FROM
      data_clothing d0_
  ) dctrn_result
LIMIT
  15 OFFSET 2745

SELECT DISTINCT id_0 FROM (SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.variation AS variation_2, d0_.diy AS diy_3, d0_.buy AS buy_4, d0_.sell AS sell_5, d0_.color1 AS color1_6, d0_.color2 AS color2_7, d0_.size AS size_8, d0_.source AS source_9, d0_.source_notes AS source_notes_10, d0_.seasonal_availability AS seasonal_availability_11, d0_.version AS version_12, d0_.style AS style_13, d0_.label_themes AS label_themes_14, d0_.type AS type_15, d0_.catalog AS catalog_16, d0_.filename AS filename_17, d0_.internal_id AS internal_id_18, d0_.unique_entry_id AS unique_entry_id_19, d0_.category AS category_20, d0_.table_id AS table_id_21 FROM data_clothing d0_) dctrn_result LIMIT 15 OFFSET 2745;

SELECT
  d0_.id AS id_0,
  d0_.name AS name_1,
  d0_.variation AS variation_2,
  d0_.diy AS diy_3,
  d0_.buy AS buy_4,
  d0_.sell AS sell_5,
  d0_.color1 AS color1_6,
  d0_.color2 AS color2_7,
  d0_.size AS size_8,
  d0_.source AS source_9,
  d0_.source_notes AS source_notes_10,
  d0_.seasonal_availability AS seasonal_availability_11,
  d0_.version AS version_12,
  d0_.style AS style_13,
  d0_.label_themes AS label_themes_14,
  d0_.type AS type_15,
  d0_.catalog AS catalog_16,
  d0_.filename AS filename_17,
  d0_.internal_id AS internal_id_18,
  d0_.unique_entry_id AS unique_entry_id_19,
  d0_.category AS category_20,
  d0_.table_id AS table_id_21
FROM
  data_clothing d0_
WHERE
  d0_.id IN (?)

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.variation AS variation_2, d0_.diy AS diy_3, d0_.buy AS buy_4, d0_.sell AS sell_5, d0_.color1 AS color1_6, d0_.color2 AS color2_7, d0_.size AS size_8, d0_.source AS source_9, d0_.source_notes AS source_notes_10, d0_.seasonal_availability AS seasonal_availability_11, d0_.version AS version_12, d0_.style AS style_13, d0_.label_themes AS label_themes_14, d0_.type AS type_15, d0_.catalog AS catalog_16, d0_.filename AS filename_17, d0_.internal_id AS internal_id_18, d0_.unique_entry_id AS unique_entry_id_19, d0_.category AS category_20, d0_.table_id AS table_id_21 FROM data_clothing d0_ WHERE d0_.id IN (2746, 2747, 2748, 2749, 2750, 2751, 2752, 2753, 2754, 2755, 2756, 2757, 2758, 2759, 2760);