Review Detail

5.0 4

רב-דף - דפי נחיתה של "רב מסר" חודשיים חינם

דפי נחיתה - השוואת מערכות לבניית דף נחיתה 13565

מערכת מצויינת ומאוד נוחה!

יולי 05, 2013

דירוג כללי

5.0

התועלת שבמוצר או תוכנה

5.0

הגינות המחיר

5.0

קושי השימוש וההבנה

5.0

איכות התמיכה

5.0

התחלתי בגרסה הניסיונית של רב מסר שמגיעה עם רב דף. ואני הולך לקנות את המוצר. מערכת מצויינת ומאוד נוחה לשימוש.

בליג

דווח על חוות הדעת האם חוות הדעת סייעה לך? 0 0

תגובות

כדי לכתוב תגובה, אנא register אוהרחיב ב

קטגוריה

מילות מפתח

דירוג המשתמש

מה אחרים חשבו?

דפי הנחיתה של "שלח מסר"

4.0

א אנונימי

"אודות החברה: 'שלח מסר', זו מערכת שכוללת: דיוור אלקטרוני..."

PageWiz - מערכת דפי נחיתה מקצועית

5.0

A Amit

"מוצר מעולה, תמיכה סופר מהירה!"

רב-דף - דפי נחיתה של "רב מסר" חודשיים חינם

5.0

ב בליג

"התחלתי בגרסה הניסיונית של רב מסר שמגיעה עם רב דף...."

רב-דף - דפי נחיתה של "רב מסר" חודשיים חינם

5.0

אש אהבה שמעיה

"באמצעות השימוש ברב מסר הפכתי את הקורס הזה: http://ahavamusic.ravpage.co.il/hakaftor-GuitarCourse-early לרב..."

רב-דף - דפי נחיתה של "רב מסר" חודשיים חינם

5.0

על עדי ליניאל

"מערכת מצויינת ומומלצת!"

מערכת דפי הנחיתה fbPage גם לפייסבוק ולמובייל

4.8

ה הדר

"מערכת דפי נחיתה זו עונה על כל הדרישות שלי ממערכת..."

מערכת דפי הנחיתה fbPage גם לפייסבוק ולמובייל

4.8

חק חיים קנדל

"שירות מעלה, מערכת מצוינת , מחירים נוחים - בסה"כ ממליץ..."

מערכת דפי הנחיתה fbPage גם לפייסבוק ולמובייל

5.0

רל רוני לב

"מערכת קלה לתפעול וללמידה. המון סרטוני הדרכה והשירות והתמיכה מעל..."

מערכת דפי הנחיתה fbPage גם לפייסבוק ולמובייל

5.0

מא מיכל אופיר

"אני מאוד שמחה שבחרתי את מערכת דפי הנחיתה fbPage. המערכת..."

רב-דף - דפי נחיתה של "רב מסר" חודשיים חינם

5.0

אה אוריאל הרצוג - אתר השתלמוודל

"מוצר נפלא, נותן גם מענה טכני פשוט ביותר להפעלה עם..."

דיונים אחרונים בפורום

אין הודעות לתצוגה.

קונסול ניטור של ג'ומלה

Session

{
    "__default": {
        "session": {
            "counter": 4,
            "timer": {
                "start": 1745625489,
                "last": 1745625492,
                "now": 1745625493
            },
            "client": {
                "forwarded": "3.141.192.51"
            },
            "token": "8oRHT2ssoGikOC1gEJLdtYHBB8A7BiBA"
        },
        "registry": {
            "cmobile": {
                "ismobile": false,
                "isdevice": false,
                "device": "{}",
                "detection": {
                    "system": false
                }
            },
            "com_kunena": {
                "user0_read": {
                    "1": 1,
                    "6": 6,
                    "2": 2,
                    "3": 3,
                    "5": 5,
                    "7": 7
                }
            }
        },
        "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
        }
    },
    "__jreviews": {
        "user": null,
        "gid": null
    },
    "__findCount": {
        "Review": {
            "f6bce4d283959ec5606494b57ab49597": "7"
        },
        "Discussion": {
            "ba6a749e00f2076bb9afbe43c3ae9a7d": "0",
            "715f15aab31c67c07cf5d0d73d5de025": "0",
            "c502ba0463b7b124ee919f7459ee477c": "0"
        }
    }
}

מידע פרופיל

Time

Memory

Time: 4.29 ms / 4.29 ms Memory: 0.415 MB / 0.78 MB Application: afterLoad

Time: 33.60 ms / 37.89 ms Memory: 2.080 MB / 2.86 MB Application: afterInitialise

Time: 4.29 ms / 42.18 ms Memory: 0.202 MB / 3.06 MB Application: Before Access::preloadComponents (all components)

Time: 1.20 ms / 43.38 ms Memory: 0.069 MB / 3.13 MB Application: After Access::preloadComponents (all components)

Time: 0.03 ms / 43.41 ms Memory: -0.004 MB / 3.12 MB Application: Before Access::getAssetRules (id:16 name:com_menus)

Time: 0.29 ms / 43.70 ms Memory: 0.008 MB / 3.13 MB Application: After Access::getAssetRules (id:16 name:com_menus)

Time: 0.06 ms / 43.76 ms Memory: 0.001 MB / 3.13 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Time: 0.03 ms / 43.78 ms Memory: 0.007 MB / 3.14 MB Application: After Access::getAssetRules (id:1 name:root.1)

Time: 1.69 ms / 45.47 ms Memory: 0.045 MB / 3.18 MB Application: afterRoute

Time: 0.77 ms / 46.24 ms Memory: 0.013 MB / 3.20 MB Application: beforeRenderComponent com_jreviews

Time: 249.12 ms / 295.35 ms Memory: 4.954 MB / 8.15 MB Application: afterRenderComponent com_jreviews

Time: 0.95 ms / 296.30 ms Memory: 0.011 MB / 8.16 MB Application: afterDispatch

Time: 19.30 ms / 315.61 ms Memory: 1.093 MB / 9.25 MB Application: beforeRenderModule mod_jreviews_advsearch (JReviews Advanced Search Module)

Time: 5.52 ms / 321.12 ms Memory: 0.114 MB / 9.37 MB Application: afterRenderModule mod_jreviews_advsearch (JReviews Advanced Search Module)

Time: 1.45 ms / 322.57 ms Memory: 0.030 MB / 9.40 MB Application: beforeRenderModule mod_menu (Top Menu)

Time: 1.68 ms / 324.26 ms Memory: 0.083 MB / 9.48 MB Application: afterRenderModule mod_menu (Top Menu)

Time: 1.51 ms / 325.77 ms Memory: 0.015 MB / 9.49 MB Application: beforeRenderModule mod_search (Search)

Time: 1.10 ms / 326.87 ms Memory: 0.029 MB / 9.52 MB Application: afterRenderModule mod_search (Search)

Time: 0.26 ms / 327.12 ms Memory: -0.001 MB / 9.52 MB Application: beforeRenderModule mod_menu (ביקורות על חברות אחסון, קורסים לבניית אתרים ועוד )

Time: 6.81 ms / 333.93 ms Memory: 0.175 MB / 9.70 MB Application: afterRenderModule mod_menu (ביקורות על חברות אחסון, קורסים לבניית אתרים ועוד )

Time: 2.81 ms / 336.74 ms Memory: -0.003 MB / 9.69 MB Application: beforeRenderModule mod_custom (logo)

Time: 0.57 ms / 337.31 ms Memory: 0.006 MB / 9.70 MB Application: afterRenderModule mod_custom (logo)

Time: 0.22 ms / 337.53 ms Memory: 0.000 MB / 9.70 MB Application: beforeRenderModule mod_custom (logo-mobile)

Time: 0.32 ms / 337.85 ms Memory: 0.002 MB / 9.70 MB Application: afterRenderModule mod_custom (logo-mobile)

Time: 1.21 ms / 339.06 ms Memory: 0.018 MB / 9.72 MB Application: beforeRenderModule mod_custom (שומר שבת 1)

Time: 0.29 ms / 339.35 ms Memory: 0.003 MB / 9.72 MB Application: afterRenderModule mod_custom (שומר שבת 1)

Time: 0.04 ms / 339.39 ms Memory: 0.008 MB / 9.73 MB Application: beforeRenderModule mod_jreviews_reviews (מה אחרים חשבו?)

Time: 20.28 ms / 359.67 ms Memory: 0.612 MB / 10.34 MB Application: afterRenderModule mod_jreviews_reviews (מה אחרים חשבו?)

Time: 0.06 ms / 359.73 ms Memory: -0.001 MB / 10.34 MB Application: beforeRenderModule mod_kunenalatest (דיונים אחרונים בפורום)

Time: 14.19 ms / 373.92 ms Memory: 0.595 MB / 10.94 MB Application: Before Access::getAssetRules (id:635 name:com_kunena)

Time: 0.02 ms / 373.94 ms Memory: 0.002 MB / 10.94 MB Application: After Access::getAssetRules (id:635 name:com_kunena)

Time: 9.59 ms / 383.53 ms Memory: 0.107 MB / 11.05 MB Application: afterRenderModule mod_kunenalatest (דיונים אחרונים בפורום)

Time: 0.05 ms / 383.58 ms Memory: -0.008 MB / 11.04 MB Application: beforeRenderModule mod_custom (שומר שבת 2)

Time: 0.44 ms / 384.02 ms Memory: 0.005 MB / 11.04 MB Application: afterRenderModule mod_custom (שומר שבת 2)

Time: 0.65 ms / 384.67 ms Memory: 0.017 MB / 11.06 MB Application: beforeRenderModule mod_menu (קורסים ומוצרים לבניית אתרים ושיווק באינטרנט)

Time: 3.17 ms / 387.84 ms Memory: 0.052 MB / 11.11 MB Application: afterRenderModule mod_menu (קורסים ומוצרים לבניית אתרים ושיווק באינטרנט)

Time: 1.53 ms / 389.37 ms Memory: -0.000 MB / 11.11 MB Application: beforeRenderModule mod_menu (Main Menu - mobile)

Time: 3.85 ms / 393.22 ms Memory: 0.015 MB / 11.13 MB Application: afterRenderModule mod_menu (Main Menu - mobile)

Time: 616.13 ms / 1009.35 ms Memory: 0.626 MB / 11.75 MB Application: beforeProcess plgSystem (JCH Optimize)

Time: 0.33 ms / 1009.68 ms Memory: 0.006 MB / 11.76 MB Application: afterLoadClass plgSystem (JCH Optimize)

Time: 2.22 ms / 1011.90 ms Memory: 0.100 MB / 11.86 MB Application: afterParseUserAgent plgSystem (JCH Optimize)

Time: 0.18 ms / 1012.08 ms Memory: 0.004 MB / 11.86 MB Application: afterSetUpExcludes plgSystem (JCH Optimize)

Time: 0.02 ms / 1012.10 ms Memory: 0.002 MB / 11.87 MB Application: afterInitSearch plgSystem (JCH Optimize)

Time: 0.98 ms / 1013.08 ms Memory: 0.095 MB / 11.96 MB Application: afterSearchArea - head plgSystem (JCH Optimize)

Time: 0.30 ms / 1013.39 ms Memory: -0.009 MB / 11.95 MB Application: afterRunCronTasks plgSystem (JCH Optimize)

Time: 0.39 ms / 1013.78 ms Memory: 0.008 MB / 11.96 MB Application: afterGetCombinedFiles - css plgSystem (JCH Optimize)

Time: 0.26 ms / 1014.04 ms Memory: 0.068 MB / 12.03 MB Application: afterCreateStaticFiles - css plgSystem (JCH Optimize)

Time: 0.20 ms / 1014.23 ms Memory: 0.001 MB / 12.03 MB Application: afterReplaceLinks - css plgSystem (JCH Optimize)

Time: 0.02 ms / 1014.25 ms Memory: -0.068 MB / 11.96 MB Application: afterProcess plgSystem (JCH Optimize)

Time: 0.02 ms / 1014.27 ms Memory: -0.071 MB / 11.89 MB Application: afterRender

Database queries total: 697.78 ms

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

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Same as call in the line below.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:854
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:414
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j3x_extensions	NULL	ref	extension	extension	82	const	50	1.00	Using where

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

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	b	NULL	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	2	100.00	Using where

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j3x_extensions	NULL	ref	extension	extension	82	const	276	0.40	Using index condition; Using where; Using filesort

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j3x_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

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

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
12	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
11	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
10	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
9	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
8	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/jamp/jamp.php:808
7	PlgSystemJAmp->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:695
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j3x_osmembership_urls	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	7	14.29	Using where

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
9	JDatabaseDriver->loadColumn()	JROOT/plugins/system/osmembershipurls/osmembershipurls.php:145
8	plgSystemOSMembershipUrls->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:696
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j3x_osmembership_plans	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	8	12.50	Using where

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
9	JDatabaseDriver->loadColumn()	JROOT/plugins/system/osmembershipurls/osmembershipurls.php:157
8	plgSystemOSMembershipUrls->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:696
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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	223	3.33	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	freepate_bikorn.m.component_id	1	100.00	Using where

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
18	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:445
14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
12	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
11	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:561
10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/jreviews_sef/joomla_380/jreviews_sef.php:50
8	plgSystemJreviews_sef->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:696
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j3x_jreviews_categories	NULL	const	PRIMARY,option	PRIMARY	156	const,const	1	100.00	Using index

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/plugins/system/jreviews_sef/joomla_380/router.php:2639
12	JReviewsRouter->isJReviewsCategory()	JROOT/plugins/system/jreviews_sef/joomla_380/router.php:1373
11	JReviewsRouter->parseRule()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
9	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:597
8	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:570
7	Joomla\CMS\Router\Router->_processParseRules()	JROOT/libraries/src/Router/Router.php:216
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1170
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/components/com_osmembership/helper/helper.php:30
9	OSMembershipHelper::getConfig()	JROOT/plugins/system/registrationredirect/registrationredirect.php:46
8	plgSystemRegistrationRedirect->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1218
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j3x_jreviews_categories	NULL	const	PRIMARY,option	PRIMARY	156	const,const	1	100.00	Using index

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
19	JDatabaseDriver->loadResult()	JROOT/plugins/system/jreviews_sef/joomla_380/router.php:2639
18	JReviewsRouter->isJReviewsCategory()	JROOT/plugins/system/jreviews_sef/joomla_380/router.php:1373
17	JReviewsRouter->parseRule()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
15	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:597
14	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:570
13	Joomla\CMS\Router\Router->_processParseRules()	JROOT/libraries/src/Router/Router.php:216
12	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
11	Joomla\CMS\Router\SiteRouter->parse()	JROOT/plugins/system/easyfrontendseo/easyfrontendseo.php:280
10	PlgSystemEasyFrontendSeo->buildInternalUrl()	JROOT/plugins/system/easyfrontendseo/easyfrontendseo.php:220
9	PlgSystemEasyFrontendSeo->getCorrectUrlId()	JROOT/plugins/system/easyfrontendseo/easyfrontendseo.php:186
8	PlgSystemEasyFrontendSeo->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1218
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_client_id	1	const	4	100.00	NULL
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	freepate_bikorn.s.template,const	1	5.00	Using index condition; Using where

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
10	JDatabase->query()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:72
9	S2Model->query()	JROOT/components/com_jreviews/jreviews/framework.php:92
8	require JROOT/components/com_jreviews/jreviews/framework.php	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:18
7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

EXPLAIN not possible on query: INSERT INTO j3x_jreviews_reviewer_ranks (user_id, reviews, votes_percent_helpful, votes_total) ( SELECT userid AS user_id, COUNT(*) AS reviews, (IF(SUM(vote_total)>0,SUM(vote_helpful)/SUM(vote_total),0)) AS votes_percent_helpful, SUM(vote_total) AS votes_total FROM j3x_jreviews_comments AS Review RIGHT JOIN j3x_users AS User ON User.id = Review.userid AND User.block = 0 WHERE userid > 0 AND published = 1 GROUP BY userid ORDER BY NULL ) ON DUPLICATE KEY UPDATE reviews = VALUES(reviews), votes_percent_helpful = VALUES(votes_percent_helpful), votes_total = VALUES(votes_total);

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
Waiting for table level lock	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.02 ms
Sorting result	0.00 ms
executing	0.01 ms
Sending data	1.12 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.03 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
16	JDatabase->query()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:72
15	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/review.php:1314
14	ReviewModel->rebuildRanksTable()	JROOT/components/com_jreviews/jreviews/plugins/cron_functions.php:111
13	CronFunctionsComponent->rebuildRankTable()	JROOT/components/com_jreviews/jreviews/plugins/cron_functions.php:46
12	CronFunctionsComponent->startup()	JROOT/components/com_s2framework/s2framework/libs/controller/controller.php:141
11	S2Controller->__initComponents()	JROOT/components/com_jreviews/jreviews/controllers/my_controller.php:636
10	MyController->_initPlugins()	JROOT/components/com_jreviews/jreviews/controllers/my_controller.php:248
9	MyController->beforeFilter()	JROOT/components/com_s2framework/s2framework/dispatcher.php:335
8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:207
7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.60 ms After last query: 0.11 ms Query memory: 0.008 MB Memory before query: 7.449 MB

