Symfony Profiler

[
  "route" => "default_dashboard"
  "route_parameters" => [
    "_route" => "default_dashboard"
    "_controller" => "App\Module\Shared\Controller\DefaultController::dashboard"
  ]
  "request_uri" => "https://managoo.korki.me/?end=2026-04-18&start=2026-04-18"
  "method" => "GET"
]

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

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

[
  "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\RememberMeToken"
]

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

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.full_name AS full_name_4, t0.password AS password_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM `user` t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "michal@gmmedia.biz"
]

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

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

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

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

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bridge\Doctrine\Middleware\IdleConnection\Listener::onKernelRequest"
]

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

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

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

[
  "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\IsCsrfTokenValidAttributeListener::onKernelControllerArguments"
]

[
  "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" => "ContainerNxA8Pbo\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments"
]

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

[
  "sql" => """
    SELECT\n
        :start AS date_from,\n
        :end AS date_to,\n
        combined.main_product_name,\n
        SUM(combined.daily_cost)   AS total_cost,\n
        SUM(combined.daily_profit) AS total_profit,\n
        CASE\n
            WHEN SUM(combined.daily_cost) = 0 THEN 0\n
            ELSE ROUND(SUM(combined.daily_profit) / SUM(combined.daily_cost), 2)\n
        END AS roas\n
    FROM (\n
        SELECT\n
            mp.name AS main_product_name,\n
            m.date AS order_date,\n
            SUM(m.spend) AS daily_cost,\n
            0 AS daily_profit\n
        FROM ads_metrics m\n
        JOIN ads_ads a ON m.ad_id = a.id\n
        JOIN ads_ad_sets s ON a.ad_set_id = s.id\n
        JOIN ads_campaign c ON s.campaign_id = c.id\n
        JOIN main_product mp ON c.main_product_id = mp.id\n
        WHERE m.date BETWEEN :start AND :end\n
        \n
        GROUP BY mp.name, m.date\n
    \n
        UNION ALL\n
    \n
        SELECT\n
            COALESCE(mp.name, 'unsorted') AS main_product_name,\n
            DATE(o.created_at) AS order_date,\n
            0 AS daily_cost,\n
            SUM(o.gross) AS daily_profit\n
        FROM `order` o\n
        LEFT JOIN main_product mp ON o.main_product_id = mp.id\n
        WHERE DATE(o.created_at) BETWEEN :start AND :end\n
        \n
        GROUP BY COALESCE(mp.name, 'unsorted'), DATE(o.created_at)\n
    ) AS combined\n
    GROUP BY combined.main_product_name\n
    ORDER BY combined.main_product_name;
    """
  "params" => [
    ":start" => "2026-04-18"
    ":end" => "2026-04-18"
  ]
  "types" => [
    ":start" => 2
    ":end" => 2
  ]
]

[
  "sql" => """
    SELECT\n
        CONCAT(:start, '') AS date_start,\n
        CONCAT(:end, '') AS date_end,\n
        SUM(t.total_cost) AS total_cost,\n
        SUM(t.total_gross) AS total_gross,\n
        SUM(t.total_net) AS total_net,\n
        CASE\n
          WHEN SUM(t.total_cost) = 0 THEN 0\n
          ELSE ROUND(SUM(t.total_gross) / SUM(t.total_cost), 2)\n
        END AS roas\n
    FROM (\n
        SELECT \n
            SUM(m.spend) AS total_cost,\n
            0 AS total_gross,\n
            0 AS total_net\n
        FROM ads_metrics m\n
        WHERE m.date BETWEEN :start AND :end\n
    \n
        UNION ALL\n
    \n
        SELECT \n
            0 AS total_cost,\n
            SUM(o.gross) AS total_gross,\n
            SUM(o.net5 + o.net23) AS total_net\n
        FROM `order` o\n
        WHERE DATE(o.created_at) BETWEEN :start AND :end\n
    ) t;
    """
  "params" => [
    ":start" => "2026-04-18"
    ":end" => "2026-04-18"
  ]
  "types" => [
    ":start" => 2
    ":end" => 2
  ]
]

