SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 457723 LIMIT 1 [ RunTime:0.002034s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 457723 [ RunTime:0.006772s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (867606,1018203,653885,812595,533701,627740,504594,2746,410818,613205,881415,543592,981531,662802,100095,836471,186039,557775,583795,336415,17493,899851,701667,309961,261402,47905,37393,264578,351980,198125,805217,410068,232752,725492,67585,240422,573754,614003,361070,207286,686509,440076,114590,926114,319455,777144,5207,957356,680660,300038,691124,137833,75592,624605,244027,631167,86939,404602,84950,377252) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 457723 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000546s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 457723 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]