SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 497346 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 497346 [ RunTime:0.008556s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (251783,763989,328389,1008464,791533,281518,724478,492089,305870,572829,248982,780528,544975,119786,28158,150694,794227,124103,698308,310220,819982,235847,496945,1043698,519260,41691,462989,193387,732706,975166,148173,761318,966933,14076,428881,956306,5975,621650,12794,219112,219075,556496,995873,434533,868401,109675,903871,879138,471758,863412,577747,962733,962251,465728,392483,203683,990585,114894,428235,490015) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 497346 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000850s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 497346 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001414s ]