ASKESIS conseil de la création d'un FCPR de 10M€

0.00283525	DESC `actualites_themes`

0.00149875	SELECT DISTINCT `actualites_themes`.* FROM `actualites` LEFT JOIN `actualites_themes` ON FIND_IN_SET(actualites_themes.id,actualites.theme) WHERE 1  AND FIND_IN_SET('fr',`actualites`.`lang`) AND `actualites_themes`.`id` IS NOT NULL AND (`actualites`.etat = "en-ligne") ORDER BY libelle_fr

0.00036950	SELECT DISTINCT `actualites`.* FROM `actualites` LEFT JOIN `actualites_themes` ON FIND_IN_SET(actualites_themes.id,actualites.theme)  WHERE 1  AND FIND_IN_SET('fr',`actualites`.`lang`) AND (`actualites`.etat = "en-ligne")  AND `actualites`.id = '14'

0.00257625	SELECT MAX(update_time) FROM information_schema.tables WHERE table_schema = 'askesiyfrank' AND table_name = 'actualites'

0.00064450	SELECT * FROM `pages` WHERE (FIND_IN_SET('fr', lang) OR lang = '') AND `etat` = 'en-ligne' AND url <> '' AND groupe <> 'invisible' ORDER BY ordre > 0 DESC, ordre ASC, url ASC

0.00271200	DESC `expertises`

0.00051500	SELECT id, `expertises`.`titre_fr` AS titre, "" AS title, alias_fr AS alias FROM `expertises` WHERE 1  AND (`expertises`.etat = "en-ligne")   ORDER BY rang ASC

0.00134375	DESC `actualites`

0.00128475	DESC `actualites_themes`

0.00135350	SELECT DISTINCT `actualites_themes`.* FROM `actualites` LEFT JOIN `actualites_themes` ON FIND_IN_SET(actualites_themes.id,actualites.theme) WHERE 1  AND FIND_IN_SET('fr',`actualites`.`lang`) AND `actualites_themes`.`id` IS NOT NULL AND (`actualites`.etat = "en-ligne") ORDER BY libelle_fr

0.00046375	SELECT url, cible, alias_fr AS alias FROM pages WHERE etat = 'en-ligne'

0.00156350	DESC `actualites`

0.00046325	SELECT COUNT(*) FROM `actualites` WHERE 1  AND FIND_IN_SET('fr',`actualites`.`lang`) AND (`actualites`.etat = "en-ligne")

0.00048925	SELECT * FROM `actualites` WHERE 1  AND FIND_IN_SET('fr',`actualites`.`lang`) AND (`actualites`.etat = "en-ligne")   ORDER BY date DESC  LIMIT 0,10

0.00043525	SELECT url, cible, alias_en AS alias FROM pages WHERE etat = 'en-ligne'

0.01854825	Total: 15