SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503108 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503108 [ RunTime:0.002648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (426831,688127,613323,779049,330055,393922,22762,474596,191577,954277,790452,328046,346835,812432,820506,557484,978297,140790,542851,793080,140704,848523,89621,282952,744667,683192,125914,1046738,72371,387031,354118,218788,432193,214075,306582,475083,920666,511507,5040,525087,956094,735129,294371,986388,604572,1043913,514308,86474,594818,966849,210384,73246,534964,684619,612210,112223,533647,176297,678429,210598) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000938s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503108 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503108 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000420s ]