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&fq=idDepot%3A1&fq=idNegociant%3A46&fq=categories%3A452&sort=quantite_ventes_evolubat%20desc%2CprixGlobal%20asc%2Cscore%20desc%2CdesignationWebString%20asc&start=0&rows=4&q=%2A%3A%2Ainfo: Solr temps : 0.006 secinfo: 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&fq=idDepot%3A1&fq=idNegociant%3A46&fq=categories%3A452&fq=%7B%21tag%3Dexclure%7D%20-idAD%3A386099&fq=%7B%21tag%3Dexclure%7D%20-idAD%3A1094323&fq=%7B%21tag%3Dexclure%7D%20-idAD%3A1102867&fq=%7B%21tag%3Dexclure%7D%20-idAD%3A388707&sort=designationWebString%20asc%2Cscore%20desc%2CdesignationWebString%20asc&start=0&rows=96&q=%2A%3A%2Ainfo: Solr temps : 0.005 sec
SQL (0.113s)
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.000 : 1 : SELECT * FROM categories WHERE cat_id = '452';
0.000 : 0 : SELECT cat_id
FROM categories
WHERE cat_filtre_enfants = 1
AND cat_id IN (12)
ORDER BY cat_niveau ASC
0.000 : 0 : 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 = '452'
0.000 : 1 : SELECT * FROM categories WHERE cat_id = '452';
0.000 : 1 : SELECT * FROM categories WHERE cat_id = '12';
0.000 : 0 : SELECT * FROM categories WHERE cat_id = '0';
0.000 : 0 : SELECT cat_id
FROM categories
WHERE cat_filtre_enfants = 1
AND cat_id IN (12)
ORDER BY cat_niveau ASC
0.000 : 0 : 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 = '452'
0.087 : 100 : 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 ('386099','1094323','1102867','388707','1040163','1216003','1203843','1211523','1040771','579411','1094323'0,'1094323'1,'1094323'2,'1094323'3,'1094323'4,'1094323'5,'1094323'6,'1094323'7,'1094323'8,'1094323'9,'1102867'0,'1102867'1,'1102867'2,'1102867'3,'1102867'4,'1102867'5,'1102867'6,'1102867'7,'1102867'8,'1102867'9,'388707'0,'388707'1,'388707'2,'388707'3,'388707'4,'388707'5,'388707'6,'388707'7,'388707'8,'388707'9,'1040163'0,'1040163'1,'1040163'2,'1040163'3,'1040163'4,'1040163'5,'1040163'6,'1040163'7,'1040163'8,'1040163'9,'1216003'0,'1216003'1,'1216003'2,'1216003'3,'1216003'4,'1216003'5,'1216003'6,'1216003'7,'1216003'8,'1216003'9,'1203843'0,'1203843'1,'1203843'2,'1203843'3,'1203843'4,'1203843'5,'1203843'6,'1203843'7,'1203843'8,'1203843'9,'1211523'0,'1211523'1,'1211523'2,'1211523'3,'1211523'4,'1211523'5,'1211523'6,'1211523'7,'1211523'8,'1211523'9,'1040771'0,'1040771'1,'1040771'2,'1040771'3,'1040771'4,'1040771'5,'1040771'6,'1040771'7,'1040771'8,'1040771'9,'579411'0,'579411'1,'579411'2,'579411'3,'579411'4,'579411'5,'579411'6,'579411'7,'579411'8,'579411'9)
GROUP BY pde_idAD
ORDER BY CASE pde_idAD WHEN 386099 THEN 0 WHEN 1094323 THEN 1 WHEN 1102867 THEN 2 WHEN 388707 THEN 3 WHEN 1040163 THEN 4 WHEN 1216003 THEN 5 WHEN 1203843 THEN 6 WHEN 1211523 THEN 7 WHEN 1040771 THEN 8 WHEN 579411 THEN 9 WHEN 2301787 THEN 10 WHEN 2301770 THEN 11 WHEN 545283 THEN 12 WHEN 1739302 THEN 13 WHEN 559827 THEN 14 WHEN 559811 THEN 15 WHEN 1098003 THEN 16 WHEN 1908772 THEN 17 WHEN 551571 THEN 18 WHEN 1102099 THEN 19 WHEN 1100707 THEN 20 WHEN 382163 THEN 21 WHEN 1097619 THEN 22 WHEN 1038995 THEN 23 WHEN 381587 THEN 24 WHEN 380003 THEN 25 WHEN 577843 THEN 26 WHEN 526179 THEN 27 WHEN 526163 THEN 28 WHEN 385235 THEN 29 WHEN 385315 THEN 30 WHEN 1216259 THEN 31 WHEN 575587 THEN 32 WHEN 574099 THEN 33 WHEN 1628357 THEN 34 WHEN 1027571 THEN 35 WHEN 1104995 THEN 36 WHEN 378867 THEN 37 WHEN 380147 THEN 38 WHEN 2214382 THEN 39 WHEN 562835 THEN 40 WHEN 2073010 THEN 41 WHEN 370147 THEN 42 WHEN 348515 THEN 43 WHEN 698003 THEN 44 WHEN 378691 THEN 45 WHEN 432707 THEN 46 WHEN 545299 THEN 47 WHEN 433027 THEN 48 WHEN 577811 THEN 49 WHEN 378227 THEN 50 WHEN 549235 THEN 51 WHEN 389891 THEN 52 WHEN 555059 THEN 53 WHEN 379459 THEN 54 WHEN 537555 THEN 55 WHEN 376483 THEN 56 WHEN 2211900 THEN 57 WHEN 348531 THEN 58 WHEN 1936503 THEN 59 WHEN 575203 THEN 60 WHEN 552227 THEN 61 WHEN 1038979 THEN 62 WHEN 1067171 THEN 63 WHEN 1041427 THEN 64 WHEN 1043011 THEN 65 WHEN 1067187 THEN 66 WHEN 552803 THEN 67 WHEN 377971 THEN 68 WHEN 429811 THEN 69 WHEN 428643 THEN 70 WHEN 433443 THEN 71 WHEN 535747 THEN 72 WHEN 530003 THEN 73 WHEN 388259 THEN 74 WHEN 531027 THEN 75 WHEN 397107 THEN 76 WHEN 556067 THEN 77 WHEN 383603 THEN 78 WHEN 545587 THEN 79 WHEN 386803 THEN 80 WHEN 2301260 THEN 81 WHEN 1040915 THEN 82 WHEN 1095155 THEN 83 WHEN 1113219 THEN 84 WHEN 1107715 THEN 85 WHEN 1105379 THEN 86 WHEN 1098643 THEN 87 WHEN 2201627 THEN 88 WHEN 1093955 THEN 89 WHEN 1102067 THEN 90 WHEN 1102083 THEN 91 WHEN 1102035 THEN 92 WHEN 1102051 THEN 93 WHEN 1097603 THEN 94 WHEN 1095699 THEN 95 WHEN 1097475 THEN 96 WHEN 1094147 THEN 97 WHEN 1097395 THEN 98 WHEN 1425434 THEN 99 END;
0.000 : 1 : SELECT cat_nom FROM categories WHERE cat_id = '452'
0.000 : 1 : SELECT * FROM categories WHERE cat_id = '12';
0.000 : 1 : SELECT cat_nom FROM categories WHERE cat_id = '12'
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.013 : 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 = 'Catalogue' 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.000 : 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.001 : 1 : SELECT *
FROM rgpd_cookies_parametres
LEFT JOIN rgpd_cookies_parametres_lang ON (lrcp_id = rcp_id AND lang = 'fr')
0.003 : 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.001 : 355 : 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 = '46'