TIGE FILETEE / TIREFOND / MANCHON

0.001 : Connexion BDD sur localhost:gimel

0.054 : 2 : SELECT * FROM gimel.registry

0.052 : 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.039 : 84 : SELECT * FROM registry

0.040 : 1 : SELECT dep_idDep FROM depots WHERE dep_defaut = 1;

0.082 : 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.041 : 10 : SELECT dho_day, dho_opening_hour, dho_closure_hour FROM depots_horaires WHERE dho_idDep = '2';

0.084 : 1 : SELECT * FROM categories WHERE cat_id = '335';

0.001 : 1 : SELECT cat_id FROM categories WHERE cat_filtre_enfants = 1 AND cat_id IN (329,330) ORDER BY cat_niveau ASC

0.078 : 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 = '329'

0.033 : 1 : SELECT * FROM categories WHERE cat_id = '335';

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

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

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 (329,330) 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 = '329'

1.926 : 17 : 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, GROUP_CONCAT(catp_libelle ORDER BY catp_id) as cat_perso_libelles, GROUP_CONCAT(catp_couleur ORDER BY catp_id) as cat_perso_couleurs, GROUP_CONCAT(catp_forcer_connexion ORDER BY catp_id) as cat_perso_forcer_connexion, GROUP_CONCAT(catp_produits_exclusif ORDER BY catp_id) as cat_perso_produits_exclusif, GROUP_CONCAT(catp_a_gestion_stock ORDER BY catp_id) as cat_perso_a_gestion_stock, GROUP_CONCAT(catp_type_client ORDER BY catp_id, '| ') as cat_perso_type_client, GROUP_CONCAT(catp_is_label ORDER BY catp_id) as cat_perso_is_label 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 = '') LEFT JOIN catalogues_personnalises_produits ON (catpp_prod_idArt = a.idArt) LEFT JOIN catalogues_personnalises ON (catp_id = catpp_catp_id AND catp_actif = 1) WHERE pde_idAd IN ('274509','274541','226191','24372','24380','24388','24396','209288','209296','209304','274541'0,'274541'1,'274541'2,'274541'3,'274541'4,'274541'5,'274541'6) GROUP BY pde_idAD ORDER BY CASE pde_idAD WHEN 274509 THEN 0 WHEN 274541 THEN 1 WHEN 226191 THEN 2 WHEN 24372 THEN 3 WHEN 24380 THEN 4 WHEN 24388 THEN 5 WHEN 24396 THEN 6 WHEN 209288 THEN 7 WHEN 209296 THEN 8 WHEN 209304 THEN 9 WHEN 209312 THEN 10 WHEN 209320 THEN 11 WHEN 209328 THEN 12 WHEN 209336 THEN 13 WHEN 209344 THEN 14 WHEN 209352 THEN 15 WHEN 209360 THEN 16 END;

0.001 : 1 : SELECT cat_nom FROM categories WHERE cat_id = '335'

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

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

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

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

0.024 : 1 : SELECT * FROM sliders WHERE sli_code='imglogin'

0.069 : 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.021 : 0 : SELECT * FROM sliders_images_complement WHERE comp_sli_img_id='22'

2.193 : 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.003 : 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.005 : 21 : SELECT * FROM cms

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' 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.000 : 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.028 : 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.001 : 1 : SELECT * FROM rgpd_cookies_parametres LEFT JOIN rgpd_cookies_parametres_lang ON (lrcp_id = rcp_id AND lang = 'fr')

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.001 : 0 : SELECT nec_valeur FROM gimel.negociants_config WHERE nec_module = 'listesAchats' AND nec_parametre = 'actif' AND nec_id_negociant = '69'