Symfony Profiler

SELECT
  s0_.id AS id_0,
  s0_.bezeichnung AS bezeichnung_1,
  s0_.slug AS slug_2,
  s0_.in_planung AS in_planung_3,
  s0_.geschlossen AS geschlossen_4,
  s0_.created_at AS created_at_5,
  s0_.website AS website_6,
  s0_.telefon AS telefon_7,
  s0_.mobil AS mobil_8,
  s0_.fax AS fax_9,
  s0_.plz AS plz_10,
  s0_.ort AS ort_11,
  s0_.strasse AS strasse_12,
  s0_.email AS email_13,
  s0_.position AS position_14,
  s0_.leistungen AS leistungen_15,
  g1_.id AS id_16,
  g1_.geo_lon AS geo_lon_17,
  g1_.geo_lat AS geo_lat_18,
  g1_.geo_json AS geo_json_19,
  g1_.created_at AS created_at_20,
  g1_.display_name AS display_name_21,
  g1_.bounding_box AS bounding_box_22,
  g1_.importance AS importance_23,
  g1_.osm_id AS osm_id_24,
  g1_.place_id AS place_id_25,
  g1_.osm_type AS osm_type_26,
  s2_.id AS id_27,
  s2_.content AS content_28,
  s2_.impressum AS impressum_29,
  s2_.created_at AS created_at_30,
  s2_.custom_fields AS custom_fields_31,
  s3_.id AS id_32,
  s3_.montag AS montag_33,
  s3_.dienstag AS dienstag_34,
  s3_.mittwoch AS mittwoch_35,
  s3_.donnerstag AS donnerstag_36,
  s3_.freitag AS freitag_37,
  s3_.samstag AS samstag_38,
  s3_.sonntag AS sonntag_39,
  s3_.support_active AS support_active_40,
  s3_.open247 AS open247_41,
  s3_.info AS info_42,
  s3_.bezeichnung AS bezeichnung_43,
  s3_.text247 AS text247_44,
  s3_.created_at AS created_at_45,
  o4_.id AS id_46,
  o4_.montag AS montag_47,
  o4_.dienstag AS dienstag_48,
  o4_.mittwoch AS mittwoch_49,
  o4_.donnerstag AS donnerstag_50,
  o4_.freitag AS freitag_51,
  o4_.samstag AS samstag_52,
  o4_.sonntag AS sonntag_53,
  o4_.active AS active_54,
  o4_.open247 AS open247_55,
  o4_.info AS info_56,
  o4_.bezeichnung AS bezeichnung_57,
  o4_.text247 AS text247_58,
  o4_.created_at AS created_at_59,
  s5_.id AS id_60,
  s5_.type AS type_61,
  s5_.slug AS slug_62,
  s5_.seo_content AS seo_content_63,
  s5_.seo_title AS seo_title_64,
  s5_.created_at AS created_at_65,
  s5_.no_index AS no_index_66,
  s5_.no_follow AS no_follow_67,
  s5_.fb_aktiv AS fb_aktiv_68,
  s5_.x_aktiv AS x_aktiv_69,
  s5_.og_type AS og_type_70,
  s5_.og_title AS og_title_71,
  s5_.og_content AS og_content_72,
  s5_.og_image AS og_image_73,
  s5_.x_type AS x_type_74,
  s5_.x_site AS x_site_75,
  s5_.x_creator AS x_creator_76,
  s5_.fb_app_id AS fb_app_id_77,
  s5_.fb_admins AS fb_admins_78,
  s5_.seo_separator AS seo_separator_79,
  s5_.title_prefix AS title_prefix_80,
  s5_.title_suffix AS title_suffix_81,
  s6_.id AS id_82,
  s6_.cover_img AS cover_img_83,
  s6_.filename AS filename_84,
  s6_.originalname AS originalname_85,
  s6_.mime_type AS mime_type_86,
  s6_.file_size AS file_size_87,
  s6_.file_size_convert AS file_size_convert_88,
  s6_.created_at AS created_at_89,
  s6_.cover_img_id AS cover_img_id_90,
  s7_.id AS id_91,
  s7_.original AS original_92,
  s7_.filename AS filename_93,
  s7_.size AS size_94,
  s7_.type AS type_95,
  s7_.handle AS handle_96,
  s7_.mime_type AS mime_type_97,
  s7_.title AS title_98,
  s7_.alt AS alt_99,
  s7_.description AS description_100,
  s7_.custom AS custom_101,
  s7_.created_at AS created_at_102,
  s7_.position AS position_103,
  n8_.id AS id_104,
  n8_.title AS title_105,
  n8_.quelle AS quelle_106,
  n8_.type AS type_107,
  n8_.content AS content_108,
  n8_.active AS active_109,
  n8_.news_date AS news_date_110,
  n8_.created_at AS created_at_111,
  n8_.cover_id AS cover_id_112,
  s9_.id AS id_113,
  s9_.original AS original_114,
  s9_.filename AS filename_115,
  s9_.size AS size_116,
  s9_.type AS type_117,
  s9_.handle AS handle_118,
  s9_.mime_type AS mime_type_119,
  s9_.title AS title_120,
  s9_.alt AS alt_121,
  s9_.description AS description_122,
  s9_.custom AS custom_123,
  s9_.created_at AS created_at_124,
  s9_.position AS position_125,
  s0_.franchise_nehmer_id AS franchise_nehmer_id_126,
  s0_.geodaten AS geodaten_127,
  s0_.studioContent AS studioContent_128,
  s0_.zeiten AS zeiten_129,
  s0_.saunaZeiten AS saunaZeiten_130,
  s0_.accessZeiten AS accessZeiten_131,
  s0_.supportZeiten AS supportZeiten_132,
  s0_.openingTimes AS openingTimes_133,
  s0_.siteSeo AS siteSeo_134,
  s0_.studioKurse AS studioKurse_135,
  s6_.studio_id AS studio_id_136,
  s7_.studio_id AS studio_id_137,
  s7_.news_id AS news_id_138,
  n8_.category_id AS category_id_139,
  n8_.studio_id AS studio_id_140,
  s9_.studio_id AS studio_id_141,
  s9_.news_id AS news_id_142
