Query Metrics
32
Database Queries
23
Different statements
10.49 ms
Query time
0
Invalid entities
5
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.74 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.username AS username_3, t0.email AS email_4, t0.password AS password_5, t0.locale AS locale_6, t0.uni AS uni_7, t0.register_on AS register_on_8, t0.activate_on AS activate_on_9, t0.referal_on AS referal_on_10, t0.referal_by AS referal_by_11, t0.last_active AS last_active_12, t0.roles AS roles_13, t0.is_verified AS is_verified_14, t0.login_on AS login_on_15, t0.logout_on AS logout_on_16, t0.points AS points_17, t0.build_points AS build_points_18, t0.research_points AS research_points_19, t0.fleet_points AS fleet_points_20, t0.password_reset_token AS password_reset_token_21, t0.password_reset_expires_at AS password_reset_expires_at_22, t0.registration_otp AS registration_otp_23 FROM user t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"ShaoKhan@gmx.de"
]
|
||||||||||||||||||||||||||||||
| 2 | 0.39 ms |
SELECT t0.id AS id_1, t0.user_uuid AS user_uuid_2, t0.reason AS reason_3, t0.blocked_at AS blocked_at_4, t0.blocked_by AS blocked_by_5 FROM user_blocked t0 WHERE t0.user_uuid = ? LIMIT 1
Parameters:
[
"8ea56b7d-70ac-4956-8925-743ecadded35"
]
|
||||||||||||||||||||||||||||||
| 3 | 0.21 ms |
"START TRANSACTION"
Parameters:
[] |
||||||||||||||||||||||||||||||
| 4 | 0.33 ms |
UPDATE user SET login_on = ? WHERE id = ?
Parameters:
[ "2026-03-09 09:05:22" 51 ] |
||||||||||||||||||||||||||||||
| 5 | 0.56 ms |
"COMMIT"
Parameters:
[] |
||||||||||||||||||||||||||||||
| 6 | 0.61 ms |
SELECT t0.id AS id_1, t0.user_uuid AS user_uuid_2, t0.name AS name_3, t0.uni AS uni_4, t0.system_x AS system_x_5, t0.system_y AS system_y_6, t0.system_z AS system_z_7, t0.destroyed AS destroyed_8, t0.metal AS metal_9, t0.metal_max AS metal_max_10, t0.crystal AS crystal_11, t0.crystal_max AS crystal_max_12, t0.deuterium AS deuterium_13, t0.deuterium_max AS deuterium_max_14, t0.last_resource_update AS last_resource_update_15, t0.tf_metal AS tf_metal_16, t0.tf_crystal AS tf_crystal_17, t0.metal_building AS metal_building_18, t0.crystal_building AS crystal_building_19, t0.deuterium_building AS deuterium_building_20, t0.solar_building AS solar_building_21, t0.nuclear_building AS nuclear_building_22, t0.robot_building AS robot_building_23, t0.nanite_building AS nanite_building_24, t0.hangar_building AS hangar_building_25, t0.metalstorage_building AS metalstorage_building_26, t0.crystalstorage_building AS crystalstorage_building_27, t0.deuteriumstorage_building AS deuteriumstorage_building_28, t0.laboratory_building AS laboratory_building_29, t0.university_building AS university_building_30, t0.alliancehangar_building AS alliancehangar_building_31, t0.missilesilo_building AS missilesilo_building_32, t0.missilelauncher_defense AS missilelauncher_defense_33, t0.phalanx_defense AS phalanx_defense_34, t0.smalllaser_defense AS smalllaser_defense_35, t0.biglaser_defense AS biglaser_defense_36, t0.gausscannon_defense AS gausscannon_defense_37, t0.ioncannon_defense AS ioncannon_defense_38, t0.plasmacannon_defense AS plasmacannon_defense_39, t0.smallshield_defense AS smallshield_defense_40, t0.bigshield_defense AS bigshield_defense_41, t0.planetshield_defense AS planetshield_defense_42, t0.gravitoncannon_defense AS gravitoncannon_defense_43, t0.interceptormissile_defense AS interceptormissile_defense_44, t0.orbitaldefenseplatform_defense AS orbitaldefenseplatform_defense_45, t0.smalltransportship_ship AS smalltransportship_ship_46, t0.bigtransportship_ship AS bigtransportship_ship_47, t0.lighthunter_ship AS lighthunter_ship_48, t0.heavyhunter_ship AS heavyhunter_ship_49, t0.cruiser_ship AS cruiser_ship_50, t0.battleship_ship AS battleship_ship_51, t0.colonyship_ship AS colonyship_ship_52, t0.smallrecycler_ship AS smallrecycler_ship_53, t0.mediumrecycler_ship AS mediumrecycler_ship_54, t0.bigrecycler_ship AS bigrecycler_ship_55, t0.spyprobe_ship AS spyprobe_ship_56, t0.bomber_ship AS bomber_ship_57, t0.solarsatellite_ship AS solarsatellite_ship_58, t0.destroyer_ship AS destroyer_ship_59, t0.deathstar_ship AS deathstar_ship_60, t0.battlecruiser_ship AS battlecruiser_ship_61, t0.lunenoire_ship AS lunenoire_ship_62, t0.evolutiontransporter_ship AS evolutiontransporter_ship_63, t0.gigarecycler_ship AS gigarecycler_ship_64, t0.dmcollector_ship AS dmcollector_ship_65, t0.darkmatter AS darkmatter_66, t0.uuid AS uuid_67, t0.terraforming_building AS terraforming_building_68, t0.jumpgate_building AS jumpgate_building_69, t0.moonbase_building AS moonbase_building_70, t0.laserphalanx_building AS laserphalanx_building_71, t0.planet_type AS planet_type_72, t0.last_update AS last_update_73, t0.crystal_storage AS crystal_storage_74, t0.deuterium_storage AS deuterium_storage_75, t0.metal_production AS metal_production_76, t0.crystal_production AS crystal_production_77, t0.deuterium_production AS deuterium_production_78, t0.energy_used AS energy_used_79, t0.energy_max AS energy_max_80, t0.metal_mine AS metal_mine_81, t0.crystal_mine AS crystal_mine_82, t0.deuterium_synthesizer AS deuterium_synthesizer_83, t0.solar_plant AS solar_plant_84, t0.fusion_reactor AS fusion_reactor_85, t0.robotics_factory AS robotics_factory_86, t0.nanite_factory AS nanite_factory_87, t0.shipyard AS shipyard_88, t0.terraformer AS terraformer_89, t0.alliance_depot AS alliance_depot_90, t0.missile_silo AS missile_silo_91 FROM planet t0 WHERE t0.user_uuid = ?
Parameters:
[
"8ea56b7d-70ac-4956-8925-743ecadded35"
]
|
||||||||||||||||||||||||||||||
| 7 | 0.55 ms |
SELECT t0.id AS id_1, t0.user_uuid AS user_uuid_2, t0.name AS name_3, t0.uni AS uni_4, t0.system_x AS system_x_5, t0.system_y AS system_y_6, t0.system_z AS system_z_7, t0.destroyed AS destroyed_8, t0.metal AS metal_9, t0.metal_max AS metal_max_10, t0.crystal AS crystal_11, t0.crystal_max AS crystal_max_12, t0.deuterium AS deuterium_13, t0.deuterium_max AS deuterium_max_14, t0.last_resource_update AS last_resource_update_15, t0.tf_metal AS tf_metal_16, t0.tf_crystal AS tf_crystal_17, t0.metal_building AS metal_building_18, t0.crystal_building AS crystal_building_19, t0.deuterium_building AS deuterium_building_20, t0.solar_building AS solar_building_21, t0.nuclear_building AS nuclear_building_22, t0.robot_building AS robot_building_23, t0.nanite_building AS nanite_building_24, t0.hangar_building AS hangar_building_25, t0.metalstorage_building AS metalstorage_building_26, t0.crystalstorage_building AS crystalstorage_building_27, t0.deuteriumstorage_building AS deuteriumstorage_building_28, t0.laboratory_building AS laboratory_building_29, t0.university_building AS university_building_30, t0.alliancehangar_building AS alliancehangar_building_31, t0.missilesilo_building AS missilesilo_building_32, t0.missilelauncher_defense AS missilelauncher_defense_33, t0.phalanx_defense AS phalanx_defense_34, t0.smalllaser_defense AS smalllaser_defense_35, t0.biglaser_defense AS biglaser_defense_36, t0.gausscannon_defense AS gausscannon_defense_37, t0.ioncannon_defense AS ioncannon_defense_38, t0.plasmacannon_defense AS plasmacannon_defense_39, t0.smallshield_defense AS smallshield_defense_40, t0.bigshield_defense AS bigshield_defense_41, t0.planetshield_defense AS planetshield_defense_42, t0.gravitoncannon_defense AS gravitoncannon_defense_43, t0.interceptormissile_defense AS interceptormissile_defense_44, t0.orbitaldefenseplatform_defense AS orbitaldefenseplatform_defense_45, t0.smalltransportship_ship AS smalltransportship_ship_46, t0.bigtransportship_ship AS bigtransportship_ship_47, t0.lighthunter_ship AS lighthunter_ship_48, t0.heavyhunter_ship AS heavyhunter_ship_49, t0.cruiser_ship AS cruiser_ship_50, t0.battleship_ship AS battleship_ship_51, t0.colonyship_ship AS colonyship_ship_52, t0.smallrecycler_ship AS smallrecycler_ship_53, t0.mediumrecycler_ship AS mediumrecycler_ship_54, t0.bigrecycler_ship AS bigrecycler_ship_55, t0.spyprobe_ship AS spyprobe_ship_56, t0.bomber_ship AS bomber_ship_57, t0.solarsatellite_ship AS solarsatellite_ship_58, t0.destroyer_ship AS destroyer_ship_59, t0.deathstar_ship AS deathstar_ship_60, t0.battlecruiser_ship AS battlecruiser_ship_61, t0.lunenoire_ship AS lunenoire_ship_62, t0.evolutiontransporter_ship AS evolutiontransporter_ship_63, t0.gigarecycler_ship AS gigarecycler_ship_64, t0.dmcollector_ship AS dmcollector_ship_65, t0.darkmatter AS darkmatter_66, t0.uuid AS uuid_67, t0.terraforming_building AS terraforming_building_68, t0.jumpgate_building AS jumpgate_building_69, t0.moonbase_building AS moonbase_building_70, t0.laserphalanx_building AS laserphalanx_building_71, t0.planet_type AS planet_type_72, t0.last_update AS last_update_73, t0.crystal_storage AS crystal_storage_74, t0.deuterium_storage AS deuterium_storage_75, t0.metal_production AS metal_production_76, t0.crystal_production AS crystal_production_77, t0.deuterium_production AS deuterium_production_78, t0.energy_used AS energy_used_79, t0.energy_max AS energy_max_80, t0.metal_mine AS metal_mine_81, t0.crystal_mine AS crystal_mine_82, t0.deuterium_synthesizer AS deuterium_synthesizer_83, t0.solar_plant AS solar_plant_84, t0.fusion_reactor AS fusion_reactor_85, t0.robotics_factory AS robotics_factory_86, t0.nanite_factory AS nanite_factory_87, t0.shipyard AS shipyard_88, t0.terraformer AS terraformer_89, t0.alliance_depot AS alliance_depot_90, t0.missile_silo AS missile_silo_91 FROM planet t0 WHERE t0.user_uuid = ?
Parameters:
[
"8ea56b7d-70ac-4956-8925-743ecadded35"
]
|
||||||||||||||||||||||||||||||
| 8 | 0.50 ms |
SELECT t0.id AS id_1, t0.user_uuid AS user_uuid_2, t0.name AS name_3, t0.uni AS uni_4, t0.system_x AS system_x_5, t0.system_y AS system_y_6, t0.system_z AS system_z_7, t0.destroyed AS destroyed_8, t0.metal AS metal_9, t0.metal_max AS metal_max_10, t0.crystal AS crystal_11, t0.crystal_max AS crystal_max_12, t0.deuterium AS deuterium_13, t0.deuterium_max AS deuterium_max_14, t0.last_resource_update AS last_resource_update_15, t0.tf_metal AS tf_metal_16, t0.tf_crystal AS tf_crystal_17, t0.metal_building AS metal_building_18, t0.crystal_building AS crystal_building_19, t0.deuterium_building AS deuterium_building_20, t0.solar_building AS solar_building_21, t0.nuclear_building AS nuclear_building_22, t0.robot_building AS robot_building_23, t0.nanite_building AS nanite_building_24, t0.hangar_building AS hangar_building_25, t0.metalstorage_building AS metalstorage_building_26, t0.crystalstorage_building AS crystalstorage_building_27, t0.deuteriumstorage_building AS deuteriumstorage_building_28, t0.laboratory_building AS laboratory_building_29, t0.university_building AS university_building_30, t0.alliancehangar_building AS alliancehangar_building_31, t0.missilesilo_building AS missilesilo_building_32, t0.missilelauncher_defense AS missilelauncher_defense_33, t0.phalanx_defense AS phalanx_defense_34, t0.smalllaser_defense AS smalllaser_defense_35, t0.biglaser_defense AS biglaser_defense_36, t0.gausscannon_defense AS gausscannon_defense_37, t0.ioncannon_defense AS ioncannon_defense_38, t0.plasmacannon_defense AS plasmacannon_defense_39, t0.smallshield_defense AS smallshield_defense_40, t0.bigshield_defense AS bigshield_defense_41, t0.planetshield_defense AS planetshield_defense_42, t0.gravitoncannon_defense AS gravitoncannon_defense_43, t0.interceptormissile_defense AS interceptormissile_defense_44, t0.orbitaldefenseplatform_defense AS orbitaldefenseplatform_defense_45, t0.smalltransportship_ship AS smalltransportship_ship_46, t0.bigtransportship_ship AS bigtransportship_ship_47, t0.lighthunter_ship AS lighthunter_ship_48, t0.heavyhunter_ship AS heavyhunter_ship_49, t0.cruiser_ship AS cruiser_ship_50, t0.battleship_ship AS battleship_ship_51, t0.colonyship_ship AS colonyship_ship_52, t0.smallrecycler_ship AS smallrecycler_ship_53, t0.mediumrecycler_ship AS mediumrecycler_ship_54, t0.bigrecycler_ship AS bigrecycler_ship_55, t0.spyprobe_ship AS spyprobe_ship_56, t0.bomber_ship AS bomber_ship_57, t0.solarsatellite_ship AS solarsatellite_ship_58, t0.destroyer_ship AS destroyer_ship_59, t0.deathstar_ship AS deathstar_ship_60, t0.battlecruiser_ship AS battlecruiser_ship_61, t0.lunenoire_ship AS lunenoire_ship_62, t0.evolutiontransporter_ship AS evolutiontransporter_ship_63, t0.gigarecycler_ship AS gigarecycler_ship_64, t0.dmcollector_ship AS dmcollector_ship_65, t0.darkmatter AS darkmatter_66, t0.uuid AS uuid_67, t0.terraforming_building AS terraforming_building_68, t0.jumpgate_building AS jumpgate_building_69, t0.moonbase_building AS moonbase_building_70, t0.laserphalanx_building AS laserphalanx_building_71, t0.planet_type AS planet_type_72, t0.last_update AS last_update_73, t0.crystal_storage AS crystal_storage_74, t0.deuterium_storage AS deuterium_storage_75, t0.metal_production AS metal_production_76, t0.crystal_production AS crystal_production_77, t0.deuterium_production AS deuterium_production_78, t0.energy_used AS energy_used_79, t0.energy_max AS energy_max_80, t0.metal_mine AS metal_mine_81, t0.crystal_mine AS crystal_mine_82, t0.deuterium_synthesizer AS deuterium_synthesizer_83, t0.solar_plant AS solar_plant_84, t0.fusion_reactor AS fusion_reactor_85, t0.robotics_factory AS robotics_factory_86, t0.nanite_factory AS nanite_factory_87, t0.shipyard AS shipyard_88, t0.terraformer AS terraformer_89, t0.alliance_depot AS alliance_depot_90, t0.missile_silo AS missile_silo_91 FROM planet t0 WHERE t0.user_uuid = ? AND t0.uuid = ? LIMIT 1
Parameters:
[ "8ea56b7d-70ac-4956-8925-743ecadded35" "34803f10-0fdc-4b1c-9f27-a756d54c12da" ]
|
||||||||||||||||||||||||||||||
| 9 | 0.46 ms |
SELECT t0.id AS id_1, t0.users_amount AS users_amount_2, t0.game_speed AS game_speed_3, t0.fleet_speed AS fleet_speed_4, t0.resource_multiplier AS resource_multiplier_5, t0.storage_multiplier AS storage_multiplier_6, t0.message_delete_behavior AS message_delete_behavior_7, t0.message_delete_days AS message_delete_days_8, t0.halt_speed AS halt_speed_9, t0.fleet_cdr AS fleet_cdr_10, t0.def_in_tf AS def_in_tf_11, t0.fleet_in_tf AS fleet_in_tf_12, t0.resource_loot AS resource_loot_13, t0.planet_fields AS planet_fields_14, t0.uni_name AS uni_name_15, t0.uni_enabled AS uni_enabled_16, t0.closed_text AS closed_text_17, t0.metal_standard_income AS metal_standard_income_18, t0.crystal_standard_income AS crystal_standard_income_19, t0.deuterium_standard_income AS deuterium_standard_income_20, t0.energy_standard_income AS energy_standard_income_21, t0.noob_protection AS noob_protection_22, t0.noob_protectiontime AS noob_protectiontime_23, t0.forum_url AS forum_url_24, t0.admin_attackable AS admin_attackable_25, t0.language AS language_26, t0.teamspeak_mod AS teamspeak_mod_27, t0.teamspeak_server AS teamspeak_server_28, t0.teamspeak_tcp_port AS teamspeak_tcp_port_29, t0.teamspeak_udp_port AS teamspeak_udp_port_30, t0.registration_closed AS registration_closed_31, t0.welcome_text AS welcome_text_32, t0.min_build_time AS min_build_time_33, t0.modules AS modules_34, t0.tradeable_ships AS tradeable_ships_35, t0.tradeable_ships_fee AS tradeable_ships_fee_36, t0.galaxy_width AS galaxy_width_37, t0.galaxy_height AS galaxy_height_38, t0.galaxy_depth AS galaxy_depth_39, t0.max_construction_count AS max_construction_count_40, t0.max_science_count AS max_science_count_41, t0.max_ship_count AS max_ship_count_42, t0.refund_building_percent AS refund_building_percent_43, t0.refund_research_percent AS refund_research_percent_44, t0.refund_ship_percent AS refund_ship_percent_45, t0.max_start_planets_per_player AS max_start_planets_per_player_46, t0.max_planets AS max_planets_47, t0.max_planets_astrophysics AS max_planets_astrophysics_48, t0.max_planets_officers AS max_planets_officers_49, t0.max_planets_science AS max_planets_science_50, t0.flight_deuterium_cost_per_click AS flight_deuterium_cost_per_click_51, t0.max_dm_missions AS max_dm_missions_52, t0.max_resource_overflow AS max_resource_overflow_53, t0.moon_chance_factor AS moon_chance_factor_54, t0.moon_chance AS moon_chance_55, t0.trader_dm_cost AS trader_dm_cost_56, t0.university_factor_science AS university_factor_science_57, t0.max_fleets_per_association AS max_fleets_per_association_58, t0.delete_moon_debris AS delete_moon_debris_59, t0.min_umode_time AS min_umode_time_60, t0.gate_interval_time AS gate_interval_time_61, t0.start_metal AS start_metal_62, t0.start_crystal AS start_crystal_63, t0.start_deuterium AS start_deuterium_64, t0.start_dm AS start_dm_65, t0.referal_active AS referal_active_66, t0.referal_bonus_dm AS referal_bonus_dm_67, t0.referal_minpoints AS referal_minpoints_68, t0.referal_max_referals AS referal_max_referals_69, t0.del_user_manual AS del_user_manual_70, t0.send_inavtive_mail AS send_inavtive_mail_71, t0.silo_size_factor AS silo_size_factor_72, t0.energy_factor AS energy_factor_73, t0.alliance_min_points AS alliance_min_points_74, t0.expedition_res_limit AS expedition_res_limit_75, t0.server_id AS server_id_76 FROM uni t0
Parameters:
[]
|
||||||||||||||||||||||||||||||
| 10 | 0.16 ms |
"START TRANSACTION"
Parameters:
[]
|
||||||||||||||||||||||||||||||
| 11 | 0.23 ms |
UPDATE planet SET last_resource_update = ? WHERE id = ?
Parameters:
[ "2026-03-09 09:05:22" 18 ]
|
||||||||||||||||||||||||||||||
| 12 | 0.31 ms |
"COMMIT"
Parameters:
[]
|
||||||||||||||||||||||||||||||
| 13 | 0.24 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.factor AS factor_4, t0.level_max AS level_max_5, t0.cost_metal AS cost_metal_6, t0.cost_crystal AS cost_crystal_7, t0.cost_deuterium AS cost_deuterium_8, t0.cost_dark_matter AS cost_dark_matter_9, t0.cost_energy AS cost_energy_10, t0.storage_metal AS storage_metal_11, t0.storage_crystal AS storage_crystal_12, t0.storage_deuterium AS storage_deuterium_13, t0.energy_consumption_base AS energy_consumption_base_14, t0.energy_production_base AS energy_production_base_15, t0.image AS image_16, t0.description AS description_17, t0.building_class AS building_class_18, t0.one_per_planet AS one_per_planet_19, t0.is_buildable AS is_buildable_20, t0.slug AS slug_21 FROM buildings t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"metal_mine"
]
|
||||||||||||||||||||||||||||||
| 14 | 0.22 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.factor AS factor_4, t0.level_max AS level_max_5, t0.cost_metal AS cost_metal_6, t0.cost_crystal AS cost_crystal_7, t0.cost_deuterium AS cost_deuterium_8, t0.cost_dark_matter AS cost_dark_matter_9, t0.cost_energy AS cost_energy_10, t0.storage_metal AS storage_metal_11, t0.storage_crystal AS storage_crystal_12, t0.storage_deuterium AS storage_deuterium_13, t0.energy_consumption_base AS energy_consumption_base_14, t0.energy_production_base AS energy_production_base_15, t0.image AS image_16, t0.description AS description_17, t0.building_class AS building_class_18, t0.one_per_planet AS one_per_planet_19, t0.is_buildable AS is_buildable_20, t0.slug AS slug_21 FROM buildings t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"crystal_mine"
]
|
||||||||||||||||||||||||||||||
| 15 | 0.23 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.factor AS factor_4, t0.level_max AS level_max_5, t0.cost_metal AS cost_metal_6, t0.cost_crystal AS cost_crystal_7, t0.cost_deuterium AS cost_deuterium_8, t0.cost_dark_matter AS cost_dark_matter_9, t0.cost_energy AS cost_energy_10, t0.storage_metal AS storage_metal_11, t0.storage_crystal AS storage_crystal_12, t0.storage_deuterium AS storage_deuterium_13, t0.energy_consumption_base AS energy_consumption_base_14, t0.energy_production_base AS energy_production_base_15, t0.image AS image_16, t0.description AS description_17, t0.building_class AS building_class_18, t0.one_per_planet AS one_per_planet_19, t0.is_buildable AS is_buildable_20, t0.slug AS slug_21 FROM buildings t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"deuterium_sintetizer"
]
|
||||||||||||||||||||||||||||||
| 16 | 0.26 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.factor AS factor_4, t0.level_max AS level_max_5, t0.cost_metal AS cost_metal_6, t0.cost_crystal AS cost_crystal_7, t0.cost_deuterium AS cost_deuterium_8, t0.cost_dark_matter AS cost_dark_matter_9, t0.cost_energy AS cost_energy_10, t0.storage_metal AS storage_metal_11, t0.storage_crystal AS storage_crystal_12, t0.storage_deuterium AS storage_deuterium_13, t0.energy_consumption_base AS energy_consumption_base_14, t0.energy_production_base AS energy_production_base_15, t0.image AS image_16, t0.description AS description_17, t0.building_class AS building_class_18, t0.one_per_planet AS one_per_planet_19, t0.is_buildable AS is_buildable_20, t0.slug AS slug_21 FROM buildings t0 WHERE t0.id = ?
Parameters:
[
286
]
|
||||||||||||||||||||||||||||||
| 17 | 0.21 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.factor AS factor_4, t0.level_max AS level_max_5, t0.cost_metal AS cost_metal_6, t0.cost_crystal AS cost_crystal_7, t0.cost_deuterium AS cost_deuterium_8, t0.cost_dark_matter AS cost_dark_matter_9, t0.cost_energy AS cost_energy_10, t0.storage_metal AS storage_metal_11, t0.storage_crystal AS storage_crystal_12, t0.storage_deuterium AS storage_deuterium_13, t0.energy_consumption_base AS energy_consumption_base_14, t0.energy_production_base AS energy_production_base_15, t0.image AS image_16, t0.description AS description_17, t0.building_class AS building_class_18, t0.one_per_planet AS one_per_planet_19, t0.is_buildable AS is_buildable_20, t0.slug AS slug_21 FROM buildings t0 WHERE t0.id = ?
Parameters:
[
287
]
|
||||||||||||||||||||||||||||||
| 18 | 0.19 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.factor AS factor_4, t0.level_max AS level_max_5, t0.cost_metal AS cost_metal_6, t0.cost_crystal AS cost_crystal_7, t0.cost_deuterium AS cost_deuterium_8, t0.cost_dark_matter AS cost_dark_matter_9, t0.cost_energy AS cost_energy_10, t0.storage_metal AS storage_metal_11, t0.storage_crystal AS storage_crystal_12, t0.storage_deuterium AS storage_deuterium_13, t0.energy_consumption_base AS energy_consumption_base_14, t0.energy_production_base AS energy_production_base_15, t0.image AS image_16, t0.description AS description_17, t0.building_class AS building_class_18, t0.one_per_planet AS one_per_planet_19, t0.is_buildable AS is_buildable_20, t0.slug AS slug_21 FROM buildings t0 WHERE t0.id = ?
Parameters:
[
288
]
|
||||||||||||||||||||||||||||||
| 19 | 0.42 ms |
SELECT t0.id AS id_1, t0.user_uuid AS user_uuid_2, t0.name AS name_3, t0.uni AS uni_4, t0.system_x AS system_x_5, t0.system_y AS system_y_6, t0.system_z AS system_z_7, t0.destroyed AS destroyed_8, t0.metal AS metal_9, t0.metal_max AS metal_max_10, t0.crystal AS crystal_11, t0.crystal_max AS crystal_max_12, t0.deuterium AS deuterium_13, t0.deuterium_max AS deuterium_max_14, t0.last_resource_update AS last_resource_update_15, t0.tf_metal AS tf_metal_16, t0.tf_crystal AS tf_crystal_17, t0.metal_building AS metal_building_18, t0.crystal_building AS crystal_building_19, t0.deuterium_building AS deuterium_building_20, t0.solar_building AS solar_building_21, t0.nuclear_building AS nuclear_building_22, t0.robot_building AS robot_building_23, t0.nanite_building AS nanite_building_24, t0.hangar_building AS hangar_building_25, t0.metalstorage_building AS metalstorage_building_26, t0.crystalstorage_building AS crystalstorage_building_27, t0.deuteriumstorage_building AS deuteriumstorage_building_28, t0.laboratory_building AS laboratory_building_29, t0.university_building AS university_building_30, t0.alliancehangar_building AS alliancehangar_building_31, t0.missilesilo_building AS missilesilo_building_32, t0.missilelauncher_defense AS missilelauncher_defense_33, t0.phalanx_defense AS phalanx_defense_34, t0.smalllaser_defense AS smalllaser_defense_35, t0.biglaser_defense AS biglaser_defense_36, t0.gausscannon_defense AS gausscannon_defense_37, t0.ioncannon_defense AS ioncannon_defense_38, t0.plasmacannon_defense AS plasmacannon_defense_39, t0.smallshield_defense AS smallshield_defense_40, t0.bigshield_defense AS bigshield_defense_41, t0.planetshield_defense AS planetshield_defense_42, t0.gravitoncannon_defense AS gravitoncannon_defense_43, t0.interceptormissile_defense AS interceptormissile_defense_44, t0.orbitaldefenseplatform_defense AS orbitaldefenseplatform_defense_45, t0.smalltransportship_ship AS smalltransportship_ship_46, t0.bigtransportship_ship AS bigtransportship_ship_47, t0.lighthunter_ship AS lighthunter_ship_48, t0.heavyhunter_ship AS heavyhunter_ship_49, t0.cruiser_ship AS cruiser_ship_50, t0.battleship_ship AS battleship_ship_51, t0.colonyship_ship AS colonyship_ship_52, t0.smallrecycler_ship AS smallrecycler_ship_53, t0.mediumrecycler_ship AS mediumrecycler_ship_54, t0.bigrecycler_ship AS bigrecycler_ship_55, t0.spyprobe_ship AS spyprobe_ship_56, t0.bomber_ship AS bomber_ship_57, t0.solarsatellite_ship AS solarsatellite_ship_58, t0.destroyer_ship AS destroyer_ship_59, t0.deathstar_ship AS deathstar_ship_60, t0.battlecruiser_ship AS battlecruiser_ship_61, t0.lunenoire_ship AS lunenoire_ship_62, t0.evolutiontransporter_ship AS evolutiontransporter_ship_63, t0.gigarecycler_ship AS gigarecycler_ship_64, t0.dmcollector_ship AS dmcollector_ship_65, t0.darkmatter AS darkmatter_66, t0.uuid AS uuid_67, t0.terraforming_building AS terraforming_building_68, t0.jumpgate_building AS jumpgate_building_69, t0.moonbase_building AS moonbase_building_70, t0.laserphalanx_building AS laserphalanx_building_71, t0.planet_type AS planet_type_72, t0.last_update AS last_update_73, t0.crystal_storage AS crystal_storage_74, t0.deuterium_storage AS deuterium_storage_75, t0.metal_production AS metal_production_76, t0.crystal_production AS crystal_production_77, t0.deuterium_production AS deuterium_production_78, t0.energy_used AS energy_used_79, t0.energy_max AS energy_max_80, t0.metal_mine AS metal_mine_81, t0.crystal_mine AS crystal_mine_82, t0.deuterium_synthesizer AS deuterium_synthesizer_83, t0.solar_plant AS solar_plant_84, t0.fusion_reactor AS fusion_reactor_85, t0.robotics_factory AS robotics_factory_86, t0.nanite_factory AS nanite_factory_87, t0.shipyard AS shipyard_88, t0.terraformer AS terraformer_89, t0.alliance_depot AS alliance_depot_90, t0.missile_silo AS missile_silo_91 FROM planet t0 WHERE t0.uuid = ?
Parameters:
[
"34803f10-0fdc-4b1c-9f27-a756d54c12da"
]
|
||||||||||||||||||||||||||||||
| 20 | 0.30 ms |
SELECT p0_.id AS id_0, p0_.building_level AS building_level_1, p0_.planet_slug AS planet_slug_2, p0_.building_slug AS building_slug_3, b1_.id AS id_4, b1_.uuid AS uuid_5, b1_.name AS name_6, b1_.factor AS factor_7, b1_.level_max AS level_max_8, b1_.cost_metal AS cost_metal_9, b1_.cost_crystal AS cost_crystal_10, b1_.cost_deuterium AS cost_deuterium_11, b1_.cost_dark_matter AS cost_dark_matter_12, b1_.cost_energy AS cost_energy_13, b1_.storage_metal AS storage_metal_14, b1_.storage_crystal AS storage_crystal_15, b1_.storage_deuterium AS storage_deuterium_16, b1_.energy_consumption_base AS energy_consumption_base_17, b1_.energy_production_base AS energy_production_base_18, b1_.image AS image_19, b1_.description AS description_20, b1_.building_class AS building_class_21, b1_.one_per_planet AS one_per_planet_22, b1_.is_buildable AS is_buildable_23, b1_.slug AS slug_24, p0_.planet_id AS planet_id_25, p0_.building_id AS building_id_26 FROM planet_building p0_ INNER JOIN buildings b1_ ON p0_.building_id = b1_.id WHERE p0_.planet_id = ?
Parameters:
[
18
]
|
||||||||||||||||||||||||||||||
| 21 | 0.23 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.class AS class_3, t0.one_per_planet AS one_per_planet_4, t0.level_max AS level_max_5, t0.cost_metal AS cost_metal_6, t0.cost_crystal AS cost_crystal_7, t0.cost_deuterium AS cost_deuterium_8, t0.cost_dark_matter AS cost_dark_matter_9, t0.slug AS slug_10, t0.consumption_deuterium AS consumption_deuterium_11, t0.capacity AS capacity_12, t0.attack AS attack_13, t0.defense AS defense_14, t0.drive_science AS drive_science_15, t0.base_speed AS base_speed_16, t0.description AS description_17, t0.image AS image_18, t0.energy_production AS energy_production_19 FROM ships t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"solarsatellit"
]
|
||||||||||||||||||||||||||||||
| 22 | 0.44 ms |
SELECT t0.id AS id_1, t0.users_amount AS users_amount_2, t0.game_speed AS game_speed_3, t0.fleet_speed AS fleet_speed_4, t0.resource_multiplier AS resource_multiplier_5, t0.storage_multiplier AS storage_multiplier_6, t0.message_delete_behavior AS message_delete_behavior_7, t0.message_delete_days AS message_delete_days_8, t0.halt_speed AS halt_speed_9, t0.fleet_cdr AS fleet_cdr_10, t0.def_in_tf AS def_in_tf_11, t0.fleet_in_tf AS fleet_in_tf_12, t0.resource_loot AS resource_loot_13, t0.planet_fields AS planet_fields_14, t0.uni_name AS uni_name_15, t0.uni_enabled AS uni_enabled_16, t0.closed_text AS closed_text_17, t0.metal_standard_income AS metal_standard_income_18, t0.crystal_standard_income AS crystal_standard_income_19, t0.deuterium_standard_income AS deuterium_standard_income_20, t0.energy_standard_income AS energy_standard_income_21, t0.noob_protection AS noob_protection_22, t0.noob_protectiontime AS noob_protectiontime_23, t0.forum_url AS forum_url_24, t0.admin_attackable AS admin_attackable_25, t0.language AS language_26, t0.teamspeak_mod AS teamspeak_mod_27, t0.teamspeak_server AS teamspeak_server_28, t0.teamspeak_tcp_port AS teamspeak_tcp_port_29, t0.teamspeak_udp_port AS teamspeak_udp_port_30, t0.registration_closed AS registration_closed_31, t0.welcome_text AS welcome_text_32, t0.min_build_time AS min_build_time_33, t0.modules AS modules_34, t0.tradeable_ships AS tradeable_ships_35, t0.tradeable_ships_fee AS tradeable_ships_fee_36, t0.galaxy_width AS galaxy_width_37, t0.galaxy_height AS galaxy_height_38, t0.galaxy_depth AS galaxy_depth_39, t0.max_construction_count AS max_construction_count_40, t0.max_science_count AS max_science_count_41, t0.max_ship_count AS max_ship_count_42, t0.refund_building_percent AS refund_building_percent_43, t0.refund_research_percent AS refund_research_percent_44, t0.refund_ship_percent AS refund_ship_percent_45, t0.max_start_planets_per_player AS max_start_planets_per_player_46, t0.max_planets AS max_planets_47, t0.max_planets_astrophysics AS max_planets_astrophysics_48, t0.max_planets_officers AS max_planets_officers_49, t0.max_planets_science AS max_planets_science_50, t0.flight_deuterium_cost_per_click AS flight_deuterium_cost_per_click_51, t0.max_dm_missions AS max_dm_missions_52, t0.max_resource_overflow AS max_resource_overflow_53, t0.moon_chance_factor AS moon_chance_factor_54, t0.moon_chance AS moon_chance_55, t0.trader_dm_cost AS trader_dm_cost_56, t0.university_factor_science AS university_factor_science_57, t0.max_fleets_per_association AS max_fleets_per_association_58, t0.delete_moon_debris AS delete_moon_debris_59, t0.min_umode_time AS min_umode_time_60, t0.gate_interval_time AS gate_interval_time_61, t0.start_metal AS start_metal_62, t0.start_crystal AS start_crystal_63, t0.start_deuterium AS start_deuterium_64, t0.start_dm AS start_dm_65, t0.referal_active AS referal_active_66, t0.referal_bonus_dm AS referal_bonus_dm_67, t0.referal_minpoints AS referal_minpoints_68, t0.referal_max_referals AS referal_max_referals_69, t0.del_user_manual AS del_user_manual_70, t0.send_inavtive_mail AS send_inavtive_mail_71, t0.silo_size_factor AS silo_size_factor_72, t0.energy_factor AS energy_factor_73, t0.alliance_min_points AS alliance_min_points_74, t0.expedition_res_limit AS expedition_res_limit_75, t0.server_id AS server_id_76 FROM uni t0 WHERE t0.id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||
| 23 | 0.20 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.image AS image_3, t0.fields AS fields_4, t0.fields_max AS fields_max_5, t0.temp_min AS temp_min_6, t0.temp_max AS temp_max_7, t0.diameter AS diameter_8 FROM planet_type t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
2
]
|
||||||||||||||||||||||||||||||
| 24 | 0.20 ms |
SELECT SUM(p0_.building_level) AS sclr_0 FROM planet_building p0_ WHERE p0_.planet_id = ?
Parameters:
[
18
]
|
||||||||||||||||||||||||||||||
| 25 | 0.28 ms |
SELECT t0.id AS id_1, t0.from_uuid AS from_uuid_2, t0.from_name AS from_name_3, t0.to_uuid AS to_uuid_4, t0.to_name AS to_name_5, t0.send_date AS send_date_6, t0.message AS message_7, t0.was_read AS was_read_8, t0.deleted AS deleted_9, t0.answered AS answered_10, t0.subject AS subject_11, t0.message_type AS message_type_12, t0.slug AS slug_13 FROM messages t0 WHERE t0.to_uuid = ? AND t0.deleted = ? ORDER BY t0.send_date DESC
Parameters:
[ "8ea56b7d-70ac-4956-8925-743ecadded35" 0 ]
|
||||||||||||||||||||||||||||||
| 26 | 0.28 ms |
SELECT r0_.id AS id_0, r0_.version AS version_1, r0_.git_tag AS git_tag_2, r0_.released_at AS released_at_3, r0_.body AS body_4, r0_.created_at AS created_at_5 FROM `release` r0_ ORDER BY r0_.released_at DESC LIMIT 1
Parameters:
[] |
||||||||||||||||||||||||||||||
| 27 | 0.32 ms |
SELECT COUNT(m0_.id) AS sclr_0 FROM messages m0_ WHERE m0_.to_uuid = ? AND m0_.deleted = ? AND m0_.was_read = ?
Parameters:
[ "8ea56b7d-70ac-4956-8925-743ecadded35" 0 0 ] |
||||||||||||||||||||||||||||||
| 28 | 0.26 ms |
SELECT COUNT(s0_.id) AS sclr_0 FROM support s0_ INNER JOIN support s1_ ON (s1_.id = s0_.parent_message) WHERE s0_.parent_message IS NOT NULL AND s0_.seen_by_player = ? AND s1_.uuid = ?
Parameters:
[ 0 "ShaoKhan@gmx.de" ] |
||||||||||||||||||||||||||||||
| 29 | 0.27 ms |
SELECT 1 AS sclr_0 FROM planet_building p0_ INNER JOIN planet p1_ ON p0_.planet_id = p1_.id WHERE p1_.user_uuid = ? AND p0_.building_slug = ? AND p0_.building_level >= 1 LIMIT 1
Parameters:
[ "8ea56b7d-70ac-4956-8925-743ecadded35" "laboratory" ] |
||||||||||||||||||||||||||||||
| 30 | 0.21 ms |
SELECT 1 AS sclr_0 FROM planet_building p0_ INNER JOIN planet p1_ ON p0_.planet_id = p1_.id WHERE p1_.user_uuid = ? AND p0_.building_slug = ? AND p0_.building_level >= 1 LIMIT 1
Parameters:
[ "8ea56b7d-70ac-4956-8925-743ecadded35" "hangar" ] |
||||||||||||||||||||||||||||||
| 31 | 0.43 ms |
SELECT t0.id AS id_1, t0.user_uuid AS user_uuid_2, t0.name AS name_3, t0.uni AS uni_4, t0.system_x AS system_x_5, t0.system_y AS system_y_6, t0.system_z AS system_z_7, t0.destroyed AS destroyed_8, t0.metal AS metal_9, t0.metal_max AS metal_max_10, t0.crystal AS crystal_11, t0.crystal_max AS crystal_max_12, t0.deuterium AS deuterium_13, t0.deuterium_max AS deuterium_max_14, t0.last_resource_update AS last_resource_update_15, t0.tf_metal AS tf_metal_16, t0.tf_crystal AS tf_crystal_17, t0.metal_building AS metal_building_18, t0.crystal_building AS crystal_building_19, t0.deuterium_building AS deuterium_building_20, t0.solar_building AS solar_building_21, t0.nuclear_building AS nuclear_building_22, t0.robot_building AS robot_building_23, t0.nanite_building AS nanite_building_24, t0.hangar_building AS hangar_building_25, t0.metalstorage_building AS metalstorage_building_26, t0.crystalstorage_building AS crystalstorage_building_27, t0.deuteriumstorage_building AS deuteriumstorage_building_28, t0.laboratory_building AS laboratory_building_29, t0.university_building AS university_building_30, t0.alliancehangar_building AS alliancehangar_building_31, t0.missilesilo_building AS missilesilo_building_32, t0.missilelauncher_defense AS missilelauncher_defense_33, t0.phalanx_defense AS phalanx_defense_34, t0.smalllaser_defense AS smalllaser_defense_35, t0.biglaser_defense AS biglaser_defense_36, t0.gausscannon_defense AS gausscannon_defense_37, t0.ioncannon_defense AS ioncannon_defense_38, t0.plasmacannon_defense AS plasmacannon_defense_39, t0.smallshield_defense AS smallshield_defense_40, t0.bigshield_defense AS bigshield_defense_41, t0.planetshield_defense AS planetshield_defense_42, t0.gravitoncannon_defense AS gravitoncannon_defense_43, t0.interceptormissile_defense AS interceptormissile_defense_44, t0.orbitaldefenseplatform_defense AS orbitaldefenseplatform_defense_45, t0.smalltransportship_ship AS smalltransportship_ship_46, t0.bigtransportship_ship AS bigtransportship_ship_47, t0.lighthunter_ship AS lighthunter_ship_48, t0.heavyhunter_ship AS heavyhunter_ship_49, t0.cruiser_ship AS cruiser_ship_50, t0.battleship_ship AS battleship_ship_51, t0.colonyship_ship AS colonyship_ship_52, t0.smallrecycler_ship AS smallrecycler_ship_53, t0.mediumrecycler_ship AS mediumrecycler_ship_54, t0.bigrecycler_ship AS bigrecycler_ship_55, t0.spyprobe_ship AS spyprobe_ship_56, t0.bomber_ship AS bomber_ship_57, t0.solarsatellite_ship AS solarsatellite_ship_58, t0.destroyer_ship AS destroyer_ship_59, t0.deathstar_ship AS deathstar_ship_60, t0.battlecruiser_ship AS battlecruiser_ship_61, t0.lunenoire_ship AS lunenoire_ship_62, t0.evolutiontransporter_ship AS evolutiontransporter_ship_63, t0.gigarecycler_ship AS gigarecycler_ship_64, t0.dmcollector_ship AS dmcollector_ship_65, t0.darkmatter AS darkmatter_66, t0.uuid AS uuid_67, t0.terraforming_building AS terraforming_building_68, t0.jumpgate_building AS jumpgate_building_69, t0.moonbase_building AS moonbase_building_70, t0.laserphalanx_building AS laserphalanx_building_71, t0.planet_type AS planet_type_72, t0.last_update AS last_update_73, t0.crystal_storage AS crystal_storage_74, t0.deuterium_storage AS deuterium_storage_75, t0.metal_production AS metal_production_76, t0.crystal_production AS crystal_production_77, t0.deuterium_production AS deuterium_production_78, t0.energy_used AS energy_used_79, t0.energy_max AS energy_max_80, t0.metal_mine AS metal_mine_81, t0.crystal_mine AS crystal_mine_82, t0.deuterium_synthesizer AS deuterium_synthesizer_83, t0.solar_plant AS solar_plant_84, t0.fusion_reactor AS fusion_reactor_85, t0.robotics_factory AS robotics_factory_86, t0.nanite_factory AS nanite_factory_87, t0.shipyard AS shipyard_88, t0.terraformer AS terraformer_89, t0.alliance_depot AS alliance_depot_90, t0.missile_silo AS missile_silo_91 FROM planet t0 WHERE t0.user_uuid = ?
Parameters:
[
"8ea56b7d-70ac-4956-8925-743ecadded35"
]
|
||||||||||||||||||||||||||||||
| 32 | 0.24 ms |
SELECT 1 AS sclr_0 FROM planet_ships p0_ WHERE p0_.planet_slug IN (?) AND p0_.amount > 0 LIMIT 1
Parameters:
[
"34803f10-0fdc-4b1c-9f27-a756d54c12da"
]
|
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\User | 1 |
| App\Entity\Planet | 1 |
| App\Entity\Uni | 1 |
| App\Entity\Server | 1 |
| App\Entity\Release | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\UserBlocked | No errors. |
| App\Entity\Planet | No errors. |
| App\Entity\PlanetBuilding | No errors. |
| App\Entity\BuildingsQueue | No errors. |
| App\Entity\Uni | No errors. |
| App\Entity\Server | No errors. |
| App\Entity\Buildings | No errors. |
| App\Entity\Ships | No errors. |
| App\Entity\PlanetType | No errors. |
| App\Entity\Messages | No errors. |
| App\Entity\Release | No errors. |
| App\Entity\Support | No errors. |
| App\Entity\PlanetShips | No errors. |