Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.symbol AS symbol_3,
  t0.emoji AS emoji_4
FROM
  language t0
WHERE
  t0.symbol = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.symbol AS symbol_3, t0.emoji AS emoji_4 FROM language t0 WHERE t0.symbol = 'nl' LIMIT 1;

SELECT
  COUNT(DISTINCT o0_.id) AS sclr_0
FROM
  obituary o0_
  LEFT JOIN title t1_ ON o0_.title_id = t1_.id
  LEFT JOIN title_translation t2_ ON t1_.id = t2_.title_id
WHERE
  o0_.deleted = 0
  AND o0_.visible = 1
  AND (
    o0_.first_name LIKE ?
    OR o0_.last_name LIKE ?
    OR t2_.name LIKE ?
  )

SELECT COUNT(DISTINCT o0_.id) AS sclr_0 FROM obituary o0_ LEFT JOIN title t1_ ON o0_.title_id = t1_.id LEFT JOIN title_translation t2_ ON t1_.id = t2_.title_id WHERE o0_.deleted = 0 AND o0_.visible = 1 AND (o0_.first_name LIKE '%%' OR o0_.last_name LIKE '%%' OR t2_.name LIKE '%%');

SELECT
  DISTINCT o0_.id AS id_0,
  o0_.death_date AS death_date_1,
  o0_.created_at AS created_at_2,
  o0_.visible AS visible_3,
  o0_.deleted AS deleted_4,
  o0_.birth_date AS birth_date_5,
  o0_.deleted_at AS deleted_at_6,
  o0_.first_name AS first_name_7,
  o0_.last_name AS last_name_8,
  o0_.photo_name AS photo_name_9,
  o0_.created_by_id AS created_by_id_10,
  o0_.deleted_by_id AS deleted_by_id_11,
  o0_.title_id AS title_id_12
FROM
  obituary o0_
  LEFT JOIN title t1_ ON o0_.title_id = t1_.id
  LEFT JOIN title_translation t2_ ON t1_.id = t2_.title_id
WHERE
  o0_.deleted = 0
  AND o0_.visible = 1
  AND (
    o0_.first_name LIKE ?
    OR o0_.last_name LIKE ?
    OR t2_.name LIKE ?
  )
ORDER BY
  o0_.death_date DESC
LIMIT
  9

SELECT DISTINCT o0_.id AS id_0, o0_.death_date AS death_date_1, o0_.created_at AS created_at_2, o0_.visible AS visible_3, o0_.deleted AS deleted_4, o0_.birth_date AS birth_date_5, o0_.deleted_at AS deleted_at_6, o0_.first_name AS first_name_7, o0_.last_name AS last_name_8, o0_.photo_name AS photo_name_9, o0_.created_by_id AS created_by_id_10, o0_.deleted_by_id AS deleted_by_id_11, o0_.title_id AS title_id_12 FROM obituary o0_ LEFT JOIN title t1_ ON o0_.title_id = t1_.id LEFT JOIN title_translation t2_ ON t1_.id = t2_.title_id WHERE o0_.deleted = 0 AND o0_.visible = 1 AND (o0_.first_name LIKE '%%' OR o0_.last_name LIKE '%%' OR t2_.name LIKE '%%') ORDER BY o0_.death_date DESC LIMIT 9;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.title_id AS title_id_3,
  t0.language_id AS language_id_4
FROM
  title_translation t0
WHERE
  t0.language_id = ?
  AND t0.title_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.title_id AS title_id_3, t0.language_id AS language_id_4 FROM title_translation t0 WHERE t0.language_id = 2 AND t0.title_id = 4 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.pdf_file_name AS pdf_file_name_3,
  t0.obituary_id AS obituary_id_4,
  t0.language_id AS language_id_5
FROM
  obituary_translation t0
WHERE
  t0.language_id = ?
  AND t0.obituary_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.description AS description_2, t0.pdf_file_name AS pdf_file_name_3, t0.obituary_id AS obituary_id_4, t0.language_id AS language_id_5 FROM obituary_translation t0 WHERE t0.language_id = 2 AND t0.obituary_id = 12 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.title_id AS title_id_3,
  t0.language_id AS language_id_4
FROM
  title_translation t0
WHERE
  t0.language_id = ?
  AND t0.title_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.title_id AS title_id_3, t0.language_id AS language_id_4 FROM title_translation t0 WHERE t0.language_id = 2 AND t0.title_id = 11 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.pdf_file_name AS pdf_file_name_3,
  t0.obituary_id AS obituary_id_4,
  t0.language_id AS language_id_5
FROM
  obituary_translation t0
WHERE
  t0.language_id = ?
  AND t0.obituary_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.description AS description_2, t0.pdf_file_name AS pdf_file_name_3, t0.obituary_id AS obituary_id_4, t0.language_id AS language_id_5 FROM obituary_translation t0 WHERE t0.language_id = 2 AND t0.obituary_id = 3 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.title_id AS title_id_3,
  t0.language_id AS language_id_4
FROM
  title_translation t0
WHERE
  t0.language_id = ?
  AND t0.title_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.title_id AS title_id_3, t0.language_id AS language_id_4 FROM title_translation t0 WHERE t0.language_id = 2 AND t0.title_id = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.pdf_file_name AS pdf_file_name_3,
  t0.obituary_id AS obituary_id_4,
  t0.language_id AS language_id_5
