[ 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.000488s ]
[ SQL ] SELECT * FROM `yoshop_upload_file` WHERE `yoshop_upload_file`.`wxapp_id` = '10001' AND `file_id` = 11266 [ RunTime:0.000477s ]
[ SQL ] SELECT * FROM `yoshop_upload_file` WHERE `yoshop_upload_file`.`wxapp_id` = '10001' AND `file_id` = 11267 [ RunTime:0.000323s ]
[ SQL ] SELECT * FROM `yoshop_upload_file` WHERE `yoshop_upload_file`.`wxapp_id` = '10001' AND `file_id` = 10735 [ RunTime:0.000292s ]
[ SQL ] SELECT * FROM `yoshop_upload_file` WHERE `yoshop_upload_file`.`wxapp_id` = '10001' AND `file_id` = 11301 [ RunTime:0.000270s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_banner` [ RunTime:0.001103s ]
[ 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.000405s ]
[ SQL ] SELECT * FROM `yoshop_upload_file` WHERE `yoshop_upload_file`.`wxapp_id` = '10001' AND `file_id` IN (12989) [ RunTime:0.000387s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_user` [ RunTime:0.000679s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_memorial` [ RunTime:0.000613s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_memorial_log` [ RunTime:0.000594s ]
[ SQL ] SELECT * FROM `yoshop_memorial_log` WHERE `yoshop_memorial_log`.`wxapp_id` = '10001' AND ( `end_time` > 1756554191 or `end_time` = 0 ) ORDER BY `id` DESC [ RunTime:0.044291s ]
[ SQL ] SELECT * FROM `yoshop_user` WHERE `yoshop_user`.`wxapp_id` = '10001' AND `user_id` IN (11226,11929,11452,12202,11060,12572,11387,12566,11300,12149,11579,11711,10163,12930,12210,11625,12987,12945,10076,10005,11482,10853,12931,10008,10443,11295,12790,10204,12769,12121,12759,12756,12724,12702,10449,12618,12726,10118,11390,10294,10442,10440,10186,10166,10155,10001) [ RunTime:0.001391s ]
[ SQL ] SELECT * FROM `yoshop_memorial` WHERE `yoshop_memorial`.`wxapp_id` = '10001' AND `is_delete` = 0 AND `id` IN (574,802,928,641,865,503,977,979,792,961,590,892,676,740,158,1015,869,868,689,1079,1072,704,56,656,612,441,1048,841,354,589,1044,1029,173,1027,1020,839,1017,1009,1003,967,132,615,484,235,296,76,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.001268s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_memorial_people` [ RunTime:0.000744s ]
[ SQL ] SELECT * FROM `yoshop_memorial_people` WHERE `yoshop_memorial_people`.`wxapp_id` = '10001' AND `memorial_id` IN (56,76,89,132,152,153,158,165,173,190,191,192,200,208,209,210,212,235,296,354,441,503,574,589,590,612,615,641,656,676,689,704,740,792,802,839,841,865,868,869,892,928,961,967,977,979,1003,1009,1015,1017,1020,1027,1029,1044,1048,1072,1079) [ RunTime:0.001476s ]
[ SQL ] SELECT * FROM `yoshop_upload_file` WHERE `yoshop_upload_file`.`wxapp_id` = '10001' AND `file_id` IN (10811,1,11557,11537,11907,11911,11536,12271,12272,12635,12719,12720,11867,11513,12861,12862,12856,12938,13035,13034,13201,13275,13449,13450,13451,13641,13733,11608,11741,13854,13855,13903,13904,13947,13966,13965,14018,14042,13648,14067,14079,14099,14121,14127,14161,13690,14387,14406,14008,14430) [ RunTime:0.000804s ]
[ 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') = '08-30' or DATE_FORMAT(dieday,'%m-%d') = '08-30' ) ) AND `is_delete` = 0 AND `is_private` = 0 GROUP BY `Memorial`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.002326s ]
[ 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') = '08-30' or DATE_FORMAT(dieday,'%m-%d') = '08-30' ) ) AND `is_delete` = 0 AND `is_private` = 0 GROUP BY `Memorial`.`id` ORDER BY `id` DESC LIMIT 0,3 [ RunTime:0.003132s ]
[ SQL ] SELECT * FROM `yoshop_memorial_people` WHERE `yoshop_memorial_people`.`wxapp_id` = '10001' AND `memorial_id` IN (1202) [ RunTime:0.001151s ]
[ SQL ] SELECT * FROM `yoshop_upload_file` WHERE `yoshop_upload_file`.`wxapp_id` = '10001' AND `file_id` IN (14465) [ RunTime:0.000306s ]
[ SQL ] SELECT * FROM `yoshop_user` WHERE `yoshop_user`.`wxapp_id` = '10001' AND `user_id` IN (13680) [ RunTime:0.000336s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_memorial_area_category` [ RunTime:0.000589s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_memorial_area` [ RunTime:0.000846s ]
[ SQL ] SELECT * FROM `yoshop_memorial_area` WHERE `yoshop_memorial_area`.`wxapp_id` = '10001' AND `id` IN (0) [ RunTime:0.000326s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_article` [ RunTime:0.000579s ]
[ 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.001999s ]
[ 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.002414s ]
[ 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.000451s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_memorial_message` [ RunTime:0.000646s ]
[ 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.000821s ]
[ 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.000383s ]
[ SQL ] SELECT `avatarUrl`,`nickName`,`user_id` FROM `yoshop_user` WHERE `yoshop_user`.`wxapp_id` = '10001' AND `user_id` IN (13680,13681,13682) [ RunTime:0.000297s ]
[ SQL ] SELECT `id`,`type`,`title` FROM `yoshop_memorial` WHERE `yoshop_memorial`.`wxapp_id` = '10001' AND `id` IN (1202) [ RunTime:0.000306s ]
[ SQL ] SELECT * FROM `yoshop_memorial_people` WHERE `yoshop_memorial_people`.`wxapp_id` = '10001' AND `memorial_id` IN (1202) [ RunTime:0.000907s ]
[ SQL ] SELECT * FROM `yoshop_upload_file` WHERE `yoshop_upload_file`.`wxapp_id` = '10001' AND `file_id` IN (14465) [ RunTime:0.000280s ]
[ SQL ] SELECT * FROM `yoshop_article` WHERE `yoshop_article`.`wxapp_id` = '10001' AND `category_id` = 9 LIMIT 1 [ RunTime:0.000585s ]
[ SQL ] SELECT * FROM `yoshop_upload_file` WHERE `yoshop_upload_file`.`wxapp_id` = '10001' AND `file_id` = 11772 [ RunTime:0.000352s ]
[ SQL ] UPDATE `yoshop_article` SET `actual_views`=`actual_views`+1 WHERE `article_id` = 20 [ RunTime:0.005045s ]
[ 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.002195s ]
[ 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.002098s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_memorial_article` [ RunTime:0.000699s ]
[ 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.000390s ]
[ 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.000566s ]
[ SQL ] SELECT `id`,`title` FROM `yoshop_memorial` WHERE `yoshop_memorial`.`wxapp_id` = '10001' AND `id` IN (1001,1009,977,979,1075,1072,1048) [ RunTime:0.000465s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_goods` [ RunTime:0.000643s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yoshop_memorial_log` WHERE `yoshop_memorial_log`.`wxapp_id` = '10001' AND ( `end_time` > 1756554192 or `end_time` = 0 ) LIMIT 1 [ RunTime:0.020288s ]
[ SQL ] SELECT * FROM `yoshop_memorial_log` WHERE `yoshop_memorial_log`.`wxapp_id` = '10001' AND ( `end_time` > 1756554192 or `end_time` = 0 ) ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000669s ]
[ SQL ] SELECT * FROM `yoshop_user` WHERE `yoshop_user`.`wxapp_id` = '10001' AND `user_id` IN (11226,11929,11452) [ RunTime:0.000509s ]
[ SQL ] SELECT * FROM `yoshop_memorial` WHERE `yoshop_memorial`.`wxapp_id` = '10001' AND `id` IN (574,802,928,641) [ RunTime:0.000455s ]
[ SQL ] SELECT `goods_id`,`goods_name`,`image_id` FROM `yoshop_goods` WHERE `yoshop_goods`.`wxapp_id` = '10001' AND `goods_id` IN (10021,10132,10477) [ RunTime:0.000340s ]
[ SQL ] SELECT * FROM `yoshop_upload_file` WHERE `yoshop_upload_file`.`wxapp_id` = '10001' AND `file_id` IN (11959,11041,12424) [ RunTime:0.000292s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_memorial_group` [ RunTime:0.000666s ]
[ 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.000898s ]
[ 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.000667s ]
[ 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.000641s ]
[ SQL ] SELECT * FROM `yoshop_memorial_group` WHERE `yoshop_memorial_group`.`wxapp_id` = '10001' AND `memorial_id` = 802 AND `user_id` = 11929 GROUP BY id DESC LIMIT 1 [ RunTime:0.000756s ]
[ SQL ] SELECT * FROM `yoshop_memorial_group` WHERE `yoshop_memorial_group`.`wxapp_id` = '10001' AND `memorial_id` = 928 AND `user_id` = 11929 GROUP BY id DESC LIMIT 1 [ RunTime:0.000536s ]
[ SQL ] SELECT * FROM `yoshop_memorial_group` WHERE `yoshop_memorial_group`.`wxapp_id` = '10001' AND `memorial_id` = 802 AND `user_id` = 11929 GROUP BY id DESC LIMIT 1 [ RunTime:0.000598s ]
[ SQL ] SELECT * FROM `yoshop_memorial_group` WHERE `yoshop_memorial_group`.`wxapp_id` = '10001' AND `memorial_id` = 928 AND `user_id` = 11929 GROUP BY id DESC LIMIT 1 [ RunTime:0.000449s ]
[ SQL ] SELECT * FROM `yoshop_memorial_group` WHERE `yoshop_memorial_group`.`wxapp_id` = '10001' AND `memorial_id` = 641 AND `user_id` = 11452 GROUP BY id DESC LIMIT 1 [ RunTime:0.000572s ]