Symfony Profiler

SELECT 
  t0.alt AS alt_1, 
  t0.caption AS caption_2, 
  t0.collation_code AS collation_code_3, 
  t0.meta AS meta_4, 
  t0.id AS id_5, 
  t0.sort_num AS sort_num_6, 
  t0.status AS status_7, 
  t0.publish_at AS publish_at_8, 
  t0.expires_at AS expires_at_9, 
  t0.created_at AS created_at_10, 
  t0.updated_at AS updated_at_11, 
  t0.title AS title_12, 
  t0.item_id AS item_id_13, 
  t14.alias AS alias_15, 
  t14.path AS path_16, 
  t14.mime AS mime_17, 
  t14.file_size AS file_size_18, 
  t14.width AS width_19, 
  t14.height AS height_20, 
  t14.alt AS alt_21, 
  t14.caption AS caption_22, 
  t14.link_url AS link_url_23, 
  t14.content_data AS content_data_24, 
  t14.thumb_path AS thumb_path_25, 
  t14.hidden AS hidden_26, 
  t14.collation_code AS collation_code_27, 
  t14.is_locked AS is_locked_28, 
  t14.meta AS meta_29, 
  t14.cdn_domain AS cdn_domain_30, 
  t14.id AS id_31, 
  t14.sort_num AS sort_num_32, 
  t14.status AS status_33, 
  t14.publish_at AS publish_at_34, 
  t14.expires_at AS expires_at_35, 
  t14.created_at AS created_at_36, 
  t14.updated_at AS updated_at_37, 
  t14.title AS title_38, 
  t14.revision_parent AS revision_parent_39, 
  t14.revision_version AS revision_version_40, 
  t14.post_type AS post_type_41, 
  t14.access_token AS access_token_42, 
  t14.category AS category_43, 
  t14.facility_id AS facility_id_44, 
  t14.original_id AS original_id_45, 
  t14.created_by AS created_by_46, 
  t14.updated_by AS updated_by_47, 
  t14.latest_approval_request_id AS latest_approval_request_id_48, 
  t0.thumb_item_id AS thumb_item_id_49, 
  t50.alias AS alias_51, 
  t50.path AS path_52, 
  t50.mime AS mime_53, 
  t50.file_size AS file_size_54, 
  t50.width AS width_55, 
  t50.height AS height_56, 
  t50.alt AS alt_57, 
  t50.caption AS caption_58, 
  t50.link_url AS link_url_59, 
  t50.content_data AS content_data_60, 
  t50.thumb_path AS thumb_path_61, 
  t50.hidden AS hidden_62, 
  t50.collation_code AS collation_code_63, 
  t50.is_locked AS is_locked_64, 
  t50.meta AS meta_65, 
  t50.cdn_domain AS cdn_domain_66, 
  t50.id AS id_67, 
  t50.sort_num AS sort_num_68, 
  t50.status AS status_69, 
  t50.publish_at AS publish_at_70, 
  t50.expires_at AS expires_at_71, 
  t50.created_at AS created_at_72, 
  t50.updated_at AS updated_at_73, 
  t50.title AS title_74, 
  t50.revision_parent AS revision_parent_75, 
  t50.revision_version AS revision_version_76, 
  t50.post_type AS post_type_77, 
  t50.access_token AS access_token_78, 
  t50.category AS category_79, 
  t50.facility_id AS facility_id_80, 
  t50.original_id AS original_id_81, 
  t50.created_by AS created_by_82, 
  t50.updated_by AS updated_by_83, 
  t50.latest_approval_request_id AS latest_approval_request_id_84, 
  t0.group_id AS group_id_85, 
  t0.created_by AS created_by_86, 
  t87.username AS username_88, 
  t87.username_canonical AS username_canonical_89, 
  t87.enabled AS enabled_90, 
  t87.last_login AS last_login_91, 
  t87.confirmation_token AS confirmation_token_92, 
  t87.password_requested_at AS password_requested_at_93, 
  t87.roles AS roles_94, 
  t87.id AS id_95, 
  t87.display_name AS display_name_96, 
  t87.sort_num AS sort_num_97, 
  t87.email AS email_98, 
  t87.email_canonical AS email_canonical_99, 
  t87.salt AS salt_100, 
  t87.password AS password_101, 
  t87.group_id AS group_id_102, 
  t87.facility_id AS facility_id_103, 
  t0.updated_by AS updated_by_104, 
  t105.username AS username_106, 
  t105.username_canonical AS username_canonical_107, 
  t105.enabled AS enabled_108, 
  t105.last_login AS last_login_109, 
  t105.confirmation_token AS confirmation_token_110, 
  t105.password_requested_at AS password_requested_at_111, 
  t105.roles AS roles_112, 
  t105.id AS id_113, 
  t105.display_name AS display_name_114, 
  t105.sort_num AS sort_num_115, 
  t105.email AS email_116, 
  t105.email_canonical AS email_canonical_117, 
  t105.salt AS salt_118, 
  t105.password AS password_119, 
  t105.group_id AS group_id_120, 
  t105.facility_id AS facility_id_121 
