Symfony Profiler

SELECT 
  t0.is_root AS is_root_1, 
  t0.category_role AS category_role_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.lock_flags AS lock_flags_14, 
  t0.parent_id AS parent_id_15, 
  t16.is_root AS is_root_17, 
  t16.category_role AS category_role_18, 
  t16.id AS id_19, 
  t16.sort_num AS sort_num_20, 
  t16.status AS status_21, 
  t16.publish_at AS publish_at_22, 
  t16.expires_at AS expires_at_23, 
  t16.created_at AS created_at_24, 
  t16.updated_at AS updated_at_25, 
  t16.title AS title_26, 
  t16.language_parent AS language_parent_27, 
  t16.language_alias AS language_alias_28, 
  t16.language_active AS language_active_29, 
  t16.lock_flags AS lock_flags_30, 
  t16.parent_id AS parent_id_31, 
  t16.facility_id AS facility_id_32, 
  t16.created_by AS created_by_33, 
  t16.updated_by AS updated_by_34, 
  t16.language_id AS language_id_35, 
  t0.facility_id AS facility_id_36, 
  t37.code AS code_38, 
  t37.title AS title_39, 
  t37.intro_text AS intro_text_40, 
  t37.zip AS zip_41, 
  t37.address AS address_42, 
  t37.building AS building_43, 
  t37.google_maps_url AS google_maps_url_44, 
  t37.phone AS phone_45, 
  t37.website AS website_46, 
  t37.opening_hours AS opening_hours_47, 
  t37.holiday AS holiday_48, 
  t37.access AS access_49, 
  t37.access_car AS access_car_50, 
  t37.access_train AS access_train_51, 
  t37.id AS id_52, 
  t37.sort_num AS sort_num_53, 
  t37.status AS status_54, 
  t37.publish_at AS publish_at_55, 
  t37.expires_at AS expires_at_56, 
  t37.created_at AS created_at_57, 
  t37.updated_at AS updated_at_58, 
  t37.area_id AS area_id_59, 
  t37.prefecture_id AS prefecture_id_60, 
  t37.logo_image AS logo_image_61, 
  t37.main_image AS main_image_62, 
  t37.created_by AS created_by_63, 
  t37.updated_by AS updated_by_64, 
  t0.created_by AS created_by_65, 
  t66.username AS username_67, 
  t66.username_canonical AS username_canonical_68, 
  t66.enabled AS enabled_69, 
  t66.last_login AS last_login_70, 
  t66.confirmation_token AS confirmation_token_71, 
  t66.password_requested_at AS password_requested_at_72, 
  t66.roles AS roles_73, 
  t66.id AS id_74, 
  t66.display_name AS display_name_75, 
  t66.sort_num AS sort_num_76, 
  t66.email AS email_77, 
  t66.email_canonical AS email_canonical_78, 
  t66.salt AS salt_79, 
  t66.password AS password_80, 
  t66.group_id AS group_id_81, 
  t66.facility_id AS facility_id_82, 
  t0.updated_by AS updated_by_83, 
  t84.username AS username_85, 
  t84.username_canonical AS username_canonical_86, 
  t84.enabled AS enabled_87, 
  t84.last_login AS last_login_88, 
  t84.confirmation_token AS confirmation_token_89, 
  t84.password_requested_at AS password_requested_at_90, 
  t84.roles AS roles_91, 
  t84.id AS id_92, 
  t84.display_name AS display_name_93, 
  t84.sort_num AS sort_num_94, 
  t84.email AS email_95, 
  t84.email_canonical AS email_canonical_96, 
  t84.salt AS salt_97, 
  t84.password AS password_98, 
  t84.group_id AS group_id_99, 
  t84.facility_id AS facility_id_100, 
  t0.language_id AS language_id_101, 
  t102.alias AS alias_103, 
  t102.translate_key AS translate_key_104, 
  t102.target_key AS target_key_105, 
  t102.id AS id_106, 
  t102.sort_num AS sort_num_107, 
  t102.status AS status_108, 
  t102.publish_at AS publish_at_109, 
  t102.expires_at AS expires_at_110, 
  t102.created_at AS created_at_111, 
  t102.updated_at AS updated_at_112, 
  t102.title AS title_113, 
  t102.created_by AS created_by_114, 
  t102.updated_by AS updated_by_115 
