Symfony Profiler

[
  "route" => "app_dashboard"
  "route_parameters" => [
    "_route" => "app_dashboard"
    "_controller" => "App\Controller\DashboardController::index"
  ]
  "request_uri" => "https://itastock.com.ar/app/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\UsernamePasswordToken"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "itas_admin"
    "password" => "<redacted>"
    "driverOptions" => []
    "serverVersion" => "10.11.2-MariaDB"
    "defaultTableOptions" => []
    "dbname" => "itas_db"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.full_name AS full_name_5, t0.reset_token AS reset_token_6, t0.reset_requested_at AS reset_requested_at_7, t0.is_active AS is_active_8, t0.business_id AS business_id_9 FROM users t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#795
      +name: "INTEGER"
    }
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "juanquiross@gmail.com"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3, t0.created_at AS created_at_4, t5.id AS id_6, t5.status AS status_7, t5.start_at AS start_at_8, t5.end_at AS end_at_9, t5.trial_ends_at AS trial_ends_at_10, t5.notes AS notes_11, t5.mp_preapproval_id AS mp_preapproval_id_12, t5.mp_preapproval_plan_id AS mp_preapproval_plan_id_13, t5.payer_email AS payer_email_14, t5.last_synced_at AS last_synced_at_15, t5.override_mode AS override_mode_16, t5.override_until AS override_until_17, t5.created_at AS created_at_18, t5.updated_at AS updated_at_19, t5.business_id AS business_id_20, t5.plan_id AS plan_id_21 FROM business t0 LEFT JOIN subscriptions t5 ON t5.business_id = t0.id WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#795
      +name: "INTEGER"
    }
  ]
]

[
  "key" => "dashboard_summary_1_1"
]

