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%3A9&sort=quantite_ventes_evolubat%20desc%2CprixGlobal%20asc%2Cscore%20desc%2CdesignationWebString%20asc&start=0&rows=4&q=%2A%3A%2Ainfo: Solr temps : 0.010 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%3A9&fq=%7B%21tag%3Dexclure%7D%20-idAD%3A1225523&fq=%7B%21tag%3Dexclure%7D%20-idAD%3A1202963&fq=%7B%21tag%3Dexclure%7D%20-idAD%3A1183683&fq=%7B%21tag%3Dexclure%7D%20-idAD%3A2097751&sort=designationWebString%20asc%2Cscore%20desc%2CdesignationWebString%20asc&start=0&rows=144&q=%2A%3A%2Ainfo: Solr temps : 0.005 secinfo: Commande executée: git rev-parse HEAD ; statut de retour: 0
SQL (0.117s)
0.000 : Connexion BDD sur localhost:gimel
0.000 : 2 : SELECT * FROM gimel.registry
0.001 : 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 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 = '1';
0.000 : 10 : SELECT dho_day, dho_opening_hour, dho_closure_hour FROM depots_horaires WHERE dho_idDep = '1';
0.000 : 1 : SELECT * FROM categories WHERE cat_id = '9';
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 = '9'
0.000 : 1 : SELECT * FROM categories WHERE cat_id = '9';
0.000 : 0 : SELECT * FROM categories WHERE cat_id = '0';
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 = '9'
0.088 : 148 : 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 ('1225523','1202963','1183683','2097751','2186947','1235091','1236467','1703011','1924360','1228291','1202963'0,'1202963'1,'1202963'2,'1202963'3,'1202963'4,'1202963'5,'1202963'6,'1202963'7,'1202963'8,'1202963'9,'1183683'0,'1183683'1,'1183683'2,'1183683'3,'1183683'4,'1183683'5,'1183683'6,'1183683'7,'1183683'8,'1183683'9,'2097751'0,'2097751'1,'2097751'2,'2097751'3,'2097751'4,'2097751'5,'2097751'6,'2097751'7,'2097751'8,'2097751'9,'2186947'0,'2186947'1,'2186947'2,'2186947'3,'2186947'4,'2186947'5,'2186947'6,'2186947'7,'2186947'8,'2186947'9,'1235091'0,'1235091'1,'1235091'2,'1235091'3,'1235091'4,'1235091'5,'1235091'6,'1235091'7,'1235091'8,'1235091'9,'1236467'0,'1236467'1,'1236467'2,'1236467'3,'1236467'4,'1236467'5,'1236467'6,'1236467'7,'1236467'8,'1236467'9,'1703011'0,'1703011'1,'1703011'2,'1703011'3,'1703011'4,'1703011'5,'1703011'6,'1703011'7,'1703011'8,'1703011'9,'1924360'0,'1924360'1,'1924360'2,'1924360'3,'1924360'4,'1924360'5,'1924360'6,'1924360'7,'1924360'8,'1924360'9,'1228291'0,'1228291'1,'1228291'2,'1228291'3,'1228291'4,'1228291'5,'1228291'6,'1228291'7,'1228291'8,'1228291'9,'1202963'00,'1202963'01,'1202963'02,'1202963'03,'1202963'04,'1202963'05,'1202963'06,'1202963'07,'1202963'08,'1202963'09,'1202963'10,'1202963'11,'1202963'12,'1202963'13,'1202963'14,'1202963'15,'1202963'16,'1202963'17,'1202963'18,'1202963'19,'1202963'20,'1202963'21,'1202963'22,'1202963'23,'1202963'24,'1202963'25,'1202963'26,'1202963'27,'1202963'28,'1202963'29,'1202963'30,'1202963'31,'1202963'32,'1202963'33,'1202963'34,'1202963'35,'1202963'36,'1202963'37,'1202963'38,'1202963'39,'1202963'40,'1202963'41,'1202963'42,'1202963'43,'1202963'44,'1202963'45,'1202963'46,'1202963'47)
GROUP BY pde_idAD
ORDER BY CASE pde_idAD WHEN 1225523 THEN 0 WHEN 1202963 THEN 1 WHEN 1183683 THEN 2 WHEN 2097751 THEN 3 WHEN 2186947 THEN 4 WHEN 1235091 THEN 5 WHEN 1236467 THEN 6 WHEN 1703011 THEN 7 WHEN 1924360 THEN 8 WHEN 1228291 THEN 9 WHEN 1254499 THEN 10 WHEN 2125701 THEN 11 WHEN 1668576 THEN 12 WHEN 1265635 THEN 13 WHEN 1223651 THEN 14 WHEN 1668610 THEN 15 WHEN 1253011 THEN 16 WHEN 1249059 THEN 17 WHEN 1225587 THEN 18 WHEN 2097768 THEN 19 WHEN 1186179 THEN 20 WHEN 2076512 THEN 21 WHEN 1265763 THEN 22 WHEN 1180147 THEN 23 WHEN 1973969 THEN 24 WHEN 1255203 THEN 25 WHEN 1239635 THEN 26 WHEN 1186499 THEN 27 WHEN 1183539 THEN 28 WHEN 1183507 THEN 29 WHEN 1183491 THEN 30 WHEN 1183123 THEN 31 WHEN 1185939 THEN 32 WHEN 1199859 THEN 33 WHEN 1185971 THEN 34 WHEN 1183875 THEN 35 WHEN 1185987 THEN 36 WHEN 1199779 THEN 37 WHEN 2052011 THEN 38 WHEN 1231235 THEN 39 WHEN 1221187 THEN 40 WHEN 1235475 THEN 41 WHEN 1233683 THEN 42 WHEN 1897242 THEN 43 WHEN 1640069 THEN 44 WHEN 1253907 THEN 45 WHEN 2125225 THEN 46 WHEN 2125412 THEN 47 WHEN 2125429 THEN 48 WHEN 2125446 THEN 49 WHEN 2076478 THEN 50 WHEN 2076495 THEN 51 WHEN 2041781 THEN 52 WHEN 1961943 THEN 53 WHEN 2014699 THEN 54 WHEN 1220323 THEN 55 WHEN 1202819 THEN 56 WHEN 1265827 THEN 57 WHEN 1202003 THEN 58 WHEN 1254835 THEN 59 WHEN 1242771 THEN 60 WHEN 1265811 THEN 61 WHEN 2118930 THEN 62 WHEN 2118947 THEN 63 WHEN 1217491 THEN 64 WHEN 1252867 THEN 65 WHEN 1218963 THEN 66 WHEN 1218739 THEN 67 WHEN 1243379 THEN 68 WHEN 1237315 THEN 69 WHEN 1226723 THEN 70 WHEN 1218387 THEN 71 WHEN 1476024 THEN 72 WHEN 1226147 THEN 73 WHEN 1224531 THEN 74 WHEN 1224899 THEN 75 WHEN 2206490 THEN 76 WHEN 2014019 THEN 77 WHEN 1249347 THEN 78 WHEN 2206524 THEN 79 WHEN 1221571 THEN 80 WHEN 1231187 THEN 81 WHEN 1169235 THEN 82 WHEN 1219875 THEN 83 WHEN 1249571 THEN 84 WHEN 1221827 THEN 85 WHEN 2096731 THEN 86 WHEN 1237475 THEN 87 WHEN 1229523 THEN 88 WHEN 1220211 THEN 89 WHEN 1245507 THEN 90 WHEN 1237507 THEN 91 WHEN 1969430 THEN 92 WHEN 1969447 THEN 93 WHEN 1962011 THEN 94 WHEN 2093805 THEN 95 WHEN 3375382 THEN 96 WHEN 2016637 THEN 97 WHEN 2016620 THEN 98 WHEN 2016603 THEN 99 WHEN 2093244 THEN 100 WHEN 1961960 THEN 101 WHEN 1961977 THEN 102 WHEN 1229779 THEN 103 WHEN 1249651 THEN 104 WHEN 2096748 THEN 105 WHEN 1845461 THEN 106 WHEN 1226387 THEN 107 WHEN 1250611 THEN 108 WHEN 1224867 THEN 109 WHEN 1228483 THEN 110 WHEN 1225539 THEN 111 WHEN 1254147 THEN 112 WHEN 1224483 THEN 113 WHEN 1228419 THEN 114 WHEN 1245347 THEN 115 WHEN 1237667 THEN 116 WHEN 1239075 THEN 117 WHEN 1236275 THEN 118 WHEN 1239059 THEN 119 WHEN 1249363 THEN 120 WHEN 1252995 THEN 121 WHEN 1248723 THEN 122 WHEN 1603468 THEN 123 WHEN 1253603 THEN 124 WHEN 2206507 THEN 125 WHEN 1961994 THEN 126 WHEN 1226083 THEN 127 WHEN 1236995 THEN 128 WHEN 1226627 THEN 129 WHEN 1219955 THEN 130 WHEN 1233315 THEN 131 WHEN 1183587 THEN 132 WHEN 1186067 THEN 133 WHEN 1183523 THEN 134 WHEN 1180819 THEN 135 WHEN 2076427 THEN 136 WHEN 1945278 THEN 137 WHEN 1239363 THEN 138 WHEN 224067 THEN 139 WHEN 1241827 THEN 140 WHEN 1182835 THEN 141 WHEN 2211764 THEN 142 WHEN 1186259 THEN 143 WHEN 1219091 THEN 144 WHEN 1254611 THEN 145 WHEN 1265987 THEN 146 WHEN 1255075 THEN 147 END;
0.000 : 1 : SELECT cat_nom FROM categories WHERE cat_id = '9'
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.018 : 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.000 : 1 : SELECT *
FROM rgpd_cookies_parametres
LEFT JOIN rgpd_cookies_parametres_lang ON (lrcp_id = rcp_id AND lang = 'fr')
0.001 : 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'