Logs
info: infoinfo: infoinfo: Solr URL : http://localhost:8983/solr/evoweb/select/?version=2.2&indent=on&wt=xmlinfo: Solr Request : defType=edismax&facet=true&facet.mincount=1&facet.sort=index&fl=idAD&facet.field=%7B%21ex%3Dfeatures_marque%7Dfeatures_marque&fq=idDepot%3A2&fq=idNegociant%3A69&fq=categories%3A160&sort=designationWebString%20asc%2Cscore%20desc%2CdesignationWebString%20asc&start=0&rows=96&q=%2A%3A%2Ainfo: Solr temps : 0.006 secinfo: Commande executée: git rev-parse HEAD ; statut de retour: 0
SQL (0.096s)
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.000 : 1 : SELECT dep_idDep FROM depots WHERE dep_defaut = 1;
0.000 : 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.000 : 1 : SELECT * FROM categories WHERE cat_id = '160';
0.000 : 1 : SELECT cat_id
FROM categories
WHERE cat_filtre_enfants = 1
AND cat_id IN (148)
ORDER BY cat_niveau ASC
0.001 : 1 : SELECT DISTINCT f_champ as champ, f_libelle as libelle
FROM categories_features
INNER JOIN pim_features ON (f_champ = caf_champ_feature)
WHERE caf_cat_id = '148'
0.000 : 1 : SELECT * FROM categories WHERE cat_id = '160';
0.000 : 1 : SELECT * FROM categories WHERE cat_id = '148';
0.000 : 0 : SELECT * FROM categories WHERE cat_id = '0';
0.000 : 1 : SELECT cat_id
FROM categories
WHERE cat_filtre_enfants = 1
AND cat_id IN (148)
ORDER BY cat_niveau ASC
0.001 : 1 : SELECT DISTINCT f_champ as champ, f_libelle as libelle
FROM categories_features
INNER JOIN pim_features ON (f_champ = caf_champ_feature)
WHERE caf_cat_id = '148'
0.059 : 96 : 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 ('167494','167470','167430','167438','286108','347315','347287','347322','347294','347301','167470'0,'167470'1,'167470'2,'167470'3,'167470'4,'167470'5,'167470'6,'167470'7,'167470'8,'167470'9,'167430'0,'167430'1,'167430'2,'167430'3,'167430'4,'167430'5,'167430'6,'167430'7,'167430'8,'167430'9,'167438'0,'167438'1,'167438'2,'167438'3,'167438'4,'167438'5,'167438'6,'167438'7,'167438'8,'167438'9,'286108'0,'286108'1,'286108'2,'286108'3,'286108'4,'286108'5,'286108'6,'286108'7,'286108'8,'286108'9,'347315'0,'347315'1,'347315'2,'347315'3,'347315'4,'347315'5,'347315'6,'347315'7,'347315'8,'347315'9,'347287'0,'347287'1,'347287'2,'347287'3,'347287'4,'347287'5,'347287'6,'347287'7,'347287'8,'347287'9,'347322'0,'347322'1,'347322'2,'347322'3,'347322'4,'347322'5,'347322'6,'347322'7,'347322'8,'347322'9,'347294'0,'347294'1,'347294'2,'347294'3,'347294'4,'347294'5,'347294'6,'347294'7,'347294'8,'347294'9,'347301'0,'347301'1,'347301'2,'347301'3,'347301'4,'347301'5)
GROUP BY pde_idAD
ORDER BY CASE pde_idAD WHEN 167494 THEN 0 WHEN 167470 THEN 1 WHEN 167430 THEN 2 WHEN 167438 THEN 3 WHEN 286108 THEN 4 WHEN 347315 THEN 5 WHEN 347287 THEN 6 WHEN 347322 THEN 7 WHEN 347294 THEN 8 WHEN 347301 THEN 9 WHEN 347308 THEN 10 WHEN 347329 THEN 11 WHEN 347336 THEN 12 WHEN 286684 THEN 13 WHEN 288269 THEN 14 WHEN 284506 THEN 15 WHEN 286844 THEN 16 WHEN 347093 THEN 17 WHEN 347100 THEN 18 WHEN 347107 THEN 19 WHEN 347114 THEN 20 WHEN 347121 THEN 21 WHEN 347128 THEN 22 WHEN 352804 THEN 23 WHEN 257321 THEN 24 WHEN 257305 THEN 25 WHEN 257313 THEN 26 WHEN 257329 THEN 27 WHEN 257337 THEN 28 WHEN 257345 THEN 29 WHEN 256220 THEN 30 WHEN 256228 THEN 31 WHEN 256236 THEN 32 WHEN 256244 THEN 33 WHEN 256348 THEN 34 WHEN 256316 THEN 35 WHEN 256252 THEN 36 WHEN 256284 THEN 37 WHEN 256356 THEN 38 WHEN 256324 THEN 39 WHEN 256260 THEN 40 WHEN 256292 THEN 41 WHEN 256364 THEN 42 WHEN 256332 THEN 43 WHEN 256268 THEN 44 WHEN 256300 THEN 45 WHEN 256372 THEN 46 WHEN 256340 THEN 47 WHEN 256276 THEN 48 WHEN 256308 THEN 49 WHEN 342697 THEN 50 WHEN 287028 THEN 51 WHEN 287068 THEN 52 WHEN 287108 THEN 53 WHEN 287036 THEN 54 WHEN 287116 THEN 55 WHEN 287076 THEN 56 WHEN 287044 THEN 57 WHEN 287084 THEN 58 WHEN 287124 THEN 59 WHEN 287052 THEN 60 WHEN 287132 THEN 61 WHEN 287092 THEN 62 WHEN 287060 THEN 63 WHEN 287100 THEN 64 WHEN 287140 THEN 65 WHEN 259187 THEN 66 WHEN 259227 THEN 67 WHEN 348509 THEN 68 WHEN 348516 THEN 69 WHEN 348495 THEN 70 WHEN 348502 THEN 71 WHEN 348481 THEN 72 WHEN 348488 THEN 73 WHEN 348467 THEN 74 WHEN 348474 THEN 75 WHEN 259291 THEN 76 WHEN 259299 THEN 77 WHEN 259355 THEN 78 WHEN 259307 THEN 79 WHEN 259315 THEN 80 WHEN 259363 THEN 81 WHEN 259323 THEN 82 WHEN 259331 THEN 83 WHEN 259371 THEN 84 WHEN 259347 THEN 85 WHEN 259339 THEN 86 WHEN 286660 THEN 87 WHEN 286668 THEN 88 WHEN 286676 THEN 89 WHEN 286596 THEN 90 WHEN 286716 THEN 91 WHEN 286724 THEN 92 WHEN 286708 THEN 93 WHEN 286692 THEN 94 WHEN 286636 THEN 95 END;
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 * FROM sliders WHERE sli_code='imglogin'
0.002 : 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.024 : 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.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 : 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'