SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 479295 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 479295 [ RunTime:0.001895s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (854667,244626,878500,808016,337647,1008293,268443,330701,827017,297240,1010271,510915,693960,4384,710183,326157,1033332,17437,951398,171194,484036,532611,1022702,1010662,551340,539883,940590,283504,722636,205733,105289,455064,212552,933325,596001,458170,990722,196796,804953,392444,308677,632925,67742,744023,505585,102418,1022403,241790,933689,754949,394831,155963,635814,518427,478058,57632,333959,966881,10563,659405) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 479295 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 479295 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000394s ]