| 3 |
| SQL |
SELECT D.id AS data_objet_id, D.nom, D.modificateurs, D.portee, D.effets, D.immunites, D.type, D.slot, D.groupe_id, D.niveau, D.poids, D.prix, D.race_id, D.classe_id, D.perte, D.description, D.action_id, D.magique,
A.cout AS action_cout, A.nom AS action_nom, A.modificateurs AS action_modificateurs, A.immunites AS action_immunites, A.effets AS action_effets, A.description AS action_description, A.cible AS action_cible, A.type AS action_type, D.cooldown, A.portee AS action_portee, A.cooldown AS action_cooldown, A.est_offensif as action_est_offensif, dispo
FROM data_objets AS D
LEFT JOIN data_actions AS A
ON A.id=D.action_id
WHERE (D.race_id=5 OR dispo=5) AND (dispo IS NULL OR dispo<>8)
ORDER BY groupe_id, dispo, prix |
| time |
1418287 |
| trace |
#0 /app/regles/race.php(143): Database->query() #1 {main} |
| Time |
1.418287 ms |
|
| 2 |
| SQL |
SELECT id, nom, modificateurs, cout, type, portee, cible, effets, immunites, element_id, race_id, classe_id, description, niveau, cooldown
FROM data_sorts
WHERE dispo=5 AND classe_id IS NULL
ORDER BY element_id, niveau
|
| time |
1027845 |
| trace |
#0 /app/regles/race.php(121): Database->query() #1 {main} |
| Time |
1.027845 ms |
|