INSERT INTO
                j3x_jreviews_reviewer_ranks (user_id, `rank`)
                (
                    SELECT
                        user_id,
                        @curRank := @curRank + 1 AS `rank`
                    
  FROM
                        j3x_jreviews_reviewer_ranks, (SELECT @curRank := 0) r
                    
  ORDER BY
                        reviews DESC, votes_percent_helpful DESC
                )
            
  ON DUPLICATE KEY UPDATE
                `rank` = 
  VALUES(`rank`);

Explain

EXPLAIN not possible on query: INSERT INTO j3x_jreviews_reviewer_ranks (user_id, `rank`) ( SELECT user_id, @curRank := @curRank + 1 AS `rank` FROM j3x_jreviews_reviewer_ranks, (SELECT @curRank := 0) r ORDER BY reviews DESC, votes_percent_helpful DESC ) ON DUPLICATE KEY UPDATE `rank` = VALUES(`rank`);

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.15 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
optimizing	0.01 ms
executing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
Creating tmp table	0.01 ms
Sorting for order	0.00 ms
executing	0.01 ms
Sending data	0.21 ms
end	0.00 ms
query end	0.00 ms
removing tmp table	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.00 ms
closing tables	0.03 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
16	JDatabase->query()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:72
15	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/review.php:1316
14	ReviewModel->rebuildRanksTable()	JROOT/components/com_jreviews/jreviews/plugins/cron_functions.php:111
13	CronFunctionsComponent->rebuildRankTable()	JROOT/components/com_jreviews/jreviews/plugins/cron_functions.php:46
12	CronFunctionsComponent->startup()	JROOT/components/com_s2framework/s2framework/libs/controller/controller.php:141
11	S2Controller->__initComponents()	JROOT/components/com_jreviews/jreviews/controllers/my_controller.php:636
10	MyController->_initPlugins()	JROOT/components/com_jreviews/jreviews/controllers/my_controller.php:248
9	MyController->beforeFilter()	JROOT/components/com_s2framework/s2framework/dispatcher.php:335
8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:207
7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->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.10 ms Query memory: 0.009 MB Memory before query: 7.458 MB

INSERT INTO j3x_jreviews_config ( id, value ) 
  VALUES ('media_likes_rebuild_last','1745625493') 
  ON DUPLICATE KEY UPDATE value = 
  VALUES(value)

Explain

EXPLAIN not possible on query: INSERT INTO j3x_jreviews_config ( id, value ) VALUES ('media_likes_rebuild_last','1745625493') ON DUPLICATE KEY UPDATE value = VALUES(value)

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
update	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
18	JDatabase->query()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:72
17	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/configuration.php:82
16	JReviews\Models\ConfigurationModel->store()	JROOT/components/com_jreviews/jreviews/services/configuration/configuration.php:823
15	JReviews\Services\Configuration->store()	JROOT/components/com_jreviews/jreviews/plugins/cron_functions.php:56
14	CronFunctionsComponent->run()	JROOT/components/com_jreviews/jreviews/plugins/cron_functions.php:117
13	CronFunctionsComponent->rebuildMediaLikesTable()	JROOT/components/com_jreviews/jreviews/plugins/cron_functions.php:49
12	CronFunctionsComponent->startup()	JROOT/components/com_s2framework/s2framework/libs/controller/controller.php:141
11	S2Controller->__initComponents()	JROOT/components/com_jreviews/jreviews/controllers/my_controller.php:636
10	MyController->_initPlugins()	JROOT/components/com_jreviews/jreviews/controllers/my_controller.php:248
9	MyController->beforeFilter()	JROOT/components/com_s2framework/s2framework/dispatcher.php:335
8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:207
7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.68 ms After last query: 1.11 ms Query memory: 0.008 MB Memory before query: 7.496 MB

INSERT INTO
				j3x_jreviews_media (media_id, likes_up, likes_total)
				(SELECT
					media_id AS media_id,
					SUM(IF(vote = 1, 1, 0)) AS likes_up,
					COUNT(*) AS likes_total
				
  FROM j3x_jreviews_media_likes
				
				
  GROUP BY media_id
				
  ORDER BY NULL
				)
			
  ON DUPLICATE KEY UPDATE
				likes_up = 
  VALUES(likes_up),
				likes_total = 
  VALUES(likes_total);

Explain

EXPLAIN not possible on query: INSERT INTO j3x_jreviews_media (media_id, likes_up, likes_total) (SELECT media_id AS media_id, SUM(IF(vote = 1, 1, 0)) AS likes_up, COUNT(*) AS likes_total FROM j3x_jreviews_media_likes GROUP BY media_id ORDER BY NULL ) ON DUPLICATE KEY UPDATE likes_up = VALUES(likes_up), likes_total = VALUES(likes_total);

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.16 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
Creating tmp table	0.02 ms
executing	0.01 ms
Sending data	0.25 ms
end	0.01 ms
query end	0.00 ms
removing tmp table	0.00 ms
query end	0.00 ms
closing tables	0.04 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
16	JDatabase->query()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:72
15	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/media_like.php:177
14	MediaLikeModel->updateCount()	JROOT/components/com_jreviews/jreviews/plugins/cron_functions.php:123
13	CronFunctionsComponent->rebuildMediaLikesTable()	JROOT/components/com_jreviews/jreviews/plugins/cron_functions.php:49
12	CronFunctionsComponent->startup()	JROOT/components/com_s2framework/s2framework/libs/controller/controller.php:141
11	S2Controller->__initComponents()	JROOT/components/com_jreviews/jreviews/controllers/my_controller.php:636
10	MyController->_initPlugins()	JROOT/components/com_jreviews/jreviews/controllers/my_controller.php:248
9	MyController->beforeFilter()	JROOT/components/com_s2framework/s2framework/dispatcher.php:335
8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:207
7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.57 ms After last query: 0.09 ms Query memory: 0.024 MB Memory before query: 7.505 MB Rows returned: 1

SELECT @max_likes := MAX(likes_total) 
  FROM j3x_jreviews_media;

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.24 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
16	JDatabase->query()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:72
15	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/media_like.php:181
14	MediaLikeModel->updateCount()	JROOT/components/com_jreviews/jreviews/plugins/cron_functions.php:123
13	CronFunctionsComponent->rebuildMediaLikesTable()	JROOT/components/com_jreviews/jreviews/plugins/cron_functions.php:49
12	CronFunctionsComponent->startup()	JROOT/components/com_s2framework/s2framework/libs/controller/controller.php:141
11	S2Controller->__initComponents()	JROOT/components/com_jreviews/jreviews/controllers/my_controller.php:636
10	MyController->_initPlugins()	JROOT/components/com_jreviews/jreviews/controllers/my_controller.php:248
9	MyController->beforeFilter()	JROOT/components/com_s2framework/s2framework/dispatcher.php:335
8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:207
7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.47 ms After last query: 0.09 ms Query memory: 0.008 MB Memory before query: 7.514 MB

INSERT INTO
					j3x_jreviews_media (media_id, likes_rank)
					(SELECT
						media_id AS media_id,
						(SUM(IF(vote = 1, 1,0))/COUNT(*)) * (COUNT(*)/@max_likes) * 16000000 AS likes_rank
					
  FROM
						j3x_jreviews_media_likes
					
  GROUP BY
						media_id
					
  ORDER BY
						NULL
					)
				
  ON DUPLICATE KEY UPDATE
						likes_rank = 
  VALUES(likes_rank);

Explain

EXPLAIN not possible on query: INSERT INTO j3x_jreviews_media (media_id, likes_rank) (SELECT media_id AS media_id, (SUM(IF(vote = 1, 1,0))/COUNT(*)) * (COUNT(*)/@max_likes) * 16000000 AS likes_rank FROM j3x_jreviews_media_likes GROUP BY media_id ORDER BY NULL ) ON DUPLICATE KEY UPDATE likes_rank = VALUES(likes_rank);

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
Creating tmp table	0.02 ms
executing	0.01 ms
Sending data	0.26 ms
end	0.00 ms
query end	0.01 ms
removing tmp table	0.00 ms
query end	0.00 ms
closing tables	0.04 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
16	JDatabase->query()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:72
15	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/media_like.php:183
14	MediaLikeModel->updateCount()	JROOT/components/com_jreviews/jreviews/plugins/cron_functions.php:123
13	CronFunctionsComponent->rebuildMediaLikesTable()	JROOT/components/com_jreviews/jreviews/plugins/cron_functions.php:49
12	CronFunctionsComponent->startup()	JROOT/components/com_s2framework/s2framework/libs/controller/controller.php:141
11	S2Controller->__initComponents()	JROOT/components/com_jreviews/jreviews/controllers/my_controller.php:636
10	MyController->_initPlugins()	JROOT/components/com_jreviews/jreviews/controllers/my_controller.php:248
9	MyController->beforeFilter()	JROOT/components/com_s2framework/s2framework/dispatcher.php:335
8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:207
7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.48 ms After last query: 0.78 ms Query memory: 0.024 MB Memory before query: 7.556 MB Rows returned: 1

SELECT Review.id AS `Review.review_id`,
Review.pid AS `Review.listing_id`,
Review.mode AS `Review.extension`,
Review.created AS `Review.created`,
Review.modified AS `Review.modified`,
Review.userid AS `Review.user_id`,
User.id AS `User.user_id`,

  CASE WHEN CHAR_LENGTH(User.name) THEN User.name ELSE Review.name END AS `User.name`,

  CASE WHEN CHAR_LENGTH(User.username) THEN User.username ELSE Review.username END AS `User.username`,
User.block AS `User.block`,
Review.email AS `User.email`,
Review.ipaddress AS `User.ipaddress`,
ReviewerRank.`rank` AS `User.reviewer_rank`,
ReviewerRank.reviews AS `User.review_count`,
Review.title AS `Review.title`,
Review.comments AS `Review.comments`,
Review.posts AS `Review.posts`,
Review.author AS `Review.editor`,
Review.published AS `Review.published`,
IF(Review.rating=0,"na",Review.rating) AS `Rating.average_rating`,
Review.vote_helpful AS `Vote.yes`,
(Review.vote_total - Review.vote_helpful) AS `Vote.no`,
(Review.vote_helpful/Review.vote_total)*Review.vote_helpful AS `Vote.helpful`,
Review.owner_reply_text AS `Review.owner_reply_text`,
Review.owner_reply_approved AS `Review.owner_reply_approved`,
Review.owner_reply_created AS `Review.owner_reply_created`,
Review.media_count AS `Review.media_count`,
Review.video_count AS `Review.video_count`,
Review.photo_count AS `Review.photo_count`,
Review.audio_count AS `Review.audio_count`,
Review.attachment_count AS `Review.attachment_count`,
Review.listing_type_id AS `ListingType.listing_type_id`
 
  FROM j3x_jreviews_comments AS Review

  LEFT JOIN j3x_users AS User 
  ON Review.userid = User.id

  LEFT JOIN j3x_jreviews_reviewer_ranks AS ReviewerRank 
  ON Review.userid = ReviewerRank.user_id
 
  WHERE 1 = 1 
  AND ( 
   Review.id = 668
   
  AND Review.published = 1
 )

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	Review	NULL	const	PRIMARY,published,published_user_author	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	User	NULL	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found
1	SIMPLE	ReviewerRank	NULL	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found

Profile

Status	Duration
starting	0.15 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
13	JDatabaseDriver->loadAssocList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:72
12	S2Model->query()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:426
11	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:175
10	S2ModelCore->findRow()	JROOT/components/com_jreviews/jreviews/controllers/discussions_controller.php:448
9	DiscussionsController->review()	JROOT/components/com_s2framework/s2framework/dispatcher.php:350
8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:207
7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->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: 0.18 ms Query memory: 0.024 MB Memory before query: 7.577 MB Rows returned: 4

SELECT
                review_id, criteria_id, IF(rating=0,'na',rating) AS rating
            
  FROM
                j3x_jreviews_review_ratings
            
  WHERE
                review_id IN (668)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j3x_jreviews_review_ratings	NULL	ref	PRIMARY,rating	rating	4	const	3	100.00	Using index

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
14	JDatabaseDriver->loadAssocList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:72
13	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/review.php:1614
12	ReviewModel->afterFind()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:450
11	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:175
10	S2ModelCore->findRow()	JROOT/components/com_jreviews/jreviews/controllers/discussions_controller.php:448
9	DiscussionsController->review()	JROOT/components/com_s2framework/s2framework/dispatcher.php:350
8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:207
7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.27 ms After last query: 0.28 ms Query memory: 0.025 MB Memory before query: 7.603 MB Rows returned: 2

Duplicate queries: #61

SELECT
                    groupid
                
  FROM j3x_jreviews_groups
                
  WHERE
                    groupid IN (7,30,17,4,33,31,23)
                    
  AND type = 'review'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j3x_jreviews_groups	NULL	ref	PRIMARY,type	type	152	const	9	21.21	Using where

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.06 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
17	JDatabaseDriver->loadColumn()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:72
16	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/field.php:670
15	FieldModel->getFieldGroupIdsByListingTypeIds()	JROOT/components/com_jreviews/jreviews/models/field.php:936
14	FieldModel->getFieldsArray()	JROOT/components/com_jreviews/jreviews/models/field.php:848
13	FieldModel->addFields()	JROOT/components/com_jreviews/jreviews/models/review.php:1658
12	ReviewModel->afterFind()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:450
11	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:175
10	S2ModelCore->findRow()	JROOT/components/com_jreviews/jreviews/controllers/discussions_controller.php:448
9	DiscussionsController->review()	JROOT/components/com_s2framework/s2framework/dispatcher.php:350
8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:207
7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->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: 0.11 ms Query memory: 0.025 MB Memory before query: 7.615 MB Rows returned: 2

Duplicate queries: #62

SELECT
                Field.fieldid AS `Field.field_id`, 
                Field.groupid AS `Field.group_id`, 
                Field.name AS `Field.name`, 
                Field.title AS `Field.title`,
                Field.showtitle AS `Field.showTitle`, 
                Field.description AS `Field.description`, 
                Field.required AS `Field.required`,
                Field.type AS `Field.type`, 
                Field.location AS `Field.location`, 
                Field.options AS `Field.params`,
                Field.contentview AS `Field.contentView`, 
                Field.listview AS `Field.listView`, 
                Field.compareview AS `Field.compareView`, 
                Field.listsort AS `Field.listSort`,
                Field.search AS `Field.search`, 
                Field.access AS `Field.access`, 
                Field.access_view AS `Field.accessView`,
                Field.published As `Field.published`, 
                Field.ordering AS `Field.ordering`,
                `
  Group`.groupid AS `
  Group.group_id`,
                `
  Group`.title AS `
  Group.title`,
                `
  Group`.name AS `
  Group.name`,
                `
  Group`.showtitle AS `
  Group.showTitle`,
                `
  Group`.ordering AS `
  Group.ordering`,
                `
  Group`.control_field AS `
  Group.control_field`,
                `
  Group`.control_value AS `
  Group.control_value`
             
  FROM
                j3x_jreviews_fields AS Field
         
  LEFT JOIN
            j3x_jreviews_groups AS `
  Group` 
  ON `
  Group`.groupid = Field.groupid
         
  WHERE
            Field.published = 1
            
  AND Field.location = 'review'
            
  AND Field.groupid IN ( 23,31)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	Field	NULL	range	groupid,entry_published,list_published	groupid	4	NULL	6	47.14	Using index condition; Using where