[
  "sql" => """
    SELECT\n
        CONCAT(:start, '') AS date_start,\n
        CONCAT(:end, '') AS date_end,\n
        SUM(t.total_cost) AS total_cost,\n
        SUM(t.total_gross) AS total_gross,\n
        SUM(t.total_net) AS total_net,\n
        CASE\n
          WHEN SUM(t.total_cost) = 0 THEN 0\n
          ELSE ROUND(SUM(t.total_gross) / SUM(t.total_cost), 2)\n
        END AS roas\n
    FROM (\n
        SELECT \n
            SUM(m.spend) AS total_cost,\n
            0 AS total_gross,\n
            0 AS total_net\n
        FROM ads_metrics m\n
        WHERE m.date BETWEEN :start AND :end\n
    \n
        UNION ALL\n
    \n
        SELECT \n
            0 AS total_cost,\n
            SUM(o.gross) AS total_gross,\n
            SUM(o.net5 + o.net23) AS total_net\n
        FROM `order` o\n
        WHERE DATE(o.created_at) BETWEEN :start AND :end\n
    ) t;
    """
  "params" => [
    ":start" => "2026-04-18"
    ":end" => "2026-04-18"
  ]
  "types" => [
    ":start" => 2
    ":end" => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.unique_name AS unique_name_3, t0.sort AS sort_4, t0.is_active AS is_active_5 FROM main_product t0 WHERE t0.is_active = ? ORDER BY t0.sort ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 5
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.is_active AS is_active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.main_product_id AS main_product_id_7 FROM ads_campaign t0 WHERE t0.main_product_id = ?"
  "params" => [
    1 => 10
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.is_active AS is_active_4, t0.campaign_id AS campaign_id_5 FROM ads_ad_sets t0 WHERE t0.campaign_id = ? ORDER BY t0.name ASC"
  "params" => [
    1 => 50
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.is_active AS is_active_4, t0.ad_set_id AS ad_set_id_5 FROM ads_ads t0 WHERE t0.ad_set_id = ?"
  "params" => [
    1 => 147
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 276
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.is_active AS is_active_4, t0.ad_set_id AS ad_set_id_5 FROM ads_ads t0 WHERE t0.ad_set_id = ?"
  "params" => [
    1 => 154
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 283
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.is_active AS is_active_4, t0.ad_set_id AS ad_set_id_5 FROM ads_ads t0 WHERE t0.ad_set_id = ?"
  "params" => [
    1 => 149
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 278
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.is_active AS is_active_4, t0.ad_set_id AS ad_set_id_5 FROM ads_ads t0 WHERE t0.ad_set_id = ?"
  "params" => [
    1 => 156
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 285
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.is_active AS is_active_4, t0.ad_set_id AS ad_set_id_5 FROM ads_ads t0 WHERE t0.ad_set_id = ?"
  "params" => [
    1 => 150
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 279
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.is_active AS is_active_4, t0.ad_set_id AS ad_set_id_5 FROM ads_ads t0 WHERE t0.ad_set_id = ?"
  "params" => [
    1 => 155
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 284
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.is_active AS is_active_4, t0.ad_set_id AS ad_set_id_5 FROM ads_ads t0 WHERE t0.ad_set_id = ?"
  "params" => [
    1 => 162
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 291
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.is_active AS is_active_4, t0.ad_set_id AS ad_set_id_5 FROM ads_ads t0 WHERE t0.ad_set_id = ?"
  "params" => [
    1 => 148
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 277
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.is_active AS is_active_4, t0.ad_set_id AS ad_set_id_5 FROM ads_ads t0 WHERE t0.ad_set_id = ?"
  "params" => [
    1 => 157
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 286
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.is_active AS is_active_4, t0.ad_set_id AS ad_set_id_5 FROM ads_ads t0 WHERE t0.ad_set_id = ?"
  "params" => [
    1 => 145
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 274
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.is_active AS is_active_4, t0.ad_set_id AS ad_set_id_5 FROM ads_ads t0 WHERE t0.ad_set_id = ?"
  "params" => [
    1 => 152
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 281
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.is_active AS is_active_4, t0.ad_set_id AS ad_set_id_5 FROM ads_ads t0 WHERE t0.ad_set_id = ?"
  "params" => [
    1 => 163
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 292
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 276
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.impressions AS impressions_2, t0.spend AS spend_3, t0.ctr AS ctr_4, t0.date AS date_5, t0.ad_id AS ad_id_6 FROM ads_metrics t0 WHERE ((t0.date >= ? AND t0.date <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18"
    2 => "2026-04-18"
    3 => 276
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 276
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 283
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.impressions AS impressions_2, t0.spend AS spend_3, t0.ctr AS ctr_4, t0.date AS date_5, t0.ad_id AS ad_id_6 FROM ads_metrics t0 WHERE ((t0.date >= ? AND t0.date <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18"
    2 => "2026-04-18"
    3 => 283
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 283
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 278
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.impressions AS impressions_2, t0.spend AS spend_3, t0.ctr AS ctr_4, t0.date AS date_5, t0.ad_id AS ad_id_6 FROM ads_metrics t0 WHERE ((t0.date >= ? AND t0.date <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18"
    2 => "2026-04-18"
    3 => 278
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 278
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 285
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.impressions AS impressions_2, t0.spend AS spend_3, t0.ctr AS ctr_4, t0.date AS date_5, t0.ad_id AS ad_id_6 FROM ads_metrics t0 WHERE ((t0.date >= ? AND t0.date <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18"
    2 => "2026-04-18"
    3 => 285
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 285
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 279
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.impressions AS impressions_2, t0.spend AS spend_3, t0.ctr AS ctr_4, t0.date AS date_5, t0.ad_id AS ad_id_6 FROM ads_metrics t0 WHERE ((t0.date >= ? AND t0.date <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18"
    2 => "2026-04-18"
    3 => 279
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 279
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 284
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.impressions AS impressions_2, t0.spend AS spend_3, t0.ctr AS ctr_4, t0.date AS date_5, t0.ad_id AS ad_id_6 FROM ads_metrics t0 WHERE ((t0.date >= ? AND t0.date <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18"
    2 => "2026-04-18"
    3 => 284
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 284
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 291
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.impressions AS impressions_2, t0.spend AS spend_3, t0.ctr AS ctr_4, t0.date AS date_5, t0.ad_id AS ad_id_6 FROM ads_metrics t0 WHERE ((t0.date >= ? AND t0.date <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18"
    2 => "2026-04-18"
    3 => 291
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 291
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 277
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.impressions AS impressions_2, t0.spend AS spend_3, t0.ctr AS ctr_4, t0.date AS date_5, t0.ad_id AS ad_id_6 FROM ads_metrics t0 WHERE ((t0.date >= ? AND t0.date <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18"
    2 => "2026-04-18"
    3 => 277
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 277
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 286
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.impressions AS impressions_2, t0.spend AS spend_3, t0.ctr AS ctr_4, t0.date AS date_5, t0.ad_id AS ad_id_6 FROM ads_metrics t0 WHERE ((t0.date >= ? AND t0.date <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18"
    2 => "2026-04-18"
    3 => 286
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 286
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 274
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.impressions AS impressions_2, t0.spend AS spend_3, t0.ctr AS ctr_4, t0.date AS date_5, t0.ad_id AS ad_id_6 FROM ads_metrics t0 WHERE ((t0.date >= ? AND t0.date <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18"
    2 => "2026-04-18"
    3 => 274
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 274
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 281
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.impressions AS impressions_2, t0.spend AS spend_3, t0.ctr AS ctr_4, t0.date AS date_5, t0.ad_id AS ad_id_6 FROM ads_metrics t0 WHERE ((t0.date >= ? AND t0.date <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18"
    2 => "2026-04-18"
    3 => 281
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 281
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 292
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.impressions AS impressions_2, t0.spend AS spend_3, t0.ctr AS ctr_4, t0.date AS date_5, t0.ad_id AS ad_id_6 FROM ads_metrics t0 WHERE ((t0.date >= ? AND t0.date <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18"
    2 => "2026-04-18"
    3 => 292
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 292
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.is_active AS is_active_4, t0.campaign_id AS campaign_id_5 FROM ads_ad_sets t0 WHERE t0.campaign_id = ? ORDER BY t0.name ASC"
  "params" => [
    1 => 51
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.is_active AS is_active_4, t0.ad_set_id AS ad_set_id_5 FROM ads_ads t0 WHERE t0.ad_set_id = ?"
  "params" => [
    1 => 146
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 275
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 322
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 332
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.is_active AS is_active_4, t0.ad_set_id AS ad_set_id_5 FROM ads_ads t0 WHERE t0.ad_set_id = ?"
  "params" => [
    1 => 151
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 280
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.is_active AS is_active_4, t0.ad_set_id AS ad_set_id_5 FROM ads_ads t0 WHERE t0.ad_set_id = ?"
  "params" => [
    1 => 175
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 309
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 313
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 275
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 322
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 332
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.impressions AS impressions_2, t0.spend AS spend_3, t0.ctr AS ctr_4, t0.date AS date_5, t0.ad_id AS ad_id_6 FROM ads_metrics t0 WHERE ((t0.date >= ? AND t0.date <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18"
    2 => "2026-04-18"
    3 => 275
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 275
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.impressions AS impressions_2, t0.spend AS spend_3, t0.ctr AS ctr_4, t0.date AS date_5, t0.ad_id AS ad_id_6 FROM ads_metrics t0 WHERE ((t0.date >= ? AND t0.date <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18"
    2 => "2026-04-18"
    3 => 322
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 322
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.impressions AS impressions_2, t0.spend AS spend_3, t0.ctr AS ctr_4, t0.date AS date_5, t0.ad_id AS ad_id_6 FROM ads_metrics t0 WHERE ((t0.date >= ? AND t0.date <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18"
    2 => "2026-04-18"
    3 => 332
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 332
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 280
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.impressions AS impressions_2, t0.spend AS spend_3, t0.ctr AS ctr_4, t0.date AS date_5, t0.ad_id AS ad_id_6 FROM ads_metrics t0 WHERE ((t0.date >= ? AND t0.date <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18"
    2 => "2026-04-18"
    3 => 280
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 280
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 309
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 313
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.impressions AS impressions_2, t0.spend AS spend_3, t0.ctr AS ctr_4, t0.date AS date_5, t0.ad_id AS ad_id_6 FROM ads_metrics t0 WHERE ((t0.date >= ? AND t0.date <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18"
    2 => "2026-04-18"
    3 => 309
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 309
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.impressions AS impressions_2, t0.spend AS spend_3, t0.ctr AS ctr_4, t0.date AS date_5, t0.ad_id AS ad_id_6 FROM ads_metrics t0 WHERE ((t0.date >= ? AND t0.date <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18"
    2 => "2026-04-18"
    3 => 313
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 313
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.is_active AS is_active_4, t0.campaign_id AS campaign_id_5 FROM ads_ad_sets t0 WHERE t0.campaign_id = ? ORDER BY t0.name ASC"
  "params" => [
    1 => 53
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.is_active AS is_active_4, t0.ad_set_id AS ad_set_id_5 FROM ads_ads t0 WHERE t0.ad_set_id = ?"
  "params" => [
    1 => 161
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 290
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.is_active AS is_active_4, t0.ad_set_id AS ad_set_id_5 FROM ads_ads t0 WHERE t0.ad_set_id = ?"
  "params" => [
    1 => 164
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 293
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.is_active AS is_active_4, t0.ad_set_id AS ad_set_id_5 FROM ads_ads t0 WHERE t0.ad_set_id = ?"
  "params" => [
    1 => 177
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 316
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 319
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.is_active AS is_active_4, t0.ad_set_id AS ad_set_id_5 FROM ads_ads t0 WHERE t0.ad_set_id = ?"
  "params" => [
    1 => 178
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 317
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 318
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 290
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.impressions AS impressions_2, t0.spend AS spend_3, t0.ctr AS ctr_4, t0.date AS date_5, t0.ad_id AS ad_id_6 FROM ads_metrics t0 WHERE ((t0.date >= ? AND t0.date <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18"
    2 => "2026-04-18"
    3 => 290
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 290
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 293
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.impressions AS impressions_2, t0.spend AS spend_3, t0.ctr AS ctr_4, t0.date AS date_5, t0.ad_id AS ad_id_6 FROM ads_metrics t0 WHERE ((t0.date >= ? AND t0.date <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18"
    2 => "2026-04-18"
    3 => 293
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 293
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 316
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 319
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.impressions AS impressions_2, t0.spend AS spend_3, t0.ctr AS ctr_4, t0.date AS date_5, t0.ad_id AS ad_id_6 FROM ads_metrics t0 WHERE ((t0.date >= ? AND t0.date <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18"
    2 => "2026-04-18"
    3 => 316
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 316
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.impressions AS impressions_2, t0.spend AS spend_3, t0.ctr AS ctr_4, t0.date AS date_5, t0.ad_id AS ad_id_6 FROM ads_metrics t0 WHERE ((t0.date >= ? AND t0.date <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18"
    2 => "2026-04-18"
    3 => 319
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 319
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 317
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 WHERE ((t0.created_at >= ? AND t0.created_at <= ?) AND t0.ad_id = ?)"
  "params" => [
    1 => "2026-04-18 00:00:00"
    2 => "2026-04-18 23:59:59"
    3 => 318
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]