24.7 +994 (70) 842-00-11

Sizin səbətiniz boşdur

Seçdiyiniz malları səbətə əlavə edin.

https://bakumarket.az/ /index.php/az/cart/view /index.php/az/product/view /index.php/az/cart/delete /index.php/az/cart/clear https://bakumarket.az/components/com_jshopping/files/img_products 2 ₼ Səbətdə olan mallar Səbətə keçid Malların sayı: malların ümumi dəyəri Təmizlə Zəhmət olmasa, malın atributlarını seçərdiniz.

Bizimlə əlaqə

Sizi maraqlandıran mal haqqında və ya digər suallarınızı aşağıda göstərilən vasitələrin köməyi ilə verə bilərsiz.

Əlaqə vasitələri

Azərbaycan, Bakı, Az1110 Akademik Həsən Əliyev küçəsi 90

Ünvan:

+994 (70) 842 00 11

Telefonlar:

+994 (70) 842 00 11

Whatsapp:

info@bakumarket.az

E-mail:

BakuMarket.Az

Sayt:

Xəritə

Müraciətinizi göndərin (Geri əlaqə forması)

Sizin adınız *

Email *

Bizi necə tapdınız? *

Sosial şəbəkələr

İnternetdə axtarış

Dostların məsləhəti ilə

Şəhər və ya yaşayış məntəqəsi

Sizin müraciətinizin mətni *

Spamdan mühafizə

İnsan olduğunuzu quş qoymaqla təsdiq edin *

Fayl əlavə et

Faylı yüklə

Faylı əlavə et ...

Xidmətlərdən istifadə şərtləri ilə razıyam *

Popup

Məktubun surəti mənim emaylıma göndərilsin

YIĞILSIN AÇILSIN DƏYİŞSİN

Müqayisə üçün mal seçilməyib

Bu vebsayt - saytdan istifadə etdiyiniz zaman maksimal rahatlığınız təminatı üçün kuki fayllarından istifadə edir. Təfərrüatlar

İcazə verilsin

Qonaq 2337
İstif. 0

Joomla! Debug Console

Session

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

Profile Information

Time

Memory

Time: 4.29 ms / 4.29 ms Memory: 0.045 MB / 0.38 MB Application: afterLoad

Time: 25.24 ms / 29.53 ms Memory: 1.359 MB / 1.74 MB Application: afterInitialise

Time: 5.87 ms / 35.40 ms Memory: 0.419 MB / 2.15 MB Application: afterRoute

Time: 0.35 ms / 35.75 ms Memory: 0.013 MB / 2.17 MB Application: beforeRenderComponent com_creativecontactform

Time: 84.63 ms / 120.38 ms Memory: 0.469 MB / 2.64 MB Application: afterRenderComponent com_creativecontactform

Time: 5.24 ms / 125.63 ms Memory: 0.136 MB / 2.77 MB Application: afterDispatch

Time: 26.46 ms / 152.09 ms Memory: 0.770 MB / 3.54 MB Application: beforeRenderModule mod_languages (Сменить язык (внизу))

Time: 1.06 ms / 153.16 ms Memory: 0.033 MB / 3.58 MB Application: afterRenderModule mod_languages (Сменить язык (внизу))

Time: 0.24 ms / 153.40 ms Memory: 0.005 MB / 3.58 MB Application: beforeRenderModule mod_whosonline (Ziyarətçilər)

Time: 2.95 ms / 156.35 ms Memory: 0.036 MB / 3.62 MB Application: afterRenderModule mod_whosonline (Ziyarətçilər)

Time: 0.50 ms / 156.85 ms Memory: 0.020 MB / 3.64 MB Application: beforeRenderModule mod_menu (İstifadəçi menyusu)

Time: 1.13 ms / 157.98 ms Memory: 0.018 MB / 3.65 MB Application: afterRenderModule mod_menu (İstifadəçi menyusu)

Time: 0.56 ms / 158.54 ms Memory: 0.000 MB / 3.65 MB Application: beforeRenderModule mod_menu (Hüquqi məlumat)

Time: 0.88 ms / 159.43 ms Memory: 0.013 MB / 3.66 MB Application: afterRenderModule mod_menu (Hüquqi məlumat)

Time: 0.15 ms / 159.58 ms Memory: 0.000 MB / 3.64 MB Application: beforeRenderModule mod_easycookieinfo (EasyCookieInfo)

Time: 0.29 ms / 159.86 ms Memory: 0.012 MB / 3.66 MB Application: afterRenderModule mod_easycookieinfo (EasyCookieInfo)

Time: 0.04 ms / 159.90 ms Memory: 0.000 MB / 3.65 MB Application: beforeRenderModule mod_breadcrumbs (Хлебные крошки (верх))

Time: 0.36 ms / 160.26 ms Memory: 0.012 MB / 3.66 MB Application: afterRenderModule mod_breadcrumbs (Хлебные крошки (верх))

Time: 0.30 ms / 160.56 ms Memory: 0.159 MB / 3.82 MB Application: beforeRenderModule mod_jshopping_products_compare (Malların müqayisəsi)

Time: 1.50 ms / 162.06 ms Memory: 0.041 MB / 3.86 MB Application: afterRenderModule mod_jshopping_products_compare (Malların müqayisəsi)

Time: 0.04 ms / 162.09 ms Memory: 0.000 MB / 3.86 MB Application: beforeRenderModule mod_jshopping_search (Поиск товаров)

Time: 0.46 ms / 162.55 ms Memory: 0.011 MB / 3.87 MB Application: afterRenderModule mod_jshopping_search (Поиск товаров)

Time: 0.28 ms / 162.83 ms Memory: 0.157 MB / 4.03 MB Application: beforeRenderModule mod_jshopping_products_compare (Malların müqayisəsi)

Time: 0.14 ms / 162.97 ms Memory: 0.008 MB / 4.03 MB Application: afterRenderModule mod_jshopping_products_compare (Malların müqayisəsi)

Time: 0.03 ms / 163.00 ms Memory: 0.000 MB / 4.03 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs (навигатор))

Time: 0.09 ms / 163.09 ms Memory: 0.005 MB / 4.03 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs (навигатор))

Time: 0.04 ms / 163.13 ms Memory: 0.001 MB / 4.03 MB Application: beforeRenderModule mod_jcart_ajax (Cart Ajax)

Time: 0.65 ms / 163.78 ms Memory: 0.026 MB / 4.06 MB Application: afterRenderModule mod_jcart_ajax (Cart Ajax)

Time: 0.26 ms / 164.04 ms Memory: 0.008 MB / 4.07 MB Application: beforeRenderModule mod_languages ( Language Switcher )

Time: 0.39 ms / 164.42 ms Memory: 0.005 MB / 4.07 MB Application: afterRenderModule mod_languages ( Language Switcher )

Time: 265.05 ms / 429.47 ms Memory: 0.879 MB / 4.95 MB Application: afterRender

Database queries total: 90.34 ms

Memory Usage

Database Queries

67 Queries Logged 90.34 ms

32 duplicate found!

10 duplicates: #11 #14 #17 #20 #23 #27 #30 #33 #36 #39

10 duplicates: #12 #15 #18 #21 #24 #28 #31 #34 #37 #40

10 duplicates: #13 #16 #19 #22 #25 #29 #32 #35 #38 #41

2 duplicates: #50 #51

Query Time: 0.46 ms Query memory: 0.022 MB Memory before query: 0.655 MB Rows returned: 0

SELECT `data`

  FROM `bm_session`

  WHERE `session_id` = 'bd7a86cdf8e6fcb8ffda09a671e3a914'

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `data` FROM `#__session` WHERE `session_id` = 'bd7a86cdf8e6fcb8ffda09a671' at line 1 SQL=EXPLAIN EXTENDED SELECT `data` FROM `#__session` WHERE `session_id` = 'bd7a86cdf8e6fcb8ffda09a671e3a914'

Profile

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.14 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.04 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
12	JSessionStorageDatabase->read()	Same as call in the line below.
11	session_start()	JROOT/libraries/joomla/session/handler/native.php:259
10	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:49
9	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:81
8	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:636
7	JSession->_start()	JROOT/libraries/joomla/session/session.php:596
6	JSession->start()	JROOT/libraries/cms/application/cms.php:773
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

