[ DB ] CONNECT:[ UseTime:0.024473s ] pgsql:dbname=cnpwd;host=127.0.0.1;port=5432
[ SQL ] 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('yf_user'); [ RunTime:0.249781s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM yf_user WHERE id = 9781 LIMIT 1 [ RunTime:0.014001s ]
[ SQL ] 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('yf_user_info'); [ RunTime:0.074655s ]
[ SQL ] SELECT * FROM yf_user_info WHERE user_id = 9781 AND kind = 1 LIMIT 1 [ RunTime:0.012464s ]
[ SQL ] 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('yf_venue'); [ RunTime:0.323586s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM yf_venue WHERE user_id = 9781 AND status = 5 AND start_time <= 1772257029 AND end_time >= 1772257029 LIMIT 1 [ RunTime:0.006650s ]
[ SQL ] SELECT * FROM yf_venue WHERE user_id = 9781 AND status = 5 AND start_time <= 1772257029 AND end_time >= 1772257029 ORDER BY istop DESC,count_click DESC,id DESC LIMIT 18 OFFSET 0 [ RunTime:0.016853s ]