| 0.0002 |
SELECT `concession`.*
FROM (`concession`)
WHERE `id_concession` = '9'
|
| 0.0001 |
SELECT *
FROM (`marque`)
WHERE `id_marque` = '8'
|
| 0.0001 |
SELECT *
FROM (`marque`)
WHERE `id_marque` = '2'
|
| 0.0001 |
SELECT *
FROM (`marque`)
WHERE `id_marque` = 'dacia'
|
| 0.0001 |
SELECT *
FROM (`marque`)
WHERE `slug` = 'dacia'
|
| 0.0010 |
SELECT MIN(`prix`) AS prix
FROM (`vehicule`)
WHERE `prix` > 0
AND `rid_marque` = '8'
AND `rid_type` = 'null'
AND `rid_concession` = '9'
|
| 0.0006 |
SELECT MAX(`prix`) AS prix
FROM (`vehicule`)
WHERE `prix` > 0
AND `rid_marque` = '8'
AND `rid_type` = 'null'
AND `rid_concession` = '9'
|
| 0.0004 |
SELECT *
FROM (`type`)
WHERE `id_type` = 'null'
|
| 0.0004 |
SELECT concession.*
FROM (`concession`)
WHERE `active` = 1
ORDER BY `ordre`
|
| 0.0003 |
SELECT *
FROM (`marque`)
WHERE `id_marque` = '8'
|
| 0.0002 |
SELECT *
FROM (`marque`)
WHERE `id_marque` = '2'
|
| 0.0002 |
SELECT *
FROM (`marque`)
WHERE `id_marque` IS NULL
|
| 0.0002 |
SELECT *
FROM (`marque`)
WHERE `slug` IS NULL
|
| 0.0002 |
SELECT *
FROM (`marque`)
WHERE `id_marque` = '8'
|
| 0.0001 |
SELECT *
FROM (`marque`)
WHERE `id_marque` = '2'
|
| 0.0001 |
SELECT *
FROM (`marque`)
WHERE `id_marque` = '8'
|
| 0.0001 |
SELECT *
FROM (`marque`)
WHERE `id_marque` = '2'
|
| 0.0001 |
SELECT *
FROM (`marque`)
WHERE `id_marque` = '8'
|
| 0.0001 |
SELECT *
FROM (`marque`)
WHERE `id_marque` = '2'
|
| 0.0001 |
SELECT *
FROM (`marque`)
WHERE `id_marque` = '12'
|
| 0.0001 |
SELECT *
FROM (`marque`)
WHERE `id_marque` = '12'
|
| 0.0001 |
SELECT *
FROM (`marque`)
WHERE `id_marque` = '12'
|
| 0.0001 |
SELECT `concession`.*
FROM (`concession`)
WHERE `id_concession` = '9'
|
| 0.0001 |
SELECT *
FROM (`marque`)
WHERE `id_marque` = '8'
|
| 0.0001 |
SELECT *
FROM (`marque`)
WHERE `id_marque` = '2'
|
| 0.0003 |
SELECT *
FROM (`marque`)
WHERE `id_marque` = '8;2'
|
| 0.0001 |
SELECT *
FROM (`cms__page`)
WHERE `id_page` = 7
|
| 0.0001 |
SELECT *
FROM (`type`)
WHERE `id_type` = 'null'
|
| 0.0001 |
SELECT `concession`.*
FROM (`concession`)
WHERE `id_concession` = '9'
|
| 0.0001 |
SELECT *
FROM (`marque`)
WHERE `id_marque` = '8'
|
| 0.0001 |
SELECT *
FROM (`marque`)
WHERE `id_marque` = '2'
|
| 0.0013 |
SELECT *
FROM (`carrosserie`)
JOIN `modele` ON `modele`.`rid_carrosserie` = `carrosserie`.`id_carrosserie`
JOIN `vehicule` ON `vehicule`.`rid_modele` = `modele`.`id_modele`
WHERE `vehicule`.`rid_concession` = '9'
AND `vehicule`.`rid_type` = 'null'
AND `prix` <> 0
AND `afficher` = 1
GROUP BY `carrosserie`.`id_carrosserie`
ORDER BY `carrosserie`
|
| 0.0005 |
SELECT *
FROM (`marque`)
JOIN `vehicule` ON `vehicule`.`rid_marque` = `marque`.`id_marque`
WHERE `vehicule`.`rid_concession` = '9'
AND `vehicule`.`rid_type` = 'null'
AND `prix` <> 0
GROUP BY `marque`.`id_marque`
ORDER BY `ordre`
|
| 0.0009 |
SELECT `modele`.*, `modele`.`id_modele` as id_modele, `marque`.`marque` as libelle_marque, `carrosserie`.`carrosserie` as libelle_carrosserie, `genre`.`genre` as libelle_genre, MIN(vehicule.prix) as prix_min, MIN(vehicule.prix_marchand) as prix_marchand_min, COUNT(vehicule.id_vehicule) as nb_vehi
FROM (`modele`)
LEFT OUTER JOIN `marque` ON `modele`.`rid_marque` = `marque`.`id_marque`
LEFT OUTER JOIN `carrosserie` ON `modele`.`rid_carrosserie` = `carrosserie`.`id_carrosserie`
LEFT OUTER JOIN `genre` ON `modele`.`code_genre` = `genre`.`code_genre`
JOIN `vehicule` ON `modele`.`id_modele` = `vehicule`.`rid_modele`
WHERE `prix` <> 0
AND `vehicule`.`rid_concession` = '9'
AND `vehicule`.`rid_type` = 'null'
AND `modele`.`rid_marque` = '8'
GROUP BY `modele`.`id_modele`
ORDER BY `modele`
|
SARCELLES (95) Les Garages Sarcellois RENAULT / DACIA
Retour site