Symfony Profiler

[
  "route" => "api_v1_distribution_upsert"
  "route_parameters" => [
    "_route" => "api_v1_distribution_upsert"
    "_format" => "json"
    "_controller" => "App\Controller\APIController::upsertDistribution"
  ]
  "request_uri" => "https://staging.g2h.biz/api/v1/distribution/upsert"
  "method" => "POST"
]

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

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

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

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

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

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

[
  "params" => [
    "driver" => "pdo_mysql"
    "use_savepoints" => true
    "idle_connection_ttl" => 600
    "host" => "100.65.135.83"
    "port" => 3306
    "user" => "reportsg"
    "password" => "<redacted>"
    "driverOptions" => []
    "serverVersion" => "8.0"
    "defaultTableOptions" => []
    "dbname" => "reportsg_growers2home"
    "charset" => "utf8"
  ]
]

[
  "sql" => "SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.description AS description_2, a0_.owner_email AS owner_email_3, a0_.key_hash AS key_hash_4, a0_.scope AS scope_5, a0_.rate_limit_override AS rate_limit_override_6, a0_.is_active AS is_active_7, a0_.expires_at AS expires_at_8, a0_.created_at AS created_at_9, a0_.updated_at AS updated_at_10, a0_.rotated_at AS rotated_at_11, a0_.previous_hash AS previous_hash_12, a0_.created_by_id AS created_by_id_13 FROM api_key a0_ WHERE a0_.is_active = 1 AND (a0_.expires_at IS NULL OR a0_.expires_at > ?)"
  "params" => [
    1 => "2026-02-05 23:47:17"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#991
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.description AS description_2, a0_.owner_email AS owner_email_3, a0_.key_hash AS key_hash_4, a0_.scope AS scope_5, a0_.rate_limit_override AS rate_limit_override_6, a0_.is_active AS is_active_7, a0_.expires_at AS expires_at_8, a0_.created_at AS created_at_9, a0_.updated_at AS updated_at_10, a0_.rotated_at AS rotated_at_11, a0_.previous_hash AS previous_hash_12, a0_.created_by_id AS created_by_id_13 FROM api_key a0_ WHERE a0_.id = ? AND a0_.is_active = 1 AND (a0_.expires_at IS NULL OR a0_.expires_at > ?)"
  "params" => [
    1 => b"•ûÝ\x15XüAª—Û%˾™Àz"
    2 => "2026-02-05 23:47:18"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1159
      +name: "BINARY"
    }
    2 => Doctrine\DBAL\ParameterType {#991
      +name: "STRING"
    }
  ]
]

[
  "event" => "Symfony\Component\Security\Http\Event\CheckPassportEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\UserProviderListener::checkPassport"
]

[
  "event" => "Symfony\Component\Security\Http\Event\CheckPassportEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\UserProviderListener::checkPassport"
]

[
  "event" => "Symfony\Component\Security\Http\Event\CheckPassportEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\CsrfProtectionListener::checkPassport"
]

[
  "event" => "Symfony\Component\Security\Http\Event\CheckPassportEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\UserCheckerListener::preCheckCredentials"
]

[
  "event" => "Symfony\Component\Security\Http\Event\CheckPassportEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\CheckCredentialsListener::checkPassport"
]

[
  "event" => "security.authentication.success"
  "listener" => "Symfony\Component\Security\Http\EventListener\UserCheckerListener::postCheckCredentials"
]

