[ SQL ] SHOW COLUMNS FROM `think_event` [ RunTime:0.000719s ]
[ SQL ] SELECT * FROM `think_event` WHERE ( id=1351 ) LIMIT 1 [ RunTime:0.000333s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 1000 LIMIT 1 [ RunTime:0.000241s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 1300 LIMIT 1 [ RunTime:0.000187s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 5638 LIMIT 1 [ RunTime:0.000169s ]
[ SQL ] SHOW COLUMNS FROM `think_label` [ RunTime:0.000438s ]
[ SQL ] SELECT * FROM `think_label` WHERE ( infoid=1351 ) [ RunTime:0.000870s ]
[ SQL ] SHOW COLUMNS FROM `think_enterprice` [ RunTime:0.000554s ]
[ SQL ] SELECT * FROM `think_enterprice` WHERE ( id=2379 ) LIMIT 1 [ RunTime:0.000320s ]
[ SQL ] SELECT * FROM `think_enterprice` WHERE ( id=1620 ) LIMIT 1 [ RunTime:0.000240s ]
[ SQL ] SELECT * FROM `think_enterprice` WHERE ( id=1560 ) LIMIT 1 [ RunTime:0.000238s ]
[ SQL ] SELECT * FROM `think_enterprice` WHERE ( id=2259 ) LIMIT 1 [ RunTime:0.000239s ]
[ SQL ] SHOW COLUMNS FROM `think_venue` [ RunTime:0.000560s ]
[ SQL ] SELECT * FROM `think_venue` WHERE ( id=133 ) LIMIT 1 [ RunTime:0.000251s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 1300 LIMIT 1 [ RunTime:0.000220s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 5638 LIMIT 1 [ RunTime:0.000229s ]
[ SQL ] UPDATE `think_event` SET `sort`=`sort`+1 WHERE ( id=1351 ) [ RunTime:0.004680s ]
[ SQL ] SHOW COLUMNS FROM `think_img` [ RunTime:0.000420s ]
[ SQL ] SELECT * FROM `think_img` WHERE ( tablename="event" and infoid=1351 ) ORDER BY `sort`,`id` [ RunTime:0.002261s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `think_img` WHERE ( tablename ="event" and infoid=1351 ) LIMIT 1 [ RunTime:0.002111s ]
[ SQL ] SELECT * FROM `think_event` WHERE ( id<>1351 and DATEDIFF(startimenew,"2024-06-19 00:00:00")=0 and venueid=133 and state in (1,4) ) ORDER BY `state`,`hot` DESC,`reorder` DESC LIMIT 0,6 [ RunTime:0.013134s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 24 LIMIT 1 [ RunTime:0.000381s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 27 LIMIT 1 [ RunTime:0.000190s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 1000 LIMIT 1 [ RunTime:0.000172s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 1300 LIMIT 1 [ RunTime:0.000177s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 5638 LIMIT 1 [ RunTime:0.000170s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 1000 LIMIT 1 [ RunTime:0.000159s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 1300 LIMIT 1 [ RunTime:0.000130s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 5638 LIMIT 1 [ RunTime:0.000138s ]
[ SQL ] SHOW COLUMNS FROM `think_special` [ RunTime:0.000479s ]
[ SQL ] SELECT * FROM `think_special` WHERE ( tablename="event" and infoid=367 and psid=60 ) ORDER BY `sort` LIMIT 1 [ RunTime:0.001769s ]
[ SQL ] SELECT * FROM `think_special` WHERE ( tablename="event" and infoid=367 and psid=73 ) ORDER BY `sort` LIMIT 1 [ RunTime:0.001721s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 73 LIMIT 1 [ RunTime:0.000214s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 5531 LIMIT 1 [ RunTime:0.000189s ]
[ SQL ] SELECT * FROM `think_label` WHERE ( infoid=367 ) [ RunTime:0.000847s ]
[ SQL ] SELECT * FROM `think_enterprice` WHERE ( id=1564 ) LIMIT 1 [ RunTime:0.000261s ]
[ SQL ] SELECT * FROM `think_venue` WHERE ( id=133 ) LIMIT 1 [ RunTime:0.000237s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 24 LIMIT 1 [ RunTime:0.000173s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 28 LIMIT 1 [ RunTime:0.000172s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 1000 LIMIT 1 [ RunTime:0.000159s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 1300 LIMIT 1 [ RunTime:0.000175s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 5638 LIMIT 1 [ RunTime:0.000159s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 1000 LIMIT 1 [ RunTime:0.000160s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 1300 LIMIT 1 [ RunTime:0.000160s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 5638 LIMIT 1 [ RunTime:0.000176s ]
[ SQL ] SELECT * FROM `think_special` WHERE ( tablename="event" and infoid=426 and psid=60 ) ORDER BY `sort` LIMIT 1 [ RunTime:0.001824s ]
[ SQL ] SELECT * FROM `think_special` WHERE ( tablename="event" and infoid=426 and psid=74 ) ORDER BY `sort` LIMIT 1 [ RunTime:0.001775s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 74 LIMIT 1 [ RunTime:0.000203s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 5535 LIMIT 1 [ RunTime:0.000182s ]
[ SQL ] SELECT * FROM `think_label` WHERE ( infoid=426 ) [ RunTime:0.000653s ]
[ SQL ] SELECT * FROM `think_enterprice` WHERE ( id=1620 ) LIMIT 1 [ RunTime:0.000255s ]
[ SQL ] SELECT * FROM `think_venue` WHERE ( id=133 ) LIMIT 1 [ RunTime:0.000215s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 24 LIMIT 1 [ RunTime:0.000186s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 28 LIMIT 1 [ RunTime:0.000171s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 1000 LIMIT 1 [ RunTime:0.000167s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 1300 LIMIT 1 [ RunTime:0.000147s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 5638 LIMIT 1 [ RunTime:0.000128s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 1000 LIMIT 1 [ RunTime:0.000157s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 1300 LIMIT 1 [ RunTime:0.000146s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 5638 LIMIT 1 [ RunTime:0.000153s ]
[ SQL ] SELECT * FROM `think_special` WHERE ( tablename="event" and infoid=2489 and psid=60 ) ORDER BY `sort` LIMIT 1 [ RunTime:0.002285s ]
[ SQL ] SELECT * FROM `think_special` WHERE ( tablename="event" and infoid=2489 and psid=77 ) ORDER BY `sort` LIMIT 1 [ RunTime:0.001617s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 77 LIMIT 1 [ RunTime:0.000220s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 5561 LIMIT 1 [ RunTime:0.000212s ]
[ SQL ] SELECT * FROM `think_label` WHERE ( infoid=2489 ) [ RunTime:0.000543s ]
[ SQL ] SELECT * FROM `think_enterprice` WHERE ( id=2379 ) LIMIT 1 [ RunTime:0.000252s ]
[ SQL ] SELECT * FROM `think_enterprice` WHERE ( id=1620 ) LIMIT 1 [ RunTime:0.000188s ]
[ SQL ] SELECT * FROM `think_enterprice` WHERE ( id=1560 ) LIMIT 1 [ RunTime:0.000199s ]
[ SQL ] SELECT * FROM `think_enterprice` WHERE ( id=2259 ) LIMIT 1 [ RunTime:0.000182s ]
[ SQL ] SELECT * FROM `think_venue` WHERE ( id=133 ) LIMIT 1 [ RunTime:0.000216s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 24 LIMIT 1 [ RunTime:0.000161s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 28 LIMIT 1 [ RunTime:0.000161s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 1000 LIMIT 1 [ RunTime:0.000188s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 1300 LIMIT 1 [ RunTime:0.000193s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 5638 LIMIT 1 [ RunTime:0.000157s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 1000 LIMIT 1 [ RunTime:0.000133s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 1300 LIMIT 1 [ RunTime:0.000155s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 5638 LIMIT 1 [ RunTime:0.000138s ]
[ SQL ] SELECT * FROM `think_special` WHERE ( tablename="event" and infoid=987 and psid=60 ) ORDER BY `sort` LIMIT 1 [ RunTime:0.001535s ]
[ SQL ] SELECT * FROM `think_special` WHERE ( tablename="event" and infoid=987 and psid=69 ) ORDER BY `sort` LIMIT 1 [ RunTime:0.001691s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 69 LIMIT 1 [ RunTime:0.000219s ]
[ SQL ] SELECT * FROM `think_label` WHERE ( infoid=987 ) [ RunTime:0.000881s ]
[ SQL ] SELECT * FROM `think_enterprice` WHERE ( id=1620 ) LIMIT 1 [ RunTime:0.000246s ]
[ SQL ] SELECT * FROM `think_venue` WHERE ( id=133 ) LIMIT 1 [ RunTime:0.000245s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 24 LIMIT 1 [ RunTime:0.000180s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 28 LIMIT 1 [ RunTime:0.000161s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 1000 LIMIT 1 [ RunTime:0.000160s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 1300 LIMIT 1 [ RunTime:0.000187s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 5638 LIMIT 1 [ RunTime:0.000166s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 1000 LIMIT 1 [ RunTime:0.000167s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 1300 LIMIT 1 [ RunTime:0.000165s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 5638 LIMIT 1 [ RunTime:0.000162s ]
[ SQL ] SELECT * FROM `think_special` WHERE ( tablename="event" and infoid=996 and psid=60 ) ORDER BY `sort` LIMIT 1 [ RunTime:0.001709s ]
[ SQL ] SELECT * FROM `think_special` WHERE ( tablename="event" and infoid=996 and psid=69 ) ORDER BY `sort` LIMIT 1 [ RunTime:0.001587s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 69 LIMIT 1 [ RunTime:0.000215s ]
[ SQL ] SELECT * FROM `think_label` WHERE ( infoid=996 ) [ RunTime:0.000528s ]
[ SQL ] SELECT * FROM `think_enterprice` WHERE ( id=1620 ) LIMIT 1 [ RunTime:0.000242s ]
[ SQL ] SELECT * FROM `think_venue` WHERE ( id=133 ) LIMIT 1 [ RunTime:0.000190s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 24 LIMIT 1 [ RunTime:0.000182s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 28 LIMIT 1 [ RunTime:0.000153s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 1000 LIMIT 1 [ RunTime:0.000192s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 1300 LIMIT 1 [ RunTime:0.000185s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 5638 LIMIT 1 [ RunTime:0.000169s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 1000 LIMIT 1 [ RunTime:0.000178s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 1300 LIMIT 1 [ RunTime:0.000198s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 5638 LIMIT 1 [ RunTime:0.000218s ]
[ SQL ] SELECT * FROM `think_special` WHERE ( tablename="event" and infoid=1352 and psid=60 ) ORDER BY `sort` LIMIT 1 [ RunTime:0.001778s ]
[ SQL ] SELECT * FROM `think_special` WHERE ( tablename="event" and infoid=1352 and psid=74 ) ORDER BY `sort` LIMIT 1 [ RunTime:0.001483s ]
[ SQL ] SELECT * FROM `think_base` WHERE `id` = 74 LIMIT 1 [ RunTime:0.000203s ]
[ SQL ] SELECT * FROM `think_label` WHERE ( infoid=1352 ) [ RunTime:0.000748s ]
[ SQL ] SELECT * FROM `think_enterprice` WHERE ( id=1560 ) LIMIT 1 [ RunTime:0.000205s ]
[ SQL ] SELECT * FROM `think_enterprice` WHERE ( id=2379 ) LIMIT 1 [ RunTime:0.000295s ]
[ SQL ] SELECT * FROM `think_enterprice` WHERE ( id=1620 ) LIMIT 1 [ RunTime:0.000288s ]
[ SQL ] SELECT * FROM `think_venue` WHERE ( id=133 ) LIMIT 1 [ RunTime:0.000274s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `think_event` WHERE ( id<>1351 and DATEDIFF(startimenew,"2024-06-19 00:00:00")=0 and venueid=133 and state in (1,4) ) LIMIT 1 [ RunTime:0.005607s ]
[ SQL ] SELECT * FROM `think_event` WHERE ( id<>1351 and DATEDIFF(startimenew,"2024-06-19 00:00:00")=0 and area2=1300 and state=1 ) ORDER BY `hot` DESC,`reorder` DESC LIMIT 0,6 [ RunTime:0.009635s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `think_event` WHERE ( id<>1351 and DATEDIFF(startimenew,"2024-06-19 00:00:00")=0 and area2=1300 and state=1 ) LIMIT 1 [ RunTime:0.005199s ]