SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 866801 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 866801 [ RunTime:0.001681s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (489851,421351,872122,546633,454933,1037742,74970,641224,15076,569492,320780,659032,467882,533890,783949,371304,550122,927012,195530,631038,163764,502535,810233,697101,79067,30,272210,279482,431132,190366,297442,316528,592619,294282,250369,976846,725334,1037310,749463,1048904,489067,1005167,350823,349157,1028790,38809,308364,452124,299060,213656,783274,618234,791725,1046972,259437,391977,155820,1043877,970507,897174) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 866801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 866801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000940s ]