Symfony Profiler

[
  "route" => "app_chat"
  "route_parameters" => [
    "_route" => "app_chat"
    "_controller" => "App\Controller\ChatController::index"
  ]
  "request_uri" => "https://moldxpert.cz/chat?conversation=1"
  "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"
]

[
  "key" => "_security_main"
  "token_class" => "Symfony\Component\Security\Core\Authentication\Token\UsernamePasswordToken"
]

[
  "params" => [
    "driver" => "pdo_pgsql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 5432
    "user" => "appuser"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "appdb"
    "serverVersion" => "16"
    "charset" => "utf8"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.created_at AS created_at_6, t0.is_active AS is_active_7, t0.company_id AS company_id_8 FROM "user" t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#774
      +name: "INTEGER"
    }
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "firma@moldxpert.cz"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.unique_code AS unique_code_3, t0.ico AS ico_4, t0.specialization AS specialization_5, t0.user_limit AS user_limit_6, t0.created_at AS created_at_7, t0.is_active AS is_active_8 FROM company t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#774
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.payment_transaction_id AS payment_transaction_id_5, t0.last_payment_date AS last_payment_date_6, t0.next_payment_date AS next_payment_date_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.company_id AS company_id_10, t0.plan_id AS plan_id_11 FROM subscription t0 WHERE t0.company_id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#774
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.type AS type_2, c0_.created_at AS created_at_3, c0_.last_message_at AS last_message_at_4, c0_.company_id AS company_id_5, c0_.created_by_id AS created_by_id_6 FROM conversation c0_ INNER JOIN conversation_participant c1_ ON c0_.id = c1_.conversation_id WHERE c1_.user_id = ? AND c0_.company_id = ? ORDER BY c0_.last_message_at DESC, c0_.created_at DESC"
  "params" => [
    1 => 1
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#774
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#774}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.role AS role_2, t0.joined_at AS joined_at_3, t0.last_read_at AS last_read_at_4, t0.is_muted AS is_muted_5, t0.conversation_id AS conversation_id_6, t0.user_id AS user_id_7 FROM conversation_participant t0 WHERE t0.conversation_id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#774
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT COUNT(m0_.id) AS sclr_0 FROM message m0_ WHERE m0_.conversation_id = ? AND m0_.sender_id <> ? AND m0_.created_at > ?"
  "params" => [
    1 => 1
    2 => 1
    3 => "2026-03-25 12:38:56"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#774
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#774}
    3 => Doctrine\DBAL\ParameterType {#1201
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.role AS role_2, t0.joined_at AS joined_at_3, t0.last_read_at AS last_read_at_4, t0.is_muted AS is_muted_5, t0.conversation_id AS conversation_id_6, t0.user_id AS user_id_7 FROM conversation_participant t0 WHERE t0.conversation_id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#774
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT COUNT(m0_.id) AS sclr_0 FROM message m0_ WHERE m0_.conversation_id = ? AND m0_.sender_id <> ? AND m0_.created_at > ?"
  "params" => [
    1 => 2
    2 => 1
    3 => "2026-03-25 12:24:44"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#774
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#774}
    3 => Doctrine\DBAL\ParameterType {#1201
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.name AS name_4, u0_.created_at AS created_at_5, u0_.is_active AS is_active_6, u0_.company_id AS company_id_7 FROM "user" u0_ WHERE u0_.company_id = ? AND u0_.is_active = ? ORDER BY u0_.name ASC"
  "params" => [
    1 => 1
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#774
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1452
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.type AS type_2, c0_.created_at AS created_at_3, c0_.last_message_at AS last_message_at_4, c0_.company_id AS company_id_5, c0_.created_by_id AS created_by_id_6 FROM conversation c0_ WHERE c0_.id = ? AND c0_.company_id = ?"
  "params" => [
    1 => 1
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#774
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#774}
  ]
]

[
  "sql" => "SELECT m0_.id AS id_0, m0_.content AS content_1, m0_.type AS type_2, m0_.created_at AS created_at_3, m0_.edited_at AS edited_at_4, m0_.is_deleted AS is_deleted_5, m0_.metadata AS metadata_6, m0_.conversation_id AS conversation_id_7, m0_.sender_id AS sender_id_8, m0_.sender_partner_id AS sender_partner_id_9, m0_.reply_to_id AS reply_to_id_10 FROM message m0_ WHERE m0_.conversation_id = ? ORDER BY m0_.created_at DESC LIMIT 50"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#774
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "UPDATE conversation_participant SET last_read_at = ? WHERE id = ?"
  "params" => [
    1 => "2026-04-14 10:44:26"
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1201
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#774
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.reference_number AS reference_number_1, c0_.service_type AS service_type_2, c0_.custom_service_type AS custom_service_type_3, c0_.description AS description_4, c0_.notes AS notes_5, c0_.date_from AS date_from_6, c0_.date_to AS date_to_7, c0_.logistics_required AS logistics_required_8, c0_.status AS status_9, c0_.partner_response AS partner_response_10, c0_.responded_at AS responded_at_11, c0_.attachments AS attachments_12, c0_.created_at AS created_at_13, c0_.updated_at AS updated_at_14, c0_.partner_id AS partner_id_15, c0_.project_id AS project_id_16, c0_.item_id AS item_id_17, c0_.created_by_id AS created_by_id_18, c0_.conversation_id AS conversation_id_19 FROM cooperation c0_ WHERE c0_.conversation_id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#774
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.content AS content_2, t0.type AS type_3, t0.created_at AS created_at_4, t0.edited_at AS edited_at_5, t0.is_deleted AS is_deleted_6, t0.metadata AS metadata_7, t0.conversation_id AS conversation_id_8, t0.sender_id AS sender_id_9, t0.sender_partner_id AS sender_partner_id_10, t0.reply_to_id AS reply_to_id_11 FROM message t0 WHERE t0.conversation_id = ? ORDER BY t0.created_at ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#774
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.content AS content_2, t0.type AS type_3, t0.created_at AS created_at_4, t0.edited_at AS edited_at_5, t0.is_deleted AS is_deleted_6, t0.metadata AS metadata_7, t0.conversation_id AS conversation_id_8, t0.sender_id AS sender_id_9, t0.sender_partner_id AS sender_partner_id_10, t0.reply_to_id AS reply_to_id_11 FROM message t0 WHERE t0.conversation_id = ? ORDER BY t0.created_at ASC"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#774
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.ico AS ico_3, t0.description AS description_4, t0.specializations AS specializations_5, t0.contact_email AS contact_email_6, t0.contact_phone AS contact_phone_7, t0.contact_name AS contact_name_8, t0.address AS address_9, t0.city AS city_10, t0.postal_code AS postal_code_11, t0.country AS country_12, t0.website AS website_13, t0.logo_url AS logo_url_14, t0.status AS status_15, t0.accepting_orders AS accepting_orders_16, t0.is_verified AS is_verified_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.verified_at AS verified_at_20, t0.roles AS roles_21, t0.password AS password_22 FROM partner t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#774
      +name: "INTEGER"
    }
  ]
]

[
  "key" => "_security_main"
]