0.0014 |
SELECT `bg_ayarlar_liste`.`ayar`, `bg_ayarlar_veri`.`deger` FROM (`bg_ayarlar_liste`) LEFT JOIN `bg_ayarlar_veri` ON `bg_ayarlar_veri`.`ayar` = `bg_ayarlar_liste`.`ayar` WHERE `bg_ayarlar_liste`.`otomatik` = 1
|
0.0002 |
SELECT * FROM (`bg_ayarlar`) WHERE `ayar` = 'ucuz_urun'
|
0.0001 |
SELECT * FROM (`bg_ayarlar`) WHERE `ayar` = 'usd_kur'
|
0.0002 |
SELECT * FROM (`bg_ayarlar`) WHERE `ayar` = 'eur_kur'
|
0.0005 |
SELECT * FROM (`bg_kategoriler`) WHERE `durum` = 1 ORDER BY `pozisyon` ASC
|
0.0002 |
SELECT * FROM (`bg_gruplar`) WHERE `durum` = 1 ORDER BY `pozisyon` ASC
|
0.0002 |
SELECT * FROM (`bg_urunler_ozellik`) ORDER BY `sira` ASC, `yuklenme_zamani` DESC
|
0.0003 |
SELECT * FROM (`bg_uyeler`) WHERE `mail` = '' AND `sifre` = '' AND `durum` = 1
|
0.0002 |
SELECT * FROM (`bg_urun_renkleri`)
|
0.0002 |
SELECT * FROM (`bg_sayfa_icerik`) WHERE `url_baslik` = 'slogan_ziyaretci' AND `durum` = 1
|
0.0002 |
SELECT * FROM (`bg_kutular`) WHERE `gorunurluk` IN ('herkes', 'uye_olmayanlar') ORDER BY `sira` ASC
|
0.0001 |
SELECT * FROM (`bg_ayarlar_veri`) WHERE `ayar` = 'KATEGORI_GOSTERIM'
|
0.0002 |
SELECT * FROM (`bg_kategoriler`) WHERE `id` = 333
|
0.0142 |
select kisa_aciklama from bg_urunler where kategori_id = 333 and stok_adet > min_stok_miktar and durum = 1 group by kisa_aciklama
|
0.0002 |
SELECT * FROM (`bg_sayfa_icerik`) WHERE `url_baslik` = 'kategori_ust_kisim_ziyaretci' AND `durum` = 1
|
0.0002 |
SELECT * FROM (`bg_sayfa_icerik`) WHERE `url_baslik` = 'kategori_alt_kisim_ziyaretci' AND `durum` = 1
|
0.0002 |
SELECT * FROM (`bg_ayarlar_veri`) WHERE `ayar` IN ('SERSEO_KATEGORI_BASLIK', 'SERSEO_KATEGORI_KEYWORDS', 'SERSEO_KATEGORI_DESC')
|
0.0037 |
SELECT COUNT(DISTINCT bg_T1.id) AS adet FROM (`bg_urunler` bg_T1) INNER JOIN `bg_filtre` F5 ON `bg_T1`.`id` = `F5`.`urun_id` INNER JOIN `bg_filtre` F6 ON `bg_T1`.`id` = `F6`.`urun_id` WHERE (F5.grup_id='2930') AND (F6.grup_id='838' OR F6.grup_id='833' OR F6.grup_id='153' OR F6.grup_id='827') AND `stok_adet` > min_stok_miktar AND `kategori_id` = 333 AND `durum` = 1 AND `dosya` <> '' ORDER BY `fiyat` DESC
|
0.0044 |
SELECT * FROM (`bg_urunler` bg_T1) INNER JOIN `bg_filtre` F5 ON `bg_T1`.`id` = `F5`.`urun_id` INNER JOIN `bg_filtre` F6 ON `bg_T1`.`id` = `F6`.`urun_id` WHERE (F5.grup_id='2930') AND (F6.grup_id='838' OR F6.grup_id='833' OR F6.grup_id='153' OR F6.grup_id='827') AND `stok_adet` > min_stok_miktar AND `kategori_id` = 333 AND `durum` = 1 AND `dosya` <> '' GROUP BY `bg_T1`.`id` ORDER BY `fiyat` DESC, `bg_T1`.`id` DESC LIMIT 40
|
0.0275 |
SELECT `bg_filtre_grup`.*, `bg_filtre_ana_grup`.`deger` AS ana_deger, `bg_filtre_ana_grup`.`deger_ru` AS ana_deger_ru, `bg_filtre_ana_grup`.`deger_en` AS ana_deger_en, `bg_filtre_ana_grup`.`deger_ar` AS ana_deger_ar FROM (`bg_filtre_grup`) LEFT JOIN `bg_filtre_ana_grup` ON `bg_filtre_ana_grup`.`id` = `bg_filtre_grup`.`ana_grup_id`
where bg_filtre_grup.id IN
(
select distinct bg_filtre.grup_id from bg_filtre
RIGHT JOIN
(
SELECT `bg_T1`.`id` FROM (`bg_urunler` bg_T1) WHERE `stok_adet` > min_stok_miktar AND `kategori_id` = 333 AND `durum` = 1 AND `dosya` <> '' ORDER BY `fiyat` DESC
)
AS filtre_sonuc_liste ON bg_filtre.`urun_id` = filtre_sonuc_liste.id
)
ORDER BY `ana_grup_id` ASC, pozisyon ASC, `deger` ASC
|
0.0264 |
SELECT `bg_filtre_grup`.*, `bg_filtre_ana_grup`.`deger` AS ana_deger, `bg_filtre_ana_grup`.`deger_ru` AS ana_deger_ru, `bg_filtre_ana_grup`.`deger_en` AS ana_deger_en, `bg_filtre_ana_grup`.`deger_ar` AS ana_deger_ar FROM (`bg_filtre_grup`) LEFT JOIN `bg_filtre_ana_grup` ON `bg_filtre_ana_grup`.`id` = `bg_filtre_grup`.`ana_grup_id`
where bg_filtre_grup.id IN
(
select distinct bg_filtre.grup_id from bg_filtre
RIGHT JOIN
(
SELECT `bg_T1`.`id` FROM (`bg_urunler` bg_T1) WHERE `stok_adet` > min_stok_miktar AND `kategori_id` = 333 AND `durum` = 1 AND `dosya` <> ''
)
AS filtre_sonuc_liste ON bg_filtre.`urun_id` = filtre_sonuc_liste.id
)
ORDER BY `ana_grup_id` ASC, pozisyon ASC, `deger` ASC
|
0.0002 |
SELECT `bg_filtre_kayit`.* FROM (`bg_filtre_kayit`) WHERE `f1` = '' AND `f2` = '' AND `f3` = '' AND `f4` = '' AND `f5` = '2930' AND `f6` = '838,833,153,827' AND `f7` = '' AND `f8` = '' AND `f9` = '' AND `f10` = '' AND `siralama` = 'fiyatz'
|
0.0002 |
SELECT * FROM (`bg_kategoriler`) WHERE `pozisyon` < '14' AND `ana_kategori` = 1 ORDER BY `pozisyon` DESC LIMIT 1
|
0.0002 |
SELECT *, IF(gorunurluk = 1, "Aktif", "Pasif") as gorunurluk FROM (`bg_ana_menu`)
|