Joomla! Debug Console

Time

Memory

59 Queries Logged 42.4 ms

1. Query Time: 0.27 ms

   SELECT `data`
   
     FROM `j3du8_session`
   
     WHERE `session_id` = '7jqge66icu757vposfec29fqk6'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	j3du8_session	const	PRIMARY	PRIMARY	602	const	1

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   JROOT/libraries/joomla/session/storage/database.php:46

   JROOT/libraries/joomla/session/session.php:658

   JROOT/libraries/joomla/session/session.php:596

   JROOT/libraries/cms/application/cms.php:672

   JROOT/libraries/cms/application/cms.php:131

   JROOT/libraries/cms/application/site.php:63

   JROOT/libraries/cms/application/cms.php:332

   JROOT/libraries/joomla/factory.php:124

   JROOT/index.php:37

   [Add xdebug.file_link_format directive to your php.ini file to have links for files]

   ---

2. Query Time: 0.24 ms After last query: 1.39 ms

   DELETE 
   
     FROM `j3du8_session`
   
     WHERE `time` < '1527312569'

   Explain

   EXPLAIN not possible on query: DELETE FROM `j3du8_session` WHERE `time` < '1527312569'

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   JROOT/libraries/cms/application/cms.php:689

   JROOT/libraries/cms/application/cms.php:131

   JROOT/libraries/cms/application/site.php:63

   JROOT/libraries/cms/application/cms.php:332

   JROOT/libraries/joomla/factory.php:124

   JROOT/index.php:37

   [Add xdebug.file_link_format directive to your php.ini file to have links for files]

   ---

3. Query Time: 0.21 ms After last query: 0.16 ms

   SELECT `session_id`
   
     FROM `j3du8_session`
   
     WHERE `session_id` = '7jqge66icu757vposfec29fqk6' 
     LIMIT 0, 1

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	j3du8_session	const	PRIMARY	PRIMARY	602	const	1	Using index

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   JROOT/libraries/cms/application/cms.php:175

   JROOT/libraries/cms/application/cms.php:698

   JROOT/libraries/cms/application/cms.php:131

   JROOT/libraries/cms/application/site.php:63

   JROOT/libraries/cms/application/cms.php:332

   JROOT/libraries/joomla/factory.php:124

   JROOT/index.php:37

   [Add xdebug.file_link_format directive to your php.ini file to have links for files]

   ---

4. Query Time: 2.46 ms After last query: 0.11 ms

   INSERT INTO `j3du8_session`
   (`session_id`, `client_id`, `time`) 
     VALUES 
   ('7jqge66icu757vposfec29fqk6', 0, '1527313469')

   Explain

   EXPLAIN not possible on query: INSERT INTO `j3du8_session` (`session_id`, `client_id`, `time`) VALUES ('7jqge66icu757vposfec29fqk6', 0, '1527313469')

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   JROOT/libraries/cms/application/cms.php:207

   JROOT/libraries/cms/application/cms.php:698

   JROOT/libraries/cms/application/cms.php:131

   JROOT/libraries/cms/application/site.php:63

   JROOT/libraries/cms/application/cms.php:332

   JROOT/libraries/joomla/factory.php:124

   JROOT/index.php:37

   [Add xdebug.file_link_format directive to your php.ini file to have links for files]

   ---

5. Query Time: 0.35 ms After last query: 3.68 ms

   SELECT extension_id AS id, element AS "option", params, enabled
   
     FROM j3du8_extensions
   
     WHERE `type` = 'component' 
     AND `element` = 'com_users'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	j3du8_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	Using index condition; Using where

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   JROOT/libraries/joomla/cache/controller/callback.php:158

   JROOT/libraries/cms/component/helper.php:396

   JROOT/libraries/cms/component/helper.php:43

   JROOT/libraries/cms/component/helper.php:91

   JROOT/libraries/cms/application/site.php:541

   JROOT/libraries/cms/application/site.php:196

   JROOT/libraries/cms/application/cms.php:255

   JROOT/index.php:40

   [Add xdebug.file_link_format directive to your php.ini file to have links for files]

   ---

6. Query Time: 0.29 ms After last query: 1.13 ms

   SELECT b.id
   
     FROM j3du8_usergroups AS a
   
     LEFT JOIN j3du8_usergroups AS b 
     ON b.lft <= a.lft 
     AND b.rgt >= a.rgt
   
     WHERE a.id = 1

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
   1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	1	Using where; Using index

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   JROOT/libraries/joomla/access/access.php:336

   JROOT/libraries/joomla/access/access.php:405

   JROOT/libraries/joomla/user/user.php:420

   JROOT/libraries/cms/plugin/helper.php:298

   JROOT/libraries/cms/plugin/helper.php:165

   JROOT/libraries/cms/application/site.php:546

   JROOT/libraries/cms/application/site.php:196

   JROOT/libraries/cms/application/cms.php:255

   JROOT/index.php:40

   [Add xdebug.file_link_format directive to your php.ini file to have links for files]

   ---

7. Query Time: 0.20 ms After last query: 0.55 ms

   SELECT id, rules
   
     FROM `j3du8_viewlevels`

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	j3du8_viewlevels	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	3

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   JROOT/libraries/joomla/access/access.php:422

   JROOT/libraries/joomla/user/user.php:420

   JROOT/libraries/cms/plugin/helper.php:298

   JROOT/libraries/cms/plugin/helper.php:165

   JROOT/libraries/cms/application/site.php:546

   JROOT/libraries/cms/application/site.php:196

   JROOT/libraries/cms/application/cms.php:255

   JROOT/index.php:40

   [Add xdebug.file_link_format directive to your php.ini file to have links for files]

   ---

8. Query Time: 0.55 ms After last query: 0.18 ms

   SELECT folder AS type, element AS name, params
   
     FROM j3du8_extensions
   
     WHERE enabled >= 1 
     AND type ='plugin' 
     AND state >= 0 
     AND access IN (1,1)
   
     ORDER BY ordering

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	j3du8_extensions	ref	extension	extension	62	const	75	Using index condition; Using where; Using filesort

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   JROOT/libraries/cms/plugin/helper.php:312

   JROOT/libraries/cms/plugin/helper.php:165

   JROOT/libraries/cms/application/site.php:546

   JROOT/libraries/cms/application/site.php:196

   JROOT/libraries/cms/application/cms.php:255

   JROOT/index.php:40

   [Add xdebug.file_link_format directive to your php.ini file to have links for files]

   ---

9. Query Time: 0.24 ms After last query: 0.44 ms

   SELECT extension_id AS id, element AS "option", params, enabled
   
     FROM j3du8_extensions
   
     WHERE `type` = 'component' 
     AND `element` = 'com_languages'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	j3du8_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	Using index condition; Using where

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   JROOT/libraries/joomla/cache/controller/callback.php:158

   JROOT/libraries/cms/component/helper.php:396

   JROOT/libraries/cms/component/helper.php:43

   JROOT/libraries/cms/component/helper.php:91

   JROOT/libraries/cms/application/site.php:599

   JROOT/libraries/cms/application/site.php:196

   JROOT/libraries/cms/application/cms.php:255

   JROOT/index.php:40

   [Add xdebug.file_link_format directive to your php.ini file to have links for files]

   ---

10. Query Time: 0.33 ms After last query: 16.98 ms

    SELECT extension_id AS id, element AS "option", params, enabled
    
      FROM j3du8_extensions
    
      WHERE `type` = 'component' 
      AND `element` = 'com_k2'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	j3du8_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	Using index condition; Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/libraries/joomla/cache/controller/callback.php:158

    JROOT/libraries/cms/component/helper.php:396

    JROOT/libraries/cms/component/helper.php:43

    JROOT/libraries/cms/component/helper.php:91

    JROOT/plugins/system/k2/k2.php:435

    JROOT/libraries/joomla/event/event.php:71

    JROOT/libraries/joomla/event/dispatcher.php:162

    JROOT/libraries/joomla/application/base.php:106

    JROOT/libraries/cms/application/cms.php:587

    JROOT/libraries/cms/application/site.php:620

    JROOT/libraries/cms/application/site.php:196

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

11. Query Time: 0.58 ms After last query: 4.47 ms

    SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
    
      FROM j3du8_menu AS m
    
      LEFT JOIN j3du8_extensions AS e 
      ON m.component_id = e.extension_id
    
      WHERE m.published = 1 
      AND m.parent_id > 0 
      AND m.client_id = 0
    
      ORDER BY m.lft

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	22	Using index condition; Using where; Using filesort
    1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	mmotorsp_DfbdAb2jes.m.component_id	1	Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/libraries/cms/menu/site.php:47

    JROOT/libraries/cms/menu/menu.php:64

    JROOT/libraries/cms/menu/menu.php:118

    JROOT/libraries/cms/application/cms.php:357

    JROOT/libraries/cms/application/site.php:250

    JROOT/libraries/cms/router/site.php:210

    JROOT/libraries/cms/router/router.php:391

    JROOT/libraries/cms/router/router.php:184

    JROOT/libraries/cms/router/site.php:82

    JROOT/libraries/cms/application/cms.php:1022

    JROOT/libraries/cms/application/site.php:720

    JROOT/libraries/cms/application/site.php:202

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

