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%3A2&fq=idNegociant%3A38&fq=categories%3A10&sort=designationWebString%20asc%2Cscore%20desc%2CdesignationWebString%20asc&start=0&rows=144&q=%2A%3A%2Ainfo: Solr temps : 0.010 secinfo: Commande executée: git rev-parse HEAD ; statut de retour: 0
SQL (0.230s)
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 = 'evodemo.kyxar.fr' OR neg_domaine_back = 'evodemo.kyxar.fr'
0.000 : 0 : USE gimel_evodemo
0.001 : 1 : SELECT * FROM gimel.negociants WHERE neg_schema = 'evodemo';
0.000 : 1 : SELECT DATABASE()
0.000 : 66 : 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 : 0 : 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 = '10';
0.000 : 0 : SELECT cat_id
FROM categories
WHERE cat_filtre_enfants = 1
AND cat_id IN (9)
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 = '10'
0.000 : 1 : SELECT * FROM categories WHERE cat_id = '10';
0.000 : 1 : SELECT * FROM categories WHERE cat_id = '9';
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 (9)
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 = '10'
0.197 : 144 : 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_reel, s.stkReelAD) as stock,
adfour.codADF,
count(w.wish_id_contact) as favoris,
SUBSTRING_INDEX(tva.valDLib,";",1) as pourcentage_tva,
( SELECT sum(evo_stock.stkReelAD) 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.stkReelAD)
FROM evo_article_detail ad2
INNER JOIN evo_stock s2 ON (ad2.idAD = s2.idAD)
WHERE ad2.idArt = p.prod_idArt
), s.stkReelAD) 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 ('13083','13088','13093','13098','7773','7778','7783','7788','7793','7798','13088'0,'13088'1,'13088'2,'13088'3,'13088'4,'13088'5,'13088'6,'13088'7,'13088'8,'13088'9,'13093'0,'13093'1,'13093'2,'13093'3,'13093'4,'13093'5,'13093'6,'13093'7,'13093'8,'13093'9,'13098'0,'13098'1,'13098'2,'13098'3,'13098'4,'13098'5,'13098'6,'13098'7,'13098'8,'13098'9,'7773'0,'7773'1,'7773'2,'7773'3,'7773'4,'7773'5,'7773'6,'7773'7,'7773'8,'7773'9,'7778'0,'7778'1,'7778'2,'7778'3,'7778'4,'7778'5,'7778'6,'7778'7,'7778'8,'7778'9,'7783'0,'7783'1,'7783'2,'7783'3,'7783'4,'7783'5,'7783'6,'7783'7,'7783'8,'7783'9,'7788'0,'7788'1,'7788'2,'7788'3,'7788'4,'7788'5,'7788'6,'7788'7,'7788'8,'7788'9,'7793'0,'7793'1,'7793'2,'7793'3,'7793'4,'7793'5,'7793'6,'7793'7,'7793'8,'7793'9,'7798'0,'7798'1,'7798'2,'7798'3,'7798'4,'7798'5,'7798'6,'7798'7,'7798'8,'7798'9,'13088'00,'13088'01,'13088'02,'13088'03,'13088'04,'13088'05,'13088'06,'13088'07,'13088'08,'13088'09,'13088'10,'13088'11,'13088'12,'13088'13,'13088'14,'13088'15,'13088'16,'13088'17,'13088'18,'13088'19,'13088'20,'13088'21,'13088'22,'13088'23,'13088'24,'13088'25,'13088'26,'13088'27,'13088'28,'13088'29,'13088'30,'13088'31,'13088'32,'13088'33,'13088'34,'13088'35,'13088'36,'13088'37,'13088'38,'13088'39,'13088'40,'13088'41,'13088'42,'13088'43)
GROUP BY pde_idAD
ORDER BY CASE pde_idAD WHEN 13083 THEN 0 WHEN 13088 THEN 1 WHEN 13093 THEN 2 WHEN 13098 THEN 3 WHEN 7773 THEN 4 WHEN 7778 THEN 5 WHEN 7783 THEN 6 WHEN 7788 THEN 7 WHEN 7793 THEN 8 WHEN 7798 THEN 9 WHEN 178939 THEN 10 WHEN 894855 THEN 11 WHEN 894860 THEN 12 WHEN 7768 THEN 13 WHEN 12913 THEN 14 WHEN 12918 THEN 15 WHEN 12923 THEN 16 WHEN 12928 THEN 17 WHEN 12933 THEN 18 WHEN 12938 THEN 19 WHEN 12943 THEN 20 WHEN 248606 THEN 21 WHEN 248611 THEN 22 WHEN 248616 THEN 23 WHEN 725314 THEN 24 WHEN 719439 THEN 25 WHEN 771478 THEN 26 WHEN 719449 THEN 27 WHEN 719454 THEN 28 WHEN 1248275 THEN 29 WHEN 1248270 THEN 30 WHEN 7013 THEN 31 WHEN 7018 THEN 32 WHEN 7023 THEN 33 WHEN 7028 THEN 34 WHEN 7033 THEN 35 WHEN 666001 THEN 36 WHEN 7038 THEN 37 WHEN 7043 THEN 38 WHEN 7048 THEN 39 WHEN 7053 THEN 40 WHEN 7058 THEN 41 WHEN 876115 THEN 42 WHEN 876120 THEN 43 WHEN 876125 THEN 44 WHEN 876130 THEN 45 WHEN 876135 THEN 46 WHEN 876140 THEN 47 WHEN 724079 THEN 48 WHEN 719244 THEN 49 WHEN 178987 THEN 50 WHEN 12718 THEN 51 WHEN 12723 THEN 52 WHEN 12728 THEN 53 WHEN 12733 THEN 54 WHEN 12738 THEN 55 WHEN 12743 THEN 56 WHEN 12748 THEN 57 WHEN 248506 THEN 58 WHEN 248511 THEN 59 WHEN 248516 THEN 60 WHEN 724074 THEN 61 WHEN 719229 THEN 62 WHEN 1232110 THEN 63 WHEN 719234 THEN 64 WHEN 719239 THEN 65 WHEN 178982 THEN 66 WHEN 12683 THEN 67 WHEN 12688 THEN 68 WHEN 12693 THEN 69 WHEN 12698 THEN 70 WHEN 12703 THEN 71 WHEN 12708 THEN 72 WHEN 12713 THEN 73 WHEN 248491 THEN 74 WHEN 248496 THEN 75 WHEN 248501 THEN 76 WHEN 1127183 THEN 77 WHEN 719249 THEN 78 WHEN 719254 THEN 79 WHEN 12948 THEN 80 WHEN 724069 THEN 81 WHEN 12953 THEN 82 WHEN 12958 THEN 83 WHEN 12963 THEN 84 WHEN 314050 THEN 85 WHEN 719214 THEN 86 WHEN 12968 THEN 87 WHEN 12973 THEN 88 WHEN 1232095 THEN 89 WHEN 248626 THEN 90 WHEN 719219 THEN 91 WHEN 248631 THEN 92 WHEN 775613 THEN 93 WHEN 719224 THEN 94 WHEN 12648 THEN 95 WHEN 12653 THEN 96 WHEN 12658 THEN 97 WHEN 12663 THEN 98 WHEN 12668 THEN 99 WHEN 12673 THEN 100 WHEN 12678 THEN 101 WHEN 248476 THEN 102 WHEN 248481 THEN 103 WHEN 248486 THEN 104 WHEN 12983 THEN 105 WHEN 12993 THEN 106 WHEN 12988 THEN 107 WHEN 12998 THEN 108 WHEN 314045 THEN 109 WHEN 13003 THEN 110 WHEN 724064 THEN 111 WHEN 719199 THEN 112 WHEN 719204 THEN 113 WHEN 719209 THEN 114 WHEN 7183 THEN 115 WHEN 12613 THEN 116 WHEN 12618 THEN 117 WHEN 12623 THEN 118 WHEN 12628 THEN 119 WHEN 12633 THEN 120 WHEN 12638 THEN 121 WHEN 12643 THEN 122 WHEN 248461 THEN 123 WHEN 248466 THEN 124 WHEN 248471 THEN 125 WHEN 1232120 THEN 126 WHEN 650126 THEN 127 WHEN 314055 THEN 128 WHEN 314060 THEN 129 WHEN 314065 THEN 130 WHEN 314070 THEN 131 WHEN 7228 THEN 132 WHEN 7233 THEN 133 WHEN 7238 THEN 134 WHEN 7243 THEN 135 WHEN 7248 THEN 136 WHEN 7253 THEN 137 WHEN 7263 THEN 138 WHEN 7258 THEN 139 WHEN 7268 THEN 140 WHEN 894740 THEN 141 WHEN 894745 THEN 142 WHEN 894750 THEN 143 END;
0.000 : 1 : SELECT cat_nom FROM categories WHERE cat_id = '10'
0.000 : 1 : SELECT * FROM categories WHERE cat_id = '9';
0.000 : 1 : SELECT cat_nom FROM categories WHERE cat_id = '9'
0.000 : 0 : SELECT * FROM sliders WHERE sli_code='imglogin'
0.020 : 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 = '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 : 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 = 'navigation'
AND md.actif = 1
ORDER BY ordre_rubrique ASC
0.000 : 6 : SELECT * FROM cms
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'
AND md.actif = 1
ORDER BY ordre_rubrique ASC
0.001 : 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.001 : 2 : 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.001 : 3 : 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 : 4 : 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 : 16 : SELECT cat_id,cat_id_parent,cat_niveau,cat_nom,cat_enfants FROM categories ORDER BY cat_ordre ASC
0.001 : 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 = '38'