SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 154141 LIMIT 1 [ RunTime:0.000573s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 154141 [ RunTime:0.001761s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (113737,936033,516529,941003,581917,1017869,600488,968781,489089,85133,894209,532332,564711,793670,835450,416692,899950,166878,274865,67682,275488,610975,201454,983961,26454,194837,86396,794567,7984,483297,388686,294292,1035207,559906,224904,469848,91761,882630,471960,948918,40046,481553,463304,353566,357339,888767,518785,659022,400669,1020383,593480,105687,397881,708419,791332,159765,119370,286696,313355,814140) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001529s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 154141 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 154141 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000651s ]