FROM 
  cms_media_item_details t0 
  LEFT JOIN cms_media_items t14 ON t0.item_id = t14.id 
  AND (
    (
      t14.post_type IN ("master")
    ) 
    AND (
      t14.status = 1 
      AND (
        t14.publish_at IS NULL 
        OR t14.publish_at <= "2024-11-16 12:57:02"
      ) 
      AND (
        t14.expires_at IS NULL 
        OR t14.expires_at > "2024-11-16 12:57:02"
      )
    )
  ) 
  LEFT JOIN cms_media_items t50 ON t0.thumb_item_id = t50.id 
  AND (
    (
      t50.post_type IN ("master")
    ) 
    AND (
      t50.status = 1 
      AND (
        t50.publish_at IS NULL 
        OR t50.publish_at <= "2024-11-16 12:57:02"
      ) 
      AND (
        t50.expires_at IS NULL 
        OR t50.expires_at > "2024-11-16 12:57:02"
      )
    )
  ) 
  LEFT JOIN cms_user t87 ON t0.created_by = t87.id 
  LEFT JOIN cms_user t105 ON t0.updated_by = t105.id 
WHERE 
  t0.id IN (?) 
  AND (
    (
      t0.status = 1 
      AND (
        t0.publish_at IS NULL 
        OR t0.publish_at <= "2024-11-16 12:57:02"
      ) 
      AND (
        t0.expires_at IS NULL 
        OR t0.expires_at > "2024-11-16 12:57:02"
      )
    )
  )

SELECT t0.alt AS alt_1, t0.caption AS caption_2, t0.collation_code AS collation_code_3, t0.meta AS meta_4, t0.id AS id_5, t0.sort_num AS sort_num_6, t0.status AS status_7, t0.publish_at AS publish_at_8, t0.expires_at AS expires_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.title AS title_12, t0.item_id AS item_id_13, t14.alias AS alias_15, t14.path AS path_16, t14.mime AS mime_17, t14.file_size AS file_size_18, t14.width AS width_19, t14.height AS height_20, t14.alt AS alt_21, t14.caption AS caption_22, t14.link_url AS link_url_23, t14.content_data AS content_data_24, t14.thumb_path AS thumb_path_25, t14.hidden AS hidden_26, t14.collation_code AS collation_code_27, t14.is_locked AS is_locked_28, t14.meta AS meta_29, t14.cdn_domain AS cdn_domain_30, t14.id AS id_31, t14.sort_num AS sort_num_32, t14.status AS status_33, t14.publish_at AS publish_at_34, t14.expires_at AS expires_at_35, t14.created_at AS created_at_36, t14.updated_at AS updated_at_37, t14.title AS title_38, t14.revision_parent AS revision_parent_39, t14.revision_version AS revision_version_40, t14.post_type AS post_type_41, t14.access_token AS access_token_42, t14.category AS category_43, t14.facility_id AS facility_id_44, t14.original_id AS original_id_45, t14.created_by AS created_by_46, t14.updated_by AS updated_by_47, t14.latest_approval_request_id AS latest_approval_request_id_48, t0.thumb_item_id AS thumb_item_id_49, t50.alias AS alias_51, t50.path AS path_52, t50.mime AS mime_53, t50.file_size AS file_size_54, t50.width AS width_55, t50.height AS height_56, t50.alt AS alt_57, t50.caption AS caption_58, t50.link_url AS link_url_59, t50.content_data AS content_data_60, t50.thumb_path AS thumb_path_61, t50.hidden AS hidden_62, t50.collation_code AS collation_code_63, t50.is_locked AS is_locked_64, t50.meta AS meta_65, t50.cdn_domain AS cdn_domain_66, t50.id AS id_67, t50.sort_num AS sort_num_68, t50.status AS status_69, t50.publish_at AS publish_at_70, t50.expires_at AS expires_at_71, t50.created_at AS created_at_72, t50.updated_at AS updated_at_73, t50.title AS title_74, t50.revision_parent AS revision_parent_75, t50.revision_version AS revision_version_76, t50.post_type AS post_type_77, t50.access_token AS access_token_78, t50.category AS category_79, t50.facility_id AS facility_id_80, t50.original_id AS original_id_81, t50.created_by AS created_by_82, t50.updated_by AS updated_by_83, t50.latest_approval_request_id AS latest_approval_request_id_84, t0.group_id AS group_id_85, t0.created_by AS created_by_86, t87.username AS username_88, t87.username_canonical AS username_canonical_89, t87.enabled AS enabled_90, t87.last_login AS last_login_91, t87.confirmation_token AS confirmation_token_92, t87.password_requested_at AS password_requested_at_93, t87.roles AS roles_94, t87.id AS id_95, t87.display_name AS display_name_96, t87.sort_num AS sort_num_97, t87.email AS email_98, t87.email_canonical AS email_canonical_99, t87.salt AS salt_100, t87.password AS password_101, t87.group_id AS group_id_102, t87.facility_id AS facility_id_103, t0.updated_by AS updated_by_104, t105.username AS username_106, t105.username_canonical AS username_canonical_107, t105.enabled AS enabled_108, t105.last_login AS last_login_109, t105.confirmation_token AS confirmation_token_110, t105.password_requested_at AS password_requested_at_111, t105.roles AS roles_112, t105.id AS id_113, t105.display_name AS display_name_114, t105.sort_num AS sort_num_115, t105.email AS email_116, t105.email_canonical AS email_canonical_117, t105.salt AS salt_118, t105.password AS password_119, t105.group_id AS group_id_120, t105.facility_id AS facility_id_121 FROM cms_media_item_details t0 LEFT JOIN cms_media_items t14 ON t0.item_id = t14.id AND ((t14.post_type IN ("master")) AND (t14.status = 1 AND (t14.publish_at IS NULL OR t14.publish_at <= "2024-11-16 12405, 406, 409, 410, 413, 414:02") AND (t14.expires_at IS NULL OR t14.expires_at > "2024-11-16 12:57:02"))) LEFT JOIN cms_media_items t50 ON t0.thumb_item_id = t50.id AND ((t50.post_type IN ("master")) AND (t50.status = 1 AND (t50.publish_at IS NULL OR t50.publish_at <= "2024-11-16 12:57:02") AND (t50.expires_at IS NULL OR t50.expires_at > "2024-11-16 12:57:02"))) LEFT JOIN cms_user t87 ON t0.created_by = t87.id LEFT JOIN cms_user t105 ON t0.updated_by = t105.id WHERE t0.id IN (?) AND ((t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2024-11-16 12:57:02") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-16 12:57:02")));

