array(2) {
["data_classes_nom_65"]=>
int(16)
["data_classes_nom"]=>
int(1)
}
| Total time |
11.234778 ms |
| nb_queries |
6 |
| 2 |
| SQL |
SELECT a.id, a.nom, a.modificateurs, a.cout, a.type, a.cible, a.effets, a.immunites, a.action_liee, a.portee, a.description, a.classe_id, a.race_id, a.niveau, a.PC, a.cooldown, a.est_offensif,
a.remplace, remplace.nom as remplace_name,
GROUP_CONCAT(DISTINCT exclu.id) as exclude_ids, GROUP_CONCAT(DISTINCT exclu.nom) as exclude_names,
GROUP_CONCAT(DISTINCT required.id) as required_ids, GROUP_CONCAT(DISTINCT required.nom) as required_names
FROM data_actions a
LEFT JOIN data_actions exclu on FIND_IN_SET(exclu.id ,a.`exclusions`)
LEFT JOIN data_actions required on FIND_IN_SET(required.id ,a.`pre_requis`)
LEFT JOIN data_actions remplace on remplace.id = a.remplace
WHERE a.classe_id=65
GROUP BY a.id
ORDER BY a.niveau,remplace.id,MAX(required.id),MAX(exclu.id) |
| time |
7401991 |
| trace |
#0 /app/includes/classes/services/class_action_service.php(25): Database->query() #1 /app/includes/classes/services/class_action_service.php(73): action_service->find() #2 /app/regles/classe.php(226): action_service->get_actions_from_classe() #3 {main} |
| Time |
7.401991 ms |
|
| 4 |
| SQL |
SELECT classe_id, race_id
FROM data_classes_races
JOIN data_classes AS DC ON DC.id = classe_id
WHERE
invisible=0 AND
debouche_1=65 OR debouche_2=65 OR debouche_3=65 |
| time |
941651 |
| trace |
#0 /app/regles/classe.php(255): Database->query() #1 {main} |
| Time |
0.941651 ms |
|
| 3 |
| SQL |
SELECT id, nom, modificateurs, cout, type, portee, cible, effets, immunites, element_id, race_id, classe_id, description, niveau, cooldown
FROM data_sorts
WHERE classe_id=65
ORDER BY element_id, niveau
|
| time |
862715 |
| trace |
#0 /app/regles/classe.php(232): Database->query() #1 {main} |
| Time |
0.862715 ms |
|
| 1 |
| SQL |
SELECT id,nom FROM data_classes ORDER BY nom |
| time |
755411 |
| trace |
#0 /app/includes/constantes.php(211): Database->query() #1 /app/includes/classes/utils/class_CacheManager.php(23): {closure}() #2 /app/includes/constantes.php(209): CacheManager::get() #3 /app/regles/classe.php(204): get_array_classes_nom() #4 {main} |
| Time |
0.755411 ms |
|
| 0 |
| SQL |
SELECT id, nom, classe_initiale, invisible, description, niveau_min FROM data_classes WHERE id=65 |
| time |
722770 |
| trace |
#0 /app/regles/classe.php(197): Database->query() #1 {main} |
| Time |
0.72277 ms |
|
| 5 |
| SQL |
SELECT description_sup, race_id, debouche_1, debouche_2, debouche_3
FROM data_classes_races
WHERE classe_id=65 |
| time |
550240 |
| trace |
#0 /app/regles/classe.php(266): Database->query() #1 {main} |
| Time |
0.55024 ms |
|