Ana Menü

Duyurular

Sosyal Medya

Bir problemin çözümünü gerçeklerken, işlemcilerde en çok ihtiyaç duyduğumuz konulardan biri de zamanlayıcılardır. Belirli bir iş belirli zamanlarda yapılmak istendiğinde, o sürenin ölçümü için zamanlayıcılar kullanılır. Bu makalemde, Microchip firmasının üretmiş olduğu PIC18F2580 işlemcisi örnek alınarak, zamanlayıcılar ille nasıl işlem yapıldığını anlatacağım. PIC18F2580 işlemcisinin datasheet'ine buradan indirebilirisiniz. Yazılım geliştiriken kullanacağım platform MplabX ve yazılım dili de XC8'dir.

Kesme(Interrupt) Nedir?

Kesmeyi günlük bir olaydan örnek vererek anlatmaya çalışayım. Örneğin; evinizde yemek yapacaksınız ve hastanede de önem verdiğiniz biri var ve ondan da telefon bekliyorsunuz. Normalde işiniz yemek yapmak olduğu için, başladınız yemeğe ama kulağınız telefonda. Siz yemek yaparken biranda telefonunuz çaldı ve çalar çalmaz elinizdeki tüm işi bıraktınız ve telefonu açtınız. Telefonu kapattıktan sonra da kaldığınız yerden yemek yapmaya devam ettiniz. İşte burada yapmakta olduğunuz işi bir süre bıraktırıp, önceliği olan başka bir işe yönelme durumuna kesme adını veriyoruz. Yani telefonun çalması sizin hayatınızda bir kesme oluşturdu.

İşlemciler de rutin olarak yapması gerek işleri gerçekleştirirken daha önceden tanımlanmış olan önceliği yüksek bir durumla karşılaşıldığında, elindeki tüm işleri bırakıp o durum için tanımlanan işlemleri yapıp, daha sonra rutin işine kaldığı yerden devam eder. Burada işlemcinin rutin işini yarıda bırakıp, başka bir işe yönelmesi için gerçekleşen olaya kesme (interrupt) adını veriyoruz.

PIC18F2580'de 12 adet kesme bulunmakta ve bu kesmeler 10 farklı kayıtçı(register) ile kontrol edilmektedir:

RCON
INTCON
INTCON2
INTCON3
PIR1, PIR2, PIR3
PIE1, PIE2, PIE3
IPR1, IPR2, IPR3

Tüm kesmelerin aktif olabilmesi için INTCON kayıtçısının 7. biti olan GIE kayıtçısının değeri 1 olarak ayarlanmalıdır.

Zamanlayıcı Kesmesi

Belirli bir işi belirtilen bir zamanda yapmak için zamanlayıcı kesmesi kullanılır. Örneğin; butona basıldıktan 1. motor çalışsın, 5dk sonra 2. motor çalışsın, 15dk sonra 1. ve 2. motor durup 3. motor çalışmaya başlasın şeklinde bir problemle karşılaşabiliriz. Problemin içine zamanlayıcı girdiği için işlemcideki zamanlayıcı kesmelerini kullanırız. Tam 5dk. olduğunda işlemci tüm işini bırakıp, 2. motoru çalıştırmaya gider ve daha sonra da kaldığı yerden devam eder. 15dk. olduğunda da işlemci yine tüm işini bırakıp, 1. ve 2. motoru durdurur ve 3. motoru çalıştırır.

PIC18F2580 işlemcisinde 1 adet 8bit, 3 adet de 16bit olmak üzere toplamda 4 adet zamanlayıcı(timer) bulunur. Biz bu yazımızda Timer0 zamanlayıcı kesmesini kullanacağız.

Timer0 kesmesini kullanabilmek için öncelikle bazı ayarlamalar yapmamız gerekiyor:

T0CON: Timer 0 Control Register

T0CON kayıtçısı Timer 0'ın temel ayarlarının yapıldığı yerdir.

Timer0 zamanlayıcısının çalışabilmesi için herşeyden önce 7. bit olan TIMER0ON biti 1 yapılmalıdır.

T08BIT: Zamanlayıcımızı 8bitlik mi yoksa 16bitlik mi çalıştırmak istediğimizi seçiyoruz. Eğer 8bit seçersek zamanlayıcı hafızası(TMR0) değeri 255; 16bit seçersek de 65535 olur.

T0CS: Zamanlayıcının referans saatinin belirleneceği bit. İşlemciye dışarıdan bağlanan kristaller, işlemci içerisinden 4'te 1 oranından darbe oluşturabilirler. Yani 40MHz'lik bir kristal bağladığımızda, işlemcinin hızı 40/4=10MHz olarak hesaplanır.

T0SE: Zamanlayıcı içerisindeki sayacın yükselen kenarda mı yoksa düşen kenarda mı artacağını belirten bit.

PSA: Zamanlayıcının sayacındaki herbir artışı geciktirme kullanılıp kullanılmayacağını belirten bit. Bu ne demek? Örneğin; işlemcimize 4MHz'lik bir kristal bağladık. O zaman işlemcimizin hızı 1/(4MHz/4)=1us olur. Yani zamanlayıcının sayacı her 1us'de 1 artar. Eğer bir sayac değerini 2us'de bir arttırmak istersek, prescaler dediğimiz gecikme ayarını yapmamız gerekiyor.