[
  "token" => Symfony\Component\Security\Http\Authenticator\Token\PostAuthenticationToken {#1160
    -user: App\Security\ApiKeyUser {#1153 …}
    -roleNames: [
      "ROLE_API"
    ]
    -attributes: []
    -firewallName: "main"
  }
  "authenticator" => "App\Security\ApiKeyAuthenticator"
]

[
  "authenticator" => "App\Security\ApiKeyAuthenticator"
]

[
  "event" => "Symfony\Component\Security\Http\Event\LoginSuccessEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\SessionStrategyListener::onSuccessfulLogin"
]

[
  "event" => "Symfony\Component\Security\Http\Event\LoginSuccessEvent"
  "listener" => "App\EventSubscriber\LoginSuccessSubscriber::onLoginSuccess"
]

[
  "event" => "Symfony\Component\Security\Http\Event\LoginSuccessEvent"
  "listener" => "App\EventSubscriber\UpdateLastLoginSubscriber::onLoginSuccess"
]

[
  "event" => "Symfony\Component\Security\Http\Event\LoginSuccessEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\PasswordMigratingListener::onLoginSuccess"
]

[
  "event" => "Symfony\Component\Security\Http\Event\LoginSuccessEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\CheckRememberMeConditionsListener::onSuccessfulLogin"
]

[
  "event" => "Symfony\Component\Security\Http\Event\LoginSuccessEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\RememberMeListener::onSuccessfulLogin"
]

[
  "authenticator" => "App\Security\ApiKeyAuthenticator"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "resource" => Symfony\Component\Lock\Key {#1206
    -resource: b"api_key-•ûÝ\x15XüAª—Û%˾™Àz"
    -expiringTime: null
    -state: []
    -serializable: false
  }
]

[
  "resource" => Symfony\Component\Lock\Key {#1206
    -resource: b"api_key-•ûÝ\x15XüAª—Û%˾™Àz"
    -expiringTime: null
    -state: []
    -serializable: false
  }
  "ttl" => 300.0
]

[
  "resource" => Symfony\Component\Lock\Key {#1206
    -resource: b"api_key-•ûÝ\x15XüAª—Û%˾™Àz"
    -expiringTime: null
    -state: []
    -serializable: false
  }
]

[
  "resource" => Symfony\Component\Lock\Key {#1221
    -resource: "api_ip-35.243.21.36"
    -expiringTime: null
    -state: []
    -serializable: false
  }
]

[
  "resource" => Symfony\Component\Lock\Key {#1221
    -resource: "api_ip-35.243.21.36"
    -expiringTime: null
    -state: []
    -serializable: false
  }
  "ttl" => 300.0
]

[
  "resource" => Symfony\Component\Lock\Key {#1221
    -resource: "api_ip-35.243.21.36"
    -expiringTime: null
    -state: []
    -serializable: false
  }
]

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

[
  "event" => "kernel.request"
  "listener" => "App\EventSubscriber\AdminEntityIdNormalizerSubscriber::normalizeEntityId"
]

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

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

[
  "event" => "kernel.request"
  "listener" => "App\EventSubscriber\LegacyApiSubscriber::onKernelRequest"
]

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

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelRequest"
]

[
  "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" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

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

[
  "event" => "kernel.request"
  "listener" => "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelRequestPrettyUrls"
]

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

[
  "event" => "kernel.request"
  "listener" => "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventSubscriber\ApiRateLimitSubscriber::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelController"
]

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

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::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" => "ContainerGX8xMpM\RequestPayloadValueResolverGhost3590451::onKernelControllerArguments"
]

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

