Home > Article list > Whats New

Copyright

Date:2015-06-18  Source:Freek Roeters
CopyrightCopyrightCopyrightCopyright
Tags
Information
Article Categories

Feedback

Please enter your name
*The Name can not be empty
Enter your phone number
*The phone number can not be empty!
Please enter your feedback:
*Please enter your content
Total Queries:26, Time: 0.004503 secs,Gzip Off,Memory 901.51 KB Run Time: 0.494841 secs
SQL queries Ran:
1>>select * from cp_help order by sort asc
2>>select * from cp_message_cate order by id asc
3>>select * from cp_user_level order by point asc
4>>select * from cp_deal_cate where is_delete=0
5>>select * from cp_article_cate where is_effect=1 and is_delete=0 order by sort asc
6>>select ac.*,fa.num from cp_article_cate as ac left join (SELECT count(*) as num,cate_id from cp_article where is_effect=1 and is_delete=0 GROUP BY cate_id) as fa on fa.cate_id=ac.id where ac.is_effect=1 and ac.is_delete=0 order by ac.sort asc
7>>select id,cate_id,title from cp_article where is_effect=1 and is_delete=0 order by sort asc
8>>select * from cp_nav where is_effect = 1 order by sort asc
9>>delete from cp_deal_order where order_status = 0 and credit_pay = 0 and 1634981557 - create_time > 259200
10>>select count(*) from cp_deal_notify
11>>select * from cp_link_group where is_effect = 1
12>>select * from cp_link where is_effect = 1 and show_index = 1 and group_id = 14 order by sort desc
13>>select ac.*,fa.num from cp_article_cate as ac left join (SELECT count(*) as num,cate_id from cp_article where is_effect=1 and is_delete=0 GROUP BY cate_id) as fa on fa.cate_id=ac.id where ac.is_effect=1 and ac.is_delete=0 order by ac.sort asc
14>>select * from cp_article where is_effect=1 and is_delete=0 order by sort desc
15>>SELECT * FROM cp_payment_notice where is_mortgate=1 and is_paid=1 and order_id=0
16>>select * from cp_collocation where is_effect=1
17>>select * from cp_link_group where is_effect = 1
18>>select * from cp_link where is_effect = 1 and show_index = 1 and group_id = 14 order by sort desc
19>>select a.*,ac.type_id from cp_article as a left join cp_article_cate as ac on ac.id=a.cate_id where a.id=78
20>>select * from cp_article where id<78 order by id desc limit 0,1
21>>select * from cp_article where id>78 order by id desc limit 0,1
22>>select ac.*,fa.num from cp_article_cate as ac left join (SELECT count(*) as num,cate_id from cp_article where is_effect=1 and is_delete=0 GROUP BY cate_id) as fa on fa.cate_id=ac.id where ac.is_effect=1 and ac.is_delete=0 order by ac.sort asc
23>>SELECT a.*,c.type_id from cp_article a LEFT JOIN cp_article_cate c on a.cate_id=c.id where 1=1 and a.is_delete=0 and a.is_effect=1 and c.type_id=1 and a.cate_id=21 and a.id!=78 order by update_time desc limit 0,5
24>>select * from cp_article where id=78
25>>select title from cp_article_cate where id=21
26>>select * from cp_api_login