FROM
  studio s0_
  LEFT JOIN geo_data g1_ ON s0_.geodaten = g1_.id
  LEFT JOIN studio_content s2_ ON s0_.studioContent = s2_.id
  LEFT JOIN support_zeiten s3_ ON s0_.supportZeiten = s3_.id
  LEFT JOIN opening_times o4_ ON s0_.openingTimes = o4_.id
  LEFT JOIN site_seo s5_ ON s0_.siteSeo = s5_.id
  LEFT JOIN studio_video s6_ ON s0_.id = s6_.studio_id
  LEFT JOIN studio_media s7_ ON s0_.id = s7_.studio_id
  LEFT JOIN news n8_ ON s0_.id = n8_.studio_id
  LEFT JOIN studio_media s9_ ON n8_.id = s9_.news_id
WHERE
  s0_.slug = ?
  AND s0_.in_planung = ?
  AND s0_.geschlossen = ?
ORDER BY
  s0_.id ASC,
  s7_.position ASC
LIMIT
  999999

SELECT s0_.id AS id_0, s0_.bezeichnung AS bezeichnung_1, s0_.slug AS slug_2, s0_.in_planung AS in_planung_3, s0_.geschlossen AS geschlossen_4, s0_.created_at AS created_at_5, s0_.website AS website_6, s0_.telefon AS telefon_7, s0_.mobil AS mobil_8, s0_.fax AS fax_9, s0_.plz AS plz_10, s0_.ort AS ort_11, s0_.strasse AS strasse_12, s0_.email AS email_13, s0_.position AS position_14, s0_.leistungen AS leistungen_15, g1_.id AS id_16, g1_.geo_lon AS geo_lon_17, g1_.geo_lat AS geo_lat_18, g1_.geo_json AS geo_json_19, g1_.created_at AS created_at_20, g1_.display_name AS display_name_21, g1_.bounding_box AS bounding_box_22, g1_.importance AS importance_23, g1_.osm_id AS osm_id_24, g1_.place_id AS place_id_25, g1_.osm_type AS osm_type_26, s2_.id AS id_27, s2_.content AS content_28, s2_.impressum AS impressum_29, s2_.created_at AS created_at_30, s2_.custom_fields AS custom_fields_31, s3_.id AS id_32, s3_.montag AS montag_33, s3_.dienstag AS dienstag_34, s3_.mittwoch AS mittwoch_35, s3_.donnerstag AS donnerstag_36, s3_.freitag AS freitag_37, s3_.samstag AS samstag_38, s3_.sonntag AS sonntag_39, s3_.support_active AS support_active_40, s3_.open247 AS open247_41, s3_.info AS info_42, s3_.bezeichnung AS bezeichnung_43, s3_.text247 AS text247_44, s3_.created_at AS created_at_45, o4_.id AS id_46, o4_.montag AS montag_47, o4_.dienstag AS dienstag_48, o4_.mittwoch AS mittwoch_49, o4_.donnerstag AS donnerstag_50, o4_.freitag AS freitag_51, o4_.samstag AS samstag_52, o4_.sonntag AS sonntag_53, o4_.active AS active_54, o4_.open247 AS open247_55, o4_.info AS info_56, o4_.bezeichnung AS bezeichnung_57, o4_.text247 AS text247_58, o4_.created_at AS created_at_59, s5_.id AS id_60, s5_.type AS type_61, s5_.slug AS slug_62, s5_.seo_content AS seo_content_63, s5_.seo_title AS seo_title_64, s5_.created_at AS created_at_65, s5_.no_index AS no_index_66, s5_.no_follow AS no_follow_67, s5_.fb_aktiv AS fb_aktiv_68, s5_.x_aktiv AS x_aktiv_69, s5_.og_type AS og_type_70, s5_.og_title AS og_title_71, s5_.og_content AS og_content_72, s5_.og_image AS og_image_73, s5_.x_type AS x_type_74, s5_.x_site AS x_site_75, s5_.x_creator AS x_creator_76, s5_.fb_app_id AS fb_app_id_77, s5_.fb_admins AS fb_admins_78, s5_.seo_separator AS seo_separator_79, s5_.title_prefix AS title_prefix_80, s5_.title_suffix AS title_suffix_81, s6_.id AS id_82, s6_.cover_img AS cover_img_83, s6_.filename AS filename_84, s6_.originalname AS originalname_85, s6_.mime_type AS mime_type_86, s6_.file_size AS file_size_87, s6_.file_size_convert AS file_size_convert_88, s6_.created_at AS created_at_89, s6_.cover_img_id AS cover_img_id_90, s7_.id AS id_91, s7_.original AS original_92, s7_.filename AS filename_93, s7_.size AS size_94, s7_.type AS type_95, s7_.handle AS handle_96, s7_.mime_type AS mime_type_97, s7_.title AS title_98, s7_.alt AS alt_99, s7_.description AS description_100, s7_.custom AS custom_101, s7_.created_at AS created_at_102, s7_.position AS position_103, n8_.id AS id_104, n8_.title AS title_105, n8_.quelle AS quelle_106, n8_.type AS type_107, n8_.content AS content_108, n8_.active AS active_109, n8_.news_date AS news_date_110, n8_.created_at AS created_at_111, n8_.cover_id AS cover_id_112, s9_.id AS id_113, s9_.original AS original_114, s9_.filename AS filename_115, s9_.size AS size_116, s9_.type AS type_117, s9_.handle AS handle_118, s9_.mime_type AS mime_type_119, s9_.title AS title_120, s9_.alt AS alt_121, s9_.description AS description_122, s9_.custom AS custom_123, s9_.created_at AS created_at_124, s9_.position AS position_125, s0_.franchise_nehmer_id AS franchise_nehmer_id_126, s0_.geodaten AS geodaten_127, s0_.studioContent AS studioContent_128, s0_.zeiten AS zeiten_129, s0_.saunaZeiten AS saunaZeiten_130, s0_.accessZeiten AS accessZeiten_131, s0_.supportZeiten AS supportZeiten_132, s0_.openingTimes AS openingTimes_133, s0_.siteSeo AS siteSeo_134, s0_.studioKurse AS studioKurse_135, s6_.studio_id AS studio_id_136, s7_.studio_id AS studio_id_137, s7_.news_id AS news_id_138, n8_.category_id AS category_id_139, n8_.studio_id AS studio_id_140, s9_.studio_id AS studio_id_141, s9_.news_id AS news_id_142 FROM studio s0_ LEFT JOIN geo_data g1_ ON s0_.geodaten = g1_.id LEFT JOIN studio_content s2_ ON s0_.studioContent = s2_.id LEFT JOIN support_zeiten s3_ ON s0_.supportZeiten = s3_.id LEFT JOIN opening_times o4_ ON s0_.openingTimes = o4_.id LEFT JOIN site_seo s5_ ON s0_.siteSeo = s5_.id LEFT JOIN studio_video s6_ ON s0_.id = s6_.studio_id LEFT JOIN studio_media s7_ ON s0_.id = s7_.studio_id LEFT JOIN news n8_ ON s0_.id = n8_.studio_id LEFT JOIN studio_media s9_ ON n8_.id = s9_.news_id WHERE s0_.slug = 'oebisfelde' AND s0_.in_planung = '0' AND s0_.geschlossen = '0' ORDER BY s0_.id ASC, s7_.position ASC LIMIT 999999;

