THIẾT BỊ ĐƯỜNG DÂY

PHỤ KIỆN ĐƯỜNG DÂY

THIẾT BỊ VIỄN THÔNG

THIẾT BỊ TRẠM BIẾN ÁP

THIẾT BỊ SẢN XUẤT

DANH MỤC SẢN PHẨM

Ra mắt mô hình 'Nhà máy thủy điện an toàn về phòng cháy chữa cháy và cứu nạn cứu hộ kiểu mẫu' trên địa bàn tỉnh Lai Châu

Công ty Thủy điện Sơn La vừa phối hợp với Công an tỉnh Lai Châu tổ chức ra mắt mô hình “Nhà máy thủy điện an toàn về phòng cháy chữa cháy và cứu nạn cứu hộ kiểu mẫu” trên địa bàn tỉnh Lai Châu cho công trình Nhà máy Thủy điện Lai Châu.

Công an tỉnh Lai Châu trao Quyết định và tặng hoa chúc mừng Công ty Thủy điện Sơn La với mô hình “Nhà máy thủy điện an toàn về phòng cháy chữa cháy và cứu nạn cứu hộ kiểu mẫu” tại NMTĐ Lai Châu

NMTĐ Lai Châu là một trong những công trình trọng điểm quốc gia, được xây dựng trên dòng Sông Đà thuộc thị trấn Nậm Nhùn, huyện Nậm Nhùn, tỉnh Lai Châu. Đây là công trình thủy điện không những có vai trò quan trọng trong việc phát triển điện, cấp nước cho đồng bằng sông hồng về mùa khô mà còn tạo cơ hội phát triển - kinh tế xã hội tại tỉnh Lai Châu, đảm bảo an ninh quốc phòng khu vực Tây Bắc.

Trong thời gian qua, Công ty Thủy điện Sơn La đã tổ chức thực hiện nghiêm túc các quy định của pháp luật về PCCC và CNCH tại NMTĐ Lai Châu và đạt được nhiều thành tích. Đặc biệt, Công ty Thủy điện Sơn La vinh dự được Công an tỉnh Lai Châu trao quyết định công nhận đạt mô hình “Nhà máy thủy điện an toàn về PCCC và CNCH kiểu mẫu” trên địa bàn tỉnh Lai Châu.

Thượng tá Nguyễn Tuấn Hưng – Phó Giám đốc Công an tỉnh Lai Châu ghi nhận và đánh giá cao công tác PCCC và CNCH tại NMTĐ Lai Châu của Công ty Thủy điện Sơn La, là đơn vị luôn đi đầu trong công tác PCCC và CNCH trên địa bàn tỉnh Lai Châu. Mong rằng công ty tiếp tục duy trì, phát huy thực hiện tốt các quy định của Pháp luật trong công tác PCCC và CNCH đảm bảo an toàn cho công trình trọng điểm quốc gia.

Ông Nguyễn Xuân Phong - Phó Giám đốc Công ty Thủy điện Sơn La cam kết thực hiện nghiêm các nội dung đảm bảo an toàn về PCCC và CNCH nhằm xây dựng và duy trì hoạt động của mô hình “Nhà máy thủy điện an toàn về PCCC và CNCH kiểu mẫu” trên địa bàn tỉnh Lai Châu tại NMTĐ Lai Châu, từ đó nhân rộng ra các NMTĐ khác, giúp thúc đẩy phong trào toàn dân tham gia phòng cháy chữa cháy, góp phần bảo đảm an ninh trật tự trên địa bàn tỉnh Lai Châu

theo Xuân Tiến từ EVN

: Tin tức; 12 Tháng 9 2022; Lượt xem: 624

Trụ sở chính công ty

Văn phòng đại diện tại TP Hồ Chí Minh

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1728671932,
                "last": 1728671932,
                "now": 1728671932
            },
            "token": "KP1V05PZuKZ2ejkf9UAgO3BpqCgEg5QD"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Profile Information

Time

Memory

Time: 12.61 ms / 12.61 ms Memory: 0.541 MB / 0.93 MB Application: afterLoad

Time: 58.15 ms / 70.76 ms Memory: 4.218 MB / 5.15 MB Application: afterInitialise

Time: 16.73 ms / 87.50 ms Memory: 0.702 MB / 5.85 MB Application: afterRoute

Time: 5.29 ms / 92.78 ms Memory: 0.239 MB / 6.09 MB Application: beforeRenderComponent com_content

Time: 5.84 ms / 98.62 ms Memory: 0.493 MB / 6.58 MB Application: Start JAccess::getAssetRules Old (1)

Time: 0.71 ms / 99.33 ms Memory: 0.033 MB / 6.61 MB Application: Finish JAccess::getAssetRules Old (1)

Time: 0.07 ms / 99.40 ms Memory: 0.000 MB / 6.61 MB Application: Start JAccess::preload(components)

Time: 2.26 ms / 101.66 ms Memory: 0.223 MB / 6.83 MB Application: Finish JAccess::preload(components)

Time: 116.27 ms / 217.94 ms Memory: 0.789 MB / 7.62 MB Application: New JAccess Preloading Process(com_content.article)

