SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 396210 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 396210 [ RunTime:0.001601s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (108874,556898,331846,906636,296666,884460,337350,698152,616015,207565,399008,736402,191851,247213,366385,913821,819255,279197,800872,898388,274688,588141,765766,557059,970003,416179,1013487,170698,167976,346443,13937,321352,821274,606610,604832,918392,93949,813105,369861,166309,336033,96166,13867,691232,806568,871034,260929,381236,406046,299440,957302,812138,907251,1013641,679104,396514,296183,65931,536376,39447) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 396210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001578s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 396210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]