Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.preview_image_url AS preview_image_url_2,
  t0.completion_text AS completion_text_3,
  t0.guide_completion_text AS guide_completion_text_4,
  t0.audio_guide_completion_text_url AS audio_guide_completion_text_url_5,
  t0.approximate_duration AS approximate_duration_6,
  t0.approximate_length AS approximate_length_7,
  t0.notification_distance AS notification_distance_8,
  t0.updated_at AS updated_at_9,
  t0.titlevalue AS titlevalue_10,
  t0.live AS live_11,
  t0.title_id AS title_id_12,
  t0.description_id AS description_id_13,
  t0.short_description_id AS short_description_id_14
FROM
  tour t0
WHERE
  t0.live = ?

SELECT t0.id AS id_1, t0.preview_image_url AS preview_image_url_2, t0.completion_text AS completion_text_3, t0.guide_completion_text AS guide_completion_text_4, t0.audio_guide_completion_text_url AS audio_guide_completion_text_url_5, t0.approximate_duration AS approximate_duration_6, t0.approximate_length AS approximate_length_7, t0.notification_distance AS notification_distance_8, t0.updated_at AS updated_at_9, t0.titlevalue AS titlevalue_10, t0.live AS live_11, t0.title_id AS title_id_12, t0.description_id AS description_id_13, t0.short_description_id AS short_description_id_14 FROM tour t0 WHERE t0.live = 1;

SELECT
  t0.id AS id_1,
  t0.preview_image_url AS preview_image_url_2,
  t0.item_prensentation_aspectratio AS item_prensentation_aspectratio_3,
  t0.titlevalue AS titlevalue_4,
  t0.updated_at AS updated_at_5,
  t0.live AS live_6,
  t0.title_id AS title_id_7,
  t0.description_id AS description_id_8,
  t0.short_description_id AS short_description_id_9
FROM
  category t0
WHERE
  t0.live = ?

SELECT t0.id AS id_1, t0.preview_image_url AS preview_image_url_2, t0.item_prensentation_aspectratio AS item_prensentation_aspectratio_3, t0.titlevalue AS titlevalue_4, t0.updated_at AS updated_at_5, t0.live AS live_6, t0.title_id AS title_id_7, t0.description_id AS description_id_8, t0.short_description_id AS short_description_id_9 FROM category t0 WHERE t0.live = 1;

SELECT
  t0.id AS id_1,
  t0.preview_image_url AS preview_image_url_2,
  t0.longitude AS longitude_3,
  t0.latidtude AS latidtude_4,
  t0.visited_completion_distance AS visited_completion_distance_5,
  t0.activation_distance AS activation_distance_6,
  t0.notification_distance AS notification_distance_7,
  t0.notification_text AS notification_text_8,
  t0.guide_text_entry AS guide_text_entry_9,
  t0.audio_guide_text_entry_url AS audio_guide_text_entry_url_10,
  t0.guide_text_exit AS guide_text_exit_11,
  t0.audio_guide_text_exit_url AS audio_guide_text_exit_url_12,
  t0.custom_3_d_model_url AS custom_3_d_model_url_13,
  t0.completion_condition AS completion_condition_14,
  t0.titlevalue AS titlevalue_15,
  t0.model_offset_x AS model_offset_x_16,
  t0.model_offset_y AS model_offset_y_17,
  t0.model_offset_z AS model_offset_z_18,
  t0.live AS live_19,
  t0.updated_at AS updated_at_20,
  t0.custom_3_d_android_model_url AS custom_3_d_android_model_url_21,
  t0.custom_3_d_ios_model_url AS custom_3_d_ios_model_url_22,
  t0.video_url AS video_url_23,
  t0.title_id AS title_id_24,
  t0.description_id AS description_id_25,
  t0.short_description_id AS short_description_id_26,
  t0.treasure_name_id AS treasure_name_id_27
FROM
  poi t0
WHERE
  t0.live = ?

