Query Metrics
5
Database Queries
5
Different statements
14.41 ms
Query time
0
Invalid entities
240
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
8.10 ms (56.22%) |
1 |
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.content AS content_3, p0_.icon AS icon_4, p0_.position AS position_5, p0_.published AS published_6, p0_.is_bestiaire AS is_bestiaire_7, p0_.is_personnage AS is_personnage_8, p0_.featured_image AS featured_image_9, p0_.featured_image_align AS featured_image_align_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p1_.id AS id_13, p1_.title AS title_14, p1_.slug AS slug_15, p1_.content AS content_16, p1_.icon AS icon_17, p1_.position AS position_18, p1_.published AS published_19, p1_.is_bestiaire AS is_bestiaire_20, p1_.is_personnage AS is_personnage_21, p1_.featured_image AS featured_image_22, p1_.featured_image_align AS featured_image_align_23, p1_.created_at AS created_at_24, p1_.updated_at AS updated_at_25, p0_.parent_id AS parent_id_26, p1_.parent_id AS parent_id_27 FROM page p0_ LEFT JOIN page p1_ ON p0_.id = p1_.parent_id WHERE p0_.parent_id IS NULL ORDER BY p0_.position ASC, p1_.position ASC
Parameters:
[]
|
||||||||||||||||||||||||||||
|
2.17 ms (15.03%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.slug AS slug_4, t0.description AS description_5, t0.image AS image_6, t0.race AS race_7, t0.origin AS origin_8, t0.profession AS profession_9, t0.constitution AS constitution_10, t0.force_score AS force_score_11, t0.agilite AS agilite_12, t0.rapidite AS rapidite_13, t0.intelligence AS intelligence_14, t0.perception AS perception_15, t0.presence AS presence_16, t0.volonte AS volonte_17, t0.empathie AS empathie_18, t0.essence AS essence_19, t0.creativite AS creativite_20, t0.constitution_start AS constitution_start_21, t0.force_start AS force_start_22, t0.agilite_start AS agilite_start_23, t0.rapidite_start AS rapidite_start_24, t0.intelligence_start AS intelligence_start_25, t0.perception_start AS perception_start_26, t0.presence_start AS presence_start_27, t0.volonte_start AS volonte_start_28, t0.empathie_start AS empathie_start_29, t0.essence_start AS essence_start_30, t0.creativite_start AS creativite_start_31, t0.corruption_start AS corruption_start_32, t0.skills AS skills_33, t0.skills_start AS skills_start_34, t0.race_specialization AS race_specialization_35, t0.race_specialization_score AS race_specialization_score_36, t0.race_specialization_skill AS race_specialization_skill_37, t0.origin_specialization AS origin_specialization_38, t0.origin_specialization_score AS origin_specialization_score_39, t0.origin_specialization_skill AS origin_specialization_skill_40, t0.secondary_specializations AS secondary_specializations_41, t0.initiative AS initiative_42, t0.actions AS actions_43, t0.attaque_arme1_main AS attaque_arme1_main_44, t0.attaque_arme2_mains AS attaque_arme2_mains_45, t0.attaque_distance AS attaque_distance_46, t0.attaque_art_martial AS attaque_art_martial_47, t0.attaque_sortilege AS attaque_sortilege_48, t0.defense AS defense_49, t0.defense_bouclier AS defense_bouclier_50, t0.bonus_dommages AS bonus_dommages_51, t0.actions2_armes AS actions2_armes_52, t0.actions_arc_tir AS actions_arc_tir_53, t0.actions_art_martial AS actions_art_martial_54, t0.bonus_dommages2_mains AS bonus_dommages2_mains_55, t0.pv AS pv_56, t0.pm AS pm_57, t0.pf AS pf_58, t0.blessure_critique AS blessure_critique_59, t0.blessure_grave AS blessure_grave_60, t0.corruption AS corruption_61, t0.tares AS tares_62, t0.mort AS mort_63, t0.mort_xp_spent AS mort_xp_spent_64, t0.equipment AS equipment_65, t0.gold AS gold_66, t0.armor_score AS armor_score_67, t0.experience AS experience_68, t0.professions AS professions_69, t0.profession_level AS profession_level_70, t0.created_at AS created_at_71, t0.updated_at AS updated_at_72 FROM personnage t0 ORDER BY t0.name ASC
Parameters:
[]
|
||||||||||||||||||||||||||||
|
1.71 ms (11.86%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.slug AS slug_4, t0.description AS description_5, t0.image AS image_6, t0.race AS race_7, t0.origin AS origin_8, t0.profession AS profession_9, t0.constitution AS constitution_10, t0.force_score AS force_score_11, t0.agilite AS agilite_12, t0.rapidite AS rapidite_13, t0.intelligence AS intelligence_14, t0.perception AS perception_15, t0.presence AS presence_16, t0.volonte AS volonte_17, t0.empathie AS empathie_18, t0.essence AS essence_19, t0.creativite AS creativite_20, t0.constitution_start AS constitution_start_21, t0.force_start AS force_start_22, t0.agilite_start AS agilite_start_23, t0.rapidite_start AS rapidite_start_24, t0.intelligence_start AS intelligence_start_25, t0.perception_start AS perception_start_26, t0.presence_start AS presence_start_27, t0.volonte_start AS volonte_start_28, t0.empathie_start AS empathie_start_29, t0.essence_start AS essence_start_30, t0.creativite_start AS creativite_start_31, t0.corruption_start AS corruption_start_32, t0.skills AS skills_33, t0.skills_start AS skills_start_34, t0.race_specialization AS race_specialization_35, t0.race_specialization_score AS race_specialization_score_36, t0.race_specialization_skill AS race_specialization_skill_37, t0.origin_specialization AS origin_specialization_38, t0.origin_specialization_score AS origin_specialization_score_39, t0.origin_specialization_skill AS origin_specialization_skill_40, t0.secondary_specializations AS secondary_specializations_41, t0.initiative AS initiative_42, t0.actions AS actions_43, t0.attaque_arme1_main AS attaque_arme1_main_44, t0.attaque_arme2_mains AS attaque_arme2_mains_45, t0.attaque_distance AS attaque_distance_46, t0.attaque_art_martial AS attaque_art_martial_47, t0.attaque_sortilege AS attaque_sortilege_48, t0.defense AS defense_49, t0.defense_bouclier AS defense_bouclier_50, t0.bonus_dommages AS bonus_dommages_51, t0.actions2_armes AS actions2_armes_52, t0.actions_arc_tir AS actions_arc_tir_53, t0.actions_art_martial AS actions_art_martial_54, t0.bonus_dommages2_mains AS bonus_dommages2_mains_55, t0.pv AS pv_56, t0.pm AS pm_57, t0.pf AS pf_58, t0.blessure_critique AS blessure_critique_59, t0.blessure_grave AS blessure_grave_60, t0.corruption AS corruption_61, t0.tares AS tares_62, t0.mort AS mort_63, t0.mort_xp_spent AS mort_xp_spent_64, t0.equipment AS equipment_65, t0.gold AS gold_66, t0.armor_score AS armor_score_67, t0.experience AS experience_68, t0.professions AS professions_69, t0.profession_level AS profession_level_70, t0.created_at AS created_at_71, t0.updated_at AS updated_at_72 FROM personnage t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"sumaq"
]
|
||||||||||||||||||||||||||||
|
1.27 ms (8.83%) |
1 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.characteristic AS characteristic_4, t0.is_magic AS is_magic_5 FROM skill t0 ORDER BY t0.characteristic ASC, t0.name ASC
Parameters:
[]
|
||||||||||||||||||||||||||||
|
1.16 ms (8.06%) |
1 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.carac AS carac_4, t0.skill AS skill_5, t0.bonus AS bonus_6 FROM profession t0 ORDER BY t0.name ASC
Parameters:
[]
|
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\Page | 89 |
| App\Entity\Skill | 66 |
| App\Entity\Profession | 63 |
| App\Entity\Character | 22 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Character | No errors. |
| App\Entity\Page | No errors. |
| App\Entity\Skill | No errors. |
| App\Entity\Profession | No errors. |