| Total time |
5.90553 ms |
| nb_queries |
7 |
| 1 |
| SQL |
SELECT COUNT(race_id) AS nb, race_id, MAX(alliance_id) as alliance_id
FROM jeu_profils AS PRO
LEFT JOIN jeu_persos AS PER
ON PER.id=PRO.id
WHERE PRO.id >= 1
AND PRO.id < 90000
AND derniere_co > 1779397549
AND plan_id is not null
GROUP BY race_id
ORDER BY nb DESC
|
| time |
1198660 |
| trace |
#0 /app/statistiques.php(28): Database->query() #1 {main} |
| Time |
1.19866 ms |
|
| 0 |
| SQL |
SELECT id,nom,classe_initiale
FROM data_classes
ORDER BY nom |
| time |
1061115 |
| trace |
#0 /app/statistiques.php(18): Database->query() #1 {main} |
| Time |
1.061115 ms |
|
| 3 |
| SQL |
SELECT COUNT(sexe) AS nb, sexe
FROM jeu_profils AS PRO
LEFT JOIN jeu_persos AS PER
ON PER.id=PRO.id
WHERE PRO.id >= 1
AND PRO.id < 90000
AND derniere_co > 1779397549
AND plan_id is not null
GROUP BY sexe
ORDER BY nb DESC
|
| time |
802298 |
| trace |
#0 /app/statistiques.php(67): Database->query() #1 {main} |
| Time |
0.802298 ms |
|
| 6 |
| SQL |
SELECT AVG(XP) AS XP, COUNT(*) AS nb_joueurs
FROM jeu_profils AS PRO
LEFT JOIN jeu_persos AS PER
ON PER.id=PRO.id
WHERE PRO.id >= 1
AND PRO.id < 90000
AND derniere_co > 1779397549
AND plan_id is not null
|
| time |
778166 |
| trace |
#0 /app/statistiques.php(106): Database->query() #1 {main} |
| Time |
0.778166 ms |
|
| 4 |
| SQL |
SELECT COUNT(classe_id) AS nb, classe_id, race_id AS id
FROM jeu_profils AS PRO
LEFT JOIN jeu_persos AS PER
ON PER.id=PRO.id
WHERE PRO.id >= 1
AND PRO.id < 90000
AND derniere_co > 1779397549
AND plan_id is not null
GROUP BY classe_id, race_id
ORDER BY id,nb DESC
|
| time |
767595 |
| trace |
#0 /app/statistiques.php(85): Database->query() #1 {main} |
| Time |
0.767595 ms |
|
| 2 |
| SQL |
SELECT COUNT(classe_id) AS nb, classe_id
FROM jeu_profils AS PRO
LEFT JOIN jeu_persos AS PER
ON PER.id=PRO.id
WHERE PRO.id >= 1
AND PRO.id < 90000
AND derniere_co > 1779397549
AND plan_id is not null
GROUP BY classe_id
ORDER BY nb DESC
|
| time |
715047 |
| trace |
#0 /app/statistiques.php(49): Database->query() #1 {main} |
| Time |
0.715047 ms |
|
| 5 |
| SQL |
SELECT id,nom FROM data_alliance ORDER BY nom
|
| time |
582649 |
| trace |
#0 /app/includes/constantes.php(325): Database->query() #1 /app/includes/classes/utils/class_CacheManager.php(23): {closure}() #2 /app/includes/constantes.php(323): CacheManager::get() #3 /app/statistiques.php(103): get_data_alliances_nom() #4 {main} |
| Time |
0.582649 ms |
|