T0PS<2:0>: Gecikme miktarının ayarlandığı bitler.

TMR0: İçerisinde sayaç değeri tutulan kayıtçıdır. Her bir adım aralığında içindeki değer bir artar. Ne zaman ki içerisindeki değer 0 oldu, o zaman kesme bayrağı 1 yapılır. Eğer zamanlayıcımızı 16bit olarak ayarlamışsak 65535'e kadar, 8bitlik ayarlamışsak da 255'e kadar sayar. TMR0 sayıcısının ilk 8bit'i TMR0L kayıtçısında, son 8biti de TMR0H kayıtçısında tutulur.

Timer0 Zamanlayıcısı Kesme Ayarı

Timer 0 zamanlayıcı kesmesini kurmak için INTCON kayıtçısından yararlanılmakta.

Timer0 zamanlayıcı kesmesi kurmak için şu adımlar izlenir:

T0CON kayıtçısını ayarla
TMR0H ve TMR0L değerlerini ayarla
INTCON kayıtçısının 5.biti olan TMR0IE bitini 1 yap
INTCON kayıtçısının 2.biti olan TMR0IF bitini 0 yap. TMR0IF biti 1 olduğunda işlemci kesmeye girer.
INTCON kayıtçısının 7. biti olan GIE/GIEH bitinin 1 yap. GIE/GIEH biti tüm kesmeleri aktif eder.

TMR0H ve TMR0L Ayarları

TMR0H ve TMR0L kayıtçılarının sayac değerinin tuttuğunu söylemiştik. TMR0 kayıtçısı değeri her 0 oluşunda TMR0IF bayrağı 1 yapılarak, işlemcinin kesmeye gitmesi sağlanır.

Peki bir işlemcinin adım aralığı nedir? Bir işlemcinin çalışabilmesi için zaman darbesine ihtiyaç vardır. İşlemci her bir komutu bu zaman darbesine göre gerçekleştirir. Bu zaman darbesi işlemciye bağlanan kristaller ile oluşturulur. Makalemin devamında, PIC18F2580 işlemcisine 40MHz kristal bağlanmış kabul edeceğiz.

Eğer timer0 zamanlayıcısı işlemciye bağlanan kristalin 4'te birini kullanır. 40MHz işlemcimiz için timer0 zamanlayıcısı 10MHz olarak çalışır. Eğer prescaler değeri aktif edilmemişse, TMR0 içerisindeki sayaç değeri, 1/10MHz = 100ns'de bir artacaktır.

Kesme süresi = TMR0 * Prescaler * ( 1/ (F_osc/4) )

Eğer biz her 10ms'de bir kesmeye girilmesini istersek, TMR0 sayacımızın sayma değerinin; 10ms/100ns = 100000(yüz bin)
olarak ayarlamalıyız. Ama timer0 kayıtçımız en fazla 65535 değerini alabildiği için bu mümkün değil. Bu yüzden prescaler özelliğini kullanmalıyız. Prescaler değerini 2 ayarlarsak, TMR0 kayıtçısının sayma değerini de 100000/2=50000 olarak ayarlayabiliriz. Burada unutulmaması gereken önemli bir kısım var.

Peki TMR0 kayıtçısının sayma değeri nedir? 16bitlik timer0 zamanlayıcısı için TMR0 kayıtçısı en fazla 65535 değerini alabileceği söylemiştik. TMR0 sayaç değeri her adım aralığında 1 artar. Sayaç değeri 65535 olduktan sonraki artışta, sayaç 0 olur ve TMR0IF bayrağı 1 yapılarak işlemci kesmeye gönderilir. Eğer biz TMR0 kayıtçısının 50000 sayıp, kesmeye girmesini istiyorsak, TMR0 değerini;
65535 - 50000 = 15535
olarak ayarlamalıyız. Bunun anlamı, TMR0 kayıtçısı içerisindeki sayaç 15535 değerinden başyalayacak ve 65535 olduktan sonra kesmeye gidecek.

Örnek Uygulama

Bu uygulamamızda; PIC18F2580 işlemcisinin RB7 pinine bağlı bir ledi 1sn açık, 1sn kapalı yapacak programı yazalım.

#include <xc.h>
#include<stdlib.h>

#define _XTAL_FREQ 40000000 //40MHz
#define LED PORTBbits.RB7

typedef unsigned int uint;
typedef unsigned char uchar;

uchar Sayac=0;
const uint TMR0_Sayac=50000;

void picAyar()
{
    TRISA = 0; 
	TRISB = 0; 
	TRISC = 0;

    PORTA = 0; 
    PORTB = 0;
	PORTC = 0;


    //Timer Kurulumu -- 10ms'de bir kesmeye girilecek
    T0CON = 0b10000000; //TIMER0 Aktif, PRESCALE= 1:2 (1/(40MHz / 4)*2 = 200nS)  *50000
    WRITETIMER0(65535-TMR0_Sayac); //10ms'de bir Timer0 kesmesine girilecek. TMR0 sayacına değer giriliyor.
    INTCONbits.TMR0IE=1;
    INTCONbits.TMR0IF=0;
    ei(); // Tüm kesmeler aktif edildi
}
void main(void)
{
    picAyar();
    while(1){}   
}

