Symfony Profiler

SELECT
  ep.person_id AS pid,
  MIN(
    COALESCE(
      e.year, e.year_estimated, e.year_calculated
    )
  ) AS ymin,
  MAX(
    COALESCE(
      e.year, e.year_estimated, e.year_calculated
    )
  ) AS ymax
FROM
  event_person ep
  INNER JOIN event e ON e.id = ep.event_id
WHERE
  COALESCE(
    e.year, e.year_estimated, e.year_calculated
  ) IS NOT NULL
GROUP BY
  ep.person_id

SELECT ep.person_id AS pid,
                    MIN(COALESCE(e.year, e.year_estimated, e.year_calculated)) AS ymin,
                    MAX(COALESCE(e.year, e.year_estimated, e.year_calculated)) AS ymax
             FROM event_person ep
             INNER JOIN event e ON e.id = ep.event_id
             WHERE COALESCE(e.year, e.year_estimated, e.year_calculated) IS NOT NULL
             GROUP BY ep.person_id;

SELECT
  p0_.id AS id_0,
  p0_.approved AS approved_1,
  p0_.name AS name_2,
  p0_.born AS born_3,
  p0_.died AS died_4,
  p0_.born_estimated AS born_estimated_5,
  p0_.died_estimated AS died_estimated_6,
  p0_.gender AS gender_7,
  p0_.alternate_names AS alternate_names_8,
  p0_.url AS url_9,
  p0_.image AS image_10,
  p0_.is_abstract AS is_abstract_11,
  p0_.leaf_start AS leaf_start_12,
  p0_.leaf_out AS leaf_out_13,
  p0_.leaf_level AS leaf_level_14,
  p0_.born_calculated AS born_calculated_15,
  p0_.died_calculated AS died_calculated_16,
  p0_.born_at_father_age AS born_at_father_age_17,
  p0_.description AS description_18,
  p0_.created_at AS created_at_19,
  p0_.updated_at AS updated_at_20,
  p0_.tagged_for_delete_by_id AS tagged_for_delete_by_id_21,
  p0_.folk_id AS folk_id_22,
  p0_.owner_id AS owner_id_23,
  p0_.lived_at_time_of_person_id AS lived_at_time_of_person_id_24,
  p0_.update_of_id AS update_of_id_25
FROM
  person p0_
WHERE
  p0_.approved > 0
  AND (
    COALESCE(
      p0_.born, p0_.born_estimated, p0_.born_calculated
    ) IS NOT NULL
    OR p0_.lived_at_time_of_person_id IS NOT NULL
    OR EXISTS (
      SELECT
        1 AS sclr_26
      FROM
        event_person e1_
        INNER JOIN event e2_ ON e1_.event_id = e2_.id
      WHERE
        e1_.person_id = p0_.id
        AND COALESCE(
          e2_.year, e2_.year_estimated, e2_.year_calculated
        ) IS NOT NULL
    )
  )
ORDER BY
  p0_.born_calculated ASC,
  p0_.leaf_level ASC

SELECT p0_.id AS id_0, p0_.approved AS approved_1, p0_.name AS name_2, p0_.born AS born_3, p0_.died AS died_4, p0_.born_estimated AS born_estimated_5, p0_.died_estimated AS died_estimated_6, p0_.gender AS gender_7, p0_.alternate_names AS alternate_names_8, p0_.url AS url_9, p0_.image AS image_10, p0_.is_abstract AS is_abstract_11, p0_.leaf_start AS leaf_start_12, p0_.leaf_out AS leaf_out_13, p0_.leaf_level AS leaf_level_14, p0_.born_calculated AS born_calculated_15, p0_.died_calculated AS died_calculated_16, p0_.born_at_father_age AS born_at_father_age_17, p0_.description AS description_18, p0_.created_at AS created_at_19, p0_.updated_at AS updated_at_20, p0_.tagged_for_delete_by_id AS tagged_for_delete_by_id_21, p0_.folk_id AS folk_id_22, p0_.owner_id AS owner_id_23, p0_.lived_at_time_of_person_id AS lived_at_time_of_person_id_24, p0_.update_of_id AS update_of_id_25 FROM person p0_ WHERE p0_.approved > 0 AND (COALESCE(p0_.born, p0_.born_estimated, p0_.born_calculated) IS NOT NULL OR p0_.lived_at_time_of_person_id IS NOT NULL OR EXISTS (SELECT 1 AS sclr_26 FROM event_person e1_ INNER JOIN event e2_ ON e1_.event_id = e2_.id WHERE e1_.person_id = p0_.id AND COALESCE(e2_.year, e2_.year_estimated, e2_.year_calculated) IS NOT NULL)) ORDER BY p0_.born_calculated ASC, p0_.leaf_level ASC;

