SELECT `l`.`id`,`l`.`name` AS `lang_name`,`l`.`en_name` AS `lang_en_name`,`l`.`code` AS `lang_code`,`l`.`icon` AS `lang_icon`,`l`.`url` AS `lang_url`,`c`.`id` AS `country_id`,`c`.`name` AS `country_zh_name`,`c`.`en_name` AS `country_en_name`,`c`.`code` AS `country_code` FROM `ow_sys_language` `l` INNER JOIN `ow_sys_country` `c` ON `c`.`id`=`l`.`country_id` WHERE `l`.`status` = '1' AND `c`.`status` = '1' ORDER BY `l`.`sort` ASC,`l`.`id` ASC [ RunTime:0.000675s ]
SELECT `id`,`pid`,`name`,`icon`,`level` FROM `ow_product_category` WHERE ( `language_id` = 1 AND `is_show` = 1 ) AND `ow_product_category`.`deleted_at` IS NULL ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000687s ]
SELECT `id`,`name`,`short_name`,`cover_image` FROM `ow_product` WHERE ( `language_id` = 1 AND `is_sale` = 1 AND `is_show` = 1 AND `is_hot` = 1 ) AND `ow_product`.`deleted_at` IS NULL ORDER BY `sort` ASC,`id` DESC LIMIT 3 [ RunTime:0.008149s ]
SHOW FULL COLUMNS FROM `ow_sys_navigation_item` [ RunTime:0.001543s ]
SELECT `SysNavigationItemModel`.* FROM `ow_sys_navigation_item` `SysNavigationItemModel` INNER JOIN `ow_sys_navigation` `SysNavigationModel` ON `SysNavigationItemModel`.`nav_id`=`SysNavigationModel`.`id` WHERE `SysNavigationModel`.`deleted_at` IS NULL AND ( ( `SysNavigationModel`.`unique_label` = 'NAV_67f3701f3e831' AND `SysNavigationModel`.`language_id` = '1' AND `SysNavigationModel`.`status` = '1' ) ) AND `SysNavigationItemModel`.`status` = '1' ORDER BY `SysNavigationItemModel`.`sort` ASC,`SysNavigationItemModel`.`id` ASC [ RunTime:0.000630s ]
SELECT `c`.`id`,`c`.`title`,`c`.`name`,`c`.`value`,`c`.`extra`,`c`.`type`,`g`.`unique_label` FROM `ow_sys_config` `c` INNER JOIN `ow_sys_config_group` `g` ON `g`.`id`=`c`.`group_id` WHERE ( `g`.`unique_label` IN ('basic','contact','media') AND `g`.`language_id` = '1' ) AND `c`.`deleted_at` IS NULL ORDER BY `c`.`sort` ASC,`c`.`id` DESC [ RunTime:0.000762s ]
SELECT `SysNavigationItemModel`.* FROM `ow_sys_navigation_item` `SysNavigationItemModel` INNER JOIN `ow_sys_navigation` `SysNavigationModel` ON `SysNavigationItemModel`.`nav_id`=`SysNavigationModel`.`id` WHERE `SysNavigationModel`.`deleted_at` IS NULL AND ( ( `SysNavigationModel`.`unique_label` = 'NAV_67f60be43df8d' AND `SysNavigationModel`.`language_id` = '1' AND `SysNavigationModel`.`status` = '1' ) ) AND `SysNavigationItemModel`.`status` = '1' ORDER BY `SysNavigationItemModel`.`sort` ASC,`SysNavigationItemModel`.`id` ASC [ RunTime:0.000529s ]
SELECT * FROM `ow_sys_banner` WHERE ( `at_platform` = 'pc' AND `unique_label` = 'BANNER_6808abd813d78' AND `language_id` = 1 AND `status` = 1 ) AND `ow_sys_banner`.`deleted_at` IS NULL [ RunTime:0.000423s ]
SHOW FULL COLUMNS FROM `ow_sys_banner_item` [ RunTime:0.001361s ]
SHOW FULL COLUMNS FROM `ow_sys_banner_prod_cate_mapping` [ RunTime:0.001119s ]
SELECT `id`,`banner_id`,`title`,`title_txt_color`,`desc`,`desc_txt_color`,`type`,`image`,`video`,`link_to`,`link`,`sort` FROM `ow_sys_banner_item` WHERE ( EXISTS ( SELECT * FROM `ow_sys_banner_prod_cate_mapping` WHERE ( banner_item_id = ow_sys_banner_item.id ) AND `product_category_id` = 61 ) AND `status` = 1 AND ( `banner_id` = 61 ) ) AND `ow_sys_banner_item`.`deleted_at` IS NULL ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000550s ]
SHOW FULL COLUMNS FROM `ow_product_category` [ RunTime:0.001237s ]
SELECT `id`,`name`,`level` FROM `ow_product_category` WHERE ( `language_id` = 1 AND `is_show` = 1 AND ( `pid` = 61 OR `id` = 61 ) ) AND `ow_product_category`.`deleted_at` IS NULL ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000534s ]
SELECT `id`,`category_id`,`spu`,`name`,`short_name`,`cover_image`,`desc` FROM `ow_product` WHERE ( `category_id` = 61 AND `language_id` = 1 AND `status` = 1 AND `is_sale` = 1 AND `is_show` = 1 ) AND `ow_product`.`deleted_at` IS NULL ORDER BY `sort` ASC,`created_at` DESC,`id` DESC [ RunTime:0.009612s ]
SHOW FULL COLUMNS FROM `ow_product_sku` [ RunTime:0.001245s ]
SELECT `id`,`product_id`,`sku`,`main_image`,`photo_album` FROM `ow_product_sku` WHERE `product_id` IN (10798,10797,10796,10772,10668,10667,10666,10664,3887,3886,3854,3853,3734,3733,3732,3731,3730,3727,3726,3725,3724,3723,3720,3719,3705,3704,3702,3678,3620,3619,3597,3576,3568,3565,3563,3562,3561,3556,3555,3552,3545,3514,3461,3457,3456,3453,3288,3287,3286,3285,3284,3271,3024,3023,3022,3020,3019,3018,3017,3014,2991,2990,2989,2986,2985,2977,2976,2895,2835,2769,2768,2754,2753,2740,2733,2707,2706,2703,2702,2701,2687,2685,2684,2675,2674,2635,2634,2633,2622,2620,2564,2561,2559,2545,2535,2499,2498,2494,2431,2430,2392,2390,2386,2385,2382,2358,2349,2348,2347,2346,2345,2303,2302,2301,2294,2293,2292,2291,2290,2286,2265,2229,2228,2210,1955,871,835,785,600,550,532,524,501,498,491,490,489,487,486,481,472,468,464,458,450,443,423,418,411,407,404,401,396,383,364,360,351,180,137,113,83,81,79,68,61,47,45,3508) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.005964s ]
SELECT * FROM `ow_product_sku_attr` WHERE `sku_id` IN (6562,6564,6587,6588,6595,6606,6607,6609,6610,6611,6613,6650,6678,6729,6730,6731,6732,6960,6970,6974,6975,6998,6999,7014,7023,7024,7027,7033,7037,7045,7050,7073,7080,7089,7097,7104,7105,7110,7121,7126,7127,7128,7129,7130,7131,7132,7134,7135,7136,7137,7147,7151,7186,7195,7220,7221,7222,7285,7546,7605,7606,7661,7662,7663,9085,9086,9087,9450,9451,9470,9471,9522,9555,9559,9560,9561,9562,9563,9564,9571,9572,9573,9574,9575,9576,9656,9657,9658,9659,9660,9672,9673,9704,9705,9710,9711,9712,9713,9719,9721,9778,9779,9854,9857,9858,9911,9912,9926,9940,9941,9943,9944,9949,10039,10041,10053,10054,10055,10105,10106,10115,10116,10118,10133,10134,10135,10138,10139,10166,10173,10186,10187,10202,10203,10277,10278,10413,10414,10511,10512,10522,10523,10528,10529,10530,10558,10561,10562,10563,10564,10567,10568,10569,11057,11058,11059,11080,11081,11082,11083,11084,11085,11086,11087,11088,11089,11090,11091,11092,11093,11094,11356,11359,11360,11361,11362,11363,11368,11431,11437,11438,11439,11477,11478,11487,11493,11494,11495,11496,11501,11502,11503,11505,11506,11507,11512,11520,11544,11567,11568,11569,11570,11631,11656,11658,11659,11674,11675,11676,11677,11678,11681,11682,11683,11684,11685,11690,11691,11692,11693,11694,11832,11833,11868,11869,12001,12002,12003,12004,12109,12110,12119,12120,12121) [ RunTime:0.001728s ]
SELECT `attr_name`,`id` FROM `ow_product_attr` WHERE `id` IN (1,13) [ RunTime:0.000394s ]