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.000631s ]
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.000660s ]
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.008066s ]
SHOW FULL COLUMNS FROM `ow_sys_navigation_item` [ RunTime:0.001603s ]
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.000679s ]
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.000752s ]
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.000453s ]
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.000330s ]
SHOW FULL COLUMNS FROM `ow_sys_banner_item` [ RunTime:0.001275s ]
SHOW FULL COLUMNS FROM `ow_sys_banner_prod_cate_mapping` [ RunTime:0.001007s ]
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` = 19 ) AND `status` = 1 AND ( `banner_id` = 61 ) ) AND `ow_sys_banner_item`.`deleted_at` IS NULL ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000515s ]
SHOW FULL COLUMNS FROM `ow_product_category` [ RunTime:0.001199s ]
SELECT `id`,`name`,`level` FROM `ow_product_category` WHERE ( `language_id` = 1 AND `is_show` = 1 AND ( `pid` = 19 OR `id` = 19 ) ) AND `ow_product_category`.`deleted_at` IS NULL ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000585s ]
SELECT `id`,`category_id`,`spu`,`name`,`short_name`,`cover_image`,`desc` FROM `ow_product` WHERE ( `category_id` IN (56,55,54,53) 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.009534s ]
SHOW FULL COLUMNS FROM `ow_product_sku` [ RunTime:0.001111s ]
SELECT `id`,`product_id`,`sku`,`main_image`,`photo_album` FROM `ow_product_sku` WHERE `product_id` IN (3835,3834,3833,3826,3811,3810,3791,3790,3788,3787,3708,3689,3687,3628,3622,3617,3615,3604,3679,3592,3573,3328,3327,3326,3323,3260,3259,3258,3248,3077,3074,3059,3058,3057,3056,3055,3054,3050,3049,2960,2959,2952,2951,2932,2928,2927,2926,2918,2891,2855,2854,2853,2852,2851,2850,2849,2848,2844,2843,2837,2834,2833,2823,2822,2821,2817,2816,2773,2772,2580,2579,2537,2495,2448,2442,2436,2406,2340,2334,2332,2327,2325,2314,2278,2267,2262,2261,2235,2177,2166,2148,2136,2095,2083,2049,2045,1880,873,861,842,806,790,749,745,737,735,693,652,651,439,437,434,430,428,424,422,421,420,419,269,266,265,264,262,261,260,259,258,257,251,250,245,244,242,241,236,235,232,231,230,228,159,14,10,9,5,4,3,2,1,8) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.005608s ]
SELECT * FROM `ow_product_sku_attr` WHERE `sku_id` IN (6482,6483,6484,6485,6486,6487,6490,6491,6492,6493,6494,6495,6496,6500,6704,6817,6819,6820,6821,6822,6826,6827,6832,6833,6835,6836,6837,6843,6844,6850,6851,6852,6853,6854,6855,6856,6858,6859,6860,6863,7046,7047,7048,7049,7051,7055,7060,7064,7067,7069,7344,7345,7404,7462,7464,7477,7478,7479,7480,7484,7551,7568,7619,7644,7665,8975,9195,9199,9262,9274,9325,9326,9347,9348,9367,9368,9369,9370,9389,9390,9391,9392,9477,9518,9519,9526,9527,9545,9591,9614,9616,9624,9626,9636,9637,9638,9639,9746,9784,9790,9791,9797,9855,9914,9974,9975,10206,10207,10250,10251,10255,10256,10257,10258,10259,10260,10271,10272,10273,10274,10275,10276,10282,10283,10284,10301,10302,10303,10304,10305,10306,10310,10311,10312,10313,10314,10315,10316,10317,10318,10319,10320,10321,10322,10323,10324,10325,10326,10327,10406,10407,10408,10447,10448,10449,10457,10458,10459,10460,10461,10465,10486,10487,10494,10495,10596,10597,10610,10611,10612,10613,10614,10615,10616,10617,10618,10619,10620,10621,10622,10623,10624,10625,10626,10627,10652,10653,10656,10657,11002,11003,11004,11005,11033,11034,11035,11036,11037,11038,11039,11040,11041,11042,11043,11044,11131,11134,11135,11136,11517,11539,11551,11563,11565,11572,11578,11632,11641,11643,11663,11756,11757,11758,11760,11761,11782,11783,11798,11805,11806,11807) [ RunTime:0.001545s ]
SELECT `attr_name`,`id` FROM `ow_product_attr` WHERE `id` = 1 [ RunTime:0.000330s ]