SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 340005 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 340005 [ RunTime:0.001727s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (26156,91200,152913,1033405,133954,1033819,314906,192190,414466,781260,551992,208578,221510,604075,943972,398627,198561,654106,728442,1004446,200804,107681,750907,963766,161688,832852,915650,404721,307201,432500,981760,349067,871275,505321,211676,361463,993674,596207,40876,28170,215307,764518,539115,429144,95697,540388,503118,563603,3943,158190,1040413,124304,231492,319476,408206,328053,297518,783914,368166,13853) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 340005 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 340005 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]