Time: 0.53 ms / 218.46 ms Memory: 0.144 MB / 7.76 MB Application: After preloadPermissionsParentIdMapping (com_content.article)

Time: 1.18 ms / 219.64 ms Memory: 0.203 MB / 7.96 MB Application: After preloadPermissions (com_content.article)

Time: 0.01 ms / 219.65 ms Memory: 0.001 MB / 7.97 MB Application: End New JAccess Preloading Process(com_content.article)

Time: 0.01 ms / 219.67 ms Memory: 0.001 MB / 7.97 MB Application: Start JAccess::getAssetRules New (com_content.article.480)

Time: 0.06 ms / 219.72 ms Memory: 0.005 MB / 7.97 MB Application: Finish JAccess::getAssetRules New (com_content.article.480)

Time: 17.28 ms / 237.00 ms Memory: 0.772 MB / 8.74 MB Application: afterRenderComponent com_content

Time: 4.98 ms / 241.98 ms Memory: 0.155 MB / 8.90 MB Application: afterDispatch

Time: 38.71 ms / 280.69 ms Memory: 1.960 MB / 10.86 MB Application: beforeRenderModule mod_vina_treeview_menus (Menus trên Mobile)

Time: 3.81 ms / 284.50 ms Memory: 0.099 MB / 10.96 MB Application: afterRenderModule mod_vina_treeview_menus (Menus trên Mobile)

Time: 2.95 ms / 287.45 ms Memory: 0.038 MB / 10.99 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 0.93 ms / 288.38 ms Memory: 0.085 MB / 11.08 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 1.25 ms / 289.63 ms Memory: 0.010 MB / 11.09 MB Application: beforeRenderModule mod_menu (MENU TOP)

Time: 2.74 ms / 292.38 ms Memory: 0.040 MB / 11.13 MB Application: afterRenderModule mod_menu (MENU TOP)

Time: 0.28 ms / 292.66 ms Memory: 0.000 MB / 11.11 MB Application: beforeRenderModule mod_languages (Chuyển ngôn ngữ)

Time: 1.96 ms / 294.62 ms Memory: 0.059 MB / 11.17 MB Application: afterRenderModule mod_languages (Chuyển ngôn ngữ)

Time: 2.14 ms / 296.76 ms Memory: 0.167 MB / 11.33 MB Application: afterRender

Database queries total: 71.01 ms

Memory Usage

Database Queries

38 Queries Logged 71.01 ms

7 duplicate found!

2 duplicates: #1 #6

2 duplicates: #5 #7

3 duplicates: #11 #20 #23

Query Time: 0.78 ms Query memory: 0.050 MB Memory before query: 4.562 MB Rows returned: 15

Duplicate queries: #6

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 lws_menu AS m

  LEFT JOIN lws_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	33	3.33	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	hkecc763_hkec.m.component_id	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
21	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
20	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
19	JFalangDatabase->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
18	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
17	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
16	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
15	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
14	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
13	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
12	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:197
11	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:535
10	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
9	JApplicationSite::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:130
8	PlgSystemLanguageFilter->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.14 ms After last query: 1.50 ms Query memory: 0.027 MB Memory before query: 4.709 MB Rows returned: 7

SELECT joomlatablename,tablepkID 
  FROM `lws_falang_tableinfo`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	lws_falang_tableinfo	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	7	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
26	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
25	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
24	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:142
23	FalangManager->_loadPrimaryKeyData()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:60
22	FalangManager->__construct()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:88
21	FalangManager::getInstance()	JROOT/components/com_falang/helpers/falang.class.php:52
20	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:326
19	JFalangDatabase->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
18	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
17	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
16	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
15	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
14	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
13	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
12	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:197
11	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:535
10	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
9	JApplicationSite::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:130
8	PlgSystemLanguageFilter->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.13 ms After last query: 0.11 ms Query memory: 0.029 MB Memory before query: 4.722 MB Rows returned: 6

SELECT * 
  FROM lws_languages 
  ORDER BY ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	lws_languages	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	6	100.00	Using filesort

Profile

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

Call Stack

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
26	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
25	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
24	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:317
23	FalangManager->getLanguages()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:66
22	FalangManager->__construct()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:88
21	FalangManager::getInstance()	JROOT/components/com_falang/helpers/falang.class.php:52
20	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:326
19	JFalangDatabase->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
18	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
17	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
16	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
15	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
14	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
13	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
12	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:197
11	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:535
10	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
9	JApplicationSite::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:130
8	PlgSystemLanguageFilter->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.61 ms After last query: 2.07 ms Query memory: 0.031 MB Memory before query: 4.894 MB Rows returned: 14

SHOW FULL COLUMNS 
  FROM `lws_languages`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `lws_languages`

Profile

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

Call Stack

