ÖSYM Başvuru Merkezleri
Ösym Bürosu
ÖSYM BAŞVURU MERKEZLERİ
İLÇE ADI |
BAŞVURU MERKEZİ |
ADRES |
AYVACIK |
MEHMET AKİF ERSOY ÇOK PROGRAMLI ANADOLU LİSESİ (ÇANAKKALE - AYVACIK) |
ÜMMÜHAN MAH. LİSE SOKAK NO:13 PK:17860 |
BAYRAMİÇ |
BAYRAMİÇ ATATÜRK ANADOLU LİSESİ (ÇANAKKALE - BAYRAMİÇ) |
TEPECİK MAH. ÇALIŞKAN CAD. NO: 3 |
BİGA |
MEHMET AKİF ERSOY ANADOLU LİSESİ (ÇANAKKALE - BİGA) |
İSTİKLAL MAH. KEVSER ÖZENGİL CAD. BİGA İLKÖĞRETİM OKULU SİTESİ NO: 2 |
BOZCAADA |
GAZİ ANADOLU LİSESİ (ÇANAKKALE - BOZCAADA) |
ALAYBEY MAH. DOĞAN ÖZ CAD. NO: 23 |
ÇAN |
ÇAN ANADOLU LİSESİ (ÇANAKKALE - ÇAN) |
ATATÜRK MAH. ÇANAKKALE CAD. ÇAN LİSE BLOK NO: 88 İÇ KAPI NO: 1 |
ECEABAT |
ECEABAT MEHMET AKİF ERSOY ÇOK PROGRAMLI ANADOLU LİSESİ (ÇANAKKALE - ECEABAT) |
İSMETPAŞA MAH. İSTİKLAL CAD. NO: 36 |
EZİNE |
EZİNE ÇOK PROGRAMLI ANADOLU LİSESİ (ÇANAKKALE - EZİNE) |
CAMİKEBİR MAH. 18 MART CADDE NO:19 PK:17100 |
GELİBOLU |
ATATÜRK MESLEKİ VE TEKNİK ANADOLU LİSESİ (ÇANAKKALE - GELİBOLU) |
GAZİ SÜLEYMAN PAŞA MAH. EMEK CADDE NO:3 PK:17500 |
GÖKÇEADA |
GÖKÇEADA ATATÜRK ANADOLU LİSESİ (ÇANAKKALE - GÖKÇEADA) |
YENİ MAH. YILDIRIM BEYAZIT CADDE NO:2 PK:17760 |
LAPSEKİ |
LAPSEKİ İÇDAŞ-ÇİB MESLEKİ VE TEKNİK EĞİTİM MERKEZİ (ÇANAKKALE - LAPSEKİ) |
GAZİ SÜLEYMAN PAŞA MAH. SAMYELİ CAD. ÇELİK İHRACATÇILARI BİRLİĞİ ENDÜSTRİ MESLEK LİSESİ BLOK NO: 10 İÇ KAPI NO: 1 |
MERKEZ |
NEDİME HANIM MESLEKİ VE TEKNİK ANADOLU LİSESİ (ÇANAKKALE - MERKEZ) |
KEMALPAŞA MAH. MEHMETÇİK BUL. NO: 8 |
YENİCE |
MEHMET BODUR ANADOLU İMAM HATİP LİSESİ (ÇANAKKALE - YENİCE) |
KURTULUŞ MAH. MEHMET BODUR CAD. NO: 35 |
Kullanım Şartları: Bu Sitedeki Firma bilgileri ilgili firmalara aittir. Sorumluluk ilgili firmalara ve kurumlara ait olup, www.heryerdebul.com , bu sitede yayımlanan ve yanlış, eksik olduğu ortaya çıkan veya sonradan ilgili firma tarafından değiştirilen bilgilere göre hareket edilmesi sonucu herhangi bir mağduriyet, kayıp veya hasara yönelik sorumluluk www.heryerdebul.com olarak kabul edilmemektedir.
{ "__default": { "session": { "counter": 1, "timer": { "start": 1611491278, "last": 1611491278, "now": 1611491278 }, "token": "S7lYFpZcddRhJXLlDQPidafxQ43Gk4P7" }, "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 } } }
SELECT `data`
FROM `frm_session`
WHERE `session_id` = X'3335316336646437383266376136636333353561376666663265623335663431'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | frm_session | const | PRIMARY | PRIMARY | 194 | const | 1 |
Status | Duration |
---|---|
Starting | 0.21 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.04 ms |
Optimizing | 0.03 ms |
Statistics | 0.08 ms |
Preparing | 0.01 ms |
Executing | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.02 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.07 ms |
Updating status | 0.04 ms |
Reset for next command | 0.01 ms |
# | Çağırıcı | Dosya ve satır sayısı |
---|---|---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
15 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/session/storage/database.php:45 |
14 | JSessionStorageDatabase->read() | Aşağıdaki satırda bulunan çağrı gibi. |
13 | session_start() | JROOT/libraries/joomla/session/handler/native.php:260 |
12 | JSessionHandlerNative->doSessionStart() | JROOT/libraries/joomla/session/handler/native.php:50 |
11 | JSessionHandlerNative->start() | JROOT/libraries/joomla/session/handler/joomla.php:88 |
10 | JSessionHandlerJoomla->start() | JROOT/libraries/src/Session/Session.php:660 |
9 | Joomla\CMS\Session\Session->_start() | JROOT/libraries/src/Session/Session.php:620 |
8 | Joomla\CMS\Session\Session->start() | JROOT/libraries/src/Session/Session.php:498 |
7 | Joomla\CMS\Session\Session->get() | JROOT/libraries/src/Session/Session.php:455 |
6 | Joomla\CMS\Session\Session->isNew() | JROOT/libraries/src/Application/CMSApplication.php:758 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:135 |
4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:344 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
SELECT `session_id`
FROM `frm_session`
WHERE `session_id` = X'3335316336646437383266376136636333353561376666663265623335663431'
LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | frm_session | const | PRIMARY | PRIMARY | 194 | const | 1 | Using index |
Status | Duration |
---|---|
Starting | 0.12 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.02 ms |
Optimizing | 0.01 ms |
Statistics | 0.03 ms |
Preparing | 0.01 ms |
Executing | 0.01 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.07 ms |
Updating status | 0.05 ms |
Reset for next command | 0.01 ms |
# | Çağırıcı | Dosya ve satır sayısı |
---|---|---|
9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
8 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Session/MetadataManager.php:74 |
7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:153 |
6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:760 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:135 |
4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:344 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
INSERT INTO `frm_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3335316336646437383266376136636333353561376666663265623335663431', 1, 1611491279, 0, '', 0)
Status | Duration |
---|---|
Starting | 0.10 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init for update | 0.02 ms |
Update | 0.10 ms |
Waiting for query cache lock | 0.01 ms |
Update | 0.01 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.04 ms |
Closing tables | 0.02 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.05 ms |
Updating status | 0.05 ms |
Reset for next command | 0.01 ms |
# | Çağırıcı | Dosya ve satır sayısı |
---|---|---|
8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Session/MetadataManager.php:116 |
7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:153 |
6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:760 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:135 |
4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:344 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
SELECT id, rules
FROM `frm_viewlevels`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | frm_viewlevels | ALL | NULL | HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR | NULL | NULL | 5 |
Status | Duration |
---|---|
Starting | 0.20 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.02 ms |
Init | 0.03 ms |
Optimizing | 0.05 ms |
Statistics | 0.02 ms |
Preparing | 0.04 ms |
Executing | 0.01 ms |
Sending data | 0.06 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.06 ms |
Updating status | 0.08 ms |
Reset for next command | 0.01 ms |
# | Çağırıcı | Dosya ve satır sayısı |
---|---|---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
9 | JDatabaseDriver->loadAssocList() | JROOT/libraries/src/Access/Access.php:1063 |
8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:321 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT b.id
FROM frm_usergroups AS a
LEFT JOIN frm_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | b | index | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 8 | NULL | 9 | Using where; Using index |
Status | Duration |
---|---|
Starting | 0.13 ms |
Checking permissions | 0.03 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.03 ms |
Optimizing | 0.03 ms |
Statistics | 0.14 ms |
Preparing | 0.01 ms |
Unlocking tables | 0.01 ms |
Preparing | 0.03 ms |
Executing | 0.01 ms |
Sending data | 0.04 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.02 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.06 ms |
Updating status | 0.04 ms |
Reset for next command | 0.01 ms |
# | Çağırıcı | Dosya ve satır sayısı |
---|---|---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
10 | JDatabaseDriver->loadColumn() | JROOT/libraries/src/Access/Access.php:980 |
9 | Joomla\CMS\Access\Access::getGroupsByUser() | JROOT/libraries/src/Access/Access.php:1095 |
8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:321 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SHOW FULL COLUMNS
FROM `frm_gsd_config`
Status | Duration |
---|---|
Starting | 0.26 ms |
Checking permissions | 0.02 ms |
Closing tables | 0.01 ms |
Opening tables | 0.61 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
Table lock | 0.03 ms |
Init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.04 ms |
Preparing | 0.04 ms |
Executing | 0.02 ms |
Filling schema table | 0.03 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
Checking permissions | 0.10 ms |
Closing tables | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.06 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Removing tmp table | 0.22 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.10 ms |
Updating status | 0.09 ms |
Reset for next command | 0.01 ms |
# | Çağırıcı | Dosya ve satır sayısı |
---|---|---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
14 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:445 |
13 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
12 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
11 | Joomla\CMS\Table\Table->__construct() | JROOT/administrator/components/com_gsd/tables/config.php:26 |
10 | GSDTableConfig->__construct() | JROOT/libraries/src/Table/Table.php:312 |
9 | Joomla\CMS\Table\Table::getInstance() | JROOT/administrator/components/com_gsd/GSD/Helper.php:407 |
8 | GSD\Helper::getParams() | JROOT/plugins/system/gsd/gsd.php:61 |
7 | plgSystemGSD->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:283 |
6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:625 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM frm_gsd_config
WHERE `name` = 'config'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | frm_gsd_config | system | NULL | HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR | NULL | NULL | 1 |
Status | Duration |
---|---|
Starting | 0.16 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.02 ms |
Init | 0.04 ms |
Optimizing | 0.02 ms |
Statistics | 0.06 ms |
Preparing | 0.01 ms |
Unlocking tables | 0.01 ms |
Preparing | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.02 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.03 ms |
Freeing items | 0.08 ms |
Updating status | 0.05 ms |
Reset for next command | 0.01 ms |
# | Çağırıcı | Dosya ve satır sayısı |
---|---|---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
10 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:731 |
9 | Joomla\CMS\Table\Table->load() | JROOT/administrator/components/com_gsd/GSD/Helper.php:408 |
8 | GSD\Helper::getParams() | JROOT/plugins/system/gsd/gsd.php:61 |
7 | plgSystemGSD->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:283 |
6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:625 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
select id, title, alias
from frm_jumi
where published = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | frm_jumi | ALL | NULL | HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR | NULL | NULL | 9 | Using where |
Status | Duration |
---|---|
Starting | 0.17 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.02 ms |
Optimizing | 0.03 ms |
Statistics | 0.02 ms |
Preparing | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.14 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.06 ms |
Updating status | 0.05 ms |
Reset for next command | 0.01 ms |
# | Çağırıcı | Dosya ve satır sayısı |
---|---|---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1811 |
12 | JDatabaseDriver->loadRowList() | JROOT/plugins/system/jumirouter/jumirouter.php:57 |
11 | parseJumiRouter() | Aşağıdaki satırda bulunan çağrı gibi. |
10 | call_user_func_array() | JROOT/libraries/src/Router/Router.php:596 |
9 | Joomla\CMS\Router\Router->processParseRules() | JROOT/libraries/src/Router/SiteRouter.php:593 |
8 | Joomla\CMS\Router\SiteRouter->processParseRules() | JROOT/libraries/src/Router/Router.php:570 |
7 | Joomla\CMS\Router\Router->_processParseRules() | JROOT/libraries/src/Router/Router.php:216 |
6 | Joomla\CMS\Router\Router->parse() | JROOT/libraries/src/Router/SiteRouter.php:138 |
5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1074 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
UPDATE `frm_extensions`
SET `params` = '{\"mediaversion\":\"79980070114301e9ef5cf0446db4b655\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
Status | Duration |
---|---|
Starting | 0.15 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init for update | 0.24 ms |
Updating | 0.10 ms |
End of update loop | 0.01 ms |
Waiting for query cache lock | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Waiting for query cache lock | 0.01 ms |
Unlocking tables | 0.03 ms |
Closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.06 ms |
Updating status | 0.05 ms |
Reset for next command | 0.01 ms |
# | Çağırıcı | Dosya ve satır sayısı |
---|---|---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 |
13 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 |
12 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 |
11 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
10 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
9 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/djjquerymonster/djjquerymonster.php:54 |
8 | plgSystemDJjQueryMonster->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1122 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT s.*
FROM frm_template_styles as s
WHERE s.client_id = 0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | s | ref | idx_client_id,idx_client_id_home | idx_client_id | 1 | const | 5 |
Status | Duration |
---|---|
Starting | 0.27 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
Table lock | 0.03 ms |
Init | 0.05 ms |
Optimizing | 0.03 ms |
Statistics | 0.08 ms |
Preparing | 0.04 ms |
Executing | 0.01 ms |
Sending data | 0.09 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.09 ms |
Updating status | 0.06 ms |
Reset for next command | 0.01 ms |
# | Çağırıcı | Dosya ve satır sayısı |
---|---|---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/advancedtemplates/src/Document.php:193 |
12 | RegularLabs\Plugin\System\AdvancedTemplates\Document::getStyles() | JROOT/plugins/system/advancedtemplates/src/Document.php:121 |
11 | RegularLabs\Plugin\System\AdvancedTemplates\Document::getActiveStyle() | JROOT/plugins/system/advancedtemplates/src/Document.php:102 |
10 | RegularLabs\Plugin\System\AdvancedTemplates\Document::setTemplate() | JROOT/plugins/system/advancedtemplates/advancedtemplates.php:105 |
9 | PlgSystemAdvancedTemplates->handleOnAfterRoute() | JROOT/libraries/regularlabs/src/Plugin.php:94 |
8 | RegularLabs\Library\Plugin->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1122 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT a.params
FROM frm_advancedtemplates AS a
WHERE a.styleid = 4
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.23 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.02 ms |
Init | 0.04 ms |
Optimizing | 0.03 ms |
Statistics | 0.07 ms |
Preparing | 0.02 ms |
Unlocking tables | 0.02 ms |
Preparing | 0.03 ms |
Executing | 0.01 ms |
Sending data | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.11 ms |
Updating status | 0.06 ms |
Reset for next command | 0.01 ms |
# | Çağırıcı | Dosya ve satır sayısı |
---|---|---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
16 | JDatabaseDriver->loadResult() | JROOT/plugins/system/advancedtemplates/src/Document.php:300 |
15 | RegularLabs\Plugin\System\AdvancedTemplates\Document::getAdvancedParams() | JROOT/plugins/system/advancedtemplates/src/Document.php:207 |
14 | RegularLabs\Plugin\System\AdvancedTemplates\Document::getStyleParams() | JROOT/plugins/system/advancedtemplates/src/Document.php:270 |
13 | RegularLabs\Plugin\System\AdvancedTemplates\Document::stylePassesAssignments() | JROOT/plugins/system/advancedtemplates/src/Document.php:173 |
12 | RegularLabs\Plugin\System\AdvancedTemplates\Document::isStyleActive() | JROOT/plugins/system/advancedtemplates/src/Document.php:127 |
11 | RegularLabs\Plugin\System\AdvancedTemplates\Document::getActiveStyle() | JROOT/plugins/system/advancedtemplates/src/Document.php:102 |
10 | RegularLabs\Plugin\System\AdvancedTemplates\Document::setTemplate() | JROOT/plugins/system/advancedtemplates/advancedtemplates.php:105 |
9 | PlgSystemAdvancedTemplates->handleOnAfterRoute() | JROOT/libraries/regularlabs/src/Plugin.php:94 |
8 | RegularLabs\Library\Plugin->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1122 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT a.params
FROM frm_advancedtemplates AS a
WHERE a.styleid = 7
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.18 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.02 ms |
Init | 0.03 ms |
Optimizing | 0.03 ms |
Statistics | 0.06 ms |
Preparing | 0.01 ms |
Unlocking tables | 0.01 ms |
Preparing | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.08 ms |
Updating status | 0.05 ms |
Reset for next command | 0.01 ms |
# | Çağırıcı | Dosya ve satır sayısı |
---|---|---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
16 | JDatabaseDriver->loadResult() | JROOT/plugins/system/advancedtemplates/src/Document.php:300 |
15 | RegularLabs\Plugin\System\AdvancedTemplates\Document::getAdvancedParams() | JROOT/plugins/system/advancedtemplates/src/Document.php:207 |
14 | RegularLabs\Plugin\System\AdvancedTemplates\Document::getStyleParams() | JROOT/plugins/system/advancedtemplates/src/Document.php:270 |
13 | RegularLabs\Plugin\System\AdvancedTemplates\Document::stylePassesAssignments() | JROOT/plugins/system/advancedtemplates/src/Document.php:173 |
12 | RegularLabs\Plugin\System\AdvancedTemplates\Document::isStyleActive() | JROOT/plugins/system/advancedtemplates/src/Document.php:127 |
11 | RegularLabs\Plugin\System\AdvancedTemplates\Document::getActiveStyle() | JROOT/plugins/system/advancedtemplates/src/Document.php:102 |
10 | RegularLabs\Plugin\System\AdvancedTemplates\Document::setTemplate() | JROOT/plugins/system/advancedtemplates/advancedtemplates.php:105 |
9 | PlgSystemAdvancedTemplates->handleOnAfterRoute() | JROOT/libraries/regularlabs/src/Plugin.php:94 |
8 | RegularLabs\Library\Plugin->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1122 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT a.params
FROM frm_advancedtemplates AS a
WHERE a.styleid = 14
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.13 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.05 ms |
Optimizing | 0.02 ms |
Statistics | 0.04 ms |
Preparing | 0.01 ms |
Unlocking tables | 0.01 ms |
Preparing | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.08 ms |
Updating status | 0.05 ms |
Reset for next command | 0.01 ms |
# | Çağırıcı | Dosya ve satır sayısı |
---|---|---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
16 | JDatabaseDriver->loadResult() | JROOT/plugins/system/advancedtemplates/src/Document.php:300 |
15 | RegularLabs\Plugin\System\AdvancedTemplates\Document::getAdvancedParams() | JROOT/plugins/system/advancedtemplates/src/Document.php:207 |
14 | RegularLabs\Plugin\System\AdvancedTemplates\Document::getStyleParams() | JROOT/plugins/system/advancedtemplates/src/Document.php:270 |
13 | RegularLabs\Plugin\System\AdvancedTemplates\Document::stylePassesAssignments() | JROOT/plugins/system/advancedtemplates/src/Document.php:173 |
12 | RegularLabs\Plugin\System\AdvancedTemplates\Document::isStyleActive() | JROOT/plugins/system/advancedtemplates/src/Document.php:127 |
11 | RegularLabs\Plugin\System\AdvancedTemplates\Document::getActiveStyle() | JROOT/plugins/system/advancedtemplates/src/Document.php:102 |
10 | RegularLabs\Plugin\System\AdvancedTemplates\Document::setTemplate() | JROOT/plugins/system/advancedtemplates/advancedtemplates.php:105 |
9 | PlgSystemAdvancedTemplates->handleOnAfterRoute() | JROOT/libraries/regularlabs/src/Plugin.php:94 |
8 | RegularLabs\Library\Plugin->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1122 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT a.params
FROM frm_advancedtemplates AS a
WHERE a.styleid = 15
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.14 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.02 ms |
Optimizing | 0.02 ms |
Statistics | 0.04 ms |
Preparing | 0.01 ms |
Unlocking tables | 0.01 ms |
Preparing | 0.03 ms |
Executing | 0.01 ms |
Sending data | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.05 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.08 ms |
Updating status | 0.05 ms |
Reset for next command | 0.01 ms |
# | Çağırıcı | Dosya ve satır sayısı |
---|---|---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
16 | JDatabaseDriver->loadResult() | JROOT/plugins/system/advancedtemplates/src/Document.php:300 |
15 | RegularLabs\Plugin\System\AdvancedTemplates\Document::getAdvancedParams() | JROOT/plugins/system/advancedtemplates/src/Document.php:207 |
14 | RegularLabs\Plugin\System\AdvancedTemplates\Document::getStyleParams() | JROOT/plugins/system/advancedtemplates/src/Document.php:270 |
13 | RegularLabs\Plugin\System\AdvancedTemplates\Document::stylePassesAssignments() | JROOT/plugins/system/advancedtemplates/src/Document.php:173 |
12 | RegularLabs\Plugin\System\AdvancedTemplates\Document::isStyleActive() | JROOT/plugins/system/advancedtemplates/src/Document.php:127 |
11 | RegularLabs\Plugin\System\AdvancedTemplates\Document::getActiveStyle() | JROOT/plugins/system/advancedtemplates/src/Document.php:102 |
10 | RegularLabs\Plugin\System\AdvancedTemplates\Document::setTemplate() | JROOT/plugins/system/advancedtemplates/advancedtemplates.php:105 |
9 | PlgSystemAdvancedTemplates->handleOnAfterRoute() | JROOT/libraries/regularlabs/src/Plugin.php:94 |
8 | RegularLabs\Library\Plugin->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1122 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT a.params
FROM frm_advancedtemplates AS a
WHERE a.styleid = 16
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.12 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.03 ms |
Init | 0.02 ms |
Optimizing | 0.02 ms |
Statistics | 0.04 ms |
Preparing | 0.01 ms |
Unlocking tables | 0.01 ms |
Preparing | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.09 ms |
Updating status | 0.05 ms |
Reset for next command | 0.01 ms |
# | Çağırıcı | Dosya ve satır sayısı |
---|---|---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
16 | JDatabaseDriver->loadResult() | JROOT/plugins/system/advancedtemplates/src/Document.php:300 |
15 | RegularLabs\Plugin\System\AdvancedTemplates\Document::getAdvancedParams() | JROOT/plugins/system/advancedtemplates/src/Document.php:207 |
14 | RegularLabs\Plugin\System\AdvancedTemplates\Document::getStyleParams() | JROOT/plugins/system/advancedtemplates/src/Document.php:270 |
13 | RegularLabs\Plugin\System\AdvancedTemplates\Document::stylePassesAssignments() | JROOT/plugins/system/advancedtemplates/src/Document.php:173 |
12 | RegularLabs\Plugin\System\AdvancedTemplates\Document::isStyleActive() | JROOT/plugins/system/advancedtemplates/src/Document.php:127 |
11 | RegularLabs\Plugin\System\AdvancedTemplates\Document::getActiveStyle() | JROOT/plugins/system/advancedtemplates/src/Document.php:102 |
10 | RegularLabs\Plugin\System\AdvancedTemplates\Document::setTemplate() | JROOT/plugins/system/advancedtemplates/advancedtemplates.php:105 |
9 | PlgSystemAdvancedTemplates->handleOnAfterRoute() | JROOT/libraries/regularlabs/src/Plugin.php:94 |
8 | RegularLabs\Library\Plugin->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1122 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT id, home, template, s.params
FROM frm_template_styles as s
LEFT JOIN frm_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | s | ref | idx_template,idx_client_id,idx_client_id_home | idx_client_id | 1 | const | 5 | |
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | element_clientid | 403 | u8289662_hbfirma.s.template,const | 1 | Using index condition; Using where |
Status | Duration |
---|---|
Starting | 0.27 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.04 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
Table lock | 0.02 ms |
Init | 0.07 ms |
Optimizing | 0.05 ms |
Statistics | 0.22 ms |
Preparing | 0.06 ms |
Executing | 0.02 ms |
Sending data | 0.31 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.03 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.09 ms |
Updating status | 0.07 ms |
Reset for next command | 0.01 ms |
# | Çağırıcı | Dosya ve satır sayısı |
---|---|---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
11 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:2182 |
10 | JMFTemplate::getTemplateStyleId() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:136 |
9 | JMFTemplate->__construct() | JROOT/plugins/system/ef4_jmframework/ef4_jmframework.php:296 |
8 | plgSystemEF4_JMFramework->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1122 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT item_id
FROM frm_djcf_items_promotions
WHERE date_exp <= '2021-01-24 15:27:59'
AND updated=0
GROUP BY item_id
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | frm_djcf_items_promotions | ALL | date_exp | HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR | NULL | NULL | 18552 | Using where; Using temporary; Dosya sıralama kullanılıyor |
Status | Duration |
---|---|
Starting | 0.12 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.03 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.05 ms |
Preparing | 0.03 ms |
Creating tmp table | 0.03 ms |
Sorting result | 0.01 ms |
Executing | 0.01 ms |
Sending data | 3.45 ms |
Creating sort index | 0.21 ms |
Removing tmp table | 0.01 ms |
Creating sort index | 0.01 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.09 ms |
Updating status | 0.07 ms |
Reset for next command | 0.01 ms |
# | Çağırıcı | Dosya ve satır sayısı |
---|---|---|
9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
8 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_djclassifieds/lib/djpayment.php:912 |
7 | DJClassifiedsPayment::updatePromotions() | JROOT/components/com_djclassifieds/djclassifieds.php:108 |
6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM frm_djcf_items
WHERE id=2208
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | frm_djcf_items | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.24 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.04 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.02 ms |
Init | 0.09 ms |
Optimizing | 0.04 ms |
Statistics | 0.10 ms |
Preparing | 0.01 ms |
Unlocking tables | 0.01 ms |
Preparing | 0.03 ms |
Executing | 0.01 ms |
Sending data | 0.35 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.02 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.08 ms |
Updating status | 0.06 ms |
Reset for next command | 0.01 ms |
# | Çağırıcı | Dosya ve satır sayısı |
---|---|---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
9 | JDatabaseDriver->loadObject() | JROOT/components/com_djclassifieds/controllers/item.php:57 |
8 | DJClassifiedsControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:137 |
6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
UPDATE `frm_djcf_items`
SET display=display+1
WHERE id=2208
Status | Duration |
---|---|
Starting | 0.15 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init for update | 0.08 ms |
Updating | 0.10 ms |
End of update loop | 0.01 ms |
Waiting for query cache lock | 0.01 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Waiting for query cache lock | 0.02 ms |
Unlocking tables | 0.03 ms |
Closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.08 ms |
Updating status | 0.05 ms |
Reset for next command | 0.01 ms |
# | Çağırıcı | Dosya ve satır sayısı |
---|---|---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/database.php:33 |
9 | JDatabase->query() | JROOT/components/com_djclassifieds/controllers/item.php:92 |
8 | DJClassifiedsControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:137 |
6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT i.*,c.name as c_name,c.alias as c_alias, c.access_view as c_access_view, c.access_item_view as c_access_item_view, c.rev_group_id, r.name as r_name, u.name as username, u.email as u_email, iu.name as unit_name , t.id as t_id, t.name as t_name,t.params as t_params
FROM frm_djcf_categories c, frm_djcf_items i
LEFT JOIN frm_djcf_types t
ON t.id = i.type_id
LEFT JOIN frm_users u
ON u.id = i.user_id
LEFT JOIN frm_djcf_regions r
ON r.id = i.region_id
LEFT JOIN frm_djcf_items_units iu
ON iu.id = i.unit_id
WHERE c.id=i.cat_id
AND i.id = 2208
LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | i | const | PRIMARY,cat_id | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | t | const | PRIMARY | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | u | const | PRIMARY | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | r | const | PRIMARY | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | iu | const | PRIMARY | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | c | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.28 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.08 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
Table lock | 0.02 ms |
Init | 0.10 ms |
Optimizing | 0.05 ms |
Statistics | 0.36 ms |
Preparing | 0.02 ms |
Unlocking tables | 0.04 ms |
Preparing | 0.04 ms |
Executing | 0.01 ms |
Sending data | 0.32 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.02 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.03 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.09 ms |
Updating status | 0.10 ms |
Reset for next command | 0.03 ms |
# | Çağırıcı | Dosya ve satır sayısı |
---|---|---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
12 | JDatabaseDriver->loadObject() | JROOT/components/com_djclassifieds/models/item.php:71 |
11 | DjclassifiedsModelItem->getItem() | JROOT/components/com_djclassifieds/views/item/view.html.php:56 |
10 | DJclassifiedsViewItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djclassifieds/controllers/item.php:98 |
8 | DJClassifiedsControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:137 |
6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT c.*
FROM frm_djcf_items_categories ic, frm_djcf_categories c
WHERE c.id=ic.cat_id
AND ic.item_id = 2208
ORDER BY ic.item_id,ic.ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | NULL | NULL | NULL | HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
Status | Duration |
---|---|
Starting | 0.17 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.02 ms |
Init | 0.04 ms |
Optimizing | 0.02 ms |
Statistics | 0.03 ms |
Preparing | 0.02 ms |
Executing | 0.04 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.07 ms |
Updating status | 0.06 ms |
Reset for next command | 0.01 ms |
# | Çağırıcı | Dosya ve satır sayısı |
---|---|---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/components/com_djclassifieds/models/item.php:78 |
11 | DjclassifiedsModelItem->getItem() | JROOT/components/com_djclassifieds/views/item/view.html.php:56 |
10 | DJclassifiedsViewItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djclassifieds/controllers/item.php:98 |
8 | DJClassifiedsControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:137 |
6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT img.*
FROM frm_djcf_images img
WHERE img.item_id IN (2208)
AND img.type='item'
ORDER BY img.item_id, img.ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | img | ref | item_id,type | item_id | 4 | const | 1 | Using where; Dosya sıralama kullanılıyor |
Status | Duration |
---|---|
Starting | 0.12 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.10 ms |
Preparing | 0.03 ms |
Sorting result | 0.01 ms |
Executing | 0.01 ms |
Sending data | 0.01 ms |
Creating sort index | 0.07 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.01 ms |
Starting cleanup | 0.03 ms |
Freeing items | 0.07 ms |
Updating status | 0.05 ms |
Reset for next command | 0.01 ms |
# | Çağırıcı | Dosya ve satır sayısı |
---|---|---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_djclassifieds/lib/djimage.php:427 |
11 | DJClassifiedsImage::getAdsImages() | JROOT/components/com_djclassifieds/views/item/view.html.php:71 |
10 | DJclassifiedsViewItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djclassifieds/controllers/item.php:98 |
8 | DJClassifiedsControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:137 |
6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT c.*
FROM frm_djcf_categories c
WHERE id='16'
LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | c | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.13 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.07 ms |
Preparing | 0.01 ms |
Unlocking tables | 0.02 ms |
Preparing | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.60 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.09 ms |
Updating status | 0.04 ms |
Reset for next command | 0.01 ms |
# | Çağırıcı | Dosya ve satır sayısı |
---|---|---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
12 | JDatabaseDriver->loadObject() | JROOT/components/com_djclassifieds/models/item.php:90 |
11 | DjclassifiedsModelItem->getCategory() | JROOT/components/com_djclassifieds/views/item/view.html.php:73 |
10 | DJclassifiedsViewItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djclassifieds/controllers/item.php:98 |
8 | DJClassifiedsControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:137 |
6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT f.*, v.value,v.value_date,v.value_date_to
FROM frm_djcf_fields f
LEFT JOIN frm_djcf_fields_xref fx
ON f.id=fx.field_id
LEFT JOIN (SELECT *
FROM frm_djcf_fields_values
WHERE item_id=2208) v
ON v.field_id=f.id
WHERE fx.cat_id IN (SELECT cat_id
FROM frm_djcf_items_categories
WHERE item_id=2208 UNION SELECT 16)
AND f.published=1
AND f.access=0
AND f.name!='price'
AND f.name!='contact'
ORDER BY fx.ordering, f.ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | PRIMARY | f | ref | name,published | published | 4 | const | 7 | Using where; Using temporary; Dosya sıralama kullanılıyor |
1 | PRIMARY | fx | ALL | NULL | HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR | NULL | NULL | 57 | Using where |
1 | PRIMARY | frm_djcf_fields_values | ref | field_id,item_id | item_id | 4 | const | 1 | Using where |
3 | DEPENDENT SUBQUERY | NULL | NULL | NULL | HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
4 | DEPENDENT UNION | NULL | NULL | NULL | HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR | NULL | NULL | NULL | No tables used |
NULL | UNION RESULT | <union3,4> | ALL | NULL | HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR | NULL | NULL | NULL |
Status | Duration |
---|---|
Starting | 0.23 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.06 ms |
After opening tables | 0.01 ms |
System lock | 0.02 ms |
Table lock | 0.02 ms |
Init | 0.18 ms |
Optimizing | 0.05 ms |
Statistics | 0.12 ms |
Preparing | 0.05 ms |
Optimizing | 0.02 ms |
Statistics | 0.03 ms |
Preparing | 0.02 ms |
Optimizing | 0.03 ms |
Creating tmp table | 0.07 ms |
Sorting result | 0.03 ms |
Executing | 0.01 ms |
Sending data | 1.51 ms |
Creating sort index | 0.05 ms |
Removing tmp table | 0.13 ms |
Creating sort index | 0.01 ms |
End of update loop | 0.02 ms |
Removing tmp table | 0.01 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Removing tmp table | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Removing tmp table | 0.07 ms |
Freeing items | 0.13 ms |
Updating status | 0.32 ms |
Reset for next command | 0.02 ms |
# | Çağırıcı | Dosya ve satır sayısı |
---|---|---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/components/com_djclassifieds/models/item.php:161 |
11 | DjclassifiedsModelItem->getFields() | JROOT/components/com_djclassifieds/views/item/view.html.php:74 |
10 | DJclassifiedsViewItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djclassifieds/controllers/item.php:98 |
8 | DJClassifiedsControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:137 |
6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT f.*, v.value,v.value_date,v.value_date_to
FROM frm_djcf_fields f
LEFT JOIN frm_djcf_fields_xref fx
ON f.id=fx.field_id
LEFT JOIN (SELECT *
FROM frm_djcf_fields_values
WHERE item_id=2208) v
ON v.field_id=f.id
WHERE f.source=1
AND f.published=1
AND f.access=0
AND f.name!='price'
GROUP BY f.id
ORDER BY fx.ordering, f.ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | f | ref | name,published | published | 4 | const | 7 | Using where; Using temporary; Dosya sıralama kullanılıyor |
1 | SIMPLE | fx | ALL | NULL | HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR | NULL | NULL | 57 | Using where |
1 | SIMPLE | frm_djcf_fields_values | ref | field_id,item_id | item_id | 4 | const | 1 | Using where |
Status | Duration |
---|---|
Starting | 0.22 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.09 ms |
Optimizing | 0.04 ms |
Statistics | 0.10 ms |
Preparing | 0.05 ms |
Creating tmp table | 0.06 ms |
Sorting result | 0.03 ms |
Executing | 0.01 ms |
Sending data | 0.63 ms |
Creating sort index | 0.09 ms |
Removing tmp table | 0.16 ms |
Creating sort index | 0.02 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.02 ms |
Closing tables | 0.01 ms |
Removing tmp table | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.13 ms |
Updating status | 0.37 ms |
Reset for next command | 0.01 ms |
# | Çağırıcı | Dosya ve satır sayısı |
---|---|---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/components/com_djclassifieds/models/item.php:177 |
11 | DjclassifiedsModelItem->geContactFields() | JROOT/components/com_djclassifieds/views/item/view.html.php:75 |
10 | DJclassifiedsViewItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djclassifieds/controllers/item.php:98 |
8 | DJClassifiedsControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:137 |
6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT s.plan_id
FROM frm_djcf_plans_subscr_items si, frm_djcf_plans_subscr s
WHERE si.subscr_id= s.id
AND si.item_id = 2208
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | NULL | NULL | NULL | HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
Status | Duration |
---|---|
Starting | 0.16 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.03 ms |
Optimizing | 0.03 ms |
Statistics | 0.03 ms |
Preparing | 0.01 ms |
Executing | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.11 ms |
Updating status | 0.27 ms |
Reset for next command | 0.02 ms |
# | Çağırıcı | Dosya ve satır sayısı |
---|---|---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
12 | JDatabaseDriver->loadResult() | JROOT/components/com_djclassifieds/models/item.php:199 |
11 | DjclassifiedsModelItem->getItemPayment() | JROOT/components/com_djclassifieds/views/item/view.html.php:76 |
10 | DJclassifiedsViewItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djclassifieds/controllers/item.php:98 |
8 | DJClassifiedsControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:137 |
6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT COUNT(p.id)
FROM frm_djcf_payments p
WHERE p.price>0
AND p.item_id = 2208
AND p.type=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | p | ALL | NULL | HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR | NULL | NULL | 16 | Using where |
Status | Duration |
---|---|
Starting | 0.17 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.02 ms |
Init | 0.03 ms |
Optimizing | 0.03 ms |
Statistics | 0.02 ms |
Preparing | 0.03 ms |
Executing | 0.01 ms |
Sending data | 0.04 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.12 ms |
Updating status | 0.31 ms |
Reset for next command | 0.02 ms |
# | Çağırıcı | Dosya ve satır sayısı |
---|---|---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
12 | JDatabaseDriver->loadResult() | JROOT/components/com_djclassifieds/models/item.php:210 |
11 | DjclassifiedsModelItem->getItemPayment() | JROOT/components/com_djclassifieds/views/item/view.html.php:76 |
10 | DJclassifiedsViewItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djclassifieds/controllers/item.php:98 |
8 | DJClassifiedsControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:137 |
6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT f.*
FROM frm_djcf_fields_values_sale f
WHERE f.item_id =2208
ORDER BY f.id
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | NULL | NULL | NULL | HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
Status | Duration |
---|---|
Starting | 0.16 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.02 ms |
Preparing | 0.01 ms |
Executing | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.16 ms |
Updating status | 0.27 ms |
Reset for next command | 0.02 ms |
# | Çağırıcı | Dosya ve satır sayısı |
---|---|---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/components/com_djclassifieds/models/item.php:309 |
11 | DjclassifiedsModelItem->getItemOptions() | JROOT/components/com_djclassifieds/views/item/view.html.php:77 |
10 | DJclassifiedsViewItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djclassifieds/controllers/item.php:98 |
8 | DJClassifiedsControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:137 |
6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT a.*, u.name as u_name
FROM frm_djcf_auctions a, frm_users u
WHERE a.user_id=u.id
AND a.item_id=2208
ORDER BY a.date DESC
LIMIT 3
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | NULL | NULL | NULL | HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
Status | Duration |
---|---|
Starting | 0.16 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.02 ms |
Table lock | 0.01 ms |
Init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.03 ms |
Preparing | 0.01 ms |
Executing | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.11 ms |
Updating status | 0.27 ms |
Reset for next command | 0.02 ms |
# | Çağırıcı | Dosya ve satır sayısı |
---|---|---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/components/com_djclassifieds/models/item.php:247 |
11 | DjclassifiedsModelItem->getBids() | JROOT/components/com_djclassifieds/views/item/view.html.php:78 |
10 | DJclassifiedsViewItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djclassifieds/controllers/item.php:98 |
8 | DJClassifiedsControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:137 |
6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT COUNT(i.id)
FROM frm_djcf_items i
WHERE i.published=1
AND i.date_exp > '2021-01-24 15:27:59'
AND i.user_id = 866
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | i | ref | user_id,published | user_id | 4 | const | 3455 | Using where |
Status | Duration |
---|---|
Starting | 0.18 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.03 ms |
Optimizing | 0.03 ms |
Statistics | 0.09 ms |
Preparing | 0.04 ms |
Executing | 0.01 ms |
Sending data | 73.26 ms |
End of update loop | 0.03 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.10 ms |
Updating status | 0.15 ms |
Reset for next command | 0.01 ms |
# | Çağırıcı | Dosya ve satır sayısı |
---|---|---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
12 | JDatabaseDriver->loadResult() | JROOT/components/com_djclassifieds/models/item.php:106 |
11 | DjclassifiedsModelItem->getUserItemsCount() | JROOT/components/com_djclassifieds/views/item/view.html.php:80 |
10 | DJclassifiedsViewItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djclassifieds/controllers/item.php:98 |
8 | DJClassifiedsControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:137 |
6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT c.*
FROM frm_djcf_categories c
WHERE c.published=1
AND c.access_view IN (1,1,5)
ORDER BY c.parent_id, c.ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | c | ref | published | published | 4 | const | 61 | Using where; Dosya sıralama kullanılıyor |
Status | Duration |
---|---|
Starting | 0.34 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.06 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
Table lock | 0.02 ms |
Init | 0.09 ms |
Optimizing | 0.04 ms |
Statistics | 0.10 ms |
Preparing | 0.05 ms |
Sorting result | 0.03 ms |
Executing | 0.01 ms |
Sending data | 0.04 ms |
Creating sort index | 11.27 ms |
End of update loop | 0.05 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.14 ms |
Updating status | 1.57 ms |
Reset for next command | 0.03 ms |
# | Çağırıcı | Dosya ve satır sayısı |
---|---|---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:499 |
12 | DJClassifiedsCategory::getCategories() | JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:276 |
11 | DJClassifiedsCategory::getParentPath() | JROOT/components/com_djclassifieds/views/item/view.html.php:92 |
10 | DJclassifiedsViewItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djclassifieds/controllers/item.php:98 |
8 | DJClassifiedsControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:137 |
6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT i.cat_id, count(i.id) as items_count
FROM frm_djcf_items i
WHERE i.published=1
AND i.blocked=0
AND i.date_exp > '2021-01-24 15:00:00'
GROUP BY i.cat_id
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | i | ref | published,blocked | published | 4 | const | 3515 | Using where; Using temporary; Dosya sıralama kullanılıyor |
Status | Duration |
---|---|
Starting | 0.23 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.02 ms |
Init | 0.06 ms |
Optimizing | 0.04 ms |
Statistics | 0.14 ms |
Preparing | 0.05 ms |
Creating tmp table | 0.05 ms |
Sorting result | 0.02 ms |
Executing | 0.01 ms |
Sending data | 80.44 ms |
Creating sort index | 0.15 ms |
Removing tmp table | 0.09 ms |
Creating sort index | 0.02 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.03 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.13 ms |
Updating status | 0.69 ms |
Reset for next command | 0.02 ms |
# | Çağırıcı | Dosya ve satır sayısı |
---|---|---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
14 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:552 |
13 | DJClassifiedsCategory::getItemsCount() | JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:511 |
12 | DJClassifiedsCategory::getCategories() | JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:276 |
11 | DJClassifiedsCategory::getParentPath() | JROOT/components/com_djclassifieds/views/item/view.html.php:92 |
10 | DJclassifiedsViewItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djclassifieds/controllers/item.php:98 |
8 | DJClassifiedsControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:137 |
6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT ic.cat_id, count(ic.item_id) as items_count
FROM frm_djcf_items_categories ic, frm_djcf_items i
WHERE ic.item_id=i.id
AND i.published=1
AND i.blocked=0
AND i.date_exp > '2021-01-24 15:00:00'
GROUP BY ic.cat_id
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | NULL | NULL | NULL | HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
Status | Duration |
---|---|
Starting | 0.22 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.04 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
Table lock | 0.02 ms |
Init | 0.07 ms |
Optimizing | 0.05 ms |
Statistics | 0.13 ms |
Preparing | 0.02 ms |
Executing | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.01 ms |
Starting cleanup | 0.04 ms |
Freeing items | 0.12 ms |
Updating status | 2.85 ms |
Reset for next command | 0.02 ms |
# | Çağırıcı | Dosya ve satır sayısı |
---|---|---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:518 |
12 | DJClassifiedsCategory::getCategories() | JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:276 |
11 | DJClassifiedsCategory::getParentPath() | JROOT/components/com_djclassifieds/views/item/view.html.php:92 |
10 | DJclassifiedsViewItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djclassifieds/controllers/item.php:98 |
8 | DJClassifiedsControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:137 |
6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT r.*
FROM frm_djcf_regions r
WHERE published=1
ORDER BY r.parent_id
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | r | ALL | published | HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR | NULL | NULL | 1136 | Using where; Dosya sıralama kullanılıyor |
Status | Duration |
---|---|
Starting | 0.17 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
Table lock | 0.02 ms |
Init | 0.07 ms |
Optimizing | 0.02 ms |
Statistics | 0.06 ms |
Preparing | 0.04 ms |
Sorting result | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.02 ms |
Creating sort index | 10.25 ms |
End of update loop | 0.03 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.11 ms |
Updating status | 3.45 ms |
Reset for next command | 0.03 ms |
# | Çağırıcı | Dosya ve satır sayısı |
---|---|---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/components/com_djclassifieds/models/item.php:188 |
11 | DjclassifiedsModelItem->getRegions() | JROOT/components/com_djclassifieds/views/item/view.html.php:137 |
10 | DJclassifiedsViewItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djclassifieds/controllers/item.php:98 |
8 | DJClassifiedsControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:137 |
6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM frm_djcf_images
WHERE item_id = 866
AND type='profile'
LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | frm_djcf_images | ref | item_id,type | item_id | 4 | const | 1 | Using where |
Status | Duration |
---|---|
Starting | 0.21 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.02 ms |
Init | 0.07 ms |
Optimizing | 0.05 ms |
Statistics | 0.19 ms |
Preparing | 0.04 ms |
Executing | 0.01 ms |
Sending data | 0.03 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.09 ms |
Updating status | 0.05 ms |
Reset for next command | 0.02 ms |
# | Çağırıcı | Dosya ve satır sayısı |
---|---|---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
12 | JDatabaseDriver->loadObject() | JROOT/components/com_djclassifieds/models/item.php:221 |
11 | DjclassifiedsModelItem->getProfile() | JROOT/components/com_djclassifieds/views/item/view.html.php:173 |
10 | DJclassifiedsViewItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djclassifieds/controllers/item.php:98 |
8 | DJClassifiedsControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:137 |
6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT f.*, v.value, v.value_date
FROM frm_djcf_fields f
LEFT JOIN (SELECT *
FROM frm_djcf_fields_values_profile
WHERE user_id=866) v
ON v.field_id=f.id
WHERE f.published=1
AND f.source=2
AND f.in_item=1
AND f.access=0
ORDER BY f.ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | f | ref | published | published | 4 | const | 7 | Using where; Using temporary; Dosya sıralama kullanılıyor |
1 | SIMPLE | frm_djcf_fields_values_profile | ALL | NULL | HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR | NULL | NULL | 13 | Using where |
Status | Duration |
---|---|
Starting | 0.25 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.04 ms |
After opening tables | 0.01 ms |
System lock | 0.03 ms |
Table lock | 0.02 ms |
Init | 0.14 ms |
Optimizing | 0.05 ms |
Statistics | 0.10 ms |
Preparing | 0.06 ms |
Creating tmp table | 0.07 ms |
Sorting result | 0.03 ms |
Executing | 0.01 ms |
Sending data | 0.60 ms |
Creating sort index | 0.05 ms |
Removing tmp table | 0.14 ms |
Creating sort index | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Removing tmp table | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.08 ms |
Updating status | 0.06 ms |
Reset for next command | 0.01 ms |
# | Çağırıcı | Dosya ve satır sayısı |
---|---|---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/components/com_djclassifieds/models/item.php:228 |
11 | DjclassifiedsModelItem->getProfile() | JROOT/components/com_djclassifieds/views/item/view.html.php:173 |
10 | DJclassifiedsViewItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djclassifieds/controllers/item.php:98 |
8 | DJClassifiedsControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:137 |
6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM frm_djcf_profiles
WHERE user_id = 866
LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | NULL | NULL | NULL | HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
Status | Duration |
---|---|
Starting | 0.11 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.04 ms |
Optimizing | 0.02 ms |
Statistics | 0.03 ms |
Preparing | 0.01 ms |
Unlocking tables | 0.01 ms |
Preparing | 0.01 ms |
Executing | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.02 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.08 ms |
Updating status | 0.05 ms |
Reset for next command | 0.01 ms |
# | Çağırıcı | Dosya ve satır sayısı |
---|---|---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
12 | JDatabaseDriver->loadObject() | JROOT/components/com_djclassifieds/models/item.php:232 |
11 | DjclassifiedsModelItem->getProfile() | JROOT/components/com_djclassifieds/views/item/view.html.php:173 |
10 | DJclassifiedsViewItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djclassifieds/controllers/item.php:98 |
8 | DJClassifiedsControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:137 |
6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT f.*
FROM frm_djcf_fields f
WHERE f.published=1
AND f.source=3
ORDER BY f.ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | f | ref | published | published | 4 | const | 7 | Using where; Dosya sıralama kullanılıyor |
Status | Duration |
---|---|
Starting | 0.13 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.04 ms |
Optimizing | 0.02 ms |
Statistics | 0.04 ms |
Preparing | 0.03 ms |
Sorting result | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.03 ms |
Creating sort index | 0.12 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.10 ms |
Updating status | 0.05 ms |
Reset for next command | 0.01 ms |
# | Çağırıcı | Dosya ve satır sayısı |
---|---|---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/components/com_djclassifieds/models/item.php:278 |
11 | DjclassifiedsModelItem->getCustomAskSellerFields() | JROOT/components/com_djclassifieds/views/item/view.html.php:176 |
10 | DJclassifiedsViewItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djclassifieds/controllers/item.php:98 |
8 | DJClassifiedsControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:137 |
6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT r.*
FROM frm_djcf_regions r
ORDER BY r.parent_id, r.name COLLATE utf8_polish_ci
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | r | ALL | NULL |