SELECT 
  c0_.post_id AS post_id_0, 
  c0_.recommended AS recommended_1, 
  c0_.important AS important_2, 
  c0_.detail_type AS detail_type_3, 
  c0_.link_url AS link_url_4, 
  c0_.meta_title AS meta_title_5, 
  c0_.meta_keywords AS meta_keywords_6, 
  c0_.meta_description AS meta_description_7, 
  c0_.meta_h1 AS meta_h1_8, 
  c0_.custom_html AS custom_html_9, 
  c0_.is_imported AS is_imported_10, 
  c0_.period AS period_11, 
  c0_.list_text AS list_text_12, 
  c0_.public_date AS public_date_13, 
  c0_.customblock AS customblock_14, 
  c0_.id AS id_15, 
  c0_.sort_num AS sort_num_16, 
  c0_.status AS status_17, 
  c0_.publish_at AS publish_at_18, 
  c0_.expires_at AS expires_at_19, 
  c0_.created_at AS created_at_20, 
  c0_.updated_at AS updated_at_21, 
  c0_.title AS title_22, 
  c0_.language_parent AS language_parent_23, 
  c0_.language_alias AS language_alias_24, 
  c0_.language_active AS language_active_25, 
  c0_.revision_parent AS revision_parent_26, 
  c0_.revision_version AS revision_version_27, 
  c0_.post_type AS post_type_28, 
  c0_.access_token AS access_token_29, 
  c0_.common_thumbnail AS common_thumbnail_30, 
  c0_.thumbnail AS thumbnail_31, 
  c0_.facility_id AS facility_id_32, 
  c0_.created_by AS created_by_33, 
  c0_.updated_by AS updated_by_34, 
  c0_.language_id AS language_id_35, 
  c0_.latest_approval_request_id AS latest_approval_request_id_36 
FROM 
  cms_mod_topics_posts c0_ 
  INNER JOIN cms_mod_topics_post_category c2_ ON c0_.id = c2_.item_id 
  INNER JOIN cms_mod_topics_categories c1_ ON c1_.id = c2_.category_id 
  AND (
    c1_.status = 1 
    AND (
      c1_.publish_at IS NULL 
      OR c1_.publish_at <= "2024-11-16 12:57:02"
    ) 
    AND (
      c1_.expires_at IS NULL 
      OR c1_.expires_at > "2024-11-16 12:57:02"
    )
  ) 
WHERE 
  (c0_.important = 1) 
  AND (
    c0_.post_type IN ("master")
  ) 
  AND (
    c0_.status = 1 
    AND (
      c0_.publish_at IS NULL 
      OR c0_.publish_at <= "2024-11-16 12:57:02"
    ) 
    AND (
      c0_.expires_at IS NULL 
      OR c0_.expires_at > "2024-11-16 12:57:02"
    ) 
    AND (
      c0_.public_date IS NULL 
      OR c0_.public_date <= "2024-11-16"
    )
  ) 
