SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405438 LIMIT 1 [ RunTime:0.000451s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405438 [ RunTime:0.004412s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (982773,192650,61180,13188,501251,157965,709205,610562,1026797,806546,114804,334356,957416,1037664,147349,612722,912025,568937,706221,947217,686098,872300,90123,116385,802154,823724,989234,972360,112036,369019,228070,623083,981567,674352,842920,1004772,886990,969457,659167,633701,95698,304112,537832,198900,731246,431176,390717,170938,932092,10959,666792,552941,69519,664082,943560,1045324,510045,740563,80196,600580) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002984s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000675s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000691s ]