[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.36 ms Query memory: 0.003 MB Memory before query: 0.671 MB

DELETE 

  FROM `bm_session`

  WHERE `time` < '1772233455'

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELETE FROM `#__session` WHERE `time` < '1772233455'' at line 1 SQL=EXPLAIN EXTENDED DELETE FROM `#__session` WHERE `time` < '1772233455'

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.05 ms
updating	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:790
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

[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.13 ms Query memory: 0.019 MB Memory before query: 0.676 MB Rows returned: 0

SELECT `session_id`

  FROM `bm_session`

  WHERE `session_id` = 'bd7a86cdf8e6fcb8ffda09a671e3a914' 
  LIMIT 1

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `session_id` FROM `#__session` WHERE `session_id` = 'bd7a86cdf8e6fcb8ffda' at line 1 SQL=EXPLAIN EXTENDED SELECT `session_id` FROM `#__session` WHERE `session_id` = 'bd7a86cdf8e6fcb8ffda09a671e3a914' LIMIT 1

Profile

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Query Time: 0.37 ms After last query: 0.07 ms Query memory: 0.003 MB Memory before query: 0.680 MB

INSERT INTO `bm_session`
(`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES 
('bd7a86cdf8e6fcb8ffda09a671e3a914', 0, 1, '1772593455', 0, '')

Explain

EXPLAIN not possible on query: INSERT INTO `bm_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('bd7a86cdf8e6fcb8ffda09a671e3a914', 0, 1, '1772593455', 0, '')

Profile

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
update	0.11 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.05 ms
freeing items	0.05 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:212
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

[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.73 ms Query memory: 0.021 MB Memory before query: 0.729 MB Rows returned: 2

SELECT b.id

  FROM bm_usergroups AS a

  LEFT JOIN bm_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 9

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT b.id FROM #__usergroups AS a LEFT JOIN #__usergroups AS b ON b.lft <= a.l' at line 1 SQL=EXPLAIN EXTENDED SELECT b.id FROM #__usergroups AS a LEFT JOIN #__usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE a.id = 9

Profile

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.03 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:835
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:904
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.30 ms After last query: 0.06 ms Query memory: 0.021 MB Memory before query: 0.733 MB Rows returned: 6

SELECT id, rules

  FROM `bm_viewlevels`

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT id, rules FROM `#__viewlevels`' at line 1 SQL=EXPLAIN EXTENDED SELECT id, rules FROM `#__viewlevels`

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.05 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:921
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.06 ms After last query: 0.42 ms Query memory: 0.025 MB Memory before query: 0.744 MB Rows returned: 73

SELECT folder AS type, element AS name, params

  FROM bm_extensions

  WHERE enabled = 1 
  AND type ='plugin' 
  AND state IN (0,1) 
  AND access IN (1,1,5)

  ORDER BY ordering

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT folder AS type, element AS name, params FROM #__extensions WHERE enabled ' at line 1 SQL=EXPLAIN EXTENDED SELECT folder AS type, element AS name, params FROM #__extensions WHERE enabled = 1 AND type ='plugin' AND state IN (0,1) AND access IN (1,1,5) ORDER BY ordering

Profile

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.70 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
7	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:310
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.40 ms After last query: 3.52 ms Query memory: 0.021 MB Memory before query: 1.097 MB Rows returned: 3

SELECT element

  FROM bm_extensions

  WHERE type = 'language' 
  AND client_id = 0 
  AND enabled = 1

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT element FROM #__extensions WHERE type = 'language' AND client_id = 0 AND ' at line 1 SQL=EXPLAIN EXTENDED SELECT element FROM #__extensions WHERE type = 'language' AND client_id = 0 AND enabled = 1

Profile

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.05 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/multilang.php:90
8	JLanguageMultilang::getSiteLangs()	JROOT/plugins/system/languagefilter/languagefilter.php:108
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.48 ms After last query: 1.54 ms Query memory: 0.007 MB Memory before query: 1.269 MB

UPDATE `bm_extensions`

  SET `params` = '{\"mediaversion\":\"3983b462b5f2c0666ce8dd20eadbf96c\"}'

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

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UPDATE `#__extensions` SET `params` = '{\"mediaversion\":\"3983b462b5f2c0666ce8d' at line 1 SQL=EXPLAIN EXTENDED UPDATE `#__extensions` SET `params` = '{\"mediaversion\":\"3983b462b5f2c0666ce8dd20eadbf96c\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.08 ms
updating	0.07 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.13 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
15	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
14	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
13	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
12	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
11	JFactory::getDocument()	JROOT/plugins/system/helix/core/helix.php:50
10	Helix::getDocument()	JROOT/plugins/system/helix/core/helix.php:36
9	Helix::getInstance()	JROOT/plugins/system/helix/helix.php:21
8	plgSystemHelix->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.78 ms After last query: 0.17 ms Query memory: 0.077 MB Memory before query: 1.290 MB Rows returned: 61

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

  LEFT JOIN bm_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.ty' at line 1 SQL=EXPLAIN EXTENDED 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 #__menu AS m LEFT JOIN #__extensions AS e ON m.component_id = e.extension_id WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0 ORDER BY m.lft

Profile

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.04 ms
executing	1.40 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
20	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
19	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
18	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
17	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
16	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
15	JApplicationSite->getMenu()	JROOT/libraries/cms/application/site.php:438
14	JApplicationSite->getTemplate()	JROOT/plugins/system/helix/core/helix.php:65
13	Helix::themeName()	JROOT/plugins/system/helix/core/helix.php:114
12	Helix::themePath()	JROOT/plugins/system/helix/core/helix.php:302
11	Helix::_Import()	JROOT/plugins/system/helix/core/helix.php:290
10	Helix::Import()	JROOT/plugins/system/helix/core/helix.php:1592
9	Helix::loadHelixOverwrite()	JROOT/plugins/system/helix/helix.php:22
8	plgSystemHelix->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 7.41 ms After last query: 24.60 ms Query memory: 0.025 MB Memory before query: 2.219 MB Rows returned: 17

Duplicate queries: #14 #17 #20 #23 #27 #30 #33 #36 #39

SELECT
					sp.id,
					st.name as type
					
  FROM
					`bm_creative_fields` sp
					JOIN `bm_creative_field_types` st 
  ON st.id = sp.id_type
					
  WHERE sp.published = '1'
					
  AND sp.id_form = '18'
					
  ORDER BY sp.ordering,sp.id

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT sp.id, st.name as type FROM `#__creative_fields` ' at line 1 SQL=EXPLAIN EXTENDED SELECT sp.id, st.name as type FROM `#__creative_fields` sp JOIN `#__creative_field_types` st ON st.id = sp.id_type WHERE sp.published = '1' AND sp.id_form = '18' ORDER BY sp.ordering,sp.id

Profile

Status	Duration
starting	0.14 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	2.75 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.04 ms
statistics	2.91 ms
preparing	0.06 ms
executing	1.19 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
16	JDatabaseDriver->loadAssocList()	JROOT/components/com_creativecontactform/helpers/helper.php:229
15	CreativecontactformHelper->get_data()	JROOT/components/com_creativecontactform/helpers/helper.php:980
14	CreativecontactformHelper->render_html()	JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php:23
13	include JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_creativecontactform/views/creativecontactform/view.html.php:21
10	CreativeContactFormViewCreativecontactform->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_creativecontactform/controller.php:34
8	CreativeContactFormController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_creativecontactform/creativecontactform.php:32
6	require_once JROOT/components/com_creativecontactform/creativecontactform.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 16.89 ms After last query: 0.16 ms Query memory: 0.025 MB Memory before query: 2.240 MB Rows returned: 1

Duplicate queries: #15 #18 #21 #24 #28 #31 #34 #37 #40

SELECT
					sp.`id_template`,
					sp.name,
					sp.top_text,
					sp.pre_text,
					sp.thank_you_text,
					sp.send_text,
					sp.send_new_text,
					sp.close_alert_text,
					sp.form_width,
					sp.redirect,
					sp.redirect_itemid,
					sp.redirect_url,
					sp.redirect_delay,
					sp.shake_count,
					sp.shake_distanse,
					sp.send_copy_enable,
					sp.send_copy_text,
					sp.shake_duration,
					sp.custom_css,
					st.styles,

					sp.render_type,
					sp.popup_button_text,
					sp.static_button_position,
					sp.static_button_offset,
					sp.appear_animation_type,
					sp.check_token,
					sp.next_button_text,
					sp.prev_button_text

					
  FROM
					`bm_creative_forms` sp
					
  LEFT JOIN `bm_contact_templates` st 
  ON st.id = sp.id_template
					
  WHERE sp.published = '1'
					
  AND sp.id = '18'

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT sp.`id_template`, sp.name, sp.top_text, sp.pre_te' at line 1 SQL=EXPLAIN EXTENDED SELECT sp.`id_template`, sp.name, sp.top_text, sp.pre_text, sp.thank_you_text, sp.send_text, sp.send_new_text, sp.close_alert_text, sp.form_width, sp.redirect, sp.redirect_itemid, sp.redirect_url, sp.redirect_delay, sp.shake_count, sp.shake_distanse, sp.send_copy_enable, sp.send_copy_text, sp.shake_duration, sp.custom_css, st.styles, sp.render_type, sp.popup_button_text, sp.static_button_position, sp.static_button_offset, sp.appear_animation_type, sp.check_token, sp.next_button_text, sp.prev_button_text FROM `#__creative_forms` sp LEFT JOIN `#__contact_templates` st ON st.id = sp.id_template WHERE sp.published = '1' AND sp.id = '18'

Profile

Status	Duration
starting	0.15 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	2.14 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	14.16 ms
preparing	0.02 ms
executing	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
16	JDatabaseDriver->loadAssoc()	JROOT/components/com_creativecontactform/helpers/helper.php:283
15	CreativecontactformHelper->get_data()	JROOT/components/com_creativecontactform/helpers/helper.php:980
14	CreativecontactformHelper->render_html()	JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php:23
13	include JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_creativecontactform/views/creativecontactform/view.html.php:21
10	CreativeContactFormViewCreativecontactform->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_creativecontactform/controller.php:34
8	CreativeContactFormController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_creativecontactform/creativecontactform.php:32
6	require_once JROOT/components/com_creativecontactform/creativecontactform.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 2.41 ms After last query: 0.13 ms Query memory: 0.118 MB Memory before query: 2.257 MB Rows returned: 17

Duplicate queries: #16 #19 #22 #25 #29 #32 #35 #38 #41

SELECT
					sp.id,
					sp.name,
					sp.tooltip_text,
					sp.required,
					sp.ordering_field,
					sp.select_default_text,
					sp.show_parent_label,
					sp.select_no_match_text,
					sp.width,
					sp.field_margin_top,
					sp.select_show_scroll_after,
					sp.select_show_search_after,
					sp.upload_button_text,
					sp.upload_minfilesize,
					sp.upload_maxfilesize,
					sp.upload_acceptfiletypes,
					sp.upload_minfilesize_message,
					sp.upload_maxfilesize_message,
					sp.upload_acceptfiletypes_message,
					sp.captcha_wrong_message,

					sp.datepicker_date_format,
					sp.datepicker_animation,
					sp.datepicker_style,
					sp.datepicker_icon_style,
					sp.datepicker_show_icon,
					sp.datepicker_input_readonly,
					sp.datepicker_number_months,
					sp.datepicker_mindate,
					sp.datepicker_maxdate,
					sp.datepicker_changemonths,
					sp.datepicker_changeyears,
					sp.column_type,
					sp.custom_html,
					sp.google_maps,
					sp.heading,
					sp.recaptcha_site_key,
					sp.recaptcha_wrong_message,
					sp.recaptcha_theme,
					sp.recaptcha_type,
					sp.contact_data,
					sp.contact_data_width,
					sp.creative_popup,
					sp.creative_popup_embed,

					sp.m_recipients_value,
					sp.m_recipients_multiple,
					sp.pagebreak_type,
					sp.pagebreak_page_title,
					sp.if_id,
					sp.if_val,
					sp.then_id,
					sp.hidden_val,

					st.name as type
				
  FROM
					`bm_creative_fields` sp
				JOIN `bm_creative_field_types` st 
  ON st.id = sp.id_type
				
  WHERE sp.published = '1'
				
  AND sp.id_form = '18'
				
  ORDER BY sp.ordering,sp.id

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT sp.id, sp.name, sp.tooltip_text, sp.required, ' at line 1 SQL=EXPLAIN EXTENDED SELECT sp.id, sp.name, sp.tooltip_text, sp.required, sp.ordering_field, sp.select_default_text, sp.show_parent_label, sp.select_no_match_text, sp.width, sp.field_margin_top, sp.select_show_scroll_after, sp.select_show_search_after, sp.upload_button_text, sp.upload_minfilesize, sp.upload_maxfilesize, sp.upload_acceptfiletypes, sp.upload_minfilesize_message, sp.upload_maxfilesize_message, sp.upload_acceptfiletypes_message, sp.captcha_wrong_message, sp.datepicker_date_format, sp.datepicker_animation, sp.datepicker_style, sp.datepicker_icon_style, sp.datepicker_show_icon, sp.datepicker_input_readonly, sp.datepicker_number_months, sp.datepicker_mindate, sp.datepicker_maxdate, sp.datepicker_changemonths, sp.datepicker_changeyears, sp.column_type, sp.custom_html, sp.google_maps, sp.heading, sp.recaptcha_site_key, sp.recaptcha_wrong_message, sp.recaptcha_theme, sp.recaptcha_type, sp.contact_data, sp.contact_data_width, sp.creative_popup, sp.creative_popup_embed, sp.m_recipients_value, sp.m_recipients_multiple, sp.pagebreak_type, sp.pagebreak_page_title, sp.if_id, sp.if_val, sp.then_id, sp.hidden_val, st.name as type FROM `#__creative_fields` sp JOIN `#__creative_field_types` st ON st.id = sp.id_type WHERE sp.published = '1' AND sp.id_form = '18' ORDER BY sp.ordering,sp.id

Profile

Status	Duration
starting	0.14 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.10 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.11 ms
preparing	0.07 ms
executing	1.69 ms
end	0.01 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
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
16	JDatabaseDriver->loadAssocList()	JROOT/components/com_creativecontactform/helpers/helper.php:353
15	CreativecontactformHelper->get_data()	JROOT/components/com_creativecontactform/helpers/helper.php:980
14	CreativecontactformHelper->render_html()	JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php:23
13	include JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_creativecontactform/views/creativecontactform/view.html.php:21
10	CreativeContactFormViewCreativecontactform->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_creativecontactform/controller.php:34
8	CreativeContactFormController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_creativecontactform/creativecontactform.php:32
6	require_once JROOT/components/com_creativecontactform/creativecontactform.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.96 ms After last query: 2.21 ms Query memory: 0.026 MB Memory before query: 2.369 MB Rows returned: 17

Duplicate queries: #11 #17 #20 #23 #27 #30 #33 #36 #39

SELECT
					sp.id,
					st.name as type
					
  FROM
					`bm_creative_fields` sp
					JOIN `bm_creative_field_types` st 
  ON st.id = sp.id_type
					
  WHERE sp.published = '1'
					
  AND sp.id_form = '18'
					
  ORDER BY sp.ordering,sp.id

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT sp.id, st.name as type FROM `#__creative_fields` ' at line 1 SQL=EXPLAIN EXTENDED SELECT sp.id, st.name as type FROM `#__creative_fields` sp JOIN `#__creative_field_types` st ON st.id = sp.id_type WHERE sp.published = '1' AND sp.id_form = '18' ORDER BY sp.ordering,sp.id

Profile

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.06 ms
preparing	0.04 ms
executing	0.46 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
18	JDatabaseDriver->loadAssocList()	JROOT/components/com_creativecontactform/helpers/helper.php:229
17	CreativecontactformHelper->get_data()	JROOT/components/com_creativecontactform/helpers/helper.php:439
16	CreativecontactformHelper->print_fields_array_html()	JROOT/components/com_creativecontactform/helpers/helper.php:911
15	CreativecontactformHelper->print_fields_columns()	JROOT/components/com_creativecontactform/helpers/helper.php:1195
14	CreativecontactformHelper->render_html()	JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php:23
13	include JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_creativecontactform/views/creativecontactform/view.html.php:21
10	CreativeContactFormViewCreativecontactform->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_creativecontactform/controller.php:34
8	CreativeContactFormController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_creativecontactform/creativecontactform.php:32
6	require_once JROOT/components/com_creativecontactform/creativecontactform.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

Duplicate queries: #12 #18 #21 #24 #28 #31 #34 #37 #40

SELECT
					sp.`id_template`,
					sp.name,
					sp.top_text,
					sp.pre_text,
					sp.thank_you_text,
					sp.send_text,
					sp.send_new_text,
					sp.close_alert_text,
					sp.form_width,
					sp.redirect,
					sp.redirect_itemid,
					sp.redirect_url,
					sp.redirect_delay,
					sp.shake_count,
					sp.shake_distanse,
					sp.send_copy_enable,
					sp.send_copy_text,
					sp.shake_duration,
					sp.custom_css,
					st.styles,

					sp.render_type,
					sp.popup_button_text,
					sp.static_button_position,
					sp.static_button_offset,
					sp.appear_animation_type,
					sp.check_token,
					sp.next_button_text,
					sp.prev_button_text

					
  FROM
					`bm_creative_forms` sp
					
  LEFT JOIN `bm_contact_templates` st 
  ON st.id = sp.id_template
					
  WHERE sp.published = '1'
					
  AND sp.id = '18'

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT sp.`id_template`, sp.name, sp.top_text, sp.pre_te' at line 1 SQL=EXPLAIN EXTENDED SELECT sp.`id_template`, sp.name, sp.top_text, sp.pre_text, sp.thank_you_text, sp.send_text, sp.send_new_text, sp.close_alert_text, sp.form_width, sp.redirect, sp.redirect_itemid, sp.redirect_url, sp.redirect_delay, sp.shake_count, sp.shake_distanse, sp.send_copy_enable, sp.send_copy_text, sp.shake_duration, sp.custom_css, st.styles, sp.render_type, sp.popup_button_text, sp.static_button_position, sp.static_button_offset, sp.appear_animation_type, sp.check_token, sp.next_button_text, sp.prev_button_text FROM `#__creative_forms` sp LEFT JOIN `#__contact_templates` st ON st.id = sp.id_template WHERE sp.published = '1' AND sp.id = '18'

Profile

Status	Duration
starting	0.12 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.11 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.13 ms
preparing	0.02 ms
executing	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.17 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
18	JDatabaseDriver->loadAssoc()	JROOT/components/com_creativecontactform/helpers/helper.php:283
17	CreativecontactformHelper->get_data()	JROOT/components/com_creativecontactform/helpers/helper.php:439
16	CreativecontactformHelper->print_fields_array_html()	JROOT/components/com_creativecontactform/helpers/helper.php:911
15	CreativecontactformHelper->print_fields_columns()	JROOT/components/com_creativecontactform/helpers/helper.php:1195
14	CreativecontactformHelper->render_html()	JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php:23
13	include JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_creativecontactform/views/creativecontactform/view.html.php:21
10	CreativeContactFormViewCreativecontactform->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_creativecontactform/controller.php:34
8	CreativeContactFormController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_creativecontactform/creativecontactform.php:32
6	require_once JROOT/components/com_creativecontactform/creativecontactform.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 2.35 ms After last query: 0.09 ms Query memory: 0.119 MB Memory before query: 2.408 MB Rows returned: 17

Duplicate queries: #13 #19 #22 #25 #29 #32 #35 #38 #41

SELECT
					sp.id,
					sp.name,
					sp.tooltip_text,
					sp.required,
					sp.ordering_field,
					sp.select_default_text,
					sp.show_parent_label,
					sp.select_no_match_text,
					sp.width,
					sp.field_margin_top,
					sp.select_show_scroll_after,
					sp.select_show_search_after,
					sp.upload_button_text,
					sp.upload_minfilesize,
					sp.upload_maxfilesize,
					sp.upload_acceptfiletypes,
					sp.upload_minfilesize_message,
					sp.upload_maxfilesize_message,
					sp.upload_acceptfiletypes_message,
					sp.captcha_wrong_message,

					sp.datepicker_date_format,
					sp.datepicker_animation,
					sp.datepicker_style,
					sp.datepicker_icon_style,
					sp.datepicker_show_icon,
					sp.datepicker_input_readonly,
					sp.datepicker_number_months,
					sp.datepicker_mindate,
					sp.datepicker_maxdate,
					sp.datepicker_changemonths,
					sp.datepicker_changeyears,
					sp.column_type,
					sp.custom_html,
					sp.google_maps,
					sp.heading,
					sp.recaptcha_site_key,
					sp.recaptcha_wrong_message,
					sp.recaptcha_theme,
					sp.recaptcha_type,
					sp.contact_data,
					sp.contact_data_width,
					sp.creative_popup,
					sp.creative_popup_embed,

					sp.m_recipients_value,
					sp.m_recipients_multiple,
					sp.pagebreak_type,
					sp.pagebreak_page_title,
					sp.if_id,
					sp.if_val,
					sp.then_id,
					sp.hidden_val,

					st.name as type
				
  FROM
					`bm_creative_fields` sp
				JOIN `bm_creative_field_types` st 
  ON st.id = sp.id_type
				
  WHERE sp.published = '1'
				
  AND sp.id_form = '18'
				
  ORDER BY sp.ordering,sp.id

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT sp.id, sp.name, sp.tooltip_text, sp.required, ' at line 1 SQL=EXPLAIN EXTENDED SELECT sp.id, sp.name, sp.tooltip_text, sp.required, sp.ordering_field, sp.select_default_text, sp.show_parent_label, sp.select_no_match_text, sp.width, sp.field_margin_top, sp.select_show_scroll_after, sp.select_show_search_after, sp.upload_button_text, sp.upload_minfilesize, sp.upload_maxfilesize, sp.upload_acceptfiletypes, sp.upload_minfilesize_message, sp.upload_maxfilesize_message, sp.upload_acceptfiletypes_message, sp.captcha_wrong_message, sp.datepicker_date_format, sp.datepicker_animation, sp.datepicker_style, sp.datepicker_icon_style, sp.datepicker_show_icon, sp.datepicker_input_readonly, sp.datepicker_number_months, sp.datepicker_mindate, sp.datepicker_maxdate, sp.datepicker_changemonths, sp.datepicker_changeyears, sp.column_type, sp.custom_html, sp.google_maps, sp.heading, sp.recaptcha_site_key, sp.recaptcha_wrong_message, sp.recaptcha_theme, sp.recaptcha_type, sp.contact_data, sp.contact_data_width, sp.creative_popup, sp.creative_popup_embed, sp.m_recipients_value, sp.m_recipients_multiple, sp.pagebreak_type, sp.pagebreak_page_title, sp.if_id, sp.if_val, sp.then_id, sp.hidden_val, st.name as type FROM `#__creative_fields` sp JOIN `#__creative_field_types` st ON st.id = sp.id_type WHERE sp.published = '1' AND sp.id_form = '18' ORDER BY sp.ordering,sp.id

Profile

Status	Duration
starting	0.16 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.12 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.06 ms
preparing	0.05 ms
executing	1.74 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
18	JDatabaseDriver->loadAssocList()	JROOT/components/com_creativecontactform/helpers/helper.php:353
17	CreativecontactformHelper->get_data()	JROOT/components/com_creativecontactform/helpers/helper.php:439
16	CreativecontactformHelper->print_fields_array_html()	JROOT/components/com_creativecontactform/helpers/helper.php:911
15	CreativecontactformHelper->print_fields_columns()	JROOT/components/com_creativecontactform/helpers/helper.php:1195
14	CreativecontactformHelper->render_html()	JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php:23
13	include JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_creativecontactform/views/creativecontactform/view.html.php:21
10	CreativeContactFormViewCreativecontactform->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_creativecontactform/controller.php:34
8	CreativeContactFormController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_creativecontactform/creativecontactform.php:32
6	require_once JROOT/components/com_creativecontactform/creativecontactform.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.93 ms After last query: 0.66 ms Query memory: 0.026 MB Memory before query: 2.490 MB Rows returned: 17

Duplicate queries: #11 #14 #20 #23 #27 #30 #33 #36 #39

SELECT
					sp.id,
					st.name as type
					
  FROM
					`bm_creative_fields` sp
					JOIN `bm_creative_field_types` st 
  ON st.id = sp.id_type
					
  WHERE sp.published = '1'
					
  AND sp.id_form = '18'
					
  ORDER BY sp.ordering,sp.id

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT sp.id, st.name as type FROM `#__creative_fields` ' at line 1 SQL=EXPLAIN EXTENDED SELECT sp.id, st.name as type FROM `#__creative_fields` sp JOIN `#__creative_field_types` st ON st.id = sp.id_type WHERE sp.published = '1' AND sp.id_form = '18' ORDER BY sp.ordering,sp.id

Profile

Status	Duration
starting	0.09 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.06 ms
preparing	0.04 ms
executing	0.47 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
18	JDatabaseDriver->loadAssocList()	JROOT/components/com_creativecontactform/helpers/helper.php:229
17	CreativecontactformHelper->get_data()	JROOT/components/com_creativecontactform/helpers/helper.php:439
16	CreativecontactformHelper->print_fields_array_html()	JROOT/components/com_creativecontactform/helpers/helper.php:919
15	CreativecontactformHelper->print_fields_columns()	JROOT/components/com_creativecontactform/helpers/helper.php:1195
14	CreativecontactformHelper->render_html()	JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php:23
13	include JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_creativecontactform/views/creativecontactform/view.html.php:21
10	CreativeContactFormViewCreativecontactform->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_creativecontactform/controller.php:34
8	CreativeContactFormController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_creativecontactform/creativecontactform.php:32
6	require_once JROOT/components/com_creativecontactform/creativecontactform.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

Duplicate queries: #12 #15 #21 #24 #28 #31 #34 #37 #40

SELECT
					sp.`id_template`,
					sp.name,
					sp.top_text,
					sp.pre_text,
					sp.thank_you_text,
					sp.send_text,
					sp.send_new_text,
					sp.close_alert_text,
					sp.form_width,
					sp.redirect,
					sp.redirect_itemid,
					sp.redirect_url,
					sp.redirect_delay,
					sp.shake_count,
					sp.shake_distanse,
					sp.send_copy_enable,
					sp.send_copy_text,
					sp.shake_duration,
					sp.custom_css,
					st.styles,

					sp.render_type,
					sp.popup_button_text,
					sp.static_button_position,
					sp.static_button_offset,
					sp.appear_animation_type,
					sp.check_token,
					sp.next_button_text,
					sp.prev_button_text

					
  FROM
					`bm_creative_forms` sp
					
  LEFT JOIN `bm_contact_templates` st 
  ON st.id = sp.id_template
					
  WHERE sp.published = '1'
					
  AND sp.id = '18'

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT sp.`id_template`, sp.name, sp.top_text, sp.pre_te' at line 1 SQL=EXPLAIN EXTENDED SELECT sp.`id_template`, sp.name, sp.top_text, sp.pre_text, sp.thank_you_text, sp.send_text, sp.send_new_text, sp.close_alert_text, sp.form_width, sp.redirect, sp.redirect_itemid, sp.redirect_url, sp.redirect_delay, sp.shake_count, sp.shake_distanse, sp.send_copy_enable, sp.send_copy_text, sp.shake_duration, sp.custom_css, st.styles, sp.render_type, sp.popup_button_text, sp.static_button_position, sp.static_button_offset, sp.appear_animation_type, sp.check_token, sp.next_button_text, sp.prev_button_text FROM `#__creative_forms` sp LEFT JOIN `#__contact_templates` st ON st.id = sp.id_template WHERE sp.published = '1' AND sp.id = '18'

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
18	JDatabaseDriver->loadAssoc()	JROOT/components/com_creativecontactform/helpers/helper.php:283
17	CreativecontactformHelper->get_data()	JROOT/components/com_creativecontactform/helpers/helper.php:439
16	CreativecontactformHelper->print_fields_array_html()	JROOT/components/com_creativecontactform/helpers/helper.php:919
15	CreativecontactformHelper->print_fields_columns()	JROOT/components/com_creativecontactform/helpers/helper.php:1195
14	CreativecontactformHelper->render_html()	JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php:23
13	include JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_creativecontactform/views/creativecontactform/view.html.php:21
10	CreativeContactFormViewCreativecontactform->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_creativecontactform/controller.php:34
8	CreativeContactFormController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_creativecontactform/creativecontactform.php:32
6	require_once JROOT/components/com_creativecontactform/creativecontactform.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.26 ms After last query: 0.06 ms Query memory: 0.119 MB Memory before query: 2.521 MB Rows returned: 17

Duplicate queries: #13 #16 #22 #25 #29 #32 #35 #38 #41

SELECT
					sp.id,
					sp.name,
					sp.tooltip_text,
					sp.required,
					sp.ordering_field,
					sp.select_default_text,
					sp.show_parent_label,
					sp.select_no_match_text,
					sp.width,
					sp.field_margin_top,
					sp.select_show_scroll_after,
					sp.select_show_search_after,
					sp.upload_button_text,
					sp.upload_minfilesize,
					sp.upload_maxfilesize,
					sp.upload_acceptfiletypes,
					sp.upload_minfilesize_message,
					sp.upload_maxfilesize_message,
					sp.upload_acceptfiletypes_message,
					sp.captcha_wrong_message,

					sp.datepicker_date_format,
					sp.datepicker_animation,
					sp.datepicker_style,
					sp.datepicker_icon_style,
					sp.datepicker_show_icon,
					sp.datepicker_input_readonly,
					sp.datepicker_number_months,
					sp.datepicker_mindate,
					sp.datepicker_maxdate,
					sp.datepicker_changemonths,
					sp.datepicker_changeyears,
					sp.column_type,
					sp.custom_html,
					sp.google_maps,
					sp.heading,
					sp.recaptcha_site_key,
					sp.recaptcha_wrong_message,
					sp.recaptcha_theme,
					sp.recaptcha_type,
					sp.contact_data,
					sp.contact_data_width,
					sp.creative_popup,
					sp.creative_popup_embed,

					sp.m_recipients_value,
					sp.m_recipients_multiple,
					sp.pagebreak_type,
					sp.pagebreak_page_title,
					sp.if_id,
					sp.if_val,
					sp.then_id,
					sp.hidden_val,

					st.name as type
				
  FROM
					`bm_creative_fields` sp
				JOIN `bm_creative_field_types` st 
  ON st.id = sp.id_type
				
  WHERE sp.published = '1'
				
  AND sp.id_form = '18'
				
  ORDER BY sp.ordering,sp.id

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT sp.id, sp.name, sp.tooltip_text, sp.required, ' at line 1 SQL=EXPLAIN EXTENDED SELECT sp.id, sp.name, sp.tooltip_text, sp.required, sp.ordering_field, sp.select_default_text, sp.show_parent_label, sp.select_no_match_text, sp.width, sp.field_margin_top, sp.select_show_scroll_after, sp.select_show_search_after, sp.upload_button_text, sp.upload_minfilesize, sp.upload_maxfilesize, sp.upload_acceptfiletypes, sp.upload_minfilesize_message, sp.upload_maxfilesize_message, sp.upload_acceptfiletypes_message, sp.captcha_wrong_message, sp.datepicker_date_format, sp.datepicker_animation, sp.datepicker_style, sp.datepicker_icon_style, sp.datepicker_show_icon, sp.datepicker_input_readonly, sp.datepicker_number_months, sp.datepicker_mindate, sp.datepicker_maxdate, sp.datepicker_changemonths, sp.datepicker_changeyears, sp.column_type, sp.custom_html, sp.google_maps, sp.heading, sp.recaptcha_site_key, sp.recaptcha_wrong_message, sp.recaptcha_theme, sp.recaptcha_type, sp.contact_data, sp.contact_data_width, sp.creative_popup, sp.creative_popup_embed, sp.m_recipients_value, sp.m_recipients_multiple, sp.pagebreak_type, sp.pagebreak_page_title, sp.if_id, sp.if_val, sp.then_id, sp.hidden_val, st.name as type FROM `#__creative_fields` sp JOIN `#__creative_field_types` st ON st.id = sp.id_type WHERE sp.published = '1' AND sp.id_form = '18' ORDER BY sp.ordering,sp.id

Profile

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.06 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.91 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
18	JDatabaseDriver->loadAssocList()	JROOT/components/com_creativecontactform/helpers/helper.php:353
17	CreativecontactformHelper->get_data()	JROOT/components/com_creativecontactform/helpers/helper.php:439
16	CreativecontactformHelper->print_fields_array_html()	JROOT/components/com_creativecontactform/helpers/helper.php:919
15	CreativecontactformHelper->print_fields_columns()	JROOT/components/com_creativecontactform/helpers/helper.php:1195
14	CreativecontactformHelper->render_html()	JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php:23
13	include JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_creativecontactform/views/creativecontactform/view.html.php:21
10	CreativeContactFormViewCreativecontactform->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_creativecontactform/controller.php:34
8	CreativeContactFormController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_creativecontactform/creativecontactform.php:32
6	require_once JROOT/components/com_creativecontactform/creativecontactform.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.53 ms After last query: 0.27 ms Query memory: 0.026 MB Memory before query: 2.521 MB Rows returned: 17

Duplicate queries: #11 #14 #17 #23 #27 #30 #33 #36 #39

SELECT
					sp.id,
					st.name as type
					
  FROM
					`bm_creative_fields` sp
					JOIN `bm_creative_field_types` st 
  ON st.id = sp.id_type
					
  WHERE sp.published = '1'
					
  AND sp.id_form = '18'
					
  ORDER BY sp.ordering,sp.id

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT sp.id, st.name as type FROM `#__creative_fields` ' at line 1 SQL=EXPLAIN EXTENDED SELECT sp.id, st.name as type FROM `#__creative_fields` sp JOIN `#__creative_field_types` st ON st.id = sp.id_type WHERE sp.published = '1' AND sp.id_form = '18' ORDER BY sp.ordering,sp.id

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.25 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
18	JDatabaseDriver->loadAssocList()	JROOT/components/com_creativecontactform/helpers/helper.php:229
17	CreativecontactformHelper->get_data()	JROOT/components/com_creativecontactform/helpers/helper.php:439
16	CreativecontactformHelper->print_fields_array_html()	JROOT/components/com_creativecontactform/helpers/helper.php:928
15	CreativecontactformHelper->print_fields_columns()	JROOT/components/com_creativecontactform/helpers/helper.php:1195
14	CreativecontactformHelper->render_html()	JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php:23
13	include JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_creativecontactform/views/creativecontactform/view.html.php:21
10	CreativeContactFormViewCreativecontactform->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_creativecontactform/controller.php:34
8	CreativeContactFormController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_creativecontactform/creativecontactform.php:32
6	require_once JROOT/components/com_creativecontactform/creativecontactform.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.41 ms After last query: 0.07 ms Query memory: 0.025 MB Memory before query: 2.540 MB Rows returned: 1

Duplicate queries: #12 #15 #18 #24 #28 #31 #34 #37 #40

SELECT
					sp.`id_template`,
					sp.name,
					sp.top_text,
					sp.pre_text,
					sp.thank_you_text,
					sp.send_text,
					sp.send_new_text,
					sp.close_alert_text,
					sp.form_width,
					sp.redirect,
					sp.redirect_itemid,
					sp.redirect_url,
					sp.redirect_delay,
					sp.shake_count,
					sp.shake_distanse,
					sp.send_copy_enable,
					sp.send_copy_text,
					sp.shake_duration,
					sp.custom_css,
					st.styles,

					sp.render_type,
					sp.popup_button_text,
					sp.static_button_position,
					sp.static_button_offset,
					sp.appear_animation_type,
					sp.check_token,
					sp.next_button_text,
					sp.prev_button_text

					
  FROM
					`bm_creative_forms` sp
					
  LEFT JOIN `bm_contact_templates` st 
  ON st.id = sp.id_template
					
  WHERE sp.published = '1'
					
  AND sp.id = '18'

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT sp.`id_template`, sp.name, sp.top_text, sp.pre_te' at line 1 SQL=EXPLAIN EXTENDED SELECT sp.`id_template`, sp.name, sp.top_text, sp.pre_text, sp.thank_you_text, sp.send_text, sp.send_new_text, sp.close_alert_text, sp.form_width, sp.redirect, sp.redirect_itemid, sp.redirect_url, sp.redirect_delay, sp.shake_count, sp.shake_distanse, sp.send_copy_enable, sp.send_copy_text, sp.shake_duration, sp.custom_css, st.styles, sp.render_type, sp.popup_button_text, sp.static_button_position, sp.static_button_offset, sp.appear_animation_type, sp.check_token, sp.next_button_text, sp.prev_button_text FROM `#__creative_forms` sp LEFT JOIN `#__contact_templates` st ON st.id = sp.id_template WHERE sp.published = '1' AND sp.id = '18'

Profile

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.10 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
18	JDatabaseDriver->loadAssoc()	JROOT/components/com_creativecontactform/helpers/helper.php:283
17	CreativecontactformHelper->get_data()	JROOT/components/com_creativecontactform/helpers/helper.php:439
16	CreativecontactformHelper->print_fields_array_html()	JROOT/components/com_creativecontactform/helpers/helper.php:928
15	CreativecontactformHelper->print_fields_columns()	JROOT/components/com_creativecontactform/helpers/helper.php:1195
14	CreativecontactformHelper->render_html()	JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php:23
13	include JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_creativecontactform/views/creativecontactform/view.html.php:21
10	CreativeContactFormViewCreativecontactform->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_creativecontactform/controller.php:34
8	CreativeContactFormController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_creativecontactform/creativecontactform.php:32
6	require_once JROOT/components/com_creativecontactform/creativecontactform.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.30 ms After last query: 0.06 ms Query memory: 0.119 MB Memory before query: 2.552 MB Rows returned: 17

Duplicate queries: #13 #16 #19 #25 #29 #32 #35 #38 #41

SELECT
					sp.id,
					sp.name,
					sp.tooltip_text,
					sp.required,
					sp.ordering_field,
					sp.select_default_text,
					sp.show_parent_label,
					sp.select_no_match_text,
					sp.width,
					sp.field_margin_top,
					sp.select_show_scroll_after,
					sp.select_show_search_after,
					sp.upload_button_text,
					sp.upload_minfilesize,
					sp.upload_maxfilesize,
					sp.upload_acceptfiletypes,
					sp.upload_minfilesize_message,
					sp.upload_maxfilesize_message,
					sp.upload_acceptfiletypes_message,
					sp.captcha_wrong_message,

					sp.datepicker_date_format,
					sp.datepicker_animation,
					sp.datepicker_style,
					sp.datepicker_icon_style,
					sp.datepicker_show_icon,
					sp.datepicker_input_readonly,
					sp.datepicker_number_months,
					sp.datepicker_mindate,
					sp.datepicker_maxdate,
					sp.datepicker_changemonths,
					sp.datepicker_changeyears,
					sp.column_type,
					sp.custom_html,
					sp.google_maps,
					sp.heading,
					sp.recaptcha_site_key,
					sp.recaptcha_wrong_message,
					sp.recaptcha_theme,
					sp.recaptcha_type,
					sp.contact_data,
					sp.contact_data_width,
					sp.creative_popup,
					sp.creative_popup_embed,

					sp.m_recipients_value,
					sp.m_recipients_multiple,
					sp.pagebreak_type,
					sp.pagebreak_page_title,
					sp.if_id,
					sp.if_val,
					sp.then_id,
					sp.hidden_val,

					st.name as type
				
  FROM
					`bm_creative_fields` sp
				JOIN `bm_creative_field_types` st 
  ON st.id = sp.id_type
				
  WHERE sp.published = '1'
				
  AND sp.id_form = '18'
				
  ORDER BY sp.ordering,sp.id

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT sp.id, sp.name, sp.tooltip_text, sp.required, ' at line 1 SQL=EXPLAIN EXTENDED SELECT sp.id, sp.name, sp.tooltip_text, sp.required, sp.ordering_field, sp.select_default_text, sp.show_parent_label, sp.select_no_match_text, sp.width, sp.field_margin_top, sp.select_show_scroll_after, sp.select_show_search_after, sp.upload_button_text, sp.upload_minfilesize, sp.upload_maxfilesize, sp.upload_acceptfiletypes, sp.upload_minfilesize_message, sp.upload_maxfilesize_message, sp.upload_acceptfiletypes_message, sp.captcha_wrong_message, sp.datepicker_date_format, sp.datepicker_animation, sp.datepicker_style, sp.datepicker_icon_style, sp.datepicker_show_icon, sp.datepicker_input_readonly, sp.datepicker_number_months, sp.datepicker_mindate, sp.datepicker_maxdate, sp.datepicker_changemonths, sp.datepicker_changeyears, sp.column_type, sp.custom_html, sp.google_maps, sp.heading, sp.recaptcha_site_key, sp.recaptcha_wrong_message, sp.recaptcha_theme, sp.recaptcha_type, sp.contact_data, sp.contact_data_width, sp.creative_popup, sp.creative_popup_embed, sp.m_recipients_value, sp.m_recipients_multiple, sp.pagebreak_type, sp.pagebreak_page_title, sp.if_id, sp.if_val, sp.then_id, sp.hidden_val, st.name as type FROM `#__creative_fields` sp JOIN `#__creative_field_types` st ON st.id = sp.id_type WHERE sp.published = '1' AND sp.id_form = '18' ORDER BY sp.ordering,sp.id

Profile

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.06 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.95 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
18	JDatabaseDriver->loadAssocList()	JROOT/components/com_creativecontactform/helpers/helper.php:353
17	CreativecontactformHelper->get_data()	JROOT/components/com_creativecontactform/helpers/helper.php:439
16	CreativecontactformHelper->print_fields_array_html()	JROOT/components/com_creativecontactform/helpers/helper.php:928
15	CreativecontactformHelper->print_fields_columns()	JROOT/components/com_creativecontactform/helpers/helper.php:1195
14	CreativecontactformHelper->render_html()	JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php:23
13	include JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_creativecontactform/views/creativecontactform/view.html.php:21
10	CreativeContactFormViewCreativecontactform->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_creativecontactform/controller.php:34
8	CreativeContactFormController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_creativecontactform/creativecontactform.php:32
6	require_once JROOT/components/com_creativecontactform/creativecontactform.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.62 ms After last query: 0.25 ms Query memory: 0.026 MB Memory before query: 2.551 MB Rows returned: 17

Duplicate queries: #11 #14 #17 #20 #27 #30 #33 #36 #39

SELECT
					sp.id,
					st.name as type
					
  FROM
					`bm_creative_fields` sp
					JOIN `bm_creative_field_types` st 
  ON st.id = sp.id_type
					
  WHERE sp.published = '1'
					
  AND sp.id_form = '18'
					
  ORDER BY sp.ordering,sp.id

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT sp.id, st.name as type FROM `#__creative_fields` ' at line 1 SQL=EXPLAIN EXTENDED SELECT sp.id, st.name as type FROM `#__creative_fields` sp JOIN `#__creative_field_types` st ON st.id = sp.id_type WHERE sp.published = '1' AND sp.id_form = '18' ORDER BY sp.ordering,sp.id

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.07 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.27 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
18	JDatabaseDriver->loadAssocList()	JROOT/components/com_creativecontactform/helpers/helper.php:229
17	CreativecontactformHelper->get_data()	JROOT/components/com_creativecontactform/helpers/helper.php:439
16	CreativecontactformHelper->print_fields_array_html()	JROOT/components/com_creativecontactform/helpers/helper.php:911
15	CreativecontactformHelper->print_fields_columns()	JROOT/components/com_creativecontactform/helpers/helper.php:1195
14	CreativecontactformHelper->render_html()	JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php:23
13	include JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_creativecontactform/views/creativecontactform/view.html.php:21
10	CreativeContactFormViewCreativecontactform->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_creativecontactform/controller.php:34
8	CreativeContactFormController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_creativecontactform/creativecontactform.php:32
6	require_once JROOT/components/com_creativecontactform/creativecontactform.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.33 ms After last query: 0.09 ms Query memory: 0.025 MB Memory before query: 2.570 MB Rows returned: 1

Duplicate queries: #12 #15 #18 #21 #28 #31 #34 #37 #40

SELECT
					sp.`id_template`,
					sp.name,
					sp.top_text,
					sp.pre_text,
					sp.thank_you_text,
					sp.send_text,
					sp.send_new_text,
					sp.close_alert_text,
					sp.form_width,
					sp.redirect,
					sp.redirect_itemid,
					sp.redirect_url,
					sp.redirect_delay,
					sp.shake_count,
					sp.shake_distanse,
					sp.send_copy_enable,
					sp.send_copy_text,
					sp.shake_duration,
					sp.custom_css,
					st.styles,

					sp.render_type,
					sp.popup_button_text,
					sp.static_button_position,
					sp.static_button_offset,
					sp.appear_animation_type,
					sp.check_token,
					sp.next_button_text,
					sp.prev_button_text

					
  FROM
					`bm_creative_forms` sp
					
  LEFT JOIN `bm_contact_templates` st 
  ON st.id = sp.id_template
					
  WHERE sp.published = '1'
					
  AND sp.id = '18'

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT sp.`id_template`, sp.name, sp.top_text, sp.pre_te' at line 1 SQL=EXPLAIN EXTENDED SELECT sp.`id_template`, sp.name, sp.top_text, sp.pre_text, sp.thank_you_text, sp.send_text, sp.send_new_text, sp.close_alert_text, sp.form_width, sp.redirect, sp.redirect_itemid, sp.redirect_url, sp.redirect_delay, sp.shake_count, sp.shake_distanse, sp.send_copy_enable, sp.send_copy_text, sp.shake_duration, sp.custom_css, st.styles, sp.render_type, sp.popup_button_text, sp.static_button_position, sp.static_button_offset, sp.appear_animation_type, sp.check_token, sp.next_button_text, sp.prev_button_text FROM `#__creative_forms` sp LEFT JOIN `#__contact_templates` st ON st.id = sp.id_template WHERE sp.published = '1' AND sp.id = '18'

Profile

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
18	JDatabaseDriver->loadAssoc()	JROOT/components/com_creativecontactform/helpers/helper.php:283
17	CreativecontactformHelper->get_data()	JROOT/components/com_creativecontactform/helpers/helper.php:439
16	CreativecontactformHelper->print_fields_array_html()	JROOT/components/com_creativecontactform/helpers/helper.php:911
15	CreativecontactformHelper->print_fields_columns()	JROOT/components/com_creativecontactform/helpers/helper.php:1195
14	CreativecontactformHelper->render_html()	JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php:23
13	include JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_creativecontactform/views/creativecontactform/view.html.php:21
10	CreativeContactFormViewCreativecontactform->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_creativecontactform/controller.php:34
8	CreativeContactFormController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_creativecontactform/creativecontactform.php:32
6	require_once JROOT/components/com_creativecontactform/creativecontactform.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.34 ms After last query: 0.06 ms Query memory: 0.119 MB Memory before query: 2.582 MB Rows returned: 17

Duplicate queries: #13 #16 #19 #22 #29 #32 #35 #38 #41

SELECT
					sp.id,
					sp.name,
					sp.tooltip_text,
					sp.required,
					sp.ordering_field,
					sp.select_default_text,
					sp.show_parent_label,
					sp.select_no_match_text,
					sp.width,
					sp.field_margin_top,
					sp.select_show_scroll_after,
					sp.select_show_search_after,
					sp.upload_button_text,
					sp.upload_minfilesize,
					sp.upload_maxfilesize,
					sp.upload_acceptfiletypes,
					sp.upload_minfilesize_message,
					sp.upload_maxfilesize_message,
					sp.upload_acceptfiletypes_message,
					sp.captcha_wrong_message,

					sp.datepicker_date_format,
					sp.datepicker_animation,
					sp.datepicker_style,
					sp.datepicker_icon_style,
					sp.datepicker_show_icon,
					sp.datepicker_input_readonly,
					sp.datepicker_number_months,
					sp.datepicker_mindate,
					sp.datepicker_maxdate,
					sp.datepicker_changemonths,
					sp.datepicker_changeyears,
					sp.column_type,
					sp.custom_html,
					sp.google_maps,
					sp.heading,
					sp.recaptcha_site_key,
					sp.recaptcha_wrong_message,
					sp.recaptcha_theme,
					sp.recaptcha_type,
					sp.contact_data,
					sp.contact_data_width,
					sp.creative_popup,
					sp.creative_popup_embed,

					sp.m_recipients_value,
					sp.m_recipients_multiple,
					sp.pagebreak_type,
					sp.pagebreak_page_title,
					sp.if_id,
					sp.if_val,
					sp.then_id,
					sp.hidden_val,

					st.name as type
				
  FROM
					`bm_creative_fields` sp
				JOIN `bm_creative_field_types` st 
  ON st.id = sp.id_type
				
  WHERE sp.published = '1'
				
  AND sp.id_form = '18'
				
  ORDER BY sp.ordering,sp.id

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT sp.id, sp.name, sp.tooltip_text, sp.required, ' at line 1 SQL=EXPLAIN EXTENDED SELECT sp.id, sp.name, sp.tooltip_text, sp.required, sp.ordering_field, sp.select_default_text, sp.show_parent_label, sp.select_no_match_text, sp.width, sp.field_margin_top, sp.select_show_scroll_after, sp.select_show_search_after, sp.upload_button_text, sp.upload_minfilesize, sp.upload_maxfilesize, sp.upload_acceptfiletypes, sp.upload_minfilesize_message, sp.upload_maxfilesize_message, sp.upload_acceptfiletypes_message, sp.captcha_wrong_message, sp.datepicker_date_format, sp.datepicker_animation, sp.datepicker_style, sp.datepicker_icon_style, sp.datepicker_show_icon, sp.datepicker_input_readonly, sp.datepicker_number_months, sp.datepicker_mindate, sp.datepicker_maxdate, sp.datepicker_changemonths, sp.datepicker_changeyears, sp.column_type, sp.custom_html, sp.google_maps, sp.heading, sp.recaptcha_site_key, sp.recaptcha_wrong_message, sp.recaptcha_theme, sp.recaptcha_type, sp.contact_data, sp.contact_data_width, sp.creative_popup, sp.creative_popup_embed, sp.m_recipients_value, sp.m_recipients_multiple, sp.pagebreak_type, sp.pagebreak_page_title, sp.if_id, sp.if_val, sp.then_id, sp.hidden_val, st.name as type FROM `#__creative_fields` sp JOIN `#__creative_field_types` st ON st.id = sp.id_type WHERE sp.published = '1' AND sp.id_form = '18' ORDER BY sp.ordering,sp.id

Profile

Status	Duration
starting	0.15 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.08 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.88 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
18	JDatabaseDriver->loadAssocList()	JROOT/components/com_creativecontactform/helpers/helper.php:353
17	CreativecontactformHelper->get_data()	JROOT/components/com_creativecontactform/helpers/helper.php:439
16	CreativecontactformHelper->print_fields_array_html()	JROOT/components/com_creativecontactform/helpers/helper.php:911
15	CreativecontactformHelper->print_fields_columns()	JROOT/components/com_creativecontactform/helpers/helper.php:1195
14	CreativecontactformHelper->render_html()	JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php:23
13	include JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_creativecontactform/views/creativecontactform/view.html.php:21
10	CreativeContactFormViewCreativecontactform->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_creativecontactform/controller.php:34
8	CreativeContactFormController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_creativecontactform/creativecontactform.php:32
6	require_once JROOT/components/com_creativecontactform/creativecontactform.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 10.05 ms After last query: 0.31 ms Query memory: 0.025 MB Memory before query: 2.583 MB Rows returned: 3

SELECT
 							spo.name,
 							spo.id,
 							spo.value,
 							spo.selected
							
  FROM
								`bm_creative_form_options` spo
							
  WHERE spo.id_parent = '156'
							
  AND spo.showrow = '1'
							
  ORDER BY spo.ordering

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT spo.name, spo.id, spo.value, spo.sele' at line 1 SQL=EXPLAIN EXTENDED SELECT spo.name, spo.id, spo.value, spo.selected FROM `#__creative_form_options` spo WHERE spo.id_parent = '156' AND spo.showrow = '1' ORDER BY spo.ordering

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.68 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.02 ms
executing	9.11 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
17	JDatabaseDriver->loadAssocList()	JROOT/components/com_creativecontactform/helpers/helper.php:584
16	CreativecontactformHelper->print_fields_array_html()	JROOT/components/com_creativecontactform/helpers/helper.php:911
15	CreativecontactformHelper->print_fields_columns()	JROOT/components/com_creativecontactform/helpers/helper.php:1195
14	CreativecontactformHelper->render_html()	JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php:23
13	include JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_creativecontactform/views/creativecontactform/view.html.php:21
10	CreativeContactFormViewCreativecontactform->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_creativecontactform/controller.php:34
8	CreativeContactFormController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_creativecontactform/creativecontactform.php:32
6	require_once JROOT/components/com_creativecontactform/creativecontactform.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.45 ms After last query: 0.19 ms Query memory: 0.026 MB Memory before query: 2.591 MB Rows returned: 17

Duplicate queries: #11 #14 #17 #20 #23 #30 #33 #36 #39

SELECT
					sp.id,
					st.name as type
					
  FROM
					`bm_creative_fields` sp
					JOIN `bm_creative_field_types` st 
  ON st.id = sp.id_type
					
  WHERE sp.published = '1'
					
  AND sp.id_form = '18'
					
  ORDER BY sp.ordering,sp.id

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT sp.id, st.name as type FROM `#__creative_fields` ' at line 1 SQL=EXPLAIN EXTENDED SELECT sp.id, st.name as type FROM `#__creative_fields` sp JOIN `#__creative_field_types` st ON st.id = sp.id_type WHERE sp.published = '1' AND sp.id_form = '18' ORDER BY sp.ordering,sp.id

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.05 ms
executing	0.17 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
18	JDatabaseDriver->loadAssocList()	JROOT/components/com_creativecontactform/helpers/helper.php:229
17	CreativecontactformHelper->get_data()	JROOT/components/com_creativecontactform/helpers/helper.php:439
16	CreativecontactformHelper->print_fields_array_html()	JROOT/components/com_creativecontactform/helpers/helper.php:919
15	CreativecontactformHelper->print_fields_columns()	JROOT/components/com_creativecontactform/helpers/helper.php:1195
14	CreativecontactformHelper->render_html()	JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php:23
13	include JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_creativecontactform/views/creativecontactform/view.html.php:21
10	CreativeContactFormViewCreativecontactform->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_creativecontactform/controller.php:34
8	CreativeContactFormController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_creativecontactform/creativecontactform.php:32
6	require_once JROOT/components/com_creativecontactform/creativecontactform.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.26 ms After last query: 0.10 ms Query memory: 0.025 MB Memory before query: 2.610 MB Rows returned: 1

Duplicate queries: #12 #15 #18 #21 #24 #31 #34 #37 #40

SELECT
					sp.`id_template`,
					sp.name,
					sp.top_text,
					sp.pre_text,
					sp.thank_you_text,
					sp.send_text,
					sp.send_new_text,
					sp.close_alert_text,
					sp.form_width,
					sp.redirect,
					sp.redirect_itemid,
					sp.redirect_url,
					sp.redirect_delay,
					sp.shake_count,
					sp.shake_distanse,
					sp.send_copy_enable,
					sp.send_copy_text,
					sp.shake_duration,
					sp.custom_css,
					st.styles,

					sp.render_type,
					sp.popup_button_text,
					sp.static_button_position,
					sp.static_button_offset,
					sp.appear_animation_type,
					sp.check_token,
					sp.next_button_text,
					sp.prev_button_text

					
  FROM
					`bm_creative_forms` sp
					
  LEFT JOIN `bm_contact_templates` st 
  ON st.id = sp.id_template
					
  WHERE sp.published = '1'
					
  AND sp.id = '18'

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT sp.`id_template`, sp.name, sp.top_text, sp.pre_te' at line 1 SQL=EXPLAIN EXTENDED SELECT sp.`id_template`, sp.name, sp.top_text, sp.pre_text, sp.thank_you_text, sp.send_text, sp.send_new_text, sp.close_alert_text, sp.form_width, sp.redirect, sp.redirect_itemid, sp.redirect_url, sp.redirect_delay, sp.shake_count, sp.shake_distanse, sp.send_copy_enable, sp.send_copy_text, sp.shake_duration, sp.custom_css, st.styles, sp.render_type, sp.popup_button_text, sp.static_button_position, sp.static_button_offset, sp.appear_animation_type, sp.check_token, sp.next_button_text, sp.prev_button_text FROM `#__creative_forms` sp LEFT JOIN `#__contact_templates` st ON st.id = sp.id_template WHERE sp.published = '1' AND sp.id = '18'

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
18	JDatabaseDriver->loadAssoc()	JROOT/components/com_creativecontactform/helpers/helper.php:283
17	CreativecontactformHelper->get_data()	JROOT/components/com_creativecontactform/helpers/helper.php:439
16	CreativecontactformHelper->print_fields_array_html()	JROOT/components/com_creativecontactform/helpers/helper.php:919
15	CreativecontactformHelper->print_fields_columns()	JROOT/components/com_creativecontactform/helpers/helper.php:1195
14	CreativecontactformHelper->render_html()	JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php:23
13	include JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_creativecontactform/views/creativecontactform/view.html.php:21
10	CreativeContactFormViewCreativecontactform->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_creativecontactform/controller.php:34
8	CreativeContactFormController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_creativecontactform/creativecontactform.php:32
6	require_once JROOT/components/com_creativecontactform/creativecontactform.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.95 ms After last query: 0.06 ms Query memory: 0.119 MB Memory before query: 2.621 MB Rows returned: 17

Duplicate queries: #13 #16 #19 #22 #25 #32 #35 #38 #41

SELECT
					sp.id,
					sp.name,
					sp.tooltip_text,
					sp.required,
					sp.ordering_field,
					sp.select_default_text,
					sp.show_parent_label,
					sp.select_no_match_text,
					sp.width,
					sp.field_margin_top,
					sp.select_show_scroll_after,
					sp.select_show_search_after,
					sp.upload_button_text,
					sp.upload_minfilesize,
					sp.upload_maxfilesize,
					sp.upload_acceptfiletypes,
					sp.upload_minfilesize_message,
					sp.upload_maxfilesize_message,
					sp.upload_acceptfiletypes_message,
					sp.captcha_wrong_message,

					sp.datepicker_date_format,
					sp.datepicker_animation,
					sp.datepicker_style,
					sp.datepicker_icon_style,
					sp.datepicker_show_icon,
					sp.datepicker_input_readonly,
					sp.datepicker_number_months,
					sp.datepicker_mindate,
					sp.datepicker_maxdate,
					sp.datepicker_changemonths,
					sp.datepicker_changeyears,
					sp.column_type,
					sp.custom_html,
					sp.google_maps,
					sp.heading,
					sp.recaptcha_site_key,
					sp.recaptcha_wrong_message,
					sp.recaptcha_theme,
					sp.recaptcha_type,
					sp.contact_data,
					sp.contact_data_width,
					sp.creative_popup,
					sp.creative_popup_embed,

					sp.m_recipients_value,
					sp.m_recipients_multiple,
					sp.pagebreak_type,
					sp.pagebreak_page_title,
					sp.if_id,
					sp.if_val,
					sp.then_id,
					sp.hidden_val,

					st.name as type
				
  FROM
					`bm_creative_fields` sp
				JOIN `bm_creative_field_types` st 
  ON st.id = sp.id_type
				
  WHERE sp.published = '1'
				
  AND sp.id_form = '18'
				
  ORDER BY sp.ordering,sp.id

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT sp.id, sp.name, sp.tooltip_text, sp.required, ' at line 1 SQL=EXPLAIN EXTENDED SELECT sp.id, sp.name, sp.tooltip_text, sp.required, sp.ordering_field, sp.select_default_text, sp.show_parent_label, sp.select_no_match_text, sp.width, sp.field_margin_top, sp.select_show_scroll_after, sp.select_show_search_after, sp.upload_button_text, sp.upload_minfilesize, sp.upload_maxfilesize, sp.upload_acceptfiletypes, sp.upload_minfilesize_message, sp.upload_maxfilesize_message, sp.upload_acceptfiletypes_message, sp.captcha_wrong_message, sp.datepicker_date_format, sp.datepicker_animation, sp.datepicker_style, sp.datepicker_icon_style, sp.datepicker_show_icon, sp.datepicker_input_readonly, sp.datepicker_number_months, sp.datepicker_mindate, sp.datepicker_maxdate, sp.datepicker_changemonths, sp.datepicker_changeyears, sp.column_type, sp.custom_html, sp.google_maps, sp.heading, sp.recaptcha_site_key, sp.recaptcha_wrong_message, sp.recaptcha_theme, sp.recaptcha_type, sp.contact_data, sp.contact_data_width, sp.creative_popup, sp.creative_popup_embed, sp.m_recipients_value, sp.m_recipients_multiple, sp.pagebreak_type, sp.pagebreak_page_title, sp.if_id, sp.if_val, sp.then_id, sp.hidden_val, st.name as type FROM `#__creative_fields` sp JOIN `#__creative_field_types` st ON st.id = sp.id_type WHERE sp.published = '1' AND sp.id_form = '18' ORDER BY sp.ordering,sp.id

Profile

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.64 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
18	JDatabaseDriver->loadAssocList()	JROOT/components/com_creativecontactform/helpers/helper.php:353
17	CreativecontactformHelper->get_data()	JROOT/components/com_creativecontactform/helpers/helper.php:439
16	CreativecontactformHelper->print_fields_array_html()	JROOT/components/com_creativecontactform/helpers/helper.php:919
15	CreativecontactformHelper->print_fields_columns()	JROOT/components/com_creativecontactform/helpers/helper.php:1195
14	CreativecontactformHelper->render_html()	JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php:23
13	include JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_creativecontactform/views/creativecontactform/view.html.php:21
10	CreativeContactFormViewCreativecontactform->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_creativecontactform/controller.php:34
8	CreativeContactFormController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_creativecontactform/creativecontactform.php:32
6	require_once JROOT/components/com_creativecontactform/creativecontactform.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.46 ms After last query: 0.33 ms Query memory: 0.026 MB Memory before query: 2.621 MB Rows returned: 17

Duplicate queries: #11 #14 #17 #20 #23 #27 #33 #36 #39

SELECT
					sp.id,
					st.name as type
					
  FROM
					`bm_creative_fields` sp
					JOIN `bm_creative_field_types` st 
  ON st.id = sp.id_type
					
  WHERE sp.published = '1'
					
  AND sp.id_form = '18'
					
  ORDER BY sp.ordering,sp.id

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT sp.id, st.name as type FROM `#__creative_fields` ' at line 1 SQL=EXPLAIN EXTENDED SELECT sp.id, st.name as type FROM `#__creative_fields` sp JOIN `#__creative_field_types` st ON st.id = sp.id_type WHERE sp.published = '1' AND sp.id_form = '18' ORDER BY sp.ordering,sp.id

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.19 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
18	JDatabaseDriver->loadAssocList()	JROOT/components/com_creativecontactform/helpers/helper.php:229
17	CreativecontactformHelper->get_data()	JROOT/components/com_creativecontactform/helpers/helper.php:439
16	CreativecontactformHelper->print_fields_array_html()	JROOT/components/com_creativecontactform/helpers/helper.php:928
15	CreativecontactformHelper->print_fields_columns()	JROOT/components/com_creativecontactform/helpers/helper.php:1195
14	CreativecontactformHelper->render_html()	JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php:23
13	include JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_creativecontactform/views/creativecontactform/view.html.php:21
10	CreativeContactFormViewCreativecontactform->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_creativecontactform/controller.php:34
8	CreativeContactFormController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_creativecontactform/creativecontactform.php:32
6	require_once JROOT/components/com_creativecontactform/creativecontactform.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.25 ms After last query: 0.09 ms Query memory: 0.025 MB Memory before query: 2.640 MB Rows returned: 1

Duplicate queries: #12 #15 #18 #21 #24 #28 #34 #37 #40

SELECT
					sp.`id_template`,
					sp.name,
					sp.top_text,
					sp.pre_text,
					sp.thank_you_text,
					sp.send_text,
					sp.send_new_text,
					sp.close_alert_text,
					sp.form_width,
					sp.redirect,
					sp.redirect_itemid,
					sp.redirect_url,
					sp.redirect_delay,
					sp.shake_count,
					sp.shake_distanse,
					sp.send_copy_enable,
					sp.send_copy_text,
					sp.shake_duration,
					sp.custom_css,
					st.styles,

					sp.render_type,
					sp.popup_button_text,
					sp.static_button_position,
					sp.static_button_offset,
					sp.appear_animation_type,
					sp.check_token,
					sp.next_button_text,
					sp.prev_button_text

					
  FROM
					`bm_creative_forms` sp
					
  LEFT JOIN `bm_contact_templates` st 
  ON st.id = sp.id_template
					
  WHERE sp.published = '1'
					
  AND sp.id = '18'

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT sp.`id_template`, sp.name, sp.top_text, sp.pre_te' at line 1 SQL=EXPLAIN EXTENDED SELECT sp.`id_template`, sp.name, sp.top_text, sp.pre_text, sp.thank_you_text, sp.send_text, sp.send_new_text, sp.close_alert_text, sp.form_width, sp.redirect, sp.redirect_itemid, sp.redirect_url, sp.redirect_delay, sp.shake_count, sp.shake_distanse, sp.send_copy_enable, sp.send_copy_text, sp.shake_duration, sp.custom_css, st.styles, sp.render_type, sp.popup_button_text, sp.static_button_position, sp.static_button_offset, sp.appear_animation_type, sp.check_token, sp.next_button_text, sp.prev_button_text FROM `#__creative_forms` sp LEFT JOIN `#__contact_templates` st ON st.id = sp.id_template WHERE sp.published = '1' AND sp.id = '18'

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
18	JDatabaseDriver->loadAssoc()	JROOT/components/com_creativecontactform/helpers/helper.php:283
17	CreativecontactformHelper->get_data()	JROOT/components/com_creativecontactform/helpers/helper.php:439
16	CreativecontactformHelper->print_fields_array_html()	JROOT/components/com_creativecontactform/helpers/helper.php:928
15	CreativecontactformHelper->print_fields_columns()	JROOT/components/com_creativecontactform/helpers/helper.php:1195
14	CreativecontactformHelper->render_html()	JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php:23
13	include JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_creativecontactform/views/creativecontactform/view.html.php:21
10	CreativeContactFormViewCreativecontactform->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_creativecontactform/controller.php:34
8	CreativeContactFormController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_creativecontactform/creativecontactform.php:32
6	require_once JROOT/components/com_creativecontactform/creativecontactform.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.91 ms After last query: 0.06 ms Query memory: 0.119 MB Memory before query: 2.652 MB Rows returned: 17

Duplicate queries: #13 #16 #19 #22 #25 #29 #35 #38 #41

SELECT
					sp.id,
					sp.name,
					sp.tooltip_text,
					sp.required,
					sp.ordering_field,
					sp.select_default_text,
					sp.show_parent_label,
					sp.select_no_match_text,
					sp.width,
					sp.field_margin_top,
					sp.select_show_scroll_after,
					sp.select_show_search_after,
					sp.upload_button_text,
					sp.upload_minfilesize,
					sp.upload_maxfilesize,
					sp.upload_acceptfiletypes,
					sp.upload_minfilesize_message,
					sp.upload_maxfilesize_message,
					sp.upload_acceptfiletypes_message,
					sp.captcha_wrong_message,

					sp.datepicker_date_format,
					sp.datepicker_animation,
					sp.datepicker_style,
					sp.datepicker_icon_style,
					sp.datepicker_show_icon,
					sp.datepicker_input_readonly,
					sp.datepicker_number_months,
					sp.datepicker_mindate,
					sp.datepicker_maxdate,
					sp.datepicker_changemonths,
					sp.datepicker_changeyears,
					sp.column_type,
					sp.custom_html,
					sp.google_maps,
					sp.heading,
					sp.recaptcha_site_key,
					sp.recaptcha_wrong_message,
					sp.recaptcha_theme,
					sp.recaptcha_type,
					sp.contact_data,
					sp.contact_data_width,
					sp.creative_popup,
					sp.creative_popup_embed,

					sp.m_recipients_value,
					sp.m_recipients_multiple,
					sp.pagebreak_type,
					sp.pagebreak_page_title,
					sp.if_id,
					sp.if_val,
					sp.then_id,
					sp.hidden_val,

					st.name as type
				
  FROM
					`bm_creative_fields` sp
				JOIN `bm_creative_field_types` st 
  ON st.id = sp.id_type
				
  WHERE sp.published = '1'
				
  AND sp.id_form = '18'
				
  ORDER BY sp.ordering,sp.id

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT sp.id, sp.name, sp.tooltip_text, sp.required, ' at line 1 SQL=EXPLAIN EXTENDED SELECT sp.id, sp.name, sp.tooltip_text, sp.required, sp.ordering_field, sp.select_default_text, sp.show_parent_label, sp.select_no_match_text, sp.width, sp.field_margin_top, sp.select_show_scroll_after, sp.select_show_search_after, sp.upload_button_text, sp.upload_minfilesize, sp.upload_maxfilesize, sp.upload_acceptfiletypes, sp.upload_minfilesize_message, sp.upload_maxfilesize_message, sp.upload_acceptfiletypes_message, sp.captcha_wrong_message, sp.datepicker_date_format, sp.datepicker_animation, sp.datepicker_style, sp.datepicker_icon_style, sp.datepicker_show_icon, sp.datepicker_input_readonly, sp.datepicker_number_months, sp.datepicker_mindate, sp.datepicker_maxdate, sp.datepicker_changemonths, sp.datepicker_changeyears, sp.column_type, sp.custom_html, sp.google_maps, sp.heading, sp.recaptcha_site_key, sp.recaptcha_wrong_message, sp.recaptcha_theme, sp.recaptcha_type, sp.contact_data, sp.contact_data_width, sp.creative_popup, sp.creative_popup_embed, sp.m_recipients_value, sp.m_recipients_multiple, sp.pagebreak_type, sp.pagebreak_page_title, sp.if_id, sp.if_val, sp.then_id, sp.hidden_val, st.name as type FROM `#__creative_fields` sp JOIN `#__creative_field_types` st ON st.id = sp.id_type WHERE sp.published = '1' AND sp.id_form = '18' ORDER BY sp.ordering,sp.id

Profile

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.03 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.56 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
18	JDatabaseDriver->loadAssocList()	JROOT/components/com_creativecontactform/helpers/helper.php:353
17	CreativecontactformHelper->get_data()	JROOT/components/com_creativecontactform/helpers/helper.php:439
16	CreativecontactformHelper->print_fields_array_html()	JROOT/components/com_creativecontactform/helpers/helper.php:928
15	CreativecontactformHelper->print_fields_columns()	JROOT/components/com_creativecontactform/helpers/helper.php:1195
14	CreativecontactformHelper->render_html()	JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php:23
13	include JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_creativecontactform/views/creativecontactform/view.html.php:21
10	CreativeContactFormViewCreativecontactform->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_creativecontactform/controller.php:34
8	CreativeContactFormController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_creativecontactform/creativecontactform.php:32
6	require_once JROOT/components/com_creativecontactform/creativecontactform.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.42 ms After last query: 0.42 ms Query memory: 0.027 MB Memory before query: 2.658 MB Rows returned: 17

Duplicate queries: #11 #14 #17 #20 #23 #27 #30 #36 #39

SELECT
					sp.id,
					st.name as type
					
  FROM
					`bm_creative_fields` sp
					JOIN `bm_creative_field_types` st 
  ON st.id = sp.id_type
					
  WHERE sp.published = '1'
					
  AND sp.id_form = '18'
					
  ORDER BY sp.ordering,sp.id

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT sp.id, st.name as type FROM `#__creative_fields` ' at line 1 SQL=EXPLAIN EXTENDED SELECT sp.id, st.name as type FROM `#__creative_fields` sp JOIN `#__creative_field_types` st ON st.id = sp.id_type WHERE sp.published = '1' AND sp.id_form = '18' ORDER BY sp.ordering,sp.id

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.18 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
18	JDatabaseDriver->loadAssocList()	JROOT/components/com_creativecontactform/helpers/helper.php:229
17	CreativecontactformHelper->get_data()	JROOT/components/com_creativecontactform/helpers/helper.php:439
16	CreativecontactformHelper->print_fields_array_html()	JROOT/components/com_creativecontactform/helpers/helper.php:911
15	CreativecontactformHelper->print_fields_columns()	JROOT/components/com_creativecontactform/helpers/helper.php:1195
14	CreativecontactformHelper->render_html()	JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php:23
13	include JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_creativecontactform/views/creativecontactform/view.html.php:21
10	CreativeContactFormViewCreativecontactform->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_creativecontactform/controller.php:34
8	CreativeContactFormController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_creativecontactform/creativecontactform.php:32
6	require_once JROOT/components/com_creativecontactform/creativecontactform.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.26 ms After last query: 0.08 ms Query memory: 0.025 MB Memory before query: 2.678 MB Rows returned: 1

Duplicate queries: #12 #15 #18 #21 #24 #28 #31 #37 #40

SELECT
					sp.`id_template`,
					sp.name,
					sp.top_text,
					sp.pre_text,
					sp.thank_you_text,
					sp.send_text,
					sp.send_new_text,
					sp.close_alert_text,
					sp.form_width,
					sp.redirect,
					sp.redirect_itemid,
					sp.redirect_url,
					sp.redirect_delay,
					sp.shake_count,
					sp.shake_distanse,
					sp.send_copy_enable,
					sp.send_copy_text,
					sp.shake_duration,
					sp.custom_css,
					st.styles,

					sp.render_type,
					sp.popup_button_text,
					sp.static_button_position,
					sp.static_button_offset,
					sp.appear_animation_type,
					sp.check_token,
					sp.next_button_text,
					sp.prev_button_text

					
  FROM
					`bm_creative_forms` sp
					
  LEFT JOIN `bm_contact_templates` st 
  ON st.id = sp.id_template
					
  WHERE sp.published = '1'
					
  AND sp.id = '18'

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT sp.`id_template`, sp.name, sp.top_text, sp.pre_te' at line 1 SQL=EXPLAIN EXTENDED SELECT sp.`id_template`, sp.name, sp.top_text, sp.pre_text, sp.thank_you_text, sp.send_text, sp.send_new_text, sp.close_alert_text, sp.form_width, sp.redirect, sp.redirect_itemid, sp.redirect_url, sp.redirect_delay, sp.shake_count, sp.shake_distanse, sp.send_copy_enable, sp.send_copy_text, sp.shake_duration, sp.custom_css, st.styles, sp.render_type, sp.popup_button_text, sp.static_button_position, sp.static_button_offset, sp.appear_animation_type, sp.check_token, sp.next_button_text, sp.prev_button_text FROM `#__creative_forms` sp LEFT JOIN `#__contact_templates` st ON st.id = sp.id_template WHERE sp.published = '1' AND sp.id = '18'

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
18	JDatabaseDriver->loadAssoc()	JROOT/components/com_creativecontactform/helpers/helper.php:283
17	CreativecontactformHelper->get_data()	JROOT/components/com_creativecontactform/helpers/helper.php:439
16	CreativecontactformHelper->print_fields_array_html()	JROOT/components/com_creativecontactform/helpers/helper.php:911
15	CreativecontactformHelper->print_fields_columns()	JROOT/components/com_creativecontactform/helpers/helper.php:1195
14	CreativecontactformHelper->render_html()	JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php:23
13	include JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_creativecontactform/views/creativecontactform/view.html.php:21
10	CreativeContactFormViewCreativecontactform->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_creativecontactform/controller.php:34
8	CreativeContactFormController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_creativecontactform/creativecontactform.php:32
6	require_once JROOT/components/com_creativecontactform/creativecontactform.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.96 ms After last query: 0.15 ms Query memory: 0.119 MB Memory before query: 2.690 MB Rows returned: 17

Duplicate queries: #13 #16 #19 #22 #25 #29 #32 #38 #41

SELECT
					sp.id,
					sp.name,
					sp.tooltip_text,
					sp.required,
					sp.ordering_field,
					sp.select_default_text,
					sp.show_parent_label,
					sp.select_no_match_text,
					sp.width,
					sp.field_margin_top,
					sp.select_show_scroll_after,
					sp.select_show_search_after,
					sp.upload_button_text,
					sp.upload_minfilesize,
					sp.upload_maxfilesize,
					sp.upload_acceptfiletypes,
					sp.upload_minfilesize_message,
					sp.upload_maxfilesize_message,
					sp.upload_acceptfiletypes_message,
					sp.captcha_wrong_message,

					sp.datepicker_date_format,
					sp.datepicker_animation,
					sp.datepicker_style,
					sp.datepicker_icon_style,
					sp.datepicker_show_icon,
					sp.datepicker_input_readonly,
					sp.datepicker_number_months,
					sp.datepicker_mindate,
					sp.datepicker_maxdate,
					sp.datepicker_changemonths,
					sp.datepicker_changeyears,
					sp.column_type,
					sp.custom_html,
					sp.google_maps,
					sp.heading,
					sp.recaptcha_site_key,
					sp.recaptcha_wrong_message,
					sp.recaptcha_theme,
					sp.recaptcha_type,
					sp.contact_data,
					sp.contact_data_width,
					sp.creative_popup,
					sp.creative_popup_embed,

					sp.m_recipients_value,
					sp.m_recipients_multiple,
					sp.pagebreak_type,
					sp.pagebreak_page_title,
					sp.if_id,
					sp.if_val,
					sp.then_id,
					sp.hidden_val,

					st.name as type
				
  FROM
					`bm_creative_fields` sp
				JOIN `bm_creative_field_types` st 
  ON st.id = sp.id_type
				
  WHERE sp.published = '1'
				
  AND sp.id_form = '18'
				
  ORDER BY sp.ordering,sp.id

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT sp.id, sp.name, sp.tooltip_text, sp.required, ' at line 1 SQL=EXPLAIN EXTENDED SELECT sp.id, sp.name, sp.tooltip_text, sp.required, sp.ordering_field, sp.select_default_text, sp.show_parent_label, sp.select_no_match_text, sp.width, sp.field_margin_top, sp.select_show_scroll_after, sp.select_show_search_after, sp.upload_button_text, sp.upload_minfilesize, sp.upload_maxfilesize, sp.upload_acceptfiletypes, sp.upload_minfilesize_message, sp.upload_maxfilesize_message, sp.upload_acceptfiletypes_message, sp.captcha_wrong_message, sp.datepicker_date_format, sp.datepicker_animation, sp.datepicker_style, sp.datepicker_icon_style, sp.datepicker_show_icon, sp.datepicker_input_readonly, sp.datepicker_number_months, sp.datepicker_mindate, sp.datepicker_maxdate, sp.datepicker_changemonths, sp.datepicker_changeyears, sp.column_type, sp.custom_html, sp.google_maps, sp.heading, sp.recaptcha_site_key, sp.recaptcha_wrong_message, sp.recaptcha_theme, sp.recaptcha_type, sp.contact_data, sp.contact_data_width, sp.creative_popup, sp.creative_popup_embed, sp.m_recipients_value, sp.m_recipients_multiple, sp.pagebreak_type, sp.pagebreak_page_title, sp.if_id, sp.if_val, sp.then_id, sp.hidden_val, st.name as type FROM `#__creative_fields` sp JOIN `#__creative_field_types` st ON st.id = sp.id_type WHERE sp.published = '1' AND sp.id_form = '18' ORDER BY sp.ordering,sp.id

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
18	JDatabaseDriver->loadAssocList()	JROOT/components/com_creativecontactform/helpers/helper.php:353
17	CreativecontactformHelper->get_data()	JROOT/components/com_creativecontactform/helpers/helper.php:439
16	CreativecontactformHelper->print_fields_array_html()	JROOT/components/com_creativecontactform/helpers/helper.php:911
15	CreativecontactformHelper->print_fields_columns()	JROOT/components/com_creativecontactform/helpers/helper.php:1195
14	CreativecontactformHelper->render_html()	JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php:23
13	include JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_creativecontactform/views/creativecontactform/view.html.php:21
10	CreativeContactFormViewCreativecontactform->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_creativecontactform/controller.php:34
8	CreativeContactFormController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_creativecontactform/creativecontactform.php:32
6	require_once JROOT/components/com_creativecontactform/creativecontactform.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.40 ms After last query: 0.32 ms Query memory: 0.026 MB Memory before query: 2.705 MB Rows returned: 17

Duplicate queries: #11 #14 #17 #20 #23 #27 #30 #33 #39

SELECT
					sp.id,
					st.name as type
					
  FROM
					`bm_creative_fields` sp
					JOIN `bm_creative_field_types` st 
  ON st.id = sp.id_type
					
  WHERE sp.published = '1'
					
  AND sp.id_form = '18'
					
  ORDER BY sp.ordering,sp.id

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT sp.id, st.name as type FROM `#__creative_fields` ' at line 1 SQL=EXPLAIN EXTENDED SELECT sp.id, st.name as type FROM `#__creative_fields` sp JOIN `#__creative_field_types` st ON st.id = sp.id_type WHERE sp.published = '1' AND sp.id_form = '18' ORDER BY sp.ordering,sp.id

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.16 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
18	JDatabaseDriver->loadAssocList()	JROOT/components/com_creativecontactform/helpers/helper.php:229
17	CreativecontactformHelper->get_data()	JROOT/components/com_creativecontactform/helpers/helper.php:439
16	CreativecontactformHelper->print_fields_array_html()	JROOT/components/com_creativecontactform/helpers/helper.php:919
15	CreativecontactformHelper->print_fields_columns()	JROOT/components/com_creativecontactform/helpers/helper.php:1195
14	CreativecontactformHelper->render_html()	JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php:23
13	include JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_creativecontactform/views/creativecontactform/view.html.php:21
10	CreativeContactFormViewCreativecontactform->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_creativecontactform/controller.php:34
8	CreativeContactFormController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_creativecontactform/creativecontactform.php:32
6	require_once JROOT/components/com_creativecontactform/creativecontactform.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

Duplicate queries: #12 #15 #18 #21 #24 #28 #31 #34 #40

SELECT
					sp.`id_template`,
					sp.name,
					sp.top_text,
					sp.pre_text,
					sp.thank_you_text,
					sp.send_text,
					sp.send_new_text,
					sp.close_alert_text,
					sp.form_width,
					sp.redirect,
					sp.redirect_itemid,
					sp.redirect_url,
					sp.redirect_delay,
					sp.shake_count,
					sp.shake_distanse,
					sp.send_copy_enable,
					sp.send_copy_text,
					sp.shake_duration,
					sp.custom_css,
					st.styles,

					sp.render_type,
					sp.popup_button_text,
					sp.static_button_position,
					sp.static_button_offset,
					sp.appear_animation_type,
					sp.check_token,
					sp.next_button_text,
					sp.prev_button_text

					
  FROM
					`bm_creative_forms` sp
					
  LEFT JOIN `bm_contact_templates` st 
  ON st.id = sp.id_template
					
  WHERE sp.published = '1'
					
  AND sp.id = '18'

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT sp.`id_template`, sp.name, sp.top_text, sp.pre_te' at line 1 SQL=EXPLAIN EXTENDED SELECT sp.`id_template`, sp.name, sp.top_text, sp.pre_text, sp.thank_you_text, sp.send_text, sp.send_new_text, sp.close_alert_text, sp.form_width, sp.redirect, sp.redirect_itemid, sp.redirect_url, sp.redirect_delay, sp.shake_count, sp.shake_distanse, sp.send_copy_enable, sp.send_copy_text, sp.shake_duration, sp.custom_css, st.styles, sp.render_type, sp.popup_button_text, sp.static_button_position, sp.static_button_offset, sp.appear_animation_type, sp.check_token, sp.next_button_text, sp.prev_button_text FROM `#__creative_forms` sp LEFT JOIN `#__contact_templates` st ON st.id = sp.id_template WHERE sp.published = '1' AND sp.id = '18'

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
18	JDatabaseDriver->loadAssoc()	JROOT/components/com_creativecontactform/helpers/helper.php:283
17	CreativecontactformHelper->get_data()	JROOT/components/com_creativecontactform/helpers/helper.php:439
16	CreativecontactformHelper->print_fields_array_html()	JROOT/components/com_creativecontactform/helpers/helper.php:919
15	CreativecontactformHelper->print_fields_columns()	JROOT/components/com_creativecontactform/helpers/helper.php:1195
14	CreativecontactformHelper->render_html()	JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php:23
13	include JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_creativecontactform/views/creativecontactform/view.html.php:21
10	CreativeContactFormViewCreativecontactform->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_creativecontactform/controller.php:34
8	CreativeContactFormController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_creativecontactform/creativecontactform.php:32
6	require_once JROOT/components/com_creativecontactform/creativecontactform.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.96 ms After last query: 0.07 ms Query memory: 0.119 MB Memory before query: 2.736 MB Rows returned: 17

Duplicate queries: #13 #16 #19 #22 #25 #29 #32 #35 #41

SELECT
					sp.id,
					sp.name,
					sp.tooltip_text,
					sp.required,
					sp.ordering_field,
					sp.select_default_text,
					sp.show_parent_label,
					sp.select_no_match_text,
					sp.width,
					sp.field_margin_top,
					sp.select_show_scroll_after,
					sp.select_show_search_after,
					sp.upload_button_text,
					sp.upload_minfilesize,
					sp.upload_maxfilesize,
					sp.upload_acceptfiletypes,
					sp.upload_minfilesize_message,
					sp.upload_maxfilesize_message,
					sp.upload_acceptfiletypes_message,
					sp.captcha_wrong_message,

					sp.datepicker_date_format,
					sp.datepicker_animation,
					sp.datepicker_style,
					sp.datepicker_icon_style,
					sp.datepicker_show_icon,
					sp.datepicker_input_readonly,
					sp.datepicker_number_months,
					sp.datepicker_mindate,
					sp.datepicker_maxdate,
					sp.datepicker_changemonths,
					sp.datepicker_changeyears,
					sp.column_type,
					sp.custom_html,
					sp.google_maps,
					sp.heading,
					sp.recaptcha_site_key,
					sp.recaptcha_wrong_message,
					sp.recaptcha_theme,
					sp.recaptcha_type,
					sp.contact_data,
					sp.contact_data_width,
					sp.creative_popup,
					sp.creative_popup_embed,

					sp.m_recipients_value,
					sp.m_recipients_multiple,
					sp.pagebreak_type,
					sp.pagebreak_page_title,
					sp.if_id,
					sp.if_val,
					sp.then_id,
					sp.hidden_val,

					st.name as type
				
  FROM
					`bm_creative_fields` sp
				JOIN `bm_creative_field_types` st 
  ON st.id = sp.id_type
				
  WHERE sp.published = '1'
				
  AND sp.id_form = '18'
				
  ORDER BY sp.ordering,sp.id

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT sp.id, sp.name, sp.tooltip_text, sp.required, ' at line 1 SQL=EXPLAIN EXTENDED SELECT sp.id, sp.name, sp.tooltip_text, sp.required, sp.ordering_field, sp.select_default_text, sp.show_parent_label, sp.select_no_match_text, sp.width, sp.field_margin_top, sp.select_show_scroll_after, sp.select_show_search_after, sp.upload_button_text, sp.upload_minfilesize, sp.upload_maxfilesize, sp.upload_acceptfiletypes, sp.upload_minfilesize_message, sp.upload_maxfilesize_message, sp.upload_acceptfiletypes_message, sp.captcha_wrong_message, sp.datepicker_date_format, sp.datepicker_animation, sp.datepicker_style, sp.datepicker_icon_style, sp.datepicker_show_icon, sp.datepicker_input_readonly, sp.datepicker_number_months, sp.datepicker_mindate, sp.datepicker_maxdate, sp.datepicker_changemonths, sp.datepicker_changeyears, sp.column_type, sp.custom_html, sp.google_maps, sp.heading, sp.recaptcha_site_key, sp.recaptcha_wrong_message, sp.recaptcha_theme, sp.recaptcha_type, sp.contact_data, sp.contact_data_width, sp.creative_popup, sp.creative_popup_embed, sp.m_recipients_value, sp.m_recipients_multiple, sp.pagebreak_type, sp.pagebreak_page_title, sp.if_id, sp.if_val, sp.then_id, sp.hidden_val, st.name as type FROM `#__creative_fields` sp JOIN `#__creative_field_types` st ON st.id = sp.id_type WHERE sp.published = '1' AND sp.id_form = '18' ORDER BY sp.ordering,sp.id

Profile

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.59 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
18	JDatabaseDriver->loadAssocList()	JROOT/components/com_creativecontactform/helpers/helper.php:353
17	CreativecontactformHelper->get_data()	JROOT/components/com_creativecontactform/helpers/helper.php:439
16	CreativecontactformHelper->print_fields_array_html()	JROOT/components/com_creativecontactform/helpers/helper.php:919
15	CreativecontactformHelper->print_fields_columns()	JROOT/components/com_creativecontactform/helpers/helper.php:1195
14	CreativecontactformHelper->render_html()	JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php:23
13	include JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_creativecontactform/views/creativecontactform/view.html.php:21
10	CreativeContactFormViewCreativecontactform->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_creativecontactform/controller.php:34
8	CreativeContactFormController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_creativecontactform/creativecontactform.php:32
6	require_once JROOT/components/com_creativecontactform/creativecontactform.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.37 ms After last query: 0.32 ms Query memory: 0.026 MB Memory before query: 2.735 MB Rows returned: 17

Duplicate queries: #11 #14 #17 #20 #23 #27 #30 #33 #36

SELECT
					sp.id,
					st.name as type
					
  FROM
					`bm_creative_fields` sp
					JOIN `bm_creative_field_types` st 
  ON st.id = sp.id_type
					
  WHERE sp.published = '1'
					
  AND sp.id_form = '18'
					
  ORDER BY sp.ordering,sp.id

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT sp.id, st.name as type FROM `#__creative_fields` ' at line 1 SQL=EXPLAIN EXTENDED SELECT sp.id, st.name as type FROM `#__creative_fields` sp JOIN `#__creative_field_types` st ON st.id = sp.id_type WHERE sp.published = '1' AND sp.id_form = '18' ORDER BY sp.ordering,sp.id

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.16 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
18	JDatabaseDriver->loadAssocList()	JROOT/components/com_creativecontactform/helpers/helper.php:229
17	CreativecontactformHelper->get_data()	JROOT/components/com_creativecontactform/helpers/helper.php:439
16	CreativecontactformHelper->print_fields_array_html()	JROOT/components/com_creativecontactform/helpers/helper.php:928
15	CreativecontactformHelper->print_fields_columns()	JROOT/components/com_creativecontactform/helpers/helper.php:1195
14	CreativecontactformHelper->render_html()	JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php:23
13	include JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_creativecontactform/views/creativecontactform/view.html.php:21
10	CreativeContactFormViewCreativecontactform->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_creativecontactform/controller.php:34
8	CreativeContactFormController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_creativecontactform/creativecontactform.php:32
6	require_once JROOT/components/com_creativecontactform/creativecontactform.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.30 ms After last query: 0.08 ms Query memory: 0.025 MB Memory before query: 2.754 MB Rows returned: 1

Duplicate queries: #12 #15 #18 #21 #24 #28 #31 #34 #37

SELECT
					sp.`id_template`,
					sp.name,
					sp.top_text,
					sp.pre_text,
					sp.thank_you_text,
					sp.send_text,
					sp.send_new_text,
					sp.close_alert_text,
					sp.form_width,
					sp.redirect,
					sp.redirect_itemid,
					sp.redirect_url,
					sp.redirect_delay,
					sp.shake_count,
					sp.shake_distanse,
					sp.send_copy_enable,
					sp.send_copy_text,
					sp.shake_duration,
					sp.custom_css,
					st.styles,

					sp.render_type,
					sp.popup_button_text,
					sp.static_button_position,
					sp.static_button_offset,
					sp.appear_animation_type,
					sp.check_token,
					sp.next_button_text,
					sp.prev_button_text

					
  FROM
					`bm_creative_forms` sp
					
  LEFT JOIN `bm_contact_templates` st 
  ON st.id = sp.id_template
					
  WHERE sp.published = '1'
					
  AND sp.id = '18'

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT sp.`id_template`, sp.name, sp.top_text, sp.pre_te' at line 1 SQL=EXPLAIN EXTENDED SELECT sp.`id_template`, sp.name, sp.top_text, sp.pre_text, sp.thank_you_text, sp.send_text, sp.send_new_text, sp.close_alert_text, sp.form_width, sp.redirect, sp.redirect_itemid, sp.redirect_url, sp.redirect_delay, sp.shake_count, sp.shake_distanse, sp.send_copy_enable, sp.send_copy_text, sp.shake_duration, sp.custom_css, st.styles, sp.render_type, sp.popup_button_text, sp.static_button_position, sp.static_button_offset, sp.appear_animation_type, sp.check_token, sp.next_button_text, sp.prev_button_text FROM `#__creative_forms` sp LEFT JOIN `#__contact_templates` st ON st.id = sp.id_template WHERE sp.published = '1' AND sp.id = '18'

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
18	JDatabaseDriver->loadAssoc()	JROOT/components/com_creativecontactform/helpers/helper.php:283
17	CreativecontactformHelper->get_data()	JROOT/components/com_creativecontactform/helpers/helper.php:439
16	CreativecontactformHelper->print_fields_array_html()	JROOT/components/com_creativecontactform/helpers/helper.php:928
15	CreativecontactformHelper->print_fields_columns()	JROOT/components/com_creativecontactform/helpers/helper.php:1195
14	CreativecontactformHelper->render_html()	JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php:23
13	include JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_creativecontactform/views/creativecontactform/view.html.php:21
10	CreativeContactFormViewCreativecontactform->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_creativecontactform/controller.php:34
8	CreativeContactFormController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_creativecontactform/creativecontactform.php:32
6	require_once JROOT/components/com_creativecontactform/creativecontactform.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.90 ms After last query: 0.08 ms Query memory: 0.119 MB Memory before query: 2.766 MB Rows returned: 17

Duplicate queries: #13 #16 #19 #22 #25 #29 #32 #35 #38

SELECT
					sp.id,
					sp.name,
					sp.tooltip_text,
					sp.required,
					sp.ordering_field,
					sp.select_default_text,
					sp.show_parent_label,
					sp.select_no_match_text,
					sp.width,
					sp.field_margin_top,
					sp.select_show_scroll_after,
					sp.select_show_search_after,
					sp.upload_button_text,
					sp.upload_minfilesize,
					sp.upload_maxfilesize,
					sp.upload_acceptfiletypes,
					sp.upload_minfilesize_message,
					sp.upload_maxfilesize_message,
					sp.upload_acceptfiletypes_message,
					sp.captcha_wrong_message,

					sp.datepicker_date_format,
					sp.datepicker_animation,
					sp.datepicker_style,
					sp.datepicker_icon_style,
					sp.datepicker_show_icon,
					sp.datepicker_input_readonly,
					sp.datepicker_number_months,
					sp.datepicker_mindate,
					sp.datepicker_maxdate,
					sp.datepicker_changemonths,
					sp.datepicker_changeyears,
					sp.column_type,
					sp.custom_html,
					sp.google_maps,
					sp.heading,
					sp.recaptcha_site_key,
					sp.recaptcha_wrong_message,
					sp.recaptcha_theme,
					sp.recaptcha_type,
					sp.contact_data,
					sp.contact_data_width,
					sp.creative_popup,
					sp.creative_popup_embed,

					sp.m_recipients_value,
					sp.m_recipients_multiple,
					sp.pagebreak_type,
					sp.pagebreak_page_title,
					sp.if_id,
					sp.if_val,
					sp.then_id,
					sp.hidden_val,

					st.name as type
				
  FROM
					`bm_creative_fields` sp
				JOIN `bm_creative_field_types` st 
  ON st.id = sp.id_type
				
  WHERE sp.published = '1'
				
  AND sp.id_form = '18'
				
  ORDER BY sp.ordering,sp.id

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT sp.id, sp.name, sp.tooltip_text, sp.required, ' at line 1 SQL=EXPLAIN EXTENDED SELECT sp.id, sp.name, sp.tooltip_text, sp.required, sp.ordering_field, sp.select_default_text, sp.show_parent_label, sp.select_no_match_text, sp.width, sp.field_margin_top, sp.select_show_scroll_after, sp.select_show_search_after, sp.upload_button_text, sp.upload_minfilesize, sp.upload_maxfilesize, sp.upload_acceptfiletypes, sp.upload_minfilesize_message, sp.upload_maxfilesize_message, sp.upload_acceptfiletypes_message, sp.captcha_wrong_message, sp.datepicker_date_format, sp.datepicker_animation, sp.datepicker_style, sp.datepicker_icon_style, sp.datepicker_show_icon, sp.datepicker_input_readonly, sp.datepicker_number_months, sp.datepicker_mindate, sp.datepicker_maxdate, sp.datepicker_changemonths, sp.datepicker_changeyears, sp.column_type, sp.custom_html, sp.google_maps, sp.heading, sp.recaptcha_site_key, sp.recaptcha_wrong_message, sp.recaptcha_theme, sp.recaptcha_type, sp.contact_data, sp.contact_data_width, sp.creative_popup, sp.creative_popup_embed, sp.m_recipients_value, sp.m_recipients_multiple, sp.pagebreak_type, sp.pagebreak_page_title, sp.if_id, sp.if_val, sp.then_id, sp.hidden_val, st.name as type FROM `#__creative_fields` sp JOIN `#__creative_field_types` st ON st.id = sp.id_type WHERE sp.published = '1' AND sp.id_form = '18' ORDER BY sp.ordering,sp.id

Profile

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.57 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
18	JDatabaseDriver->loadAssocList()	JROOT/components/com_creativecontactform/helpers/helper.php:353
17	CreativecontactformHelper->get_data()	JROOT/components/com_creativecontactform/helpers/helper.php:439
16	CreativecontactformHelper->print_fields_array_html()	JROOT/components/com_creativecontactform/helpers/helper.php:928
15	CreativecontactformHelper->print_fields_columns()	JROOT/components/com_creativecontactform/helpers/helper.php:1195
14	CreativecontactformHelper->render_html()	JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php:23
13	include JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_creativecontactform/views/creativecontactform/view.html.php:21
10	CreativeContactFormViewCreativecontactform->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_creativecontactform/controller.php:34
8	CreativeContactFormController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_creativecontactform/creativecontactform.php:32
6	require_once JROOT/components/com_creativecontactform/creativecontactform.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 8.58 ms After last query: 0.28 ms Query memory: 0.025 MB Memory before query: 2.766 MB Rows returned: 1

SELECT
 							spo.name,
 							spo.id,
 							spo.value,
 							spo.selected
							
  FROM
								`bm_creative_form_options` spo
							
  WHERE spo.id_parent = '160'
							
  AND spo.showrow = '1'
							
  ORDER BY spo.ordering

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT spo.name, spo.id, spo.value, spo.sele' at line 1 SQL=EXPLAIN EXTENDED SELECT spo.name, spo.id, spo.value, spo.selected FROM `#__creative_form_options` spo WHERE spo.id_parent = '160' AND spo.showrow = '1' ORDER BY spo.ordering

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	8.39 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
17	JDatabaseDriver->loadAssocList()	JROOT/components/com_creativecontactform/helpers/helper.php:584
16	CreativecontactformHelper->print_fields_array_html()	JROOT/components/com_creativecontactform/helpers/helper.php:928
15	CreativecontactformHelper->print_fields_columns()	JROOT/components/com_creativecontactform/helpers/helper.php:1195
14	CreativecontactformHelper->render_html()	JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php:23
13	include JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_creativecontactform/views/creativecontactform/view.html.php:21
10	CreativeContactFormViewCreativecontactform->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_creativecontactform/controller.php:34
8	CreativeContactFormController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_creativecontactform/creativecontactform.php:32
6	require_once JROOT/components/com_creativecontactform/creativecontactform.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.94 ms After last query: 0.61 ms Query memory: 0.023 MB Memory before query: 2.706 MB Rows returned: 8

SHOW FULL COLUMNS 
  FROM `bm_template_styles`

Explain

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

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.37 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.02 ms
Creating tmp table	0.03 ms
executing	0.05 ms
checking permissions	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
12	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
11	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
10	JTable->__construct()	JROOT/administrator/components/com_templates/tables/style.php:30
9	TemplatesTableStyle->__construct()	JROOT/libraries/joomla/table/table.php:308
8	JTable::getInstance()	JROOT/plugins/system/helix/helix.php:83
7	plgSystemHelix->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.24 ms After last query: 0.25 ms Query memory: 0.060 MB Memory before query: 2.724 MB Rows returned: 1

SELECT *

  FROM bm_template_styles

  WHERE `id` = '141'

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM #__template_styles WHERE `id` = '141'' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM #__template_styles WHERE `id` = '141'

Profile

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.04 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
9	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
8	JTable->load()	JROOT/plugins/system/helix/helix.php:84
7	plgSystemHelix->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.69 ms After last query: 0.55 ms Query memory: 0.021 MB Memory before query: 2.849 MB Rows returned: 3

SELECT language,id

  FROM `bm_menu`

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

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT language,id FROM `#__menu` WHERE home = 1 AND published = 1 AND client_id' at line 1 SQL=EXPLAIN EXTENDED SELECT language,id FROM `#__menu` WHERE home = 1 AND published = 1 AND client_id = 0

Profile

Status	Duration
starting	0.14 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.36 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

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

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

Query Time: 3.47 ms After last query: 12.00 ms Query memory: 0.051 MB Memory before query: 2.868 MB Rows returned: 140

SHOW FULL COLUMNS 
  FROM `bm_jshopping_config`

Explain

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

Profile

Status	Duration
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 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.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 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.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 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.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.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.05 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 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.01 ms
checking permissions	0.17 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.10 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
30	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
29	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
28	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
27	JTable->__construct()	JROOT/components/com_jshopping/tables/config.php:14
26	jshopConfig->__construct()	JROOT/components/com_jshopping/lib/factory.php:24
25	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
24	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
23	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1595
22	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:14
21	jshoppingBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
20	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
19	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
18	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
17	JRouter->build()	JROOT/libraries/cms/router/site.php:147
16	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
15	JRoute::_()	JROOT/plugins/system/helix/core/classes/menu.php:194
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:30
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.50 ms After last query: 0.34 ms Query memory: 0.102 MB Memory before query: 3.070 MB Rows returned: 1

SELECT *

  FROM bm_jshopping_config

  WHERE `id` = '1'

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM #__jshopping_config WHERE `id` = '1'' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM #__jshopping_config WHERE `id` = '1'

Profile

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.06 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.03 ms
executing	0.09 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
27	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
26	JTable->load()	JROOT/components/com_jshopping/lib/factory.php:30
25	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
24	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
23	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1595
22	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:14
21	jshoppingBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
20	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
19	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
18	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
17	JRouter->build()	JROOT/libraries/cms/router/site.php:147
16	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
15	JRoute::_()	JROOT/plugins/system/helix/core/classes/menu.php:194
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:30
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.14 ms After last query: 0.27 ms Query memory: 0.033 MB Memory before query: 3.077 MB Rows returned: 8

SHOW FULL COLUMNS 
  FROM `bm_jshopping_currencies`

Explain

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

Profile

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.42 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.03 ms
Creating tmp table	0.04 ms
executing	0.06 ms
checking permissions	0.04 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.06 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
35	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
34	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
33	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
32	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
31	JTable->__construct()	JROOT/components/com_jshopping/tables/currency.php:14
30	jshopCurrency->__construct()	JROOT/libraries/joomla/table/table.php:308
29	JTable::getInstance()	JROOT/components/com_jshopping/lib/factory.php:621
28	JSFactory::getTable()	JROOT/components/com_jshopping/lib/factory.php:569
27	JSFactory::getAllCurrency()	JROOT/components/com_jshopping/tables/config.php:53
26	jshopConfig->loadCurrencyValue()	JROOT/components/com_jshopping/lib/factory.php:32
25	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
24	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
23	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1595
22	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:14
21	jshoppingBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
20	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
19	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
18	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
17	JRouter->build()	JROOT/libraries/cms/router/site.php:147
16	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
15	JRoute::_()	JROOT/plugins/system/helix/core/classes/menu.php:194
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:30
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.24 ms After last query: 0.05 ms Query memory: 0.029 MB Memory before query: 3.102 MB Rows returned: 1

SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value 
  FROM `bm_jshopping_currencies` 
  WHERE currency_publish = '1' 
  ORDER BY currency_ordering

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_va' at line 1 SQL=EXPLAIN EXTENDED SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value FROM `#__jshopping_currencies` WHERE currency_publish = '1' ORDER BY currency_ordering

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
29	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/currency.php:22
28	jshopCurrency->getAllCurrencies()	JROOT/components/com_jshopping/lib/factory.php:570
27	JSFactory::getAllCurrency()	JROOT/components/com_jshopping/tables/config.php:53
26	jshopConfig->loadCurrencyValue()	JROOT/components/com_jshopping/lib/factory.php:32
25	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
24	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
23	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1595
22	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:14
21	jshoppingBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
20	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
19	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
18	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
17	JRouter->build()	JROOT/libraries/cms/router/site.php:147
16	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
15	JRoute::_()	JROOT/plugins/system/helix/core/classes/menu.php:194
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:30
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 2.05 ms After last query: 0.08 ms Query memory: 0.044 MB Memory before query: 3.122 MB Rows returned: 58

Duplicate queries: #51

SHOW FULL COLUMNS 
  FROM `bm_jshopping_users`

Explain

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

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.37 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.05 ms
statistics	0.11 ms
preparing	0.03 ms
Creating tmp table	0.04 ms
executing	0.06 ms
checking permissions	0.05 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 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.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.04 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.10 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
35	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
34	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
33	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
32	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
31	JTable->__construct()	JROOT/components/com_jshopping/tables/usershopbase.php:14
30	jshopUserShopBase->__construct()	JROOT/components/com_jshopping/tables/usershop.php:15
29	jshopUserShop->__construct()	JROOT/components/com_jshopping/lib/factory.php:47
28	JSFactory::getUserShop()	JROOT/components/com_jshopping/tables/config.php:70
27	jshopConfig->getDisplayPriceFront()	JROOT/components/com_jshopping/tables/config.php:296
26	jshopConfig->parseConfigVars()	JROOT/components/com_jshopping/lib/factory.php:35
25	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
24	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
23	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1595
22	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:14
21	jshoppingBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
20	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
19	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
18	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
17	JRouter->build()	JROOT/libraries/cms/router/site.php:147
16	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
15	JRoute::_()	JROOT/plugins/system/helix/core/classes/menu.php:194
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:30
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.95 ms After last query: 0.21 ms Query memory: 0.044 MB Memory before query: 3.216 MB Rows returned: 58

Duplicate queries: #50

SHOW FULL COLUMNS 
  FROM `bm_jshopping_users`

Explain

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

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.42 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.03 ms
Creating tmp table	0.04 ms
executing	0.05 ms
checking permissions	0.05 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.05 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.05 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.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.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.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.01 ms
checking permissions	0.07 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
35	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
34	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
33	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
32	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
31	JTable->__construct()	JROOT/components/com_jshopping/tables/usershopbase.php:14
30	jshopUserShopBase->__construct()	JROOT/components/com_jshopping/models/userguest.php:16
29	jshopUserGust->__construct()	JROOT/components/com_jshopping/lib/factory.php:66
28	JSFactory::getUserShopGuest()	JROOT/components/com_jshopping/tables/config.php:74
27	jshopConfig->getDisplayPriceFront()	JROOT/components/com_jshopping/tables/config.php:296
26	jshopConfig->parseConfigVars()	JROOT/components/com_jshopping/lib/factory.php:35
25	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
24	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
23	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1595
22	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:14
21	jshoppingBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
20	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
19	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
18	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
17	JRouter->build()	JROOT/libraries/cms/router/site.php:147
16	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
15	JRoute::_()	JROOT/plugins/system/helix/core/classes/menu.php:194
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:30
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.83 ms After last query: 0.18 ms Query memory: 0.034 MB Memory before query: 3.299 MB Rows returned: 12

SHOW FULL COLUMNS 
  FROM `bm_jshopping_usergroups`

Explain

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

Profile

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.02 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.33 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
Creating tmp table	0.03 ms
executing	0.04 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.03 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.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.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
37	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
36	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
35	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
34	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
33	JTable->__construct()	JROOT/components/com_jshopping/tables/usergroup.php:14
32	jshopUserGroup->__construct()	JROOT/libraries/joomla/table/table.php:308
31	JTable::getInstance()	JROOT/components/com_jshopping/lib/factory.php:621
30	JSFactory::getTable()	JROOT/components/com_jshopping/models/userguest.php:30
29	jshopUserGust->load()	JROOT/components/com_jshopping/lib/factory.php:67
28	JSFactory::getUserShopGuest()	JROOT/components/com_jshopping/tables/config.php:74
27	jshopConfig->getDisplayPriceFront()	JROOT/components/com_jshopping/tables/config.php:296
26	jshopConfig->parseConfigVars()	JROOT/components/com_jshopping/lib/factory.php:35
25	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
24	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
23	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1595
22	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:14
21	jshoppingBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
20	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
19	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
18	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
17	JRouter->build()	JROOT/libraries/cms/router/site.php:147
16	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
15	JRoute::_()	JROOT/plugins/system/helix/core/classes/menu.php:194
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:30
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.73 ms After last query: 0.12 ms Query memory: 0.032 MB Memory before query: 3.331 MB Rows returned: 4

SHOW FULL COLUMNS 
  FROM `bm_jshopping_config_display_prices`

Explain

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

Profile

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.02 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.33 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
Creating tmp table	0.03 ms
executing	0.04 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
35	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
34	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
33	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
32	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
31	JTable->__construct()	JROOT/components/com_jshopping/tables/configdisplayprice.php:14
30	jshopConfigDisplayPrice->__construct()	JROOT/libraries/joomla/table/table.php:308
29	JTable::getInstance()	JROOT/components/com_jshopping/lib/factory.php:621
28	JSFactory::getTable()	JROOT/components/com_jshopping/tables/config.php:82
27	jshopConfig->getDisplayPriceFront()	JROOT/components/com_jshopping/tables/config.php:296
26	jshopConfig->parseConfigVars()	JROOT/components/com_jshopping/lib/factory.php:35
25	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
24	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
23	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1595
22	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:14
21	jshoppingBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
20	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
19	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
18	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
17	JRouter->build()	JROOT/libraries/cms/router/site.php:147
16	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
15	JRoute::_()	JROOT/plugins/system/helix/core/classes/menu.php:194
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:30
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.13 ms After last query: 0.03 ms Query memory: 0.029 MB Memory before query: 3.351 MB Rows returned: 1

SELECT * 
  FROM `bm_jshopping_config_display_prices`

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM `#__jshopping_config_display_prices`' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM `#__jshopping_config_display_prices`

Profile

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
29	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/configdisplayprice.php:33
28	jshopConfigDisplayPrice->getList()	JROOT/components/com_jshopping/tables/config.php:83
27	jshopConfig->getDisplayPriceFront()	JROOT/components/com_jshopping/tables/config.php:296
26	jshopConfig->parseConfigVars()	JROOT/components/com_jshopping/lib/factory.php:35
25	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
24	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
23	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1595
22	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:14
21	jshoppingBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
20	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
19	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
18	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
17	JRouter->build()	JROOT/libraries/cms/router/site.php:147
16	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
15	JRoute::_()	JROOT/plugins/system/helix/core/classes/menu.php:194
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:30
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.68 ms After last query: 0.06 ms Query memory: 0.028 MB Memory before query: 3.358 MB Rows returned: 17

select id,link 
  from bm_menu 
			          
  where `type`='component' 
  and published=1 
  and link like '%option=com_jshopping%' 
  and client_id=0 
					  
  and (language='*' or language='az-AZ') 
  and access IN (1,1,5)

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select id,link from #__menu where `type`='component' and publishe' at line 1 SQL=EXPLAIN EXTENDED select id,link from #__menu where `type`='component' and published=1 and link like '%option=com_jshopping%' and client_id=0 and (language='*' or language='az-AZ') and access IN (1,1,5)

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.47 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
25	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/shop_item_menu.php:141
24	shopItemMenu->getList()	JROOT/components/com_jshopping/lib/shop_item_menu.php:47
23	shopItemMenu->init()	JROOT/components/com_jshopping/lib/shop_item_menu.php:40
22	shopItemMenu::getInstance()	JROOT/components/com_jshopping/router.php:16
21	jshoppingBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
20	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
19	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
18	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
17	JRouter->build()	JROOT/libraries/cms/router/site.php:147
16	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
15	JRoute::_()	JROOT/plugins/system/helix/core/classes/menu.php:194
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:30
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.65 ms After last query: 1.61 ms Query memory: 0.027 MB Memory before query: 3.477 MB Rows returned: 18

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

  FROM bm_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-03-04 03:04:15') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-03-04 03:04:15') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 1185 OR mm.menuid <= 0) 
  AND m.language IN ('az-AZ','*')

  ORDER BY m.position, m.ordering

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm' at line 1 SQL=EXPLAIN EXTENDED SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM #__modules AS m LEFT JOIN #__modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN #__extensions AS e ON e.element = m.module AND e.client_id = m.client_id WHERE m.published = 1 AND e.enabled = 1 AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-03-04 03:04:15') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-03-04 03:04:15') AND m.access IN (1,1,5) AND m.client_id = 0 AND (mm.menuid = 1185 OR mm.menuid <= 0) AND m.language IN ('az-AZ','*') ORDER BY m.position, m.ordering

Profile

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.00 ms
starting	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.00 ms
System lock	0.00 ms
optimizing	0.04 ms
statistics	0.07 ms
preparing	0.03 ms
executing	0.29 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:413
15	JModuleHelper::getModuleList()	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:356
14	JModuleHelper::load()	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:84
13	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:501
12	JDocumentHtml->countModules()	JROOT/plugins/system/helix/core/helix.php:735
11	Helix::countModules()	JROOT/plugins/system/helix/core/helix.php:351
10	Helix::showRow()	JROOT/plugins/system/helix/core/helix.php:448
9	Helix::generatelayout()	JROOT/plugins/system/helix/core/helix.php:713
8	Helix::layout()	JROOT/templates/vina_veneno/index.php:54
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.28 ms After last query: 1.82 ms Query memory: 0.023 MB Memory before query: 3.571 MB Rows returned: 2

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

  FROM `bm_menu` AS `c`

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

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

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

  WHERE c.id = 1185

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `c2`.`language`,`c2`.`id` FROM `#__menu` AS `c` INNER JOIN `#__associatio' at line 1 SQL=EXPLAIN EXTENDED SELECT `c2`.`language`,`c2`.`id` FROM `#__menu` AS `c` INNER JOIN `#__associations` AS `a` ON a.id = c.`id` AND a.context='com_menus.item' INNER JOIN `#__associations` AS `a2` ON a.key = a2.key INNER JOIN `#__menu` AS `c2` ON a2.id = c2.`id` WHERE c.id = 1185

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	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.03 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

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

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

Query Time: 1.49 ms After last query: 0.98 ms Query memory: 0.151 MB Memory before query: 3.600 MB Rows returned: 2337

SELECT guest, client_id

  FROM bm_session

  WHERE client_id = 0

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT guest, client_id FROM #__session WHERE client_id = 0' at line 1 SQL=EXPLAIN EXTENDED SELECT guest, client_id FROM #__session WHERE client_id = 0

Profile

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.91 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_whosonline/helper.php:43
11	ModWhosonlineHelper::getOnlineCount()	JROOT/modules/mod_whosonline/mod_whosonline.php:19
10	include JROOT/modules/mod_whosonline/mod_whosonline.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.92 ms After last query: 5.67 ms Query memory: 0.026 MB Memory before query: 3.852 MB Rows returned: 10

SHOW FULL COLUMNS 
  FROM `bm_jshopping_products_reviews`

Explain

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

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.32 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.02 ms
Creating tmp table	0.03 ms
executing	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.03 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.01 ms
checking permissions	0.01 ms
checking permissions	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
15	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
14	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
13	JTable->__construct()	JROOT/components/com_jshopping/tables/review.php:14
12	jshopReview->__construct()	JROOT/libraries/joomla/table/table.php:308
11	JTable::getInstance()	JROOT/modules/mod_jshopping_products_compare/mod_jshopping_products_compare.php:29
10	include JROOT/modules/mod_jshopping_products_compare/mod_jshopping_products_compare.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.40 ms After last query: 6.97 ms Query memory: 0.004 MB Memory before query: 4.883 MB

LOCK TABLES `bm_extensions` WRITE

Explain

EXPLAIN not possible on query: LOCK TABLES `bm_extensions` WRITE

Profile

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.27 ms
System lock	0.01 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.00 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver/mysqli.php:543
8	JDatabaseDriverMysqli->lockTable()	JROOT/plugins/system/updatenotification/updatenotification.php:79
7	PlgSystemUpdatenotification->onAfterRender()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1092
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.41 ms After last query: 0.04 ms Query memory: 0.004 MB Memory before query: 4.887 MB

UPDATE `bm_extensions`

  SET `params` = '{\"lastrun\":1772593455}'

  WHERE `type` = 'plugin' 
  AND `folder` = 'system' 
  AND `element` = 'updatenotification'

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UPDATE `#__extensions` SET `params` = '{\"lastrun\":1772593455}' WHERE `type` = ' at line 1 SQL=EXPLAIN EXTENDED UPDATE `#__extensions` SET `params` = '{\"lastrun\":1772593455}' WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'updatenotification'

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.07 ms
updating	0.05 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.15 ms
closing tables	0.00 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/updatenotification/updatenotification.php:90
7	PlgSystemUpdatenotification->onAfterRender()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1092
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.10 ms After last query: 0.31 ms Query memory: 0.004 MB Memory before query: 4.893 MB

UNLOCK TABLES

Explain

EXPLAIN not possible on query: UNLOCK TABLES

Profile

Status	Duration
starting	0.01 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
waiting for handler commit	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver/mysqli.php:918
8	JDatabaseDriverMysqli->unlockTables()	JROOT/plugins/system/updatenotification/updatenotification.php:104
7	PlgSystemUpdatenotification->onAfterRender()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1092
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.37 ms After last query: 0.12 ms Query memory: 0.021 MB Memory before query: 4.904 MB Rows returned: 1

SELECT DISTINCT a.update_site_id, a.type, a.location, a.last_check_timestamp, a.extra_query

  FROM `bm_update_sites` AS `a`

  INNER JOIN bm_update_sites_extensions AS b 
  ON a.update_site_id = b.update_site_id

  WHERE a.enabled = 1 
  AND b.extension_id IN (700)

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT DISTINCT a.update_site_id, a.type, a.location, a.last_check_timestamp, a.' at line 1 SQL=EXPLAIN EXTENDED SELECT DISTINCT a.update_site_id, a.type, a.location, a.last_check_timestamp, a.extra_query FROM `#__update_sites` AS `a` INNER JOIN #__update_sites_extensions AS b ON a.update_site_id = b.update_site_id WHERE a.enabled = 1 AND b.extension_id IN (700)

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
Creating tmp table	0.03 ms
executing	0.13 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
10	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/updater/updater.php:229
9	JUpdater->getUpdateSites()	JROOT/libraries/joomla/updater/updater.php:119
8	JUpdater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:123
7	PlgSystemUpdatenotification->onAfterRender()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1092
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.19 ms After last query: 0.09 ms Query memory: 0.022 MB Memory before query: 4.916 MB Rows returned: 1

SELECT `name`

  FROM `bm_update_sites`

  WHERE `update_site_id` = '2'

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `name` FROM `#__update_sites` WHERE `update_site_id` = '2'' at line 1 SQL=EXPLAIN EXTENDED SELECT `name` FROM `#__update_sites` WHERE `update_site_id` = '2'

Profile

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.03 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/updater/updateadapter.php:188
12	JUpdateAdapter->getUpdateSiteName()	JROOT/libraries/joomla/updater/updateadapter.php:215
11	JUpdateAdapter->getUpdateSiteResponse()	JROOT/libraries/joomla/updater/adapters/collection.php:223
10	JUpdaterCollection->findUpdate()	JROOT/libraries/joomla/updater/updater.php:267
9	JUpdater->getUpdateObjectsForSite()	JROOT/libraries/joomla/updater/updater.php:151
8	JUpdater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:123
7	PlgSystemUpdatenotification->onAfterRender()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1092
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.27 ms After last query: 0.04 ms Query memory: 0.011 MB Memory before query: 4.931 MB

UPDATE `bm_update_sites`

  SET `enabled` = '0'

  WHERE `update_site_id` = '2'

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UPDATE `#__update_sites` SET `enabled` = '0' WHERE `update_site_id` = '2'' at line 1 SQL=EXPLAIN EXTENDED UPDATE `#__update_sites` SET `enabled` = '0' WHERE `update_site_id` = '2'

Profile

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.06 ms
updating	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.06 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/updater/updateadapter.php:153
12	JUpdateAdapter->toggleUpdateSite()	JROOT/libraries/joomla/updater/updateadapter.php:238
11	JUpdateAdapter->getUpdateSiteResponse()	JROOT/libraries/joomla/updater/adapters/collection.php:223
10	JUpdaterCollection->findUpdate()	JROOT/libraries/joomla/updater/updater.php:267
9	JUpdater->getUpdateObjectsForSite()	JROOT/libraries/joomla/updater/updater.php:151
8	JUpdater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:123
7	PlgSystemUpdatenotification->onAfterRender()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1092
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.67 ms After last query: 248.29 ms Query memory: 0.006 MB Memory before query: 4.947 MB

UPDATE `bm_update_sites`

  SET `enabled` = '1'

  WHERE `update_site_id` = '2'

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UPDATE `#__update_sites` SET `enabled` = '1' WHERE `update_site_id` = '2'' at line 1 SQL=EXPLAIN EXTENDED UPDATE `#__update_sites` SET `enabled` = '1' WHERE `update_site_id` = '2'

Profile

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.06 ms
updating	0.08 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.14 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/updater/updateadapter.php:153
12	JUpdateAdapter->toggleUpdateSite()	JROOT/libraries/joomla/updater/updateadapter.php:254
11	JUpdateAdapter->getUpdateSiteResponse()	JROOT/libraries/joomla/updater/adapters/collection.php:223
10	JUpdaterCollection->findUpdate()	JROOT/libraries/joomla/updater/updater.php:267
9	JUpdater->getUpdateObjectsForSite()	JROOT/libraries/joomla/updater/updater.php:151
8	JUpdater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:123
7	PlgSystemUpdatenotification->onAfterRender()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1092
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.43 ms After last query: 0.23 ms Query memory: 0.005 MB Memory before query: 4.949 MB

UPDATE `bm_update_sites`

  SET `last_check_timestamp` = '1772593456'

  WHERE `update_site_id` = '2'

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UPDATE `#__update_sites` SET `last_check_timestamp` = '1772593456' WHERE `update' at line 1 SQL=EXPLAIN EXTENDED UPDATE `#__update_sites` SET `last_check_timestamp` = '1772593456' WHERE `update_site_id` = '2'

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.04 ms
updating	0.05 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.09 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/updater/updater.php:429
9	JUpdater->updateLastCheckTimestamp()	JROOT/libraries/joomla/updater/updater.php:165
8	JUpdater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:123
7	PlgSystemUpdatenotification->onAfterRender()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1092
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

38 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

10 × SELECT
      sp.`id_template`,
      sp.name,
      sp.top_text,
      sp.pre_text,
      sp.thank_you_text,
      sp.send_text,
      sp.send_new_text,
      sp.close_alert_text,
      sp.form_width,
      sp.redirect,
      sp.redirect_itemid,
      sp.redirect_url,
      sp.redirect_delay,
      sp.shake_count,
      sp.shake_distanse,
      sp.send_copy_enable,
      sp.send_copy_text,
      sp.shake_duration,
      sp.custom_css,
      st.styles,
 
      sp.render_type,
      sp.popup_button_text,
      sp.static_button_position,
      sp.static_button_offset,
      sp.appear_animation_type,
      sp.check_token,
      sp.next_button_text,
      sp.prev_button_text
 
      
  FROM
      `bm_creative_forms` sp
      
  LEFT JOIN `bm_contact_templates` st 
  ON st.id = sp.id_template

10 × SELECT
      sp.id,
      st.name as type
      
  FROM
      `bm_creative_fields` sp
      JOIN `bm_creative_field_types` st 
  ON st.id = sp.id_type

10 × SELECT
      sp.id,
      sp.name,
      sp.tooltip_text,
      sp.required,
      sp.ordering_field,
      sp.select_default_text,
      sp.show_parent_label,
      sp.select_no_match_text,
      sp.width,
      sp.field_margin_top,
      sp.select_show_scroll_after,
      sp.select_show_search_after,
      sp.upload_button_text,
      sp.upload_minfilesize,
      sp.upload_maxfilesize,
      sp.upload_acceptfiletypes,
      sp.upload_minfilesize_message,
      sp.upload_maxfilesize_message,
      sp.upload_acceptfiletypes_message,
      sp.captcha_wrong_message,
 
      sp.datepicker_date_format,
      sp.datepicker_animation,
      sp.datepicker_style,
      sp.datepicker_icon_style,
      sp.datepicker_show_icon,
      sp.datepicker_input_readonly,
      sp.datepicker_number_months,
      sp.datepicker_mindate,
      sp.datepicker_maxdate,
      sp.datepicker_changemonths,
      sp.datepicker_changeyears,
      sp.column_type,
      sp.custom_html,
      sp.google_maps,
      sp.heading,
      sp.recaptcha_site_key,
      sp.recaptcha_wrong_message,
      sp.recaptcha_theme,
      sp.recaptcha_type,
      sp.contact_data,
      sp.contact_data_width,
      sp.creative_popup,
      sp.creative_popup_embed,
 
      sp.m_recipients_value,
      sp.m_recipients_multiple,
      sp.pagebreak_type,
      sp.pagebreak_page_title,
      sp.if_id,
      sp.if_val,
      sp.then_id,
      sp.hidden_val,
 
      st.name as type
     
  FROM
      `bm_creative_fields` sp
     JOIN `bm_creative_field_types` st 
  ON st.id = sp.id_type

2 × SELECT
         spo.name,
         spo.id,
         spo.value,
         spo.selected
        
  FROM
         `bm_creative_form_options` spo

1 × SELECT `data` 
  FROM `bm_session`

1 × SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value 
  FROM `bm_jshopping_currencies`

1 × SELECT DISTINCT a.update_site_id, a.type, a.location, a.last_check_timestamp, a.extra_query 
  FROM `bm_update_sites` AS `a` 
  INNER JOIN bm_update_sites_extensions AS b 
  ON a.update_site_id = b.update_site_id

1 × SELECT guest, client_id 
  FROM bm_session

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

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

```
1 × select id,link 
  from bm_menu
```

1 × SELECT * 
  FROM `bm_jshopping_config_display_prices

1 × SELECT * 
  FROM bm_template_styles

1 × SELECT * 
  FROM bm_jshopping_config

1 × SELECT language,id 
  FROM `bm_menu`

1 × SELECT `session_id` 
  FROM `bm_session`

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

1 × SELECT element 
  FROM bm_extensions

1 × SELECT folder AS type, element AS name, params 
  FROM bm_extensions

1 × SELECT id, rules 
  FROM `bm_viewlevels

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

1 × SELECT `name` 
  FROM `bm_update_sites`

OTHER Tables:

2 × SHOW FULL COLUMNS 
  FROM `bm_jshopping_users

```
1 × DELETE  
  FROM `bm_session`
```

1 × INSERT INTO `bm_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES  ('bd7a86cdf8e6fcb8ffda09a671e3a914', 0, 1, '1772593455', 0, ''

1 × UPDATE `bm_extensions` 
  SET `params` = '{\"mediaversion\":\"3983b462b5f2c0666ce8dd20eadbf96c\"}'

1 × SHOW FULL COLUMNS 
  FROM `bm_template_styles

1 × SHOW FULL COLUMNS 
  FROM `bm_jshopping_config

1 × SHOW FULL COLUMNS 
  FROM `bm_jshopping_currencies

1 × SHOW FULL COLUMNS 
  FROM `bm_jshopping_usergroups

1 × SHOW FULL COLUMNS 
  FROM `bm_jshopping_config_display_prices

1 × SHOW FULL COLUMNS 
  FROM `bm_jshopping_products_reviews

```
1 × LOCK TABLES `bm_extensions` WRIT
```

1 × UPDATE `bm_extensions` 
  SET `params` = '{\"lastrun\":1772593455}'

```
1 × UNLOCK TABLE
```

1 × UPDATE `bm_update_sites` 
  SET `enabled` = '0'

1 × UPDATE `bm_update_sites` 
  SET `enabled` = '1'

1 × UPDATE `bm_update_sites` 
  SET `last_check_timestamp` = '1772593456'

Sizin səbətiniz boşdur

Mallar və xidmətlər

Malların müqayisəsi

Hüquqi məlumat

İstifadəçi menyusu

Ziyarətçilər

GİRİŞ / QEYDİYYAT

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

67 Queries Logged 90.34 ms

32 duplicate found!

38 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: