SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001398s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 547064 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 547064 [ RunTime:0.001718s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (260605,221141,572446,284832,410377,88441,871729,497864,818021,909888,807742,30989,807622,869467,598741,558446,160033,648518,578815,847831,198668,799650,901331,321724,130094,645600,720059,968470,191068,650805,630626,660019,112966,65917,185423,935667,499105,245708,814564,777143,862551,85807,570076,342506,378710,181062,796442,697658,43695,174280,297599,902076,284711,531439,321735,164566,800264,985822,247133,171268) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 547064 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 547064 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002786s ]