SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548405 LIMIT 1 [ RunTime:0.001783s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548405 [ RunTime:0.003069s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (880388,453892,355557,230755,10294,722680,899135,150878,198794,710977,802271,325140,646032,737183,942298,617279,823798,632982,261319,913550,20086,46964,81909,989474,834474,21002,64963,630831,28799,131857,60515,259986,771623,980054,409884,447580,706007,192133,141520,496066,909716,603740,817553,445586,321977,778739,922414,73647,783020,867710,167375,100520,692353,243534,795689,887084,1016367,269872,248993,748796) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548405 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548405 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003068s ]