SELECT
  t0.id AS id_1,
  t0.montag AS montag_2,
  t0.dienstag AS dienstag_3,
  t0.mittwoch AS mittwoch_4,
  t0.donnerstag AS donnerstag_5,
  t0.freitag AS freitag_6,
  t0.samstag AS samstag_7,
  t0.sonntag AS sonntag_8,
  t0.sauna_active AS sauna_active_9,
  t0.open247 AS open247_10,
  t0.info AS info_11,
  t0.bezeichnung AS bezeichnung_12,
  t0.text247 AS text247_13,
  t0.created_at AS created_at_14,
  t15.id AS id_16,
  t15.bezeichnung AS bezeichnung_17,
  t15.slug AS slug_18,
  t15.in_planung AS in_planung_19,
  t15.geschlossen AS geschlossen_20,
  t15.created_at AS created_at_21,
  t15.website AS website_22,
  t15.telefon AS telefon_23,
  t15.mobil AS mobil_24,
  t15.fax AS fax_25,
  t15.plz AS plz_26,
  t15.ort AS ort_27,
  t15.strasse AS strasse_28,
  t15.email AS email_29,
  t15.position AS position_30,
  t15.leistungen AS leistungen_31,
  t15.franchise_nehmer_id AS franchise_nehmer_id_32,
  t15.geodaten AS geodaten_33,
  t15.studioContent AS studioContent_34,
  t15.zeiten AS zeiten_35,
  t15.saunaZeiten AS saunaZeiten_36,
  t15.accessZeiten AS accessZeiten_37,
  t15.supportZeiten AS supportZeiten_38,
  t15.openingTimes AS openingTimes_39,
  t15.siteSeo AS siteSeo_40,
  t15.studioKurse AS studioKurse_41