#	Caller	File and line number
31	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
30	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
29	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
28	JFalangDatabase->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
27	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
26	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
25	JTable->__construct()	JROOT/administrator/components/com_falang/tables/JFLanguage.php:77
24	TableJFLanguage->__construct()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:323
23	FalangManager->getLanguages()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:66
22	FalangManager->__construct()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:88
21	FalangManager::getInstance()	JROOT/components/com_falang/helpers/falang.class.php:52
20	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:326
19	JFalangDatabase->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
18	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
17	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
16	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
15	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
14	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
13	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
12	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:197
11	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:535
10	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
9	JApplicationSite::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:130
8	PlgSystemLanguageFilter->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.14 ms After last query: 0.82 ms Query memory: 0.026 MB Memory before query: 4.953 MB Rows returned: 0

Duplicate queries: #7

SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 

  FROM lws_falang_content AS falang_content

  WHERE falang_content.language_id=6
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(491,427,416,501,504,502,158,468,478,426,154,506,479,507,508)
   
  AND falang_content.reference_table='menu'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	falang_content	NULL	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table	language_id	4	const	1	5.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
24	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
23	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:269
22	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:252
21	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:125
20	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:326
19	JFalangDatabase->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
18	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
17	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
16	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
15	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
14	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
13	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
12	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:197
11	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:535
10	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
9	JApplicationSite::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:130
8	PlgSystemLanguageFilter->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.16 ms After last query: 8.41 ms Query memory: 0.047 MB Memory before query: 5.588 MB Rows returned: 15

Duplicate queries: #1

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 lws_menu AS m

  LEFT JOIN lws_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	33	3.33	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	hkecc763_hkec.m.component_id	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
16	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
14	JFalangDatabase->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
13	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
12	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
11	JMenuSite->__construct()	JROOT/plugins/system/falangdriver/falangdriver.php:305
10	plgSystemFalangdriver->parseRule()	JROOT/libraries/cms/router/router.php:596
9	JRouter->processParseRules()	JROOT/libraries/cms/router/site.php:561
8	JRouterSite->processParseRules()	JROOT/libraries/cms/router/router.php:570
7	JRouter->_processParseRules()	JROOT/libraries/cms/router/router.php:224
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.14 ms After last query: 0.28 ms Query memory: 0.025 MB Memory before query: 5.657 MB Rows returned: 0

Duplicate queries: #5

SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 

  FROM lws_falang_content AS falang_content

  WHERE falang_content.language_id=6
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(491,427,416,501,504,502,158,468,478,426,154,506,479,507,508)
   
  AND falang_content.reference_table='menu'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	falang_content	NULL	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table	language_id	4	const	1	5.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
19	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:269
17	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:252
16	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:125
15	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:326
14	JFalangDatabase->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
13	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
12	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
11	JMenuSite->__construct()	JROOT/plugins/system/falangdriver/falangdriver.php:305
10	plgSystemFalangdriver->parseRule()	JROOT/libraries/cms/router/router.php:596
9	JRouter->processParseRules()	JROOT/libraries/cms/router/site.php:561
8	JRouterSite->processParseRules()	JROOT/libraries/cms/router/router.php:570
7	JRouter->_processParseRules()	JROOT/libraries/cms/router/router.php:224
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 2.07 ms After last query: 2.34 ms Query memory: 0.030 MB Memory before query: 5.763 MB Rows returned: 17

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM lws_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM lws_categories AS cat JOIN lws_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND badcats.id is null 
  AND c.language in ('vi-VN','*')

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	c	NULL	ALL	cat_idx,idx_access,idx_language	NO INDEX KEY COULD BE USED	NULL	NULL	26	73.96	Using where; Using temporary; Using filesort
1	PRIMARY	<derived2>	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	9	11.11	Using where; Not exists; Using join buffer (Block Nested Loop)
2	DERIVED	parent	NULL	range	cat_idx,idx_left_right	cat_idx	203	NULL	2	100.00	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	NULL	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias	idx_left_right	8	NULL	26	11.11	Using where; Using index; Using join buffer (Block Nested Loop)

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
14	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
12	JFalangDatabase->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
11	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
10	JCategories->get()	JROOT/components/com_content/router.php:341
9	ContentRouter->parse()	JROOT/libraries/cms/router/site.php:408
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.31 ms After last query: 0.45 ms Query memory: 0.022 MB Memory before query: 5.830 MB Rows returned: 0

SELECT `alias`,`catid`

  FROM `lws_content`

  WHERE `id` = 0

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
13	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
12	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
11	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
10	JFalangDatabase->loadObject()	JROOT/components/com_content/router.php:357
9	ContentRouter->parse()	JROOT/libraries/cms/router/site.php:408
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.95 ms After last query: 0.16 ms Query memory: 0.023 MB Memory before query: 5.839 MB Rows returned: 1

SELECT `id`

  FROM lws_content

  WHERE `catid` = 77 
  AND `alias` = 'ra-mat-mo-hinh-nha-may-thuy-dien-an-toan-ve-phong-chay-chua-chay-va-cuu-nan-cuu-ho-kieu-mau-tren-dia-ban-tinh-lai-chau'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	lws_content	NULL	ref	idx_catid	idx_catid	4	const	246	10.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
