Symfony Profiler

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          d0_.id AS id_0,
          d0_.name AS name_1,
          d0_.species AS species_2,
          d0_.gender AS gender_3,
          d0_.personality AS personality_4,
          d0_.hobby AS hobby_5,
          d0_.birthday AS birthday_6,
          d0_.catchphrase AS catchphrase_7,
          d0_.style1 AS style1_8,
          d0_.style2 AS style2_9,
          d0_.color1 AS color1_10,
          d0_.color2 AS color2_11,
          d0_.filename AS filename_12,
          d0_.unique_entry_id AS unique_entry_id_13
        FROM
          data_villagers 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_.species AS species_2, d0_.gender AS gender_3, d0_.personality AS personality_4, d0_.hobby AS hobby_5, d0_.birthday AS birthday_6, d0_.catchphrase AS catchphrase_7, d0_.style1 AS style1_8, d0_.style2 AS style2_9, d0_.color1 AS color1_10, d0_.color2 AS color2_11, d0_.filename AS filename_12, d0_.unique_entry_id AS unique_entry_id_13 FROM data_villagers d0_) dctrn_result) dctrn_table;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.species AS species_3,
  t0.gender AS gender_4,
  t0.personality AS personality_5,
  t0.hobby AS hobby_6,
  t0.birthday AS birthday_7,
  t0.catchphrase AS catchphrase_8,
  t0.style1 AS style1_9,
  t0.style2 AS style2_10,
  t0.color1 AS color1_11,
  t0.color2 AS color2_12,
  t0.filename AS filename_13,
  t0.unique_entry_id AS unique_entry_id_14
FROM
  data_villagers t0
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.species AS species_3, t0.gender AS gender_4, t0.personality AS personality_5, t0.hobby AS hobby_6, t0.birthday AS birthday_7, t0.catchphrase AS catchphrase_8, t0.style1 AS style1_9, t0.style2 AS style2_10, t0.color1 AS color1_11, t0.color2 AS color2_12, t0.filename AS filename_13, t0.unique_entry_id AS unique_entry_id_14 FROM data_villagers t0 ORDER BY t0.name ASC;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      d0_.id AS id_0,
      d0_.name AS name_1,
      d0_.species AS species_2,
      d0_.gender AS gender_3,
      d0_.personality AS personality_4,
      d0_.hobby AS hobby_5,
      d0_.birthday AS birthday_6,
      d0_.catchphrase AS catchphrase_7,
      d0_.style1 AS style1_8,
      d0_.style2 AS style2_9,
      d0_.color1 AS color1_10,
      d0_.color2 AS color2_11,
      d0_.filename AS filename_12,
      d0_.unique_entry_id AS unique_entry_id_13
    FROM
      data_villagers d0_
  ) dctrn_result
LIMIT
  15

SELECT DISTINCT id_0 FROM (SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.species AS species_2, d0_.gender AS gender_3, d0_.personality AS personality_4, d0_.hobby AS hobby_5, d0_.birthday AS birthday_6, d0_.catchphrase AS catchphrase_7, d0_.style1 AS style1_8, d0_.style2 AS style2_9, d0_.color1 AS color1_10, d0_.color2 AS color2_11, d0_.filename AS filename_12, d0_.unique_entry_id AS unique_entry_id_13 FROM data_villagers d0_) dctrn_result LIMIT 15;

SELECT
  d0_.id AS id_0,
  d0_.name AS name_1,
  d0_.species AS species_2,
  d0_.gender AS gender_3,
  d0_.personality AS personality_4,
  d0_.hobby AS hobby_5,
  d0_.birthday AS birthday_6,
  d0_.catchphrase AS catchphrase_7,
  d0_.style1 AS style1_8,
  d0_.style2 AS style2_9,
  d0_.color1 AS color1_10,
  d0_.color2 AS color2_11,
  d0_.filename AS filename_12,
  d0_.unique_entry_id AS unique_entry_id_13
FROM
  data_villagers d0_
WHERE
  d0_.id IN (?)

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.species AS species_2, d0_.gender AS gender_3, d0_.personality AS personality_4, d0_.hobby AS hobby_5, d0_.birthday AS birthday_6, d0_.catchphrase AS catchphrase_7, d0_.style1 AS style1_8, d0_.style2 AS style2_9, d0_.color1 AS color1_10, d0_.color2 AS color2_11, d0_.filename AS filename_12, d0_.unique_entry_id AS unique_entry_id_13 FROM data_villagers d0_ WHERE d0_.id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15);