BLOC PORTE / PORTE SEULE

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

0.000 : 0 : USE gimel_novamat

0.001 : 1 : SELECT * FROM gimel.negociants WHERE neg_schema = 'novamat';

0.000 : 1 : SELECT DATABASE()

0.001 : 84 : 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 = '2';

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

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

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

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

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

0.000 : 0 : SELECT * FROM categories WHERE cat_id = '0';

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

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

0.038 : 48 : 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 evo_article_detail ad2 INNER JOIN evo_stock s2 ON (ad2.idAD = s2.idAD) WHERE ad2.idArt = p.prod_idArt ), 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 ('260488','260496','260504','260512','260520','260528','354326','260536','354334','260544','260496'0,'260496'1,'260496'2,'260496'3,'260496'4,'260496'5,'260496'6,'260496'7,'260496'8,'260496'9,'260504'0,'260504'1,'260504'2,'260504'3,'260504'4,'260504'5,'260504'6,'260504'7,'260504'8,'260504'9,'260512'0,'260512'1,'260512'2,'260512'3,'260512'4,'260512'5,'260512'6,'260512'7,'260512'8,'260512'9,'260520'0,'260520'1,'260520'2,'260520'3,'260520'4,'260520'5,'260520'6,'260520'7) GROUP BY pde_idAD ORDER BY CASE pde_idAD WHEN 260488 THEN 0 WHEN 260496 THEN 1 WHEN 260504 THEN 2 WHEN 260512 THEN 3 WHEN 260520 THEN 4 WHEN 260528 THEN 5 WHEN 354326 THEN 6 WHEN 260536 THEN 7 WHEN 354334 THEN 8 WHEN 260544 THEN 9 WHEN 260424 THEN 10 WHEN 260432 THEN 11 WHEN 260440 THEN 12 WHEN 260448 THEN 13 WHEN 260456 THEN 14 WHEN 260464 THEN 15 WHEN 260472 THEN 16 WHEN 260480 THEN 17 WHEN 268339 THEN 18 WHEN 268347 THEN 19 WHEN 268355 THEN 20 WHEN 268363 THEN 21 WHEN 268371 THEN 22 WHEN 268379 THEN 23 WHEN 268443 THEN 24 WHEN 268451 THEN 25 WHEN 268459 THEN 26 WHEN 268467 THEN 27 WHEN 268483 THEN 28 WHEN 268491 THEN 29 WHEN 268499 THEN 30 WHEN 268507 THEN 31 WHEN 268275 THEN 32 WHEN 268283 THEN 33 WHEN 268291 THEN 34 WHEN 268299 THEN 35 WHEN 268315 THEN 36 WHEN 268323 THEN 37 WHEN 261586 THEN 38 WHEN 261594 THEN 39 WHEN 261602 THEN 40 WHEN 261610 THEN 41 WHEN 354342 THEN 42 WHEN 274397 THEN 43 WHEN 274405 THEN 44 WHEN 261618 THEN 45 WHEN 261626 THEN 46 WHEN 315813 THEN 47 END;

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

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

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

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='7' AND sli_img_active=1 ORDER BY sli_img_ordre ASC

0.000 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='22'

0.024 : 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 : 1 : SELECT * FROM tracking_analytics WHERE trk_actif = 1

0.001 : 343 : SELECT cat_id,cat_id_parent,cat_niveau,cat_nom,cat_enfants FROM categories ORDER BY cat_ordre ASC

0.002 : 13 : 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.001 : 21 : SELECT * FROM cms

0.002 : 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 = 'footer_nav' AND md.actif = 1 ORDER BY ordre_rubrique ASC

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 = 'footer_nav_compte' AND md.actif = 1 ORDER BY ordre_rubrique ASC

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_legal' AND md.actif = 1 ORDER BY ordre_rubrique ASC

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