SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422380 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422380 [ RunTime:0.001681s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (347871,638753,509552,532301,394904,581968,253308,446465,904201,243612,982947,704067,696149,620317,378010,269472,810737,998626,739851,104907,680940,681566,531636,434893,537333,919797,756418,517362,223879,909684,1030546,289155,347711,706394,489793,962663,185440,532387,37302,270484,226519,121342,322416,472237,649905,930811,900020,805554,782910,1038643,100890,579120,896373,25853,31166,687797,58337,868177,881093,220487) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001540s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]