SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003743s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509191 LIMIT 1 [ RunTime:0.004221s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509191 [ RunTime:0.003459s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (128412,493770,556133,85977,971179,810803,988483,321703,240770,690079,840481,339349,939854,412339,39486,946890,910032,609771,774795,178176,793021,205077,862537,101291,333997,234563,874514,643507,716075,245077,815131,73153,744618,213454,337181,1019457,771630,494129,991536,107633,687345,793978,270596,667949,918104,549638,559124,843132,499004,831957,1008112,538233,39296,51213,959827,306645,629130,35203,834044,995944) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001584s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509191 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000632s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509191 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000428s ]