SHOW FULL COLUMNS FROM `mall_shop_config` [ RunTime:0.000873s ]
SELECT * FROM `mall_shop_config` WHERE `domain` = 'dimpou.com' LIMIT 1 [ RunTime:0.000653s ]
SHOW FULL COLUMNS FROM `mall_other_config` [ RunTime:0.000693s ]
SELECT `site_name`,`whatsapp_link`,`agreement`,`privacy`,`copyright`,`integral`,`seo_title`,`seo_keywords`,`seo_description`,`follow_us_facebook`,`follow_us_twitter`,`follow_us_instagram`,`follow_us_douyin`,`follow_us_weibo`,`follow_us_xiaohongshu`,`online_communication_whatsapp`,`online_communication_wechat`,`online_communication_line`,`hot`,`official`,`search_word` FROM `mall_other_config` WHERE `shop_id` = 38 LIMIT 1 [ RunTime:0.000446s ]
SHOW FULL COLUMNS FROM `mall_wxminiprograms` [ RunTime:0.000641s ]
SELECT `wxacode_url`,`urlscheme` FROM `mall_wxminiprograms` WHERE `hotel_appId` = 'b862a0deacca12d690dec0d17451bad1' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SHOW FULL COLUMNS FROM `mall_plugin_javascript` [ RunTime:0.000565s ]
SELECT `content` FROM `mall_plugin_javascript` WHERE `shop_id` = 38 AND `status` = 1 AND `is_audit` = 1 [ RunTime:0.000357s ]
SHOW FULL COLUMNS FROM `mall_banner` [ RunTime:0.000545s ]
SELECT `id`,`product_id`,`activity_id`,`title`,`img`,`jump_type`,`class`,`website` FROM `mall_banner` WHERE `shop_id` = 38 AND `type` = 6 AND `is_show` = 1 AND `start_time` <= '2023-03-30 23:09:51' AND `end_time` >= '2023-03-30 23:09:51' ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000498s ]
SHOW FULL COLUMNS FROM `mall_type` [ RunTime:0.000570s ]
SELECT `id`,`p_id`,`name`,`img`,`index_style` FROM `mall_type` WHERE `shop_id` = 38 AND `is_show` = 1 ORDER BY `sort` DESC [ RunTime:0.000872s ]
SHOW FULL COLUMNS FROM `mall_partner` [ RunTime:0.000531s ]
SELECT `name`,`link`,`img` FROM `mall_partner` WHERE `shop_id` = 38 AND `is_show` = 1 ORDER BY `sort` DESC [ RunTime:0.000367s ]
SHOW FULL COLUMNS FROM `mall_web_menu` [ RunTime:0.000495s ]
SELECT `id`,`p_id`,`name`,`url`,`target` FROM `mall_web_menu` WHERE `shop_id` = 38 AND `type` = 1 AND `is_show` = 1 ORDER BY `sort` DESC [ RunTime:0.000520s ]
SELECT `id`,`p_id`,`name`,`url`,`target` FROM `mall_web_menu` WHERE `shop_id` = 38 AND `type` = 2 AND `is_show` = 1 ORDER BY `sort` DESC [ RunTime:0.000545s ]
SHOW FULL COLUMNS FROM `mall_wxminiprograms_icons` [ RunTime:0.000461s ]
SELECT `name`,`path`,`icon` FROM `mall_wxminiprograms_icons` WHERE `group` = 5 AND `theme` IN ('theme-cyan','theme-common') [ RunTime:0.000398s ]
SELECT `user_template_id`,`authorizer_appid` FROM `mall_wxminiprograms` WHERE `hotel_appId` = 'b862a0deacca12d690dec0d17451bad1' LIMIT 1 [ RunTime:0.000348s ]
SHOW FULL COLUMNS FROM `mall_plugin_analytics` [ RunTime:0.000456s ]
SELECT `google_id`,`google_status`,`facebook_pixel_id`,`facebook_status`,`yahoo_project_id`,`yahoo_pixel_id`,`yahoo_status` FROM `mall_plugin_analytics` WHERE `shop_id` = 38 LIMIT 1 [ RunTime:0.000340s ]
SHOW FULL COLUMNS FROM `mall_product` [ RunTime:0.000554s ]
SELECT * FROM `mall_product` WHERE `shop_id` = 38 AND `id` = 3542 LIMIT 1 [ RunTime:0.000422s ]
SELECT * FROM `mall_type` WHERE `shop_id` = 38 AND `is_show` = 1 [ RunTime:0.001127s ]
SHOW FULL COLUMNS FROM `mall_pro_attribute` [ RunTime:0.000478s ]
SELECT * FROM `mall_pro_attribute` WHERE `pro_id` = 3542 ORDER BY `sort` ASC [ RunTime:0.000441s ]
SHOW FULL COLUMNS FROM `mall_pro_attribute_value` [ RunTime:0.000459s ]
SELECT * FROM `mall_pro_attribute_value` WHERE `attribute_id` = 318 ORDER BY `sort` ASC [ RunTime:0.000578s ]
SHOW FULL COLUMNS FROM `mall_product_add_service_group` [ RunTime:0.000597s ]
SELECT `id`,`title`,`type` FROM `mall_product_add_service_group` WHERE `product_id` = 3542 AND `shop_id` = 38 [ RunTime:0.000362s ]
SHOW FULL COLUMNS FROM `mall_product_sku` [ RunTime:0.000489s ]
SELECT `code`,`stock` FROM `mall_product_sku` WHERE `shop_id` = 38 AND `code` IN ('1000227212461','100022721246222') [ RunTime:0.000402s ]
SHOW FULL COLUMNS FROM `mall_tag` [ RunTime:0.000486s ]
SELECT `words` FROM `mall_tag` WHERE `id` = 0 AND `shop_id` = 38 [ RunTime:0.000311s ]
SHOW FULL COLUMNS FROM `mall_exchange_product` [ RunTime:0.000470s ]
SELECT `pro_id`,`product_id`,`spec_id`,`exchange_price`,`num` FROM `mall_exchange_product` WHERE `pro_id` = 3542 [ RunTime:0.000303s ]
SHOW FULL COLUMNS FROM `mall_evaluate` [ RunTime:0.000453s ]
SELECT AVG(`score`) AS think_avg FROM `mall_evaluate` WHERE `pro_id` = 3542 LIMIT 1 [ RunTime:0.000341s ]
SELECT COUNT(`id`) AS think_count FROM `mall_evaluate` WHERE `pro_id` = 3542 LIMIT 1 [ RunTime:0.000319s ]
SELECT COUNT(`id`) AS think_count FROM `mall_evaluate` WHERE `pro_id` = 3542 AND `is_add` = 1 LIMIT 1 [ RunTime:0.000321s ]
SELECT COUNT(`id`) AS think_count FROM `mall_evaluate` WHERE `pro_id` = 3542 AND `is_img` = 1 LIMIT 1 [ RunTime:0.000304s ]
SHOW FULL COLUMNS FROM `mall_activity` [ RunTime:0.000501s ]
SELECT * FROM `mall_activity` WHERE `shop_id` = 38 AND `status` = 1 AND `start_time` <= '2023-03-30' AND `end_time` >= '2023-03-30' ORDER BY `price` [ RunTime:0.000441s ]
SHOW FULL COLUMNS FROM `mall_coupons` [ RunTime:0.000536s ]
SELECT * FROM `mall_coupons` WHERE `shop_id` = 38 AND `end_time` >= '2023-03-30' AND `member` = 0 AND `status` = 1 AND `is_public` = 1 AND FIND_IN_SET('3542', `pro_ids`) [ RunTime:0.000471s ]
SELECT * FROM `mall_coupons` WHERE `shop_id` = 38 AND `end_time` >= '2023-03-30' AND `member` = 0 AND `status` = 1 AND `is_public` = 1 AND FIND_IN_SET('1271', `pro_type`) [ RunTime:0.001673s ]
SELECT `id`,`p_id`,`name` FROM `mall_type` WHERE `shop_id` = 38 AND `is_show` = 1 [ RunTime:0.000853s ]
SELECT `id`,`p_id`,`name`,`img` FROM `mall_type` WHERE `shop_id` = 38 AND `is_show` = 1 [ RunTime:0.000870s ]
SELECT COUNT(*) AS think_count FROM `mall_product` WHERE `is_up` = 1 AND `shop_id` = 38 AND `is_recommend` = 1 AND ( ( FIND_IN_SET('1271', `class`) ) ) LIMIT 1 [ RunTime:0.002328s ]
SELECT `id`,`name`,`price2`,`spec`,`img`,`promotion_words`,`promotion_words_color` FROM `mall_product` WHERE `is_up` = 1 AND `shop_id` = 38 AND `is_recommend` = 1 AND ( ( FIND_IN_SET('1271', `class`) ) ) ORDER BY RAND() LIMIT 0,5 [ RunTime:0.004342s ]
SELECT `stock` FROM `mall_product_sku` WHERE `code` = '1000227212461' AND `shop_id` = 38 LIMIT 1 [ RunTime:0.000412s ]
SELECT `stock` FROM `mall_product_sku` WHERE `code` = '100022721246222' AND `shop_id` = 38 LIMIT 1 [ RunTime:0.000333s ]
SELECT `stock` FROM `mall_product_sku` WHERE `code` = '1000398260841' AND `shop_id` = 38 LIMIT 1 [ RunTime:0.000288s ]
SELECT `stock` FROM `mall_product_sku` WHERE `code` = '1000398260842' AND `shop_id` = 38 LIMIT 1 [ RunTime:0.000281s ]
SELECT `stock` FROM `mall_product_sku` WHERE `code` = '1000398260843' AND `shop_id` = 38 LIMIT 1 [ RunTime:0.000280s ]
SELECT `stock` FROM `mall_product_sku` WHERE `code` = '1000398260844' AND `shop_id` = 38 LIMIT 1 [ RunTime:0.000281s ]
SELECT `stock` FROM `mall_product_sku` WHERE `code` = '1000398260845' AND `shop_id` = 38 LIMIT 1 [ RunTime:0.000319s ]
SELECT `stock` FROM `mall_product_sku` WHERE `code` = '1000398260846' AND `shop_id` = 38 LIMIT 1 [ RunTime:0.000282s ]
SELECT `stock` FROM `mall_product_sku` WHERE `code` = '1000398260847' AND `shop_id` = 38 LIMIT 1 [ RunTime:0.000270s ]
SELECT `stock` FROM `mall_product_sku` WHERE `code` = '1000398260848' AND `shop_id` = 38 LIMIT 1 [ RunTime:0.000319s ]
SELECT `stock` FROM `mall_product_sku` WHERE `code` = '1000117920591' AND `shop_id` = 38 LIMIT 1 [ RunTime:0.000286s ]
SELECT `stock` FROM `mall_product_sku` WHERE `code` = '1000117920592' AND `shop_id` = 38 LIMIT 1 [ RunTime:0.000316s ]
SELECT `stock` FROM `mall_product_sku` WHERE `code` = '1000227212181' AND `shop_id` = 38 LIMIT 1 [ RunTime:0.000317s ]
SELECT `stock` FROM `mall_product_sku` WHERE `code` = '1000227212182' AND `shop_id` = 38 LIMIT 1 [ RunTime:0.000282s ]
SHOW FULL COLUMNS FROM `mall_deal` [ RunTime:0.000507s ]
INSERT INTO `mall_deal` SET `type` = 1 , `shop_id` = 38 , `create_time` = '2023-03-30 23:09:51' [ RunTime:0.004228s ]
SHOW FULL COLUMNS FROM `mall_count_rate` [ RunTime:0.000629s ]
UPDATE `mall_count_rate` SET `click` = `click` + 1 WHERE `product_id` = 3542 [ RunTime:0.004250s ]
SHOW FULL COLUMNS FROM `mall_count_click_product` [ RunTime:0.000574s ]
INSERT INTO `mall_count_click_product` SET `product_id` = 3542 , `date` = '2023-03-30' [ RunTime:0.003603s ]
SELECT `id` FROM `mall_shop_config` WHERE `domain` = 'dimpou.com' LIMIT 1 [ RunTime:0.000587s ]
SHOW FULL COLUMNS FROM `mall_visit` [ RunTime:0.000588s ]