ORDER BY 
  c0_.public_date DESC 
LIMIT 
  1

SELECT c0_.post_id AS post_id_0, c0_.recommended AS recommended_1, c0_.important AS important_2, c0_.detail_type AS detail_type_3, c0_.link_url AS link_url_4, c0_.meta_title AS meta_title_5, c0_.meta_keywords AS meta_keywords_6, c0_.meta_description AS meta_description_7, c0_.meta_h1 AS meta_h1_8, c0_.custom_html AS custom_html_9, c0_.is_imported AS is_imported_10, c0_.period AS period_11, c0_.list_text AS list_text_12, c0_.public_date AS public_date_13, c0_.customblock AS customblock_14, c0_.id AS id_15, c0_.sort_num AS sort_num_16, c0_.status AS status_17, c0_.publish_at AS publish_at_18, c0_.expires_at AS expires_at_19, c0_.created_at AS created_at_20, c0_.updated_at AS updated_at_21, c0_.title AS title_22, c0_.language_parent AS language_parent_23, c0_.language_alias AS language_alias_24, c0_.language_active AS language_active_25, c0_.revision_parent AS revision_parent_26, c0_.revision_version AS revision_version_27, c0_.post_type AS post_type_28, c0_.access_token AS access_token_29, c0_.common_thumbnail AS common_thumbnail_30, c0_.thumbnail AS thumbnail_31, c0_.facility_id AS facility_id_32, c0_.created_by AS created_by_33, c0_.updated_by AS updated_by_34, c0_.language_id AS language_id_35, c0_.latest_approval_request_id AS latest_approval_request_id_36 FROM cms_mod_topics_posts c0_ INNER JOIN cms_mod_topics_post_category c2_ ON c0_.id = c2_.item_id INNER JOIN cms_mod_topics_categories c1_ ON c1_.id = c2_.category_id AND (c1_.status = 1 AND (c1_.publish_at IS NULL OR c1_.publish_at <= "2024-11-16 12:57:02") AND (c1_.expires_at IS NULL OR c1_.expires_at > "2024-11-16 12:57:02")) WHERE (c0_.important = 1) AND (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2024-11-16 12:57:02") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-16 12:57:02") AND (c0_.public_date IS NULL OR c0_.public_date <= "2024-11-16")) ORDER BY c0_.public_date DESC LIMIT 1;

SELECT 
  c0_.title_for_list AS title_for_list_0, 
  c0_.alias AS alias_1, 
  c0_.show_in_list AS show_in_list_2, 
  c0_.public_date AS public_date_3, 
  c0_.customblock AS customblock_4, 
  c0_.id AS id_5, 
  c0_.sort_num AS sort_num_6, 
  c0_.status AS status_7, 
  c0_.publish_at AS publish_at_8, 
  c0_.expires_at AS expires_at_9, 
  c0_.created_at AS created_at_10, 
  c0_.updated_at AS updated_at_11, 
  c0_.title AS title_12, 
  c0_.language_parent AS language_parent_13, 
  c0_.language_alias AS language_alias_14, 
  c0_.language_active AS language_active_15, 
  c0_.revision_parent AS revision_parent_16, 
  c0_.revision_version AS revision_version_17, 
  c0_.post_type AS post_type_18, 
  c0_.access_token AS access_token_19, 
  c0_.image_pc AS image_pc_20, 
  c0_.image_sp AS image_sp_21, 
  c0_.thumbnail AS thumbnail_22, 
  c0_.facility_id AS facility_id_23, 
  c0_.created_by AS created_by_24, 
  c0_.updated_by AS updated_by_25, 
  c0_.language_id AS language_id_26, 
  c0_.latest_approval_request_id AS latest_approval_request_id_27 
FROM 
  cms_mod_restaurant_genres c0_ 
WHERE 
  (
    c0_.post_type IN ("master")
  ) 
  AND (
    c0_.status = 1 
    AND (
      c0_.publish_at IS NULL 
      OR c0_.publish_at <= "2024-11-16 12:57:02"
    ) 
    AND (
      c0_.expires_at IS NULL 
      OR c0_.expires_at > "2024-11-16 12:57:02"
    ) 
    AND (
      c0_.public_date IS NULL 
      OR c0_.public_date <= "2024-11-16"
    )
  ) 
ORDER BY 
  c0_.sort_num ASC, 
  c0_.id ASC