void interrupt kesmeler()
{
    di(); // Tüm kesmeler pasif
    if(INTCONbits.TMR0IE && INTCONbits.TMR0IF) // Timer-0 Kesmesi
    { 
        if(++Sayac >= 100)
        {// 1sn'de LED'i Tersle
            LED = ~LED;
            Sayac=0;
        }
        WRITETIMER0(65535-TMR0_Sayac);
        INTCONbits.TMR0IF=0;
    }
    ei(); // Tüm kesmeler aktif
}

Bir makalemin de sonua geldik. Bu makalemde işlemcilerde en çok ihtiyaç duyulan zamanlayıcı kesmesi hakkında temel bir bilgi vermeye çalıştım. Umarım sizler için faydalı bir yazı olmuştur.

Bir sonraki makalemde görüşünceye dek, sağlıcakla kalın.

Muhammet EFE

Yorumlar

0 # Serhat Evcim 06-01-2015 16:10

Emeğine sağlık kardeşim , her zaman olduğu gibi çok faydalı bir döküman. Birçok kişinin işine yarayacaktır.

Sevgiler :)

Cevap

0 # Mert 22-01-2015 20:39

Güzel bir makale daha. Emeğiniz ve ilginiz için teşekkür ederim.

Cevap

0 # cem üstün 29-04-2017 18:43

PIC in herhangibir pinine metal bir cisimle dokunduğumuzda PIC reset atıyor veya INT0 kesmesi aktif ise PIC kesmeye giriyor. bu sorun nasıl aşılır , klasik yöntemler den biri PIC voltaj uçlarına küçük degerlilkli kapasite koymak ,fakat bu çözüm değil , INT0 kesmesi daha hassas ve duyarlı , aynı şebeke hattına temas olsa bile PIC kesmeye giriyor, program veya donanım nasıl bir çözüm bulunmalı

Cevap

Yorum listesini yenile
RSS beslemesi, bu iletideki yorumlar için

Yorum ekle

JComments

Joomla Hata Ayıklama Konsolu

Oturum

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1695936692,
                "last": 1695936692,
                "now": 1695936692
            },
            "token": "YbAklrMl3AXOmK1ZTnj0aiJEHAp6vcvz"
        },
        "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
        }
    }
}

Profil Bilgisi

Süre

Bellek

Süre: 5.00 ms / 5.00 ms Bellek: 0.488 MB / 0.87 MB Application: afterLoad

Süre: 29.91 ms / 34.91 ms Bellek: 0.887 MB / 1.76 MB Application: afterInitialise

Süre: 19.72 ms / 54.63 ms Bellek: 0.422 MB / 2.18 MB Application: afterRoute

Süre: 1.97 ms / 56.60 ms Bellek: 0.065 MB / 2.24 MB Application: beforeRenderComponent com_content

Süre: 2.45 ms / 59.05 ms Bellek: 0.115 MB / 2.36 MB Application: Before Access::preloadComponents (all components)

Süre: 1.90 ms / 60.95 ms Bellek: 0.055 MB / 2.41 MB Application: After Access::preloadComponents (all components)

Süre: 0.04 ms / 60.99 ms Bellek: 0.000 MB / 2.41 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Süre: 0.29 ms / 61.28 ms Bellek: 0.009 MB / 2.42 MB Application: After Access::getAssetRules (id:8 name:com_content)

Süre: 49.72 ms / 111.00 ms Bellek: 0.469 MB / 2.89 MB Application: Before Access::preloadPermissions (com_content)

Süre: 2.15 ms / 113.15 ms Bellek: 0.066 MB / 2.96 MB Application: After Access::preloadPermissions (com_content)

Süre: 0.04 ms / 113.19 ms Bellek: 0.000 MB / 2.95 MB Application: Before Access::getAssetRules (id:103 name:com_content.article.29)

Süre: 0.10 ms / 113.28 ms Bellek: 0.007 MB / 2.96 MB Application: After Access::getAssetRules (id:103 name:com_content.article.29)

Süre: 38.13 ms / 151.41 ms Bellek: 0.300 MB / 3.26 MB Application: afterRenderComponent com_content

Süre: 0.68 ms / 152.09 ms Bellek: 0.009 MB / 3.27 MB Application: afterDispatch

Süre: 10.29 ms / 162.38 ms Bellek: 0.051 MB / 3.32 MB Application: beforeRenderModule mod_menu (Ana Menü)

Süre: 5.16 ms / 167.54 ms Bellek: 0.178 MB / 3.50 MB Application: afterRenderModule mod_menu (Ana Menü)

Süre: 0.06 ms / 167.60 ms Bellek: 0.000 MB / 3.50 MB Application: beforeRenderModule mod_articles_latest (Duyurular)

Süre: 5.83 ms / 173.42 ms Bellek: 0.091 MB / 3.59 MB Application: afterRenderModule mod_articles_latest (Duyurular)

