Symfony Profiler

[
  "route" => "api_mobile_country_plans"
  "route_parameters" => [
    "_route" => "api_mobile_country_plans"
    "_controller" => "App\Controller\Api\MobileApiController::getCountryPlans"
    "id" => "267"
  ]
  "request_uri" => "http://api.getfastesim.com/api/mobile/countries/267/plans?category=sim"
  "method" => "GET"
]

[
  "params" => [
    "driver" => "pdo_pgsql"
    "idle_connection_ttl" => 600
    "host" => "ea57459-002.eu.clouddb.ovh.net"
    "port" => 35510
    "user" => "fastesim"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "fastesim"
    "serverVersion" => "18"
    "charset" => "utf8"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.iso_code AS iso_code_3, t0.flag_url AS flag_url_4, t0.is_active AS is_active_5, t0.is_popular AS is_popular_6, t0.created_at AS created_at_7 FROM country t0 WHERE t0.id = ?"
  "params" => [
    1 => 267
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#744
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3 FROM app_settings t0 WHERE t0.setting_key = ? LIMIT 1"
  "params" => [
    1 => "STANDARD_MARGIN_PERCENT"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#856
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.data_gb AS data_gb_4, t0.duration_days AS duration_days_5, t0.price AS price_6, t0.initial_price AS initial_price_7, t0.is_unlimited AS is_unlimited_8, t0.is_active AS is_active_9, t0.currency AS currency_10, t0.package_code AS package_code_11, t0.raw_data AS raw_data_12, t0.category AS category_13, t0.slug AS slug_14, t0.location_code AS location_code_15, t0.location_logo AS location_logo_16, t0.description AS description_17, t0.favorite AS favorite_18, t0.operator_list AS operator_list_19, t0.location AS location_20, t0.created_at AS created_at_21 FROM plan t0 INNER JOIN plan_country ON t0.id = plan_country.plan_id WHERE plan_country.country_id = ?"
  "params" => [
    1 => 267
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#744
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.iso_code AS iso_code_3, t0.flag_url AS flag_url_4, t0.is_active AS is_active_5, t0.is_popular AS is_popular_6, t0.created_at AS created_at_7 FROM country t0 INNER JOIN plan_country ON t0.id = plan_country.country_id WHERE plan_country.plan_id = ?"
  "params" => [
    1 => 7854
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#744
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.iso_code AS iso_code_3, t0.flag_url AS flag_url_4, t0.is_active AS is_active_5, t0.is_popular AS is_popular_6, t0.created_at AS created_at_7 FROM country t0 INNER JOIN plan_country ON t0.id = plan_country.country_id WHERE plan_country.plan_id = ?"
  "params" => [
    1 => 7855
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#744
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.iso_code AS iso_code_3, t0.flag_url AS flag_url_4, t0.is_active AS is_active_5, t0.is_popular AS is_popular_6, t0.created_at AS created_at_7 FROM country t0 INNER JOIN plan_country ON t0.id = plan_country.country_id WHERE plan_country.plan_id = ?"
  "params" => [
    1 => 7856
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#744
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.iso_code AS iso_code_3, t0.flag_url AS flag_url_4, t0.is_active AS is_active_5, t0.is_popular AS is_popular_6, t0.created_at AS created_at_7 FROM country t0 INNER JOIN plan_country ON t0.id = plan_country.country_id WHERE plan_country.plan_id = ?"
  "params" => [
    1 => 7857
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#744
      +name: "INTEGER"
    }
  ]
]