SELECT c0_.title_for_list AS title_for_list_0, c0_.alias AS alias_1, c0_.show_in_list AS show_in_list_2, c0_.public_date AS public_date_3, c0_.customblock AS customblock_4, c0_.id AS id_5, c0_.sort_num AS sort_num_6, c0_.status AS status_7, c0_.publish_at AS publish_at_8, c0_.expires_at AS expires_at_9, c0_.created_at AS created_at_10, c0_.updated_at AS updated_at_11, c0_.title AS title_12, c0_.language_parent AS language_parent_13, c0_.language_alias AS language_alias_14, c0_.language_active AS language_active_15, c0_.revision_parent AS revision_parent_16, c0_.revision_version AS revision_version_17, c0_.post_type AS post_type_18, c0_.access_token AS access_token_19, c0_.image_pc AS image_pc_20, c0_.image_sp AS image_sp_21, c0_.thumbnail AS thumbnail_22, c0_.facility_id AS facility_id_23, c0_.created_by AS created_by_24, c0_.updated_by AS updated_by_25, c0_.language_id AS language_id_26, c0_.latest_approval_request_id AS latest_approval_request_id_27 FROM cms_mod_restaurant_genres c0_ WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2024-11-16 12:57:02") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-16 12:57:02") AND (c0_.public_date IS NULL OR c0_.public_date <= "2024-11-16")) ORDER BY c0_.sort_num ASC, c0_.id ASC;

SELECT 
  c0_.post_id AS post_id_0, 
  c0_.recommended AS recommended_1, 
  c0_.important AS important_2, 
  c0_.detail_type AS detail_type_3, 
  c0_.link_url AS link_url_4, 
  c0_.meta_title AS meta_title_5, 
  c0_.meta_keywords AS meta_keywords_6, 
  c0_.meta_description AS meta_description_7, 
  c0_.meta_h1 AS meta_h1_8, 
  c0_.custom_html AS custom_html_9, 
  c0_.is_imported AS is_imported_10, 
  c0_.period AS period_11, 
  c0_.list_text AS list_text_12, 
  c0_.public_date AS public_date_13, 
  c0_.customblock AS customblock_14, 
  c0_.id AS id_15, 
  c0_.sort_num AS sort_num_16, 
  c0_.status AS status_17, 
  c0_.publish_at AS publish_at_18, 
  c0_.expires_at AS expires_at_19, 
  c0_.created_at AS created_at_20, 
  c0_.updated_at AS updated_at_21, 
  c0_.title AS title_22, 
  c0_.language_parent AS language_parent_23, 
  c0_.language_alias AS language_alias_24, 
  c0_.language_active AS language_active_25, 
  c0_.revision_parent AS revision_parent_26, 
  c0_.revision_version AS revision_version_27, 
  c0_.post_type AS post_type_28, 
  c0_.access_token AS access_token_29, 
  c0_.common_thumbnail AS common_thumbnail_30, 
  c0_.thumbnail AS thumbnail_31, 
  c0_.facility_id AS facility_id_32, 
  c0_.created_by AS created_by_33, 
  c0_.updated_by AS updated_by_34, 
  c0_.language_id AS language_id_35, 
  c0_.latest_approval_request_id AS latest_approval_request_id_36 
FROM 
  cms_mod_topics_posts c0_ 
  INNER JOIN cms_mod_topics_post_category c2_ ON c0_.id = c2_.item_id 
  INNER JOIN cms_mod_topics_categories c1_ ON c1_.id = c2_.category_id 
  AND (
    c1_.status = 1 
    AND (
      c1_.publish_at IS NULL 
      OR c1_.publish_at <= "2024-11-16 12:57:02"
    ) 
    AND (
      c1_.expires_at IS NULL 
      OR c1_.expires_at > "2024-11-16 12:57:02"
    )
  ) 
WHERE 
  (
    c0_.post_type IN ("master")
  ) 
  AND (
    c0_.status = 1 
    AND (
      c0_.publish_at IS NULL 
      OR c0_.publish_at <= "2024-11-16 12:57:02"
    ) 
    AND (
      c0_.expires_at IS NULL 
      OR c0_.expires_at > "2024-11-16 12:57:02"
    ) 
    AND (
      c0_.public_date IS NULL 
      OR c0_.public_date <= "2024-11-16"
    )
  ) 
ORDER BY 
  c0_.public_date DESC 
LIMIT 
  5

