SELECT "id","desc","var","val","cfg_file" FROM "public"."cms_config" ORDER BY "id" DESC [ RunTime:0.001909s ]
SELECT "id","pid","name","url","image","icon" FROM "public"."cms_column" WHERE ( "pid" = 0 ) ORDER BY "sort" DESC, "id" DESC [ RunTime:0.001669s ]
SELECT * FROM "public"."cms_news_type" ORDER BY "sort" DESC [ RunTime:0.000791s ]
SELECT "id","name","image","url","pie","content","title" FROM "public"."cms_business" ORDER BY "sort" DESC, "id" DESC [ RunTime:0.000934s ]
SELECT "id","name","image","url" FROM "public"."cms_bottom_image" ORDER BY "sort" DESC, "id" DESC [ RunTime:0.000733s ]
SELECT "id","image","icon" FROM "public"."cms_column" WHERE ( "id" = 3 ) LIMIT 1 [ RunTime:0.000698s ]
SELECT * FROM "public"."cms_news_type" ORDER BY "sort" DESC [ RunTime:0.000548s ]
SELECT "id","news_type_id","title","source","views","sort","publish_date","content" FROM "public"."cms_news" WHERE ( "id" = 100 ) LIMIT 1 [ RunTime:0.000941s ]
select fields_name as "field",fields_type as "type",fields_not_null as "null",fields_key_name as "key",fields_default as "default",fields_default as "extra" from table_msg('cms_news'); [ RunTime:0.050414s ]
SELECT "id","title" FROM "public"."cms_news" WHERE "news_type_id" = 2 AND ( "sort" > 0 OR ( "sort" = 0 AND "publish_date" > '2020-02-07' ) OR ( "sort" = 0 AND "publish_date" = '2020-02-07' AND "id" > 100 ) ) ORDER BY "sort" ASC,"publish_date" ASC,"id" ASC LIMIT 1 [ RunTime:0.002059s ]
SELECT "id","title" FROM "public"."cms_news" WHERE "news_type_id" = 2 AND ( "sort" < 0 OR ( "sort" = 0 AND "publish_date" < '2020-02-07' ) OR ( "sort" = 0 AND "publish_date" = '2020-02-07' AND "id" < 100 ) ) ORDER BY "sort" DESC,"publish_date" DESC,"id" DESC LIMIT 1 [ RunTime:0.001371s ]
UPDATE "public"."cms_news" SET "views" = 10899 , "update_time" = '2026-10-25 17:24:33.018436' WHERE ( "id" = 100 ) [ RunTime:0.001005s ]
SELECT COUNT(*) AS think_count FROM "public"."cms_news" WHERE ( "news_type_id" = 2 ) [ RunTime:0.001149s ]
SELECT "id","news_type_id","title","summary","source","views","publish_date","cover","url" FROM "public"."cms_news" WHERE ( "news_type_id" = 2 ) ORDER BY "sort" DESC, "publish_date" DESC, "id" DESC LIMIT 6 OFFSET 0 [ RunTime:0.001495s ]
川公网安备51079002110101号 网站支持IPV6 
信访举报
合规举报