SELECT t0.id AS id_1, t0.preview_image_url AS preview_image_url_2, t0.longitude AS longitude_3, t0.latidtude AS latidtude_4, t0.visited_completion_distance AS visited_completion_distance_5, t0.activation_distance AS activation_distance_6, t0.notification_distance AS notification_distance_7, t0.notification_text AS notification_text_8, t0.guide_text_entry AS guide_text_entry_9, t0.audio_guide_text_entry_url AS audio_guide_text_entry_url_10, t0.guide_text_exit AS guide_text_exit_11, t0.audio_guide_text_exit_url AS audio_guide_text_exit_url_12, t0.custom_3_d_model_url AS custom_3_d_model_url_13, t0.completion_condition AS completion_condition_14, t0.titlevalue AS titlevalue_15, t0.model_offset_x AS model_offset_x_16, t0.model_offset_y AS model_offset_y_17, t0.model_offset_z AS model_offset_z_18, t0.live AS live_19, t0.updated_at AS updated_at_20, t0.custom_3_d_android_model_url AS custom_3_d_android_model_url_21, t0.custom_3_d_ios_model_url AS custom_3_d_ios_model_url_22, t0.video_url AS video_url_23, t0.title_id AS title_id_24, t0.description_id AS description_id_25, t0.short_description_id AS short_description_id_26, t0.treasure_name_id AS treasure_name_id_27 FROM poi t0 WHERE t0.live = 1;

SELECT
  t0.id AS id_1,
  t0.preview_image_url AS preview_image_url_2,
  t0.item_prensentation_aspectratio AS item_prensentation_aspectratio_3,
  t0.titlevalue AS titlevalue_4,
  t0.updated_at AS updated_at_5,
  t0.live AS live_6,
  t0.title_id AS title_id_7,
  t0.description_id AS description_id_8,
  t0.short_description_id AS short_description_id_9
FROM
  category t0
  INNER JOIN category_category ON t0.id = category_category.category_target
WHERE
  category_category.category_source = ?

SELECT t0.id AS id_1, t0.preview_image_url AS preview_image_url_2, t0.item_prensentation_aspectratio AS item_prensentation_aspectratio_3, t0.titlevalue AS titlevalue_4, t0.updated_at AS updated_at_5, t0.live AS live_6, t0.title_id AS title_id_7, t0.description_id AS description_id_8, t0.short_description_id AS short_description_id_9 FROM category t0 INNER JOIN category_category ON t0.id = category_category.category_target WHERE category_category.category_source = 3;

SELECT
  t0.id AS id_1,
  t0.sortorder AS sortorder_2,
  t0.category_id AS category_id_3,
  t0.poi_id AS poi_id_4
FROM
  category_poi t0
WHERE
  t0.category_id = ?
ORDER BY
  t0.sortorder ASC

SELECT t0.id AS id_1, t0.sortorder AS sortorder_2, t0.category_id AS category_id_3, t0.poi_id AS poi_id_4 FROM category_poi t0 WHERE t0.category_id = 3 ORDER BY t0.sortorder ASC;

SELECT
  t0.id AS id_1,
  t0.preview_image_url AS preview_image_url_2,
  t0.completion_text AS completion_text_3,
  t0.guide_completion_text AS guide_completion_text_4,
  t0.audio_guide_completion_text_url AS audio_guide_completion_text_url_5,
  t0.approximate_duration AS approximate_duration_6,
  t0.approximate_length AS approximate_length_7,
  t0.notification_distance AS notification_distance_8,
  t0.updated_at AS updated_at_9,
  t0.titlevalue AS titlevalue_10,
  t0.live AS live_11,
  t0.title_id AS title_id_12,
  t0.description_id AS description_id_13,
  t0.short_description_id AS short_description_id_14
FROM
  tour t0
  INNER JOIN category_tour ON t0.id = category_tour.tour_id
WHERE
  category_tour.category_id = ?

SELECT t0.id AS id_1, t0.preview_image_url AS preview_image_url_2, t0.completion_text AS completion_text_3, t0.guide_completion_text AS guide_completion_text_4, t0.audio_guide_completion_text_url AS audio_guide_completion_text_url_5, t0.approximate_duration AS approximate_duration_6, t0.approximate_length AS approximate_length_7, t0.notification_distance AS notification_distance_8, t0.updated_at AS updated_at_9, t0.titlevalue AS titlevalue_10, t0.live AS live_11, t0.title_id AS title_id_12, t0.description_id AS description_id_13, t0.short_description_id AS short_description_id_14 FROM tour t0 INNER JOIN category_tour ON t0.id = category_tour.tour_id WHERE category_tour.category_id = 3;

