Query Metrics
6
Database Queries
5
Different statements
9.51 ms
Query time
0
Invalid entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
2.96 ms (31.18%) |
2 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.intro AS intro_4, t0.has_home_matches AS has_home_matches_5, t0.description AS description_6, t0.practical_info AS practical_info_7, t0.city_info AS city_info_8, t0.deleted AS deleted_9, t0.meta_title AS meta_title_10, t0.meta_description AS meta_description_11, t0.logo_id AS logo_id_12, t0.country_id AS country_id_13, t0.hero_id AS hero_id_14, t0.content_hero_id AS content_hero_id_15, t0.stadium_id AS stadium_id_16 FROM club t0 WHERE t0.id = ? AND ((t0.deleted IS NULL))
Parameters:
[
40
]
|
|
2.39 ms (25.10%) |
1 |
SELECT DATABASE()
Parameters:
[] |
|
1.50 ms (15.73%) |
1 |
SELECT t0.id AS id_1, t0.date AS date_2, t0.cheapest_accommodation AS cheapest_accommodation_3, t0.match_ticket_price AS match_ticket_price_4, t0.match_ticket_price_base AS match_ticket_price_base_5, t0.final AS final_6, t0.offer AS offer_7, t0.popular AS popular_8, t0.has_flight AS has_flight_9, t0.disable_booking AS disable_booking_10, t0.first_of_month AS first_of_month_11, t0.last_sync_date AS last_sync_date_12, t0.sync_time AS sync_time_13, t0.sync_status AS sync_status_14, t0.sync_message AS sync_message_15, t0.home_club_id AS home_club_id_16, t0.away_club_id AS away_club_id_17, t0.match_country_id AS match_country_id_18, t0.competition_id AS competition_id_19, t0.stadium_id AS stadium_id_20 FROM `match` t0 WHERE t0.id = ?
Parameters:
[
"143"
]
|
|
1.44 ms (15.19%) |
1 |
SELECT f0_.name AS name_0, f0_.active AS active_1 FROM feature f0_
Parameters:
[] |
|
1.22 ms (12.79%) |
1 |
SELECT t0.id AS id_1, t0.source AS source_2, t0.destination AS destination_3, t0.is_permanent AS is_permanent_4 FROM redirect t0 WHERE t0.source = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[
"/checkout/143"
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| parent | doctrine.dbal.parent_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| parent | doctrine.orm.parent_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
default entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\CustomTranslation | No errors. |
| App\Entity\CompanyMatchUser | No errors. |
| App\Entity\CompanyMatch | No errors. |
| App\Entity\Vacancy | No errors. |
| App\Entity\WebServiceApiKey | No errors. |
| App\Entity\Redirect | No errors. |
| App\Entity\Game | No errors. |
| App\Entity\Club | No errors. |
| App\Entity\Country | No errors. |
| App\Entity\Competition | No errors. |
| App\Entity\Stadium | No errors. |
| App\Entity\GameCategory | No errors. |
| App\Entity\Asset | No errors. |
| App\Entity\ClubInformation | No errors. |
| App\Entity\Feature | No errors. |
parent entity manager
No loaded entities.