Uygulamayı Mağazadan Edinebilirsiniz

MENÜ
Son 24 saatte 35 kişi bu ürüne baktı.
Xiaomi Redmi Note 6 Pro 64 GB 4 GB Ram CEP TELEFONU (İthalatçı Garantili)

Xiaomi Redmi Note 6 Pro Özellikleri

Teknoloji dünyasının yükselen markası Xiaomi, son zamanlarda adından sıkça bahsettiriyor. Özellikle fiyat performans odaklı ürünleriyle nam salan marka, Redmi Note serisinin en son sürümüyle teknoloji takipçilerinin karşısına çıktı. Yeni nesil tasarım özellikleri ve güçlü donanımıyla dikkat çeken Xiaomi Redmi Note 6 Pro, fiyatıyla da beğeni kazanıyor.

İddiasını Üstün Teknolojisinden Alan Xiaomi Redmi Note 6 Pro
Ekran özelliklerinden donanım ve yazılım bileşenlerine kadar birçok alanda iddialı olan Xiaomi Redmi Note 6 Pro modelleri, modern ve bir o kadar da şık tasarımıyla tüketicilerin aklını çelmeyi başarıyor. Uygun fiyat, yenilikçi tasarım ve güçlü özellikleriyle Xiaomi Redmi Note 6 Pro, kullanıcıların çok yönlü ihtiyaçlarını karşılayabilecekleri bir model olarak dikkat çekiyor. Çentikli ekran akımının en yeni üyelerinden birisi olan Xiaomi Redmi Note 6 Pro, 6,26 inç büyüklüğündeki 19:9 ekran ile tam ekran deneyimini kullanıcılara sunmayı vadediyor. Güçlü 8 çekirdekli işlemciye sahip modelde yenilikçi yapay zeka destekli çift kamera ise son derece iddialı. Yüksek kapasiteli bataryası sayesinde şarj sorunu yaşamayacağınız Xiaomi Redmi Note 6 Pro, yüksek depolama alanı ile de işinizi kolaylaştırıyor. Android 8.1 Oreo ile çalışan model son derece akıcı ve hızlı bir biçimde size en iyi deneyimi sunuyor.

• 6,26 inç büyüklüğündeki çentikli ekrana sahip olan Xiaomi Redmi Note 6 Pro, 2280 x 1080 piksel çözünürlüğünde tam ekran deneyimi sunuyor. Yüksek ekran kasa oranı ise telefonu kullanmayı zevkli ve rahat bir hale getiriyor.
• Gücünü 14 nm üretim mimarisine sahip 8 çekirdekli Snapdragon 636 işlemciden alan akıllı telefon ile donma ve ısınma problemlerini arkanızda bırakabilirsiniz.
• 4 GB RAM ve 64 GB dahili depolamaya sahip olan Redmi Note 6 Pro, ayrıca microSD kart desteği sayesinde 256 GB’a kadar ekstra alanı hizmetinize sunabiliyor.
• 12 Megapiksel ve 5 Megapiksel çözünürlüğünde çift arka kameranın yer aldığı modelde 27 farklı modun yer aldığı yapay zeka desteği sayesinde en güzel fotoğrafları çekmek kolaylaşıyor. Yapay zeka destekli portre moduna sahip 20 megapiksel ve 2 megapiksellik ön kamera sayesindeyse başarılı özçekimler çekmek mümkün oluyor.
• 4000 mAh kapasitesindeki batarya sayesindeyse kullanıcılar uzun kullanım sürelerine ulaşabiliyor.
• Çift SIM kart ile 2G, 3G, 4G ve 4.5G desteği ile her an hayata bağlı kalmanızı sağlayan akıllı telefonda, Wi-Fi 802.11 a/b/g/n/ac desteği ile en hızlı internet bağlantısı da unutulmamış.

Xiaomi Redmi Note 6 Pro 

