SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001315s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103913 LIMIT 1 [ RunTime:0.001918s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103913 [ RunTime:0.002659s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (481531,1032798,937023,1029833,632862,269995,528116,26750,889495,130357,489220,83211,597897,631296,740628,72074,566766,383570,31668,853057,386522,368509,280377,294054,760723,145397,905718,63168,437280,899367,37446,270764,603324,40252,428055,774767,888472,707345,227708,524057,524390,724160,636339,338571,134110,845232,234476,193169,842489,8889,126271,964626,579615,719107,34061,898328,868836,966070,18227,83363) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002591s ]