SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003093s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 550321 LIMIT 1 [ RunTime:0.001533s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 550321 [ RunTime:0.003146s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (986403,1036315,968314,498969,1000502,441706,831743,707950,898935,527570,370371,855554,331194,723778,858147,974561,142273,147652,291125,160717,629634,260640,784942,32143,332028,205647,321340,267360,95011,387862,89632,120402,53147,710846,672965,13084,813952,286984,800974,641719,487842,660753,610025,390393,687155,138231,639011,680115,935878,455812,852891,434868,49402,637305,437044,855608,725548,148961,801059,704659) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 550321 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002091s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 550321 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]