SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 289015 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 289015 [ RunTime:0.003324s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (713343,291490,923150,831076,710325,830404,516733,858634,163388,965062,638907,777683,893298,828476,135620,225817,910569,362928,713224,840119,28130,490311,303020,812413,890888,179116,932490,790352,409500,394515,661894,481858,146738,505105,396297,517498,806180,484460,865404,231821,732291,556719,55360,1010258,438821,845009,166468,292734,1037154,850872,814092,221392,779688,933378,127041,632229,316159,878790,824656,13008) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.014445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 289015 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 289015 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001261s ]