Query Metrics
3
Database Queries
3
Different statements
1.41 ms
Query time
0
Invalid entities
2
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.52 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.id = ?
Parameters:
[
51
]
|
||||||||||||||||||||||||||||
| 2 | 0.62 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 = ? LIMIT 1
Parameters:
[
"8ea56b7d-70ac-4956-8925-743ecadded35"
]
|
||||||||||||||||||||||||||||
| 3 | 0.27 ms |
SELECT t0.id AS id_1, t0.building_level AS building_level_2, t0.planet_slug AS planet_slug_3, t0.building_slug AS building_slug_4, t0.planet_id AS planet_id_5, t0.building_id AS building_id_6 FROM planet_building t0 WHERE t0.planet_id = ?
Parameters:
[
18
]
|
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 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Planet | No errors. |
| App\Entity\PlanetBuilding | No errors. |
| App\Entity\BuildingsQueue | No errors. |
| App\Entity\Buildings | No errors. |