SELECT
  t0.id AS id_1,
  t0.text AS text_2,
  t0.audio_text_url AS audio_text_url_3
FROM
  audio_text_block t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.text AS text_2, t0.audio_text_url AS audio_text_url_3 FROM audio_text_block t0 WHERE t0.id = 20;

SELECT
  t0.id AS id_1,
  t0.text AS text_2,
  t0.audio_text_url AS audio_text_url_3
FROM
  audio_text_block t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.text AS text_2, t0.audio_text_url AS audio_text_url_3 FROM audio_text_block t0 WHERE t0.id = 21;

SELECT
  t0.id AS id_1,
  t0.preview_image_url AS preview_image_url_2,
  t0.item_prensentation_aspectratio AS item_prensentation_aspectratio_3,
  t0.titlevalue AS titlevalue_4,
  t0.updated_at AS updated_at_5,
  t0.live AS live_6,
  t0.title_id AS title_id_7,
  t0.description_id AS description_id_8,
  t0.short_description_id AS short_description_id_9
FROM
  category t0
  INNER JOIN category_category ON t0.id = category_category.category_target
WHERE
  category_category.category_source = ?

SELECT t0.id AS id_1, t0.preview_image_url AS preview_image_url_2, t0.item_prensentation_aspectratio AS item_prensentation_aspectratio_3, t0.titlevalue AS titlevalue_4, t0.updated_at AS updated_at_5, t0.live AS live_6, t0.title_id AS title_id_7, t0.description_id AS description_id_8, t0.short_description_id AS short_description_id_9 FROM category t0 INNER JOIN category_category ON t0.id = category_category.category_target WHERE category_category.category_source = 4;

SELECT
  t0.id AS id_1,
  t0.sortorder AS sortorder_2,
  t0.category_id AS category_id_3,
  t0.poi_id AS poi_id_4
FROM
  category_poi t0
WHERE
  t0.category_id = ?
ORDER BY
  t0.sortorder ASC

SELECT t0.id AS id_1, t0.sortorder AS sortorder_2, t0.category_id AS category_id_3, t0.poi_id AS poi_id_4 FROM category_poi t0 WHERE t0.category_id = 4 ORDER BY t0.sortorder ASC;

SELECT
  t0.id AS id_1,
  t0.preview_image_url AS preview_image_url_2,
  t0.completion_text AS completion_text_3,
  t0.guide_completion_text AS guide_completion_text_4,
  t0.audio_guide_completion_text_url AS audio_guide_completion_text_url_5,
  t0.approximate_duration AS approximate_duration_6,
  t0.approximate_length AS approximate_length_7,
  t0.notification_distance AS notification_distance_8,
  t0.updated_at AS updated_at_9,
  t0.titlevalue AS titlevalue_10,
  t0.live AS live_11,
  t0.title_id AS title_id_12,
  t0.description_id AS description_id_13,
  t0.short_description_id AS short_description_id_14
FROM
  tour t0
  INNER JOIN category_tour ON t0.id = category_tour.tour_id
WHERE
  category_tour.category_id = ?

SELECT t0.id AS id_1, t0.preview_image_url AS preview_image_url_2, t0.completion_text AS completion_text_3, t0.guide_completion_text AS guide_completion_text_4, t0.audio_guide_completion_text_url AS audio_guide_completion_text_url_5, t0.approximate_duration AS approximate_duration_6, t0.approximate_length AS approximate_length_7, t0.notification_distance AS notification_distance_8, t0.updated_at AS updated_at_9, t0.titlevalue AS titlevalue_10, t0.live AS live_11, t0.title_id AS title_id_12, t0.description_id AS description_id_13, t0.short_description_id AS short_description_id_14 FROM tour t0 INNER JOIN category_tour ON t0.id = category_tour.tour_id WHERE category_tour.category_id = 4;

