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.000641s ]
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.000822s ]
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.008040s ]
SHOW FULL COLUMNS FROM `ow_sys_navigation_item` [ RunTime:0.001859s ]
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.000600s ]
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.000723s ]
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.000455s ]
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.000327s ]
SHOW FULL COLUMNS FROM `ow_sys_banner_item` [ RunTime:0.001261s ]
SHOW FULL COLUMNS FROM `ow_sys_banner_prod_cate_mapping` [ RunTime:0.001039s ]
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` = 76 ) AND `status` = 1 AND ( `banner_id` = 61 ) ) AND `ow_sys_banner_item`.`deleted_at` IS NULL ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000495s ]
SHOW FULL COLUMNS FROM `ow_product_category` [ RunTime:0.001113s ]
SELECT `id`,`name`,`level` FROM `ow_product_category` WHERE ( `language_id` = 1 AND `is_show` = 1 AND ( `pid` = 76 OR `id` = 76 ) ) AND `ow_product_category`.`deleted_at` IS NULL ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000525s ]
SELECT `id`,`category_id`,`spu`,`name`,`short_name`,`cover_image`,`desc` FROM `ow_product` WHERE ( `category_id` = 76 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.009388s ]
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,10213,3637,3593,3093,3092,3091,2825,2774,3684,2764,2762,2741,2739,2730,2705,2704,2695,2694,2677,2676,2672,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,2364,2363,2331,2330,2329,2324,2319,2318,2316,2312,2279,2252,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,427,398,395,390,386,381,271,197,196,195,194,181,179,178,176,175,174,170,169,167,135,133,132,95,84,69,67,66,65,64,56) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.005341s ]
SELECT * FROM `ow_product_sku_attr` WHERE `sku_id` IN (6577,6578,6591,6592,6593,6594,6596,6614,6626,6669,6670,6673,6674,6675,6676,6713,6715,6716,6717,6718,6719,6723,6724,6725,6727,6728,6733,6734,6735,6736,6737,6758,6759,6760,6761,6865,6866,6867,6868,6996,7002,7007,7013,7016,7054,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,9144,9173,9196,9503,9546,9589,9593,9595,9596,9597,9613,9618,9619,9620,9621,9622,9623,9679,9680,9681,9682,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,10097,10098,10099,10100,10107,10108,10125,10126,10136,10137,10163,10172,10174,10195,10196,10197,10198,10208,10262,10671,10672,10673,11540,11589,11590,11638,11913,12118,12240) [ RunTime:0.001833s ]
SELECT `attr_name`,`id` FROM `ow_product_attr` WHERE `id` IN (1,3,11) [ RunTime:0.000348s ]