FROM 
  cms_mod_topics_categories t0 
  LEFT JOIN cms_mod_topics_categories t16 ON t0.parent_id = t16.id 
  AND (
    (
      t16.status = 1 
      AND (
        t16.publish_at IS NULL 
        OR t16.publish_at <= "2024-11-15 13:06:44"
      ) 
      AND (
        t16.expires_at IS NULL 
        OR t16.expires_at > "2024-11-15 13:06:44"
      )
    )
  ) 
  LEFT JOIN cms_facility t37 ON t0.facility_id = t37.id 
  AND (
    (
      t37.status = 1 
      AND (
        t37.publish_at IS NULL 
        OR t37.publish_at <= "2024-11-15 13:06:44"
      ) 
      AND (
        t37.expires_at IS NULL 
        OR t37.expires_at > "2024-11-15 13:06:44"
      )
    )
  ) 
  LEFT JOIN cms_user t66 ON t0.created_by = t66.id 
  LEFT JOIN cms_user t84 ON t0.updated_by = t84.id 
  LEFT JOIN cms_master_languages t102 ON t0.language_id = t102.id 
  AND (
    (
      t102.status = 1 
      AND (
        t102.publish_at IS NULL 
        OR t102.publish_at <= "2024-11-15 13:06:44"
      ) 
      AND (
        t102.expires_at IS NULL 
        OR t102.expires_at > "2024-11-15 13:06:44"
      )
    )
  ) 
  INNER JOIN cms_mod_topics_post_category ON t0.id = cms_mod_topics_post_category.category_id 
WHERE 
  cms_mod_topics_post_category.item_id = ? 
  AND (
    (
      t0.status = 1 
      AND (
        t0.publish_at IS NULL 
        OR t0.publish_at <= "2024-11-15 13:06:44"
      ) 
      AND (
        t0.expires_at IS NULL 
        OR t0.expires_at > "2024-11-15 13:06:44"
      )
    )
  ) 
ORDER BY 
  t0.sort_num ASC, 
  t0.id ASC

