Symfony Profiler

[
  "route" => "app_api_bitrix_sendmessagednotification"
  "route_parameters" => [
    "_route" => "app_api_bitrix_sendmessagednotification"
    "_controller" => "App\Controller\Api\BitrixController::sendMessagedNotification"
  ]
  "request_uri" => "https://bilka.landfills.xyz/api/bitrix/crm/send/message/notification"
  "method" => "POST"
]

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

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

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\LoginFormAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\LoginFormAuthenticator"
]

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

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

[
  "event" => "kernel.request"
  "listener" => "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::onKernelRequest"
]

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

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

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

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::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" => "FOS\RestBundle\EventListener\BodyListener::onKernelRequest"
]

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

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

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

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

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

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

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

[
  "event" => "kernel.controller"
  "listener" => "App\EventSubscriber\RequestSubscriber::logException"
]

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

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

[
  "params" => [
    "url" => "<redacted>"
    "driver" => "pdo_pgsql"
    "host" => "127.0.0.1"
    "port" => 5432
    "user" => "postgres"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "BitrixChatBotForSupport"
    "serverVersion" => "13"
    "charset" => "utf8"
  ]
]

[
  "sql" => "SELECT NEXTVAL('system_logs_id_seq')"
]

[
  "sql" => "INSERT INTO system_logs (stage, data, id, created_at, updated_at) VALUES (?, ?, ?, ?, ?)"
  "params" => [
    1 => "/crm/send/message/notification"
    2 => "{"api_token":"ZsB782nU6Rp4X77v3ZAkZspGmga9M6","text":"\n            Event name: QR code generated  \u2589  \n            Platform: c30-v3.landfills.xyz  \u2589  \n            Account number: 100000  \u2589  \n            User email: [email protected]  \u2589  \n            Pay method: Credit from partners  \u2589  \n            Value: https:\/\/chatgpt.com\/  \u2589  \n            Go to user account: \ud83d\udc49 https:\/\/admin.c30-v3.landfills.xyz\/user\/100000 \ud83d\udc48\n              \u2589  Field name: https:\/\/chatgpt.com\/","bitrix_id":1,"crm_deal_id":null,"leadId":"","depositor":false,"ignore_lead_connection_deal":false,"always_send_notification_to_lead":false}"
    3 => 10353
    4 => "2026-03-18 08:26:30"
    5 => null
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.domain AS domain_2, t0.bot_client_id AS bot_client_id_3, t0.bot_id AS bot_id_4, t0.code_bot AS code_bot_5, t0.name_bot AS name_bot_6, t0.event_handler AS event_handler_7, t0.user_input_webhook_url AS user_input_webhook_url_8, t0.number_for_api AS number_for_api_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM bitrix t0 WHERE t0.number_for_api = ? LIMIT 1"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT NEXTVAL('system_logs_id_seq')"
]

[
  "sql" => "INSERT INTO system_logs (stage, data, id, created_at, updated_at) VALUES (?, ?, ?, ?, ?)"
  "params" => [
    1 => "bitrix request"
    2 => "method: crm.deal.list, params: {"filter":{"LEAD_ID":""},"select":["ID","LEAD_ID","ASSIGNED_BY_ID"]}, response: {"result":[{"ID":"1","LEAD_ID":null,"ASSIGNED_BY_ID":"1"},{"ID":"2","LEAD_ID":null,"ASSIGNED_BY_ID":"1"},{"ID":"3","LEAD_ID":null,"ASSIGNED_BY_ID":"1"},{"ID":"4","LEAD_ID":null,"ASSIGNED_BY_ID":"1"},{"ID":"5","LEAD_ID":null,"ASSIGNED_BY_ID":"1"},{"ID":"6","LEAD_ID":null,"ASSIGNED_BY_ID":"1"},{"ID":"8","LEAD_ID":null,"ASSIGNED_BY_ID":"1"},{"ID":"9","LEAD_ID":null,"ASSIGNED_BY_ID":"1"},{"ID":"10","LEAD_ID":null,"ASSIGNED_BY_ID":"1"},{"ID":"19","LEAD_ID":null,"ASSIGNED_BY_ID":"10"},{"ID":"24","LEAD_ID":null,"ASSIGNED_BY_ID":"4"},{"ID":"27","LEAD_ID":null,"ASSIGNED_BY_ID":"5"},{"ID":"28","LEAD_ID":null,"ASSIGNED_BY_ID":"5"}],"total":13,"time":{"start":1773822390.359137,"finish":1773822390.481904,"duration":0.12276697158813477,"processing":0.03885197639465332,"date_start":"2026-03-18T04:26:30-04:00","date_finish":"2026-03-18T04:26:30-04:00"}}"
    3 => 10354
    4 => "2026-03-18 08:26:30"
    5 => null
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT CURRENT_DATABASE()"
]

[
  "sql" => """
    SELECT quote_ident(table_name) AS table_name,\n
           table_schema AS schema_name\n
    FROM information_schema.tables\n
    WHERE table_catalog = ?\n
      AND table_schema NOT LIKE 'pg\_%'\n
      AND table_schema != 'information_schema'\n
      AND table_name != 'geometry_columns'\n
      AND table_name != 'spatial_ref_sys'\n
      AND table_type = 'BASE TABLE'
    """
  "params" => [
    1 => "BitrixChatBotForSupport"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => """
    SELECT schema_name\n
    FROM   information_schema.schemata\n
    WHERE  schema_name NOT LIKE 'pg\_%'\n
    AND    schema_name != 'information_schema'
    """
]

[
  "sql" => "SHOW search_path"
]

[
  "sql" => "SELECT CURRENT_DATABASE()"
]

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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