SELECT
  p0_.id AS id_0,
  p0_.approved AS approved_1,
  p0_.parent_id AS parent_id_2,
  p0_.child_id AS child_id_3,
  p0_.owner_id AS owner_id_4,
  p0_.tagged_for_delete_by_id AS tagged_for_delete_by_id_5
FROM
  person_link p0_
WHERE
  p0_.approved > 0

SELECT p0_.id AS id_0, p0_.approved AS approved_1, p0_.parent_id AS parent_id_2, p0_.child_id AS child_id_3, p0_.owner_id AS owner_id_4, p0_.tagged_for_delete_by_id AS tagged_for_delete_by_id_5 FROM person_link p0_ WHERE p0_.approved > 0;

SELECT
  t0.id AS id_1,
  t0.approved AS approved_2,
  t0.name AS name_3,
  t0.born AS born_4,
  t0.died AS died_5,
  t0.born_estimated AS born_estimated_6,
  t0.died_estimated AS died_estimated_7,
  t0.gender AS gender_8,
  t0.alternate_names AS alternate_names_9,
  t0.url AS url_10,
  t0.image AS image_11,
  t0.is_abstract AS is_abstract_12,
  t0.leaf_start AS leaf_start_13,
  t0.leaf_out AS leaf_out_14,
  t0.leaf_level AS leaf_level_15,
  t0.born_calculated AS born_calculated_16,
  t0.died_calculated AS died_calculated_17,
  t0.born_at_father_age AS born_at_father_age_18,
  t0.description AS description_19,
  t0.created_at AS created_at_20,
  t0.updated_at AS updated_at_21,
  t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_22,
  t0.folk_id AS folk_id_23,
  t0.owner_id AS owner_id_24,
  t0.lived_at_time_of_person_id AS lived_at_time_of_person_id_25,
  t0.update_of_id AS update_of_id_26
FROM
  person t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.approved AS approved_2, t0.name AS name_3, t0.born AS born_4, t0.died AS died_5, t0.born_estimated AS born_estimated_6, t0.died_estimated AS died_estimated_7, t0.gender AS gender_8, t0.alternate_names AS alternate_names_9, t0.url AS url_10, t0.image AS image_11, t0.is_abstract AS is_abstract_12, t0.leaf_start AS leaf_start_13, t0.leaf_out AS leaf_out_14, t0.leaf_level AS leaf_level_15, t0.born_calculated AS born_calculated_16, t0.died_calculated AS died_calculated_17, t0.born_at_father_age AS born_at_father_age_18, t0.description AS description_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_22, t0.folk_id AS folk_id_23, t0.owner_id AS owner_id_24, t0.lived_at_time_of_person_id AS lived_at_time_of_person_id_25, t0.update_of_id AS update_of_id_26 FROM person t0 WHERE t0.id = 4321;

SELECT
  t0.id AS id_1,
  t0.approved AS approved_2,
  t0.parent_id AS parent_id_3,
  t0.child_id AS child_id_4,
  t0.owner_id AS owner_id_5,
  t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6
FROM
  person_link t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.approved AS approved_2, t0.parent_id AS parent_id_3, t0.child_id AS child_id_4, t0.owner_id AS owner_id_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6 FROM person_link t0 WHERE t0.parent_id = 4338;

SELECT
  t0.id AS id_1,
  t0.approved AS approved_2,
  t0.parent_id AS parent_id_3,
  t0.child_id AS child_id_4,
  t0.owner_id AS owner_id_5,
  t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6
FROM
  person_link t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.approved AS approved_2, t0.parent_id AS parent_id_3, t0.child_id AS child_id_4, t0.owner_id AS owner_id_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6 FROM person_link t0 WHERE t0.parent_id = 4339;

SELECT
  t0.id AS id_1,
  t0.approved AS approved_2,
  t0.parent_id AS parent_id_3,
  t0.child_id AS child_id_4,
  t0.owner_id AS owner_id_5,
  t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6
