| 2.0806 |
SELECT "v_id", "v_ip", "v_page"
FROM "tb_hitcounter"
WHERE "v_ip" = '3.143.17.164'
AND "v_page" = 'https://www.souvanny.la/product/detail/819097'
|
| 0.0026 |
INSERT INTO "tb_hitcounter" ("v_ip", "v_country", "v_city", "v_timeview", "v_counter", "v_page") VALUES ('3.143.17.164', 'United States', '', '2025-04-28 10:23:13', 1, 'https://www.souvanny.la/product/detail/819097')
|
| 0.0705 |
SELECT
aa.pro_id
,coalesce(aa.plus_code,''::text) plus_code
--,coalesce(aa.pro_barcode,''::text) pro_barcode
,coalesce(aa.pro_code,''::text) pro_code
,coalesce(aa.pro_number,''::text) pro_number
,coalesce(aa.pro_name_la,''::text) pro_name_la
,coalesce(aa.pro_name_en,''::text) pro_name_en
,coalesce((prc.product_price1*(SELECT rr.r_rate FROM tb_rates AS rr WHERE rr.r_currency = 'THB')),0) price
-- ,coalesce(aa.pro_desc,''::text) pro_desc
-- ,coalesce(aa.pro_desc_spc_la,'') pro_desc_spc_la
-- ,coalesce(aa.pro_desc_spc_en,'')pro_desc_spc_en
,coalesce(aa.pro_weight,0) pro_weight -- ນໍ້າໜັກ
,coalesce(aa.cbm,0) cbm
-- ,coalesce(aa.pro_size,0) pro_size
,coalesce(aa.pro_width,0) pro_width -- ກ້ວາງ
,coalesce(aa.pro_length,0) pro_length -- ຍາວ
,coalesce(aa.pro_heigth,0) pro_heigth -- ສູງ
,coalesce(aa.propertie_use,''::text) propertie_use -- ການໃຊ້ງານທີ່ເໝາະສົມ
,coalesce(aa.conttent,''::text) conttent -- ປະລິມານບັນຈຸ
,coalesce(aa.khuam_meuan_online,''::text) khuam_meuan_online -- ຄ່າຄວາມມື່ນ
,coalesce(aa.water_quantity_used_online,''::text) water_quantity_used_online -- ປະລິມານໃຊ້ນໍ້າ
,coalesce(aa.cleanse_system,''::text) cleanse_system -- ລະບົບຊຳລະລ້າງ
,coalesce(aa.surface,''::text) surface -- ພື້ນຜິວ
,coalesce(aa.material_online,''::text) material_online -- ວັດຖູ
,coalesce(aa.pattern_design_online,''::text) pattern_design_online -- ການອອກແບບລວດລາຍ
,coalesce(aa.wattage,''::text) wattage -- ກຳລັງວັດ
,coalesce(aa.guarantee,''::text) guarantee -- ການຮັບປະກັນ
,coalesce(aa.good_property,''::text) good_property -- ຄຸນສົມບັດເດັ່ນ
,coalesce(aa.prohibit_cateful,''::text) prohibit_cateful -- ຂໍ້ຫ້າມ/ລະວັງ
,aa.expire -- ສິນຄ້າໝົດອາຍຸ
,coalesce(ii.product_pattern_name_online,''::text) product_pattern_name_online -- ຮູບແບບ
--,aa.max_add -- ການບັນຈຸ
-- ,aa.ctl_id,aa.cbm
,coalesce(aa.pro_img_cover,''::text) pro_img_cover
--,aa.pro_created,aa.pro_updated
-- ,coalesce(aa.pro_status,'Enable'::text) pro_status
-- ,coalesce(aa.pro_online,true) pro_online
,coalesce(aa.cat_id,''::text) cat_id
,coalesce(bb.cat_name_la,''::text) cat_name_la
,coalesce(bb.cat_name_en,'') cat_name_en
,coalesce(aa.prog_id,''::text) prog_id
,coalesce(cc.prog_name_la,''::text) prog_name_la
,coalesce(cc.prog_name_en,''::text) prog_name_en
,coalesce(aa.prot_id,''::text) prot_id
,coalesce(dd.product_type_name_online,''::text) prot_name_la
,coalesce(dd.product_type_name_online,''::text) prot_name_en
-- ,coalesce(aa.unit_id,0) unit_id
,coalesce(ee.unit_name_la,'') unit_name_la
,coalesce(ee.unit_name_en,'') unit_name_en
-- ,coalesce(aa.brn_id,0) brn_id
,coalesce(prc.brchcode,'') brchcode
-- ,coalesce(brch.b_name,'') brchnamela
-- ,coalesce(brch.b_name_eng,'') brchnameeng
,coalesce(ff.product_brand_name_online,''::text) brn_name_la
--,coalesce(ff.product_brand_name_online,''::text) brn_name_en
-- ,coalesce(aa.pro_img_id,0) pro_img_id
-- ,coalesce(gg.pro_img_title,''::text) pro_img_title
,coalesce(gg.pro_img_1,''::text)pro_img_1
,coalesce(gg.pro_img_2,''::text) pro_img_2
,coalesce(gg.pro_img_3,''::text) pro_img_3
,coalesce(gg.pro_img_4,''::text) pro_img_4
,coalesce(gg.pro_img_5,''::text) pro_img_5
-- ,coalesce(aa.sup_id,0) sup_id
-- ,(SELECT rr.r_rate FROM tb_rates AS rr WHERE rr.r_currency = 'THB') as currencyrate
-- ,1 saleqty,''::text publickey,''::text secretkey,aa.vatrate
,coalesce(stc.stock,0)::bigint stock
,coalesce(prc.product_price1,0) product_price1
-- ,coalesce(prc.product_price2,0) product_price2
-- ,coalesce(prc.product_price3,0) product_price3
-- ,coalesce(prc.product_price4,0) product_price4
-- ,coalesce(prc.product_price5,0) product_price5
-- ,coalesce(prc.product_price6,0) product_price6
-- ,coalesce(prc.product_price7,0) product_price7
-- ,coalesce(prc.product_price8,0) product_price8
-- ,coalesce(prc.product_price9,0) product_price9
-- ,coalesce(prc.product_price10,0) product_price10
FROM tb_product as aa
LEFT JOIN tb_category as bb ON bb.cat_id = aa.cat_id
LEFT JOIN tb_product_group as cc ON cc.prog_id = aa.prog_id
LEFT JOIN tb_product_type as dd ON dd.prot_id = aa.prot_id
LEFT JOIN tb_unit as ee ON ee.unit_id = aa.unit_id
LEFT JOIN tb_brand as ff ON ff.brn_id = aa.brn_id
LEFT JOIN tb_image as gg ON gg.pro_img_id = aa.pro_img_id
LEFT JOIN master_product_pattern as ii ON ii.product_pattern_id = aa.product_pattern_id
LEFT JOIN (SELECT SUM(st.stock)::bigint stock,st.brchcode,st.productcode
FROM mvw_stockcard st
WHERE st.brchcode in('SVN-005')
GROUP BY st.brchcode,st.productcode
) stc ON stc.productcode = aa.pro_code
LEFT JOIN master_product_multiprice prc ON prc.product_code = aa.pro_code AND
prc.brchcode in('SVN-005')
-- LEFT JOIN tb_branch brch ON brch.brchcode = prc.brchcode
WHERE aa.pro_status = 'Enable'
AND aa.status_check_img_true
AND aa.online_retail
AND aa.cbm > 0
AND prc.product_price1 > 0
AND aa.pro_id IN('819097')
AND aa.pro_code NOT IN('')
AND aa.pro_img_cover != 'https://www.souvanny.la/assets/source/2020/NoImage.png'
|
| 0.0565 |
SELECT aa.pro_id,aa.pro_code
,coalesce(aa.pro_number,''::text) pro_number
,coalesce(aa.pro_name_la,''::text) pro_name_la
,coalesce(aa.pro_name_en,''::text) pro_name_en
,coalesce((prc.product_price1*(SELECT rr.r_rate FROM tb_rates AS rr WHERE rr.r_currency = 'THB')),0) price
,coalesce(un.unit_name_la,'') unit_name_la
,coalesce(un.unit_name_en,'') unit_name_en
,coalesce(aa.brn_id,0) brn_id
,coalesce(prc.product_price1,0) product_price1
,coalesce(stc.stock,0)::bigint stock
,coalesce(aa.pro_img_cover,''::text) pro_img_cover
,coalesce(aa.pro_img_id,0) pro_img_id
,coalesce(gg.pro_img_1,''::text)pro_img_1
,coalesce(gg.pro_img_2,''::text) pro_img_2
,coalesce(gg.pro_img_3,''::text) pro_img_3
,coalesce(gg.pro_img_4,''::text) pro_img_4
,coalesce(gg.pro_img_5,''::text) pro_img_5
FROM tb_product as aa
LEFT JOIN tb_unit as un ON un.unit_id = aa.unit_id
LEFT JOIN tb_image as gg ON gg.pro_img_id = aa.pro_img_id
LEFT JOIN (
SELECT SUM(st.stock)::bigint stock,st.brchcode,st.productcode
FROM mvw_stockcard st
WHERE st.brchcode in('SVN-005')
GROUP BY st.brchcode,st.productcode
) stc ON stc.productcode = aa.pro_code
LEFT JOIN master_product_multiprice prc ON prc.product_code = aa.pro_code AND
prc.brchcode in('SVN-005')
WHERE aa.pro_status = 'Enable'
AND aa.online_retail
AND stc.stock > 2
AND aa.cbm > 0
AND aa.pro_weight > 0
AND aa.pro_code NOT IN('')
AND aa.cat_id in('10-AP')
AND aa.status_check_img_true
AND aa.status_check_img_false = false
AND aa.pro_updated::date < now()
AND aa.pro_img_cover != 'https://www.souvanny.la/assets/source/2020/NoImage.png'
order by aa.cat_id asc
limit '15' offset '0'
|
| 0.0007 |
SELECT cat_id, cat_name_la, cat_name_en, url FROM public.tb_category where active=true order by order_list asc
|
| 0.0002 |
SELECT cat_id, cat_name_la, cat_name_en, url FROM public.tb_category where active=true order by order_list asc
|
| 0.0010 |
SELECT *
FROM "tb_product_group"
WHERE "active" = TRUE
AND "prog_name_la" != 'XXX'
|
| 0.0006 |
SELECT *
FROM "tb_product_group"
WHERE "active" = TRUE
AND "prog_name_la" != 'XXX'
|
| 0.0006 |
SELECT *
FROM "tb_product_group"
WHERE "active" = TRUE
AND "prog_name_la" != 'XXX'
|
| 0.0006 |
SELECT *
FROM "tb_product_group"
WHERE "active" = TRUE
AND "prog_name_la" != 'XXX'
|
| 0.0006 |
SELECT *
FROM "tb_product_group"
WHERE "active" = TRUE
AND "prog_name_la" != 'XXX'
|
| 0.0006 |
SELECT *
FROM "tb_product_group"
WHERE "active" = TRUE
AND "prog_name_la" != 'XXX'
|
| 0.0006 |
SELECT *
FROM "tb_product_group"
WHERE "active" = TRUE
AND "prog_name_la" != 'XXX'
|
| 0.0006 |
SELECT *
FROM "tb_product_group"
WHERE "active" = TRUE
AND "prog_name_la" != 'XXX'
|
| 0.0006 |
SELECT *
FROM "tb_product_group"
WHERE "active" = TRUE
AND "prog_name_la" != 'XXX'
|
| 0.0007 |
SELECT *
FROM "tb_product_group"
WHERE "active" = TRUE
AND "prog_name_la" != 'XXX'
|
| 0.0006 |
SELECT *
FROM "tb_product_group"
WHERE "active" = TRUE
AND "prog_name_la" != 'XXX'
|
| 0.0008 |
SELECT *
FROM "tb_product_group"
WHERE "active" = TRUE
AND "prog_name_la" != 'XXX'
|
| 0.0006 |
SELECT *
FROM "tb_product_group"
WHERE "active" = TRUE
AND "prog_name_la" != 'XXX'
|
| 0.0006 |
SELECT *
FROM "tb_product_group"
WHERE "active" = TRUE
AND "prog_name_la" != 'XXX'
|
| 0.0006 |
SELECT *
FROM "tb_product_group"
WHERE "active" = TRUE
AND "prog_name_la" != 'XXX'
|
| 0.0006 |
SELECT *
FROM "tb_product_group"
WHERE "active" = TRUE
AND "prog_name_la" != 'XXX'
|
| 0.0007 |
SELECT *
FROM "tb_product_group"
WHERE "active" = TRUE
AND "prog_name_la" != 'XXX'
|
| 0.0010 |
SELECT *
FROM "tb_product_group"
WHERE "active" = TRUE
AND "prog_name_la" != 'XXX'
|
| 0.0011 |
SELECT *
FROM "tb_product_group"
WHERE "active" = TRUE
AND "prog_name_la" != 'XXX'
|
| 0.0005 |
SELECT coalesce(pt.promo_type_id,null) promo_type_id,
coalesce(pt.promo_type_name,''::text) promo_type_name,
coalesce(pt.promo_type_name_en,''::text) promo_type_name_en
FROM public.tb_promotion_type as pt
where pt.promo_type_status in('Enable')
order by pt.promo_type_id asc
|
| 0.0004 |
SELECT coalesce(st.sv_type_id,null) sv_type_id,
coalesce(st.sv_type_name,''::text) sv_type_name,
coalesce(st.sv_type_name_en,''::text) sv_type_name_en
FROM public.tb_service_type as st
where st.sv_type_status in('Enable')
order by st.sv_type_id asc
|
| 0.0059 |
SELECT coalesce(ht.hg_type_id,null) hg_type_id,
coalesce(ht.hg_type_name,''::text) hg_type_name,
coalesce(ht.hg_type_name_en,''::text) hg_type_name_en
FROM public.tb_homeguru_type as ht
where ht.hg_type_display in('On')
order by ht.hg_type_id desc
|
| 0.0003 |
SELECT cat_id, cat_name_la, cat_name_en, url FROM public.tb_category where active=true order by order_list asc
|
| 0.0003 |
SELECT coalesce(pt.promo_type_id,null) promo_type_id,
coalesce(pt.promo_type_name,''::text) promo_type_name,
coalesce(pt.promo_type_name_en,''::text) promo_type_name_en
FROM public.tb_promotion_type as pt
where pt.promo_type_status in('Enable')
order by pt.promo_type_id asc
|
| 0.0003 |
SELECT coalesce(st.sv_type_id,null) sv_type_id,
coalesce(st.sv_type_name,''::text) sv_type_name,
coalesce(st.sv_type_name_en,''::text) sv_type_name_en
FROM public.tb_service_type as st
where st.sv_type_status in('Enable')
order by st.sv_type_id asc
|
| 0.0002 |
SELECT coalesce(ht.hg_type_id,null) hg_type_id,
coalesce(ht.hg_type_name,''::text) hg_type_name,
coalesce(ht.hg_type_name_en,''::text) hg_type_name_en
FROM public.tb_homeguru_type as ht
where ht.hg_type_display in('On')
order by ht.hg_type_id desc
|
| 0.0018 |
SELECT aa.msdtid,aa.mshdid,aa.sms,to_char(aa.msdate,'dd-mm-yyyy hh24:mi:ss AM') msdate,bb.mshddate,bb.lastupdate,aa.cus_id,ee.em_email cus_email,ee.em_phone::text cus_tel
,'admin'::varchar(25) cus_usertype,aa.smstype,aa.url
FROM chat.chatdt aa
left join chat.chathd bb on bb.mshdid = aa.mshdid
left join tb_customer cc on cc.cus_id = aa.cus_id
left join tb_user dd on dd.user_id = aa.cus_id
left join tb_employee ee on ee.em_id = dd.em_id
WHERE dd.user_id is not null
AND bb.cus_id = 44 and user_read = false
|
| 0.0009 |
SELECT *
FROM "tb_customer"
WHERE "cus_id" IS NULL
|
| 0.0002 |
SELECT *
FROM "chat"."chathd"
WHERE "chathd"."cus_id" IS NULL
LIMIT 1
|
ສຸວັນນີ ໂຮມເຊັນເຕີ ຈິນຕະນາການທີ່ເປັນໄປໄດ້
LA
EN
ໝວດກະໂລ້
ໝວດຫ້ອງນ້ຳ
ໝວດຊີມັງ
ໝວດສີ
ໝວດເຫຼັກ
ໝວດຖັງນ້ຳ ແລະ ອຸປະກອນປະປາ
ໝວດຫຼັງຄາ
ໝວດສວນ ແລະ ອຸປະກອນ
ໝວດເຟີນີເຈີ ແລະ ເຄື່ອງໃຊ້ໃນເຮືອນ
ໝວດເຄື່ອງມືຊ່າງ
ໝວດອຸປະກອນຮາດແວແລະເຟີນີເຈີ
ໝວດປະຕູ ແລະ ປ່ອງຢ້ຽມ
ໝວດໄຟຟ້າ ແລະ ອຸປະກອນ
ໝວດເຄື່ອງໃຊ້ໄຟຟ້າ
ໝວດເຄື່ອງຄົວໄຟຟ້າ
ໝວດຫ້ອງຄົວ
ໝວດວັດສະດຸຕົກແຕ່ງພື້ນແລະຝາ
ໝວດເຄມີພັນ
ໝວດເຄື່ອງມືເຮັດຄວາມສະອາດ
/93716%20APP.jpg)
