SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 193394 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 193394 [ RunTime:0.001702s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (160778,135757,99885,344309,202589,100733,252503,654644,49467,741285,783643,522147,996543,68512,1002975,310792,850530,249391,20109,624893,67189,263007,533410,1020668,771272,846119,104634,169467,569508,196321,414800,473814,228294,207195,722979,33777,287484,547960,869802,499175,917650,58702,499264,824383,749651,241095,746082,41670,1028073,559143,711333,754673,695084,607251,219755,15148,940740,484188,123417,202975) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 193394 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 193394 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]