GET https://www.preprod.1ercorpscolonial.fr/

Query Metrics

31 Database Queries
7 Different statements
18.55 ms Query time
0 Invalid entities
91 Managed entities

Queries

Group similar statements

# Time Info
1 1.84 ms
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"
]
2 0.81 ms
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"
]
3 3.84 ms
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
]
4 0.94 ms
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
]
5 0.59 ms
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
]
6 0.46 ms
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
]
7 0.40 ms
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
]
8 0.50 ms
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:
[
  4940
]
9 0.42 ms
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:
[
  4541
]
10 0.28 ms
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:
[
  4922
]
11 0.42 ms
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:
[
  184
]
12 0.24 ms
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:
[
  10
]
13 0.21 ms
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:
[
  10
]
14 0.34 ms
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:
[
  10
]
15 0.23 ms
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:
[
  161
]
16 0.26 ms
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:
[
  36
]
17 0.24 ms
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:
[
  28
]
18 0.25 ms
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:
[
  11
]
19 0.23 ms
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:
[
  1
]
20 0.20 ms
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:
[
  96
]
21 0.23 ms
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:
[
  115
]
22 0.42 ms
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:
[
  175
]
23 0.51 ms
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:
[
  179
]
24 0.97 ms
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:
[
  8
]
25 0.26 ms
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:
[
  8
]
26 0.65 ms
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:
[
  8
]
27 0.43 ms
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:
[
  15
]
28 0.87 ms
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:
[
  44
]
29 0.48 ms
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:
[
  75
]
30 0.74 ms
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:
[
  77
]
31 0.28 ms
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:
[
  117
]

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