96.77 ms (25.08%)
|
1 |
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=1
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=1;
|
66.84 ms (17.32%)
|
1 |
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=7
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=7;
|
59.71 ms (15.48%)
|
1 |
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=3
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=3;
|
39.30 ms (10.18%)
|
1 |
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=6
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=6;
|
38.47 ms (9.97%)
|
1 |
SELECT idcategorie, COUNT(*) AS count FROM ann_annonces WHERE online=1 AND valid=1 AND attente=0 GROUP BY idcategorie
SELECT idcategorie, COUNT(*) AS count FROM ann_annonces WHERE online=1 AND valid=1 AND attente=0 GROUP BY idcategorie;
|
29.28 ms (7.59%)
|
1 |
SELECT a.*,e.login FROM ann_annonces a, extranetusers e
WHERE e.idextranetuser=a.idextranetuser
AND a.online=1 AND a.valid=1 AND a.attente=0 ORDER BY a.dateinsert DESC LIMIT 0,1
SELECT a.*,e.login FROM ann_annonces a, extranetusers e
WHERE e.idextranetuser=a.idextranetuser
AND a.online=1 AND a.valid=1 AND a.attente=0 ORDER BY a.dateinsert DESC LIMIT 0,1;
|
28.74 ms (7.45%)
|
1 |
SELECT COUNT(idannonce) FROM ann_annonces WHERE online=1 AND valid=1 AND attente=0
SELECT COUNT(idannonce) FROM ann_annonces WHERE online=1 AND valid=1 AND attente=0;
|
15.08 ms (3.91%)
|
1 |
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=4
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=4;
|
4.04 ms (1.05%)
|
1 |
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=8
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=8;
|
3.11 ms (0.81%)
|
1 |
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=9
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=9;
|
2.19 ms (0.57%)
|
1 |
SELECT * FROM bannieres
WHERE publish=1
AND valid=1
AND is_bottom=1
AND date_start<=NOW()
AND date_end>=NOW()
ORDER BY bannieres.order ASC
LIMIT 0,10
SELECT * FROM bannieres
WHERE publish=1
AND valid=1
AND is_bottom=1
AND date_start<=NOW()
AND date_end>=NOW()
ORDER BY bannieres.order ASC
LIMIT 0,10;
|
1.64 ms (0.43%)
|
1 |
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=2
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=2;
|
0.23 ms (0.06%)
|
1 |
SELECT * FROM ann_categories WHERE online=1 ORDER BY class
SELECT * FROM ann_categories WHERE online=1 ORDER BY class;
|
0.22 ms (0.06%)
|
1 |
SELECT idcategorie, name FROM ann_categories WHERE online=1
SELECT idcategorie, name FROM ann_categories WHERE online=1;
|
0.22 ms (0.06%)
|
1 |
SELECT *,`bigregions`.idbigregion as idbigregion
FROM `bigregions`
JOIN `regions` ON `regions`.`idbigregion`=`bigregions`.`idbigregion`
JOIN `departements` ON `regions`.`idregion`=`departements`.`idregion`
ORDER BY `bigregions`.`bigregion` ASC, `departements`.`departement` ASC
SELECT *,`bigregions`.idbigregion as idbigregion
FROM `bigregions`
JOIN `regions` ON `regions`.`idbigregion`=`bigregions`.`idbigregion`
JOIN `departements` ON `regions`.`idregion`=`departements`.`idregion`
ORDER BY `bigregions`.`bigregion` ASC, `departements`.`departement` ASC;
|