FROM
  sauna_zeiten t0
  LEFT JOIN studio t15 ON t15.saunaZeiten = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.montag AS montag_2, t0.dienstag AS dienstag_3, t0.mittwoch AS mittwoch_4, t0.donnerstag AS donnerstag_5, t0.freitag AS freitag_6, t0.samstag AS samstag_7, t0.sonntag AS sonntag_8, t0.sauna_active AS sauna_active_9, t0.open247 AS open247_10, t0.info AS info_11, t0.bezeichnung AS bezeichnung_12, t0.text247 AS text247_13, t0.created_at AS created_at_14, t15.id AS id_16, t15.bezeichnung AS bezeichnung_17, t15.slug AS slug_18, t15.in_planung AS in_planung_19, t15.geschlossen AS geschlossen_20, t15.created_at AS created_at_21, t15.website AS website_22, t15.telefon AS telefon_23, t15.mobil AS mobil_24, t15.fax AS fax_25, t15.plz AS plz_26, t15.ort AS ort_27, t15.strasse AS strasse_28, t15.email AS email_29, t15.position AS position_30, t15.leistungen AS leistungen_31, t15.franchise_nehmer_id AS franchise_nehmer_id_32, t15.geodaten AS geodaten_33, t15.studioContent AS studioContent_34, t15.zeiten AS zeiten_35, t15.saunaZeiten AS saunaZeiten_36, t15.accessZeiten AS accessZeiten_37, t15.supportZeiten AS supportZeiten_38, t15.openingTimes AS openingTimes_39, t15.siteSeo AS siteSeo_40, t15.studioKurse AS studioKurse_41 FROM sauna_zeiten t0 LEFT JOIN studio t15 ON t15.saunaZeiten = t0.id WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.montag AS montag_2,
  t0.dienstag AS dienstag_3,
  t0.mittwoch AS mittwoch_4,
  t0.donnerstag AS donnerstag_5,
  t0.freitag AS freitag_6,
  t0.samstag AS samstag_7,
  t0.sonntag AS sonntag_8,
  t0.access_active AS access_active_9,
  t0.open247 AS open247_10,
  t0.info AS info_11,
  t0.bezeichnung AS bezeichnung_12,
  t0.text247 AS text247_13,
  t0.created_at AS created_at_14,
  t15.id AS id_16,
  t15.bezeichnung AS bezeichnung_17,
  t15.slug AS slug_18,
  t15.in_planung AS in_planung_19,
  t15.geschlossen AS geschlossen_20,
  t15.created_at AS created_at_21,
  t15.website AS website_22,
  t15.telefon AS telefon_23,
  t15.mobil AS mobil_24,
  t15.fax AS fax_25,
  t15.plz AS plz_26,
  t15.ort AS ort_27,
  t15.strasse AS strasse_28,
  t15.email AS email_29,
  t15.position AS position_30,
  t15.leistungen AS leistungen_31,
  t15.franchise_nehmer_id AS franchise_nehmer_id_32,
  t15.geodaten AS geodaten_33,
  t15.studioContent AS studioContent_34,
  t15.zeiten AS zeiten_35,
  t15.saunaZeiten AS saunaZeiten_36,
  t15.accessZeiten AS accessZeiten_37,
  t15.supportZeiten AS supportZeiten_38,
  t15.openingTimes AS openingTimes_39,
  t15.siteSeo AS siteSeo_40,
  t15.studioKurse AS studioKurse_41
