Symfony Profiler

[
  "route" => "app_dashboard"
  "route_parameters" => [
    "_route" => "app_dashboard"
    "_controller" => "App\Controller\DashboardController::index"
  ]
  "request_uri" => "https://zeltoadmin.juodaskodas.lt/dashboard"
  "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\SwitchUserToken"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "dev_zelto"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "dev_zelto"
    "serverVersion" => "8.0.46"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4 FROM admin t0 WHERE t0.email = ? LIMIT 1"
  "params" => [
    1 => "dominykas409@gmail.com"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#663
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.company_name AS company_name_5, t0.company_code AS company_code_6, t0.individual_activity_certificate_number AS individual_activity_certificate_number_7, t0.city AS city_8, t0.address AS address_9, t0.zip AS zip_10, t0.iban AS iban_11, t0.comment AS comment_12, t0.phone AS phone_13, t0.contact_name AS contact_name_14, t0.contact_email AS contact_email_15, t0.contact_phone AS contact_phone_16, t0.fee_percent AS fee_percent_17, t0.shop_title AS shop_title_18, t0.vat_code AS vat_code_19, t0.oss_registered AS oss_registered_20, t0.office_address AS office_address_21, t0.customer_phone AS customer_phone_22, t0.customer_email AS customer_email_23, t0.bank_name AS bank_name_24, t0.swift AS swift_25, t0.invoice_email AS invoice_email_26, t0.return_country AS return_country_27, t0.return_city AS return_city_28, t0.return_address AS return_address_29, t0.return_post_code AS return_post_code_30, t0.return_phone AS return_phone_31, t0.return_email AS return_email_32, t0.pickup_workdays AS pickup_workdays_33, t0.pickup_hours_from AS pickup_hours_from_34, t0.pickup_hours_to AS pickup_hours_to_35, t0.delivery_hours AS delivery_hours_36, t0.delivery_apply_all AS delivery_apply_all_37, t0.delivery_methods AS delivery_methods_38, t0.ai_pricing_strategy AS ai_pricing_strategy_39, t0.auto_price_reduction_enabled AS auto_price_reduction_enabled_40, t0.auto_price_reduction_days AS auto_price_reduction_days_41, t0.auto_price_reduction_percent AS auto_price_reduction_percent_42, t0.notify_product_sold AS notify_product_sold_43, t0.notify_new_message AS notify_new_message_44, t0.notify_ai_price_change AS notify_ai_price_change_45, t0.notify_return_request AS notify_return_request_46, t0.notify_weekly_report AS notify_weekly_report_47, t0.notify_low_inventory AS notify_low_inventory_48, t0.holiday_mode AS holiday_mode_49 FROM seller t0 WHERE t0.email = ? LIMIT 1"
  "params" => [
    1 => "dominykas409@gmail.com"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#663
      +name: "STRING"
    }
  ]
]

[
  "provider" => "App\Security\CombinedUserProvider"
  "username" => "dominykas409@gmail.com"
  "impersonator_username" => "apolskis.linas@gmail.com"
]

[
  "sql" => "SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM customer_order c0_ LEFT JOIN customer_order_item c1_ ON c0_.id = c1_.order_ref_id LEFT JOIN product p2_ ON c1_.product_id = p2_.id LEFT JOIN seller s3_ ON p2_.seller_id = s3_.id WHERE s3_.id = ? AND c0_.status <> ? AND c0_.status = ?"
  "params" => [
    1 => 2
    2 => "draft"
    3 => "pending"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#756
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#663
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#663}
  ]
]

