Query Metrics
31
Database Queries
7
Different statements
18.55 ms
Query time
0
Invalid entities
91
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
6.24 ms (33.67%) |
16 |
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.code AS code_4, t0.kind AS kind_5, t0.weight_scu AS weight_scu_6, t0.price_buy AS price_buy_7, t0.price_sell AS price_sell_8, t0.is_available AS is_available_9, t0.is_visible AS is_visible_10, t0.is_illegal AS is_illegal_11, t0.is_raw AS is_raw_12, t0.is_refined AS is_refined_13, t0.signali AS signali_14, t0.wiki AS wiki_15, t0.date_added AS date_added_16, t0.date_modified AS date_modified_17, t0.parent_id AS parent_id_18 FROM catalog_commodity t0 WHERE t0.id = ?
Parameters:
[
183
]
|
|
5.05 ms (27.24%) |
3 |
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.xp_per_unit AS xp_per_unit_3, t0.item_id AS item_id_4, t0.contract_id AS contract_id_5 FROM contract_item t0 WHERE t0.contract_id = ?
Parameters:
[
9
]
|
|
1.84 ms (9.90%) |
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, e0_.type_id AS type_id_31, e0_.user_orig_id AS user_orig_id_32 FROM event e0_ 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 3
Parameters:
[ "PUBLISHED" "PUBLIC" "2026-07-17 00:38:25" "2026-07-17 00:38:25" ] |
|
1.60 ms (8.65%) |
4 |
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.slug AS slug_4, t0.uuid AS uuid_5, t0.company_external_id AS company_external_id_6, t0.company_name AS company_name_7, t0.vehicle_external_id AS vehicle_external_id_8, t0.vehicle_name AS vehicle_name_9, t0.size AS size_10, t0.color AS color_11, t0.color2 AS color2_12, t0.quality AS quality_13, t0.url_store AS url_store_14, t0.is_exclusive_pledge AS is_exclusive_pledge_15, t0.is_exclusive_subscriber AS is_exclusive_subscriber_16, t0.is_exclusive_concierge AS is_exclusive_concierge_17, t0.is_commodity AS is_commodity_18, t0.is_harvestable AS is_harvestable_19, t0.screenshot AS screenshot_20, t0.game_version AS game_version_21, t0.notification AS notification_22, t0.date_added AS date_added_23, t0.date_modified AS date_modified_24, t0.category_id AS category_id_25, t0.parent_id AS parent_id_26 FROM catalog_item t0 WHERE t0.id = ?
Parameters:
[
3266
]
|
|
1.58 ms (8.54%) |
3 |
SELECT t0.id AS id_1, t0.kind AS kind_2, t0.quantity AS quantity_3, t0.note AS note_4, t0.is_voided AS is_voided_5, t0.voided_at AS voided_at_6, t0.void_reason AS void_reason_7, t0.is_completed AS is_completed_8, t0.created_at AS created_at_9, t0.contract_id AS contract_id_10, t0.item_id AS item_id_11, t0.commodity_id AS commodity_id_12, t0.given_by_id AS given_by_id_13, t0.created_by_id AS created_by_id_14, t0.voided_by_id AS voided_by_id_15 FROM contract_progress_entry t0 WHERE t0.contract_id = ? ORDER BY t0.created_at DESC
Parameters:
[
9
]
|
|
1.42 ms (7.64%) |
3 |
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.xp_per_unit AS xp_per_unit_3, t0.commodity_id AS commodity_id_4, t0.contract_id AS contract_id_5 FROM contract_commodity t0 WHERE t0.contract_id = ?
Parameters:
[
9
]
|
|
0.81 ms (4.36%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image_path AS image_path_4, t0.responsable_mode AS responsable_mode_5, t0.status AS status_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.completed AS completed_9, t0.discord_message_id AS discord_message_id_10, t0.discord_thread_id AS discord_thread_id_11, t0.on_homepage AS on_homepage_12, t0.homepage_order AS homepage_order_13, t0.responsable_id AS responsable_id_14 FROM contract t0 WHERE t0.on_homepage = ? AND t0.status = ? ORDER BY t0.homepage_order ASC, t0.created_at DESC LIMIT 4
Parameters:
[ 1 "active" ] |
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\Catalog\CatalogCommodity | 26 |
| App\Entity\Contract\ContractCommodity | 25 |
| App\Entity\Contract\ContractProgressEntry | 16 |
| App\Entity\Member\User | 7 |
| App\Entity\Catalog\CatalogItem | 7 |
| App\Entity\Contract\ContractItem | 4 |
| App\Entity\Contract\Contract | 3 |
| App\Entity\Catalog\CatalogCategory | 3 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Embeddable\DiscordMeta | No errors. |
| App\Entity\Event\Event | No errors. |
| App\Entity\Event\EventType | No errors. |
| App\Entity\Member\User | No errors. |
| App\Entity\Contract\Contract | No errors. |
| App\Entity\Contract\ContractProgressEntry | No errors. |
| App\Entity\Contract\ContractItem | No errors. |
| App\Entity\Contract\ContractCommodity | No errors. |
| App\Entity\Catalog\CatalogItem | No errors. |
| App\Entity\Catalog\CatalogCommodity | No errors. |
| App\Entity\Catalog\CatalogCategory | No errors. |
| App\Entity\Catalog\CatalogItemPrice | No errors. |