0.86 ms (29.56%)
|
2 |
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.content AS content_3, p0_.image AS image_4, p0_.description AS description_5, p0_.parish AS parish_6, p0_.video AS video_7, p0_.vis AS vis_8, p0_.start_at AS start_at_9, p0_.highli AS highli_10 FROM posts p0_ WHERE p0_.start_at >= ? AND p0_.vis LIKE ? AND p0_.highli LIKE ? ORDER BY p0_.start_at ASC
Parameters: [
"2024-12-23 15:55:15"
1
"%0%"
]
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.content AS content_3, p0_.image AS image_4, p0_.description AS description_5, p0_.parish AS parish_6, p0_.video AS video_7, p0_.vis AS vis_8, p0_.start_at AS start_at_9, p0_.highli AS highli_10 FROM posts p0_ WHERE p0_.start_at >= '2024-12-23 15:55:15' AND p0_.vis LIKE 1 AND p0_.highli LIKE '%0%' ORDER BY p0_.start_at ASC;
|
0.45 ms (15.33%)
|
1 |
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, start_at_9 FROM (SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.content AS content_3, p0_.image AS image_4, p0_.description AS description_5, p0_.parish AS parish_6, p0_.video AS video_7, p0_.vis AS vis_8, p0_.start_at AS start_at_9, p0_.highli AS highli_10 FROM posts p0_ WHERE p0_.start_at >= ? AND p0_.vis LIKE ? AND p0_.highli LIKE ?) dctrn_result_inner ORDER BY start_at_9 ASC) dctrn_result LIMIT 7 OFFSET 49
Parameters: [
"2024-12-23 15:55:15"
1
"%0%"
]
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, start_at_9 FROM (SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.content AS content_3, p0_.image AS image_4, p0_.description AS description_5, p0_.parish AS parish_6, p0_.video AS video_7, p0_.vis AS vis_8, p0_.start_at AS start_at_9, p0_.highli AS highli_10 FROM posts p0_ WHERE p0_.start_at >= '2024-12-23 15:55:15' AND p0_.vis LIKE 1 AND p0_.highli LIKE '%0%') dctrn_result_inner ORDER BY start_at_9 ASC) dctrn_result LIMIT 7 OFFSET 49;
|
0.35 ms (12.11%)
|
1 |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.content AS content_3, p0_.image AS image_4, p0_.description AS description_5, p0_.parish AS parish_6, p0_.video AS video_7, p0_.vis AS vis_8, p0_.start_at AS start_at_9, p0_.highli AS highli_10 FROM posts p0_ WHERE p0_.start_at >= ? AND p0_.vis LIKE ? AND p0_.highli LIKE ? ORDER BY p0_.start_at ASC) dctrn_result) dctrn_table
Parameters: [
"2024-12-23 15:55:15"
1
"%0%"
]
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.content AS content_3, p0_.image AS image_4, p0_.description AS description_5, p0_.parish AS parish_6, p0_.video AS video_7, p0_.vis AS vis_8, p0_.start_at AS start_at_9, p0_.highli AS highli_10 FROM posts p0_ WHERE p0_.start_at >= '2024-12-23 15:55:15' AND p0_.vis LIKE 1 AND p0_.highli LIKE '%0%' ORDER BY p0_.start_at ASC) dctrn_result) dctrn_table;
|
0.31 ms (10.49%)
|
1 |
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.content AS content_3, p0_.image AS image_4, p0_.description AS description_5, p0_.parish AS parish_6, p0_.video AS video_7, p0_.vis AS vis_8, p0_.start_at AS start_at_9, p0_.highli AS highli_10 FROM posts p0_ WHERE p0_.start_at >= ? AND p0_.vis LIKE ? AND p0_.highli LIKE ? ORDER BY p0_.start_at ASC LIMIT 3 OFFSET 4
Parameters: [
"2024-12-23 15:55:15"
1
"%0%"
]
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.content AS content_3, p0_.image AS image_4, p0_.description AS description_5, p0_.parish AS parish_6, p0_.video AS video_7, p0_.vis AS vis_8, p0_.start_at AS start_at_9, p0_.highli AS highli_10 FROM posts p0_ WHERE p0_.start_at >= '2024-12-23 15:55:15' AND p0_.vis LIKE 1 AND p0_.highli LIKE '%0%' ORDER BY p0_.start_at ASC LIMIT 3 OFFSET 4;
|
0.23 ms (8.02%)
|
1 |
SELECT d0_.id AS id_0, d0_.date AS date_1, d0_.title AS title_2, d0_.description AS description_3, d0_.place AS place_4, d0_.file AS file_5, d0_.slug AS slug_6 FROM dates d0_ WHERE d0_.date >= ? ORDER BY d0_.date ASC LIMIT 5
Parameters: [
"2024-12-23 15:55:15"
]
SELECT d0_.id AS id_0, d0_.date AS date_1, d0_.title AS title_2, d0_.description AS description_3, d0_.place AS place_4, d0_.file AS file_5, d0_.slug AS slug_6 FROM dates d0_ WHERE d0_.date >= '2024-12-23 15:55:15' ORDER BY d0_.date ASC LIMIT 5;
|
0.19 ms (6.45%)
|
1 |
SELECT d0_.id AS id_0, d0_.date AS date_1, d0_.title AS title_2, d0_.description AS description_3, d0_.place AS place_4, d0_.file AS file_5, d0_.slug AS slug_6 FROM dates d0_ WHERE d0_.date >= ? ORDER BY d0_.date ASC LIMIT 1
Parameters: [
"2024-12-23 15:55:15"
]
SELECT d0_.id AS id_0, d0_.date AS date_1, d0_.title AS title_2, d0_.description AS description_3, d0_.place AS place_4, d0_.file AS file_5, d0_.slug AS slug_6 FROM dates d0_ WHERE d0_.date >= '2024-12-23 15:55:15' ORDER BY d0_.date ASC LIMIT 1;
|
0.12 ms (4.01%)
|
1 |
SELECT w0_.id AS id_0, w0_.sort AS sort_1, w0_.title AS title_2, w0_.content AS content_3, w0_.file AS file_4, w0_.slug AS slug_5 FROM wtw w0_ ORDER BY w0_.sort ASC
SELECT w0_.id AS id_0, w0_.sort AS sort_1, w0_.title AS title_2, w0_.content AS content_3, w0_.file AS file_4, w0_.slug AS slug_5 FROM wtw w0_ ORDER BY w0_.sort ASC;
|
0.11 ms (3.80%)
|
1 |
SELECT j0_.id AS id_0, j0_.title AS title_1, j0_.content AS content_2, j0_.image AS image_3, j0_.create_at AS create_at_4, j0_.updated_at AS updated_at_5, j0_.sectioon AS sectioon_6, j0_.pdf AS pdf_7 FROM jobs j0_ ORDER BY j0_.create_at DESC LIMIT 2
SELECT j0_.id AS id_0, j0_.title AS title_1, j0_.content AS content_2, j0_.image AS image_3, j0_.create_at AS create_at_4, j0_.updated_at AS updated_at_5, j0_.sectioon AS sectioon_6, j0_.pdf AS pdf_7 FROM jobs j0_ ORDER BY j0_.create_at DESC LIMIT 2;
|
0.08 ms (2.58%)
|
1 |
SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.description AS description_2, g0_.image AS image_3, g0_.video AS video_4, g0_.date AS date_5 FROM galary g0_ ORDER BY g0_.date DESC LIMIT 10
SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.description AS description_2, g0_.image AS image_3, g0_.video AS video_4, g0_.date AS date_5 FROM galary g0_ ORDER BY g0_.date DESC LIMIT 10;
|
0.07 ms (2.57%)
|
1 |
SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.content AS content_2, l0_.file AS file_3 FROM laden l0_ ORDER BY l0_.id DESC LIMIT 1
SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.content AS content_2, l0_.file AS file_3 FROM laden l0_ ORDER BY l0_.id DESC LIMIT 1;
|
0.07 ms (2.54%)
|
1 |
SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.description AS description_2, g0_.image AS image_3, g0_.video AS video_4, g0_.date AS date_5 FROM galary g0_ ORDER BY g0_.date DESC LIMIT 3
SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.description AS description_2, g0_.image AS image_3, g0_.video AS video_4, g0_.date AS date_5 FROM galary g0_ ORDER BY g0_.date DESC LIMIT 3;
|
0.07 ms (2.54%)
|
1 |
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.content AS content_3, p0_.image AS image_4, p0_.description AS description_5, p0_.parish AS parish_6, p0_.video AS video_7, p0_.vis AS vis_8, p0_.start_at AS start_at_9, p0_.highli AS highli_10 FROM posts p0_ WHERE p0_.vis LIKE ? AND p0_.highli LIKE ? LIMIT 2
Parameters: [
"%1%"
"%1%"
]
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.content AS content_3, p0_.image AS image_4, p0_.description AS description_5, p0_.parish AS parish_6, p0_.video AS video_7, p0_.vis AS vis_8, p0_.start_at AS start_at_9, p0_.highli AS highli_10 FROM posts p0_ WHERE p0_.vis LIKE '%1%' AND p0_.highli LIKE '%1%' LIMIT 2;
|