SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 323914 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 323914 [ RunTime:0.003339s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (259820,450122,285634,881507,410501,561853,895078,525550,461620,87830,680937,632396,959830,740902,796107,168075,375088,407050,1027587,873464,713180,952591,336855,176578,10981,294901,596449,661083,138932,720772,409244,522898,843542,774704,859471,127918,185074,833144,660925,598293,47357,551800,583351,640331,528986,248332,267240,771644,352343,302782,552637,10790,676525,785086,38547,239345,208854,382257,859261,857479) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001806s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 323914 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000575s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 323914 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]