15	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
13	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
12	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
11	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:134
10	JFalangDatabase->loadResult()	JROOT/components/com_content/router.php:443
9	ContentRouter->parse()	JROOT/libraries/cms/router/site.php:408
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 2.64 ms After last query: 0.18 ms Query memory: 0.024 MB Memory before query: 5.848 MB Rows returned: 0

Duplicate queries: #20 #23

SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 

  FROM lws_falang_content AS falang_content

  WHERE falang_content.language_id=6
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(480)
   
  AND falang_content.reference_table='content'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	falang_content	NULL	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table	idxFalang1	4	const	1	5.00	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
18	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:269
16	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:252
15	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:125
14	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:326
13	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
12	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
11	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:134
10	JFalangDatabase->loadResult()	JROOT/components/com_content/router.php:443
9	ContentRouter->parse()	JROOT/libraries/cms/router/site.php:408
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.01 ms After last query: 0.84 ms Query memory: 0.005 MB Memory before query: 5.870 MB

UPDATE `lws_extensions`

  SET `params` = '{\"mediaversion\":\"b9f0c4b2b8a20267bfe2deebdf1d84b6\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	lws_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
10	JFalangDatabase->execute()	JROOT/libraries/cms/library/helper.php:119
9	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
8	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:977
4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.66 ms After last query: 8.33 ms Query memory: 0.027 MB Memory before query: 6.551 MB Rows returned: 8

SHOW FULL COLUMNS 
  FROM `lws_assets`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `lws_assets`

Profile

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
22	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
21	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
20	JFalangDatabase->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
18	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
17	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:60
16	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:308
15	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:696
14	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
13	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:435
10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:262
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.14 ms After last query: 0.20 ms Query memory: 0.026 MB Memory before query: 6.574 MB Rows returned: 1

SELECT *

  FROM lws_assets

  WHERE `id` = '1'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	lws_assets	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
21	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
20	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
19	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
18	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
17	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:426
16	JFalangDatabase->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
15	JTable->load()	JROOT/libraries/joomla/access/access.php:697
14	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
13	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:435
10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:262
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.11 ms After last query: 0.19 ms Query memory: 0.024 MB Memory before query: 6.580 MB Rows returned: 1

SELECT a.rules

  FROM lws_assets AS a

  WHERE (a.id = 1 OR a.name = 'root.1')

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,202	NULL	2	100.00	Using union(PRIMARY,idx_asset_name); Using where

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
17	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
15	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:170
14	JFalangDatabase->loadColumn()	JROOT/libraries/joomla/access/access.php:652
13	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:435
10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:262
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.93 ms After last query: 0.67 ms Query memory: 0.026 MB Memory before query: 6.608 MB Rows returned: 37

SELECT element

  FROM lws_extensions

  WHERE type = 'component' 
  AND enabled = '1'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	lws_extensions	NULL	ref	extension	extension	82	const	40	10.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
19	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
17	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:170
16	JFalangDatabase->loadColumn()	JROOT/libraries/joomla/access/access.php:413
15	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
14	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
13	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:435
10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:262
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.13 ms After last query: 0.22 ms Query memory: 0.027 MB Memory before query: 6.625 MB Rows returned: 37

SELECT a.name, a.rules

  FROM lws_assets AS a

  WHERE (a.name IN ('com_admin','com_ajax','com_akeeba','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_customfilters','com_easyjoomlabackup','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_multicategories','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_sigpro','com_tags','com_tcpdf','com_templates','com_users','com_virtuemart','com_virtuemart_allinone','com_wrapper') OR a.name = 'root.1')

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	range	idx_asset_name	idx_asset_name	202	NULL	38	100.00	Using index condition

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
19	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
17	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:451
16	JFalangDatabase->loadAssocList()	JROOT/libraries/joomla/access/access.php:441
15	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
14	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
13	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:435
10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:262
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.88 ms After last query: 1.50 ms Query memory: 0.033 MB Memory before query: 6.858 MB Rows returned: 30

SHOW FULL COLUMNS 
  FROM `lws_content`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `lws_content`

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
17	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
15	JFalangDatabase->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
13	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
12	JTable->__construct()	JROOT/libraries/legacy/table/content.php:31
11	JTableContent->__construct()	JROOT/libraries/joomla/table/table.php:308
10	JTable::getInstance()	JROOT/components/com_content/models/article.php:264
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.46 ms After last query: 2.54 ms Query memory: 0.024 MB Memory before query: 7.057 MB Rows returned: 1

SELECT *

  FROM lws_content

  WHERE `id` = '480'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	lws_content	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
16	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
14	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
13	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
12	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:426
11	JFalangDatabase->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
10	JTable->load()	JROOT/components/com_content/models/article.php:265
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.14 ms After last query: 0.31 ms Query memory: 0.025 MB Memory before query: 7.091 MB Rows returned: 0

Duplicate queries: #11 #23

SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 

  FROM lws_falang_content AS falang_content

  WHERE falang_content.language_id=6
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(480)
   
  AND falang_content.reference_table='content'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	falang_content	NULL	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table	idxFalang1	4	const	1	5.00	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
