array(2) {
["data_classes_nom_11"]=>
int(19)
["data_classes_nom"]=>
int(1)
}
| Total time |
13.216029 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=11
GROUP BY a.id
ORDER BY a.niveau,remplace.id,MAX(required.id),MAX(exclu.id) |
| time |
10242921 |
| 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 |
10.242921 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=11
ORDER BY element_id, niveau
|
| time |
761502 |
| trace |
#0 /app/regles/classe.php(232): Database->query() #1 {main} |
| Time |
0.761502 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=11 OR debouche_2=11 OR debouche_3=11 |
| time |
760911 |
| trace |
#0 /app/regles/classe.php(255): Database->query() #1 {main} |
| Time |
0.760911 ms |
|
| 0 |
| SQL |
SELECT id, nom, classe_initiale, invisible, description, niveau_min FROM data_classes WHERE id=11 |
| time |
577945 |
| trace |
#0 /app/regles/classe.php(197): Database->query() #1 {main} |
| Time |
0.577945 ms |
|
| 1 |
| SQL |
SELECT id,nom FROM data_classes ORDER BY nom |
| time |
446092 |
| 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.446092 ms |
|
| 5 |
| SQL |
SELECT description_sup, race_id, debouche_1, debouche_2, debouche_3
FROM data_classes_races
WHERE classe_id=11 |
| time |
426658 |
| trace |
#0 /app/regles/classe.php(266): Database->query() #1 {main} |
| Time |
0.426658 ms |
|