Symfony Profiler

[
  "params" => [
    "driver" => "pdo_sqlite"
    "idle_connection_ttl" => 600
    "host" => "localhost"
    "port" => null
    "user" => "root"
    "password" => null
    "driverOptions" => []
    "wrapperClass" => "App\Database\PrefixedConnection"
    "defaultTableOptions" => []
    "path" => "/var/www/studio/var/data_dev.db"
    "charset" => "utf8"
  ]
]

[
  "sql" => "SELECT t0.uid AS uid_1, t0.package_scopes AS package_scopes_2, t0.package_name AS package_name_3, t0.path AS path_4, t0.manifest_version AS manifest_version_5, t0.installed_version AS installed_version_6, t0.available_version AS available_version_7, t0.status AS status_8, t0.metadata AS metadata_9, t0.modified_at AS modified_at_10 FROM studio_extension_package t0 WHERE t0.status = ?"
  "params" => [
    1 => "active"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#786
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.uid AS uid_1, t0.package_scopes AS package_scopes_2, t0.package_name AS package_name_3, t0.path AS path_4, t0.manifest_version AS manifest_version_5, t0.installed_version AS installed_version_6, t0.available_version AS available_version_7, t0.status AS status_8, t0.metadata AS metadata_9, t0.modified_at AS modified_at_10 FROM studio_extension_package t0 WHERE t0.status = ?"
  "params" => [
    1 => "active"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#786
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT 1 FROM studio_config_entry LIMIT 1"
]

[
  "sql" => "SELECT 1 FROM studio_api_key LIMIT 1"
]

[
  "sql" => "SELECT 1 FROM studio_user_account LIMIT 1"
]

[
  "sql" => "SELECT value FROM studio_config_entry WHERE config_key = ?"
  "params" => [
    1 => "security.app_secret_fingerprints"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#786
      +name: "STRING"
    }
  ]
]

[
  "route" => "content_show"
  "route_parameters" => [
    "_route" => "content_show"
    "_controller" => "App\Controller\PublicContentController::show"
    "path" => "robots.txt"
  ]
  "request_uri" => "https://dev.aavion.media/robots.txt"
  "method" => "GET"
]

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

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "sql" => "SELECT value FROM studio_config_entry WHERE config_key = ?"
  "params" => [
    1 => "localization.default_language"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#786
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT value FROM studio_config_entry WHERE config_key = ?"
  "params" => [
    1 => "localization.default_language"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#786
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT value FROM studio_config_entry WHERE config_key = ?"
  "params" => [
    1 => "localization.route_prefixes_enabled"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#786
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT value FROM studio_config_entry WHERE config_key = ?"
  "params" => [
    1 => "localization.route_prefixes_enabled"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#786
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.uid AS uid_1, t0.slug AS slug_2, t0.status AS status_3, t0.parent_uid AS parent_uid_4, t0.sort_order AS sort_order_5, t0.custom_url AS custom_url_6, t0.redirect_target AS redirect_target_7, t0.schema_version AS schema_version_8, t0.version AS version_9, t0.available_languages AS available_languages_10, t0.available_variants AS available_variants_11, t0.visibility AS visibility_12, t0.acl_restrictions AS acl_restrictions_13, t0.view_min_level AS view_min_level_14, t0.view_group_identifiers AS view_group_identifiers_15, t0.edit_min_level AS edit_min_level_16, t0.edit_group_identifiers AS edit_group_identifiers_17, t0.manage_min_level AS manage_min_level_18, t0.manage_group_identifiers AS manage_group_identifiers_19, t0.metadata AS metadata_20, t0.schema_uid AS schema_uid_21, t0.active_revision_uid AS active_revision_uid_22 FROM studio_content_item t0 WHERE t0.custom_url = ? LIMIT 1"
  "params" => [
    1 => "/system/error-pages/403"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#786
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.uid AS uid_1, t0.slug AS slug_2, t0.status AS status_3, t0.parent_uid AS parent_uid_4, t0.sort_order AS sort_order_5, t0.custom_url AS custom_url_6, t0.redirect_target AS redirect_target_7, t0.schema_version AS schema_version_8, t0.version AS version_9, t0.available_languages AS available_languages_10, t0.available_variants AS available_variants_11, t0.visibility AS visibility_12, t0.acl_restrictions AS acl_restrictions_13, t0.view_min_level AS view_min_level_14, t0.view_group_identifiers AS view_group_identifiers_15, t0.edit_min_level AS edit_min_level_16, t0.edit_group_identifiers AS edit_group_identifiers_17, t0.manage_min_level AS manage_min_level_18, t0.manage_group_identifiers AS manage_group_identifiers_19, t0.metadata AS metadata_20, t0.schema_uid AS schema_uid_21, t0.active_revision_uid AS active_revision_uid_22 FROM studio_content_item t0 WHERE t0.slug = ? AND t0.parent_uid = ? LIMIT 1"
  "params" => [
    1 => "error-pages"
    2 => "system"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#786
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#786}
  ]
]

[
  "sql" => "SELECT uid FROM studio_site_menu WHERE identifier = ? AND active = 1"
  "params" => [
    1 => "main"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#786
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT value FROM studio_config_entry WHERE config_key = ?"
  "params" => [
    1 => "user.menu.enabled"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#786
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT value FROM studio_config_entry WHERE config_key = ?"
  "params" => [
    1 => "user.menu.sort_order"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#786
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT value FROM studio_config_entry WHERE config_key = ?"
  "params" => [
    1 => "user.menu.sort_order"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#786
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT value FROM studio_package_setting_entry WHERE package_name = ? AND setting_key = ?"
  "params" => [
    1 => "demo-module"
    2 => "demo.route"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#786
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#786}
  ]
]

[
  "sql" => "SELECT value FROM studio_config_entry WHERE config_key = ?"
  "params" => [
    1 => "localization.route_prefixes_enabled"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#786
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT value FROM studio_config_entry WHERE config_key = ?"
  "params" => [
    1 => "localization.route_prefixes_enabled"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#786
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT value FROM studio_package_setting_entry WHERE package_name = ? AND setting_key = ?"
  "params" => [
    1 => "demo-module"
    2 => "demo.route"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#786
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#786}
  ]
]

[
  "sql" => "SELECT value FROM studio_config_entry WHERE config_key = ?"
  "params" => [
    1 => "localization.route_prefixes_enabled"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#786
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT value FROM studio_package_setting_entry WHERE package_name = ? AND setting_key = ?"
  "params" => [
    1 => "demo-module"
    2 => "demo.route"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#786
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#786}
  ]
]

[
  "sql" => "SELECT value FROM studio_config_entry WHERE config_key = ?"
  "params" => [
    1 => "site.footer_copyright"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#786
      +name: "STRING"
    }
  ]
]

[
  "request_id" => "7f8f09637969b6dfe67dc5aa20a20c23"
  "method" => "GET"
  "path" => "/robots.txt"
  "requested_path" => "/robots.txt"
  "route" => "content_show"
  "resolved_route" => "content_show"
  "surface" => "public"
  "query_string" => ""
  "http_status" => 403
  "duration_ms" => 77
  "visitor_id" => "f3c890230da56fa084222967d05ff64d4200bc6226ed398b9868ca8779b42f32"
  "scheme" => "https"
  "host" => "dev.aavion.media"
  "ip" => "216.73.216.221"
  "client_ip" => "216.73.216.221"
  "proxy_client_ip" => "216.73.216.221"
  "proxy_ip_chain" => [
    "216.73.216.221"
  ]
  "user_agent" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])"
  "referrer" => "n/a"
  "referrer_host" => "n/a"
  "accept_language" => "n/a"
  "preferred_language" => "n/a"
  "request_content_type" => "n/a"
  "response_content_type" => "text/html"
  "response_size" => 13750
  "city" => "n/a"
  "state" => "n/a"
  "country" => "n/a"
  "continent" => "n/a"
]

[
  "sql" => "SELECT value FROM studio_config_entry WHERE config_key = ?"
  "params" => [
    1 => "statistics.enabled"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#786
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT value FROM studio_config_entry WHERE config_key = ?"
  "params" => [
    1 => "statistics.respect_do_not_track"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#786
      +name: "STRING"
    }
  ]
]

[
  "sql" => "INSERT INTO studio_access_statistic_event (uid, occurred_at, request_id, visitor_id, method, path, requested_path, route, resolved_route, surface, http_status, duration_ms, browser_family, device_type, is_bot, do_not_track, referrer_host, preferred_language, request_content_type, response_content_type, response_size, city, state, country, continent, metadata) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => "61083636-9293-47fd-b2b6-4d1d869e50c0"
    2 => "2026-09-16 07:45:03"
    3 => "7f8f09637969b6dfe67dc5aa20a20c23"
    4 => "f3c890230da56fa084222967d05ff64d4200bc6226ed398b9868ca8779b42f32"
    5 => "GET"
    6 => "/robots.txt"
    7 => "/robots.txt"
    8 => "content_show"
    9 => "content_show"
    10 => "public"
    11 => 403
    12 => 78
    13 => "bot"
    14 => "bot"
    15 => true
    16 => false
    17 => "n/a"
    18 => "n/a"
    19 => "n/a"
    20 => "text/html"
    21 => 13750
    22 => "n/a"
    23 => "n/a"
    24 => "n/a"
    25 => "n/a"
    26 => "{"query_present":false}"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#786
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#786}
    3 => Doctrine\DBAL\ParameterType {#786}
    4 => Doctrine\DBAL\ParameterType {#786}
    5 => Doctrine\DBAL\ParameterType {#786}
    6 => Doctrine\DBAL\ParameterType {#786}
    7 => Doctrine\DBAL\ParameterType {#786}
    8 => Doctrine\DBAL\ParameterType {#786}
    9 => Doctrine\DBAL\ParameterType {#786}
    10 => Doctrine\DBAL\ParameterType {#786}
    11 => Doctrine\DBAL\ParameterType {#786}
    12 => Doctrine\DBAL\ParameterType {#786}
    13 => Doctrine\DBAL\ParameterType {#786}
    14 => Doctrine\DBAL\ParameterType {#786}
    15 => Doctrine\DBAL\ParameterType {#786}
    16 => Doctrine\DBAL\ParameterType {#786}
    17 => Doctrine\DBAL\ParameterType {#786}
    18 => Doctrine\DBAL\ParameterType {#786}
    19 => Doctrine\DBAL\ParameterType {#786}
    20 => Doctrine\DBAL\ParameterType {#786}
    21 => Doctrine\DBAL\ParameterType {#786}
    22 => Doctrine\DBAL\ParameterType {#786}
    23 => Doctrine\DBAL\ParameterType {#786}
    24 => Doctrine\DBAL\ParameterType {#786}
    25 => Doctrine\DBAL\ParameterType {#786}
    26 => Doctrine\DBAL\ParameterType {#786}
  ]
]

[
  "sql" => "DELETE FROM studio_access_statistic_event WHERE occurred_at < ?"
  "params" => [
    1 => "2026-06-16 07:45:03"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#786
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT COUNT(*) FROM studio_messenger_messages WHERE queue_name = ? AND delivered_at IS NULL AND available_at <= ?"
  "params" => [
    1 => "default"
    2 => "2026-09-16 07:45:03"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#786
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#786}
  ]
]

[
  "sql" => "SELECT value FROM studio_config_entry WHERE config_key = ?"
  "params" => [
    1 => "scheduler.enabled"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#786
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT value FROM studio_config_entry WHERE config_key = ?"
  "params" => [
    1 => "scheduler.web_trigger_enabled"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#786
      +name: "STRING"
    }
  ]
]