SELECT c0_.post_id AS post_id_0, c0_.recommended AS recommended_1, c0_.important AS important_2, c0_.detail_type AS detail_type_3, c0_.link_url AS link_url_4, c0_.meta_title AS meta_title_5, c0_.meta_keywords AS meta_keywords_6, c0_.meta_description AS meta_description_7, c0_.meta_h1 AS meta_h1_8, c0_.custom_html AS custom_html_9, c0_.is_imported AS is_imported_10, c0_.period AS period_11, c0_.list_text AS list_text_12, c0_.public_date AS public_date_13, c0_.customblock AS customblock_14, c0_.id AS id_15, c0_.sort_num AS sort_num_16, c0_.status AS status_17, c0_.publish_at AS publish_at_18, c0_.expires_at AS expires_at_19, c0_.created_at AS created_at_20, c0_.updated_at AS updated_at_21, c0_.title AS title_22, c0_.language_parent AS language_parent_23, c0_.language_alias AS language_alias_24, c0_.language_active AS language_active_25, c0_.revision_parent AS revision_parent_26, c0_.revision_version AS revision_version_27, c0_.post_type AS post_type_28, c0_.access_token AS access_token_29, c0_.common_thumbnail AS common_thumbnail_30, c0_.thumbnail AS thumbnail_31, c0_.facility_id AS facility_id_32, c0_.created_by AS created_by_33, c0_.updated_by AS updated_by_34, c0_.language_id AS language_id_35, c0_.latest_approval_request_id AS latest_approval_request_id_36 FROM cms_mod_topics_posts c0_ INNER JOIN cms_mod_topics_post_category c2_ ON c0_.id = c2_.item_id INNER JOIN cms_mod_topics_categories c1_ ON c1_.id = c2_.category_id AND (c1_.status = 1 AND (c1_.publish_at IS NULL OR c1_.publish_at <= "2024-11-16 12:57:02") AND (c1_.expires_at IS NULL OR c1_.expires_at > "2024-11-16 12:57:02")) WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2024-11-16 12:57:02") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-16 12:57:02") AND (c0_.public_date IS NULL OR c0_.public_date <= "2024-11-16")) ORDER BY c0_.public_date DESC LIMIT 5;

SELECT 
  t0.code AS code_1, 
  t0.title AS title_2, 
  t0.intro_text AS intro_text_3, 
  t0.zip AS zip_4, 
  t0.address AS address_5, 
  t0.building AS building_6, 
  t0.google_maps_url AS google_maps_url_7, 
  t0.phone AS phone_8, 
  t0.website AS website_9, 
  t0.opening_hours AS opening_hours_10, 
  t0.holiday AS holiday_11, 
  t0.access AS access_12, 
  t0.access_car AS access_car_13, 
  t0.access_train AS access_train_14, 
  t0.id AS id_15, 
  t0.sort_num AS sort_num_16, 
  t0.status AS status_17, 
  t0.publish_at AS publish_at_18, 
  t0.expires_at AS expires_at_19, 
  t0.created_at AS created_at_20, 
  t0.updated_at AS updated_at_21, 
  t0.area_id AS area_id_22, 
  t0.prefecture_id AS prefecture_id_23, 
  t0.logo_image AS logo_image_24, 
  t0.main_image AS main_image_25, 
  t0.created_by AS created_by_26, 
  t27.username AS username_28, 
  t27.username_canonical AS username_canonical_29, 
  t27.enabled AS enabled_30, 
  t27.last_login AS last_login_31, 
  t27.confirmation_token AS confirmation_token_32, 
  t27.password_requested_at AS password_requested_at_33, 
  t27.roles AS roles_34, 
  t27.id AS id_35, 
  t27.display_name AS display_name_36, 
  t27.sort_num AS sort_num_37, 
  t27.email AS email_38, 
  t27.email_canonical AS email_canonical_39, 
  t27.salt AS salt_40, 
  t27.password AS password_41, 
  t27.group_id AS group_id_42, 
  t27.facility_id AS facility_id_43, 
  t0.updated_by AS updated_by_44, 
  t45.username AS username_46, 
  t45.username_canonical AS username_canonical_47, 
  t45.enabled AS enabled_48, 
  t45.last_login AS last_login_49, 
  t45.confirmation_token AS confirmation_token_50, 
  t45.password_requested_at AS password_requested_at_51, 
  t45.roles AS roles_52, 
  t45.id AS id_53, 
  t45.display_name AS display_name_54, 
  t45.sort_num AS sort_num_55, 
  t45.email AS email_56, 
  t45.email_canonical AS email_canonical_57, 
  t45.salt AS salt_58, 
  t45.password AS password_59, 
  t45.group_id AS group_id_60, 
  t45.facility_id AS facility_id_61 
FROM 
  cms_facility t0 
  LEFT JOIN cms_user t27 ON t0.created_by = t27.id 
  LEFT JOIN cms_user t45 ON t0.updated_by = t45.id 
WHERE 
  t0.id IN (?) 
  AND (
    (
      t0.status = 1 
      AND (
        t0.publish_at IS NULL 
        OR t0.publish_at <= "2024-11-16 12:57:02"
      ) 
      AND (
        t0.expires_at IS NULL 
        OR t0.expires_at > "2024-11-16 12:57:02"
      )
    )
  )

