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.000646s ]
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.000724s ]
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.008297s ]
SHOW FULL COLUMNS FROM `ow_sys_navigation_item` [ RunTime:0.001428s ]
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.000583s ]
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.000780s ]
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.000590s ]
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.000507s ]
SHOW FULL COLUMNS FROM `ow_sys_banner_item` [ RunTime:0.001309s ]
SHOW FULL COLUMNS FROM `ow_sys_banner_prod_cate_mapping` [ RunTime:0.001137s ]
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` = 77 ) AND `status` = 1 AND ( `banner_id` = 63 ) ) AND `ow_sys_banner_item`.`deleted_at` IS NULL ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000712s ]
SELECT `id`,`pid`,`name`,`path`,`level` FROM `ow_product_category` WHERE ( `language_id` = 2 AND `is_show` = 1 AND ( FIND_IN_SET('77', path) ) ) AND `ow_product_category`.`deleted_at` IS NULL ORDER BY `pid` ASC,`sort` ASC,`id` DESC [ RunTime:0.000586s ]
SHOW FULL COLUMNS FROM `ow_product` [ RunTime:0.001255s ]
SELECT * FROM (( SELECT `id`,`category_id`,`spu`,`name`,`cover_image`,`is_new`,(81) AS `group_mark` FROM `ow_product` WHERE ( `category_id` IN (101,102,103,100) 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 LIMIT 5 )) as a UNION ( SELECT `id`,`category_id`,`spu`,`name`,`cover_image`,`is_new`,(81) AS `group_mark` FROM `ow_product` WHERE `category_id` IN (101,102,103,100) AND `language_id` = 2 AND `status` = 1 AND `is_sale` = 1 AND `is_show` = 1 ORDER BY `sort` ASC,`created_at` DESC,`id` DESC LIMIT 5 ) UNION ( SELECT `id`,`category_id`,`spu`,`name`,`cover_image`,`is_new`,(82) AS `group_mark` FROM `ow_product` WHERE `category_id` = 140 AND `language_id` = 2 AND `status` = 1 AND `is_sale` = 1 AND `is_show` = 1 ORDER BY `sort` ASC,`created_at` DESC,`id` DESC LIMIT 5 ) UNION ( SELECT `id`,`category_id`,`spu`,`name`,`cover_image`,`is_new`,(83) AS `group_mark` FROM `ow_product` WHERE `category_id` IN (175,144,104) AND `language_id` = 2 AND `status` = 1 AND `is_sale` = 1 AND `is_show` = 1 ORDER BY `sort` ASC,`created_at` DESC,`id` DESC LIMIT 5 ) UNION ( SELECT `id`,`category_id`,`spu`,`name`,`cover_image`,`is_new`,(170) AS `group_mark` FROM `ow_product` WHERE `category_id` IN (174,173,172,171) AND `language_id` = 2 AND `status` = 1 AND `is_sale` = 1 AND `is_show` = 1 ORDER BY `sort` ASC,`created_at` DESC,`id` DESC LIMIT 5 ) UNION ( SELECT `id`,`category_id`,`spu`,`name`,`cover_image`,`is_new`,(85) AS `group_mark` FROM `ow_product` WHERE `category_id` IN (108,107,106,105) AND `language_id` = 2 AND `status` = 1 AND `is_sale` = 1 AND `is_show` = 1 ORDER BY `sort` ASC,`created_at` DESC,`id` DESC LIMIT 5 ) UNION ( SELECT `id`,`category_id`,`spu`,`name`,`cover_image`,`is_new`,(84) AS `group_mark` FROM `ow_product` WHERE `category_id` = 141 AND `language_id` = 2 AND `status` = 1 AND `is_sale` = 1 AND `is_show` = 1 ORDER BY `sort` ASC,`created_at` DESC,`id` DESC LIMIT 5 ) UNION ( SELECT `id`,`category_id`,`spu`,`name`,`cover_image`,`is_new`,(86) AS `group_mark` FROM `ow_product` WHERE `category_id` = 135 AND `language_id` = 2 AND `status` = 1 AND `is_sale` = 1 AND `is_show` = 1 ORDER BY `sort` ASC,`created_at` DESC,`id` DESC LIMIT 5 ) [ RunTime:0.064873s ]