GET http://api.getfastesim.com/api/mobile/countries/267/plans?category=sim

Query Metrics

7 Database Queries
4 Different statements
6.83 ms Query time
0 Invalid entities
30 Managed entities

Queries

Group similar statements

# Time Info
1 1.28 ms
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 = ?
Parameters:
[
  267
]
2 0.88 ms
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
Parameters:
[
  "STANDARD_MARGIN_PERCENT"
]
3 2.25 ms
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 = ?
Parameters:
[
  267
]
4 0.69 ms
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 = ?
Parameters:
[
  7854
]
5 0.61 ms
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 = ?
Parameters:
[
  7855
]
6 0.58 ms
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 = ?
Parameters:
[
  7856
]
7 0.54 ms
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 = ?
Parameters:
[
  7857
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Plan 29
App\Entity\Country 1

Entities Mapping

Class Mapping errors
App\Entity\Country No errors.
App\Entity\Plan No errors.
App\Entity\AppSetting No errors.
App\Entity\Order No errors.