| 0.0005 |
SELECT `concession`.*
FROM (`concession`)
WHERE `id_concession` = '16'
|
| 0.0006 |
SELECT *
FROM (`slide`)
WHERE `afficher` = 1
AND `rid_concession` = '16'
ORDER BY `ordre`
|
| 0.5332 |
SELECT `blog__articles`.*, COUNT(blog__commentaires.id_commentaire) as nbCommentaires
FROM (`blog__articles`)
LEFT OUTER JOIN `blog__commentaires` ON `blog__commentaires`.`rid_article` = `blog__articles`.`id_article`
GROUP BY `blog__articles`.`id_article`
ORDER BY `id_article` DESC
LIMIT 3
|
| 0.0002 |
SELECT *
FROM (`type`)
ORDER BY `type` DESC
|
| 0.0009 |
SELECT `vehicule`.*, ROUND(100- (vehicule.prix * 100 / vehicule.prix_constructeur)) as remise, `modele`.`nb_places`, `motorisation`.`nb_rapports`, `motorisation`.`cylindree`, `motorisation`.`puissance_reelle`, `motorisation`.`puissance_fiscale`, `motorisation`.`emission_co2`, `motorisation`.`consommation_extraurbaine`, `motorisation`.`consommation_urbaine`, `motorisation`.`consommation_mixte`, `marque`.`marque` as libelle_marque, `modele`.`rid_marque`, `modele`.`id_modele`, `modele`.`modele` as libelle_modele, modele.logo as logo, `finition`.`finition` as libelle_finition, `disponibilite`.`disponibilite` as libelle_disponibilite, `motorisation`.`motorisation` as libelle_motorisation, `carrosserie`.`carrosserie` as libelle_carrosserie, `type`.`type` as libelle_type, `pays`.`pays` as libelle_pays, `energie`.`energie` as libelle_energie, `transmission`.`transmission` as libelle_transmission, `concession`.`nom` AS libelle_concession
FROM (`vehicule`)
JOIN `marque` ON `vehicule`.`rid_marque` = `marque`.`id_marque`
JOIN `modele` ON `vehicule`.`rid_modele` = `modele`.`id_modele`
JOIN `finition` ON `vehicule`.`rid_finition` = `finition`.`id_finition`
JOIN `motorisation` ON `vehicule`.`rid_motorisation` = `motorisation`.`id_motorisation`
LEFT OUTER JOIN `pays` ON `vehicule`.`rid_pays` = `pays`.`id_pays`
LEFT OUTER JOIN `disponibilite` ON `vehicule`.`rid_disponibilite` = `disponibilite`.`id_disponibilite`
LEFT OUTER JOIN `carrosserie` ON `modele`.`rid_carrosserie` = `id_carrosserie`
LEFT OUTER JOIN `energie` ON `motorisation`.`rid_energie` = `id_energie`
LEFT OUTER JOIN `transmission` ON `motorisation`.`rid_transmission` = `id_transmission`
LEFT JOIN `type` ON `type`.`id_type` = `vehicule`.`rid_type`
LEFT JOIN `concession` ON `concession`.`id_concession` = `vehicule`.`rid_concession`
WHERE `rid_concession` = '16'
AND `rid_type` = 2
AND `isSelectionFlash` = 1
GROUP BY `vehicule`.`id_vehicule`
ORDER BY RAND()
LIMIT 3
|
| 0.0007 |
SELECT `vehicule`.*, ROUND(100- (vehicule.prix * 100 / vehicule.prix_constructeur)) as remise, `modele`.`nb_places`, `motorisation`.`nb_rapports`, `motorisation`.`cylindree`, `motorisation`.`puissance_reelle`, `motorisation`.`puissance_fiscale`, `motorisation`.`emission_co2`, `motorisation`.`consommation_extraurbaine`, `motorisation`.`consommation_urbaine`, `motorisation`.`consommation_mixte`, `marque`.`marque` as libelle_marque, `modele`.`rid_marque`, `modele`.`id_modele`, `modele`.`modele` as libelle_modele, modele.logo as logo, `finition`.`finition` as libelle_finition, `disponibilite`.`disponibilite` as libelle_disponibilite, `motorisation`.`motorisation` as libelle_motorisation, `carrosserie`.`carrosserie` as libelle_carrosserie, `type`.`type` as libelle_type, `pays`.`pays` as libelle_pays, `energie`.`energie` as libelle_energie, `transmission`.`transmission` as libelle_transmission, `concession`.`nom` AS libelle_concession
FROM (`vehicule`)
JOIN `marque` ON `vehicule`.`rid_marque` = `marque`.`id_marque`
JOIN `modele` ON `vehicule`.`rid_modele` = `modele`.`id_modele`
JOIN `finition` ON `vehicule`.`rid_finition` = `finition`.`id_finition`
JOIN `motorisation` ON `vehicule`.`rid_motorisation` = `motorisation`.`id_motorisation`
LEFT OUTER JOIN `pays` ON `vehicule`.`rid_pays` = `pays`.`id_pays`
LEFT OUTER JOIN `disponibilite` ON `vehicule`.`rid_disponibilite` = `disponibilite`.`id_disponibilite`
LEFT OUTER JOIN `carrosserie` ON `modele`.`rid_carrosserie` = `id_carrosserie`
LEFT OUTER JOIN `energie` ON `motorisation`.`rid_energie` = `id_energie`
LEFT OUTER JOIN `transmission` ON `motorisation`.`rid_transmission` = `id_transmission`
LEFT JOIN `type` ON `type`.`id_type` = `vehicule`.`rid_type`
LEFT JOIN `concession` ON `concession`.`id_concession` = `vehicule`.`rid_concession`
WHERE `rid_concession` = '16'
AND `rid_type` = 2
GROUP BY `vehicule`.`id_vehicule`
ORDER BY RAND()
LIMIT 3
|
| 0.0007 |
SELECT `vehicule`.*, ROUND(100- (vehicule.prix * 100 / vehicule.prix_constructeur)) as remise, `modele`.`nb_places`, `motorisation`.`nb_rapports`, `motorisation`.`cylindree`, `motorisation`.`puissance_reelle`, `motorisation`.`puissance_fiscale`, `motorisation`.`emission_co2`, `motorisation`.`consommation_extraurbaine`, `motorisation`.`consommation_urbaine`, `motorisation`.`consommation_mixte`, `marque`.`marque` as libelle_marque, `modele`.`rid_marque`, `modele`.`id_modele`, `modele`.`modele` as libelle_modele, modele.logo as logo, `finition`.`finition` as libelle_finition, `disponibilite`.`disponibilite` as libelle_disponibilite, `motorisation`.`motorisation` as libelle_motorisation, `carrosserie`.`carrosserie` as libelle_carrosserie, `type`.`type` as libelle_type, `pays`.`pays` as libelle_pays, `energie`.`energie` as libelle_energie, `transmission`.`transmission` as libelle_transmission, `concession`.`nom` AS libelle_concession
FROM (`vehicule`)
JOIN `marque` ON `vehicule`.`rid_marque` = `marque`.`id_marque`
JOIN `modele` ON `vehicule`.`rid_modele` = `modele`.`id_modele`
JOIN `finition` ON `vehicule`.`rid_finition` = `finition`.`id_finition`
JOIN `motorisation` ON `vehicule`.`rid_motorisation` = `motorisation`.`id_motorisation`
LEFT OUTER JOIN `pays` ON `vehicule`.`rid_pays` = `pays`.`id_pays`
LEFT OUTER JOIN `disponibilite` ON `vehicule`.`rid_disponibilite` = `disponibilite`.`id_disponibilite`
LEFT OUTER JOIN `carrosserie` ON `modele`.`rid_carrosserie` = `id_carrosserie`
LEFT OUTER JOIN `energie` ON `motorisation`.`rid_energie` = `id_energie`
LEFT OUTER JOIN `transmission` ON `motorisation`.`rid_transmission` = `id_transmission`
LEFT JOIN `type` ON `type`.`id_type` = `vehicule`.`rid_type`
LEFT JOIN `concession` ON `concession`.`id_concession` = `vehicule`.`rid_concession`
WHERE `rid_concession` = '16'
AND `rid_type` = 1
AND `isSelectionFlash` = 1
GROUP BY `vehicule`.`id_vehicule`
ORDER BY RAND()
LIMIT 3
|
| 0.0007 |
SELECT `vehicule`.*, ROUND(100- (vehicule.prix * 100 / vehicule.prix_constructeur)) as remise, `modele`.`nb_places`, `motorisation`.`nb_rapports`, `motorisation`.`cylindree`, `motorisation`.`puissance_reelle`, `motorisation`.`puissance_fiscale`, `motorisation`.`emission_co2`, `motorisation`.`consommation_extraurbaine`, `motorisation`.`consommation_urbaine`, `motorisation`.`consommation_mixte`, `marque`.`marque` as libelle_marque, `modele`.`rid_marque`, `modele`.`id_modele`, `modele`.`modele` as libelle_modele, modele.logo as logo, `finition`.`finition` as libelle_finition, `disponibilite`.`disponibilite` as libelle_disponibilite, `motorisation`.`motorisation` as libelle_motorisation, `carrosserie`.`carrosserie` as libelle_carrosserie, `type`.`type` as libelle_type, `pays`.`pays` as libelle_pays, `energie`.`energie` as libelle_energie, `transmission`.`transmission` as libelle_transmission, `concession`.`nom` AS libelle_concession
FROM (`vehicule`)
JOIN `marque` ON `vehicule`.`rid_marque` = `marque`.`id_marque`
JOIN `modele` ON `vehicule`.`rid_modele` = `modele`.`id_modele`
JOIN `finition` ON `vehicule`.`rid_finition` = `finition`.`id_finition`
JOIN `motorisation` ON `vehicule`.`rid_motorisation` = `motorisation`.`id_motorisation`
LEFT OUTER JOIN `pays` ON `vehicule`.`rid_pays` = `pays`.`id_pays`
LEFT OUTER JOIN `disponibilite` ON `vehicule`.`rid_disponibilite` = `disponibilite`.`id_disponibilite`
LEFT OUTER JOIN `carrosserie` ON `modele`.`rid_carrosserie` = `id_carrosserie`
LEFT OUTER JOIN `energie` ON `motorisation`.`rid_energie` = `id_energie`
LEFT OUTER JOIN `transmission` ON `motorisation`.`rid_transmission` = `id_transmission`
LEFT JOIN `type` ON `type`.`id_type` = `vehicule`.`rid_type`
LEFT JOIN `concession` ON `concession`.`id_concession` = `vehicule`.`rid_concession`
WHERE `rid_concession` = '16'
AND `rid_type` = 1
GROUP BY `vehicule`.`id_vehicule`
ORDER BY RAND()
LIMIT 3
|
| 0.0004 |
SELECT *
FROM (`marque`)
JOIN `vehicule` ON `vehicule`.`rid_marque` = `marque`.`id_marque`
WHERE `vehicule`.`rid_concession` = '16'
AND `prix` <> 0
GROUP BY `marque`.`id_marque`
ORDER BY `marque` ASC
|
| 0.0002 |
SELECT concession.*
FROM (`concession`)
WHERE `active` = 1
ORDER BY `ordre`
|
| 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` IS NULL
|
| 0.0001 |
SELECT *
FROM (`marque`)
WHERE `slug` IS NULL
|
| 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` = '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` = '16'
|
| 0.0001 |
SELECT *
FROM (`marque`)
WHERE `id_marque` = '12'
|
| 0.0001 |
SELECT *
FROM (`cms__page`)
WHERE `id_page` = 7
|
Pôle Société Groupe N.E.P Car