SELECT t0.is_root AS is_root_1, t0.category_role AS category_role_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.lock_flags AS lock_flags_14, t0.parent_id AS parent_id_15, t16.is_root AS is_root_17, t16.category_role AS category_role_18, t16.id AS id_19, t16.sort_num AS sort_num_20, t16.status AS status_21, t16.publish_at AS publish_at_22, t16.expires_at AS expires_at_23, t16.created_at AS created_at_24, t16.updated_at AS updated_at_25, t16.title AS title_26, t16.language_parent AS language_parent_27, t16.language_alias AS language_alias_28, t16.language_active AS language_active_29, t16.lock_flags AS lock_flags_30, t16.parent_id AS parent_id_31, t16.facility_id AS facility_id_32, t16.created_by AS created_by_33, t16.updated_by AS updated_by_34, t16.language_id AS language_id_35, t0.facility_id AS facility_id_36, t37.code AS code_38, t37.title AS title_39, t37.intro_text AS intro_text_40, t37.zip AS zip_41, t37.address AS address_42, t37.building AS building_43, t37.google_maps_url AS google_maps_url_44, t37.phone AS phone_45, t37.website AS website_46, t37.opening_hours AS opening_hours_47, t37.holiday AS holiday_48, t37.access AS access_49, t37.access_car AS access_car_50, t37.access_train AS access_train_51, t37.id AS id_52, t37.sort_num AS sort_num_53, t37.status AS status_54, t37.publish_at AS publish_at_55, t37.expires_at AS expires_at_56, t37.created_at AS created_at_57, t37.updated_at AS updated_at_58, t37.area_id AS area_id_59, t37.prefecture_id AS prefecture_id_60, t37.logo_image AS logo_image_61, t37.main_image AS main_image_62, t37.created_by AS created_by_63, t37.updated_by AS updated_by_64, t0.created_by AS created_by_65, t66.username AS username_67, t66.username_canonical AS username_canonical_68, t66.enabled AS enabled_69, t66.last_login AS last_login_70, t66.confirmation_token AS confirmation_token_71, t66.password_requested_at AS password_requested_at_72, t66.roles AS roles_73, t66.id AS id_74, t66.display_name AS display_name_75, t66.sort_num AS sort_num_76, t66.email AS email_77, t66.email_canonical AS email_canonical_78, t66.salt AS salt_79, t66.password AS password_80, t66.group_id AS group_id_81, t66.facility_id AS facility_id_82, t0.updated_by AS updated_by_83, t84.username AS username_85, t84.username_canonical AS username_canonical_86, t84.enabled AS enabled_87, t84.last_login AS last_login_88, t84.confirmation_token AS confirmation_token_89, t84.password_requested_at AS password_requested_at_90, t84.roles AS roles_91, t84.id AS id_92, t84.display_name AS display_name_93, t84.sort_num AS sort_num_94, t84.email AS email_95, t84.email_canonical AS email_canonical_96, t84.salt AS salt_97, t84.password AS password_98, t84.group_id AS group_id_99, t84.facility_id AS facility_id_100, t0.language_id AS language_id_101, t102.alias AS alias_103, t102.translate_key AS translate_key_104, t102.target_key AS target_key_105, t102.id AS id_106, t102.sort_num AS sort_num_107, t102.status AS status_108, t102.publish_at AS publish_at_109, t102.expires_at AS expires_at_110, t102.created_at AS created_at_111, t102.updated_at AS updated_at_112, t102.title AS title_113, t102.created_by AS created_by_114, t102.updated_by AS updated_by_115 FROM cms_mod_topics_categories t0 LEFT JOIN cms_mod_topics_categories t16 ON t0.parent_id = t16.id AND ((t16.status = 1 AND (t16.publish_at IS NULL OR t16.publish_at <= "2024-11-15 131:44") AND (t16.expires_at IS NULL OR t16.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_facility t37 ON t0.facility_id = t37.id AND ((t37.status = 1 AND (t37.publish_at IS NULL OR t37.publish_at <= "2024-11-15 13:06:44") AND (t37.expires_at IS NULL OR t37.expires_at > "2024-11-15 13:06:44"))) LEFT JOIN cms_user t66 ON t0.created_by = t66.id LEFT JOIN cms_user t84 ON t0.updated_by = t84.id LEFT JOIN cms_master_languages t102 ON t0.language_id = t102.id AND ((t102.status = 1 AND (t102.publish_at IS NULL OR t102.publish_at <= "2024-11-15 13:06:44") AND (t102.expires_at IS NULL OR t102.expires_at > "2024-11-15 13:06:44"))) INNER JOIN cms_mod_topics_post_category ON t0.id = cms_mod_topics_post_category.category_id WHERE cms_mod_topics_post_category.item_id = ? AND ((t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2024-11-15 13:06:44") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 13:06:44"))) ORDER BY t0.sort_num ASC, t0.id ASC;

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-15 13:06:44"
      ) 
      AND (
        t14.expires_at IS NULL 
        OR t14.expires_at > "2024-11-15 13:06:44"
      )
    )
  ) 
  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-15 13:06:44"
      ) 
      AND (
        t50.expires_at IS NULL 
        OR t50.expires_at > "2024-11-15 13:06:44"
      )
    )
  ) 
  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-15 13:06:44"
      ) 
      AND (
        t0.expires_at IS NULL 
        OR t0.expires_at > "2024-11-15 13:06:44"
      )
    )
  )

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-15 13405, 406, 409, 410, 413, 414:44") AND (t14.expires_at IS NULL OR t14.expires_at > "2024-11-15 13:06:44"))) 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-15 13:06:44") AND (t50.expires_at IS NULL OR t50.expires_at > "2024-11-15 13:06:44"))) 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-15 13:06:44") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 13:06:44")));

