Logs
info: infoinfo: info
SQL (0.082s)
0.000 : Connexion BDD sur localhost:gimel
0.000 : 2 : SELECT * FROM gimel.registry
0.000 : 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.000 : 1 : SELECT * FROM gimel.negociants WHERE neg_schema = 'vf_confort';
0.000 : 1 : SELECT DATABASE()
0.000 : 105 : SELECT * FROM registry
0.001 : 5 : 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 = '34561' LIMIT 1)
AND pde_active = 1
ORDER BY pgd_ordre ASC
0.009 : 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 ('276483')
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 = '276483' OR (pim_idArt = '34561' AND pim_idAD IS NULL))
ORDER BY donnee_ad DESC , po.po_ordre ASC, pf.f_ordre ASC
0.000 : 7 : 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 = '59'
)
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 = '59'
)
)
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 = '59'
)
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 = '59'
)
)
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 = '34561' AND idAD = '276483'
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 = '34561' AND idSoc = '1'
ORDER BY cat_niveau DESC
0.000 : 1 : SELECT cat_nom FROM categories WHERE cat_id = '240'
0.000 : 1 : SELECT * FROM categories WHERE cat_id = '236';
0.000 : 1 : SELECT cat_nom FROM categories WHERE cat_id = '236'
0.000 : 1 : SELECT * FROM categories WHERE cat_id = '11';
0.000 : 1 : SELECT cat_nom FROM categories WHERE cat_id = '11'
0.036 : 5 : 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 = '34561' LIMIT 1))
OR
(pde_idArt = '34561' AND pgd_id_groupe IS NULL)
)
AND products_details.pde_idDep = '1' AND products_details.pde_active = 1
ORDER BY pgd_ordre;
0.004 : 5 : 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 ('276483','276499','276515','276531','276547')
GROUP BY pde_idAD
ORDER BY CASE pde_idAD WHEN 276483 THEN 0 WHEN 276499 THEN 1 WHEN 276515 THEN 2 WHEN 276531 THEN 3 WHEN 276547 THEN 4 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 = '276483' OR (pim_idArt = '34561' 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 = '276499' OR (pim_idArt = '34563' 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 = '276515' OR (pim_idArt = '34565' 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 = '276531' OR (pim_idArt = '34567' 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 = '276547' OR (pim_idArt = '34569' AND pim_idAD IS NULL))
ORDER BY donnee_ad DESC , po.po_ordre ASC, pf.f_ordre ASC
0.000 : 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 ('34561','34563','34565','34567','34569') 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 ('34561','34563','34565','34567','34569') 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.000 : 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 ('34561','34563','34565','34567','34569') 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 ('34561','34563','34565','34567','34569') 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.020 : 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.001 : 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.000 : 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'
