Logs
info: infoinfo: info
SQL (0.077s)
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 = 'novamat.kyxar.fr' OR neg_domaine_back = 'novamat.kyxar.fr'
0.000 : 0 : USE gimel_novamat
0.001 : 1 : SELECT * FROM gimel.negociants WHERE neg_schema = 'novamat';
0.000 : 1 : SELECT DATABASE()
0.000 : 84 : SELECT * FROM registry
0.001 : 1 : SELECT pde_idAD FROM products_details WHERE pde_idArt = '125572' AND pde_idDep = '2';
0.005 : 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 evo_article_detail ad2
INNER JOIN evo_stock s2 ON (ad2.idAD = s2.idAD)
WHERE ad2.idArt = p.prod_idArt
), 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,
GROUP_CONCAT(catp_libelle ORDER BY catp_id) as cat_perso_libelles,
GROUP_CONCAT(catp_couleur ORDER BY catp_id) as cat_perso_couleurs,
GROUP_CONCAT(catp_forcer_connexion ORDER BY catp_id) as cat_perso_forcer_connexion,
GROUP_CONCAT(catp_produits_exclusif ORDER BY catp_id) as cat_perso_produits_exclusif,
GROUP_CONCAT(catp_a_gestion_stock ORDER BY catp_id) as cat_perso_a_gestion_stock,
GROUP_CONCAT(catp_type_client ORDER BY catp_id, '| ') as cat_perso_type_client,
GROUP_CONCAT(catp_is_label ORDER BY catp_id) as cat_perso_is_label
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 = '')
LEFT JOIN catalogues_personnalises_produits ON (catpp_prod_idArt = a.idArt)
LEFT JOIN catalogues_personnalises ON (catp_id = catpp_catp_id AND catp_actif = 1)
WHERE pde_idAd IN ('349809')
GROUP BY pde_idAD
;
0.002 : 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 = '349809' OR (pim_idArt = '125572' AND pim_idAD IS NULL))
ORDER BY donnee_ad DESC , po.po_ordre ASC, pf.f_ordre ASC
0.001 : 0 : SELECT img_id, img_file, img_origin, img_idArt, img_idAD
FROM products_images
WHERE (img_idArt = '125572' AND (img_idAD IS NULL OR img_idAD = '')) OR (img_idAD = '349809')
GROUP BY img_md5
ORDER BY img_ordre
0.002 : 0 : SELECT doc_id, doc_file, doc_date_add, doc_type, doc_idArt, doc_idAD, pdt_libelle, doc_original_file
FROM products_documents
INNER JOIN products_documents_type ON products_documents.doc_type = products_documents_type.pdt_id
WHERE (doc_idArt = '125572' AND (doc_idAD IS NULL OR doc_idAD = '')) OR (doc_idAD = '349809')
GROUP BY doc_md5
ORDER BY products_documents_type.pdt_ordre ASC, doc_ordre ASC
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 = '125572' AND idSoc = '1'
ORDER BY cat_niveau DESC
0.000 : 1 : SELECT cat_nom FROM categories WHERE cat_id = '168'
0.000 : 1 : SELECT * FROM categories WHERE cat_id = '160';
0.000 : 1 : SELECT cat_nom FROM categories WHERE cat_id = '160'
0.000 : 1 : SELECT * FROM categories WHERE cat_id = '148';
0.000 : 1 : SELECT cat_nom FROM categories WHERE cat_id = '148'
0.000 : 1 : SELECT idAD,desiAutoAD , pde_active
FROM evo_article_detail
INNER JOIN products_details ON (pde_idAD = evo_article_detail.idAD)
WHERE idArt = '125572' AND idDep = '2' AND pde_active = 1
GROUP BY idAD
0.000 : 0 : SELECT *
FROM campagne_promotion_produit
INNER JOIN campagne_promotion ON (cpro_id = cpp_id_cpro)
INNER JOIN campagne_promotion_contact ON (cpro_id = cpc_id_cpro)
WHERE cpc_id_contact = '' AND cpp_actif = 1 AND cpc_actif = 1
AND cpp_id_art = '125572' AND cpro_etat = 'ACTIF'
AND cpro_date_debut <= DATE(NOW()) AND cpro_date_fin >= DATE(NOW())
0.001 : 3 : SELECT pde_idAD
FROM evo_complete c
INNER JOIN products_details ON (products_details.pde_idDep = '2' AND pde_idArt = idArtCpl)
INNER JOIN evo_article ON (evo_article.idArt = idArtCpl AND flgConsArt != 1)
LEFT JOIN products_groups_details pgd ON (pgd.pgd_idArt = idArtCpl)
WHERE c.idArt = '125572' 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 = '2' 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 = '125572' AND pd2.pde_active = 1
GROUP BY pgd2.pgd_id_groupe
))
0.000 : 1 : SELECT FOUND_ROWS() as nb
0.000 : 0 : SELECT * FROM i18n WHERE lang='fr'
0.008 : 3 : 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 evo_article_detail ad2
INNER JOIN evo_stock s2 ON (ad2.idAD = s2.idAD)
WHERE ad2.idArt = p.prod_idArt
), 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,
GROUP_CONCAT(catp_libelle ORDER BY catp_id) as cat_perso_libelles,
GROUP_CONCAT(catp_couleur ORDER BY catp_id) as cat_perso_couleurs,
GROUP_CONCAT(catp_forcer_connexion ORDER BY catp_id) as cat_perso_forcer_connexion,
GROUP_CONCAT(catp_produits_exclusif ORDER BY catp_id) as cat_perso_produits_exclusif,
GROUP_CONCAT(catp_a_gestion_stock ORDER BY catp_id) as cat_perso_a_gestion_stock,
GROUP_CONCAT(catp_type_client ORDER BY catp_id, '| ') as cat_perso_type_client,
GROUP_CONCAT(catp_is_label ORDER BY catp_id) as cat_perso_is_label
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 = '')
LEFT JOIN catalogues_personnalises_produits ON (catpp_prod_idArt = a.idArt)
LEFT JOIN catalogues_personnalises ON (catp_id = catpp_catp_id AND catp_actif = 1)
WHERE pde_idAd IN ('349817','349873','340599')
GROUP BY pde_idAD
ORDER BY CASE pde_idAD WHEN 349817 THEN 0 WHEN 349873 THEN 1 WHEN 340599 THEN 2 END;
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 = '125572' AND pde_idDep = '2' 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 = '125572' AND pd2.pde_idDep = '2' 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.000 : 1 : SELECT * FROM sliders_images LEFT JOIN sliders_images_lang ON (lsli_img_id = sli_img_id AND lang = 'fr') WHERE sli_id='7' AND sli_img_active=1 ORDER BY sli_img_ordre ASC
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='22'
0.048 : 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 : 1 : SELECT * FROM tracking_analytics WHERE trk_actif = 1
0.001 : 343 : SELECT cat_id,cat_id_parent,cat_niveau,cat_nom,cat_enfants FROM categories ORDER BY cat_ordre ASC
0.001 : 13 : 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 : 21 : SELECT * FROM cms
0.001 : 6 : 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 : 6 : 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.001 : 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 : 4 : 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 : 7 : 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.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 = '69'