Modern Çağın Yeni Nesil Özellikleri
• Ekran Özellikleri: 19:9 oranındaki 6,26 inç büyüklüğe sahip IPS LCD ekran, 403 PPI, 2280 x 1080 piksel, yüzde 81.1 ekran kasa oranı, 500 nit parlaklık, 1500:1 kontrast oranı.
• Depolama Özellikleri: 4 GB LPDDRR4X RAM, 64 GB eMMC 5.1 dahili depolama birimi, 256 GB’a kadar destekli microSD hafıza desteği.
• Kamera Özellikleri: Arka tarafta; 12 Megapiksel, f/1.9, 1/2.55", 1.4µm, dual pixel PDAF ana kamera ve 5 Megapiksel, f/2.2, 1.12µm, derinlik sensörü. HDR, Panorama, Burst, Yüz Tanıma, Dynamic Bokeh modları ve video kaydı için EIS desteği. Ön tarafta; 20 Megapiksel, f/2.0, 0.9µm, 4-in-1 Super Pixel ve 2 Megapiksel, f/2.2, 1.75µm, derinlik sensörü. Yapay zeka destekli portre ve Beautify 4.0 modu, zamanlama, yüz tanıma desteği.
• Batarya Özellikleri: Değiştirilemeyen 4000 mAh lithium-ion polymer batarya, 5V / 2A hızlı şarj.
Android 8.1 Oreo ile çalışan model ayrıca 157.9 x 76.4 x 8.3 mm boyutlarında ve 182 gram ağırlığa sahip. Ayrıca arka tarafında parmak izi sensörü barındıran akıllı telefon, Bluetooth 5.0, GPS, A-GPS, GLONASS, Wi-Fi 802.11 a/b/g/n/ac, dual - band, Wi-Fi Direct, hotspot gibi bağlantı seçeneklerine sahip. Güçlü Özelliklerin Uygun Fiyatla Buluştuğu Akıllı Telefon
Hayatımızın vazgeçilmezi haline gelen akıllı telefonların her geçen gün yepyeni bir özellikle karşımıza çıktığı şu günlerde Xiaomi, Redmi Note 6 Pro modeli ile birçok kullanıcının beklentilerini karşılayabilecek, iddialı bir akıllı telefon sundu. Tam ekrana en yakın deneyiminin sunulmaya çalışıldığı akıllı telefonlarda artık bir standart haline gelen çentikli ekrana sahip olan Xiaomi Redmi Note 6 Pro, 6,26 inç büyüklüğündeki çentikli Full HD+ ekranıyla beğenileri kazanıyor. Son derece şık bir görünüme sahip olan akıllı telefonun ön yüzeyi tamamen camdan ve yüzde 81.1 oranında ekrandan oluşurken arka tarafta ise alüminyum kasa dikkat çekiyor. Sağ üst tarafa konumlandırılan çift kameraya ek olarak parmak izi sensörü ise kullanıcının kolay ulaşılabilmesi için ekranın ortasına konumlandırılmış.

Xiaomi Redmi Note 6 Pro ile Tanışın!

Kullanıcısını Düşünen Akıllı Telefon
Android 8.1 Oreo sürümü üzerinde geliştirilen MIUI 9 arayüzüyle çalışan Xiaomi Redmi Note 6 Pro, artırılabilir 64 GB dahili hafızası ve 4 GB RAM sayesinde akıllı telefon kullanıcılarının sıklıkla yaşadığı depolama sorununun önüne geçiyor.
Cihaz güvenliğini artırmak için parmak izi okuyucu ile gelen akıllı telefon ayrıca pusula, jiroskop, yakınlık sensörü, ivme ölçer ve ortam ışığı gibi çeşitli sensörleri bünyesinde barındırıyor. İşlemci performansı, başarılı fotoğraf çekimleri, yüksek batarya kapasitesi gibi birçok özellikle donatılan Xiaomi Redmi Note 6 Pro, 182 gram ağırlığında ve 8.3 milimetre kalınlığıyla ince, şık ve modern bir tasarımı sizinle buluşturuyor.
Akıllı Telefondan Akıllı Ev Elektroniklerine Kadar Her Yerdeler: Xiaomi!
Halihazırda dünyadaki en büyük teknoloji üreticilerinden birisi olan Xiaomi, 2010 yılında Lei Jun tarafından Çin, Pekin'de kuruldu. Hindistan ve Çin’de birçok alanda pazar lideri olan marka aynı zamanda dünyanın en büyük 4. akıllı telefon üreticisi olarak dikkat çekiyor. Dizüstü bilgisayardan televizyona, kameradan gimbal sistemlerine, lambadan şemsiyeye varana kadar son derece geniş bir ürün yelpazesiyle karşımıza çıkan Xiaomi'nin kurucusu Lei Jun dünyanın en zengin isimlerinden birisi olmayı başardı. Özellikle akıllı telefonlarıyla adından sıkça bahsettiren Xiaomi, fiyat performans odaklı ürünleriyle tüm dünyada bir hayran kitlesi oluşturdu.

