SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 807313 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 807313 [ RunTime:0.001567s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (980010,858918,974292,736672,8333,622421,995932,1004040,763450,159736,912171,871203,555320,275948,489647,696124,135880,978973,252220,392485,208441,544399,982063,220171,824192,55025,791094,961254,27906,752957,17329,991270,291474,818009,912368,99447,312082,987739,304830,623784,1001386,933327,819118,664207,824583,173781,111323,541401,1012669,511165,940047,663647,251647,929481,255742,265028,287957,525836,338867,1029727) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 807313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 807313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]