Süre: 0.05 ms / 173.48 ms Bellek: 0.000 MB / 3.54 MB Application: beforeRenderModule mod_nice_social_bookmark (Sosyal Medya)

Süre: 0.60 ms / 174.07 ms Bellek: 0.011 MB / 3.55 MB Application: afterRenderModule mod_nice_social_bookmark (Sosyal Medya)

Süre: 0.07 ms / 174.14 ms Bellek: 0.000 MB / 3.55 MB Application: beforeRenderModule mod_rokajaxsearch (Arama)

Süre: 1.61 ms / 175.75 ms Bellek: 0.011 MB / 3.56 MB Application: afterRenderModule mod_rokajaxsearch (Arama)

Süre: 0.07 ms / 175.82 ms Bellek: 0.000 MB / 3.56 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Süre: 30.92 ms / 206.74 ms Bellek: 0.014 MB / 3.57 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Süre: 0.12 ms / 206.86 ms Bellek: 0.000 MB / 3.57 MB Application: beforeRenderModule mod_menu (Main Menü)

Süre: 1.32 ms / 208.17 ms Bellek: 0.005 MB / 3.57 MB Application: afterRenderModule mod_menu (Main Menü)

Süre: 3.36 ms / 211.53 ms Bellek: 0.119 MB / 3.69 MB Application: afterRender

Veritabanı sorguları toplamı: 45.61 ms

Bellek Kullanımı

Veritabanı Sorguları

32 Sorgu Kaydedildi 45.61 ms

Sorgu Süresi: 1.34 ms Sorgu belleği: 0.023 MB belleği şu sorgudan önce: 1.167 MB Dönen satır: 0

SELECT `data`

  FROM `mysite_session`

  WHERE `session_id` = '420a2c0ae7d22f2e9d48e79ef1b26d2b'

Açıkla

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

Profil

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

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
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:755
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
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:343
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

Sorgu Süresi: 0.38 ms Son sorgudan sonra: 0.58 ms Sorgu belleği: 0.020 MB belleği şu sorgudan önce: 1.245 MB Dönen satır: 0

SELECT `session_id`

  FROM `mysite_session`

  WHERE `session_id` = '420a2c0ae7d22f2e9d48e79ef1b26d2b' 
  LIMIT 1

Açıkla

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

Profil

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

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:152
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:757
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
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:343
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

Sorgu Süresi: 0.43 ms Son sorgudan sonra: 0.11 ms Sorgu belleği: 0.004 MB belleği şu sorgudan önce: 1.251 MB

INSERT INTO `mysite_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('420a2c0ae7d22f2e9d48e79ef1b26d2b', 1, '1695936692', 0, '', 0)

Açıkla

Şu sorgudaki olamayacakları AÇIKLA: INSERT INTO `mysite_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('420a2c0ae7d22f2e9d48e79ef1b26d2b', 1, '1695936692', 0, '', 0)

Profil

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

Yığın Çağır

#	Ç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:152
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:757
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
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:343
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

Sorgu Süresi: 1.83 ms Son sorgudan sonra: 0.92 ms Sorgu belleği: 0.024 MB belleği şu sorgudan önce: 1.286 MB Dönen satır: 38

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `mysite_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

Açıkla

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `mys' at line 1

Profil

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

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:425
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Aşağıdaki satırda bulunan çağrı gibi.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:433
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:499
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:596
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

Sorgu Süresi: 0.96 ms Son sorgudan sonra: 1.17 ms Sorgu belleği: 0.021 MB belleği şu sorgudan önce: 1.316 MB Dönen satır: 3

SELECT id, rules

  FROM `mysite_viewlevels`

Açıkla

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

Profil

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

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1496
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:606
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

Sorgu Süresi: 0.83 ms Son sorgudan sonra: 0.13 ms Sorgu belleği: 0.021 MB belleği şu sorgudan önce: 1.327 MB Dönen satır: 1

SELECT b.id

  FROM mysite_usergroups AS a

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

  WHERE a.id = 1

Açıkla

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT b.id FROM #__usergroups AS a LEFT JOIN #__usergroups AS b ON b.lf' at line 1

Profil

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

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
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:606
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

Sorgu Süresi: 2.02 ms Son sorgudan sonra: 0.35 ms Sorgu belleği: 0.030 MB belleği şu sorgudan önce: 1.350 MB Dönen satır: 81

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

  FROM mysite_extensions

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

  ORDER BY ordering

Açıkla

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id' at line 1

Profil

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

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Aşağıdaki satırda bulunan çağrı gibi.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
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:606
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

Sorgu Süresi: 1.64 ms Son sorgudan sonra: 6.58 ms Sorgu belleği: 0.044 MB belleği şu sorgudan önce: 1.848 MB Dönen satır: 13

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM mysite_menu AS m

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

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

  ORDER BY m.lft

Açıkla

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.ty' at line 1

Profil

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

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Aşağıdaki satırda bulunan çağrı gibi.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:374
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:488
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:405
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1070
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

Sorgu Süresi: 1.55 ms Son sorgudan sonra: 3.24 ms Sorgu belleği: 0.024 MB belleği şu sorgudan önce: 1.983 MB Dönen satır: 3

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

  FROM `mysite_categories` AS `s`

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

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

  ORDER BY c.lft

