Query Metrics
227
Database Queries
2
Different statements
377.13 ms
Query time
0
Invalid entities
2170
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
374.56 ms (99.32%) |
226 |
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:
[
203
]
|
||||||||||||||||||||||||||||||||
|
2.57 ms (0.68%) |
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.is_active = ? ORDER BY t0.name ASC
Parameters:
[
1
]
|
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 | 1944 |
| App\Entity\Country | 226 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Country | No errors. |
| App\Entity\Plan | No errors. |
| App\Entity\Order | No errors. |