| 0.0015 |
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.0002 |
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.0002 |
SELECT *
FROM (`bg_ayarlar_veri`)
WHERE `ayar` = 'KATEGORI_GOSTERIM'
|
| 0.0002 |
SELECT *
FROM (`bg_kategoriler`)
WHERE `id` = 333
|
| 0.0162 |
select kisa_aciklama from bg_urunler where kategori_id = 333 and stok_adet > min_stok_miktar and durum = 1 group by kisa_aciklama
|
| 0.0003 |
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.0030 |
SELECT COUNT(DISTINCT bg_T1.id) AS adet
FROM (`bg_urunler` bg_T1)
INNER JOIN `bg_filtre` F6 ON `bg_T1`.`id` = `F6`.`urun_id`
WHERE (F6.grup_id='185' OR F6.grup_id='877' OR F6.grup_id='122' OR F6.grup_id='197' OR F6.grup_id='77' OR F6.grup_id='169')
AND `is_stock_active` = 1
AND `kategori_id` = 333
AND `durum` = 1
AND `dosya` <> ''
|
| 0.0045 |
SELECT *
FROM (`bg_urunler` bg_T1)
INNER JOIN `bg_filtre` F6 ON `bg_T1`.`id` = `F6`.`urun_id`
WHERE (F6.grup_id='185' OR F6.grup_id='877' OR F6.grup_id='122' OR F6.grup_id='197' OR F6.grup_id='77' OR F6.grup_id='169')
AND `is_stock_active` = 1
AND `kategori_id` = 333
AND `durum` = 1
AND `dosya` <> ''
GROUP BY `bg_T1`.`id`
ORDER BY `bg_T1`.`id` DESC
LIMIT 40
|
| 0.0288 |
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.0060 |
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 `is_stock_active` = 1
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` = ''
AND `f6` = '185,877,122,197,77,169'
AND `f7` = ''
AND `f8` = ''
AND `f9` = ''
AND `f10` = ''
AND `siralama` = ''
|
| 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`)
|
