SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542982 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542982 [ RunTime:0.001969s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1015341,851813,529182,8927,692887,672320,885164,34388,407024,926562,844147,584353,308265,803727,286186,715466,19783,813968,26058,477071,184276,1038839,800898,837147,109913,901373,783508,819491,549044,476242,908298,804592,843542,765982,419986,944089,815474,756546,789063,746689,768793,367224,778073,658188,354117,170326,695933,861186,731818,39480,179154,61532,202824,833781,693534,1004495,958813,22627,176097,225839) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542982 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542982 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]