0.93 ms (33.52%)
|
3 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.enabled AS enabled_4, t0.in_menu AS in_menu_5, t0.in_footer_menu AS in_footer_menu_6, t0.menu_name AS menu_name_7, t0.position AS position_8, t0.redirect AS redirect_9, t0.title AS title_10, t0.content AS content_11, t0.image AS image_12, t0.image2 AS image2_13, t0.keywords AS keywords_14, t0.meta_title AS meta_title_15, t0.meta_desc AS meta_desc_16, t0.lead_image AS lead_image_17, t0.lead AS lead_18, t0.created AS created_19, t0.updated AS updated_20, t0.parent_id AS parent_id_21, t0.template_id AS template_id_22 FROM page t0 WHERE t0.parent_id = ? ORDER BY t0.position DESC
SELECT
t0.id AS id_1,
t0.name AS name_2,
t0.url AS url_3,
t0.enabled AS enabled_4,
t0.in_menu AS in_menu_5,
t0.in_footer_menu AS in_footer_menu_6,
t0.menu_name AS menu_name_7,
t0.position AS position_8,
t0.redirect AS redirect_9,
t0.title AS title_10,
t0.content AS content_11,
t0.image AS image_12,
t0.image2 AS image2_13,
t0.keywords AS keywords_14,
t0.meta_title AS meta_title_15,
t0.meta_desc AS meta_desc_16,
t0.lead_image AS lead_image_17,
t0.lead AS lead_18,
t0.created AS created_19,
t0.updated AS updated_20,
t0.parent_id AS parent_id_21,
t0.template_id AS template_id_22
FROM
page t0
WHERE
t0.parent_id = ?
ORDER BY
t0.position DESC
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.enabled AS enabled_4, t0.in_menu AS in_menu_5, t0.in_footer_menu AS in_footer_menu_6, t0.menu_name AS menu_name_7, t0.position AS position_8, t0.redirect AS redirect_9, t0.title AS title_10, t0.content AS content_11, t0.image AS image_12, t0.image2 AS image2_13, t0.keywords AS keywords_14, t0.meta_title AS meta_title_15, t0.meta_desc AS meta_desc_16, t0.lead_image AS lead_image_17, t0.lead AS lead_18, t0.created AS created_19, t0.updated AS updated_20, t0.parent_id AS parent_id_21, t0.template_id AS template_id_22 FROM page t0 WHERE t0.parent_id = 4 ORDER BY t0.position DESC;
|
0.62 ms (22.30%)
|
1 |
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.url AS url_2, t0_.enabled AS enabled_3, t0_.promo AS promo_4, t0_.position AS position_5, t0_.start_date AS start_date_6, t0_.end_date AS end_date_7, t0_.lead AS lead_8, t0_.title AS title_9, t0_.content AS content_10, t0_.content2 AS content2_11, t0_.image AS image_12, t0_.schedule_name AS schedule_name_13, t0_.schedule AS schedule_14, t0_.schedule2_name AS schedule2_name_15, t0_.schedule2 AS schedule2_16, t0_.lead_image AS lead_image_17, t0_.nolink AS nolink_18, t0_.lead_color AS lead_color_19, t0_.keywords AS keywords_20, t0_.css AS css_21, t0_.redirect AS redirect_22, t0_.created AS created_23, t0_.updated AS updated_24, t0_.homepage AS homepage_25 FROM tile t0_ INNER JOIN tiles_categories t2_ ON t0_.id = t2_.tile_id INNER JOIN category c1_ ON c1_.id = t2_.category_id WHERE t0_.enabled = 1 AND t0_.start_date <= ? AND (t0_.end_date >= ? OR t0_.end_date IS NULL) AND c1_.slug = ? ORDER BY t0_.start_date DESC, t0_.position DESC LIMIT 9 OFFSET 325116
Parameters: [â–¼
"2025-06-17 08:49:35"
"2025-06-17 08:49:35"
"komunikaty"
]
SELECT
t0_.id AS id_0,
t0_.name AS name_1,
t0_.url AS url_2,
t0_.enabled AS enabled_3,
t0_.promo AS promo_4,
t0_.position AS position_5,
t0_.start_date AS start_date_6,
t0_.end_date AS end_date_7,
t0_.lead AS lead_8,
t0_.title AS title_9,
t0_.content AS content_10,
t0_.content2 AS content2_11,
t0_.image AS image_12,
t0_.schedule_name AS schedule_name_13,
t0_.schedule AS schedule_14,
t0_.schedule2_name AS schedule2_name_15,
t0_.schedule2 AS schedule2_16,
t0_.lead_image AS lead_image_17,
t0_.nolink AS nolink_18,
t0_.lead_color AS lead_color_19,
t0_.keywords AS keywords_20,
t0_.css AS css_21,
t0_.redirect AS redirect_22,
t0_.created AS created_23,
t0_.updated AS updated_24,
t0_.homepage AS homepage_25
FROM
tile t0_
INNER JOIN tiles_categories t2_ ON t0_.id = t2_.tile_id
INNER JOIN category c1_ ON c1_.id = t2_.category_id
WHERE
t0_.enabled = 1
AND t0_.start_date <= ?
AND (
t0_.end_date >= ?
OR t0_.end_date IS NULL
)
AND c1_.slug = ?
ORDER BY
t0_.start_date DESC,
t0_.position DESC
LIMIT
9
OFFSET
325116
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.url AS url_2, t0_.enabled AS enabled_3, t0_.promo AS promo_4, t0_.position AS position_5, t0_.start_date AS start_date_6, t0_.end_date AS end_date_7, t0_.lead AS lead_8, t0_.title AS title_9, t0_.content AS content_10, t0_.content2 AS content2_11, t0_.image AS image_12, t0_.schedule_name AS schedule_name_13, t0_.schedule AS schedule_14, t0_.schedule2_name AS schedule2_name_15, t0_.schedule2 AS schedule2_16, t0_.lead_image AS lead_image_17, t0_.nolink AS nolink_18, t0_.lead_color AS lead_color_19, t0_.keywords AS keywords_20, t0_.css AS css_21, t0_.redirect AS redirect_22, t0_.created AS created_23, t0_.updated AS updated_24, t0_.homepage AS homepage_25 FROM tile t0_ INNER JOIN tiles_categories t2_ ON t0_.id = t2_.tile_id INNER JOIN category c1_ ON c1_.id = t2_.category_id WHERE t0_.enabled = 1 AND t0_.start_date <= '2025-06-17 08:49:35' AND (t0_.end_date >= '2025-06-17 08:49:35' OR t0_.end_date IS NULL) AND c1_.slug = 'komunikaty' ORDER BY t0_.start_date DESC, t0_.position DESC LIMIT 9 OFFSET 325116;
|
0.31 ms (11.06%)
|
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.enabled AS enabled_4, t0.in_menu AS in_menu_5, t0.in_footer_menu AS in_footer_menu_6, t0.menu_name AS menu_name_7, t0.position AS position_8, t0.redirect AS redirect_9, t0.title AS title_10, t0.content AS content_11, t0.image AS image_12, t0.image2 AS image2_13, t0.keywords AS keywords_14, t0.meta_title AS meta_title_15, t0.meta_desc AS meta_desc_16, t0.lead_image AS lead_image_17, t0.lead AS lead_18, t0.created AS created_19, t0.updated AS updated_20, t0.parent_id AS parent_id_21, t0.template_id AS template_id_22 FROM page t0 WHERE t0.in_menu = ? AND t0.parent_id IS NULL AND t0.enabled = ? ORDER BY t0.position DESC
SELECT
t0.id AS id_1,
t0.name AS name_2,
t0.url AS url_3,
t0.enabled AS enabled_4,
t0.in_menu AS in_menu_5,
t0.in_footer_menu AS in_footer_menu_6,
t0.menu_name AS menu_name_7,
t0.position AS position_8,
t0.redirect AS redirect_9,
t0.title AS title_10,
t0.content AS content_11,
t0.image AS image_12,
t0.image2 AS image2_13,
t0.keywords AS keywords_14,
t0.meta_title AS meta_title_15,
t0.meta_desc AS meta_desc_16,
t0.lead_image AS lead_image_17,
t0.lead AS lead_18,
t0.created AS created_19,
t0.updated AS updated_20,
t0.parent_id AS parent_id_21,
t0.template_id AS template_id_22
FROM
page t0
WHERE
t0.in_menu = ?
AND t0.parent_id IS NULL
AND t0.enabled = ?
ORDER BY
t0.position DESC
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.enabled AS enabled_4, t0.in_menu AS in_menu_5, t0.in_footer_menu AS in_footer_menu_6, t0.menu_name AS menu_name_7, t0.position AS position_8, t0.redirect AS redirect_9, t0.title AS title_10, t0.content AS content_11, t0.image AS image_12, t0.image2 AS image2_13, t0.keywords AS keywords_14, t0.meta_title AS meta_title_15, t0.meta_desc AS meta_desc_16, t0.lead_image AS lead_image_17, t0.lead AS lead_18, t0.created AS created_19, t0.updated AS updated_20, t0.parent_id AS parent_id_21, t0.template_id AS template_id_22 FROM page t0 WHERE t0.in_menu = 1 AND t0.parent_id IS NULL AND t0.enabled = 1 ORDER BY t0.position DESC;
|