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.000595s ]
SELECT `id`,`pid`,`name`,`icon`,`level` FROM `ow_product_category` WHERE ( `language_id` = 2 AND `is_show` = 1 ) AND `ow_product_category`.`deleted_at` IS NULL ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000670s ]
SELECT `id`,`name`,`short_name`,`cover_image` FROM `ow_product` WHERE ( `language_id` = 2 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.013416s ]
SHOW FULL COLUMNS FROM `ow_sys_navigation_item` [ RunTime:0.001672s ]
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` = '2' AND `SysNavigationModel`.`status` = '1' ) ) AND `SysNavigationItemModel`.`status` = '1' ORDER BY `SysNavigationItemModel`.`sort` ASC,`SysNavigationItemModel`.`id` ASC [ RunTime:0.000692s ]
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` = '2' ) AND `c`.`deleted_at` IS NULL ORDER BY `c`.`sort` ASC,`c`.`id` DESC [ RunTime:0.001048s ]
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` = '2' AND `SysNavigationModel`.`status` = '1' ) ) AND `SysNavigationItemModel`.`status` = '1' ORDER BY `SysNavigationItemModel`.`sort` ASC,`SysNavigationItemModel`.`id` ASC [ RunTime:0.000704s ]
SELECT * FROM `ow_sys_banner` WHERE ( `at_platform` = 'pc' AND `unique_label` = 'BANNER_6808abd813d78' AND `language_id` = 2 AND `status` = 1 ) AND `ow_sys_banner`.`deleted_at` IS NULL [ RunTime:0.000417s ]
SHOW FULL COLUMNS FROM `ow_sys_banner_item` [ RunTime:0.001724s ]
SHOW FULL COLUMNS FROM `ow_sys_banner_prod_cate_mapping` [ RunTime:0.001333s ]
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` = 138 ) AND `status` = 1 AND ( `banner_id` = 63 ) ) AND `ow_sys_banner_item`.`deleted_at` IS NULL ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000486s ]
SHOW FULL COLUMNS FROM `ow_product_category` [ RunTime:0.001168s ]
SELECT `id`,`name`,`level` FROM `ow_product_category` WHERE ( `language_id` = 2 AND `is_show` = 1 AND ( `pid` = 138 OR `id` = 138 ) ) AND `ow_product_category`.`deleted_at` IS NULL ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000492s ]
SELECT `id`,`category_id`,`spu`,`name`,`short_name`,`cover_image`,`desc` FROM `ow_product` WHERE ( `category_id` = 138 AND `language_id` = 2 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.016175s ]
SHOW FULL COLUMNS FROM `ow_product_sku` [ RunTime:0.001524s ]
SELECT `id`,`product_id`,`sku`,`main_image`,`photo_album` FROM `ow_product_sku` WHERE `product_id` IN (10842,9763,3839,3825,3824,3756,3755,3753,3752,3751,3750,3749,3748,3747,3746,3745,3744,3737,3711,3710,3700,3696,3695,3694,3693,3692,3691,3690,3671,3670,3665,3448,3447,3446,3430,3429,3396,3387,3386,3385,3384,3382,3381,3380,3379,3378,3377,3376,3375,3374,3373,3359,3358,3357,3356,3355,3354,3353,3352,3351,3316,3314,3313,3312,3350,3349,3348,3347,3346,3293,3257,3256,3255,3254,3252,3251,3250,3249,3247,3246,3244,3243,3242,3239,3238,3237,3236,3230,3229,3228,3227,3226,3225,3224,3222,3221,3220,3219,3211,3210,3209,3208,3207,3206,3185,3203,3202,3201,3200,3199,3198,3197,3196,3195,3194,3193,3192,3191,3190,3189,3188,3187,3186,3180,3179,3178,3177,3176,3175,3174,3173,3172,3171,3170,3169,3168,3167,3166,3165,3164,3163,3162,3161,3152,3134,3133,3132,3040,3039,3038,3037,3035,3034,3033,3032,3031,3030,3029,3028,3027,3009,3005,3004,3003,3002,3000,2997,2966,3217,2893,2872,3322,3321,3320,3319,3318,3317,3315,3311,2814,2812,2798,2797,2796,2793,2789,2784,2783,2782,2781,2778,2737,2721,2712,2711,2710,2709,2691,2689,2688,2682,2679,2563,2562,2536,2528,2421,2420,2393,2391,2384,2357,2356,2354,2353,2352,2351,2350,2311,2310,2309,2308,2307,2306,2305,2304,2300,2299,2298,2297,2240,2231,2230,2211,2173,2038,1958,1852,1789,1532,1427,1415,1399,1395,1391,1385,1382,1370,1349,1339,1337,3442,1333,1330,1327,1290,1269,899,1042,1008,1007,995,985,983,972,971,970,968,967,966,965,10684,10683,3653,3652,3608,3607,3584,3578,3564,3560,3559,3558,3541,3540,3530,3528,3527,3526,3510,3509,3474,3473,3470,3131,3511) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.007938s ]
SELECT * FROM `ow_product_sku_attr` WHERE `sku_id` IN (7695,7794,7795,7796,7797,7799,7800,7801,7821,7822,7824,7835,7847,7848,7849,8190,8213,8214,8261,8262,8265,8275,8277,8278,8288,8312,8324,8327,8335,8341,8346,8365,8366,8367,8368,8369,8385,8523,8866,8939,8940,9090,9091,9092,9384,9452,9453,9472,9473,9482,9567,9568,9585,9586,9587,9588,9661,9662,9663,9664,9665,9668,9669,9670,9671,9708,9709,9720,9722,9904,9913,9945,9946,9947,9948,10110,10113,10119,10120,10122,10141,10142,10143,10144,10153,10170,10215,10216,10217,10218,10223,10227,10230,10231,10232,10246,10248,10370,10371,10501,10540,10544,10546,10547,10548,10549,10553,10575,10576,10577,10578,10579,10580,10581,10582,10584,10585,10586,10784,10785,10786,10807,10808,10809,10810,10811,10812,10984,10985,10986,10987,10988,10989,10999,11000,11001,11006,11007,11008,11120,11196,11346,11347,11348,11349,11350,11383,11384,11432,11433,11434,11456,11457,11458,11462,11472,11473,11498,11499,11500,11504,11522,11528,11554,11555,11605,11606,11618,11623,11624,11644,11645,11646,11647,11648,11649,11650,11654,11665,11666,11703,11710,11711,11712,11713,11714,11715,11716,11717,11718,11719,11721,11722,11796,11797,11811,12174,12181,12209,12230,12231,12232,12233,12234,12235,12236,12237,12238,12239,12266,12267,12268,12269,12315,12347,12348,12367,12368,12409,12410,12411,12412,12413,12414,12415,12416,12417,12418,12419,12420,12421,12422,12423,12424,12457,12458,12459,12460,12461,12462,12463,12464,12465,12466,12467,12468,12469,12470,12471,12472,12473,12474,12475,12476,12477,12478,12479,12480,12481,12482,12483,12484,12485,12486,12487,12488,12489,12502,12503,12504,12505,12506,12507,12508,12509,12510,12511,12512,12513,12514,12515,12516,12517,12518,12519,12520,12521,12522,12523,12524,12525,12526,12527,12528,12529,12530,12531,12532,12533,12534,12535,12536,12537,12538,12539,12540,12541,12544,12545,12546,12547,12548,12549,12550,12551,12552,12553,12554,12555,12556,12557,12558,12559,12560,12561,12577,12578,12579,12581,12582,12583,12584,12585,12586,12587,12588,12592,12593,12594,12595,12596,12597,12598,12599,12600,12601,12602,12603,12604,12605,12606,12611,12612,12613,12614,12615,12616,12617,12618,12619,12620,12621,12625,12626,12627,12628,12629,12630,12631,12632,12633,12634,12635,12636,12637,12638,12639,12644,12645,12646,12647,12648,12649,12650,12651,12656,12657,12658,12675,12676,12677,12678,12679,12680,12681,12682,12683,12684,12685,12729,12730,12731,12732,12733,12734,12735,12736,12737,12738,12739,12740,12741,12742,12743,12744,12745,12746,12747,12748,12749,12750,12751,12752,12753,12754,12755,12756,12757,12758,12759,12760,12761,12762,12763,12777,12778,12779,12780,12781,12782,12783,12784,12785,12786,12787,12789,12790,12791,12792,12801,12802,12845,12846,12847,12848,12849,12850,12860,12880,12896,12897,12907,12948,12949,12997) [ RunTime:0.007593s ]
SELECT `attr_name`,`id` FROM `ow_product_attr` WHERE `id` IN (2,5) [ RunTime:0.000621s ]