19	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:269
17	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:252
16	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:125
15	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:326
14	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
13	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
12	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:426
11	JFalangDatabase->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
10	JTable->load()	JROOT/components/com_content/models/article.php:265
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 47.64 ms After last query: 0.14 ms Query memory: 0.006 MB Memory before query: 7.096 MB

UPDATE lws_content

  SET `hits` = (`hits` + 1)

  WHERE `id` = '480'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	lws_content	NULL	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
11	JFalangDatabase->execute()	JROOT/libraries/joomla/table/table.php:1228
10	JTable->hit()	JROOT/components/com_content/models/article.php:266
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.21 ms After last query: 56.29 ms Query memory: 0.025 MB Memory before query: 7.234 MB Rows returned: 1

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count

  FROM lws_content AS a

  LEFT JOIN lws_categories AS c 
  on c.id = a.catid

  LEFT JOIN lws_users AS u 
  on u.id = a.created_by

  LEFT JOIN lws_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN lws_content_rating AS v 
  ON a.id = v.content_id

  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM lws_categories AS cat JOIN lws_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published <= 0 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  WHERE a.language in ('vi-VN','*') 
  AND a.id = 480 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-10-11 18:38:52') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-10-11 18:38:52') 
  AND (a.state = 1 OR a.state =2)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	a	NULL	const	PRIMARY,idx_state,idx_language	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	u	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	v	NULL	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	const	1	100.00	Using index
2	DERIVED	parent	NULL	range	cat_idx,idx_left_right	cat_idx	203	NULL	1	100.00	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	NULL	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias	idx_left_right	8	NULL	26	11.11	Using where; Using index; Using join buffer (Block Nested Loop)

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
17	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
15	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
14	JFalangDatabase->loadObject()	JROOT/components/com_content/models/article.php:159
13	ContentModelArticle->getItem()	JROOT/libraries/legacy/view/legacy.php:408
12	JViewLegacy->get()	JROOT/components/com_content/views/article/view.html.php:42
11	ContentViewArticle->display()	JROOT/libraries/joomla/cache/controller/view.php:95
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.09 ms After last query: 0.40 ms Query memory: 0.025 MB Memory before query: 7.253 MB Rows returned: 0

Duplicate queries: #11 #20

SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 

  FROM lws_falang_content AS falang_content

  WHERE falang_content.language_id=6
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(480)
   
  AND falang_content.reference_table='content'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	falang_content	NULL	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table	idxFalang1	4	const	1	5.00	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
