Hi
When you activate the joomla debug mode you can see that for each seblod list you almost have a duplicate query
the first one is the main query itself :
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 `zkx3r_cck_core` AS t0
LEFT JOIN `zkx3r_content` AS t1 ON t1.id = t0.pk
LEFT JOIN `zkx3r_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 <= '2018-07-04 16:34' ) AND ( t1.publish_down = '0000-00-00 00:00:00' OR t1.publish_down >= '2018-07-04 16:34' ) AND t0.cck = 'produit'
ORDER BY t1.title ASC LIMIT 25
and the second one (just after the first one) is almost the same but to get the count of the results:
SELECT COUNT(t0.id)
FROM `zkx3r_cck_core` AS t0
LEFT JOIN `zkx3r_content` AS t1 ON t1.id = t0.pk
LEFT JOIN `zkx3r_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 <= '2018-07-04 16:34' ) AND ( t1.publish_down = '0000-00-00 00:00:00' OR t1.publish_down >= '2018-07-04 16:34' ) AND t0.cck = 'produit'
on large database (here 220 000 products) this duplicate time makes the page very slow to appear.
Can we deactivate the second query please ?
thanks
cyril