SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 294438 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 294438 [ RunTime:0.002201s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (860336,407627,859326,48576,958777,948059,913528,419437,730409,170616,989190,701981,980891,471879,552411,236137,861602,181455,596484,581350,928660,460680,682127,759080,280956,227505,40532,1024780,398403,537959,203392,656194,332935,467243,662759,87648,591355,8995,617934,707420,944848,775945,216456,374127,22910,877256,594870,665210,761833,611552,215257,127601,248839,206468,63292,470400,383083,164121,615721,300951) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 294438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 294438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]