SELECT
  t0.id AS id_1,
  t0.text AS text_2,
  t0.audio_text_url AS audio_text_url_3
FROM
  audio_text_block t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.text AS text_2, t0.audio_text_url AS audio_text_url_3 FROM audio_text_block t0 WHERE t0.id = 36;

SELECT
  t0.id AS id_1,
  t0.text AS text_2,
  t0.audio_text_url AS audio_text_url_3
FROM
  audio_text_block t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.text AS text_2, t0.audio_text_url AS audio_text_url_3 FROM audio_text_block t0 WHERE t0.id = 37;

SELECT
  t0.id AS id_1,
  t0.preview_image_url AS preview_image_url_2,
  t0.item_prensentation_aspectratio AS item_prensentation_aspectratio_3,
  t0.titlevalue AS titlevalue_4,
  t0.updated_at AS updated_at_5,
  t0.live AS live_6,
  t0.title_id AS title_id_7,
  t0.description_id AS description_id_8,
  t0.short_description_id AS short_description_id_9
FROM
  category t0
  INNER JOIN category_category ON t0.id = category_category.category_target
WHERE
  category_category.category_source = ?

SELECT t0.id AS id_1, t0.preview_image_url AS preview_image_url_2, t0.item_prensentation_aspectratio AS item_prensentation_aspectratio_3, t0.titlevalue AS titlevalue_4, t0.updated_at AS updated_at_5, t0.live AS live_6, t0.title_id AS title_id_7, t0.description_id AS description_id_8, t0.short_description_id AS short_description_id_9 FROM category t0 INNER JOIN category_category ON t0.id = category_category.category_target WHERE category_category.category_source = 5;

SELECT
  t0.id AS id_1,
  t0.sortorder AS sortorder_2,
  t0.category_id AS category_id_3,
  t0.poi_id AS poi_id_4
FROM
  category_poi t0
WHERE
  t0.category_id = ?
ORDER BY
  t0.sortorder ASC

SELECT t0.id AS id_1, t0.sortorder AS sortorder_2, t0.category_id AS category_id_3, t0.poi_id AS poi_id_4 FROM category_poi t0 WHERE t0.category_id = 5 ORDER BY t0.sortorder ASC;

SELECT
  t0.id AS id_1,
  t0.preview_image_url AS preview_image_url_2,
  t0.completion_text AS completion_text_3,
  t0.guide_completion_text AS guide_completion_text_4,
  t0.audio_guide_completion_text_url AS audio_guide_completion_text_url_5,
  t0.approximate_duration AS approximate_duration_6,
  t0.approximate_length AS approximate_length_7,
  t0.notification_distance AS notification_distance_8,
  t0.updated_at AS updated_at_9,
  t0.titlevalue AS titlevalue_10,
  t0.live AS live_11,
  t0.title_id AS title_id_12,
  t0.description_id AS description_id_13,
  t0.short_description_id AS short_description_id_14
FROM
  tour t0
  INNER JOIN category_tour ON t0.id = category_tour.tour_id
WHERE
  category_tour.category_id = ?

SELECT t0.id AS id_1, t0.preview_image_url AS preview_image_url_2, t0.completion_text AS completion_text_3, t0.guide_completion_text AS guide_completion_text_4, t0.audio_guide_completion_text_url AS audio_guide_completion_text_url_5, t0.approximate_duration AS approximate_duration_6, t0.approximate_length AS approximate_length_7, t0.notification_distance AS notification_distance_8, t0.updated_at AS updated_at_9, t0.titlevalue AS titlevalue_10, t0.live AS live_11, t0.title_id AS title_id_12, t0.description_id AS description_id_13, t0.short_description_id AS short_description_id_14 FROM tour t0 INNER JOIN category_tour ON t0.id = category_tour.tour_id WHERE category_tour.category_id = 5;

SELECT
  t0.id AS id_1,
  t0.text AS text_2,
  t0.audio_text_url AS audio_text_url_3
FROM
  audio_text_block t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.text AS text_2, t0.audio_text_url AS audio_text_url_3 FROM audio_text_block t0 WHERE t0.id = 419;

SELECT
  t0.id AS id_1,
  t0.text AS text_2,
  t0.audio_text_url AS audio_text_url_3
