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.000553s ]
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.000595s ]
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.008017s ]
SHOW FULL COLUMNS FROM `ow_sys_navigation_item` [ RunTime:0.001368s ]
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.000545s ]
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.000731s ]
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.000531s ]
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.000421s ]
SHOW FULL COLUMNS FROM `ow_sys_banner_item` [ RunTime:0.001394s ]
SHOW FULL COLUMNS FROM `ow_sys_banner_prod_cate_mapping` [ RunTime:0.001086s ]
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` = 23 ) AND `status` = 1 AND ( `banner_id` = 61 ) ) AND `ow_sys_banner_item`.`deleted_at` IS NULL ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000540s ]
SHOW FULL COLUMNS FROM `ow_product_category` [ RunTime:0.001194s ]
SELECT `id`,`name`,`level` FROM `ow_product_category` WHERE ( `language_id` = 1 AND `is_show` = 1 AND ( `pid` = 23 OR `id` = 23 ) ) AND `ow_product_category`.`deleted_at` IS NULL ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000558s ]
SELECT `id`,`category_id`,`spu`,`name`,`short_name`,`cover_image`,`desc` FROM `ow_product` WHERE ( `category_id` IN (76,71,70,69) 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.009883s ]
SHOW FULL COLUMNS FROM `ow_product_sku` [ RunTime:0.001131s ]
SELECT `id`,`product_id`,`sku`,`main_image`,`photo_album` FROM `ow_product_sku` WHERE `product_id` IN (10788,10701,10213,3637,3593,3277,3276,3093,3092,3091,3081,2968,2967,2825,2774,3684,2764,2762,2741,2739,2731,2730,2705,2704,2695,2694,2677,2676,2672,2670,2668,2658,2651,2650,2649,2629,2628,2595,2593,2591,2589,2585,2565,2543,2533,2532,2530,2529,2522,2517,2516,2502,2497,2482,2481,2480,2479,2478,2466,2457,2454,2424,2411,2410,2409,2375,2372,2364,2363,2331,2330,2329,2324,2319,2318,2316,2312,2279,2252,2132,2070,2068,2046,2027,2005,1881,887,886,874,864,801,800,799,798,763,758,656,628,624,622,620,619,618,617,616,615,614,613,612,611,610,609,608,607,604,601,540,525,445,444,442,427,414,412,409,400,398,395,390,387,386,384,381,271,214,210,197,196,195,194,183,181,179,178,176,175,174,170,169,167,148,135,133,132,112,95,84,69,67,66,65,64,56,26,25,22,21,20,15,1961,1963,1962,1960) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.005878s ]
SELECT * FROM `ow_product_sku_attr` WHERE `sku_id` IN (6501,6506,6507,6508,6509,6510,6511,6512,6513,6514,6515,6516,6517,6518,6519,6520,6521,6525,6526,6527,6528,6529,6577,6578,6591,6592,6593,6594,6596,6614,6626,6649,6669,6670,6673,6674,6675,6676,6690,6691,6713,6715,6716,6717,6718,6719,6723,6724,6725,6727,6728,6733,6734,6735,6736,6737,6739,6758,6759,6760,6761,6788,6794,6795,6796,6865,6866,6867,6868,6996,7000,7002,7003,7004,7007,7013,7016,7018,7019,7020,7021,7022,7035,7038,7041,7054,7072,7074,7075,7187,7188,7205,7206,7286,7289,7292,7293,7294,7295,7296,7297,7298,7299,7300,7301,7302,7303,7304,7305,7308,7310,7314,7349,7501,7502,7509,7510,7559,7560,7561,7562,7647,7666,7682,7683,8976,9094,9095,9096,9097,9144,9173,9196,9235,9236,9237,9241,9242,9243,9319,9503,9546,9589,9593,9595,9596,9597,9613,9618,9619,9620,9621,9622,9623,9679,9680,9681,9682,9693,9696,9749,9750,9751,9768,9803,9806,9816,9834,9835,9836,9837,9838,9856,9861,9862,9885,9886,9887,9894,9905,9906,9908,9909,9924,9950,9951,9980,9984,9986,9988,9990,10047,10048,10049,10072,10073,10074,10081,10093,10095,10097,10098,10099,10100,10107,10108,10125,10126,10136,10137,10163,10164,10172,10174,10195,10196,10197,10198,10208,10262,10502,10503,10661,10671,10672,10673,11072,11073,11540,11589,11590,11638,11913,12036,12037,12038,12039,12118,12240) [ RunTime:0.001730s ]
SELECT `attr_name`,`id` FROM `ow_product_attr` WHERE `id` IN (1,3,11) [ RunTime:0.000394s ]