SELECT t0.code AS code_1, t0.title AS title_2, t0.intro_text AS intro_text_3, t0.zip AS zip_4, t0.address AS address_5, t0.building AS building_6, t0.google_maps_url AS google_maps_url_7, t0.phone AS phone_8, t0.website AS website_9, t0.opening_hours AS opening_hours_10, t0.holiday AS holiday_11, t0.access AS access_12, t0.access_car AS access_car_13, t0.access_train AS access_train_14, t0.id AS id_15, t0.sort_num AS sort_num_16, t0.status AS status_17, t0.publish_at AS publish_at_18, t0.expires_at AS expires_at_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.area_id AS area_id_22, t0.prefecture_id AS prefecture_id_23, t0.logo_image AS logo_image_24, t0.main_image AS main_image_25, t0.created_by AS created_by_26, t27.username AS username_28, t27.username_canonical AS username_canonical_29, t27.enabled AS enabled_30, t27.last_login AS last_login_31, t27.confirmation_token AS confirmation_token_32, t27.password_requested_at AS password_requested_at_33, t27.roles AS roles_34, t27.id AS id_35, t27.display_name AS display_name_36, t27.sort_num AS sort_num_37, t27.email AS email_38, t27.email_canonical AS email_canonical_39, t27.salt AS salt_40, t27.password AS password_41, t27.group_id AS group_id_42, t27.facility_id AS facility_id_43, t0.updated_by AS updated_by_44, t45.username AS username_46, t45.username_canonical AS username_canonical_47, t45.enabled AS enabled_48, t45.last_login AS last_login_49, t45.confirmation_token AS confirmation_token_50, t45.password_requested_at AS password_requested_at_51, t45.roles AS roles_52, t45.id AS id_53, t45.display_name AS display_name_54, t45.sort_num AS sort_num_55, t45.email AS email_56, t45.email_canonical AS email_canonical_57, t45.salt AS salt_58, t45.password AS password_59, t45.group_id AS group_id_60, t45.facility_id AS facility_id_61 FROM cms_facility t0 LEFT JOIN cms_user t27 ON t0.created_by = t27.id LEFT JOIN cms_user t45 ON t0.updated_by = t45.id WHERE t0.id IN (1) AND ((t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2024-11-16 12:57:02") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-16 12:57:02")));