Açıkla

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, ' at line 1

Profil

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

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:312
12	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
11	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/helpers/legacyrouter.php:350
10	ContentRouterRulesLegacy->parse()	JROOT/libraries/src/Component/Router/RouterView.php:266
9	Joomla\CMS\Component\Router\RouterView->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
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:1071
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

Sorgu Süresi: 1.25 ms Son sorgudan sonra: 0.25 ms Sorgu belleği: 0.021 MB belleği şu sorgudan önce: 2.067 MB Dönen satır: 1

SELECT `alias`,`catid`

  FROM `mysite_content`

  WHERE `id` = 29

Açıkla

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `alias`,`catid` FROM `#__content` WHERE `id` = 29' at line 1

Profil

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

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
11	JDatabaseDriver->loadObject()	JROOT/components/com_content/helpers/legacyrouter.php:366
10	ContentRouterRulesLegacy->parse()	JROOT/libraries/src/Component/Router/RouterView.php:266
9	Joomla\CMS\Component\Router\RouterView->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
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:1071
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

Sorgu Süresi: 0.81 ms Son sorgudan sonra: 0.93 ms Sorgu belleği: 0.024 MB belleği şu sorgudan önce: 2.107 MB Dönen satır: 1

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `mysite_extensions`

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

Açıkla

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `mys' at line 1

Profil

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

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Aşağıdaki satırda bulunan çağrı gibi.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
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/jcomments/jcomments.php:111
8	plgSystemJComments->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:1080
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

Sorgu Süresi: 0.46 ms Son sorgudan sonra: 0.17 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 2.100 MB

UPDATE `mysite_extensions`

  SET `params` = '{\"mediaversion\":\"4e78e84ab270b52228025b79c93e1162\"}'

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

Açıkla

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UPDATE `#__extensions` SET `params` = '{\"mediaversion\":\"4e78e84ab270b5222' at line 1

Profil

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

Yığın Çağır

#	Ç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/jcomments/jcomments.php:111
8	plgSystemJComments->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:1080
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

Sorgu Süresi: 1.42 ms Son sorgudan sonra: 5.43 ms Sorgu belleği: 0.032 MB belleği şu sorgudan önce: 2.149 MB Dönen satır: 91

SELECT *

  FROM `mysite_jcomments_settings`

  WHERE `lang` = '' 
  AND `component` = ''

Açıkla

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

Profil

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

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jcomments/classes/config.php:140
14	JCommentsCfg::_load()	Aşağıdaki satırda bulunan çağrı gibi.
13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/components/com_jcomments/classes/config.php:159
11	JCommentsCfg->load()	JROOT/components/com_jcomments/classes/config.php:47
10	JCommentsCfg::getInstance()	JROOT/components/com_jcomments/helpers/system.php:39
9	JCommentsSystemPluginHelper::getCSS()	JROOT/plugins/system/jcomments/jcomments.php:139
8	plgSystemJComments->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:1080
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

Sorgu Süresi: 0.98 ms Son sorgudan sonra: 0.62 ms Sorgu belleği: 0.022 MB belleği şu sorgudan önce: 2.154 MB Dönen satır: 7

SELECT id, home, template, s.params

  FROM mysite_template_styles as s

  LEFT JOIN mysite_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

Açıkla

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT id, home, template, s.params FROM #__template_styles as s LEFT JOIN m' at line 1

Profil

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

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:488
10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/components/com_jcomments/helpers/system.php:46
9	JCommentsSystemPluginHelper::getCSS()	JROOT/plugins/system/jcomments/jcomments.php:139
8	plgSystemJComments->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:1080
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

Sorgu Süresi: 0.86 ms Son sorgudan sonra: 0.62 ms Sorgu belleği: 0.019 MB belleği şu sorgudan önce: 2.192 MB Dönen satır: 1

SELECT *

  FROM mysite_languages

  WHERE published=1

  ORDER BY ordering ASC

Açıkla

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM #__languages WHERE published=1 ORDER BY ordering ASC' at line 1

Profil

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

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

Sorgu Süresi: 1.46 ms Son sorgudan sonra: 3.42 ms Sorgu belleği: 0.027 MB belleği şu sorgudan önce: 2.363 MB Dönen satır: 38

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `mysite_assets`

  WHERE `name` IN ('root.1','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_ckeditor','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_foxcontact','com_installer','com_jcomments','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper','com_xcloner-backupandrestore')

