| 2221668 | dbname | localhost | dbname | Query | 1 | Copying to tmp table | SELECT DISTINCT i.*,c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS | 0.000 |

SELECT DISTINCT i.*,c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams 
  FROM mydb_k2_items as i RIGHT JOIN mydb_k2_categories c 
  ON c.id = i.catid 
  WHERE i.published = 1 
  AND i.access IN(1,1,2,3,6,7) 
  AND i.trash = 0 
  AND c.published = 1 
  AND c.access IN(1,1,2,3,6,7)  
  AND c.trash = 0 
  AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2018-01-17 16:21:26' ) 
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2018-01-17 16:21:26' ) 
  AND i.catid IN(18) 
  ORDER BY i.created DESC 
  LIMIT 0, 10

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	const	PRIMARY,category,published,access,trash	PRIMARY	4	const	1	100.00	
1	SIMPLE	i	index	item,catid	created	8	NULL	70	100.00	Using where

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
After opening tables	0.00 ms
Waiting for query cache lock	0.00 ms
After opening tables	0.02 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.12 ms
preparing	0.06 ms
executing	0.01 ms
Sorting result	0.01 ms
Sending data	0.23 ms
Waiting for query cache lock	0.00 ms
Sending data	0.07 ms
Waiting for query cache lock	0.00 ms
Sending data	0.12 ms
Waiting for query cache lock	0.00 ms
Sending data	0.10 ms
Waiting for query cache lock	0.00 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.00 ms

19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
18	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_k2_content/helper.php:286
17	modK2ContentHelper::getItems()	JROOT/modules/mod_k2_content/mod_k2_content.php:82
16	include JROOT/modules/mod_k2_content/mod_k2_content.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/modules/mod_sptab/helper.php:31
14	modspTabHelper::getTabs()	JROOT/modules/mod_sptab/mod_sptab.php:84
13	include JROOT/modules/mod_sptab/mod_sptab.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Même appel que celui de la ligne ci-dessous.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:610
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:782
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1117
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

SELECT DISTINCT i.*,c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams 
  FROM mydb_k2_items as i RIGHT JOIN pdyqm_k2_categories c 
  ON c.id = i.catid 
  WHERE i.published = 1 
  AND i.access IN(1,1,2,3,6,7) 
  AND i.trash = 0 
  AND c.published = 1 
  AND c.access IN(1,1,2,3,6,7)  
  AND c.trash = 0 
  AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2018-01-18 11:49:34' ) 
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2018-01-18 11:49:34' ) 
  AND i.catid IN (2,3,4,6,7,8,9,10,11,14,21) 
  ORDER BY i.id DESC 
  LIMIT 0, 5

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
After opening tables	0.00 ms
Waiting for query cache lock	0.00 ms
After opening tables	0.02 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.17 ms
preparing	0.03 ms
executing	0.00 ms
Copying to tmp table	0.16 ms
Copying to tmp table	359.22 ms
Sorting result	14.43 ms
Sending data	0.09 ms
Waiting for query cache lock	0.00 ms
Sending data	0.04 ms
Waiting for query cache lock	0.00 ms
Sending data	0.01 ms
end	0.01 ms
removing tmp table	4.12 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.00 ms

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
15	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_k2_content/helper.php:286
14	modK2ContentHelper::getItems()	JROOT/modules/mod_k2_content/mod_k2_content.php:82
13	include JROOT/modules/mod_k2_content/mod_k2_content.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Même appel que celui de la ligne ci-dessous.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:610
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:782
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1117
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49