Query Metrics
2
Database Queries
2
Different statements
1.36 ms
Query time
0
Invalid entities
4
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
0.77 ms (56.80%) |
1 |
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.start AS start_2, e0_.end AS end_3, e0_.launch_server AS launch_server_4, e0_.launch_scenario AS launch_scenario_5, e0_.location AS location_6, e0_.spawn AS spawn_7, e0_.picture AS picture_8, e0_.object1_cc AS object1_cc_9, e0_.object_adv AS object_adv_10, e0_.commentaire AS commentaire_11, e0_.description AS description_12, e0_.vehicle_rules AS vehicle_rules_13, e0_.engagement_rules AS engagement_rules_14, e0_.equipment_rules AS equipment_rules_15, e0_.available_roles AS available_roles_16, e0_.nb_resp AS nb_resp_17, e0_.status AS status_18, e0_.visibility AS visibility_19, e0_.briefing_template_name AS briefing_template_name_20, e0_.respawn AS respawn_21, e0_.appel_msg_discord AS appel_msg_discord_22, e0_.rapport_env AS rapport_env_23, e0_.publish_at AS publish_at_24, e0_.published_at AS published_at_25, e0_.responsable AS responsable_26, e0_.discord_message_id AS discord_message_id_27, e0_.discord_briefing_message_id AS discord_briefing_message_id_28, e0_.discord_attribution_message_id AS discord_attribution_message_id_29, e0_.discord_vocal_parent_id AS discord_vocal_parent_id_30, e1_.id AS id_31, e1_.name AS name_32, e1_.color AS color_33, e1_.xp AS xp_34, e0_.type_id AS type_id_35, e0_.user_orig_id AS user_orig_id_36 FROM event e0_ LEFT JOIN event_type e1_ ON e0_.type_id = e1_.id WHERE e0_.status = ? AND e0_.visibility = ? AND e0_.start >= ? AND ((e0_.publish_at IS NULL OR e0_.publish_at <= ?)) ORDER BY e0_.start ASC LIMIT 20
Parameters:
[ "PUBLISHED" "PUBLIC" "2026-04-17 21:00:34" "2026-04-17 21:00:34" ]
|
||||||||||||||||||||||||||
|
0.59 ms (43.20%) |
1 |
SELECT t0.id AS id_1, t0.roles AS roles_2, t0.username AS username_3, t0.discord_id AS discord_id_4, t0.avatar AS avatar_5, t0.compagnon_token AS compagnon_token_6, t0.compagnon_key_api AS compagnon_key_api_7, t0.compagnon_last_login AS compagnon_last_login_8, t0.compagnon_expire_at AS compagnon_expire_at_9, t10.id AS id_11, t10.status AS status_12, t10.last_promotion AS last_promotion_13, t10.date_entree AS date_entree_14, t10.json_entrer AS json_entrer_15, t10.promotion_send AS promotion_send_16, t10.user_id AS user_id_17, t10.grade_id AS grade_id_18, t10.pending_approval_id AS pending_approval_id_19, t20.id AS id_21, t20.theme AS theme_22, t20.accent_color AS accent_color_23, t20.banner_url AS banner_url_24, t20.default_tab AS default_tab_25, t20.compact_mode AS compact_mode_26, t20.disable_animations AS disable_animations_27, t20.visible_sections AS visible_sections_28, t20.section_order AS section_order_29, t20.featured_certifications AS featured_certifications_30, t20.featured_objectives AS featured_objectives_31, t20.bio AS bio_32, t20.speciality AS speciality_33, t20.favorite_ship AS favorite_ship_34, t20.favorite_role AS favorite_role_35, t20.notes AS notes_36, t20.custom_theme AS custom_theme_37, t20.user_id AS user_id_38, t20.favorite_ship_id AS favorite_ship_id_39, t20.profile_theme_id AS profile_theme_id_40 FROM user t0 LEFT JOIN rhmember t10 ON t10.user_id = t0.id LEFT JOIN user_profile_preference t20 ON t20.user_id = t0.id WHERE t0.compagnon_token = ? LIMIT 1
Parameters:
[
"01fb75b632a068ea6206518237d0abaf57dbb022243d3a4801e3b6bcc0e678f7"
]
|
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\Member\User | 1 |
| App\Entity\RH\RHMember | 1 |
| App\Entity\Member\Rank | 1 |
| App\Entity\Member\UserProfilePreference | 1 |