“İthalatçı firma garantili ürünlerde aksesuar aparatları (şarj cihazı gibi) yurt dışı uyumlu olabilmektedir. Yurtdışı uyumlu aparatları kullanabilmeniz için gerekli çevirici vs gibi aparatlar ürün ile birlikte tarafınıza gönderilmektedir.”

 
 
Ağırlık182 g
Arttırılabilir Hafıza256 GB'a kadar
Assisted GPS (Baz İstasyon Destekli Küresel Konumlama Sistemi)Var
Bağlantı Hızı42.2 Mbps
Bekleme SüresiMaksimum 288 Saat (4G ile)
BluetoothVar
Boyutlar157.9 x 76.4 x 8.3 mm
Çift HatlıVar ( Tek İşlemcili )
Dahili Hafıza64 GB
Dahili ModemVar
Dokunmatik EkranVar
Ekran Boyut Aralığı6 inç ve Üzeri
Ekran Boyutu6,2 inç
Ekran Çözünürlüğü1080 x 2280
Ekran Renk Çözünürlüğü16 Milyon
Ekran TipiIPS LCD
E-mail DesteğiVar
Entegre FlaşVar
Entegre KameraVar
Garanti Tipiİthalatçı Garantili
Görüntülü KonuşmaVar ( Uygulama ile data kullanır )
Göz TaramasıYok
GPS (Küresel Konumlama Sistemi)Var
Hafıza Kartı TipiMicro SD
HandsFree (Eller Serbest)Var
İşlemci Kapasitesi1,8 GHz Octa Core
İşletim SistemiAndroid 8.1 (Oreo)
İşletim TürüAndroid
Kablosuz ŞarjYok
Kamera Çözünürlüğü Aralığı8 - 12,9 MP
Kamera Çözünürlüğü12 MP + 5 MP
Kamera Zoom (Yakınlaştırma)3x, Var
KlavyeYok
Konuşma SüresiMaksimum 40 Saat (30 Saat)
Mobil Bağlantı Hızı4.5G
MP3 ÇalmaVar
NFC (Yakın Alan İletişimi)Yok
Ön (Selfie) Kamera Aralığı20 MP ve Üzeri
Ön (Selfie) Kamera20 MP
Paket İçeriğiCep Telefonu,Data Kablosu,Şarj Adaptörü,Kullanım Kılavuzu
Parmak İzi OkuyucuVar
Pil Gücü Aralığı4000 - 4999 mAh
Pil Gücü4000 mAh
RadyoVar
RAM Kapasitesi4 GB RAM
SAR (Özgül Soğurma Oranı) Değeri0.755 W/kg (Baş) 1.476 W/kg (Vücut)
Ses KayıtVar
Şarj GirişiMicro USB
Şebeke800/850/900/1800/1900/2100/2300/2500/2600
Telefon HafızasıVar
Telefon ModeliRedmi Note 6 Pro
Telefon TipiBar Tipi
Video KayıtVar
Video OynatmaVar
Wi-Fi802.11 a/b/g/n/ac
Yüz TanımaVar
Zil TipiPolifonik - MP3

Yorum Yap


Satın almış olduğunuz ürüne yorum yapabilirsiniz.

Sorunuzu ekleyin

Not: Html Kodu yazamazsınız !

Xiaomi Redmi Note 6 Pro 64 GB 4 GB Ram CEP TELEFONU (İthalatçı Garantili)

    Mağaza: TEKNOPAZAR
  • Görünümler: 6013
  • Ürün Kodu: İthalatçı Garantili
  • Stok Durumu: Var
  • kargo ücreti: 0 TL.
  • 1.249,00 TL

Mevcut Seçenekler:

