[ SQL ] SHOW COLUMNS FROM `yoshop_upload_file` [ RunTime:0.000622s ]
[ SQL ] SELECT * FROM `yoshop_upload_file` WHERE `yoshop_upload_file`.`wxapp_id` = '10001' AND `file_id` = 13116 [ RunTime:0.000369s ]
[ SQL ] SELECT * FROM `yoshop_upload_file` WHERE `yoshop_upload_file`.`wxapp_id` = '10001' AND `file_id` = 11266 [ RunTime:0.000426s ]
[ SQL ] SELECT * FROM `yoshop_upload_file` WHERE `yoshop_upload_file`.`wxapp_id` = '10001' AND `file_id` = 11267 [ RunTime:0.000288s ]
[ SQL ] SELECT * FROM `yoshop_upload_file` WHERE `yoshop_upload_file`.`wxapp_id` = '10001' AND `file_id` = 10735 [ RunTime:0.000291s ]
[ SQL ] SELECT * FROM `yoshop_upload_file` WHERE `yoshop_upload_file`.`wxapp_id` = '10001' AND `file_id` = 11301 [ RunTime:0.000277s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_banner` [ RunTime:0.000940s ]
[ SQL ] SELECT `image_id` FROM `yoshop_banner` WHERE `yoshop_banner`.`wxapp_id` = '10001' AND `is_delete` = 0 AND `status` = 1 AND `positon` = 4 ORDER BY `sort` [ RunTime:0.000512s ]
[ SQL ] SELECT * FROM `yoshop_upload_file` WHERE `yoshop_upload_file`.`wxapp_id` = '10001' AND `file_id` IN (12989) [ RunTime:0.000458s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_user` [ RunTime:0.000860s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_memorial` [ RunTime:0.000565s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_memorial_log` [ RunTime:0.000619s ]
[ SQL ] SELECT * FROM `yoshop_memorial_log` WHERE `yoshop_memorial_log`.`wxapp_id` = '10001' AND ( `end_time` > 1730222770 or `end_time` = 0 ) ORDER BY `id` DESC [ RunTime:0.026317s ]
[ SQL ] SELECT * FROM `yoshop_user` WHERE `yoshop_user`.`wxapp_id` = '10001' AND `user_id` IN (11226,12688,12731,10047,10984,10014,10008,12790,12769,10204,12121,12759,12762,12756,12721,12702,11300,10378,10449,11482,12618,12726,12210,10408,11579,12643,11387,12570,12149,11929,12551,12548,11625,10443,10076,12374,10163,11295,11711,12312,10219,10005,12202,10118,11067,11340,11390,10294,10442,10440,10186,10166,10155,10001) [ RunTime:0.001266s ]
[ SQL ] SELECT * FROM `yoshop_memorial` WHERE `yoshop_memorial`.`wxapp_id` = '10001' AND `is_delete` = 0 AND `id` IN (574,998,1009,101,489,76,841,1029,1027,1020,173,839,1017,1015,1003,590,306,354,656,967,868,229,676,973,792,962,892,928,957,689,802,704,908,158,589,740,896,193,56,865,869,132,522,521,519,603,615,484,235,296,165,67,85,110,212,209,208,210,200,192,191,190,152,153,61,89,88,83,72,78,79,84,68,63,86,82,65,69,81,80,57,66,75,62,71,70,64,8,53,1) [ RunTime:0.001323s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_memorial_people` [ RunTime:0.000741s ]
[ SQL ] SELECT * FROM `yoshop_memorial_people` WHERE `yoshop_memorial_people`.`wxapp_id` = '10001' AND `memorial_id` IN (56,76,89,101,132,152,153,158,165,173,190,191,192,193,200,208,209,210,212,229,235,296,306,354,489,519,521,522,574,589,590,603,615,656,676,689,704,740,792,802,839,841,865,868,869,892,896,908,928,957,962,967,973,998,1003,1009,1015,1017,1020,1027,1029) [ RunTime:0.001363s ]
[ SQL ] SELECT * FROM `yoshop_upload_file` WHERE `yoshop_upload_file`.`wxapp_id` = '10001' AND `file_id` IN (10811,1,11557,11537,11749,11907,11911,11536,12160,12271,12272,12732,12735,12736,12738,11867,11513,12861,12862,12856,12890,12938,13201,13275,13449,11877,13447,13450,13451,13641,13687,13690,13733,13736,13764,13803,11608,11741,13851,13882,13947,13939,13966,13965,14007,14008,14042,13648,14067,14076) [ RunTime:0.000863s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) FROM `yoshop_memorial` `Memorial` INNER JOIN `yoshop_memorial_people` `MemorialPeople` ON `Memorial`.`id`=`MemorialPeople`.`memorial_id` WHERE `Memorial`.`wxapp_id` = '10001' AND ( ( DATE_FORMAT(brithday,'%m-%d') = '10-30' or DATE_FORMAT(dieday,'%m-%d') = '10-30' ) ) AND `is_delete` = 0 AND `is_private` = 0 GROUP BY `Memorial`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.002529s ]
[ SQL ] SELECT `Memorial`.* FROM `yoshop_memorial` `Memorial` INNER JOIN `yoshop_memorial_people` `MemorialPeople` ON `Memorial`.`id`=`MemorialPeople`.`memorial_id` WHERE `Memorial`.`wxapp_id` = '10001' AND ( ( DATE_FORMAT(brithday,'%m-%d') = '10-30' or DATE_FORMAT(dieday,'%m-%d') = '10-30' ) ) AND `is_delete` = 0 AND `is_private` = 0 GROUP BY `Memorial`.`id` ORDER BY `id` DESC LIMIT 0,3 [ RunTime:0.003031s ]
[ SQL ] SELECT * FROM `yoshop_memorial_people` WHERE `yoshop_memorial_people`.`wxapp_id` = '10001' AND `memorial_id` IN (1016,539,415) [ RunTime:0.001422s ]
[ SQL ] SELECT * FROM `yoshop_upload_file` WHERE `yoshop_upload_file`.`wxapp_id` = '10001' AND `file_id` IN (12471,1,14039) [ RunTime:0.000593s ]
[ SQL ] SELECT * FROM `yoshop_user` WHERE `yoshop_user`.`wxapp_id` = '10001' AND `user_id` IN (12757,11110,10703) [ RunTime:0.000521s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_memorial_area_category` [ RunTime:0.000593s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_memorial_area` [ RunTime:0.000396s ]
[ SQL ] SELECT * FROM `yoshop_memorial_area` WHERE `yoshop_memorial_area`.`wxapp_id` = '10001' AND `id` IN (0) [ RunTime:0.000285s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_article` [ RunTime:0.000576s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yoshop_article` WHERE ( `yoshop_article`.`wxapp_id` = '10001' AND `yoshop_article`.`wxapp_id` = '10001' ) AND `category_id` = 5 AND `article_status` = 1 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.001939s ]
[ SQL ] SELECT `article_id`,`article_title`,`show_type`,`category_id`,`image_id`,`article_sort`,`article_status`,`virtual_views`,`actual_views`,`is_delete`,`wxapp_id`,`create_time`,`update_time`,`sub_title`,`seo_keywords`,`seo_content` FROM `yoshop_article` WHERE ( `yoshop_article`.`wxapp_id` = '10001' AND `yoshop_article`.`wxapp_id` = '10001' ) AND `category_id` = 5 AND `article_status` = 1 AND `is_delete` = 0 ORDER BY `article_sort` ASC,`create_time` DESC LIMIT 0,13 [ RunTime:0.002200s ]
[ SQL ] SELECT * FROM `yoshop_upload_file` WHERE `yoshop_upload_file`.`wxapp_id` = '10001' AND `file_id` IN (13751,13584,13750,13460,13309,13475,13461,13266,13272) [ RunTime:0.000429s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_memorial_message` [ RunTime:0.000753s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yoshop_memorial_message` WHERE `yoshop_memorial_message`.`wxapp_id` = '10001' AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000703s ]
[ SQL ] SELECT * FROM `yoshop_memorial_message` WHERE `yoshop_memorial_message`.`wxapp_id` = '10001' AND `is_delete` = 0 ORDER BY `id` DESC LIMIT 0,7 [ RunTime:0.000319s ]
[ SQL ] SELECT `avatarUrl`,`nickName`,`user_id` FROM `yoshop_user` WHERE `yoshop_user`.`wxapp_id` = '10001' AND `user_id` IN (12688,12790,11912,12784,12788) [ RunTime:0.000412s ]
[ SQL ] SELECT `id`,`type`,`title` FROM `yoshop_memorial` WHERE `yoshop_memorial`.`wxapp_id` = '10001' AND `id` IN (998,1027,793,101,1026) [ RunTime:0.000284s ]
[ SQL ] SELECT * FROM `yoshop_memorial_people` WHERE `yoshop_memorial_people`.`wxapp_id` = '10001' AND `memorial_id` IN (101,793,998,1026,1027) [ RunTime:0.000884s ]
[ SQL ] SELECT * FROM `yoshop_upload_file` WHERE `yoshop_upload_file`.`wxapp_id` = '10001' AND `file_id` IN (1,13939,14059,14067) [ RunTime:0.000307s ]
[ SQL ] SELECT * FROM `yoshop_article` WHERE `yoshop_article`.`wxapp_id` = '10001' AND `category_id` = 9 LIMIT 1 [ RunTime:0.000414s ]
[ SQL ] SELECT * FROM `yoshop_upload_file` WHERE `yoshop_upload_file`.`wxapp_id` = '10001' AND `file_id` = 11772 [ RunTime:0.000318s ]
[ SQL ] UPDATE `yoshop_article` SET `actual_views`=`actual_views`+1 WHERE `article_id` = 20 [ RunTime:0.005767s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yoshop_article` WHERE ( `yoshop_article`.`wxapp_id` = '10001' AND `yoshop_article`.`wxapp_id` = '10001' ) AND `category_id` = 9 AND `article_status` = 1 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.002482s ]
[ SQL ] SELECT `article_id`,`article_title`,`show_type`,`category_id`,`image_id`,`article_sort`,`article_status`,`virtual_views`,`actual_views`,`is_delete`,`wxapp_id`,`create_time`,`update_time`,`sub_title`,`seo_keywords`,`seo_content` FROM `yoshop_article` WHERE ( `yoshop_article`.`wxapp_id` = '10001' AND `yoshop_article`.`wxapp_id` = '10001' ) AND `category_id` = 9 AND `article_status` = 1 AND `is_delete` = 0 ORDER BY `article_sort` ASC,`create_time` DESC LIMIT 0,10 [ RunTime:0.002476s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_memorial_article` [ RunTime:0.000685s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yoshop_memorial_article` WHERE `yoshop_memorial_article`.`wxapp_id` = '10001' AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000431s ]
[ SQL ] SELECT * FROM `yoshop_memorial_article` WHERE `yoshop_memorial_article`.`wxapp_id` = '10001' AND `is_delete` = 0 ORDER BY `id` DESC LIMIT 0,13 [ RunTime:0.000630s ]
[ SQL ] SELECT `id`,`title` FROM `yoshop_memorial` WHERE `yoshop_memorial`.`wxapp_id` = '10001' AND `id` IN (1009,1001,1006,961,913,886,665) [ RunTime:0.000365s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_goods` [ RunTime:0.000728s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yoshop_memorial_log` WHERE `yoshop_memorial_log`.`wxapp_id` = '10001' AND ( `end_time` > 1730222770 or `end_time` = 0 ) LIMIT 1 [ RunTime:0.011126s ]
[ SQL ] SELECT * FROM `yoshop_memorial_log` WHERE `yoshop_memorial_log`.`wxapp_id` = '10001' AND ( `end_time` > 1730222770 or `end_time` = 0 ) ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000612s ]
[ SQL ] SELECT * FROM `yoshop_user` WHERE `yoshop_user`.`wxapp_id` = '10001' AND `user_id` IN (11226,12688) [ RunTime:0.000493s ]
[ SQL ] SELECT * FROM `yoshop_memorial` WHERE `yoshop_memorial`.`wxapp_id` = '10001' AND `id` IN (574,998) [ RunTime:0.000401s ]
[ SQL ] SELECT `goods_id`,`goods_name`,`image_id` FROM `yoshop_goods` WHERE `yoshop_goods`.`wxapp_id` = '10001' AND `goods_id` IN (10021,10063,10141,10084,10420,10413,10559,10086) [ RunTime:0.000327s ]
[ SQL ] SELECT * FROM `yoshop_upload_file` WHERE `yoshop_upload_file`.`wxapp_id` = '10001' AND `file_id` IN (11959,11864,11781,10321,10377,12021,12042,13255) [ RunTime:0.000388s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_memorial_group` [ RunTime:0.000635s ]
[ SQL ] SELECT * FROM `yoshop_memorial_group` WHERE `yoshop_memorial_group`.`wxapp_id` = '10001' AND `memorial_id` = 574 AND `user_id` = 11226 GROUP BY id DESC LIMIT 1 [ RunTime:0.000660s ]
[ SQL ] SELECT * FROM `yoshop_memorial_group` WHERE `yoshop_memorial_group`.`wxapp_id` = '10001' AND `memorial_id` = 574 AND `user_id` = 11226 GROUP BY id DESC LIMIT 1 [ RunTime:0.000778s ]
[ SQL ] SELECT * FROM `yoshop_memorial_group` WHERE `yoshop_memorial_group`.`wxapp_id` = '10001' AND `memorial_id` = 574 AND `user_id` = 11226 GROUP BY id DESC LIMIT 1 [ RunTime:0.000732s ]
[ SQL ] SELECT * FROM `yoshop_memorial_group` WHERE `yoshop_memorial_group`.`wxapp_id` = '10001' AND `memorial_id` = 574 AND `user_id` = 11226 GROUP BY id DESC LIMIT 1 [ RunTime:0.000662s ]
[ SQL ] SELECT * FROM `yoshop_memorial_group` WHERE `yoshop_memorial_group`.`wxapp_id` = '10001' AND `memorial_id` = 574 AND `user_id` = 11226 GROUP BY id DESC LIMIT 1 [ RunTime:0.000656s ]
[ SQL ] SELECT * FROM `yoshop_memorial_group` WHERE `yoshop_memorial_group`.`wxapp_id` = '10001' AND `memorial_id` = 574 AND `user_id` = 11226 GROUP BY id DESC LIMIT 1 [ RunTime:0.000719s ]
[ SQL ] SELECT * FROM `yoshop_memorial_group` WHERE `yoshop_memorial_group`.`wxapp_id` = '10001' AND `memorial_id` = 998 AND `user_id` = 12688 GROUP BY id DESC LIMIT 1 [ RunTime:0.000437s ]
[ SQL ] SELECT * FROM `yoshop_memorial_group` WHERE `yoshop_memorial_group`.`wxapp_id` = '10001' AND `memorial_id` = 998 AND `user_id` = 12688 GROUP BY id DESC LIMIT 1 [ RunTime:0.000369s ]