1 |
1.41 ms |
SELECT idcategorie, name FROM ann_categories WHERE online=1
SELECT idcategorie, name FROM ann_categories WHERE online=1;
|
2 |
0.47 ms |
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 |
1.14 ms |
SELECT * FROM ann_categories WHERE online=1 ORDER BY class
SELECT * FROM ann_categories WHERE online=1 ORDER BY class;
|
4 |
43.29 ms |
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;
|
5 |
144.93 ms |
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=1
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=1;
|
6 |
2.05 ms |
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=2
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=2;
|
7 |
75.07 ms |
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=3
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=3;
|
8 |
18.82 ms |
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=4
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=4;
|
9 |
87.02 ms |
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=7
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=7;
|
10 |
4.45 ms |
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=8
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=8;
|
11 |
48.02 ms |
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=6
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=6;
|
12 |
4.52 ms |
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=9
SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=9;
|
13 |
39.47 ms |
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;
|
14 |
37.97 ms |
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 |
1.11 ms |
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;
|