select table_name from USER_TABLES where TABLESPACE_NAME='MAIN' [ RunTime:0.008129s ]
select * from user_tab_columns where table_name='cms_category' [ RunTime:0.001720s ]
select a.name COL_NAME from SYS.SYSCOLUMNS a,all_tables b,sys.sysobjects c where a.INFO2 & 0x01 = 0x01
and a.id=c.id and c.name= b.table_name and b.TABLE_NAME = 'cms_category' [ RunTime:0.002577s ]
SELECT `id`,`catname`,`type`,`route` FROM `RENYINGDB`.`cms_category` WHERE `is_del` = 0 AND `status` = 1 ORDER BY `sort` DESC,`id` ASC LIMIT 9999 [ RunTime:0.002223s ]
select * from user_tab_columns where table_name='cms_config' [ RunTime:0.000783s ]
select a.name COL_NAME from SYS.SYSCOLUMNS a,all_tables b,sys.sysobjects c where a.INFO2 & 0x01 = 0x01
and a.id=c.id and c.name= b.table_name and b.TABLE_NAME = 'cms_config' [ RunTime:0.002781s ]
SELECT * FROM `RENYINGDB`.`cms_config` WHERE `status` = 1 AND `cfg` = 'status' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001063s ]
SELECT * FROM `RENYINGDB`.`cms_config` WHERE `status` = 1 AND `cfg` = 'ip' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000900s ]
SELECT `id`,`catname`,`type` FROM `RENYINGDB`.`cms_category` WHERE `up_id` = 0 AND `status` = 1 AND `is_nav` = 1 AND `is_del` = 0 ORDER BY `sort` DESC,`id` ASC LIMIT 99 [ RunTime:0.001392s ]
SELECT * FROM `RENYINGDB`.`cms_category` WHERE `is_del` = 0 AND `status` = 1 AND `id` = 4 ORDER BY `sort` DESC,`id` ASC LIMIT 1 [ RunTime:0.001377s ]
SELECT `id`,`catname`,`type` FROM `RENYINGDB`.`cms_category` WHERE `up_id` = 4 AND `status` = 1 AND `is_nav` = 1 AND `is_del` = 0 ORDER BY `sort` DESC,`id` ASC LIMIT 99 [ RunTime:0.000909s ]
SELECT * FROM `RENYINGDB`.`cms_category` WHERE `is_del` = 0 AND `status` = 1 AND `id` = 5 ORDER BY `sort` DESC,`id` ASC LIMIT 1 [ RunTime:0.001227s ]
SELECT `id`,`catname`,`type` FROM `RENYINGDB`.`cms_category` WHERE `up_id` = 5 AND `status` = 1 AND `is_nav` = 1 AND `is_del` = 0 ORDER BY `sort` DESC,`id` ASC LIMIT 99 [ RunTime:0.000777s ]
SELECT * FROM `RENYINGDB`.`cms_category` WHERE `is_del` = 0 AND `status` = 1 AND `id` = 6 ORDER BY `sort` DESC,`id` ASC LIMIT 1 [ RunTime:0.001245s ]
SELECT `id`,`catname`,`type` FROM `RENYINGDB`.`cms_category` WHERE `up_id` = 6 AND `status` = 1 AND `is_nav` = 1 AND `is_del` = 0 ORDER BY `sort` DESC,`id` ASC LIMIT 99 [ RunTime:0.000701s ]
SELECT * FROM `RENYINGDB`.`cms_category` WHERE `is_del` = 0 AND `status` = 1 AND `id` = 7 ORDER BY `sort` DESC,`id` ASC LIMIT 1 [ RunTime:0.001258s ]
SELECT `id`,`catname`,`type` FROM `RENYINGDB`.`cms_category` WHERE `up_id` = 7 AND `status` = 1 AND `is_nav` = 1 AND `is_del` = 0 ORDER BY `sort` DESC,`id` ASC LIMIT 99 [ RunTime:0.000880s ]
SELECT * FROM `RENYINGDB`.`cms_category` WHERE `is_del` = 0 AND `status` = 1 AND `id` = 8 ORDER BY `sort` DESC,`id` ASC LIMIT 1 [ RunTime:0.000835s ]
SELECT `id`,`catname`,`type` FROM `RENYINGDB`.`cms_category` WHERE `up_id` = 8 AND `status` = 1 AND `is_nav` = 1 AND `is_del` = 0 ORDER BY `sort` DESC,`id` ASC LIMIT 99 [ RunTime:0.000717s ]
select * from user_tab_columns where table_name='cms_visit' [ RunTime:0.000493s ]
select a.name COL_NAME from SYS.SYSCOLUMNS a,all_tables b,sys.sysobjects c where a.INFO2 & 0x01 = 0x01
and a.id=c.id and c.name= b.table_name and b.TABLE_NAME = 'cms_visit' [ RunTime:0.002547s ]
DELETE FROM `RENYINGDB`.`cms_visit` WHERE `addtime` < '1780979650' [ RunTime:0.000733s ]
SELECT * FROM `RENYINGDB`.`cms_category` WHERE `is_del` = 0 AND `status` = 1 AND `id` = 15 ORDER BY `sort` DESC,`id` ASC LIMIT 1 [ RunTime:0.001648s ]
SELECT * FROM `RENYINGDB`.`cms_category` WHERE `id` = 15 AND `status` = 1 AND `is_del` = 0 LIMIT 1 [ RunTime:0.000982s ]
SELECT * FROM `RENYINGDB`.`cms_category` WHERE `id` = 15 AND `is_del` = 0 LIMIT 1 [ RunTime:0.001536s ]
SELECT * FROM `RENYINGDB`.`cms_category` WHERE `id` = 6 AND `is_del` = 0 LIMIT 1 [ RunTime:0.001145s ]
SELECT * FROM `RENYINGDB`.`cms_category` WHERE `up_id` = 6 AND `status` = 1 AND `is_del` = 0 ORDER BY `sort` DESC,`id` ASC LIMIT 99 [ RunTime:0.000965s ]
SELECT * FROM `RENYINGDB`.`cms_category` WHERE `id` = 15 AND `status` = 1 AND `is_del` = 0 LIMIT 1 [ RunTime:0.000959s ]
select * from user_tab_columns where table_name='cms_model_table' [ RunTime:0.000844s ]
select a.name COL_NAME from SYS.SYSCOLUMNS a,all_tables b,sys.sysobjects c where a.INFO2 & 0x01 = 0x01
and a.id=c.id and c.name= b.table_name and b.TABLE_NAME = 'cms_model_table' [ RunTime:0.002847s ]
SELECT * FROM `RENYINGDB`.`cms_model_table` WHERE `id` = 34 LIMIT 1 [ RunTime:0.002280s ]
SELECT * FROM `RENYINGDB`.`cms_category` WHERE `is_del` = 0 AND `status` = 1 AND `id` = 15 ORDER BY `sort` DESC,`id` ASC LIMIT 1 [ RunTime:0.001198s ]
select * from user_tab_columns where table_name='cms_article_chengguo' [ RunTime:0.001232s ]
select a.name COL_NAME from SYS.SYSCOLUMNS a,all_tables b,sys.sysobjects c where a.INFO2 & 0x01 = 0x01
and a.id=c.id and c.name= b.table_name and b.TABLE_NAME = 'cms_article_chengguo' [ RunTime:0.002802s ]
SELECT COUNT(*) AS think_count FROM `RENYINGDB`.`cms_article_chengguo` WHERE `cat_id` = 15 AND `status` = 1 AND `is_del` = 0 LIMIT 1 [ RunTime:0.000656s ]
SELECT * FROM `RENYINGDB`.`cms_article_chengguo` WHERE `cat_id` = 15 AND `status` = 1 AND `is_del` = 0 AND `cat_id` = 15 AND `status` = 1 AND `is_del` = 0 ORDER BY `sort` DESC,`push_time` DESC LIMIT 0,12 [ RunTime:0.000928s ]
SELECT * FROM `RENYINGDB`.`cms_category` WHERE `is_del` = 0 AND `status` = 1 AND `id` = 15 ORDER BY `sort` DESC,`id` ASC LIMIT 1 [ RunTime:0.000974s ]
SELECT * FROM `RENYINGDB`.`cms_article_chengguo` WHERE `cat_id` = 15 AND `status` = 1 AND `is_del` = 0 GROUP BY `year` [ RunTime:0.001285s ]
SELECT * FROM `RENYINGDB`.`cms_category` WHERE `is_del` = 0 AND `status` = 1 AND `id` = 15 ORDER BY `sort` DESC,`id` ASC LIMIT 1 [ RunTime:0.000975s ]
SELECT * FROM `RENYINGDB`.`cms_category` WHERE `id` = 15 AND `status` = 1 AND `is_del` = 0 LIMIT 1 [ RunTime:0.000854s ]
SELECT * FROM `RENYINGDB`.`cms_model_table` WHERE `id` = 34 LIMIT 1 [ RunTime:0.000568s ]
SELECT * FROM `RENYINGDB`.`cms_article_chengguo` WHERE `cat_id` = 15 AND `status` = 1 AND `is_del` = 0 AND `id` = 1 LIMIT 1 [ RunTime:0.000794s ]
SELECT * FROM `RENYINGDB`.`cms_category` WHERE `is_del` = 0 AND `status` = 1 AND `id` = 15 ORDER BY `sort` DESC,`id` ASC LIMIT 1 [ RunTime:0.001502s ]
SELECT * FROM `RENYINGDB`.`cms_category` WHERE `id` = 15 AND `status` = 1 AND `is_del` = 0 LIMIT 1 [ RunTime:0.001184s ]
SELECT * FROM `RENYINGDB`.`cms_model_table` WHERE `id` = 34 LIMIT 1 [ RunTime:0.001010s ]
SELECT * FROM `RENYINGDB`.`cms_article_chengguo` WHERE `cat_id` = 15 AND `status` = 1 AND `is_del` = 0 AND `id` = 2 LIMIT 1 [ RunTime:0.000848s ]
