SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001303s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 28673 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 28673 [ RunTime:0.002166s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1004840,299676,766780,885126,703771,611766,138912,113912,787898,1026866,165496,61517,858428,903747,418597,833976,572311,763481,556639,684608,606064,628147,706976,889667,721914,444445,456467,432530,777161,88329,840975,542410,809543,445359,437147,585851,687386,297271,231982,696420,514975,240205,324675,719311,776512,1018010,946096,582008,942079,338174,966542,471147,754604,450330,900955,176532,299023,961631,504305,833212) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 28673 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 28673 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]