SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401985 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401985 [ RunTime:0.001693s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (273770,385384,141518,112335,629095,903239,159314,554555,645183,866348,236033,720746,464634,973660,954694,185256,325809,126302,114505,973775,66501,743218,510011,382305,972885,589643,164415,283120,2538,34307,164185,268987,132686,982463,628883,553201,207764,742456,405670,265497,949387,748325,132954,239917,122846,85332,747861,338428,32584,340177,458655,407194,250636,158130,338878,213150,633540,624714,455672,636836) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401985 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000518s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401985 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000868s ]