Açıkla

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `id`,`name`,`rules`,`parent_id` FROM `#__assets` WHERE `name` IN ('ro' at line 1

Profil

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

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
16	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:55
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:248
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

Sorgu Süresi: 2.50 ms Son sorgudan sonra: 1.54 ms Sorgu belleği: 0.032 MB belleği şu sorgudan önce: 2.425 MB Dönen satır: 30

SHOW FULL COLUMNS 
  FROM `mysite_content`

Açıkla

Şu sorgudaki olamayacakları AÇIKLA: SHOW FULL COLUMNS FROM `mysite_content`

Profil

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

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:441
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
12	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
11	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:312
10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_content/models/article.php:250
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

Sorgu Süresi: 0.49 ms Son sorgudan sonra: 3.03 ms Sorgu belleği: 0.038 MB belleği şu sorgudan önce: 2.477 MB Dönen satır: 1

SELECT *

  FROM mysite_content

  WHERE `id` = '29'

Açıkla

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

Profil

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

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
10	Joomla\CMS\Table\Table->load()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

Sorgu Süresi: 0.54 ms Son sorgudan sonra: 0.13 ms Sorgu belleği: 0.005 MB belleği şu sorgudan önce: 2.497 MB

UPDATE mysite_content

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

  WHERE `id` = '29'

Açıkla

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UPDATE #__content SET `hits` = (`hits` + 1) WHERE `id` = '29'' at line 1

Profil

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

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1242
10	Joomla\CMS\Table\Table->hit()	JROOT/components/com_content/models/article.php:252
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

Sorgu Süresi: 1.87 ms Son sorgudan sonra: 1.79 ms Sorgu belleği: 0.038 MB belleği şu sorgudan önce: 2.584 MB Dönen satır: 1

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

  FROM mysite_content AS a

  INNER JOIN mysite_categories AS c 
  on c.id = a.catid

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

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

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

  WHERE a.id = 29 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-09-28 21:31:33') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-09-28 21:31:33') 
  AND (a.state = 1 OR a.state =2)

Açıkla

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.c' at line 1

Profil

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

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
13	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:148
12	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:423
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

Sorgu Süresi: 0.83 ms Son sorgudan sonra: 2.61 ms Sorgu belleği: 0.028 MB belleği şu sorgudan önce: 2.629 MB Dönen satır: 4

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

  FROM `mysite_categories` AS `s`

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

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

  ORDER BY c.lft

Açıkla

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, ' at line 1

Profil

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

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:312
21	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
20	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
19	ContentRouter->getCategorySegment()	Aşağıdaki satırda bulunan çağrı gibi.
18	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
17	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
16	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
15	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
14	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
13	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
12	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
11	Joomla\CMS\Router\Route::_()	JROOT/components/com_content/views/article/view.html.php:71
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

Sorgu Süresi: 2.42 ms Son sorgudan sonra: 0.50 ms Sorgu belleği: 0.022 MB belleği şu sorgudan önce: 2.658 MB Dönen satır: 0

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

  FROM `mysite_contentitem_tag_map` AS m 

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

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

Açıkla

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `m`.`tag_id`,`t`.* FROM `#__contentitem_tag_map` AS m INNER JOIN `my' at line 1

Profil

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

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
11	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/views/article/view.html.php:184
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

Sorgu Süresi: 3.60 ms Son sorgudan sonra: 12.37 ms Sorgu belleği: 0.025 MB belleği şu sorgudan önce: 2.779 MB Dönen satır: 0

SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM mysite_fields AS a

  LEFT JOIN `mysite_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN mysite_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN mysite_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN mysite_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN mysite_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `mysite_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (34,0,26,10)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Açıkla

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state' at line 1

Profil

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

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
16	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:479
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

Sorgu Süresi: 1.76 ms Son sorgudan sonra: 16.42 ms Sorgu belleği: 0.030 MB belleği şu sorgudan önce: 2.893 MB Dönen satır: 59

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `mysite_assets`

  WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0

Açıkla

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `id`,`name`,`rules`,`parent_id` FROM `#__assets` WHERE `name` LIKE 'c' at line 1

Profil

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

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
18	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
17	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
14	Joomla\CMS\User\User->authorise()	JROOT/plugins/content/pagenavigation/pagenavigation.php:54
13	PlgContentPagenavigation->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:199
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

Sorgu Süresi: 0.96 ms Son sorgudan sonra: 0.55 ms Sorgu belleği: 0.023 MB belleği şu sorgudan önce: 2.971 MB Dönen satır: 4

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

  FROM mysite_content AS a

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

  WHERE a.catid = 34 
  AND a.state = 1 
  AND a.access IN (1,1)  
  AND (a.state = 1 OR a.state = -1) 
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2023-09-28 21:31:33') 
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2023-09-28 21:31:33')

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

Açıkla

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT a.id, a.title, a.catid, a.language, CASE WHEN CHAR_LENGTH(a.alias) != 0 T' at line 1

Profil

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

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
14	JDatabaseDriver->loadObjectList()	JROOT/plugins/content/pagenavigation/pagenavigation.php:159
13	PlgContentPagenavigation->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:199
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

Sorgu Süresi: 1.22 ms Son sorgudan sonra: 13.88 ms Sorgu belleği: 0.025 MB belleği şu sorgudan önce: 3.059 MB Dönen satır: 1

SELECT COUNT(*)

  FROM `mysite_jcomments_blacklist`

  WHERE `ip` = '44.200.101.84' OR `ip` = '44.200.101.*' OR `ip` = '44.200.*.*' OR `ip` = '44.*.*.*'

Açıkla

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT COUNT(*) FROM `#__jcomments_blacklist` WHERE `ip` = '44.200.101.84' O' at line 1