12. Query Time: 0.40 ms After last query: 2.60 ms

    SELECT id, home, template, s.params
    
      FROM j3du8_template_styles as s
    
      LEFT JOIN j3du8_extensions as e 
      ON e.element=s.template 
      AND e.type='template' 
      AND e.client_id=s.client_id
    
      WHERE s.client_id = 0 
      AND e.enabled = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	9	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	mmotorsp_DfbdAb2jes.s.template,const	1	Using index condition; Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/libraries/cms/application/site.php:457

    JROOT/libraries/cms/html/html.php:336

    JROOT/libraries/cms/html/html.php:682

    JROOT/libraries/cms/html/html.php:238

    JROOT/libraries/cms/html/html.php:140

    JROOT/libraries/cms/html/jquery.php:55

    JROOT/libraries/cms/html/html.php:238

    JROOT/libraries/cms/html/html.php:140

    JROOT/plugins/system/jquery/jquery.php:40

    JROOT/libraries/joomla/event/event.php:71

    JROOT/libraries/joomla/event/dispatcher.php:162

    JROOT/libraries/joomla/application/base.php:106

    JROOT/libraries/cms/application/cms.php:1031

    JROOT/libraries/cms/application/site.php:720

    JROOT/libraries/cms/application/site.php:202

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

13. Query Time: 0.26 ms After last query: 1.24 ms

    SELECT extension_id AS id, element AS "option", params, enabled
    
      FROM j3du8_extensions
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	j3du8_extensions	ref	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	Using index condition

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/libraries/joomla/cache/controller/callback.php:158

    JROOT/libraries/cms/library/helper.php:156

    JROOT/libraries/cms/library/helper.php:47

    JROOT/libraries/cms/library/helper.php:90

    JROOT/libraries/cms/version/version.php:179

    JROOT/libraries/joomla/factory.php:734

    JROOT/libraries/joomla/factory.php:215

    JROOT/libraries/cms/html/html.php:703

    JROOT/libraries/cms/html/html.php:238

    JROOT/libraries/cms/html/html.php:140

    JROOT/libraries/cms/html/jquery.php:55

    JROOT/libraries/cms/html/html.php:238

    JROOT/libraries/cms/html/html.php:140

    JROOT/plugins/system/jquery/jquery.php:40

    JROOT/libraries/joomla/event/event.php:71

    JROOT/libraries/joomla/event/dispatcher.php:162

    JROOT/libraries/joomla/application/base.php:106

    JROOT/libraries/cms/application/cms.php:1031

    JROOT/libraries/cms/application/site.php:720

    JROOT/libraries/cms/application/site.php:202

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

14. Query Time: 1.04 ms After last query: 0.21 ms

    UPDATE `j3du8_extensions`
    
      SET `params` = '{\"mediaversion\":\"89a54a85c616eaee2a4186d8793736bf\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explain

    EXPLAIN not possible on query: UPDATE `j3du8_extensions` SET `params` = '{\"mediaversion\":\"89a54a85c616eaee2a4186d8793736bf\"}' WHERE `type` = 'library' AND `element` = 'joomla'

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/libraries/cms/library/helper.php:119

    JROOT/libraries/cms/version/version.php:230

    JROOT/libraries/cms/version/version.php:189

    JROOT/libraries/joomla/factory.php:734

    JROOT/libraries/joomla/factory.php:215

    JROOT/libraries/cms/html/html.php:703

    JROOT/libraries/cms/html/html.php:238

    JROOT/libraries/cms/html/html.php:140

    JROOT/libraries/cms/html/jquery.php:55

    JROOT/libraries/cms/html/html.php:238

    JROOT/libraries/cms/html/html.php:140

    JROOT/plugins/system/jquery/jquery.php:40

    JROOT/libraries/joomla/event/event.php:71

    JROOT/libraries/joomla/event/dispatcher.php:162

    JROOT/libraries/joomla/application/base.php:106

    JROOT/libraries/cms/application/cms.php:1031

    JROOT/libraries/cms/application/site.php:720

    JROOT/libraries/cms/application/site.php:202

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

15. Query Time: 0.25 ms After last query: 4.23 ms

    SELECT *
    
      FROM j3du8_languages
    
      WHERE published=1
    
      ORDER BY ordering ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	j3du8_languages	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where; Using filesort

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/libraries/joomla/language/helper.php:166

    JROOT/libraries/cms/application/site.php:307

    JROOT/components/com_k2/helpers/utilities.php:315

    JROOT/administrator/components/com_k2/helpers/html.php:56

    JROOT/plugins/system/k2/k2.php:55

    JROOT/libraries/joomla/event/event.php:71

    JROOT/libraries/joomla/event/dispatcher.php:162

    JROOT/libraries/joomla/application/base.php:106

    JROOT/libraries/cms/application/cms.php:1031

    JROOT/libraries/cms/application/site.php:720

    JROOT/libraries/cms/application/site.php:202

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

16. Query Time: 0.27 ms After last query: 2.80 ms

    SELECT extension_id AS id, element AS "option", params, enabled
    
      FROM j3du8_extensions
    
      WHERE `type` = 'component' 
      AND `element` = 'com_youtubegallery'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	j3du8_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	Using index condition; Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/libraries/joomla/cache/controller/callback.php:158

    JROOT/libraries/cms/component/helper.php:396

    JROOT/libraries/cms/component/helper.php:43

    JROOT/libraries/cms/component/helper.php:91

    JROOT/libraries/cms/application/site.php:299

    JROOT/libraries/cms/application/site.php:122

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

17. Query Time: 1.77 ms After last query: 22.35 ms
    Duplicate queries: #18

    SELECT `value` 
      FROM `j3du8_youtubegallery_settings` 
      WHERE `option`="errorreporting" 
      LIMIT 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_youtubegallery/includes/misc.php:1823

    JROOT/components/com_youtubegallery/models/youtubegallery.php:44

    JROOT/libraries/legacy/view/legacy.php:398

    JROOT/components/com_youtubegallery/views/youtubegallery/view.html.php:28

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_youtubegallery/youtubegallery.php:20

    JROOT/libraries/cms/component/helper.php:352

    JROOT/libraries/cms/component/helper.php:332

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

18. Query Time: 0.18 ms After last query: 0.08 ms
    Duplicate queries: #17

    SELECT `value` 
      FROM `j3du8_youtubegallery_settings` 
      WHERE `option`="errorreporting" 
      LIMIT 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_youtubegallery/includes/misc.php:1824

    JROOT/components/com_youtubegallery/models/youtubegallery.php:44

    JROOT/libraries/legacy/view/legacy.php:398

    JROOT/components/com_youtubegallery/views/youtubegallery/view.html.php:28

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_youtubegallery/youtubegallery.php:20

    JROOT/libraries/cms/component/helper.php:352

    JROOT/libraries/cms/component/helper.php:332

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

19. Query Time: 7.23 ms After last query: 68.36 ms
    Duplicate queries: #20

    SELECT j3du8_youtubegallery_videolists.id AS id, j3du8_youtubegallery_videolists.listname AS listname, j3du8_youtubegallery_videolists.videolist AS videolist, j3du8_youtubegallery_videolists.catid AS catid, j3du8_youtubegallery_videolists.updateperiod AS updateperiod, j3du8_youtubegallery_videolists.lastplaylistupdate AS lastplaylistupdate, COUNT(j3du8_youtubegallery_videos.listid) AS TotalVideos 
      FROM `j3du8_youtubegallery_videolists` 
      LEFT JOIN j3du8_youtubegallery_videos 
      ON j3du8_youtubegallery_videos.listid=j3du8_youtubegallery_videolists.id 
      AND j3du8_youtubegallery_videos.isvideo 
      WHERE j3du8_youtubegallery_videolists.id=1  
      GROUP BY `id` 
      LIMIT 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	j3du8_youtubegallery_videolists	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1
    1	SIMPLE	j3du8_youtubegallery_videos	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_youtubegallery/includes/misc.php:46

    JROOT/components/com_youtubegallery/models/youtubegallery.php:107

    JROOT/libraries/legacy/view/legacy.php:398

    JROOT/components/com_youtubegallery/views/youtubegallery/view.html.php:28

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_youtubegallery/youtubegallery.php:20

    JROOT/libraries/cms/component/helper.php:352

    JROOT/libraries/cms/component/helper.php:332

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

