Logs
info: infoinfo: infoinfo: Commande executée: git rev-parse HEAD ; statut de retour: 0
SQL (0.104s)
0.001 : Connexion BDD sur localhost:gimel
0.001 : 2 : SELECT * FROM gimel.registry
0.001 : 1 : SELECT *
FROM gimel.negociants
WHERE neg_domaine_front = 'first-robinetterie.kyxar.fr' OR neg_domaine_back = 'first-robinetterie.kyxar.fr'
0.000 : 0 : USE gimel_first_robinetterie
0.000 : 1 : SELECT * FROM gimel.negociants WHERE neg_schema = 'first_robinetterie';
0.000 : 1 : SELECT DATABASE()
0.001 : 73 : 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 = '10';
0.000 : 0 : SELECT dho_day, dho_opening_hour, dho_closure_hour FROM depots_horaires WHERE dho_idDep = '10';
0.002 : 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.012 : 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.005 : 0 : SELECT * FROM tags JOIN news_tags ON (id = tag_id)
0.001 : 1 : SELECT * FROM sliders WHERE sli_code='btn-home'
0.001 : 4 : SELECT * FROM sliders_images LEFT JOIN sliders_images_lang ON (lsli_img_id = sli_img_id AND lang = 'fr') WHERE sli_id='10' AND sli_img_active=1 ORDER BY sli_img_ordre ASC
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='96'
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='99'
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='100'
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='102'
0.000 : 1 : SELECT * FROM sliders WHERE sli_code='a-la-une'
0.001 : 5 : 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='4'
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='6'
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.001 : 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.001 : 6 : 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='101'
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='110'
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='111'
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='112'
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='113'
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='114'
0.002 : 1 : SELECT DISTINCT * FROM slider_produit WHERE sp_code='ma_selection'
0.007 : 8 : 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 = '10')
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.030 : 8 : 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 ('22026','34884','40134','40710','41796','115778','119565','150388')
GROUP BY pde_idAD
ORDER BY CASE pde_idAD WHEN 22026 THEN 0 WHEN 34884 THEN 1 WHEN 40134 THEN 2 WHEN 40710 THEN 3 WHEN 41796 THEN 4 WHEN 115778 THEN 5 WHEN 119565 THEN 6 WHEN 150388 THEN 7 END;
0.003 : 13 : 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='nos-domaines'
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='11' AND sli_img_active=1 ORDER BY sli_img_ordre ASC
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='103'
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='107'
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='108'
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='109'
0.000 : 1 : SELECT * FROM sliders WHERE sli_code='marques'
0.000 : 21 : 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='66'
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='67'
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='68'
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='69'
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='70'
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='71'
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='72'
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='73'
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='74'
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='76'
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='77'
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='78'
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='80'
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='81'
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='82'
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='83'
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='84'
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='86'
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='87'
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='88'
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='89'
0.000 : 1 : SELECT * FROM sliders WHERE sli_code='decouverte'
0.000 : 3 : SELECT * FROM sliders_images LEFT JOIN sliders_images_lang ON (lsli_img_id = sli_img_id AND lang = 'fr') WHERE sli_id='12' AND sli_img_active=1 ORDER BY sli_img_ordre ASC
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='104'
0.000 : 1 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='105'
0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='106'
0.005 : 1 : SELECT mes.*, COALESCE(lmes.limage, mes.image) as image
FROM mises_en_scene mes
LEFT JOIN mises_en_scene_lang lmes ON lmes.lid = mes.id AND lmes.lang = 'fr'
WHERE mes.code = 'homepage'
0.002 : 2 : SELECT * FROM mises_en_scene_products WHERE mes_id = '2'
0.000 : 2 : SELECT mesp.*, prod_idArt, prod_name
FROM mises_en_scene_products mesp
INNER JOIN products ON (mesp.product_idArt = prod_idArt)
WHERE mesp.mes_id = '2'
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.011 : 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 : 0 : 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 = 'Index' 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 : 7 : 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 : 7 : SELECT * FROM cms
0.000 : 1 : 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 : 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 : 6 : 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 : 268 : SELECT cat_id,cat_id_parent,cat_niveau,cat_nom,cat_enfants FROM categories ORDER BY cat_ordre ASC
0.001 : 1 : 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.001 : 337 : 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 = '74'
0.001 : 1 : 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 = 'menu_top'
AND md.actif = 1
ORDER BY ordre_rubrique ASC