Symfony Profiler

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

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 = 'wayra' LIMIT 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

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;

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

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;

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

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;

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

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;