1	SIMPLE	Group	NULL	eq_ref	PRIMARY	PRIMARY	4	freepate_bikorn.Field.groupid	1	100.00	NULL

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.10 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
15	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/field.php:986
14	FieldModel->getFieldsArray()	JROOT/components/com_jreviews/jreviews/models/field.php:848
13	FieldModel->addFields()	JROOT/components/com_jreviews/jreviews/models/review.php:1658
12	ReviewModel->afterFind()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:450
11	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:175
10	S2ModelCore->findRow()	JROOT/components/com_jreviews/jreviews/controllers/discussions_controller.php:448
9	DiscussionsController->review()	JROOT/components/com_s2framework/s2framework/dispatcher.php:350
8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:207
7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->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.11 ms Query memory: 0.024 MB Memory before query: 7.631 MB Rows returned: 0

SELECT
                            Review.reviewid AS element_id,jr_productsdiditry,jr_productmysite
                        
  FROM
                            j3x_jreviews_review_fields AS Review
                        
  WHERE
                            Review.reviewid IN (668)

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

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
15	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/field.php:1129
14	FieldModel->getFieldsArray()	JROOT/components/com_jreviews/jreviews/models/field.php:848
13	FieldModel->addFields()	JROOT/components/com_jreviews/jreviews/models/review.php:1658
12	ReviewModel->afterFind()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:450
11	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:175
10	S2ModelCore->findRow()	JROOT/components/com_jreviews/jreviews/controllers/discussions_controller.php:448
9	DiscussionsController->review()	JROOT/components/com_s2framework/s2framework/dispatcher.php:350
8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:207
7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.84 ms After last query: 151.45 ms Query memory: 0.040 MB Memory before query: 7.663 MB Rows returned: 1

SELECT Listing.id AS `Listing.listing_id`,
Listing.alias AS `Listing.slug`,
Listing.title AS `Listing.title`,
Listing.introtext AS `Listing.summary`,
Listing.fulltext AS `Listing.description`,
Listing.images AS `Listing.images`,
Listing.hits AS `Listing.hits`,
Listing.catid AS `Listing.cat_id`,
Listing.created_by AS `Listing.user_id`,
Listing.created_by_alias AS `Listing.author_alias`,
Listing.created AS `Listing.created`,
Listing.modified AS `Listing.modified`,
Listing.access AS `Listing.access`,
Listing.state AS `Listing.state`,
Listing.publish_up AS `Listing.publish_up`,
Listing.publish_down AS `Listing.publish_down`,
Listing.metakey AS `Listing.metakey`,
Listing.metadesc AS `Listing.metadesc`,
'com_content' AS `Listing.extension`,
Field.featured AS `Listing.featured`,
JreviewsCategory.criteriaid AS `ListingType.listing_type_id`,
Category.id AS `Category.cat_id`,
Category.title AS `Category.title`,
Category.alias AS `Category.slug`,
Category.access AS `Category.access`,
Category.params AS `Category.params`,
Directory.id AS `Directory.dir_id`,
Directory.title AS `Directory.title`,
Directory.slug AS `Directory.slug`,
User.id AS `User.user_id`,
User.name AS `User.name`,
User.username AS `User.username`,
User.email AS `User.email`,
User.block AS `User.block`,
Claim.approved AS `Claim.approved`,
Totals.user_rating AS `Review.user_rating`,
Totals.user_rating_count AS `Review.user_rating_count`,
Totals.user_criteria_rating AS `Review.user_criteria_rating`,
Totals.user_criteria_rating_count AS `Review.user_criteria_rating_count`,
Totals.user_comment_count AS `Review.user_review_count`,
Totals.editor_rating AS `Review.editor_rating`,
Totals.editor_rating_count AS `Review.editor_rating_count`,
Totals.editor_criteria_rating AS `Review.editor_criteria_rating`,
Totals.editor_criteria_rating_count AS `Review.editor_criteria_rating_count`,
Totals.editor_comment_count AS `Review.editor_review_count`,
Totals.media_count AS `Listing.media_count`,
Totals.video_count AS `Listing.video_count`,
Totals.photo_count AS `Listing.photo_count`,
Totals.audio_count AS `Listing.audio_count`,
Totals.attachment_count AS `Listing.attachment_count`,
(Totals.media_count - Totals.media_count_user) AS `Listing.media_count_owner`,
(Totals.video_count - Totals.video_count_user) AS `Listing.video_count_owner`,
(Totals.photo_count - Totals.photo_count_user) AS `Listing.photo_count_owner`,
(Totals.audio_count - Totals.audio_count_user) AS `Listing.audio_count_owner`,
(Totals.attachment_count - Totals.attachment_count_user) AS `Listing.attachment_count_owner`,
Totals.media_count_user AS `Listing.media_count_user`,
Totals.video_count_user AS `Listing.video_count_user`,
Totals.photo_count_user AS `Listing.photo_count_user`,
Totals.audio_count_user AS `Listing.audio_count_user`,
Totals.attachment_count_user AS `Listing.attachment_count_user`
 
  FROM j3x_content AS Listing

  LEFT JOIN j3x_jreviews_listing_totals AS Totals 
  ON Totals.listing_id = Listing.id 
  AND Totals.extension = 'com_content'

  LEFT JOIN j3x_jreviews_content AS Field 
  ON Field.contentid = Listing.id

  LEFT JOIN j3x_jreviews_categories AS JreviewsCategory 
  ON JreviewsCategory.id = Listing.catid 
  AND JreviewsCategory.`option` = 'com_content'

  LEFT JOIN j3x_categories AS Category 
  ON Category.id = Listing.catid 
  AND Category.extension = 'com_content'

  LEFT JOIN j3x_jreviews_directories AS Directory 
  ON Directory.id = JreviewsCategory.dirid

  LEFT JOIN j3x_users AS User 
  ON User.id = Listing.created_by

  LEFT JOIN j3x_jreviews_claims AS Claim 
  ON Claim.listing_id = Listing.id 
  AND Claim.user_id = Listing.created_by 
  AND Claim.approved = 1
 
  WHERE 1 = 1 
  AND ( 
   Listing.id=399
 )

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	Listing	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	Totals	NULL	const	PRIMARY	PRIMARY	156	const,const	1	100.00	NULL
1	SIMPLE	Field	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	JreviewsCategory	NULL	const	PRIMARY,option	PRIMARY	156	const,const	1	100.00	NULL
1	SIMPLE	Category	NULL	const	PRIMARY,cat_idx	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	Directory	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	User	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	Claim	NULL	ref	listing_id,user_id,approved	listing_id	4	const	1	100.00	Using where

Profile

Status	Duration
starting	0.19 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.05 ms
init	0.07 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.20 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.06 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
13	JDatabaseDriver->loadAssocList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:72
12	S2Model->query()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:426
11	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:175
10	S2ModelCore->findRow()	JROOT/components/com_jreviews/jreviews/controllers/discussions_controller.php:469
9	DiscussionsController->review()	JROOT/components/com_s2framework/s2framework/dispatcher.php:350
8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:207
7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.30 ms After last query: 0.32 ms Query memory: 0.025 MB Memory before query: 7.694 MB Rows returned: 5

SELECT
                    groupid
                
  FROM j3x_jreviews_groups
                
  WHERE
                    groupid IN (7,30,17,4,33,31,23)
                    
  AND type = 'content'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j3x_jreviews_groups	NULL	ref	PRIMARY,type	type	152	const	23	21.21	Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.08 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
17	JDatabaseDriver->loadColumn()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:72
16	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/field.php:670
15	FieldModel->getFieldGroupIdsByListingTypeIds()	JROOT/components/com_jreviews/jreviews/models/field.php:936
14	FieldModel->getFieldsArray()	JROOT/components/com_jreviews/jreviews/models/field.php:848
13	FieldModel->addFields()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:752
12	EverywhereComContentModel->afterFind()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:450
11	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:175
10	S2ModelCore->findRow()	JROOT/components/com_jreviews/jreviews/controllers/discussions_controller.php:469
9	DiscussionsController->review()	JROOT/components/com_s2framework/s2framework/dispatcher.php:350
8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:207
7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.51 ms After last query: 0.08 ms Query memory: 0.032 MB Memory before query: 7.706 MB Rows returned: 13

SELECT
                Field.fieldid AS `Field.field_id`, 
                Field.groupid AS `Field.group_id`, 
                Field.name AS `Field.name`, 
                Field.title AS `Field.title`,
                Field.showtitle AS `Field.showTitle`, 
                Field.description AS `Field.description`, 
                Field.required AS `Field.required`,
                Field.type AS `Field.type`, 
                Field.location AS `Field.location`, 
                Field.options AS `Field.params`,
                Field.contentview AS `Field.contentView`, 
                Field.listview AS `Field.listView`, 
                Field.compareview AS `Field.compareView`, 
                Field.listsort AS `Field.listSort`,
                Field.search AS `Field.search`, 
                Field.access AS `Field.access`, 
                Field.access_view AS `Field.accessView`,
                Field.published As `Field.published`, 
                Field.ordering AS `Field.ordering`,
                `
  Group`.groupid AS `
  Group.group_id`,
                `
  Group`.title AS `
  Group.title`,
                `
  Group`.name AS `
  Group.name`,
                `
  Group`.showtitle AS `
  Group.showTitle`,
                `
  Group`.ordering AS `
  Group.ordering`,
                `
  Group`.control_field AS `
  Group.control_field`,
                `
  Group`.control_value AS `
  Group.control_value`
             
  FROM
                j3x_jreviews_fields AS Field
         
  LEFT JOIN
            j3x_jreviews_groups AS `
  Group` 
  ON `
  Group`.groupid = Field.groupid
         
  WHERE
            Field.published = 1
            
  AND Field.location = 'content'
            
  AND Field.groupid IN ( 4,7,17,30,33)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	Field	NULL	range	groupid,entry_published,list_published	groupid	4	NULL	14	47.14	Using index condition; Using where
1	SIMPLE	Group	NULL	eq_ref	PRIMARY	PRIMARY	4	freepate_bikorn.Field.groupid	1	100.00	NULL

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.20 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
15	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/field.php:986
14	FieldModel->getFieldsArray()	JROOT/components/com_jreviews/jreviews/models/field.php:848
13	FieldModel->addFields()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:752
12	EverywhereComContentModel->afterFind()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:450
11	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:175
10	S2ModelCore->findRow()	JROOT/components/com_jreviews/jreviews/controllers/discussions_controller.php:469
9	DiscussionsController->review()	JROOT/components/com_s2framework/s2framework/dispatcher.php:350
8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:207
7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.20 ms After last query: 0.13 ms Query memory: 0.025 MB Memory before query: 7.748 MB Rows returned: 1

SELECT
                            Listing.contentid AS element_id,jr_website,jr_buyonlist,jr_buyonpageclali,jr_try,jr_codeforsignup,jr_productprice,jr_pricediscount,jr_hebrew,jr_hdaracha,jr_freetryial,jr_videoproducts,jr_order,jr_remarketingcode
                        
  FROM
                            j3x_jreviews_content AS Listing
                        
  WHERE
                            Listing.contentid IN (399)

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
15	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/field.php:1071
14	FieldModel->getFieldsArray()	JROOT/components/com_jreviews/jreviews/models/field.php:848
13	FieldModel->addFields()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:752
12	EverywhereComContentModel->afterFind()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:450
11	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:175
10	S2ModelCore->findRow()	JROOT/components/com_jreviews/jreviews/controllers/discussions_controller.php:469
9	DiscussionsController->review()	JROOT/components/com_s2framework/s2framework/dispatcher.php:350
8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:207
7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.34 ms After last query: 0.09 ms Query memory: 0.025 MB Memory before query: 7.762 MB Rows returned: 3

SELECT
                        *
                    
  FROM
                        j3x_jreviews_fieldoptions
                    
  WHERE
                        fieldid IN ( '90','66')
                        
  AND
                        value IN ( 'hebrew','writen','videos')
                    
  ORDER
                        BY ordering ASC ,optionid ASC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j3x_jreviews_fieldoptions	NULL	range	fieldid,field_value	field_value	767	NULL	5	4.58	Using index condition; Using where; Using filesort

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.09 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.07 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
15	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/field.php:1184
14	FieldModel->getFieldsArray()	JROOT/components/com_jreviews/jreviews/models/field.php:848
13	FieldModel->addFields()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:752
12	EverywhereComContentModel->afterFind()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:450
11	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:175
10	S2ModelCore->findRow()	JROOT/components/com_jreviews/jreviews/controllers/discussions_controller.php:469
9	DiscussionsController->review()	JROOT/components/com_s2framework/s2framework/dispatcher.php:350
8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:207
7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.19 ms After last query: 0.33 ms Query memory: 0.023 MB Memory before query: 7.786 MB Rows returned: 0

SELECT
                content_id AS listing_id, count(*) AS favored 
  FROM j3x_jreviews_favorites AS Favorite
		    
  WHERE
                Favorite.content_id IN (399)
		    
  GROUP BY
                listing_id

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	Favorite	NULL	ref	user_favorite	user_favorite	4	const	1	100.00	Using index

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
15	JDatabaseDriver->loadAssocList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
14	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/favorite.php:91
13	FavoriteModel->addFavorite()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:767
12	EverywhereComContentModel->afterFind()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:450
11	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:175
10	S2ModelCore->findRow()	JROOT/components/com_jreviews/jreviews/controllers/discussions_controller.php:469
9	DiscussionsController->review()	JROOT/components/com_s2framework/s2framework/dispatcher.php:350
8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:207
7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.32 ms After last query: 0.21 ms Query memory: 0.025 MB Memory before query: 7.799 MB Rows returned: 1

SELECT
						media.media_id,
						media.media_type,
						media.media_function,
						media.likes_rank,
						media.likes_up,
						media.likes_total,
						media.created,
						media.main_media,
						media.listing_id,
						media.review_id,
						media.user_id,
						media.filename,
						media.file_extension,
						media.rel_path,
						media.title,
						media.description,
						media.media_info,
						media.metadata,
						media.embed,
						media.published,
						media.approved,
						media.access,
						media.views,
						media.filesize,
						media.extension
					
  FROM
						j3x_jreviews_media AS media
					
  WHERE

						listing_id IN (399)

						
  AND published = 1 
  AND approved = 1

						
  AND access IN (1)

						
  AND main_media = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	media	NULL	ref	listing	listing	4	const	2	2.50	Using index condition; Using where

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
16	JDatabaseDriver->loadAssocList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:72
15	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/media.php:1563
14	MediaModel->addMediaDetail()	JROOT/components/com_jreviews/jreviews/models/media.php:1182
13	MediaModel->addMedia()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:797
12	EverywhereComContentModel->afterFind()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:450
11	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:175
10	S2ModelCore->findRow()	JROOT/components/com_jreviews/jreviews/controllers/discussions_controller.php:469
9	DiscussionsController->review()	JROOT/components/com_s2framework/s2framework/dispatcher.php:350
8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:207
7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.41 ms After last query: 0.70 ms Query memory: 0.023 MB Memory before query: 7.813 MB Rows returned: 0

SELECT Discussion.discussion_id AS `Discussion.discussion_id`,
Discussion.type AS `Discussion.type`,
Discussion.parent_post_id AS `Discussion.parent_post_id`,
Discussion.review_id AS `Discussion.review_id`,
Discussion.user_id AS `Discussion.user_id`,
Discussion.name AS `Discussion.name`,
Discussion.username AS `Discussion.username`,
Discussion.ipaddress AS `Discussion.ipaddress`,
Discussion.text AS `Discussion.text`,
Discussion.created AS `Discussion.created`,
Discussion.modified AS `Discussion.modified`,
Discussion.approved AS `Discussion.approved`,
User.id AS `User.user_id`,
User.block AS `User.block`,
Discussion.email As `User.email`,
Review.id AS `Review.review_id`,
Review.title AS `Review.title`,
Review.mode AS `Review.extension`,
Review.pid AS `Review.listing_id`,
Review.userid AS `Review.user_id`,
Review.listing_type_id AS `ListingType.listing_type_id`,
Review.author AS `Review.editor`,
Review.pid AS `Listing.listing_id`,
Review.mode AS `Listing.extension`,

  CASE WHEN CHAR_LENGTH(User. name) THEN User. name ELSE Discussion.name END AS `User.name`,

  CASE WHEN CHAR_LENGTH(User. username) THEN User.username ELSE Discussion.username END AS `User.username`
 
  FROM j3x_jreviews_discussions AS Discussion

  LEFT JOIN j3x_users AS User 
  ON Discussion.user_id = User.id

  INNER JOIN j3x_jreviews_comments AS Review 
  ON Discussion.review_id = Review.id 
  AND Review.published = 1
 
  WHERE 1 = 1 
  AND ( 
   Discussion.type = "review"
   
  AND Discussion.review_id = 668
   
  AND Discussion.approved = 1
 )
 
  ORDER BY Discussion.created ASC
 
  LIMIT 10

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	Review	NULL	const	PRIMARY,published,published_user_author	PRIMARY	4	const	1	100.00	Using filesort
1	SIMPLE	Discussion	NULL	ref	review_id,approved	review_id	4	const	1	5.00	Using index condition; Using where
1	SIMPLE	User	NULL	eq_ref	PRIMARY	PRIMARY	4	freepate_bikorn.Discussion.user_id	1	100.00	NULL

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
13	JDatabaseDriver->loadAssocList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:72
12	S2Model->query()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:426
11	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:139
10	S2ModelCore->findAll()	JROOT/components/com_jreviews/jreviews/controllers/discussions_controller.php:500
9	DiscussionsController->review()	JROOT/components/com_s2framework/s2framework/dispatcher.php:350
8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:207
7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.32 ms After last query: 0.20 ms Query memory: 0.022 MB Memory before query: 7.819 MB Rows returned: 1