20. Query Time: 0.26 ms After last query: 0.13 ms
    Duplicate queries: #19

    SELECT j3du8_youtubegallery_videolists.id AS id, j3du8_youtubegallery_videolists.listname AS listname, j3du8_youtubegallery_videolists.videolist AS videolist, j3du8_youtubegallery_videolists.catid AS catid, j3du8_youtubegallery_videolists.updateperiod AS updateperiod, j3du8_youtubegallery_videolists.lastplaylistupdate AS lastplaylistupdate, COUNT(j3du8_youtubegallery_videos.listid) AS TotalVideos 
      FROM `j3du8_youtubegallery_videolists` 
      LEFT JOIN j3du8_youtubegallery_videos 
      ON j3du8_youtubegallery_videos.listid=j3du8_youtubegallery_videolists.id 
      AND j3du8_youtubegallery_videos.isvideo 
      WHERE j3du8_youtubegallery_videolists.id=1  
      GROUP BY `id` 
      LIMIT 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	j3du8_youtubegallery_videolists	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1
    1	SIMPLE	j3du8_youtubegallery_videos	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_youtubegallery/includes/misc.php:48

    JROOT/components/com_youtubegallery/models/youtubegallery.php:107

    JROOT/libraries/legacy/view/legacy.php:398

    JROOT/components/com_youtubegallery/views/youtubegallery/view.html.php:28

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_youtubegallery/youtubegallery.php:20

    JROOT/libraries/cms/component/helper.php:352

    JROOT/libraries/cms/component/helper.php:332

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

21. Query Time: 2.18 ms After last query: 0.12 ms
    Duplicate queries: #22

    SELECT `id`, `themename`, `width`, `height`, `playvideo`, `repeat`, `fullscreen`, `autoplay`, `related`, `allowplaylist`, `showinfo`, `bgcolor`, `cols`,
    		`showtitle`, `cssstyle`, `navbarstyle`, `thumbnailstyle`, `linestyle`, `showlistname`, `listnamestyle`, `showactivevideotitle`, `activevideotitlestyle`,
    		`description`, `descr_position`, `descr_style`, `color1`, `color2`, `border`, `openinnewwindow`, `rel`, `hrefaddon`, `pagination`, `customlimit`,
    		`controls`, `youtubeparams`, `playertype`, `useglass`, `logocover`, `customlayout`,  `prepareheadtags`, `muteonplay`,
    		`volume`, `orderby`, `customnavlayout`, `responsive`, `mediafolder`, `readonly`, `headscript`, `themedescription`, `nocookie`, `changepagetitle`
    		
      FROM `j3du8_youtubegallery_themes` 
      WHERE `id`=2 
      LIMIT 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	j3du8_youtubegallery_themes	const	PRIMARY	PRIMARY	4	const	1

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_youtubegallery/includes/misc.php:73

    JROOT/components/com_youtubegallery/models/youtubegallery.php:110

    JROOT/libraries/legacy/view/legacy.php:398

    JROOT/components/com_youtubegallery/views/youtubegallery/view.html.php:28

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_youtubegallery/youtubegallery.php:20

    JROOT/libraries/cms/component/helper.php:352

    JROOT/libraries/cms/component/helper.php:332

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

22. Query Time: 0.30 ms After last query: 0.08 ms
    Duplicate queries: #21

    SELECT `id`, `themename`, `width`, `height`, `playvideo`, `repeat`, `fullscreen`, `autoplay`, `related`, `allowplaylist`, `showinfo`, `bgcolor`, `cols`,
    		`showtitle`, `cssstyle`, `navbarstyle`, `thumbnailstyle`, `linestyle`, `showlistname`, `listnamestyle`, `showactivevideotitle`, `activevideotitlestyle`,
    		`description`, `descr_position`, `descr_style`, `color1`, `color2`, `border`, `openinnewwindow`, `rel`, `hrefaddon`, `pagination`, `customlimit`,
    		`controls`, `youtubeparams`, `playertype`, `useglass`, `logocover`, `customlayout`,  `prepareheadtags`, `muteonplay`,
    		`volume`, `orderby`, `customnavlayout`, `responsive`, `mediafolder`, `readonly`, `headscript`, `themedescription`, `nocookie`, `changepagetitle`
    		
      FROM `j3du8_youtubegallery_themes` 
      WHERE `id`=2 
      LIMIT 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	j3du8_youtubegallery_themes	const	PRIMARY	PRIMARY	4	const	1

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_youtubegallery/includes/misc.php:75

    JROOT/components/com_youtubegallery/models/youtubegallery.php:110

    JROOT/libraries/legacy/view/legacy.php:398

    JROOT/components/com_youtubegallery/views/youtubegallery/view.html.php:28

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_youtubegallery/youtubegallery.php:20

    JROOT/libraries/cms/component/helper.php:352

    JROOT/libraries/cms/component/helper.php:332

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

23. Query Time: 0.21 ms After last query: 0.23 ms
    Duplicate queries: #24  #25  #26  #27  #28  #45  #46  #47  #48  #52  #53

    SELECT `value` 
      FROM `j3du8_youtubegallery_settings` 
      WHERE `option`="getinfomethod" 
      LIMIT 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_youtubegallery/includes/misc.php:1823

    JROOT/components/com_youtubegallery/includes/misc.php:87

    JROOT/components/com_youtubegallery/includes/misc.php:1122

    JROOT/components/com_youtubegallery/includes/misc.php:1102

    JROOT/components/com_youtubegallery/models/youtubegallery.php:117

    JROOT/libraries/legacy/view/legacy.php:398

    JROOT/components/com_youtubegallery/views/youtubegallery/view.html.php:28

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_youtubegallery/youtubegallery.php:20

    JROOT/libraries/cms/component/helper.php:352

    JROOT/libraries/cms/component/helper.php:332

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

24. Query Time: 0.21 ms After last query: 0.09 ms
    Duplicate queries: #23  #25  #26  #27  #28  #45  #46  #47  #48  #52  #53

    SELECT `value` 
      FROM `j3du8_youtubegallery_settings` 
      WHERE `option`="getinfomethod" 
      LIMIT 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_youtubegallery/includes/misc.php:1824

    JROOT/components/com_youtubegallery/includes/misc.php:87

    JROOT/components/com_youtubegallery/includes/misc.php:1122

    JROOT/components/com_youtubegallery/includes/misc.php:1102

    JROOT/components/com_youtubegallery/models/youtubegallery.php:117

    JROOT/libraries/legacy/view/legacy.php:398

    JROOT/components/com_youtubegallery/views/youtubegallery/view.html.php:28

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_youtubegallery/youtubegallery.php:20

    JROOT/libraries/cms/component/helper.php:352

    JROOT/libraries/cms/component/helper.php:332

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

25. Query Time: 0.33 ms After last query: 54.12 ms
    Duplicate queries: #23  #24  #26  #27  #28  #45  #46  #47  #48  #52  #53

    SELECT `value` 
      FROM `j3du8_youtubegallery_settings` 
      WHERE `option`="getinfomethod" 
      LIMIT 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_youtubegallery/includes/misc.php:1823

    JROOT/components/com_youtubegallery/includes/misc.php:1709

    JROOT/components/com_youtubegallery/includes/youtube.php:151

    JROOT/components/com_youtubegallery/includes/youtube.php:75

    JROOT/components/com_youtubegallery/includes/misc.php:593

    JROOT/components/com_youtubegallery/includes/misc.php:344

    JROOT/components/com_youtubegallery/includes/misc.php:1122

    JROOT/components/com_youtubegallery/includes/misc.php:1102

    JROOT/components/com_youtubegallery/models/youtubegallery.php:117

    JROOT/libraries/legacy/view/legacy.php:398

    JROOT/components/com_youtubegallery/views/youtubegallery/view.html.php:28

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_youtubegallery/youtubegallery.php:20

    JROOT/libraries/cms/component/helper.php:352

    JROOT/libraries/cms/component/helper.php:332

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

26. Query Time: 0.16 ms After last query: 0.08 ms
    Duplicate queries: #23  #24  #25  #27  #28  #45  #46  #47  #48  #52  #53

    SELECT `value` 
      FROM `j3du8_youtubegallery_settings` 
      WHERE `option`="getinfomethod" 
      LIMIT 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_youtubegallery/includes/misc.php:1824

    JROOT/components/com_youtubegallery/includes/misc.php:1709

    JROOT/components/com_youtubegallery/includes/youtube.php:151

    JROOT/components/com_youtubegallery/includes/youtube.php:75

    JROOT/components/com_youtubegallery/includes/misc.php:593

    JROOT/components/com_youtubegallery/includes/misc.php:344

    JROOT/components/com_youtubegallery/includes/misc.php:1122

    JROOT/components/com_youtubegallery/includes/misc.php:1102

    JROOT/components/com_youtubegallery/models/youtubegallery.php:117

    JROOT/libraries/legacy/view/legacy.php:398

    JROOT/components/com_youtubegallery/views/youtubegallery/view.html.php:28

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_youtubegallery/youtubegallery.php:20

    JROOT/libraries/cms/component/helper.php:352

    JROOT/libraries/cms/component/helper.php:332

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