ETİKETLER: Xiaomi, Redmi, Note, 6, Pro, 64, GB, (İthalatçı, Garantili)

Queries: 105, Total time: 942.947 ms [By time] [By id] [By file]
1 (2.291)
SELECT `data`
FROM `oc_session`
WHERE session_id = '8db9bf740bda56caf441cafe78' AND expire > 1576458000
/home/bpazar/public_html/system/library/session/db.php:21
2 (0.075)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/home/bpazar/public_html/system/library/openbay.php:61
3 (0.091)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/home/bpazar/public_html/system/library/openbay.php:61
4 (0.525)
SELECT `data`
FROM `oc_session`
WHERE session_id = 'b78a231a6625d14e1289f0150f' AND expire > 1576458000
/home/bpazar/public_html/system/library/session/db.php:21
5 (0.068)
SELECT *
FROM oc_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://bpazar.com/'
/home/bpazar/storage/modification/catalog/controller/startup/startup.php:6
6 (0.631)
SELECT *
FROM `oc_setting`
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
/home/bpazar/storage/modification/catalog/controller/startup/startup.php:25
7 (0.082)
SELECT *
FROM oc_language
WHERE status = '1'
ORDER BY sort_order, name
/home/bpazar/public_html/catalog/model/localisation/language.php:15
8 (0.087)
SELECT *
FROM oc_currency
/home/bpazar/storage/modification/system/library/cart/currency.php:10
9 (0.080)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '215' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3354')
ORDER BY tr1.priority ASC
/home/bpazar/public_html/system/library/cart/tax.php:16
10 (0.059)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '215' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3354')
ORDER BY tr1.priority ASC
/home/bpazar/public_html/system/library/cart/tax.php:44
11 (0.083)
SELECT *
FROM oc_weight_class wc
LEFT JOIN oc_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id)
WHERE wcd.language_id = '3'
/home/bpazar/public_html/system/library/cart/weight.php:10
12 (0.081)
SELECT *
FROM oc_length_class mc
LEFT JOIN oc_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id)
WHERE mcd.language_id = '3'
/home/bpazar/public_html/system/library/cart/length.php:10
13 (4.563)
DELETE
FROM oc_cart
WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)
/home/bpazar/storage/modification/system/library/cart/cart.php:15
14 (0.129)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/home/bpazar/public_html/system/library/openbay.php:61
15 (0.099)
SELECT *
FROM `oc_event`
WHERE `trigger` LIKE 'catalog/%' AND status = '1'
ORDER BY `sort_order` ASC
/home/bpazar/public_html/catalog/model/setting/event.php:4
16 (0.690)
SELECT DISTINCT *, pd.name AS name, p.image, p.price AS price, p.quantity, ctp.customer_id ,p.shipping_method , m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating,(SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_customerpartner_to_product ctp ON (p.product_id = ctp.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '2829309' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/bpazar/storage/modification/catalog/model/catalog/product.php:1034
17 (0.116)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '2829309'
/home/bpazar/storage/modification/catalog/model/catalog/product.php:1966
18 (0.117)
SELECT cp.category_id, cp.path_id, cp.level, c.dc
FROM oc_category_path AS cp
LEFT JOIN oc_category AS c ON (c.category_id = cp.category_id)
WHERE c.dc>0 AND c.category_id = '33'
/home/bpazar/storage/modification/catalog/model/catalog/product.php:2000
19 (0.074)
SELECT cp.category_id, cp.path_id, cp.level, c.dc
FROM oc_category_path AS cp
LEFT JOIN oc_category AS c ON (c.category_id = cp.category_id)
WHERE c.dc>0 AND c.category_id = '69'
/home/bpazar/storage/modification/catalog/model/catalog/product.php:2000
20 (0.075)
SELECT cp.category_id, cp.path_id, cp.level, c.dc
FROM oc_category_path AS cp
LEFT JOIN oc_category AS c ON (c.category_id = cp.category_id)
WHERE c.dc>0 AND c.category_id = '1565'
/home/bpazar/storage/modification/catalog/model/catalog/product.php:2000
21 (0.373)
show tables like "oc\_journal2\_config"
/home/bpazar/public_html/system/journal2/startup.php:154
22 (0.115)
SELECT *
FROM oc_journal2_config
WHERE store_id = '0' OR store_id = -1
/home/bpazar/public_html/catalog/model/journal2/db.php:7
23 (0.090)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '2829309' AND store_id = '0'
/home/bpazar/storage/modification/catalog/model/catalog/product.php:1952
24 (0.063)
SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/bpazar/public_html/catalog/model/design/layout.php:13
25 (0.057)
SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'column_left'
ORDER BY sort_order
/home/bpazar/public_html/catalog/model/design/layout.php:23
26 (0.063)
SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'column_right'
ORDER BY sort_order
/home/bpazar/public_html/catalog/model/design/layout.php:23
27 (0.160)
SELECT viewed
FROM oc_product
WHERE product_id = '2829309'
/home/bpazar/public_html/catalog/model/journal2/product.php:134
28 (5.414)
SELECT Count(*) AS 'viewed'
FROM oc_view_by_day
WHERE product_id = '2829309' AND date >= CURDATE() - INTERVAL 1 DAY AND date < CURDATE() + INTERVAL 1 DAY
/home/bpazar/public_html/catalog/model/journal2/product.php:144
29 (1.933)
SELECT sum(op.quantity) as quantity
FROM `oc_order_product` op
LEFT JOIN `oc_order` o ON op.order_id = o.order_id
WHERE o.order_status_id <> 0 AND op.product_id = '2829309'
/home/bpazar/public_html/catalog/model/journal2/product.php:149
30 (0.590)
SELECT DISTINCT *, pd.name AS name, p.image, p.price AS price, p.quantity, ctp.customer_id ,p.shipping_method , m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating,(SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_customerpartner_to_product ctp ON (p.product_id = ctp.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '2829309' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/bpazar/storage/modification/catalog/model/catalog/product.php:1034
31 (0.066)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '2829309'
/home/bpazar/storage/modification/catalog/model/catalog/product.php:1966
32 (0.063)
SELECT cp.category_id, cp.path_id, cp.level, c.dc
FROM oc_category_path AS cp
LEFT JOIN oc_category AS c ON (c.category_id = cp.category_id)
WHERE c.dc>0 AND c.category_id = '33'
/home/bpazar/storage/modification/catalog/model/catalog/product.php:2000
33 (0.063)
SELECT cp.category_id, cp.path_id, cp.level, c.dc
FROM oc_category_path AS cp
LEFT JOIN oc_category AS c ON (c.category_id = cp.category_id)
WHERE c.dc>0 AND c.category_id = '69'
/home/bpazar/storage/modification/catalog/model/catalog/product.php:2000
34 (0.063)
SELECT cp.category_id, cp.path_id, cp.level, c.dc
FROM oc_category_path AS cp
LEFT JOIN oc_category AS c ON (c.category_id = cp.category_id)
WHERE c.dc>0 AND c.category_id = '1565'
/home/bpazar/storage/modification/catalog/model/catalog/product.php:2000
35 (0.101)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = 2829309
/home/bpazar/public_html/catalog/model/journal2/module.php:16
36 (0.489)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = 2829309
/home/bpazar/public_html/catalog/model/journal2/module.php:24
37 (0.107)
SELECT *
FROM oc_journal2_modules
WHERE module_type = "journal2_product_tabs"
/home/bpazar/public_html/catalog/model/journal2/module.php:31
38 (0.065)
SELECT *
FROM oc_journal2_modules
WHERE module_type = "journal2_product_tabs"
/home/bpazar/public_html/catalog/model/journal2/module.php:90
39 (0.100)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '2829309' AND store_id = '0'
/home/bpazar/storage/modification/catalog/model/catalog/product.php:1952
40 (0.061)
SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/bpazar/public_html/catalog/model/design/layout.php:13
41 (0.059)
SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'top'
ORDER BY sort_order
/home/bpazar/public_html/catalog/model/design/layout.php:23
42 (0.061)
SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'bottom'
ORDER BY sort_order
/home/bpazar/public_html/catalog/model/design/layout.php:23
43 (0.058)
SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'header'
ORDER BY sort_order
/home/bpazar/public_html/catalog/model/design/layout.php:23
44 (0.060)
SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'footer'
ORDER BY sort_order
/home/bpazar/public_html/catalog/model/design/layout.php:23
45 (0.764)
SELECT DISTINCT *, pd.name AS name, p.image, p.price AS price, p.quantity, ctp.customer_id ,p.shipping_method , m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating,(SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_customerpartner_to_product ctp ON (p.product_id = ctp.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '2829309' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/bpazar/storage/modification/catalog/model/catalog/product.php:1034
46 (0.037)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '2829309'
/home/bpazar/storage/modification/catalog/model/catalog/product.php:1966
47 (0.033)
SELECT cp.category_id, cp.path_id, cp.level, c.dc
FROM oc_category_path AS cp
LEFT JOIN oc_category AS c ON (c.category_id = cp.category_id)
WHERE c.dc>0 AND c.category_id = '33'
/home/bpazar/storage/modification/catalog/model/catalog/product.php:2000
48 (0.029)
SELECT cp.category_id, cp.path_id, cp.level, c.dc
FROM oc_category_path AS cp
LEFT JOIN oc_category AS c ON (c.category_id = cp.category_id)
WHERE c.dc>0 AND c.category_id = '69'
/home/bpazar/storage/modification/catalog/model/catalog/product.php:2000
49 (0.031)
SELECT cp.category_id, cp.path_id, cp.level, c.dc
FROM oc_category_path AS cp
LEFT JOIN oc_category AS c ON (c.category_id = cp.category_id)
WHERE c.dc>0 AND c.category_id = '1565'
/home/bpazar/storage/modification/catalog/model/catalog/product.php:2000
50 (0.197)
SELECT COUNT(*) AS total
FROM oc_review r
LEFT JOIN oc_product p ON (r.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
WHERE p.product_id = '2829309' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '3'
/home/bpazar/storage/modification/catalog/model/catalog/review.php:69
51 (0.200)
SELECT r.review_id, r.author, r.rating, r.text, p.product_id, pd.name, p.price, p.image, r.date_added
FROM oc_review r
LEFT JOIN oc_product p ON (r.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
WHERE p.product_id = '2829309' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '3'
ORDER BY r.date_added DESC LIMIT 0,5
/home/bpazar/storage/modification/catalog/model/catalog/review.php:63
52 (0.713)
SELECT DISTINCT *, pd.name AS name, p.image, p.price AS price, p.quantity, ctp.customer_id ,p.shipping_method , m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating,(SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_customerpartner_to_product ctp ON (p.product_id = ctp.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '2829309' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/bpazar/storage/modification/catalog/model/catalog/product.php:1034
53 (0.122)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '2829309'
/home/bpazar/storage/modification/catalog/model/catalog/product.php:1966
54 (0.050)
SELECT cp.category_id, cp.path_id, cp.level, c.dc
FROM oc_category_path AS cp
LEFT JOIN oc_category AS c ON (c.category_id = cp.category_id)
WHERE c.dc>0 AND c.category_id = '33'
/home/bpazar/storage/modification/catalog/model/catalog/product.php:2000
55 (0.043)
SELECT cp.category_id, cp.path_id, cp.level, c.dc
FROM oc_category_path AS cp
LEFT JOIN oc_category AS c ON (c.category_id = cp.category_id)
WHERE c.dc>0 AND c.category_id = '69'
/home/bpazar/storage/modification/catalog/model/catalog/product.php:2000
56 (0.043)
SELECT cp.category_id, cp.path_id, cp.level, c.dc
FROM oc_category_path AS cp
LEFT JOIN oc_category AS c ON (c.category_id = cp.category_id)
WHERE c.dc>0 AND c.category_id = '1565'
/home/bpazar/storage/modification/catalog/model/catalog/product.php:2000
57 (0.067)
SELECT c2c.*, c.*,c.firstname,c.lastname,co.name as country, a.address_1, a.address_2, a.city, a.postcode, a.country_id, a.zone_id, a.custom_field
FROM oc_customerpartner_to_customer c2c
LEFT JOIN oc_customer c ON (c2c.customer_id = c.customer_id)
LEFT JOIN oc_address a ON (c.address_id = a.address_id)
LEFT JOIN oc_country co ON (c2c.country = co.iso_code_2)
WHERE c2c.customer_id = '20114' AND c2c.is_partner = '1' AND c.status = '1'
/home/bpazar/public_html/catalog/model/customerpartner/master.php:120
58 (0.039)
SELECT *
FROM oc_product_to_category
WHERE product_id = '2829309'
/home/bpazar/storage/modification/catalog/model/catalog/product.php:1960
59 (0.086)
SELECT *
FROM oc_product_to_category AS ptc
LEFT JOIN oc_category_description AS cd ON (ptc.category_id = cd.category_id)
WHERE ptc.product_id = '2829309' AND language_id = '3'
/home/bpazar/storage/modification/catalog/model/catalog/product.php:2006
60 (0.069)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '0' AND m2s.store_id = '0'
/home/bpazar/public_html/catalog/model/catalog/manufacturer.php:4
61 (0.073)
SELECT *
FROM oc_product_image
WHERE product_id = '2829309'
ORDER BY sort_order ASC
/home/bpazar/storage/modification/catalog/model/catalog/product.php:1939
62 (0.172)
SELECT *
FROM oc_product_discount
WHERE product_id = '2829309' AND customer_group_id = '1' AND quantity > 1 AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY quantity ASC, priority ASC, price ASC
/home/bpazar/storage/modification/catalog/model/catalog/product.php:1935
63 (0.084)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '2829309' AND od.language_id = '3'
ORDER BY o.sort_order
/home/bpazar/storage/modification/catalog/model/catalog/product.php:1884
64 (0.116)
SELECT *
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '2829309' AND pov.product_option_id = '3634875' AND ovd.language_id = '3'
ORDER BY ov.sort_order
/home/bpazar/storage/modification/catalog/model/catalog/product.php:1887
65 (0.076)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '2829309' AND agd.language_id = '3' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/bpazar/storage/modification/catalog/model/catalog/product.php:1863
66 (0.188)
SELECT *
FROM oc_product_related pr
LEFT JOIN oc_product p ON (pr.related_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pr.product_id = '2829309' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/bpazar/storage/modification/catalog/model/catalog/product.php:1945
67 (1.156)
SELECT product_id
FROM oc_customerpartner_to_product
WHERE product_id = '2829309' AND customer_id = '0'
/home/bpazar/public_html/catalog/model/account/customerpartner.php:28
68 (0.044)
SELECT fieldId
FROM oc_wk_custom_field_product
WHERE productId = '2829309'
/home/bpazar/public_html/catalog/model/account/customerpartner.php:3400
69 (0.039)
SELECT product_id
FROM oc_customerpartner_to_product
WHERE product_id = '2829309' AND customer_id = '0'
/home/bpazar/public_html/catalog/model/account/customerpartner.php:28
70 (0.043)
SELECT rd.*
FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 3 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id
WHERE pr.product_id = 2829309 AND status = '1' AND pr.customer_group_id = '1'
ORDER BY sort_order ASC
/home/bpazar/storage/modification/catalog/model/catalog/product.php:2173
71 (913.013)
UPDATE oc_product SET viewed = (viewed + 1)
WHERE product_id = '2829309'
/home/bpazar/storage/modification/catalog/model/catalog/product.php:1009
72 (0.186)
INSERT INTO oc_view_by_day (customer_id,date,product_id) VALUES ( 0, '2019-12-16 01:00', 2829309)
/home/bpazar/storage/modification/catalog/model/catalog/product.php:1013
73 (0.098)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '2829309' AND store_id = '0'
/home/bpazar/storage/modification/catalog/model/catalog/product.php:1952
74 (0.080)
SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/bpazar/public_html/catalog/model/design/layout.php:13
75 (0.716)
SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'column_left'
ORDER BY sort_order
/home/bpazar/public_html/catalog/model/design/layout.php:23
76 (0.047)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '2829309' AND store_id = '0'
/home/bpazar/storage/modification/catalog/model/catalog/product.php:1952
77 (0.046)
SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/bpazar/public_html/catalog/model/design/layout.php:13
78 (0.052)
SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'column_right'
ORDER BY sort_order
/home/bpazar/public_html/catalog/model/design/layout.php:23
79 (0.050)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '2829309' AND store_id = '0'
/home/bpazar/storage/modification/catalog/model/catalog/product.php:1952
80 (0.048)
SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/bpazar/public_html/catalog/model/design/layout.php:13
81 (0.046)
SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'content_top'
ORDER BY sort_order
/home/bpazar/public_html/catalog/model/design/layout.php:23
82 (0.041)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '2829309' AND store_id = '0'
/home/bpazar/storage/modification/catalog/model/catalog/product.php:1952
83 (0.040)
SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/bpazar/public_html/catalog/model/design/layout.php:13
84 (0.041)
SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'content_bottom'
ORDER BY sort_order
/home/bpazar/public_html/catalog/model/design/layout.php:23
85 (0.433)
DELETE
FROM `oc_customer_online`
WHERE date_added < '2019-12-16 00:00:01'
/home/bpazar/public_html/catalog/model/tool/online.php:4
86 (0.117)
REPLACE INTO `oc_customer_online` SET `ip` = '3.234.214.179', `customer_id` = '0', `url` = 'https://www.bpazar.com/Cep-Telefonu-Aksesuarlari/Xiaomi-Redmi-Note-6-Pro-64-GB-CEP-TELEFONU-(Ithalatci-Garantili)/2829309', `referer` = '', `date_added` = '2019-12-16 01:00:01'
/home/bpazar/public_html/catalog/model/tool/online.php:6
87 (0.085)
SELECT *
FROM oc_extension
WHERE `type` = 'analytics'
/home/bpazar/public_html/catalog/model/setting/extension.php:4
88 (0.085)
SELECT *
FROM oc_customerpartner_to_customer
WHERE customer_id = '0'
/home/bpazar/public_html/catalog/model/account/customerpartner.php:1460
89 (0.081)
SELECT *
FROM oc_customerpartner_to_customer
WHERE customer_id = '0'
/home/bpazar/public_html/catalog/model/account/customerpartner.php:1460
90 (0.074)
SELECT *
FROM oc_language
WHERE status = '1'
ORDER BY sort_order, name
/home/bpazar/public_html/catalog/model/localisation/language.php:15
91 (0.117)
SELECT *
FROM oc_pointsvalues
/home/bpazar/storage/modification/system/library/cart/cart.php:144
92 (1.334)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'b78a231a6625d14e1289f0150f'
ORDER BY seller_id ASC
/home/bpazar/storage/modification/system/library/cart/cart.php:147
93 (0.100)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/home/bpazar/public_html/catalog/model/setting/extension.php:4
94 (0.079)
SELECT *
FROM oc_pointsvalues
/home/bpazar/storage/modification/system/library/cart/cart.php:144
95 (0.083)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'b78a231a6625d14e1289f0150f'
ORDER BY seller_id ASC
/home/bpazar/storage/modification/system/library/cart/cart.php:147
96 (0.096)
SELECT *
FROM oc_pointsvalues
/home/bpazar/storage/modification/system/library/cart/cart.php:144
97 (0.090)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'b78a231a6625d14e1289f0150f'
ORDER BY seller_id ASC
/home/bpazar/storage/modification/system/library/cart/cart.php:147
98 (0.107)
SELECT SUM(amount) AS total
FROM oc_customer_transaction
WHERE customer_id = '0'
/home/bpazar/storage/modification/system/library/cart/customer.php:122
99 (0.077)
SELECT *
FROM oc_pointsvalues
/home/bpazar/storage/modification/system/library/cart/cart.php:144
100 (0.079)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'b78a231a6625d14e1289f0150f'
ORDER BY seller_id ASC
/home/bpazar/storage/modification/system/library/cart/cart.php:147
101 (0.073)
SELECT *
FROM oc_pointsvalues
/home/bpazar/storage/modification/system/library/cart/cart.php:144
102 (0.069)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'b78a231a6625d14e1289f0150f'
ORDER BY seller_id ASC
/home/bpazar/storage/modification/system/library/cart/cart.php:147
103 (0.156)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '0' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/bpazar/public_html/catalog/model/catalog/category.php:11
104 (0.165)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '59' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/bpazar/public_html/catalog/model/catalog/category.php:11
105 (0.141)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '69' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/bpazar/public_html/catalog/model/catalog/category.php:11