SELECT COUNT(*)
 
  FROM j3x_jreviews_discussions AS Discussion

  INNER JOIN j3x_jreviews_comments AS Review 
  ON Discussion.review_id = Review.id 
  AND Review.published = 1
 
  WHERE 1 = 1 
  AND ( 
   Discussion.type = "review"
   
  AND Discussion.review_id = 668
   
  AND Discussion.approved = 1
 )

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	Review	NULL	const	PRIMARY,published,published_user_author	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	Discussion	NULL	ref	review_id,approved	review_id	4	const	1	5.00	Using where

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:72
11	S2Model->query()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:296
10	S2ModelCore->findCount()	JROOT/components/com_jreviews/jreviews/controllers/discussions_controller.php:508
9	DiscussionsController->review()	JROOT/components/com_s2framework/s2framework/dispatcher.php:350
8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:207
7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.22 ms After last query: 2.54 ms Query memory: 0.028 MB Memory before query: 8.004 MB Rows returned: 1

SELECT
                                catid
                            
  FROM
                                j3x_content
                            
  WHERE
                                id = 399

Explain

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

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
26	JDatabaseDriver->loadResult()	JROOT/plugins/system/jreviews_sef/joomla_380/router.php:1001
25	JReviewsRouter->buildRule()	Same as call in the line below.
24	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
23	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:661
22	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
21	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
20	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
19	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
18	Joomla\CMS\Router\Route::_()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/framework_joomla.php:1167
17	cmsFramework::route()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/views/helpers/routes.php:803
16	RoutesHelper->listing()	JROOT/components/com_jreviews/jreviews/views/helpers/custom_fields.php:126
15	CustomFieldsHelper->setReviewClick2SearchUrl()	JROOT/components/com_jreviews/jreviews/views/themes/default/discussions/review.thtml:38
14	include JROOT/components/com_jreviews/jreviews/views/themes/default/discussions/review.thtml	JROOT/components/com_s2framework/s2framework/libs/view/view.php:426
13	MyView->_render()	JROOT/components/com_s2framework/s2framework/libs/view/view.php:203
12	MyView->render()	JROOT/components/com_s2framework/s2framework/libs/controller/controller.php:246
11	S2Controller->render()	JROOT/components/com_jreviews/jreviews/controllers/my_controller.php:361
10	MyController->render()	JROOT/components/com_jreviews/jreviews/controllers/discussions_controller.php:683
9	DiscussionsController->review()	JROOT/components/com_s2framework/s2framework/dispatcher.php:350
8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:207
7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->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.22 ms Query memory: 0.030 MB Memory before query: 8.031 MB Rows returned: 1

