我在后台查询了一下,发现有几条SQL语句的执行比较耗时,等待时间过长。
其中一条语句:
select * from ( select content0_.content_id as content1_14_, content0_.sort_date as sort2_14_, content0_.top_level as top3_14_, content0_.has_title_img as has4_14_, content0_.is_recommend as is5_14_, content0_.status as status14_, content0_.views_day as views7_14_, content0_.comments_day as comments8_14_, content0_.downloads_day as downloads9_14_, content0_.ups_day as ups10_14_, content0_.score as score14_, content0_.type_id as type12_14_, content0_.site_id as site13_14_, content0_.user_id as user14_14_, content0_.channel_id as channel15_14_, content0_.model_id as model16_14_ from jc_content content0_ left outer join jc_content_share_check contentsha1_ on content0_.content_id=contentsha1_.content_id left outer join jc_channel channel2_ on contentsha1_.channel_id=channel2_.channel_id inner join jc_channel channel3_ on content0_.channel_id=channel3_.channel_id cross join jc_channel channel4_ cross join jc_content_ext contentext5_ where content0_.content_id=contentext5_.content_id and ((c
这是什么操作? |
|