[ SQL ] SHOW COLUMNS FROM `think_event` [ RunTime:0.000591s ]
[ SQL ] SELECT * FROM `think_event` WHERE ( id=1978 ) LIMIT 1 [ RunTime:0.000307s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 1000 LIMIT 1 [ RunTime:0.000203s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 2600 LIMIT 1 [ RunTime:0.000195s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 2601 LIMIT 1 [ RunTime:0.000166s ]
[ SQL ] SHOW COLUMNS FROM `think_label` [ RunTime:0.000351s ]
[ SQL ] SELECT * FROM `think_label` WHERE ( infoid=1978 ) [ RunTime:0.000525s ]
[ SQL ] SHOW COLUMNS FROM `think_enterprice` [ RunTime:0.000434s ]
[ SQL ] SELECT * FROM `think_enterprice` WHERE ( id=1601 ) LIMIT 1 [ RunTime:0.000237s ]
[ SQL ] SELECT * FROM `think_enterprice` WHERE ( id=1670 ) LIMIT 1 [ RunTime:0.000210s ]
[ SQL ] SHOW COLUMNS FROM `think_venue` [ RunTime:0.000412s ]
[ SQL ] SELECT * FROM `think_venue` WHERE ( id=111 ) LIMIT 1 [ RunTime:0.000233s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 2600 LIMIT 1 [ RunTime:0.000195s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 2601 LIMIT 1 [ RunTime:0.000180s ]
[ SQL ] UPDATE `think_event` SET `sort`=`sort`+1 WHERE ( id=1978 ) [ RunTime:0.007894s ]
[ SQL ] SHOW COLUMNS FROM `think_img` [ RunTime:0.000454s ]
[ SQL ] SELECT * FROM `think_img` WHERE ( tablename="event" and infoid=1978 ) ORDER BY `sort`,`id` [ RunTime:0.002221s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `think_img` WHERE ( tablename ="event" and infoid=1978 ) LIMIT 1 [ RunTime:0.002063s ]
[ SQL ] SELECT * FROM `think_event` WHERE ( id<>1978 and DATEDIFF(startimenew,"2024-09-06 00:00:00")=0 and venueid=111 and state in (1,4) ) ORDER BY `state`,`hot` DESC,`reorder` DESC LIMIT 0,6 [ RunTime:0.010258s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `think_event` WHERE ( id<>1978 and DATEDIFF(startimenew,"2024-09-06 00:00:00")=0 and venueid=111 and state in (1,4) ) LIMIT 1 [ RunTime:0.005732s ]
[ SQL ] SELECT * FROM `think_event` WHERE ( id<>1978 and DATEDIFF(startimenew,"2024-09-06 00:00:00")=0 and area2=2600 and state=1 ) ORDER BY `hot` DESC,`reorder` DESC LIMIT 0,6 [ RunTime:0.009900s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `think_event` WHERE ( id<>1978 and DATEDIFF(startimenew,"2024-09-06 00:00:00")=0 and area2=2600 and state=1 ) LIMIT 1 [ RunTime:0.005456s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 7755 LIMIT 1 [ RunTime:0.000294s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 7758 LIMIT 1 [ RunTime:0.000192s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 7764 LIMIT 1 [ RunTime:0.000178s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 7787 LIMIT 1 [ RunTime:0.000179s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 7821 LIMIT 1 [ RunTime:0.000180s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 7825 LIMIT 1 [ RunTime:0.000163s ]