SELECT alias

  FROM j3x_content

  WHERE id=399

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.02 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
30	JDatabaseDriver->loadResult()	JROOT/components/com_content/helpers/legacyrouter.php:140
29	ContentRouterRulesLegacy->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
28	Joomla\CMS\Component\Router\RouterView->build()	JROOT/components/com_content/router.php:249
27	contentBuildRoute()	JROOT/plugins/system/jreviews_sef/joomla_380/router.php:2549
26	JReviewsRouter->getArticleRoute()	JROOT/plugins/system/jreviews_sef/joomla_380/router.php:1011
25	JReviewsRouter->buildRule()	Same as call in the line below.
24	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
23	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:661
22	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
21	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
20	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
19	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
18	Joomla\CMS\Router\Route::_()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/framework_joomla.php:1167
17	cmsFramework::route()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/views/helpers/routes.php:803
16	RoutesHelper->listing()	JROOT/components/com_jreviews/jreviews/views/helpers/custom_fields.php:126
15	CustomFieldsHelper->setReviewClick2SearchUrl()	JROOT/components/com_jreviews/jreviews/views/themes/default/discussions/review.thtml:38
14	include JROOT/components/com_jreviews/jreviews/views/themes/default/discussions/review.thtml	JROOT/components/com_s2framework/s2framework/libs/view/view.php:426
13	MyView->_render()	JROOT/components/com_s2framework/s2framework/libs/view/view.php:203
12	MyView->render()	JROOT/components/com_s2framework/s2framework/libs/controller/controller.php:246
11	S2Controller->render()	JROOT/components/com_jreviews/jreviews/controllers/my_controller.php:361
10	MyController->render()	JROOT/components/com_jreviews/jreviews/controllers/discussions_controller.php:683
9	DiscussionsController->review()	JROOT/components/com_s2framework/s2framework/dispatcher.php:350
8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:207
7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.54 ms After last query: 0.45 ms Query memory: 0.033 MB Memory before query: 8.053 MB Rows returned: 3

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 `j3x_categories` AS `s`

  INNER JOIN `j3x_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id = 89

  ORDER BY c.lft

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	NULL	range	cat_idx,idx_access,idx_left_right	idx_left_right	4	NULL	25	71.54	Using index condition; Using where

Profile

Status	Duration
starting	0.08 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.15 ms
preparing	0.04 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.08 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
32	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
31	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
30	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/helpers/legacyrouter.php:173
29	ContentRouterRulesLegacy->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
28	Joomla\CMS\Component\Router\RouterView->build()	JROOT/components/com_content/router.php:249
27	contentBuildRoute()	JROOT/plugins/system/jreviews_sef/joomla_380/router.php:2549
26	JReviewsRouter->getArticleRoute()	JROOT/plugins/system/jreviews_sef/joomla_380/router.php:1011
25	JReviewsRouter->buildRule()	Same as call in the line below.
24	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
23	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:661
22	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
21	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
20	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
19	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
18	Joomla\CMS\Router\Route::_()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/framework_joomla.php:1167
17	cmsFramework::route()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/views/helpers/routes.php:803
16	RoutesHelper->listing()	JROOT/components/com_jreviews/jreviews/views/helpers/custom_fields.php:126
15	CustomFieldsHelper->setReviewClick2SearchUrl()	JROOT/components/com_jreviews/jreviews/views/themes/default/discussions/review.thtml:38
14	include JROOT/components/com_jreviews/jreviews/views/themes/default/discussions/review.thtml	JROOT/components/com_s2framework/s2framework/libs/view/view.php:426
13	MyView->_render()	JROOT/components/com_s2framework/s2framework/libs/view/view.php:203
12	MyView->render()	JROOT/components/com_s2framework/s2framework/libs/controller/controller.php:246
11	S2Controller->render()	JROOT/components/com_jreviews/jreviews/controllers/my_controller.php:361
10	MyController->render()	JROOT/components/com_jreviews/jreviews/controllers/discussions_controller.php:683
9	DiscussionsController->review()	JROOT/components/com_s2framework/s2framework/dispatcher.php:350
8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:207
7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 4.32 ms After last query: 8.19 ms Query memory: 0.168 MB Memory before query: 8.417 MB Rows returned: 68

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down

  FROM j3x_modules AS m

  LEFT JOIN j3x_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  LEFT JOIN j3x_advancedmodules as am 
  ON am.moduleid = m.id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND m.access IN (1,1) 
  AND m.client_id = 0

  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	ref	published,newsfeeds	published	1	const	106	2.00	Using index condition; Using where; Using filesort
1	SIMPLE	am	NULL	eq_ref	PRIMARY	PRIMARY	4	freepate_bikorn.m.id	1	100.00	NULL
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	freepate_bikorn.m.module,const	1	10.00	Using index condition; Using where

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	2.49 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.03 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:413
18	PlgSystemAdvancedModuleHelper->getModuleList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:127
17	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
16	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
15	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Helper/ModuleHelper.php:366
14	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
13	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:591
12	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/yoo_lava/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:54
11	Warp\Joomla\Helper\WidgetsHelper->count()	JROOT/templates/yoo_lava/layouts/theme.config.php:26
10	include JROOT/templates/yoo_lava/layouts/theme.config.php	JROOT/templates/yoo_lava/layouts/theme.php:10
9	include JROOT/templates/yoo_lava/layouts/theme.php	JROOT/templates/yoo_lava/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_lava/index.php:16
7	require JROOT/templates/yoo_lava/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->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: 5.20 ms Query memory: 0.027 MB Memory before query: 8.923 MB Rows returned: 1

SELECT t.parent_id

  FROM j3x_menu as t

  WHERE t.id = 193

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
23	JDatabaseDriver->loadResult()	JROOT/libraries/regularlabs/src/Condition.php:314
22	RegularLabs\Library\Condition->getParentIds()	JROOT/libraries/regularlabs/src/Condition/Menu.php:70
21	RegularLabs\Library\Condition\Menu->getMenuParentIds()	JROOT/libraries/regularlabs/src/Condition/Menu.php:53
20	RegularLabs\Library\Condition\Menu->pass()	JROOT/libraries/regularlabs/src/Conditions.php:253
19	RegularLabs\Library\Conditions::passByType()	JROOT/libraries/regularlabs/src/Conditions.php:63
18	RegularLabs\Library\Conditions::pass()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:178
17	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
16	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
15	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Helper/ModuleHelper.php:366
14	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
13	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:591
12	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/yoo_lava/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:54
11	Warp\Joomla\Helper\WidgetsHelper->count()	JROOT/templates/yoo_lava/layouts/theme.config.php:26
10	include JROOT/templates/yoo_lava/layouts/theme.config.php	JROOT/templates/yoo_lava/layouts/theme.php:10
9	include JROOT/templates/yoo_lava/layouts/theme.php	JROOT/templates/yoo_lava/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_lava/index.php:16
7	require JROOT/templates/yoo_lava/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->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.06 ms Query memory: 0.027 MB Memory before query: 8.935 MB Rows returned: 1

SELECT t.parent_id

  FROM j3x_menu as t

  WHERE t.id = 1

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.02 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.00 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
23	JDatabaseDriver->loadResult()	JROOT/libraries/regularlabs/src/Condition.php:314
22	RegularLabs\Library\Condition->getParentIds()	JROOT/libraries/regularlabs/src/Condition/Menu.php:70
21	RegularLabs\Library\Condition\Menu->getMenuParentIds()	JROOT/libraries/regularlabs/src/Condition/Menu.php:53
20	RegularLabs\Library\Condition\Menu->pass()	JROOT/libraries/regularlabs/src/Conditions.php:253
19	RegularLabs\Library\Conditions::passByType()	JROOT/libraries/regularlabs/src/Conditions.php:63
18	RegularLabs\Library\Conditions::pass()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:178
17	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
16	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
15	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Helper/ModuleHelper.php:366
14	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
13	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:591
12	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/yoo_lava/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:54
11	Warp\Joomla\Helper\WidgetsHelper->count()	JROOT/templates/yoo_lava/layouts/theme.config.php:26
10	include JROOT/templates/yoo_lava/layouts/theme.config.php	JROOT/templates/yoo_lava/layouts/theme.php:10
9	include JROOT/templates/yoo_lava/layouts/theme.php	JROOT/templates/yoo_lava/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_lava/index.php:16
7	require JROOT/templates/yoo_lava/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.28 ms After last query: 5.38 ms Query memory: 0.027 MB Memory before query: 9.232 MB Rows returned: 51

SELECT
                id
            
  FROM
                j3x_jreviews_categories
            
  WHERE
                `option` = 'com_content'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j3x_jreviews_categories	NULL	index	option	PRIMARY	156	NULL	59	84.75	Using where; Using index

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.02 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jreviews_sef/joomla_380/jreviews_sef.php:203
17	JReviewsPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
16	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
15	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Helper/ModuleHelper.php:378
14	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
13	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:591
12	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/yoo_lava/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:54
11	Warp\Joomla\Helper\WidgetsHelper->count()	JROOT/templates/yoo_lava/layouts/theme.config.php:26
10	include JROOT/templates/yoo_lava/layouts/theme.config.php	JROOT/templates/yoo_lava/layouts/theme.php:10
9	include JROOT/templates/yoo_lava/layouts/theme.php	JROOT/templates/yoo_lava/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_lava/index.php:16
7	require JROOT/templates/yoo_lava/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.26 ms After last query: 3.12 ms Query memory: 0.033 MB Memory before query: 9.371 MB Rows returned: 48

SELECT
                Category.id AS value,Category.level AS level,Category.parent_id AS parent_id,JreviewsCategory.criteriaid AS listing_type_id,CONCAT(REPEAT('─', IF(Category.level>0,Category.level - 1,1)), ' ',Category.title) AS text
			
  FROM
				j3x_categories AS Category
            RIGHT JOIN
                j3x_jreviews_categories AS JreviewsCategory 
  ON JreviewsCategory.id = Category.id 
  AND JreviewsCategory.`option` = 'com_content'
			
  WHERE
				Category.published = 1
				
  AND Category.access IN ( 1  )
                
  AND Category.level > 0 
  AND Category.extension = 'com_content' 
			
  ORDER BY
				Category.lft

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	Category	NULL	ref	PRIMARY,cat_idx,idx_access	cat_idx	207	const,const,const	87	33.33	Using index condition; Using where; Using filesort
1	SIMPLE	JreviewsCategory	NULL	eq_ref	PRIMARY,option	PRIMARY	156	freepate_bikorn.Category.id,const	1	100.00	NULL

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.17 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	1.72 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
26	JDatabaseDriver->loadObjectList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
25	S2Model->query()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/category.php:269
24	CategoryModel->getCategoryList()	JROOT/components/com_jreviews/jreviews/controllers/components/advanced_search_theme.php:301
23	AdvancedSearchThemeComponent->categories()	JROOT/components/com_jreviews/jreviews/controllers/components/advanced_search_theme.php:145
22	AdvancedSearchThemeComponent->render()	JROOT/components/com_jreviews/jreviews/controllers/modules/module_advanced_search_controller.php:93
21	ModuleAdvancedSearchController->index()	JROOT/components/com_s2framework/s2framework/dispatcher.php:350
20	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:53
19	JreviewsModuleHelper::renderModule()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
17	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:566
16	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:153
15	JreviewsModuleHelper::moduleCache()	JROOT/modules/mod_jreviews_advsearch/mod_jreviews_advsearch.php:40
14	include JROOT/modules/mod_jreviews_advsearch/mod_jreviews_advsearch.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_lava/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_lava/layouts/theme.config.php:67
10	include JROOT/templates/yoo_lava/layouts/theme.config.php	JROOT/templates/yoo_lava/layouts/theme.php:10
9	include JROOT/templates/yoo_lava/layouts/theme.php	JROOT/templates/yoo_lava/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_lava/index.php:16
7	require JROOT/templates/yoo_lava/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->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: 7.22 ms Query memory: 0.029 MB Memory before query: 9.573 MB Rows returned: 1

SELECT *

  FROM `j3x_kunena_configuration`

  WHERE `id`=1

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
28	JDatabaseDriver->loadAssoc()	JROOT/libraries/kunena/config.php:1430
27	KunenaConfig->load()	JROOT/libraries/kunena/config.php:1403
26	KunenaConfig::getInstance()	JROOT/components/com_kunena/router.php:42
25	KunenaBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
24	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
23	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
22	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
21	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
20	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
19	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
18	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_menu/helper.php:139
17	ModMenuHelper::getList()	JROOT/modules/mod_menu/mod_menu.php:15
16	include JROOT/modules/mod_menu/mod_menu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_lava/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_lava/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/yoo_lava/warp/systems/joomla/layouts/widgets.php	JROOT/templates/yoo_lava/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_lava/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/yoo_lava/layouts/theme.php:49
9	include JROOT/templates/yoo_lava/layouts/theme.php	JROOT/templates/yoo_lava/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_lava/index.php:16
7	require JROOT/templates/yoo_lava/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.67 ms After last query: 13.87 ms Query memory: 0.029 MB Memory before query: 9.927 MB Rows returned: 1

SELECT
                    Category.id
                
  FROM
                    j3x_categories AS Category,
                    j3x_categories AS ParentCategory
                
  WHERE
                    Category.published >= 0
                    
  AND Category.extension = "com_content"
                    
  AND Category.access IN ( 1)
                    
  AND Category.lft BETWEEN ParentCategory.lft 
  AND ParentCategory.rgt
                    
  AND ParentCategory.id = 89

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ParentCategory	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	Category	NULL	range	cat_idx,idx_access,idx_left_right	idx_left_right	4	NULL	1	82.13	Using index condition; Using where

Profile

Status	Duration
starting	0.14 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.19 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
27	JDatabaseDriver->loadColumn()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:72
26	S2Model->query()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:439
25	EverywhereComContentModel->getCatIdsFromParentCatId()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:293
24	EverywhereComContentModel->addCategoryFiltering()	JROOT/components/com_jreviews/jreviews/controllers/modules/module_reviews_controller.php:169
23	ModuleReviewsController->index()	JROOT/components/com_s2framework/s2framework/dispatcher.php:350
22	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:53
21	JreviewsModuleHelper::renderModule()	Same as call in the line below.
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:566
18	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:153
17	JreviewsModuleHelper::moduleCache()	JROOT/modules/mod_jreviews_reviews/mod_jreviews_reviews.php:40
16	include JROOT/modules/mod_jreviews_reviews/mod_jreviews_reviews.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_lava/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_lava/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/yoo_lava/warp/systems/joomla/layouts/widgets.php	JROOT/templates/yoo_lava/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_lava/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/yoo_lava/layouts/theme.php:129
9	include JROOT/templates/yoo_lava/layouts/theme.php	JROOT/templates/yoo_lava/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_lava/index.php:16
7	require JROOT/templates/yoo_lava/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->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.10 ms Query memory: 0.031 MB Memory before query: 9.940 MB Rows returned: 51

SELECT id 
  FROM j3x_jreviews_categories 
  WHERE `option` = "com_content"

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j3x_jreviews_categories	NULL	index	option	PRIMARY	156	NULL	59	84.75	Using where; Using index

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.06 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
27	JDatabaseDriver->loadColumn()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:72
26	S2Model->query()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:447
25	EverywhereComContentModel->getCatIdsFromParentCatId()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:293
24	EverywhereComContentModel->addCategoryFiltering()	JROOT/components/com_jreviews/jreviews/controllers/modules/module_reviews_controller.php:169
23	ModuleReviewsController->index()	JROOT/components/com_s2framework/s2framework/dispatcher.php:350
22	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:53
21	JreviewsModuleHelper::renderModule()	Same as call in the line below.
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:566
18	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:153
17	JreviewsModuleHelper::moduleCache()	JROOT/modules/mod_jreviews_reviews/mod_jreviews_reviews.php:40
16	include JROOT/modules/mod_jreviews_reviews/mod_jreviews_reviews.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_lava/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_lava/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/yoo_lava/warp/systems/joomla/layouts/widgets.php	JROOT/templates/yoo_lava/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_lava/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/yoo_lava/layouts/theme.php:129
9	include JROOT/templates/yoo_lava/layouts/theme.php	JROOT/templates/yoo_lava/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_lava/index.php:16
7	require JROOT/templates/yoo_lava/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.73 ms After last query: 0.24 ms Query memory: 0.038 MB Memory before query: 9.961 MB Rows returned: 10

SELECT Review.id AS `Review.review_id`,
Review.pid AS `Review.listing_id`,
Review.mode AS `Review.extension`,
Review.created AS `Review.created`,
Review.modified AS `Review.modified`,
Review.userid AS `Review.user_id`,
User.id AS `User.user_id`,

  CASE WHEN CHAR_LENGTH(User.name) THEN User.name ELSE Review.name END AS `User.name`,

  CASE WHEN CHAR_LENGTH(User.username) THEN User.username ELSE Review.username END AS `User.username`,
User.block AS `User.block`,
Review.email AS `User.email`,
Review.ipaddress AS `User.ipaddress`,
ReviewerRank.`rank` AS `User.reviewer_rank`,
ReviewerRank.reviews AS `User.review_count`,
Review.title AS `Review.title`,
Review.comments AS `Review.comments`,
Review.posts AS `Review.posts`,
Review.author AS `Review.editor`,
Review.published AS `Review.published`,
IF(Review.rating=0,"na",Review.rating) AS `Rating.average_rating`,
Review.vote_helpful AS `Vote.yes`,
(Review.vote_total - Review.vote_helpful) AS `Vote.no`,
(Review.vote_helpful/Review.vote_total)*Review.vote_helpful AS `Vote.helpful`,
Review.owner_reply_text AS `Review.owner_reply_text`,
Review.owner_reply_approved AS `Review.owner_reply_approved`,
Review.owner_reply_created AS `Review.owner_reply_created`,
Review.media_count AS `Review.media_count`,
Review.video_count AS `Review.video_count`,
Review.photo_count AS `Review.photo_count`,
Review.audio_count AS `Review.audio_count`,
Review.attachment_count AS `Review.attachment_count`,
Review.listing_type_id AS `ListingType.listing_type_id`
 
  FROM j3x_jreviews_comments AS Review

  LEFT JOIN j3x_users AS User 
  ON Review.userid = User.id

  LEFT JOIN j3x_jreviews_reviewer_ranks AS ReviewerRank 
  ON Review.userid = ReviewerRank.user_id

  LEFT JOIN j3x_content AS Listing 
  ON Listing.id = Review.pid

  LEFT JOIN j3x_jreviews_listing_totals AS Totals 
  ON Totals.listing_id = Review.pid 
  AND Totals.extension = 'com_content'
 
  WHERE 1 = 1 
  AND ( 
   Review.mode = 'com_content'
   
  AND Listing.catid IN (89)
   
  AND Listing.state = 1
   
  AND Listing.access IN ( 1)
   
  AND ( Listing.publish_up IS NULL OR Listing.publish_up <= UTC_TIMESTAMP )
   
  AND (Listing.publish_down IS NULL OR Listing.publish_down = 0 OR Listing.publish_down > UTC_TIMESTAMP)
   
  AND Review.published > 0
 )
 
  GROUP BY Review.id
 
  ORDER BY `Review.created` DESC
 
  LIMIT 10

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	Listing	NULL	range	PRIMARY,idx_access,idx_state,idx_catid,jr_listing_count,jr_state	jr_listing_count	14	NULL	9	46.00	Using index condition; Using where; Using temporary; Using filesort
1	SIMPLE	Review	NULL	ref	PRIMARY,listing_id,extension,published,published_user_author,listing	listing_id	4	freepate_bikorn.Listing.id	12	92.78	Using index condition; Using where
1	SIMPLE	User	NULL	eq_ref	PRIMARY	PRIMARY	4	freepate_bikorn.Review.userid	1	100.00	NULL
1	SIMPLE	ReviewerRank	NULL	eq_ref	PRIMARY	PRIMARY	4	freepate_bikorn.Review.userid	1	100.00	NULL
1	SIMPLE	Totals	NULL	eq_ref	PRIMARY	PRIMARY	156	freepate_bikorn.Review.pid,const	1	100.00	Using index

Profile

Status	Duration
starting	0.20 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.10 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.27 ms
preparing	0.04 ms
Creating tmp table	0.06 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.60 ms
Creating sort index	0.14 ms
end	0.00 ms
query end	0.01 ms
removing tmp table	0.03 ms
query end	0.00 ms
closing tables	0.05 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
27	JDatabaseDriver->loadAssocList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:72
26	S2Model->query()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:426
25	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:139
24	S2ModelCore->findAll()	JROOT/components/com_jreviews/jreviews/controllers/modules/module_reviews_controller.php:282
23	ModuleReviewsController->index()	JROOT/components/com_s2framework/s2framework/dispatcher.php:350
22	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:53
21	JreviewsModuleHelper::renderModule()	Same as call in the line below.
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:566
18	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:153
17	JreviewsModuleHelper::moduleCache()	JROOT/modules/mod_jreviews_reviews/mod_jreviews_reviews.php:40
16	include JROOT/modules/mod_jreviews_reviews/mod_jreviews_reviews.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_lava/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_lava/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/yoo_lava/warp/systems/joomla/layouts/widgets.php	JROOT/templates/yoo_lava/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_lava/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/yoo_lava/layouts/theme.php:129
9	include JROOT/templates/yoo_lava/layouts/theme.php	JROOT/templates/yoo_lava/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_lava/index.php:16
7	require JROOT/templates/yoo_lava/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.92 ms After last query: 0.51 ms Query memory: 0.053 MB Memory before query: 10.049 MB Rows returned: 4

SELECT Listing.id AS `Listing.listing_id`,
Listing.alias AS `Listing.slug`,
Listing.title AS `Listing.title`,
Listing.introtext AS `Listing.summary`,
Listing.fulltext AS `Listing.description`,
Listing.images AS `Listing.images`,
Listing.hits AS `Listing.hits`,
Listing.catid AS `Listing.cat_id`,
Listing.created_by AS `Listing.user_id`,
Listing.created_by_alias AS `Listing.author_alias`,
Listing.created AS `Listing.created`,
Listing.modified AS `Listing.modified`,
Listing.access AS `Listing.access`,
Listing.state AS `Listing.state`,
Listing.publish_up AS `Listing.publish_up`,
Listing.publish_down AS `Listing.publish_down`,
Listing.metakey AS `Listing.metakey`,
Listing.metadesc AS `Listing.metadesc`,
'com_content' AS `Listing.extension`,
Field.featured AS `Listing.featured`,
JreviewsCategory.criteriaid AS `ListingType.listing_type_id`,
Category.id AS `Category.cat_id`,
Category.title AS `Category.title`,
Category.alias AS `Category.slug`,
Category.access AS `Category.access`,
Category.params AS `Category.params`,
Directory.id AS `Directory.dir_id`,
Directory.title AS `Directory.title`,
Directory.slug AS `Directory.slug`,
User.id AS `User.user_id`,
User.name AS `User.name`,
User.username AS `User.username`,
User.email AS `User.email`,
User.block AS `User.block`,
Claim.approved AS `Claim.approved`,
Totals.user_rating AS `Review.user_rating`,
Totals.user_rating_count AS `Review.user_rating_count`,
Totals.user_criteria_rating AS `Review.user_criteria_rating`,
Totals.user_criteria_rating_count AS `Review.user_criteria_rating_count`,
Totals.user_comment_count AS `Review.user_review_count`,
Totals.editor_rating AS `Review.editor_rating`,
Totals.editor_rating_count AS `Review.editor_rating_count`,
Totals.editor_criteria_rating AS `Review.editor_criteria_rating`,
Totals.editor_criteria_rating_count AS `Review.editor_criteria_rating_count`,
Totals.editor_comment_count AS `Review.editor_review_count`,
Totals.media_count AS `Listing.media_count`,
Totals.video_count AS `Listing.video_count`,
Totals.photo_count AS `Listing.photo_count`,
Totals.audio_count AS `Listing.audio_count`,
Totals.attachment_count AS `Listing.attachment_count`,
(Totals.media_count - Totals.media_count_user) AS `Listing.media_count_owner`,
(Totals.video_count - Totals.video_count_user) AS `Listing.video_count_owner`,
(Totals.photo_count - Totals.photo_count_user) AS `Listing.photo_count_owner`,
(Totals.audio_count - Totals.audio_count_user) AS `Listing.audio_count_owner`,
(Totals.attachment_count - Totals.attachment_count_user) AS `Listing.attachment_count_owner`,
Totals.media_count_user AS `Listing.media_count_user`,
Totals.video_count_user AS `Listing.video_count_user`,
Totals.photo_count_user AS `Listing.photo_count_user`,
Totals.audio_count_user AS `Listing.audio_count_user`,
Totals.attachment_count_user AS `Listing.attachment_count_user`
 
  FROM j3x_content AS Listing

  LEFT JOIN j3x_jreviews_listing_totals AS Totals 
  ON Totals.listing_id = Listing.id 
  AND Totals.extension = 'com_content'

  LEFT JOIN j3x_jreviews_content AS Field 
  ON Field.contentid = Listing.id

  LEFT JOIN j3x_jreviews_categories AS JreviewsCategory 
  ON JreviewsCategory.id = Listing.catid 
  AND JreviewsCategory.`option` = 'com_content'

  LEFT JOIN j3x_categories AS Category 
  ON Category.id = Listing.catid 
  AND Category.extension = 'com_content'

  LEFT JOIN j3x_jreviews_directories AS Directory 
  ON Directory.id = JreviewsCategory.dirid

  LEFT JOIN j3x_users AS User 
  ON User.id = Listing.created_by

  LEFT JOIN j3x_jreviews_claims AS Claim 
  ON Claim.listing_id = Listing.id 
  AND Claim.user_id = Listing.created_by 
  AND Claim.approved = 1
 
  WHERE 1 = 1 
  AND ( 
   Listing.id IN (400,407,399,401)
 )

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	Listing	NULL	range	PRIMARY	PRIMARY	4	NULL	4	100.00	Using index condition
1	SIMPLE	Totals	NULL	eq_ref	PRIMARY	PRIMARY	156	freepate_bikorn.Listing.id,const	1	100.00	Using where
1	SIMPLE	Field	NULL	eq_ref	PRIMARY	PRIMARY	4	freepate_bikorn.Listing.id	1	100.00	Using where
1	SIMPLE	JreviewsCategory	NULL	eq_ref	PRIMARY,option	PRIMARY	156	freepate_bikorn.Listing.catid,const	1	100.00	Using where
1	SIMPLE	Category	NULL	eq_ref	PRIMARY,cat_idx	PRIMARY	4	freepate_bikorn.Listing.catid	1	100.00	Using where
1	SIMPLE	Directory	NULL	eq_ref	PRIMARY	PRIMARY	4	freepate_bikorn.JreviewsCategory.dirid	1	100.00	NULL
1	SIMPLE	User	NULL	eq_ref	PRIMARY	PRIMARY	4	freepate_bikorn.Listing.created_by	1	100.00	Using where
1	SIMPLE	Claim	NULL	ref	listing_id,user_id,approved	listing_id	4	freepate_bikorn.Listing.id	1	100.00	Using where

Profile

Status	Duration
starting	0.14 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.08 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.29 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.04 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
33	JDatabaseDriver->loadAssocList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:72
32	S2Model->query()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:426
31	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:139
30	S2ModelCore->findAll()	JROOT/components/com_jreviews/jreviews/controllers/components/everywhere.php:191
29	EverywhereComponent->runEverywhereModels()	JROOT/components/com_jreviews/jreviews/controllers/components/everywhere.php:323
28	EverywhereComponent->plgAfterFind()	JROOT/components/com_jreviews/jreviews/models/my_model.php:175
27	MyModel->notifyObservers()	JROOT/components/com_jreviews/jreviews/models/my_model.php:106
26	MyModel->plgAfterFind()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:446
25	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:139
24	S2ModelCore->findAll()	JROOT/components/com_jreviews/jreviews/controllers/modules/module_reviews_controller.php:282
23	ModuleReviewsController->index()	JROOT/components/com_s2framework/s2framework/dispatcher.php:350
22	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:53
21	JreviewsModuleHelper::renderModule()	Same as call in the line below.
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:566
18	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:153
17	JreviewsModuleHelper::moduleCache()	JROOT/modules/mod_jreviews_reviews/mod_jreviews_reviews.php:40
16	include JROOT/modules/mod_jreviews_reviews/mod_jreviews_reviews.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_lava/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_lava/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/yoo_lava/warp/systems/joomla/layouts/widgets.php	JROOT/templates/yoo_lava/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_lava/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/yoo_lava/layouts/theme.php:129
9	include JROOT/templates/yoo_lava/layouts/theme.php	JROOT/templates/yoo_lava/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_lava/index.php:16
7	require JROOT/templates/yoo_lava/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.04 ms After last query: 0.41 ms Query memory: 0.035 MB Memory before query: 10.140 MB Rows returned: 4

SELECT
						media.media_id,
						media.media_type,
						media.media_function,
						media.likes_rank,
						media.likes_up,
						media.likes_total,
						media.created,
						media.main_media,
						media.listing_id,
						media.review_id,
						media.user_id,
						media.filename,
						media.file_extension,
						media.rel_path,
						media.title,
						media.description,
						media.media_info,
						media.metadata,
						media.embed,
						media.published,
						media.approved,
						media.access,
						media.views,
						media.filesize,
						media.extension
					
  FROM
						j3x_jreviews_media AS media
					
  WHERE

						listing_id IN (399,400,401,407)

						
  AND published = 1 
  AND approved = 1

						
  AND access IN (1)

						
  AND main_media = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	media	NULL	range	listing	listing	4	NULL	5	1.00	Using index condition; Using where

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.09 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.09 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
37	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
36	JDatabaseDriver->loadAssocList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:72
35	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/media.php:1563
34	MediaModel->addMediaDetail()	JROOT/components/com_jreviews/jreviews/models/media.php:1182
33	MediaModel->addMedia()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:797
32	EverywhereComContentModel->afterFind()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:450
31	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:139
30	S2ModelCore->findAll()	JROOT/components/com_jreviews/jreviews/controllers/components/everywhere.php:191
29	EverywhereComponent->runEverywhereModels()	JROOT/components/com_jreviews/jreviews/controllers/components/everywhere.php:323
28	EverywhereComponent->plgAfterFind()	JROOT/components/com_jreviews/jreviews/models/my_model.php:175
27	MyModel->notifyObservers()	JROOT/components/com_jreviews/jreviews/models/my_model.php:106
26	MyModel->plgAfterFind()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:446
25	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:139
24	S2ModelCore->findAll()	JROOT/components/com_jreviews/jreviews/controllers/modules/module_reviews_controller.php:282
23	ModuleReviewsController->index()	JROOT/components/com_s2framework/s2framework/dispatcher.php:350
22	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:53
21	JreviewsModuleHelper::renderModule()	Same as call in the line below.
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:566
18	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:153
17	JreviewsModuleHelper::moduleCache()	JROOT/modules/mod_jreviews_reviews/mod_jreviews_reviews.php:40
16	include JROOT/modules/mod_jreviews_reviews/mod_jreviews_reviews.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_lava/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_lava/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/yoo_lava/warp/systems/joomla/layouts/widgets.php	JROOT/templates/yoo_lava/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_lava/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/yoo_lava/layouts/theme.php:129
9	include JROOT/templates/yoo_lava/layouts/theme.php	JROOT/templates/yoo_lava/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_lava/index.php:16
7	require JROOT/templates/yoo_lava/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.52 ms After last query: 0.81 ms Query memory: 0.032 MB Memory before query: 10.163 MB Rows returned: 40

SELECT
                review_id, criteria_id, IF(rating=0,'na',rating) AS rating
            
  FROM
                j3x_jreviews_review_ratings
            
  WHERE
                review_id IN (1405,1182,668,665,606,545,542,538,537,533)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j3x_jreviews_review_ratings	NULL	range	PRIMARY,rating	rating	4	NULL	46	100.00	Using where; Using index

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.15 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.07 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
28	JDatabaseDriver->loadAssocList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:72
27	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/review.php:1614
26	ReviewModel->afterFind()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:450
25	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:139
24	S2ModelCore->findAll()	JROOT/components/com_jreviews/jreviews/controllers/modules/module_reviews_controller.php:282
23	ModuleReviewsController->index()	JROOT/components/com_s2framework/s2framework/dispatcher.php:350
22	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:53
21	JreviewsModuleHelper::renderModule()	Same as call in the line below.
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:566
18	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:153
17	JreviewsModuleHelper::moduleCache()	JROOT/modules/mod_jreviews_reviews/mod_jreviews_reviews.php:40
16	include JROOT/modules/mod_jreviews_reviews/mod_jreviews_reviews.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_lava/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_lava/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/yoo_lava/warp/systems/joomla/layouts/widgets.php	JROOT/templates/yoo_lava/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_lava/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/yoo_lava/layouts/theme.php:129
9	include JROOT/templates/yoo_lava/layouts/theme.php	JROOT/templates/yoo_lava/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_lava/index.php:16
7	require JROOT/templates/yoo_lava/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.25 ms After last query: 0.40 ms Query memory: 0.030 MB Memory before query: 10.239 MB Rows returned: 2

Duplicate queries: #34

SELECT
                    groupid
                
  FROM j3x_jreviews_groups
                
  WHERE
                    groupid IN (7,30,17,4,33,31,23)
                    
  AND type = 'review'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j3x_jreviews_groups	NULL	ref	PRIMARY,type	type	152	const	9	21.21	Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.06 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
31	JDatabaseDriver->loadColumn()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:72
30	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/field.php:670
29	FieldModel->getFieldGroupIdsByListingTypeIds()	JROOT/components/com_jreviews/jreviews/models/field.php:936
28	FieldModel->getFieldsArray()	JROOT/components/com_jreviews/jreviews/models/field.php:848
27	FieldModel->addFields()	JROOT/components/com_jreviews/jreviews/models/review.php:1658
26	ReviewModel->afterFind()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:450
25	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:139
24	S2ModelCore->findAll()	JROOT/components/com_jreviews/jreviews/controllers/modules/module_reviews_controller.php:282
23	ModuleReviewsController->index()	JROOT/components/com_s2framework/s2framework/dispatcher.php:350
22	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:53
21	JreviewsModuleHelper::renderModule()	Same as call in the line below.
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:566
18	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:153
17	JreviewsModuleHelper::moduleCache()	JROOT/modules/mod_jreviews_reviews/mod_jreviews_reviews.php:40
16	include JROOT/modules/mod_jreviews_reviews/mod_jreviews_reviews.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_lava/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_lava/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/yoo_lava/warp/systems/joomla/layouts/widgets.php	JROOT/templates/yoo_lava/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_lava/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/yoo_lava/layouts/theme.php:129
9	include JROOT/templates/yoo_lava/layouts/theme.php	JROOT/templates/yoo_lava/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_lava/index.php:16
7	require JROOT/templates/yoo_lava/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.39 ms After last query: 0.13 ms Query memory: 0.031 MB Memory before query: 10.256 MB Rows returned: 2

Duplicate queries: #35

SELECT
                Field.fieldid AS `Field.field_id`, 
                Field.groupid AS `Field.group_id`, 
                Field.name AS `Field.name`, 
                Field.title AS `Field.title`,
                Field.showtitle AS `Field.showTitle`, 
                Field.description AS `Field.description`, 
                Field.required AS `Field.required`,
                Field.type AS `Field.type`, 
                Field.location AS `Field.location`, 
                Field.options AS `Field.params`,
                Field.contentview AS `Field.contentView`, 
                Field.listview AS `Field.listView`, 
                Field.compareview AS `Field.compareView`, 
                Field.listsort AS `Field.listSort`,
                Field.search AS `Field.search`, 
                Field.access AS `Field.access`, 
                Field.access_view AS `Field.accessView`,
                Field.published As `Field.published`, 
                Field.ordering AS `Field.ordering`,
                `
  Group`.groupid AS `
  Group.group_id`,
                `
  Group`.title AS `
  Group.title`,
                `
  Group`.name AS `
  Group.name`,
                `
  Group`.showtitle AS `
  Group.showTitle`,
                `
  Group`.ordering AS `
  Group.ordering`,
                `
  Group`.control_field AS `
  Group.control_field`,
                `
  Group`.control_value AS `
  Group.control_value`
             
  FROM
                j3x_jreviews_fields AS Field
         
  LEFT JOIN
            j3x_jreviews_groups AS `
  Group` 
  ON `
  Group`.groupid = Field.groupid
         
  WHERE
            Field.published = 1
            
  AND Field.location = 'review'
            
  AND Field.groupid IN ( 23,31)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	Field	NULL	range	groupid,entry_published,list_published	groupid	4	NULL	6	47.14	Using index condition; Using where
1	SIMPLE	Group	NULL	eq_ref	PRIMARY	PRIMARY	4	freepate_bikorn.Field.groupid	1	100.00	NULL

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.07 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
30	JDatabaseDriver->loadObjectList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
29	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/field.php:986
28	FieldModel->getFieldsArray()	JROOT/components/com_jreviews/jreviews/models/field.php:848
27	FieldModel->addFields()	JROOT/components/com_jreviews/jreviews/models/review.php:1658
26	ReviewModel->afterFind()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:450
25	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:139
24	S2ModelCore->findAll()	JROOT/components/com_jreviews/jreviews/controllers/modules/module_reviews_controller.php:282
23	ModuleReviewsController->index()	JROOT/components/com_s2framework/s2framework/dispatcher.php:350
22	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:53
21	JreviewsModuleHelper::renderModule()	Same as call in the line below.
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:566
18	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:153
17	JreviewsModuleHelper::moduleCache()	JROOT/modules/mod_jreviews_reviews/mod_jreviews_reviews.php:40
16	include JROOT/modules/mod_jreviews_reviews/mod_jreviews_reviews.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_lava/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_lava/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/yoo_lava/warp/systems/joomla/layouts/widgets.php	JROOT/templates/yoo_lava/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_lava/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/yoo_lava/layouts/theme.php:129
9	include JROOT/templates/yoo_lava/layouts/theme.php	JROOT/templates/yoo_lava/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_lava/index.php:16
7	require JROOT/templates/yoo_lava/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.73 ms After last query: 0.11 ms Query memory: 0.030 MB Memory before query: 10.276 MB Rows returned: 2

SELECT
                            Review.reviewid AS element_id,jr_productsdiditry,jr_productmysite
                        
  FROM
                            j3x_jreviews_review_fields AS Review
                        
  WHERE
                            Review.reviewid IN (1405,1182,668,665,606,545,542,538,537,533)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	Review	NULL	range	PRIMARY	PRIMARY	4	NULL	10	100.00	Using index condition

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
30	JDatabaseDriver->loadObjectList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
29	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/field.php:1129
28	FieldModel->getFieldsArray()	JROOT/components/com_jreviews/jreviews/models/field.php:848
27	FieldModel->addFields()	JROOT/components/com_jreviews/jreviews/models/review.php:1658
26	ReviewModel->afterFind()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:450
25	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:139
24	S2ModelCore->findAll()	JROOT/components/com_jreviews/jreviews/controllers/modules/module_reviews_controller.php:282
23	ModuleReviewsController->index()	JROOT/components/com_s2framework/s2framework/dispatcher.php:350
22	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:53
21	JreviewsModuleHelper::renderModule()	Same as call in the line below.
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:566
18	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:153
17	JreviewsModuleHelper::moduleCache()	JROOT/modules/mod_jreviews_reviews/mod_jreviews_reviews.php:40
16	include JROOT/modules/mod_jreviews_reviews/mod_jreviews_reviews.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_lava/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_lava/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/yoo_lava/warp/systems/joomla/layouts/widgets.php	JROOT/templates/yoo_lava/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_lava/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/yoo_lava/layouts/theme.php:129
9	include JROOT/templates/yoo_lava/layouts/theme.php	JROOT/templates/yoo_lava/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_lava/index.php:16
7	require JROOT/templates/yoo_lava/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT
                        *
                    
  FROM
                        j3x_jreviews_fieldoptions
                    
  WHERE
                        fieldid IN ( '107')
                        
  AND
                        value IN ( 'yes')
                    
  ORDER
                        BY ordering ASC ,optionid ASC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j3x_jreviews_fieldoptions	NULL	ref	fieldid,field_value	fieldid	4	const	1	7.19	Using index condition; Using where; Using filesort

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
30	JDatabaseDriver->loadObjectList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
29	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/field.php:1184
28	FieldModel->getFieldsArray()	JROOT/components/com_jreviews/jreviews/models/field.php:848
27	FieldModel->addFields()	JROOT/components/com_jreviews/jreviews/models/review.php:1658
26	ReviewModel->afterFind()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:450
25	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:139
24	S2ModelCore->findAll()	JROOT/components/com_jreviews/jreviews/controllers/modules/module_reviews_controller.php:282
23	ModuleReviewsController->index()	JROOT/components/com_s2framework/s2framework/dispatcher.php:350
22	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:53
21	JreviewsModuleHelper::renderModule()	Same as call in the line below.
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:566
18	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:153
17	JreviewsModuleHelper::moduleCache()	JROOT/modules/mod_jreviews_reviews/mod_jreviews_reviews.php:40
16	include JROOT/modules/mod_jreviews_reviews/mod_jreviews_reviews.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_lava/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_lava/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/yoo_lava/warp/systems/joomla/layouts/widgets.php	JROOT/templates/yoo_lava/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_lava/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/yoo_lava/layouts/theme.php:129
9	include JROOT/templates/yoo_lava/layouts/theme.php	JROOT/templates/yoo_lava/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_lava/index.php:16
7	require JROOT/templates/yoo_lava/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.98 ms After last query: 8.37 ms Query memory: 0.046 MB Memory before query: 10.418 MB Rows returned: 56

SHOW FULL COLUMNS 
  FROM `j3x_kunena_users`

Explain

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

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.17 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.18 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Sending data	0.12 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.03 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
32	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
31	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:253
30	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:172
29	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/kunena/tables/kunenausers.php:445
28	TableKunenaUsers->__construct()	JROOT/libraries/src/Table/Table.php:320
27	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/kunena/user/user.php:231
26	KunenaUser->getTable()	JROOT/libraries/kunena/user/user.php:190
25	KunenaUser->load()	JROOT/libraries/kunena/user/user.php:165
24	KunenaUser->__construct()	JROOT/libraries/kunena/user/helper.php:91
23	KunenaUserHelper::initialize()	JROOT/libraries/kunena/user/helper.php:13
22	include_once JROOT/libraries/kunena/user/helper.php	JROOT/libraries/loader.php:738
21	JLoader::_load()	JROOT/libraries/loader.php:707
20	JLoader::_autoload()	Same as call in the line below.
19	spl_autoload_call()	JROOT/libraries/kunena/factory.php:74
18	KunenaFactory::getUser()	JROOT/libraries/kunena/module/module.php:77
17	KunenaModule->display()	JROOT/modules/mod_kunenalatest/mod_kunenalatest.php:36
16	include JROOT/modules/mod_kunenalatest/mod_kunenalatest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_lava/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_lava/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/yoo_lava/warp/systems/joomla/layouts/widgets.php	JROOT/templates/yoo_lava/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_lava/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/yoo_lava/layouts/theme.php:129
9	include JROOT/templates/yoo_lava/layouts/theme.php	JROOT/templates/yoo_lava/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_lava/index.php:16
7	require JROOT/templates/yoo_lava/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 6.82 ms After last query: 4.69 ms Query memory: 0.036 MB Memory before query: 10.859 MB Rows returned: 7

SELECT * 
  FROM j3x_kunena_categories 
  ORDER BY ordering, name

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.00 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.11 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
32	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/forum/category/helper.php:85
31	KunenaForumCategoryHelper::loadCategories()	JROOT/libraries/kunena/forum/category/helper.php:58
30	KunenaForumCategoryHelper::initialize()	JROOT/libraries/kunena/forum/category/helper.php:1048
29	include_once JROOT/libraries/kunena/forum/category/helper.php	JROOT/libraries/loader.php:738
28	JLoader::_load()	JROOT/libraries/loader.php:707
27	JLoader::_autoload()	Same as call in the line below.
26	spl_autoload_call()	JROOT/libraries/kunena/forum/topic/helper.php:291
25	KunenaForumTopicHelper::getLatestTopics()	JROOT/components/com_kunena/models/topics.php:361
24	KunenaModelTopics->getRecentTopics()	JROOT/components/com_kunena/models/topics.php:266
23	KunenaModelTopics->getTopics()	JROOT/libraries/src/MVC/View/HtmlView.php:425
22	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_kunena/views/topics/view.html.php:35
21	KunenaViewTopics->displayDefault()	JROOT/libraries/kunena/view.php:209
20	KunenaView->displayLayout()	JROOT/libraries/kunena/forum/forum.php:489
19	KunenaForum::display()	JROOT/modules/mod_kunenalatest/class.php:99
18	ModuleKunenaLatest->_display()	JROOT/libraries/kunena/module/module.php:91
17	KunenaModule->display()	JROOT/modules/mod_kunenalatest/mod_kunenalatest.php:36
16	include JROOT/modules/mod_kunenalatest/mod_kunenalatest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_lava/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_lava/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/yoo_lava/warp/systems/joomla/layouts/widgets.php	JROOT/templates/yoo_lava/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_lava/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/yoo_lava/layouts/theme.php:129
9	include JROOT/templates/yoo_lava/layouts/theme.php	JROOT/templates/yoo_lava/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_lava/index.php:16
7	require JROOT/templates/yoo_lava/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 6.33 ms After last query: 0.70 ms Query memory: 0.034 MB Memory before query: 10.943 MB Rows returned: 6

SELECT DISTINCT(user_id)

  FROM j3x_usergroups AS ug1

  INNER JOIN j3x_usergroups AS ug2 
  ON ug2.lft>=ug1.lft 
  AND ug1.rgt>=ug2.rgt

  INNER JOIN j3x_user_usergroup_map AS m 
  ON ug2.id=m.group_id

  WHERE ug1.id IN (8)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ug1	NULL	const	PRIMARY,idx_usergroup_nested_set_lookup	PRIMARY	4	const	1	100.00	Using temporary
1	SIMPLE	ug2	NULL	ALL	PRIMARY,idx_usergroup_nested_set_lookup	NO INDEX KEY COULD BE USED	NULL	NULL	18	11.11	Using where
1	SIMPLE	m	NULL	index	PRIMARY	PRIMARY	8	NULL	3159	10.00	Using where; Using index; Using join buffer (Block Nested Loop)

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
Creating tmp table	0.02 ms
executing	0.00 ms
Sending data	0.90 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.01 ms
query end	0.00 ms
closing tables	0.03 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
38	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
37	JDatabaseDriver->loadColumn()	JROOT/plugins/kunena/joomla/access.php:383
36	KunenaAccessJoomla->getUsersByGroup()	JROOT/plugins/kunena/joomla/access.php:326
35	KunenaAccessJoomla->getAuthorisedUsers()	JROOT/plugins/kunena/joomla/access.php:262
34	KunenaAccessJoomla->loadCategoryRoles()	JROOT/libraries/kunena/access.php:151
33	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:123
32	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:237
31	KunenaAccess::getInstance()	JROOT/libraries/kunena/forum/category/helper.php:66
30	KunenaForumCategoryHelper::initialize()	JROOT/libraries/kunena/forum/category/helper.php:1048
29	include_once JROOT/libraries/kunena/forum/category/helper.php	JROOT/libraries/loader.php:738
28	JLoader::_load()	JROOT/libraries/loader.php:707
27	JLoader::_autoload()	Same as call in the line below.
26	spl_autoload_call()	JROOT/libraries/kunena/forum/topic/helper.php:291
25	KunenaForumTopicHelper::getLatestTopics()	JROOT/components/com_kunena/models/topics.php:361
24	KunenaModelTopics->getRecentTopics()	JROOT/components/com_kunena/models/topics.php:266
23	KunenaModelTopics->getTopics()	JROOT/libraries/src/MVC/View/HtmlView.php:425
22	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_kunena/views/topics/view.html.php:35
21	KunenaViewTopics->displayDefault()	JROOT/libraries/kunena/view.php:209
20	KunenaView->displayLayout()	JROOT/libraries/kunena/forum/forum.php:489
19	KunenaForum::display()	JROOT/modules/mod_kunenalatest/class.php:99
18	ModuleKunenaLatest->_display()	JROOT/libraries/kunena/module/module.php:91
17	KunenaModule->display()	JROOT/modules/mod_kunenalatest/mod_kunenalatest.php:36
16	include JROOT/modules/mod_kunenalatest/mod_kunenalatest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_lava/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_lava/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/yoo_lava/warp/systems/joomla/layouts/widgets.php	JROOT/templates/yoo_lava/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_lava/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/yoo_lava/layouts/theme.php:129
9	include JROOT/templates/yoo_lava/layouts/theme.php	JROOT/templates/yoo_lava/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_lava/index.php:16
7	require JROOT/templates/yoo_lava/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.66 ms After last query: 0.12 ms Query memory: 0.034 MB Memory before query: 10.962 MB Rows returned: 5

SELECT DISTINCT(user_id)

  FROM j3x_usergroups AS ug1

  INNER JOIN j3x_usergroups AS ug2 
  ON ug2.lft>=ug1.lft 
  AND ug1.rgt>=ug2.rgt

  INNER JOIN j3x_user_usergroup_map AS m 
  ON ug2.id=m.group_id

  WHERE ug1.id IN (7)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ug1	NULL	const	PRIMARY,idx_usergroup_nested_set_lookup	PRIMARY	4	const	1	100.00	Using temporary
1	SIMPLE	ug2	NULL	ALL	PRIMARY,idx_usergroup_nested_set_lookup	NO INDEX KEY COULD BE USED	NULL	NULL	18	22.22	Using where
1	SIMPLE	m	NULL	index	PRIMARY	PRIMARY	8	NULL	3159	10.00	Using where; Using index; Using join buffer (Block Nested Loop)

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
Creating tmp table	0.02 ms
executing	0.00 ms
Sending data	1.14 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.01 ms
query end	0.00 ms
closing tables	0.03 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
38	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
37	JDatabaseDriver->loadColumn()	JROOT/plugins/kunena/joomla/access.php:383
36	KunenaAccessJoomla->getUsersByGroup()	JROOT/plugins/kunena/joomla/access.php:326
35	KunenaAccessJoomla->getAuthorisedUsers()	JROOT/plugins/kunena/joomla/access.php:262
34	KunenaAccessJoomla->loadCategoryRoles()	JROOT/libraries/kunena/access.php:151
33	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:123
32	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:237
31	KunenaAccess::getInstance()	JROOT/libraries/kunena/forum/category/helper.php:66
30	KunenaForumCategoryHelper::initialize()	JROOT/libraries/kunena/forum/category/helper.php:1048
29	include_once JROOT/libraries/kunena/forum/category/helper.php	JROOT/libraries/loader.php:738
28	JLoader::_load()	JROOT/libraries/loader.php:707
27	JLoader::_autoload()	Same as call in the line below.
26	spl_autoload_call()	JROOT/libraries/kunena/forum/topic/helper.php:291
25	KunenaForumTopicHelper::getLatestTopics()	JROOT/components/com_kunena/models/topics.php:361
24	KunenaModelTopics->getRecentTopics()	JROOT/components/com_kunena/models/topics.php:266
23	KunenaModelTopics->getTopics()	JROOT/libraries/src/MVC/View/HtmlView.php:425
22	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_kunena/views/topics/view.html.php:35
21	KunenaViewTopics->displayDefault()	JROOT/libraries/kunena/view.php:209
20	KunenaView->displayLayout()	JROOT/libraries/kunena/forum/forum.php:489
19	KunenaForum::display()	JROOT/modules/mod_kunenalatest/class.php:99
18	ModuleKunenaLatest->_display()	JROOT/libraries/kunena/module/module.php:91
17	KunenaModule->display()	JROOT/modules/mod_kunenalatest/mod_kunenalatest.php:36
16	include JROOT/modules/mod_kunenalatest/mod_kunenalatest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_lava/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_lava/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/yoo_lava/warp/systems/joomla/layouts/widgets.php	JROOT/templates/yoo_lava/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_lava/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/yoo_lava/layouts/theme.php:129
9	include JROOT/templates/yoo_lava/layouts/theme.php	JROOT/templates/yoo_lava/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_lava/index.php:16
7	require JROOT/templates/yoo_lava/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->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: 0.11 ms Query memory: 0.033 MB Memory before query: 10.982 MB Rows returned: 0

SELECT `user_id`,`category_id`,`role`

  FROM `j3x_kunena_user_categories`

  WHERE `role` IN (1,2)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j3x_kunena_user_categories	NULL	range	role	role	1	NULL	2	100.00	Using index condition

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
35	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
34	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/access.php:165
33	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:123
32	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:237
31	KunenaAccess::getInstance()	JROOT/libraries/kunena/forum/category/helper.php:66
30	KunenaForumCategoryHelper::initialize()	JROOT/libraries/kunena/forum/category/helper.php:1048
29	include_once JROOT/libraries/kunena/forum/category/helper.php	JROOT/libraries/loader.php:738
28	JLoader::_load()	JROOT/libraries/loader.php:707
27	JLoader::_autoload()	Same as call in the line below.
26	spl_autoload_call()	JROOT/libraries/kunena/forum/topic/helper.php:291
25	KunenaForumTopicHelper::getLatestTopics()	JROOT/components/com_kunena/models/topics.php:361
24	KunenaModelTopics->getRecentTopics()	JROOT/components/com_kunena/models/topics.php:266
23	KunenaModelTopics->getTopics()	JROOT/libraries/src/MVC/View/HtmlView.php:425
22	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_kunena/views/topics/view.html.php:35
21	KunenaViewTopics->displayDefault()	JROOT/libraries/kunena/view.php:209
20	KunenaView->displayLayout()	JROOT/libraries/kunena/forum/forum.php:489
19	KunenaForum::display()	JROOT/modules/mod_kunenalatest/class.php:99
18	ModuleKunenaLatest->_display()	JROOT/libraries/kunena/module/module.php:91
17	KunenaModule->display()	JROOT/modules/mod_kunenalatest/mod_kunenalatest.php:36
16	include JROOT/modules/mod_kunenalatest/mod_kunenalatest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_lava/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_lava/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/yoo_lava/warp/systems/joomla/layouts/widgets.php	JROOT/templates/yoo_lava/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_lava/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/yoo_lava/layouts/theme.php:129
9	include JROOT/templates/yoo_lava/layouts/theme.php	JROOT/templates/yoo_lava/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_lava/index.php:16
7	require JROOT/templates/yoo_lava/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.27 ms After last query: 0.16 ms Query memory: 0.029 MB Memory before query: 11.065 MB Rows returned: 1

SELECT COUNT(*) 
  FROM j3x_kunena_topics AS tt 
  WHERE tt.hold IN (0) 
  AND tt.category_id IN (2,3,5,7)   
  AND tt.last_post_time>'1743033493'  
  AND tt.moved_id='0'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	tt	NULL	range	category_id,hold,last_post_time	last_post_time	4	NULL	4	7.71	Using index condition; Using where

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
26	JDatabaseDriver->loadResult()	JROOT/libraries/kunena/forum/topic/helper.php:372
25	KunenaForumTopicHelper::getLatestTopics()	JROOT/components/com_kunena/models/topics.php:361
24	KunenaModelTopics->getRecentTopics()	JROOT/components/com_kunena/models/topics.php:266
23	KunenaModelTopics->getTopics()	JROOT/libraries/src/MVC/View/HtmlView.php:425
22	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_kunena/views/topics/view.html.php:35
21	KunenaViewTopics->displayDefault()	JROOT/libraries/kunena/view.php:209
20	KunenaView->displayLayout()	JROOT/libraries/kunena/forum/forum.php:489
19	KunenaForum::display()	JROOT/modules/mod_kunenalatest/class.php:99
18	ModuleKunenaLatest->_display()	JROOT/libraries/kunena/module/module.php:91
17	KunenaModule->display()	JROOT/modules/mod_kunenalatest/mod_kunenalatest.php:36
16	include JROOT/modules/mod_kunenalatest/mod_kunenalatest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_lava/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_lava/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/yoo_lava/warp/systems/joomla/layouts/widgets.php	JROOT/templates/yoo_lava/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_lava/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/yoo_lava/layouts/theme.php:129
9	include JROOT/templates/yoo_lava/layouts/theme.php	JROOT/templates/yoo_lava/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_lava/index.php:16
7	require JROOT/templates/yoo_lava/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 601.44 ms After last query: 13.47 ms Query memory: 0.022 MB Memory before query: 11.093 MB Rows returned: 1

SELECT * 
  FROM `j3x_plg_easyfrontendseo` 
  WHERE `url` = 'index.php?option=com_jreviews&view=category&id=668&cat=89&url=discussions/review&Itemid=193'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j3x_plg_easyfrontendseo	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	210705	10.00	Using where

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	601.12 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
13	JDatabaseDriver->loadAssoc()	JROOT/plugins/system/easyfrontendseo/easyfrontendseo.php:358
12	PlgSystemEasyFrontendSeo->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.34 ms After last query: 9.58 ms Query memory: 0.033 MB Memory before query: 11.598 MB Rows returned: 229

SELECT * 
  FROM j3x_acymailing_config

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.12 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
10	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:473
9	acymailing_config()	JROOT/administrator/components/com_acymailing/helpers/helper.php:1185
8	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/plugins/system/regacymailing/regacymailing.php:139
7	plgSystemRegacymailing->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1146
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.45 ms After last query: 2.98 ms Query memory: 0.024 MB Memory before query: 11.835 MB Rows returned: 1

SELECT folder AS type, element AS name, params, extension_id

  FROM j3x_extensions

  WHERE element = 'jch_optimize' 
  AND type = 'plugin'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j3x_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.21 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/plugins/system/jch_optimize/platform/plugin.php:73
16	JchPlatformPlugin::loadjch()	JROOT/plugins/system/jch_optimize/platform/plugin.php:45
15	JchPlatformPlugin::getPlugin()	JROOT/plugins/system/jch_optimize/platform/plugin.php:90
14	JchPlatformPlugin::getPluginParams()	JROOT/plugins/system/jch_optimize/platform/cache.php:131
13	JchPlatformCache::getLifetime()	JROOT/plugins/system/jch_optimize/platform/cache.php:117
12	JchPlatformCache::getCacheObject()	JROOT/plugins/system/jch_optimize/platform/cache.php:37
11	JchPlatformCache::getCache()	JROOT/plugins/system/jch_optimize/jchoptimize/parser.php:79
10	JchOptimizeParser->__construct()	JROOT/plugins/system/jch_optimize/jchoptimize/jchoptimize.php:53
9	JchOptimize->process()	JROOT/plugins/system/jch_optimize/jchoptimize/jchoptimize.php:107
8	JchOptimize::optimize()	JROOT/plugins/system/jch_optimize/jch_optimize.php:102
7	plgSystemJCH_Optimize->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1146
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

60 Query Types Logged, Sorted by Occurrences.

טבלאות SELECT:

3 × SELECT                     groupid                 
  FROM j3x_jreviews_groups

3 × SELECT                 Field.fieldid AS `Field.field_id`,                  Field.groupid AS `Field.group_id`,                  Field.name AS `Field.name`,                  Field.title AS `Field.title`,                 Field.showtitle AS `Field.showTitle`,                  Field.description AS `Field.description`,                  Field.required AS `Field.required`,                 Field.type AS `Field.type`,                  Field.location AS `Field.location`,                  Field.options AS `Field.params`,                 Field.contentview AS `Field.contentView`,                  Field.listview AS `Field.listView`,                  Field.compareview AS `Field.compareView`,                  Field.listsort AS `Field.listSort`,                 Field.search AS `Field.search`,                  Field.access AS `Field.access`,                  Field.access_view AS `Field.accessView`,                 Field.published As `Field.published`,                  Field.ordering AS `Field.ordering`,                 `
  Group`.groupid AS `
  Group.group_id`,                 `
  Group`.title AS `
  Group.title`,                 `
  Group`.name AS `
  Group.name`,                 `
  Group`.showtitle AS `
  Group.showTitle`,                 `
  Group`.ordering AS `
  Group.ordering`,                 `
  Group`.control_field AS `
  Group.control_field`,                 `
  Group`.control_value AS `
  Group.control_value`              
  FROM                 j3x_jreviews_fields AS Field          
  LEFT JOIN             j3x_jreviews_groups AS `
  Group` 
  ON `
  Group`.groupid = Field.groupid

2 × SELECT       media.media_id,       media.media_type,       media.media_function,       media.likes_rank,       media.likes_up,       media.likes_total,       media.created,       media.main_media,       media.listing_id,       media.review_id,       media.user_id,       media.filename,       media.file_extension,       media.rel_path,       media.title,       media.description,       media.media_info,       media.metadata,       media.embed,       media.published,       media.approved,       media.access,       media.views,       media.filesize,       media.extension      
  FROM       j3x_jreviews_media AS media

2 × SELECT t.parent_id 
  FROM j3x_menu as t

2 × SELECT                         *                     
  FROM                         j3x_jreviews_fieldoptions

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `j3x_extensions`

2 × SELECT Listing.id AS `Listing.listing_id`, Listing.alias AS `Listing.slug`, Listing.title AS `Listing.title`, Listing.introtext AS `Listing.summary`, Listing.fulltext AS `Listing.description`, Listing.images AS `Listing.images`, Listing.hits AS `Listing.hits`, Listing.catid AS `Listing.cat_id`, Listing.created_by AS `Listing.user_id`, Listing.created_by_alias AS `Listing.author_alias`, Listing.created AS `Listing.created`, Listing.modified AS `Listing.modified`, Listing.access AS `Listing.access`, Listing.state AS `Listing.state`, Listing.publish_up AS `Listing.publish_up`, Listing.publish_down AS `Listing.publish_down`, Listing.metakey AS `Listing.metakey`, Listing.metadesc AS `Listing.metadesc`, 'com_content' AS `Listing.extension`, Field.featured AS `Listing.featured`, JreviewsCategory.criteriaid AS `ListingType.listing_type_id`, Category.id AS `Category.cat_id`, Category.title AS `Category.title`, Category.alias AS `Category.slug`, Category.access AS `Category.access`, Category.params AS `Category.params`, Directory.id AS `Directory.dir_id`, Directory.title AS `Directory.title`, Directory.slug AS `Directory.slug`, User.id AS `User.user_id`, User.name AS `User.name`, User.username AS `User.username`, User.email AS `User.email`, User.block AS `User.block`, Claim.approved AS `Claim.approved`, Totals.user_rating AS `Review.user_rating`, Totals.user_rating_count AS `Review.user_rating_count`, Totals.user_criteria_rating AS `Review.user_criteria_rating`, Totals.user_criteria_rating_count AS `Review.user_criteria_rating_count`, Totals.user_comment_count AS `Review.user_review_count`, Totals.editor_rating AS `Review.editor_rating`, Totals.editor_rating_count AS `Review.editor_rating_count`, Totals.editor_criteria_rating AS `Review.editor_criteria_rating`, Totals.editor_criteria_rating_count AS `Review.editor_criteria_rating_count`, Totals.editor_comment_count AS `Review.editor_review_count`, Totals.media_count AS `Listing.media_count`, Totals.video_count AS `Listing.video_count`, Totals.photo_count AS `Listing.photo_count`, Totals.audio_count AS `Listing.audio_count`, Totals.attachment_count AS `Listing.attachment_count`, (Totals.media_count - Totals.media_count_user) AS `Listing.media_count_owner`, (Totals.video_count - Totals.video_count_user) AS `Listing.video_count_owner`, (Totals.photo_count - Totals.photo_count_user) AS `Listing.photo_count_owner`, (Totals.audio_count - Totals.audio_count_user) AS `Listing.audio_count_owner`, (Totals.attachment_count - Totals.attachment_count_user) AS `Listing.attachment_count_owner`, Totals.media_count_user AS `Listing.media_count_user`, Totals.video_count_user AS `Listing.video_count_user`, Totals.photo_count_user AS `Listing.photo_count_user`, Totals.audio_count_user AS `Listing.audio_count_user`, Totals.attachment_count_user AS `Listing.attachment_count_user`  
  FROM j3x_content AS Listing 
  LEFT JOIN j3x_jreviews_listing_totals AS Totals 
  ON Totals.listing_id = Listing.id 
  AND Totals.extension = 'com_content' 
  LEFT JOIN j3x_jreviews_content AS Field 
  ON Field.contentid = Listing.id 
  LEFT JOIN j3x_jreviews_categories AS JreviewsCategory 
  ON JreviewsCategory.id = Listing.catid 
  AND JreviewsCategory.`option` = 'com_content' 
  LEFT JOIN j3x_categories AS Category 
  ON Category.id = Listing.catid 
  AND Category.extension = 'com_content' 
  LEFT JOIN j3x_jreviews_directories AS Directory 
  ON Directory.id = JreviewsCategory.dirid 
  LEFT JOIN j3x_users AS User 
  ON User.id = Listing.created_by 
  LEFT JOIN j3x_jreviews_claims AS Claim 
  ON Claim.listing_id = Listing.id 
  AND Claim.user_id = Listing.created_by 
  AND Claim.approved = 1

2 × SELECT DISTINCT(user_id) 
  FROM j3x_usergroups AS ug1 
  INNER JOIN j3x_usergroups AS ug2 
  ON ug2.lft>=ug1.lft 
  AND ug1.rgt>=ug2.rgt 
  INNER JOIN j3x_user_usergroup_map AS m 
  ON ug2.id=m.group_id

2 × SELECT                             Review.reviewid AS element_id,jr_productsdiditry,jr_productmysite                         
  FROM                             j3x_jreviews_review_fields AS Review

2 × SELECT                 count(*)             
  FROM                 j3x_jreviews_categories

2 × SELECT                 review_id, criteria_id, IF(rating=0,'na',rating) AS rating             
  FROM                 j3x_jreviews_review_ratings

```
1 × SELECT alias 
  FROM j3x_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 `j3x_categories` AS `s` 
  INNER JOIN `j3x_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down 
  FROM j3x_modules AS m 
  LEFT JOIN j3x_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id 
  LEFT JOIN j3x_advancedmodules as am 
  ON am.moduleid = m.id

1 × SELECT `data` 
  FROM `j3x_session`

1 × SELECT                 id             
  FROM                 j3x_jreviews_categories

1 × SELECT                                 catid                             
  FROM                                 j3x_content

1 × SELECT * 
  FROM `j3x_kunena_configuration`

1 × SELECT                     Category.id                 
  FROM                     j3x_categories AS Category,                     j3x_categories AS ParentCategory

1 × SELECT id 
  FROM j3x_jreviews_categories

1 × SELECT Review.id AS `Review.review_id`, Review.pid AS `Review.listing_id`, Review.mode AS `Review.extension`, Review.created AS `Review.created`, Review.modified AS `Review.modified`, Review.userid AS `Review.user_id`, User.id AS `User.user_id`, 
  CASE WHEN CHAR_LENGTH(User.name) THEN User.name ELSE Review.name END AS `User.name`, 
  CASE WHEN CHAR_LENGTH(User.username) THEN User.username ELSE Review.username END AS `User.username`, User.block AS `User.block`, Review.email AS `User.email`, Review.ipaddress AS `User.ipaddress`, ReviewerRank.`rank` AS `User.reviewer_rank`, ReviewerRank.reviews AS `User.review_count`, Review.title AS `Review.title`, Review.comments AS `Review.comments`, Review.posts AS `Review.posts`, Review.author AS `Review.editor`, Review.published AS `Review.published`, IF(Review.rating=0,"na",Review.rating) AS `Rating.average_rating`, Review.vote_helpful AS `Vote.yes`, (Review.vote_total - Review.vote_helpful) AS `Vote.no`, (Review.vote_helpful/Review.vote_total)*Review.vote_helpful AS `Vote.helpful`, Review.owner_reply_text AS `Review.owner_reply_text`, Review.owner_reply_approved AS `Review.owner_reply_approved`, Review.owner_reply_created AS `Review.owner_reply_created`, Review.media_count AS `Review.media_count`, Review.video_count AS `Review.video_count`, Review.photo_count AS `Review.photo_count`, Review.audio_count AS `Review.audio_count`, Review.attachment_count AS `Review.attachment_count`, Review.listing_type_id AS `ListingType.listing_type_id`  
  FROM j3x_jreviews_comments AS Review 
  LEFT JOIN j3x_users AS User 
  ON Review.userid = User.id 
  LEFT JOIN j3x_jreviews_reviewer_ranks AS ReviewerRank 
  ON Review.userid = ReviewerRank.user_id 
  LEFT JOIN j3x_content AS Listing 
  ON Listing.id = Review.pid 
  LEFT JOIN j3x_jreviews_listing_totals AS Totals 
  ON Totals.listing_id = Review.pid 
  AND Totals.extension = 'com_content'

1 × SELECT * 
  FROM j3x_kunena_categories

1 × SELECT `user_id`,`category_id`,`role` 
  FROM `j3x_kunena_user_categories`

1 × SELECT COUNT(*) 
  FROM j3x_kunena_topics AS tt

1 × SELECT * 
  FROM `j3x_plg_easyfrontendseo`

1 × SELECT * 
  FROM j3x_acymailing_confi

1 × SELECT                 Category.id AS value,Category.level AS level,Category.parent_id AS parent_id,JreviewsCategory.criteriaid AS listing_type_id,CONCAT(REPEAT('─', IF(Category.level>0,Category.level - 1,1)), ' ',Category.title) AS text    
  FROM     j3x_categories AS Category             RIGHT JOIN                 j3x_jreviews_categories AS JreviewsCategory 
  ON JreviewsCategory.id = Category.id 
  AND JreviewsCategory.`option` = 'com_content'

1 × SELECT                             Listing.contentid AS element_id,jr_website,jr_buyonlist,jr_buyonpageclali,jr_try,jr_codeforsignup,jr_productprice,jr_pricediscount,jr_hebrew,jr_hdaracha,jr_freetryial,jr_videoproducts,jr_order,jr_remarketingcode                         
  FROM                             j3x_jreviews_content AS Listing

1 × SELECT COUNT(*)  
  FROM j3x_jreviews_discussions AS Discussion 
  INNER JOIN j3x_jreviews_comments AS Review 
  ON Discussion.review_id = Review.id 
  AND Review.published = 1

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `j3x_assets`

1 × SELECT id, rules 
  FROM `j3x_viewlevels

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

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM j3x_extensions

1 × SELECT plan_id 
  FROM j3x_osmembership_urls

1 × SELECT id 
  FROM j3x_osmembership_plans

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 j3x_menu AS m 
  LEFT JOIN j3x_extensions AS e 
  ON m.component_id = e.extension_id

```
1 × SELECT * 
  FROM j3x_languages
```

1 × SELECT * 
  FROM j3x_osmembership_config

1 × SELECT Discussion.discussion_id AS `Discussion.discussion_id`, Discussion.type AS `Discussion.type`, Discussion.parent_post_id AS `Discussion.parent_post_id`, Discussion.review_id AS `Discussion.review_id`, Discussion.user_id AS `Discussion.user_id`, Discussion.name AS `Discussion.name`, Discussion.username AS `Discussion.username`, Discussion.ipaddress AS `Discussion.ipaddress`, Discussion.text AS `Discussion.text`, Discussion.created AS `Discussion.created`, Discussion.modified AS `Discussion.modified`, Discussion.approved AS `Discussion.approved`, User.id AS `User.user_id`, User.block AS `User.block`, Discussion.email As `User.email`, Review.id AS `Review.review_id`, Review.title AS `Review.title`, Review.mode AS `Review.extension`, Review.pid AS `Review.listing_id`, Review.userid AS `Review.user_id`, Review.listing_type_id AS `ListingType.listing_type_id`, Review.author AS `Review.editor`, Review.pid AS `Listing.listing_id`, Review.mode AS `Listing.extension`, 
  CASE WHEN CHAR_LENGTH(User. name) THEN User. name ELSE Discussion.name END AS `User.name`, 
  CASE WHEN CHAR_LENGTH(User. username) THEN User.username ELSE Discussion.username END AS `User.username`  
  FROM j3x_jreviews_discussions AS Discussion 
  LEFT JOIN j3x_users AS User 
  ON Discussion.user_id = User.id 
  INNER JOIN j3x_jreviews_comments AS Review 
  ON Discussion.review_id = Review.id 
  AND Review.published = 1