SELECT 
  t0.title_for_list AS title_for_list_1, 
  t0.alias AS alias_2, 
  t0.show_in_list AS show_in_list_3, 
  t0.public_date AS public_date_4, 
  t0.customblock AS customblock_5, 
  t0.id AS id_6, 
  t0.sort_num AS sort_num_7, 
  t0.status AS status_8, 
  t0.publish_at AS publish_at_9, 
  t0.expires_at AS expires_at_10, 
  t0.created_at AS created_at_11, 
  t0.updated_at AS updated_at_12, 
  t0.title AS title_13, 
  t0.language_parent AS language_parent_14, 
  t0.language_alias AS language_alias_15, 
  t0.language_active AS language_active_16, 
  t0.revision_parent AS revision_parent_17, 
  t0.revision_version AS revision_version_18, 
  t0.post_type AS post_type_19, 
  t0.access_token AS access_token_20, 
  t0.image_pc AS image_pc_21, 
  t22.alt AS alt_23, 
  t22.caption AS caption_24, 
  t22.collation_code AS collation_code_25, 
  t22.meta AS meta_26, 
  t22.id AS id_27, 
  t22.sort_num AS sort_num_28, 
  t22.status AS status_29, 
  t22.publish_at AS publish_at_30, 
  t22.expires_at AS expires_at_31, 
  t22.created_at AS created_at_32, 
  t22.updated_at AS updated_at_33, 
  t22.title AS title_34, 
  t22.item_id AS item_id_35, 
  t22.thumb_item_id AS thumb_item_id_36, 
  t22.group_id AS group_id_37, 
  t22.created_by AS created_by_38, 
  t22.updated_by AS updated_by_39, 
  t0.image_sp AS image_sp_40, 
  t41.alt AS alt_42, 
  t41.caption AS caption_43, 
  t41.collation_code AS collation_code_44, 
  t41.meta AS meta_45, 
  t41.id AS id_46, 
  t41.sort_num AS sort_num_47, 
  t41.status AS status_48, 
  t41.publish_at AS publish_at_49, 
  t41.expires_at AS expires_at_50, 
  t41.created_at AS created_at_51, 
  t41.updated_at AS updated_at_52, 
  t41.title AS title_53, 
  t41.item_id AS item_id_54, 
  t41.thumb_item_id AS thumb_item_id_55, 
  t41.group_id AS group_id_56, 
  t41.created_by AS created_by_57, 
  t41.updated_by AS updated_by_58, 
  t0.thumbnail AS thumbnail_59, 
  t60.alt AS alt_61, 
  t60.caption AS caption_62, 
  t60.collation_code AS collation_code_63, 
  t60.meta AS meta_64, 
  t60.id AS id_65, 
  t60.sort_num AS sort_num_66, 
  t60.status AS status_67, 
  t60.publish_at AS publish_at_68, 
  t60.expires_at AS expires_at_69, 
  t60.created_at AS created_at_70, 
  t60.updated_at AS updated_at_71, 
  t60.title AS title_72, 
  t60.item_id AS item_id_73, 
  t60.thumb_item_id AS thumb_item_id_74, 
  t60.group_id AS group_id_75, 
  t60.created_by AS created_by_76, 
  t60.updated_by AS updated_by_77, 
  t0.facility_id AS facility_id_78, 
  t79.code AS code_80, 
  t79.title AS title_81, 
  t79.intro_text AS intro_text_82, 
  t79.zip AS zip_83, 
  t79.address AS address_84, 
  t79.building AS building_85, 
  t79.google_maps_url AS google_maps_url_86, 
  t79.phone AS phone_87, 
  t79.website AS website_88, 
  t79.opening_hours AS opening_hours_89, 
  t79.holiday AS holiday_90, 
  t79.access AS access_91, 
  t79.access_car AS access_car_92, 
  t79.access_train AS access_train_93, 
  t79.id AS id_94, 
  t79.sort_num AS sort_num_95, 
  t79.status AS status_96, 
  t79.publish_at AS publish_at_97, 
  t79.expires_at AS expires_at_98, 
  t79.created_at AS created_at_99, 
  t79.updated_at AS updated_at_100, 
  t79.area_id AS area_id_101, 
  t79.prefecture_id AS prefecture_id_102, 
  t79.logo_image AS logo_image_103, 
  t79.main_image AS main_image_104, 
  t79.created_by AS created_by_105, 
  t79.updated_by AS updated_by_106, 
  t0.created_by AS created_by_107, 
  t108.username AS username_109, 
  t108.username_canonical AS username_canonical_110, 
  t108.enabled AS enabled_111, 
  t108.last_login AS last_login_112, 
  t108.confirmation_token AS confirmation_token_113, 
  t108.password_requested_at AS password_requested_at_114, 
  t108.roles AS roles_115, 
  t108.id AS id_116, 
  t108.display_name AS display_name_117, 
  t108.sort_num AS sort_num_118, 
  t108.email AS email_119, 
  t108.email_canonical AS email_canonical_120, 
  t108.salt AS salt_121, 
  t108.password AS password_122, 
  t108.group_id AS group_id_123, 
  t108.facility_id AS facility_id_124, 
  t0.updated_by AS updated_by_125, 
  t126.username AS username_127, 
  t126.username_canonical AS username_canonical_128, 
  t126.enabled AS enabled_129, 
  t126.last_login AS last_login_130, 
  t126.confirmation_token AS confirmation_token_131, 
  t126.password_requested_at AS password_requested_at_132, 
  t126.roles AS roles_133, 
  t126.id AS id_134, 
  t126.display_name AS display_name_135, 
  t126.sort_num AS sort_num_136, 
  t126.email AS email_137, 
  t126.email_canonical AS email_canonical_138, 
  t126.salt AS salt_139, 
  t126.password AS password_140, 
  t126.group_id AS group_id_141, 
  t126.facility_id AS facility_id_142, 
  t0.language_id AS language_id_143, 
  t144.alias AS alias_145, 
  t144.translate_key AS translate_key_146, 
  t144.target_key AS target_key_147, 
  t144.id AS id_148, 
  t144.sort_num AS sort_num_149, 
  t144.status AS status_150, 
  t144.publish_at AS publish_at_151, 
  t144.expires_at AS expires_at_152, 
  t144.created_at AS created_at_153, 
  t144.updated_at AS updated_at_154, 
  t144.title AS title_155, 
  t144.created_by AS created_by_156, 
  t144.updated_by AS updated_by_157, 
  t0.latest_approval_request_id AS latest_approval_request_id_158, 
  t159.id AS id_160, 
  t159.handler_name AS handler_name_161, 
  t159.title AS title_162, 
  t159.target_id AS target_id_163, 
  t159.request_type AS request_type_164, 
  t159.moderated_at AS moderated_at_165, 
  t159.approval_status AS approval_status_166, 
  t159.comment AS comment_167, 
  t159.created_at AS created_at_168, 
  t159.updated_at AS updated_at_169, 
  t159.facility_id AS facility_id_170, 
  t159.requested_by AS requested_by_171, 
  t159.moderated_by AS moderated_by_172 
