SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 810169 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 810169 [ RunTime:0.001533s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (311328,872367,311309,840622,543127,898012,871186,36100,276885,442670,314052,263621,52492,469946,346093,596321,840030,808855,427662,422248,871189,878679,103718,72170,395936,974527,407258,116732,875700,64118,745523,75359,696274,704279,529827,908942,501169,523570,309038,471164,194517,535957,733785,196676,1033200,342404,722381,145904,459459,704908,744201,836461,107311,143891,514330,533990,187514,777109,534692,745036) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000930s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 810169 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 810169 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]