27. Query Time: 0.76 ms After last query: 862.12 ms
    Duplicate queries: #23  #24  #25  #26  #28  #45  #46  #47  #48  #52  #53

    SELECT `value` 
      FROM `j3du8_youtubegallery_settings` 
      WHERE `option`="getinfomethod" 
      LIMIT 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_youtubegallery/includes/misc.php:1823

    JROOT/components/com_youtubegallery/includes/misc.php:1709

    JROOT/components/com_youtubegallery/includes/youtube.php:151

    JROOT/components/com_youtubegallery/includes/youtube.php:75

    JROOT/components/com_youtubegallery/includes/misc.php:593

    JROOT/components/com_youtubegallery/includes/misc.php:344

    JROOT/components/com_youtubegallery/includes/misc.php:1122

    JROOT/components/com_youtubegallery/includes/misc.php:1102

    JROOT/components/com_youtubegallery/models/youtubegallery.php:117

    JROOT/libraries/legacy/view/legacy.php:398

    JROOT/components/com_youtubegallery/views/youtubegallery/view.html.php:28

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_youtubegallery/youtubegallery.php:20

    JROOT/libraries/cms/component/helper.php:352

    JROOT/libraries/cms/component/helper.php:332

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

28. Query Time: 0.60 ms After last query: 0.22 ms
    Duplicate queries: #23  #24  #25  #26  #27  #45  #46  #47  #48  #52  #53

    SELECT `value` 
      FROM `j3du8_youtubegallery_settings` 
      WHERE `option`="getinfomethod" 
      LIMIT 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_youtubegallery/includes/misc.php:1824

    JROOT/components/com_youtubegallery/includes/misc.php:1709

    JROOT/components/com_youtubegallery/includes/youtube.php:151

    JROOT/components/com_youtubegallery/includes/youtube.php:75

    JROOT/components/com_youtubegallery/includes/misc.php:593

    JROOT/components/com_youtubegallery/includes/misc.php:344

    JROOT/components/com_youtubegallery/includes/misc.php:1122

    JROOT/components/com_youtubegallery/includes/misc.php:1102

    JROOT/components/com_youtubegallery/models/youtubegallery.php:117

    JROOT/libraries/legacy/view/legacy.php:398

    JROOT/components/com_youtubegallery/views/youtubegallery/view.html.php:28

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_youtubegallery/youtubegallery.php:20

    JROOT/libraries/cms/component/helper.php:352

    JROOT/libraries/cms/component/helper.php:332

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

29. Query Time: 0.62 ms After last query: 344.71 ms
    Duplicate queries: #30  #34  #35  #49  #50  #54  #55

    SELECT `alias` 
      FROM `j3du8_youtubegallery_videos` 
      WHERE `alias`="video-not-found-cannot-connect-to-youtube-server"

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	j3du8_youtubegallery_videos	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_youtubegallery/includes/misc.php:1846

    JROOT/components/com_youtubegallery/includes/misc.php:1201

    JROOT/components/com_youtubegallery/includes/misc.php:1102

    JROOT/components/com_youtubegallery/models/youtubegallery.php:117

    JROOT/libraries/legacy/view/legacy.php:398

    JROOT/components/com_youtubegallery/views/youtubegallery/view.html.php:28

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_youtubegallery/youtubegallery.php:20

    JROOT/libraries/cms/component/helper.php:352

    JROOT/libraries/cms/component/helper.php:332

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

30. Query Time: 0.55 ms After last query: 0.12 ms
    Duplicate queries: #29  #34  #35  #49  #50  #54  #55

    SELECT `alias` 
      FROM `j3du8_youtubegallery_videos` 
      WHERE `alias`="video-not-found-cannot-connect-to-youtube-server"

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	j3du8_youtubegallery_videos	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_youtubegallery/includes/misc.php:1847

    JROOT/components/com_youtubegallery/includes/misc.php:1201

    JROOT/components/com_youtubegallery/includes/misc.php:1102

    JROOT/components/com_youtubegallery/models/youtubegallery.php:117

    JROOT/libraries/legacy/view/legacy.php:398

    JROOT/components/com_youtubegallery/views/youtubegallery/view.html.php:28

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_youtubegallery/youtubegallery.php:20

    JROOT/libraries/cms/component/helper.php:352

    JROOT/libraries/cms/component/helper.php:332

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

31. Query Time: 0.54 ms After last query: 0.17 ms
    Duplicate queries: #32

    SELECT id, allowupdates 
      FROM j3du8_youtubegallery_videos 
      WHERE `videosource`="youtube" 
      AND `videoid`="mCPVsbuMS7o" 
      AND `listid`=1 
      LIMIT 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	j3du8_youtubegallery_videos	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_youtubegallery/includes/misc.php:839

    JROOT/components/com_youtubegallery/includes/misc.php:1314

    JROOT/components/com_youtubegallery/includes/misc.php:1102

    JROOT/components/com_youtubegallery/models/youtubegallery.php:117

    JROOT/libraries/legacy/view/legacy.php:398

    JROOT/components/com_youtubegallery/views/youtubegallery/view.html.php:28

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_youtubegallery/youtubegallery.php:20

    JROOT/libraries/cms/component/helper.php:352

    JROOT/libraries/cms/component/helper.php:332

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

32. Query Time: 0.70 ms After last query: 0.28 ms
    Duplicate queries: #31

    SELECT id, allowupdates 
      FROM j3du8_youtubegallery_videos 
      WHERE `videosource`="youtube" 
      AND `videoid`="mCPVsbuMS7o" 
      AND `listid`=1 
      LIMIT 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	j3du8_youtubegallery_videos	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_youtubegallery/includes/misc.php:841

    JROOT/components/com_youtubegallery/includes/misc.php:1314

    JROOT/components/com_youtubegallery/includes/misc.php:1102

    JROOT/components/com_youtubegallery/models/youtubegallery.php:117

    JROOT/libraries/legacy/view/legacy.php:398

    JROOT/components/com_youtubegallery/views/youtubegallery/view.html.php:28

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_youtubegallery/youtubegallery.php:20

    JROOT/libraries/cms/component/helper.php:352

    JROOT/libraries/cms/component/helper.php:332

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

33. Query Time: 0.75 ms After last query: 0.35 ms

    UPDATE j3du8_youtubegallery_videos 
      SET `listid`="1", `parentid`="0", `videosource`="youtube", `videoid`="mCPVsbuMS7o", `datalink`="http://gdata.youtube.com/feeds/api/videos/mCPVsbuMS7o?v=2", `title`="***Video not found*** (Cannot Connect to Youtube Server)", `description`="Cannot Connect to Youtube Server", `custom_imageurl`="", `alias`="video-not-found-cannot-connect-to-youtube-server", `custom_title`="", `custom_description`="", `specialparams`="", `startsecond`="0", `endsecond`="0", `link`="http://youtu.be/mCPVsbuMS7o", `ordering`="10000", `isvideo`="1", `publisheddate`="", `duration`="0", `rating_average`="0", `rating_max`="0", `rating_min`="0", `rating_numRaters`="0", `statistics_favoriteCount`="0", `statistics_viewCount`="0", `keywords`="", `likes`="0", `dislikes`="" 
      WHERE id=4

    Explain

    EXPLAIN not possible on query: UPDATE j3du8_youtubegallery_videos SET `listid`="1", `parentid`="0", `videosource`="youtube", `videoid`="mCPVsbuMS7o", `datalink`="http://gdata.youtube.com/feeds/api/videos/mCPVsbuMS7o?v=2", `title`="***Video not found*** (Cannot Connect to Youtube Server)", `description`="Cannot Connect to Youtube Server", `custom_imageurl`="", `alias`="video-not-found-cannot-connect-to-youtube-server", `custom_title`="", `custom_description`="", `specialparams`="", `startsecond`="0", `endsecond`="0", `link`="http://youtu.be/mCPVsbuMS7o", `ordering`="10000", `isvideo`="1", `publisheddate`="", `duration`="0", `rating_average`="0", `rating_max`="0", `rating_min`="0", `rating_numRaters`="0", `statistics_favoriteCount`="0", `statistics_viewCount`="0", `keywords`="", `likes`="0", `dislikes`="" WHERE id=4

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_youtubegallery/includes/misc.php:1349

    JROOT/components/com_youtubegallery/includes/misc.php:1102

    JROOT/components/com_youtubegallery/models/youtubegallery.php:117

    JROOT/libraries/legacy/view/legacy.php:398

    JROOT/components/com_youtubegallery/views/youtubegallery/view.html.php:28

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_youtubegallery/youtubegallery.php:20

    JROOT/libraries/cms/component/helper.php:352

    JROOT/libraries/cms/component/helper.php:332

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

34. Query Time: 0.59 ms After last query: 0.35 ms
    Duplicate queries: #29  #30  #35  #49  #50  #54  #55

    SELECT `alias` 
      FROM `j3du8_youtubegallery_videos` 
      WHERE `alias`="video-not-found-cannot-connect-to-youtube-server"

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	j3du8_youtubegallery_videos	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_youtubegallery/includes/misc.php:1846

    JROOT/components/com_youtubegallery/includes/misc.php:1201

    JROOT/components/com_youtubegallery/includes/misc.php:1102

    JROOT/components/com_youtubegallery/models/youtubegallery.php:117

    JROOT/libraries/legacy/view/legacy.php:398

    JROOT/components/com_youtubegallery/views/youtubegallery/view.html.php:28

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_youtubegallery/youtubegallery.php:20

    JROOT/libraries/cms/component/helper.php:352

    JROOT/libraries/cms/component/helper.php:332

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