FROM 
  cms_mod_restaurant_genres t0 
  LEFT JOIN cms_media_item_details t22 ON t0.image_pc = t22.id 
  AND (
    (
      t22.status = 1 
      AND (
        t22.publish_at IS NULL 
        OR t22.publish_at <= "2024-11-15 13:06:44"
      ) 
      AND (
        t22.expires_at IS NULL 
        OR t22.expires_at > "2024-11-15 13:06:44"
      )
    )
  ) 
  LEFT JOIN cms_media_item_details t41 ON t0.image_sp = t41.id 
  AND (
    (
      t41.status = 1 
      AND (
        t41.publish_at IS NULL 
        OR t41.publish_at <= "2024-11-15 13:06:44"
      ) 
      AND (
        t41.expires_at IS NULL 
        OR t41.expires_at > "2024-11-15 13:06:44"
      )
    )
  ) 
  LEFT JOIN cms_media_item_details t60 ON t0.thumbnail = t60.id 
  AND (
    (
      t60.status = 1 
      AND (
        t60.publish_at IS NULL 
        OR t60.publish_at <= "2024-11-15 13:06:44"
      ) 
      AND (
        t60.expires_at IS NULL 
        OR t60.expires_at > "2024-11-15 13:06:44"
      )
    )
  ) 
  LEFT JOIN cms_facility t79 ON t0.facility_id = t79.id 
  AND (
    (
      t79.status = 1 
      AND (
        t79.publish_at IS NULL 
        OR t79.publish_at <= "2024-11-15 13:06:44"
      ) 
      AND (
        t79.expires_at IS NULL 
        OR t79.expires_at > "2024-11-15 13:06:44"
      )
    )
  ) 
  LEFT JOIN cms_user t108 ON t0.created_by = t108.id 
  LEFT JOIN cms_user t126 ON t0.updated_by = t126.id 
  LEFT JOIN cms_master_languages t144 ON t0.language_id = t144.id 
  AND (
    (
      t144.status = 1 
      AND (
        t144.publish_at IS NULL 
        OR t144.publish_at <= "2024-11-15 13:06:44"
      ) 
      AND (
        t144.expires_at IS NULL 
        OR t144.expires_at > "2024-11-15 13:06:44"
      )
    )
  ) 
  LEFT JOIN cms_approval_requests t159 ON t0.latest_approval_request_id = t159.id 
  INNER JOIN cms_mod_top_gourmet_pickup_items_genres ON t0.id = cms_mod_top_gourmet_pickup_items_genres.genre_id 
WHERE 
  cms_mod_top_gourmet_pickup_items_genres.gourmet_pickup_id = ? 
  AND (
    (
      t0.post_type IN ("master")
    ) 
    AND (
      t0.status = 1 
      AND (
        t0.publish_at IS NULL 
        OR t0.publish_at <= "2024-11-15 13:06:44"
      ) 
      AND (
        t0.expires_at IS NULL 
        OR t0.expires_at > "2024-11-15 13:06:44"
      ) 
      AND (
        t0.public_date IS NULL 
        OR t0.public_date <= "2024-11-15"
      )
    )
  ) 
ORDER BY 
  t0.sort_num ASC, 
  t0.id ASC