SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001322s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200972 LIMIT 1 [ RunTime:0.000506s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200972 [ RunTime:0.004438s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (806415,1040231,46530,846775,884939,546309,592601,89991,807446,310628,951082,788833,261604,358420,856349,44006,992849,869865,333280,897438,368455,906617,609009,394728,99238,627637,211849,976284,624968,240780,802656,659981,324273,187238,1047050,750085,48473,650899,719995,38558,74334,320645,724400,1007103,171615,243473,213935,779815,528973,326763,933741,312788,434258,753574,911383,265995,1025780,1023367,550010,686008) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200972 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200972 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001003s ]