94.41 ms (24.48%)
|
1 |
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=1
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=1;
|
63.04 ms (16.35%)
|
1 |
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=7
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=7;
|
60.21 ms (15.61%)
|
1 |
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=3
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=3;
|
39.12 ms (10.15%)
|
1 |
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=6
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=6;
|
38.68 ms (10.03%)
|
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.61 ms (7.68%)
|
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;
|
29.52 ms (7.66%)
|
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;
|
14.20 ms (3.68%)
|
1 |
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=4
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=4;
|
4.61 ms (1.19%)
|
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;
|
3.60 ms (0.93%)
|
1 |
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=8
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=8;
|
2.93 ms (0.76%)
|
1 |
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=9
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=9;
|
2.06 ms (0.54%)
|
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.63 ms (0.42%)
|
1 |
SELECT * FROM ann_categories WHERE online=1 ORDER BY class
SELECT * FROM ann_categories WHERE online=1 ORDER BY class;
|
1.61 ms (0.42%)
|
1 |
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=2
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=2;
|
0.36 ms (0.09%)
|
1 |
SELECT idcategorie, name FROM ann_categories WHERE online=1
SELECT idcategorie, name FROM ann_categories WHERE online=1;
|