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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
3.84 ms
(33.92%)
1
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
]
3.73 ms
(32.95%)
4
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
]
2.25 ms
(19.89%)
1
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
]
1.50 ms
(13.25%)
1
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"
]

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.