FROM
  audio_text_block t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.text AS text_2, t0.audio_text_url AS audio_text_url_3 FROM audio_text_block t0 WHERE t0.id = 420;

SELECT
  t0.id AS id_1,
  t0.sortorder AS sortorder_2,
  t0.tour_id AS tour_id_3,
  t0.poi_id AS poi_id_4
FROM
  poi_tour t0
WHERE
  t0.tour_id = ?
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.sortorder AS sortorder_2, t0.tour_id AS tour_id_3, t0.poi_id AS poi_id_4 FROM poi_tour t0 WHERE t0.tour_id = 8 ORDER BY t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.preview_image_url AS preview_image_url_2,
  t0.item_prensentation_aspectratio AS item_prensentation_aspectratio_3,
  t0.titlevalue AS titlevalue_4,
  t0.updated_at AS updated_at_5,
  t0.live AS live_6,
  t0.title_id AS title_id_7,
  t0.description_id AS description_id_8,
  t0.short_description_id AS short_description_id_9
FROM
  category t0
  INNER JOIN category_tour ON t0.id = category_tour.category_id
WHERE
  category_tour.tour_id = ?

SELECT t0.id AS id_1, t0.preview_image_url AS preview_image_url_2, t0.item_prensentation_aspectratio AS item_prensentation_aspectratio_3, t0.titlevalue AS titlevalue_4, t0.updated_at AS updated_at_5, t0.live AS live_6, t0.title_id AS title_id_7, t0.description_id AS description_id_8, t0.short_description_id AS short_description_id_9 FROM category t0 INNER JOIN category_tour ON t0.id = category_tour.category_id WHERE category_tour.tour_id = 8;

SELECT
  t0.id AS id_1,
  t0.text AS text_2,
  t0.audio_text_url AS audio_text_url_3
FROM
  audio_text_block t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.text AS text_2, t0.audio_text_url AS audio_text_url_3 FROM audio_text_block t0 WHERE t0.id = 400;

SELECT
  t0.id AS id_1,
  t0.text AS text_2,
  t0.audio_text_url AS audio_text_url_3
FROM
  audio_text_block t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.text AS text_2, t0.audio_text_url AS audio_text_url_3 FROM audio_text_block t0 WHERE t0.id = 401;

SELECT
  t0.id AS id_1,
  t0.text AS text_2,
  t0.audio_text_url AS audio_text_url_3
FROM
  audio_text_block t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.text AS text_2, t0.audio_text_url AS audio_text_url_3 FROM audio_text_block t0 WHERE t0.id = 402;

SELECT
  t0.id AS id_1,
  t0.text AS text_2,
  t0.audio_text_url AS audio_text_url_3
FROM
  audio_text_block t0
  INNER JOIN tourtextblockguidestart ON t0.id = tourtextblockguidestart.audio_text_block_id
WHERE
  tourtextblockguidestart.tour_id = ?

SELECT t0.id AS id_1, t0.text AS text_2, t0.audio_text_url AS audio_text_url_3 FROM audio_text_block t0 INNER JOIN tourtextblockguidestart ON t0.id = tourtextblockguidestart.audio_text_block_id WHERE tourtextblockguidestart.tour_id = 8;

SELECT
  t0.id AS id_1,
  t0.text AS text_2,
  t0.audio_text_url AS audio_text_url_3
FROM
  audio_text_block t0
  INNER JOIN tourtextblockguidecompletion ON t0.id = tourtextblockguidecompletion.audio_text_block_id
WHERE
  tourtextblockguidecompletion.tour_id = ?

SELECT t0.id AS id_1, t0.text AS text_2, t0.audio_text_url AS audio_text_url_3 FROM audio_text_block t0 INNER JOIN tourtextblockguidecompletion ON t0.id = tourtextblockguidecompletion.audio_text_block_id WHERE tourtextblockguidecompletion.tour_id = 8;

SELECT
  t0.id AS id_1,
  t0.text AS text_2,
  t0.audio_text_url AS audio_text_url_3
FROM
  audio_text_block t0
  INNER JOIN tourtextblockcompletion ON t0.id = tourtextblockcompletion.audio_text_block_id
