Logs
info: infoinfo: infoinfo: Commande executée: git rev-parse HEAD ; statut de retour: 0
SQL (0.118s)
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.000 : 1 : SELECT * FROM gimel.negociants WHERE neg_schema = 'novamat';
0.000 : 1 : SELECT DATABASE()
0.000 : 84 : SELECT * FROM registry
0.000 : 1 : SELECT dep_idDep FROM depots WHERE dep_defaut = 1;
0.001 : 1 : 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 idDep = '2';
0.000 : 10 : SELECT dho_day, dho_opening_hour, dho_closure_hour FROM depots_horaires WHERE dho_idDep = '2';
0.001 : 1 : SELECT traduction FROM i18n_seo WHERE hash = 'ae80d103f028c16e2d1900530858bef1' AND lang = 'fr' AND page = 'Accueil'
0.000 : 1 : SELECT traduction FROM i18n_seo WHERE hash = 'f65ecca2ed917561839ee55fa9b91f7b' AND lang = 'fr' AND page = 'Accueil'
0.021 : 3 : SELECT *, date_format(news_date,'%d/%m/%Y') as news_date_fr
FROM news
LEFT JOIN news_lang ON (lnews_id = news_id AND lang='fr')
WHERE (news_date_publication <= NOW() OR news_date_publication IS NULL)
AND (news_date_depublication >= NOW() OR news_date_depublication IS NULL)
AND news_active=1
ORDER BY news_date DESC, news_id DESC
LIMIT 3
0.010 : 0 : SELECT * FROM tags JOIN news_tags ON (id = tag_id)
0.000 : 1 : SELECT * FROM sliders WHERE sli_code='btn-home'
0.000 : 4 : SELECT * FROM sliders_images LEFT JOIN sliders_images_lang ON (lsli_img_id = sli_img_id AND lang = 'fr') WHERE sli_id='3' AND sli_img_active=1 ORDER BY sli_img_ordre ASC
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='9'
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='10'
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='11'
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='12'
0.000 : 1 : SELECT * FROM sliders WHERE sli_code='a-la-une'
0.000 : 6 : SELECT * FROM sliders_images LEFT JOIN sliders_images_lang ON (lsli_img_id = sli_img_id AND lang = 'fr') WHERE sli_id='2' AND sli_img_active=1 ORDER BY sli_img_ordre ASC
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='3'
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='7'
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='4'
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='6'
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='5'
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='8'
0.000 : 1 : SELECT * FROM sliders WHERE sli_code='articlehome'
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='4' AND sli_img_active=1 ORDER BY sli_img_ordre ASC
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='13'
0.000 : 1 : SELECT * FROM sliders WHERE sli_code='sliderhome'
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='1' AND sli_img_active=1 ORDER BY sli_img_ordre ASC
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='2'
0.006 : 1 : SELECT DISTINCT * FROM slider_produit WHERE sp_code='ma_selection'
0.005 : 5 : SELECT SQL_CALC_FOUND_ROWS distinct pde_idAD
FROM evo_article a
INNER JOIN products p ON (a.idArt = p.prod_idArt)
INNER JOIN products_details pde ON (p.prod_idArt = pde.pde_idArt AND pde.pde_idDep = '2')
INNER JOIN evo_prix prix ON prix.idAD = pde.pde_idAD
LEFT JOIN slider_produit_article spa ON (spa.spa_idArt = a.idArt)
WHERE pde_active = 1 AND spa.spa_slider_article_id = '1'
GROUP BY a.idArt
LIMIT 12
OFFSET 0
0.000 : 1 : SELECT FOUND_ROWS() as nb
0.020 : 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 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 ('147538','154328','232825','298033','298365')
GROUP BY pde_idAD
ORDER BY CASE pde_idAD WHEN 147538 THEN 0 WHEN 154328 THEN 1 WHEN 232825 THEN 2 WHEN 298033 THEN 3 WHEN 298365 THEN 4 END;
0.004 : 7 : SELECT name, s.sli_code,indisponible_mobile
FROM home_boxes hb
LEFT JOIN sliders s ON (hb.sli_id = s.sli_id)
WHERE actif = 1
ORDER BY position
0.000 : 1 : SELECT * FROM sliders WHERE sli_code='marques'
0.001 : 19 : SELECT * FROM sliders_images LEFT JOIN sliders_images_lang ON (lsli_img_id = sli_img_id AND lang = 'fr') WHERE sli_id='9' AND sli_img_active=1 ORDER BY sli_img_ordre ASC
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='27'
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='34'
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='35'
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='36'
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='37'
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='38'
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='39'
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='40'
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='41'
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='42'
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='43'
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='44'
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='45'
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='46'
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='47'
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='48'
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='49'
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='50'
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='51'
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.031 : 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 * FROM i18n WHERE lang='fr'
0.000 : 0 : SELECT nec_valeur
FROM gimel.negociants_config
WHERE nec_module = 'listesAchats'
AND nec_parametre = 'actif'
AND nec_id_negociant = '69'