35. Query Time: 0.59 ms After last query: 0.20 ms
    Duplicate queries: #29  #30  #34  #49  #50  #54  #55

    SELECT `alias` 
      FROM `j3du8_youtubegallery_videos` 
      WHERE `alias`="video-not-found-cannot-connect-to-youtube-server"

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	j3du8_youtubegallery_videos	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_youtubegallery/includes/misc.php:1847

    JROOT/components/com_youtubegallery/includes/misc.php:1201

    JROOT/components/com_youtubegallery/includes/misc.php:1102

    JROOT/components/com_youtubegallery/models/youtubegallery.php:117

    JROOT/libraries/legacy/view/legacy.php:398

    JROOT/components/com_youtubegallery/views/youtubegallery/view.html.php:28

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_youtubegallery/youtubegallery.php:20

    JROOT/libraries/cms/component/helper.php:352

    JROOT/libraries/cms/component/helper.php:332

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

36. Query Time: 0.62 ms After last query: 0.31 ms
    Duplicate queries: #37

    SELECT id, allowupdates 
      FROM j3du8_youtubegallery_videos 
      WHERE `videosource`="youtube" 
      AND `videoid`="g-nz2WZhFaE" 
      AND `listid`=1 
      LIMIT 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	j3du8_youtubegallery_videos	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_youtubegallery/includes/misc.php:839

    JROOT/components/com_youtubegallery/includes/misc.php:1314

    JROOT/components/com_youtubegallery/includes/misc.php:1102

    JROOT/components/com_youtubegallery/models/youtubegallery.php:117

    JROOT/libraries/legacy/view/legacy.php:398

    JROOT/components/com_youtubegallery/views/youtubegallery/view.html.php:28

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_youtubegallery/youtubegallery.php:20

    JROOT/libraries/cms/component/helper.php:352

    JROOT/libraries/cms/component/helper.php:332

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

37. Query Time: 0.66 ms After last query: 0.22 ms
    Duplicate queries: #36

    SELECT id, allowupdates 
      FROM j3du8_youtubegallery_videos 
      WHERE `videosource`="youtube" 
      AND `videoid`="g-nz2WZhFaE" 
      AND `listid`=1 
      LIMIT 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	j3du8_youtubegallery_videos	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_youtubegallery/includes/misc.php:841

    JROOT/components/com_youtubegallery/includes/misc.php:1314

    JROOT/components/com_youtubegallery/includes/misc.php:1102

    JROOT/components/com_youtubegallery/models/youtubegallery.php:117

    JROOT/libraries/legacy/view/legacy.php:398

    JROOT/components/com_youtubegallery/views/youtubegallery/view.html.php:28

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_youtubegallery/youtubegallery.php:20

    JROOT/libraries/cms/component/helper.php:352

    JROOT/libraries/cms/component/helper.php:332

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

38. Query Time: 0.75 ms After last query: 0.43 ms

    UPDATE j3du8_youtubegallery_videos 
      SET `listid`="1", `parentid`="0", `videosource`="youtube", `videoid`="g-nz2WZhFaE", `datalink`="http://gdata.youtube.com/feeds/api/videos/g-nz2WZhFaE?v=2", `title`="***Video not found*** (Cannot Connect to Youtube Server)", `description`="Cannot Connect to Youtube Server", `custom_imageurl`="", `alias`="video-not-found-cannot-connect-to-youtube-server", `custom_title`="", `custom_description`="", `specialparams`="", `startsecond`="0", `endsecond`="0", `link`="http://youtu.be/g-nz2WZhFaE", `ordering`="20000", `isvideo`="1", `publisheddate`="", `duration`="0", `rating_average`="0", `rating_max`="0", `rating_min`="0", `rating_numRaters`="0", `statistics_favoriteCount`="0", `statistics_viewCount`="0", `keywords`="", `likes`="0", `dislikes`="" 
      WHERE id=5

    Explain

    EXPLAIN not possible on query: UPDATE j3du8_youtubegallery_videos SET `listid`="1", `parentid`="0", `videosource`="youtube", `videoid`="g-nz2WZhFaE", `datalink`="http://gdata.youtube.com/feeds/api/videos/g-nz2WZhFaE?v=2", `title`="***Video not found*** (Cannot Connect to Youtube Server)", `description`="Cannot Connect to Youtube Server", `custom_imageurl`="", `alias`="video-not-found-cannot-connect-to-youtube-server", `custom_title`="", `custom_description`="", `specialparams`="", `startsecond`="0", `endsecond`="0", `link`="http://youtu.be/g-nz2WZhFaE", `ordering`="20000", `isvideo`="1", `publisheddate`="", `duration`="0", `rating_average`="0", `rating_max`="0", `rating_min`="0", `rating_numRaters`="0", `statistics_favoriteCount`="0", `statistics_viewCount`="0", `keywords`="", `likes`="0", `dislikes`="" WHERE id=5

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_youtubegallery/includes/misc.php:1349

    JROOT/components/com_youtubegallery/includes/misc.php:1102

    JROOT/components/com_youtubegallery/models/youtubegallery.php:117

    JROOT/libraries/legacy/view/legacy.php:398

    JROOT/components/com_youtubegallery/views/youtubegallery/view.html.php:28

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_youtubegallery/youtubegallery.php:20

    JROOT/libraries/cms/component/helper.php:352

    JROOT/libraries/cms/component/helper.php:332

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

39. Query Time: 0.65 ms After last query: 0.35 ms

    UPDATE j3du8_youtubegallery_videolists 
      SET `lastplaylistupdate`="2018-05-26 05:44:31" 
      WHERE `id`="1"

    Explain

    EXPLAIN not possible on query: UPDATE j3du8_youtubegallery_videolists SET `lastplaylistupdate`="2018-05-26 05:44:31" WHERE `id`="1"

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_youtubegallery/includes/misc.php:1108

    JROOT/components/com_youtubegallery/models/youtubegallery.php:117

    JROOT/libraries/legacy/view/legacy.php:398

    JROOT/components/com_youtubegallery/views/youtubegallery/view.html.php:28

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_youtubegallery/youtubegallery.php:20

    JROOT/libraries/cms/component/helper.php:352

    JROOT/libraries/cms/component/helper.php:332

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

40. Query Time: 0.72 ms After last query: 0.28 ms
    Duplicate queries: #41

    SELECT `videoid` 
      FROM `j3du8_youtubegallery_videos` 
      WHERE `listid`="1" 
      AND `isvideo`=0 
      AND `videosource`="videolist"

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	j3du8_youtubegallery_videos	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_youtubegallery/includes/misc.php:872

    JROOT/components/com_youtubegallery/models/youtubegallery.php:128

    JROOT/libraries/legacy/view/legacy.php:398

    JROOT/components/com_youtubegallery/views/youtubegallery/view.html.php:28

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_youtubegallery/youtubegallery.php:20

    JROOT/libraries/cms/component/helper.php:352

    JROOT/libraries/cms/component/helper.php:332

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

41. Query Time: 0.62 ms After last query: 0.16 ms
    Duplicate queries: #40

    SELECT `videoid` 
      FROM `j3du8_youtubegallery_videos` 
      WHERE `listid`="1" 
      AND `isvideo`=0 
      AND `videosource`="videolist"

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	j3du8_youtubegallery_videos	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_youtubegallery/includes/misc.php:873

    JROOT/components/com_youtubegallery/models/youtubegallery.php:128

    JROOT/libraries/legacy/view/legacy.php:398

    JROOT/components/com_youtubegallery/views/youtubegallery/view.html.php:28

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_youtubegallery/youtubegallery.php:20

    JROOT/libraries/cms/component/helper.php:352

    JROOT/libraries/cms/component/helper.php:332

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

42. Query Time: 1.96 ms After last query: 0.49 ms

    SELECT * 
      FROM `j3du8_youtubegallery_videos` 
      WHERE 1=1 
      and (`listid`="1") 
      AND `isvideo` 
      GROUP BY `videoid` 
      ORDER BY publisheddate

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	j3du8_youtubegallery_videos	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where; Using temporary; Using filesort

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_youtubegallery/includes/misc.php:1025

    JROOT/components/com_youtubegallery/includes/misc.php:929

    JROOT/components/com_youtubegallery/models/youtubegallery.php:128

    JROOT/libraries/legacy/view/legacy.php:398

    JROOT/components/com_youtubegallery/views/youtubegallery/view.html.php:28

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_youtubegallery/youtubegallery.php:20

    JROOT/libraries/cms/component/helper.php:352

    JROOT/libraries/cms/component/helper.php:332

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

