0.000 seconds (0.000); 2.91 MB (2.911) - beforeSearch

SELECT t0.id AS pid,t0.pk AS pk,t0.pkb AS pkb,t0.parent_id AS parent,t0.author_id AS author,t0.author_session AS author_session,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.pkb
LEFT JOIN `#__users` AS t2 ON t2.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 <= '2020-10-24 03:44' )
  AND ( t1.publish_down = '0000-00-00 00:00:00' OR t1.publish_down >= '2020-10-24 03:44' )
  AND t0.cck = 'membre'
ORDER BY t2.name ASC
LIMIT 30, 30

SELECT COUNT(t0.id)
FROM `#__cck_core` AS t0
LEFT JOIN `#__content` AS t1 ON t1.id = t0.pkb
LEFT JOIN `#__users` AS t2 ON t2.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 <= '2020-10-24 03:44' )
  AND ( t1.publish_down = '0000-00-00 00:00:00' OR t1.publish_down >= '2020-10-24 03:44' )
  AND t0.cck = 'membre'

0.886 seconds (0.886); 3.01 MB (0.099) - afterSearch [Cache=OFF] = 72648 results.
0.944 seconds (0.058); 4.19 MB (1.175) - afterRender [Cache=OFF]

Users