Blocs, briques

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

0.000 : 0 : USE gimel_evodemo

0.000 : 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 = '16';

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

0.003 : 3 : 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 = '16'

0.001 : 1 : SELECT * FROM categories WHERE cat_id = '16';

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

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

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 (14,15) ORDER BY cat_niveau ASC

0.000 : 3 : 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 = '16'

0.681 : 96 : 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 ('74630','509627','74595','509637','74600','714595','714505','74615','509647','455165','509627'0,'509627'1,'509627'2,'509627'3,'509627'4,'509627'5,'509627'6,'509627'7,'509627'8,'509627'9,'74595'0,'74595'1,'74595'2,'74595'3,'74595'4,'74595'5,'74595'6,'74595'7,'74595'8,'74595'9,'509637'0,'509637'1,'509637'2,'509637'3,'509637'4,'509637'5,'509637'6,'509637'7,'509637'8,'509637'9,'74600'0,'74600'1,'74600'2,'74600'3,'74600'4,'74600'5,'74600'6,'74600'7,'74600'8,'74600'9,'714595'0,'714595'1,'714595'2,'714595'3,'714595'4,'714595'5,'714595'6,'714595'7,'714595'8,'714595'9,'714505'0,'714505'1,'714505'2,'714505'3,'714505'4,'714505'5,'714505'6,'714505'7,'714505'8,'714505'9,'74615'0,'74615'1,'74615'2,'74615'3,'74615'4,'74615'5,'74615'6,'74615'7,'74615'8,'74615'9,'509647'0,'509647'1,'509647'2,'509647'3,'509647'4,'509647'5,'509647'6,'509647'7,'509647'8,'509647'9,'455165'0,'455165'1,'455165'2,'455165'3,'455165'4,'455165'5) GROUP BY pde_idAD ORDER BY CASE pde_idAD WHEN 74630 THEN 0 WHEN 509627 THEN 1 WHEN 74595 THEN 2 WHEN 509637 THEN 3 WHEN 74600 THEN 4 WHEN 714595 THEN 5 WHEN 714505 THEN 6 WHEN 74615 THEN 7 WHEN 509647 THEN 8 WHEN 455165 THEN 9 WHEN 509737 THEN 10 WHEN 74590 THEN 11 WHEN 509617 THEN 12 WHEN 1204126 THEN 13 WHEN 1204121 THEN 14 WHEN 1204136 THEN 15 WHEN 1204131 THEN 16 WHEN 1204156 THEN 17 WHEN 1204151 THEN 18 WHEN 1841958 THEN 19 WHEN 1841484 THEN 20 WHEN 1841976 THEN 21 WHEN 1841502 THEN 22 WHEN 1236095 THEN 23 WHEN 1646925 THEN 24 WHEN 2467561 THEN 25 WHEN 2275509 THEN 26 WHEN 1693583 THEN 27 WHEN 888785 THEN 28 WHEN 790971 THEN 29 WHEN 790976 THEN 30 WHEN 790966 THEN 31 WHEN 1784129 THEN 32 WHEN 945264 THEN 33 WHEN 1842198 THEN 34 WHEN 1841724 THEN 35 WHEN 1842204 THEN 36 WHEN 1841730 THEN 37 WHEN 1334782 THEN 38 WHEN 1334692 THEN 39 WHEN 1334707 THEN 40 WHEN 1334727 THEN 41 WHEN 1334752 THEN 42 WHEN 2468359 THEN 43 WHEN 2467498 THEN 44 WHEN 1125902 THEN 45 WHEN 1125907 THEN 46 WHEN 1125887 THEN 47 WHEN 1125892 THEN 48 WHEN 1125897 THEN 49 WHEN 50197 THEN 50 WHEN 50202 THEN 51 WHEN 1204106 THEN 52 WHEN 1204111 THEN 53 WHEN 1204076 THEN 54 WHEN 1204086 THEN 55 WHEN 1204091 THEN 56 WHEN 1204101 THEN 57 WHEN 1204176 THEN 58 WHEN 1204181 THEN 59 WHEN 1204186 THEN 60 WHEN 1841316 THEN 61 WHEN 1841838 THEN 62 WHEN 1841364 THEN 63 WHEN 1841856 THEN 64 WHEN 1841886 THEN 65 WHEN 1841412 THEN 66 WHEN 1841892 THEN 67 WHEN 1841418 THEN 68 WHEN 1204171 THEN 69 WHEN 50127 THEN 70 WHEN 50112 THEN 71 WHEN 1842078 THEN 72 WHEN 1841604 THEN 73 WHEN 1842084 THEN 74 WHEN 1841610 THEN 75 WHEN 1842096 THEN 76 WHEN 1841622 THEN 77 WHEN 1842120 THEN 78 WHEN 1841646 THEN 79 WHEN 1842126 THEN 80 WHEN 1841652 THEN 81 WHEN 1001725 THEN 82 WHEN 1001730 THEN 83 WHEN 1001745 THEN 84 WHEN 1507671 THEN 85 WHEN 1274637 THEN 86 WHEN 1274642 THEN 87 WHEN 1001720 THEN 88 WHEN 855794 THEN 89 WHEN 790916 THEN 90 WHEN 790921 THEN 91 WHEN 790926 THEN 92 WHEN 790936 THEN 93 WHEN 1004540 THEN 94 WHEN 1004545 THEN 95 END;

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

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

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

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

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

0.000 : 0 : SELECT * FROM sliders WHERE sli_code='imglogin'

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