[
  "sql" => """
    INSERT INTO `distribution`\n
      (`upc`, `fiscal_week`, `store`, `route`, `warehouse`, `sku_description`,\n
       `qty_placed`, `scheduled_delivery_date`, `operator`, `uploaded_file_id`)\n
    VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n
    ON DUPLICATE KEY UPDATE\n
      `qty_placed` = VALUES(`qty_placed`),\n
      `scheduled_delivery_date` = VALUES(`scheduled_delivery_date`),\n
      `warehouse` = VALUES(`warehouse`),\n
      `operator` = VALUES(`operator`),\n
      `uploaded_file_id` = VALUES(`uploaded_file_id`),\n
      `notes` = CONCAT(COALESCE(`notes`, ''), ?)
    """
  "params" => [
    1 => "61084028822"
    2 => 202606
    3 => "1444"
    4 => "EMD 02 GLENTMONT 202605"
    5 => "MD"
    6 => "e(SMD)"
    7 => 5
    8 => "2026-02-06"
    9 => "DOK"
    10 => 0
    11 => ":gs"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#991
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#991}
    3 => Doctrine\DBAL\ParameterType {#991}
    4 => Doctrine\DBAL\ParameterType {#991}
    5 => Doctrine\DBAL\ParameterType {#991}
    6 => Doctrine\DBAL\ParameterType {#991}
    7 => Doctrine\DBAL\ParameterType {#991}
    8 => Doctrine\DBAL\ParameterType {#991}
    9 => Doctrine\DBAL\ParameterType {#991}
    10 => Doctrine\DBAL\ParameterType {#991}
    11 => Doctrine\DBAL\ParameterType {#991}
  ]
]

[
  "sql" => """
    INSERT INTO `distribution`\n
      (`upc`, `fiscal_week`, `store`, `route`, `warehouse`, `sku_description`,\n
       `qty_placed`, `scheduled_delivery_date`, `operator`, `uploaded_file_id`)\n
    VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n
    ON DUPLICATE KEY UPDATE\n
      `qty_placed` = VALUES(`qty_placed`),\n
      `scheduled_delivery_date` = VALUES(`scheduled_delivery_date`),\n
      `warehouse` = VALUES(`warehouse`),\n
      `operator` = VALUES(`operator`),\n
      `uploaded_file_id` = VALUES(`uploaded_file_id`),\n
      `notes` = CONCAT(COALESCE(`notes`, ''), ?)
    """
  "params" => [
    1 => "61084028815"
    2 => 202606
    3 => "1444"
    4 => "EMD 02 GLENTMONT 202605"
    5 => "MD"
    6 => "e(PR)"
    7 => 1
    8 => "2026-02-06"
    9 => "DOK"
    10 => 0
    11 => ":gs"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#991
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#991}
    3 => Doctrine\DBAL\ParameterType {#991}
    4 => Doctrine\DBAL\ParameterType {#991}
    5 => Doctrine\DBAL\ParameterType {#991}
    6 => Doctrine\DBAL\ParameterType {#991}
    7 => Doctrine\DBAL\ParameterType {#991}
    8 => Doctrine\DBAL\ParameterType {#991}
    9 => Doctrine\DBAL\ParameterType {#991}
    10 => Doctrine\DBAL\ParameterType {#991}
    11 => Doctrine\DBAL\ParameterType {#991}
  ]
]

[
  "sql" => """
    INSERT INTO `distribution`\n
      (`upc`, `fiscal_week`, `store`, `route`, `warehouse`, `sku_description`,\n
       `qty_placed`, `scheduled_delivery_date`, `operator`, `uploaded_file_id`)\n
    VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n
    ON DUPLICATE KEY UPDATE\n
      `qty_placed` = VALUES(`qty_placed`),\n
      `scheduled_delivery_date` = VALUES(`scheduled_delivery_date`),\n
      `warehouse` = VALUES(`warehouse`),\n
      `operator` = VALUES(`operator`),\n
      `uploaded_file_id` = VALUES(`uploaded_file_id`),\n
      `notes` = CONCAT(COALESCE(`notes`, ''), ?)
    """
  "params" => [
    1 => "89324800213"
    2 => 202606
    3 => "1444"
    4 => "EMD 02 GLENTMONT 202605"
    5 => "MD"
    6 => "e(R)"
    7 => 0
    8 => "2026-02-06"
    9 => "DOK"
    10 => 0
    11 => ":gs"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#991
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#991}
    3 => Doctrine\DBAL\ParameterType {#991}
    4 => Doctrine\DBAL\ParameterType {#991}
    5 => Doctrine\DBAL\ParameterType {#991}
    6 => Doctrine\DBAL\ParameterType {#991}
    7 => Doctrine\DBAL\ParameterType {#991}
    8 => Doctrine\DBAL\ParameterType {#991}
    9 => Doctrine\DBAL\ParameterType {#991}
    10 => Doctrine\DBAL\ParameterType {#991}
    11 => Doctrine\DBAL\ParameterType {#991}
  ]
]

[
  "sql" => """
    INSERT INTO `distribution`\n
      (`upc`, `fiscal_week`, `store`, `route`, `warehouse`, `sku_description`,\n
       `qty_placed`, `scheduled_delivery_date`, `operator`, `uploaded_file_id`)\n
    VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n
    ON DUPLICATE KEY UPDATE\n
      `qty_placed` = VALUES(`qty_placed`),\n
      `scheduled_delivery_date` = VALUES(`scheduled_delivery_date`),\n
      `warehouse` = VALUES(`warehouse`),\n
      `operator` = VALUES(`operator`),\n
      `uploaded_file_id` = VALUES(`uploaded_file_id`),\n
      `notes` = CONCAT(COALESCE(`notes`, ''), ?)
    """
  "params" => [
    1 => "61084028822"
    2 => 202606
    3 => "1444"
    4 => "EMD 02 GLENTMONT 202605"
    5 => "MD"
    6 => "e(SM)"
    7 => 0
    8 => "2026-02-06"
    9 => "DOK"
    10 => 0
    11 => ":gs"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#991
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#991}
    3 => Doctrine\DBAL\ParameterType {#991}
    4 => Doctrine\DBAL\ParameterType {#991}
    5 => Doctrine\DBAL\ParameterType {#991}
    6 => Doctrine\DBAL\ParameterType {#991}
    7 => Doctrine\DBAL\ParameterType {#991}
    8 => Doctrine\DBAL\ParameterType {#991}
    9 => Doctrine\DBAL\ParameterType {#991}
    10 => Doctrine\DBAL\ParameterType {#991}
    11 => Doctrine\DBAL\ParameterType {#991}
  ]
]

[
  "sql" => """
    INSERT INTO `distribution`\n
      (`upc`, `fiscal_week`, `store`, `route`, `warehouse`, `sku_description`,\n
       `qty_placed`, `scheduled_delivery_date`, `operator`, `uploaded_file_id`)\n
    VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n
    ON DUPLICATE KEY UPDATE\n
      `qty_placed` = VALUES(`qty_placed`),\n
      `scheduled_delivery_date` = VALUES(`scheduled_delivery_date`),\n
      `warehouse` = VALUES(`warehouse`),\n
      `operator` = VALUES(`operator`),\n
      `uploaded_file_id` = VALUES(`uploaded_file_id`),\n
      `notes` = CONCAT(COALESCE(`notes`, ''), ?)
    """
  "params" => [
    1 => "61084028822"
    2 => 202606
    3 => "1468"
    4 => "EMD 02 GLENTMONT 202605"
    5 => "MD"
    6 => "e(SMD)"
    7 => 4
    8 => "2026-02-06"
    9 => "DOK"
    10 => 0
    11 => ":gs"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#991
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#991}
    3 => Doctrine\DBAL\ParameterType {#991}
    4 => Doctrine\DBAL\ParameterType {#991}
    5 => Doctrine\DBAL\ParameterType {#991}
    6 => Doctrine\DBAL\ParameterType {#991}
    7 => Doctrine\DBAL\ParameterType {#991}
    8 => Doctrine\DBAL\ParameterType {#991}
    9 => Doctrine\DBAL\ParameterType {#991}
    10 => Doctrine\DBAL\ParameterType {#991}
    11 => Doctrine\DBAL\ParameterType {#991}
  ]
]

[
  "sql" => """
    INSERT INTO `distribution`\n
      (`upc`, `fiscal_week`, `store`, `route`, `warehouse`, `sku_description`,\n
       `qty_placed`, `scheduled_delivery_date`, `operator`, `uploaded_file_id`)\n
    VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n
    ON DUPLICATE KEY UPDATE\n
      `qty_placed` = VALUES(`qty_placed`),\n
      `scheduled_delivery_date` = VALUES(`scheduled_delivery_date`),\n
      `warehouse` = VALUES(`warehouse`),\n
      `operator` = VALUES(`operator`),\n
      `uploaded_file_id` = VALUES(`uploaded_file_id`),\n
      `notes` = CONCAT(COALESCE(`notes`, ''), ?)
    """
  "params" => [
    1 => "61084028815"
    2 => 202606
    3 => "1468"
    4 => "EMD 02 GLENTMONT 202605"
    5 => "MD"
    6 => "e(PR)"
    7 => 1
    8 => "2026-02-06"
    9 => "DOK"
    10 => 0
    11 => ":gs"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#991
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#991}
    3 => Doctrine\DBAL\ParameterType {#991}
    4 => Doctrine\DBAL\ParameterType {#991}
    5 => Doctrine\DBAL\ParameterType {#991}
    6 => Doctrine\DBAL\ParameterType {#991}
    7 => Doctrine\DBAL\ParameterType {#991}
    8 => Doctrine\DBAL\ParameterType {#991}
    9 => Doctrine\DBAL\ParameterType {#991}
    10 => Doctrine\DBAL\ParameterType {#991}
    11 => Doctrine\DBAL\ParameterType {#991}
  ]
]

[
  "sql" => """
    INSERT INTO `distribution`\n
      (`upc`, `fiscal_week`, `store`, `route`, `warehouse`, `sku_description`,\n
       `qty_placed`, `scheduled_delivery_date`, `operator`, `uploaded_file_id`)\n
    VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n
    ON DUPLICATE KEY UPDATE\n
      `qty_placed` = VALUES(`qty_placed`),\n
      `scheduled_delivery_date` = VALUES(`scheduled_delivery_date`),\n
      `warehouse` = VALUES(`warehouse`),\n
      `operator` = VALUES(`operator`),\n
      `uploaded_file_id` = VALUES(`uploaded_file_id`),\n
      `notes` = CONCAT(COALESCE(`notes`, ''), ?)
    """
  "params" => [
    1 => "89324800213"
    2 => 202606
    3 => "1468"
    4 => "EMD 02 GLENTMONT 202605"
    5 => "MD"
    6 => "e(R)"
    7 => 0
    8 => "2026-02-06"
    9 => "DOK"
    10 => 0
    11 => ":gs"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#991
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#991}
    3 => Doctrine\DBAL\ParameterType {#991}
    4 => Doctrine\DBAL\ParameterType {#991}
    5 => Doctrine\DBAL\ParameterType {#991}
    6 => Doctrine\DBAL\ParameterType {#991}
    7 => Doctrine\DBAL\ParameterType {#991}
    8 => Doctrine\DBAL\ParameterType {#991}
    9 => Doctrine\DBAL\ParameterType {#991}
    10 => Doctrine\DBAL\ParameterType {#991}
    11 => Doctrine\DBAL\ParameterType {#991}
  ]
]

[
  "sql" => """
    INSERT INTO `distribution`\n
      (`upc`, `fiscal_week`, `store`, `route`, `warehouse`, `sku_description`,\n
       `qty_placed`, `scheduled_delivery_date`, `operator`, `uploaded_file_id`)\n
    VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n
    ON DUPLICATE KEY UPDATE\n
      `qty_placed` = VALUES(`qty_placed`),\n
      `scheduled_delivery_date` = VALUES(`scheduled_delivery_date`),\n
      `warehouse` = VALUES(`warehouse`),\n
      `operator` = VALUES(`operator`),\n
      `uploaded_file_id` = VALUES(`uploaded_file_id`),\n
      `notes` = CONCAT(COALESCE(`notes`, ''), ?)
    """
  "params" => [
    1 => "61084028822"
    2 => 202606
    3 => "1468"
    4 => "EMD 02 GLENTMONT 202605"
    5 => "MD"
    6 => "e(SM)"
    7 => 0
    8 => "2026-02-06"
    9 => "DOK"
    10 => 0
    11 => ":gs"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#991
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#991}
    3 => Doctrine\DBAL\ParameterType {#991}
    4 => Doctrine\DBAL\ParameterType {#991}
    5 => Doctrine\DBAL\ParameterType {#991}
    6 => Doctrine\DBAL\ParameterType {#991}
    7 => Doctrine\DBAL\ParameterType {#991}
    8 => Doctrine\DBAL\ParameterType {#991}
    9 => Doctrine\DBAL\ParameterType {#991}
    10 => Doctrine\DBAL\ParameterType {#991}
    11 => Doctrine\DBAL\ParameterType {#991}
  ]
]

[
  "sql" => """
    INSERT INTO `distribution`\n
      (`upc`, `fiscal_week`, `store`, `route`, `warehouse`, `sku_description`,\n
       `qty_placed`, `scheduled_delivery_date`, `operator`, `uploaded_file_id`)\n
    VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n
    ON DUPLICATE KEY UPDATE\n
      `qty_placed` = VALUES(`qty_placed`),\n
      `scheduled_delivery_date` = VALUES(`scheduled_delivery_date`),\n
      `warehouse` = VALUES(`warehouse`),\n
      `operator` = VALUES(`operator`),\n
      `uploaded_file_id` = VALUES(`uploaded_file_id`),\n
      `notes` = CONCAT(COALESCE(`notes`, ''), ?)
    """
  "params" => [
    1 => "61084028822"
    2 => 202606
    3 => "1499"
    4 => "EMD 02 GLENTMONT 202605"
    5 => "MD"
    6 => "e(SMD)"
    7 => 4
    8 => "2026-02-06"
    9 => "DOK"
    10 => 0
    11 => ":gs"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#991
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#991}
    3 => Doctrine\DBAL\ParameterType {#991}
    4 => Doctrine\DBAL\ParameterType {#991}
    5 => Doctrine\DBAL\ParameterType {#991}
    6 => Doctrine\DBAL\ParameterType {#991}
    7 => Doctrine\DBAL\ParameterType {#991}
    8 => Doctrine\DBAL\ParameterType {#991}
    9 => Doctrine\DBAL\ParameterType {#991}
    10 => Doctrine\DBAL\ParameterType {#991}
    11 => Doctrine\DBAL\ParameterType {#991}
  ]
]

[
  "sql" => """
    INSERT INTO `distribution`\n
      (`upc`, `fiscal_week`, `store`, `route`, `warehouse`, `sku_description`,\n
       `qty_placed`, `scheduled_delivery_date`, `operator`, `uploaded_file_id`)\n
    VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n
    ON DUPLICATE KEY UPDATE\n
      `qty_placed` = VALUES(`qty_placed`),\n
      `scheduled_delivery_date` = VALUES(`scheduled_delivery_date`),\n
      `warehouse` = VALUES(`warehouse`),\n
      `operator` = VALUES(`operator`),\n
      `uploaded_file_id` = VALUES(`uploaded_file_id`),\n
      `notes` = CONCAT(COALESCE(`notes`, ''), ?)
    """
  "params" => [
    1 => "61084028815"
    2 => 202606
    3 => "1499"
    4 => "EMD 02 GLENTMONT 202605"
    5 => "MD"
    6 => "e(PR)"
    7 => 1
    8 => "2026-02-06"
    9 => "DOK"
    10 => 0
    11 => ":gs"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#991
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#991}
    3 => Doctrine\DBAL\ParameterType {#991}
    4 => Doctrine\DBAL\ParameterType {#991}
    5 => Doctrine\DBAL\ParameterType {#991}
    6 => Doctrine\DBAL\ParameterType {#991}
    7 => Doctrine\DBAL\ParameterType {#991}
    8 => Doctrine\DBAL\ParameterType {#991}
    9 => Doctrine\DBAL\ParameterType {#991}
    10 => Doctrine\DBAL\ParameterType {#991}
    11 => Doctrine\DBAL\ParameterType {#991}
  ]
]

[
  "sql" => """
    INSERT INTO `distribution`\n
      (`upc`, `fiscal_week`, `store`, `route`, `warehouse`, `sku_description`,\n
       `qty_placed`, `scheduled_delivery_date`, `operator`, `uploaded_file_id`)\n
    VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n
    ON DUPLICATE KEY UPDATE\n
      `qty_placed` = VALUES(`qty_placed`),\n
      `scheduled_delivery_date` = VALUES(`scheduled_delivery_date`),\n
      `warehouse` = VALUES(`warehouse`),\n
      `operator` = VALUES(`operator`),\n
      `uploaded_file_id` = VALUES(`uploaded_file_id`),\n
      `notes` = CONCAT(COALESCE(`notes`, ''), ?)
    """
  "params" => [
    1 => "89324800213"
    2 => 202606
    3 => "1499"
    4 => "EMD 02 GLENTMONT 202605"
    5 => "MD"
    6 => "e(R)"
    7 => 0
    8 => "2026-02-06"
    9 => "DOK"
    10 => 0
    11 => ":gs"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#991
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#991}
    3 => Doctrine\DBAL\ParameterType {#991}
    4 => Doctrine\DBAL\ParameterType {#991}
    5 => Doctrine\DBAL\ParameterType {#991}
    6 => Doctrine\DBAL\ParameterType {#991}
    7 => Doctrine\DBAL\ParameterType {#991}
    8 => Doctrine\DBAL\ParameterType {#991}
    9 => Doctrine\DBAL\ParameterType {#991}
    10 => Doctrine\DBAL\ParameterType {#991}
    11 => Doctrine\DBAL\ParameterType {#991}
  ]
]

[
  "sql" => """
    INSERT INTO `distribution`\n
      (`upc`, `fiscal_week`, `store`, `route`, `warehouse`, `sku_description`,\n
       `qty_placed`, `scheduled_delivery_date`, `operator`, `uploaded_file_id`)\n
    VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n
    ON DUPLICATE KEY UPDATE\n
      `qty_placed` = VALUES(`qty_placed`),\n
      `scheduled_delivery_date` = VALUES(`scheduled_delivery_date`),\n
      `warehouse` = VALUES(`warehouse`),\n
      `operator` = VALUES(`operator`),\n
      `uploaded_file_id` = VALUES(`uploaded_file_id`),\n
      `notes` = CONCAT(COALESCE(`notes`, ''), ?)
    """
  "params" => [
    1 => "61084028822"
    2 => 202606
    3 => "1499"
    4 => "EMD 02 GLENTMONT 202605"
    5 => "MD"
    6 => "e(SM)"
    7 => 0
    8 => "2026-02-06"
    9 => "DOK"
    10 => 0
    11 => ":gs"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#991
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#991}
    3 => Doctrine\DBAL\ParameterType {#991}
    4 => Doctrine\DBAL\ParameterType {#991}
    5 => Doctrine\DBAL\ParameterType {#991}
    6 => Doctrine\DBAL\ParameterType {#991}
    7 => Doctrine\DBAL\ParameterType {#991}
    8 => Doctrine\DBAL\ParameterType {#991}
    9 => Doctrine\DBAL\ParameterType {#991}
    10 => Doctrine\DBAL\ParameterType {#991}
    11 => Doctrine\DBAL\ParameterType {#991}
  ]
]

[
  "sql" => """
    INSERT INTO `distribution`\n
      (`upc`, `fiscal_week`, `store`, `route`, `warehouse`, `sku_description`,\n
       `qty_placed`, `scheduled_delivery_date`, `operator`, `uploaded_file_id`)\n
    VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n
    ON DUPLICATE KEY UPDATE\n
      `qty_placed` = VALUES(`qty_placed`),\n
      `scheduled_delivery_date` = VALUES(`scheduled_delivery_date`),\n
      `warehouse` = VALUES(`warehouse`),\n
      `operator` = VALUES(`operator`),\n
      `uploaded_file_id` = VALUES(`uploaded_file_id`),\n
      `notes` = CONCAT(COALESCE(`notes`, ''), ?)
    """
  "params" => [
    1 => "61084028822"
    2 => 202606
    3 => "1459"
    4 => "EMD 02 GLENTMONT 202605"
    5 => "MD"
    6 => "e(SMD)"
    7 => 4
    8 => "2026-02-06"
    9 => "DOK"
    10 => 0
    11 => ":gs"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#991
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#991}
    3 => Doctrine\DBAL\ParameterType {#991}
    4 => Doctrine\DBAL\ParameterType {#991}
    5 => Doctrine\DBAL\ParameterType {#991}
    6 => Doctrine\DBAL\ParameterType {#991}
    7 => Doctrine\DBAL\ParameterType {#991}
    8 => Doctrine\DBAL\ParameterType {#991}
    9 => Doctrine\DBAL\ParameterType {#991}
    10 => Doctrine\DBAL\ParameterType {#991}
    11 => Doctrine\DBAL\ParameterType {#991}
  ]
]

[
  "sql" => """
    INSERT INTO `distribution`\n
      (`upc`, `fiscal_week`, `store`, `route`, `warehouse`, `sku_description`,\n
       `qty_placed`, `scheduled_delivery_date`, `operator`, `uploaded_file_id`)\n
    VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n
    ON DUPLICATE KEY UPDATE\n
      `qty_placed` = VALUES(`qty_placed`),\n
      `scheduled_delivery_date` = VALUES(`scheduled_delivery_date`),\n
      `warehouse` = VALUES(`warehouse`),\n
      `operator` = VALUES(`operator`),\n
      `uploaded_file_id` = VALUES(`uploaded_file_id`),\n
      `notes` = CONCAT(COALESCE(`notes`, ''), ?)
    """
  "params" => [
    1 => "61084028815"
    2 => 202606
    3 => "1459"
    4 => "EMD 02 GLENTMONT 202605"
    5 => "MD"
    6 => "e(PR)"
    7 => 1
    8 => "2026-02-06"
    9 => "DOK"
    10 => 0
    11 => ":gs"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#991
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#991}
    3 => Doctrine\DBAL\ParameterType {#991}
    4 => Doctrine\DBAL\ParameterType {#991}
    5 => Doctrine\DBAL\ParameterType {#991}
    6 => Doctrine\DBAL\ParameterType {#991}
    7 => Doctrine\DBAL\ParameterType {#991}
    8 => Doctrine\DBAL\ParameterType {#991}
    9 => Doctrine\DBAL\ParameterType {#991}
    10 => Doctrine\DBAL\ParameterType {#991}
    11 => Doctrine\DBAL\ParameterType {#991}
  ]
]

[
  "sql" => """
    INSERT INTO `distribution`\n
      (`upc`, `fiscal_week`, `store`, `route`, `warehouse`, `sku_description`,\n
       `qty_placed`, `scheduled_delivery_date`, `operator`, `uploaded_file_id`)\n
    VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n
    ON DUPLICATE KEY UPDATE\n
      `qty_placed` = VALUES(`qty_placed`),\n
      `scheduled_delivery_date` = VALUES(`scheduled_delivery_date`),\n
      `warehouse` = VALUES(`warehouse`),\n
      `operator` = VALUES(`operator`),\n
      `uploaded_file_id` = VALUES(`uploaded_file_id`),\n
      `notes` = CONCAT(COALESCE(`notes`, ''), ?)
    """
  "params" => [
    1 => "89324800213"
    2 => 202606
    3 => "1459"
    4 => "EMD 02 GLENTMONT 202605"
    5 => "MD"
    6 => "e(R)"
    7 => 0
    8 => "2026-02-06"
    9 => "DOK"
    10 => 0
    11 => ":gs"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#991
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#991}
    3 => Doctrine\DBAL\ParameterType {#991}
    4 => Doctrine\DBAL\ParameterType {#991}
    5 => Doctrine\DBAL\ParameterType {#991}
    6 => Doctrine\DBAL\ParameterType {#991}
    7 => Doctrine\DBAL\ParameterType {#991}
    8 => Doctrine\DBAL\ParameterType {#991}
    9 => Doctrine\DBAL\ParameterType {#991}
    10 => Doctrine\DBAL\ParameterType {#991}
    11 => Doctrine\DBAL\ParameterType {#991}
  ]
]

[
  "sql" => """
    INSERT INTO `distribution`\n
      (`upc`, `fiscal_week`, `store`, `route`, `warehouse`, `sku_description`,\n
       `qty_placed`, `scheduled_delivery_date`, `operator`, `uploaded_file_id`)\n
    VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n
    ON DUPLICATE KEY UPDATE\n
      `qty_placed` = VALUES(`qty_placed`),\n
      `scheduled_delivery_date` = VALUES(`scheduled_delivery_date`),\n
      `warehouse` = VALUES(`warehouse`),\n
      `operator` = VALUES(`operator`),\n
      `uploaded_file_id` = VALUES(`uploaded_file_id`),\n
      `notes` = CONCAT(COALESCE(`notes`, ''), ?)
    """
  "params" => [
    1 => "61084028822"
    2 => 202606
    3 => "1459"
    4 => "EMD 02 GLENTMONT 202605"
    5 => "MD"
    6 => "e(SM)"
    7 => 0
    8 => "2026-02-06"
    9 => "DOK"
    10 => 0
    11 => ":gs"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#991
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#991}
    3 => Doctrine\DBAL\ParameterType {#991}
    4 => Doctrine\DBAL\ParameterType {#991}
    5 => Doctrine\DBAL\ParameterType {#991}
    6 => Doctrine\DBAL\ParameterType {#991}
    7 => Doctrine\DBAL\ParameterType {#991}
    8 => Doctrine\DBAL\ParameterType {#991}
    9 => Doctrine\DBAL\ParameterType {#991}
    10 => Doctrine\DBAL\ParameterType {#991}
    11 => Doctrine\DBAL\ParameterType {#991}
  ]
]

[
  "sql" => """
    INSERT INTO `distribution`\n
      (`upc`, `fiscal_week`, `store`, `route`, `warehouse`, `sku_description`,\n
       `qty_placed`, `scheduled_delivery_date`, `operator`, `uploaded_file_id`)\n
    VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n
    ON DUPLICATE KEY UPDATE\n
      `qty_placed` = VALUES(`qty_placed`),\n
      `scheduled_delivery_date` = VALUES(`scheduled_delivery_date`),\n
      `warehouse` = VALUES(`warehouse`),\n
      `operator` = VALUES(`operator`),\n
      `uploaded_file_id` = VALUES(`uploaded_file_id`),\n
      `notes` = CONCAT(COALESCE(`notes`, ''), ?)
    """
  "params" => [
    1 => "61084028822"
    2 => 202606
    3 => "2221"
    4 => "EMD 02 GLENTMONT 202605"
    5 => "MD"
    6 => "e(SMD)"
    7 => 4
    8 => "2026-02-06"
    9 => "DOK"
    10 => 0
    11 => ":gs"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#991
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#991}
    3 => Doctrine\DBAL\ParameterType {#991}
    4 => Doctrine\DBAL\ParameterType {#991}
    5 => Doctrine\DBAL\ParameterType {#991}
    6 => Doctrine\DBAL\ParameterType {#991}
    7 => Doctrine\DBAL\ParameterType {#991}
    8 => Doctrine\DBAL\ParameterType {#991}
    9 => Doctrine\DBAL\ParameterType {#991}
    10 => Doctrine\DBAL\ParameterType {#991}
    11 => Doctrine\DBAL\ParameterType {#991}
  ]
]