FROM
  obituary_translation t0
WHERE
  t0.language_id = ?
  AND t0.obituary_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.description AS description_2, t0.pdf_file_name AS pdf_file_name_3, t0.obituary_id AS obituary_id_4, t0.language_id AS language_id_5 FROM obituary_translation t0 WHERE t0.language_id = 2 AND t0.obituary_id = 4 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.title_id AS title_id_3,
  t0.language_id AS language_id_4
FROM
  title_translation t0
WHERE
  t0.language_id = ?
  AND t0.title_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.title_id AS title_id_3, t0.language_id AS language_id_4 FROM title_translation t0 WHERE t0.language_id = 2 AND t0.title_id = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.pdf_file_name AS pdf_file_name_3,
  t0.obituary_id AS obituary_id_4,
  t0.language_id AS language_id_5
FROM
  obituary_translation t0
WHERE
  t0.language_id = ?
  AND t0.obituary_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.description AS description_2, t0.pdf_file_name AS pdf_file_name_3, t0.obituary_id AS obituary_id_4, t0.language_id AS language_id_5 FROM obituary_translation t0 WHERE t0.language_id = 2 AND t0.obituary_id = 5 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.title_id AS title_id_3,
  t0.language_id AS language_id_4
FROM
  title_translation t0
WHERE
  t0.language_id = ?
  AND t0.title_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.title_id AS title_id_3, t0.language_id AS language_id_4 FROM title_translation t0 WHERE t0.language_id = 2 AND t0.title_id = 12 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.pdf_file_name AS pdf_file_name_3,
  t0.obituary_id AS obituary_id_4,
  t0.language_id AS language_id_5
FROM
  obituary_translation t0
WHERE
  t0.language_id = ?
  AND t0.obituary_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.description AS description_2, t0.pdf_file_name AS pdf_file_name_3, t0.obituary_id AS obituary_id_4, t0.language_id AS language_id_5 FROM obituary_translation t0 WHERE t0.language_id = 2 AND t0.obituary_id = 2 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.title_id AS title_id_3,
  t0.language_id AS language_id_4
FROM
  title_translation t0
WHERE
  t0.language_id = ?
  AND t0.title_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.title_id AS title_id_3, t0.language_id AS language_id_4 FROM title_translation t0 WHERE t0.language_id = 2 AND t0.title_id = 10 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.pdf_file_name AS pdf_file_name_3,
  t0.obituary_id AS obituary_id_4,
  t0.language_id AS language_id_5
FROM
  obituary_translation t0
WHERE
  t0.language_id = ?
  AND t0.obituary_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.description AS description_2, t0.pdf_file_name AS pdf_file_name_3, t0.obituary_id AS obituary_id_4, t0.language_id AS language_id_5 FROM obituary_translation t0 WHERE t0.language_id = 2 AND t0.obituary_id = 6 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.title_id AS title_id_3,
  t0.language_id AS language_id_4
FROM
  title_translation t0
WHERE
  t0.language_id = ?
  AND t0.title_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.title_id AS title_id_3, t0.language_id AS language_id_4 FROM title_translation t0 WHERE t0.language_id = 2 AND t0.title_id = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.pdf_file_name AS pdf_file_name_3,
  t0.obituary_id AS obituary_id_4,
  t0.language_id AS language_id_5
FROM
  obituary_translation t0
WHERE
  t0.language_id = ?
  AND t0.obituary_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.description AS description_2, t0.pdf_file_name AS pdf_file_name_3, t0.obituary_id AS obituary_id_4, t0.language_id AS language_id_5 FROM obituary_translation t0 WHERE t0.language_id = 2 AND t0.obituary_id = 7 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.title_id AS title_id_3,
  t0.language_id AS language_id_4
FROM
  title_translation t0
WHERE
  t0.language_id = ?
  AND t0.title_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.title_id AS title_id_3, t0.language_id AS language_id_4 FROM title_translation t0 WHERE t0.language_id = 2 AND t0.title_id = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.pdf_file_name AS pdf_file_name_3,
  t0.obituary_id AS obituary_id_4,
  t0.language_id AS language_id_5
FROM
  obituary_translation t0
WHERE
  t0.language_id = ?
  AND t0.obituary_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.description AS description_2, t0.pdf_file_name AS pdf_file_name_3, t0.obituary_id AS obituary_id_4, t0.language_id AS language_id_5 FROM obituary_translation t0 WHERE t0.language_id = 2 AND t0.obituary_id = 8 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.title_id AS title_id_3,
  t0.language_id AS language_id_4
FROM
  title_translation t0
WHERE
  t0.language_id = ?
  AND t0.title_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.title_id AS title_id_3, t0.language_id AS language_id_4 FROM title_translation t0 WHERE t0.language_id = 2 AND t0.title_id = 4 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.pdf_file_name AS pdf_file_name_3,
  t0.obituary_id AS obituary_id_4,
  t0.language_id AS language_id_5
FROM
  obituary_translation t0
WHERE
  t0.language_id = ?
  AND t0.obituary_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.description AS description_2, t0.pdf_file_name AS pdf_file_name_3, t0.obituary_id AS obituary_id_4, t0.language_id AS language_id_5 FROM obituary_translation t0 WHERE t0.language_id = 2 AND t0.obituary_id = 9 LIMIT 1;