SHOW FULL COLUMNS FROM `mall_shop_config` [ RunTime:0.000891s ]
SELECT * FROM `mall_shop_config` WHERE `domain` = 'dimpou.com' LIMIT 1 [ RunTime:0.000603s ]
SHOW FULL COLUMNS FROM `mall_other_config` [ RunTime:0.000738s ]
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.000484s ]
SHOW FULL COLUMNS FROM `mall_wxminiprograms` [ RunTime:0.000643s ]
SELECT `wxacode_url`,`urlscheme` FROM `mall_wxminiprograms` WHERE `hotel_appId` = 'b862a0deacca12d690dec0d17451bad1' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SHOW FULL COLUMNS FROM `mall_plugin_javascript` [ RunTime:0.000515s ]
SELECT `content` FROM `mall_plugin_javascript` WHERE `shop_id` = 38 AND `status` = 1 AND `is_audit` = 1 [ RunTime:0.000349s ]
SHOW FULL COLUMNS FROM `mall_banner` [ RunTime:0.000561s ]
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:06:51' AND `end_time` >= '2023-03-30 23:06:51' ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000460s ]
SHOW FULL COLUMNS FROM `mall_type` [ RunTime:0.000558s ]
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.000897s ]
SHOW FULL COLUMNS FROM `mall_partner` [ RunTime:0.000558s ]
SELECT `name`,`link`,`img` FROM `mall_partner` WHERE `shop_id` = 38 AND `is_show` = 1 ORDER BY `sort` DESC [ RunTime:0.000393s ]
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.000500s ]
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.000488s ]
SELECT `name`,`path`,`icon` FROM `mall_wxminiprograms_icons` WHERE `group` = 5 AND `theme` IN ('theme-cyan','theme-common') [ RunTime:0.000396s ]
SELECT `user_template_id`,`authorizer_appid` FROM `mall_wxminiprograms` WHERE `hotel_appId` = 'b862a0deacca12d690dec0d17451bad1' LIMIT 1 [ RunTime:0.000394s ]
SHOW FULL COLUMNS FROM `mall_plugin_analytics` [ RunTime:0.000505s ]
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.000338s ]
SHOW FULL COLUMNS FROM `mall_product` [ RunTime:0.000604s ]
SELECT * FROM `mall_product` WHERE `shop_id` = 38 AND `id` = 3543 LIMIT 1 [ RunTime:0.000441s ]
SELECT * FROM `mall_type` WHERE `shop_id` = 38 AND `is_show` = 1 [ RunTime:0.001196s ]
SHOW FULL COLUMNS FROM `mall_pro_attribute` [ RunTime:0.000494s ]
SELECT * FROM `mall_pro_attribute` WHERE `pro_id` = 3543 ORDER BY `sort` ASC [ RunTime:0.000455s ]
SHOW FULL COLUMNS FROM `mall_pro_attribute_value` [ RunTime:0.000476s ]
SELECT * FROM `mall_pro_attribute_value` WHERE `attribute_id` = 319 ORDER BY `sort` ASC [ RunTime:0.000598s ]
SHOW FULL COLUMNS FROM `mall_product_add_service_group` [ RunTime:0.000528s ]
SELECT `id`,`title`,`type` FROM `mall_product_add_service_group` WHERE `product_id` = 3543 AND `shop_id` = 38 [ RunTime:0.000310s ]
SHOW FULL COLUMNS FROM `mall_product_sku` [ RunTime:0.000453s ]
SELECT `code`,`stock` FROM `mall_product_sku` WHERE `shop_id` = 38 AND `code` IN ('1000227212181','1000227212182') [ RunTime:0.000362s ]
SHOW FULL COLUMNS FROM `mall_tag` [ RunTime:0.000474s ]
SELECT `words` FROM `mall_tag` WHERE `id` = 0 AND `shop_id` = 38 [ RunTime:0.000318s ]
SHOW FULL COLUMNS FROM `mall_exchange_product` [ RunTime:0.000478s ]
SELECT `pro_id`,`product_id`,`spec_id`,`exchange_price`,`num` FROM `mall_exchange_product` WHERE `pro_id` = 3543 [ RunTime:0.000318s ]
SHOW FULL COLUMNS FROM `mall_evaluate` [ RunTime:0.000482s ]
SELECT AVG(`score`) AS think_avg FROM `mall_evaluate` WHERE `pro_id` = 3543 LIMIT 1 [ RunTime:0.000336s ]
SELECT COUNT(`id`) AS think_count FROM `mall_evaluate` WHERE `pro_id` = 3543 LIMIT 1 [ RunTime:0.000349s ]
SELECT COUNT(`id`) AS think_count FROM `mall_evaluate` WHERE `pro_id` = 3543 AND `is_add` = 1 LIMIT 1 [ RunTime:0.000339s ]
SELECT COUNT(`id`) AS think_count FROM `mall_evaluate` WHERE `pro_id` = 3543 AND `is_img` = 1 LIMIT 1 [ RunTime:0.000304s ]
SHOW FULL COLUMNS FROM `mall_activity` [ RunTime:0.000528s ]
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.000432s ]
SHOW FULL COLUMNS FROM `mall_coupons` [ RunTime:0.000528s ]
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('3543', `pro_ids`) [ RunTime:0.000501s ]
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.000437s ]
SELECT `id`,`p_id`,`name` FROM `mall_type` WHERE `shop_id` = 38 AND `is_show` = 1 [ RunTime:0.000799s ]
SELECT `id`,`p_id`,`name`,`img` FROM `mall_type` WHERE `shop_id` = 38 AND `is_show` = 1 [ RunTime:0.000883s ]
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.002395s ]
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.004487s ]
SELECT `stock` FROM `mall_product_sku` WHERE `code` = '1000227212181' AND `shop_id` = 38 LIMIT 1 [ RunTime:0.000400s ]
SELECT `stock` FROM `mall_product_sku` WHERE `code` = '1000227212182' AND `shop_id` = 38 LIMIT 1 [ RunTime:0.000371s ]
SELECT `stock` FROM `mall_product_sku` WHERE `code` = '1000117920591' AND `shop_id` = 38 LIMIT 1 [ RunTime:0.000342s ]
SELECT `stock` FROM `mall_product_sku` WHERE `code` = '1000117920592' AND `shop_id` = 38 LIMIT 1 [ RunTime:0.000331s ]
SELECT `stock` FROM `mall_product_sku` WHERE `code` = '1000227212461' AND `shop_id` = 38 LIMIT 1 [ RunTime:0.000299s ]
SELECT `stock` FROM `mall_product_sku` WHERE `code` = '100022721246222' AND `shop_id` = 38 LIMIT 1 [ RunTime:0.000343s ]
SELECT `stock` FROM `mall_product_sku` WHERE `code` = '1000398260841' AND `shop_id` = 38 LIMIT 1 [ RunTime:0.000310s ]
SELECT `stock` FROM `mall_product_sku` WHERE `code` = '1000398260842' AND `shop_id` = 38 LIMIT 1 [ RunTime:0.000304s ]
SELECT `stock` FROM `mall_product_sku` WHERE `code` = '1000398260843' AND `shop_id` = 38 LIMIT 1 [ RunTime:0.000300s ]
SELECT `stock` FROM `mall_product_sku` WHERE `code` = '1000398260844' AND `shop_id` = 38 LIMIT 1 [ RunTime:0.000358s ]
SELECT `stock` FROM `mall_product_sku` WHERE `code` = '1000398260845' AND `shop_id` = 38 LIMIT 1 [ RunTime:0.000320s ]
SELECT `stock` FROM `mall_product_sku` WHERE `code` = '1000398260846' AND `shop_id` = 38 LIMIT 1 [ RunTime:0.000294s ]
SELECT `stock` FROM `mall_product_sku` WHERE `code` = '1000398260847' AND `shop_id` = 38 LIMIT 1 [ RunTime:0.000273s ]
SELECT `stock` FROM `mall_product_sku` WHERE `code` = '1000398260848' AND `shop_id` = 38 LIMIT 1 [ RunTime:0.000276s ]
SHOW FULL COLUMNS FROM `mall_deal` [ RunTime:0.000475s ]
INSERT INTO `mall_deal` SET `type` = 1 , `shop_id` = 38 , `create_time` = '2023-03-30 23:06:51' [ RunTime:0.004093s ]
SHOW FULL COLUMNS FROM `mall_count_rate` [ RunTime:0.000567s ]
UPDATE `mall_count_rate` SET `click` = `click` + 1 WHERE `product_id` = 3543 [ RunTime:0.005691s ]
SHOW FULL COLUMNS FROM `mall_count_click_product` [ RunTime:0.000550s ]
INSERT INTO `mall_count_click_product` SET `product_id` = 3543 , `date` = '2023-03-30' [ RunTime:0.003464s ]
SELECT `id` FROM `mall_shop_config` WHERE `domain` = 'dimpou.com' LIMIT 1 [ RunTime:0.000604s ]
SHOW FULL COLUMNS FROM `mall_visit` [ RunTime:0.000553s ]