SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001350s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481411 LIMIT 1 [ RunTime:0.000796s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481411 [ RunTime:0.001580s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (204804,478801,857240,66121,403600,721973,868894,384268,597345,646374,97233,102391,527745,175847,355571,903885,346451,403668,288474,952481,203931,607861,708799,239891,607934,779432,69261,946471,336821,467438,456677,1005310,137102,333661,444672,184801,502907,757509,797995,1005945,886316,101256,899995,677812,1027650,889035,142442,440055,412829,338580,730441,605642,95249,881833,714636,289685,568355,495983,72180,645994) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000664s ]