FROM
  access_zeiten t0
  LEFT JOIN studio t15 ON t15.accessZeiten = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.montag AS montag_2, t0.dienstag AS dienstag_3, t0.mittwoch AS mittwoch_4, t0.donnerstag AS donnerstag_5, t0.freitag AS freitag_6, t0.samstag AS samstag_7, t0.sonntag AS sonntag_8, t0.access_active AS access_active_9, t0.open247 AS open247_10, t0.info AS info_11, t0.bezeichnung AS bezeichnung_12, t0.text247 AS text247_13, t0.created_at AS created_at_14, t15.id AS id_16, t15.bezeichnung AS bezeichnung_17, t15.slug AS slug_18, t15.in_planung AS in_planung_19, t15.geschlossen AS geschlossen_20, t15.created_at AS created_at_21, t15.website AS website_22, t15.telefon AS telefon_23, t15.mobil AS mobil_24, t15.fax AS fax_25, t15.plz AS plz_26, t15.ort AS ort_27, t15.strasse AS strasse_28, t15.email AS email_29, t15.position AS position_30, t15.leistungen AS leistungen_31, t15.franchise_nehmer_id AS franchise_nehmer_id_32, t15.geodaten AS geodaten_33, t15.studioContent AS studioContent_34, t15.zeiten AS zeiten_35, t15.saunaZeiten AS saunaZeiten_36, t15.accessZeiten AS accessZeiten_37, t15.supportZeiten AS supportZeiten_38, t15.openingTimes AS openingTimes_39, t15.siteSeo AS siteSeo_40, t15.studioKurse AS studioKurse_41 FROM access_zeiten t0 LEFT JOIN studio t15 ON t15.accessZeiten = t0.id WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.montag AS montag_2,
  t0.dienstag AS dienstag_3,
  t0.mittwoch AS mittwoch_4,
  t0.donnerstag AS donnerstag_5,
  t0.freitag AS freitag_6,
  t0.samstag AS samstag_7,
  t0.sonntag AS sonntag_8,
  t0.created_at AS created_at_9,
  t10.id AS id_11,
  t10.bezeichnung AS bezeichnung_12,
  t10.slug AS slug_13,
  t10.in_planung AS in_planung_14,
  t10.geschlossen AS geschlossen_15,
  t10.created_at AS created_at_16,
  t10.website AS website_17,
  t10.telefon AS telefon_18,
  t10.mobil AS mobil_19,
  t10.fax AS fax_20,
  t10.plz AS plz_21,
  t10.ort AS ort_22,
  t10.strasse AS strasse_23,
  t10.email AS email_24,
  t10.position AS position_25,
  t10.leistungen AS leistungen_26,
  t10.franchise_nehmer_id AS franchise_nehmer_id_27,
  t10.geodaten AS geodaten_28,
  t10.studioContent AS studioContent_29,
  t10.zeiten AS zeiten_30,
  t10.saunaZeiten AS saunaZeiten_31,
  t10.accessZeiten AS accessZeiten_32,
  t10.supportZeiten AS supportZeiten_33,
  t10.openingTimes AS openingTimes_34,
  t10.siteSeo AS siteSeo_35,
  t10.studioKurse AS studioKurse_36
