Query Metrics
434
Database Queries
15
Different statements
99.07 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
30.86 ms (31.15%) |
128 |
SELECT t0.id AS id_1, t0.upgrade_id AS upgrade_id_2, t0.item_type AS item_type_3, t0.item_id AS item_id_4, t0.count AS count_5, t0.item_id AS item_id_6, t0.item_id AS item_id_7, t0.item_id AS item_id_8, t0.item_id AS item_id_9, t0.item_id AS item_id_10, t0.item_id AS item_id_11, t0.item_id AS item_id_12, t0.item_id AS item_id_13, t0.item_id AS item_id_14, t0.item_id AS item_id_15, t0.upgrade_id AS upgrade_id_16 FROM upgrade_item t0 WHERE t0.upgrade_id = ?
Parameters:
[
1
]
|
26.98 ms (27.23%) |
128 |
SELECT t0.id AS id_1, t0.grade AS grade_2, t0.failure AS failure_3, t0.cost_percent AS cost_percent_4, t0.cost_j AS cost_j_5, t0.percent AS percent_6 FROM upgrade t0 WHERE t0.id = ?
Parameters:
[
1
]
|
15.86 ms (16.01%) |
75 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.source AS source_3, t0.location AS location_4, t0.weight AS weight_5, t0.price AS price_6, t0.image AS image_7, t0.type AS type_8 FROM loot t0 WHERE t0.id = ?
Parameters:
[
19
]
|
8.05 ms (8.13%) |
30 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.level AS level_3, t0.min_damage AS min_damage_4, t0.max_damage AS max_damage_5, t0.min_damage_en AS min_damage_en_6, t0.max_damage_en AS max_damage_en_7, t0.min_distance AS min_distance_8, t0.max_distance AS max_distance_9, t0.radius AS radius_10, t0.power_usage AS power_usage_11, t0.firing_rate AS firing_rate_12, t0.weight AS weight_13, t0.durability AS durability_14, t0.cost AS cost_15, t0.cost_j AS cost_j_16, t0.image AS image_17, t0.effects AS effects_18, t0.type AS type_19, t0.type AS type_20 FROM weapon t0 WHERE t0.id = ?
Parameters:
[
18
]
|
6.32 ms (6.38%) |
28 |
SELECT t0.id AS id_1, t0.upgrade_id AS upgrade_id_2, t0.upgrade_type_id AS upgrade_type_id_3, t0.upgrade_id AS upgrade_id_4, t0.upgrade_type_id AS upgrade_type_id_5 FROM upgrade_type t0 WHERE t0.upgrade_type_id = ?
Parameters:
[
1
]
|
1.82 ms (1.83%) |
9 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.category_id AS category_id_3, t0.category_id AS category_id_4 FROM type_equipment t0 WHERE t0.id = ?
Parameters:
[
1
]
|
1.73 ms (1.75%) |
7 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.level AS level_3, t0.effects AS effects_4, t0.power_usage AS power_usage_5, t0.weight AS weight_6, t0.cost AS cost_7, t0.cost_j AS cost_j_8, t0.image AS image_9 FROM consumables t0 WHERE t0.id = ?
Parameters:
[
9
]
|
1.61 ms (1.62%) |
7 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.spell AS spell_3, t0.count AS count_4, t0.durability AS durability_5, t0.cost AS cost_6, t0.cost_j AS cost_j_7, t0.image AS image_8, t0.type AS type_9, t0.result_category AS result_category_10, t0.result_item_id AS result_item_id_11 FROM draft t0 WHERE t0.id = ?
Parameters:
[
1
]
|
1.28 ms (1.30%) |
6 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.level AS level_3, t0.effects AS effects_4, t0.weight AS weight_5, t0.durability AS durability_6, t0.cost AS cost_7, t0.cost_j AS cost_j_8, t0.image AS image_9 FROM computer t0 WHERE t0.id = ?
Parameters:
[
19
]
|
0.97 ms (0.97%) |
4 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.level AS level_3, t0.protection AS protection_4, t0.weight AS weight_5, t0.durability AS durability_6, t0.cost AS cost_7, t0.cost_j AS cost_j_8, t0.image AS image_9, t0.type AS type_10 FROM armour t0 WHERE t0.id = ?
Parameters:
[
1
]
|
0.86 ms (0.87%) |
3 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.level AS level_3, t0.type AS type_4, t0.protection AS protection_5, t0.weight AS weight_6, t0.durability AS durability_7, t0.cost AS cost_8, t0.cost_j AS cost_j_9, t0.image AS image_10, t0.effects AS effects_11 FROM shield t0 WHERE t0.id = ?
Parameters:
[
25
]
|
0.81 ms (0.82%) |
3 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.level AS level_3, t0.capacity AS capacity_4, t0.weight AS weight_5, t0.durability AS durability_6, t0.cost AS cost_7, t0.cost_j AS cost_j_8, t0.image AS image_9, t0.effects AS effects_10, t0.type AS type_11 FROM battery t0 WHERE t0.id = ?
Parameters:
[
13
]
|
0.72 ms (0.73%) |
3 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.level AS level_3, t0.power AS power_4, t0.weight AS weight_5, t0.durability AS durability_6, t0.cost AS cost_7, t0.cost_j AS cost_j_8, t0.image AS image_9, t0.effects AS effects_10, t0.type AS type_11 FROM generator t0 WHERE t0.id = ?
Parameters:
[
1
]
|
0.66 ms (0.67%) |
1 |
SELECT t0.upgrade_type AS upgrade_type_1, t0.description AS description_2 FROM upgrade_types t0
Parameters:
[] |
0.53 ms (0.54%) |
2 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.level AS level_3, t0.type AS type_4, t0.capacity AS capacity_5, t0.weight AS weight_6, t0.durability AS durability_7, t0.cost AS cost_8, t0.cost_j AS cost_j_9, t0.image AS image_10, t0.effects AS effects_11 FROM bay t0 WHERE t0.id = ?
Parameters:
[
1
]
|
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.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\UpgradeTypes | No errors. |
App\Entity\UpgradeType | No errors. |
App\Entity\Upgrade | No errors. |
App\Entity\UpgradeItem | No errors. |
App\Entity\Loot | No errors. |
App\Entity\Weapon | No errors. |
App\Entity\Computer | No errors. |
App\Entity\Armour | No errors. |
App\Entity\Shield | No errors. |
App\Entity\Generator | No errors. |
App\Entity\Battery | No errors. |
App\Entity\Bay | No errors. |
App\Entity\Consumables | No errors. |
App\Entity\Draft | No errors. |
App\Entity\TypeEquipment | No errors. |
App\Entity\CategoryEquipment | No errors. |