2.27 ms (50.33%)
|
1 |
SELECT * FROM ann_categories WHERE online=1 ORDER BY class
SELECT * FROM ann_categories WHERE online=1 ORDER BY class;
|
1.15 ms (25.49%)
|
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;
|
0.27 ms (5.90%)
|
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;
|
0.13 ms (2.97%)
|
1 |
SELECT idcategorie, name FROM ann_categories WHERE online=1
SELECT idcategorie, name FROM ann_categories WHERE online=1;
|
0.09 ms (1.91%)
|
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;
|
0.08 ms (1.88%)
|
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;
|
0.06 ms (1.42%)
|
1 |
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=1
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=1;
|
0.06 ms (1.31%)
|
1 |
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=9
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=9;
|
0.06 ms (1.31%)
|
1 |
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=8
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=8;
|
0.06 ms (1.29%)
|
1 |
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=7
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=7;
|
0.06 ms (1.26%)
|
1 |
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=6
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=6;
|
0.06 ms (1.26%)
|
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;
|
0.06 ms (1.22%)
|
1 |
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=2
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=2;
|
0.06 ms (1.22%)
|
1 |
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=3
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=3;
|
0.06 ms (1.22%)
|
1 |
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=4
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=4;
|