| 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=4 OR dispo=4) AND (dispo IS NULL OR dispo<>8)
ORDER BY groupe_id, dispo, prix |
| time |
1705306 |
| trace |
#0 /app/regles/race.php(143): Database->query() #1 {main} |
| Time |
1.705306 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=4 AND classe_id IS NULL
ORDER BY element_id, niveau
|
| time |
690894 |
| trace |
#0 /app/regles/race.php(121): Database->query() #1 {main} |
| Time |
0.690894 ms |
|