20	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:269
18	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:252
17	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:125
16	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:326
15	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
14	JFalangDatabase->loadObject()	JROOT/components/com_content/models/article.php:159
13	ContentModelArticle->getItem()	JROOT/libraries/legacy/view/legacy.php:408
12	JViewLegacy->get()	JROOT/components/com_content/views/article/view.html.php:42
11	ContentViewArticle->display()	JROOT/libraries/joomla/cache/controller/view.php:95
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.10 ms After last query: 2.33 ms Query memory: 0.023 MB Memory before query: 7.422 MB Rows returned: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `lws_contentitem_tag_map` AS m 

  INNER JOIN `lws_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 480 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	hkecc763_hkec.m.tag_id	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
15	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
13	JFalangDatabase->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
12	JHelperTags->getItemTags()	JROOT/components/com_content/views/article/view.html.php:156
11	ContentViewArticle->display()	JROOT/libraries/joomla/cache/controller/view.php:95
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.13 ms After last query: 3.27 ms Query memory: 0.037 MB Memory before query: 7.618 MB Rows returned: 249

SELECT a.id, a.parent_id

  FROM lws_assets AS a

  WHERE (a.name LIKE 'com_content.%' OR a.name = 'com_content' OR a.id = 1)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ALL	PRIMARY,idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	404	20.20	Using where

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
21	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
20	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
19	JFalangDatabase->loadObjectList()	JROOT/libraries/joomla/access/access.php:332
18	JAccess::preloadPermissionsParentIdMapping()	JROOT/libraries/joomla/access/access.php:240
17	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
16	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
15	JUser->authorise()	JROOT/plugins/content/pagenavigation/pagenavigation.php:54
14	PlgContentPagenavigation->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:69
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:167
11	ContentViewArticle->display()	JROOT/libraries/joomla/cache/controller/view.php:95
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.18 ms After last query: 0.69 ms Query memory: 0.072 MB Memory before query: 7.774 MB Rows returned: 249

SELECT a.id, a.name, a.rules

  FROM lws_assets AS a

  WHERE (a.name LIKE 'com_content.%' OR a.name = 'com_content' OR a.id = 1 )

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ALL	PRIMARY,idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	404	20.20	Using where

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
20	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1255
19	JDatabaseDriver->getIterator()	JROOT/libraries/joomla/access/access.php:373
18	JAccess::preloadPermissions()	JROOT/libraries/joomla/access/access.php:243
17	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
16	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
15	JUser->authorise()	JROOT/plugins/content/pagenavigation/pagenavigation.php:54
14	PlgContentPagenavigation->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:69
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:167
11	ContentViewArticle->display()	JROOT/libraries/joomla/cache/controller/view.php:95
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 3.59 ms After last query: 0.81 ms Query memory: 0.098 MB Memory before query: 7.982 MB Rows returned: 240

SELECT a.id, a.title, a.catid, a.language, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug

  FROM lws_content AS a

  LEFT JOIN lws_categories AS cc 
  ON cc.id = a.catid

  WHERE a.catid = 77 
  AND a.state = 1 
  AND a.access IN (1,1,5)  
  AND (a.state = 1 OR a.state = -1) 
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-10-11 18:38:52') 
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-10-11 18:38:52') 
  AND a.language in ('vi-VN','*')

  ORDER BY  
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_access,idx_state,idx_catid,idx_language	idx_catid	4	const	246	16.00	Using index condition; Using where; Using filesort
1	SIMPLE	cc	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
17	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
15	JFalangDatabase->loadObjectList()	JROOT/plugins/content/pagenavigation/pagenavigation.php:152
14	PlgContentPagenavigation->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:69
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:167
11	ContentViewArticle->display()	JROOT/libraries/joomla/cache/controller/view.php:95
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.11 ms After last query: 1.94 ms Query memory: 0.025 MB Memory before query: 8.215 MB Rows returned: 0

SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 

  FROM lws_falang_content AS falang_content

  WHERE falang_content.language_id=6
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(495,493,492,491,490,488,487,486,485,484,483,482,481,480,479,478,477,476,475,474,473,472,467,466,465,464,463,462,461,460,459,458,457,456,455,454,453,452,451,450,449,446,445,444,443,442,441,440,439,438,437,436,435,434,433,430,432,431,429,428,427,426,425,424,423,422,421,420,419,418,417,416,415,414,412,411,410,409,408,407,406,405,403,402,401,400,399,397,398,396,395,394,393,388,387,386,385,384,383,381,382,380,379,378,377,375,374,373,372,370,368,367,363,361,360,359,304,302,301,300,299,298,296,295,289,288,287,286,285,284,283,282,281,280,279,278,277,272,271,270,269,268,267,266,265,264,263,262,260,259,258,257,256,255,254,253,252,249,243,241,240,236,232,231,230,229,228,227,226,225,224,223,222,221,220,209,208,207,206,205,203,202,201,200,199,198,197,196,195,194,193,192,190,189,188,186,185,184,183,182,173,172,171,170,169,168,167,163,162,161,160,159,158,154,153,152,151,150,149,148,140,139,138,132,130,129,128,127,126,124,118,117,116,115,114,111,109,103,102,91)
   
  AND falang_content.reference_table='content'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	falang_content	NULL	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table	language_id	4	const	1	5.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
20	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:269
18	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:252
17	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:125
16	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:326
15	JFalangDatabase->loadObjectList()	JROOT/plugins/content/pagenavigation/pagenavigation.php:152
14	PlgContentPagenavigation->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:69
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:167
11	ContentViewArticle->display()	JROOT/libraries/joomla/cache/controller/view.php:95
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.14 ms After last query: 10.67 ms Query memory: 0.021 MB Memory before query: 8.746 MB Rows returned: 1

SELECT language,id

  FROM `lws_menu`

  WHERE home = 1 
  AND published = 1 
  AND client_id = 0

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	lws_menu	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	18	1.52	Using where

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
11	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
9	JFalangDatabase->loadObjectList()	JROOT/libraries/cms/language/multilang.php:121
8	JLanguageMultilang::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:697
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.15 ms After last query: 0.23 ms Query memory: 0.022 MB Memory before query: 8.753 MB Rows returned: 0

SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 

  FROM lws_falang_content AS falang_content

  WHERE falang_content.language_id=6
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(491)
   
  AND falang_content.reference_table='menu'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	falang_content	NULL	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table	falangContent	310	const,const,const	1	10.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
14	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:269
12	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:252
11	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:125
10	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:326
9	JFalangDatabase->loadObjectList()	JROOT/libraries/cms/language/multilang.php:121
8	JLanguageMultilang::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:697
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.35 ms After last query: 0.43 ms Query memory: 0.025 MB Memory before query: 8.760 MB Rows returned: 1

SELECT alias

  FROM lws_content

  WHERE id=480

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	lws_content	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
19	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
17	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
16	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
15	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:134
14	JFalangDatabase->loadResult()	JROOT/components/com_content/router.php:118
13	ContentRouter->build()	JROOT/libraries/cms/router/site.php:496
12	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
11	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
10	JRouter->build()	JROOT/libraries/cms/router/site.php:147
9	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
8	JRoute::_()	JROOT/plugins/system/languagefilter/languagefilter.php:709
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.85 ms After last query: 1.05 ms Query memory: 0.021 MB Memory before query: 8.799 MB Rows returned: 0

SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`

  FROM `lws_content` AS `c`

  INNER JOIN `lws_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_content.item'

  INNER JOIN `lws_associations` AS `a2` 
  ON a.key = a2.key

  INNER JOIN `lws_content` AS `c2` 
  ON a2.id = c2.`id`

  INNER JOIN `lws_categories` AS `ca` 
  ON `c2`.`catid` = ca.id 
  AND ca.extension = 'com_content'

  WHERE c.id = 480

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
12	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
10	JFalangDatabase->loadObjectList()	JROOT/libraries/cms/language/associations.php:101
9	JLanguageAssociations::getAssociations()	JROOT/components/com_content/helpers/association.php:43
8	ContentHelperAssociation::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:729
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.88 ms After last query: 23.95 ms Query memory: 0.030 MB Memory before query: 10.590 MB Rows returned: 1

SHOW TABLES LIKE "lws_virtuemart_configs"

Explain

EXPLAIN not possible on query: SHOW TABLES LIKE "lws_virtuemart_configs"

Profile

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

Call Stack

#	Caller	File and line number
30	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
29	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
28	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
27	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
26	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
25	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:134
24	JFalangDatabase->loadResult()	JROOT/administrator/components/com_virtuemart/models/config.php:511
23	VirtueMartModelConfig::checkConfigTableExists()	JROOT/administrator/components/com_virtuemart/helpers/config.php:810
22	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:784
21	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:27
20	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
19	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
18	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
17	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
16	JRouter->build()	JROOT/libraries/cms/router/site.php:147
15	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
14	JRoute::_()	JROOT/plugins/system/helix3/core/classes/menu.php:112
13	Helix3Menu->initMenu()	JROOT/plugins/system/helix3/core/classes/menu.php:31
12	Helix3Menu->__construct()	JROOT/plugins/system/helix3/core/helix3.php:830
11	Helix3::loadMegaMenu()	JROOT/templates/vina_bubox/features/menu.php:34
10	Helix3FeatureMenu->renderFeature()	JROOT/plugins/system/helix3/core/helix3.php:200
9	Helix3::importFeatures()	JROOT/plugins/system/helix3/core/helix3.php:241
8	Helix3::generatelayout()	JROOT/templates/vina_bubox/index.php:131
7	require JROOT/templates/vina_bubox/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.10 ms After last query: 0.28 ms Query memory: 0.028 MB Memory before query: 10.604 MB Rows returned: 1

SELECT `config` 
  FROM `lws_virtuemart_configs` 
  WHERE `virtuemart_config_id` = "1";

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	lws_virtuemart_configs	NULL	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
28	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
27	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
26	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
25	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
24	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:134
23	JFalangDatabase->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/config.php:862
22	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:784
21	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:27
20	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
19	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
18	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
17	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
16	JRouter->build()	JROOT/libraries/cms/router/site.php:147
15	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
14	JRoute::_()	JROOT/plugins/system/helix3/core/classes/menu.php:112
13	Helix3Menu->initMenu()	JROOT/plugins/system/helix3/core/classes/menu.php:31
12	Helix3Menu->__construct()	JROOT/plugins/system/helix3/core/helix3.php:830
11	Helix3::loadMegaMenu()	JROOT/templates/vina_bubox/features/menu.php:34
10	Helix3FeatureMenu->renderFeature()	JROOT/plugins/system/helix3/core/helix3.php:200
9	Helix3::importFeatures()	JROOT/plugins/system/helix3/core/helix3.php:241
8	Helix3::generatelayout()	JROOT/templates/vina_bubox/index.php:131
7	require JROOT/templates/vina_bubox/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.61 ms After last query: 4.49 ms Query memory: 0.049 MB Memory before query: 10.870 MB Rows returned: 50

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM lws_modules AS m

  LEFT JOIN lws_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN lws_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 <= '2024-10-11 18:38:52') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-10-11 18:38:52') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 158 OR mm.menuid <= 0) 
  AND m.language IN ('vi-VN','*')

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	PRIMARY,published,newsfeeds,idx_language	published	5	NULL	30	1.55	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	hkecc763_hkec.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	hkecc763_hkec.m.id	3	40.00	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
18	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
16	JFalangDatabase->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:152
15	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:425
14	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:361
13	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
12	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:501
11	JDocumentHtml->countModules()	JROOT/plugins/system/helix3/core/helix3.php:507
10	Helix3::countModules()	JROOT/plugins/system/helix3/core/helix3.php:454
9	Helix3::rowColumns()	JROOT/plugins/system/helix3/core/helix3.php:263
8	Helix3::generatelayout()	JROOT/templates/vina_bubox/index.php:131
7	require JROOT/templates/vina_bubox/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.16 ms After last query: 0.34 ms Query memory: 0.026 MB Memory before query: 10.938 MB Rows returned: 0

SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 

  FROM lws_falang_content AS falang_content

  WHERE falang_content.language_id=6
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(193,99,17,198,205,206,238,207,230,187,112,201,243,200,115,209,222,109,242)
   
  AND falang_content.reference_table='modules'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	falang_content	NULL	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table	language_id	4	const	1	5.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
21	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
20	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:269
19	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:252
18	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:125
17	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:326
16	JFalangDatabase->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:152
15	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:425
14	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:361
13	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
12	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:501
11	JDocumentHtml->countModules()	JROOT/plugins/system/helix3/core/helix3.php:507
10	Helix3::countModules()	JROOT/plugins/system/helix3/core/helix3.php:454
9	Helix3::rowColumns()	JROOT/plugins/system/helix3/core/helix3.php:263
8	Helix3::generatelayout()	JROOT/templates/vina_bubox/index.php:131
7	require JROOT/templates/vina_bubox/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.21 ms After last query: 21.67 ms Query memory: 0.024 MB Memory before query: 11.177 MB Rows returned: 0

SELECT `c2`.`language`,`c2`.`id`

  FROM `lws_menu` AS `c`

  INNER JOIN `lws_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item'

  INNER JOIN `lws_associations` AS `a2` 
  ON a.key = a2.key

  INNER JOIN `lws_menu` AS `c2` 
  ON a2.id = c2.`id`

  WHERE c.id = 158

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
16	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
14	JFalangDatabase->loadObjectList()	JROOT/libraries/cms/language/associations.php:101
13	JLanguageAssociations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:284
12	MenusHelper::getAssociations()	JROOT/modules/mod_languages/helper.php:62
11	ModLanguagesHelper::getList()	JROOT/modules/mod_languages/mod_languages.php:17
10	include JROOT/modules/mod_languages/mod_languages.php	JROOT/libraries/cms/module/helper.php:199
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

