SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 477010 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 477010 [ RunTime:0.002012s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (796585,781122,129413,1043690,198380,818937,483737,199771,77416,616958,186661,368498,287704,785597,871796,686806,773123,640403,195926,439303,151684,989684,49871,1038357,692097,255923,153635,828128,556823,782668,281273,979422,102133,476358,960211,965123,882904,439931,1039294,848399,1027698,922797,307345,948474,518345,432119,629006,963157,840411,329219,396956,195765,586134,901647,997070,967365,685902,820941,372741,434723) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 477010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 477010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]