SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541215 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541215 [ RunTime:0.001898s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (354311,221941,538325,407132,1046011,674233,357168,739679,217254,774126,491513,124836,563119,1036103,562080,592883,871379,504311,790660,378536,603715,691370,466051,17655,220900,63225,479102,592454,992904,397327,894586,895229,281901,660040,35378,38886,993235,645242,238648,396401,387225,1041759,9314,483705,558672,803150,609004,63839,655832,973469,685334,561358,750303,790876,359828,62369,769931,944258,738199,966171) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541215 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000530s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541215 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]