29 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

8 × SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value  
  FROM lws_falang_content AS falang_content

2 × 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 lws_menu AS m 
  LEFT JOIN lws_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT `m`.`tag_id`,`t`.* 
  FROM `lws_contentitem_tag_map` AS m  
  INNER JOIN `lws_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM lws_modules AS m 
  LEFT JOIN lws_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN lws_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT `config` 
  FROM `lws_virtuemart_configs`

1 × SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid` 
  FROM `lws_content` AS `c` 
  INNER JOIN `lws_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_content.item' 
  INNER JOIN `lws_associations` AS `a2` 
  ON a.key = a2.key 
  INNER JOIN `lws_content` AS `c2` 
  ON a2.id = c2.`id` 
  INNER JOIN `lws_categories` AS `ca` 
  ON `c2`.`catid` = ca.id 
  AND ca.extension = 'com_content'

```
1 × SELECT alias 
  FROM lws_content
```

1 × SELECT language,id 
  FROM `lws_menu`

1 × SELECT a.id, a.title, a.catid, a.language, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug 
  FROM lws_content AS a 
  LEFT JOIN lws_categories AS cc 
  ON cc.id = a.catid

1 × SELECT a.id, a.name, a.rules 
  FROM lws_assets AS a

1 × SELECT a.id, a.parent_id 
  FROM lws_assets AS a

```
1 × SELECT * 
  FROM lws_content