WHERE
  tourtextblockcompletion.tour_id = ?

SELECT t0.id AS id_1, t0.text AS text_2, t0.audio_text_url AS audio_text_url_3 FROM audio_text_block t0 INNER JOIN tourtextblockcompletion ON t0.id = tourtextblockcompletion.audio_text_block_id WHERE tourtextblockcompletion.tour_id = 8;

SELECT
  t0.id AS id_1,
  t0.text AS text_2,
  t0.audio_text_url AS audio_text_url_3
FROM
  audio_text_block t0
  INNER JOIN tourtextblocknotification ON t0.id = tourtextblocknotification.audio_text_block_id
WHERE
  tourtextblocknotification.tour_id = ?

SELECT t0.id AS id_1, t0.text AS text_2, t0.audio_text_url AS audio_text_url_3 FROM audio_text_block t0 INNER JOIN tourtextblocknotification ON t0.id = tourtextblocknotification.audio_text_block_id WHERE tourtextblocknotification.tour_id = 8;

SELECT
  t0.id AS id_1,
  t0.sortorder AS sortorder_2,
  t0.tour_id AS tour_id_3,
  t0.poi_id AS poi_id_4
FROM
  poi_tour t0
WHERE
  t0.tour_id = ?
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.sortorder AS sortorder_2, t0.tour_id AS tour_id_3, t0.poi_id AS poi_id_4 FROM poi_tour t0 WHERE t0.tour_id = 9 ORDER BY t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.preview_image_url AS preview_image_url_2,
  t0.item_prensentation_aspectratio AS item_prensentation_aspectratio_3,
  t0.titlevalue AS titlevalue_4,
  t0.updated_at AS updated_at_5,
  t0.live AS live_6,
  t0.title_id AS title_id_7,
  t0.description_id AS description_id_8,
  t0.short_description_id AS short_description_id_9
FROM
  category t0
  INNER JOIN category_tour ON t0.id = category_tour.category_id
WHERE
  category_tour.tour_id = ?

SELECT t0.id AS id_1, t0.preview_image_url AS preview_image_url_2, t0.item_prensentation_aspectratio AS item_prensentation_aspectratio_3, t0.titlevalue AS titlevalue_4, t0.updated_at AS updated_at_5, t0.live AS live_6, t0.title_id AS title_id_7, t0.description_id AS description_id_8, t0.short_description_id AS short_description_id_9 FROM category t0 INNER JOIN category_tour ON t0.id = category_tour.category_id WHERE category_tour.tour_id = 9;

SELECT
  t0.id AS id_1,
  t0.text AS text_2,
  t0.audio_text_url AS audio_text_url_3
FROM
  audio_text_block t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.text AS text_2, t0.audio_text_url AS audio_text_url_3 FROM audio_text_block t0 WHERE t0.id = 415;

SELECT
  t0.id AS id_1,
  t0.text AS text_2,
  t0.audio_text_url AS audio_text_url_3
FROM
  audio_text_block t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.text AS text_2, t0.audio_text_url AS audio_text_url_3 FROM audio_text_block t0 WHERE t0.id = 416;

SELECT
  t0.id AS id_1,
  t0.text AS text_2,
  t0.audio_text_url AS audio_text_url_3
FROM
  audio_text_block t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.text AS text_2, t0.audio_text_url AS audio_text_url_3 FROM audio_text_block t0 WHERE t0.id = 417;

SELECT
  t0.id AS id_1,
  t0.text AS text_2,
  t0.audio_text_url AS audio_text_url_3
FROM
  audio_text_block t0
  INNER JOIN tourtextblockguidestart ON t0.id = tourtextblockguidestart.audio_text_block_id
WHERE
  tourtextblockguidestart.tour_id = ?

SELECT t0.id AS id_1, t0.text AS text_2, t0.audio_text_url AS audio_text_url_3 FROM audio_text_block t0 INNER JOIN tourtextblockguidestart ON t0.id = tourtextblockguidestart.audio_text_block_id WHERE tourtextblockguidestart.tour_id = 9;