FROM
  person_link t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.approved AS approved_2, t0.parent_id AS parent_id_3, t0.child_id AS child_id_4, t0.owner_id AS owner_id_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6 FROM person_link t0 WHERE t0.parent_id = 2684;

SELECT
  b0_.name AS name_0,
  b0_.from_year AS from_year_1,
  COALESCE(b0_.to_year, b0_.from_year + 200) AS sclr_2
FROM
  bible_books b0_
WHERE
  b0_.from_year IS NOT NULL
ORDER BY
  b0_.from_year ASC

SELECT b0_.name AS name_0, b0_.from_year AS from_year_1, COALESCE(b0_.to_year, b0_.from_year + 200) AS sclr_2 FROM bible_books b0_ WHERE b0_.from_year IS NOT NULL ORDER BY b0_.from_year ASC;

SELECT
  10000 + f0_.id AS sclr_0,
  f0_.name AS name_1,
  f0_.name AS name_2,
  'folk' AS sclr_3,
  0 AS sclr_4,
  COALESCE(
    p1_.born + 40, p1_.born_estimated + 40,
    p1_.born_calculated + 40, p2_.born + 40,
    -2000
  ) AS sclr_5,
  COALESCE(f0_.died, p1_.born + 1000, 0) AS sclr_6
FROM
  folk f0_
  LEFT JOIN person_folk p3_ ON f0_.id = p3_.folk_id
  LEFT JOIN person p1_ ON p1_.id = p3_.person_id
  LEFT JOIN folk f4_ ON f0_.father_folk_id = f4_.id
  LEFT JOIN person_folk p5_ ON f4_.id = p5_.folk_id
  LEFT JOIN person p2_ ON p2_.id = p5_.person_id
WHERE
  p1_.id IS NOT NULL
  OR f4_.id IS NOT NULL

SELECT 10000 + f0_.id AS sclr_0, f0_.name AS name_1, f0_.name AS name_2, 'folk' AS sclr_3, 0 AS sclr_4, COALESCE(p1_.born + 40, p1_.born_estimated + 40, p1_.born_calculated + 40, p2_.born + 40, -2000) AS sclr_5, COALESCE(f0_.died, p1_.born + 1000, 0) AS sclr_6 FROM folk f0_ LEFT JOIN person_folk p3_ ON f0_.id = p3_.folk_id LEFT JOIN person p1_ ON p1_.id = p3_.person_id LEFT JOIN folk f4_ ON f0_.father_folk_id = f4_.id LEFT JOIN person_folk p5_ ON f4_.id = p5_.folk_id LEFT JOIN person p2_ ON p2_.id = p5_.person_id WHERE p1_.id IS NOT NULL OR f4_.id IS NOT NULL;

SELECT
  p0_.id AS id_0,
  f1_.id + 10000 AS sclr_1
FROM
  folk f1_
  LEFT JOIN person_folk p2_ ON f1_.id = p2_.folk_id
  LEFT JOIN person p0_ ON p0_.id = p2_.person_id
WHERE
  p0_.id IS NOT NULL

SELECT p0_.id AS id_0, f1_.id + 10000 AS sclr_1 FROM folk f1_ LEFT JOIN person_folk p2_ ON f1_.id = p2_.folk_id LEFT JOIN person p0_ ON p0_.id = p2_.person_id WHERE p0_.id IS NOT NULL;

SELECT
  f0_.id + 10000 AS sclr_0,
  f1_.id + 10000 AS sclr_1
FROM
  folk f1_
  LEFT JOIN folk f0_ ON f1_.father_folk_id = f0_.id
WHERE
  f0_.id IS NOT NULL

SELECT f0_.id + 10000 AS sclr_0, f1_.id + 10000 AS sclr_1 FROM folk f1_ LEFT JOIN folk f0_ ON f1_.father_folk_id = f0_.id WHERE f0_.id IS NOT NULL;

SELECT
  f0_.id + 10000 AS sclr_0,
  p1_.id AS id_1
FROM
  folk f0_
  LEFT JOIN person p1_ ON (p1_.folk_id = f0_.id)
WHERE
  p1_.id IS NOT NULL

SELECT f0_.id + 10000 AS sclr_0, p1_.id AS id_1 FROM folk f0_ LEFT JOIN person p1_ ON (p1_.folk_id = f0_.id) WHERE p1_.id IS NOT NULL;