SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447172 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447172 [ RunTime:0.001724s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (285896,883937,348624,789863,812546,207543,740392,338671,340946,973326,503539,856676,263507,592740,541914,973786,256975,180581,484077,213154,387597,181331,516997,867920,143737,114480,71529,222941,908824,111921,373656,564168,4809,200491,332986,357929,540580,37848,342595,168225,32510,443306,880066,95782,378142,648885,114117,595382,702214,849266,932868,236033,635863,80214,654434,481776,23829,198883,289067,306605) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447172 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447172 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]