SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 527341 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 527341 [ RunTime:0.002989s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1048865,279686,975922,912733,520027,1005249,104308,103976,845846,68380,724971,196544,720881,82771,436199,629048,795729,879672,307651,252313,90814,621195,807528,859830,263269,826909,744539,844283,121495,940436,879607,414074,514664,910318,839798,951299,639582,688494,364204,700381,345344,951841,174205,1039205,712195,980599,224498,57406,838308,585596,336620,691266,326933,775865,299834,775132,95454,246387,531613,906033) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 527341 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000472s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 527341 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003394s ]