SELECT
  t0.id AS id_1,
  t0.text AS text_2,
  t0.audio_text_url AS audio_text_url_3
FROM
  audio_text_block t0
  INNER JOIN tourtextblockguidecompletion ON t0.id = tourtextblockguidecompletion.audio_text_block_id
WHERE
  tourtextblockguidecompletion.tour_id = ?

SELECT t0.id AS id_1, t0.text AS text_2, t0.audio_text_url AS audio_text_url_3 FROM audio_text_block t0 INNER JOIN tourtextblockguidecompletion ON t0.id = tourtextblockguidecompletion.audio_text_block_id WHERE tourtextblockguidecompletion.tour_id = 9;

SELECT
  t0.id AS id_1,
  t0.text AS text_2,
  t0.audio_text_url AS audio_text_url_3
FROM
  audio_text_block t0
  INNER JOIN tourtextblockcompletion ON t0.id = tourtextblockcompletion.audio_text_block_id
WHERE
  tourtextblockcompletion.tour_id = ?

SELECT t0.id AS id_1, t0.text AS text_2, t0.audio_text_url AS audio_text_url_3 FROM audio_text_block t0 INNER JOIN tourtextblockcompletion ON t0.id = tourtextblockcompletion.audio_text_block_id WHERE tourtextblockcompletion.tour_id = 9;

SELECT
  t0.id AS id_1,
  t0.text AS text_2,
  t0.audio_text_url AS audio_text_url_3
FROM
  audio_text_block t0
  INNER JOIN tourtextblocknotification ON t0.id = tourtextblocknotification.audio_text_block_id
WHERE
  tourtextblocknotification.tour_id = ?

SELECT t0.id AS id_1, t0.text AS text_2, t0.audio_text_url AS audio_text_url_3 FROM audio_text_block t0 INNER JOIN tourtextblocknotification ON t0.id = tourtextblocknotification.audio_text_block_id WHERE tourtextblocknotification.tour_id = 9;

SELECT
  t0.id AS id_1,
  t0.sortorder AS sortorder_2,
  t0.category_id AS category_id_3,
  t0.poi_id AS poi_id_4
FROM
  category_poi t0
WHERE
  t0.poi_id = ?

SELECT t0.id AS id_1, t0.sortorder AS sortorder_2, t0.category_id AS category_id_3, t0.poi_id AS poi_id_4 FROM category_poi t0 WHERE t0.poi_id = 64;

SELECT
  t0.id AS id_1,
  t0.sortorder AS sortorder_2,
  t0.tour_id AS tour_id_3,
  t0.poi_id AS poi_id_4
FROM
  poi_tour t0
WHERE
  t0.poi_id = ?

SELECT t0.id AS id_1, t0.sortorder AS sortorder_2, t0.tour_id AS tour_id_3, t0.poi_id AS poi_id_4 FROM poi_tour t0 WHERE t0.poi_id = 64;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.text AS text_3,
  t0.audio_text_url AS audio_text_url_4,
  t0.video_url AS video_url_5,
  t0.image_url AS image_url_6,
  t0.audio_url AS audio_url_7
FROM
  poicontent t0
  INNER JOIN poicontent_poi ON t0.id = poicontent_poi.poicontent_id
WHERE
  poicontent_poi.poi_id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.text AS text_3, t0.audio_text_url AS audio_text_url_4, t0.video_url AS video_url_5, t0.image_url AS image_url_6, t0.audio_url AS audio_url_7 FROM poicontent t0 INNER JOIN poicontent_poi ON t0.id = poicontent_poi.poicontent_id WHERE poicontent_poi.poi_id = 64;

