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

Grouped Statements

Show all queries

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