SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002324s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412330 LIMIT 1 [ RunTime:0.003023s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412330 [ RunTime:0.005059s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (664300,287883,259532,848178,965640,67090,1014540,307712,30885,763656,276074,28969,40589,537309,352697,300031,561162,90443,92132,403528,2576,919419,827206,492060,185827,301617,256226,685340,422354,55352,684663,1039468,126291,295246,522273,1023750,728599,226890,367294,84053,301380,283476,41586,756209,116993,346442,563068,846761,870771,108105,1014230,615359,958436,309293,89146,805862,342807,262486,351217,190732) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003830s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412330 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000321s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412330 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]