SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 904930 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 904930 [ RunTime:0.001778s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (72709,861296,73963,139561,738050,380998,1020401,475981,492371,562845,339483,1023114,831055,238629,305065,795753,906658,742318,472839,13972,570028,832365,1025183,113064,352797,449327,352138,912075,146911,962292,341952,628396,513202,877618,815715,306202,353016,1018910,399710,575063,611339,162093,752361,350742,15087,14631,806192,593841,888313,331719,312660,827302,751902,20084,184087,840649,904793,194180,799682,212935) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000955s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 904930 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 904930 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]