Symfony Profiler

[
  "route" => "app_events_list"
  "route_parameters" => [
    "_route" => "app_events_list"
    "_controller" => "App\Controller\EventController::events"
  ]
  "request_uri" => "https://event.endocrincentr.ru/events"
  "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"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "u_events"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "db_events"
    "serverVersion" => "10.11.2-MariaDB"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, start_at_9 FROM (SELECT e0_.id AS id_0, e0_.slug AS slug_1, e0_.program_name AS program_name_2, e0_.program_original_name AS program_original_name_3, e0_.program_mime_type AS program_mime_type_4, e0_.program_size AS program_size_5, e0_.program_updated_at AS program_updated_at_6, e0_.is_activated AS is_activated_7, e0_.is_enabled AS is_enabled_8, e0_.start_at AS start_at_9, e0_.end_at AS end_at_10, e0_.status AS status_11, e0_.format AS format_12, e0_.created_at AS created_at_13, e0_.is_show_chat AS is_show_chat_14, e0_.is_registration AS is_registration_15, e0_.is_calendar AS is_calendar_16, e0_.is_nmo AS is_nmo_17, e0_.is_show_slider AS is_show_slider_18, e0_.image_name AS image_name_19, e0_.image_original_name AS image_original_name_20, e0_.image_mime_type AS image_mime_type_21, e0_.image_size AS image_size_22, e0_.image_updated_at AS image_updated_at_23, e0_.card_image_name AS card_image_name_24, e0_.card_image_original_name AS card_image_original_name_25, e0_.card_image_mime_type AS card_image_mime_type_26, e0_.card_image_size AS card_image_size_27, e0_.card_image_updated_at AS card_image_updated_at_28, e1_.id AS id_29, e1_.title AS title_30, e1_.seo_title AS seo_title_31, e1_.seo_description AS seo_description_32, e1_.content AS content_33, l2_.id AS id_34, l2_.name AS name_35, s3_.id AS id_36, s3_.name AS name_37, s3_.type AS type_38 FROM event e0_ LEFT JOIN event_translate e1_ ON e0_.id = e1_.event_id LEFT JOIN language l2_ ON e1_.lang_id = l2_.id LEFT JOIN event_specialty e4_ ON e0_.id = e4_.event_id LEFT JOIN specialty s3_ ON s3_.id = e4_.specialty_id WHERE e0_.is_enabled = ? AND e0_.is_activated = ? AND ((e0_.start_at >= ? OR (e0_.end_at IS NOT NULL AND e0_.end_at >= ?))) AND e0_.status IN (?, ?, ?)) dctrn_result_inner ORDER BY start_at_9 ASC, id_0 ASC) dctrn_result LIMIT 10"
  "params" => [
    1 => 1
    2 => 1
    3 => "2026-05-22 14:00:09"
    4 => "2026-05-22 14:00:09"
    5 => "active"
    6 => "online"
    7 => "postponed"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1342
      +name: "BOOLEAN"
    }
    2 => Doctrine\DBAL\ParameterType {#1342}
    3 => Doctrine\DBAL\ParameterType {#1275
      +name: "STRING"
    }
    4 => Doctrine\DBAL\ParameterType {#1275}
    5 => Doctrine\DBAL\ParameterType {#1275}
    6 => Doctrine\DBAL\ParameterType {#1275}
    7 => Doctrine\DBAL\ParameterType {#1275}
  ]
]

[
  "sql" => "SELECT e0_.id AS id_0, e0_.slug AS slug_1, e0_.program_name AS program_name_2, e0_.program_original_name AS program_original_name_3, e0_.program_mime_type AS program_mime_type_4, e0_.program_size AS program_size_5, e0_.program_updated_at AS program_updated_at_6, e0_.is_activated AS is_activated_7, e0_.is_enabled AS is_enabled_8, e0_.start_at AS start_at_9, e0_.end_at AS end_at_10, e0_.status AS status_11, e0_.format AS format_12, e0_.created_at AS created_at_13, e0_.is_show_chat AS is_show_chat_14, e0_.is_registration AS is_registration_15, e0_.is_calendar AS is_calendar_16, e0_.is_nmo AS is_nmo_17, e0_.is_show_slider AS is_show_slider_18, e0_.image_name AS image_name_19, e0_.image_original_name AS image_original_name_20, e0_.image_mime_type AS image_mime_type_21, e0_.image_size AS image_size_22, e0_.image_updated_at AS image_updated_at_23, e0_.card_image_name AS card_image_name_24, e0_.card_image_original_name AS card_image_original_name_25, e0_.card_image_mime_type AS card_image_mime_type_26, e0_.card_image_size AS card_image_size_27, e0_.card_image_updated_at AS card_image_updated_at_28, e1_.id AS id_29, e1_.title AS title_30, e1_.seo_title AS seo_title_31, e1_.seo_description AS seo_description_32, e1_.content AS content_33, l2_.id AS id_34, l2_.name AS name_35, s3_.id AS id_36, s3_.name AS name_37, s3_.type AS type_38, e0_.poll_id AS poll_id_39, e0_.event_group_id AS event_group_id_40, e1_.lang_id AS lang_id_41, e1_.event_id AS event_id_42 FROM event e0_ LEFT JOIN event_translate e1_ ON e0_.id = e1_.event_id LEFT JOIN language l2_ ON e1_.lang_id = l2_.id LEFT JOIN event_specialty e4_ ON e0_.id = e4_.event_id LEFT JOIN specialty s3_ ON s3_.id = e4_.specialty_id WHERE e0_.is_enabled = ? AND e0_.is_activated = ? AND ((e0_.start_at >= ? OR (e0_.end_at IS NOT NULL AND e0_.end_at >= ?))) AND e0_.status IN (?, ?, ?) AND e0_.id IN (?, ?, ?) ORDER BY e0_.start_at ASC, e0_.id ASC"
  "params" => [
    1 => 1
    2 => 1
    3 => "2026-05-22 14:00:09"
    4 => "2026-05-22 14:00:09"
    5 => "active"
    6 => "online"
    7 => "postponed"
    8 => 3
    9 => 4
    10 => 5
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1342
      +name: "BOOLEAN"
    }
    2 => Doctrine\DBAL\ParameterType {#1342}
    3 => Doctrine\DBAL\ParameterType {#1275
      +name: "STRING"
    }
    4 => Doctrine\DBAL\ParameterType {#1275}
    5 => Doctrine\DBAL\ParameterType {#1275}
    6 => Doctrine\DBAL\ParameterType {#1275}
    7 => Doctrine\DBAL\ParameterType {#1275}
    8 => Doctrine\DBAL\ParameterType {#1340
      +name: "INTEGER"
    }
    9 => Doctrine\DBAL\ParameterType {#1340}
    10 => Doctrine\DBAL\ParameterType {#1340}
  ]
]

[
  "sql" => "SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT e0_.id AS id_0, e0_.slug AS slug_1, e0_.program_name AS program_name_2, e0_.program_original_name AS program_original_name_3, e0_.program_mime_type AS program_mime_type_4, e0_.program_size AS program_size_5, e0_.program_updated_at AS program_updated_at_6, e0_.is_activated AS is_activated_7, e0_.is_enabled AS is_enabled_8, e0_.start_at AS start_at_9, e0_.end_at AS end_at_10, e0_.status AS status_11, e0_.format AS format_12, e0_.created_at AS created_at_13, e0_.is_show_chat AS is_show_chat_14, e0_.is_registration AS is_registration_15, e0_.is_calendar AS is_calendar_16, e0_.is_nmo AS is_nmo_17, e0_.is_show_slider AS is_show_slider_18, e0_.image_name AS image_name_19, e0_.image_original_name AS image_original_name_20, e0_.image_mime_type AS image_mime_type_21, e0_.image_size AS image_size_22, e0_.image_updated_at AS image_updated_at_23, e0_.card_image_name AS card_image_name_24, e0_.card_image_original_name AS card_image_original_name_25, e0_.card_image_mime_type AS card_image_mime_type_26, e0_.card_image_size AS card_image_size_27, e0_.card_image_updated_at AS card_image_updated_at_28, e1_.id AS id_29, e1_.title AS title_30, e1_.seo_title AS seo_title_31, e1_.seo_description AS seo_description_32, e1_.content AS content_33, l2_.id AS id_34, l2_.name AS name_35, s3_.id AS id_36, s3_.name AS name_37, s3_.type AS type_38 FROM event e0_ LEFT JOIN event_translate e1_ ON e0_.id = e1_.event_id LEFT JOIN language l2_ ON e1_.lang_id = l2_.id LEFT JOIN event_specialty e4_ ON e0_.id = e4_.event_id LEFT JOIN specialty s3_ ON s3_.id = e4_.specialty_id WHERE e0_.is_enabled = ? AND e0_.is_activated = ? AND ((e0_.start_at >= ? OR (e0_.end_at IS NOT NULL AND e0_.end_at >= ?))) AND e0_.status IN (?, ?, ?) ORDER BY e0_.start_at ASC, e0_.id ASC) dctrn_result) dctrn_table"
  "params" => [
    1 => 1
    2 => 1
    3 => "2026-05-22 14:00:09"
    4 => "2026-05-22 14:00:09"
    5 => "active"
    6 => "online"
    7 => "postponed"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1342
      +name: "BOOLEAN"
    }
    2 => Doctrine\DBAL\ParameterType {#1342}
    3 => Doctrine\DBAL\ParameterType {#1275
      +name: "STRING"
    }
    4 => Doctrine\DBAL\ParameterType {#1275}
    5 => Doctrine\DBAL\ParameterType {#1275}
    6 => Doctrine\DBAL\ParameterType {#1275}
    7 => Doctrine\DBAL\ParameterType {#1275}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3 FROM specialty t0 ORDER BY t0.name ASC"
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2 FROM specialty s0_"
]