SELECT
  t0.id AS id_1,
  t0.preview_image_url AS preview_image_url_2,
  t0.longitude AS longitude_3,
  t0.latidtude AS latidtude_4,
  t0.visited_completion_distance AS visited_completion_distance_5,
  t0.activation_distance AS activation_distance_6,
  t0.notification_distance AS notification_distance_7,
  t0.notification_text AS notification_text_8,
  t0.guide_text_entry AS guide_text_entry_9,
  t0.audio_guide_text_entry_url AS audio_guide_text_entry_url_10,
  t0.guide_text_exit AS guide_text_exit_11,
  t0.audio_guide_text_exit_url AS audio_guide_text_exit_url_12,
  t0.custom_3_d_model_url AS custom_3_d_model_url_13,
  t0.completion_condition AS completion_condition_14,
  t0.titlevalue AS titlevalue_15,
  t0.model_offset_x AS model_offset_x_16,
  t0.model_offset_y AS model_offset_y_17,
  t0.model_offset_z AS model_offset_z_18,
  t0.live AS live_19,
  t0.updated_at AS updated_at_20,
  t0.custom_3_d_android_model_url AS custom_3_d_android_model_url_21,
  t0.custom_3_d_ios_model_url AS custom_3_d_ios_model_url_22,
  t0.video_url AS video_url_23,
  t0.title_id AS title_id_24,
  t0.description_id AS description_id_25,
  t0.short_description_id AS short_description_id_26,
  t0.treasure_name_id AS treasure_name_id_27
FROM
  poi t0
  INNER JOIN poicontent_poi ON t0.id = poicontent_poi.poi_id
WHERE
  poicontent_poi.poicontent_id = ?

SELECT t0.id AS id_1, t0.preview_image_url AS preview_image_url_2, t0.longitude AS longitude_3, t0.latidtude AS latidtude_4, t0.visited_completion_distance AS visited_completion_distance_5, t0.activation_distance AS activation_distance_6, t0.notification_distance AS notification_distance_7, t0.notification_text AS notification_text_8, t0.guide_text_entry AS guide_text_entry_9, t0.audio_guide_text_entry_url AS audio_guide_text_entry_url_10, t0.guide_text_exit AS guide_text_exit_11, t0.audio_guide_text_exit_url AS audio_guide_text_exit_url_12, t0.custom_3_d_model_url AS custom_3_d_model_url_13, t0.completion_condition AS completion_condition_14, t0.titlevalue AS titlevalue_15, t0.model_offset_x AS model_offset_x_16, t0.model_offset_y AS model_offset_y_17, t0.model_offset_z AS model_offset_z_18, t0.live AS live_19, t0.updated_at AS updated_at_20, t0.custom_3_d_android_model_url AS custom_3_d_android_model_url_21, t0.custom_3_d_ios_model_url AS custom_3_d_ios_model_url_22, t0.video_url AS video_url_23, t0.title_id AS title_id_24, t0.description_id AS description_id_25, t0.short_description_id AS short_description_id_26, t0.treasure_name_id AS treasure_name_id_27 FROM poi t0 INNER JOIN poicontent_poi ON t0.id = poicontent_poi.poi_id WHERE poicontent_poi.poicontent_id = 60;

SELECT
  t0.question AS question_1,
  t0.audio_text_url AS audio_text_url_2,
  t0.image_url AS image_url_3,
  t0.solution_index AS solution_index_4,
  t0.id AS id_5,
  t0.poi_id AS poi_id_6,
  t0.description_id AS description_id_7
FROM
  quiz_entry t0
WHERE
  t0.poi_id = ?

SELECT t0.question AS question_1, t0.audio_text_url AS audio_text_url_2, t0.image_url AS image_url_3, t0.solution_index AS solution_index_4, t0.id AS id_5, t0.poi_id AS poi_id_6, t0.description_id AS description_id_7 FROM quiz_entry t0 WHERE t0.poi_id = 64;

SELECT
  t0.id AS id_1,
  t0.text AS text_2,
  t0.audio_text_url AS audio_text_url_3
FROM
  audio_text_block t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.text AS text_2, t0.audio_text_url AS audio_text_url_3 FROM audio_text_block t0 WHERE t0.id = 335;

SELECT
  t0.id AS id_1,
  t0.text AS text_2,
  t0.audio_text_url AS audio_text_url_3
FROM
  audio_text_block t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.text AS text_2, t0.audio_text_url AS audio_text_url_3 FROM audio_text_block t0 WHERE t0.id = 336;

SELECT
  t0.id AS id_1,
  t0.text AS text_2,
  t0.audio_text_url AS audio_text_url_3
FROM
  audio_text_block t0
WHERE
  t0.id = ?