Fixation

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 = 'vfconfort.kyxar.fr' OR neg_domaine_back = 'vfconfort.kyxar.fr'

0.000 : 0 : USE gimel_vf_confort

0.001 : 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.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 = '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 = '479';

0.000 : 0 : SELECT cat_id FROM categories WHERE cat_filtre_enfants = 1 AND cat_id IN (478) ORDER BY cat_niveau ASC

0.001 : 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 = '479'

0.000 : 1 : SELECT * FROM categories WHERE cat_id = '479';

0.000 : 1 : SELECT * FROM categories WHERE cat_id = '478';

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 (478) 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 = '479'

0.063 : 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 ('1869235','2314524','2074489','2091136','1181619','1197075','1661738','1202195','1211683','1211139','2314524'0,'2314524'1,'2314524'2,'2314524'3,'2314524'4,'2314524'5,'2314524'6,'2314524'7,'2314524'8,'2314524'9,'2074489'0,'2074489'1,'2074489'2,'2074489'3,'2074489'4,'2074489'5,'2074489'6,'2074489'7,'2074489'8,'2074489'9,'2091136'0,'2091136'1,'2091136'2,'2091136'3,'2091136'4,'2091136'5,'2091136'6,'2091136'7,'2091136'8,'2091136'9,'1181619'0,'1181619'1,'1181619'2,'1181619'3,'1181619'4,'1181619'5,'1181619'6,'1181619'7,'1181619'8,'1181619'9,'1197075'0,'1197075'1,'1197075'2,'1197075'3,'1197075'4,'1197075'5,'1197075'6,'1197075'7,'1197075'8,'1197075'9,'1661738'0,'1661738'1,'1661738'2,'1661738'3,'1661738'4,'1661738'5,'1661738'6,'1661738'7,'1661738'8,'1661738'9,'1202195'0,'1202195'1,'1202195'2,'1202195'3,'1202195'4,'1202195'5,'1202195'6,'1202195'7,'1202195'8,'1202195'9,'1211683'0,'1211683'1,'1211683'2,'1211683'3,'1211683'4,'1211683'5,'1211683'6,'1211683'7,'1211683'8,'1211683'9,'1211139'0,'1211139'1,'1211139'2,'1211139'3,'1211139'4,'1211139'5,'1211139'6,'1211139'7,'1211139'8,'1211139'9,'2314524'00,'2314524'01,'2314524'02,'2314524'03,'2314524'04,'2314524'05,'2314524'06,'2314524'07,'2314524'08,'2314524'09,'2314524'10,'2314524'11,'2314524'12,'2314524'13,'2314524'14,'2314524'15,'2314524'16,'2314524'17,'2314524'18,'2314524'19,'2314524'20,'2314524'21,'2314524'22,'2314524'23,'2314524'24,'2314524'25,'2314524'26,'2314524'27,'2314524'28,'2314524'29,'2314524'30,'2314524'31,'2314524'32,'2314524'33,'2314524'34,'2314524'35,'2314524'36,'2314524'37,'2314524'38,'2314524'39,'2314524'40,'2314524'41,'2314524'42,'2314524'43,'2314524'44,'2314524'45,'2314524'46,'2314524'47) GROUP BY pde_idAD ORDER BY CASE pde_idAD WHEN 1869235 THEN 0 WHEN 2314524 THEN 1 WHEN 2074489 THEN 2 WHEN 2091136 THEN 3 WHEN 1181619 THEN 4 WHEN 1197075 THEN 5 WHEN 1661738 THEN 6 WHEN 1202195 THEN 7 WHEN 1211683 THEN 8 WHEN 1211139 THEN 9 WHEN 1211043 THEN 10 WHEN 3393529 THEN 11 WHEN 1628374 THEN 12 WHEN 3393546 THEN 13 WHEN 3393563 THEN 14 WHEN 1193971 THEN 15 WHEN 1178051 THEN 16 WHEN 2226688 THEN 17 WHEN 2226705 THEN 18 WHEN 2226722 THEN 19 WHEN 2226739 THEN 20 WHEN 2226824 THEN 21 WHEN 2225600 THEN 22 WHEN 2225617 THEN 23 WHEN 1840639 THEN 24 WHEN 1840673 THEN 25 WHEN 1840707 THEN 26 WHEN 1840656 THEN 27 WHEN 1840690 THEN 28 WHEN 1866933 THEN 29 WHEN 1866882 THEN 30 WHEN 1866916 THEN 31 WHEN 1866865 THEN 32 WHEN 1866780 THEN 33 WHEN 1866831 THEN 34 WHEN 1840333 THEN 35 WHEN 1840350 THEN 36 WHEN 1840367 THEN 37 WHEN 1840384 THEN 38 WHEN 1840401 THEN 39 WHEN 1840418 THEN 40 WHEN 1840435 THEN 41 WHEN 1999951 THEN 42 WHEN 1840452 THEN 43 WHEN 1840197 THEN 44 WHEN 1839701 THEN 45 WHEN 1843889 THEN 46 WHEN 1999917 THEN 47 WHEN 1840486 THEN 48 WHEN 1901459 THEN 49 WHEN 1840503 THEN 50 WHEN 1840537 THEN 51 WHEN 1869099 THEN 52 WHEN 1974587 THEN 53 WHEN 1840571 THEN 54 WHEN 1840588 THEN 55 WHEN 1840605 THEN 56 WHEN 1840622 THEN 57 WHEN 1840758 THEN 58 WHEN 1840775 THEN 59 WHEN 1840792 THEN 60 WHEN 1840809 THEN 61 WHEN 1869201 THEN 62 WHEN 1868737 THEN 63 WHEN 1840826 THEN 64 WHEN 1840860 THEN 65 WHEN 1840894 THEN 66 WHEN 1840928 THEN 67 WHEN 1840979 THEN 68 WHEN 1841030 THEN 69 WHEN 1841064 THEN 70 WHEN 1841098 THEN 71 WHEN 1841132 THEN 72 WHEN 1841183 THEN 73 WHEN 2073435 THEN 74 WHEN 2073486 THEN 75 WHEN 1841268 THEN 76 WHEN 1841302 THEN 77 WHEN 1841336 THEN 78 WHEN 1841370 THEN 79 WHEN 1841404 THEN 80 WHEN 1841438 THEN 81 WHEN 1841472 THEN 82 WHEN 1841506 THEN 83 WHEN 1841540 THEN 84 WHEN 1841574 THEN 85 WHEN 1841642 THEN 86 WHEN 1841710 THEN 87 WHEN 2005119 THEN 88 WHEN 1841761 THEN 89 WHEN 1841795 THEN 90 WHEN 1841846 THEN 91 WHEN 1840843 THEN 92 WHEN 1840877 THEN 93 WHEN 1840911 THEN 94 WHEN 1840945 THEN 95 WHEN 1840962 THEN 96 WHEN 1840996 THEN 97 WHEN 1841013 THEN 98 WHEN 1841047 THEN 99 WHEN 1841081 THEN 100 WHEN 1841115 THEN 101 WHEN 1841149 THEN 102 WHEN 1841166 THEN 103 WHEN 1841200 THEN 104 WHEN 2019612 THEN 105 WHEN 1841285 THEN 106 WHEN 1841319 THEN 107 WHEN 1841353 THEN 108 WHEN 1841387 THEN 109 WHEN 1841421 THEN 110 WHEN 1841455 THEN 111 WHEN 1841489 THEN 112 WHEN 1841523 THEN 113 WHEN 1841557 THEN 114 WHEN 1841591 THEN 115 WHEN 1841625 THEN 116 WHEN 1841659 THEN 117 WHEN 1841693 THEN 118 WHEN 1841727 THEN 119 WHEN 1841744 THEN 120 WHEN 1841778 THEN 121 WHEN 1841812 THEN 122 WHEN 1841829 THEN 123 WHEN 1841863 THEN 124 WHEN 1841880 THEN 125 WHEN 1841897 THEN 126 WHEN 1841914 THEN 127 WHEN 1841948 THEN 128 WHEN 1841965 THEN 129 WHEN 1841982 THEN 130 WHEN 2074013 THEN 131 WHEN 2074064 THEN 132 WHEN 2074319 THEN 133 WHEN 2074336 THEN 134 WHEN 1214691 THEN 135 WHEN 1963189 THEN 136 WHEN 1963206 THEN 137 WHEN 2073809 THEN 138 WHEN 2073826 THEN 139 WHEN 2073843 THEN 140 WHEN 2090881 THEN 141 WHEN 2073860 THEN 142 WHEN 2073877 THEN 143 WHEN 2091119 THEN 144 WHEN 2090932 THEN 145 WHEN 2090966 THEN 146 WHEN 2090983 THEN 147 END;

0.000 : 1 : SELECT cat_nom FROM categories WHERE cat_id = '479'

0.000 : 1 : SELECT * FROM categories WHERE cat_id = '478';

0.000 : 1 : SELECT cat_nom FROM categories WHERE cat_id = '478'

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.016 : 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.000 : 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'