SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001522s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 983021 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 983021 [ RunTime:0.002155s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (193911,490930,622777,951348,200566,210977,20922,730275,463880,767187,891093,506196,728633,481881,834332,128215,115495,902396,891927,1048362,436934,201033,941471,765974,150678,376569,149140,418127,438139,875699,633549,514957,209828,100450,734323,255898,539333,15234,987700,865656,283768,175406,124368,663846,540442,672018,676475,1021058,377105,756114,352313,707961,863760,717579,133274,85283,928557,777071,213716,54617) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 983021 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 983021 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]