43. Query Time: 1.65 ms After last query: 0.32 ms
    Duplicate queries: #44

    SELECT * 
      FROM `j3du8_youtubegallery_videos` 
      WHERE 1=1 
      and (`listid`="1") 
      AND `isvideo` 
      GROUP BY `videoid` 
      ORDER BY publisheddate 
      LIMIT 0, 12

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	j3du8_youtubegallery_videos	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where; Using temporary; Using filesort

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_youtubegallery/includes/misc.php:1034

    JROOT/components/com_youtubegallery/includes/misc.php:929

    JROOT/components/com_youtubegallery/models/youtubegallery.php:128

    JROOT/libraries/legacy/view/legacy.php:398

    JROOT/components/com_youtubegallery/views/youtubegallery/view.html.php:28

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_youtubegallery/youtubegallery.php:20

    JROOT/libraries/cms/component/helper.php:352

    JROOT/libraries/cms/component/helper.php:332

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

44. Query Time: 1.63 ms After last query: 0.24 ms
    Duplicate queries: #43

    SELECT * 
      FROM `j3du8_youtubegallery_videos` 
      WHERE 1=1 
      and (`listid`="1") 
      AND `isvideo` 
      GROUP BY `videoid` 
      ORDER BY publisheddate 
      LIMIT 0, 12

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	j3du8_youtubegallery_videos	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where; Using temporary; Using filesort

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_youtubegallery/includes/misc.php:1038

    JROOT/components/com_youtubegallery/includes/misc.php:929

    JROOT/components/com_youtubegallery/models/youtubegallery.php:128

    JROOT/libraries/legacy/view/legacy.php:398

    JROOT/components/com_youtubegallery/views/youtubegallery/view.html.php:28

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_youtubegallery/youtubegallery.php:20

    JROOT/libraries/cms/component/helper.php:352

    JROOT/libraries/cms/component/helper.php:332

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

45. Query Time: 0.47 ms After last query: 0.78 ms
    Duplicate queries: #23  #24  #25  #26  #27  #28  #46  #47  #48  #52  #53

    SELECT `value` 
      FROM `j3du8_youtubegallery_settings` 
      WHERE `option`="getinfomethod" 
      LIMIT 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_youtubegallery/includes/misc.php:1823

    JROOT/components/com_youtubegallery/includes/layoutrenderer.php:972

    JROOT/components/com_youtubegallery/includes/layoutrenderer.php:133

    JROOT/components/com_youtubegallery/includes/layoutrenderer.php:397

    JROOT/components/com_youtubegallery/includes/render.php:161

    JROOT/components/com_youtubegallery/models/youtubegallery.php:146

    JROOT/libraries/legacy/view/legacy.php:398

    JROOT/components/com_youtubegallery/views/youtubegallery/view.html.php:28

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_youtubegallery/youtubegallery.php:20

    JROOT/libraries/cms/component/helper.php:352

    JROOT/libraries/cms/component/helper.php:332

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

46. Query Time: 0.40 ms After last query: 0.21 ms
    Duplicate queries: #23  #24  #25  #26  #27  #28  #45  #47  #48  #52  #53

    SELECT `value` 
      FROM `j3du8_youtubegallery_settings` 
      WHERE `option`="getinfomethod" 
      LIMIT 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    Status	Duration
    starting	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    After opening tables	0.0 ms
    System lock	0.0 ms
    Table lock	0.0 ms
    init	0.0 ms
    optimizing	0.0 ms
    statistics	0.0 ms
    preparing	0.0 ms
    executing	0.0 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    Unlocking tables	0.0 ms
    freeing items	0.0 ms
    updating status	0.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/components/com_youtubegallery/includes/misc.php:1824

    JROOT/components/com_youtubegallery/includes/layoutrenderer.php:972

    JROOT/components/com_youtubegallery/includes/layoutrenderer.php:133

    JROOT/components/com_youtubegallery/includes/layoutrenderer.php:397

    JROOT/components/com_youtubegallery/includes/render.php:161

    JROOT/components/com_youtubegallery/models/youtubegallery.php:146

    JROOT/libraries/legacy/view/legacy.php:398

    JROOT/components/com_youtubegallery/views/youtubegallery/view.html.php:28

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_youtubegallery/youtubegallery.php:20

    JROOT/libraries/cms/component/helper.php:352

    JROOT/libraries/cms/component/helper.php:332

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

47. Query Time: 0.41 ms After last query: 0.48 ms
    Duplicate queries: #23  #24  #25  #26  #27  #28  #45  #46  #48  #52  #53

    SELECT `value` 
      FROM `j3du8_youtubegallery_settings` 
      WHERE `option`="getinfomethod" 
      LIMIT 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    Status	Duration
    starting	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    After opening tables	0.0 ms
    System lock	0.0 ms
    Table lock	0.0 ms
    init	0.0 ms
    optimizing	0.0 ms
    statistics	0.0 ms
    preparing	0.0 ms
    executing	0.0 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    Unlocking tables	0.0 ms
    freeing items	0.0 ms
    updating status	0.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/components/com_youtubegallery/includes/misc.php:1823

    JROOT/components/com_youtubegallery/includes/misc.php:1709

    JROOT/components/com_youtubegallery/includes/youtube.php:151

    JROOT/components/com_youtubegallery/includes/youtube.php:75

    JROOT/components/com_youtubegallery/includes/misc.php:593

    JROOT/components/com_youtubegallery/includes/misc.php:1453

    JROOT/components/com_youtubegallery/includes/layoutrenderer.php:975

    JROOT/components/com_youtubegallery/includes/layoutrenderer.php:133

    JROOT/components/com_youtubegallery/includes/layoutrenderer.php:397

    JROOT/components/com_youtubegallery/includes/render.php:161

    JROOT/components/com_youtubegallery/models/youtubegallery.php:146

    JROOT/libraries/legacy/view/legacy.php:398

    JROOT/components/com_youtubegallery/views/youtubegallery/view.html.php:28

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_youtubegallery/youtubegallery.php:20

    JROOT/libraries/cms/component/helper.php:352

    JROOT/libraries/cms/component/helper.php:332

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

48. Query Time: 0.51 ms After last query: 0.28 ms
    Duplicate queries: #23  #24  #25  #26  #27  #28  #45  #46  #47  #52  #53

    SELECT `value` 
      FROM `j3du8_youtubegallery_settings` 
      WHERE `option`="getinfomethod" 
      LIMIT 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    Status	Duration
    starting	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    After opening tables	0.0 ms
    System lock	0.0 ms
    Table lock	0.0 ms
    init	0.0 ms
    optimizing	0.0 ms
    statistics	0.0 ms
    preparing	0.0 ms
    executing	0.0 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    Unlocking tables	0.0 ms
    freeing items	0.0 ms
    updating status	0.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/components/com_youtubegallery/includes/misc.php:1824

    JROOT/components/com_youtubegallery/includes/misc.php:1709

    JROOT/components/com_youtubegallery/includes/youtube.php:151

    JROOT/components/com_youtubegallery/includes/youtube.php:75

    JROOT/components/com_youtubegallery/includes/misc.php:593

    JROOT/components/com_youtubegallery/includes/misc.php:1453

    JROOT/components/com_youtubegallery/includes/layoutrenderer.php:975

    JROOT/components/com_youtubegallery/includes/layoutrenderer.php:133

    JROOT/components/com_youtubegallery/includes/layoutrenderer.php:397

    JROOT/components/com_youtubegallery/includes/render.php:161

    JROOT/components/com_youtubegallery/models/youtubegallery.php:146

    JROOT/libraries/legacy/view/legacy.php:398

    JROOT/components/com_youtubegallery/views/youtubegallery/view.html.php:28

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_youtubegallery/youtubegallery.php:20

    JROOT/libraries/cms/component/helper.php:352

    JROOT/libraries/cms/component/helper.php:332

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

49. Query Time: 0.32 ms After last query: 349.06 ms
    Duplicate queries: #29  #30  #34  #35  #50  #54  #55

    SELECT `alias` 
      FROM `j3du8_youtubegallery_videos` 
      WHERE `alias`="video-not-found-cannot-connect-to-youtube-server"

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	j3du8_youtubegallery_videos	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where

    Profile

    Status	Duration
    starting	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    After opening tables	0.0 ms
    System lock	0.0 ms
    Table lock	0.0 ms
    init	0.0 ms
    optimizing	0.0 ms
    statistics	0.0 ms
    preparing	0.0 ms
    executing	0.0 ms
    Sending data	0.0 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    Unlocking tables	0.0 ms
    freeing items	0.0 ms
    updating status	0.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/components/com_youtubegallery/includes/misc.php:1846

    JROOT/components/com_youtubegallery/includes/misc.php:1469

    JROOT/components/com_youtubegallery/includes/layoutrenderer.php:975

    JROOT/components/com_youtubegallery/includes/layoutrenderer.php:133

    JROOT/components/com_youtubegallery/includes/layoutrenderer.php:397

    JROOT/components/com_youtubegallery/includes/render.php:161

    JROOT/components/com_youtubegallery/models/youtubegallery.php:146

    JROOT/libraries/legacy/view/legacy.php:398

    JROOT/components/com_youtubegallery/views/youtubegallery/view.html.php:28

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_youtubegallery/youtubegallery.php:20

    JROOT/libraries/cms/component/helper.php:352

    JROOT/libraries/cms/component/helper.php:332

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

