SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 132834 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 132834 [ RunTime:0.001533s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (567022,425440,1022714,209304,972482,48014,824953,123959,353785,1007564,219823,314035,873444,895059,368298,65037,69638,589035,85286,815580,942284,682602,327681,1026027,807973,679785,1025248,113086,801237,353598,573003,369911,704799,1022723,284451,872740,729337,281140,750005,1044296,905051,583423,469953,953396,207199,661405,779029,914717,363745,570667,653077,31005,7330,702717,285370,451937,143962,940559,372004,1025888) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 132834 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 132834 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]