Thank you Klas for your help. I think that is it Seblod debugger but my debug site option is still NO (and Joomla one also). Here is what I'm seeing on content view :
SELECT t0.id AS pid,t0.pk AS pk,t0.pkb AS pkb,t0.parent_id AS
parent,t0.author_id AS author,t0.cck AS cck,t0.storage_location AS
loc,tt.id AS type_id,tt.alias AS type_alias
FROM `#__cck_core` AS t0
LEFT JOIN `#__content` AS t1 ON t1.id = t0.pk
LEFT JOIN `#__cck_core_types` AS tt ON tt.name = t0.cck
WHERE t1.state = 1
AND t1.access IN (1,1,5)
AND ( t1.publish_up = '0000-00-00 00:00:00' OR t1.publish_up <= '2016-10-10 12:14' )
AND ( t1.publish_down = '0000-00-00 00:00:00' OR t1.publish_down >= '2016-10-10 12:14' )
AND t0.cck = 'medaille'
ORDER BY t1.title ASC
SELECT COUNT(t0.id)
FROM `#__cck_core` AS t0
LEFT JOIN `#__content` AS t1 ON t1.id = t0.pk
LEFT JOIN `#__cck_core_types` AS tt ON tt.name = t0.cck
WHERE t1.state = 1
AND t1.access IN (1,1,5)
AND ( t1.publish_up = '0000-00-00 00:00:00' OR t1.publish_up <= '2016-10-10 12:14' )
AND ( t1.publish_down = '0000-00-00 00:00:00' OR t1.publish_down >= '2016-10-10 12:14' )
AND t0.cck = 'medaille'
0.004 seconds (0.004); 14.84 MB (14.842) - afterSearch [Cache=OFF] = 3 results.