50. Query Time: 0.24 ms After last query: 0.11 ms
    Duplicate queries: #29  #30  #34  #35  #49  #54  #55

    SELECT `alias` 
      FROM `j3du8_youtubegallery_videos` 
      WHERE `alias`="video-not-found-cannot-connect-to-youtube-server"

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	j3du8_youtubegallery_videos	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where

    Profile

    Status	Duration
    starting	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    After opening tables	0.0 ms
    System lock	0.0 ms
    Table lock	0.0 ms
    init	0.0 ms
    optimizing	0.0 ms
    statistics	0.0 ms
    preparing	0.0 ms
    executing	0.0 ms
    Sending data	0.0 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    Unlocking tables	0.0 ms
    freeing items	0.0 ms
    updating status	0.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/components/com_youtubegallery/includes/misc.php:1847

    JROOT/components/com_youtubegallery/includes/misc.php:1469

    JROOT/components/com_youtubegallery/includes/layoutrenderer.php:975

    JROOT/components/com_youtubegallery/includes/layoutrenderer.php:133

    JROOT/components/com_youtubegallery/includes/layoutrenderer.php:397

    JROOT/components/com_youtubegallery/includes/render.php:161

    JROOT/components/com_youtubegallery/models/youtubegallery.php:146

    JROOT/libraries/legacy/view/legacy.php:398

    JROOT/components/com_youtubegallery/views/youtubegallery/view.html.php:28

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_youtubegallery/youtubegallery.php:20

    JROOT/libraries/cms/component/helper.php:352

    JROOT/libraries/cms/component/helper.php:332

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

51. Query Time: 0.29 ms After last query: 0.23 ms

    UPDATE `j3du8_youtubegallery_videos` 
      SET `title`="***Video not found*** (Cannot Connect to Youtube Server)", `alias`="video-not-found-cannot-connect-to-youtube-server_mCPVsbuMS7o", `description`="Cannot Connect to Youtube Server", `imageurl`="", `lastupdate`="2018-05-26 05:44:31", `status`="200", `startsecond`="0", `endsecond`="0", `publisheddate`="", `duration`="0", `rating_average`="0", `rating_max`="0", `rating_min`="0", `rating_numRaters`="0", `statistics_favoriteCount`="0", `statistics_viewCount`="0", `keywords`="", `likes`="0", `dislikes`="", `commentcount`="" 
      WHERE `id`=4

    Explain

    EXPLAIN not possible on query: UPDATE `j3du8_youtubegallery_videos` SET `title`="***Video not found*** (Cannot Connect to Youtube Server)", `alias`="video-not-found-cannot-connect-to-youtube-server_mCPVsbuMS7o", `description`="Cannot Connect to Youtube Server", `imageurl`="", `lastupdate`="2018-05-26 05:44:31", `status`="200", `startsecond`="0", `endsecond`="0", `publisheddate`="", `duration`="0", `rating_average`="0", `rating_max`="0", `rating_min`="0", `rating_numRaters`="0", `statistics_favoriteCount`="0", `statistics_viewCount`="0", `keywords`="", `likes`="0", `dislikes`="", `commentcount`="" WHERE `id`=4

    Profile

    Status	Duration
    starting	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    After opening tables	0.0 ms
    System lock	0.0 ms
    Table lock	0.0 ms
    init	0.0 ms
    updating	0.1 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    Unlocking tables	0.0 ms
    freeing items	0.0 ms
    updating status	0.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/components/com_youtubegallery/includes/misc.php:1523

    JROOT/components/com_youtubegallery/includes/layoutrenderer.php:975

    JROOT/components/com_youtubegallery/includes/layoutrenderer.php:133

    JROOT/components/com_youtubegallery/includes/layoutrenderer.php:397

    JROOT/components/com_youtubegallery/includes/render.php:161

    JROOT/components/com_youtubegallery/models/youtubegallery.php:146

    JROOT/libraries/legacy/view/legacy.php:398

    JROOT/components/com_youtubegallery/views/youtubegallery/view.html.php:28

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_youtubegallery/youtubegallery.php:20

    JROOT/libraries/cms/component/helper.php:352

    JROOT/libraries/cms/component/helper.php:332

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

52. Query Time: 0.20 ms After last query: 0.22 ms
    Duplicate queries: #23  #24  #25  #26  #27  #28  #45  #46  #47  #48  #53

    SELECT `value` 
      FROM `j3du8_youtubegallery_settings` 
      WHERE `option`="getinfomethod" 
      LIMIT 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    Status	Duration
    starting	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    After opening tables	0.0 ms
    System lock	0.0 ms
    Table lock	0.0 ms
    init	0.0 ms
    optimizing	0.0 ms
    statistics	0.0 ms
    preparing	0.0 ms
    executing	0.0 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    Unlocking tables	0.0 ms
    freeing items	0.0 ms
    updating status	0.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/components/com_youtubegallery/includes/misc.php:1823

    JROOT/components/com_youtubegallery/includes/misc.php:1709

    JROOT/components/com_youtubegallery/includes/youtube.php:151

    JROOT/components/com_youtubegallery/includes/youtube.php:75

    JROOT/components/com_youtubegallery/includes/misc.php:593

    JROOT/components/com_youtubegallery/includes/misc.php:1453

    JROOT/components/com_youtubegallery/includes/layoutrenderer.php:975

    JROOT/components/com_youtubegallery/includes/layoutrenderer.php:133

    JROOT/components/com_youtubegallery/includes/layoutrenderer.php:397

    JROOT/components/com_youtubegallery/includes/render.php:161

    JROOT/components/com_youtubegallery/models/youtubegallery.php:146

    JROOT/libraries/legacy/view/legacy.php:398

    JROOT/components/com_youtubegallery/views/youtubegallery/view.html.php:28

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_youtubegallery/youtubegallery.php:20

    JROOT/libraries/cms/component/helper.php:352

    JROOT/libraries/cms/component/helper.php:332

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

53. Query Time: 0.19 ms After last query: 0.10 ms
    Duplicate queries: #23  #24  #25  #26  #27  #28  #45  #46  #47  #48  #52

    SELECT `value` 
      FROM `j3du8_youtubegallery_settings` 
      WHERE `option`="getinfomethod" 
      LIMIT 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    Status	Duration
    starting	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    After opening tables	0.0 ms
    System lock	0.0 ms
    Table lock	0.0 ms
    init	0.0 ms
    optimizing	0.0 ms
    statistics	0.0 ms
    preparing	0.0 ms
    executing	0.0 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    Unlocking tables	0.0 ms
    freeing items	0.0 ms
    updating status	0.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/components/com_youtubegallery/includes/misc.php:1824

    JROOT/components/com_youtubegallery/includes/misc.php:1709

    JROOT/components/com_youtubegallery/includes/youtube.php:151

    JROOT/components/com_youtubegallery/includes/youtube.php:75

    JROOT/components/com_youtubegallery/includes/misc.php:593

    JROOT/components/com_youtubegallery/includes/misc.php:1453

    JROOT/components/com_youtubegallery/includes/layoutrenderer.php:975

    JROOT/components/com_youtubegallery/includes/layoutrenderer.php:133

    JROOT/components/com_youtubegallery/includes/layoutrenderer.php:397

    JROOT/components/com_youtubegallery/includes/render.php:161

    JROOT/components/com_youtubegallery/models/youtubegallery.php:146

    JROOT/libraries/legacy/view/legacy.php:398

    JROOT/components/com_youtubegallery/views/youtubegallery/view.html.php:28

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_youtubegallery/youtubegallery.php:20

    JROOT/libraries/cms/component/helper.php:352

    JROOT/libraries/cms/component/helper.php:332

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

54. Query Time: 0.30 ms After last query: 350.46 ms
    Duplicate queries: #29  #30  #34  #35  #49  #50  #55

    SELECT `alias` 
      FROM `j3du8_youtubegallery_videos` 
      WHERE `alias`="video-not-found-cannot-connect-to-youtube-server"

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	j3du8_youtubegallery_videos	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where

    Profile

    Status	Duration
    starting	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    After opening tables	0.0 ms
    System lock	0.0 ms
    Table lock	0.0 ms
    init	0.0 ms
    optimizing	0.0 ms
    statistics	0.0 ms
    preparing	0.0 ms
    executing	0.0 ms
    Sending data	0.0 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    Unlocking tables	0.0 ms
    freeing items	0.0 ms
    updating status	0.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/components/com_youtubegallery/includes/misc.php:1846

    JROOT/components/com_youtubegallery/includes/misc.php:1469

    JROOT/components/com_youtubegallery/includes/layoutrenderer.php:975

    JROOT/components/com_youtubegallery/includes/layoutrenderer.php:133

    JROOT/components/com_youtubegallery/includes/layoutrenderer.php:397

    JROOT/components/com_youtubegallery/includes/render.php:161

    JROOT/components/com_youtubegallery/models/youtubegallery.php:146

    JROOT/libraries/legacy/view/legacy.php:398

    JROOT/components/com_youtubegallery/views/youtubegallery/view.html.php:28

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_youtubegallery/youtubegallery.php:20

    JROOT/libraries/cms/component/helper.php:352

    JROOT/libraries/cms/component/helper.php:332

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

