SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501959 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501959 [ RunTime:0.004027s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (582759,1031343,345160,94446,413715,974223,92100,815237,360804,947254,660798,399601,86654,238607,557369,628527,34471,354006,281586,937923,490257,891589,572637,19576,979733,85201,625191,619107,299882,11838,990467,244871,732572,137598,105975,308493,735805,109168,153801,305184,566477,737816,865081,964434,48474,577625,834656,714655,631260,655656,294332,788023,882851,989249,897465,435201,153226,180602,814736,968057) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501959 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501959 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000424s ]