[
  "sql" => "SELECT COALESCE(SUM(s0_.total), 0) AS sclr_0, COUNT(s0_.id) AS sclr_1, COALESCE(AVG(s0_.total), 0) AS sclr_2 FROM sales s0_ WHERE s0_.business_id = ? AND s0_.created_at >= ? AND s0_.created_at < ? AND s0_.status = ?"
  "params" => [
    1 => 1
    2 => "2025-12-29 00:00:00"
    3 => "2025-12-30 00:00:00"
    4 => "CONFIRMED"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#795
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1214
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#1214}
    4 => Doctrine\DBAL\ParameterType {#1214}
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.opened_at AS opened_at_1, c0_.closed_at AS closed_at_2, c0_.initial_cash AS initial_cash_3, c0_.final_cash_counted AS final_cash_counted_4, c0_.totals_by_payment_method AS totals_by_payment_method_5, c0_.business_id AS business_id_6, c0_.opened_by_id AS opened_by_id_7 FROM cash_sessions c0_ WHERE c0_.business_id = ? AND c0_.opened_by_id = ? AND c0_.closed_at IS NULL LIMIT 1"
  "params" => [
    1 => 1
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#795
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#795}
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(s0_.total), 0) AS sclr_0, COUNT(s0_.id) AS sclr_1, COALESCE(AVG(s0_.total), 0) AS sclr_2 FROM sales s0_ WHERE s0_.business_id = ? AND s0_.created_at >= ? AND s0_.created_at < ? AND s0_.status = ?"
  "params" => [
    1 => 1
    2 => "2025-12-01 00:00:00"
    3 => "2026-01-01 00:00:00"
    4 => "CONFIRMED"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#795
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1214
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#1214}
    4 => Doctrine\DBAL\ParameterType {#1214}
  ]
]

[
  "sql" => "SELECT p0_.method AS method_0, COALESCE(SUM(p0_.amount), 0) AS sclr_1 FROM payments p0_ INNER JOIN sales s1_ ON p0_.sale_id = s1_.id WHERE s1_.business_id = ? AND s1_.status = ? AND p0_.created_at >= ? AND p0_.created_at < ? GROUP BY p0_.method"
  "params" => [
    1 => 1
    2 => "CONFIRMED"
    3 => "2025-12-01 00:00:00"
    4 => "2026-01-01 00:00:00"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#795
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1214
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#1214}
    4 => Doctrine\DBAL\ParameterType {#1214}
  ]
]

[
  "sql" => "SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM sales s1_ LEFT JOIN customers c0_ ON s1_.customer_id = c0_.id WHERE s1_.business_id = ? AND s1_.created_at >= ? AND s1_.created_at < ? AND s1_.status = ? AND c0_.id IS NOT NULL AND c0_.is_active = 1"
  "params" => [
    1 => 1
    2 => "2025-12-01 00:00:00"
    3 => "2026-01-01 00:00:00"
    4 => "CONFIRMED"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#795
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1214
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#1214}
    4 => Doctrine\DBAL\ParameterType {#1214}
  ]
]

[
  "sql" => """
        SELECT DATE_FORMAT(s.created_at, '%H') AS hour, COALESCE(SUM(s.total), 0) AS amount\n
        FROM sales s\n
        WHERE s.business_id = ?\n
          AND s.created_at >= ?\n
          AND s.created_at < ?\n
          AND s.status = 'CONFIRMED' GROUP BY hour ORDER BY hour ASC
    """
  "params" => [
    1 => 1
    2 => "2025-12-29 00:00:00"
    3 => "2025-12-30 00:00:00"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1214
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1214}
    3 => Doctrine\DBAL\ParameterType {#1214}
  ]
]

[
  "sql" => """
        SELECT DATE_FORMAT(s.created_at, '%Y-%m-%d') AS date, COALESCE(SUM(s.total), 0) AS amount\n
        FROM sales s\n
        WHERE s.business_id = ?\n
          AND s.created_at >= ?\n
          AND s.created_at < ?\n
          AND s.status = 'CONFIRMED'\n
        GROUP BY date\n
        ORDER BY date ASC
    """
  "params" => [
    1 => 1
    2 => "2025-12-23 00:00:00"
    3 => "2025-12-30 00:00:00"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1214
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1214}
    3 => Doctrine\DBAL\ParameterType {#1214}
  ]
]

[
  "sql" => "SELECT p0_.method AS method_0, COALESCE(SUM(p0_.amount), 0) AS sclr_1 FROM payments p0_ INNER JOIN sales s1_ ON p0_.sale_id = s1_.id WHERE s1_.business_id = ? AND s1_.status = ? AND p0_.created_at >= ? AND p0_.created_at < ? GROUP BY p0_.method"
  "params" => [
    1 => 1
    2 => "CONFIRMED"
    3 => "2025-12-29 00:00:00"
    4 => "2025-12-30 00:00:00"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#795
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1214
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#1214}
    4 => Doctrine\DBAL\ParameterType {#1214}
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.sku AS sku_1, p0_.name AS name_2, p0_.stock AS stock_3, p0_.stock_min AS stock_min_4, p0_.stock - p0_.stock_min AS sclr_5 FROM products p0_ WHERE p0_.business_id = ? AND p0_.stock <= p0_.stock_min ORDER BY sclr_5 ASC LIMIT 5"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#795
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT c0_.customer_id AS sclr_0, COALESCE(SUM(CASE WHEN c0_.type = ? THEN c0_.amount ELSE -c0_.amount END), 0) AS sclr_1, MAX(c0_.created_at) AS sclr_2 FROM customer_account_movements c0_ WHERE c0_.business_id = ? GROUP BY c0_.customer_id HAVING COALESCE(SUM(CASE WHEN c0_.type = ? THEN c0_.amount ELSE -c0_.amount END), 0) > 0 ORDER BY sclr_1 DESC LIMIT 5"
  "params" => [
    1 => "DEBIT"
    2 => 1
    3 => "DEBIT"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1214
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#795
      +name: "INTEGER"
    }
    3 => Doctrine\DBAL\ParameterType {#1214}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.document_type AS document_type_3, t0.document_number AS document_number_4, t0.phone AS phone_5, t0.address AS address_6, t0.customer_type AS customer_type_7, t0.is_active AS is_active_8, t0.created_at AS created_at_9, t0.business_id AS business_id_10, t0.price_list_id AS price_list_id_11 FROM customers t0 WHERE t0.id IN (?, ?)"
  "params" => [
    1 => 1
    2 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#795
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#795}
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.created_at AS created_at_1, s0_.total AS total_2, COALESCE(c1_.name, ?) AS sclr_3, MIN(p2_.method) AS sclr_4 FROM sales s0_ LEFT JOIN customers c1_ ON s0_.customer_id = c1_.id LEFT JOIN payments p2_ ON s0_.id = p2_.sale_id WHERE s0_.business_id = ? AND s0_.status = ? GROUP BY s0_.id, c1_.name, s0_.created_at, s0_.total ORDER BY s0_.created_at DESC LIMIT 10"
  "params" => [
    1 => "Consumidor final"
    2 => 1
    3 => "CONFIRMED"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1214
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#795
      +name: "INTEGER"
    }
    3 => Doctrine\DBAL\ParameterType {#1214}
  ]
]

[
  "key" => "_security_main"
]