GJF adheres to the cooperation philosophy of "integrity, innovation, altruism, and win-win."We wholeheartedly serve and aim to achieve win-win situations in the future automotive aftermarket.
รับใบเสนอราคาฟรี
ติดต่อเรา
No.20, Checheng Avenue,Xiuquan Street, Huadu district Guangzhou City , Guangdong Province ,China.
SELECT `type`,`name`,`value` FROM `la_config` WHERE `type` IN ('official_website','page_banner') [ RunTime:0.000486s ]
SELECT c.*, COALESCE(ct.name, ct_en.name, c.id) as name, COALESCE(ct.description, ct_en.description) as description, COALESCE(ct.seo_title, ct_en.seo_title) as seo_title, COALESCE(ct.seo_keywords, ct_en.seo_keywords) as seo_keywords, COALESCE(ct.seo_description, ct_en.seo_description) as seo_description FROM `la_product_category` `c` LEFT JOIN `la_product_category_translation` `ct` ON `ct`.`category_id`=c.id AND ct.lang = 'th' LEFT JOIN `la_product_category_translation` `ct_en` ON `ct_en`.`category_id`=c.id AND ct_en.lang = 'en' WHERE ( `c`.`is_show` = '1' AND `c`.`cate_type` = 'product' ) AND `c`.`delete_time` IS NULL ORDER BY `c`.`sort` ASC,`c`.`id` ASC [ RunTime:0.001093s ]
SELECT `code`,`name`,`native_name`,`subdomain`,`is_rtl` FROM `la_language` WHERE `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000461s ]
SELECT `c`.*,`ct`.`name`,`ct`.`description`,`ct`.`seo_title`,`ct`.`seo_keywords`,`ct`.`seo_description` FROM `la_product_category_translation` `ct` LEFT JOIN `la_product_category` `c` ON `c`.`id`=`ct`.`category_id` WHERE `ct`.`lang` = 'th' AND `c`.`is_show` = '1' AND `c`.`delete_time` IS NULL AND `c`.`cate_type` = 'product' ORDER BY `c`.`sort` ASC,`c`.`id` ASC [ RunTime:0.000666s ]
SELECT `c`.*,`ct`.`name`,`ct`.`description`,`ct`.`seo_title`,`ct`.`seo_keywords`,`ct`.`seo_description` FROM `la_product_category_translation` `ct` LEFT JOIN `la_product_category` `c` ON `c`.`id`=`ct`.`category_id` WHERE `ct`.`lang` = 'en' AND `c`.`is_show` = '1' AND `c`.`delete_time` IS NULL AND `c`.`cate_type` = 'product' ORDER BY `c`.`sort` ASC,`c`.`id` ASC [ RunTime:0.000845s ]
SELECT COUNT(*) AS think_count FROM `la_product` `p` LEFT JOIN `la_product_translation` `pt` ON `pt`.`product_id`=p.id AND pt.lang = 'th' LEFT JOIN `la_product_translation` `pt_en` ON `pt_en`.`product_id`=p.id AND pt_en.lang = 'en' WHERE ( `p`.`is_delete` = '0' AND `p`.`is_show` = '1' AND ( EXISTS (SELECT 1 FROM la_product_category_pivot pcp WHERE pcp.product_id = p.id AND pcp.category_id IN (11)) ) ) AND `p`.`delete_time` IS NULL [ RunTime:0.001867s ]
SELECT p.id, p.model, p.product_code, p.sort, p.custom_url, COALESCE(pt.name, pt_en.name, '') as name FROM `la_product` `p` LEFT JOIN `la_product_translation` `pt` ON `pt`.`product_id`=p.id AND pt.lang = 'th' LEFT JOIN `la_product_translation` `pt_en` ON `pt_en`.`product_id`=p.id AND pt_en.lang = 'en' WHERE ( `p`.`is_delete` = '0' AND `p`.`is_show` = '1' AND ( EXISTS (SELECT 1 FROM la_product_category_pivot pcp WHERE pcp.product_id = p.id AND pcp.category_id IN (11)) ) ) AND `p`.`delete_time` IS NULL ORDER BY `p`.`id` DESC LIMIT 0,12 [ RunTime:0.000820s ]
SELECT `product_id`,`image` FROM `la_product_image` WHERE `product_id` IN (211,210,209,208,207,206,205,204,203,202,201,200) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000638s ]
SELECT `tag_id`,`product_id` FROM `la_product_tag_pivot` WHERE `product_id` IN (211,210,209,208,207,206,205,204,203,202,201,200) [ RunTime:0.000522s ]
SELECT * FROM `la_product_category_translation` WHERE `category_id` = 11 AND `lang` IN ('th','en') [ RunTime:0.000473s ]