FROM
  studio_kurse t0
  LEFT JOIN studio t10 ON t10.studioKurse = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.montag AS montag_2, t0.dienstag AS dienstag_3, t0.mittwoch AS mittwoch_4, t0.donnerstag AS donnerstag_5, t0.freitag AS freitag_6, t0.samstag AS samstag_7, t0.sonntag AS sonntag_8, t0.created_at AS created_at_9, t10.id AS id_11, t10.bezeichnung AS bezeichnung_12, t10.slug AS slug_13, t10.in_planung AS in_planung_14, t10.geschlossen AS geschlossen_15, t10.created_at AS created_at_16, t10.website AS website_17, t10.telefon AS telefon_18, t10.mobil AS mobil_19, t10.fax AS fax_20, t10.plz AS plz_21, t10.ort AS ort_22, t10.strasse AS strasse_23, t10.email AS email_24, t10.position AS position_25, t10.leistungen AS leistungen_26, t10.franchise_nehmer_id AS franchise_nehmer_id_27, t10.geodaten AS geodaten_28, t10.studioContent AS studioContent_29, t10.zeiten AS zeiten_30, t10.saunaZeiten AS saunaZeiten_31, t10.accessZeiten AS accessZeiten_32, t10.supportZeiten AS supportZeiten_33, t10.openingTimes AS openingTimes_34, t10.siteSeo AS siteSeo_35, t10.studioKurse AS studioKurse_36 FROM studio_kurse t0 LEFT JOIN studio t10 ON t10.studioKurse = t0.id WHERE t0.id = 8;