Climatisation

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 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 = '68';

0.000 : 0 : SELECT cat_id FROM categories WHERE cat_filtre_enfants = 1 AND cat_id IN (8) 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 = '68'

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

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

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 (8) 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 = '68'

0.085 : 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 ('710035','706611','710131','710179','692035','2043124','709075','709203','707555','709219','706611'0,'706611'1,'706611'2,'706611'3,'706611'4,'706611'5,'706611'6,'706611'7,'706611'8,'706611'9,'710131'0,'710131'1,'710131'2,'710131'3,'710131'4,'710131'5,'710131'6,'710131'7,'710131'8,'710131'9,'710179'0,'710179'1,'710179'2,'710179'3,'710179'4,'710179'5,'710179'6,'710179'7,'710179'8,'710179'9,'692035'0,'692035'1,'692035'2,'692035'3,'692035'4,'692035'5,'692035'6,'692035'7,'692035'8,'692035'9,'2043124'0,'2043124'1,'2043124'2,'2043124'3,'2043124'4,'2043124'5,'2043124'6,'2043124'7,'2043124'8,'2043124'9,'709075'0,'709075'1,'709075'2,'709075'3,'709075'4,'709075'5,'709075'6,'709075'7,'709075'8,'709075'9,'709203'0,'709203'1,'709203'2,'709203'3,'709203'4,'709203'5,'709203'6,'709203'7,'709203'8,'709203'9,'707555'0,'707555'1,'707555'2,'707555'3,'707555'4,'707555'5,'707555'6,'707555'7,'707555'8,'707555'9,'709219'0,'709219'1,'709219'2,'709219'3,'709219'4,'709219'5,'709219'6,'709219'7,'709219'8,'709219'9,'706611'00,'706611'01,'706611'02,'706611'03,'706611'04,'706611'05,'706611'06,'706611'07,'706611'08,'706611'09,'706611'10,'706611'11,'706611'12,'706611'13,'706611'14,'706611'15,'706611'16,'706611'17,'706611'18,'706611'19,'706611'20,'706611'21,'706611'22,'706611'23,'706611'24,'706611'25,'706611'26,'706611'27,'706611'28,'706611'29,'706611'30,'706611'31,'706611'32,'706611'33,'706611'34,'706611'35,'706611'36,'706611'37,'706611'38,'706611'39,'706611'40,'706611'41,'706611'42,'706611'43,'706611'44,'706611'45,'706611'46,'706611'47) GROUP BY pde_idAD ORDER BY CASE pde_idAD WHEN 710035 THEN 0 WHEN 706611 THEN 1 WHEN 710131 THEN 2 WHEN 710179 THEN 3 WHEN 692035 THEN 4 WHEN 2043124 THEN 5 WHEN 709075 THEN 6 WHEN 709203 THEN 7 WHEN 707555 THEN 8 WHEN 709219 THEN 9 WHEN 709011 THEN 10 WHEN 709123 THEN 11 WHEN 709187 THEN 12 WHEN 708963 THEN 13 WHEN 708915 THEN 14 WHEN 708979 THEN 15 WHEN 708995 THEN 16 WHEN 709027 THEN 17 WHEN 709043 THEN 18 WHEN 709059 THEN 19 WHEN 708931 THEN 20 WHEN 708947 THEN 21 WHEN 708195 THEN 22 WHEN 708211 THEN 23 WHEN 709091 THEN 24 WHEN 709155 THEN 25 WHEN 709107 THEN 26 WHEN 709171 THEN 27 WHEN 707299 THEN 28 WHEN 709459 THEN 29 WHEN 2319765 THEN 30 WHEN 266531 THEN 31 WHEN 266563 THEN 32 WHEN 266515 THEN 33 WHEN 266547 THEN 34 WHEN 266579 THEN 35 WHEN 266675 THEN 36 WHEN 2116162 THEN 37 WHEN 2116179 THEN 38 WHEN 678851 THEN 39 WHEN 2319731 THEN 40 WHEN 706307 THEN 41 WHEN 670387 THEN 42 WHEN 670275 THEN 43 WHEN 666003 THEN 44 WHEN 669811 THEN 45 WHEN 710211 THEN 46 WHEN 738131 THEN 47 WHEN 2043379 THEN 48 WHEN 2043413 THEN 49 WHEN 2319782 THEN 50 WHEN 2043158 THEN 51 WHEN 678739 THEN 52 WHEN 1669596 THEN 53 WHEN 266851 THEN 54 WHEN 265283 THEN 55 WHEN 2102188 THEN 56 WHEN 2043107 THEN 57 WHEN 2043090 THEN 58 WHEN 710163 THEN 59 WHEN 2043039 THEN 60 WHEN 2042988 THEN 61 WHEN 710195 THEN 62 WHEN 2043073 THEN 63 WHEN 2043056 THEN 64 WHEN 2215198 THEN 65 WHEN 706435 THEN 66 WHEN 1874174 THEN 67 WHEN 1893711 THEN 68 WHEN 715027 THEN 69 WHEN 2243236 THEN 70 WHEN 706499 THEN 71 WHEN 1608109 THEN 72 WHEN 1608126 THEN 73 WHEN 710627 THEN 74 WHEN 732355 THEN 75 WHEN 703075 THEN 76 WHEN 264467 THEN 77 WHEN 264499 THEN 78 WHEN 266355 THEN 79 WHEN 264483 THEN 80 WHEN 1457064 THEN 81 WHEN 670371 THEN 82 WHEN 666451 THEN 83 WHEN 715075 THEN 84 WHEN 708003 THEN 85 WHEN 2125718 THEN 86 WHEN 2119628 THEN 87 WHEN 2119560 THEN 88 WHEN 2119594 THEN 89 WHEN 2119543 THEN 90 WHEN 2119577 THEN 91 WHEN 2119611 THEN 92 WHEN 705603 THEN 93 WHEN 1967310 THEN 94 WHEN 269363 THEN 95 WHEN 1832812 THEN 96 WHEN 729859 THEN 97 WHEN 2095930 THEN 98 WHEN 732211 THEN 99 WHEN 2043226 THEN 100 WHEN 2043192 THEN 101 WHEN 710435 THEN 102 WHEN 2043328 THEN 103 WHEN 2043957 THEN 104 WHEN 2043940 THEN 105 WHEN 703411 THEN 106 WHEN 703347 THEN 107 WHEN 700451 THEN 108 WHEN 702915 THEN 109 WHEN 703315 THEN 110 WHEN 706131 THEN 111 WHEN 703443 THEN 112 WHEN 265059 THEN 113 WHEN 265027 THEN 114 WHEN 265043 THEN 115 WHEN 265075 THEN 116 WHEN 265235 THEN 117 WHEN 265219 THEN 118 WHEN 267251 THEN 119 WHEN 708131 THEN 120 WHEN 708867 THEN 121 WHEN 708803 THEN 122 WHEN 2015090 THEN 123 WHEN 732051 THEN 124 WHEN 732275 THEN 125 WHEN 679011 THEN 126 WHEN 678611 THEN 127 WHEN 682867 THEN 128 WHEN 665091 THEN 129 WHEN 653779 THEN 130 WHEN 653667 THEN 131 WHEN 653683 THEN 132 WHEN 653699 THEN 133 WHEN 653715 THEN 134 WHEN 653731 THEN 135 WHEN 653747 THEN 136 WHEN 653763 THEN 137 WHEN 1835927 THEN 138 WHEN 1835944 THEN 139 WHEN 1835961 THEN 140 WHEN 665763 THEN 141 WHEN 665779 THEN 142 WHEN 665795 THEN 143 WHEN 665827 THEN 144 WHEN 665059 THEN 145 WHEN 1453448 THEN 146 WHEN 1453464 THEN 147 END;

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

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

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

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