1 × SELECT id, home, template, s.params 
  FROM j3x_template_styles as s 
  LEFT JOIN j3x_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

1 × SELECT value 
  FROM j3x_jreviews_config

1 × SELECT name 
  FROM j3x_jreviews_addons

1 × SELECT                  Review.id             
  FROM j3x_jreviews_comments as Review

1 × SELECT @max_likes := MAX(likes_total) 
  FROM j3x_jreviews_media

1 × SELECT Review.id AS `Review.review_id`, Review.pid AS `Review.listing_id`, Review.mode AS `Review.extension`, Review.created AS `Review.created`, Review.modified AS `Review.modified`, Review.userid AS `Review.user_id`, User.id AS `User.user_id`, 
  CASE WHEN CHAR_LENGTH(User.name) THEN User.name ELSE Review.name END AS `User.name`, 
  CASE WHEN CHAR_LENGTH(User.username) THEN User.username ELSE Review.username END AS `User.username`, User.block AS `User.block`, Review.email AS `User.email`, Review.ipaddress AS `User.ipaddress`, ReviewerRank.`rank` AS `User.reviewer_rank`, ReviewerRank.reviews AS `User.review_count`, Review.title AS `Review.title`, Review.comments AS `Review.comments`, Review.posts AS `Review.posts`, Review.author AS `Review.editor`, Review.published AS `Review.published`, IF(Review.rating=0,"na",Review.rating) AS `Rating.average_rating`, Review.vote_helpful AS `Vote.yes`, (Review.vote_total - Review.vote_helpful) AS `Vote.no`, (Review.vote_helpful/Review.vote_total)*Review.vote_helpful AS `Vote.helpful`, Review.owner_reply_text AS `Review.owner_reply_text`, Review.owner_reply_approved AS `Review.owner_reply_approved`, Review.owner_reply_created AS `Review.owner_reply_created`, Review.media_count AS `Review.media_count`, Review.video_count AS `Review.video_count`, Review.photo_count AS `Review.photo_count`, Review.audio_count AS `Review.audio_count`, Review.attachment_count AS `Review.attachment_count`, Review.listing_type_id AS `ListingType.listing_type_id`  
  FROM j3x_jreviews_comments AS Review 
  LEFT JOIN j3x_users AS User 
  ON Review.userid = User.id 
  LEFT JOIN j3x_jreviews_reviewer_ranks AS ReviewerRank 
  ON Review.userid = ReviewerRank.user_id

