| 0.0023 |
SELECT p.*, `m`.`nom` as `nom_marque`, `c`.`nom` as `nom_categorie`, `t`.`taux_tva` as `montant_tva`, `r`.`nom` as `nom_rubrique`, `g`.`nom` as `nom_genre`, `ma`.`nom` as `nom_matiere`
FROM `produits` `p`
LEFT OUTER JOIN `produits_decli` `pd` ON `pd`.`rid_produit` = `p`.`id_produit`
LEFT OUTER JOIN `produits_marquage_vetement` `pmv` ON `pmv`.`rid_decli` = `pd`.`id_decli`
LEFT OUTER JOIN `marque` `m` ON `m`.`id_marque` = `p`.`id_produit`
LEFT OUTER JOIN `categories` `c` ON `c`.`id_categorie` = `p`.`rid_categorie`
LEFT OUTER JOIN `rubrique` `r` ON `r`.`id_rubrique` = `p`.`rid_rubrique`
LEFT OUTER JOIN `marquage_vetement` `mv` ON `mv`.`reference` = `pmv`.`ref_marquage`
LEFT OUTER JOIN `tva` `t` ON `t`.`id_tva` = `p`.`rid_tva`
LEFT OUTER JOIN `genre` `g` ON `g`.`id_genre` = `p`.`rid_genre`
LEFT OUTER JOIN `matiere` `ma` ON `ma`.`id_matiere` = `p`.`rid_matiere`
LEFT OUTER JOIN `produits_activite` `pa` ON `pa`.`rid_produit` = `p`.`id_produit`
WHERE `p`.`id_produit` = '493'
GROUP BY `id_produit`
|
| 0.0001 |
SELECT `c`.*
FROM `categories` `c`
WHERE `c`.`id_categorie` = '68'
GROUP BY `id_categorie`
|
| 0.0012 |
SELECT `pd`.*, `c`.`nom` as `nom_couleur`, `t`.`nom` as `nom_taille`, `pmv`.`ref_marquage` as `reference`
FROM `produits_decli` `pd`
LEFT OUTER JOIN `couleur` `c` ON `c`.`id_couleur` = `pd`.`rid_couleur`
LEFT OUTER JOIN `taille` `t` ON `t`.`id_taille` = `pd`.`rid_taille`
LEFT OUTER JOIN `produits_marquage_vetement` `pmv` ON `pmv`.`rid_decli` = `pd`.`id_decli`
WHERE `rid_produit` = '493'
|
| 0.0001 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0001 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0000 |
SELECT `m`.*
FROM `marquage_vetement` `m`
WHERE `reference` = 'BDH'
AND `reference` NOT IN('SERT', 'SERS')
GROUP BY `id_marquage`
|
| 0.0011 |
SELECT `pd`.*, `c`.`nom` as `nom_couleur`, `t`.`nom` as `nom_taille`, `pmv`.`ref_marquage` as `reference`
FROM `produits_decli` `pd`
LEFT OUTER JOIN `couleur` `c` ON `c`.`id_couleur` = `pd`.`rid_couleur`
LEFT OUTER JOIN `taille` `t` ON `t`.`id_taille` = `pd`.`rid_taille`
LEFT OUTER JOIN `produits_marquage_vetement` `pmv` ON `pmv`.`rid_decli` = `pd`.`id_decli`
WHERE `rid_produit` = '493'
GROUP BY `rid_couleur`
|
| 0.0007 |
SELECT `pd`.*, `c`.`nom` as `nom_couleur`, `t`.`nom` as `nom_taille`, `pmv`.`ref_marquage` as `reference`
FROM `produits_decli` `pd`
LEFT OUTER JOIN `couleur` `c` ON `c`.`id_couleur` = `pd`.`rid_couleur`
LEFT OUTER JOIN `taille` `t` ON `t`.`id_taille` = `pd`.`rid_taille`
LEFT OUTER JOIN `produits_marquage_vetement` `pmv` ON `pmv`.`rid_decli` = `pd`.`id_decli`
WHERE `rid_produit` = '493'
AND `rid_couleur` = '1'
GROUP BY `id_decli`
ORDER BY `t`.`ordre` ASC
|
| 0.0008 |
SELECT `pd`.*, `c`.`nom` as `nom_couleur`, `t`.`nom` as `nom_taille`, `pmv`.`ref_marquage` as `reference`
FROM `produits_decli` `pd`
LEFT OUTER JOIN `couleur` `c` ON `c`.`id_couleur` = `pd`.`rid_couleur`
LEFT OUTER JOIN `taille` `t` ON `t`.`id_taille` = `pd`.`rid_taille`
LEFT OUTER JOIN `produits_marquage_vetement` `pmv` ON `pmv`.`rid_decli` = `pd`.`id_decli`
WHERE `rid_produit` = '493'
AND `rid_couleur` = '24'
GROUP BY `id_decli`
ORDER BY `t`.`ordre` ASC
|
| 0.0007 |
SELECT `pd`.*, `c`.`nom` as `nom_couleur`, `t`.`nom` as `nom_taille`, `pmv`.`ref_marquage` as `reference`
FROM `produits_decli` `pd`
LEFT OUTER JOIN `couleur` `c` ON `c`.`id_couleur` = `pd`.`rid_couleur`
LEFT OUTER JOIN `taille` `t` ON `t`.`id_taille` = `pd`.`rid_taille`
LEFT OUTER JOIN `produits_marquage_vetement` `pmv` ON `pmv`.`rid_decli` = `pd`.`id_decli`
WHERE `rid_produit` = '493'
AND `rid_couleur` = '45'
GROUP BY `id_decli`
ORDER BY `t`.`ordre` ASC
|
| 0.0007 |
SELECT `pd`.*, `c`.`nom` as `nom_couleur`, `t`.`nom` as `nom_taille`, `pmv`.`ref_marquage` as `reference`
FROM `produits_decli` `pd`
LEFT OUTER JOIN `couleur` `c` ON `c`.`id_couleur` = `pd`.`rid_couleur`
LEFT OUTER JOIN `taille` `t` ON `t`.`id_taille` = `pd`.`rid_taille`
LEFT OUTER JOIN `produits_marquage_vetement` `pmv` ON `pmv`.`rid_decli` = `pd`.`id_decli`
WHERE `rid_produit` = '493'
AND `rid_couleur` = '164'
GROUP BY `id_decli`
ORDER BY `t`.`ordre` ASC
|
| 0.0005 |
SELECT `pd`.*, `c`.`nom` as `nom_couleur`, `t`.`nom` as `nom_taille`, `pmv`.`ref_marquage` as `reference`
FROM `produits_decli` `pd`
LEFT OUTER JOIN `couleur` `c` ON `c`.`id_couleur` = `pd`.`rid_couleur`
LEFT OUTER JOIN `taille` `t` ON `t`.`id_taille` = `pd`.`rid_taille`
LEFT OUTER JOIN `produits_marquage_vetement` `pmv` ON `pmv`.`rid_decli` = `pd`.`id_decli`
WHERE `rid_produit` = '493'
AND `rid_couleur` = '282'
GROUP BY `id_decli`
ORDER BY `t`.`ordre` ASC
|
| 0.0005 |
SELECT `pd`.*, `c`.`nom` as `nom_couleur`, `t`.`nom` as `nom_taille`, `pmv`.`ref_marquage` as `reference`
FROM `produits_decli` `pd`
LEFT OUTER JOIN `couleur` `c` ON `c`.`id_couleur` = `pd`.`rid_couleur`
LEFT OUTER JOIN `taille` `t` ON `t`.`id_taille` = `pd`.`rid_taille`
LEFT OUTER JOIN `produits_marquage_vetement` `pmv` ON `pmv`.`rid_decli` = `pd`.`id_decli`
WHERE `rid_produit` = '493'
AND `rid_couleur` = '585'
GROUP BY `id_decli`
ORDER BY `t`.`ordre` ASC
|
| 0.0006 |
SELECT `pd`.*, `c`.`nom` as `nom_couleur`, `t`.`nom` as `nom_taille`, `pmv`.`ref_marquage` as `reference`
FROM `produits_decli` `pd`
LEFT OUTER JOIN `couleur` `c` ON `c`.`id_couleur` = `pd`.`rid_couleur`
LEFT OUTER JOIN `taille` `t` ON `t`.`id_taille` = `pd`.`rid_taille`
LEFT OUTER JOIN `produits_marquage_vetement` `pmv` ON `pmv`.`rid_decli` = `pd`.`id_decli`
WHERE `rid_produit` = '493'
AND `rid_couleur` = '586'
GROUP BY `id_decli`
ORDER BY `t`.`ordre` ASC
|
| 0.0006 |
SELECT `pd`.*, `c`.`nom` as `nom_couleur`, `t`.`nom` as `nom_taille`, `pmv`.`ref_marquage` as `reference`
FROM `produits_decli` `pd`
LEFT OUTER JOIN `couleur` `c` ON `c`.`id_couleur` = `pd`.`rid_couleur`
LEFT OUTER JOIN `taille` `t` ON `t`.`id_taille` = `pd`.`rid_taille`
LEFT OUTER JOIN `produits_marquage_vetement` `pmv` ON `pmv`.`rid_decli` = `pd`.`id_decli`
WHERE `rid_produit` = '493'
AND `rid_couleur` = '587'
GROUP BY `id_decli`
ORDER BY `t`.`ordre` ASC
|
| 0.0005 |
SELECT `pd`.*, `c`.`nom` as `nom_couleur`, `t`.`nom` as `nom_taille`, `pmv`.`ref_marquage` as `reference`
FROM `produits_decli` `pd`
LEFT OUTER JOIN `couleur` `c` ON `c`.`id_couleur` = `pd`.`rid_couleur`
LEFT OUTER JOIN `taille` `t` ON `t`.`id_taille` = `pd`.`rid_taille`
LEFT OUTER JOIN `produits_marquage_vetement` `pmv` ON `pmv`.`rid_decli` = `pd`.`id_decli`
WHERE `rid_produit` = '493'
AND `rid_couleur` = '588'
GROUP BY `id_decli`
ORDER BY `t`.`ordre` ASC
|
| 0.0005 |
SELECT `pd`.*, `c`.`nom` as `nom_couleur`, `t`.`nom` as `nom_taille`, `pmv`.`ref_marquage` as `reference`
FROM `produits_decli` `pd`
LEFT OUTER JOIN `couleur` `c` ON `c`.`id_couleur` = `pd`.`rid_couleur`
LEFT OUTER JOIN `taille` `t` ON `t`.`id_taille` = `pd`.`rid_taille`
LEFT OUTER JOIN `produits_marquage_vetement` `pmv` ON `pmv`.`rid_decli` = `pd`.`id_decli`
WHERE `rid_produit` = '493'
AND `rid_couleur` = '589'
GROUP BY `id_decli`
ORDER BY `t`.`ordre` ASC
|
| 0.0005 |
SELECT `pd`.*, `c`.`nom` as `nom_couleur`, `t`.`nom` as `nom_taille`, `pmv`.`ref_marquage` as `reference`
FROM `produits_decli` `pd`
LEFT OUTER JOIN `couleur` `c` ON `c`.`id_couleur` = `pd`.`rid_couleur`
LEFT OUTER JOIN `taille` `t` ON `t`.`id_taille` = `pd`.`rid_taille`
LEFT OUTER JOIN `produits_marquage_vetement` `pmv` ON `pmv`.`rid_decli` = `pd`.`id_decli`
WHERE `rid_produit` = '493'
AND `rid_couleur` = '590'
GROUP BY `id_decli`
ORDER BY `t`.`ordre` ASC
|
| 0.0001 |
SELECT `rid_activite`
FROM `produits_activite`
WHERE `rid_produit` = '493'
|
| 0.0001 |
SELECT p.*, `m`.`nom` as `nom_marque`, `c`.`nom` as `nom_categorie`, `t`.`taux_tva` as `montant_tva`, `r`.`nom` as `nom_rubrique`, `g`.`nom` as `nom_genre`, `ma`.`nom` as `nom_matiere`
FROM `produits` `p`
LEFT OUTER JOIN `produits_decli` `pd` ON `pd`.`rid_produit` = `p`.`id_produit`
LEFT OUTER JOIN `produits_marquage_vetement` `pmv` ON `pmv`.`rid_decli` = `pd`.`id_decli`
LEFT OUTER JOIN `marque` `m` ON `m`.`id_marque` = `p`.`id_produit`
LEFT OUTER JOIN `categories` `c` ON `c`.`id_categorie` = `p`.`rid_categorie`
LEFT OUTER JOIN `rubrique` `r` ON `r`.`id_rubrique` = `p`.`rid_rubrique`
LEFT OUTER JOIN `marquage_vetement` `mv` ON `mv`.`reference` = `pmv`.`ref_marquage`
LEFT OUTER JOIN `tva` `t` ON `t`.`id_tva` = `p`.`rid_tva`
LEFT OUTER JOIN `genre` `g` ON `g`.`id_genre` = `p`.`rid_genre`
LEFT OUTER JOIN `matiere` `ma` ON `ma`.`id_matiere` = `p`.`rid_matiere`
LEFT OUTER JOIN `produits_activite` `pa` ON `pa`.`rid_produit` = `p`.`id_produit`
WHERE `p`.`rid_categorie` = '68'
AND `p`.`afficher` = 1
GROUP BY `id_produit`
|
| 0.0001 |
SELECT `c`.*
FROM `categories` `c`
WHERE `c`.`id_categorie` = '40'
GROUP BY `id_categorie`
|
| 0.0026 |
SELECT p.*, `m`.`nom` as `nom_marque`, `c`.`nom` as `nom_categorie`, `t`.`taux_tva` as `montant_tva`, `r`.`nom` as `nom_rubrique`, `g`.`nom` as `nom_genre`, `ma`.`nom` as `nom_matiere`
FROM `produits` `p`
INNER JOIN `produits_decli` `pd` ON `pd`.`rid_produit` = `p`.`id_produit`
INNER JOIN `produits_marquage_vetement` `pmv` ON `pmv`.`rid_decli` = `pd`.`id_decli`
INNER JOIN `marque` `m` ON `m`.`id_marque` = `p`.`id_produit`
INNER JOIN `categories` `c` ON `c`.`id_categorie` = `p`.`rid_categorie`
INNER JOIN `rubrique` `r` ON `r`.`id_rubrique` = `p`.`rid_rubrique`
INNER JOIN `marquage_vetement` `mv` ON `mv`.`reference` = `pmv`.`ref_marquage`
INNER JOIN `tva` `t` ON `t`.`id_tva` = `p`.`rid_tva`
INNER JOIN `genre` `g` ON `g`.`id_genre` = `p`.`rid_genre`
INNER JOIN `matiere` `ma` ON `ma`.`id_matiere` = `p`.`rid_matiere`
INNER JOIN `produits_activite` `pa` ON `pa`.`rid_produit` = `p`.`id_produit`
WHERE `p`.`id_produit` > "493"
GROUP BY `id_produit`
|
| 0.0001 |
SELECT `c`.*
FROM `categories` `c`
WHERE `rid_rubrique` = '1'
AND `rid_categorie` = 0
AND `afficher` = '1'
GROUP BY `id_categorie`
ORDER BY `ordre`, `nom`
|
| 0.0001 |
SELECT `c`.*
FROM `categories` `c`
WHERE `rid_rubrique` = '1'
AND `rid_categorie` = '6'
AND `afficher` = '1'
GROUP BY `id_categorie`
ORDER BY `ordre`, `nom`
|
| 0.0001 |
SELECT `c`.*
FROM `categories` `c`
WHERE `rid_rubrique` = '1'
AND `rid_categorie` = '40'
AND `afficher` = '1'
GROUP BY `id_categorie`
ORDER BY `ordre`, `nom`
|
| 0.0001 |
SELECT `c`.*
FROM `categories` `c`
WHERE `rid_rubrique` = '1'
AND `rid_categorie` = '15'
AND `afficher` = '1'
GROUP BY `id_categorie`
ORDER BY `ordre`, `nom`
|
| 0.0001 |
SELECT `c`.*
FROM `categories` `c`
WHERE `rid_rubrique` = '1'
AND `rid_categorie` = '38'
AND `afficher` = '1'
GROUP BY `id_categorie`
ORDER BY `ordre`, `nom`
|
| 0.0001 |
SELECT `c`.*
FROM `categories` `c`
WHERE `rid_rubrique` = '1'
AND `rid_categorie` = '28'
AND `afficher` = '1'
GROUP BY `id_categorie`
ORDER BY `ordre`, `nom`
|
| 0.0001 |
SELECT `c`.*
FROM `categories` `c`
WHERE `rid_rubrique` = '1'
AND `rid_categorie` = '52'
AND `afficher` = '1'
GROUP BY `id_categorie`
ORDER BY `ordre`, `nom`
|
| 0.0001 |
SELECT `c`.*
FROM `categories` `c`
WHERE `rid_rubrique` = '1'
AND `rid_categorie` = '26'
AND `afficher` = '1'
GROUP BY `id_categorie`
ORDER BY `ordre`, `nom`
|
| 0.0001 |
SELECT `c`.*
FROM `categories` `c`
WHERE `rid_rubrique` = '1'
AND `rid_categorie` = '4'
AND `afficher` = '1'
GROUP BY `id_categorie`
ORDER BY `ordre`, `nom`
|
| 0.0001 |
SELECT `c`.*
FROM `categories` `c`
WHERE `rid_rubrique` = '1'
AND `rid_categorie` = '18'
AND `afficher` = '1'
GROUP BY `id_categorie`
ORDER BY `ordre`, `nom`
|
| 0.0001 |
SELECT `c`.*
FROM `categories` `c`
WHERE `rid_rubrique` = '1'
AND `rid_categorie` = '8'
AND `afficher` = '1'
GROUP BY `id_categorie`
ORDER BY `ordre`, `nom`
|
| 0.0001 |
SELECT `c`.*
FROM `categories` `c`
WHERE `rid_rubrique` = '1'
AND `rid_categorie` = '1'
AND `afficher` = '1'
GROUP BY `id_categorie`
ORDER BY `ordre`, `nom`
|
| 0.0001 |
SELECT `c`.*
FROM `categories` `c`
WHERE `rid_rubrique` = '1'
AND `rid_categorie` = '20'
AND `afficher` = '1'
GROUP BY `id_categorie`
ORDER BY `ordre`, `nom`
|
| 0.0001 |
SELECT `c`.*
FROM `categories` `c`
WHERE `rid_rubrique` = '1'
AND `rid_categorie` = '12'
AND `afficher` = '1'
GROUP BY `id_categorie`
ORDER BY `ordre`, `nom`
|
| 0.0001 |
SELECT `c`.*
FROM `categories` `c`
WHERE `rid_rubrique` = '1'
AND `rid_categorie` = '43'
AND `afficher` = '1'
GROUP BY `id_categorie`
ORDER BY `ordre`, `nom`
|
| 0.0001 |
SELECT `c`.*
FROM `categories` `c`
WHERE `rid_rubrique` = '2'
AND `rid_categorie` = 0
AND `afficher` = '1'
GROUP BY `id_categorie`
ORDER BY `ordre`, `nom`
|
| 0.0001 |
SELECT `c`.*
FROM `categories` `c`
WHERE `rid_rubrique` = '2'
AND `rid_categorie` = '104'
AND `afficher` = '1'
GROUP BY `id_categorie`
ORDER BY `ordre`, `nom`
|
| 0.0001 |
SELECT `c`.*
FROM `categories` `c`
WHERE `rid_rubrique` = '2'
AND `rid_categorie` = '116'
AND `afficher` = '1'
GROUP BY `id_categorie`
ORDER BY `ordre`, `nom`
|
| 0.0001 |
SELECT `c`.*
FROM `categories` `c`
WHERE `rid_rubrique` = '2'
AND `rid_categorie` = '124'
AND `afficher` = '1'
GROUP BY `id_categorie`
ORDER BY `ordre`, `nom`
|
| 0.0001 |
SELECT `c`.*
FROM `categories` `c`
WHERE `rid_rubrique` = '2'
AND `rid_categorie` = '139'
AND `afficher` = '1'
GROUP BY `id_categorie`
ORDER BY `ordre`, `nom`
|
| 0.0001 |
SELECT `c`.*
FROM `categories` `c`
WHERE `rid_rubrique` = '2'
AND `rid_categorie` = '146'
AND `afficher` = '1'
GROUP BY `id_categorie`
ORDER BY `ordre`, `nom`
|
| 0.0001 |
SELECT `c`.*
FROM `categories` `c`
WHERE `rid_rubrique` = '2'
AND `rid_categorie` = '153'
AND `afficher` = '1'
GROUP BY `id_categorie`
ORDER BY `ordre`, `nom`
|
| 0.0001 |
SELECT `c`.*
FROM `categories` `c`
WHERE `rid_rubrique` = '2'
AND `rid_categorie` = '168'
AND `afficher` = '1'
GROUP BY `id_categorie`
ORDER BY `ordre`, `nom`
|
| 0.0001 |
SELECT `c`.*
FROM `categories` `c`
WHERE `rid_rubrique` = '2'
AND `rid_categorie` = '173'
AND `afficher` = '1'
GROUP BY `id_categorie`
ORDER BY `ordre`, `nom`
|
| 0.0001 |
SELECT `c`.*
FROM `categories` `c`
WHERE `rid_rubrique` = '2'
AND `rid_categorie` = '180'
AND `afficher` = '1'
GROUP BY `id_categorie`
ORDER BY `ordre`, `nom`
|
| 0.0001 |
SELECT `c`.*
FROM `categories` `c`
WHERE `rid_rubrique` = '2'
AND `rid_categorie` = '194'
AND `afficher` = '1'
GROUP BY `id_categorie`
ORDER BY `ordre`, `nom`
|
| 0.0001 |
SELECT `c`.*
FROM `categories` `c`
WHERE `rid_rubrique` = '2'
AND `rid_categorie` = '206'
AND `afficher` = '1'
GROUP BY `id_categorie`
ORDER BY `ordre`, `nom`
|
| 0.0001 |
SELECT `c`.*
FROM `categories` `c`
WHERE `rid_rubrique` = '2'
AND `rid_categorie` = '212'
AND `afficher` = '1'
GROUP BY `id_categorie`
ORDER BY `ordre`, `nom`
|
| 0.0001 |
SELECT `c`.*
FROM `categories` `c`
WHERE `rid_rubrique` = '2'
AND `rid_categorie` = '231'
AND `afficher` = '1'
GROUP BY `id_categorie`
ORDER BY `ordre`, `nom`
|
| 0.0001 |
SELECT `c`.*
FROM `categories` `c`
WHERE `rid_rubrique` = '4'
AND `rid_categorie` = 0
AND `afficher` = '1'
GROUP BY `id_categorie`
ORDER BY `ordre`, `nom`
|
| 0.0001 |
SELECT `c`.*
FROM `categories` `c`
WHERE `rid_rubrique` = '4'
AND `rid_categorie` = '235'
AND `afficher` = '1'
GROUP BY `id_categorie`
ORDER BY `ordre`, `nom`
|
| 0.0001 |
SELECT `c`.*
FROM `categories` `c`
WHERE `rid_rubrique` = '4'
AND `rid_categorie` = '236'
AND `afficher` = '1'
GROUP BY `id_categorie`
ORDER BY `ordre`, `nom`
|
