SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 590217 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 590217 [ RunTime:0.001610s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (657244,183880,228915,897239,724825,26050,953618,81546,1039686,331994,740437,555791,577309,86370,239614,315637,48329,803017,387847,551388,282682,441727,451891,532024,177199,214826,508161,641695,146834,835300,1029367,297126,337329,284189,844990,578967,448615,412396,327635,720283,117861,1025152,543238,877378,440743,420229,550952,281878,336280,444315,758465,724547,933832,376969,596797,525088,519560,894604,859968,484809) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 590217 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 590217 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]