Profil

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

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
19	JDatabaseDriver->loadResult()	JROOT/components/com_jcomments/classes/security.php:154
18	JCommentsSecurity::checkBlacklist()	JROOT/components/com_jcomments/classes/acl.php:76
17	JCommentsACL->JCommentsACL()	JROOT/components/com_jcomments/classes/factory.php:274
16	JCommentsFactory::getACL()	JROOT/components/com_jcomments/jcomments.php:190
15	JComments::show()	JROOT/plugins/content/jcomments/jcomments.php:280
14	plgContentJComments->onAfterDisplayContent()	JROOT/plugins/content/jcomments/jcomments.php:337
13	plgContentJComments->onContentAfterDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:202
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

Sorgu Süresi: 1.40 ms Son sorgudan sonra: 1.39 ms Sorgu belleği: 0.027 MB belleği şu sorgudan önce: 3.105 MB Dönen satır: 1

SELECT *  
  FROM `mysite_jcomments_objects` 
  WHERE `object_id` = '29' 
  AND `object_group` = 'com_content' 
  AND `lang` = 'tr-TR'

Açıkla

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM `#__jcomments_objects` WHERE `object_id` = '29' AND `object_g' at line 1

Profil

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

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
23	JDatabaseDriver->loadObject()	JROOT/components/com_jcomments/models/object.php:28
22	JCommentsModelObject::getObjectInfo()	JROOT/components/com_jcomments/helpers/object.php:117
21	JCommentsObjectHelper::fetchObjectInfo()	Aşağıdaki satırda bulunan çağrı gibi.
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/components/com_jcomments/helpers/object.php:159
18	JCommentsObjectHelper::getObjectInfo()	JROOT/components/com_jcomments/helpers/object.php:46
17	JCommentsObjectHelper::getLink()	JROOT/components/com_jcomments/classes/factory.php:255
16	JCommentsFactory::getTemplate()	JROOT/components/com_jcomments/jcomments.php:194
15	JComments::show()	JROOT/plugins/content/jcomments/jcomments.php:280
14	plgContentJComments->onAfterDisplayContent()	JROOT/plugins/content/jcomments/jcomments.php:337
13	plgContentJComments->onContentAfterDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:202
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

Sorgu Süresi: 2.39 ms Son sorgudan sonra: 0.60 ms Sorgu belleği: 0.025 MB belleği şu sorgudan önce: 3.087 MB Dönen satır: 1

SELECT count(*)

  FROM mysite_jcomments AS c

  WHERE c.object_id = 29 
  AND c.object_group = 'com_content' 
  AND c.published = 1

Açıkla

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT count(*) FROM #__jcomments AS c WHERE c.object_id = 29 AND c.object_g' at line 1

Profil

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

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
18	JDatabaseDriver->loadResult()	JROOT/components/com_jcomments/models/jcomments.php:35
17	JCommentsModel::getCommentsCount()	JROOT/components/com_jcomments/jcomments.php:1306
16	JComments::getCommentsCount()	JROOT/components/com_jcomments/jcomments.php:224
15	JComments::show()	JROOT/plugins/content/jcomments/jcomments.php:280
14	plgContentJComments->onAfterDisplayContent()	JROOT/plugins/content/jcomments/jcomments.php:337
13	plgContentJComments->onContentAfterDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:202
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

Sorgu Süresi: 1.41 ms Son sorgudan sonra: 0.25 ms Sorgu belleği: 0.026 MB belleği şu sorgudan önce: 3.100 MB Dönen satır: 3

SELECT c.id, c.parent, c.object_id, c.object_group, c.userid, c.name, c.username, c.title, c.comment
, c.email, c.homepage, c.date, c.date as datetime, c.ip, c.published, c.deleted, c.checked_out, c.checked_out_time
, c.isgood, c.ispoor
, v.value as voted
, 
  case when c.parent = 0 then unix_timestamp(c.date) else 0 end as threaddate, '' AS object_title, '' AS object_link, 0 AS object_access, 0 AS object_owner

  FROM mysite_jcomments AS c

  LEFT JOIN mysite_jcomments_votes AS v 
  ON c.id = v.commentid  
  AND v.userid = 0 
  AND v.ip = '44.200.101.84'

  WHERE c.object_id = 29 
  AND c.object_group = 'com_content' 
  AND c.published = 1

  ORDER BY c.parent, c.date ASC

Açıkla

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT c.id, c.parent, c.object_id, c.object_group, c.userid, c.name, c.username' at line 1

Profil

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

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
18	JDatabaseDriver->loadObjectList()	JROOT/components/com_jcomments/models/jcomments.php:80
17	JCommentsModel::getCommentsList()	JROOT/components/com_jcomments/jcomments.php:792
16	JComments::getCommentsTree()	JROOT/components/com_jcomments/jcomments.php:269
15	JComments::show()	JROOT/plugins/content/jcomments/jcomments.php:280
14	plgContentJComments->onAfterDisplayContent()	JROOT/plugins/content/jcomments/jcomments.php:337
13	plgContentJComments->onContentAfterDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:202
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

Sorgu Süresi: 2.55 ms Son sorgudan sonra: 18.49 ms Sorgu belleği: 0.024 MB belleği şu sorgudan önce: 3.312 MB Dönen satır: 6

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

  FROM mysite_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-09-28 21:31:33') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-09-28 21:31:33') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 139 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Açıkla

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm' at line 1

Profil

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

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
15	JDatabaseDriver->loadObjectList()	Aşağıdaki satırda bulunan çağrı gibi.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:433
12	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:363
11	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
10	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
9	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/allrounder-3/head_includes.php:79
8	require JROOT/templates/allrounder-3/head_includes.php	JROOT/templates/allrounder-3/index.php:8
7	require JROOT/templates/allrounder-3/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1027
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

Sorgu Süresi: 2.27 ms Son sorgudan sonra: 10.67 ms Sorgu belleği: 0.041 MB belleği şu sorgudan önce: 3.532 MB Dönen satır: 3

SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating, 
							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count

  FROM mysite_content AS a

  LEFT JOIN mysite_categories AS c 
  ON c.id = a.catid

  LEFT JOIN mysite_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN mysite_users AS uam 
  ON uam.id = a.modified_by

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

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

  WHERE a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND a.state = 1 
  AND a.catid IN (17) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-09-28 21:31:33') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-09-28 21:31:33')

  ORDER BY a.created DESC 
  LIMIT 5

Açıkla

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked' at line 1

Profil

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

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:559
12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_latest/helper.php:118
11	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
10	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

Sorgu Süresi: 1.17 ms Son sorgudan sonra: 0.52 ms Sorgu belleği: 0.027 MB belleği şu sorgudan önce: 3.596 MB Dönen satır: 2

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

  FROM `mysite_categories` AS `s`

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

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

  ORDER BY c.lft

Açıkla

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, ' at line 1

Profil

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

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:312
22	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
21	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
20	ContentRouter->getCategorySegment()	Aşağıdaki satırda bulunan çağrı gibi.
19	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
18	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
17	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
16	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
15	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
12	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_articles_latest/helper.php:130
11	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
10	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

28 sorgu türü kayıt altına alındı, yinelemeye göre tersten sıralandı.

Seçili Tablolar:

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

2 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `mysite_assets`

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

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

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

1 × SELECT c.id, c.parent, c.object_id, c.object_group, c.userid, c.name, c.username, c.title, c.comment , c.email, c.homepage, c.date, c.date as datetime, c.ip, c.published, c.deleted, c.checked_out, c.checked_out_time , c.isgood, c.ispoor , v.value as voted , 
  case when c.parent = 0 then unix_timestamp(c.date) else 0 end as threaddate, '' AS object_title, '' AS object_link, 0 AS object_access, 0 AS object_owner 
  FROM mysite_jcomments AS c 
  LEFT JOIN mysite_jcomments_votes AS v 
  ON c.id = v.commentid  
  AND v.userid = 0 
  AND v.ip = '44.200.101.84'

1 × SELECT count(*) 
  FROM mysite_jcomments AS c

1 × SELECT *  
  FROM `mysite_jcomments_objects`

1 × SELECT COUNT(*) 
  FROM `mysite_jcomments_blacklist`

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

1 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM mysite_fields AS a 
  LEFT JOIN `mysite_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN mysite_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN mysite_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN mysite_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN mysite_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `mysite_fields_categories` AS fc 
  ON fc.field_id = a.id

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

