[ SQL ] SHOW COLUMNS FROM `yoshop_upload_file` [ RunTime:0.000508s ]
[ SQL ] SELECT * FROM `yoshop_upload_file` WHERE `yoshop_upload_file`.`wxapp_id` = '10001' AND `file_id` = 13116 [ RunTime:0.000439s ]
[ SQL ] SELECT * FROM `yoshop_upload_file` WHERE `yoshop_upload_file`.`wxapp_id` = '10001' AND `file_id` = 11266 [ RunTime:0.000448s ]
[ SQL ] SELECT * FROM `yoshop_upload_file` WHERE `yoshop_upload_file`.`wxapp_id` = '10001' AND `file_id` = 11267 [ RunTime:0.000369s ]
[ SQL ] SELECT * FROM `yoshop_upload_file` WHERE `yoshop_upload_file`.`wxapp_id` = '10001' AND `file_id` = 10735 [ RunTime:0.000293s ]
[ SQL ] SELECT * FROM `yoshop_upload_file` WHERE `yoshop_upload_file`.`wxapp_id` = '10001' AND `file_id` = 11301 [ RunTime:0.000361s ]
[ SQL ] SELECT * FROM `yoshop_upload_file` WHERE `yoshop_upload_file`.`wxapp_id` = '10001' AND `file_id` IN (12989) [ RunTime:0.000572s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_user` [ RunTime:0.000776s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_memorial` [ RunTime:0.000876s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_memorial_log` [ RunTime:0.000654s ]
[ SQL ] SELECT * FROM `yoshop_memorial_log` WHERE `yoshop_memorial_log`.`wxapp_id` = '10001' AND ( `end_time` > 1786075253 or `end_time` = 0 ) ORDER BY `id` DESC [ RunTime:0.045444s ]
[ SQL ] SELECT * FROM `yoshop_user` WHERE `yoshop_user`.`wxapp_id` = '10001' AND `user_id` IN (11226,14030,12724,14023,12572,10005,12202,10274,12149,14008,10443,13914,10118,13676,13852,11711,11300,13770,10204,13609,12759,13692,10853,11295,11482,11390,10294,10442,10440,10449,10163,10186,10166,10155,10001) [ RunTime:0.001065s ]
[ SQL ] SELECT * FROM `yoshop_memorial` WHERE `yoshop_memorial`.`wxapp_id` = '10001' AND `is_delete` = 0 AND `id` IN (574,1299,1009,1296,979,1237,865,229,892,1280,354,977,760,1251,132,1201,1250,740,590,1227,173,1189,1017,441,1044,656,589,615,484,235,158,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,56,62,71,70,64,8,53,1) [ RunTime:0.001214s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_memorial_people` [ RunTime:0.000865s ]
[ 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,229,235,296,354,441,574,589,590,615,656,740,760,865,892,977,979,1009,1017,1044,1189,1201,1227,1237,1251,1280,1296,1299) [ RunTime:0.001233s ]
[ 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,11867,11513,12861,12862,12856,12938,13447,13448,13450,13451,13733,11608,11741,13903,13904,14018,14042,14079,14121,14406,14008,14420,14443,14504,14506,14558,14559,14611,11877,14645,14654,14655) [ RunTime:0.000515s ]
[ 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-07' or DATE_FORMAT(dieday,'%m-%d') = '08-07' ) ) AND `is_delete` = 0 AND `is_private` = 0 GROUP BY `Memorial`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.002153s ]
[ 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-07' or DATE_FORMAT(dieday,'%m-%d') = '08-07' ) ) AND `is_delete` = 0 AND `is_private` = 0 GROUP BY `Memorial`.`id` ORDER BY `id` DESC LIMIT 0,3 [ RunTime:0.003158s ]
[ SQL ] SELECT * FROM `yoshop_memorial_people` WHERE `yoshop_memorial_people`.`wxapp_id` = '10001' AND `memorial_id` IN (1162,354) [ RunTime:0.001011s ]
[ SQL ] SELECT * FROM `yoshop_upload_file` WHERE `yoshop_upload_file`.`wxapp_id` = '10001' AND `file_id` IN (12271,12272,1) [ RunTime:0.000322s ]
[ SQL ] SELECT * FROM `yoshop_user` WHERE `yoshop_user`.`wxapp_id` = '10001' AND `user_id` IN (13448,10440) [ RunTime:0.000331s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_memorial_area_category` [ RunTime:0.000515s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_memorial_area` [ RunTime:0.000432s ]
[ SQL ] SELECT * FROM `yoshop_memorial_area` WHERE `yoshop_memorial_area`.`wxapp_id` = '10001' AND `id` IN (0) [ RunTime:0.000224s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_article` [ RunTime:0.000524s ]
[ 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.001952s ]
[ 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.001994s ]
[ 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.000374s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_memorial_message` [ RunTime:0.000563s ]
[ 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.000869s ]
[ 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.000251s ]
[ SQL ] SELECT `avatarUrl`,`nickName`,`user_id` FROM `yoshop_user` WHERE `yoshop_user`.`wxapp_id` = '10001' AND `user_id` IN (14035,14034,14030,12724,14023,14020) [ RunTime:0.000279s ]
[ SQL ] SELECT `id`,`type`,`title` FROM `yoshop_memorial` WHERE `yoshop_memorial`.`wxapp_id` = '10001' AND `id` IN (1299,1009,1296,1294) [ RunTime:0.000250s ]
[ SQL ] SELECT * FROM `yoshop_memorial_people` WHERE `yoshop_memorial_people`.`wxapp_id` = '10001' AND `memorial_id` IN (1009,1294,1296,1299) [ RunTime:0.001005s ]
[ SQL ] SELECT * FROM `yoshop_upload_file` WHERE `yoshop_upload_file`.`wxapp_id` = '10001' AND `file_id` IN (14406,14008,1,14645,14654,14655) [ RunTime:0.000283s ]
[ SQL ] SELECT * FROM `yoshop_article` WHERE `yoshop_article`.`wxapp_id` = '10001' AND `category_id` = 9 LIMIT 1 [ RunTime:0.000468s ]
[ SQL ] SELECT * FROM `yoshop_upload_file` WHERE `yoshop_upload_file`.`wxapp_id` = '10001' AND `file_id` = 11772 [ RunTime:0.000291s ]
[ SQL ] UPDATE `yoshop_article` SET `actual_views`=`actual_views`+1 WHERE `article_id` = 20 [ RunTime:0.005798s ]
[ 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.001563s ]
[ 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.001532s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_memorial_article` [ RunTime:0.000574s ]
[ 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.000294s ]
[ 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.000313s ]
[ SQL ] SELECT `id`,`title` FROM `yoshop_memorial` WHERE `yoshop_memorial`.`wxapp_id` = '10001' AND `id` IN (1301,1296,1009,1001,977,979) [ RunTime:0.000269s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_goods` [ RunTime:0.000558s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yoshop_memorial_log` WHERE `yoshop_memorial_log`.`wxapp_id` = '10001' AND ( `end_time` > 1786075253 or `end_time` = 0 ) LIMIT 1 [ RunTime:0.020534s ]
[ SQL ] SELECT * FROM `yoshop_memorial_log` WHERE `yoshop_memorial_log`.`wxapp_id` = '10001' AND ( `end_time` > 1786075253 or `end_time` = 0 ) ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000615s ]
[ SQL ] SELECT * FROM `yoshop_user` WHERE `yoshop_user`.`wxapp_id` = '10001' AND `user_id` IN (11226,14030,12724,14023) [ RunTime:0.000487s ]
[ SQL ] SELECT * FROM `yoshop_memorial` WHERE `yoshop_memorial`.`wxapp_id` = '10001' AND `id` IN (574,1299,1009,1296) [ RunTime:0.000361s ]
[ SQL ] SELECT `goods_id`,`goods_name`,`image_id` FROM `yoshop_goods` WHERE `yoshop_goods`.`wxapp_id` = '10001' AND `goods_id` IN (10063,10070,10408,10045,10002,10005) [ RunTime:0.000293s ]
[ SQL ] SELECT * FROM `yoshop_upload_file` WHERE `yoshop_upload_file`.`wxapp_id` = '10001' AND `file_id` IN (12212,10714,12548,11864,12193,11934) [ RunTime:0.000301s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_memorial_group` [ RunTime:0.000590s ]
[ 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.000738s ]
[ 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.000836s ]
[ SQL ] SELECT * FROM `yoshop_memorial_group` WHERE `yoshop_memorial_group`.`wxapp_id` = '10001' AND `memorial_id` = 1299 AND `user_id` = 14030 GROUP BY id DESC LIMIT 1 [ RunTime:0.000296s ]
[ SQL ] SELECT * FROM `yoshop_memorial_group` WHERE `yoshop_memorial_group`.`wxapp_id` = '10001' AND `memorial_id` = 1299 AND `user_id` = 14030 GROUP BY id DESC LIMIT 1 [ RunTime:0.000268s ]
[ SQL ] SELECT * FROM `yoshop_memorial_group` WHERE `yoshop_memorial_group`.`wxapp_id` = '10001' AND `memorial_id` = 1299 AND `user_id` = 14030 GROUP BY id DESC LIMIT 1 [ RunTime:0.000262s ]
[ SQL ] SELECT * FROM `yoshop_memorial_group` WHERE `yoshop_memorial_group`.`wxapp_id` = '10001' AND `memorial_id` = 1009 AND `user_id` = 12724 GROUP BY id DESC LIMIT 1 [ RunTime:0.000430s ]
[ SQL ] SELECT * FROM `yoshop_memorial_group` WHERE `yoshop_memorial_group`.`wxapp_id` = '10001' AND `memorial_id` = 1296 AND `user_id` = 14023 GROUP BY id DESC LIMIT 1 [ RunTime:0.000419s ]
[ SQL ] SELECT * FROM `yoshop_memorial_group` WHERE `yoshop_memorial_group`.`wxapp_id` = '10001' AND `memorial_id` = 1296 AND `user_id` = 14023 GROUP BY id DESC LIMIT 1 [ RunTime:0.000544s ]
