SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001700s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 841001 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 841001 [ RunTime:0.001571s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (691514,166446,391826,26103,12274,250849,332479,124855,82867,954926,226975,263602,935076,462641,208914,563079,494128,881235,4297,358756,9557,870480,937089,441923,354791,452198,136697,530338,1026044,170115,300845,300024,957195,29014,983828,169511,553583,1048831,209614,270729,285477,125537,675598,1043158,582244,288841,636374,341319,188773,13814,23222,958581,455953,631486,909155,260009,551591,293237,295324,885952) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 841001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 841001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]