select table_name from USER_TABLES where TABLESPACE_NAME='MAIN' [ RunTime:0.005100s ]
select * from user_tab_columns where table_name='cms_category' [ RunTime:0.001175s ]
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.002148s ]
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.002135s ]
select * from user_tab_columns where table_name='cms_config' [ RunTime:0.000691s ]
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.002412s ]
SELECT * FROM `RENYINGDB`.`cms_config` WHERE `status` = 1 AND `cfg` = 'status' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001002s ]
SELECT * FROM `RENYINGDB`.`cms_config` WHERE `status` = 1 AND `cfg` = 'ip' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000675s ]
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.000741s ]
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.001207s ]
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.001059s ]
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.001209s ]
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.000794s ]
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.001022s ]
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.000714s ]
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.001077s ]
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.000710s ]
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.000847s ]
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.000732s ]
select * from user_tab_columns where table_name='cms_visit' [ RunTime:0.000507s ]
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.002854s ]
DELETE FROM `RENYINGDB`.`cms_visit` WHERE `addtime` < '1780983705' [ RunTime:0.000737s ]
SELECT * FROM `RENYINGDB`.`cms_category` WHERE `is_del` = 0 AND `status` = 1 AND `id` = 13 ORDER BY `sort` DESC,`id` ASC LIMIT 1 [ RunTime:0.000969s ]
SELECT * FROM `RENYINGDB`.`cms_category` WHERE `id` = 13 AND `status` = 1 AND `is_del` = 0 LIMIT 1 [ RunTime:0.000893s ]
SELECT * FROM `RENYINGDB`.`cms_category` WHERE `id` = 13 AND `is_del` = 0 LIMIT 1 [ RunTime:0.000744s ]
SELECT * FROM `RENYINGDB`.`cms_category` WHERE `id` = 5 AND `is_del` = 0 LIMIT 1 [ RunTime:0.000754s ]
SELECT * FROM `RENYINGDB`.`cms_category` WHERE `up_id` = 5 AND `status` = 1 AND `is_del` = 0 ORDER BY `sort` DESC,`id` ASC LIMIT 99 [ RunTime:0.000952s ]
SELECT * FROM `RENYINGDB`.`cms_category` WHERE `id` = 13 AND `status` = 1 AND `is_del` = 0 LIMIT 1 [ RunTime:0.000818s ]
select * from user_tab_columns where table_name='cms_model_table' [ RunTime:0.000787s ]
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.002644s ]
SELECT `id`,`table_name` FROM `RENYINGDB`.`cms_model_table` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000686s ]
select * from user_tab_columns where table_name='cms_article_news' [ RunTime:0.000882s ]
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_news' [ RunTime:0.002661s ]
SELECT * FROM `RENYINGDB`.`cms_article_news` WHERE `id` = 12 AND `cat_id` = 13 AND `status` = 1 AND `is_del` = 0 LIMIT 1 [ RunTime:0.000849s ]
UPDATE `RENYINGDB`.`cms_article_news` SET `onclick` = 11 WHERE `id` = 12 AND `cat_id` = 13 AND `status` = 1 AND `is_del` = 0 AND `id` = 12 AND `cat_id` = 13 AND `status` = 1 AND `is_del` = 0 [ RunTime:0.002357s ]
SELECT `id`,`model_id`,`up_id`,`path`,`type`,`status` FROM `RENYINGDB`.`cms_category` WHERE `id` = 13 LIMIT 1 [ RunTime:0.000625s ]
SELECT `id`,`table_name` FROM `RENYINGDB`.`cms_model_table` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000552s ]
SELECT * FROM `RENYINGDB`.`cms_article_news` WHERE `id` = 12 AND `cat_id` = 13 AND `status` = 1 AND `is_del` = 0 LIMIT 1 [ RunTime:0.000749s ]
SELECT * FROM `RENYINGDB`.`cms_article_news` WHERE `push_time` > 1783492730 AND `status` = 1 AND `is_del` = 0 AND `cat_id` = 13 AND `id` <> 12 ORDER BY `push_time` ASC LIMIT 1 [ RunTime:0.000964s ]
SELECT * FROM `RENYINGDB`.`cms_category` WHERE `is_del` = 0 AND `status` = 1 AND `id` = 13 ORDER BY `sort` DESC,`id` ASC LIMIT 1 [ RunTime:0.000950s ]
SELECT * FROM `RENYINGDB`.`cms_category` WHERE `id` = 13 AND `status` = 1 AND `is_del` = 0 LIMIT 1 [ RunTime:0.000817s ]
SELECT * FROM `RENYINGDB`.`cms_model_table` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000551s ]
SELECT * FROM `RENYINGDB`.`cms_article_news` WHERE `cat_id` = 13 AND `status` = 1 AND `is_del` = 0 AND `id` = 13 LIMIT 1 [ RunTime:0.000747s ]
SELECT * FROM `RENYINGDB`.`cms_article_news` WHERE `push_time` < 1783492730 AND `status` = 1 AND `cat_id` = 13 AND `is_del` = 0 AND `id` <> 12 ORDER BY `push_time` DESC LIMIT 1 [ RunTime:0.001139s ]
SELECT * FROM `RENYINGDB`.`cms_category` WHERE `is_del` = 0 AND `status` = 1 AND `id` = 13 ORDER BY `sort` DESC,`id` ASC LIMIT 1 [ RunTime:0.001121s ]