SELECT 
  t0.public_date AS public_date_1, 
  t0.customblock AS customblock_2, 
  t0.id AS id_3, 
  t0.sort_num AS sort_num_4, 
  t0.status AS status_5, 
  t0.publish_at AS publish_at_6, 
  t0.expires_at AS expires_at_7, 
  t0.created_at AS created_at_8, 
  t0.updated_at AS updated_at_9, 
  t0.title AS title_10, 
  t0.language_parent AS language_parent_11, 
  t0.language_alias AS language_alias_12, 
  t0.language_active AS language_active_13, 
  t0.revision_parent AS revision_parent_14, 
  t0.revision_version AS revision_version_15, 
  t0.post_type AS post_type_16, 
  t0.access_token AS access_token_17, 
  t0.thumbnail AS thumbnail_18, 
  t19.alt AS alt_20, 
  t19.caption AS caption_21, 
  t19.collation_code AS collation_code_22, 
  t19.meta AS meta_23, 
  t19.id AS id_24, 
  t19.sort_num AS sort_num_25, 
  t19.status AS status_26, 
  t19.publish_at AS publish_at_27, 
  t19.expires_at AS expires_at_28, 
  t19.created_at AS created_at_29, 
  t19.updated_at AS updated_at_30, 
  t19.title AS title_31, 
  t19.item_id AS item_id_32, 
  t19.thumb_item_id AS thumb_item_id_33, 
  t19.group_id AS group_id_34, 
  t19.created_by AS created_by_35, 
  t19.updated_by AS updated_by_36, 
  t0.facility_id AS facility_id_37, 
  t38.code AS code_39, 
  t38.title AS title_40, 
  t38.intro_text AS intro_text_41, 
  t38.zip AS zip_42, 
  t38.address AS address_43, 
  t38.building AS building_44, 
  t38.google_maps_url AS google_maps_url_45, 
  t38.phone AS phone_46, 
  t38.website AS website_47, 
  t38.opening_hours AS opening_hours_48, 
  t38.holiday AS holiday_49, 
  t38.access AS access_50, 
  t38.access_car AS access_car_51, 
  t38.access_train AS access_train_52, 
  t38.id AS id_53, 
  t38.sort_num AS sort_num_54, 
  t38.status AS status_55, 
  t38.publish_at AS publish_at_56, 
  t38.expires_at AS expires_at_57, 
  t38.created_at AS created_at_58, 
  t38.updated_at AS updated_at_59, 
  t38.area_id AS area_id_60, 
  t38.prefecture_id AS prefecture_id_61, 
  t38.logo_image AS logo_image_62, 
  t38.main_image AS main_image_63, 
  t38.created_by AS created_by_64, 
  t38.updated_by AS updated_by_65, 
  t0.created_by AS created_by_66, 
  t67.username AS username_68, 
  t67.username_canonical AS username_canonical_69, 
  t67.enabled AS enabled_70, 
  t67.last_login AS last_login_71, 
  t67.confirmation_token AS confirmation_token_72, 
  t67.password_requested_at AS password_requested_at_73, 
  t67.roles AS roles_74, 
  t67.id AS id_75, 
  t67.display_name AS display_name_76, 
  t67.sort_num AS sort_num_77, 
  t67.email AS email_78, 
  t67.email_canonical AS email_canonical_79, 
  t67.salt AS salt_80, 
  t67.password AS password_81, 
  t67.group_id AS group_id_82, 
  t67.facility_id AS facility_id_83, 
  t0.updated_by AS updated_by_84, 
  t85.username AS username_86, 
  t85.username_canonical AS username_canonical_87, 
  t85.enabled AS enabled_88, 
  t85.last_login AS last_login_89, 
  t85.confirmation_token AS confirmation_token_90, 
  t85.password_requested_at AS password_requested_at_91, 
  t85.roles AS roles_92, 
  t85.id AS id_93, 
  t85.display_name AS display_name_94, 
  t85.sort_num AS sort_num_95, 
  t85.email AS email_96, 
  t85.email_canonical AS email_canonical_97, 
  t85.salt AS salt_98, 
  t85.password AS password_99, 
  t85.group_id AS group_id_100, 
  t85.facility_id AS facility_id_101, 
  t0.language_id AS language_id_102, 
  t103.alias AS alias_104, 
  t103.translate_key AS translate_key_105, 
  t103.target_key AS target_key_106, 
  t103.id AS id_107, 
  t103.sort_num AS sort_num_108, 
  t103.status AS status_109, 
  t103.publish_at AS publish_at_110, 
  t103.expires_at AS expires_at_111, 
  t103.created_at AS created_at_112, 
  t103.updated_at AS updated_at_113, 
  t103.title AS title_114, 
  t103.created_by AS created_by_115, 
  t103.updated_by AS updated_by_116, 
  t0.latest_approval_request_id AS latest_approval_request_id_117, 
  t118.id AS id_119, 
  t118.handler_name AS handler_name_120, 
  t118.title AS title_121, 
  t118.target_id AS target_id_122, 
  t118.request_type AS request_type_123, 
  t118.moderated_at AS moderated_at_124, 
  t118.approval_status AS approval_status_125, 
  t118.comment AS comment_126, 
  t118.created_at AS created_at_127, 
  t118.updated_at AS updated_at_128, 
  t118.facility_id AS facility_id_129, 
  t118.requested_by AS requested_by_130, 
  t118.moderated_by AS moderated_by_131 
FROM 
  cms_mod_restaurant_time_by_cars t0 
  LEFT JOIN cms_media_item_details t19 ON t0.thumbnail = t19.id 
  AND (
    (
      t19.status = 1 
      AND (
        t19.publish_at IS NULL 
        OR t19.publish_at <= "2024-11-16 12:57:02"
      ) 
      AND (
        t19.expires_at IS NULL 
        OR t19.expires_at > "2024-11-16 12:57:02"
      )
    )
  ) 
  LEFT JOIN cms_facility t38 ON t0.facility_id = t38.id 
  AND (
    (
      t38.status = 1 
      AND (
        t38.publish_at IS NULL 
        OR t38.publish_at <= "2024-11-16 12:57:02"
      ) 
      AND (
        t38.expires_at IS NULL 
        OR t38.expires_at > "2024-11-16 12:57:02"
      )
    )
  ) 
  LEFT JOIN cms_user t67 ON t0.created_by = t67.id 
  LEFT JOIN cms_user t85 ON t0.updated_by = t85.id 
  LEFT JOIN cms_master_languages t103 ON t0.language_id = t103.id 
  AND (
    (
      t103.status = 1 
      AND (
        t103.publish_at IS NULL 
        OR t103.publish_at <= "2024-11-16 12:57:02"
      ) 
      AND (
        t103.expires_at IS NULL 
        OR t103.expires_at > "2024-11-16 12:57:02"
      )
    )
  ) 
  LEFT JOIN cms_approval_requests t118 ON t0.latest_approval_request_id = t118.id 
WHERE 
  t0.id IN (?) 
  AND (
    (
      t0.post_type IN ("master")
    ) 
    AND (
      t0.status = 1 
      AND (
        t0.publish_at IS NULL 
        OR t0.publish_at <= "2024-11-16 12:57:02"
      ) 
      AND (
        t0.expires_at IS NULL 
        OR t0.expires_at > "2024-11-16 12:57:02"
      ) 
      AND (
        t0.public_date IS NULL 
        OR t0.public_date <= "2024-11-16"
      )
    )
  )