SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001575s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400009 LIMIT 1 [ RunTime:0.000530s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400009 [ RunTime:0.001546s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (49731,726226,673468,955189,232715,124779,562313,974834,450952,237958,439480,529531,105472,291800,600575,458474,977749,370031,939218,996572,376646,532323,353004,560910,364950,766565,959705,1020749,746162,413309,943180,193205,426380,759122,192797,271384,872026,1042427,142330,333957,877627,398669,577391,413189,1046433,531600,875559,35419,594124,767192,19369,755933,1001731,769973,276248,448812,791834,349229,500617,833508) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400009 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400009 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002351s ]