Logs
info: infoinfo: info
SQL (0.099s)
0.001 : Connexion BDD sur localhost:gimel
0.000 : 2 : SELECT * FROM gimel.registry
0.001 : 1 : SELECT *
FROM gimel.negociants
WHERE neg_domaine_front = 'vfconfort.kyxar.fr' OR neg_domaine_back = 'vfconfort.kyxar.fr'
0.000 : 0 : USE gimel_vf_confort
0.001 : 1 : SELECT * FROM gimel.negociants WHERE neg_schema = 'vf_confort';
0.000 : 1 : SELECT DATABASE()
0.000 : 105 : SELECT * FROM registry
0.002 : 28 : SELECT *
FROM products_groups_details
INNER JOIN products_details ON (pde_idArt = pgd_idArt AND pde_idDep = '1')
WHERE pgd_id_groupe = (SELECT pgd_id_groupe FROM products_groups_details WHERE pgd_idArt = '154423' LIMIT 1)
AND pde_active = 1
ORDER BY pgd_ordre ASC
0.010 : 1 : SELECT p.*, pde.*, prixGlobal.*, prixClient.*, stock_cache.*,
ad.codAD, ad.noAD, ad.condVteAD, ad.desiAutoAD,ad.cvStoVteAD, ad.typCvStoVteAD,ad.flgDecondAD,ad.condVteAD,ad.nbUStoCondVteAD,ad.codSuspAD,ad.comtechAD,ad.codCatAD,
a.uStoArt, a.uVteArt,a.desiArt,a.desi2Art, a.idprArt,
prod_marque, COALESCE(stock_cache.pst_stock_disponible, s.stkDispo) as stock,
adfour.codADF,
count(w.wish_id_contact) as favoris,
SUBSTRING_INDEX(tva.valDLib,";",1) as pourcentage_tva,
( SELECT sum(evo_stock.stkDispo) FROM evo_stock INNER JOIN evo_article_detail ON (evo_article_detail.idAD = evo_stock.idAD) WHERE desiAutoAD = ad.desiAutoAD AND idSoc = ad.idSoc AND idDep != 0 AND idArt = ad.idArt) as stkTotal,
IFNULL(( SELECT sum(s2.stkDispo)
FROM products_groups_details pgd2
INNER JOIN evo_article_detail ad2 ON (ad2.idArt = pgd2.pgd_idArt)
INNER JOIN evo_stock s2 ON (ad2.idAD = s2.idAD)
WHERE pgd2.pgd_id_groupe = pgr.pgr_id ), s.stkDispo) as stock_decli,
pgr_name, pgr_id, pgr_marque, pgr_description,
(SELECT img_file FROM products_images WHERE (img_idArt = ad.idArt AND (img_idAD IS NULL OR img_idAD = '')) ORDER BY img_ordre, img_idAD DESC LIMIT 1) as img_fileArt,
(SELECT img_file FROM products_images WHERE (img_idAD = ad.idAD) ORDER BY img_ordre, img_idAD DESC LIMIT 1) as img_fileAD,
(SELECT img_file FROM products_images WHERE (img_id_group = pgr.pgr_id) AND pgr.pgr_id IS NOT NULL ORDER BY img_ordre, img_id_group DESC LIMIT 1) as img_fileGroup,
(SELECT img_file FROM products_groups_details INNER JOIN products_images ON (products_images.img_idArt = products_groups_details.pgd_idArt) WHERE pgd_id_groupe = pgr.pgr_id ORDER BY products_groups_details.pgd_ordre, img_ordre, img_id_group DESC LIMIT 1) as img_fileArtGroup
FROM products_details pde
INNER JOIN evo_article_detail ad ON (ad.idAD = pde_idAD)
INNER JOIN evo_article a ON (a.idArt = ad.idArt)
INNER JOIN products p ON (a.idArt = p.prod_idArt)
INNER JOIN evo_stock s ON (ad.idAD = s.idAD)
LEFT JOIN products_groups_details pgd ON (pgd.pgd_idArt = pde.pde_idArt)
LEFT JOIN products_groups pgr ON (pgr.pgr_id = pgd.pgd_id_groupe)
LEFT JOIN evo_prix prixGlobal ON (prixGlobal.idAD = pde.pde_idAD)
LEFT JOIN products_prices prixClient ON (prixClient.ppr_idAD = pde.pde_idAD AND prixClient.ppr_idCli = 0 AND ppr_idCha = 0 AND ppr_date_upd > DATE_SUB(NOW(), INTERVAL 60 MINUTE))
LEFT JOIN products_stock stock_cache ON (stock_cache.pst_idAD = pde.pde_idAD AND stock_cache.pst_date_upd > DATE_SUB(NOW(), INTERVAL 10 MINUTE))
LEFT JOIN evo_adfour adfour ON (pde_idAD = adfour.idAD AND adfour.dateDelete IS NULL)
LEFT JOIN evo_libelle as tva ON (tva.codLib = a.codTvaArt AND tva.famLib = 'CodTva' AND tva.datFinLib > NOW())
LEFT JOIN wishlists as w ON (w.wish_idAD = pde.pde_idAD AND wish_id_contact = '')
WHERE pde_idAd IN ('1235379')
GROUP BY pde_idAD
;
0.001 : 0 : SELECT f_id, f_champ,f_libelle,f_type_donnee,f_origine,f_section_front,f_id_feature_unite,pim_value,pim_id,po_couleur,
IF(pim_idAD, true, false) as donnee_ad
FROM pim p
INNER JOIN evo_article as a ON (pim_idArt = a.idArt)
INNER JOIN pim_features pf ON (p.pim_id_feature = pf.f_id AND pf.f_active = 1)
INNER JOIN pim_origines po ON (pf.f_origine = po.po_origine)
WHERE 1=1 AND (pim_idAD = '1235379' OR (pim_idArt = '154423' AND pim_idAD IS NULL))
ORDER BY donnee_ad DESC , po.po_ordre ASC, pf.f_ordre ASC
0.001 : 1 : SELECT *
FROM (
(
SELECT i.* , null as pgd_ordre, null as idArt
FROM products_groups g
INNER JOIN products_images i ON (g.pgr_id = i.img_id_group)
WHERE g.pgr_id = '1526'
)
UNION
(
SELECT i.*, gd.pgd_ordre, gd.pgd_idArt as idArt
FROM products_groups_details gd
INNER JOIN products_images i ON (gd.pgd_idArt = i.img_idArt)
WHERE pgd_id_groupe = '1526'
)
)
a
GROUP BY img_md5
ORDER BY img_id_group DESC,pgd_ordre,idArt,img_ordre
0.001 : 0 : SELECT *
FROM (
(
SELECT d.* ,pdt_libelle, null as pgd_ordre, null as idArt
FROM products_groups g
INNER JOIN products_documents d ON (g.pgr_id = d.doc_id_group)
INNER JOIN products_documents_type ON d.doc_type = products_documents_type.pdt_id
WHERE g.pgr_id = '1526'
)
UNION
(
SELECT d.*,pdt_libelle, gd.pgd_ordre, gd.pgd_idArt as idArt
FROM products_groups_details gd
INNER JOIN products_documents d ON (gd.pgd_idArt = d.doc_idArt)
INNER JOIN products_documents_type ON d.doc_type = products_documents_type.pdt_id
WHERE pgd_id_groupe = '1526'
)
)
a
GROUP BY doc_md5
ORDER BY doc_id_group DESC,pgd_ordre,idArt,doc_ordre
0.000 : 1 : SELECT codQRAD FROM evo_article_detail WHERE idArt = '154423' AND idAD = '1235379'
0.000 : 0 : SELECT * FROM marques WHERE mar_id = '';
0.001 : 1 : SELECT c.* FROM categories c
INNER JOIN categories_liaisons cl ON (cl.catl_cat_id = c.cat_id)
INNER JOIN evo_article_societe eac ON (eac.idIC = catl_idIC)
WHERE idArt = '154423' AND idSoc = '1'
ORDER BY cat_niveau DESC
0.000 : 1 : SELECT cat_nom FROM categories WHERE cat_id = '100'
0.000 : 1 : SELECT * FROM categories WHERE cat_id = '77';
0.000 : 1 : SELECT cat_nom FROM categories WHERE cat_id = '77'
0.000 : 1 : SELECT * FROM categories WHERE cat_id = '9';
0.000 : 1 : SELECT cat_nom FROM categories WHERE cat_id = '9'
0.028 : 28 : SELECT pde_idAD as idAD
FROM products_details
LEFT JOIN products_groups_details ON (products_details.pde_idArt = products_groups_details.pgd_idArt)
WHERE
(
(pgd_id_groupe = (SELECT pgd_id_groupe FROM products_groups_details pgd1 WHERE pgd_idArt = '154423' LIMIT 1))
OR
(pde_idArt = '154423' AND pgd_id_groupe IS NULL)
)
AND products_details.pde_idDep = '1' AND products_details.pde_active = 1
ORDER BY pgd_ordre;
0.011 : 28 : SELECT p.*, pde.*, prixGlobal.*, prixClient.*, stock_cache.*,
ad.codAD, ad.noAD, ad.condVteAD, ad.desiAutoAD,ad.cvStoVteAD, ad.typCvStoVteAD,ad.flgDecondAD,ad.condVteAD,ad.nbUStoCondVteAD,ad.codSuspAD,ad.comtechAD,ad.codCatAD,
a.uStoArt, a.uVteArt,a.desiArt,a.desi2Art, a.idprArt,
prod_marque, COALESCE(stock_cache.pst_stock_disponible, s.stkDispo) as stock,
adfour.codADF,
count(w.wish_id_contact) as favoris,
SUBSTRING_INDEX(tva.valDLib,";",1) as pourcentage_tva,
( SELECT sum(evo_stock.stkDispo) FROM evo_stock INNER JOIN evo_article_detail ON (evo_article_detail.idAD = evo_stock.idAD) WHERE desiAutoAD = ad.desiAutoAD AND idSoc = ad.idSoc AND idDep != 0 AND idArt = ad.idArt) as stkTotal,
IFNULL(( SELECT sum(s2.stkDispo)
FROM products_groups_details pgd2
INNER JOIN evo_article_detail ad2 ON (ad2.idArt = pgd2.pgd_idArt)
INNER JOIN evo_stock s2 ON (ad2.idAD = s2.idAD)
WHERE pgd2.pgd_id_groupe = pgr.pgr_id ), s.stkDispo) as stock_decli,
pgr_name, pgr_id, pgr_marque, pgr_description,
(SELECT img_file FROM products_images WHERE (img_idArt = ad.idArt AND (img_idAD IS NULL OR img_idAD = '')) ORDER BY img_ordre, img_idAD DESC LIMIT 1) as img_fileArt,
(SELECT img_file FROM products_images WHERE (img_idAD = ad.idAD) ORDER BY img_ordre, img_idAD DESC LIMIT 1) as img_fileAD,
(SELECT img_file FROM products_images WHERE (img_id_group = pgr.pgr_id) AND pgr.pgr_id IS NOT NULL ORDER BY img_ordre, img_id_group DESC LIMIT 1) as img_fileGroup,
(SELECT img_file FROM products_groups_details INNER JOIN products_images ON (products_images.img_idArt = products_groups_details.pgd_idArt) WHERE pgd_id_groupe = pgr.pgr_id ORDER BY products_groups_details.pgd_ordre, img_ordre, img_id_group DESC LIMIT 1) as img_fileArtGroup
FROM products_details pde
INNER JOIN evo_article_detail ad ON (ad.idAD = pde_idAD)
INNER JOIN evo_article a ON (a.idArt = ad.idArt)
INNER JOIN products p ON (a.idArt = p.prod_idArt)
INNER JOIN evo_stock s ON (ad.idAD = s.idAD)
LEFT JOIN products_groups_details pgd ON (pgd.pgd_idArt = pde.pde_idArt)
LEFT JOIN products_groups pgr ON (pgr.pgr_id = pgd.pgd_id_groupe)
LEFT JOIN evo_prix prixGlobal ON (prixGlobal.idAD = pde.pde_idAD)
LEFT JOIN products_prices prixClient ON (prixClient.ppr_idAD = pde.pde_idAD AND prixClient.ppr_idCli = 0 AND ppr_idCha = 0 AND ppr_date_upd > DATE_SUB(NOW(), INTERVAL 60 MINUTE))
LEFT JOIN products_stock stock_cache ON (stock_cache.pst_idAD = pde.pde_idAD AND stock_cache.pst_date_upd > DATE_SUB(NOW(), INTERVAL 10 MINUTE))
LEFT JOIN evo_adfour adfour ON (pde_idAD = adfour.idAD AND adfour.dateDelete IS NULL)
LEFT JOIN evo_libelle as tva ON (tva.codLib = a.codTvaArt AND tva.famLib = 'CodTva' AND tva.datFinLib > NOW())
LEFT JOIN wishlists as w ON (w.wish_idAD = pde.pde_idAD AND wish_id_contact = '')
WHERE pde_idAd IN ('1235379','1235395','1235859','1238195','1238275','1238355','1239491','1239507','1240547','1240579','1235395'0,'1235395'1,'1235395'2,'1235395'3,'1235395'4,'1235395'5,'1235395'6,'1235395'7,'1235395'8,'1235395'9,'1235859'0,'1235859'1,'1235859'2,'1235859'3,'1235859'4,'1235859'5,'1235859'6,'1235859'7)
GROUP BY pde_idAD
ORDER BY CASE pde_idAD WHEN 1235379 THEN 0 WHEN 1235395 THEN 1 WHEN 1235859 THEN 2 WHEN 1238195 THEN 3 WHEN 1238275 THEN 4 WHEN 1238355 THEN 5 WHEN 1239491 THEN 6 WHEN 1239507 THEN 7 WHEN 1240547 THEN 8 WHEN 1240579 THEN 9 WHEN 1240595 THEN 10 WHEN 1240611 THEN 11 WHEN 1240627 THEN 12 WHEN 1240659 THEN 13 WHEN 1240675 THEN 14 WHEN 1240691 THEN 15 WHEN 1240723 THEN 16 WHEN 1240739 THEN 17 WHEN 1240755 THEN 18 WHEN 1240771 THEN 19 WHEN 1240787 THEN 20 WHEN 1240819 THEN 21 WHEN 1240835 THEN 22 WHEN 1240851 THEN 23 WHEN 1240867 THEN 24 WHEN 1240899 THEN 25 WHEN 1240915 THEN 26 WHEN 1240931 THEN 27 END;
0.001 : 0 : SELECT f_id, f_champ,f_libelle,f_type_donnee,f_origine,f_section_front,f_id_feature_unite,pim_value,pim_id,po_couleur,
IF(pim_idAD, true, false) as donnee_ad
FROM pim p
INNER JOIN evo_article as a ON (pim_idArt = a.idArt)
INNER JOIN pim_features pf ON (p.pim_id_feature = pf.f_id AND pf.f_active = 1)
INNER JOIN pim_origines po ON (pf.f_origine = po.po_origine)
WHERE 1=1 AND (pim_idAD = '1235379' OR (pim_idArt = '154423' AND pim_idAD IS NULL))
ORDER BY donnee_ad DESC , po.po_ordre ASC, pf.f_ordre ASC
0.001 : 0 : SELECT f_id, f_champ,f_libelle,f_type_donnee,f_origine,f_section_front,f_id_feature_unite,pim_value,pim_id,po_couleur,
IF(pim_idAD, true, false) as donnee_ad
FROM pim p
INNER JOIN evo_article as a ON (pim_idArt = a.idArt)
INNER JOIN pim_features pf ON (p.pim_id_feature = pf.f_id AND pf.f_active = 1)
INNER JOIN pim_origines po ON (pf.f_origine = po.po_origine)
WHERE 1=1 AND (pim_idAD = '1235395' OR (pim_idArt = '154425' AND pim_idAD IS NULL))
ORDER BY donnee_ad DESC , po.po_ordre ASC, pf.f_ordre ASC
0.001 : 0 : SELECT f_id, f_champ,f_libelle,f_type_donnee,f_origine,f_section_front,f_id_feature_unite,pim_value,pim_id,po_couleur,
IF(pim_idAD, true, false) as donnee_ad
FROM pim p
INNER JOIN evo_article as a ON (pim_idArt = a.idArt)
INNER JOIN pim_features pf ON (p.pim_id_feature = pf.f_id AND pf.f_active = 1)
INNER JOIN pim_origines po ON (pf.f_origine = po.po_origine)
WHERE 1=1 AND (pim_idAD = '1235859' OR (pim_idArt = '154483' AND pim_idAD IS NULL))
ORDER BY donnee_ad DESC , po.po_ordre ASC, pf.f_ordre ASC
0.000 : 0 : SELECT f_id, f_champ,f_libelle,f_type_donnee,f_origine,f_section_front,f_id_feature_unite,pim_value,pim_id,po_couleur,
IF(pim_idAD, true, false) as donnee_ad
FROM pim p
INNER JOIN evo_article as a ON (pim_idArt = a.idArt)
INNER JOIN pim_features pf ON (p.pim_id_feature = pf.f_id AND pf.f_active = 1)
INNER JOIN pim_origines po ON (pf.f_origine = po.po_origine)
WHERE 1=1 AND (pim_idAD = '1238195' OR (pim_idArt = '154775' AND pim_idAD IS NULL))
ORDER BY donnee_ad DESC , po.po_ordre ASC, pf.f_ordre ASC
0.000 : 0 : SELECT f_id, f_champ,f_libelle,f_type_donnee,f_origine,f_section_front,f_id_feature_unite,pim_value,pim_id,po_couleur,
IF(pim_idAD, true, false) as donnee_ad
FROM pim p
INNER JOIN evo_article as a ON (pim_idArt = a.idArt)
INNER JOIN pim_features pf ON (p.pim_id_feature = pf.f_id AND pf.f_active = 1)
INNER JOIN pim_origines po ON (pf.f_origine = po.po_origine)
WHERE 1=1 AND (pim_idAD = '1238275' OR (pim_idArt = '154785' AND pim_idAD IS NULL))
ORDER BY donnee_ad DESC , po.po_ordre ASC, pf.f_ordre ASC
0.000 : 0 : SELECT f_id, f_champ,f_libelle,f_type_donnee,f_origine,f_section_front,f_id_feature_unite,pim_value,pim_id,po_couleur,
IF(pim_idAD, true, false) as donnee_ad
FROM pim p
INNER JOIN evo_article as a ON (pim_idArt = a.idArt)
INNER JOIN pim_features pf ON (p.pim_id_feature = pf.f_id AND pf.f_active = 1)
INNER JOIN pim_origines po ON (pf.f_origine = po.po_origine)
WHERE 1=1 AND (pim_idAD = '1238355' OR (pim_idArt = '154795' AND pim_idAD IS NULL))
ORDER BY donnee_ad DESC , po.po_ordre ASC, pf.f_ordre ASC
0.000 : 0 : SELECT f_id, f_champ,f_libelle,f_type_donnee,f_origine,f_section_front,f_id_feature_unite,pim_value,pim_id,po_couleur,
IF(pim_idAD, true, false) as donnee_ad
FROM pim p
INNER JOIN evo_article as a ON (pim_idArt = a.idArt)
INNER JOIN pim_features pf ON (p.pim_id_feature = pf.f_id AND pf.f_active = 1)
INNER JOIN pim_origines po ON (pf.f_origine = po.po_origine)
WHERE 1=1 AND (pim_idAD = '1239491' OR (pim_idArt = '154937' AND pim_idAD IS NULL))
ORDER BY donnee_ad DESC , po.po_ordre ASC, pf.f_ordre ASC
0.000 : 0 : SELECT f_id, f_champ,f_libelle,f_type_donnee,f_origine,f_section_front,f_id_feature_unite,pim_value,pim_id,po_couleur,
IF(pim_idAD, true, false) as donnee_ad
FROM pim p
INNER JOIN evo_article as a ON (pim_idArt = a.idArt)
INNER JOIN pim_features pf ON (p.pim_id_feature = pf.f_id AND pf.f_active = 1)
INNER JOIN pim_origines po ON (pf.f_origine = po.po_origine)
WHERE 1=1 AND (pim_idAD = '1239507' OR (pim_idArt = '154939' AND pim_idAD IS NULL))
ORDER BY donnee_ad DESC , po.po_ordre ASC, pf.f_ordre ASC
0.000 : 0 : SELECT f_id, f_champ,f_libelle,f_type_donnee,f_origine,f_section_front,f_id_feature_unite,pim_value,pim_id,po_couleur,
IF(pim_idAD, true, false) as donnee_ad
FROM pim p
INNER JOIN evo_article as a ON (pim_idArt = a.idArt)
INNER JOIN pim_features pf ON (p.pim_id_feature = pf.f_id AND pf.f_active = 1)
INNER JOIN pim_origines po ON (pf.f_origine = po.po_origine)
WHERE 1=1 AND (pim_idAD = '1240547' OR (pim_idArt = '155069' AND pim_idAD IS NULL))
ORDER BY donnee_ad DESC , po.po_ordre ASC, pf.f_ordre ASC
0.000 : 0 : SELECT f_id, f_champ,f_libelle,f_type_donnee,f_origine,f_section_front,f_id_feature_unite,pim_value,pim_id,po_couleur,
IF(pim_idAD, true, false) as donnee_ad
FROM pim p
INNER JOIN evo_article as a ON (pim_idArt = a.idArt)
INNER JOIN pim_features pf ON (p.pim_id_feature = pf.f_id AND pf.f_active = 1)
INNER JOIN pim_origines po ON (pf.f_origine = po.po_origine)
WHERE 1=1 AND (pim_idAD = '1240579' OR (pim_idArt = '155073' AND pim_idAD IS NULL))
ORDER BY donnee_ad DESC , po.po_ordre ASC, pf.f_ordre ASC
0.000 : 0 : SELECT f_id, f_champ,f_libelle,f_type_donnee,f_origine,f_section_front,f_id_feature_unite,pim_value,pim_id,po_couleur,
IF(pim_idAD, true, false) as donnee_ad
FROM pim p
INNER JOIN evo_article as a ON (pim_idArt = a.idArt)
INNER JOIN pim_features pf ON (p.pim_id_feature = pf.f_id AND pf.f_active = 1)
INNER JOIN pim_origines po ON (pf.f_origine = po.po_origine)
WHERE 1=1 AND (pim_idAD = '1240595' OR (pim_idArt = '155075' AND pim_idAD IS NULL))
ORDER BY donnee_ad DESC , po.po_ordre ASC, pf.f_ordre ASC
0.000 : 0 : SELECT f_id, f_champ,f_libelle,f_type_donnee,f_origine,f_section_front,f_id_feature_unite,pim_value,pim_id,po_couleur,
IF(pim_idAD, true, false) as donnee_ad
FROM pim p
INNER JOIN evo_article as a ON (pim_idArt = a.idArt)
INNER JOIN pim_features pf ON (p.pim_id_feature = pf.f_id AND pf.f_active = 1)
INNER JOIN pim_origines po ON (pf.f_origine = po.po_origine)
WHERE 1=1 AND (pim_idAD = '1240611' OR (pim_idArt = '155077' AND pim_idAD IS NULL))
ORDER BY donnee_ad DESC , po.po_ordre ASC, pf.f_ordre ASC
0.000 : 0 : SELECT f_id, f_champ,f_libelle,f_type_donnee,f_origine,f_section_front,f_id_feature_unite,pim_value,pim_id,po_couleur,
IF(pim_idAD, true, false) as donnee_ad
FROM pim p
INNER JOIN evo_article as a ON (pim_idArt = a.idArt)
INNER JOIN pim_features pf ON (p.pim_id_feature = pf.f_id AND pf.f_active = 1)
INNER JOIN pim_origines po ON (pf.f_origine = po.po_origine)
WHERE 1=1 AND (pim_idAD = '1240627' OR (pim_idArt = '155079' AND pim_idAD IS NULL))
ORDER BY donnee_ad DESC , po.po_ordre ASC, pf.f_ordre ASC
0.000 : 0 : SELECT f_id, f_champ,f_libelle,f_type_donnee,f_origine,f_section_front,f_id_feature_unite,pim_value,pim_id,po_couleur,
IF(pim_idAD, true, false) as donnee_ad
FROM pim p
INNER JOIN evo_article as a ON (pim_idArt = a.idArt)
INNER JOIN pim_features pf ON (p.pim_id_feature = pf.f_id AND pf.f_active = 1)
INNER JOIN pim_origines po ON (pf.f_origine = po.po_origine)
WHERE 1=1 AND (pim_idAD = '1240659' OR (pim_idArt = '155083' AND pim_idAD IS NULL))
ORDER BY donnee_ad DESC , po.po_ordre ASC, pf.f_ordre ASC
0.000 : 0 : SELECT f_id, f_champ,f_libelle,f_type_donnee,f_origine,f_section_front,f_id_feature_unite,pim_value,pim_id,po_couleur,
IF(pim_idAD, true, false) as donnee_ad
FROM pim p
INNER JOIN evo_article as a ON (pim_idArt = a.idArt)
INNER JOIN pim_features pf ON (p.pim_id_feature = pf.f_id AND pf.f_active = 1)
INNER JOIN pim_origines po ON (pf.f_origine = po.po_origine)
WHERE 1=1 AND (pim_idAD = '1240675' OR (pim_idArt = '155085' AND pim_idAD IS NULL))
ORDER BY donnee_ad DESC , po.po_ordre ASC, pf.f_ordre ASC
0.000 : 0 : SELECT f_id, f_champ,f_libelle,f_type_donnee,f_origine,f_section_front,f_id_feature_unite,pim_value,pim_id,po_couleur,
IF(pim_idAD, true, false) as donnee_ad
FROM pim p
INNER JOIN evo_article as a ON (pim_idArt = a.idArt)
INNER JOIN pim_features pf ON (p.pim_id_feature = pf.f_id AND pf.f_active = 1)
INNER JOIN pim_origines po ON (pf.f_origine = po.po_origine)
WHERE 1=1 AND (pim_idAD = '1240691' OR (pim_idArt = '155087' AND pim_idAD IS NULL))
ORDER BY donnee_ad DESC , po.po_ordre ASC, pf.f_ordre ASC
0.000 : 0 : SELECT f_id, f_champ,f_libelle,f_type_donnee,f_origine,f_section_front,f_id_feature_unite,pim_value,pim_id,po_couleur,
IF(pim_idAD, true, false) as donnee_ad
FROM pim p
INNER JOIN evo_article as a ON (pim_idArt = a.idArt)
INNER JOIN pim_features pf ON (p.pim_id_feature = pf.f_id AND pf.f_active = 1)
INNER JOIN pim_origines po ON (pf.f_origine = po.po_origine)
WHERE 1=1 AND (pim_idAD = '1240723' OR (pim_idArt = '155091' AND pim_idAD IS NULL))
ORDER BY donnee_ad DESC , po.po_ordre ASC, pf.f_ordre ASC
0.000 : 0 : SELECT f_id, f_champ,f_libelle,f_type_donnee,f_origine,f_section_front,f_id_feature_unite,pim_value,pim_id,po_couleur,
IF(pim_idAD, true, false) as donnee_ad
FROM pim p
INNER JOIN evo_article as a ON (pim_idArt = a.idArt)
INNER JOIN pim_features pf ON (p.pim_id_feature = pf.f_id AND pf.f_active = 1)
INNER JOIN pim_origines po ON (pf.f_origine = po.po_origine)
WHERE 1=1 AND (pim_idAD = '1240739' OR (pim_idArt = '155093' AND pim_idAD IS NULL))
ORDER BY donnee_ad DESC , po.po_ordre ASC, pf.f_ordre ASC
0.000 : 0 : SELECT f_id, f_champ,f_libelle,f_type_donnee,f_origine,f_section_front,f_id_feature_unite,pim_value,pim_id,po_couleur,
IF(pim_idAD, true, false) as donnee_ad
FROM pim p
INNER JOIN evo_article as a ON (pim_idArt = a.idArt)
INNER JOIN pim_features pf ON (p.pim_id_feature = pf.f_id AND pf.f_active = 1)
INNER JOIN pim_origines po ON (pf.f_origine = po.po_origine)
WHERE 1=1 AND (pim_idAD = '1240755' OR (pim_idArt = '155095' AND pim_idAD IS NULL))
ORDER BY donnee_ad DESC , po.po_ordre ASC, pf.f_ordre ASC
0.000 : 0 : SELECT f_id, f_champ,f_libelle,f_type_donnee,f_origine,f_section_front,f_id_feature_unite,pim_value,pim_id,po_couleur,
IF(pim_idAD, true, false) as donnee_ad
FROM pim p
INNER JOIN evo_article as a ON (pim_idArt = a.idArt)
INNER JOIN pim_features pf ON (p.pim_id_feature = pf.f_id AND pf.f_active = 1)
INNER JOIN pim_origines po ON (pf.f_origine = po.po_origine)
WHERE 1=1 AND (pim_idAD = '1240771' OR (pim_idArt = '155097' AND pim_idAD IS NULL))
ORDER BY donnee_ad DESC , po.po_ordre ASC, pf.f_ordre ASC
0.000 : 0 : SELECT f_id, f_champ,f_libelle,f_type_donnee,f_origine,f_section_front,f_id_feature_unite,pim_value,pim_id,po_couleur,
IF(pim_idAD, true, false) as donnee_ad
FROM pim p
INNER JOIN evo_article as a ON (pim_idArt = a.idArt)
INNER JOIN pim_features pf ON (p.pim_id_feature = pf.f_id AND pf.f_active = 1)
INNER JOIN pim_origines po ON (pf.f_origine = po.po_origine)
WHERE 1=1 AND (pim_idAD = '1240787' OR (pim_idArt = '155099' AND pim_idAD IS NULL))
ORDER BY donnee_ad DESC , po.po_ordre ASC, pf.f_ordre ASC
0.000 : 0 : SELECT f_id, f_champ,f_libelle,f_type_donnee,f_origine,f_section_front,f_id_feature_unite,pim_value,pim_id,po_couleur,
IF(pim_idAD, true, false) as donnee_ad
FROM pim p
INNER JOIN evo_article as a ON (pim_idArt = a.idArt)
INNER JOIN pim_features pf ON (p.pim_id_feature = pf.f_id AND pf.f_active = 1)
INNER JOIN pim_origines po ON (pf.f_origine = po.po_origine)
WHERE 1=1 AND (pim_idAD = '1240819' OR (pim_idArt = '155103' AND pim_idAD IS NULL))
ORDER BY donnee_ad DESC , po.po_ordre ASC, pf.f_ordre ASC
0.000 : 0 : SELECT f_id, f_champ,f_libelle,f_type_donnee,f_origine,f_section_front,f_id_feature_unite,pim_value,pim_id,po_couleur,
IF(pim_idAD, true, false) as donnee_ad
FROM pim p
INNER JOIN evo_article as a ON (pim_idArt = a.idArt)
INNER JOIN pim_features pf ON (p.pim_id_feature = pf.f_id AND pf.f_active = 1)
INNER JOIN pim_origines po ON (pf.f_origine = po.po_origine)
WHERE 1=1 AND (pim_idAD = '1240835' OR (pim_idArt = '155105' AND pim_idAD IS NULL))
ORDER BY donnee_ad DESC , po.po_ordre ASC, pf.f_ordre ASC
0.000 : 0 : SELECT f_id, f_champ,f_libelle,f_type_donnee,f_origine,f_section_front,f_id_feature_unite,pim_value,pim_id,po_couleur,
IF(pim_idAD, true, false) as donnee_ad
FROM pim p
INNER JOIN evo_article as a ON (pim_idArt = a.idArt)
INNER JOIN pim_features pf ON (p.pim_id_feature = pf.f_id AND pf.f_active = 1)
INNER JOIN pim_origines po ON (pf.f_origine = po.po_origine)
WHERE 1=1 AND (pim_idAD = '1240851' OR (pim_idArt = '155107' AND pim_idAD IS NULL))
ORDER BY donnee_ad DESC , po.po_ordre ASC, pf.f_ordre ASC
0.000 : 0 : SELECT f_id, f_champ,f_libelle,f_type_donnee,f_origine,f_section_front,f_id_feature_unite,pim_value,pim_id,po_couleur,
IF(pim_idAD, true, false) as donnee_ad
FROM pim p
INNER JOIN evo_article as a ON (pim_idArt = a.idArt)
INNER JOIN pim_features pf ON (p.pim_id_feature = pf.f_id AND pf.f_active = 1)
INNER JOIN pim_origines po ON (pf.f_origine = po.po_origine)
WHERE 1=1 AND (pim_idAD = '1240867' OR (pim_idArt = '155109' AND pim_idAD IS NULL))
ORDER BY donnee_ad DESC , po.po_ordre ASC, pf.f_ordre ASC
0.000 : 0 : SELECT f_id, f_champ,f_libelle,f_type_donnee,f_origine,f_section_front,f_id_feature_unite,pim_value,pim_id,po_couleur,
IF(pim_idAD, true, false) as donnee_ad
FROM pim p
INNER JOIN evo_article as a ON (pim_idArt = a.idArt)
INNER JOIN pim_features pf ON (p.pim_id_feature = pf.f_id AND pf.f_active = 1)
INNER JOIN pim_origines po ON (pf.f_origine = po.po_origine)
WHERE 1=1 AND (pim_idAD = '1240899' OR (pim_idArt = '155113' AND pim_idAD IS NULL))
ORDER BY donnee_ad DESC , po.po_ordre ASC, pf.f_ordre ASC
0.000 : 0 : SELECT f_id, f_champ,f_libelle,f_type_donnee,f_origine,f_section_front,f_id_feature_unite,pim_value,pim_id,po_couleur,
IF(pim_idAD, true, false) as donnee_ad
FROM pim p
INNER JOIN evo_article as a ON (pim_idArt = a.idArt)
INNER JOIN pim_features pf ON (p.pim_id_feature = pf.f_id AND pf.f_active = 1)
INNER JOIN pim_origines po ON (pf.f_origine = po.po_origine)
WHERE 1=1 AND (pim_idAD = '1240915' OR (pim_idArt = '155115' AND pim_idAD IS NULL))
ORDER BY donnee_ad DESC , po.po_ordre ASC, pf.f_ordre ASC
0.000 : 0 : SELECT f_id, f_champ,f_libelle,f_type_donnee,f_origine,f_section_front,f_id_feature_unite,pim_value,pim_id,po_couleur,
IF(pim_idAD, true, false) as donnee_ad
FROM pim p
INNER JOIN evo_article as a ON (pim_idArt = a.idArt)
INNER JOIN pim_features pf ON (p.pim_id_feature = pf.f_id AND pf.f_active = 1)
INNER JOIN pim_origines po ON (pf.f_origine = po.po_origine)
WHERE 1=1 AND (pim_idAD = '1240931' OR (pim_idArt = '155117' AND pim_idAD IS NULL))
ORDER BY donnee_ad DESC , po.po_ordre ASC, pf.f_ordre ASC
0.001 : 0 : SELECT pde_idAD
FROM evo_complete c
INNER JOIN products_details ON (products_details.pde_idDep = '1' AND pde_idArt = idArtCpl)
INNER JOIN evo_article ON (evo_article.idArt = c.idArtCpl AND flgConsArt != 1)
LEFT JOIN products_groups_details pgd ON (pgd.pgd_idArt = idArtCpl)
WHERE c.idArt IN ('154423','154425','154483','154775','154785','154795','154937','154939','155069','155073','154425'0,'154425'1,'154425'2,'154425'3,'154425'4,'154425'5,'154425'6,'154425'7,'154425'8,'154425'9,'154483'0,'154483'1,'154483'2,'154483'3,'154483'4,'154483'5,'154483'6,'154483'7) AND pde_active = 1 AND (pgd_idArt IS NULL OR (pgd.pgd_ordre,pgd.pgd_id_groupe) in (
SELECT MIN(pgd2.pgd_ordre), pgd2.pgd_id_groupe
FROM evo_complete c2
INNER JOIN products_details pd2 ON (pd2.pde_idDep = '1' AND pd2.pde_idArt = c2.idArtCpl)
INNER JOIN evo_article ea2 ON (ea2.idArt = c2.idArtCpl AND ea2.flgConsArt != 1)
LEFT JOIN products_groups_details pgd2 ON (pgd2.pgd_idArt = c2.idArtCpl)
WHERE c2.idArt IN ('154423','154425','154483','154775','154785','154795','154937','154939','155069','155073','154425'0,'154425'1,'154425'2,'154425'3,'154425'4,'154425'5,'154425'6,'154425'7,'154425'8,'154425'9,'154483'0,'154483'1,'154483'2,'154483'3,'154483'4,'154483'5,'154483'6,'154483'7) AND pd2.pde_active = 1
GROUP BY pgd2.pgd_id_groupe
))
0.000 : 1 : SELECT FOUND_ROWS() as nb
0.001 : 355 : SELECT * FROM i18n WHERE lang='fr'
0.001 : 0 : SELECT pde_idAD
FROM evo_remplace
INNER JOIN products_details ON (evo_remplace.idArtRemp = pde_idArt)
LEFT JOIN products_groups_details pgd ON (pgd.pgd_idArt = idArtRemp)
WHERE idArt IN ('154423','154425','154483','154775','154785','154795','154937','154939','155069','155073','154425'0,'154425'1,'154425'2,'154425'3,'154425'4,'154425'5,'154425'6,'154425'7,'154425'8,'154425'9,'154483'0,'154483'1,'154483'2,'154483'3,'154483'4,'154483'5,'154483'6,'154483'7) AND pde_idDep = '1' AND pde_active = 1 AND (pgd_idArt IS NULL OR (pgd.pgd_ordre,pgd.pgd_id_groupe) in (
SELECT MIN(pgd2.pgd_ordre), pgd2.pgd_id_groupe
FROM evo_remplace r2
INNER JOIN products_details pd2 ON (r2.idArtRemp = pd2.pde_idArt)
LEFT JOIN products_groups_details pgd2 ON (pgd2.pgd_idArt = r2.idArtRemp)
WHERE r2.idArt IN ('154423','154425','154483','154775','154785','154795','154937','154939','155069','155073','154425'0,'154425'1,'154425'2,'154425'3,'154425'4,'154425'5,'154425'6,'154425'7,'154425'8,'154425'9,'154483'0,'154483'1,'154483'2,'154483'3,'154483'4,'154483'5,'154483'6,'154483'7) AND pd2.pde_idDep = '1' AND pd2.pde_active = 1
))
GROUP BY pde_idAD
0.000 : 1 : SELECT FOUND_ROWS() as nb
0.000 : 1 : SELECT * FROM sliders WHERE sli_code='imglogin'
0.001 : 1 : SELECT * FROM sliders_images LEFT JOIN sliders_images_lang ON (lsli_img_id = sli_img_id AND lang = 'fr') WHERE sli_id='5' AND sli_img_active=1 ORDER BY sli_img_ordre ASC
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='14'
0.022 : 0 : SELECT SUBSTRING_INDEX(tva.valDLib,";",1) as pourcentage_tva
FROM evo_param p
INNER JOIN evo_param_famille pf ON (pf.idFP = p.IdFP AND pf.codFP = 'ImportCC_GimelXML2')
INNER JOIN evo_param_valeur pv ON (p.idP = pv.idP)
INNER JOIN evo_article a ON (pv.valVP = a.noArt)
INNER JOIN evo_libelle as tva ON (tva.codLib = a.codTvaArt AND tva.famLib = 'CodTva' AND tva.datFinLib > NOW())
WHERE p.CodP = 'NoArtRemise';
0.000 : 3 : SELECT * FROM tracking_analytics WHERE trk_actif = 1
0.000 : 0 : SELECT *, pop_titre as titre, pop_contenu as contenu
FROM popin p
WHERE pop_type = 'push' AND (pop_type_page = 'Product' OR pop_all_pages = 1)
AND pop_actif = 1 AND (DATE(NOW()) BETWEEN pop_date_debut AND pop_date_fin)
ORDER BY pop_date_creation DESC
LIMIT 1
0.001 : 10 : SELECT md.id_menu_detail ,md.id_parent ,md.url_type, md.url_data, mdl.lnom_rubrique, md.nom_rubrique, md.class, md.onclick, md.target, md.icone, m.name
FROM menus m
LEFT JOIN menus_details md ON (md.id_menu = m.id_menu)
LEFT JOIN menus_details_lang mdl ON (mdl.lid_menu_detail=md.id_menu_detail AND mdl.lang='fr')
WHERE m.code = 'navigation'
AND md.actif = 1
ORDER BY ordre_rubrique ASC
0.000 : 16 : SELECT * FROM cms
0.001 : 12 : SELECT md.id_menu_detail ,md.id_parent ,md.url_type, md.url_data, mdl.lnom_rubrique, md.nom_rubrique, md.class, md.onclick, md.target, md.icone, m.name
FROM menus m
LEFT JOIN menus_details md ON (md.id_menu = m.id_menu)
LEFT JOIN menus_details_lang mdl ON (mdl.lid_menu_detail=md.id_menu_detail AND mdl.lang='fr')
WHERE m.code = 'footer_nav'
AND md.actif = 1
ORDER BY ordre_rubrique ASC
0.000 : 5 : SELECT md.id_menu_detail ,md.id_parent ,md.url_type, md.url_data, mdl.lnom_rubrique, md.nom_rubrique, md.class, md.onclick, md.target, md.icone, m.name
FROM menus m
LEFT JOIN menus_details md ON (md.id_menu = m.id_menu)
LEFT JOIN menus_details_lang mdl ON (mdl.lid_menu_detail=md.id_menu_detail AND mdl.lang='fr')
WHERE m.code = 'footer_nav_compte'
AND md.actif = 1
ORDER BY ordre_rubrique ASC
0.000 : 4 : SELECT md.id_menu_detail ,md.id_parent ,md.url_type, md.url_data, mdl.lnom_rubrique, md.nom_rubrique, md.class, md.onclick, md.target, md.icone, m.name
FROM menus m
LEFT JOIN menus_details md ON (md.id_menu = m.id_menu)
LEFT JOIN menus_details_lang mdl ON (mdl.lid_menu_detail=md.id_menu_detail AND mdl.lang='fr')
WHERE m.code = 'footer_nav_legal'
AND md.actif = 1
ORDER BY ordre_rubrique ASC
0.000 : 10 : SELECT *
FROM evo_depot d
LEFT JOIN depots ON (depots.dep_idDep = d.idDep)
LEFT JOIN depots_drive_config ddc ON (ddc.ddc_idDep = d.idDep)
WHERE flgActifDep = 1 AND dep_used = 1
ORDER BY nomDep;
0.000 : 4 : SELECT ras_texte, ras_icone FROM rassurance ORDER BY ras_tri ASC;
0.001 : 8 : SELECT *
FROM rgpd_cookies
LEFT JOIN rgpd_cookies_lang lrgpdc ON (rgpdc_code = lrgpdc.lrgpdc_code AND lrgpdc.lang = 'fr')
LEFT JOIN rgpd_cookies_details ON (rgpdc_code = rcd_lrgpdc_code)
LEFT JOIN rgpd_cookies_details_lang lrcd ON (rcd_id = lrcd.lrcd_id AND lrcd.lang = 'fr')
WHERE rgpdc_active = 1
ORDER BY rgpdc_code ASC
0.000 : 1 : SELECT *
FROM rgpd_cookies_parametres
LEFT JOIN rgpd_cookies_parametres_lang ON (lrcp_id = rcp_id AND lang = 'fr')
0.001 : 510 : SELECT cat_id,cat_id_parent,cat_niveau,cat_nom,cat_enfants FROM categories ORDER BY cat_ordre ASC
0.001 : 0 : SELECT *,
(cbr_date_limite is null OR now() < cbr_date_limite) as date_limite_ok
FROM contacts_bons_reductions
WHERE cbr_auto_utilisation = 1
LIMIT 1
0.000 : 0 : SELECT nec_valeur
FROM gimel.negociants_config
WHERE nec_module = 'listesAchats'
AND nec_parametre = 'actif'
AND nec_id_negociant = '46'
