Query Metrics
4
Database Queries
3
Different statements
2.38 ms
Query time
0
Invalid entities
10
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.88 ms |
SELECT a0_.id AS id_0, a0_.start_date AS start_date_1, a0_.end_date AS end_date_2, a0_.capacity AS capacity_3, a0_.location AS location_4, a0_.header AS header_5, a0_.text AS text_6, a0_.admin_note AS admin_note_7, a0_.status AS status_8, a0_.type AS type_9, a0_.email AS email_10, a0_.phone AS phone_11, a0_.project AS project_12, a0_.token AS token_13, a0_.creator_id AS creator_id_14, a0_.moderator_id AS moderator_id_15, a0_.moderated_game_id AS moderated_game_id_16 FROM app_meeting a0_ WHERE (a0_.start_date BETWEEN ? AND ?) AND a0_.project IN (?, ?) AND a0_.status IN (?)
Parameters:
[ "2025-12-01 00:00:00" "2025-12-31 23:59:59" "financnihra.cz" "vsfg.cz" "created" ] |
| 2 | 0.30 ms |
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.contact AS contact_3, t0.text AS text_4, t0.user_id AS user_id_5, t0.meeting_id AS meeting_id_6 FROM app_meeting_user t0 WHERE t0.meeting_id IN (?, ?)
Parameters:
[ 213 214 ] |
| 3 | 0.72 ms |
SELECT t0.id AS id_1, t0.password AS password_2, t0.role AS role_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.email AS email_6, t0.phone AS phone_7, t0.street AS street_8, t0.street_number AS street_number_9, t0.street_number_orientation AS street_number_orientation_10, t0.city AS city_11, t0.moderator_county AS moderator_county_12, t0.state AS state_13, t0.postal_code AS postal_code_14, t0.vat_number AS vat_number_15, t0.coupon AS coupon_16, t0.status AS status_17, t0.email_confirmation AS email_confirmation_18, t0.created_at AS created_at_19, t0.tutorial_step AS tutorial_step_20, t0.ip1 AS ip1_21, t0.image AS image_22, t0.display_name AS display_name_23, t0.age AS age_24, t0.gender AS gender_25, t0.alcohol AS alcohol_26, t0.smoke AS smoke_27, t0.weight AS weight_28, t0.height AS height_29, t0.bmi AS bmi_30, t0.couch AS couch_31, t0.walk AS walk_32, t0.run AS run_33, t0.home_food AS home_food_34, t0.fitness AS fitness_35, t0.fruit AS fruit_36, t0.vegetables AS vegetables_37, t0.energy_drink AS energy_drink_38, t0.bike AS bike_39, t0.joga AS joga_40, t0.swimming AS swimming_41, t0.sex AS sex_42, t0.restauration AS restauration_43, t0.fitness_couch AS fitness_couch_44, t0.fast_food AS fast_food_45, t0.candy AS candy_46, t0.work_type AS work_type_47, t0.food_koef AS food_koef_48, t0.move_koef AS move_koef_49, t0.newsletter AS newsletter_50, t0.custom_families_limit AS custom_families_limit_51, t0.integration_id AS integration_id_52, t0.is_external AS is_external_53, t0.avatar AS avatar_54, t0.avatar_options AS avatar_options_55, t0.last_login_at AS last_login_at_56, t0.registration_step AS registration_step_57, t0.email_verified_at AS email_verified_at_58, t0.referer_welcome_bonus_applied AS referer_welcome_bonus_applied_59, t0.company_registration_number AS company_registration_number_60, t0.forum_user_id AS forum_user_id_61, t0.forum_user_login AS forum_user_login_62, t0.games_finished AS games_finished_63, t0.games_started AS games_started_64, t0.total_score AS total_score_65, t0.average_score AS average_score_66, t0.participate_in_ladder AS participate_in_ladder_67, t0.county_id AS county_id_68, t69.id AS id_70, t69.basic AS basic_71, t69.basic_coupons AS basic_coupons_72, t69.county AS county_73, t69.county_coupons AS county_coupons_74, t69.custom AS custom_75, t69.custom_coupons AS custom_coupons_76, t69.moderated AS moderated_77, t69.moderated_coupons AS moderated_coupons_78, t69.duel AS duel_79, t69.duel_coupons AS duel_coupons_80, t69.tournament AS tournament_81, t69.tournament_coupons AS tournament_coupons_82, t69.scenario AS scenario_83, t69.scenario_coupons AS scenario_coupons_84, t69.theme AS theme_85, t69.theme_coupons AS theme_coupons_86, t69.moderator_monthly_coupons AS moderator_monthly_coupons_87, t69.user_id AS user_id_88, t0.supervisor_id AS supervisor_id_89, t0.referer_id AS referer_id_90 FROM app_user t0 LEFT JOIN app_game_available t69 ON t69.user_id = t0.id WHERE t0.id = ?
Parameters:
[
9
]
|
| 4 | 0.48 ms |
SELECT t0.id AS id_1, t0.password AS password_2, t0.role AS role_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.email AS email_6, t0.phone AS phone_7, t0.street AS street_8, t0.street_number AS street_number_9, t0.street_number_orientation AS street_number_orientation_10, t0.city AS city_11, t0.moderator_county AS moderator_county_12, t0.state AS state_13, t0.postal_code AS postal_code_14, t0.vat_number AS vat_number_15, t0.coupon AS coupon_16, t0.status AS status_17, t0.email_confirmation AS email_confirmation_18, t0.created_at AS created_at_19, t0.tutorial_step AS tutorial_step_20, t0.ip1 AS ip1_21, t0.image AS image_22, t0.display_name AS display_name_23, t0.age AS age_24, t0.gender AS gender_25, t0.alcohol AS alcohol_26, t0.smoke AS smoke_27, t0.weight AS weight_28, t0.height AS height_29, t0.bmi AS bmi_30, t0.couch AS couch_31, t0.walk AS walk_32, t0.run AS run_33, t0.home_food AS home_food_34, t0.fitness AS fitness_35, t0.fruit AS fruit_36, t0.vegetables AS vegetables_37, t0.energy_drink AS energy_drink_38, t0.bike AS bike_39, t0.joga AS joga_40, t0.swimming AS swimming_41, t0.sex AS sex_42, t0.restauration AS restauration_43, t0.fitness_couch AS fitness_couch_44, t0.fast_food AS fast_food_45, t0.candy AS candy_46, t0.work_type AS work_type_47, t0.food_koef AS food_koef_48, t0.move_koef AS move_koef_49, t0.newsletter AS newsletter_50, t0.custom_families_limit AS custom_families_limit_51, t0.integration_id AS integration_id_52, t0.is_external AS is_external_53, t0.avatar AS avatar_54, t0.avatar_options AS avatar_options_55, t0.last_login_at AS last_login_at_56, t0.registration_step AS registration_step_57, t0.email_verified_at AS email_verified_at_58, t0.referer_welcome_bonus_applied AS referer_welcome_bonus_applied_59, t0.company_registration_number AS company_registration_number_60, t0.forum_user_id AS forum_user_id_61, t0.forum_user_login AS forum_user_login_62, t0.games_finished AS games_finished_63, t0.games_started AS games_started_64, t0.total_score AS total_score_65, t0.average_score AS average_score_66, t0.participate_in_ladder AS participate_in_ladder_67, t0.county_id AS county_id_68, t69.id AS id_70, t69.basic AS basic_71, t69.basic_coupons AS basic_coupons_72, t69.county AS county_73, t69.county_coupons AS county_coupons_74, t69.custom AS custom_75, t69.custom_coupons AS custom_coupons_76, t69.moderated AS moderated_77, t69.moderated_coupons AS moderated_coupons_78, t69.duel AS duel_79, t69.duel_coupons AS duel_coupons_80, t69.tournament AS tournament_81, t69.tournament_coupons AS tournament_coupons_82, t69.scenario AS scenario_83, t69.scenario_coupons AS scenario_coupons_84, t69.theme AS theme_85, t69.theme_coupons AS theme_coupons_86, t69.moderator_monthly_coupons AS moderator_monthly_coupons_87, t69.user_id AS user_id_88, t0.supervisor_id AS supervisor_id_89, t0.referer_id AS referer_id_90 FROM app_user t0 LEFT JOIN app_game_available t69 ON t69.user_id = t0.id WHERE t0.id = ?
Parameters:
[
7
]
|
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\User\User | 3 |
| App\Entity\Event | 2 |
| App\Entity\EventParticipant | 2 |
| App\Entity\Game\GameAvailable | 2 |
| App\Entity\User\UserCounty | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Event | No errors. |
| App\Entity\User\User | No errors. |
| App\Entity\EventParticipant | No errors. |
| App\Entity\Game\ModeratedGame | No errors. |
| App\Entity\User\UserCounty | No errors. |
| App\Entity\Game\GameAvailable | No errors. |
| App\Entity\Coupon | No errors. |
| App\Entity\Game\Game | No errors. |
| App\Entity\User\UserGroup | No errors. |