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.002668s ]
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.002455s ]
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.009528s ]
SHOW FULL COLUMNS FROM `ow_sys_navigation_item` [ RunTime:0.001482s ]
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.000572s ]
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.000710s ]
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.000449s ]
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.000330s ]
SHOW FULL COLUMNS FROM `ow_sys_banner_item` [ RunTime:0.001269s ]
SHOW FULL COLUMNS FROM `ow_sys_banner_prod_cate_mapping` [ RunTime:0.001054s ]
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` = 99 ) AND `status` = 1 AND ( `banner_id` = 63 ) ) AND `ow_sys_banner_item`.`deleted_at` IS NULL ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000529s ]
SHOW FULL COLUMNS FROM `ow_product_category` [ RunTime:0.001207s ]
SELECT `id`,`name`,`level` FROM `ow_product_category` WHERE ( `language_id` = 2 AND `is_show` = 1 AND ( `pid` = 99 OR `id` = 99 ) ) AND `ow_product_category`.`deleted_at` IS NULL ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000486s ]
SELECT `id`,`category_id`,`spu`,`name`,`short_name`,`cover_image`,`desc` FROM `ow_product` WHERE ( `category_id` IN (139,131,130,129) 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.009457s ]
SHOW FULL COLUMNS FROM `ow_product_sku` [ RunTime:0.001165s ]
SELECT `id`,`product_id`,`sku`,`main_image`,`photo_album` FROM `ow_product_sku` WHERE `product_id` IN (10840,3842,3841,3840,3589,3445,3443,3444,3441,3440,3435,3434,3433,3432,3431,3439,3438,3417,3416,3415,3414,3406,3405,3404,3403,3402,3401,3399,3372,3371,3370,3369,3368,3367,3366,3365,3364,3363,3362,3361,3360,3345,3344,3343,3342,3341,3340,3339,3338,3310,3309,3308,3307,3306,3305,3304,3303,3302,3301,3297,3130,3100,3084,3069,2998,2979,2978,3218,2864,2859,2805,2804,2803,2802,2801,2792,2791,2780,2776,2771,2770,2735,2728,2727,2719,2718,2699,2697,2693,2681,2680,2673,2659,2655,2654,2652,2648,2631,2596,2590,2586,2558,2557,2551,2534,2521,2514,2503,2501,2488,2487,2486,2485,2484,2467,2459,2458,2456,2455,2418,2417,2412,2376,2373,2370,2369,2339,2337,2336,2321,2320,2317,2313,2275,2239,2206,2133,2131,2071,1704,988,987,1822,1821,1819,1762,1717,1655,1654,1615,1591,1257,1571,1566,1558,1557,1556,1555,1554,1553,1549,1548,1547,1540,1455,1376,1372,1371,1369,1328,1326,1324,1321,1313,1310,1306,1190,1134,1129,1127,1126,1119,1117,1116,1115,1114,1113,1058,1098,1096,1095,1092,1086,1010,913,1025,1018,1014,996,993,991,990,946,945,942,939,933,10844,10771,10770,10759,10758,10187,3635,3590,3475,2554) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.005629s ]
SELECT * FROM `ow_product_sku_attr` WHERE `sku_id` IN (7709,7734,7740,7741,7742,7743,7744,7751,7752,7753,7754,7755,7759,7760,7761,7762,7763,7826,7827,7830,7831,7833,7836,7853,7857,7861,7869,7912,7945,7946,7947,7948,7954,7957,7958,7963,7964,7965,7966,7989,7990,7991,7992,7993,7995,8006,8007,8008,8009,8010,8011,8012,8013,8014,8015,8019,8026,8027,8028,8095,8096,8097,8098,8174,8175,8234,8239,8242,8251,8254,8256,8257,8258,8259,8260,8263,8311,8313,8314,8318,8422,8423,8535,8542,8543,8544,8548,8549,8550,8551,8552,8553,8561,8566,8590,8614,8677,8678,8750,8764,8831,8832,8901,8903,8904,9244,9245,9246,9316,9317,9318,9447,9481,9590,9594,9628,9629,9630,9631,9634,9635,9688,9689,9690,9691,9694,9697,9752,9757,9758,9804,9805,9807,9808,9817,9818,9840,9841,9842,9843,9844,9860,9863,9864,9881,9882,9883,9892,9893,9932,9935,9938,9939,9981,9985,9991,10075,10077,10078,10082,10101,10102,10103,10104,10111,10112,10124,10128,10130,10150,10151,10160,10161,10205,10214,10225,10226,10235,10236,10237,10238,10239,10334,10335,10346,10347,10348,10514,10541,10664,10700,10750,11173,11267,11269,11331,11332,11333,11334,11340,11341,11385,11536,11537,11587,11812,11813,11814,12217,12228,12241,12242,12243,12244,12245,12246,12275,12304,12306,12311,12313,12314,12362,12392,12580,12661,12665,12666,12667,12668,12669,12670,12671,12672,12673,12674,12722,12723,12724,12725,12726,12727,12728,12764,12765,12766,12767,12768,12769,12770,12771,12772,12773,12774,12775,12776,12805,12808,12809,12810,12811,12812,12827,12828,12829,12830,12831,12851,12852,12853,12854,12855,12856,12857,12858,12859,12861,12862,12863,12864,12865,12866,12958,12959,12960,12961,12962,12963,12964,12965,12975,12976,12977,12978,12979,12980,12981,12982,12995,12998,13010) [ RunTime:0.001983s ]
SELECT `attr_name`,`id` FROM `ow_product_attr` WHERE `id` = 2 [ RunTime:0.000453s ]