[
  "sql" => "SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM customer_order c0_ LEFT JOIN customer_order_item c1_ ON c0_.id = c1_.order_ref_id LEFT JOIN product p2_ ON c1_.product_id = p2_.id LEFT JOIN seller s3_ ON p2_.seller_id = s3_.id WHERE s3_.id = ? AND c0_.status <> ? AND c0_.status IN (?, ?) AND (NOT EXISTS (SELECT o4_.id FROM order_shipment o4_ WHERE o4_.order_ref_id = c0_.id AND o4_.status IN (?, ?, ?)))"
  "params" => [
    1 => 2
    2 => "draft"
    3 => "in_progress"
    4 => "ready"
    5 => "handed_over"
    6 => "in_transit"
    7 => "delivered"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#756
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#663
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#663}
    4 => Doctrine\DBAL\ParameterType {#663}
    5 => Doctrine\DBAL\ParameterType {#663}
    6 => Doctrine\DBAL\ParameterType {#663}
    7 => Doctrine\DBAL\ParameterType {#663}
  ]
]

[
  "sql" => "SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM customer_order c0_ LEFT JOIN customer_order_item c1_ ON c0_.id = c1_.order_ref_id LEFT JOIN product p2_ ON c1_.product_id = p2_.id LEFT JOIN seller s3_ ON p2_.seller_id = s3_.id WHERE s3_.id = ? AND c0_.status <> ? AND c0_.status NOT IN (?, ?) AND c0_.delivery_deadline IS NOT NULL AND c0_.delivery_deadline < ?"
  "params" => [
    1 => 2
    2 => "draft"
    3 => "completed"
    4 => "cancelled"
    5 => "2026-07-24 12:01:19"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#756
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#663
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#663}
    4 => Doctrine\DBAL\ParameterType {#663}
    5 => Doctrine\DBAL\ParameterType {#663}
  ]
]

[
  "sql" => "SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM customer_order c0_ LEFT JOIN customer_order_item c1_ ON c0_.id = c1_.order_ref_id LEFT JOIN product p2_ ON c1_.product_id = p2_.id LEFT JOIN seller s3_ ON p2_.seller_id = s3_.id WHERE s3_.id = ? AND c0_.status <> ? AND (EXISTS (SELECT o4_.id FROM order_return o4_ WHERE o4_.order_ref_id = c0_.id AND o4_.status NOT IN (?, ?, ?)))"
  "params" => [
    1 => 2
    2 => "draft"
    3 => "refunded"
    4 => "completed"
    5 => "declined"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#756
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#663
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#663}
    4 => Doctrine\DBAL\ParameterType {#663}
    5 => Doctrine\DBAL\ParameterType {#663}
  ]
]

[
  "sql" => "SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM customer_order c0_ LEFT JOIN customer_order_item c1_ ON c0_.id = c1_.order_ref_id LEFT JOIN product p2_ ON c1_.product_id = p2_.id LEFT JOIN seller s3_ ON p2_.seller_id = s3_.id WHERE s3_.id = ? AND c0_.status <> ?"
  "params" => [
    1 => 2
    2 => "draft"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#756
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#663
      +name: "STRING"
    }
  ]
]

[
  "sql" => """
    SELECT COALESCE(SUM(o.grand_total), 0) FROM customer_order o\n
                WHERE o.id IN (\n
                    SELECT DISTINCT i.order_ref_id FROM customer_order_item i\n
                    INNER JOIN product p ON p.id = i.product_id\n
                    WHERE p.seller_id = ?\n
                )\n
                AND o.status IN (?,?,?)
    """
  "params" => [
    1 => 2
    2 => "pending"
    3 => "in_progress"
    4 => "ready"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#663
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#663}
    3 => Doctrine\DBAL\ParameterType {#663}
    4 => Doctrine\DBAL\ParameterType {#663}
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM product_offer p0_ INNER JOIN product p1_ ON p0_.product_id = p1_.id WHERE p1_.seller_id = ? AND p0_.status IN (?, ?)"
  "params" => [
    1 => 2
    2 => "pending"
    3 => "countered"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#756
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#663
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#663}
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(p0_.offered_price), 0) AS sclr_0 FROM product_offer p0_ INNER JOIN product p1_ ON p0_.product_id = p1_.id WHERE p1_.seller_id = ? AND p0_.status IN (?, ?)"
  "params" => [
    1 => 2
    2 => "pending"
    3 => "countered"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#756
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#663
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#663}
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM product_offer p0_ INNER JOIN product p1_ ON p0_.product_id = p1_.id WHERE p1_.seller_id = ? AND p0_.status IN (?, ?) AND p0_.created_at >= ?"
  "params" => [
    1 => 2
    2 => "pending"
    3 => "countered"
    4 => "2026-07-17 12:01:19"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#756
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#663
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#663}
    4 => Doctrine\DBAL\ParameterType {#663}
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM product_offer p0_ INNER JOIN product p1_ ON p0_.product_id = p1_.id WHERE p1_.seller_id = ? AND p0_.status = ? AND p0_.counter_expires_at IS NOT NULL AND p0_.counter_expires_at <= ? AND p0_.counter_expires_at >= ?"
  "params" => [
    1 => 2
    2 => "countered"
    3 => "2026-07-31 12:01:19"
    4 => "2026-07-24 12:01:19"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#756
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#663
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#663}
    4 => Doctrine\DBAL\ParameterType {#663}
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM product p0_ WHERE p0_.seller_id = ? AND p0_.status = ?"
  "params" => [
    1 => 2
    2 => "Draft"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#756
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#663
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM product p0_ WHERE p0_.seller_id = ? AND p0_.status = ?"
  "params" => [
    1 => 2
    2 => "Preparing"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#756
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#663
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM product p0_ WHERE p0_.seller_id = ? AND p0_.status = ? AND (p0_.title IS NOT NULL AND p0_.title <> '') AND (p0_.ean IS NOT NULL AND p0_.ean <> '') AND p0_.category_id IS NOT NULL AND p0_.sale_price IS NOT NULL AND p0_.original_price IS NOT NULL AND p0_.condition_key IS NOT NULL AND (p0_.image_path IS NOT NULL OR EXISTS (SELECT p1_.id FROM product_image p1_ WHERE p1_.product_id = p0_.id))"
  "params" => [
    1 => 2
    2 => "Draft"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#756
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#663
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM product p0_ WHERE p0_.seller_id = ? AND p0_.status = ? AND p0_.ai_score IS NOT NULL AND p0_.ai_score > '0'"
  "params" => [
    1 => 2
    2 => "Draft"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#756
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#663
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM product p0_ WHERE p0_.seller_id = ? AND (p0_.title IS NOT NULL AND p0_.title <> '') AND (p0_.ean IS NOT NULL AND p0_.ean <> '') AND p0_.sale_price IS NOT NULL AND p0_.original_price IS NOT NULL AND p0_.condition_key IS NOT NULL"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#756
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM product p0_ WHERE p0_.seller_id = ? AND (p0_.quality_note IS NOT NULL AND p0_.quality_note <> '')"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#756
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM product p0_ WHERE p0_.seller_id = ? AND p0_.specification_values IS NOT NULL AND p0_.specification_values <> ?"
  "params" => [
    1 => 2
    2 => "[]"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#756
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#663
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT AVG(DATEDIFF(c0_.completed_at, p1_.created_at)) AS sclr_0 FROM customer_order c0_ INNER JOIN customer_order_item c2_ ON c0_.id = c2_.order_ref_id INNER JOIN product p1_ ON c2_.product_id = p1_.id WHERE p1_.seller_id = ? AND c0_.status = ? AND c0_.completed_at IS NOT NULL AND c0_.completed_at >= ? AND c0_.completed_at <= ?"
  "params" => [
    1 => 2
    2 => "completed"
    3 => "2026-06-24 00:00:00"
    4 => "2026-07-24 23:59:59"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#756
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#663
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#663}
    4 => Doctrine\DBAL\ParameterType {#663}
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM product p0_ WHERE p0_.seller_id = ? AND p0_.status = ? AND p0_.created_at >= ?"
  "params" => [
    1 => 2
    2 => "Active"
    3 => "2026-07-17 12:01:19"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#756
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#663
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#663}
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM product p0_ WHERE p0_.seller_id = ? AND p0_.status = ? AND p0_.created_at < ? AND p0_.created_at >= ?"
  "params" => [
    1 => 2
    2 => "Active"
    3 => "2026-07-17 12:01:19"
    4 => "2026-07-10 12:01:19"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#756
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#663
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#663}
    4 => Doctrine\DBAL\ParameterType {#663}
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM product p0_ WHERE p0_.seller_id = ? AND p0_.status = ? AND p0_.created_at < ? AND p0_.created_at >= ?"
  "params" => [
    1 => 2
    2 => "Active"
    3 => "2026-07-10 12:01:19"
    4 => "2026-06-24 12:01:19"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#756
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#663
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#663}
    4 => Doctrine\DBAL\ParameterType {#663}
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM product p0_ WHERE p0_.seller_id = ? AND p0_.status = ? AND p0_.created_at < ?"
  "params" => [
    1 => 2
    2 => "Active"
    3 => "2026-06-24 12:01:19"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#756
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#663
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#663}
  ]
]

[
  "sql" => """
    SELECT\n
                        LEAST(DATEDIFF(DATE(?), DATE(p.created_at)), ?) AS bucket,\n
                        COUNT(p.id) AS cnt\n
                    FROM product p\n
                    WHERE p.seller_id = ?\n
                      AND p.status = ?\n
                      AND p.created_at <= ?\n
                    GROUP BY LEAST(DATEDIFF(DATE(?), DATE(p.created_at)), ?)
    """
  "params" => [
    1 => "2026-07-24 12:01:19"
    2 => 29
    3 => 2
    4 => "Active"
    5 => "2026-07-24 12:01:19"
    6 => "2026-07-24 12:01:19"
    7 => 29
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#663
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#663}
    3 => Doctrine\DBAL\ParameterType {#663}
    4 => Doctrine\DBAL\ParameterType {#663}
    5 => Doctrine\DBAL\ParameterType {#663}
    6 => Doctrine\DBAL\ParameterType {#663}
    7 => Doctrine\DBAL\ParameterType {#663}
  ]
]

[
  "sql" => """
    SELECT DATE(o.completed_at) AS d,\n
                        AVG(DATEDIFF(DATE(o.completed_at), DATE(p.created_at))) AS v\n
                    FROM customer_order o\n
                    INNER JOIN customer_order_item i ON i.order_ref_id = o.id\n
                    INNER JOIN product p ON p.id = i.product_id\n
                    WHERE p.seller_id = ?\n
                      AND o.status = ?\n
                      AND o.completed_at IS NOT NULL\n
                      AND o.completed_at >= ?\n
                      AND o.completed_at <= ?\n
                    GROUP BY DATE(o.completed_at)\n
                    ORDER BY d ASC
    """
  "params" => [
    1 => 2
    2 => "completed"
    3 => "2026-06-24 00:00:00"
    4 => "2026-07-24 23:59:59"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#663
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#663}
    3 => Doctrine\DBAL\ParameterType {#663}
    4 => Doctrine\DBAL\ParameterType {#663}
  ]
]

[
  "sql" => """
    SELECT x.d AS d, COALESCE(SUM(x.pt), 0) AS amt FROM (\n
                    SELECT DATE(o.completed_at) AS d, o.id AS oid, MAX(CAST(o.payout_total AS DECIMAL(10,2))) AS pt\n
                    FROM customer_order o\n
                    INNER JOIN customer_order_item i ON i.order_ref_id = o.id\n
                    INNER JOIN product p ON p.id = i.product_id\n
                    WHERE p.seller_id = ?\n
                      AND o.status = ?\n
                      AND o.completed_at IS NOT NULL\n
                      AND o.completed_at >= ?\n
                      AND o.completed_at <= ?\n
                    GROUP BY d, o.id\n
                ) x\n
                GROUP BY x.d\n
                ORDER BY d ASC
    """
  "params" => [
    1 => 2
    2 => "completed"
    3 => "2026-06-24 00:00:00"
    4 => "2026-07-24 23:59:59"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#663
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#663}
    3 => Doctrine\DBAL\ParameterType {#663}
    4 => Doctrine\DBAL\ParameterType {#663}
  ]
]

[
  "sql" => """
    SELECT\n
                    COALESCE(SUM(o.items_total), 0) AS it,\n
                    COALESCE(SUM(o.marketplace_fee_total), 0) AS fe,\n
                    COALESCE(SUM(o.payout_total), 0) AS po,\n
                    COUNT(o.id) AS cnt\n
                FROM customer_order o\n
                WHERE o.id IN (\n
                    SELECT DISTINCT i.order_ref_id FROM customer_order_item i\n
                    INNER JOIN product p ON p.id = i.product_id\n
                    WHERE p.seller_id = ?\n
                )\n
                AND o.status = ?\n
                AND o.completed_at IS NOT NULL\n
                AND o.completed_at >= ?\n
                AND o.completed_at <= ?
    """
  "params" => [
    1 => 2
    2 => "completed"
    3 => "2026-06-24 00:00:00"
    4 => "2026-07-24 23:59:59"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#663
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#663}
    3 => Doctrine\DBAL\ParameterType {#663}
    4 => Doctrine\DBAL\ParameterType {#663}
  ]
]

[
  "sql" => """
    SELECT\n
                    COALESCE(SUM(o.items_total), 0) AS it,\n
                    COALESCE(SUM(o.marketplace_fee_total), 0) AS fe,\n
                    COALESCE(SUM(o.payout_total), 0) AS po,\n
                    COUNT(o.id) AS cnt\n
                FROM customer_order o\n
                WHERE o.id IN (\n
                    SELECT DISTINCT i.order_ref_id FROM customer_order_item i\n
                    INNER JOIN product p ON p.id = i.product_id\n
                    WHERE p.seller_id = ?\n
                )\n
                AND o.status = ?\n
                AND o.completed_at IS NOT NULL\n
                AND o.completed_at >= ?\n
                AND o.completed_at <= ?
    """
  "params" => [
    1 => 2
    2 => "completed"
    3 => "2026-05-25 00:00:00"
    4 => "2026-06-23 23:59:59"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#663
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#663}
    3 => Doctrine\DBAL\ParameterType {#663}
    4 => Doctrine\DBAL\ParameterType {#663}
  ]
]

[
  "sql" => "SELECT AVG(c0_.total_price) AS sclr_0 FROM customer_order c1_ INNER JOIN customer_order_item c0_ ON c1_.id = c0_.order_ref_id INNER JOIN product p2_ ON c0_.product_id = p2_.id WHERE p2_.seller_id = ? AND c1_.status = ? AND c1_.completed_at >= ? AND c1_.completed_at <= ?"
  "params" => [
    1 => 2
    2 => "completed"
    3 => "2026-06-24 00:00:00"
    4 => "2026-07-24 23:59:59"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#756
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#663
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#663}
    4 => Doctrine\DBAL\ParameterType {#663}
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(s0_.amount), 0) AS sclr_0 FROM seller_payout s0_ WHERE s0_.seller_id = ? AND s0_.status = ? AND s0_.paid_at IS NOT NULL AND s0_.paid_at >= ? AND s0_.paid_at <= ?"
  "params" => [
    1 => 2
    2 => "paid"
    3 => "2026-06-24 00:00:00"
    4 => "2026-07-24 23:59:59"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#756
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#663
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#663}
    4 => Doctrine\DBAL\ParameterType {#663}
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(s0_.amount), 0) AS sclr_0 FROM seller_payout s0_ WHERE s0_.seller_id = ? AND s0_.status = ? AND s0_.paid_at IS NOT NULL AND s0_.paid_at >= ? AND s0_.paid_at <= ?"
  "params" => [
    1 => 2
    2 => "paid"
    3 => "2026-05-25 00:00:00"
    4 => "2026-06-23 23:59:59"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#756
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#663
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#663}
    4 => Doctrine\DBAL\ParameterType {#663}
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(s0_.amount), 0) AS sclr_0 FROM seller_payout s0_ WHERE s0_.seller_id = ? AND s0_.status = ?"
  "params" => [
    1 => 2
    2 => "pending"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#756
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#663
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.period_start AS period_start_1, s0_.period_end AS period_end_2, s0_.scheduled_at AS scheduled_at_3, s0_.paid_at AS paid_at_4, s0_.amount AS amount_5, s0_.hold_amount AS hold_amount_6, s0_.hold_for_cases_amount AS hold_for_cases_amount_7, s0_.status AS status_8, s0_.transfer_ref AS transfer_ref_9, s0_.seller_id AS seller_id_10 FROM seller_payout s0_ WHERE s0_.seller_id = ? AND s0_.status IN (?, ?) ORDER BY s0_.scheduled_at ASC LIMIT 1"
  "params" => [
    1 => 2
    2 => "pending"
    3 => "held"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#756
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#663
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#663}
  ]
]

[
  "sql" => "SELECT COUNT(s0_.id) AS sclr_0 FROM seller_payout s0_ WHERE s0_.seller_id = ? AND s0_.status = ? AND s0_.paid_at >= ? AND s0_.paid_at <= ?"
  "params" => [
    1 => 2
    2 => "paid"
    3 => "2026-06-24 00:00:00"
    4 => "2026-07-24 23:59:59"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#756
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#663
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#663}
    4 => Doctrine\DBAL\ParameterType {#663}
  ]
]

[
  "sql" => "SELECT AVG(s0_.amount) AS sclr_0 FROM seller_payout s0_ WHERE s0_.seller_id = ? AND s0_.status = ? AND s0_.paid_at >= ? AND s0_.paid_at <= ?"
  "params" => [
    1 => 2
    2 => "paid"
    3 => "2026-06-24 00:00:00"
    4 => "2026-07-24 23:59:59"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#756
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#663
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#663}
    4 => Doctrine\DBAL\ParameterType {#663}
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM product p0_ WHERE p0_.seller_id = ? AND p0_.status = ?"
  "params" => [
    1 => 2
    2 => "Active"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#756
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#663
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(p0_.sale_price), 0) AS sclr_0 FROM product p0_ WHERE p0_.seller_id = ? AND p0_.status = ?"
  "params" => [
    1 => 2
    2 => "Active"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#756
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#663
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT AVG(DATEDIFF(?, p0_.created_at)) AS sclr_0 FROM product p0_ WHERE p0_.seller_id = ? AND p0_.status = ?"
  "params" => [
    1 => "2026-07-24 12:01:19"
    2 => 2
    3 => "Active"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#663
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#756
      +name: "INTEGER"
    }
    3 => Doctrine\DBAL\ParameterType {#663}
  ]
]

[
  "sql" => "SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product_offer p0_ INNER JOIN product p1_ ON p0_.product_id = p1_.id INNER JOIN customer c2_ ON p0_.customer_id = c2_.id LEFT JOIN category c3_ ON p1_.category_id = c3_.id WHERE p1_.seller_id = ? AND p0_.status = ?"
  "params" => [
    1 => 2
    2 => "pending"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#756
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#663
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product_offer p0_ INNER JOIN product p1_ ON p0_.product_id = p1_.id INNER JOIN customer c2_ ON p0_.customer_id = c2_.id LEFT JOIN category c3_ ON p1_.category_id = c3_.id WHERE p1_.seller_id = ? AND p0_.status = ? AND ((p0_.counter_expires_at IS NULL OR p0_.counter_expires_at >= ?))"
  "params" => [
    1 => 2
    2 => "countered"
    3 => "2026-07-24 12:01:20"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#756
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#663
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#663}
  ]
]

[
  "sql" => "SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product_offer p0_ INNER JOIN product p1_ ON p0_.product_id = p1_.id INNER JOIN customer c2_ ON p0_.customer_id = c2_.id LEFT JOIN category c3_ ON p1_.category_id = c3_.id WHERE p1_.seller_id = ? AND p0_.status = ? AND p0_.responded_by_seller_id IS NOT NULL"
  "params" => [
    1 => 2
    2 => "declined"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#756
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#663
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product_offer p0_ INNER JOIN product p1_ ON p0_.product_id = p1_.id INNER JOIN customer c2_ ON p0_.customer_id = c2_.id LEFT JOIN category c3_ ON p1_.category_id = c3_.id WHERE p1_.seller_id = ? AND ((p0_.status = ? AND p0_.responded_by_seller_id IS NULL) OR (p0_.status = ? AND p0_.counter_expires_at IS NOT NULL AND p0_.counter_expires_at < ?))"
  "params" => [
    1 => 2
    2 => "declined"
    3 => "countered"
    4 => "2026-07-24 12:01:20"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#756
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#663
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#663}
    4 => Doctrine\DBAL\ParameterType {#663}
  ]
]

[
  "sql" => "SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM customer_order c0_ LEFT JOIN customer_order_item c1_ ON c0_.id = c1_.order_ref_id LEFT JOIN product p2_ ON c1_.product_id = p2_.id LEFT JOIN seller s3_ ON p2_.seller_id = s3_.id WHERE s3_.id = ? AND c0_.status <> ? AND c0_.status = ?"
  "params" => [
    1 => 2
    2 => "draft"
    3 => "pending"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#756
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#663
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#663}
  ]
]

[
  "sql" => "SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM customer_order c0_ LEFT JOIN customer_order_item c1_ ON c0_.id = c1_.order_ref_id LEFT JOIN product p2_ ON c1_.product_id = p2_.id LEFT JOIN seller s3_ ON p2_.seller_id = s3_.id WHERE s3_.id = ? AND c0_.status <> ? AND c0_.status IN (?, ?) AND (NOT EXISTS (SELECT o4_.id FROM order_shipment o4_ WHERE o4_.order_ref_id = c0_.id AND o4_.status IN (?, ?, ?)))"
  "params" => [
    1 => 2
    2 => "draft"
    3 => "in_progress"
    4 => "ready"
    5 => "handed_over"
    6 => "in_transit"
    7 => "delivered"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#756
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#663
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#663}
    4 => Doctrine\DBAL\ParameterType {#663}
    5 => Doctrine\DBAL\ParameterType {#663}
    6 => Doctrine\DBAL\ParameterType {#663}
    7 => Doctrine\DBAL\ParameterType {#663}
  ]
]

[
  "sql" => "SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM customer_order c0_ LEFT JOIN customer_order_item c1_ ON c0_.id = c1_.order_ref_id LEFT JOIN product p2_ ON c1_.product_id = p2_.id LEFT JOIN seller s3_ ON p2_.seller_id = s3_.id WHERE s3_.id = ? AND c0_.status <> ? AND c0_.status NOT IN (?, ?) AND c0_.delivery_deadline IS NOT NULL AND c0_.delivery_deadline < ?"
  "params" => [
    1 => 2
    2 => "draft"
    3 => "completed"
    4 => "cancelled"
    5 => "2026-07-24 12:01:20"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#756
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#663
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#663}
    4 => Doctrine\DBAL\ParameterType {#663}
    5 => Doctrine\DBAL\ParameterType {#663}
  ]
]

[
  "sql" => "SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM customer_order c0_ LEFT JOIN customer_order_item c1_ ON c0_.id = c1_.order_ref_id LEFT JOIN product p2_ ON c1_.product_id = p2_.id LEFT JOIN seller s3_ ON p2_.seller_id = s3_.id WHERE s3_.id = ? AND c0_.status <> ? AND (EXISTS (SELECT o4_.id FROM order_return o4_ WHERE o4_.order_ref_id = c0_.id AND o4_.status NOT IN (?, ?, ?)))"
  "params" => [
    1 => 2
    2 => "draft"
    3 => "refunded"
    4 => "completed"
    5 => "declined"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#756
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#663
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#663}
    4 => Doctrine\DBAL\ParameterType {#663}
    5 => Doctrine\DBAL\ParameterType {#663}
  ]
]

[
  "sql" => "SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM customer_order c0_ LEFT JOIN customer_order_item c1_ ON c0_.id = c1_.order_ref_id LEFT JOIN product p2_ ON c1_.product_id = p2_.id LEFT JOIN seller s3_ ON p2_.seller_id = s3_.id WHERE s3_.id = ? AND c0_.status <> ?"
  "params" => [
    1 => 2
    2 => "draft"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#756
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#663
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(s0_.seller_unread_count), 0) AS sclr_0 FROM support_ticket s0_ WHERE s0_.seller_id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#756
      +name: "INTEGER"
    }
  ]
]

[
  "key" => "_security_main"
]