7.93 ms (42.41%)
|
9 |
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 = 1 AND t0.obituary_id = 12 LIMIT 1;
|
7.90 ms (42.25%)
|
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 = 1 AND t0.title_id = 4 LIMIT 1;
|
0.96 ms (5.14%)
|
1 |
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
Parameters: [
"%%"
"%%"
"%%"
]
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;
|