[ SQL ] SHOW COLUMNS FROM `yoshop_upload_file` [ RunTime:0.000609s ]
[ SQL ] SELECT * FROM `yoshop_upload_file` WHERE `yoshop_upload_file`.`wxapp_id` = '10001' AND `file_id` = 13116 [ RunTime:0.000429s ]
[ SQL ] SELECT * FROM `yoshop_upload_file` WHERE `yoshop_upload_file`.`wxapp_id` = '10001' AND `file_id` = 11266 [ RunTime:0.000557s ]
[ SQL ] SELECT * FROM `yoshop_upload_file` WHERE `yoshop_upload_file`.`wxapp_id` = '10001' AND `file_id` = 11267 [ RunTime:0.000404s ]
[ SQL ] SELECT * FROM `yoshop_upload_file` WHERE `yoshop_upload_file`.`wxapp_id` = '10001' AND `file_id` = 10735 [ RunTime:0.000429s ]
[ SQL ] SELECT * FROM `yoshop_upload_file` WHERE `yoshop_upload_file`.`wxapp_id` = '10001' AND `file_id` = 11301 [ RunTime:0.000341s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_banner` [ RunTime:0.000889s ]
[ 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.000559s ]
[ SQL ] SELECT * FROM `yoshop_upload_file` WHERE `yoshop_upload_file`.`wxapp_id` = '10001' AND `file_id` IN (12989) [ RunTime:0.000384s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_user` [ RunTime:0.000866s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_memorial` [ RunTime:0.000617s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_memorial_log` [ RunTime:0.000533s ]
[ SQL ] SELECT * FROM `yoshop_memorial_log` WHERE `yoshop_memorial_log`.`wxapp_id` = '10001' AND ( `end_time` > 1772635880 or `end_time` = 0 ) ORDER BY `id` DESC [ RunTime:0.046853s ]
[ SQL ] SELECT * FROM `yoshop_user` WHERE `yoshop_user`.`wxapp_id` = '10001' AND `user_id` IN (12724,12572,11226,11482,11060,13463,11300,11528,10005,11625,13655,13676,11387,11711,13770,10204,13609,12759,13692,12149,12202,10163,12210,11579,10853,11295,10118,11390,10294,10442,10440,10449,10186,10166,10155,10001) [ RunTime:0.001085s ]
[ SQL ] SELECT * FROM `yoshop_memorial` WHERE `yoshop_memorial`.`wxapp_id` = '10001' AND `is_delete` = 0 AND `id` IN (1009,979,977,574,656,503,590,669,56,1237,689,1195,1201,792,740,1227,173,1189,1017,892,865,158,869,868,676,441,1044,589,132,615,484,235,354,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.001203s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_memorial_people` [ RunTime:0.000862s ]
[ 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,615,656,669,676,689,740,792,865,868,869,892,977,979,1009,1017,1044,1189,1195,1201,1227,1237) [ RunTime:0.001828s ]
[ 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,13183,13184,13201,13275,13450,13451,13733,11608,11741,13903,13904,14018,14042,14079,14121,13690,14406,14008,14420,14443,14504,14506,14558,14559) [ RunTime:0.000808s ]
[ 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') = '03-04' or DATE_FORMAT(dieday,'%m-%d') = '03-04' ) ) AND `is_delete` = 0 AND `is_private` = 0 GROUP BY `Memorial`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.002906s ]
[ 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') = '03-04' or DATE_FORMAT(dieday,'%m-%d') = '03-04' ) ) AND `is_delete` = 0 AND `is_private` = 0 GROUP BY `Memorial`.`id` ORDER BY `id` DESC LIMIT 543,3 [ RunTime:0.004189s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_article` [ RunTime:0.000622s ]
[ 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.002287s ]
[ 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 2353,13 [ RunTime:0.006070s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_memorial_message` [ RunTime:0.000779s ]
[ 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.000998s ]
[ SQL ] SELECT * FROM `yoshop_memorial_message` WHERE `yoshop_memorial_message`.`wxapp_id` = '10001' AND `is_delete` = 0 ORDER BY `id` DESC LIMIT 1267,7 [ RunTime:0.001948s ]
[ SQL ] SELECT `avatarUrl`,`nickName`,`user_id` FROM `yoshop_user` WHERE `yoshop_user`.`wxapp_id` = '10001' AND `user_id` IN (10379) [ RunTime:0.000346s ]
[ SQL ] SELECT `id`,`type`,`title` FROM `yoshop_memorial` WHERE `yoshop_memorial`.`wxapp_id` = '10001' AND `id` IN (312) [ RunTime:0.000364s ]
[ SQL ] SELECT * FROM `yoshop_memorial_people` WHERE `yoshop_memorial_people`.`wxapp_id` = '10001' AND `memorial_id` IN (312) [ RunTime:0.001213s ]
[ SQL ] SELECT * FROM `yoshop_upload_file` WHERE `yoshop_upload_file`.`wxapp_id` = '10001' AND `file_id` IN (12161) [ RunTime:0.000426s ]
[ SQL ] SELECT * FROM `yoshop_article` WHERE `yoshop_article`.`wxapp_id` = '10001' AND `category_id` = 9 LIMIT 1 [ RunTime:0.000568s ]
[ SQL ] SELECT * FROM `yoshop_upload_file` WHERE `yoshop_upload_file`.`wxapp_id` = '10001' AND `file_id` = 11772 [ RunTime:0.000301s ]
[ SQL ] UPDATE `yoshop_article` SET `actual_views`=`actual_views`+1 WHERE `article_id` = 20 [ RunTime:0.005589s ]
[ 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.001894s ]
[ 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 1810,10 [ RunTime:0.001690s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_memorial_article` [ RunTime:0.000824s ]
[ 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.000482s ]
[ SQL ] SELECT * FROM `yoshop_memorial_article` WHERE `yoshop_memorial_article`.`wxapp_id` = '10001' AND `is_delete` = 0 ORDER BY `id` DESC LIMIT 2353,13 [ RunTime:0.000561s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_goods` [ RunTime:0.000665s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yoshop_memorial_log` WHERE `yoshop_memorial_log`.`wxapp_id` = '10001' AND ( `end_time` > 1772635881 or `end_time` = 0 ) LIMIT 1 [ RunTime:0.021375s ]
[ SQL ] SELECT * FROM `yoshop_memorial_log` WHERE `yoshop_memorial_log`.`wxapp_id` = '10001' AND ( `end_time` > 1772635881 or `end_time` = 0 ) ORDER BY `id` DESC LIMIT 1448,8 [ RunTime:0.044296s ]