```

1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count 
  FROM lws_content AS a 
  LEFT JOIN lws_categories AS c 
  on c.id = a.catid 
  LEFT JOIN lws_users AS u 
  on u.id = a.created_by 
  LEFT JOIN lws_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN lws_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM lws_categories AS cat JOIN lws_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT joomlatablename,tablepkID 
  FROM `lws_falang_tableinfo

1 × SELECT a.name, a.rules 
  FROM lws_assets AS a

1 × SELECT element 
  FROM lws_extensions

1 × SELECT a.rules 
  FROM lws_assets AS a

```
1 × SELECT * 
  FROM lws_assets
```
```
1 × SELECT `id` 
  FROM lws_content
```

1 × SELECT `alias`,`catid` 
  FROM `lws_content`

1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM lws_categories as c 
  LEFT JOIN  (SELECT cat.id as id 
  FROM lws_categories AS cat JOIN lws_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

```
1 × SELECT * 
  FROM lws_languages
```

1 × SELECT `c2`.`language`,`c2`.`id` 
  FROM `lws_menu` AS `c` 
  INNER JOIN `lws_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item' 
  INNER JOIN `lws_associations` AS `a2` 
  ON a.key = a2.key 
  INNER JOIN `lws_menu` AS `c2` 
  ON a2.id = c2.`id`

OTHER Tables:

1 × SHOW FULL COLUMNS 
  FROM `lws_languages

1 × UPDATE `lws_extensions` 
  SET `params` = '{\"mediaversion\":\"b9f0c4b2b8a20267bfe2deebdf1d84b6\"}'

1 × SHOW FULL COLUMNS 
  FROM `lws_assets

1 × SHOW FULL COLUMNS 
  FROM `lws_content

1 × UPDATE lws_content 
  SET `hits` = (`hits` + 1)

1 × SHOW TABLES LIKE "lws_virtuemart_configs

THIẾT BỊ ĐƯỜNG DÂY

PHỤ KIỆN ĐƯỜNG DÂY

THIẾT BỊ VIỄN THÔNG

THIẾT BỊ TRẠM BIẾN ÁP

THIẾT BỊ SẢN XUẤT

DANH MỤC SẢN PHẨM

Tin tức

Ra mắt mô hình 'Nhà máy thủy điện an toàn về phòng cháy chữa cháy và cứu nạn cứu hộ kiểu mẫu' trên địa bàn tỉnh Lai Châu

Hỗ trợ trực tuyến

Trụ sở chính công ty

Văn phòng đại diện tại TP Hồ Chí Minh

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

38 Queries Logged 71.01 ms

7 duplicate found!

29 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: