Symfony Profiler

[
  "route" => "_api_/studio_get_collection"
  "route_parameters" => [
    "_route" => "_api_/studio_get_collection"
    "_controller" => "api_platform.action.placeholder"
    "_format" => null
    "_stateless" => null
    "_api_resource_class" => "App\Entity\Studio"
    "_api_operation_name" => "_api_/studio_get_collection"
  ]
  "request_uri" => "https://lucky-api.hu-ku.com/api/studio?geschlossen=0&inPlanung=0&slug=oebisfelde"
  "method" => "GET"
]

[
  "firewall_name" => "api"
  "authenticators" => 1
]

[
  "firewall_name" => "api"
  "authenticator" => "League\Bundle\OAuth2ServerBundle\Security\Authenticator\OAuth2Authenticator"
]

[
  "firewall_name" => "api"
  "authenticator" => "League\Bundle\OAuth2ServerBundle\Security\Authenticator\OAuth2Authenticator"
]

[
  "params" => [
    "url" => "<redacted>"
    "driver" => "pdo_mysql"
    "host" => "localhost"
    "port" => 3306
    "user" => "d03d9acc"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "d03d9acc"
    "serverVersion" => "mariadb-10.3.36"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "oebisfelde"
    2 => "0"
    3 => "0"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "event" => "kernel.request"
  "listener" => "Nelmio\SecurityBundle\EventListener\ForcedSslListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Nelmio\CorsBundle\EventListener\CorsListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\AddFormatListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\QueryParameterValidateListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\ReadListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\DenyAccessListener::onSecurity"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\DeserializeListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\DenyAccessListener::onSecurityPostDenormalize"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\Bundle\EventListener\SwaggerUiListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Scheb\TwoFactorBundle\Security\TwoFactor\Event\TwoFactorFormListener::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\IsGrantedListener::onKernelControllerArguments"
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 8
  ]
  "types" => [
    1 => 1
  ]
]

[
  "event" => "kernel.view"
  "listener" => "ApiPlatform\Symfony\EventListener\ValidateListener::onKernelView"
]

[
  "event" => "kernel.view"
  "listener" => "ApiPlatform\Symfony\EventListener\DenyAccessListener::onSecurityPostValidation"
]

[
  "event" => "kernel.view"
  "listener" => "ApiPlatform\Symfony\EventListener\WriteListener::onKernelView"
]

[
  "event" => "kernel.view"
  "listener" => "ApiPlatform\Symfony\EventListener\SerializeListener::onKernelView"
]

[
  "event" => "kernel.view"
  "listener" => "ApiPlatform\Symfony\EventListener\RespondListener::onKernelView"
]

[
  "event" => "kernel.view"
  "listener" => "ApiPlatform\Symfony\EventListener\RespondListener::onKernelView"
]

[
  "event" => "kernel.view"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelView"
]

[
  "event" => "kernel.view"
  "listener" => "Symfony\Bridge\Twig\EventListener\TemplateAttributeListener::onKernelView"
]

[
  "event" => "kernel.response"
  "listener" => "Scheb\TwoFactorBundle\Security\TwoFactor\Provider\TwoFactorProviderPreparationListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Nelmio\CorsBundle\EventListener\CorsListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "ApiPlatform\Hydra\EventListener\AddLinkHeaderListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Nelmio\SecurityBundle\EventListener\ContentTypeListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Nelmio\SecurityBundle\EventListener\ForcedSslListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Nelmio\SecurityBundle\EventListener\ReferrerPolicyListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\RememberMe\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Nelmio\SecurityBundle\EventListener\ClickjackingListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Nelmio\SecurityBundle\EventListener\XssProtectionListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "ApiPlatform\HttpCache\EventListener\AddHeadersListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Nelmio\CorsBundle\EventListener\CacheableResponseVaryListener::onResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::removeCspHeader"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\WebpackEncoreBundle\EventListener\ResetAssetsEventListener::resetAssets"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"
]