55. Query Time: 0.33 ms After last query: 0.13 ms
    Duplicate queries: #29  #30  #34  #35  #49  #50  #54

    SELECT `alias` 
      FROM `j3du8_youtubegallery_videos` 
      WHERE `alias`="video-not-found-cannot-connect-to-youtube-server"

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	j3du8_youtubegallery_videos	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where

    Profile

    Status	Duration
    starting	0.1 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    After opening tables	0.0 ms
    System lock	0.0 ms
    Table lock	0.0 ms
    init	0.0 ms
    optimizing	0.0 ms
    statistics	0.0 ms
    preparing	0.1 ms
    executing	0.0 ms
    Sending data	0.0 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    Unlocking tables	0.0 ms
    freeing items	0.0 ms
    updating status	0.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/components/com_youtubegallery/includes/misc.php:1847

    JROOT/components/com_youtubegallery/includes/misc.php:1469

    JROOT/components/com_youtubegallery/includes/layoutrenderer.php:975

    JROOT/components/com_youtubegallery/includes/layoutrenderer.php:133

    JROOT/components/com_youtubegallery/includes/layoutrenderer.php:397

    JROOT/components/com_youtubegallery/includes/render.php:161

    JROOT/components/com_youtubegallery/models/youtubegallery.php:146

    JROOT/libraries/legacy/view/legacy.php:398

    JROOT/components/com_youtubegallery/views/youtubegallery/view.html.php:28

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_youtubegallery/youtubegallery.php:20

    JROOT/libraries/cms/component/helper.php:352

    JROOT/libraries/cms/component/helper.php:332

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

56. Query Time: 0.30 ms After last query: 0.19 ms

    UPDATE `j3du8_youtubegallery_videos` 
      SET `title`="***Video not found*** (Cannot Connect to Youtube Server)", `alias`="video-not-found-cannot-connect-to-youtube-server", `description`="Cannot Connect to Youtube Server", `imageurl`="", `lastupdate`="2018-05-26 05:44:31", `status`="200", `startsecond`="0", `endsecond`="0", `publisheddate`="", `duration`="0", `rating_average`="0", `rating_max`="0", `rating_min`="0", `rating_numRaters`="0", `statistics_favoriteCount`="0", `statistics_viewCount`="0", `keywords`="", `likes`="0", `dislikes`="", `commentcount`="" 
      WHERE `id`=5

    Explain

    EXPLAIN not possible on query: UPDATE `j3du8_youtubegallery_videos` SET `title`="***Video not found*** (Cannot Connect to Youtube Server)", `alias`="video-not-found-cannot-connect-to-youtube-server", `description`="Cannot Connect to Youtube Server", `imageurl`="", `lastupdate`="2018-05-26 05:44:31", `status`="200", `startsecond`="0", `endsecond`="0", `publisheddate`="", `duration`="0", `rating_average`="0", `rating_max`="0", `rating_min`="0", `rating_numRaters`="0", `statistics_favoriteCount`="0", `statistics_viewCount`="0", `keywords`="", `likes`="0", `dislikes`="", `commentcount`="" WHERE `id`=5

    Profile

    Status	Duration
    starting	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    After opening tables	0.0 ms
    System lock	0.0 ms
    Table lock	0.0 ms
    init	0.0 ms
    updating	0.1 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    Unlocking tables	0.0 ms
    freeing items	0.0 ms
    updating status	0.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/components/com_youtubegallery/includes/misc.php:1523

    JROOT/components/com_youtubegallery/includes/layoutrenderer.php:975

    JROOT/components/com_youtubegallery/includes/layoutrenderer.php:133

    JROOT/components/com_youtubegallery/includes/layoutrenderer.php:397

    JROOT/components/com_youtubegallery/includes/render.php:161

    JROOT/components/com_youtubegallery/models/youtubegallery.php:146

    JROOT/libraries/legacy/view/legacy.php:398

    JROOT/components/com_youtubegallery/views/youtubegallery/view.html.php:28

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_youtubegallery/youtubegallery.php:20

    JROOT/libraries/cms/component/helper.php:352

    JROOT/libraries/cms/component/helper.php:332

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

57. Query Time: 0.94 ms After last query: 13.26 ms

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM j3du8_modules AS m
    
      LEFT JOIN j3du8_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN j3du8_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2018-05-26 05:44:31') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2018-05-26 05:44:31') 
      AND m.access IN (1,1) 
      AND m.client_id = 0 
      AND (mm.menuid = 285 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	range	PRIMARY,published,newsfeeds	published	5	NULL	23	Using index condition; Using where; Using filesort
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	303	mmotorsp_DfbdAb2jes.m.module,const	1	Using index condition; Using where
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	mmotorsp_DfbdAb2jes.m.id	2	Using where; Using index

    Profile

    Status	Duration
    starting	0.1 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    After opening tables	0.0 ms
    System lock	0.0 ms
    Table lock	0.0 ms
    init	0.0 ms
    optimizing	0.0 ms
    statistics	0.1 ms
    preparing	0.0 ms
    Sorting result	0.0 ms
    executing	0.0 ms
    Sending data	0.0 ms
    Creating sort index	0.5 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    Unlocking tables	0.0 ms
    freeing items	0.0 ms
    updating status	0.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/libraries/cms/module/helper.php:376

    JROOT/libraries/cms/module/helper.php:84

    JROOT/libraries/joomla/document/html/html.php:502

    JROOT/templates/kallyas/index.php:17

    JROOT/libraries/joomla/document/html/html.php:570

    JROOT/libraries/joomla/document/html/html.php:628

    JROOT/libraries/joomla/document/html/html.php:452

    JROOT/libraries/cms/application/cms.php:978

    JROOT/libraries/cms/application/site.php:702

    JROOT/libraries/cms/application/cms.php:261

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

58. Query Time: 0.32 ms After last query: 2.58 ms

    SELECT extension_id AS id, element AS "option", params, enabled
    
      FROM j3du8_extensions
    
      WHERE `type` = 'component' 
      AND `element` = 'com_content'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	j3du8_extensions	ref	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	Using index condition

    Profile

    Status	Duration
    starting	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    After opening tables	0.0 ms
    System lock	0.0 ms
    Table lock	0.0 ms
    init	0.0 ms
    optimizing	0.0 ms
    statistics	0.0 ms
    preparing	0.0 ms
    executing	0.0 ms
    Sending data	0.0 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    Unlocking tables	0.0 ms
    freeing items	0.0 ms
    updating status	0.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/libraries/joomla/cache/controller/callback.php:158

    JROOT/libraries/cms/component/helper.php:396

    JROOT/libraries/cms/component/helper.php:43

    JROOT/libraries/cms/component/helper.php:91

    JROOT/components/com_content/router.php:26

    JROOT/libraries/cms/router/site.php:455

    JROOT/libraries/cms/router/site.php:413

    JROOT/libraries/cms/router/router.php:216

    JROOT/libraries/cms/router/site.php:98

    JROOT/libraries/joomla/application/route.php:62

    JROOT/modules/mod_menu/helper.php:125

    JROOT/templates/kallyas/helper.php:333

    JROOT/templates/kallyas/index.php:267

    JROOT/libraries/joomla/document/html/html.php:570

    JROOT/libraries/joomla/document/html/html.php:628

    JROOT/libraries/joomla/document/html/html.php:452

    JROOT/libraries/cms/application/cms.php:978

    JROOT/libraries/cms/application/site.php:702

    JROOT/libraries/cms/application/cms.php:261

    JROOT/index.php:40

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---

59. Query Time: 1.47 ms After last query: 31.03 ms

    UPDATE `j3du8_session`
    
      SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1527313469;s:18:\"session.timer.last\";i:1527313469;s:17:\"session.timer.now\";i:1527313469;s:22:\"session.client.browser\";s:39:\"CCBot/2.0 (http://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\\0\\0\\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"1\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";N;s:14:\"\\0\\0\\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}}'
    	, `time` = '1527313471'
    
      WHERE `session_id` = '7jqge66icu757vposfec29fqk6'

    Explain

    EXPLAIN not possible on query: UPDATE `j3du8_session` SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1527313469;s:18:\"session.timer.last\";i:1527313469;s:17:\"session.timer.now\";i:1527313469;s:22:\"session.client.browser\";s:39:\"CCBot/2.0 (http://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\\0\\0\\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"1\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";N;s:14:\"\\0\\0\\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}}' , `time` = '1527313471' WHERE `session_id` = '7jqge66icu757vposfec29fqk6'

    Profile

    Status	Duration
    starting	0.1 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    After opening tables	0.0 ms
    System lock	0.0 ms
    Table lock	0.0 ms
    init	0.0 ms
    updating	0.1 ms
    end	0.0 ms
    query end	1.1 ms
    closing tables	0.0 ms
    Unlocking tables	0.0 ms
    freeing items	0.0 ms
    updating status	0.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/libraries/joomla/session/storage/database.php:85

    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

    ---