SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001806s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 111976 LIMIT 1 [ RunTime:0.000687s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 111976 [ RunTime:0.001549s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (31681,126155,272650,501217,100187,130208,910122,757911,955087,1012755,308088,361577,174452,34678,483610,727882,477560,1008155,4297,414813,928222,362466,199566,584934,149402,36740,886589,530704,11248,389614,604411,389046,452629,141959,155451,867091,948338,620123,808929,372023,328556,894495,655861,358295,28119,668391,365165,649081,144875,1017612,962691,948778,912613,221428,828018,1012271,579621,340987,985562,800232) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 111976 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 111976 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000697s ]