1 × SELECT                 content_id AS listing_id, count(*) AS favored 
  FROM j3x_jreviews_favorites AS Favorite

1 × SELECT folder AS type, element AS name, params, extension_id 
  FROM j3x_extensions

טבלאות אחרות:

1 × UPDATE `j3x_extensions` 
  SET `params` = '{\"mediaversion\":\"a920581cdb27da2b99f19c5ee78cb687\"}'

```
1 × 
  SET SQL_BIG_SELECTS=
```

1 × SHOW TABLES LIKE '%_jreviews_config

1 × INSERT INTO j3x_jreviews_config ( id, value ) 
  VALUES ('ranks_rebuild_last','1745625493') 
  ON DUPLICATE KEY UPDATE value = 
  VALUES(value

1 × UPDATE                 j3x_jreviews_comments             
  SET                  vote_helpful = 0, vote_total = 0

1 × UPDATE                 j3x_jreviews_comments as Review                 
  INNER JOIN                 (                     SELECT                         review_id AS review_id,                         SUM(vote_yes + vote_no) AS vote_total,                         SUM(vote_yes) AS vote_helpful                     
  FROM                         j3x_jreviews_votes AS Review                     
  GROUP BY                         review_id

1 × DELETE             
  FROM                 j3x_jreviews_reviewer_ranks

1 × INSERT INTO                 j3x_jreviews_reviewer_ranks (user_id, reviews, votes_percent_helpful, votes_total)                 (                     SELECT                         userid AS user_id,                         COUNT(*) AS reviews,                         (IF(SUM(vote_total)>0,SUM(vote_helpful)/SUM(vote_total),0)) AS votes_percent_helpful,                         SUM(vote_total) AS votes_total                     
  FROM                         j3x_jreviews_comments AS Review                     RIGHT JOIN                         j3x_users AS User 
  ON User.id = Review.userid 
  AND User.block = 0

1 × INSERT INTO                 j3x_jreviews_reviewer_ranks (user_id, `rank`)                 (                     SELECT                         user_id,                         @curRank := @curRank + 1 AS `rank`                     
  FROM                         j3x_jreviews_reviewer_ranks, (SELECT @curRank := 0) r

1 × INSERT INTO j3x_jreviews_config ( id, value ) 
  VALUES ('media_likes_rebuild_last','1745625493') 
  ON DUPLICATE KEY UPDATE value = 
  VALUES(value

1 × INSERT INTO     j3x_jreviews_media (media_id, likes_up, likes_total)     (SELECT      media_id AS media_id,      SUM(IF(vote = 1, 1, 0)) AS likes_up,      COUNT(*) AS likes_total     
  FROM j3x_jreviews_media_likes          
  GROUP BY media_id

1 × INSERT INTO      j3x_jreviews_media (media_id, likes_rank)      (SELECT       media_id AS media_id,       (SUM(IF(vote = 1, 1,0))/COUNT(*)) * (COUNT(*)/@max_likes) * 16000000 AS likes_rank      
  FROM       j3x_jreviews_media_likes      
  GROUP BY       media_id

1 × SHOW FULL COLUMNS 
  FROM `j3x_kunena_users

Review Detail

תגובות

קונסול ניטור של ג'ומלה

Session

מידע פרופיל

Time

Memory

שימוש בזיכרון

שאליתות בסיס נתונים

73 שאילתות נרשמו 697.78 ms

6 duplicate found!

60 Query Types Logged, Sorted by Occurrences.

טבלאות SELECT:

טבלאות אחרות: