SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 496314 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 496314 [ RunTime:0.001752s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (142721,421939,247937,704349,203636,308605,777577,231860,819475,794262,420093,790791,117287,127879,30648,278929,213108,496683,502187,616990,113785,294062,685444,199954,764393,301915,458394,433399,368146,684116,816721,75878,290645,652562,527347,941187,969714,1001081,28354,552464,219862,152169,620957,458745,110060,972784,127670,591130,322925,467181,529259,39789,164437,935928,852650,356652,393978,959799,585754,194898) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 496314 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 496314 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001479s ]