1 × SELECT `data` 
  FROM `mysite_session`

```
1 × SELECT * 
  FROM mysite_content
```

1 × SELECT `session_id` 
  FROM `mysite_session`

```
1 × SELECT * 
  FROM mysite_languages
```

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

1 × SELECT * 
  FROM `mysite_jcomments_settings`

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

1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM mysite_menu AS m 
  LEFT JOIN mysite_extensions AS e 
  ON m.component_id = e.extension_id

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

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

1 × SELECT id, rules 
  FROM `mysite_viewlevels

1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,         COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count 
  FROM mysite_content AS a 
  LEFT JOIN mysite_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN mysite_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN mysite_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN mysite_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN mysite_content_rating AS v 
  ON a.id = v.content_id

Diğer Tablolar:

1 × INSERT INTO `mysite_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('420a2c0ae7d22f2e9d48e79ef1b26d2b', 1, '1695936692', 0, '', 0

1 × UPDATE `mysite_extensions` 
  SET `params` = '{\"mediaversion\":\"4e78e84ab270b52228025b79c93e1162\"}'

1 × SHOW FULL COLUMNS 
  FROM `mysite_content

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

Ana Menü

Duyurular

Sosyal Medya

PIC18F2580 İle Zamanlayıcılar

Kesme(Interrupt) Nedir?

Zamanlayıcı Kesmesi

T0CON: Timer 0 Control Register

Timer0 Zamanlayıcısı Kesme Ayarı

TMR0H ve TMR0L Ayarları

Örnek Uygulama

Yorumlar

Yorum ekle

Joomla Hata Ayıklama Konsolu

Oturum

Profil Bilgisi

Süre

Bellek

Bellek Kullanımı

Veritabanı Sorguları

32 Sorgu Kaydedildi 45.61 ms

28 sorgu türü kayıt altına alındı, yinelemeye göre tersten sıralandı.

Seçili Tablolar:

Diğer Tablolar: