SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 96844 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 96844 [ RunTime:0.001692s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (525471,997609,590237,153838,447891,510345,200008,403244,636529,568177,424078,372416,290582,917089,498749,67974,675119,194829,236540,817993,293863,436334,988121,796781,648426,656495,272039,752004,221162,175804,708076,302898,878939,233595,532112,491404,278247,29980,223107,67281,920655,205106,5058,195155,82004,4308,122011,183450,702564,181354,185494,614517,224717,1043887,744163,531365,928619,164227,1033028,553015) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 96844 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 96844 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]